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

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 | 249 | 3656 | 627 | 5.8 | 13 | 5 | 196 | 217 | 330 | 2380 | 15 | 8 | 6.7 | 112 | 271 | 1276 | 12 | 4.7 | 67 | 84 | 809 | 17 | 128 | 31.3 | 9.4 | Own 27.7 | 02:27:00 | 5.29 | 28.4 | 1.78
Opp. Stats | 240 | 3981 | 730 | 5.5 | 15 | 5 | 228 | 237 | 389 | 2527 | 17 | 10 | 6.1 | 132 | 316 | 1454 | 8 | 4.6 | 65 | 80 | 656 | 31 | 130 | 33.8 | 11.5 | Own 28.3 | 02:43:00 | 6.2 | 30.5 | 1.78
Lg Rank Offense | 17 | 25 |  |  | 13 | 9 | 31 |  | 30 | 28 | 18 | 13 | 10 |  | 19 | 6 | 5 | 4 |  |  |  |  |  | 23 | 20 | 18 | 28 | 32 | 24 | 18
Lg Rank Defense | 16 | 21 |  |  | 12 | 18 | 21 |  | 14 | 9 | 13 | 8 | 9 |  | 29 | 30 | 11 | 29 |  |  |  |  |  | 23 | 12 | 20 | 16 | 19 | 14 | 12
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:08PM ET | boxscore | L |  | 0-1 | @ | [NAME] | 10 | 12 | 11 | 214 | 150 | 64 |  | 21 | 352 | 240 | 112 | 2 | -9.75 | 5.68 | -0.42
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | L |  | 0-2 | @ | New England Patriots | 24 | 31 | 23 | 457 | 387 | 70 | 4 | 29 | 463 | 302 | 161 | 1 | 6.98 | -17.47 | 3.95
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | W | OT | 2016-01-02 00:00:00 |  | [NAME] | 30 | 24 | 23 | 426 | 311 | 115 | 3 | 21 | 430 | 261 | 169 | 1 | -3.28 | -1.58 | 12.54
4 | Thu | 2016-09-29 00:00:00 | 8:26PM ET | boxscore | L |  | 2016-01-03 00:00:00 | @ | Cincinnati Bengals | 7 | 22 | 8 | 222 | 160 | 62 | 2 | 19 | 362 | 285 | 77 |  | -13.03 | 1.78 | -4.96
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-04 00:00:00 |  | Tennessee Titans | 17 | 30 | 8 | 200 | 149 | 51 | 2 | 23 | 398 | 163 | 235 |  | -9.64 | -12.48 | 10.75
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-04 00:00:00 |  | Pittsburgh Steelers | 30 | 15 | 24 | 474 | 252 | 222 |  | 15 | 297 | 169 | 128 | 2 | 19.26 | 3.5 | -5.2
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-04 00:00:00 |  | Buffalo Bills | 28 | 25 | 26 | 454 | 198 | 256 |  | 16 | 267 | 200 | 67 |  | 16.07 | -4.44 | -6.19
8 |  |  |  |  |  |  |  |  | Bye Week
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-04-04 00:00:00 |  | New York Jets | 27 | 23 | 20 | 274 | 137 | 137 |  | 18 | 331 | 191 | 140 | 2 | 5.84 | -4.15 | 6.23
10 | Sun | 2016-11-13 00:00:00 | [NAME] | boxscore | W |  | 2016-05-04 00:00:00 | @ | San Diego Chargers | 31 | 24 | 17 | 337 | 231 | 106 | 1 | 29 | 379 | 309 | 70 | 4 | 11.95 | 2.97 | -7.25
11 | Sun | 2016-11-20 00:00:00 | [NAME] | boxscore | W |  | 2016-06-04 00:00:00 | @ | Los Angeles Rams | 14 | 10 | 17 | 240 | 142 | 98 | 1 | 12 | 227 | 125 | 102 | 1 | -6.13 | 11.35 | -3.45
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-07-04 00:00:00 |  | San Francisco 49ers | 31 | 24 | 19 | 358 | 263 | 95 |  | 25 | 475 | 282 | 193 | 2 | 13.75 | -12.23 | -0.56
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Baltimore Ravens
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Arizona Cardinals
15 | Sat | 2016-12-17 00:00:00 | 8:25PM ET | preview |  |  |  | @ | New York Jets
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Buffalo Bills
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | New England Patriots