Spreadsheet: 92251d1291873599-automatically-adjusting-a-formula-for-new-data-dashboard12810
Sheet: Wk Trend By Call Type

Open Tickets by Call Type
Call Type | 03/28-04/03 | 04/04-04/10 | 04/11-04/17 | 04/18-04/24 | 04/25-05/01 | 05/02-05/08 | 05/09-05/15 | 05/16-05/22 | 05/23-05/29 | 05/30-06/05* | 06/06-06/12 | 06/13-06/19 | 06/20-06/26 | 06/27-07/03 | 07/04-07/10* | 07/11-07/17 | 07/18-07/24 | 07/25-07/31 | 08/01-08/07 | 08/07-08/14 | 08/15-08/21 | 08/22-08/27 | 08/29-09/04 | 09/05-09/11* | 09/12-09/18 | 09/19-09/25 | 09/26-10/02 | 10/03-10/09 | 10/10-10/16* | 10/17-10/23 | 10/24-10/30 | 10/31-11/06 | 11/07-11/13* | 11/14-11/20 | 11/21-11/27* | 11/28-12/04 |  | Mean | STDEV
Calling Cards | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cancelled | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Database Issues | 6 | 6 | 6 | 2 | 12 | 9 | 12 | 3 | 4 | 4 | 11 | 10 | 6 | 8 | 5 | 7 | 13 | 7 | 15 | 5 | 15 | 7 | 5 | 6 | 9 | 5 | 8 | 2 | 6 | 4 | 9 | 9 | 5 | 3 | 2 | 5
Equipment Loan | 7 | 5 | 3 | 13 | 9 | 11 | 8 | 10 | 8 | 10 | 4 | 8 | 8 | 3 | 9 | 17 | 11 | 7 | 8 | 10 | 6 | 4 | 1 | 10 | 11 | 2 | 4 | 8 | 6 | 8 | 7 | 6 | 6 | 4 | 3 | 6
GroupWise | 59 | 46 | 61 | 52 | 48 | 49 | 48 | 40 | 34 | 37 | 73 | 54 | 62 | 43 | 22 | 52 | 58 | 63 | 57 | 41 | 36 | 56 | 50 | 36 | 66 | 50 | 71 | 48 | 42 | 63 | 74 | 49 | 75 | 68 | 38 | 46
HeatService | 0 | 0 | 0 | 11 | 2 | 9 | 2 | 4 | 4 | 11 | 3 | 1 | 2 | 5 | 2 | 2 | 4 | 2 | 2 | 0 | 3 | 0 | 1 | 0 | 4 | 7 | 3 | 3 | 0 | 0 | 3 | 2 | 0 | 2 | 2 | 2
HW Install | 0 | 8 | 9 | 12 | 3 | 9 | 7 | 6 | 10 | 6 | 7 | 3 | 6 | 5 | 9 | 9 | 6 | 4 | 3 | 6 | 3 | 5 | 4 | 6 | 8 | 16 | 3 | 7 | 3 | 8 | 4 | 6 | 4 | 4 | 3 | 2
HW Issues | 14 | 30 | 19 | 22 | 23 | 7 | 11 | 8 | 9 | 17 | 12 | 21 | 23 | 19 | 12 | 18 | 27 | 25 | 13 | 22 | 16 | 14 | 4 | 4 | 15 | 30 | 14 | 9 | 10 | 7 | 21 | 14 | 11 | 15 | 4 | 18
InfoDesk | 27 | 31 | 49 | 38 | 31 | 32 | 31 | 29 | 28 | 12 | 29 | 67 | 60 | 24 | 24 | 26 | 25 | 21 | 19 | 18 | 35 | 16 | 22 | 24 | 34 | 24 | 35 | 25 | 20 | 31 | 27 | 43 | 30 | 39 | 20 | 26
Internet/Intran | 2 | 3 | 1 | 2 | 1 | 2 | 3 | 2 | 2 | 1 | 1 | 3 | 0 | 6 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 3 | 2 | 2 | 1 | 1 | 4 | 0 | 0 | 1
Internet_Other | 8 | 7 | 10 | 5 | 3 | 4 | 2 | 2 | 7 | 6 | 2 | 6 | 8 | 2 | 3 | 9 | 1 | 2 | 9 | 0 | 4 | 2 | 4 | 4 | 6 | 5 | 4 | 2 | 13 | 3 | 5 | 8 | 7 | 4 | 1 | 2
ISER | 1 | 3 | 1 | 3 | 0 | 1 | 1 | 2 | 2 | 1 | 3 | 3 | 3 | 8 | 5 | 3 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 1 | 2 | 1 | 4 | 0 | 2 | 2 | 1 | 0 | 1 | 0 | 0 | 0
LanAdmin Access | 52 | 49 | 49 | 45 | 65 | 49 | 80 | 54 | 50 | 51 | 56 | 46 | 48 | 57 | 25 | 42 | 69 | 60 | 58 | 42 | 50 | 47 | 41 | 34 | 42 | 57 | 56 | 49 | 43 | 46 | 63 | 54 | 41 | 43 | 28 | 46
[NAME] | 73 | 79 | 63 | 118 | 213 | 121 | 121 | 134 | 66 | 77 | 64 | 85 | 94 | 87 | 147 | 57 | 55 | 136 | 109 | 71 | 62 | 52 | 33 | 37 | 110 | 58 | 94 | 82 | 53 | 93 | 134 | 110 | 282 | 116 | 24 | 93
M1 Support | 1 | 3 | 0 | 2 | 1 | 3 | 1 | 6 | 3 | 1 | 3 | 3 | 4 | 5 | 0 | 2 | 3 | 1 | 0 | 1 | 0 | 2 | 2 | 3 | 0 | 3 | 0 | 2 | 0 | 3 | 3 | 0 | 1 | 1 | 1 | 2
Network Issues | 30 | 30 | 195 | 32 | 45 | 44 | 35 | 23 | 31 | 67 | 37 | 31 | 6 | 17 | 15 | 17 | 24 | 18 | 24 | 13 | 30 | 24 | 26 | 12 | 19 | 27 | 17 | 22 | 11 | 46 | 16 | 19 | 84 | 28 | 45 | 16
Network Task | 28 | 5 | 26 | 24 | 24 | 19 | 49 | 39 | 43 | 26 | 40 | 22 | 28 | 15 | 16 | 22 | 23 | 20 | 6 | 20 | 20 | 35 | 21 | 13 | 24 | 22 | 44 | 15 | 6 | 14 | 29 | 18 | 33 | 15 | 12 | 15
ORD | 1 | 1 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 3 | 0
PC Setup | 26 | 11 | 26 | 44 | 35 | 46 | 50 | 59 | 41 | 23 | 31 | 16 | 17 | 13 | 25 | 24 | 29 | 18 | 30 | 27 | 34 | 29 | 23 | 17 | 23 | 24 | 39 | 13 | 9 | 32 | 24 | 20 | 36 | 18 | 10 | 16
Primavera |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1
Printing | 38 | 42 | 47 | 25 | 44 | 45 | 34 | 33 | 38 | 19 | 41 | 31 | 36 | 32 | 23 | 26 | 31 | 25 | 29 | 27 | 43 | 23 | 35 | 25 | 38 | 25 | 44 | 30 | 35 | 38 | 41 | 43 | 40 | 50 | 19 | 37
Project | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 1 | 3 | 0 | 1 | 1 | 0 | 0 | 1
Radio Service | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0
Repairs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Sanitization | 0 | 0 | 1 | 38 | 5 | 12 | 12 | 12 | 6 | 4 | 10 | 0 | 3 | 0 | 2 | 3 | 5 | 1 | 5 | 6 | 0 | 6 | 4 | 16 | 26 | 3 | 4 | 8 | 8 | 12 | 1 | 1 | 1 | 14 | 1 | 12
Security Issues | 19 | 7 | 25 | 5 | 8 | 24 | 5 | 4 | 2 | 3 | 6 | 33 | 25 | 9 | 15 | 10 | 4 | 3 | 4 | 5 | 19 | 11 | 9 | 11 | 11 | 51 | 12 | 2 | 20 | 4 | 9 | 4 | 7 | 3 | 3 | 2
Security Notice | 6 | 1 | 2 | 3 | 3 | 7 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 2 | 2 | 3 | 3 | 8 | 3 | 6 | 9 | 10 | 7 | 5 | 3 | 12 | 11 | 0 | 5 | 5 | 4 | 8 | 2 | 2 | 8 | 8
Security RSA Tokens | 17 | 8 | 6 | 12 | 10 | 3 | 17 | 15 | 3 | 7 | 10 | 4 | 8 | 11 | 15 | 10 | 12 | 12 | 5 | 4 | 13 | 10 | 9 | 8 | 7 | 6 | 9 | 11 | 5 | 14 | 7 | 17 | 7 | 23 | 5 | 8
Server | 26 | 15 | 12 | 11 | 15 | 16 | 8 | 6 | 9 | 8 | 14 | 12 | 6 | 0 | 1 | 3 | 2 | 2 | 4 | 4 | 5 | 0 | 0 | 2 | 6 | 0 | 3 | 2 | 1 | 0 | 0 | 0 | 3 | 2 | 52 | 3
SW Install | 11 | 6 | 25 | 22 | 13 | 7 | 29 | 14 | 27 | 4 | 12 | 11 | 10 | 4 | 16 | 15 | 10 | 7 | 6 | 3 | 3 | 10 | 11 | 14 | 6 | 2 | 25 | 6 | 7 | 2 | 8 | 13 | 9 | 6 | 3 | 4
SW Issues | 73 | 81 | 104 | 98 | 119 | 120 | 109 | 75 | 88 | 86 | 83 | 96 | 93 | 79 | 76 | 94 | 66 | 61 | 73 | 61 | 75 | 114 | 71 | 61 | 86 | 73 | 89 | 63 | 69 | 105 | 91 | 58 | 80 | 91 | 40 | 65
SW Licenses | 5 | 3 | 4 | 7 | 9 | 8 | 13 | 5 | 3 | 7 | 6 | 14 | 9 | 8 | 5 | 9 | 9 | 7 | 21 | 4 | 17 | 10 | 10 | 2 | 10 | 9 | 11 | 12 | 6 | 4 | 8 | 10 | 7 | 5 | 0 | 6
Technology Enhancement | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Telephone | 22 | 5 | 16 | 27 | 18 | 19 | 41 | 26 | 32 | 22 | 22 | 17 | 21 | 19 | 15 | 19 | 27 | 24 | 17 | 19 | 33 | 38 | 22 | 11 | 22 | 16 | 18 | 20 | 13 | 30 | 16 | 24 | 43 | 33 | 14 | 26
Telephone Down | 5 | 4 | 4 | 1 | 3 | 0 | 5 | 4 | 3 | 2 | 4 | 9 | 4 | 4 | 5 | 9 | 1 | 4 | 8 | 8 | 2 | 3 | 4 | 4 | 14 | 6 | 4 | 5 | 1 | 5 | 7 | 7 | 9 | 10 | 10 | 8
Urgent | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VTC | 0 | 0 | 0 | 0 | 0 | 4 | 5 | 3 | 9 | 4 | 2 | 7 | 2 | 3 | 3 | 3 | 4 | 2 | 3 | 1 | 3 | 1 | 1 | 0 | 3 | 4 | 2 | 5 | 5 | 3 | 5 | 1 | 2 | 1 | 3 | 0
Wireless Device | 19 | 5 | 5 | 12 | 14 | 8 | 18 | 9 | 12 | 2 | 5 | 11 | 11 | 10 | 25 | 11 | 22 | 1 | 5 | 18 | 5 | 11 | 17 | 4 | 4 | 10 | 9 | 9 | 9 | 11 | 13 | 15 | 9 | 10 | 4 | 6
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  | 606
difference open-backlog