Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fair Play
I need a formula that will provide fair play (or as close to it as possible)
for the following criteria: Round 1 Consists of: 10 Teams and 9 Weeks. Round 2 Consists of: 10 Teams and 10 Weeks Mandatory Criteria - Each team must play at home one week and away the following week. |
#2
|
|||
|
|||
"Iamrené" wrote:
Mandatory Criteria - Each team must play at home one week and away the following week. My guess is that you will not be able to achieve this. It is easy enough for one or two teams, but then you are restricted by the fact that a team's home match is the opposing team's away match. |
#3
|
|||
|
|||
On Thu, 8 Sep 2005 09:49:07 -0700, "Iamrené"
wrote: I need a formula that will provide fair play (or as close to it as possible) for the following criteria: Round 1 Consists of: 10 Teams and 9 Weeks. Round 2 Consists of: 10 Teams and 10 Weeks Mandatory Criteria - Each team must play at home one week and away the following week. What do you want the result of the formula to be. Please give an example. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#4
|
|||
|
|||
Thanks, but I can't accept that. Everything is possible mathematically, I'm
just not smart enough to know how to do it. I appreciate your assistance though. "Martin P" wrote: "Iamrené" wrote: Mandatory Criteria - Each team must play at home one week and away the following week. My guess is that you will not be able to achieve this. It is easy enough for one or two teams, but then you are restricted by the fact that a team's home match is the opposing team's away match. |
#5
|
|||
|
|||
I'm not sure if it will post correctly, however:
Weeks of play at the X axis and Game iterance at the Y axis (i.e.): Week 1 Week 2 Week 3 Away|Home Away|Home Away|Home Game 1 T1 T10 T10 | T6 T6|T1 Game 2 T2 T9 T9 | T5 T5|T2 Game 3 T3 T8 T7 | T4 T4|T3 "Richard Buttrey" wrote: On Thu, 8 Sep 2005 09:49:07 -0700, "Iamrené" wrote: I need a formula that will provide fair play (or as close to it as possible) for the following criteria: Round 1 Consists of: 10 Teams and 9 Weeks. Round 2 Consists of: 10 Teams and 10 Weeks Mandatory Criteria - Each team must play at home one week and away the following week. What do you want the result of the formula to be. Please give an example. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get animated clip art to play in excel 2000? | Excel Discussion (Misc queries) | |||
VLOOKUP with more than 7 levels of IF | Excel Worksheet Functions |