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

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 | 313 | 4083 | 713 | 5.7 | 23 | 11 | 246 | 251 | 401 | 2986 | 23 | 12 | 7 | 152 | 286 | 1097 | 9 | 3.8 | 63 | 69 | 517 | 31 | 128 | 41.4 | 16.4 | Own 30.6 | 02:43:00 | 6.11 | 31.7 | 2.24
Opp. Stats | 291 | 3972 | 710 | 5.6 | 23 | 9 | 225 | 275 | 437 | 2984 | 16 | 14 | 6.5 | 145 | 253 | 988 | 15 | 3.9 | 66 | 98 | 689 | 14 | 134 | 36.6 | 16.4 | Own 30.1 | 02:24:00 | 5.6 | 29.6 | 2.02
Lg Rank Offense | 3 | 8 |  |  | 32 | 31 | 8 |  | 16 | 5 | 6 | 26 | 8 |  | 14 | 20 | 14 | 24 |  |  |  |  |  | 8 | 2 | 2 | 12 | 14 | 13 | 8
Lg Rank Defense | 26 | 20 |  |  | 2 | 6 | 11 |  | 29 | 26 | 11 | 1 | 17 |  | 5 | 6 | 31 | 10 |  |  |  |  |  | 14 | 2 | 28 | 3 | 4 | 11 | 21
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 | L | OT | 0-1 | @ | Kansas City Chiefs | 27 | 33 | 25 | 388 | 233 | 155 |  | 26 | 413 | 330 | 83 | 1 | 11.8 | -9.06 | -5.97
2 | Sun | 2016-09-18 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-01-01 00:00:00 |  | [NAME] | 38 | 14 | 25 | 357 | 207 | 150 | 1 | 20 | 388 | 319 | 69 | 3 | 15.37 | 2.12 | 7.37
3 | Sun | 2016-09-25 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-02 00:00:00 | @ | Indianapolis Colts | 22 | 26 | 17 | 352 | 315 | 37 | 3 | 24 | 410 | 317 | 93 | 2 | -4.64 | 2.59 | -4.12
4 | Sun | 2016-10-02 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-03 00:00:00 |  | New Orleans Saints | 34 | 35 | 21 | 346 | 308 | 38 | 3 | 21 | 275 | 192 | 83 | 2 | 0.8 | -2.87 | 0.15
5 | Sun | 2016-10-09 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-04 00:00:00 | @ | Oakland Raiders | 31 | 34 | 17 | 423 | 351 | 72 | 4 | 19 | 389 | 300 | 89 | 1 | 7.38 | -7.26 | -2.71
6 | Thu | 2016-10-13 00:00:00 | 8:25PM ET | boxscore | W |  | 2016-02-04 00:00:00 |  | Denver Broncos | 21 | 13 | 16 | 265 | 166 | 99 | 2 | 16 | 304 | 220 | 84 | 2 | -0.16 | 15.82 | -3.49
7 | Sun | 2016-10-23 00:00:00 | [NAME] | boxscore | W | OT | 2016-03-04 00:00:00 | @ | Atlanta Falcons | 33 | 30 | 26 | 426 | 348 | 78 | 2 | 21 | 386 | 256 | 130 | 1 | 7.16 | -5.36 | 3.95
8 | Sun | 2016-10-30 00:00:00 | [NAME] | boxscore | L |  | 2016-03-05 00:00:00 | @ | Denver Broncos | 19 | 27 | 21 | 369 | 246 | 123 | 3 | 15 | 324 | 267 | 57 | 3 | -23.84 | 15.82 | -1.58
9 | Sun | 2016-11-06 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-04-05 00:00:00 |  | Tennessee Titans | 43 | 35 | 31 | 476 | 268 | 208 |  | 24 | 393 | 313 | 80 | 3 | 19.87 | -3.77 | -5.17
10 | Sun | 2016-11-13 00:00:00 | [NAME] | boxscore | L |  | 2016-04-06 00:00:00 |  | [NAME] | 24 | 31 | 29 | 379 | 309 | 70 | 4 | 17 | 337 | 231 | 106 | 1 | -2.97 | -11.95 | 7.25
11 |  |  |  |  |  |  |  |  | Bye Week
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-06 00:00:00 | @ | Houston Texans | 21 | 13 | 18 | 302 | 235 | 67 | 1 | 22 | 353 | 239 | 114 | 4 | 5.09 | 6.62 | -5.23
13 | Sun | 2016-12-04 00:00:00 | 4:25PM ET | preview |  |  |  |  | Tampa Bay Buccaneers
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Carolina Panthers
15 | Sun | 2016-12-18 00:00:00 | 4:25PM ET | preview |  |  |  |  | Oakland Raiders
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  | @ | [NAME]
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  |  | Kansas City Chiefs