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

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 | 276 | 3881 | 724 | 5.4 | 21 | 9 | 230 | 225 | 391 | 2677 | 15 | 12 | 6.4 | 139 | 306 | 1204 | 14 | 3.9 | 70 | 73 | 606 | 21 | 130 | 36.2 | 14.6 | Own 28.3 | 02:37:00 | 6.06 | 29.9 | 1.98
Opp. Stats | 281 | 3901 | 715 | 5.5 | 16 | 5 | 226 | 281 | 419 | 3027 | 21 | 11 | 6.7 | 159 | 265 | 874 | 6 | 3.3 | 57 | 81 | 693 | 10 | 135 | 34.8 | 11.9 | Own 27.3 | 02:22:00 | 5.7 | 28.9 | 1.84
Lg Rank Offense | 10 | 14 |  |  | 29 | 28 | 13 |  | 20 | 18 | 18 | 26 | 17 |  | 8 | 13 | 3 | 22 |  |  |  |  |  | 14 | 5 | 14 | 21 | 20 | 18 | 14
Lg Rank Defense | 24 | 17 |  |  | 10 | 18 | 14 |  | 27 | 29 | 26 | 3 | 24 |  | 9 | 2 | 7 | 1 |  |  |  |  |  | 19 | 10 | 12 | 1 | 7 | 8 | 14
 |  |  | 6 | 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 | Thu | 2016-09-08 00:00:00 | 8:40PM ET | boxscore | L |  | 0-1 | @ | Denver Broncos | 20 | 21 | 21 | 333 | 176 | 157 | 1 | 21 | 307 | 159 | 148 | 3 | 6.53 | -4.46 | -3.92
2 | Sun | 2016-09-18 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-01-01 00:00:00 |  | San Francisco 49ers | 46 | 27 | 26 | 529 | 353 | 176 | 4 | 16 | 302 | 237 | 65 | 3 | 10.97 | 13.97 | -5.67
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-02 00:00:00 |  | Minnesota Vikings | 10 | 22 | 18 | 306 | 201 | 105 | 3 | 13 | 211 | 153 | 58 |  | -12.29 | 5.7 | -7.33
4 | Sun | 2016-10-02 00:00:00 | 1:04PM ET | boxscore | L |  | 2016-01-03 00:00:00 | @ | Atlanta Falcons | 33 | 48 | 20 | 378 | 329 | 49 | 2 | 25 | 571 | 481 | 90 | 1 | 3.16 | -22.38 | 3.49
5 | Mon | 2016-10-10 00:00:00 | 8:04PM ET | boxscore | L |  | 2016-01-04 00:00:00 |  | Tampa Bay Buccaneers | 14 | 17 | 20 | 414 | 278 | 136 | 4 | 20 | 315 | 202 | 113 |  | 2.26 | -2.67 | -3.05
6 | Sun | 2016-10-16 00:00:00 | 1:03PM ET | boxscore | L |  | 2016-01-05 00:00:00 | @ | New Orleans Saints | 38 | 41 | 32 | 406 | 303 | 103 | 2 | 23 | 523 | 460 | 63 | 1 | 19.19 | -22.49 | 0.27
7 |  |  |  |  |  |  |  |  | Bye Week
8 | Sun | 2016-10-30 00:00:00 | 12:47PM ET | boxscore | W |  | 2016-02-05 00:00:00 |  | Arizona Cardinals | 30 | 20 | 19 | 349 | 208 | 141 | 1 | 22 | 340 | 316 | 24 | 2 | 1.07 | 6.19 | 3.45
9 | Sun | 2016-11-06 00:00:00 | [NAME] | boxscore | W |  | 2016-03-05 00:00:00 | @ | Los Angeles Rams | 13 | 10 | 16 | 244 | 185 | 59 |  | 18 | 339 | 280 | 59 | 1 | -1.39 | 1.87 | 4.24
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-03-06 00:00:00 |  | Kansas City Chiefs | 17 | 20 | 22 | 341 | 242 | 99 | 2 | 18 | 256 | 165 | 91 | 1 | -1.62 | 3.83 | -5.28
11 | Thu | 2016-11-17 00:00:00 | 8:25PM ET | boxscore | W |  | 2016-04-06 00:00:00 |  | New Orleans Saints | 23 | 20 | 17 | 223 | 173 | 50 |  | 28 | 371 | 264 | 107 | 2 | -4.79 | -6.16 | 11.38
12 | Sun | 2016-11-27 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-04-07 00:00:00 | @ | Oakland Raiders | 32 | 35 | 19 | 358 | 229 | 129 | 2 | 22 | 366 | 310 | 56 | 2 | 3.35 | -3.04 | -3.44
13 | Sun | 2016-12-04 00:00:00 | 8:30PM ET | preview |  |  |  | @ | [NAME]
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | San Diego Chargers
15 | Mon | 2016-12-19 00:00:00 | 8:30PM ET | preview |  |  |  | @ | Washington Redskins
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | Atlanta Falcons
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Tampa Bay Buccaneers