|
|
 ah, common sense, not as common as one might think... - Ansem Retort [more] |
 |
|
||||||||||||||
|
|||||||||||||||
By: Steve Howland
New: 04-03-2006 09:46 PM
Updated: 04-03-2006 09:46 PM
Total downloads: 230 times
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.
Attached Files
-
Championships Division Predictor
06 champ divs.xls
download file
uploaded: 04-03-2006 09:46 PM
filetype: xls
filesize: 217kb
downloads: 228
Discussion
view entire thread
04-03-2006 10:24 PM
DanDon
Re: paper: Championships division sorter
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.
04-03-2006 10:27 PM
Steve Howland
Re: paper: Championships division sorter
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...)
view entire thread
Tags
loading ...