Spreadsheet: 221171d1363387414-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
Player | MIN | Game Date | Location |  |  |  | REB | AST | STL | BLK | TO | PF | PTS | 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
D | 28 |  | A |  |  |  | 3 | 4 | 2 | 1 | 4 | 3 | 29 | C | 35 |  | A |  |  |  | 3 | 5 | 1 | 0 | 1 | 1 | 15 | 11
I | 12 |  | A |  |  |  | 3 | 0 | 0 | 0 | 1 | 1 | 0 | SF | 9 |  | A |  |  |  | 6 | 3 | 0 | 0 | 1 | 3 | 20 | 10
G | 21 |  | A |  |  |  | 5 | 1 | 0 | 1 | 0 | 1 | 10 | PG | 3 |  | A |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0
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