Fantasy Football Probability Calculator in EXCEL

Σε Εξέλιξη Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Σε Εξέλιξη Πληρώθηκε κατά την παράδοση

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.

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Μαθηματικά Γλώσσα Προγραμματισμού R

Ταυτότητα Εργασίας: #17958391

Σχετικά με την εργασία

3 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

3 freelancers κάνουν προσφορές κατά μέσο όρο $18 για αυτή τη δουλειά

dataexplorer

"Hello, I am happy to inform you that I have read your project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working her Περισσότερα

$30 USD σε 3 μέρες
(25 Αξιολογήσεις)
4.9
Iirin

Dear client, please share further details. The accuracy and timely delivery will be ensured. All the requirements will strictly be met. Looking Forward

$15 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
alimehdi03163637

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

$10 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0