What's new
Fantasy Football - Footballguys Forums

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Guys that make your own cheatsheets (1 Viewer)

Cowboysfan8

Cowboysfan8

Footballguy
How do you do it? Do you start with someone else's rankings and tweak them to your liking on paper?

Is there a website out there that allows you to do this then print it?

I've always printed a sheet from various sites over the years and highlighted names with different colors, but I've always wanted to create my own rankings but have no idea how except pen and paper and am too lazy for that

 
Start with last years final league stats  from cbs the previous year, using my leagues scoring, i can export as an excel, add rookies at draft, then tweak as i go...

 
Last edited by a moderator:
that's what I do

then tweak according to coaching changes, players changing teams, coming back from injury etc and most of all, gut feeling

drafting like everyone else is boring and won't win you much IMO

 
mphtrilogy said:
Start with last years final league stats  from cbs the previous year, using my leagues scoring, i can export as an excel, add rookies at draft, then tweak as i go...
Click to expand...
Yeah, you lost me at "export an excel" :lol:

I was afraid it may involve real computer skills..I don't have any

 
I export rankings to excel from.  The formatting is a little screwy, so I do a little exercise in copy pasting names into columns (QB. RB, WR LB, DB, etc).  Then I create a column in between each of those.  In that column, I assign a number 1-10 to each player.  Those are my tiers- 1 being stud, 10 being lowest rank.  During the camp as pre-season games and camp news is flowing fast, I adjust the numbers as I see fit.  Then, just before the draft, I sort and filter each column from lowest to highest.  Takes about three minutes.

From there, I just black out names as they are drafted.

 
Short Corner said:
There's an opening in our league if you are looking to join one more.
Click to expand...
Meh..I've been playing for a long time. I'm just trying to find an easy way to make my own rankings instead of doing it the hard way again.

Thanks for the 20 yr old message board line though..

 
Cowboysfan8 said:
How do you do it? Do you start with someone else's rankings and tweak them to your liking on paper?

Is there a website out there that allows you to do this then print it?

I've always printed a sheet from various sites over the years and highlighted names with different colors, but I've always wanted to create my own rankings but have no idea how except pen and paper and am too lazy for that
Click to expand...
you're a cowboys fan but here you go:

cheatsheetking.com

 
I make a bunch of projections over the course of the offseason but I never seem to finish them all enough to bother compiling it all into one cheat sheet. I change my mind about things pretty frequently as I view all of it being a large range of possibilities anyways. The projections are more to help quantify what players are worth, and just learning more about each teams situation. I don't draft based off of projections.

I consider ADP a lot while drafting, which is always very different than how I value players. I look for players who seem like bargains, the flip side of that is players with ADP that is too high for me, I spend less time trying to quantify those players as I already view them as being out of range. I spend more time on the players who I think present some value at their draft position.

I wont follow the cheat sheet when I draft anyways, so seems like a wasted step.

 
It's all in my head.  I don't make a sheet because I have it all mentally.  I've won many titles and have never ranked players.   I do it by research.

 
redraft vs dynasty/keeper drafts matter too

I have a 10 team re-draft with 3 keepers .... I wanted WR Thomas from NOS and I took him round 7. Sure ... I jumped, but I wanted him. Dynasty, I wanted Marvin Jones and had to move CJ Anderson and WR Hurns to get him and RB Matt Jones. I'm that high on Marvin .... am I right? Time will tell ... but I've done some risky moves and gut moves in the past well beyond the normal ADP type plays and they worked and worked well

 
I actually stole the VBD Excel format years ago.  I kept their cheatsheet page, then made tabs for each position.  Every year I pull their cheatsheets by position and paste them into each of the tabs.  Then I built columns for different professional rankings, I always have Dodds with my scoring system in there, a couple of competing websites and usually Jason Woods independant rankings.  (No defensive explaination for Jason except that I've always liked his analysis and respect his thoughts).  Then I personally rank them in my own column, feeling free to be a biased homer or hater.  In the final column, I created a sum of all the other columns, giving each different weights with mine being about 30% to add to 100%.  I call it my reach protector.

It was work the first year and it is a pain in the ### to type in all the rankings before the draft, but its fun and when I'm done, I feel really ready to draft.

 
I find it best to work off a cheat sheet of their current ADP, not my personal rankings, so value is easy to evaluate as I move along, and then I just mentally make a list of what players I like and don't like. 

 
Last edited by a moderator:
For my auction league I have a spreadsheet that I use each year.  I check a few different site's projections and along with my own opinions I will enter in each player's projected stats into the spreadsheet.  It has a formula that will generate the projected scores for my league's settings and generate auction values for each one.  It's pretty damn accurate.  Seems like a lot of work and I'm sure I could do just as well without it but I find it enjoyable.  Just a hobby basically.

 
Excel spreadsheet, couple columns - name, team, bye, INJ flags, wide "notes" column which I update frequently.

I keep them sorted alphabetically until week 3 of the preseason. That will be my first ranking, then tweak'em up until the draft.

No projections. No mock drafts.

 
3/4 of my leagues are on Yahoo so I take their initial rankings, put it in excel and divide them up into tiers and positional rankings from there.  Then starts the tinkering with the rankings and all.  Tiers on the left side grouped together, with columns of position with a number around their name.  Example:  Tier 1 Antonio Brown (1) Todd Gurley (2) Gronk (3) Julio Jones (4) etc etc.  Those aren't actual rankings btw, just to show how I divide the positions up.  I usually go around 300 players with roughly a max of 18 players in a tier, in hopes I get the last guy in that tier (All my leagues are 10 team leagues, so the max gap between start up picks pick #1 overall - pick #20 overall).  

Basically just comparing guys over and over again.  "Do I like Keenan Allen or Brandon Marshall more" -> "Ok Keenan Allen it is" "Now do I like Keenan Allen or Amari Cooper" -> And I'll probably think it over for a while and change my mind 10x before I say I finally finished those rankings which is halfway through the season.  Lather rinse repeat for next year.

 
Hawkeye21 said:
For my auction league I have a spreadsheet that I use each year.  I check a few different site's projections and along with my own opinions I will enter in each player's projected stats into the spreadsheet.  It has a formula that will generate the projected scores for my league's settings and generate auction values for each one.  It's pretty damn accurate.  Seems like a lot of work and I'm sure I could do just as well without it but I find it enjoyable.  Just a hobby basically.
Click to expand...
I do a version of this....  I grab projections from multiple different sites I trust and put these into a sheet I've built that averages these projections then creates auction values.  My sheet also factors in the keepers and money left in the auction pool.   

 
My auction league is quite a bit different so I have to do a lot of tweaking to my spreadsheet but it helps.  I think it gives me a little advantage because everyone is using auction values from websites that do not factor in our system.

 
Ghost Rider said:
I find it best to work off a cheat sheet of their current ADP, not my personal rankings, so value is easy to evaluate as I move along, and then I just mentally make a list of what players I like and don't like. 
Click to expand...
This is what I do, too. I take a copy/paste from any current ADP into Excel. I then go down the list and highlight the guys I like. I use the sheet as a guide for when I need to take the guys I like, or to look ahead and see how many players at my upcoming picks I'll have to choose from at each position. That's about all I do with cheat sheets.

 
InDesign from Adobe Suite for page layout. Hard copy printed. :coffee:

Then just start ranking from the top at each position. Including IDPs. I use depth charts, not rankings. I have a solid idea already set by time I create em.

 
I use the VBD Excel cheatsheet because I like the format (one page) and the fact that you can plug in your league's scoring system. Just use a pen to cross off names.

I don't create my own cheatsheet. I use that as a guide. What usually happens is that pockets of value present themselves because other drafters have different takes on things. If I'm a believer of a player in that pocket...that's the way I go.

I'm relatively successful with this approach.

 
Cowboysfan8 said:
Yeah, you lost me at "export an excel" :lol:

I was afraid it may involve real computer skills..I don't have any
Click to expand...
How hard is it to type?   :P

Seriously, make your cheatsheet by typing it up.  If something happens or you want to re-order it's just cut and paste (or just retype a couple lines) then print out the update.  Don't need any skills to do that.

Personally I take the Footballguys VBD spreadsheet which give me a ranking based on my scoring system (again, no "computer skills" needed).  Then I copy and paste the ranking list to a blank spreadsheet.  I'll then put in rankings based on other sites then average them out and sort it, change up what I personally think and viola, my own custom cheatsheet I print out for draft day.

 
Export projections from DD app to spreadsheet.

Calculate EDP of positions from weighted 3 year average of my leagues.

Set VBD baselines from said EDP.

Highlight undervalued players, create tiers, etc

 
I just take guys I want to root for.  It's an Auction, so it's much easier to control.   There is so much luck involved that you should just try have some fun with it.  Ironically I do much better $$ with this method.

 
Last edited by a moderator:
Here's my own personal method (for whatever it's worth). 

I go to myFBG (link: http://subscribers.footballguys.com/myfbg/my.php) and set up my league scoring. (Note: I find this especially helpful with leagues that have strange scoring rules. For example, I did a draft for the Scott Fish Bowl last month that has some weird scoring rules (.25 per carry and only .5 PPR) and it's tough to know where to start without doing this.)

On myFBG, there's an option to "see projections by position" and you can choose Dodds, Henry, Bloom, etc. for whose projections you want to use. I click on that and it shoots out the projected fantasy points scored for my exact league settings. I cut and paste those into a spreadsheet. Then I make a column where I divide the fantasy points by the games played to give me PPG for each player.

Then I look at the projections to see what the "replacement level" player is at each position (i.e. if it's a 12-team, one-QB I'll look to see approximately what the 15th or so QB scores) and subtract the projected PPG from the replacement PPG at the position in one last column. This gives me easy numbers to work with. Here's what the RB/WR/TE sheet I made for the scott fish bowl looked like:

https://docs.google.com/spreadsheets/d/1swOb9Rx8Lqcm672EJozFBJPpXHhm6_BmMVJ_gmpEExk/edit#gid=0

Those numbers in the yellow column are basically what I use to rank players initially and sort by. But I can tinker by adding a couple PPGs to guys I really like, subtracting 1-2 PPG for guys I don't, etc. I've found it's a pretty good starting point for me and I can use the PPG - replacement level PPG as a simplified version of VBD that I find really helpful. 

 
Last edited by a moderator:
irishnips said:
When I go to fantasypros and click on NFL, I can't find where you found just cheatsheets? What pulldown did you click to get here? I see cheatsheet creator but that isn't the same?
Click to expand...
I don't see it either.  If you google fantasypros cheat sheet it is the first result though.

 
Just find the cheatsheet online that you like the most and then modify it. Either re-arrange the players to your liking, or just highlight the ones you value higher than their current position on the sheet.

 
eaglesfan7 said:
you're a cowboys fan but here you go:

cheatsheetking.com
Click to expand...
Thanks for this.

 This site is great (and free). Start with their rankings, drag and drop to rank players where you want them, no typing .

I had a problem printing on my end. Emailed their support and got a response in 5 mins. After a few emails he got me straightened out.

Highly recommend 

 
You must log in or register to reply here.

Similar threads

Scoresman
Knowing your league - The Single Best Piece of FF Research You Can Do
Replies
22
Views
938
Joe Bryant
Joe Bryant
F
Fantasy Football Dynasty Tracker v1.0 [Google Spreadsheet] - Visualize and Manage your Dynasty Team
Replies
0
Views
1K
FFDynastyTracker
F
Hot Sauce Guy
My Experience With NFC Rotowire Online Championship Leagues
Replies
11
Views
1K
Hot Sauce Guy
Hot Sauce Guy

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
Back
Top