Power Rankings spreadsheet (Rough Draft)

Discussion in 'Quality Simulation Football' started by thafuture3886, Feb 24, 2014.

  1. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Trying something new for the Power Rankings...

    Notes
    -Don't pay attention to the last column, i'm still tweaking to find the correct formula to use
    -I know it's a lot of numbers but i wanted to get as much down as i could on the first run. I may condense it going forward
    -Any feedback would be great
    -Only a rough draft and will add more such as divisional and conference breakdowns in the future

    LET ME KNOW WHAT YOU THINK!!!

     
    • Like Like x 2
  2. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
  3. Glen Cieske

    Glen Cieske Walk On

    Joined:
    Jul 2, 2012
    Messages:
    1,285
    great idea.

    What about using Total Offense and Total Defense in the equation?
     
    • Like Like x 1
  4. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Does daddy leagues have that information? That's where I pulled all the info from because I can access DL at work lol
     
  5. KingPatron

    KingPatron Walk On

    Joined:
    Jan 2, 2014
    Messages:
    158
    can you make it show the top dawg first that might make it easier to read and know who is the best & worst
     
    • Like Like x 1
  6. CHUNKNESS

    CHUNKNESS Commissioner Quality Simulation Football

    Joined:
    Jun 13, 2010
    Messages:
    10,270
    OFFENSE

    DEFENSE
     
    • Like Like x 1
  7. LtJustice

    LtJustice QSF Commissioner

    Joined:
    Jul 22, 2010
    Messages:
    3,373
    This is all you need to know...

    1. Indianapolis Colts (thafuture3886)
    2-32. Everyone Else!

    ;)
     
    • Like Like x 3
  8. KingPatron

    KingPatron Walk On

    Joined:
    Jan 2, 2014
    Messages:
    158
  9. LtJustice

    LtJustice QSF Commissioner

    Joined:
    Jul 22, 2010
    Messages:
    3,373
    Curtis is doing something more sophisticated! :D
     
    • Like Like x 2
  10. ThaBayouChef

    ThaBayouChef Walk On

    Joined:
    Jul 19, 2012
    Messages:
    2,376
    DL's power rankings are wack....This is good stuff man! I agree w/ whoever said put the teams in numerical order of where they rank.
     
    • Like Like x 1
  11. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    You should be able to sort/filter from the spreadsheet. I did it alphabetical so people can sort it however they want but I will do this next time (y)
     
  12. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Indianapolis Colts 6-5 = out of the playoffs :D
    Seattle Seahawks 9-2 = Tied for first in NFC ;)


    Told you guys i'm terrible lol
     
  13. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Yeah these rankings I'm not too fond of. Plus Coach KO kind of inspired me when he said the NFC East had the hardest schedules :rolleyes:
     
    • Like Like x 1
  14. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    (y)(y)(y)
     
  15. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Some observations..

    Toughest Schedules(based on opponent w/l)
    Steelers .669 0-11
    Sentinels .636 4-7
    Lions .595 3-8
    Broncos .592 4-7
    Bucs .590 4-7

    Easiest Schedules(based on opponent w/l)
    Seahawks .331 9-2
    Panthers .374 10-1
    Chiefs .381 7-4
    Browns .381 9-2
    Packers .400 5-6

    AFC vs NFC 25-14 - .641%
    NFC vs AFC 14-25 - .359%

    AFC FTW!!!! :p
     
    Last edited: Feb 25, 2014
    • Like Like x 2
  16. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Wins Losses Total Games %
    NFC vs AFC 14 25 39 0.359%
    AFC vs NFC 25 14 39 0.641%

    Division Wins Losses Total Games % SOS
    AFC East 31 13 44 0.705% 0.5262%
    AFC South 24 20 44 0.545% 0.5248%
    AFC North 21 23 44 0.477% 0.4863%
    AFC West 18 26 44 0.409% 0.4863%
    NFC East 27 17 44 0.614% 0.5260%
    NFC South 24 20 44 0.545% 0.5111%
    NFC North 16 28 44 0.364% 0.4956%
    NFC West 15 29 44 0.341% 0.4394%

    *this is all in the spreadsheet, i just can't get on googledocs from work to update and share. I'll do that when i get home later*
     
    • Like Like x 1
  17. ThaBayouChef

    ThaBayouChef Walk On

    Joined:
    Jul 19, 2012
    Messages:
    2,376
    AFC East 31 13 44 0.705% 0.5262%

    BAM!!
     
  18. cry_havoc

    cry_havoc Walk On

    Joined:
    Jul 27, 2012
    Messages:
    1,255
    he wasnt kidding
     
    • Like Like x 1
  19. Michael Overman

    Michael Overman Walk On

    Joined:
    Jul 31, 2012
    Messages:
    2,210
    AFC EAST

    [​IMG]

    NFC WEST

    [​IMG]
     
    • Like Like x 4
  20. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Numbers were skewed by Redskins with 7th hardest schedule. Eagles, Cowboys and Giants had 13th, 18th and 20th respectively
     
    • Like Like x 1
  21. LtJustice

    LtJustice QSF Commissioner

    Joined:
    Jul 22, 2010
    Messages:
    3,373
    The Seahawks have only played 2 teams with winning records thus far this season, and lost both games:
    • Giants (9-2) - Lost 32-28 in week 4
    • Eagles (7-4) - Lost 30-24 in week 7

    The NFC West Champions have quite the schedule to close out the season, which should either gear this team up for the playoffs, or send them limping into the postseason:
    • Week 15: Cowboys (9-2)
    • Week 16: Chiefs (7-4)
    • Week 17: Vikings (8-4)

    Did I mention that all three of these games are on the road?? Sheesh, maybe I'll just rest some starters and embrace playing on Wild Card Weekend. :nailbiting:
     
    • Like Like x 1
  22. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Didn't forget about this, still tweaking it to have it ready for next season...
     
    • Like Like x 3
  23. thafuture3886

    thafuture3886 Power Rankings Analyst

    Joined:
    Jul 23, 2010
    Messages:
    2,609
    Here's the updated excel spreadsheet..

    I'll post to google and upload later if i remember

    *EDIT* Filter is all out of whack so if you filter any column it will most likely change the numbers. I'll fix it when i get time
     

    Attached Files:

    Last edited: Mar 13, 2014
    • Like Like x 1

Share This Page