I have the statistics from a Baseball league. I want to rate all the existing players with a certain formula.
Use the stat of RBI+RUNS divded by number of games to give a number (this is column 1) assume 1 is the highest you can get...if over 1 then reduce this number to 1.
Then add slugging and OBP= OPS (this is column 2)
Column 3 will be Column 1(max 1) + 2(column 2) --- The maximum will be 5 (highest number achieved)
Then rank all the players from there.
The sheet has to be clear and consise with column 1, column 2 and column 3 calculations easily viewed, and another page with the rankings and team the player played with, and their column 3 number.
28 freelancers are bidding on average $44 for this job
I am ready to complete the projects in 2 days. I have mentioned 2 days as because I don't want to do the thing in hurry but would like to do it with perfection.