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

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 | 334 | 4775 | 765 | 6.2 | 16 | 8 | 277 | 327 | 457 | 3514 | 31 | 8 | 7.4 | 188 | 290 | 1261 | 10 | 4.3 | 73 | 66 | 607 | 16 | 127 | 44.9 | 11.8 | Own 27.1 | 02:44:00 | 6.43 | 37.8 | 2.64
Opp. Stats | 307 | 4075 | 705 | 5.8 | 17 | 10 | 234 | 254 | 403 | 2985 | 17 | 7 | 7 | 152 | 280 | 1090 | 13 | 3.9 | 65 | 68 | 599 | 17 | 124 | 41.9 | 13.7 | Own 30.3 | 02:32:00 | 6.1 | 32.8 | 2.23
Lg Rank Offense | 2 | 1 |  |  | 18 | 25 | 1 |  | 2 | 1 | 1 | 13 | 5 |  | 11 | 9 | 13 | 9 |  |  |  |  |  | 4 | 14 | 23 | 10 | 6 | 3 | 3
Lg Rank Defense | 30 | 26 |  |  | 9 | 3 | 26 |  | 21 | 27 | 13 | 19 | 28 |  | 18 | 12 | 26 | 9 |  |  |  |  |  | 5 | 6 | 29 | 8 | 16 | 21 | 26
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 |  | Oakland Raiders | 34 | 35 | 27 | 507 | 419 | 88 | 1 | 25 | 486 | 319 | 167 |  | 25.79 | -24.52 | -7.78
2 | Sun | 2016-09-18 00:00:00 | 1:03PM ET | boxscore | L |  | 0-2 | @ | New York Giants | 13 | 16 | 16 | 288 | 247 | 41 |  | 22 | 417 | 353 | 64 | 3 | -3.72 | 2.94 | -1.95
3 | Mon | 2016-09-26 00:00:00 | 8:30PM ET | boxscore | L |  | 0-3 |  | Atlanta Falcons | 32 | 45 | 32 | 474 | 359 | 115 | 2 | 26 | 442 | 225 | 217 |  | 12.19 | -29.68 | 1.52
4 | Sun | 2016-10-02 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-01-03 00:00:00 | @ | San Diego Chargers | 35 | 34 | 21 | 275 | 192 | 83 | 2 | 21 | 346 | 308 | 38 | 3 | 2.87 | -0.8 | -0.15
5 |  |  |  |  |  |  |  |  | Bye Week
6 | Sun | 2016-10-16 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-02-03 00:00:00 |  | Carolina Panthers | 41 | 38 | 23 | 523 | 460 | 63 | 1 | 32 | 406 | 303 | 103 | 2 | 22.49 | -19.19 | -0.27
7 | Sun | 2016-10-23 00:00:00 | 1:03PM ET | boxscore | L |  | 2016-02-04 00:00:00 | @ | Kansas City Chiefs | 21 | 27 | 27 | 463 | 359 | 104 | 2 | 20 | 326 | 214 | 112 |  | 8.79 | -10.51 | -0.37
8 | Sun | 2016-10-30 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-03-04 00:00:00 |  | [NAME] | 25 | 20 | 28 | 375 | 252 | 123 | 1 | 15 | 359 | 285 | 74 | 1 | 6.08 | -2.63 | -1.04
9 | Sun | 2016-11-06 00:00:00 | [NAME] | boxscore | W |  | 2016-04-04 00:00:00 | @ | San Francisco 49ers | 41 | 23 | 29 | 571 | 323 | 248 |  | 19 | 486 | 393 | 93 | 4 | 29.46 | 3.2 | -11.54
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-04-05 00:00:00 |  | Denver Broncos | 23 | 25 | 19 | 373 | 293 | 80 | 4 | 24 | 337 | 234 | 103 | 2 | 0.99 | 1.05 | -2.07
11 | Thu | 2016-11-17 00:00:00 | 8:25PM ET | boxscore | L |  | 2016-04-06 00:00:00 | @ | Carolina Panthers | 20 | 23 | 28 | 371 | 264 | 107 | 2 | 17 | 223 | 173 | 50 |  | 6.16 | 4.79 | -11.38
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-06 00:00:00 |  | Los Angeles Rams | 49 | 21 | 27 | 555 | 346 | 209 | 1 | 13 | 247 | 178 | 69 | 2 | 29.28 | 9.75 | -3.18
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  |  | Detroit Lions
14 | Sun | 2016-12-11 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Tampa Bay Buccaneers
15 | Sun | 2016-12-18 00:00:00 | [NAME] | preview |  |  |  | @ | Arizona Cardinals
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | Tampa Bay Buccaneers
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Atlanta Falcons