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

[Ian]

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

Ian

 

[Ian]

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.

 

[Ian]

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

 

[thenepatsrule]

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

Just pray that rex ryan does not get hold of this

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?

 

[strngplyr]

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.

 

[thenepatsrule]

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.

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

 

[Ian]

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.

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.

 

[Ian]

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.

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.

 

[Sciz]

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!)

 

[Ian]

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.

 

[Ian]

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

 

[IcyPatriot]

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

good play Ian

 

[strngplyr]

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.

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.

 

[BradyFTW!]

Re: PatsFans.com 2011 Offensive Stats Database - BETA

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

 

[Joker]

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.

 

[Ian]

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.

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:

 

[ctpatsfan77]

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).

 

[RelocatedPatFan]

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, ...)?

 

[neuronet]

Awesome stuff! This should be a sticky.

 

[Ian]

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).

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.