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

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 | 213 | 4052 | 730 | 5.6 | 13 | 7 | 240 | 259 | 408 | 2855 | 12 | 6 | 6.5 | 145 | 290 | 1197 | 11 | 4.1 | 66 | 63 | 494 | 29 | 124 | 33.1 | 8.9 | Own 25.7 | 02:42:00 | 6.35 | 32.5 | 1.73
Opp. Stats | 245 | 4032 | 712 | 5.7 | 14 | 3 | 227 | 254 | 389 | 2706 | 20 | 11 | 6.6 | 139 | 302 | 1326 | 8 | 4.4 | 66 | 76 | 658 | 22 | 125 | 36 | 11.2 | Own 27.6 | 02:43:00 | 6.1 | 32.2 | 1.98
Lg Rank Offense | 27 | 10 |  |  | 13 | 19 | 10 |  | 12 | 10 | 24 | 9 | 14 |  | 11 | 14 | 8 | 19 |  |  |  |  |  | 20 | 22 | 29 | 13 | 7 | 9 | 21
Lg Rank Defense | 17 | 23 |  |  | 14 | 27 | 18 |  | 14 | 13 | 20 | 3 | 19 |  | 24 | 28 | 11 | 26 |  |  |  |  |  | 15 | 15 | 15 | 16 | 13 | 18 | 20
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 | @ | New York Jets | 23 | 22 | 18 | 381 | 324 | 57 | 1 | 22 | 340 | 188 | 152 | 1 | 10.02 | -6.23 | 0.57
2 | Sun | 2016-09-18 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-01 00:00:00 | @ | Pittsburgh Steelers | 16 | 24 | 21 | 412 | 366 | 46 | 2 | 19 | 374 | 250 | 124 | 2 | -5.93 | -3.03 | -2.88
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-02 00:00:00 |  | Denver Broncos | 17 | 29 | 20 | 332 | 189 | 143 | 2 | 21 | 355 | 303 | 52 | 1 | 0.55 | -6.41 | -0.45
4 | Thu | 2016-09-29 00:00:00 | 8:26PM ET | boxscore | W |  | 2016-02-02 00:00:00 |  | [NAME] | 22 | 7 | 19 | 362 | 285 | 77 |  | 8 | 222 | 160 | 62 | 2 | -1.78 | 13.03 | 4.96
5 | Sun | 2016-10-09 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-02-03 00:00:00 | @ | Dallas Cowboys | 14 | 28 | 27 | 345 | 249 | 96 |  | 21 | 402 | 222 | 180 | 1 | 11.82 | -18.6 | -7.25
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-02-04 00:00:00 | @ | New England Patriots | 17 | 35 | 20 | 357 | 237 | 120 |  | 25 | 437 | 358 | 79 |  | 8.15 | -21.68 | -3.28
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-03-04 00:00:00 |  | [NAME] | 31 | 17 | 23 | 559 | 288 | 271 | 1 | 22 | 352 | 172 | 180 | 2 | 31.04 | -4.02 | -11.95
8 | Sun | 2016-10-30 00:00:00 | 8:36AM ET | boxscore | T |  | 2001-03-04 00:00:00 |  | Washington Redskins | 27 | 27 | 35 | 415 | 263 | 152 | 2 | 30 | 546 | 446 | 100 | 1 | 13.63 | -16.21 | 7.1
9 |  |  |  |  |  |  |  |  | Bye Week
10 | Mon | 2016-11-14 00:00:00 | 8:30PM ET | boxscore | L |  | 2001-03-05 00:00:00 | @ | New York Giants | 20 | 21 | 12 | 264 | 186 | 78 | 1 | 23 | 351 | 229 | 122 | 2 | -5.97 | -1.25 | 4.9
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | L |  | 2001-03-06 00:00:00 |  | Buffalo Bills | 12 | 16 | 23 | 300 | 207 | 93 | 2 | 20 | 342 | 159 | 183 | 1 | -2.67 | 1.34 | -0.37
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2001-03-07 00:00:00 | @ | Baltimore Ravens | 14 | 19 | 22 | 325 | 261 | 64 | 2 | 16 | 311 | 219 | 92 | 1 | -3.81 | 6.28 | -7.47
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  |  | Philadelphia Eagles
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | [NAME]
15 | Sun | 2016-12-18 00:00:00 | 8:30PM ET | preview |  |  |  |  | Pittsburgh Steelers
16 | Sat | 2016-12-24 00:00:00 | 8:25PM ET | preview |  |  |  | @ | Houston Texans
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  |  | Baltimore Ravens