Welcome to PatsFans.com

Graphing Greatness

Discussion in 'PatsFans.com - Patriots Fan Forum' started by solman, Dec 13, 2007.

Thread Status:
Not open for further replies.
  1. solman

    solman Rotational Player and Threatening Starter's Job

    Joined:
    Jan 12, 2007
    Messages:
    1,069
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    Attached is a little spreadsheet I use to:

    A. Chart the Patriots progress towards becoming the greatest team of all time

    and

    B. Avoid doing work

    It includes the schedules of my top three teams of all time (1985 Bears, 1962 Packers, 1989 49ers), the 1972 Dolphins and the 2004 and 2007 Patriots.

    Since a great team isn't really tested by mediocre or poor opponents, I'm focused on important games, which I define as:

    1. Games played against opponents that finish the regular season more than two games over .500.

    2. Games which were not won. (Only the 2004 Patriots loss to the Dolphins is added by virtue of this second criteria).

    Folks are welcome to do with this as they wish. I'd appreciate getting a copy of any new features and/or data.
     

    Attached Files:

  2. PromisedLand

    PromisedLand Virtual Internet Person

    Joined:
    Sep 13, 2004
    Messages:
    3,372
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    Even though I'm trying my best not to do work myself, can you please save us the time of figuring out what all the little scattered points of light mean and just tell us your conclusions? Thanks - it look like you put a lot of work into it!
     
  3. solman

    solman Rotational Player and Threatening Starter's Job

    Joined:
    Jan 12, 2007
    Messages:
    1,069
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    Conclusions are for the end of the season.

    If the Pats finish what they started, we'll be able to conclude (with very little resistance) that they are the greatest team in the history of the NFL.

    Specifically, that they beat tougher opponents by larger margins with greater consistency.

    For now, the spreadsheet is just for folks who like playing with and looking at numbers.

    I actually find myself rooting for the Colts, Cowboys and Chargers just because I want our season to be impressive as possible. To be the best, you've got to beat the best.

    After the season (provided we win the Superbowl), I'll try to make the numerical case as simply and persuasively as possible.
     
    Last edited: Dec 13, 2007
  4. solman

    solman Rotational Player and Threatening Starter's Job

    Joined:
    Jan 12, 2007
    Messages:
    1,069
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    In the tab labeled "Important Games" you can see how we stack up thus far in comparison to the other great teams.

    Potentially playing two games each against 15-1 and 14-2 opponents will make our season look mighty good in an historical context.
     
  5. PromisedLand

    PromisedLand Virtual Internet Person

    Joined:
    Sep 13, 2004
    Messages:
    3,372
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    OK, thanks.
     
  6. Flying Fungi

    Flying Fungi In the Starting Line-Up

    Joined:
    Sep 13, 2004
    Messages:
    2,416
    Likes Received:
    2
    Ratings:
    +2 / 0 / -0

    very nice--this gives me a little better appreciation for those '62 cheesers
     
  7. psychoPat

    psychoPat Role Player PatsFans.com Supporter

    Joined:
    Oct 12, 2006
    Messages:
    1,776
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    Understand that you put this together for your own entertainment.
    But thanks for sharing it !
    I look forward to your graphical display of an immaculate season.

    Can't help but notice that the highlight of the '72 Dolphins' regular season was
    smashing the Patriots, 52-0.
    Perhaps that will be the outcome next week as well ... mirror image, of course!

    Small point: The content of your sheet 2007Patriots
    does not match up with the other great teams' sheets.
    That is, your scatter diagram is mislabeled.
     
  8. fourthandmiles

    fourthandmiles On the Game Day Roster

    Joined:
    Aug 8, 2007
    Messages:
    469
    Likes Received:
    0
    Ratings:
    +0 / 0 / -0

    Way cool. It is fun looking at a point and trying to guess which game it is. I could waste hour at work looking at this.
     
  9. BelichickFan

    BelichickFan B.O. = Fugazi PatsFans.com Supporter

    Joined:
    Sep 13, 2004
    Messages:
    31,753
    Likes Received:
    245
    Ratings:
    +603 / 17 / -16

    #24 Jersey

    Good stuff. It makes the 2007 Patriots look good, obviously, but the 2004 Patriots look really good on this graph too.
     
  10. solman

    solman Rotational Player and Threatening Starter's Job

    Joined:
    Jan 12, 2007
    Messages:
    1,069
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    2004 Patriots are amazing for a few reasons:

    1. They had an historically difficult schedule in both the regular season and the playoffs.
    2. They suffered through numerous injuries.
    3. They repeated the success of the 2003 Patriots who did the same.

    Going into this season I thought that the 2007 Patriots uninjured were better than the 2004 Patriots uninjured.

    I am no longer sure of this. The 2004 defense was just that much better.

    Its too bad that we lost the game against Pittsburgh in 2004. I think that if we had Dillon and Law for most of that game, we could have won it, and gone 19-0 that year.

    In week 2 of the 2005 season, Carolina would have ended our win streak at 35 games.
     
    Last edited: Dec 14, 2007
  11. Lloyd_Christmas

    Lloyd_Christmas I can delete my own crap! PatsFans.com Supporter

    Joined:
    Sep 15, 2004
    Messages:
    1,420
    Likes Received:
    5
    Ratings:
    +5 / 0 / -0

    Good work! Does someone inadvertantly pay you to do this :D
     
  12. solman

    solman Rotational Player and Threatening Starter's Job

    Joined:
    Jan 12, 2007
    Messages:
    1,069
    Likes Received:
    1
    Ratings:
    +1 / 0 / -0

    I get paid a lot of money NOT to do this.

    Its a puzzle to me why I spend so much time thinking about the Pats.
     
Thread Status:
Not open for further replies.

Share This Page

unset ($sidebar_block_show); ?>