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

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 | 266 | 4013 | 694 | 5.8 | 10 | 2 | 222 | 271 | 422 | 2903 | 24 | 8 | 6.7 | 147 | 258 | 1110 | 8 | 4.3 | 57 | 74 | 716 | 18 | 125 | 35.2 | 8 | Own 27.8 | 02:38:00 | 6.06 | 32 | 2.08
Opp. Stats | 222 | 3946 | 689 | 5.7 | 14 | 7 | 215 | 267 | 415 | 2898 | 13 | 7 | 6.6 | 132 | 250 | 1048 | 10 | 4.2 | 59 | 78 | 632 | 24 | 122 | 34.4 | 10.7 | Own 27.2 | 02:43:00 | 6.2 | 32.4 | 1.79
Lg Rank Offense | 13 | 12 |  |  | 9 | 1 | 16 |  | 8 | 8 | 4 | 13 | 11 |  | 26 | 18 | 17 | 12 |  |  |  |  |  | 17 | 23 | 16 | 19 | 19 | 10 | 13
Lg Rank Defense | 10 | 19 |  |  | 14 | 11 | 7 |  | 26 | 23 | 6 | 19 | 20 |  | 4 | 9 | 21 | 17 |  |  |  |  |  | 20 | 16 | 11 | 16 | 18 | 20 | 13
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 | Mon | 2016-09-12 00:00:00 | 7:11PM ET | boxscore | W |  | 2000-01-01 00:00:00 | @ | Washington Redskins | 38 | 16 | 23 | 437 | 290 | 147 | 1 | 18 | 384 | 329 | 55 | 2 | 22.31 | 4.94 | -0.19
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | W |  | 2000-02-01 00:00:00 |  | Cincinnati Bengals | 24 | 16 | 19 | 374 | 250 | 124 | 2 | 21 | 412 | 366 | 46 | 2 | 3.03 | 5.93 | 2.88
3 | Sun | 2016-09-25 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-02-01 00:00:00 | @ | Philadelphia Eagles | 3 | 34 | 15 | 251 | 222 | 29 | 2 | 25 | 426 | 301 | 125 |  | -10.46 | -22.12 | 0.94
4 | Sun | 2016-10-02 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-03-01 00:00:00 |  | Kansas City Chiefs | 43 | 14 | 18 | 436 | 287 | 149 |  | 22 | 357 | 270 | 87 | 2 | 15.53 | 3.86 | 4.24
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-04-01 00:00:00 |  | New York Jets | 31 | 13 | 30 | 436 | 375 | 61 | 1 | 16 | 316 | 244 | 72 |  | 15.65 | 0.46 | 3.39
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-04-02 00:00:00 | @ | [NAME] | 15 | 30 | 15 | 297 | 169 | 128 | 2 | 24 | 474 | 252 | 222 |  | -3.5 | -19.26 | 5.2
7 | Sun | 2016-10-23 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-04-03 00:00:00 |  | New England Patriots | 16 | 27 | 17 | 375 | 281 | 94 | 1 | 21 | 362 | 222 | 140 | 2 | -4.28 | -12.52 | 6.81
8 |  |  |  |  |  |  |  |  | Bye Week
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-04-04 00:00:00 | @ | Baltimore Ravens | 14 | 21 | 15 | 277 | 241 | 36 | 1 | 13 | 274 | 224 | 50 | 1 | -13.13 | 13.91 | -9.54
10 | Sun | 2016-11-13 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-04-05 00:00:00 |  | Dallas Cowboys | 30 | 35 | 30 | 448 | 400 | 48 |  | 20 | 422 | 295 | 127 | 1 | 21.01 | -13.5 | -10.13
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-05-05 00:00:00 | @ | [NAME] | 24 | 9 | 24 | 313 | 167 | 146 |  | 17 | 209 | 176 | 33 | 2 | 8.07 | 1.22 | 1.71
12 | Thu | 2016-11-24 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-06-05 00:00:00 | @ | Indianapolis Colts | 28 | 7 | 16 | 369 | 221 | 148 |  | 18 | 310 | 219 | 91 | 2 | 17.02 | 1.12 | -0.14
13 | Sun | 2016-12-04 00:00:00 | 4:25PM ET | preview |  |  |  |  | New York Giants
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Buffalo Bills
15 | Sun | 2016-12-18 00:00:00 | 8:30PM ET | preview |  |  |  | @ | Cincinnati Bengals
16 | Sun | 2016-12-25 00:00:00 | 4:30PM ET | preview |  |  |  |  | Baltimore Ravens
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | [NAME]