For you fantasy football junkies, this spreadsheet should help with you any cheatsheets you might need with all stats and data. a bit much, but very good info. download to zip file. enjoy
cheatsheet 06 projections (http://www.wispertel.com/~flapjack/)
Wtd Avg 2006 Projections 072906 v2002.zip -- I recommend this one, as it uses some later features of Excel.
What does this spreadsheet do?
This spreadsheet helps create personalized cheatsheets for your league draft.
. It utilizes (at least) 5 different sources of player projections, the ability to add (up to) 5 more sources of projections, the ability to WEIGHT your sources as you prefer, utilizes your league scoring rules.
. The "Rank" tabs provides a cheatsheet for the position, which also provides other irrelevant data about the players (team, bye, depth chart, age, yrs in NFL, avg draft position, etc).
. The "Rank II" tabs provide a cheatsheet for the position, but also provides the players' last 3 yrs of statistics, plus the current projections for that player.
. There are tabs that accommodate the non-TE leagues, and tabs that accommodate the TE-required leagues.
. There is a "One Pager" tab that provides a one-page overview of your cheatsheet, all positions.
. There is a "Draft" tab that allows you to enter your draft as it goes along. This SHOULD "highlight" those players "off" your One-Pager tab.
. The best way of knowing what this can do, is to play with it. If you mess up your local copy of the spreadsheet, you can always download another copy.
depth charts have not been updated so use your own football knowldege
Workbook's Table of Contents
. Byes -- Contains all the teams' bye weeks. No need for further updates here.
. Consistency -- Copied from thehuddle. Contains the players' consistency rankings of reaching a certain level of play each week, in 2005. Those players highlighted in red indicate he is not on the Players' master list for 2006 (ex: Stephen Davis). No need for further updates here.
. Avg Pick -- Copied from MFL, as of 7/22/06. Indicates the players' average draft position taken. This will be updated in future updates.
. Depth Charts -- Copied from thehuddle. This is not updated to 2006 yet. This will be updated in future updates.
. Profiles -- Copied from nfl.com. Simply provides some basic information on the players (age, yrs exp, height, and weight). No need for further updates here.
. Past Stats -- Copied from thehuddle. Contains past statistics for each player, for the past 3 years. No need for further updates here.
. Scoring -- Enter your scoring rules here. If your league uses additional scoring than what is indicated on this tab, this can be accommodated by utilizing the "Annual Points Adjustment" in the "Rank" tabs.
. QB, RB, WR, TE, PK, DEF (POS) -- Contains the master list of players for 2006 and the assorted projections by the different sources. Feel free to add your own projections, other premium sources you have access to, as well as your WEIGHTS to each source (ex: Huddle=5, Footballguys=.01).
. Rank -- The individual cheatsheets for each position. Utilizes your scoring rules, projections from the POS tabs, and your entered weights. Contains almost every sort button you can imagine.
. Rank II -- It works, but I want to update the formatting here. Input is welcome. Contains the same sort order as your Rank page, but contains the last 3 yrs of statistics for each player.
. One Pager -- One page cheatsheet, sorted in the same manner as your Rank pages. This is for TE-required leagues.
. One Pager, No TE's -- One page cheatsheet for non-TE-required leagues. Sorted in the same manner as your Rank pages.
. Draft / Draft, No TE's -- Tabs to enter your draft as it goes along. It SHOULD "mark off" the player from the appropriate One Pager tab. Names must be entered as they are in the master lists (QB, RB, WR, TE, PK, and DEF) tabs.
rjs is angry at you for posting this.
i better delete it then and lock all my doors
First, load up all your alcohol and dump it outside a 5-mile radius of your house. Then, yes.
You should be banned for posting that. People should have to put their own work in. Not steal that shtein from other losers. Ban.
At least he waited until after the NFC and Keeper league drafts, because there were certainly some heroes during those that could have used a spreadsheet tool like this one to make more intelligent decisions.
You aren't kidding about that. Yikes.
put your whistle away Mahoney. im not taking credit for it, im simply passing it along to print out and use for a quick reference at your draft.
Exactly. Ban.
when your huffing gasoline with your boys this weekend do me a favor...dont stop.
thanks in advance
love
your idol
That didn't make any sense. A weak entry. Zero points.
Player evaluation
Anyone have anythoughts on the value of L. Maroney - 1st round RB of the Patriots????
My draft completed and I'm a little thin in the third week with RB's on byes and he's available.
Laurence Maroney has basically zero likely value in week 3.
Maroney? please join my league--we accept all donations
http://www.wispertel.com/~flapjack/
unzip the 2nd one--97 version.
Updates:
a. Projections updated for huddle, fftoday, fantasysharks, and Fox Sports.
b. Projections added for Rototimes
c. Depth Chart included.
d. Avg Pick stats updated from MFL.
e. Cleaner formatting in some areas.[/url]
the only cheatsheet you need (http://sports.espn.go.com/espn/page2/story?page=gallo/060814&lpos=spotlight&lid=tab2pos2)
Quote7. Michael Vick, ATL -- You want to stock up on running backs early. And Michael Vick could be a great running back.
Ah, so
that's what you were thinking, FF.
Yeah, and I got him with the 85th pick. VALUE!
Quote9. Jon Kitna, QB, DET -- Sure, Kitna is not an accurate passer. But Detroit's receivers run very imprecise routes. The combination could results in tons of coincidental completions.
Quote from: phattymatty on August 16, 2006, 05:15:37 PM
Quote9. Jon Kitna, QB, DET -- Sure, Kitna is not an accurate passer. But Detroit's receivers run very imprecise routes. The combination could results in tons of coincidental completions.
It didn't work for McNabb his first few years.
Nice segue:
Quote5. Donovan McNabb, QB, PHI -- On the Eagles he has absolutely no one to throw to. But on your fantasy team there will be a bevy of talented receivers. That's called beating the system, ladies and gentlemen. (I can't believe I'm giving away these kinds of tips for free.)
Quote from: Sgt PSN on August 16, 2006, 05:42:36 PM
Quote from: phattymatty on August 16, 2006, 05:15:37 PM
Quote9. Jon Kitna, QB, DET -- Sure, Kitna is not an accurate passer. But Detroit's receivers run very imprecise routes. The combination could results in tons of coincidental completions.
It didn't work for McNabb his first few years.
Probably because the Eagle WRs' imprecise route running never involved burrowing 4 feet into the ground.
Quote from: QB Eagles on August 16, 2006, 06:17:43 PM
Quote from: Sgt PSN on August 16, 2006, 05:42:36 PM
Quote from: phattymatty on August 16, 2006, 05:15:37 PM
Quote9. Jon Kitna, QB, DET -- Sure, Kitna is not an accurate passer. But Detroit's receivers run very imprecise routes. The combination could results in tons of coincidental completions.
It didn't work for McNabb his first few years.
Probably because the Eagle WRs' imprecise route running never involved burrowing 4 feet into the ground.
That explains the worm burners. ;)
i got a password for footballguys.com if anyone wants to use it shoot me a pm
if anyone wants a great draft tracker to use, here you go. you might have to copy and paste. This recognizes over 700+ mock draft up-to-date from all the major websites. you can go up to 500 ranked players (obviously not necesary)-very easy to print and cross off as you go
Enjoy
http://football.myfantasyleague.com/2006/draft_analysis
according to that thing, Larry Johnson was picked 72nd overall in atleast 1 draft. Why even track something that ridiculous.
I didnt go as deep and take every number on here set in stone. but according to alot of major fantasy sites mock drafts, this puppy has been right on par.
Plus, your going to bump guys up and down regardless, because if you dont, and go right off any sheet--your no good anyway
My sheets are way better than anything you've posted.
Quote from: reese125 on August 22, 2006, 04:42:12 PM
I didnt go as deep and take every number on here set in stone. but according to alot of major fantasy sites mock drafts, this puppy has been right on par.
Plus, your going to bump guys up and down regardless, because if you dont, and go right off any sheet--your no good anyway
and somehow..you post links to more of these than anyone should have the time to read if there was any kind of non inflatable or battery opperated signifigant other in their lives.
christ, its a sheet of ranked players...and dont tell me you dont use them cool guy Wingspan over there--if you even play fantasy football.
I could care less if you read them, print it out, wipe your ass with it or blow snot on it...and I highly doubt you even got a grin from that god awful lame attempt at humor Carlin
Quote from: FFatPatt on August 22, 2006, 04:52:39 PM
My sheets are way better than anything you've posted.
have I told you yet that your my hero, or do you need a personal IM
When you pay me the $10 on our little wager, it will be implied. But thanks for the offer.
My computer won't let me open it, apparently I don't have excel.
are you using a Commodore 64? how the hell dont you have excel--copy and paste the link
It's a dell laptop, I only tried the link recommended maybe I can use the other ones.
I get a message when I try to open the file that says my computer needs to know what program created it.
Quote from: reese125 on August 22, 2006, 09:34:02 PM
are you using a Commodore 64? how the hell dont you have excel--copy and paste the link
If he didn't pay for Microsoft Office, he probably doesn't have Excel.
dells are standard with outlook and excel...am I wrong mcgraw?
If it is, I cant find it and neither can my computer.
I have Microsoft Encarta and Microsoft Money on my computer, that's it.
well I stand corrected guy, you wont be able to get it then if you cant find it in your programs tab..