Recent content by Yamato

In a slow draft and looking at these 2.  

I play in a non PPR league that gives 4 points for all TD's.  We start 2 RB, 2 WR, and 2 flex.  The 5.4 PPG is for the 84th best player but should be 5.7 for 78th best player.

I have those numbers.  I'm much more conservative.  Here are some of the players I have given games missed from Injury: Tevin Coleman 1 game John Brown 2 games LeSean McCoy 1 game Greg Olsen 1 game John Ross 1 game Allen Hurns 2 games Emmanuel Sanders 1 game Ty Montgomery 2 games...

The purpose for this post is to figure out how to rank players who are consistently injured.  II'm looking for ideas not trying to press my methods. The questions I asked I'd like to talk about. How do you value Jordan Reed?  Last 3 years he hasn't played more than 14 games.  Gronk hasn't...

How do you value Jordan Reed?  Last 3 years he hasn't played more than 14 games.  Gronk hasn't played more than 13 games the past 2 seasons.  Do you project them for 16 games? How do you rank Eifert? Edelman and Engram will miss 4 games each.  So unless they get hurt they'll get you 12 games. ...

Regarding roster/positional scarcity I did say I was considering a dead roster spot penalty. My example was based on a SUSPENDED player who will be out a specified number of games.  People keep saying you can't predict injuries? I'm not.  I'm projecting risk.  If a player for the past 3 years...

The replacement number is bases on AVT from my league standings.  Or for PPR I use this. The replacement number is bases on AVT from my league scoring.  Or for PPR I use this. https://www.footballdiehards.com/ledger/AVT_ledger.cfm The actual number for my league is 5.44 for RB's and WR's. ...

This year I'm adding games missed to my projections (projected injuries, suspensions).  I'm figuring out per game averages and using average replacement (#18 QB, #30 RB, and so on) for games missed to come up with a yearly average for that starting roster position.  So say a player averages 15...

Anyone know of a website that provides future Vegas Over/Under predictions?  Trying to use this as a strength of schedule tool but I'm having a hard time finding.  Way back in the 3.5" floppy days I had a program that would predict spread and over under but no luck finding anything like that as...

Exactly.  SOS could be made into a must have if researched and cross referenced.  End of the year SOS along with coaching and roster changes/injuries would make for a better tool.  I've been trying to incorporate offensive/ defensive games lost into the mix...

During the season subscribers can use Custom Strength of Schedule under My FBG. This is great because my league uses 4 points for all TD's and -2 for INT's.  Problem is we have to use a generic Strength of Schedule during the preseason (Ultimate Strength of Schedule).  I have to use my non...

I think I'm set everyone.  Dan Keys just got me pointed in the right direction.  Thanks all.

Sorry for not being articulate on this matter.  I've ported the stats to google docs and here it is.  https://docs.google.com/spreadsheets/d/1Lx80LrCW7n6SlZXpYXbzHf6L-9GmSjmk4uC4_khAMY8/edit#gid=543145399 I'll try again to explain what I'm looking to do. Take average team stats from "Team Ave"...

Thanks for your reply Mike. I'm trying to get average stats for all teams played against.  So 16 sets of stats for each position.  QB stats would be completions, attempts, passing yards, TDs, interceptions, 2PC, rushing attempts, yards, and TDs.  Is VLOOKUP able to grab a row of stats and add...

I'm trying to add up data for a strength of schedule analysis I'm doing.  I want to get an average of stats scored against each team and compare that to actual stats given up.  I've got the data and a schedule grid but I need help automating it.  I'd like to enter the team name and position into...