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

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 | 247 | 3625 | 655 | 5.5 | 8 | 3 | 217 | 261 | 391 | 2736 | 19 | 5 | 6.6 | 142 | 239 | 889 | 4 | 3.7 | 50 | 75 | 660 | 25 | 106 | 41.5 | 6.6 | Own 25.1 | 03:04:00 | 6.63 | 34.2 | 2.11
Opp. Stats | 238 | 3888 | 672 | 5.8 | 11 | 4 | 229 | 285 | 385 | 2760 | 22 | 7 | 6.8 | 137 | 267 | 1128 | 5 | 4.2 | 71 | 78 | 589 | 21 | 109 | 40.4 | 10.1 | Own 28.2 | 03:08:00 | 6.7 | 35.7 | 2.2
Lg Rank Offense | 19 | 26 |  |  | 2 | 3 | 18 |  | 20 | 16 | 14 | 6 | 13 |  | 31 | 30 | 29 | 25 |  |  |  |  |  | 7 | 29 | 30 | 2 | 4 | 6 | 11
Lg Rank Defense | 15 | 15 |  |  | 23 | 22 | 23 |  | 10 | 14 | 27 | 19 | 25 |  | 12 | 15 | 4 | 19 |  |  |  |  |  | 9 | 18 | 19 | 32 | 30 | 29 | 25
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 | W |  | 2000-01-01 00:00:00 | @ | Indianapolis Colts | 39 | 35 | 28 | 448 | 332 | 116 |  | 25 | 450 | 368 | 82 |  | 26 | -23.5 | 1.43
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-01 00:00:00 |  | Tennessee Titans | 15 | 16 | 22 | 375 | 238 | 137 | 1 | 22 | 363 | 224 | 139 | 1 | 0.39 | -10.15 | 6.83
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-02 00:00:00 | @ | Green Bay Packers | 27 | 34 | 22 | 418 | 368 | 50 | 1 | 17 | 324 | 201 | 123 |  | 14.19 | -17.93 | -2.24
4 | Sun | 2016-10-02 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-01-03 00:00:00 | @ | Chicago Bears | 14 | 17 | 16 | 263 | 197 | 66 | 2 | 23 | 408 | 294 | 114 |  | -7.47 | -7.93 | 10.3
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-03 00:00:00 |  | Philadelphia Eagles | 24 | 23 | 21 | 244 | 164 | 80 | 1 | 18 | 346 | 230 | 116 | 2 | 8.49 | -4.42 | -2.7
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-03 00:00:00 |  | Los Angeles Rams | 31 | 28 | 20 | 348 | 265 | 83 |  | 23 | 387 | 311 | 76 | 1 | 20.72 | -19.64 | 2.35
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-04-03 00:00:00 |  | Washington Redskins | 20 | 17 | 19 | 344 | 250 | 94 |  | 26 | 413 | 283 | 130 | 2 | 11.55 | -8.7 | 1.85
8 | Sun | 2016-10-30 00:00:00 | 1:03PM ET | boxscore | L |  | 2016-04-04 00:00:00 | @ | Houston Texans | 13 | 20 | 19 | 289 | 231 | 58 |  | 20 | 269 | 164 | 105 | 1 | 0.37 | -1.76 | -5.34
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | W | OT | 2016-05-04 00:00:00 | @ | Minnesota Vikings | 22 | 16 | 18 | 311 | 214 | 97 | 1 | 22 | 337 | 259 | 78 |  | 1.15 | -6.72 | 13.83
10 |  |  |  |  |  |  |  |  | Bye Week
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-06-04 00:00:00 |  | [NAME] | 26 | 19 | 14 | 277 | 263 | 14 | 2 | 16 | 285 | 202 | 83 | 3 | -2.74 | 12.43 | 0.09
12 | Thu | 2016-11-24 00:00:00 | 12:30PM ET | boxscore | W |  | 2016-07-04 00:00:00 |  | Minnesota Vikings | 16 | 13 | 18 | 308 | 214 | 94 |  | 17 | 306 | 224 | 82 | 1 | -1.3 | 3.19 | -1.08
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | New Orleans Saints
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Chicago Bears
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | New York Giants
16 | Mon | 2016-12-26 00:00:00 | 8:30PM ET | preview |  |  |  | @ | Dallas Cowboys
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | Green Bay Packers