Spreadsheet: 87373d1287175981-average-cells-removing-zeros-on-tails-average-20without-20leading-trailing-20zeroes-offset_nonzerotails-1-
Sheet: Helper

0 | Customer | Q1'06_IncidentsCreated | Q2'06_IncidentsCreated | Q3'06_IncidentsCreated | Q4'06_IncidentsCreated | Q1'07_IncidentsCreated | Q2'07_IncidentsCreated | Q3'07_IncidentsCreated | Q4'07_IncidentsCreated | Q1'08_IncidentsCreated | Q2'08_IncidentsCreated | Q3'08_IncidentsCreated | Q4'08_IncidentsCreated | Q1'09_IncidentsCreated | Q2'09_IncidentsCreated | Q3'09_IncidentsCreated | Q4'09_IncidentsCreated | Q1'10_IncidentsCreated | Q2'10_IncidentsCreated | Q3'10_IncidentsCreated |  | Q1'06_IncidentsCreated | Q2'06_IncidentsCreated | Q3'06_IncidentsCreated | Q4'06_IncidentsCreated | Q1'07_IncidentsCreated | Q2'07_IncidentsCreated | Q3'07_IncidentsCreated | Q4'07_IncidentsCreated | Q1'08_IncidentsCreated | Q2'08_IncidentsCreated | Q3'08_IncidentsCreated | Q4'08_IncidentsCreated | Q1'09_IncidentsCreated | Q2'09_IncidentsCreated | Q3'09_IncidentsCreated | Q4'09_IncidentsCreated | Q1'10_IncidentsCreated | Q2'10_IncidentsCreated | Q3'10_IncidentsCreated
0 | Company1 |  |  | 3 | 29 | 16 | 9 | 3 | 11 | 2 | 5 | 9 | 11 | 22 | 8 | 8 | 7 | 5 | 3 | 6 |  |  |  | 3 | 29 | 16 | 9 | 3 | 11 | 2 | 5 | 9 | 11 | 22 | 8 | 8 | 7 | 5 | 3 | 6
0 | Company2 | 9 | 15 | 10 | 1 | 4 | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 4 | 1 | 2 | 0 | 0 |  | 9 | 15 | 10 | 1 | 4 | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 4 | 1 | 2
0 | Company3 |  | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 1
0 | Company4 | 19 | 22 | 10 | 14 | 18 | 11 | 10 | 20 | 14 | 18 | 28 | 24 | 5 | 13 | 14 | 9 | 26 | 11 | 10 |  | 19 | 22 | 10 | 14 | 18 | 11 | 10 | 20 | 14 | 18 | 28 | 24 | 5 | 13 | 14 | 9 | 26 | 11 | 10
0 | Company5 | 5 | 3 | 8 | 8 | 1 | 9 | 3 | 4 | 2 | 2 | 1 | 1 | 6 | 3 | 8 | 0 | 1 | 1 | 9 |  | 5 | 3 | 8 | 8 | 1 | 9 | 3 | 4 | 2 | 2 | 1 | 1 | 6 | 3 | 8 | 0 | 1 | 1 | 9
0 | Company6 | 10 | 15 | 16 | 6 | 8 | 6 | 7 | 2 | 2 | 6 | 4 | 10 | 5 | 2 | 10 | 4 | 6 | 4 | 4 |  | 10 | 15 | 16 | 6 | 8 | 6 | 7 | 2 | 2 | 6 | 4 | 10 | 5 | 2 | 10 | 4 | 6 | 4 | 4
0 | Company7 | 8 | 5 | 5 | 2 | 7 | 7 | 0 | 2 | 4 | 0 | 1 | 1 | 7 | 3 | 2 | 3 | 1 | 2 | 2 |  | 8 | 5 | 5 | 2 | 7 | 7 | 0 | 2 | 4 | 0 | 1 | 1 | 7 | 3 | 2 | 3 | 1 | 2 | 2
0 | Company8 |  | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 4 | 20 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 4 | 20
0 | Company9 | 3 | 1 | 1 | 4 | 2 | 7 | 7 | 6 | 5 | 2 | 0 | 4 | 1 | 2 | 4 | 4 | 3 | 3 | 4 |  | 3 | 1 | 1 | 4 | 2 | 7 | 7 | 6 | 5 | 2 | 0 | 4 | 1 | 2 | 4 | 4 | 3 | 3 | 4
0 | Company10 |  |  |  | 3 | 6 | 12 | 8 | 1 | 4 | 9 | 30 | 60 | 28 | 26 | 40 | 42 | 30 | 40 | 56 |  |  |  |  | 3 | 6 | 12 | 8 | 1 | 4 | 9 | 30 | 60 | 28 | 26 | 40 | 42 | 30 | 40 | 56
0 | Company11 | 10 | 18 | 12 | 21 | 21 | 16 | 10 | 10 | 18 | 15 | 11 | 9 | 15 | 13 | 8 | 7 | 8 | 13 | 12 |  | 10 | 18 | 12 | 21 | 21 | 16 | 10 | 10 | 18 | 15 | 11 | 9 | 15 | 13 | 8 | 7 | 8 | 13 | 12
0 | Company12 |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 3
0 | Company13 | 6 | 12 | 7 | 28 | 6 | 24 | 16 | 13 | 5 | 16 | 11 | 11 | 18 | 16 | 12 | 12 | 6 | 7 | 9 |  | 6 | 12 | 7 | 28 | 6 | 24 | 16 | 13 | 5 | 16 | 11 | 11 | 18 | 16 | 12 | 12 | 6 | 7 | 9
0 | Company14 | 21 | 37 | 37 | 21 | 22 | 11 | 8 | 28 | 20 | 14 | 7 | 15 | 5 | 3 | 5 | 0 | 0 | 0 | 1 |  | 21 | 37 | 37 | 21 | 22 | 11 | 8 | 28 | 20 | 14 | 7 | 15 | 5 | 3 | 5 | 0 | 0 | 0 | 1
0 | Company15 | 8 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 | 2
0 | Company16 |  | 1 | 3 | 1 | 2 | 1 | 0 | 6 | 7 | 6 | 12 | 22 | 0 | 0 | 0 | 4 | 9 | 1 | 0 |  |  | 1 | 3 | 1 | 2 | 1 | 0 | 6 | 7 | 6 | 12 | 22 | 0 | 0 | 0 | 4 | 9 | 1
0 | Company17 | 4 | 3 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 2 | 4 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 |  | 4 | 3 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 2 | 4 | 0 | 2 | 1
0 | Company18 | 3 | 0 | 3 | 3 | 5 | 2 | 1 | 1 | 1 | 4 | 6 | 9 | 6 | 8 | 11 | 9 | 14 | 17 | 13 |  | 3 | 0 | 3 | 3 | 5 | 2 | 1 | 1 | 1 | 4 | 6 | 9 | 6 | 8 | 11 | 9 | 14 | 17 | 13
0 | Company19 | 4 | 2 | 11 | 11 | 16 | 8 | 0 | 0 | 4 | 6 | 5 | 2 | 1 | 8 | 2 | 6 | 0 | 0 | 0 |  | 4 | 2 | 11 | 11 | 16 | 8 | 0 | 0 | 4 | 6 | 5 | 2 | 1 | 8 | 2 | 6
0 | Company20 |  |  | 1 | 7 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 2 | 1 | 0 | 0 | 0 |  |  |  | 1 | 7 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 2 | 1
0 | Company21 | 13 | 3 | 9 | 2 | 9 | 6 | 3 | 5 | 14 | 8 | 12 | 13 | 5 | 5 | 15 | 16 | 17 | 23 | 13 |  | 13 | 3 | 9 | 2 | 9 | 6 | 3 | 5 | 14 | 8 | 12 | 13 | 5 | 5 | 15 | 16 | 17 | 23 | 13
0 | Company22 | 1 | 8 | 20 | 20 | 30 | 12 | 15 | 20 | 16 | 23 | 13 | 24 | 24 | 16 | 19 | 13 | 18 | 22 | 30 |  | 1 | 8 | 20 | 20 | 30 | 12 | 15 | 20 | 16 | 23 | 13 | 24 | 24 | 16 | 19 | 13 | 18 | 22 | 30
0 | Company23 | 1 | 4 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 0 | 1 | 1 | 8 | 4 | 3 | 0 |  | 1 | 4 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 0 | 1 | 1 | 8 | 4 | 3
0 | Company24 |  | 7 | 20 | 3 | 3 | 10 | 22 | 18 | 10 | 16 | 16 | 18 | 38 | 43 | 48 | 48 | 53 | 51 | 105 |  |  | 7 | 20 | 3 | 3 | 10 | 22 | 18 | 10 | 16 | 16 | 18 | 38 | 43 | 48 | 48 | 53 | 51 | 105
0 | Company25 | 24 | 39 | 70 | 48 | 91 | 63 | 148 | 89 | 135 | 230 | 249 | 198 | 165 | 172 | 163 | 136 | 180 | 122 | 116 |  | 24 | 39 | 70 | 48 | 91 | 63 | 148 | 89 | 135 | 230 | 249 | 198 | 165 | 172 | 163 | 136 | 180 | 122 | 116
0 | Company26 | 20 | 32 | 19 | 39 | 10 | 19 | 13 | 12 | 14 | 17 | 5 | 6 | 9 | 2 | 2 | 0 | 0 | 0 | 0 |  | 20 | 32 | 19 | 39 | 10 | 19 | 13 | 12 | 14 | 17 | 5 | 6 | 9 | 2 | 2
0 | Company27 | 1 | 2 | 5 | 4 | 0 | 10 | 2 | 0 | 3 | 6 | 1 | 0 | 0 | 4 | 0 | 0 | 2 | 0 | 1 |  | 1 | 2 | 5 | 4 | 0 | 10 | 2 | 0 | 3 | 6 | 1 | 0 | 0 | 4 | 0 | 0 | 2 | 0 | 1
0 | Company28 |  |  |  | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 3 | 6 | 13 | 30 | 13 | 6 | 13 | 6 | 12 |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 3 | 6 | 13 | 30 | 13 | 6 | 13 | 6 | 12
0 | Company29 | 2 | 4 | 7 | 1 | 6 | 12 | 12 | 5 | 7 | 20 | 22 | 2 | 4 | 6 | 4 | 2 | 0 | 19 | 12 |  | 2 | 4 | 7 | 1 | 6 | 12 | 12 | 5 | 7 | 20 | 22 | 2 | 4 | 6 | 4 | 2 | 0 | 19 | 12
0 | Company30 |  |  | 15 | 34 | 12 | 32 | 31 | 63 | 37 | 31 | 20 | 18 | 18 | 17 | 57 | 92 | 111 | 124 | 143 |  |  |  | 15 | 34 | 12 | 32 | 31 | 63 | 37 | 31 | 20 | 18 | 18 | 17 | 57 | 92 | 111 | 124 | 143
0 | Company31 | 13 | 12 | 40 | 14 | 14 | 15 | 13 | 23 | 34 | 12 | 5 | 9 | 16 | 7 | 8 | 13 | 6 | 7 | 9 |  | 13 | 12 | 40 | 14 | 14 | 15 | 13 | 23 | 34 | 12 | 5 | 9 | 16 | 7 | 8 | 13 | 6 | 7 | 9
0 | Company32 | 1 | 4 | 6 | 3 | 6 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 2 | 0 | 0 | 0 |  | 1 | 4 | 6 | 3 | 6 | 4 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 2
0 | Company33 | 10 | 8 | 6 | 6 | 14 | 11 | 4 | 18 | 14 | 8 | 7 | 2 | 16 | 18 | 19 | 5 | 4 | 3 | 10 |  | 10 | 8 | 6 | 6 | 14 | 11 | 4 | 18 | 14 | 8 | 7 | 2 | 16 | 18 | 19 | 5 | 4 | 3 | 10
0 | Company34 | 24 | 17 | 12 | 11 | 14 | 8 | 15 | 7 | 12 | 11 | 10 | 19 | 13 | 8 | 11 | 25 | 30 | 41 | 20 |  | 24 | 17 | 12 | 11 | 14 | 8 | 15 | 7 | 12 | 11 | 10 | 19 | 13 | 8 | 11 | 25 | 30 | 41 | 20
0 | Company35 | 23 | 12 | 33 | 16 | 19 | 13 | 14 | 9 | 6 | 15 | 27 | 18 | 21 | 23 | 26 | 15 | 18 | 19 | 27 |  | 23 | 12 | 33 | 16 | 19 | 13 | 14 | 9 | 6 | 15 | 27 | 18 | 21 | 23 | 26 | 15 | 18 | 19 | 27
0 | Company36 | 56 | 58 | 65 | 52 | 49 | 57 | 44 | 38 | 90 | 87 | 45 | 36 | 34 | 34 | 40 | 13 | 12 | 38 | 92 |  | 56 | 58 | 65 | 52 | 49 | 57 | 44 | 38 | 90 | 87 | 45 | 36 | 34 | 34 | 40 | 13 | 12 | 38 | 92
0 | Company37 |  |  | 1 | 1 | 0 | 0 | 8 | 4 | 8 | 11 | 8 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1 | 1 | 0 | 0 | 8 | 4 | 8 | 11 | 8 | 1 | 2
0 | Company38 | 1 | 2 | 2 | 1 | 0 | 2 | 1 | 1 | 1 | 3 | 4 | 4 | 5 | 7 | 7 | 5 | 0 | 1 | 0 |  | 1 | 2 | 2 | 1 | 0 | 2 | 1 | 1 | 1 | 3 | 4 | 4 | 5 | 7 | 7 | 5 | 0 | 1
0 | Company39 | 3 | 0 | 0 | 3 | 0 | 3 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 5 | 4 | 2 |  | 3 | 0 | 0 | 3 | 0 | 3 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 5 | 4 | 2
0 | Company40 | 8 | 5 | 8 | 2 | 1 | 3 | 3 | 3 | 2 | 1 | 1 | 6 | 7 | 7 | 2 | 8 | 5 | 1 | 1 |  | 8 | 5 | 8 | 2 | 1 | 3 | 3 | 3 | 2 | 1 | 1 | 6 | 7 | 7 | 2 | 8 | 5 | 1 | 1
0 | Company41 | 2 | 1 | 2 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 7 | 1 | 4 | 3 |  | 2 | 1 | 2 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 7 | 1 | 4 | 3
0 | Company42 |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 0 |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 1
0 | Company43 | 1 | 3 | 7 | 2 | 6 | 9 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 2 |  | 1 | 3 | 7 | 2 | 6 | 9 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 2
0 | Company44 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 2 | 2 | 0 | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 2 | 2 | 0 | 0 | 2
0 | Company45 | 14 | 10 | 12 | 8 | 5 | 3 | 7 | 7 | 6 | 4 | 17 | 6 | 7 | 0 | 0 | 0 | 0 | 0 | 0 |  | 14 | 10 | 12 | 8 | 5 | 3 | 7 | 7 | 6 | 4 | 17 | 6 | 7
0 | Company46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
0 | Company47 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1
0 | Company48 |  |  |  | 2 | 7 | 0 | 1 | 3 | 7 | 2 | 0 | 0 | 0 | 1 | 5 | 1 | 3 | 0 | 0 |  |  |  |  | 2 | 7 | 0 | 1 | 3 | 7 | 2 | 0 | 0 | 0 | 1 | 5 | 1 | 3
0 | Company49 | 4 | 4 | 1 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 4 | 4 | 1 | 5 | 2
0 | Company50 | 55 | 49 | 48 | 28 | 24 | 27 | 48 | 27 | 68 | 80 | 80 | 59 | 60 | 56 | 65 | 35 | 30 | 55 | 51 |  | 55 | 49 | 48 | 28 | 24 | 27 | 48 | 27 | 68 | 80 | 80 | 59 | 60 | 56 | 65 | 35 | 30 | 55 | 51