Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 12 hockey teams in a competition and I want to construct a "draw". Is
there a universal model that I can use in cases where I have more or less teams in the comptition? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way of representing teams that play each other home and away in
some competition is to draw up a table with the team names across the top row and down the first column like this: TEAM A B C D E A x B x y C x D x E x It is usual for the teams down the first column to be the home team and for the team across the top row to be the away team, so the game marked y is between team B and team D (assuming the formatting holds out). Obviously, a team can't play itself, so the leading diagonal of this table is blanked out. Within the cells of this table you can record the date each match is due to be played, or the time if it is a one-day event, and after the match has taken place you can record the score instead of the date/ time (or use another table for this). If there is only one game between each team and home/away does not apply (eg some tournament at a neutral venue), then you only need the bottom triangle of the table (below the x's), rather like a mileage chart that you see in road atlases. Hope this helps. Pete On Oct 1, 3:51*am, Peter Harrigan <Peter wrote: I have 12 hockey teams in a competition and I want to construct a "draw". Is there a universal model that I can use in cases where I have more or less teams in the comptition? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add up winning teams | Excel Discussion (Misc queries) | |||
Sum different sized (employee) teams | Excel Worksheet Functions | |||
Bowling: Handicap between Teams | Excel Worksheet Functions | |||
Does any one have a Golf Tournament spreadsheet for teams? | Excel Discussion (Misc queries) | |||
transfering numbers into teams | Excel Worksheet Functions |