I would like an excel spreadsheet that calculates the best fantasy Football lineup based on 50,000 salary cap, player costs, 1.5x salary for captain choice, FPPG, and OPRK using the Draft Kings platform.
The worksheet should include the following columns for data entry
Column A: Player Name
Column B: Salary (Player Costs)
Column:C FPPG -(FPPG stands for Fantasy Points Per Game. It is simply the average amount of fantasy points (on that particular site) that a given player scores in one game. You will see it listed right next to each player's name.)
Column D: OPRK - OPRK stands for Opponent Ranking. OPRK is used to determine projections for future weeks vs. the opponents the player is playing. If Adrian Peterson (considered to be the best RB in fantasy football) was playing the 31st ranked rushing defense he would have a favorable opponent ranking. PVO stands for Position vs. Opponent.
Only one CPT (captains pick) can be selected in the results. These are identified as CPT under roster position in the example spreadsheet.
Functionality: I would like to input the data above and have the best potential lineup consisting of 6 player spots to include the 1 captains spot.(column F) This excel sheet would need to show totals of salary costs, FPPG, and OPRK for the best team scenario.
Use the attached spreadsheet data to create the final product. Also, I would like a short description on what was used to calculate the results. I want to make sure the calculations are correct.
5 freelancers are bidding on average $21 for this job
Hello , I have read your project description and I am interested to do your project I have experience in Excel sheet and done many sheets I can do this with accurately give me a chance to work on this project. Thanks