Dropbox
Enter the d,m,t,f in the yellow cells to advance the wrestler and assign appropriate points
B1G Interactive Bracket
- Thread starter LutherAce
- Start date
Enter the d,m,t,f in the yellow cells to advance the wrestler and assign appropriate points
Post season hasn't officially arrived to the Cesspool™️ until @LutherAce shares the bracket! Look forward to this and the NCAA version every year. Thanks!
I'm off to plug in results that has Iowa finishing 1st by .5 points....
I'm off to plug in results that has Iowa finishing 1st by .5 points....
Awesome spreadsheet! Found an error. Will need to fix the formula on the Sheet "Wrestlers" in column D. Where there is the formula "=IFERROR(VLOOKUP(B16,'133'!$R$2:$AA$15,11,FALSE()),0)" need to change $R to $Q, it is not picking up points once we fill out the bracket on the "Team Standings" sheet. I highlighted column D and did a find replace (Find: $R Replace: $Q) and it fixed the sheet.Dropbox
www.dropbox.com
Enter the d,m,t,f in the yellow cells to advance the wrestler and assign appropriate points
Always look forward to this Luther. Thanks again. Unless I did something wrong.... the team scores need a tweak. I think on the wrestlers tab, the lookup for 133 and beyond needs to start with column Q instead of R. 125 is OK. Great work and thanks again.
I have Iowa getting all 10 thru, but Penn State scoring a whopping 214 points. Iowa with 150 with Nebraska a close third with 130.
125: Cruz 5th
133: Ayala 1st
141: Schriever 6th
149: Parco 3rd
157: Teemer 2nd
165: Caliendo 2nd
174: Kennedy 3rd
184: Arnold 3rd
197: Buchanan 1st
285: Keuter 7th
Poor Wisconsin, only had them scoring 1.5 points.
Complete standings:
125: Cruz 5th
133: Ayala 1st
141: Schriever 6th
149: Parco 3rd
157: Teemer 2nd
165: Caliendo 2nd
174: Kennedy 3rd
184: Arnold 3rd
197: Buchanan 1st
285: Keuter 7th
Poor Wisconsin, only had them scoring 1.5 points.
Complete standings:
| Team Standings | Prediction from Seeds | ||
1 | PSU | 214 | 171 |
2 | IA | 150 | 122 |
3 | NEB | 130 | 107.5 |
4 | MN | 99 | 87.5 |
5 | OSU | 92.5 | 68 |
6 | IL | 73.5 | 72 |
7 | MI | 66 | 53 |
8 | MD | 56 | 49.5 |
9 | RU | 47 | 61 |
10 | PU | 40 | 36.5 |
11 | IN | 27 | 36 |
12 | NU | 9 | 26 |
13 | MSU | 3 | 5 |
14 | WI | 1.5 | 15 |
Last edited:
Thanks all...updated. Also made a tweak in the scoring for the finals...I had too many points being awarded.
New sheet is available for download (should show a 2:39 central time stamp in the link above)
New sheet is available for download (should show a 2:39 central time stamp in the link above)
Last edited:
you'll need to download the updated one with the correct scoring for finals. I was giving too many points to the winners.
| Team Standings | Prediction from Seeds | ||
1 | PSU | 196 | 163 |
2 | IA | 144 | 118 |
3 | NEB | 127 | 106.5 |
4 | MN | 96 | 85.5 |
5 | OSU | 92.5 | 66 |
6 | IL | 73.5 | 71 |
7 | MI | 66 | 53 |
8 | MD | 56 | 48.5 |
9 | RU | 47 | 61 |
10 | PU | 40 | 35.5 |
11 | IN | 27 | 36 |
12 | NU | 9 | 26 |
13 | MSU | 3 | 5 |
14 | WI | 1.5 | 15 |
TEEMER is NOT losing in the finals!!! IF he is healthy, NO way KatKrap beats him!!!!
weird this fix didn't seem to help Wisconsin any 🤣
Don’t sell yourself short Turk. I think you could do better.
I wonder if he has bonuses built in to his contract? If he doesn’t he should. I’ve heard there is an 83% chance he gets canned, if there are not any NQ for Wisky.
