'koreansteve said:
Got some extra time today so I'm embarking on creating my projections for 2012.
Curious, how do you guys create your projections?
Any tips, suggestions, warnings for a first time projector?
1. Set up your excel spreadsheet w/ a seperate sheet for each of the 4 primary positions (QB, RB, WR, TE)Make sure you set it up to auto calc the total points (TP) and points per game (PPG) based on your leagues bylaws
For instance at QB, the columns would be NAME, TEAM, BYE, GAMES, ATTEMPTS, COMPL, COMPL %, TD, INT, RUSH ATT, YDS, TD, TP, PPG, (VBD, ADP)
2. The easiest two positions to start w/ are QB and TE.
3. When you do the RB and WR positions, the easiest way to process thru is to do a complete team at a time. As a self check process, you should be
going back and ensuring that the numbers you are generating balance out against one another. i.e. add up your rects, yardage totals and TD's for the
RB, WR, and TE on a given team and verify that matches up with your QB projections
4. Now that you have doen your projections, start slotting in the players by rank based on those projections. Then utilize a VBD (value based drafting)
algorithim to better contrast compare values btwn positions. This is IMO, critical if you expect to use your intel effectively.
5. Go out and do some research on ADP. Be careful to select quality data when doing this or you will get yourself burned.
I hope that helps.
P.S. Also keep in mind that there is historical turnover averages at each position. Dont get yourslef locked in the herd mentality when doing your projections. For instance in PPR at the WR position, the average turnover in the Top 10 WR from the prior year is in excess of 50% historically. In fact it is closer to 60% for the last decade. When you move out to the top 20 year over year, the average is still somewhere between 40-50%. I have the exact %'s but dont have them with me right now.