Buckeye Charting - Buffalo Offense

yrro's picture
September 8, 2013 at 3:27p
8 Comments

Here are the results from the Buffalo game. In the future I have more analysis, but for now I'm just happy to have a script working to get this data into a blog post. I'll try to put up the defense later tonight! The San Diego State game should go much smoother now that I've got everything set up, so look for it earlier in the week.

Original Spreadsheet

Time Yard Line Down and Distance Play Type Player Yards
RB-TE Formation Play Number of Rushers Air Yards Pass Accuracy
Plus Minus
Notes
11:49 O 37 1 and 10 RUSH J. Hall 5
1-1 Shotgun Trips Left Inside Read Zone      
Plus: Minus:
Handoff, well blocked, positive yards
11:27 O 42 2 and 5 RUSH J. Hall 9
1-1 Shotgun Trips Right Inside Read Zone      
Plus: J. Hall Minus:
Tackles made it to LB's to provide blocks for extra yards. Hall, nice move to avoid unblocked lineman
11:21 B 49 1 and 10 RUSH J. Hall 2
1-1 Shotgun Trips Right Inside Read Zone      
Plus: Minus:
Hall, up middle, good read
10:56 B 47 2 and 8 PASS D Smith 47
1-1 Pistol Double Wide Read Zone Play Pass, 5 47 Dead On
Plus: Miller, Smith, O-line Minus:
47 yard TD Pass. Miller, First Pass TD, O Line well blocked. D Smith, nice adjustment to ball in air.
EXTRA POINT B 3 X and X RUSH Guiton  
2-2 Crap Left QB Run      
Plus: Guiton Minus:
Guiton broke tackle to get into Endzone for Xtra Pt
    and      
-          
Plus: Minus:
 
8:25 O 39 1 and 10 PASS Wilson 18
0-1 Ace Trips Left, Open Right Motion, Swing Pass Left 4 0 Dead On
Plus: Wilson Minus:
Shoestring tackle or Wilson might have scored. Swing Pass, Wilson Nice Cut, Good Blocks by Trips Receivers.
8:15 B 43 1 and 10 RUSH Hall 0
1-1 Shotgun Trips Right Open Left Dave RUSH with Pulling Guard      
Plus: Minus: Norwell
Norwell did not seal block on his pull, Hall was stopped for no gain, if Norwell had turned in to seal Hall may have had a big run.
7:54 B 42 2 and 9 PASS Fields 25
1-1 Shotgun Trips Right Open Left Drop Back, Middle Pass 3 25 Dead On
Plus: Miller Minus:
Miller, Nice throw in between 2 defenders.
7:20 B 17 1 and 10 PASS Spencer 10
1-1 Shotgun Trips Right Open Left Drop Back, Quick Pass 3 5  
Plus: Spencer Minus: ESPN
ESPN - Missed the beginning of the play. Spencer, extra yards
7:13 B 07 1 and 7 PASS Fields 7
1-0 Shotgun Trips Left Open Right Roll Left, Out Pass 5 7 Dead On
Plus: Miller Minus:
7 yard TD Pass. Miller, squared shoulders on throw to his left.
EXTRA POINT B 03 X and X PASS Hall x
1-1 Crap Left Swing Pass behind Crap Left 2 0  
Plus: Norwell, Guiton, O-line Minus:
Norwell, Nice Kick Out Block on D End, The rest of the O Line blocked down and devasted the D Line. Guiton delivered a nice pass to Hall, Hall could have walked into endzone.
    and      
-          
Plus: Minus:
 
4:24 O 16 1 and 10 PENALTY    
1-1 Pistol, Trips Left, Open Right   5    
Plus: Minus: Mewhort, Miller
Possible Grounding on Miller, O Line Did not Block, Holding on Mewhort.
4:17 O 08 1 and 18 PASS Hall 2
1-1 Shotgun, Double Wide Back Out, Short Pass 5 2  
Plus: Minus: J. Hall
Hall fell down.
3:47 O 10 2 and 16 RUSH Hall 10
1-1 Shotgun Trips Left Open Right Option Right      
Plus: Norwell Minus:
Nice Block by Norwell to seal left side.
3:00 O 19 3 and 7 PASS Brown 8
1-0 Shotgun Double Wide Drop Back Middle Pass 3 8 Dead On
Plus: Brown Minus:
Brown, Nice catch with defender draped on his back.
2:30 O 27 1 and 10 RUSH Miller 13
1-1 Shotgun Trips Right Open Left Drop Back Pass, Scramble 5    
Plus: Brown Minus:
Brown, Nice block on D back
2:05 O 40 1 and 10 RUSH Hall 6
1-1 Shotgun Trips Left Open Right Middle Read Zone      
Plus: Linsley Minus:
Linsley manhandled Nose Guard
1:26 O 46 2 and 4 RUSH Hall 5
1-1 Shotgun TE Right Middle Read Zone      
Plus: Norwell Minus:
Norwell pulled through hole and neutralized defender
0:53 B 49 1 and 10 PASS Brown 0
1-1 Shotgun Trips Right Open Left Deep Out Right 5   Catchable
Plus: Minus: Brown
Incomplete Pass, Brown dropped ball. O Line - Good Protection. Brown Drop
0:46 B 49 2 and 10   Hall 49
1-1 Shotgun Trips Right Open Left Read Zone Left      
Plus: Linsley, Norwell, O-Line Minus:
49 yd TD Run. Linsley Pancake, Norwell Pancake, Good Blocking by entire O Line
EXTRA POINT B 03 X and X   Basil  
1-2 Crap Left, Shift, Kick X Pt Kick      
Plus: Minus:
Extra Point Good
    and      
-          
Plus: Minus:
 
14:24 OSU 17 1st and 10 pass B.Miller -4
1- Shotgun Sack 7    
Plus: Minus:
The whole O-line really ole'd this one. Mack came off a block well and LBs were blitzing, Looked like Heuerman and Philly Brown were open on short out crosses, but Braxton never had a chance
13:42 OSU 13 2nd and 14 pass D. Smith 9
1- Shotgun     3 Dead On
Plus: Minus: Decker
Mack got by Decker on this play for a near sack
13:04 OSU 22 3rd and 5 pass C.Brown (Philly) 17
1- Shotgun     10 Dead On
Plus: Minus:
Wide open in the flat
12:33 OSU 39 1st and 10 pass Incomp 0
1-1 Shotgun, Open Left I think because TE was dropped back       Bad
Plus: Minus: Miller
Miller overthrew a wide open D.Smith
12:27 OSU 39 2nd and 10 run J.Hall 6
1-1 Shotgun Open Right dive      
Plus: Decker Minus:
Decker and Norwell nice blocks, Hall did a cut back to the right and had a nice wide open hole
11:49 OSU 45 3rd and 4 pass Heuerman 3
1- Shotgun     3 Catchable
Plus: Minus:
Why you drop out a 3yrd out when we need 4, I don't know, but
11:28 OSU 48 4th and 1 run Hall 0
1-1 Shotgun dive      
Plus: Minus: Heuerman
Decker ended up doubled up because Heuerman motioned around and wiffed on Gilbo who got the stuff on Hall
10:23 OSU 42 1st and 10 run D. Wilson Fumble, -1
0-1 Shotgun end around/Fumble      
Plus: Minus: Wilson
First fumble for Dontre's career, gotta protect the rock kid
9:18 KR KR and KR KR Heuerman 13
- KR KR      
Plus: Minus:
Didn't seem to want to kick it deep to Wilson
9:14 OSU 35 1st and 10 run J.Hall -1
1- Pistol dive 6    
Plus: Minus:
OL chose to double up the DT and the LB came thru untouched
8:50 OSU 34 2nd and 11 pass Heuerman 9
1- Pistol     2 Dead On
Plus: Minus:
Miller on a boot leg out left, hits Heuerman on a dump off in the flat as the D collapsed on Miller
  OSU 44 3rd and 1 pass E. Spencer 5
-       5 Dead On
Plus: Minus:
ESPN made me miss the formation and pre-snap stuff w/Cris Carter interview
  OSU 50 1st and 10 run B.Miller -3
1-1 Pistol Scramble      
Plus: Minus:
Pass play intended, Miller scrambles OB for a loss of 3 but he made a nice move to avoid a sack before the scramble
7:26 OSU 47 2nd and 13 pass Interception  
1- Shotgun Short out   1 Bad
Plus: Minus: Miller
Mack went up and got it, pass intended for D. Wilson
KR KR KR and KR KR D. Wilson 53
- KR KR      
Plus: Wilson Minus:
Nice return, nice cutbacks, great speed
6:59 BUF 37 1st and 10 run J.Hall 37
1- Shotgun dive      
Plus: J. Hall, O-line Minus:
Never touched him for the TD
4:47 OSU 41 1st and 10 run j.Hall -1
1- Shotgun off tackle outside draw   n  
Plus: Minus: Spencer
Spencer ole'd on his block and Hall got caught in the backfield
4:06 OSU 39 2nd and 12 pass Incomp to Spencer 0
0-1 Shotgun, empty backfield     6 Dead On
Plus: Minus: Spencer
Dropped a very catchable ball, but would have gotten lit up, maybe he was already bracing for the hit
3:59 OSU 39 3rd and 12 sack B.Miller -5
1-0 Shotgun sack   n  
Plus: Minus: Decker
Decker let Mack get by him again, Mack is good but Decker was his whipping boy all day
3:50 OSU 33 4th and 18 Punt Johnson  
- Punt Punt      
Plus: Minus:
Almost blocked, he had to short leg it, or maybe that's his technique, Never seen him punt before, hopefully won't much
:57 OSU 29 1st and 10 Run J. Hall 11
1- Shotgun Shovel pass      
Plus: Minus:
Decker might have been holding, he seems to be coming up a lot negatively
:44 OSU 40 1st and 10 Pass Incomplete to J. Hall 0
1- Shotgun, Trips Left Incomp pass   0 Catchable
Plus: Minus: Miller, J. Hall
Hall wasn't really looking to catch the ball, Miller was getting swarmed but couldn't have been worse
:41 OSU 40 2nd and 10 Penalty   -10 (pen)
0- Shotgun, 4 out left Holding     Bad
Plus: Minus: ESPN
No clue who held, ESPN was showing Brown (corey not devin, beth) but it better not have been Decker
:13 OSU 30 2nd and 20 run B.Miller 9
1-1 Shotgun QB draw      
Plus: Miller Minus:
Good designed QB draw, Miller made a few good cut backs, broke a couple tackles
    and      
-          
Plus: Minus:
 
15 : 00 OSU 25 1 and 10 Run Jordan Hall -1
1-1 Shotgun Right/Ace Inside Zone Read      
Plus: Mewhort, Norwell, Boren, M. Hall, Decker, Heuerman Minus: Miller
Started 2nd half with a safe zone read, but Braxton either predetermined to hand it off or made the wrong read, and the unblocked read defender tackled Hall for a loss. Would have been an easy gain if Brax kept. We also had 1 on 1 coverage to the field side (I think Spencer is there off camera), but we did not challenge it. "+1" to Mewhort, Norwell, Boren, Hall, Decker, Heuerman - good push all across line, would have been a nice gain if Brax had made correct read
14 : 27 OSU 24 2 and 11 PA Pass Devin Smith 5
1-1 Shotgun Left/Ace *Package Play* IZR w/ X flash screen 4 2 Dead On
Plus: Miller, Smith Minus:
Very interesting play here. Appears to be a packaged play where the line and Hall run IZ, while Fields and Devin run a quick WR screen. Braxton sees 2 on 2 on the outside with the corner playing soft, so he chooses the quick WR screen. It's a good choice and they pick up 5 yards. "+1" to Brax, Devin - accurate throw and what looks like a good read on the packaged play, catch and spun up field for an extra couple of yards
13 : 52 OSU 29 3 and 6 Pass (Sack + Fumble) Miller -9
1-1 Shotgun Trips Left/Trey Left Open/Trio Left Indeterminate pass, hard to say due to sack 4    
Plus: Mewhort, Norwell, M. Hall Minus: Decker, Miller
Ugly...can't tell much about the pass routes from limited camera angle. Heuerman ran an "okie" or an small drag that he stops and reverses field towards the sideline. Philly appears to run some sort of In or Curl. Line has good protection except for Decker. Decker gets beat on a pure speed rush that results in a strip sack. Thankfully Decker falls on the fumble.-3 for Decker - got destroyed off the edge allowing his man to strip sack Braxton, thankfully recovered the fumble... -1 for Braxton - held the ball slightly too long on a quick pass play, needs to hold onto the ball when hit
13: 09 OSU 20 4 and 15 Punt Johnston 43
--- Spread punt 43 yard punt, no return      
Plus: Johnston Minus:
Good protection, no return
10 : 15 OSU 9 1 and 10 Run Miller 5
1-1 Shotgun Right/Ace Right IZ Read - Keep      
Plus: Miller, Norwell, Mewhort, M. Hall Minus:
Brax makes a good read on the IZ, keeping it for 5. Mostly good blocking on the line, though Boren got stood up a bit. Good solid pickup. "+1" to Miller - correct read on the keep, got upfield for 5, +1 Mewhort, Norwell, Hall for good run push. Boren got stood up but kept his man at bay, Heuerman wasn't a big factor. +1 to Chris Fields for an excellent block on his DB
9 : 50 OSU 14 2 and 5 Run Hall 6 (4 after contact)
1-1 Shotgun Quads Left (TE inelligible left) *Package Play* IZ (no read) w/ X flash screen      
Plus: J. Hall Minus: M. Hall
Interesting play here that we get a good gain out of, but I think that Braxton does not make the optimal choice here. We have 3 WRs to the left with the TE also on the line left. This gives us quads left, but the TE is not an elligible receiver. UB's DBs are visibly confused how to respond to this and only have 2 players within 8 yards of our trio of WRs. Devin steps back for a quick screen and the other 2 WRs set up to block for him. It appears that Devin could have easily picked up 5+ yards. Instead Braxton hands off to Hall who finds a crease and should be stopped for a 2 yard gain. He manages to break that tackle and get out of the mess before stumbling forward for a 6 yard gain and a first down. A successful play due to Hall, but I think the screen would have been the wiser read. "+2" Hall for breaking what looked like a sure tackle in the hole and turning a meh play into a nice first down
9 : 32 OSU 20 1 and 10 PA Pass (Scramble/Sack) Miller -2
1-1 Pistol Trips Right (2 WR and TE right, TE on line) / Trey Right PA rollout pass to the right, broken 4    
Plus: Minus: Heuerman, Decker
A simple PA pass rollout to the right that goes wrong. Decker steps left with the rest of the OL, then has to reach right to stop his rush. He shoves the lineman to his right, apparently expecting Heuerman to be there and pick him up. Oops. Heuerman did not step left with the other lineman and directly attacked OLB Mack (and did an admirable job). Mack shifted over right before the snap so it's possible that Decker did not see him. Either Decker or Heuerman was in the wrong here, as it resulted in a D lineman running right at Braxton after the PA fake. Braxton tries to make the best of it and reverses field, rolling out to the backside of the play. He has a lot of grass in front of him and just one defender to beat, but his leg cramps up just as he is about to cut, so he falls for a 2 yard loss. Ugh.
9 : 12 OSU 18 2 and 12 Run Hall 4
1-1 Shotgun Twins Left, TE in backfield behind LT Inside Dive with the 3 - 4 DE being kicked out by pulling TE      
Plus: Decker, M. Hall, Boren, Mewhort, Heuerman Minus: Norwell
Kenny G comes in for Braxton who went off with a cramp. No read on this play, it's a give all the way. Heuerman, lined up in the backfield like a FB, pulls and kicks out the unsuspecting DE. OL does a pretty good job getting hats on guys in the second level, except for Norwell who falls down and whiffs on his LB. This LB combines with a safety to make the tackle for a 4 yard gain. The safety was down in the box and simply unaccounted for. UB was likely keying on the run as this was the first play that Kenny G came in for. Decent run that could have gone for more if Norwell gets a piece of his LB.
8 : 28 OSU 22 3 and 8 Pass (Penalty Defense - Hands to the face) Miller 15 - thanks to penalty
1-1 Shotgun Right Open Pass of some kind that became a sack/fumble but was negated by penalty      
Plus: J. Hall Minus: Miller
Braxton back in. Another ugly play. Let's see what went wrong.Protection starts out okay. Decker starts out looking for the defender in the slot to come on a blitz, but that defender alters his course and chases Hall on his route out of the backfield. Seeing no danger coming from the outside, Decker turns inwards to "sauce the ribs" and help Hall. Meanwhile, Mewhort is doing okay at forcing his man upfield. Norwell is getting pushed back by Mack but manages to keep Mack in front of him. That is, until Mack grabs hold of Norwell's facemask and encourages Norwell to take a good look at the skies above the Shoe. Mack is flagged appropriately for this penalty, and the rest of this play would not have happened without Mack's illegal rush.With a good handle on Norwell's face, Mack is able to drive him back into Miller. This forces Braxton to scramble to his right. Unfortunately, remember that slot defender who stopped his blitz to pick up Hall? Well he decided to be tricky and come back with a delayed blitz, now coming back free right at the scrambling Miller. Braxton, being his usual self, makes this guy miss, but Mack has finally let go of Norwell's facemask and catches him from the side.He slams Braxton down on backwards upon himself, causing Braxton to lose the ball as he slams into Mack's helmet. I can't blame Braxton for trying to make something happen, but he probably should have tried to throw it away and he definitely can't fumble. Keep in mind that Mack was only in the backfield because he used illegal hands to the face to disengage from Norwell, so this play isn't perhaps as horrible as it seemed. I can't really blame Decker for not picking up the delayed blitz after 4 seconds, so I will just have to give credit to the defense there.
7 : 54 OSU 37 1 and 10 Run Miller -3
1-1 Shotgun Trio Right / 1 WR left 2 WR right TE on line right IZ Read - Keep      
Plus: Mewhort, Boren Minus: Vannett, M. Hal, Decker
Simple IZR. By playing their 3-4 ends inside the tackles, this play is much harder to execute than against a standard 4 - 3. The read defender heads towards Hall, giving Miller a "keep" key. He does so, but the DE does an excellent job of diving back and getting ahold of Miller before he can get anywhere. I wouldn't mark this down as a bad play by Braxton, but rather a great play by the DE and a result of having to read a player much closer to the mesh point than normal.
7 : 20 OSU 34 2 and 13 Run Hall 12 (11 after contact)
1-1 Pistol Trio Right / 1 WR left 2 WR right TE on line right Dave Right      
Plus: J. Hal, Decker, Norwell, Mewhort, Boren, Vannett Minus:
Everyone's favorite, "Dave" is still with us! The DE (that just blew up the IZR in part thanks to being lined up inside of Decker) gets demolished and washed down the line by Decker, leaving a big hole for Norwell to pull into, where he nicely picks up the LB. Hall maybe should have cut right off the block instead of left, but he makes his choice work as he runs right by a diving LB (who was probably overpursuing because he thought Hall would hit the other hole) and then making his way to the second level for a pickup of 12.
6 : 48 OSU 46 3 and 1 Run Hall 2
1-1 Pistol Twins Rt TE Wing Rt Dave Right      
Plus: Vannett, Decker, M. Hall, Boren Minus:
Slightly different formation, essentially the same play. If it works keep running it, right? This time the DE is lined up outside shade on Decker, so Vannet, from a FBish alignment, kicks out the DE while Norwell pulls through. It's not as big of a hole, but it's plenty clean enough for Hall to squeeze through for the first down.
6 : 20 OSU 48 1 and 10 Pass Hall 1
1-1 Shotgun Trips Left (2 WR & TE split left, 1 WR split right) Swing pass right 4 negative 5 (swing pass) Dead On
Plus: Minus:
In case you haven't noticed yet, Mack is a beast. Here Heuerman makes a pretty decent attempt at blocking him in open space, but Mack is too much. Heuerman appears to get Mack somewhat sealed to the outside, so Hall attempt to cut inside the block. Unfortunately, Mack sheds the block just as Hall gets there, resulting just a 1 yard gain instead of 5 or so. I did not give Heuerman a minus here, as it's a tough matchup and he held his own.
5 : 37 OSU 49 2 and 9 PA Pass turned to Scramble Run Miller 15
1-1 Shotgun Trio Rt (2 WR split, TE on line, 1 WR split left) *Package Play* - IZR with a 5 yard hitch to Devin on the backside...turned into a successful Braxton scramble 5    
Plus: Miller Minus:
Another interesting packaged play. The line blocks IZR. Braxton identified the corner playing well off of Devin so he chose to run the quick hitch. After the PA fake, however, the unblocked read end jumped up to block the quick pass, so Braxton wisely pulled it down and scrambled for the open space himself, picking up 15 yards before cramping up again. A wise choice.
5 : 17 UB36 1 and 10 Run Hall 3
1-1 Pistol Twins Left, TE in backfield behind LT Dave Left      
Plus: Minus: M. Hall
Dave left, just like the Dave play a few back except that Hall is pulling this time. The line does fine but Hall does not pull through the hole fast enough, so Hall runs into the back of him before the hole is cleared. Hall falls forward for a few yards, but if Hall had pulled through quicker it could have been a bigger gain.
4 : 45 UB 33 2 and 7 Run Guiton 6
1-1 Shotgun Right IZR - Keep      
Plus: Guiton Minus:
IZR, defense shows no respect for Guiton and he correctly pulls it and gets good yardage. Somehow Mack, the opposite OLB, makes the play. Dude is a monster.
4 : 11 UB 27 3 and 1 Run Ball 5
1-1 Pistol Left, TE wing left Dave Left      
Plus: Ball Minus:
Dave left, the DE is lined up tight, so Heuerman attempts to log him and seal him inside instead of kick him out. Hall pulls around outside of this block and does a decent job at falling on a LB coming around the edge, taking him out of the play. The defense blitzed a slot defender, so Ball has no choice but to head right into the line. The hole is a bit of a mess but there are hats on hats, so Ball stumbles his way forward for about 5 yards.
3 : 59 UB 23 1 and 10 Run Ball 2
1-1 Pistol Left, TE wing left Dave Left      
Plus: Minus: Heuerman, M. Hall
They ran hurry-up and got up to the line and ran the same play again. Heuerman seemed unsure whether to kick out or log the DE that was tight on the line. He eventually gets inside and attempt to kick him out. At this point, Hall is already there and attempts to pull around Heuerman instead of inside him. Ball hits the hole inside Heuerman and is met by the LB who Hall was supposed to pick up.
3 : 22 UB 21 2 and 8 PA Pass Guiton to Fields 21
1-1 Pistol Right, TE wing RT PA Pass to wide open Fields on corner route 6 21 Dead On
Plus: Guiton Minus:
PA Pass, Fields in the slot ran a corner route and nobody covered him. Touchdown Buckeyes. It doesn't get easier than that. From the limited camera angles, it looked like the outside receiver ran a post, causing the deep corner to follow him and vacating his deep quarter zone. It appears he was supposed to hand off the post to the safety and stay with the corner route. Guiton put the ball on the money and took advantage of the busted coverage.
    and      
-          
Plus: Minus:
 
12:18 Own 2 1 and 10 Run J. Hall 1
1-2 S-gun Double Tight Twins Right Inside Zone      
Plus: Minus:
Safe play coming out of out endzone
11:37 Own 3 2 and 9 Run Miller 1
1-1h S-gun Right Twins Right QB Lead Right      
Plus: Minus:
Hall is lead blocker for Miller
10:55 Own 4 3 and 8 Pass Miller 41
1-1 S-gun Double Slot Double Wide Open QB Scramble      
Plus: Miller Minus:
Swing route by Hall
10:11 Own 45 1 and 10 PA Pass Smith 15
1-1h Pistol Left Twins Right Play Action Pass      
Plus: Minus: Linsley
5 receiver route with Hall/Heuerman short, Pass interference on the defense covering D. Smith
10:03 Buff 40 1 and 10 Run Miller -3
0-1h S-gun Left Double Slot Double Wide Jet Sweep      
Plus: Minus: Brown
High snap by Linsley forces Miller to keep, play was intended to go wide to D. Wilson
9:20 Buff 43 2 and 13 Pass Brown 0
1-1 S-gun Trips Left Open 4 verts pass      
Plus: Minus:
Poor adjustment by C.Brown on slightly underthrown pass
9:13 Buff 43 3 and 13 Pass Miller 16
1-1 S-gun Trips Left Open Empty QB Scramble      
Plus: Minus:
E.Elliot in slot stays in to block, Vannett is lined up as a WR
8:32 Buff 27 1 and 10 Run Wilson 3
0-1h S-gun Right Twins Right Inside Zone      
Plus: Minus:
Play appears to be IZ Read, DE unblocked but Wilson immediately runs it outside
7:52 Buff 24 2 and 7 Run Elliot 2
1-1 S-gun Trips Left Open Inside Zone Read      
Plus: Minus:
If Miller keeps he probably gains more than 2
7:22 Buff 22 3 and 5 Pass Elliot 0
1-1 S-gun Trips Left Open Pass      
Plus: Minus:
Difficult to see routes, Elliot immediately runs a swing route and as Miller scambles Elliot stretches route down sideline but pass is high and Elliot can't bring it down
7:10 Buff 22 4 and 5 FG Basil  
- FG        
Plus: Minus:
FG Good 39 yards
    and      
-          
Plus: Minus:
 
4:08 Own 25 1 and 10 Run J. Hall 3
1-1 S-gun Left Twins Left Inside Dive      
Plus: Minus:
Straight give to Hall with formation side DE unblocked
3:39 Own 28 2 and 7 QB Scramble Miller 8
1-1h S-gun Left Twins Left Inside Dive Fake, WR quick screen      
Plus: Minus:
Can't see the WR to see why Miller didn't throw the quick pass. but he tucks and runs for 8
3:07 Own 36 1 and 10 Run M. Hall 2
1-1h Pistol Left Twins Left Dave      
Plus: Minus:
M Hall pulls to lead J Hall through hole, but J Hall beats M Hall to the LB who makes the play
2:22 Own 38 2 and 8 Run Wilson 6
0-1 S-gun Right Twins Right Inside Zone      
Plus: Minus:
Play is run away from unblocked DE by Wilson
1:46 Own 44 3 and 2 QB Scramble Miller -1
1-1 S-gun Trips Right Open Drop Back pass      
Plus: Minus:
5 routes, Hall and Heuerman short, Miller reads those 2 and then starts to scramble
0:58 Own 43 4 and 3 Punt Johnston 42
- Punt        
Plus: Minus:
Punt fair caught

 

Comments

Poison nuts's picture

Wow - what an incredible amount of work YRRO!! Thank you!

"Death created time to grow the things that it would kill" - Detective Rustin Cohle.

RedStorm45's picture

Hey Yrro, this applies to both offense and defense but I'll put it here, is the format in Excel? or easy to export to Excel?  It would be interesting to do like a VLOOKUP on formations to average out yardage gained (offense) or yielded (defense).  It might be harder to apply for a defense, since it's mostly a base 4-2-5 or 4-3.  Maybe it's too difficult with the format, I don't know.  It would take awhile, but tendencies on first downs, third and 5 or less, etc.  I could also be thinking way too far outside the box, but I would think eventually the end game of this charting project would be to be able to pull things like that from the data if it's possible.

yrro's picture

If you click on the spreadsheet link, you can download it as excel from there.
I would love it if someone started playing with the data - that's the point of this project, is to get the data out there for people to use. The spreadsheet itself is in a much better format for doing data analysis than the post is - I have to transform it significantly to make it readable here. 
As of now, teasing things out by formation could be a little difficult, just because we are still settling in to our terminology. There might still be some data cleanup and normalization to do on formation names.
As people try to do more analysis, we may want to start recording some pieces in more detail as well - such as noting which players are in at running back on given down/yardage.
I've already learned a lot about how to make collection cleaner just from the first game. Hopefully we can continue to improve.
My hope is that the SDST game will take me less time to get into a combined spreadsheet and into a blog post, so I can spend more time doing a few lookups myself.

RedStorm45's picture

Gah, I wish had that kind of time this season - maybe I'll jump in next year or do something for the OOC games.  But I'm going to have almost no free time in October and November to try to pull anything together.
Do you have the final products on Google docs?

yrro's picture

Yeah, it is linked at the top of the post.

RedStorm45's picture

Haha, stupid me.  I had too many "Charting Project" tabs open.

RedStorm45's picture

Here are some quick tid bits I pulled just from filtering in Excel:
1st downs
21 runs - of those 21 - 2 scrambles, one shovel pass
1 penalty
9 passes, 1 sack
2 PA pass, one sack
128 yards on first downs, 81 on runs
3rd downs
Average yardage = 5.61 on 13 3rd downs
2 runs, both 3rd and 1's, both got the first down
2 pass plays that lost yardage - a sack and a scramble, another sack + fumble negated by a defensive penalty.
82 yards on 3rd down, 15 more from penalty to total 97.
 
These are unofficial as sometimes yardage may or may not be picked up if a charter typed in a note in a cell.  Sacks and scrambles were also charted differently - a run play v.s. a pass play.
Close to 260+ yards of offense on 2nd downs, I believe.  Again, hard to filter and total without going through every play because the notes negate the Excel formula counting that yardage.
 
I am less familiar with defense and how to break out the play, yardage, etc. to come up with something similar above.

yrro's picture

Cool stuff!
Hopefully the spreadsheet in coming weeks will keep getting cleaner and easier to parse for this kind of stuff.