DFS Players Must See! (Draft Kings Data Trial Ballon)

I have developed an extensive excel geared towards DFS and want to get feedback on it's usefulness. I have attached a link to my dropbox, the file will be updated weekly. The goal of the excel is to compile data from multiple sources and combine it in one convenient location. It can be used for any DFS but the player cost is pulled from DK

Please give it a whirl and let me know the things you like, dislike, or think needs to be added.

There are also some bugs that I am slowly removing. I am currently working on getting the defensive points added and the defensive stats added that compile pts against per position ect. that'll probably be some time next week. Until then the opponents will either show correctly or show no opponent. This is just an artifact of where I pull that information from, that source does not contain info for my entire player database.

Brief rundown on the things I don't think are obvious.
AVG_L3 is players last three games played average
AVG_T3 is players top three games averaged
Std. Dev is standard deviation of pts per game
CV is the correlation variable, basically normalizes the Std. Dev number to the players avg score. For example if they are a high scoring player they will have a higher std. dev than a low scoring player but that doesn't mean the lower std.dev is better. This is a correction for that.
TGT% is a whacky stat I pull from a website, I eventually will remove this for actual targets a game. I believe it's tgt % based on players snaps.

There is 7 tabs for QB, RB, WR, TE, FLEX, DST, and Weekly points. last one is every players week by week scoring.

All sheets are in table form so you can sort and filter any of the stats or multiple stats in order to create a player criteria you are looking for. You must download from the link to utilize the ability to sort and filter the sheets.

Please give feedback.

https://www.dropbox.com/s/ibp3ri42uucbl50/GoldenLedger.xls.xlsx?dl=0

Apparently I linked the wrong excel, it's the exact same except I had not went through and converted each sheet into table form. Still need to download it to utilize table functions.

FYI current link has the updated correct version.

Bargain RBs that are outperforming their DK costs

T. West proj 16pts Cost 3700
west doesn't have strong stats over the last 3weeks but could be moving into a prominent role and thus you could buy low on this one

L McCoy proj 23pts Cost 5600
++ matchup this week and has been stepping it up since the bye

B. Rainey proj 18pts Cost 4400
++ matchup so may be able to outperform his current trend since Martin was injured of 13pts/gm by 4-6pts

These are some possible low cost cash game players i'm looking at

QB projections week 10

20PT locks:
Manning
Bree's
Rodgers
Palmer
Roethlisberger

17pt + locks
Ryan
Stafford
Tannehill

20pt (sleeper)
Josh McCown --> but if this scares you but you want to go with a long shot for GPP. Derek Carr linked with his TE Rivera will give you low cost bang allowing to pick out some nice top shelf talent with your spare salary.

Thanks for all this work btw. I've been playing DK a lot this season. Haven't had much luck with the NFL (college is where I'm making my money), so I'm hoping this will help me out.

Originally posted by Travisty13:
Thanks for all this work btw. I've been playing DK a lot this season. Haven't had much luck with the NFL (college is where I'm making my money), so I'm hoping this will help me out.

No problem at all, I'm just hoping that it's something that becomes very useful. Let me know if it helps!

Originally posted by Shorteous:

Originally posted by Travisty13:

Thanks for all this work btw. I've been playing DK a lot this season. Haven't had much luck with the NFL (college is where I'm making my money), so I'm hoping this will help me out.

No problem at all, I'm just hoping that it's something that becomes very useful. Let me know if it helps!

Will do.

Well some of my projections were disappointing, especially in the RB area. West was the only one that had a good night, the other two came at 10ppts.

Big Ben flopped
as Did Palmer but he did get injured.
Rodgers Manning Bree's all had 20+ Rodgers and Manning were 1 and 2 in QB points.

Tannehill flopped, Stafford made the 17 and ryan came in at 16 I think.

McCown hit 20pts, Derek Carr did ok but his cheap price and Rivera gave me the lineup that hit 175.

Spread sheet gave me a good week of 150+, 175+, and I eek out a 3 player league with a score of 196 to 194.

This weeks spread sheet has AMAZING upgrades to it. It is basically complete with all the errors removed. There is color coordinated opponent ranks, this is also included in the weekly points sheet. Shows you players score for each game of the season and is color coordinated.

DST points was added and PTS against/ranks for each team was added. It'll be updated at the link as soon as my sources upload some of the sheets I use. Should be tonight or tomorrow.

I won $5 off $2. Rolled with Rainey and McCoy in both DKs and my actual fantasy football league, needless to say, they didn't do much for me. They were my 2 lowest in DKs. Luckily everyone else got me 18.4 and above (I started Rivera at TE, he was my 3rd lowest scorer). So all in all, I still came out on top so I'm happy.