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

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 | 252 | 3611 | 697 | 5.2 | 10 | 6 | 212 | 265 | 402 | 2549 | 13 | 4 | 5.9 | 139 | 267 | 1062 | 7 | 4 | 59 | 70 | 523 | 14 | 125 | 36 | 8 | Own 30.0 | 02:41:00 | 6.18 | 28.8 | 1.72
Opp. Stats | 214 | 4201 | 740 | 5.7 | 24 | 11 | 231 | 253 | 409 | 2866 | 20 | 13 | 6.6 | 152 | 307 | 1335 | 4 | 4.3 | 61 | 73 | 540 | 18 | 127 | 30.7 | 16.5 | Own 26.5 | 02:43:00 | 6.3 | 32.9 | 1.68
Lg Rank Offense | 16 | 27 |  |  | 9 | 15 | 21 |  | 15 | 23 | 21 | 4 | 22 |  | 23 | 23 | 22 | 21 |  |  |  |  |  | 15 | 23 | 7 | 15 | 12 | 23 | 22
Lg Rank Defense | 8 | 28 |  |  | 1 | 1 | 24 |  | 23 | 20 | 20 | 2 | 22 |  | 26 | 29 | 1 | 24 |  |  |  |  |  | 26 | 1 | 6 | 16 | 22 | 23 | 9
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 | OT | 2000-01-01 00:00:00 |  | San Diego Chargers | 33 | 27 | 26 | 413 | 330 | 83 | 1 | 25 | 388 | 233 | 155 |  | 9.06 | -11.8 | 5.97
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-01 00:00:00 | @ | Houston Texans | 12 | 19 | 14 | 291 | 172 | 119 | 3 | 15 | 351 | 254 | 97 | 2 | -22.62 | 9.46 | 7.45
3 | Sun | 2016-09-25 00:00:00 | 4:26PM ET | boxscore | W |  | 2016-02-01 00:00:00 |  | New York Jets | 24 | 3 | 18 | 293 | 221 | 72 | 1 | 17 | 305 | 188 | 117 | 8 | -5.73 | 21.82 | 1.35
4 | Sun | 2016-10-02 00:00:00 | 8:30PM ET | boxscore | L |  | 2016-02-02 00:00:00 | @ | Pittsburgh Steelers | 14 | 43 | 22 | 357 | 270 | 87 | 2 | 18 | 436 | 287 | 149 |  | -3.86 | -15.53 | -4.24
5 |  |  |  |  |  |  |  |  | Bye Week
6 | Sun | 2016-10-16 00:00:00 | [NAME] | boxscore | W |  | 2016-03-02 00:00:00 | @ | Oakland Raiders | 26 | 10 | 22 | 406 | 223 | 183 |  | 16 | 285 | 221 | 64 | 2 | 15.86 | 6.31 | -3.04
7 | Sun | 2016-10-23 00:00:00 | 1:03PM ET | boxscore | W |  | 2016-04-02 00:00:00 |  | New Orleans Saints | 27 | 21 | 20 | 326 | 214 | 112 |  | 27 | 463 | 359 | 104 | 2 | 10.51 | -8.79 | 0.37
8 | Sun | 2016-10-30 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-05-02 00:00:00 | @ | Indianapolis Colts | 30 | 14 | 20 | 422 | 334 | 88 |  | 18 | 277 | 172 | 105 | 2 | 10.8 | 9.55 | -3.36
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-06-02 00:00:00 |  | [NAME] | 19 | 14 | 10 | 231 | 169 | 62 |  | 25 | 449 | 244 | 205 | 4 | -13.41 | 2.54 | 13.15
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-07-02 00:00:00 | @ | Carolina Panthers | 20 | 17 | 18 | 256 | 165 | 91 | 1 | 22 | 341 | 242 | 99 | 2 | -3.83 | 1.62 | 5.28
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-07-03 00:00:00 |  | Tampa Bay Buccaneers | 17 | 19 | 19 | 343 | 261 | 82 | 2 | 27 | 442 | 326 | 116 | 1 | 9.28 | -12.64 | 1.98
12 | Sun | 2016-11-27 00:00:00 | 8:30PM ET | boxscore | W | OT | 2016-08-03 00:00:00 | @ | Denver Broncos | 30 | 27 | 23 | 273 | 190 | 83 |  | 21 | 464 | 340 | 124 | 1 | -3.9 | -11.68 | 18.09
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Atlanta Falcons
14 | Thu | 2016-12-08 00:00:00 | 8:25PM ET | preview |  |  |  |  | Oakland Raiders
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  |  | Tennessee Titans
16 | Sun | 2016-12-25 00:00:00 | 8:30PM ET | preview |  |  |  |  | Denver Broncos
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  | @ | San Diego Chargers