Forum Discussion
Nested Ranking
https://1drv.ms/x/s!ArDGG_59A415g7J50tKtpQg0L0h_4g?e=JITDuo
You might be assuming that I--red-blooded American male (though you didn't know that)--understand pools of this type. I don't. Never take part in them. Never look at them. Haven't, as a result, any idea of what all those sheets mean or how to navigate them.
Maybe somebody else can make sense of that OneDrive workbook, but you'll have to do a lot of connecting the dots between that and your original posting for me. I understand (to a certain extent) Excel, but not sports pools.
- You are absolutely right, I had assumed that these were "common knowledge". So, with that cleared up, I'll try to answer your earlier questions.
So for the sake of clarity, please spell out the relationship between the "points" along the top and the word "score" in the tie-breaker.
The SCORE is the actual score of the football game.
What is the source of the Points numbers?
The POINTS are what the players guessed the score would be.
And where do the numbers of Wins and "Difference" come from?
The number of wins is how many games they guessed the winner of the game, and the DIFFERENCE is the difference from the actual points scored and the guessed points for the last game played.You still haven't posted this year's spreadsheet, the one where you have a question. Nor (for this novice at pools) is it clear what the connection is between that original (which looked oh, so simple) and the one you did post (which looked oh, so extensively complicated). I didn't see, for example, a page in the one you linked to that even looked like the original.
- The original was a screen shot of the (copied) area needed for the wanted calculation. The attached link was to the entire file. The area to look at is L35:V39 on any of the numbered sheets.