I started out to prove that my score was wrong due to Nick Lee's bout, but you have it correct, but I did notice Hockeygod11 predicted TF and you only gave him, and everyone, 2 pts. Is it due to the IU opponent?
Sorry, I should have offered an explanation with the scores.
JAYHOUSE,
Thanks, but the ref also got 174 wrong, there should have been a CStar escape and less riding time, lol, just kidding/not kidding!
Question, first place 98lber, just to pick on him, shows 18 for picks and 4 bonus for a total of 22, but the individual weights just show 5 2’s, is something not showing up for me? Or am I justmissing something obvious?125 Out due to FFT
141 and 165 Win type doesn't count, due to Wisconsin not sending the right guys out.
Interesting. The totals are totalling off of a different part of the spreadsheet, not the individual bout result portion. I'll have to take a look at what has gone wrong with my spreadsheet.
Picks number is how many points you get for picking winner, best possible, if no weights thrown out, would be 20, 10 x 2, you can earn a bonus point for guessing the correct Decision, ie Dec, MD, TF, F, for another possible 10 points (listed as bonus), the absolute best would be 30 points, again if all weights contested and no strange wrestlers sent on the mat. Strange is my choice of words (for listed in match notes in advance), not meaning if they have a man bun or not, lol.
12 is the number of points you got for that match by picking the correct winner. Bonus is the number of points you got for picking the correct win type in addition to winner. The 12 under picks means you got 6 weight classes right in that match.
125 Out due to FFT
141 and 165 Win type doesn't count, due to Wisconsin not sending the right guys out.
PA in TN said the individual weight is not showing up correctly, he has you down for 18 points on picks which is 9 weights (max since 125 was thrown out) at 2 points each.
You should also be confused as to why there is not a single '3' in that entire spreadsheet. I am.
Well I came in second, #2blindsquirrels?
Did you add another "If()" in there then? Just curious.Alrighty, then. Sometimes it is easy.
For the Excel nerds, the following is what got me into trouble...
=IF(AND(B6<>"",B6=B$4,C6=C$4),3,IF(AND(B6<>"",B6=B$4,C6<>C$4),2,0))
How? Well, when Penn State forfeits the 125 match, and, therefore, there is nothing in cell B6, B6 being nothing causes the AND statements to be false and return 0. The zero is correct for 125, but copy, paste and repeat across the weights, and it fails.
Anyway, here are the updated results. Same totals, but corrected individual bout scores.
No. I put 'a' in column B for all contestants, which satisfies the B not being blank. 'a' is not the name of the contestant that won the forfeit, which returns 0 for the 125 result for everyone, and in the succeeding weights allows the correct score to calculate, as well.
