Calculation of Rating
18 USD 1 .The Chess score table.xlsx is the main table in which you need to make calculations.2ndTable - Assessment of ratings_solution attempt.xlsx - respectively an independent attempt to implement a task.ThreeRules-Rating.pdf - a description of how the ratings are calculated, approved by the official federation.Establishment of task:
1 .Get the data of the rating changes, they are given in the last column +/-
Verification: after the calculations, the numbers shall be equal or close to what is indicated in the column +/-
For example now for U6 rating 19,01 - accordingly, this result needs to be obtained.2ndI would like to get the data in the Perf column.Rat (not critical)
These columns are given yellow.All other columns are the source data, they are asked manually.Special remarks :
It can be simplified.Half rating (800,91 h) - ask as you want or give up it.In the second tab "Simplified version" the table is presented without "h".Some of the “slipper features” of the rating can also be simplified.The main thing is that during the competition there are normal "fair" ratings changes.The extreme cases:
If a person solves tasks at 100%, then his rating should not be lowered.If one participant has a rating of 3000 and the rest 1000.And let the 1000s solve a different number of tasks (including one of them solved all), and the 3000s solve all.In this case, the rating of the 3000s should not decline.As provided for use:
After the tournament, the ratings of the chess players are changed to +/- and recorded in the table with their ratings.For the new tournament, a table is copied and it enters changed ratings.The work is provided manually.
Applications 1
Client's review of cooperation with Vadym Bondarenko
Calculation of RatingExcellent work by Wadi. It’s nice to work with a professional as always. Excellent programmer, master of his business. Constantly on contact, all the terms of the task are 100% fulfilled, as well as I can further say that Vadim added additional options not provided in the tz. We will work more.
Freelancer's review of cooperation with Gavryushina Lyubov
Calculation of RatingThank you for cooperation! Everything went clean, without excessive processing, the price is adequate, the delays even a little rounded.
-
Winning proposal3 days18 USD
480 4 0 Winning proposal3 days18 USD
Good day !
Ready to take. I know Exel from childhood. With the add-on learned, nothing difficult, but the question, rather than everything, will be asked in the process of implementation.
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 days 23 hours back ∙ 10 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 5 days 4 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 6 days 5 hours back ∙ 112 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 8 days 12 hours back ∙ 44 proposals |
Lvov