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

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 | 249 | 3998 | 762 | 5.2 | 18 | 7 | 242 | 259 | 417 | 2820 | 23 | 11 | 6.4 | 157 | 322 | 1178 | 5 | 3.7 | 55 | 81 | 698 | 30 | 131 | 31.3 | 13.7 | Own 27.8 | 02:40:00 | 6.31 | 30.3 | 1.79
Opp. Stats | 264 | 4062 | 697 | 5.8 | 20 | 11 | 227 | 234 | 379 | 2788 | 20 | 9 | 6.9 | 143 | 291 | 1274 | 9 | 4.4 | 67 | 83 | 717 | 17 | 129 | 34.9 | 14 | Own 28.1 | 02:30:00 | 5.8 | 31.5 | 1.95
Lg Rank Offense | 17 | 13 |  |  | 23 | 19 | 9 |  | 9 | 13 | 6 | 24 | 16 |  | 4 | 16 | 25 | 27 |  |  |  |  |  | 22 | 7 | 16 | 17 | 10 | 17 | 17
Lg Rank Defense | 18 | 24 |  |  | 4 | 1 | 18 |  | 7 | 17 | 20 | 14 | 26 |  | 21 | 22 | 15 | 25 |  |  |  |  |  | 18 | 5 | 18 | 7 | 8 | 16 | 18
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 | 1:05PM ET | boxscore | W |  | 2000-01-01 00:00:00 | @ | Atlanta Falcons | 31 | 24 | 20 | 371 | 281 | 90 | 1 | 19 | 374 | 322 | 52 |  | 12.93 | -4.71 | 0.8
2 | Sun | 2016-09-18 00:00:00 | 1:05PM ET | boxscore | L |  | 2016-01-01 00:00:00 | @ | Arizona Cardinals | 7 | 40 | 21 | 306 | 221 | 85 | 5 | 20 | 416 | 311 | 105 |  | -21.55 | -14.72 | 0.4
3 | Sun | 2016-09-25 00:00:00 | [NAME] | boxscore | L |  | 2016-01-02 00:00:00 |  | Los Angeles Rams | 32 | 37 | 30 | 472 | 389 | 83 | 2 | 18 | 320 | 183 | 137 | 2 | 4.85 | -0.44 | -5.57
4 | Sun | 2016-10-02 00:00:00 | [NAME] | boxscore | L |  | 2016-01-03 00:00:00 |  | Denver Broncos | 7 | 27 | 15 | 215 | 143 | 72 | 3 | 22 | 307 | 218 | 89 |  | -20.49 | -2.97 | 2.33
5 | Mon | 2016-10-10 00:00:00 | 8:04PM ET | boxscore | W |  | 2016-02-03 00:00:00 | @ | Carolina Panthers | 17 | 14 | 20 | 315 | 202 | 113 |  | 20 | 414 | 278 | 136 | 4 | 2.67 | -2.26 | 3.05
6 |  |  |  |  |  |  |  |  | Bye Week
7 | Sun | 2016-10-23 00:00:00 | [NAME] | boxscore | W |  | 2016-03-03 00:00:00 | @ | San Francisco 49ers | 34 | 17 | 27 | 513 | 264 | 249 | 1 | 20 | 273 | 113 | 160 | 3 | 14.93 | 2.93 | -1.95
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | L | OT | 2016-03-04 00:00:00 |  | Oakland Raiders | 24 | 30 | 18 | 270 | 168 | 102 |  | 27 | 626 | 498 | 128 | 1 | 5.09 | -18.11 | 8.18
9 | Thu | 2016-11-03 00:00:00 | 8:25PM ET | boxscore | L |  | 2016-03-05 00:00:00 |  | Atlanta Falcons | 28 | 43 | 23 | 396 | 326 | 70 | 2 | 31 | 461 | 325 | 136 | 1 | 7.8 | -22.07 | -1.04
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-04-05 00:00:00 |  | Chicago Bears | 36 | 10 | 22 | 360 | 280 | 80 | 1 | 15 | 283 | 161 | 122 | 4 | 6.68 | 20.97 | -2.32
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-05 00:00:00 | @ | Kansas City Chiefs | 19 | 17 | 27 | 442 | 326 | 116 | 1 | 19 | 343 | 261 | 82 | 2 | 12.64 | -9.28 | -1.98
12 | Sun | 2016-11-27 00:00:00 | [NAME] | boxscore | W |  | 2016-06-05 00:00:00 |  | [NAME] | 14 | 5 | 19 | 338 | 220 | 118 | 2 | 16 | 245 | 118 | 127 | 3 | -1.31 | 18.87 | -7.45
13 | Sun | 2016-12-04 00:00:00 | 4:25PM ET | preview |  |  |  | @ | San Diego Chargers
14 | Sun | 2016-12-11 00:00:00 | 4:25PM ET | preview |  |  |  |  | New Orleans Saints
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Dallas Cowboys
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  | @ | New Orleans Saints
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | Carolina Panthers