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

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 | 228 | 3571 | 703 | 5.1 | 20 | 11 | 210 | 202 | 358 | 2180 | 15 | 9 | 5.6 | 116 | 317 | 1391 | 11 | 4.4 | 80 | 66 | 555 | 14 | 135 | 30.4 | 11.9 | Own 27.7 | 02:10:00 | 5.61 | 26.5 | 1.68
Opp. Stats | 344 | 4669 | 774 | 6 | 15 | 8 | 255 | 236 | 382 | 2779 | 26 | 7 | 6.9 | 132 | 373 | 1890 | 14 | 5.1 | 98 | 66 | 578 | 25 | 141 | 41.8 | 9.9 | Own 31.0 | 02:37:00 | 5.9 | 33 | 2.39
Lg Rank Offense | 22 | 28 |  |  | 28 | 31 | 22 |  | 28 | 30 | 18 | 19 | 29 |  | 6 | 4 | 8 | 8 |  |  |  |  |  | 27 | 13 | 18 | 32 | 31 | 31 | 23
Lg Rank Defense | 32 | 32 |  |  | 12 | 8 | 31 |  | 9 | 15 | 32 | 19 | 27 |  | 32 | 32 | 30 | 32 |  |  |  |  |  | 6 | 20 | 31 | 12 | 9 | 24 | 29
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 | W |  | 2000-01-01 00:00:00 |  | Los Angeles Rams | 28 | 0 | 28 | 320 | 170 | 150 | 1 | 10 | 185 | 120 | 65 | 2 | 5.1 | 25.61 | -3.9
2 | Sun | 2016-09-18 00:00:00 | 1:03PM ET | boxscore | L |  | 2016-01-01 00:00:00 | @ | Carolina Panthers | 27 | 46 | 16 | 302 | 237 | 65 | 3 | 26 | 529 | 353 | 176 | 4 | -13.97 | -10.97 | 5.67
3 | Sun | 2016-09-25 00:00:00 | [NAME] | boxscore | L |  | 2016-01-02 00:00:00 | @ | [NAME] | 18 | 37 | 12 | 254 | 119 | 135 | 1 | 18 | 418 | 291 | 127 | 2 | -5.4 | -9.29 | -4.06
4 | Sun | 2016-10-02 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-03 00:00:00 |  | Dallas Cowboys | 17 | 24 | 14 | 295 | 189 | 106 | 1 | 26 | 428 | 234 | 194 |  | 2.03 | -15.96 | 5.8
5 | Thu | 2016-10-06 00:00:00 | 8:27PM ET | boxscore | L |  | 2016-01-04 00:00:00 |  | Arizona Cardinals | 21 | 33 | 25 | 286 | 135 | 151 | 3 | 17 | 288 | 116 | 172 |  | -2.05 | 3.49 | -11.2
6 | Sun | 2016-10-16 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-05 00:00:00 | @ | Buffalo Bills | 16 | 45 | 16 | 300 | 167 | 133 | 1 | 29 | 492 | 179 | 313 | 2 | -6.77 | -19.86 | -2.66
7 | Sun | 2016-10-23 00:00:00 | [NAME] | boxscore | L |  | 2016-01-06 00:00:00 |  | Tampa Bay Buccaneers | 17 | 34 | 20 | 273 | 113 | 160 | 3 | 27 | 513 | 264 | 249 | 1 | -2.93 | -14.93 | 1.95
8 |  |  |  |  |  |  |  |  | Bye Week
9 | Sun | 2016-11-06 00:00:00 | [NAME] | boxscore | L |  | 2016-01-07 00:00:00 |  | New Orleans Saints | 23 | 41 | 19 | 486 | 393 | 93 | 4 | 29 | 571 | 323 | 248 |  | -3.2 | -29.46 | 11.54
10 | Sun | 2016-11-13 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-08 00:00:00 | @ | Arizona Cardinals | 20 | 23 | 15 | 281 | 198 | 83 | 1 | 26 | 443 | 363 | 80 | 4 | -0.69 | -6.62 | 4.31
11 | Sun | 2016-11-20 00:00:00 | 4:25PM ET | boxscore | L |  | 2016-01-09 00:00:00 |  | New England Patriots | 17 | 30 | 20 | 299 | 177 | 122 |  | 28 | 444 | 273 | 171 |  | 1.68 | -17.09 | -1.82
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2016-01-10 00:00:00 | @ | [NAME] | 24 | 31 | 25 | 475 | 282 | 193 | 2 | 19 | 358 | 263 | 95 |  | 12.23 | -13.75 | 0.56
13 | Sun | 2016-12-04 00:00:00 | 1:00PM ET | preview |  |  |  | @ | Chicago Bears
14 | Sun | 2016-12-11 00:00:00 | [NAME] | preview |  |  |  |  | New York Jets
15 | Sun | 2016-12-18 00:00:00 | [NAME] | preview |  |  |  | @ | Atlanta Falcons
16 | Sat | 2016-12-24 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Los Angeles Rams
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  |  | [NAME]