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

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 | 196 | 3686 | 682 | 5.4 | 22 | 7 | 202 | 219 | 378 | 2462 | 12 | 15 | 6.2 | 118 | 282 | 1224 | 8 | 4.3 | 60 | 67 | 557 | 24 | 121 | 31.4 | 17.4 | Own 26.2 | 02:48:00 | 6.04 | 30.6 | 1.64
Opp. Stats | 266 | 3836 | 697 | 5.5 | 9 | 3 | 226 | 264 | 412 | 2891 | 18 | 6 | 6.7 | 151 | 266 | 945 | 6 | 3.6 | 55 | 56 | 508 | 20 | 121 | 37.2 | 6.6 | Own 28.3 | 02:39:00 | 6.2 | 31.6 | 1.91
Lg Rank Offense | 28 | 22 |  |  | 30 | 19 | 27 |  | 25 | 25 | 24 | 32 | 20 |  | 15 | 12 | 17 | 10 |  |  |  |  |  | 21 | 1 | 28 | 7 | 22 | 16 | 25
Lg Rank Defense | 21 | 12 |  |  | 29 | 27 | 14 |  | 24 | 22 | 17 | 25 | 23 |  | 11 | 4 | 7 | 5 |  |  |  |  |  | 13 | 30 | 20 | 13 | 17 | 17 | 16
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 |  | 0-1 |  | Cincinnati Bengals | 22 | 23 | 22 | 340 | 188 | 152 | 1 | 18 | 381 | 324 | 57 | 1 | 6.23 | -10.02 | -0.57
2 | Thu | 2016-09-15 00:00:00 | 8:26PM ET | boxscore | W |  | 2016-01-01 00:00:00 | @ | Buffalo Bills | 37 | 31 | 28 | 493 | 370 | 123 | 1 | 16 | 393 | 307 | 86 | 1 | 20.54 | -12.87 | -3.13
3 | Sun | 2016-09-25 00:00:00 | 4:26PM ET | boxscore | L |  | 2016-01-02 00:00:00 | @ | Kansas City Chiefs | 3 | 24 | 17 | 305 | 188 | 117 | 8 | 18 | 293 | 221 | 72 | 1 | -21.82 | 5.73 | -1.35
4 | Sun | 2016-10-02 00:00:00 | 1:03PM ET | boxscore | L |  | 2016-01-03 00:00:00 |  | [NAME] | 17 | 27 | 20 | 305 | 247 | 58 | 3 | 21 | 354 | 288 | 66 |  | 1.16 | -9.58 | -2.47
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-04 00:00:00 | @ | Pittsburgh Steelers | 13 | 31 | 16 | 316 | 244 | 72 |  | 30 | 436 | 375 | 61 | 1 | -0.46 | -15.65 | -3.39
6 | Mon | 2016-10-17 00:00:00 | 7:30PM ET | boxscore | L |  | 2016-01-05 00:00:00 | @ | Arizona Cardinals | 3 | 28 | 11 | 230 | 197 | 33 | 2 | 28 | 396 | 225 | 171 |  | -12.37 | -20.59 | 5.45
7 | Sun | 2016-10-23 00:00:00 | 1:04PM ET | boxscore | W |  | 2016-02-05 00:00:00 |  | Baltimore Ravens | 24 | 16 | 16 | 344 | 189 | 155 | 2 | 11 | 245 | 234 | 11 | 3 | -3.23 | 22.09 | -11.51
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-05 00:00:00 | @ | [NAME] | 31 | 28 | 21 | 393 | 222 | 171 |  | 22 | 407 | 339 | 68 | 2 | 14.63 | -10.82 | 0.51
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-03-06 00:00:00 | @ | [NAME] | 23 | 27 | 18 | 331 | 191 | 140 | 2 | 20 | 274 | 137 | 137 |  | 4.15 | -5.84 | -6.23
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-03-07 00:00:00 |  | Los Angeles Rams | 6 | 9 | 17 | 296 | 157 | 139 | 1 | 16 | 280 | 155 | 125 |  | -2.43 | 5.79 | -3.9
11 |  |  |  |  |  |  |  |  | Bye Week
12 | Sun | 2016-11-27 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-03-08 00:00:00 |  | New England Patriots | 17 | 22 | 16 | 333 | 269 | 64 | 2 | 26 | 377 | 286 | 91 |  | 0.93 | -11.44 | 2.73
13 | Mon | 2016-12-05 00:00:00 | 8:30PM ET | preview |  |  |  |  | Indianapolis Colts
14 | Sun | 2016-12-11 00:00:00 | [NAME] | preview |  |  |  | @ | San Francisco 49ers
15 | Sat | 2016-12-17 00:00:00 | 8:25PM ET | preview |  |  |  |  | [NAME]
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  | @ | New England Patriots
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | Buffalo Bills