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

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 | 293 | 4248 | 710 | 6 | 8 | 7 | 248 | 251 | 371 | 2974 | 22 | 1 | 7.6 | 141 | 319 | 1274 | 13 | 4 | 77 | 66 | 611 | 30 | 120 | 42.5 | 5.8 | Own 30.4 | 02:46:00 | 6.32 | 35.4 | 2.44
Opp. Stats | 197 | 3885 | 708 | 5.5 | 11 | 6 | 225 | 260 | 414 | 2790 | 16 | 5 | 6.4 | 143 | 272 | 1095 | 6 | 4 | 62 | 81 | 654 | 20 | 119 | 31.1 | 7.6 | Own 24.3 | 02:45:00 | 6.3 | 32.4 | 1.67
Lg Rank Offense | 6 | 6 |  |  | 2 | 19 | 6 |  | 27 | 6 | 8 | 1 | 4 |  | 5 | 7 | 4 | 20 |  |  |  |  |  | 6 | 30 | 5 | 9 | 9 | 5 | 4
Lg Rank Defense | 3 | 14 |  |  | 23 | 16 | 11 |  | 25 | 18 | 11 | 28 | 12 |  | 13 | 13 | 7 | 11 |  |  |  |  |  | 25 | 27 | 1 | 22 | 26 | 19 | 8
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 | 7:30PM ET | boxscore | W |  | 2000-01-01 00:00:00 | @ | Arizona Cardinals | 23 | 21 | 19 | 363 | 257 | 106 | 2 | 21 | 344 | 252 | 92 |  | 5.61 | -11.42 | 9.08
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | W |  | 2000-02-01 00:00:00 |  | [NAME] | 31 | 24 | 29 | 463 | 302 | 161 | 1 | 23 | 457 | 387 | 70 | 4 | 17.47 | -6.98 | -3.95
3 | Thu | 2016-09-22 00:00:00 | 8:26PM ET | boxscore | W |  | 2000-03-01 00:00:00 |  | Houston Texans | 27 | 0 | 15 | 282 | 97 | 185 |  | 19 | 284 | 175 | 109 | 3 | 1.19 | 14.6 | 10.11
4 | Sun | 2016-10-02 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-03-01 00:00:00 |  | Buffalo Bills | 0 | 16 | 13 | 277 | 187 | 90 | 1 | 24 | 378 | 244 | 134 |  | -10.11 | -6.11 | 3.66
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-04-01 00:00:00 | @ | [NAME] | 33 | 13 | 24 | 501 | 403 | 98 |  | 17 | 262 | 235 | 27 | 1 | 17.05 | 4.26 | -3.15
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-05-01 00:00:00 |  | Cincinnati Bengals | 35 | 17 | 25 | 437 | 358 | 79 |  | 20 | 357 | 237 | 120 |  | 21.68 | -8.15 | 3.28
7 | Sun | 2016-10-23 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-06-01 00:00:00 | @ | Pittsburgh Steelers | 27 | 16 | 21 | 362 | 222 | 140 | 2 | 17 | 375 | 281 | 94 | 1 | 12.52 | 4.28 | -6.81
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-07-01 00:00:00 | @ | Buffalo Bills | 41 | 25 | 23 | 357 | 285 | 72 |  | 25 | 376 | 209 | 167 |  | 22.71 | -13.72 | 6.16
9 |  |  |  |  |  |  |  |  | Bye Week
10 | Sun | 2016-11-13 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-07-02 00:00:00 |  | [NAME] | 24 | 31 | 25 | 385 | 304 | 81 | 2 | 23 | 420 | 324 | 96 |  | 11.93 | -17.85 | -1.92
11 | Sun | 2016-11-20 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-08-02 00:00:00 | @ | San Francisco 49ers | 30 | 17 | 28 | 444 | 273 | 171 |  | 20 | 299 | 177 | 122 |  | 17.09 | -1.68 | 1.82
12 | Sun | 2016-11-27 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-09-02 00:00:00 | @ | New York Jets | 22 | 17 | 26 | 377 | 286 | 91 |  | 16 | 333 | 269 | 64 | 2 | 11.44 | -0.93 | -2.73
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  |  | Los Angeles Rams
14 | Mon | 2016-12-12 00:00:00 | 8:30PM ET | preview |  |  |  |  | Baltimore Ravens
15 | Sun | 2016-12-18 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Denver Broncos
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | New York Jets
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | [NAME]