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

page 33 |  |  |  |  | XL CHART
 |  |  |  |  | Intermediate Gains on Long Pass Plays
 | DICE | Is QB's "X"       grade... |  | If YES, then use this result... |  |  | If NO, then use THIS result
 | 11 | greater than 5? |  | go to GO |  | chart, page 34 | receiver loses footing after gain of 25 yards
 | 12 | greater than 4? |  | go to GO |  | chart, page 34 | 25-yd gain; open, but receiver steps OB at sideline
 | 13 | greater than 3? |  | go to GO |  | chart, page 34 | QB finds receiver open for 26 yard completion
 | 14 | greater than 2? |  | go to GO |  | chart, page 34 | receiver cuts across middle for 27-yard gain
 | 15 | greater than 1 ? |  | go to GO |  | chart, page 34 | diving catch of overthrown pass, gain of 27 yards
 | 16 | greater than 0? |  | go to GO |  | chart, page 34 | pass complete for 28 yards
 | 21 | greater than 6? |  | go to GO |  | chart, page 34 | receiver makes catch between defenders, 29 yards
 | 22 | greater than 4? |  | go to GO |  | chart, page 34 | 30-yard gain after breaking tackle
 | 23 | greater than 7? |  | go to GO |  | chart, page 34 | pass play gains 31 yards
 | 24 | greater than 5? |  | go to GO |  | chart, page 34 | pulled down after gain of 32 yards
 | 25 | greater than 7? |  | go to GO |  | chart, page 34 | knocked out of bounds after 32-yard gain
 | 26 | greater than 5? |  | go to GO |  | chart, page 34 | pass complete for 33-yard gain
 | 31 | greater than 6? |  | go to GO |  | chart, page 34 | circus catch, receiver twists free for 34 yards
 | 32 | greater than 6? |  | go to GO |  | chart, page 34 | perfect strike from QB, complete for 35 yards
 | 33 | greater than 8? |  | go to GO |  | chart, page 34 | receiver wide open, pass play gains 36 yards
 | 34 | greater than 9? |  | go to GO |  | chart, page 34 | complete, receiver finds room to run, 37-yd gain
 | 35 | less than 4? |  | QB fails to spot open recieverT |  |  | go to GO! chart, page 34
 | DICE | Is this   player | rated... | If YES, then use this result... |  |  | If NO, then use THIS result...
 | 36 | I-K | 2/pass | hard pass rush forces QB out of pocket T |  |  | QB unloads ball, complete for 25 yards
 | 41 | J | 2/pass | pass protection crumbles quickly T |  |  | 26-yard completion
 | 42 | CE | 0/pass | missed block, QB pressuredT |  |  | complete at sideline for 26 yards
 | 43 | G | 2/pass | defender makes huge play ▼ |  |  | receiver gets step on defender, complete, 27 yds.
 | 44 | GB | 0/pass | leaky pass protection T |  |  | complete for gain of 28 yards
 | 45 | H | 2/pass | big play by defender T |  |  | sideline pattern gains 29 yards
 | 46 | TA | 0/pass | missed blocking assignmentT |  |  | pass complete over coverage, gain of 26 yds.
 | 51 | E | 2/pass | defender disrupts pass play T |  |  | complete for 30-yard gain
 | 52 | TB | 0/pass | pass rush pours past weak block T |  |  | 31 yard completion over the middle
 | 53 | F | 2/pass | "highlight film" play by defender T |  |  | complete, receiver cuts outside for 32 yards
 | 54 | FB | 0/pass | play breaks down T |  |  | pass play gains 33 yards
 | 55 | A | 2/pass | excellent coverage T |  |  | 34-yard gain after receiver makes tough catch
 | 56 | EB | 0/pass | unable to execute play properly T |  |  | QB floats ball over defender, 35-yard gain
 | 61 | B | 2/pass | no room to get pass to intended receiverT |  |  | receiver cuts inside after catch, gain of 36 yds.
 | 62 | SB | 0/pass | deficient execution of pass assignmentT |  |  | sideline route, complete, gain of 37 yards
 | 63 | C | 2/pass | airtight coverage of intended receiver T |  |  | receiver makes catch on run, gains 38 yards
 | 64 | QB | 0/pass | QB unable to keep composure under rush T |  |  | complete, dragged down after gain of 40+ □ yards
 | 65 | D | 2/pass | defender blankets receiver T |  |  | complete, shoved out of bounds after 40-yard gain
 | 66 | GA | 0/pass | blown blocking assignment, heavy pass rush T |  |  | receiver catches pass, breaks free for 39 yards
 | TQB |  |  | breed to pass to (choice)altemate receiver, pass complete for QQyards