1. If you haven't seen already, TSO is now powered by Discord! This means that we will eventually be disbanding the embedded chat on the main forum page. Head to this page to learn more on how to integrate your TSO account with discord! https://traditionsportsonline.com/wiki/discord-integration/

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,272
    OFFENSE

    DEFENSE
     
    • Like Like x 1
  7. LtJustice

    LtJustice QSF Commissioner

    Joined:
    Jul 22, 2010
    Messages:
    3,374
    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,374
    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,374
    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