Detailed DraftKings rankings - Fortinet Championship

[golfnhack]

OK. I know it is a day late, but have not had much time to work on the logic in the evenings lately. MANY late night work hours, since we just shipped our game, and live server support is constant.

 

Attached is an XLS that shows rankings for all players in the Fortinet Championship. Feel free to comment and provide feedback. I have also attached a Google Sheets link (for those of you who don't have Excel)

 

Here is a brief explanation of all the columns

 

• Name - The player's full name
• Salary - Their DraftKings contest salary
• Recent Form Pts - Ranking points based on the player's finish position in recent tournaments.
• Trending Pts - Ranking points based on how the user has trended in recent tournaments
• Scoring Pts - Rankings points based on number of Eagles or Better, Birdies, Pars, Bogeys, Doubles or worse in recent tournaments and DraftKings scoring points for each.
• Stat Pts - Ranking points based on a player's rankings in each stat for stats that are considered significant to doing well on the course the tournament is being played on.
• Bonus/Penalty Pts - Total bonus points from 3 categories: 1) Past results on the same course, 2) Starting Position (FedEx Tour Champs only), 3) Momentum carried over from last week's tournament less Total penalty points (Num DNF's)
• Total Pts - The total ranking points
• FPTS Value - The FPTS value for money factor, i.e. the average fpts / contest salary (0 being worst, 10 being best)
• Rank Value - The total ranking points value for money factor, i.e. the total ranking points / contest salary (0 being worst, 10 being best)
• Combined Value - (FPTS Value + Ranking Value) / 2 (0 being worst, 10 being best)
• Avg FPTS - The average FPTS earned in recent tournaments
• Risk Factors - The risk factors to consider. 2 Categories: 1) Number of recent DNF's. 2) Long period since last PGA start.
• Recent Form - A breakdown of finish positions in recent tournaments, ordered by most recent
• Trend - A visual showing  how the player is trending. The more +'s, the better they are trending. The more -'s, the worse they are trending.
• Bonuses/Pentalites - A breakdown of the bonuses awarded, penalties deducted.
• Egl+,Brd,Par,Bog,Dbl- - A breakdown of the scoring stats in recent tournaments
• Sampled Data - A breakdown of which data has been sampled for the player (if the player has no available data in a category, the data for players closest to them (but lower) in the world rankings is sampled and used)
• Rnd 1 Tee Time - Scheduled Round 1 tee time (in case of bad weather)
• Rnd 2 Tee Time - Scheduled Round 2 tee time (in case of bad weather)
• Significant stats [0-6] - The rankings in stats considered significant to playing well on the course the tournament is being played on. Anywhere from 0 to 6 stats.

 

Link to Full Rankings in Google Sheets

 

https://docs.google.com/spreadsheets/d/16-whanM3lSW6rhGt3fz_anpUxff97l65doBzRGbMRe8/edit?usp=sharing

 

 

 

 

 

fortinet.xlsx

Edited September 16, 2022 by golfnhack

[ThomasfromScarboro]

Wish I found this before I bet last week. Can't wait for the next one.