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

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 | 254 | 3696 | 713 | 5.2 | 13 | 5 | 221 | 249 | 393 | 2432 | 11 | 8 | 5.8 | 126 | 295 | 1264 | 11 | 4.3 | 77 | 90 | 707 | 18 | 123 | 38.2 | 10.6 | Own 30.5 | 02:52:00 | 6.33 | 29.8 | 1.86
Opp. Stats | 213 | 3733 | 670 | 5.6 | 16 | 7 | 206 | 226 | 379 | 2602 | 17 | 9 | 6.4 | 116 | 265 | 1131 | 6 | 4.3 | 65 | 74 | 581 | 25 | 128 | 30.5 | 11.7 | Own 27.7 | 02:27:00 | 5.7 | 29 | 1.63
Lg Rank Offense | 15 | 20 |  |  | 13 | 9 | 17 |  | 18 | 27 | 30 | 13 | 25 |  | 10 | 8 | 8 | 13 |  |  |  |  |  | 12 | 17 | 4 | 6 | 8 | 19 | 15
Lg Rank Defense | 6 | 8 |  |  | 10 | 11 | 5 |  | 7 | 11 | 13 | 14 | 14 |  | 9 | 16 | 7 | 21 |  |  |  |  |  | 27 | 11 | 16 | 4 | 6 | 10 | 7
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 |  | [NAME] | 29 | 10 | 23 | 403 | 270 | 133 |  | 14 | 288 | 168 | 120 | 1 | 8.45 | 8.11 | -3.33
2 | Mon | 2016-09-19 00:00:00 | 8:30PM ET | boxscore | W |  | 2000-02-01 00:00:00 | @ | Chicago Bears | 29 | 14 | 21 | 280 | 180 | 100 |  | 16 | 284 | 220 | 64 | 3 | 1.68 | 12.47 | 4.91
3 | Sun | 2016-09-25 00:00:00 | 4:25PM ET | boxscore | W |  | 2000-03-01 00:00:00 |  | Pittsburgh Steelers | 34 | 3 | 25 | 426 | 301 | 125 |  | 15 | 251 | 222 | 29 | 2 | 22.12 | 10.46 | -0.94
4 |  |  |  |  |  |  |  |  | Bye Week
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-03-01 00:00:00 | @ | Detroit Lions | 23 | 24 | 18 | 346 | 230 | 116 | 2 | 21 | 244 | 164 | 80 | 1 | 4.42 | -8.49 | 2.7
6 | Sun | 2016-10-16 00:00:00 | 1:03PM ET | boxscore | L |  | 2016-03-02 00:00:00 | @ | Washington Redskins | 20 | 27 | 12 | 239 | 145 | 94 |  | 26 | 493 | 263 | 230 | 1 | -4.9 | -12.56 | 7.31
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-04-02 00:00:00 |  | Minnesota Vikings | 21 | 10 | 15 | 239 | 138 | 101 | 4 | 18 | 282 | 189 | 93 | 4 | -16.68 | 22.62 | 4.42
8 | Sun | 2016-10-30 00:00:00 | 8:31PM ET | boxscore | L | OT | 2016-04-03 00:00:00 | @ | Dallas Cowboys | 23 | 29 | 21 | 291 | 194 | 97 | 1 | 26 | 460 | 273 | 187 | 1 | -3.91 | -6.81 | 6.68
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-04-04 00:00:00 | @ | New York Giants | 23 | 28 | 21 | 443 | 347 | 96 | 2 | 16 | 302 | 248 | 54 | 2 | -7.88 | 3.81 | -0.29
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-04 00:00:00 |  | Atlanta Falcons | 24 | 15 | 25 | 429 | 221 | 208 | 1 | 11 | 303 | 255 | 48 | 1 | 2.75 | 5.49 | -2.21
11 | Sun | 2016-11-20 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-05-05 00:00:00 | @ | [NAME] | 15 | 26 | 20 | 308 | 195 | 113 | 2 | 18 | 439 | 287 | 152 |  | -6.79 | -9.58 | 2.71
12 | Mon | 2016-11-28 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-05-06 00:00:00 |  | Green Bay Packers | 13 | 27 | 20 | 292 | 211 | 81 | 1 | 25 | 387 | 313 | 74 |  | 4.55 | -22.27 | 2.5
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Cincinnati Bengals
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Washington Redskins
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Baltimore Ravens
16 | Thu | 2016-12-22 00:00:00 | 8:25PM ET | preview |  |  |  |  | New York Giants
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | Dallas Cowboys