Payout for Divisions

[GMRobbins]

I am working on a sheet where players are listed per division. Once scored the goal is to pay out a percentage of the top players in each division. I've gotten as far as determining each players "place" within their division but am stumped as to how to extract to top 33% and allocate the division of payout.

Example:

Division #1 has 10 players competing, payout id to top 33%, Payout = $100 (# players * $10). Paying places: 1, 2 & 3
Division #2 has 3 players competing, payout id to top 33%, Payout = $30 (# players * $10). Paying places: 1 only
Division #3 has 27 players competing, payout id to top 33%, Payout = $270 (# players * $10). Paying places 1, 2 , 3, 4, 5, 6, &7


My sheet has the following columns:
Name - Division - Score - Place within Division - Payout

Any assistance would be appreciated.

 

[oldbrewer]

not clear yet - are players eg football players or fantasy football players or people betting on players

it is easy to pick the top 3 goal scorers by picking the top 3 numbers and using offset to get back to the "player"

 

[GMRobbins]

Say golf players, in the example mentioned, 10 competing in div#1, 3 in #2, & 27 competing in div#3

 

[GMRobbins]

My struggle is the payout variable changes with #of players .... $100/3, $30/1, & $270/7

How to determine the appropriate splits of the total payout for each?

 

[oldbrewer]

still not clear - is total payout related to number of players - and how is the number of players getting a payout determined, is it say 1/5 of the number in division, minimum 3 ???

 

[GMRobbins]

Yes, in my example payout would be top 1/3 of players within their division.

 

[GMRobbins]

One year later, I've still not found a solution on how best to solve.

Say there are two divisions of players ... Am and Pro
There are a total of 19 players ... 15 Am and 9 Pro
Payout is $10 per player = $240 total, or $150 for Am and $90 for Pro
Fields are: Player - Division - Entry Fee (payout/player) - Rank/Division - PAYOUT (???)

I have tables for determining payout percentages.
The goal is to determine the total payout for each division, then determining the top 33% of both Pro and Am divisions based on score, then allocating separate formulas for 1st place, 2nd place, 3rd place, etc.

I feel there should be a way to calculate all efficiently but have reached the upper limits of my excel skills.

Any suggestions?

 

[GMRobbins]

"There are a total of 19 players ... 15 Am and 9 Pro"

Should be a total of 24 players.