Stat Correction & Final 4 scenarios

I was going through the score sheet trying to figure out just how exactly we could wind up with a 5-way tie for 2nd place.  In the course of doing that, something didn't seem to be adding up.  My first check was to recalculate the points I had scored everyone, and those looked to be correct.  That's the good news.  The points rankings that I send out with each update are right.  That's good because that's what really determines the winner.

From there, I re-calculated the remaining 8 scenarios across everyone's picks and the results came out a little different.  My guess is that when I was making the initial spreadsheet I extended the points one cell too far.  There are a series of "if" statements that assign points, and for the Sweet 16 games, it assigns 4 points to the winner, 8 points to the Elite 8 winners, 16 to the semi-final winners, and 32 to the champion.  I must have messed up the point allocations there.   The good news is that I doesn't look like I screwed it too bad, since the same people as before can still win, just different places.  So, here's how all 8 scenarios in the Final 4 can play out.

Loyola-Chicago beats Villanova

Irene H. #7 wins 1st place.

Dennis R. wins 2nd place.

Larry G. #2 wins 3rd place.

Winner of tie-breaker between Larry G. #5 & Hal R. #2 wins 4th place.

Loyola-Chicago beats Kansas

Andrew D.#2 wins 1st place.

Kirt R. #2 wins 2nd place.

Winner of tie-breaker between Max A. #3 & Jeff Sag. #2 wins 3rd place.

Loser of tie-breaker between Max A. #3 & Jeff Sag. #2 wins 4th place.

  

Michigan beats Villanova

Larry G. #2 wins 1st place.

Hal R. #2 wins 2nd place.

Bosun S. wins 3rd place.

Irene H. #6 wins 4th place.

Michigan beats Kansas

Larry G. #2 wins 1st place.

Hal R. #2 wins 2nd place.

Bosun S. wins 3rd place.

Kirt R. #2 wins 4th place.

Villanova beats Loyola-Chicago

Larry G. #5 wins 1st place.

Miguel D. wins 2nd place.

Winner of 4-way tie-breaker between Scott K.#1, Malcolm X. #1, Jeff M. & Daisy N. #13 wins 3rd place.

2nd place of 4-way tie-breaker between Scott K.#1, Malcolm X. #1, Jeff M. & Daisy N. #13 wins 4th place.

Villanova beats Michigan

Malcolm X. #1 wins 1st place.

Chad L. #3 wins 2nd place.

Adam E. wins 3rd place.

Grant F. wins 4th place.

Kansas beats Loyola-Chicago

Andrew D. #2 wins 1st place.

Kirt R. #2 wins 2nd place.

Max A. #3 wins 3rd place.

Michelle L. #3 wins 4th place.

Kansas beats Michigan

Kirt R. #2 wins 1st place.

Andrew D. #2 wins 2nd place.

Michelle L. #3 wins 3rd place.

Max A. #3 wins 4th place.

So, after looking at everything, all the same people that were eligible for the payouts are still eligible.  No new people were added, and nobody was dropped.  Some of the potential payouts got shifted a little bit, but that seems to be it.

Sorry for the confusion.  Glad it didn't totally screw everything up.  Also glad I caught it now before I started telling people that they won only to have the math work out wrong.

Good luck!!!