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

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 | 170 | 3246 | 674 | 4.8 | 17 | 5 | 182 | 228 | 376 | 2332 | 12 | 12 | 5.8 | 115 | 271 | 914 | 5 | 3.4 | 50 | 89 | 774 | 17 | 129 | 24.8 | 13.2 | Own 27.1 | 02:32:00 | 5.69 | 25.1 | 1.27
Opp. Stats | 236 | 3738 | 710 | 5.3 | 13 | 7 | 226 | 258 | 401 | 2503 | 20 | 6 | 5.9 | 131 | 287 | 1235 | 8 | 4.3 | 68 | 67 | 597 | 27 | 129 | 27.9 | 10.1 | Own 25.8 | 02:35:00 | 5.9 | 28.8 | 1.71
Lg Rank Offense | 32 | 32 |  |  | 22 | 9 | 32 |  | 26 | 29 | 24 | 26 | 26 |  | 19 | 29 | 25 | 31 |  |  |  |  |  | 32 | 9 | 23 | 25 | 29 | 32 | 32
Lg Rank Defense | 12 | 9 |  |  | 20 | 11 | 14 |  | 20 | 7 | 20 | 25 | 6 |  | 19 | 20 | 11 | 22 |  |  |  |  |  | 31 | 19 | 2 | 10 | 10 | 7 | 10
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 | Mon | 2016-09-12 00:00:00 | 10:20PM ET | boxscore | L |  | 0-1 | @ | San Francisco 49ers | 0 | 28 | 10 | 185 | 120 | 65 | 2 | 28 | 320 | 170 | 150 | 1 | -25.61 | -5.1 | 3.9
2 | Sun | 2016-09-18 00:00:00 | 4:08PM ET | boxscore | W |  | 2016-01-01 00:00:00 |  | [NAME] | 9 | 3 | 17 | 283 | 219 | 64 |  | 17 | 306 | 239 | 67 | 1 | 0.61 | 4.15 | 1.8
3 | Sun | 2016-09-25 00:00:00 | [NAME] | boxscore | W |  | 2016-02-01 00:00:00 | @ | Tampa Bay Buccaneers | 37 | 32 | 18 | 320 | 183 | 137 | 2 | 30 | 472 | 389 | 83 | 2 | 0.44 | -4.85 | 5.57
4 | Sun | 2016-10-02 00:00:00 | 3:25PM ET | boxscore | W |  | 2016-03-01 00:00:00 | @ | Arizona Cardinals | 17 | 13 | 12 | 288 | 247 | 41 | 1 | 26 | 420 | 302 | 118 | 5 | -4.82 | 3.21 | 5.82
5 | Sun | 2016-10-09 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-03-02 00:00:00 |  | Buffalo Bills | 19 | 30 | 23 | 345 | 243 | 102 | 3 | 15 | 305 | 112 | 193 |  | -8.61 | -5.28 | 0.71
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-03-03 00:00:00 | @ | Detroit Lions | 28 | 31 | 23 | 387 | 311 | 76 | 1 | 20 | 348 | 265 | 83 |  | 19.64 | -20.72 | -2.35
7 | Sun | 2016-10-23 00:00:00 | 9:31AM ET | boxscore | L |  | 2016-03-04 00:00:00 |  | New York Giants | 10 | 17 | 20 | 345 | 271 | 74 | 4 | 13 | 232 | 196 | 36 | 1 | -15.23 | 9.64 | -0.3
8 |  |  |  |  |  |  |  |  | Bye Week
9 | Sun | 2016-11-06 00:00:00 | [NAME] | boxscore | L |  | 2016-03-05 00:00:00 |  | Carolina Panthers | 10 | 13 | 18 | 339 | 280 | 59 | 1 | 16 | 244 | 185 | 59 |  | -1.87 | 1.39 | -4.24
10 | Sun | 2016-11-13 00:00:00 | 1:00PM ET | boxscore | W |  | 2016-04-05 00:00:00 | @ | New York Jets | 9 | 6 | 16 | 280 | 155 | 125 |  | 17 | 296 | 157 | 139 | 1 | -5.79 | 2.43 | 3.9
11 | Sun | 2016-11-20 00:00:00 | [NAME] | boxscore | L |  | 2016-04-06 00:00:00 |  | [NAME] | 10 | 14 | 12 | 227 | 125 | 102 | 1 | 17 | 240 | 142 | 98 | 1 | -11.35 | 6.13 | 3.45
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-04-07 00:00:00 | @ | New Orleans Saints | 21 | 49 | 13 | 247 | 178 | 69 | 2 | 27 | 555 | 346 | 209 | 1 | -9.75 | -29.28 | 3.18
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | New England Patriots
14 | Sun | 2016-12-11 00:00:00 | 4:25PM ET | preview |  |  |  |  | Atlanta Falcons
15 | Thu | 2016-12-15 00:00:00 | 8:25PM ET | preview |  |  |  | @ | [NAME]
16 | Sat | 2016-12-24 00:00:00 | 4:25PM ET | preview |  |  |  |  | San Francisco 49ers
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  |  | Arizona Cardinals