Spreadsheet: 221180d1363392922-function-that-will-calculate-the-running-average-ofthe-last-3-in-a-set-of-conditional-data-template1
Sheet: Template

 | Team 1
 | Offensive Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Defensive Stats |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week
Week | Player | MIN | Game Date | Location |  |  |  | REB | AST | STL | BLK | TO | PF | PTS | Week | POS | MIN | Game Date | Location |  |  |  | REB | AST | STL | BLK | TO | PF | +/- | PTS
 | A | 28 | 2012-10-30 00:00:00 | H |  |  |  | 11 | 1 | 0 | 0 | 1 | 2 | 15 |  | PG | 29 | 2012-10-30 00:00:00 | H |  |  |  | 2 | 1 | 1 | 0 | 0 | 3 | 12 | 6
 | B | 41 |  | H |  |  |  | 5 | 5 | 2 | 0 | 0 | 3 | 23 |  | SF | 29 |  | H |  |  |  | 10 | 3 | 2 | 0 | 0 | 2 | 12 | 26
 | C | 32 |  | H |  |  |  | 12 | 2 | 0 | 2 | 5 | 4 | 9 |  | C | 37 |  | H |  |  |  | 10 | 1 | 0 | 3 | 1 | 3 | 15 | 19
 | D | 44 |  | H |  |  |  | 7 | 13 | 0 | 0 | 4 | 4 | 20 |  | PF | 36 |  | H |  |  |  | 1 | 11 | 3 | 0 | 1 | 3 | 11 | 8
 | E | 24 |  | H |  |  |  | 1 | 1 | 0 | 0 | 1 | 5 | 11 |  | PG | 35 |  | H |  |  |  | 3 | 4 | 2 | 1 | 4 | 3 | -6 | 29
 | F | 8 |  | H |  |  |  | 1 | 0 | 0 | 0 | 0 | 1 | 2 |  | SG | 11 |  | H |  |  |  | 3 | 0 | 0 | 0 | 1 | 1 | -2 | 0
 | G | 23 |  | H |  |  |  | 3 | 0 | 1 | 0 | 1 | 0 | 3 |  | C | 19 |  | H |  |  |  | 5 | 1 | 0 | 1 | 0 | 1 | 1 | 10
 | H | 25 |  | H |  |  |  | 0 | 1 | 1 | 0 | 3 | 3 | 8 |  | SG | 6 |  | H |  |  |  | 0 | 1 | 0 | 0 | 1 | 2 | 5 | 3
 | I | 16 |  | H |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 16 |  | PF | 31 |  | H |  |  |  | 2 | 2 | 0 | 0 | 0 | 1 | 9 | 19
 | C | 25 | 2012-11-01 00:00:00 | A |  |  |  | 2 | 1 | 1 | 0 | 0 | 3 | 6 |  | PG | 7 |  | H |  |  |  | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 0
 | B | 38 |  | A |  |  |  | 10 | 3 | 2 | 0 | 0 | 2 | 26 |  | SF | 38 | 2012-11-01 00:00:00 | A |  |  |  | 7 | 2 | 0 | 0 | 2 | 2 | 15 | 9
 | H | 31 |  | A |  |  |  | 10 | 1 | 0 | 3 | 1 | 3 | 19 |  | SG | 32 |  | A |  |  |  | 5 | 3 | 1 | 0 | 2 | 0 | 17 | 25
 | A | 40 |  | A |  |  |  | 1 | 11 | 3 | 0 | 1 | 3 | 8 |  | PG | 40 |  | A |  |  |  | 2 | 1 | 1 | 5 | 1 | 2 | 19 | 10 |  | PG
 | D | 28 |  | A |  |  |  | 3 | 4 | 2 | 1 | 4 | 3 | 29 |  | C | 35 |  | A |  |  |  | 3 | 5 | 1 | 0 | 1 | 1 | 15 | 11 |  | SF
 | I | 12 |  | A |  |  |  | 3 | 0 | 0 | 0 | 1 | 1 | 0 |  | SF | 9 |  | A |  |  |  | 6 | 3 | 0 | 0 | 1 | 3 | 20 | 10 |  | C
 | G | 21 |  | A |  |  |  | 5 | 1 | 0 | 1 | 0 | 1 | 10 |  | PG | 3 |  | A |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0 |  | PF
 | E | 19 |  | A |  |  |  | 0 | 1 | 0 | 0 | 1 | 2 | 3 |  | SG | 10 |  | A |  |  |  | 6 | 2 | 0 | 1 | 0 | 2 | 8 | 18
 | F | 12 |  | A |  |  |  | 2 | 2 | 0 | 0 | 0 | 1 | 19 |  | PF | 6 |  | A |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 6 | 2
 | H | 32 | 2012-11-04 00:00:00 | A |  |  |  | 7 | 1 | 0 | 2 | 1 | 4 | 12 |  | SG | 5 |  | A |  |  |  | 2 | 5 | 1 | 1 | 0 | 0 | 6 | 5
 | C | 35 |  | A |  |  |  | 6 | 7 | 0 | 1 | 2 | 0 | 19 |  | PF | 2 |  | A |  |  |  | 2 | 1 | 0 | 0 | 0 | 0 | 6 | 7
 | A | 40 |  | A |  |  |  | 5 | 1 | 1 | 0 | 2 | 2 | 5 |  | PG | 23 |  | A |  |  |  | 6 | 1 | 0 | 2 | 2 | 3 | 7 | 2
 | E | 19 |  | A |  |  |  | 3 | 5 | 1 | 0 | 1 | 1 | 11 |  | PF | 3 | 2012-11-04 00:00:00 | A |  |  |  | 3 | 8 | 0 | 0 | 1 | 3 | 14 | 14
 | D | 21 |  | A |  |  |  | 4 | 1 | 0 | 1 | 2 | 3 | 13 |  | PG | 26 |  | A |  |  |  | 1 | 2 | 1 | 0 | 2 | 3 | 9 | 2
 | B | 35 |  | A |  |  |  | 4 | 2 | 0 | 0 | 0 | 0 | 4 |  | PG | 27 |  | A |  |  |  | 8 | 3 | 0 | 0 | 3 | 3 | -13 | 18
 | F | 28 |  | A |  |  |  | 0 | 2 | 1 | 0 | 0 | 0 | 0 |  | SF | 27 |  | A |  |  |  | 6 | 0 | 0 | 0 | 1 | 1 | -3 | 16
 | I | 16 |  | A |  |  |  | 4 | 0 | 0 | 1 | 0 | 0 | 6 |  | SG | 22 |  | A |  |  |  | 3 | 3 | 0 | 1 | 0 | 3 | 4 | 9
 | G | 12 |  | A |  |  |  | 8 | 0 | 1 | 3 | 1 | 5 | 8 |  | C | 28 |  | A |  |  |  | 3 | 3 | 2 | 0 | 2 | 0 | -13 | 13
 | I | 35 | 2012-11-06 00:00:00 | H |  |  |  | 3 | 3 | 1 | 0 | 0 | 0 | 13 |  | PF | 3 |  | A |  |  |  | 3 | 2 | 0 | 1 | 0 | 2 | -6 | 10
 | A | 41 |  | H |  |  |  | 3 | 5 | 0 | 0 | 0 | 4 | 9 |  | PG | 20 |  | A |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | -26 | 6
 | C | 25 |  | H |  |  |  | 2 | 1 | 0 | 0 | 2 | 0 | 11 |  | C | 6 |  | A |  |  |  | 1 | 3 | 1 | 0 | 0 | 2 | -12 | 5
 | B | 19 |  | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 5 |  | SG | 15 |  | A |  |  |  | 4 | 0 | 0 | 0 | 1 | 1 | 3 | 2
 | H | 12 |  | H |  |  |  | 5 | 0 | 0 | 2 | 1 | 2 | 4 |  | SF | 5 | 2012-11-06 00:00:00 | H |  |  |  | 0 | 3 | 2 | 0 | 0 | 1 | -19 | 5
 | G | 8 |  | H |  |  |  | 3 | 2 | 1 | 1 | 0 | 1 | 2 |  | PG | 14 |  | H |  |  |  | 0 | 2 | 0 | 0 | 1 | 1 | -23 | 6
 | F | 36 |  | H |  |  |  | 0 | 2 | 0 | 0 | 1 | 1 | 5 |  | C | 26 |  | H |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | -11 | 0
 | D | 28 |  | H |  |  |  | 5 | 4 | 0 | 1 | 2 | 2 | 11 |  | SG | 20 |  | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -11 | 0
 | E | 32 |  | H |  |  |  | 5 | 5 | 0 | 0 | 0 | 2 | 21 |  | SF | 24 |  | H |  |  |  | 0 | 3 | 0 | 1 | 4 | 2 | -20 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SG | 14 |  | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | -3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PF | 20 |  | H |  |  |  | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PF | 8 |  | H |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG | 15 |  | H |  |  |  | 1 | 6 | 2 | 0 | 3 | 0 | 19 | 20
 | Player | MIN | Averages |  |  |  |  | REB | AST | STL | BLK | TO | PF | PTS |  | POS | MIN | Averages |  |  |  |  | REB | AST | STL | BLK | TO | PF | +/- | PTS
 | A |  | Season Home |  |  |  |  |  |  |  |  |  |  |  |  | PG |  | Season Home
 |  |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
 | B |  | Season Home |  |  |  |  |  |  |  |  |  |  |  |  | SG |  | Season Home
 |  |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
 | C |  | Season Home |  |  |  |  |  |  |  |  |  |  |  |  | SF |  | Season Home
 |  |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total
 | D |  | Season Home |  |  |  |  |  |  |  |  |  |  |  |  | PF |  | Season Home
 |  |  | Season Road |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Season Road
 |  |  | Last 3 total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3 total