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.
A link to the google sheet showing the rankings data is attached. Feel free to comment and provide feedback.
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
https://docs.google.com/spreadsheets/d/16-whanM3lSW6rhGt3fz_anpUxff97l65doBzRGbMRe8/edit?usp=sharing