Spartan- I assigned a value of what I felt was most important when it comes to tourney time. For example I applied a 1.5% value to Off.Eff, Def. Eff, FT%, and Hgt. I did 1.25% for TO/O, TO/D, and Exp. I put a small value of .25% to all SOS categories and some other values to the rest. It is all out of fun just to see what would happen. My highest ranking went to Syr. before Melo was disqualified. I was giving a bonus of 10pts to teams that had less then 100 miles to travel as well, so that could change from round to round. The formula really loves Cal for some reason, even to beat Temple in the next rd. I will post my spreadsheet soon just for everyone to laugh at. I almost hit the delete button last night when Iona was beating the shit outta BYU
0
Spartan- I assigned a value of what I felt was most important when it comes to tourney time. For example I applied a 1.5% value to Off.Eff, Def. Eff, FT%, and Hgt. I did 1.25% for TO/O, TO/D, and Exp. I put a small value of .25% to all SOS categories and some other values to the rest. It is all out of fun just to see what would happen. My highest ranking went to Syr. before Melo was disqualified. I was giving a bonus of 10pts to teams that had less then 100 miles to travel as well, so that could change from round to round. The formula really loves Cal for some reason, even to beat Temple in the next rd. I will post my spreadsheet soon just for everyone to laugh at. I almost hit the delete button last night when Iona was beating the shit outta BYU
I also only gave value if the team was in the top 200. So anyone over 200 received a 0. The top 200 were divided up into groups of 10 with teams ranked 1-10 getting a value of 20. The top categories that got a value of 1.5% and was in the top 10 received 30pts. Teams 11-20 would get a 28.5 and so on. Trust me this is the nerdiest shit I've ever done but who cares. It's Tourney Time!!!
0
I also only gave value if the team was in the top 200. So anyone over 200 received a 0. The top 200 were divided up into groups of 10 with teams ranked 1-10 getting a value of 20. The top categories that got a value of 1.5% and was in the top 10 received 30pts. Teams 11-20 would get a 28.5 and so on. Trust me this is the nerdiest shit I've ever done but who cares. It's Tourney Time!!!
I had to be a little nerd too and add my own way of looking at it.
I have compiled all of the data into 2 different sheets and then made pivot tables out of them. You can then sort and compare by a particular team. This would be helpful throughout the whole tourney.
0
I had to be a little nerd too and add my own way of looking at it.
I have compiled all of the data into 2 different sheets and then made pivot tables out of them. You can then sort and compare by a particular team. This would be helpful throughout the whole tourney.
I had to be a little nerd too and add my own way of looking at it.
I have compiled all of the data into 2 different sheets and then made pivot tables out of them. You can then sort and compare by a particular team. This would be helpful throughout the whole tourney.
Would love to see those sheets
My binder for tomorrow only has 84 pages and there is always room for more
0
Quote Originally Posted by OhWilson10:
I had to be a little nerd too and add my own way of looking at it.
I have compiled all of the data into 2 different sheets and then made pivot tables out of them. You can then sort and compare by a particular team. This would be helpful throughout the whole tourney.
Would love to see those sheets
My binder for tomorrow only has 84 pages and there is always room for more
I've noticed a scary trend so far on KGC's spreadsheet. The team with the better Def. Eff. has won all 6 games with L'ville and Wisc on their way to add to this.
0
I've noticed a scary trend so far on KGC's spreadsheet. The team with the better Def. Eff. has won all 6 games with L'ville and Wisc on their way to add to this.