Create tournament ranking formula
₹1500-12500 INR
Paid on delivery
I am looking for a skilled developer to create a tournament ranking formula for a project. Here are the requirements for the job:
What I have and provide
We provide points to each of the teams based on its finish in the individual tournaments and the level of difficulty.
I have majorly three types of sheets,
main sheet – the final ranking,
level of difficulty sheets – all tournament details put based on their level of difficulty,
region sub region sheets – Contains the team’s name with the multiple tournament points in a single row.
The ranking shows the present position of the team at a regional, sub-regional or world level. There is excel sheet with a list of all the tournament held with team position. Here is the list of regions and sub-regions
• America
o Brazil
o LATAM
o North America
• China
o China
• Europe
o Europe
o Turkey
• India
o India
• Korea-Japan
o Korea
o Japan
• MEA
o Africa
o Arabia
• South Asia
o Pakistan
o South Asia
• SEA
o Indonesia
o MY/SG/PH
o SEA WC
o Thailand
o Vietnam
The ranking will be created on subregional level, each tournament is marked with the team’s region and sub region.
As a part of the data, I have the list of tournaments played based on the level of difficulty. Each tournament information is in each sheet of the excel file. The tournament details consist region, sub region, team name.
Tournaments based on level of difficulty – Elite Plus, Elite, Premium, Standard, Normal
Position Elite plus Elite Premium Standard Normal
1 2400 2000 1600 1200 900
2 1700 1400 1100 800 600
3 1300 1000 800 570 440
4 1100 800 640 460 360
5 920 680 540 400 300
6 780 580 450 340 250
7 680 500 380 300 210
8 600 440 330 260 180
9 540 400 300 240 160
10 480 360 260 220 140
11 420 320 240 200 130
12 380 300 220 180 120
13 360 280 200 160 110
14 360 260 200 160 100
15 360 260 200 160 100
16 360 260 200 160 100
17 260 200 160 100
18 260 200 160 100
19 200 160 100
20 200 160 100
To keep the competition between the teams in the ranking position, points of each tournament will decay over time individually based on its date, ultimately making it to zero after 6 months.
• Up to 2 months – 100% of tournament points
• Up to 4 months – 75% of tournament points
• Up to 6 months – 50% of tournament points
• After 6 months – 0% of tournament points
If teams in the Ranking are exactly tied by points at some point, the one that has played more tournaments/events will get a higher ranking.
Initially, the points are given based on the average, total points earned/number of tournaments played.
But the denominator changes due to some criteria. Below mentioned are the criteria.
• If number of tournaments is 2, take denominator as 3
• If number of tournaments is 3, take denominator as 3.5
If the number of tournaments played is 4, it further checks the points earned in each tournament and ensures that no score is less than 300 (when if any of the 2400, 2000, 1600 points are present) and 600 (when if 1200 points are present). If these conditions are met, it returns 4.25, else it returns 4. Otherwise, if the number of tournaments is 5 or more, it returns the number of tournaments. If none of these conditions are met, it returns 0.
Additionally if,
Number of tournaments is 2,
• Add 1.25 to the denominator if 2400 points earned in a single tournament
• Add 1 to the denominator if 2000 points earned in a single tournament
• Add .75 to the denominator if 1700, 1600 points earned in a single tournament
• Add .5 to the denominator if 1200,1300,1400, 1100, 900 points earned in a single tournament
Number of tournaments is 3,
• Add 1 to the denominator if 2400 points earned in a single tournament
• Add .75 to the denominator if 2000 points earned in a single tournament
• Add .5 to the denominator if 1700, 1600 points earned in a single tournament
• Add .25 to the denominator if 1200,1300,1400, 1100, 900 points earned in a single tournament
Number of tournaments is 4,
• Add .75 to the denominator if 2400 points earned in a single tournament
• Add .5 to the denominator if 2000, 1700, 1600 points earned in a single tournament
• Add .25 to the denominator if 1200,1300,1400 points earned in a single tournament
Number of tournaments is 5,
• Add .5 to the denominator if 2400 points earned in a single tournament
• Add .25 to the denominator if 2000, 1600, 1200, 1700 points earned in a single tournament
Number of tournaments is 6,
• Add .5 to the denominator if 2400 points earned in a single tournament
• Add .25 to the denominator if 2000, 1600, 1700 points earned in a single tournament
Number of tournaments is 7 or 8,
• Add .25 to the denominator if 2400, 2000 points earned in a single tournament
Number of tournaments is 9 or 10 or above,
• Add .25 to the denominator if 2400 points earned in a single tournament
Also, if,
Number of tournaments is 5,
• Subtract .5 to the denominator if less than 50 points earned in a single tournament
• Subtract .25 to the denominator if less than 100 or 50 points earned in a single tournament
Number of tournaments is 6,
• Subtract 1 to the denominator if less than 50 points earned in a single tournament
• Subtract .5 to the denominator if less than 100 or 50 points earned in a single tournament
• Subtract .25 to the denominator if less than 150 or 100 points earned in a single tournament
Number of tournaments is 7 or 8,
• Subtract 1 to the denominator if less than 100 points earned in a single tournament
• Subtract .5 to the denominator if less than 150 or 100 points earned in a single tournament
• Subtract .25 to the denominator if less than 200 or 150 points earned in a single tournament
Number of tournaments is 9,
• Subtract 1 to the denominator if less than 150 points earned in a single tournament
• Subtract .5 to the denominator if less than 200 or 150 points earned in a single tournament
• Subtract .25 to the denominator if less than 250 or 200 points earned in a single tournament
Number of tournaments is 10 or above,
• Subtract 1 to the denominator if less than 200 points earned in a single tournament
• Subtract .5 to the denominator if less than 250 or 200 points earned in a single tournament
• Subtract .25 to the denominator if less than 300 or 250 points earned in a single tournament
Project ID: #37458021
About the project
Awarded to:
Hello my name is Jose Vaz and I'm an excel expert with a lot of experience in providing and helping with projects like this one. Ideally I would like to be provided with some sheets with data before I accept the proje More
5 freelancers are bidding on average ₹8060 for this job
Hello, I’m a certified data analyst. I have 10 years of experience in programming with Python. I’m experienced with the data science libraries such as numpy, pandas, and scimitar learn. So, I can address your project More
I am excited to hear from you regarding your project for create a tournament ranking formula. As a professional with extensive experience in the field of data analysis and content writing, I can guarantee that your pro More
