What does your research spreadsheet/database look like? (1 Viewer)

[Scoresman]

I like spreadsheets, and studying the numbers is a big part of the FF hobby for me. I'm curious if anyone else is as as me with this.

Anyway I started on this spreadsheet for this year a few months ago and it has evolved over time as key stats to look at come to light. I use the "dashboard" to highlight which players to focus on for any given week.

http://i.imgur.com/6Jj0EkQ.png

I cut and paste projections from 3 sites, calculate the H values and sort on the average of all 3 sites' data. Then I pull in the Vegas O/U, the player's opponent's DvP for his position, and the expected game pace for that player's matchup based on Football Outsider's seconds/play stat. I also bring in RB/WR/TE last 3 week targets. Conditional formatting is used to highlight key spots to exploit or avoid.

All the data is cut and pasted from various sites and consolidated onto the main sheet in the screen grab above, so its mostly automated.

 

[Ebaker5]

I like spreadsheets, and studying the numbers is a big part of the FF hobby for me. I'm curious if anyone else is as as me with this.

Anyway I started on this spreadsheet for this year a few months ago and it has evolved over time as key stats to look at come to light. I use the "dashboard" to highlight which players to focus on for any given week.

http://i.imgur.com/6Jj0EkQ.png

I cut and paste projections from 3 sites, calculate the H values and sort on the average of all 3 sites' data. Then I pull in the Vegas O/U, the player's opponent's DvP for his position, and the expected game pace for that player's matchup based on Football Outsider's seconds/play stat. I also bring in RB/WR/TE last 3 week targets. Conditional formatting is used to highlight key spots to exploit or avoid.

All the data is cut and pasted from various sites and consolidated onto the main sheet in the screen grab above, so its mostly automated.

Thats a sick spreadsheet! I need to bury my nose in Excel and make me one. My desk looks like I could have killed the rain forest after all my numbers are laid out lol.

 

[jandyt]

Very nice spreadsheet. I have a small spreadsheet with vegas lines, predicted team score based on the line, H/A, and couple other things. I print this out and then pull up information on defense ranks vs run/pass and player targets and use them to create my projections. My projections go into a spread sheet which kicks out projected points for each player, DK value, and H value. I then look at the FBG IVC to see if there is anything that stands out as a outliner from my projections. I will reconsider outliners and sometimes change my projections, sometimes not. I then update my projections as injury information comes out during the week. Condensing it all into one sheet might be a good idea but I doubt I have I will time to do something like that before next season. Very impressive.

 

[Tennessee_ATO]

I try to keep 3rd party projections away from my own work. Much as jandyt does, I rely on the 3rd party projections to generally validate my work. If something is out of whack between mine and theirs, I will try to figure out the source of the disconnect, sometimes agreeing with the 3rd party projections, other times not.

 

[Scoresman]

I try to keep 3rd party projections away from my own work. Much as jandyt does, I rely on the 3rd party projections to generally validate my work. If something is out of whack between mine and theirs, I will try to figure out the source of the disconnect, sometimes agreeing with the 3rd party projections, other times not.

Do you measure the success of your projections against 3rd parties? I decided at the beginning of this that I'd leave the projections to the pros. I use the average of 3 sites to try and get more than one person's take. I'm sure any projections I'd come up with wouldnt differentiate enough to make a huge difference, anyhow.

 

[Rock Lonemilk]

Love this. Much clearer than mine. Wish I had the time and the skills to build a better spreadsheet.

 

[Peyton Marino]

whose projections do you use?

 

[jandyt]

I try to keep 3rd party projections away from my own work. Much as jandyt does, I rely on the 3rd party projections to generally validate my work. If something is out of whack between mine and theirs, I will try to figure out the source of the disconnect, sometimes agreeing with the 3rd party projections, other times not.

Do you measure the success of your projections against 3rd parties? I decided at the beginning of this that I'd leave the projections to the pros. I use the average of 3 sites to try and get more than one person's take. I'm sure any projections I'd come up with wouldnt differentiate enough to make a huge difference, anyhow.

I not going to say my projections are better than people who do it for living and have been doing it much longer than me. But I think the process of making the projections is huge benefit even if the end result isn't necessarily better than others or greatly different. I know for me my success rate is much higher since I started doing my own projections. I don't compare the results though to 3rd party projections though.

 

[texasheat]

Maybe that's my problem...I don't have a spreadsheet.

Starting out it wasn't a big deal, but last Sunday I ended up in around 100 contests and it got tough to keep track of leading up to KO

 

[Scoresman]

whose projections do you use?

Dodds, John Paulsen, and the free ones from rotogrinders.

 

[Peyton Marino]

whose projections do you use?

Dodds, John Paulsen, and the free ones from rotogrinders.

I use the first two and then Mike Clay from PFF. do you have any historical accuracy data on the free RG projections?

 

[Scoresman]

whose projections do you use?

Dodds, John Paulsen, and the free ones from rotogrinders.

I use the first two and then Mike Clay from PFF. do you have any historical accuracy data on the free RG projections?

No not at all. I just recently threw them in since they were free. They're definitely more bold in their projections, however.

 

[Tennessee_ATO]

I try to keep 3rd party projections away from my own work. Much as jandyt does, I rely on the 3rd party projections to generally validate my work. If something is out of whack between mine and theirs, I will try to figure out the source of the disconnect, sometimes agreeing with the 3rd party projections, other times not.

Do you measure the success of your projections against 3rd parties? I decided at the beginning of this that I'd leave the projections to the pros. I use the average of 3 sites to try and get more than one person's take. I'm sure any projections I'd come up with wouldnt differentiate enough to make a huge difference, anyhow.

No, because I don't do hard projections. My work is softer. I just group players into tiers based on what I think their production will be based on things like usage, past production, targets, match-ups, and anticipated game script. I'm actually not a fan of projections reducing everything to a fixed number (82 rushing yards and 0.7 TDs for example) because they give a very false sense of accuracy. At the end of the day, that "82 yards, 0.7 TD" projection would be "accurate" if the player rushes for 75 yards and 0 TDs or if he rushes for 90 yards and a TD. That's a spread of 7.5 to 15 -- the difference between a good play and a bad play. And from a more practical standpoint, we know for a fact that no RB will rush for 0.7 TDs, so there is already 4.2 points baked in that is either too low or too high. I get why everyone does it that way, I just think it creates an illusion that doesn't truly exist.

Once I create my tiers of players, I apply salaries to the mix and start building from there. Once I have lineups I like, I will then pull the 3rd party projections into the mix to see what number gets spit out and compare that to those projections' "optimum" lineup. If they say I'm projected to score, say, 112 and their top lineup is 134 I will try to figure out where the disconnect is. Sometimes I agree with them, sometimes I don't. I've largely been successful with my approach, but I've made no effort to calculate if I would have been more successful always defaulting to the 3rd party projections.

An early example of disconnect this week: Atlanta's defense. The Titans suck. Even if Mariota goes (and I think there's a great chance he won't), he's going to struggle mightily against any competent defense right now at 100% (and he's not 100%). The Titans OL is a bit of a mess and they can't run the ball worth a flip. The only rosterable Titan is Delanie Walker. Atlanta is my top defense irrespective of price. No one else is projecting them that highly. Am I right or are they right?

 

[Peyton Marino]

your spreadsheet inspired me to clean up some of the formatting in mine. i'll post a screenshot last this weekend, perhaps. a lot of the metrics I look at are similar to yours.

 

[Ebaker5]

After reading this thread I went out and created a sheet myself. Really streamlines the weekly selection process.

http://s952.photobucket.com/user/eric_baker5/media/DF%20Spread%20Sheet_zpsyhv0qsgv.png.html

 

[Scoresman]

After reading this thread I went out and created a sheet myself. Really streamlines the weekly selection process.

http://s952.photobucket.com/user/eric_baker5/media/DF%20Spread%20Sheet_zpsyhv0qsgv.png.html

Good stuff. I have something similar to the lineup thing you have on the right side of the screenshot. I recommend pulling the projections for each player over to see how each of your 3rd party projections scores your lineup. Sort of like in the below pic.

http://i.imgur.com/H59ccbT.png

 

[Ebaker5]

After reading this thread I went out and created a sheet myself. Really streamlines the weekly selection process.

http://s952.photobucket.com/user/eric_baker5/media/DF%20Spread%20Sheet_zpsyhv0qsgv.png.html

Good stuff. I have something similar to the lineup thing you have on the right side of the screenshot. I recommend pulling the projections for each player over to see how each of your 3rd party projections scores your lineup. Sort of like in the below pic.

http://i.imgur.com/H59ccbT.png

Really like that Idea, I will have to work on that tonight!

 

[Ebaker5]

After reading this thread I went out and created a sheet myself. Really streamlines the weekly selection process.

http://s952.photobucket.com/user/eric_baker5/media/DF%20Spread%20Sheet_zpsyhv0qsgv.png.html

Good stuff. I have something similar to the lineup thing you have on the right side of the screenshot. I recommend pulling the projections for each player over to see how each of your 3rd party projections scores your lineup. Sort of like in the below pic.

http://i.imgur.com/H59ccbT.png

How are you determining your floor?

 

[Scoresman]

After reading this thread I went out and created a sheet myself. Really streamlines the weekly selection process.

http://s952.photobucket.com/user/eric_baker5/media/DF%20Spread%20Sheet_zpsyhv0qsgv.png.html

Good stuff. I have something similar to the lineup thing you have on the right side of the screenshot. I recommend pulling the projections for each player over to see how each of your 3rd party projections scores your lineup. Sort of like in the below pic.

http://i.imgur.com/H59ccbT.png

How are you determining your floor?

It's part of John Paulsen's projections. I just added it this week. I'm not too sure how useful it is though because all of the lineups I make hover around the same floor. I'm also not sure I agree with all the values I'm seeing.

 

[Bri]

I like spreadsheets, and studying the numbers is a big part of the FF hobby for me. I'm curious if anyone else is as as me with this.

Anyway I started on this spreadsheet for this year a few months ago and it has evolved over time as key stats to look at come to light. I use the "dashboard" to highlight which players to focus on for any given week.

http://i.imgur.com/6Jj0EkQ.png

I cut and paste projections from 3 sites, calculate the H values and sort on the average of all 3 sites' data. Then I pull in the Vegas O/U, the player's opponent's DvP for his position, and the expected game pace for that player's matchup based on Football Outsider's seconds/play stat. I also bring in RB/WR/TE last 3 week targets. Conditional formatting is used to highlight key spots to exploit or avoid.

All the data is cut and pasted from various sites and consolidated onto the main sheet in the screen grab above, so its mostly automated.

Nice that you put so much time in on the spreadsheet.

It looks nice

I think it's sorely lacking in facts.

I am a huge proponent of gut calls and (if this is gambling) think gut calls pay off better than just rolling with facts but...this isn't for me.

Do you have success with it?

Then it's great.

If not try adding columns of stats gained, allowed etc. and weeding out some opinions OR giving them less "strength" in your cumulative value.

I get real dorky and could probably tell you what some WRs father scored against the Seattle D before I'll tell ya what DD projects for them. To each his own, just trying to offer some feedback

 

[Scoresman]

I like spreadsheets, and studying the numbers is a big part of the FF hobby for me. I'm curious if anyone else is as as me with this.

Anyway I started on this spreadsheet for this year a few months ago and it has evolved over time as key stats to look at come to light. I use the "dashboard" to highlight which players to focus on for any given week.

http://i.imgur.com/6Jj0EkQ.png

I cut and paste projections from 3 sites, calculate the H values and sort on the average of all 3 sites' data. Then I pull in the Vegas O/U, the player's opponent's DvP for his position, and the expected game pace for that player's matchup based on Football Outsider's seconds/play stat. I also bring in RB/WR/TE last 3 week targets. Conditional formatting is used to highlight key spots to exploit or avoid.

All the data is cut and pasted from various sites and consolidated onto the main sheet in the screen grab above, so its mostly automated.

Nice that you put so much time in on the spreadsheet.

It looks nice

I think it's sorely lacking in facts.

I am a huge proponent of gut calls and (if this is gambling) think gut calls pay off better than just rolling with facts but...this isn't for me.

Do you have success with it?

Then it's great.

If not try adding columns of stats gained, allowed etc. and weeding out some opinions OR giving them less "strength" in your cumulative value.

I get real dorky and could probably tell you what some WRs father scored against the Seattle D before I'll tell ya what DD projects for them. To each his own, just trying to offer some feedback

It's biggest advantage is how it lets you organize the research. Success is hard to measure since I've never done DFS without this, but I am +EV on the year so it must be helping a little. That said, the organizing of info is the biggest benefit this gives me. Without it, my research would be a mess. It took some time to set up but I make that time back more and more as each week passes.

I disagree that it lacks in facts though. The Target, Pace and DvP numbers alone are all facts based on previous weeks' stats. As for the projections themselves I agree they're only worth so much but I use some of the best ones out there. I did want to use the PFF advanced stats, but since they decided against continuing to offer them, I decided against it.

 

[Peyton Marino]

my link

 

[SeniorVBDStudent]

I like spreadsheets, and studying the numbers is a big part of the FF hobby for me. I'm curious if anyone else is as as me with this.

Anyway I started on this spreadsheet for this year a few months ago and it has evolved over time as key stats to look at come to light. I use the "dashboard" to highlight which players to focus on for any given week.

http://i.imgur.com/6Jj0EkQ.png

I cut and paste projections from 3 sites, calculate the H values and sort on the average of all 3 sites' data. Then I pull in the Vegas O/U, the player's opponent's DvP for his position, and the expected game pace for that player's matchup based on Football Outsider's seconds/play stat. I also bring in RB/WR/TE last 3 week targets. Conditional formatting is used to highlight key spots to exploit or avoid.

All the data is cut and pasted from various sites and consolidated onto the main sheet in the screen grab above, so its mostly automated.

Nice work.

Regarding opponent's DvP, do you have a good source for pseudo-automating that import? Ditto for the last 3 weeks targets....do you import one week at a time or is there a site that is easily leechable with multi-week data in an extraction friendly format?

I'm still using a odds driven spreadsheet due to irritation over the lack of good sources for the above....tia.

 

[Scoresman]

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

 

[Scoresman]

I like spreadsheets, and studying the numbers is a big part of the FF hobby for me. I'm curious if anyone else is as as me with this.

Anyway I started on this spreadsheet for this year a few months ago and it has evolved over time as key stats to look at come to light. I use the "dashboard" to highlight which players to focus on for any given week.

http://i.imgur.com/6Jj0EkQ.png

I cut and paste projections from 3 sites, calculate the H values and sort on the average of all 3 sites' data. Then I pull in the Vegas O/U, the player's opponent's DvP for his position, and the expected game pace for that player's matchup based on Football Outsider's seconds/play stat. I also bring in RB/WR/TE last 3 week targets. Conditional formatting is used to highlight key spots to exploit or avoid.

All the data is cut and pasted from various sites and consolidated onto the main sheet in the screen grab above, so its mostly automated.

Nice work.

Regarding opponent's DvP, do you have a good source for pseudo-automating that import? Ditto for the last 3 weeks targets....do you import one week at a time or is there a site that is easily leechable with multi-week data in an extraction friendly format?

I'm still using a odds driven spreadsheet due to irritation over the lack of good sources for the above....tia.

DvP

Targets (might require a FBG sub)

I just copy paste into Excel.

 

[Peyton Marino]

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

footballoutsiders DVOA rankings

 

[SeniorVBDStudent]

I'm currently looking for:

- an exportable table format depth chart that will allow me to automate Julio = WR1, Hankerson = WR2, Roddy = WR3, etc for all skill positions and, preferably all corners and safeties too.

- an exportable table format ranking of active secondary players

Regarding #2, are there any well respected rankings out there besides subscription required pro football focus?

Any links for the above would be appreciated....

 

[Ebaker5]

I build a spread sheet.... ignore it... if I would have listened, i would be in the money everywhere this week ....

Lead a horse to water....

 

[yoALB]

so my spreadsheet(s) are a work in progress. I've only started making one in the last 2 or 3 weeks and I'm liking how it's working out.

I make one sheet with the DK Salaries I download and i just go through the list and highlight guys that I like.

Then, I make another spreadsheet with the matchups on individual tabs. This is the most extensive and time consuming. I copy and paste avg points for and against, the defense vs offense matchup stats for both teams, and I make a section for game "comments" where i write pretty much anything significant about the game and also how i think the matchup will play out (i.e. where each team will choose to attack their opponents based on their weaknesses, etc). Then i add a list of all the players i'd like to target from the game.

My 3rd sheet is where i copy and paste the DVOA rankings from Football Outsiders and highlight possible matchups to target. I then write all the names of the players who should benefit from those matchups in a new tab. I also then transfer the names of my targets from the 2nd spreadsheet next to these names to see the overlap. The third and final (!) column is one with WRs who have good matchups according to mike clay's WR vs. CB chart on PFF. Again, I notice which players are showing up on more than 1 of these lists. I then use my discretion in making the overall targets list.

I don't use projections or really know what h value is. I would like to get an opportunities (how is that calculated?) stat in there as well as red zone targets, but i am not sure where i would get the data or which spreadsheet i would include it in.

Now I'm not a super advanced excel guy, but i can do the basic vlookups and pivot tables. I'm trying to get this more streamlined and automated, so if anyone has any suggestions on how i can make this cleaner and reduce my manual labor i would VERY much appreciate it.

 

[Scoresman]

so my spreadsheet(s) are a work in progress. I've only started making one in the last 2 or 3 weeks and I'm liking how it's working out.

I make one sheet with the DK Salaries I download and i just go through the list and highlight guys that I like.

Then, I make another spreadsheet with the matchups on individual tabs. This is the most extensive and time consuming. I copy and paste avg points for and against, the defense vs offense matchup stats for both teams, and I make a section for game "comments" where i write pretty much anything significant about the game and also how i think the matchup will play out (i.e. where each team will choose to attack their opponents based on their weaknesses, etc). Then i add a list of all the players i'd like to target from the game.

My 3rd sheet is where i copy and paste the DVOA rankings from Football Outsiders and highlight possible matchups to target. I then write all the names of the players who should benefit from those matchups in a new tab. I also then transfer the names of my targets from the 2nd spreadsheet next to these names to see the overlap. The third and final (!) column is one with WRs who have good matchups according to mike clay's WR vs. CB chart on PFF. Again, I notice which players are showing up on more than 1 of these lists. I then use my discretion in making the overall targets list.

I don't use projections or really know what h value is. I would like to get an opportunities (how is that calculated?) stat in there as well as red zone targets, but i am not sure where i would get the data or which spreadsheet i would include it in.

Now I'm not a super advanced excel guy, but i can do the basic vlookups and pivot tables. I'm trying to get this more streamlined and automated, so if anyone has any suggestions on how i can make this cleaner and reduce my manual labor i would VERY much appreciate it.

Vlookups are the way to go. My biggest issue has been that some players' names are different on the various sites I pull the data from. For example, the Fanduel salaries export lists Christopher Ivory and everywhere else has him as Chris. Also ODB is a huge problem, because one site doesnt put the Jr in his name, and yet another puts a period after the Jr, screwing everything up.

Also, h value is simply the projection raised to the power of 1.78 divided by the salary. It's a complex form of points/dollar that makes it more usable.

 

[BradtheAg]

so my spreadsheet(s) are a work in progress. I've only started making one in the last 2 or 3 weeks and I'm liking how it's working out.

I make one sheet with the DK Salaries I download and i just go through the list and highlight guys that I like.

Then, I make another spreadsheet with the matchups on individual tabs. This is the most extensive and time consuming. I copy and paste avg points for and against, the defense vs offense matchup stats for both teams, and I make a section for game "comments" where i write pretty much anything significant about the game and also how i think the matchup will play out (i.e. where each team will choose to attack their opponents based on their weaknesses, etc). Then i add a list of all the players i'd like to target from the game.

My 3rd sheet is where i copy and paste the DVOA rankings from Football Outsiders and highlight possible matchups to target. I then write all the names of the players who should benefit from those matchups in a new tab. I also then transfer the names of my targets from the 2nd spreadsheet next to these names to see the overlap. The third and final (!) column is one with WRs who have good matchups according to mike clay's WR vs. CB chart on PFF. Again, I notice which players are showing up on more than 1 of these lists. I then use my discretion in making the overall targets list.

I don't use projections or really know what h value is. I would like to get an opportunities (how is that calculated?) stat in there as well as red zone targets, but i am not sure where i would get the data or which spreadsheet i would include it in.

Now I'm not a super advanced excel guy, but i can do the basic vlookups and pivot tables. I'm trying to get this more streamlined and automated, so if anyone has any suggestions on how i can make this cleaner and reduce my manual labor i would VERY much appreciate it.

Vlookups are the way to go. My biggest issue has been that some players' names are different on the various sites I pull the data from. For example, the Fanduel salaries export lists Christopher Ivory and everywhere else has him as Chris. Also ODB is a huge problem, because one site doesnt put the Jr in his name, and yet another puts a period after the Jr, screwing everything up.

Also, h value is simply the projection raised to the power of 1.78 divided by the salary. It's a complex form of points/dollar that makes it more usable.

Had the same issue in a sheet I put together to bet props. The solution was to build a list of all the alternate names I was having to correct, then adding hidden columns to the sheet with IFERROR vlookups that referenced the table and pulled in the alternate name, then adding an IFERROR to the vlookup pulling the projections and pointed it to both name columns to make it all line up.

 

[Scoresman]

Yeah, that's exactly how I ended up fixing them. I got annoyed having to go in and manually correct the exports.

One site even uses Steve-L Smith. I mean really?

 

[Peyton Marino]

so my spreadsheet(s) are a work in progress. I've only started making one in the last 2 or 3 weeks and I'm liking how it's working out.

I make one sheet with the DK Salaries I download and i just go through the list and highlight guys that I like.

Then, I make another spreadsheet with the matchups on individual tabs. This is the most extensive and time consuming. I copy and paste avg points for and against, the defense vs offense matchup stats for both teams, and I make a section for game "comments" where i write pretty much anything significant about the game and also how i think the matchup will play out (i.e. where each team will choose to attack their opponents based on their weaknesses, etc). Then i add a list of all the players i'd like to target from the game.

My 3rd sheet is where i copy and paste the DVOA rankings from Football Outsiders and highlight possible matchups to target. I then write all the names of the players who should benefit from those matchups in a new tab. I also then transfer the names of my targets from the 2nd spreadsheet next to these names to see the overlap. The third and final (!) column is one with WRs who have good matchups according to mike clay's WR vs. CB chart on PFF. Again, I notice which players are showing up on more than 1 of these lists. I then use my discretion in making the overall targets list.

I don't use projections or really know what h value is. I would like to get an opportunities (how is that calculated?) stat in there as well as red zone targets, but i am not sure where i would get the data or which spreadsheet i would include it in.

Now I'm not a super advanced excel guy, but i can do the basic vlookups and pivot tables. I'm trying to get this more streamlined and automated, so if anyone has any suggestions on how i can make this cleaner and reduce my manual labor i would VERY much appreciate it.

Vlookups are the way to go. My biggest issue has been that some players' names are different on the various sites I pull the data from. For example, the Fanduel salaries export lists Christopher Ivory and everywhere else has him as Chris. Also ODB is a huge problem, because one site doesnt put the Jr in his name, and yet another puts a period after the Jr, screwing everything up.

yes, this is my personal hell. ended up doing what the guy a couple posts up described.

 

[Alexanderson]

I write all my stuff down like an old man and just use sites for info on targets and other such stats. I barely know what a spreadsheet is. I open Excel and I just stare at it and cry.

 

[rlwomack]

Here's a sample of a previous week's spreadsheet (http://i.imgur.com/pFclVDr.jpg). I constantly add to it when I find stats that might help make a better determination. I also have a separate sheet for each position as it helps when having to merging data.

I use Dodds' projections and the FBGs target sorter and usually only look at the last 4 games of data for it to see if I see a trend emerging.

The "aFPA" comes from John Paulson's site and are Adjusted Fantasy Points Allowed per position. I also look at PFF's WR vs CB worksheet for additional data on the individual WR matchups.

Question for those who use multiple projections. What allocation percentage do you normally use to combine them into one set of projections?

I wish FBGs would put their red zone data in the same format that they have for the target sorter. I'm sure that can't be done now, but would like to see if they could do that for next season.

Love the ideas everyone is sharing. I will definitely try to incorporate some of them into my worksheets. Now I've just got to re-learn how to use the VLOOKUP function.

 

[MikeMan]

Love it! The big thing missing, in my opinion, is a look-back to see how you did - and then use that knowledge going forward. Calculate a statistical r^2 by player and position maybe? I think what you will find, and seems common sense, is you have better predictions for some positions and some players than others. Wide Receivers will have a lower ability to project correctly but if you find Antonio Brown deviates less than others, you give him a pop. I did the math on NFL before switching to NBA as I simply found the NFL too unpredictable from a statistical regression analysis. I believe a 'look back' and grading yourself is highly missing from every FF site for good reason. I still play of course!

 

[KarmaPolice]

I write all my stuff down like an old man and just use sites for info on targets and other such stats. I barely know what a spreadsheet is. I open Excel and I just stare at it and cry.

This me too. I have gone through a couple notebooks already this year with all my scribblings and lineup ideas.

 

[SeniorVBDStudent]

Is it true that both pausons aFPA and the PFF wr vs cb spreadsheet are paid content? If not, link?

 

[jandyt]

I write all my stuff down like an old man and just use sites for info on targets and other such stats. I barely know what a spreadsheet is. I open Excel and I just stare at it and cry.

This me too. I have gone through a couple notebooks already this year with all my scribblings and lineup ideas.

I do both have three excel spread sheets I use for variable things but also end with 3 or 4 sheets of paper with stuff written all over them every week.

 

[rlwomack]

Is it true that both pausons aFPA and the PFF wr vs cb spreadsheet are paid content? If not, link?

Yes, they are both part of their paid content.

 

[Peyton Marino]

Is it true that both pausons aFPA and the PFF wr vs cb spreadsheet are paid content? If not, link?

both paid.

 

[Scoresman]

Anyone have a good source for aDOT stats or yards/target for WR/TE?

 

[SeniorVBDStudent]

Is it true that both pausons aFPA and the PFF wr vs cb spreadsheet are paid content? If not, link?

both paid.

Ok. If there arent any free alternatives i guess i will use football outsiders' defense against wr1, wr2, wr3.

Any other (free) options?

 

[Alexanderson]

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

footballoutsiders DVOA rankings

May I ask how you utilize this information? I'm NOT a numbers guy and I'm looking at this and I'm following on a very base level but how does it inform you decisions? Feel free to keep it basic, Lol.

 

[Peyton Marino]

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

footballoutsiders DVOA rankings

May I ask how you utilize this information? I'm NOT a numbers guy and I'm looking at this and I'm following on a very base level but how does it inform you decisions? Feel free to keep it basic, Lol.

scroll to the first chart. I look at 'Defense DAVE' rank to determine projected overall defense strength going forward. Then I look at the 'Pass Rank' and 'Rush Rank' columns to determine a defense's overall strength against the pass and the run. So, for instance, the 49ers are dead last in passing defense.

 

[Tennessee_ATO]

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

footballoutsiders DVOA rankings

May I ask how you utilize this information? I'm NOT a numbers guy and I'm looking at this and I'm following on a very base level but how does it inform you decisions? Feel free to keep it basic, Lol.

This information is extremely useful in figuring out matchups to target/avoid. The DVOA rankings allow you to see what defenses are good (or bad) overall, against the run, against the pass, against a #1 WR, etc. You don't even really have to fret too much with math to incorporate them into your decision-making. Even if you just rely on it as a "tie breaker" it can be useful. For example, if you are torn between 2 WRs, the DVOA can help you decide if one of them is facing a defense that sucks against the passing attack and another is facing a defense that sucks against the passing attack. You can drill down even further and see how those defenses do against #1 WRs, as some teams (like Indy) are really good against #1 WRs, but really bad against WR3 and TE.

 

[Alexanderson]

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

footballoutsiders DVOA rankings

May I ask how you utilize this information? I'm NOT a numbers guy and I'm looking at this and I'm following on a very base level but how does it inform you decisions? Feel free to keep it basic, Lol.

This information is extremely useful in figuring out matchups to target/avoid. The DVOA rankings allow you to see what defenses are good (or bad) overall, against the run, against the pass, against a #1 WR, etc. You don't even really have to fret too much with math to incorporate them into your decision-making. Even if you just rely on it as a "tie breaker" it can be useful. For example, if you are torn between 2 WRs, the DVOA can help you decide if one of them is facing a defense that sucks against the passing attack and another is facing a defense that sucks against the passing attack. You can drill down even further and see how those defenses do against #1 WRs, as some teams (like Indy) are really good against #1 WRs, but really bad against WR3 and TE.

my link

Nice. Where do you get the Pass and Rush D numbers from? This is what I wanted to get from PFF before they discontinued their stats.

footballoutsiders DVOA rankings

May I ask how you utilize this information? I'm NOT a numbers guy and I'm looking at this and I'm following on a very base level but how does it inform you decisions? Feel free to keep it basic, Lol.

scroll to the first chart. I look at 'Defense DAVE' rank to determine projected overall defense strength going forward. Then I look at the 'Pass Rank' and 'Rush Rank' columns to determine a defense's overall strength against the pass and the run. So, for instance, the 49ers are dead last in passing defense.

Very helpful. I'm going to incorporate this into my regimen this week. I typically use fftoday and just take each position and determine what defense is bad against easch position based on yardage, TDs, and fantadsy points allowed and see where the overlap is. This is that next step I've been looking for. Thanks much! Gonna watch this thread and see what other info I should be looking at.

I do fine but not fine enough. $_$