Spreadsheet: 92251d1291873599-automatically-adjusting-a-formula-for-new-data-dashboard12810
Sheet: Outstanding Trend

Call Type | 3-Jul | 10-Jul | 17-Jul | 24-Jul | 31-Jul | 7-Aug | 14-Aug | 21-Aug | 28-Aug | 4-Sep | 11-Sep | 18-Sep | 25-Sep | 2-Oct | 9-Oct | 16-Oct | 23-Oct | 30-Oct | 6-Nov | 13-Nov | 20-Nov | 27-Nov | 4-Dec | Delta |  | Mean | STDEV
Calling Cards | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cancelled | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Database Issues | 4 | 6 | 1 | 7 | 6 | 9 | 7 | 7 | 2 | 0 | 1 | 0 | 4 | 1 | 1 | 1 | 1 | 4 | 7 | 0 | 0 | 2 | 0
Equipment Loan | 33 | 28 | 31 | 29 | 32 | 35 | 32 | 34 | 31 | 29 | 39 | 44 | 32 | 29 | 27 | 30 | 36 | 36 | 32 | 31 | 31 | 32 | 36
GroupWise | 4 | 6 | 8 | 8 | 5 | 8 | 8 | 7 | 7 | 4 | 7 | 9 | 6 | 10 | 3 | 8 | 4 | 5 | 8 | 7 | 5 | 7 | 5
HeatService | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1
HW Install | 4 | 6 | 6 | 4 | 4 | 2 | 4 | 5 | 8 | 6 | 4 | 9 | 12 | 6 | 1 | 3 | 4 | 5 | 7 | 7 | 1 | 1 | 2
HW Issues | 6 | 5 | 3 | 4 | 4 | 4 | 7 | 9 | 5 | 2 | 2 | 3 | 5 | 3 | 1 | 2 | 1 | 5 | 3 | 2 | 0 | 0 | 1
InfoDesk | 16 | 14 | 14 | 13 | 12 | 12 | 13 | 11 | 12 | 11 | 11 | 8 | 8 | 7 | 6 | 6 | 6 | 8 | 6 | 0 | 0 | 0 | 1
Internet/Intran | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Internet_Other | 2 | 1 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 2
ISER | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
LanAdmin Access | 0 | 0 | 2 | 1 | 2 | 0 | 2 | 1 | 0 | 0 | 2 | 2 | 1 | 3 | 0 | 6 | 2 | 2 | 1 | 4 | 1 | 0 | 1
[NAME] | 3 | 5 | 3 | 2 | 61 | 1 | 5 | 2 | 1 | 1 | 1 | 2 | 4 | 3 | 5 | 21 | 6 | 6 | 3 | 8 | 5 | 3 | 4
M1 Support | 28 | 4 | 8 | 4 | 4 | 3 | 6 | 7 | 9 | 9 | 9 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 2 | 2 | 2 | 2 | 3
Network Issues | 6 | 8 | 5 | 8 | 7 | 4 | 2 | 5 | 4 | 5 | 4 | 6 | 5 | 5 | 3 | 1 | 2 | 2 | 2 | 4 | 8 | 6 | 6
Network Task | 26 | 26 | 32 | 32 | 40 | 34 | 31 | 15 | 20 | 19 | 22 | 21 | 29 | 25 | 15 | 12 | 18 | 24 | 20 | 21 | 20 | 24 | 24
ORD | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PC Setup | 33 | 37 | 30 | 36 | 36 | 37 | 44 | 45 | 57 | 43 | 28 | 35 | 43 | 31 | 16 | 15 | 30 | 37 | 34 | 38 | 28 | 28 | 30
Primavera |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 1
Printing | 3 | 2 | 2 | 3 | 6 | 5 | 5 | 11 | 18 | 18 | 25 | 29 | 3 | 5 | 4 | 7 | 1 | 2 | 3 | 7 | 3 | 1 | 1
Project | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 11 | 12 | 12 | 12 | 12 | 15 | 15 | 15 | 17 | 17 | 18 | 18 | 18 | 18 | 17
Radio Service | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0
Repairs | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sanitization | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Security Issues | 1 | 4 | 5 | 5 | 4 | 6 | 7 | 5 | 4 | 4 | 6 | 8 | 10 | 10 | 5 | 1 | 1 | 0 | 0 | 2 | 2 | 2 | 2
Security Notice | 1 | 2 | 3 | 1 | 6 | 7 | 10 | 12 | 5 | 4 | 6 | 7 | 14 | 17 | 14 | 16 | 21 | 21 | 23 | 24 | 23 | 28 | 13
Security RSA Tokens | 0 | 2 | 0 | 0 | 1 | 2 | 3 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 3 | 0 | 1 | 1
Server | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SW Install | 3 | 2 | 3 | 6 | 5 | 2 | 4 | 3 | 3 | 3 | 4 | 4 | 2 | 4 | 2 | 5 | 3 | 4 | 6 | 5 | 4 | 3 | 2
SW Issues | 17 | 31 | 32 | 27 | 24 | 32 | 32 | 31 | 48 | 31 | 29 | 28 | 17 | 21 | 21 | 19 | 24 | 26 | 16 | 30 | 24 | 20 | 22
SW Licenses | 0 | 2 | 2 | 0 | 2 | 2 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 2 | 4 | 0 | 1 | 0 | 3 | 2 | 0 | 0
Technology Enhancement | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
Telephone | 15 | 21 | 19 | 30 | 38 | 40 | 41 | 34 | 32 | 27 | 18 | 18 | 24 | 17 | 21 | 20 | 28 | 29 | 27 | 25 | 22 | 25 | 24
Telephone Down | 1 | 2 | 3 | 2 | 3 | 5 | 6 | 4 | 3 | 4 | 3 | 2 | 3 | 1 | 4 | 2 | 3 | 2 | 2 | 0 | 1 | 4 | 3
VTC | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1
Wireless Device | 14 | 32 | 35 | 50 | 42 | 37 | 18 | 15 | 16 | 20 | 11 | 9 | 3 | 4 | 6 | 10 | 12 | 14 | 24 | 23 | 25 | 28 | 20
Grand Total
This chart displays a count of the tickets that are not closed on a given day and represents our backlog of work.