Pelican Parts Forums

Pelican Parts Forums (http://forums.pelicanparts.com/)
-   Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)
-   -   quick math or excel help (http://forums.pelicanparts.com/off-topic-discussions/800316-quick-math-excel-help.html)

rattlsnak 03-08-2014 06:12 PM

quick math or excel help
 
Sounds simple enough but I'm too lazy to try to figure this out. :rolleyes:

5 teams who each play a total of 20 games a season. They will play each other on a rotating schedule so how many games total will there need to be scheduled so that all 5 teams will play 20 games as they rotate through each other?

5 x 20 = 100, but that is obviously too many with the overlap.

lendaddy 03-08-2014 06:42 PM

Quote:

Originally Posted by NotaBRG (Post 7951623)
I get 100. It takes 20 games for each team to play each other once. Do that 5 times for the full rotation.

Yes, but in the instance where team 2 plays team 3 you get repetition by also listing team 3 playing team 2. He wants to know how many unique games there are, I assume to schedule refs, courts, etc...

SilberUrS6 03-08-2014 06:48 PM

In addition, teams don't play themselves.

For some reason, I'm getting 80. I might have to examine why my number came out like that.

ZOA NOM 03-08-2014 06:51 PM

In order for all 5 teams to play each other once, it will require 10 games:

1 vs 2
1 vs 3
1 vs 4
1 vs 5
2 vs 3
2 vs 4
2 vs 5
3 vs 4
3 vs 5
4 vs 5

Do this twice for twenty games, each team gets a home game and an away game.

edit: dang! three minutes late!

lendaddy 03-08-2014 06:56 PM

I get 50 games.

Each team plays 4 games per rotation. Each rotation consists of 10 unique combinations. To get to 20 games per team total is 5 rotations = 5 x 10.

mreid 03-08-2014 06:58 PM

It says EACH play 20 games, so the answer is 50.

SilberUrS6 03-08-2014 06:59 PM

Quote:

Originally Posted by mreid (Post 7951648)
It says EACH play 20 games, so the answer is 50.

Yup. I see where I made my mistake. :(

rattlsnak 03-08-2014 08:00 PM

So as a formula, I could use:

# of teams x 20 = X/2 ?

(5 x 20 = 100/2 = 50)

ZOA NOM 03-08-2014 09:34 PM

Quote:

Originally Posted by SilberUrS6 (Post 7951653)
Yup. I see where I made my mistake. :(

ditto. der.


All times are GMT -8. The time now is 02:32 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website


DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.