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

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 | 231 | 3695 | 681 | 5.4 | 19 | 9 | 203 | 261 | 413 | 2821 | 20 | 10 | 6.6 | 134 | 254 | 874 | 5 | 3.4 | 49 | 62 | 645 | 20 | 131 | 29 | 13 | Own 26.6 | 02:16:00 | 5.63 | 28.2 | 1.63
Opp. Stats | 213 | 3892 | 760 | 5.1 | 14 | 4 | 218 | 268 | 457 | 2912 | 10 | 10 | 6 | 138 | 278 | 980 | 9 | 3.5 | 62 | 79 | 622 | 18 | 134 | 34.3 | 9.7 | Own 29.7 | 02:43:00 | 6.2 | 29 | 1.6
Lg Rank Offense | 21 | 21 |  |  | 25 | 28 | 26 |  | 10 | 12 | 10 | 21 | 12 |  | 27 | 31 | 25 | 30 |  |  |  |  |  | 29 | 10 | 27 | 31 | 30 | 25 | 26
Lg Rank Defense | 6 | 16 |  |  | 14 | 22 | 10 |  | 31 | 24 | 2 | 8 | 7 |  | 15 | 5 | 15 | 4 |  |  |  |  |  | 21 | 21 | 26 | 16 | 20 | 9 | 6
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 | 4:27PM ET | boxscore | W |  | 2000-01-01 00:00:00 | @ | Dallas Cowboys | 20 | 19 | 18 | 316 | 203 | 113 | 1 | 24 | 328 | 227 | 101 |  | 9.23 | -6.65 | -2.24
2 | Sun | 2016-09-18 00:00:00 | 1:03PM ET | boxscore | W |  | 2000-02-01 00:00:00 |  | New Orleans Saints | 16 | 13 | 22 | 417 | 353 | 64 | 3 | 16 | 288 | 247 | 41 |  | -2.94 | 3.72 | 1.95
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-02-01 00:00:00 |  | Washington Redskins | 27 | 29 | 28 | 457 | 337 | 120 | 3 | 20 | 403 | 313 | 90 | 1 | 7.82 | -12.07 | -1.86
4 | Mon | 2016-10-03 00:00:00 | 8:35PM ET | boxscore | L |  | 2016-02-02 00:00:00 | @ | Minnesota Vikings | 10 | 24 | 18 | 339 | 261 | 78 | 2 | 22 | 366 | 262 | 104 |  | -6.33 | -8.88 | 0.73
5 | Sun | 2016-10-09 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-02-03 00:00:00 | @ | Green Bay Packers | 16 | 23 | 14 | 221 | 178 | 43 | 1 | 23 | 406 | 259 | 147 | 2 | -9.52 | -3.45 | 6.36
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-03 00:00:00 |  | Baltimore Ravens | 27 | 23 | 19 | 435 | 397 | 38 | 3 | 22 | 391 | 293 | 98 |  | 7.59 | -3.23 | -2.8
7 | Sun | 2016-10-23 00:00:00 | 9:31AM ET | boxscore | W |  | 2016-04-03 00:00:00 | @ | Los Angeles Rams | 17 | 10 | 13 | 232 | 196 | 36 | 1 | 20 | 345 | 271 | 74 | 4 | -9.64 | 15.23 | 0.3
8 |  |  |  |  |  |  |  |  | Bye Week
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-03 00:00:00 |  | Philadelphia Eagles | 28 | 23 | 16 | 302 | 248 | 54 | 2 | 21 | 443 | 347 | 96 | 2 | -3.81 | 7.88 | 0.29
10 | Mon | 2016-11-14 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-06-03 00:00:00 |  | Cincinnati Bengals | 21 | 20 | 23 | 351 | 229 | 122 | 2 | 12 | 264 | 186 | 78 | 1 | 1.25 | 5.97 | -4.9
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-07-03 00:00:00 |  | Chicago Bears | 22 | 16 | 19 | 329 | 227 | 102 |  | 17 | 315 | 222 | 93 | 1 | 7.75 | -2.68 | -0.88
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-08-03 00:00:00 | @ | [NAME] | 27 | 13 | 13 | 296 | 192 | 104 | 1 | 21 | 343 | 285 | 58 | 3 | 0.78 | 17.45 | -2.08
13 | Sun | 2016-12-04 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Pittsburgh Steelers
14 | Sun | 2016-12-11 00:00:00 | 8:30PM ET | preview |  |  |  |  | Dallas Cowboys
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  |  | Detroit Lions
16 | Thu | 2016-12-22 00:00:00 | 8:25PM ET | preview |  |  |  | @ | Philadelphia Eagles
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Washington Redskins