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

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 | 307 | 4301 | 725 | 5.9 | 9 | 4 | 235 | 281 | 424 | 3065 | 22 | 5 | 7 | 145 | 289 | 1236 | 12 | 4.3 | 63 | 105 | 867 | 27 | 134 | 40.3 | 6.7 | Own 30.9 | 02:38:00 | 5.84 | 32 | 2.22
Opp. Stats | 275 | 4294 | 689 | 6.2 | 19 | 9 | 228 | 240 | 394 | 3008 | 20 | 10 | 7.3 | 133 | 278 | 1286 | 12 | 4.6 | 67 | 83 | 807 | 28 | 130 | 38.5 | 13.1 | Own 25.8 | 02:28:00 | 5.7 | 33.1 | 2.14
Lg Rank Offense | 4 | 5 |  |  | 6 | 6 | 11 |  | 7 | 4 | 8 | 6 | 7 |  | 13 | 10 | 5 | 15 |  |  |  |  |  | 9 | 28 | 1 | 19 | 26 | 11 | 9
Lg Rank Defense | 23 | 29 |  |  | 6 | 6 | 21 |  | 17 | 28 | 20 | 8 | 30 |  | 15 | 26 | 25 | 30 |  |  |  |  |  | 11 | 7 | 2 | 5 | 5 | 25 | 23
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 | @ | New Orleans Saints | 35 | 34 | 25 | 486 | 319 | 167 |  | 27 | 507 | 419 | 88 | 1 | 24.52 | -25.79 | 7.78
2 | Sun | 2016-09-18 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-01 00:00:00 |  | Atlanta Falcons | 28 | 35 | 29 | 454 | 299 | 155 |  | 27 | 528 | 389 | 139 | 1 | 20.41 | -24.77 | -3.37
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-01 00:00:00 | @ | Tennessee Titans | 17 | 10 | 17 | 368 | 245 | 123 | 1 | 19 | 393 | 212 | 181 | 3 | 1.85 | 8.38 | -0.77
4 | Sun | 2016-10-02 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-01 00:00:00 | @ | Baltimore Ravens | 28 | 27 | 13 | 261 | 199 | 62 | 1 | 25 | 412 | 282 | 130 | 1 | -6.63 | 0.15 | 8.3
5 | Sun | 2016-10-09 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-04-01 00:00:00 |  | San Diego Chargers | 34 | 31 | 19 | 389 | 300 | 89 | 1 | 17 | 423 | 351 | 72 | 4 | 7.26 | -7.38 | 2.71
6 | Sun | 2016-10-16 00:00:00 | [NAME] | boxscore | L |  | 2016-04-02 00:00:00 |  | Kansas City Chiefs | 10 | 26 | 16 | 285 | 221 | 64 | 2 | 22 | 406 | 223 | 183 |  | -6.31 | -15.86 | 3.04
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-05-02 00:00:00 | @ | [NAME] | 33 | 16 | 21 | 344 | 200 | 144 |  | 19 | 344 | 239 | 105 | 3 | 4.78 | 4.36 | 10.08
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | W | OT | 2016-06-02 00:00:00 | @ | Tampa Bay Buccaneers | 30 | 24 | 27 | 626 | 498 | 128 | 1 | 18 | 270 | 168 | 102 |  | 18.11 | -5.09 | -8.18
9 | Sun | 2016-11-06 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-07-02 00:00:00 |  | Denver Broncos | 30 | 20 | 30 | 397 | 179 | 218 |  | 13 | 299 | 266 | 33 | 2 | 12.98 | 1.52 | -4.65
10 |  |  |  |  |  |  |  |  | Bye Week
11 | Mon | 2016-11-21 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-08-02 00:00:00 |  | Houston Texans | 27 | 20 | 16 | 325 | 295 | 30 | 1 | 22 | 354 | 230 | 124 | 2 | 12.48 | -5.77 | 4.89
12 | Sun | 2016-11-27 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-09-02 00:00:00 |  | Carolina Panthers | 35 | 32 | 22 | 366 | 310 | 56 | 2 | 19 | 358 | 229 | 129 | 2 | 3.04 | -3.35 | 3.44
13 | Sun | 2016-12-04 00:00:00 | [NAME] | preview |  |  |  |  | Buffalo Bills
14 | Thu | 2016-12-08 00:00:00 | 8:25PM ET | preview |  |  |  | @ | Kansas City Chiefs
15 | Sun | 2016-12-18 00:00:00 | 4:25PM ET | preview |  |  |  | @ | San Diego Chargers
16 | Sat | 2016-12-24 00:00:00 | [NAME] | preview |  |  |  |  | Indianapolis Colts
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Denver Broncos