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

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 | 280 | 4690 | 727 | 6.5 | 12 | 5 | 255 | 300 | 438 | 3463 | 20 | 7 | 7.7 | 167 | 275 | 1227 | 9 | 4.5 | 66 | 79 | 603 | 22 | 116 | 46.6 | 9.5 | Own 27.7 | 03:01:00 | 6.66 | 40.5 | 2.4
Opp. Stats | 264 | 4066 | 695 | 5.9 | 14 | 7 | 250 | 263 | 393 | 2782 | 14 | 7 | 6.6 | 148 | 274 | 1284 | 16 | 4.7 | 76 | 74 | 762 | 26 | 113 | 38.9 | 11.5 | Own 26.9 | 02:53:00 | 6.5 | 35.9 | 2.23
Lg Rank Offense | 9 | 2 |  |  | 12 | 9 | 3 |  | 6 | 2 | 10 | 11 | 2 |  | 18 | 11 | 14 | 6 |  |  |  |  |  | 3 | 18 | 18 | 3 | 3 | 1 | 5
Lg Rank Defense | 18 | 25 |  |  | 14 | 11 | 28 |  | 16 | 16 | 8 | 19 | 21 |  | 14 | 25 | 32 | 31 |  |  |  |  |  | 10 | 13 | 7 | 29 | 28 | 30 | 27
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 | L |  | 0-1 |  | Pittsburgh Steelers | 16 | 38 | 18 | 384 | 329 | 55 | 2 | 23 | 437 | 290 | 147 | 1 | -4.94 | -22.31 | 0.19
2 | Sun | 2016-09-18 00:00:00 | 1:03PM ET | boxscore | L |  | 0-2 |  | Dallas Cowboys | 23 | 27 | 24 | 432 | 350 | 82 | 1 | 24 | 380 | 278 | 102 | 1 | 9.76 | -14.43 | 2.03
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-01-02 00:00:00 | @ | New York Giants | 29 | 27 | 20 | 403 | 313 | 90 | 1 | 28 | 457 | 337 | 120 | 3 | 12.07 | -7.82 | 1.86
4 | Sun | 2016-10-02 00:00:00 | 1:05PM ET | boxscore | W |  | 2016-02-02 00:00:00 |  | [NAME] | 31 | 20 | 24 | 301 | 156 | 145 | 1 | 26 | 380 | 217 | 163 | 3 | 13.4 | -4.68 | -0.33
5 | Sun | 2016-10-09 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-03-02 00:00:00 | @ | Baltimore Ravens | 16 | 10 | 18 | 310 | 250 | 60 | 2 | 18 | 306 | 188 | 118 | 1 | -2.61 | 8.56 | -0.93
6 | Sun | 2016-10-16 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-04-02 00:00:00 |  | Philadelphia Eagles | 27 | 20 | 26 | 493 | 263 | 230 | 1 | 12 | 239 | 145 | 94 |  | 12.56 | 4.9 | -7.31
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-04-03 00:00:00 | @ | Detroit Lions | 17 | 20 | 26 | 413 | 283 | 130 | 2 | 19 | 344 | 250 | 94 |  | 8.7 | -11.55 | -1.85
8 | Sun | 2016-10-30 00:00:00 | 8:36AM ET | boxscore | T |  | 2001-04-03 00:00:00 | @ | Cincinnati Bengals | 27 | 27 | 30 | 546 | 446 | 100 | 1 | 35 | 415 | 263 | 152 | 2 | 16.21 | -13.63 | -7.1
9 |  |  |  |  |  |  |  |  | Bye Week
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2001-05-03 00:00:00 |  | Minnesota Vikings | 26 | 20 | 23 | 388 | 260 | 128 | 1 | 22 | 331 | 284 | 47 | 1 | 9.48 | -3.73 | 1.3
11 | Sun | 2016-11-20 00:00:00 | 8:30PM ET | boxscore | W |  | 2001-06-03 00:00:00 |  | Green Bay Packers | 42 | 24 | 21 | 515 | 364 | 151 |  | 19 | 424 | 340 | 84 | 2 | 30.26 | -10.04 | 1.17
12 | Thu | 2016-11-24 00:00:00 | 4:30PM ET | boxscore | L |  | 2001-06-04 00:00:00 | @ | Dallas Cowboys | 26 | 31 | 25 | 505 | 449 | 56 |  | 24 | 353 | 190 | 163 |  | 24.94 | -19.18 | -11.43
13 | Sun | 2016-12-04 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Arizona Cardinals
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Philadelphia Eagles
15 | Mon | 2016-12-19 00:00:00 | 8:30PM ET | preview |  |  |  |  | Carolina Panthers
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Chicago Bears
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | New York Giants