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

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