|
|
|
![]() |
|
|||||||
|
||||||||
A spreadsheet to predict which teams will end up in which divisions at Championships in 2006.
This is a spreadsheet which should, provided the randomizing method is the same, align each team within its proper championships division.
When a new team list comes out:
Simply paste in the team list on sheet 2 (you may have to paste special as text or unicode) and sort the teams by number. This will replace column E on sheet one, and shift the teams to their proper division.
06 champ divs.xls
03-04-2006 23:24
DanDon
Just wanted to humbly point out that I provided Steve with the inspiration for this little project............and that it was all his Dad's work *shifty eyes...looks around and pleads "dont shoot me"*.
In all honesty..........to the extent of our testing, the sheet works great, and I hope everyone utilizes this great tool.
03-04-2006 23:27
Steve Howland
Ooh you spoiled the secret.
Now i'm in trouble...
Yes, the ultimate formula was devised by my dad, a wiz with excel. I had tried some things but without him I would have given up (it's harder than you may think...)