ATTN: For those of you with different scoring systems - Fantasy Football Cafe 2014 Fantasy Football Cafe


Return to Football Talk

ATTN: For those of you with different scoring systems

Moderator: Football Moderators

ATTN: For those of you with different scoring systems

Postby KingGhidra » Wed Aug 11, 2004 11:03 pm

If you use excel, I made a spreadsheet for you guys. You can input your league's scoring system and it automatically updates their fantasy scoring using last year's stats. This isn't for projections, but by looking back at how a different scoring system affects last year's stats, you can get a better idea of the value of players/positions in your league.

Quick tutorial

Image

Change the modifiers in the colored cells. EG, if your scoring system is 50 passing yards = 1 pt, change cell H3 to 50. If you get -3 for INTs, change J3 to 3. The scoring in the FP column will update automatically.

Once you have your scoring system set up, click a cell in the RK (rank) column designated by the black circle, then click on the sort button (the A over the Z with the down arrow), designated by the other black circle, and it will automatically sort the players from first to last.

I don't have data for fumbles for last year, but I wouldn't worry since it doesn't affect things too much. You can make those adjustments on your own seperately if you desire. I also don't have game by game points allowed data for team defense. That actually does affect things quite a bit. You'd have to make some adjustments on your own.

Lastly, don't change any of the data in the player data cells.

Enjoy.

http://kingghidorah.is-a-geek.net/Fanta ... system.xls
KingGhidra
General Manager
General Manager

Cafe RankerMock(ing) Drafter
Posts: 4303
Joined: 3 Sep 2003
Home Cafe: Football

Postby jumpman8828 » Wed Aug 11, 2004 11:12 pm

Awesome KG, thanks ;-D
Good job putting-together all this data :-D



PS- kingghidora.is-a-geek.net? Why doesn't this surprise me? :-b
Image
jumpman8828
Head Coach
Head Coach

User avatar

Posts: 1690
Joined: 7 Aug 2003
Home Cafe: Football

Postby Vanter » Wed Aug 11, 2004 11:14 pm

I like it! Thanks for sharing the knowledge. ;-D
Vanter
Head Coach
Head Coach

User avatar
Cafe RankerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 1089
Joined: 1 Oct 2003
Home Cafe: Football

Postby atvjerryrice80 » Wed Aug 11, 2004 11:17 pm

thanks very helpful
Image
atvjerryrice80
Head Coach
Head Coach

User avatar

Posts: 1279
Joined: 23 Oct 2003
Home Cafe: Football
Location: Helping the 49ers look for replacements

Postby GreenBay4Life » Wed Aug 11, 2004 11:25 pm

That is awesome great job. much help
Image

2004: 2 League's 2 Championships
2005: 2 League's 2nd place and 6th place
2006: 1 league 2nd place
GreenBay4Life
Defensive Assistant
Defensive Assistant

User avatar
Mock(ing) Drafter
Posts: 530
Joined: 11 Jun 2003
Home Cafe: Football
Location: Brett Favre's Farm

Postby madshot31 » Thu Aug 12, 2004 12:11 am

Thanks man, this is great stuff. It really helps me with my draft tommorow that has some unusal scoring. Thanks again!
Have Fun, Live Life, Stay Safe. ^_^
madshot31 Beginner
Water Boy
Water Boy

User avatar

Posts: 60
Joined: 22 Jul 2004
Home Cafe: Football

Postby MadScott » Thu Aug 12, 2004 12:17 am

Muchos gracias KG! ;-D
Image
I like simple pleasures, like butter in my ass, lollipops in my mouth. That's just me.
MadScott
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe WriterCafe RankerSweet 16 SurvivorCafe Blackjack Weekly WinnerLucky Ladders Weekly Winner
Posts: 5924
Joined: 27 Sep 2003
Home Cafe: Football

Postby enderwiggin » Thu Aug 12, 2004 12:18 am

Thats pretty cool! Another way to do it is to create a Yahoo league with your scoring system and then look at how the players come out. Either way works though. Good job! ;-D
Image
aka Bloody Nipples for baseball
enderwiggin
Special Teams Staff
Special Teams Staff

User avatar

Posts: 233
Joined: 20 Oct 2003
Home Cafe: Football
Location: the above isnt from a challenge; i'm just embarrassed.

Postby Franchise Fan » Thu Aug 12, 2004 10:42 am

NICE Job, I am good with excel and can see this took some work. Great idea!
Image
Franchise Fan
Defensive Assistant
Defensive Assistant

User avatar
CafeholicGraphics ExpertPick 3 Weekly WinnerCafe Blackjack Weekly Winner
Posts: 569
Joined: 28 Jul 2003
Home Cafe: Football
Location: "south" jersey

Postby aussieboy » Thu Aug 12, 2004 10:16 pm

BUMP
aussieboy
Head Coach
Head Coach

User avatar

Posts: 1398
Joined: 16 Mar 2004
Home Cafe: Football
Location: Lonely island

Next

Return to Football Talk

Who is online

Users browsing this forum: No registered users and 4 guests

Forums Articles & Tips Start & Sit Sleepers Rankings Leagues


Get Ready...
The 2014 NFL season kicks off in 17:49 hours
(and 36 days)
2014 NFL Schedule


  • Fantasy Football
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact