Welcome to PatsFans.com

*NEW* PatsFans.com 2011 Offensive Stats Database - [BETA]

Discussion in 'PatsFans.com - Patriots Fan Forum' started by Ian, Sep 19, 2011.

  1. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    I just got done putting together a database that breaks down the offense by down, quarter, half, direction, etc. and it seems to be working properly so I'm going to open it up for testing. I'm still in the working phase on this, and will be tweaking it a bit. However, hopefully you guys find it interesting:

    Full 2011 Stats:
    2011 Patriots Stats

    Week 1: New England at Miami:
    2011 Patriots Stats

    Week 2: New England vs. San Diego:
    2011 Patriots Stats

    I've tested it against the books and went back through to cross reference everything and everything checked out. I'm also adding the number of times in the no-huddle, shotgun, etc., so you'll see that included later tonight. Once I'm done I'll add permanent links on the site and up above in the header, but feel free to test it out and let me know what you think :cool:

    Ian
     
  2. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Just tweaked one thing in the week one file that prevented it from sorting properly, and changed the text in the week 2 file to reflect the correct game. Just checked both and they're functioning properly.
     
  3. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Taking another look - did anyone else notice they're almost perfectly balanced in each zone throwing the football?

    Through two games:

    Left - 30 attempts
    Middle - 29 attempts
    Right - 29 attempts

    Total: 88 attempts
     
  4. thenepatsrule

    thenepatsrule In the Starting Line-Up

    Joined:
    Sep 14, 2007
    Messages:
    3,655
    Likes Received:
    86
    Ratings:
    +271 / 1 / -1

    #12 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Just pray that rex ryan does not get hold of this :D

    all kidding aside,congrats on a job well done,i was on a lookout for something like this.By the way do you know if we can get stuff like this in an excel document somewhere?
     
    Last edited: Sep 19, 2011
  5. strngplyr

    strngplyr In the Starting Line-Up

    Joined:
    Sep 18, 2010
    Messages:
    3,570
    Likes Received:
    143
    Ratings:
    +409 / 12 / -0

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Maybe it's just me, but no information about what stats we're viewing is showing up. I just see the stats themselves. Otherwise, nice work, good stuff breaking it down like you did.
     
  6. thenepatsrule

    thenepatsrule In the Starting Line-Up

    Joined:
    Sep 14, 2007
    Messages:
    3,655
    Likes Received:
    86
    Ratings:
    +271 / 1 / -1

    #12 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    I think the font for the column names is white in color ,when u highlight the whole thing with your mouse it reads

    Total Brady Passing Stats:
    Player Attempts Completions Yards TD INT
    Tom Brady 48 32 517 4 1


    Total Receiving Stats:
    Player Targets Rec Yards TD
    Wes Welker 12 8 160 2
    Aaron Hernandez 10 7 103 1
    Deion Branch 9 7 93 0
    Rob Gronkowski 7 6 86 1
    Matthew Slater 2 1 46 0
    Chad Ochocinco 3 1 14 0
    Julian Edelman 2 1 9 0
    Danny Woodhead 1 1 6 0
    BenJarvus Green-Ellis 1 0 0 0
    Dane Fletcher 1 0 0 0
    Totals: 48 32 517 4


    Total Rushing Stats:
    Player Carries Yards TD
    Danny Woodhead 14 69 0
    BenJarvus Green-Ellis 7 34 1
    Tom Brady 1 3 0
    Totals: 22 106 1


    Total Receiving Stats on Attempts to the Left:
    Player Targets Rec Yards TD
    Wes Welker 6 6 148 2
    Deion Branch 6 5 80 0
    Chad Ochocinco 2 1 14 0
    Julian Edelman 2 1 9 0
    Rob Gronkowski 1 0 0 0
    Matthew Slater 1 0 0 0
    Totals: 18 13 251 2



    Maybe someone should ask Ian to change the font color.
    hope this helps
     
    Last edited: Sep 19, 2011
  7. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Let me know a little more about what you mean? Right now it's broken down into passing, rushing, and then by passing to the left, middle, and right side of the field. As you select a field in the drop down to sort by (down, quarter, first half, etc.) Each field changes based on that selection. I'm also adding in the different directions for the runningbacks, along with how many times Brady's in the shotgun, no-huddle, etc. The data's already in the system, I just have to add it to the pages.

    You'll also be able to click on individual players and view their performances, although that's still a little ways away. But it should be great when it's done, and it will be available within an hour or two when the games end each week.

    I'm also going to go back and do a couple past seasons so that they're there to compare against, so you'll see those also at some point.
     
  8. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Actually I see it now. I tested it in Chrome and FireFox and there wasn't anything that should have tripped IE but it's not showing the background gradients. I'm fixing it now.
     
  9. Sciz

    Sciz PatsFans.com Supporter PatsFans.com Supporter

    Joined:
    Jul 13, 2009
    Messages:
    7,378
    Likes Received:
    155
    Ratings:
    +440 / 1 / -0

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    I believe the correct thing to do is to redirect to the Chrome download page if they are using IE :lol2:

    (Stats look awesome!)
     
  10. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    There, seems to be rendering now in IE. Let me know if it's working for everyone.
     
  11. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Also - it will be set up to view these same stats by Home or Away, and by past team's match-ups (for example: if you wanted to look at how they've played against Buffalo both on the road, and at Gillette collectively, etc.).

    All the data is already all in there - just have to finish putting it together :cool:
     
    Last edited: Sep 19, 2011
  12. IcyPatriot

    IcyPatriot ------------- PatsFans.com Supporter

    Joined:
    Sep 13, 2004
    Messages:
    39,330
    Likes Received:
    710
    Ratings:
    +1,814 / 35 / -29

    #87 Jersey

    now the people who talk out of their butts are really going to be challenged they may end up on mute now.:p

    good play Ian ;););)
     
    Last edited: Sep 19, 2011
  13. strngplyr

    strngplyr In the Starting Line-Up

    Joined:
    Sep 18, 2010
    Messages:
    3,570
    Likes Received:
    143
    Ratings:
    +409 / 12 / -0

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Good now! It was simple enough to figure out earlier, but yeah, what I meant was just empty columns where it should say "Attempt, TD, INT, etc.", working perfect now, good stuff.
     
  14. BradyFTW!

    BradyFTW! PatsFans.com Supporter PatsFans.com Supporter

    Joined:
    Oct 20, 2007
    Messages:
    17,875
    Likes Received:
    422
    Ratings:
    +1,363 / 20 / -4

    #12 Jersey

    Re: PatsFans.com 2011 Offensive Stats Database - BETA

    Very cool, Ian... I'm liking this quite a bit!
     
  15. Joker

    Joker PatsFans.com Supporter PatsFans.com Supporter

    Joined:
    Oct 10, 2004
    Messages:
    18,067
    Likes Received:
    1,040
    Ratings:
    +3,147 / 23 / -31

    if there is anyone better than Ian Logue when it comes to giving Pats fans what they need, I'd like to meet him...thanks for all your hard work over the years...if anybody told me way back when that Patsfans would be what it is today I would have called him a nutcase. Consistency and dedication...the Ian Logue hallmark.
     
  16. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Meh - that's a bit of a stretch, although I appreciate the kind words. I'm always trying to bring some new things to make everyone's lives a little easier, and there's still some other things in the works that will be coming to try and make this place a little better. But there's always plenty of room for improvement, and I'm always trying to make this site a fun and informative place to visit. There's still a long way to go, but I appreciate everyone's support.

    Still making some stupid mistakes with some other things here and there with the blog, but hopefully as we get deeper into the season I'll get a little better there as well. :bricks:
     
    Last edited: Sep 20, 2011
  17. ctpatsfan77

    ctpatsfan77 PatsFans.com Supporter PatsFans.com Supporter

    Joined:
    Jan 22, 2005
    Messages:
    21,449
    Likes Received:
    482
    Ratings:
    +1,299 / 18 / -8

    #3 Jersey

    FWIW, I did have a glitch in that when it showed overall stats, it only listed Green-Ellis and Ridley as having rushed the ball, but it showed what I think was the correct total # of rushes for all rushers (i.e., including Woodhead).
     
  18. RelocatedPatFan

    RelocatedPatFan In the Starting Line-Up

    Joined:
    Dec 13, 2009
    Messages:
    2,519
    Likes Received:
    55
    Ratings:
    +157 / 2 / -2

    I like it and it's a tremendous first effort (figuring it will get more complicated over time).

    Is there any way to add calculated fields so you could get Yards Per (Attempt, Carry, Completion, ...)?
     
  19. neuronet

    neuronet In the Starting Line-Up

    Joined:
    Jan 6, 2008
    Messages:
    2,241
    Likes Received:
    9
    Ratings:
    +34 / 2 / -1

    #87 Jersey

    Awesome stuff! This should be a sticky.
     
  20. Ian

    Ian Administrator Staff Member

    Joined:
    Mar 5, 2000
    Messages:
    5,303
    Likes Received:
    293
    Ratings:
    +412 / 4 / -1

    #17 Jersey

    Good find, thanks for pointing that out. I just fixed it and it appears to be working now, and it appears to be sorting properly also.
     

Share This Page

unset ($sidebar_block_show); ?>