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

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 | 3711 | 717 | 5.2 | 16 | 8 | 214 | 232 | 384 | 2613 | 17 | 8 | 6.3 | 130 | 302 | 1098 | 8 | 3.6 | 60 | 87 | 704 | 24 | 134 | 35.8 | 11.2 | Own 28.9 | 02:27:00 | 5.78 | 27.7 | 1.82
Opp. Stats | 219 | 3453 | 733 | 4.7 | 20 | 10 | 217 | 219 | 388 | 2133 | 10 | 10 | 5 | 126 | 310 | 1320 | 10 | 4.3 | 65 | 74 | 650 | 26 | 131 | 31.3 | 13 | Own 29.2 | 02:39:00 | 6.1 | 26.2 | 1.55
Lg Rank Offense | 13 | 19 |  |  | 18 | 25 | 20 |  | 22 | 22 | 16 | 13 | 18 |  | 9 | 19 | 17 | 28 |  |  |  |  |  | 16 | 15 | 11 | 28 | 28 | 27 | 16
Lg Rank Defense | 9 | 4 |  |  | 4 | 3 | 9 |  | 12 | 1 | 2 | 8 | 1 |  | 27 | 27 | 21 | 20 |  |  |  |  |  | 24 | 8 | 24 | 13 | 15 | 3 | 4
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 | W |  | 2000-01-01 00:00:00 |  | Carolina Panthers | 21 | 20 | 21 | 307 | 159 | 148 | 3 | 21 | 333 | 176 | 157 | 1 | 4.46 | -6.53 | 3.92
2 | Sun | 2016-09-18 00:00:00 | 4:25PM ET | boxscore | W |  | 2000-02-01 00:00:00 |  | Indianapolis Colts | 34 | 20 | 24 | 400 | 266 | 134 | 1 | 19 | 253 | 170 | 83 | 2 | 12.3 | 9.66 | -9.6
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | W |  | 2000-03-01 00:00:00 | @ | Cincinnati Bengals | 29 | 17 | 21 | 355 | 303 | 52 | 1 | 20 | 332 | 189 | 143 | 2 | 6.41 | -0.55 | 0.45
4 | Sun | 2016-10-02 00:00:00 | [NAME] | boxscore | W |  | 2000-04-01 00:00:00 | @ | Tampa Bay Buccaneers | 27 | 7 | 22 | 307 | 218 | 89 |  | 15 | 215 | 143 | 72 | 3 | 2.97 | 20.49 | -2.33
5 | Sun | 2016-10-09 00:00:00 | [NAME] | boxscore | L |  | 2016-04-01 00:00:00 |  | Atlanta Falcons | 16 | 23 | 18 | 267 | 183 | 84 | 1 | 19 | 372 | 250 | 122 | 1 | -1.15 | -1.87 | -5.74
6 | Thu | 2016-10-13 00:00:00 | 8:25PM ET | boxscore | L |  | 2016-04-02 00:00:00 | @ | San Diego Chargers | 13 | 21 | 16 | 304 | 220 | 84 | 2 | 16 | 265 | 166 | 99 | 2 | -15.82 | 0.16 | 3.49
7 | Mon | 2016-10-24 00:00:00 | 8:30PM ET | boxscore | W |  | 2016-05-02 00:00:00 |  | Houston Texans | 27 | 9 | 19 | 347 | 157 | 190 |  | 14 | 271 | 131 | 140 | 2 | 5.96 | 16.57 | -2.39
8 | Sun | 2016-10-30 00:00:00 | [NAME] | boxscore | W |  | 2016-06-02 00:00:00 |  | San Diego Chargers | 27 | 19 | 15 | 324 | 267 | 57 | 3 | 21 | 369 | 246 | 123 | 3 | -15.82 | 23.84 | 1.58
9 | Sun | 2016-11-06 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-06-03 00:00:00 | @ | Oakland Raiders | 20 | 30 | 13 | 299 | 266 | 33 | 2 | 30 | 397 | 179 | 218 |  | -1.52 | -12.98 | 4.65
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-07-03 00:00:00 | @ | New Orleans Saints | 25 | 23 | 24 | 337 | 234 | 103 | 2 | 19 | 373 | 293 | 80 | 4 | -1.05 | -0.99 | 2.07
11 |  |  |  |  |  |  |  |  | Bye Week
12 | Sun | 2016-11-27 00:00:00 | 8:30PM ET | boxscore | L | OT | 2016-07-04 00:00:00 |  | Kansas City Chiefs | 27 | 30 | 21 | 464 | 340 | 124 | 1 | 23 | 273 | 190 | 83 |  | 11.68 | 3.9 | -18.09
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | [NAME]
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Tennessee Titans
15 | Sun | 2016-12-18 00:00:00 | 4:25PM ET | preview |  |  |  |  | New England Patriots
16 | Sun | 2016-12-25 00:00:00 | 8:30PM ET | preview |  |  |  | @ | Kansas City Chiefs
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  |  | Oakland Raiders