NFL Confidence POOL Analysis Formula Help

nomad3d

New Member
Joined
Jan 21, 2010
Messages
1
Good Afternoon,
Been using the wealth of knowledge here for a long time. I usually find the answer to my question already posted so have never had to post before.
So as a first time poster I must take the time to say thank you to all the contributors here, your time and expertise is very much appreciated!
Now onto my question.

We run a “confidence pool” at work during the NFL season.
Basically each player picks a winner of each of the 16 games each week and applies a value of 1 to 16 based on the confidence of the pick.
Each number can only be used once.

Example:
G1-V-#5, G2-V-#10, G3-H-#12, G4-V-#15….G16-H-8
G = Game number
H = Pick Home to win
V = Pick Visitor to win
# = confidence rating
If your pick is correct after the game ends you get the corresponding points added to your total.
After all games played the point leader wins that week’s pool.

What I am looking for some assistance on is being able to analyze the picks once submitted to see out of the 65, 536 possible combinations of outcomes of a 16 game week who has what percentage of the 65,536 in wins.
In other words if my game results were 1011011100011001 and that gave me a total of 68 points and those same results give player 2 a total of 96 points then player 2 wins that 1 out of 65,536.

In addition I would like to continue the analysis during the games and see who no longer has any possibility of winning as the results start to come in.
Hope this all makes sense.
[FONT=&quot]Damon[/FONT]
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,224,603
Messages
6,179,856
Members
452,948
Latest member
UsmanAli786

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top