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

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 | 281 | 3739 | 677 | 5.5 | 6 | 2 | 217 | 195 | 319 | 2008 | 11 | 4 | 5.7 | 100 | 327 | 1731 | 20 | 5.3 | 94 | 87 | 764 | 23 | 119 | 37.8 | 5 | Own 30.3 | 02:42:00 | 6.09 | 31.1 | 2.18
Opp. Stats | 236 | 3761 | 696 | 5.4 | 14 | 6 | 234 | 217 | 357 | 2505 | 13 | 8 | 6.4 | 132 | 306 | 1256 | 13 | 4.1 | 75 | 85 | 693 | 27 | 123 | 35.8 | 10.6 | Own 27.1 | 02:45:00 | 6.1 | 30.3 | 1.92
Lg Rank Offense | 8 | 18 |  |  | 1 | 1 | 18 |  | 32 | 32 | 30 | 4 | 27 |  | 2 | 1 | 1 | 1 |  |  |  |  |  | 13 | 31 | 6 | 13 | 16 | 15 | 10
Lg Rank Defense | 12 | 10 |  |  | 14 | 16 | 26 |  | 2 | 8 | 6 | 16 | 13 |  | 25 | 21 | 26 | 13 |  |  |  |  |  | 16 | 17 | 10 | 22 | 14 | 13 | 17
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:04PM ET | boxscore | L |  | 0-1 | @ | Baltimore Ravens | 7 | 13 | 11 | 160 | 95 | 65 |  | 18 | 308 | 225 | 83 | 1 | -7.45 | 5.23 | -3.59
2 | Thu | 2016-09-15 00:00:00 | 8:26PM ET | boxscore | L |  | 0-2 |  | New York Jets | 31 | 37 | 16 | 393 | 307 | 86 | 1 | 28 | 493 | 370 | 123 | 1 | 12.87 | -20.54 | 3.13
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-01-02 00:00:00 |  | Arizona Cardinals | 33 | 18 | 16 | 297 | 89 | 208 | 1 | 25 | 348 | 260 | 88 | 5 | -2.34 | 20.9 | -5.33
4 | Sun | 2016-10-02 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-02 00:00:00 | @ | New England Patriots | 16 | 0 | 24 | 378 | 244 | 134 |  | 13 | 277 | 187 | 90 | 1 | 6.11 | 10.11 | -3.66
5 | Sun | 2016-10-09 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-03-02 00:00:00 | @ | Los Angeles Rams | 30 | 19 | 15 | 305 | 112 | 193 |  | 23 | 345 | 243 | 102 | 3 | 5.28 | 8.61 | -0.71
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-04-02 00:00:00 |  | San Francisco 49ers | 45 | 16 | 29 | 492 | 179 | 313 | 2 | 16 | 300 | 167 | 133 | 1 | 19.86 | 6.77 | 2.66
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-04-03 00:00:00 | @ | [NAME] | 25 | 28 | 16 | 267 | 200 | 67 |  | 26 | 454 | 198 | 256 |  | 4.44 | -16.07 | 6.19
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-04-04 00:00:00 |  | New England Patriots | 25 | 41 | 25 | 376 | 209 | 167 |  | 23 | 357 | 285 | 72 |  | 13.72 | -22.71 | -6.16
9 | Mon | 2016-11-07 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-04-05 00:00:00 | @ | [NAME] | 25 | 31 | 30 | 425 | 263 | 162 | 1 | 19 | 278 | 245 | 33 |  | 11.47 | -13.91 | -4.47
10 |  |  |  |  |  |  |  |  | Bye Week
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-05 00:00:00 | @ | Cincinnati Bengals | 16 | 12 | 20 | 342 | 159 | 183 | 1 | 23 | 300 | 207 | 93 | 2 | -1.34 | 2.67 | 0.37
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-06-05 00:00:00 |  | [NAME] | 28 | 21 | 15 | 304 | 151 | 153 |  | 20 | 301 | 118 | 183 |  | 15.22 | -6.53 | 0.68
13 | Sun | 2016-12-04 00:00:00 | [NAME] | preview |  |  |  | @ | Oakland Raiders
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Pittsburgh Steelers
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  |  | [NAME]
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | [NAME]
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | New York Jets