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

XR CHART
Intermediate Gains on Run Ploys |  |  |  |  |  | page 30
 | DICE | player | rated? | If YES, then use this result... | If NO, then use THIS result
 | 11 | CE | run/0 | dropped for no gain | spins thru line for 7 yards
 | 12 | I-J-K | run/2 | tripped up for no gain | cuts thru swarm of players for 7 yard gain
 | 13 | GA | run/0 | stopped for no gain | twists forward for 7 yards
 | 14 | K | nin/2 | dumped for no gain | bounced out of bounds after 7 yard gain
 | 15 | GB | run/0 | tackled for no gain | chums ahead for 7 yards
 | 16 | J | run/2 | stuffed at line for no gain | bolts thru hole for 7 yard gain
 | 21 | TB | run/0 | missed block ruins play, no gain | knifes ahead for 8 yard gain
 | 22 | I | run/2 | pulled down for no gain | drags defenders for 8 yard gain
 | 23 | TA | run/O | stacked up for no gain | slices thru small gap for 8 yards
 | 24 | G-H | run/2 | tripped up after 1 yard gain | evades defenders for 8 yard run
 | 25 | GA'GB | nin/0 | runner manages 1 yard gain | bursts thru gap for 8 yards
 | 26 | E-F | run/2 | hole closes fast, 1 yard gain | wriggles past defenders for 8 yard gain
 | 31 | TA'TB | run/0 | tackled after gain of 2 yards | pops thru hole in line for gain of 9 yards
 | 32 | H | run/2 | dragged down after gain of 2 yards | cuts outside, pick up gain of 9 yards.
 | 33 | EC | run/0 | knockd over after 2 yard gain | bolts thru hole for 9 yard run
 | 34 | G | run/2 | stacked up after gain of 2 yards | slips out of [NAME]'s grasp for 9 yard gain.
 | 35 | EB | run/O | runner pushes pile ahead, picks up 2 yards | stacked up at line but twists free for 9 yards
 | 36 | F | run/2 | downed after pick-up of 2 yards | barges thru huge hole for 9 yard gain
 | 41 | EA | run/O | swamped at line, 3 yard gain | drags along defenders for 10 yard gain
 | 42 | E | run/2 | bogged down, play gets 3 yards | breaks into secondary for 10 yard gain
 | 43 | EC | run/O | dumped after gain of □ yards | knocked out of bounds after gain of 11 yards
 | 44 | A-B-   C-D | run/2 | runner slips thru gap in line, but is met by    defensive back, stopped cold after □ yard gain | breaks free of line, hit by two defenders, finally         hauled down after picking up 11 yards
 | 45 | EA | run/O | missed assignment, runner downedQ  after yards | gallops past linebacker for 12 yard gain
 | 46 | D | run/2 | bounced to turf after □ yard gain | bolts ahead for 12 yard gain
 | 51 | FB | run/O | wrong block read, runner jarred after [NAME] | cuts outside, knocked out of bounds after 13 yds
 | 52 | C | run/2 | buried after picking thru line for □ yards | fakes outside, then powers upfield for 13 yards
 | 53 | SB | run/O | bowled over after □ yard gain | squirms free of tackle, scrambles ahead 14 yards
 | 54 | B | run/2 | gap stopped up quickly, □ yard gain | charges thru huge hole into secondary, 14 yards
 | 55 | QB | run/O | poor handoff delays play, □ yard gain | bumped out of bounds after 15 yard gain
 | 56 | A | run/2 | smothered after plunging thru line, □ yards | breaks 2 tackles, chums forward 15 yards
 | DICE | Is runner's run     grade...? |  | If YES, then use this result... | If NO, then use THIS result...
 | 61 | AAA or      AAAA |  | go to GO! chart, page 34 | dragged down after 12+ □ yard gain
 | 62 | AA or better |  | go to GO! chart, page 34 | forced out of bounds after 13+ □ yard gain
 | 63 | A or better |  | go to GO! chart, page 34 | breaks into secondary, finally knocked down after               picking up 14+Q yard gain
 | 64 | B or better |  | go to GO! chart, page 34 | breaks two tackles at line, then spins free of      linebacker, finally tackled after 15+ □ yards
 | 65 | C or better |  | go to GO! chart, page 34 | breaks free from pile-up at line of scrimmage,     picks way past defenders for 16+Q yard gain
 | 66 | D or better |  | go to GO! chart, page 34 | accelerates thru hole, speeds past linebacker's               grasp for 17+ Qyard gain