Weekly Projections in Excel? (1 Viewer)

[Seven Costanza]

Which tool or where can I find the weekly projections in excel similar to what the projections dominator has for the annual projections? I want to drop the weekly projections from Dodds, Henry, Wood, and Trembay into my excel schedule to convert the stats into fantasy points based on my league scoring.

I built a VBD excel program from scratch for my draft and I am hoping to now easily convert it to a week to week projection tool.

Thanks guys!

 

[Maurile Tremblay]

I don't think we make a downloadable file available for the weekly projections.

You could copy/paste the projections into Excel from the website, or you could set up a query in Excel to automatically "get external data from web." (You can get the relevant URLs from the projections pages on the website.) I do the latter because I like to average our weekly projections together for purposes of FanDuel and the other daily games. Once you set up a query within a macro, it takes just a few seconds to get all of the latest projections and to average them together, if that's what you want.

I'd also strongly recommend checking out the capabilities of MyFBG. You can enter your scoring system there (and automatically sync your league's rosters if it's on a major hosting site) and then get projections from each projector that are converted to points based on your scoring system. It will show you the highest projected point totals from both your roster and from any available free agents....

 

[Seven Costanza]

I don't think we make a downloadable file available for the weekly projections.

You could copy/paste the projections into Excel from the website, or you could set up a query in Excel to automatically "get external data from web." (You can get the relevant URLs from the projections pages on the website.) I do the latter because I like to average our weekly projections together for purposes of FanDuel and the other daily games. Once you set up a query within a macro, it takes just a few seconds to get all of the latest projections and to average them together, if that's what you want.

I'd also strongly recommend checking out the capabilities of MyFBG. You can enter your scoring system there (and automatically sync your league's rosters if it's on a major hosting site) and then get projections from each projector that are converted to points based on your scoring system. It will show you the highest projected point totals from both your roster and from any available free agents....

Thanks Maurile!! I always forget about the Data from Web option within excel!! I can definitely pull the projections into excel from the website using this. I dont think I am smart enough in excel to write a query within a macro to automatically pull the projections from the website, but I would love to do that if you could send me any tips!! Again, I would love to average a few of the writers projections on a weekly basis, but without unique identifiers I am not sure how this would line up??

As far as FBG, it is a great tool but I always struggle to use tools like this because my league has yardage threseholds, not simply 1 point per 10 yards etc. I looked at FBG and it just isnt designed to handle a threshold. For example, our RBs and WRs get 0 points for yards 0-49, but once they hit 50 yards it is a flat 5 points for that and then 1 point for every 10 yards over that. So if a player projects to get 49 yards rushing and receiving, our league would say 0 points, but MY FBG would most likely convert that to 10 points.

Do you see my issue?