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

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 | 178 | 3852 | 669 | 5.8 | 16 | 7 | 210 | 249 | 406 | 2769 | 13 | 9 | 6.5 | 145 | 241 | 1083 | 5 | 4.5 | 55 | 78 | 647 | 10 | 120 | 25.8 | 13.3 | Own 24.7 | 02:34:00 | 5.97 | 31.9 | 1.38
Opp. Stats | 264 | 3775 | 707 | 5.3 | 8 | 3 | 225 | 254 | 386 | 2638 | 17 | 5 | 6.4 | 140 | 297 | 1137 | 9 | 3.8 | 61 | 68 | 646 | 24 | 121 | 40.5 | 6.6 | Own 28.5 | 02:54:00 | 6.3 | 31.2 | 2.07
Lg Rank Offense | 31 | 16 |  |  | 18 | 19 | 22 |  | 14 | 15 | 21 | 19 | 15 |  | 30 | 21 | 25 | 5 |  |  |  |  |  | 31 | 8 | 31 | 24 | 23 | 12 | 31
Lg Rank Defense | 18 | 11 |  |  | 30 | 27 | 11 |  | 11 | 12 | 13 | 28 | 15 |  | 23 | 17 | 15 | 8 |  |  |  |  |  | 8 | 30 | 23 | 30 | 25 | 15 | 22
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 | L |  | 0-1 | @ | Houston Texans | 14 | 23 | 14 | 258 | 185 | 73 | 1 | 17 | 344 | 215 | 129 | 1 | -8.94 | -0.61 | -1.42
2 | Mon | 2016-09-19 00:00:00 | 8:30PM ET | boxscore | L |  | 0-2 |  | Philadelphia Eagles | 14 | 29 | 16 | 284 | 220 | 64 | 3 | 21 | 280 | 180 | 100 |  | -12.47 | -1.68 | -4.91
3 | Sun | 2016-09-25 00:00:00 | 8:31PM ET | boxscore | L |  | 0-3 | @ | Dallas Cowboys | 17 | 31 | 21 | 390 | 312 | 78 | 2 | 25 | 447 | 248 | 199 | 1 | 3.42 | -17.99 | 3.78
4 | Sun | 2016-10-02 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-01-03 00:00:00 |  | Detroit Lions | 17 | 14 | 23 | 408 | 294 | 114 |  | 16 | 263 | 197 | 66 | 2 | 7.93 | 7.47 | -10.3
5 | Sun | 2016-10-09 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-04 00:00:00 | @ | Indianapolis Colts | 23 | 29 | 25 | 522 | 397 | 125 | 1 | 20 | 396 | 298 | 98 |  | 11.01 | -7.58 | -9.67
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-05 00:00:00 |  | [NAME] | 16 | 17 | 22 | 389 | 297 | 92 |  | 20 | 317 | 263 | 54 | 2 | 1.48 | 0.89 | -2.46
7 | Thu | 2016-10-20 00:00:00 | 8:26PM ET | boxscore | L |  | 2016-01-06 00:00:00 | @ | Green Bay Packers | 10 | 26 | 13 | 189 | 120 | 69 | 2 | 32 | 406 | 303 | 103 | 1 | -10.57 | -10.91 | 9.44
8 | Mon | 2016-10-31 00:00:00 | 8:31PM ET | boxscore | W |  | 2016-02-06 00:00:00 |  | Minnesota Vikings | 20 | 10 | 19 | 403 | 245 | 158 |  | 15 | 258 | 201 | 57 |  | 12.55 | -0.28 | -0.51
9 |  |  |  |  |  |  |  |  | Bye Week
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-07 00:00:00 | @ | Tampa Bay Buccaneers | 10 | 36 | 15 | 283 | 161 | 122 | 4 | 22 | 360 | 280 | 80 | 1 | -20.97 | -6.68 | 2.32
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-08 00:00:00 | @ | New York Giants | 16 | 22 | 17 | 315 | 222 | 93 | 1 | 19 | 329 | 227 | 102 |  | 2.68 | -7.75 | 0.88
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-09 00:00:00 |  | Tennessee Titans | 21 | 27 | 25 | 411 | 316 | 95 | 2 | 18 | 375 | 226 | 149 |  | 4.46 | -12.63 | 3.88
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  |  | San Francisco 49ers
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Detroit Lions
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  |  | Green Bay Packers
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | Washington Redskins
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Minnesota Vikings