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

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 | 194 | 3486 | 731 | 4.8 | 19 | 6 | 208 | 238 | 400 | 2155 | 12 | 13 | 5.1 | 122 | 311 | 1331 | 4 | 4.3 | 70 | 62 | 601 | 16 | 127 | 30.7 | 12.6 | Own 29.0 | 02:41:00 | 6.15 | 27.4 | 1.43
Opp. Stats | 236 | 3484 | 660 | 5.3 | 10 | 4 | 195 | 219 | 352 | 2301 | 14 | 6 | 6.2 | 110 | 288 | 1183 | 10 | 4.1 | 63 | 76 | 659 | 22 | 129 | 34.1 | 7.8 | Own 29.8 | 02:32:00 | 5.5 | 26.8 | 1.77
Lg Rank Offense | 29 | 29 |  |  | 25 | 15 | 25 |  | 17 | 31 | 24 | 29 | 32 |  | 7 | 5 | 29 | 14 |  |  |  |  |  | 25 | 12 | 10 | 15 | 13 | 30 | 29
Lg Rank Defense | 12 | 5 |  |  | 28 | 22 | 3 |  | 1 | 5 | 8 | 25 | 10 |  | 20 | 19 | 21 | 14 |  |  |  |  |  | 22 | 26 | 27 | 8 | 2 | 4 | 11
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 | 1:05PM ET | boxscore | W |  | 2000-01-01 00:00:00 |  | Chicago Bears | 23 | 14 | 17 | 344 | 215 | 129 | 1 | 14 | 258 | 185 | 73 | 1 | 0.61 | 8.94 | 1.42
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | W |  | 2000-02-01 00:00:00 |  | Kansas City Chiefs | 19 | 12 | 15 | 351 | 254 | 97 | 2 | 14 | 291 | 172 | 119 | 3 | -9.46 | 22.62 | -7.45
3 | Thu | 2016-09-22 00:00:00 | 8:26PM ET | boxscore | L |  | 2016-02-01 00:00:00 | @ | New England Patriots | 0 | 27 | 19 | 284 | 175 | 109 | 3 | 15 | 282 | 97 | 185 |  | -14.6 | -1.19 | -10.11
4 | Sun | 2016-10-02 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-01 00:00:00 |  | Tennessee Titans | 27 | 20 | 21 | 359 | 244 | 115 | 2 | 16 | 320 | 196 | 124 | 1 | 3.59 | 1.88 | -0.39
5 | Sun | 2016-10-09 00:00:00 | 1:05PM ET | boxscore | L |  | 2016-03-02 00:00:00 | @ | Minnesota Vikings | 13 | 31 | 16 | 214 | 155 | 59 | 1 | 22 | 351 | 255 | 96 |  | -5.63 | -11.38 | -3.21
6 | Sun | 2016-10-16 00:00:00 | 8:32PM ET | boxscore | W | OT | 2016-04-02 00:00:00 |  | Indianapolis Colts | 26 | 23 | 26 | 414 | 256 | 158 | 1 | 19 | 392 | 231 | 161 | 1 | 9.63 | -2.34 | -5.89
7 | Mon | 2016-10-24 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-04-03 00:00:00 | @ | Denver Broncos | 9 | 27 | 14 | 271 | 131 | 140 | 2 | 19 | 347 | 157 | 190 |  | -16.57 | -5.96 | 2.39
8 | Sun | 2016-10-30 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-05-03 00:00:00 |  | Detroit Lions | 20 | 13 | 20 | 269 | 164 | 105 | 1 | 19 | 289 | 231 | 58 |  | 1.76 | -0.37 | 5.34
9 |  |  |  |  |  |  |  |  | Bye Week
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-06-03 00:00:00 | @ | [NAME] | 24 | 21 | 16 | 273 | 92 | 181 |  | 23 | 327 | 247 | 80 | 2 | -0.38 | 0.96 | -0.61
11 | Mon | 2016-11-21 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-06-04 00:00:00 | @ | Oakland Raiders | 20 | 27 | 22 | 354 | 230 | 124 | 2 | 16 | 325 | 295 | 30 | 1 | 5.77 | -12.48 | -4.89
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-06-05 00:00:00 |  | San Diego Chargers | 13 | 21 | 22 | 353 | 239 | 114 | 4 | 18 | 302 | 235 | 67 | 1 | -6.62 | -5.09 | 5.23
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Green Bay Packers
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Indianapolis Colts
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  |  | [NAME]
16 | Sat | 2016-12-24 00:00:00 | 8:25PM ET | preview |  |  |  |  | Cincinnati Bengals
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Tennessee Titans