Still working for 2020 Season :)

Hey scipio314 - awesome work. I was able to use this in last week's games. It takes some manual configuration since some projection values return 0 for players who's names on the spreadsheet may not match FantasyPros.

Was just wondering - are the projections in Standard, PPR or Half PPR?

[scipio314]

Projections are based on DraftKings scoring.

These pages are scraped: https://www.fantasypros.com/nfl/projections/wr.php

Then their stats are converted into equivalent fantasy points based on DraftKings scoring (including bonuses for 100+ yards in a game).

Thank you for the reply scipio314!

Is there any fix I can make to the spreadsheet to eliminate the manual work on the "My Team" tab of identifying player name cells who's corresponding value comes in as 0 simply because the value of the player name does not exactly match the player name value during the scraping process?

i.e. an example is DK Metcalf's value comes in as '0' after refreshing projections / injuries, because fantasy pros has his value as D.K. Metcalf (with punctuation after 'D' and 'K'.

[scipio314]

My suggestion would be to create a column of "Fantasy Pros Names" and a second column "DraftKings Names" and try to do a conversion macro.