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

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 | 333 | 4748 | 769 | 6.2 | 9 | 7 | 283 | 244 | 360 | 2878 | 19 | 2 | 7.6 | 148 | 391 | 1870 | 20 | 4.8 | 116 | 79 | 652 | 19 | 123 | 48.8 | 7.3 | Own 28.9 | 03:11:00 | 6.76 | 38.6 | 2.73
Opp. Stats | 228 | 4302 | 741 | 5.8 | 11 | 7 | 255 | 338 | 481 | 3315 | 20 | 4 | 6.6 | 177 | 237 | 987 | 5 | 4.2 | 57 | 71 | 576 | 21 | 119 | 37.8 | 8.4 | Own 27.0 | 02:49:00 | 6.8 | 36.1 | 1.97
Lg Rank Offense | 5 | 4 |  |  | 4 | 18 | 2 |  | 30 | 20 | 15 | 2 | 3 |  | 1 | 2 | 2 | 2 |  |  |  |  |  | 2 | 26 | 11 | 1 | 1 | 2 | 2
Lg Rank Defense | 5 | 18 |  |  | 26 | 15 | 25 |  | 30 | 30 | 18 | 30 | 18 |  | 1 | 3 | 3 | 16 |  |  |  |  |  | 12 | 24 | 9 | 26 | 32 | 31 | 19
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 | 4:27PM ET | boxscore | L |  | 0-1 |  | New York Giants | 19 | 20 | 24 | 328 | 227 | 101 |  | 18 | 316 | 203 | 113 | 1 | 6.65 | -9.23 | 2.24
2 | Sun | 2016-09-18 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-01-01 00:00:00 | @ | Washington Redskins | 27 | 23 | 24 | 380 | 278 | 102 | 1 | 24 | 432 | 350 | 82 | 1 | 14.43 | -9.76 | -2.03
3 | Sun | 2016-09-25 00:00:00 | 8:31PM ET | boxscore | W |  | 2016-02-01 00:00:00 |  | Chicago Bears | 31 | 17 | 25 | 447 | 248 | 199 | 1 | 21 | 390 | 312 | 78 | 2 | 17.99 | -3.42 | -3.78
4 | Sun | 2016-10-02 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-03-01 00:00:00 | @ | San Francisco 49ers | 24 | 17 | 26 | 428 | 234 | 194 |  | 14 | 295 | 189 | 106 | 1 | 15.96 | -2.03 | -5.8
5 | Sun | 2016-10-09 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-04-01 00:00:00 |  | Cincinnati Bengals | 28 | 14 | 21 | 402 | 222 | 180 | 1 | 27 | 345 | 249 | 96 |  | 18.6 | -11.82 | 7.25
6 | Sun | 2016-10-16 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-05-01 00:00:00 | @ | Green Bay Packers | 30 | 16 | 24 | 424 | 233 | 191 | 2 | 24 | 372 | 294 | 78 | 4 | 12.09 | 4.84 | -2.93
7 |  |  |  |  |  |  |  |  | Bye Week
8 | Sun | 2016-10-30 00:00:00 | 8:31PM ET | boxscore | W | OT | 2016-06-01 00:00:00 |  | Philadelphia Eagles | 29 | 23 | 26 | 460 | 273 | 187 | 1 | 21 | 291 | 194 | 97 | 1 | 6.81 | 3.91 | -6.68
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-07-01 00:00:00 | @ | [NAME] | 35 | 10 | 29 | 423 | 255 | 168 |  | 13 | 222 | 177 | 45 |  | 27.99 | -0.76 | 0.64
10 | Sun | 2016-11-13 00:00:00 | 4:25PM ET | boxscore | W |  | 2016-08-01 00:00:00 | @ | Pittsburgh Steelers | 35 | 30 | 20 | 422 | 295 | 127 | 1 | 30 | 448 | 400 | 48 |  | 13.5 | -21.01 | 10.13
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-09-01 00:00:00 |  | Baltimore Ravens | 27 | 17 | 27 | 417 | 299 | 118 |  | 17 | 368 | 267 | 101 |  | 21.44 | -10.17 | -0.83
12 | Thu | 2016-11-24 00:00:00 | 4:30PM ET | boxscore | W |  | 2016-10-01 00:00:00 |  | Washington Redskins | 31 | 26 | 24 | 353 | 190 | 163 |  | 25 | 505 | 449 | 56 |  | 19.18 | -24.94 | 11.43
13 | Thu | 2016-12-01 00:00:00 | 8:25PM ET | boxscore | W |  | 2016-11-01 00:00:00 | @ | Minnesota Vikings | 17 | 15 | 13 | 264 | 124 | 140 | 2 | 21 | 318 | 231 | 87 | 1 | -9.19 | 2.5 | 11.58
14 | Sun | 2016-12-11 00:00:00 | 8:30PM ET | preview |  |  |  | @ | New York Giants
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  |  | Tampa Bay Buccaneers
16 | Mon | 2016-12-26 00:00:00 | 8:30PM ET | preview |  |  |  |  | Detroit Lions
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Philadelphia Eagles