В работе

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.

Навыки: Обработка данных, Ввод данных, Excel, Математика, Алгоритмы

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) Gurgaon, India

ID проекта: #29379634

Поручен:

(1 отзыв)
2.0

6 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹1667

hussainmuzammal4

Word,excel,pdf,Python solution and Coding Formulas with upto 1 year [login to view URL] Read my Reviews Link below,In the similar work Assalam-o-Alaikum ⭐⭐⭐Hi!⭐⭐⭐ I have an excellent skills in your project.I have a ma Больше

₹2500 INR за 1 день
(7 отзывов(-а))
2.6
mayanksaraswat85

I am an expert in SQL and SAS, and I do work with resources who are expert in R and python. Will be able to crack this

₹1500 INR за 3 дней(-я)
(0 отзывов(-а))
0.0
kumarivikky436

I have many experience in online job and I am a very hardworking professional. My typing is very fast I can complete all project within specified time period & 100% satisfaction the client

₹1500 INR за 5 дней(-я)
(0 отзывов(-а))
0.0
pablo181295

Hi, i have a question. 1. the amount of the prize will change? example: if the contest size is 300.000 and only 250.000 user enter. the prize to the last group keep beeing 19$. should it change? you can see what i do o Больше

₹1500 INR за 1 день
(0 отзывов(-а))
0.0
zubairchishty

Hi, I have worked on data analytics for quite a long time and would like to work with you on your project. Do ping me if you are interested. Thank you, Zubair

₹1000 INR за 1 день
(0 отзывов(-а))
0.0