Tournament Prize Distribution Formula

Tournament Prize Distribution Formula is project number 280475 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Project expired)

Status:	Closed
Budget:	$30-250
Created:	06/28/2008 at 21:15 EDT
Bidding Ends:	07/08/2008 at 21:15 EDT
Project Creator:	flignats   Buyer Rating: (1 reviews)
Description:	Produce a formula that calculates a cash prize distribution among the top 33% of the participants who entered into a contest. However, the distribution needs to deliver a greater cash prize towards the top for the higher finishing contestants. The formula is for a progressive jackpot tournament so it should work correctly and adjust to any amount of contestants. Below is an example of the tournament distribution that your model should fit into. Total Players - 294 Total Places Paid - 98 Total Prize money - 332.40 Position Amount 1 $40.61 2 $24.60 3 $17.74 4 $13.93 5 $11.51 6 $9.83 7 $8.60 8 $7.66 9 $6.91 10 $6.31 11 $5.81 12 $5.40 13 $5.04 14 $4.73 15 $4.47 16 $4.23 17 $4.02 18 $3.84 19 $3.67 and so on What is the formula that will produce this type of distribution for all places paid and fill in the remaining places not listed above? The formula HAS to work universally to accommodate any amount of participants. The above info should be used ONLY to check your work and was taken off a website that is using the formula that I am looking for. Please input the data into an excel spreadsheet and fill in the remaining places and indicate the exact formula so that I can incorporate into my own tournament listings. This should be easy for anyone that has already done tournaments and prizes and should be readily accessible, I just can't figure out the formula on my own. Since this is probably on hand I wouldn't expect it to cost more than $10, just generate a couple bucks off your already hard earned work.
Job Type:	Excel
Database:	(None)
Operating system:	(None)
Bid count:	12
Average bid:	$ 104