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

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 | 214 | 3676 | 716 | 5.1 | 22 | 9 | 227 | 263 | 441 | 2617 | 20 | 13 | 5.6 | 151 | 252 | 1059 | 4 | 4.2 | 49 | 85 | 818 | 27 | 127 | 30.7 | 15 | Own 27.1 | 02:30:00 | 6.07 | 28.9 | 1.68
Opp. Stats | 293 | 3530 | 701 | 5 | 7 | 4 | 207 | 235 | 361 | 2247 | 15 | 3 | 5.8 | 111 | 316 | 1283 | 13 | 4.1 | 70 | 74 | 668 | 26 | 126 | 42.9 | 4 | Own 31.4 | 02:43:00 | 6.1 | 27.8 | 2.17
Lg Rank Offense | 25 | 23 |  |  | 30 | 28 | 15 |  | 5 | 21 | 10 | 29 | 30 |  | 28 | 24 | 29 | 17 |  |  |  |  |  | 25 | 3 | 23 | 27 | 18 | 22 | 24
Lg Rank Defense | 27 | 6 |  |  | 32 | 22 | 6 |  | 3 | 4 | 10 | 31 | 5 |  | 29 | 24 | 26 | 12 |  |  |  |  |  | 4 | 32 | 32 | 16 | 12 | 6 | 24
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:04PM ET | boxscore | L |  | 0-1 |  | Green Bay Packers | 23 | 27 | 20 | 348 | 300 | 48 | 1 | 18 | 294 | 199 | 95 |  | 5.3 | -12.55 | 4
2 | Sun | 2016-09-18 00:00:00 | 4:25PM ET | boxscore | L |  | 0-2 | @ | San Diego Chargers | 14 | 38 | 20 | 388 | 319 | 69 | 3 | 25 | 357 | 207 | 150 | 1 | -2.12 | -15.37 | -7.37
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 0-3 |  | Baltimore Ravens | 17 | 19 | 14 | 216 | 168 | 48 | 3 | 18 | 283 | 199 | 84 | 3 | -11.68 | 10.63 | -3.25
4 | Sun | 2016-10-02 00:00:00 | 9:35AM ET | boxscore | W |  | 2016-01-03 00:00:00 |  | Indianapolis Colts | 30 | 27 | 23 | 331 | 195 | 136 |  | 23 | 284 | 190 | 94 | 1 | 12.99 | -1.26 | -2.11
5 |  |  |  |  |  |  |  |  | Bye Week
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | W |  | 2016-02-03 00:00:00 | @ | Chicago Bears | 17 | 16 | 20 | 317 | 263 | 54 | 2 | 22 | 389 | 297 | 92 |  | -0.89 | -1.48 | 2.46
7 | Sun | 2016-10-23 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-02-04 00:00:00 |  | Oakland Raiders | 16 | 33 | 19 | 344 | 239 | 105 | 3 | 21 | 344 | 200 | 144 |  | -4.36 | -4.78 | -10.08
8 | Thu | 2016-10-27 00:00:00 | 8:26PM ET | boxscore | L |  | 2016-02-05 00:00:00 | @ | Tennessee Titans | 22 | 36 | 27 | 370 | 322 | 48 | 1 | 25 | 494 | 280 | 214 |  | 10.26 | -24.07 | 2.07
9 | Sun | 2016-11-06 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-06 00:00:00 | @ | Kansas City Chiefs | 14 | 19 | 25 | 449 | 244 | 205 | 4 | 10 | 231 | 169 | 62 |  | -2.54 | 13.41 | -13.15
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-07 00:00:00 |  | Houston Texans | 21 | 24 | 23 | 327 | 247 | 80 | 2 | 16 | 273 | 92 | 181 |  | -0.96 | 0.38 | 0.61
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-08 00:00:00 | @ | Detroit Lions | 19 | 26 | 16 | 285 | 202 | 83 | 3 | 14 | 277 | 263 | 14 | 2 | -12.43 | 2.74 | -0.09
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-02-09 00:00:00 | @ | Buffalo Bills | 21 | 28 | 20 | 301 | 118 | 183 |  | 15 | 304 | 151 | 153 |  | 5.16 | -16.59 | -0.68
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  |  | Denver Broncos
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  |  | Minnesota Vikings
15 | Sun | 2016-12-18 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Houston Texans
16 | Sat | 2016-12-24 00:00:00 | 1:00PM ET | preview |  |  |  |  | Tennessee Titans
17 | Sun | 2016-01-01 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Indianapolis Colts