Tournament Prize Distribution Formula

Produce a formula that calculates a cash prize distribution among the top 60% team of the participants who entered into a contest.

For example:

Entry Fee for the contest is : 49INR or 49$

Total size of the contest is: 300000

So total winner will be: 180000. ( 60% of 300000 )

I need a formula that will distribute the winning amount into the 60 percent teams.

In the above case total winner are 1800000

Contest size is : 300000 so 300000*49 = 14700000INR

In one of the competitor site in above case the prizes are

Prize 1: 5,00,000

Prize 2: 2,50,000

Prize 3: 1,00,000

Prize 4-4: 30,000

Prize 6-10: 10,000

Prize 11-50: 0,000

Prize 51-500: 2,000

Prize 501-5000: 200

Prize 5001-30000: 100

Prize 30001-60000: 72

Prize 60001-95000: 49

Prize 95001-180000: 19

Please let me know your thoughts on this.

NOTE: If the contest size is 300000 and only 250000 user is enter to contest then the prize structure will change automatically.

Skills: Data Processing, Data Entry, Excel, Mathematics, Algorithm

See more: tournament prize calculator, web banners 500 100 templates, prize distribution formula, prize listing formula distribution, tournament prize award formulae, creating formula prize distribution, prize distribution equations, tournament prize money calculation formula, tournament prize money calculation formula places, tournament prize distribution, tournament prize money distribution, excel tournament prize, excel prize distribution formula, tournament prize distribution formula, tournament prize distribution excel, tournament prize money distribution formula, prize money distribution formula excel, tournament prize formula, tournament prize distribution calculator

Project ID: #29379634