Spreadsheet: 491988d1480738149-pulling-a-value-on-several-sheets-based-on-name-of-the-sheet-and-another-variable-book
Sheet: Indianapolis

Team Stats and Rankings Table
 |  |  | Tot Yds & TO |  |  |  |  | Passing |  |  |  |  |  |  | Rushing |  |  |  |  | Penalties |  |  |  |  |  | Average Drive
Player | PF | Yds | Ply | Y/P | TO | FL | 1stD | Cmp | Att | Yds | TD | Int | NY/A | 1stD | Att | Yds | TD | Y/A | 1stD | Pen | Yds | 1stPy | #[NAME] | Sc% | TO% | Start | Time | Plays | Yds | Pts
Team Stats | 270 | 3876 | 718 | 5.4 | 13 | 3 | 232 | 259 | 412 | 2827 | 20 | 10 | 6.3 | 143 | 268 | 1049 | 8 | 3.9 | 65 | 78 | 684 | 24 | 122 | 39.3 | 10.7 | Own 26.8 | 02:47:00 | 6.22 | 31.7 | 2.1
Opp. Stats | 301 | 4345 | 706 | 6.2 | 8 | 5 | 250 | 268 | 406 | 3066 | 22 | 3 | 7.2 | 158 | 278 | 1279 | 8 | 4.6 | 67 | 88 | 767 | 25 | 119 | 45.4 | 6.7 | Own 26.2 | 02:45:00 | 6.4 | 36.4 | 2.37
Lg Rank Offense | 12 | 15 |  |  | 13 | 3 | 12 |  | 11 | 11 | 10 | 21 | 19 |  | 22 | 25 | 17 | 23 |  |  |  |  |  | 10 | 16 | 26 | 8 | 11 | 14 | 12
Lg Rank Defense | 28 | 30 |  |  | 30 | 18 | 28 |  | 22 | 31 | 27 | 31 | 29 |  | 15 | 23 | 11 | 28 |  |  |  |  |  | 2 | 28 | 4 | 22 | 27 | 32 | 28
Schedule & Game Results Table
 |  |  |  |  |  |  |  |  |  | Score |  | Offense |  |  |  |  | Defense |  |  |  |  | Expected Points
Week | Day | Date |  |  |  | OT | Rec |  | Opp | Tm | Opp | 1stD | TotYd | PassY | RushY | TO | 1stD | TotYd | PassY | RushY | TO | Offense | Defense | Sp. [NAME]
1 | Sun | 2016-09-11 00:00:00 | 4:27PM ET | boxscore | L |  | 0-1 |  | Detroit Lions | 35 | 39 | 25 | 450 | 368 | 82 |  | 28 | 448 | 332 | 116 |  | 23.5 | -26 | -1.43
2 | Sun | 2016-09-18 00:00:00 | 4:25PM ET | boxscore | L |  | 0-2 | @ | Denver Broncos | 20 | 34 | 19 | 253 | 170 | 83 | 2 | 24 | 400 | 266 | 134 | 1 | -9.66 | -12.3 | 9.6
3 | Sun | 2016-09-25 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-01-02 00:00:00 |  | San Diego Chargers | 26 | 22 | 24 | 410 | 317 | 93 | 2 | 17 | 352 | 315 | 37 | 3 | -2.59 | 4.64 | 4.12
4 | Sun | 2016-10-02 00:00:00 | 9:35AM ET | boxscore | L |  | 2016-01-03 00:00:00 | @ | [NAME] | 27 | 30 | 23 | 284 | 190 | 94 | 1 | 23 | 331 | 195 | 136 |  | 1.26 | -12.99 | 2.11
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-03 00:00:00 |  | Chicago Bears | 29 | 23 | 20 | 396 | 298 | 98 |  | 25 | 522 | 397 | 125 | 1 | 7.58 | -11.01 | 9.67
6 | Sun | 2016-10-16 00:00:00 | 8:32PM ET | boxscore | L | OT | 2016-02-04 00:00:00 | @ | Houston Texans | 23 | 26 | 19 | 392 | 231 | 161 | 1 | 26 | 414 | 256 | 158 | 1 | 2.34 | -9.63 | 5.89
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-04 00:00:00 | @ | Tennessee Titans | 34 | 26 | 26 | 422 | 341 | 81 |  | 26 | 331 | 207 | 124 | 1 | 16.76 | -9.56 | 2.64
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-03-05 00:00:00 |  | Kansas City Chiefs | 14 | 30 | 18 | 277 | 172 | 105 | 2 | 20 | 422 | 334 | 88 |  | -9.55 | -10.8 | 3.36
9 | Sun | 2016-11-06 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-04-05 00:00:00 | @ | Green Bay Packers | 31 | 26 | 22 | 355 | 270 | 85 | 2 | 25 | 405 | 289 | 116 | 1 | 6.72 | -10.86 | 11.14
10 |  |  |  |  |  |  |  |  | Bye Week
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-05 00:00:00 |  | Tennessee Titans | 24 | 17 | 18 | 327 | 251 | 76 | 1 | 20 | 351 | 254 | 97 |  | 11.39 | -1.72 | -3.98
12 | Thu | 2016-11-24 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-05-06 00:00:00 |  | Pittsburgh Steelers | 7 | 28 | 18 | 310 | 219 | 91 | 2 | 16 | 369 | 221 | 148 |  | -1.12 | -17.02 | 0.14
13 | Mon | 2016-12-05 00:00:00 | 8:30PM ET | preview |  |  |  | @ | New York Jets
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Houston Texans
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Minnesota Vikings
16 | Sat | 2016-12-24 00:00:00 | [NAME] | preview |  |  |  | @ | Oakland Raiders
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | [NAME]