Fantasy Football Spreadsheet

A few days ago I was looking online for a point calculator for fantasy football (too cheap to spend the $10 on StatTracker). Something where I can enter the players stats and calculate the total points. Unable to find one, I made it myself, in excel. I figure it might be useful to someone who happens to come across this post, so here's the link to it.

It uses the default yahoo league configurations, so if your league is different you'll have to go and change some of the numbers in the formulas, or positions, or whatever. Otherwise you put the stats in the left hand column, and the points will appear on the right. I made it so there are no partial points, and so it rounds down. For example, if your QB has 249 passing yards, you will get exactly 9 points, not 10, not 9.9.

The only points it does not calculate is points allowed for team defenses. You will have to manually enter it on the right hand column yourself. I have provided the guide for yahoo leagues.

So there you have it. If you didn't buy StatTracker and you don't want to wait for Monday morning to see where you stand, just use this sheet. Feel free to play around with the design as well and if you come up with something better, lemme know.

Comments

Mikel Burlingame said…
I'm interested in your spreadsheet but it has expired
August 19, 2008 at 3:44 PM
Anonymous said…
Good post.
November 10, 2008 at 11:36 AM
Anonymous said…
Hello !.
might , probably curious to know how one can collect a huge starting capital .
There is no need to invest much at first. You may begin to receive yields with as small sum of money as 20-100 dollars.

AimTrust is what you need
The firm incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

It is based in Panama with structures around the world.
Do you want to become a happy investor?
That`s your choice That`s what you desire!

I feel good, I started to take up real money with the help of this company,
and I invite you to do the same. If it gets down to choose a correct companion who uses your money in a right way - that`s it!.
I earn US$2,000 per day, and my first investment was 500 dollars only!
It`s easy to join , just click this link http://zofovopeb.lookseekpages.com/elonoga.html
and lucky you`re! Let`s take our chance together to become rich
December 16, 2009 at 2:57 PM
Anonymous said…
Good day, sun shines!
There have were times of hardship when I didn't know about opportunities of getting high yields on investments. I was a dump and downright stupid person.
I have never thought that there weren't any need in big starting capital.
Now, I feel good, I started to get real money.
It gets down to choose a correct companion who uses your money in a right way - that is incorporate it in real business, parts and divides the income with me.

You may ask, if there are such firms? I'm obliged to tell the truth, YES, there are. Please get to know about one of them:
http://theinvestblog.com [url=http://theinvestblog.com]Online Investment Blog[/url]
January 28, 2010 at 4:37 PM
Anonymous said…
Hey! Nice idea, but will this really work?
January 31, 2010 at 9:49 PM
Anonymous said…
Naked pic [url=http://community.vitamix.com/service/linkOut.kickAction?as=22442&url=http%3A%2F%2Fwww.platinum-celebs.com%2Factresses%2Fheather-graham%2F&h=8dcbb4371424939b3d145da7dbd54c] naked pictures[/url] Nude celeb
October 22, 2010 at 5:24 AM
Post a Comment

Popular posts from this blog

Righting the Ship

Image
Had another bad session yesterday. Actually I didn't play badly at all, I just took two horrible beats. I was taking a shot at NL $50 too. Lost to JJ twice. One hand I had 55 in a raised pot, I called from the BB, and flopped a set (9-6-5 flop I believe). Anyway, get it in with a half stack, he has JJ, river J. Great. Another hand I have KK and resolve to play a big pot with it. I raise to $3, SB calls. Flop comes 9 high, he checks, I bet pot, he calls. Turn is a blank, same action. River is a jack, he shoves for the remaining PSB, I call. He has JJ, sigh. Really wish I didn't keep getting two outed. So tonight I decide to take a shot at $100 NL (6-max of course) after the Red Sox beat the Rockies 2-1 due to great pitching to take a 2-0 lead in the series. I sit in with $100, leaving me a measly $5.12 if I lose it. But I resolved to try and get up $45 and then leave. If I go broke I take a break or redeposit or whatever. Sick and tired of grinding it out at NL $25 just to get t
Read more

LOL Redproaments

Image
Alright so I haven't updated in a while, also haven't been playing either. Recently Full Tilt offered me a $50 bonus without having to make a deposit so I've been playing a little bit. Probably only going to clear $10 of the bonus, really just can't get into playing much anymore with work and other stuff like bowling, which I've really gotten into over the past 4 months occupying my time. Anyway, tonight I sat down at a $100 PLO8 table. Morris Chestnut was at the table and I wa able to jump in and be top on the waiting list because it's PLO8. After about 10 minutes I got in. It was a pretty boring game, not much action, most of the table was playing tight. I thought there would be more action with a red pro being at the table and was hoping to see some hold'em donks occupying some seats at this table. I was up a few dollars when this hand took place. Full Tilt Poker $0.50/$1 Pot Limit Omaha Hi/Lo - 8 players The Official 2+2 Hand Converter Powered By Deuce
Read more

Foxwoods

Image
Took the afternoon off Friday and headed to Foxwoods. Got to the poker room at around 2 and I was looking to play 4/8 Omaha8. However, the list was about 8 people long, and the person at the desk said that there was an interest list going for 1/2 Pot-Limit O8. It was open seating at that point, so I joined in and soon we had a full table of 10 people and the game got going. Early on I made a pretty bad blunder with a strong hand. I had A Q 4 2 on the button and called a $6 raise. One of the blinds also called and the flop came with 2 clubs and 2 low cards, giving me a Q-high flush draw and the nut low draw. I called a $12 bet from the preflop raiser, the other player folded and we were heads up. The turn was the 5 , completing both of my draws. The PFR checked and I checked behind (I know, terrible). The river was th e , 5 putting a possible full house on board. He checked again and I not only check behind but I turn my hand face up instead of letting my opponent reveal his cards. My
Read more