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

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 | 245 | 4060 | 771 | 5 | 19 | 6 | 255 | 269 | 458 | 2885 | 17 | 13 | 5.9 | 162 | 280 | 1175 | 11 | 4.2 | 64 | 73 | 596 | 29 | 135 | 31.1 | 14.1 | Own 29.2 | 02:37:00 | 6.05 | 29.7 | 1.76
Opp. Stats | 228 | 3234 | 687 | 4.7 | 18 | 8 | 193 | 222 | 364 | 2146 | 9 | 10 | 5.5 | 110 | 294 | 1088 | 13 | 3.7 | 65 | 83 | 710 | 18 | 130 | 29.2 | 12.3 | Own 28.0 | 02:28:00 | 5.6 | 24.8 | 1.55
Lg Rank Offense | 20 | 9 |  |  | 25 | 15 | 3 |  | 1 | 9 | 16 | 29 | 24 |  | 16 | 17 | 8 | 18 |  |  |  |  |  | 24 | 6 | 9 | 21 | 21 | 21 | 19
Lg Rank Defense | 11 | 1 |  |  | 8 | 8 | 2 |  | 5 | 2 | 1 | 8 | 3 |  | 22 | 11 | 26 | 6 |  |  |  |  |  | 29 | 9 | 17 | 5 | 3 | 2 | 5
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 | 7:30PM ET | boxscore | L |  | 0-1 |  | New England Patriots | 21 | 23 | 21 | 344 | 252 | 92 |  | 19 | 363 | 257 | 106 | 2 | 11.42 | -5.61 | -9.08
2 | Sun | 2016-09-18 00:00:00 | 1:05PM ET | boxscore | W |  | 2016-01-01 00:00:00 |  | Tampa Bay Buccaneers | 40 | 7 | 20 | 416 | 311 | 105 |  | 21 | 306 | 221 | 85 | 5 | 14.72 | 21.55 | -0.4
3 | Sun | 2016-09-25 00:00:00 | 1:02PM ET | boxscore | L |  | 2016-01-02 00:00:00 | @ | Buffalo Bills | 18 | 33 | 25 | 348 | 260 | 88 | 5 | 16 | 297 | 89 | 208 | 1 | -20.9 | 2.34 | 5.33
4 | Sun | 2016-10-02 00:00:00 | 3:25PM ET | boxscore | L |  | 2016-01-03 00:00:00 |  | Los Angeles Rams | 13 | 17 | 26 | 420 | 302 | 118 | 5 | 12 | 288 | 247 | 41 | 1 | -3.21 | 4.82 | -5.82
5 | Thu | 2016-10-06 00:00:00 | 8:27PM ET | boxscore | W |  | 2016-02-03 00:00:00 | @ | San Francisco 49ers | 33 | 21 | 17 | 288 | 116 | 172 |  | 25 | 286 | 135 | 151 | 3 | -3.49 | 2.05 | 11.2
6 | Mon | 2016-10-17 00:00:00 | 7:30PM ET | boxscore | W |  | 2016-03-03 00:00:00 |  | New York Jets | 28 | 3 | 28 | 396 | 225 | 171 |  | 11 | 230 | 197 | 33 | 2 | 20.59 | 12.37 | -5.45
7 | Sun | 2016-10-23 00:00:00 | 7:30PM ET | boxscore | T | OT | 2001-03-03 00:00:00 |  | [NAME] | 6 | 6 | 23 | 443 | 311 | 132 |  | 11 | 257 | 205 | 52 |  | -1.88 | 15 | -9.26
8 | Sun | 2016-10-30 00:00:00 | 12:47PM ET | boxscore | L |  | 2001-03-04 00:00:00 | @ | Carolina Panthers | 20 | 30 | 22 | 340 | 316 | 24 | 2 | 19 | 349 | 208 | 141 | 1 | -6.19 | -1.07 | -3.45
9 |  |  |  |  |  |  |  |  | Bye Week
10 | Sun | 2016-11-13 00:00:00 | 4:25PM ET | boxscore | W |  | 2001-04-04 00:00:00 |  | San Francisco 49ers | 23 | 20 | 26 | 443 | 363 | 80 | 4 | 15 | 281 | 198 | 83 | 1 | 6.62 | 0.69 | -4.31
11 | Sun | 2016-11-20 00:00:00 | 1:00PM ET | boxscore | L |  | 2001-04-05 00:00:00 | @ | Minnesota Vikings | 24 | 30 | 24 | 290 | 155 | 135 | 2 | 16 | 217 | 145 | 72 | 1 | -6.42 | 2.66 | -4.9
12 | Sun | 2016-11-27 00:00:00 | 1:00PM ET | boxscore | L |  | 2001-04-06 00:00:00 | @ | Atlanta Falcons | 19 | 38 | 23 | 332 | 274 | 58 | 1 | 28 | 360 | 244 | 116 | 1 | 1.72 | -17.09 | -5.32
13 | Sun | 2016-12-04 00:00:00 | 4:25PM ET | preview |  |  |  |  | Washington Redskins
14 | Sun | 2016-12-11 00:00:00 | 1:00PM ET | preview |  |  |  | @ | [NAME]
15 | Sun | 2016-12-18 00:00:00 | [NAME] | preview |  |  |  |  | New Orleans Saints
16 | Sat | 2016-12-24 00:00:00 | 4:25PM ET | preview |  |  |  | @ | [NAME]
17 | Sun | 2016-01-01 00:00:00 | 4:25PM ET | preview |  |  |  | @ | Los Angeles Rams