Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba code
Could anyone help me with a vba code to do sports fixtures scheduling. I have
had help with creating the fixtures but now I need help to schedule the matches every week, so that all teams play every week, ie - with 10 teams there are 90 matches in total, but can only play 5 games every week, with 16 teams there are 240 matches in total, but can only play 8 matches every week. If possible, I would want all teams to alternate home and away every other week. Thanks for your help in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vba code
hi, !
Could anyone help me with a vba code to do sports fixtures scheduling. I have had help with creating the fixtures but now I need help to schedule the matches every week so that all teams play every week ie - with 10 teams there are 90 matches in total, but can only play 5 games every week with 16 teams there are 240 matches in total, but can only play 8 matches every week. If possible, I would want all teams to alternate home and away every other week. Thanks for your help in advance. this is in spanish, but I guess could help as a start-option (?) http://www.teladearana.es/seccion/excel/131-h22.html - uses NO vba - it is prepared only for one round (if you need a double-match tournament, just repeat the schedule ?) - you can expand/copy-drag the ranges beyond the 20 teams/players in the sample - home and/or away are NOT considered :-( hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |