Week 3 - Falcons at Dolphins - Charting the Dolphins Offense

I was able to get around to week 3's game rather quickly this week. Here's the stats from our personnel packages, and performance from Sundays dramatic win over the Falcons. Lots, and lots of 11 personnel today. Probably due the fact we were behind and needed to pass quite a bit to get back into it. I found it interesting that on that final drive, we were in 01 for several plays, and even some of the plays we were in 11, Hartline wasn't out there, it was Wallace, Gibson and Matthews with Clay and Miller.

Not sure why we didnt run more out of 12 this week. Miller ripped off the huge run from 12, i've noticed we seem to be running better out of 12. That being said, I'd like to see our running game get going out of 11 though, keep defenses more honest, right now its too easy to see that our tendency is to pass out of that grouping.

Here's the data... anything interesting to you this week?

 

For each game... you can go to nfl.com, go to the game center for each game, and then click on the game info tab and you can download the gamebook for each game. It's got all the stats from the game.

I use the gamebook for the official stats, watch the games again, fill out a spreadsheet i made to track the personnel groupings, then the results of each play from the game book... the spreadsheet fills out the rest.

not sure if that's what you were looking for?

If not, stats are all over the web for NFL games.

 

There's a thread for each game of this season already posted here.

Here's Week 1: http://www.thephins.com/forums/showthread.php?78147-Week-1-Dolphins-Browns-Charting-the-Phins-Offense

Here's week 2: http://www.thephins.com/forums/showthread.php?78163-Week-2-Dolphins-Colts-Charting-the-Dolphins-Offense

I'd be here all week doing one game if i tried to track who's on the field at any given time, this gives you an idea though. Typicall, if its one TE and a RB, its Clay and either Miller or Thomas, with Wallace, Hartline and Gibson at WR. When we go two TE's, Sims is in with Clay... just follow the depth chart for the most part. Two RB's however, generally for us is Miller or Thomas, and the Fullback.. Clutts.

 

It was similar against Cleveland (1 run, 13 passes on 3rd), but a little more balanced at Indy (3 to 8)... Alot of it I believe is due to us simply not gaining enough yards when we run on first or second. I think alot of it is created by our lack of a ground game. Leaves us in situations where we have 3rd and long alot, not much choice but to pass.

 

Its likely the plays we took sacks. The spreadsheet doesn't track them. I note down the personnel package we came out in, but not the result of the play since it only tracks runs, run play results, pass completions or incompletions and the resulting yardage. If i tracked the lost yards as a result of a sack, then the passing numbers would be all out of whack. It was something I didnt think about when I built the spreadsheet. In order for me to add the ability to track it, along with penalties against the offense, i'd have to had new columns, with formulas to track it, calculate it for each and every personnel grouping. Same with penalties. So I made the decision to do this this year without those two things factored in, until i could find the time to re-work the spreadsheet to factor it in.

So in short, a play with a sack against, or penalty against, isn't shown. Only if we got the play off, ran or passed.

 

I agree, unfortunately the spreadsheet i built doesn't have that ability to track. Well... it may, since I do input the down and distance on each play, I just dont have anything in there to track and calculate it.

For those that didnt read the first thread from the Cleveland game... this spreadsheet was a two year work in progress for me. I finally threw it together and got it functional to the point I could do this for this season, I wanted to last season, it just didnt come together. It seems some touch ups to make it perfect, sure, but finding time, and finding a way to make excel work for what I want it to do, is a bit tough at times for me. Sorry guys.

 

Im aware that a sack is a negative pass play, the reason for having to rebuild the sheet is because I only gave it the ability to track a run, or a pass that was complete, or incomplete. So, I have no way of tracking a sack. I could track it as incomplete, but then it throws the completion/incompletion numbers out of whack. So, unfortunately for the time being its not possible. Not without throwing another number out of whack anyways. The passing totals the sheet shows are higher in yards, because the negative of the sack yards aren't in there. I completely overlooked a sack when I built it, because I was more concerned with run or pass, and yards gained/lost. However when I did the passing section, I set it for for complete vs incomplete, but left nowhere for a situation where its a pass but the ball wasnt actually thrown, and it ended up a sack. It bothers me that it's not there, but I know what a pain in the *** it's going to be to try and fix. Especially to try and track all the damn forumla's in this thing. If I can find an easy fix, I will try and do it, if not, it may need to wait until the offseason, or I just quit this all together if its that big of a deal.