Spreadsheet: 270990d1381776994-vlookup-index-match-test01
Sheet: Page 5

 |  |  | Yes | NO
11 | CE | 0/pass | receiver open but pass hurried, incomplete | defense recovers quickly, complete for 7 yards
12 | I, J or K | 2/pass | heavy pressure on QB, incomplete | QB gets rid of ball for quick 7 yard completion
13 | GA | 0/pass | QB forced to unload ball early, incomplete | receiver twists past LB for gain of 8 yards
14 | K | 2/pass | knifes past blocker to tip away pass, incomplete | receiver grabs quick pass, picks way for 8 yards
15 | GB | 0/pass | poor pass protection, incomplete | dump-off pass gains 9 yards
16 | J | 2/pass | brushes past block to hurry pass, incomplete | receiver sprints ahead 9 yards after quick catch
21 | TB | 0/pass | missed blocking assignment, incomplete | cuts in front of defender to catch pass, 10-yard gain
22 | I | 2/pass | quick move sheds block, rushes QB, incomplete | QB floats pass in flat for easy 10-yard gain
23 | TA | 0/pass | missed block, defender hurries QB, incomplete | complete over the middle for gain of 11 yards
24 | G'H | 2/pass | wraps up receiver after catch, gain of (box) yards | pass caught between defenders for 11-yard gain
25 | GA or GB | 0/pass | stunting defensive lineman blows past line, QB  gets rid of ball, but only for gain of (box) yards | receiver makes catch at line, breaks tackle, eludes  LB, finally dragged down after gain of 12 yards
26 | E or F | 2/pass | open field tackle after completion, (box) yards | complete under coverage, gain of 12 yards
31 | TA or TB | 0/pass | weak pass protection flushes QB out of pocket,  dumps off pass for gain of only (box) yards | perfect strike over the middle, receiver cuts across  the field for 13 yard gain
32 | H | 2/pass | complete, but gain limited to (box) yards | receiver grabs pass, dashes upfield for 13 yards
33 | EC | 0/pass | double coverage limits completion to (box) yards | knocked down by 2 defenders after gain of 14 yds.
34 | G | 2/pass | open field tackle stops receiver after (box) yards | receiver weaves past defenders for 14 yard gain
35 | EB | 0/pass | slow execution, pass gains only (box) yards | nicely-thrown pass, gain of 15 yards
36 | F | 2/pass | receiver decked after catch, gain of (box) yards | receiver slips past defenders for 15-yard gain
41 | EA | 0/pass | pass complete but only for (box) yards | receiver spins free up sideline, gain of 16 yards
42 | E | 2/pass | complete, but tackled hard after only (box) yards | QB hits wide open receiver, 16-yard gain
43 | FB or SB | 0/pass | complete, but receiver immediately stacked up  after catching pass, (box) yards | decoy draws defenders away, receiver slips into  secondary for gain of 17 yards
44 | A,B,C, or D | 2/pass | receiver blanketed after making quick catch,  gain of only (box) yards | receiver grabs pass on run, cuts ahead for 17 yard  gain, finally tripped up from behind by DB
45 | SB | 0/pass | quick completion, but buried after (box) yard gain | receiver slants past tackier, gain [NAME]
46 | D | 2/pass | complete, but cut down after only (box) yards | complete, but not much room, 8-yard gain
51 | FB | 0/pass | wrestled down after (box) yards on completion | receiver accelerates for 9 yards
52 | C | 2/pass | dumped after catch, only (box) yards | loose coverage, complete for gain of 10 yards
53 | SB | 0/pass | complete, but receiver cut down after (box) yards | complete in front of defenders, 11-yard gain
54 | B | 2/pass | hard hit stops receiver after gain of only (box) yards | pass complete, receiver breaks free for 12 yards
55 | QB | 0/pass | pass thrown poorly, complete for only (box) yards | 13-yard gain on well-executed pass play
56 | A | 2/pass | [NAME] makes great play, receiver flattened  after gain of only (box) yards | receiver makes grab in full stride, cuts upfield past  two defenders for gain of 14 yards
61 | QB X greater than 5? | yes/no | go to GO! chart, page 34 | pass complete for 15-yard gain
62 | QB X greater than 4? | yes/no | go to GO! chart, page 34 | all alone, receiver dashes upfield for 16 yards
63 | QB X greater than 3? | yes/no | go to GO! chart, page 34 | receiver finally brought down after 17-yard gain
64 | QB X greater than 2? | yes/no | go to GO! chart, page 34 | pass complete over defender, gain of 8 yards
65 | QB X greater than 1? | yes/no | go to GO! chart, page 34 | receiver dragged down from behind, 9-yard gain
66 | QB X greater than 0? | yes/no | go to GO! chart, page 34 | receiver splits defenders, picks up 10 yards