Spreadsheet: 148905d1333611249-formulas-no-longer-working-with-date-format-excel-example_change-in-date-format
Sheet: Table input

Graphs' Input: Incidents
Tickets by Status - Graph 1 |  |  |  |  |  |  | Tickets by Category - Graph 2
Current week | Y |  |  |  |  |  | Current week | Y
Count of Ticket # | Column Labels |  |  |  |  |  | Count of Ticket # | Column Labels
Row Labels | Severity 3 | Severity 4 | Grand Total |  |  |  | Row Labels | Severity 3 | Severity 4 | Grand Total |  |  |  | [NAME] | Base Value | Element Values | Label Spaces | C1 | C2 | [NAME] | C4
resolved | 6 | 9 | 15 |  |  |  | Administration | 1 | 1 | 2 |  |  |  | Total Incidents | 0 |  | 15
cancelled |  | 1 | 1 |  |  |  | AIX | 3 | 2 | 5 |  |  |  | Severity 1 |  |  | 15
Grand Total | 6 | 10 | 16 |  |  |  | Windows |  | 2 | 2 |  |  |  | Severity 2 |  |  | 15
 |  |  |  |  |  |  | Service Request |  | 1 | 1 |  |  |  | Severity 3 |  |  | 15
 |  |  |  |  |  |  | Backup Failure | 1 | 3 | 4 |  |  |  | Severity 4 | 0 |  | 15
 |  |  |  |  |  |  | Printing | 1 |  | 1
 |  |  |  |  |  |  | N/A |  | 1 | 1
 |  |  |  |  |  |  | Grand Total | 6 | 10 | 16
Important Data: Incidents
Current week | (All)
Total Tickets submitted |  |  |  |  |  | Incidents by Support Agent
Row Labels | Count of Ticket # |  |  |  |  | Count of Ticket # | Column Labels
Severity 1 | 20 |  |  |  |  | Row Labels | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | Grand Total
Severity 2 | 23 |  |  |  |  | Severity 1 | 1 | 13 |  |  |  | 3 | 1 | 1 |  | 19
Severity 3 | 217 |  |  |  |  | Severity 2 | 1 | 10 | 2 | 3 | 1 |  | 1 | 1 | 2 | 21
Severity 4 | 99 |  |  |  |  | Severity 3 | 30 | 93 | 7 | 10 | 12 | 6 | 18 | 3 | 28 | 207
Grand Total | 359 |  |  |  |  | Severity 4 | 25 | 34 | 1 | 7 | 3 | 3 | 3 | 1 | 13 | 90
 |  |  |  |  |  | Grand Total | 57 | 150 | 10 | 20 | 16 | 12 | 23 | 6 | 43 | 337
Teams that raise incidents
Row Labels | Count of Ticket # |  | Week resolved | (Multiple Items) |  |  |  |  | EERP Infrastructure: Incident Status |  |  |  |  |  |  | Week Reported | (Multiple Items)
 | 168 |  | Total Tickets submitted |  |  |  |  |  | Severity | Total | Resolved | In-progress | Pending |  |  | Pending Stats
Infosys | 91 |  |  | Column Labels |  |  |  |  | Severity 1 | 0 | 0 | 0 | 0 |  |  |  | Column Labels
Technology Service Delivery (TSD) | 40 |  |  | Severity 2 | Severity 3 | Severity 4 | Grand Total |  | Severity 2 | 2 | 2 | 0 | 0 |  |  |  | Severity 2 | Severity 3 | Severity 4 | Grand Total
Accenture | 43 |  | Count of Ticket # | 2 | 48 | 13 | 63 |  | Severity 3 | 48 | 48 | 0 | 0 |  |  | Count of Ticket # | 2 | 34 | 13 | 49
IS/IT BAU | 3 |  |  |  |  |  |  |  | Severity 4 | 15 | 13 | 0 | 2
Grand Total | 345 |  |  |  |  |  |  |  | Total
Graph's Input: Changes
Change creation vs completion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week Change Implemented | NOT COMPLETED
Count of Change Number | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status | (Multiple Items) |  |  |  |  | Week Change Entered | 2
Row Labels | 42 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | Grand Total
42 | 4 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | Row Labels | Count of Change Number |  |  |  |  | Row Labels | Count of Change Number
43 |  | 2 | 1 | 1 |  |  |  |  |  |  | 4 |  |  |  |  | Expedite | 5 |  | UNIX | 3 |  | Expedite | 6
44 |  | 1 | 1 | 3 |  |  |  |  |  |  | 5 |  |  |  |  | Storage | 2 |  | SAN | 2 |  | Normal | 1
45 |  |  | 2 | 1 | 1 |  |  |  |  |  | 4 |  |  |  |  | UNIX | 3 |  |  |  |  | Grand Total | 7
46 |  |  |  | 1 |  |  |  |  | 1 |  | 2 |  |  |  |  | Grand Total | 5
47 |  |  |  |  | 1 |  |  |  |  |  | 1
48 |  |  |  |  | 1 | 3 | 1 |  |  |  | 5
50 |  |  |  |  |  |  |  | 2 | 2 | 2 | 6
10 |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  | 4 | unix |  | Changes Implemented |  |  | Changes Awaiting Implementation |  |  |  |  |  | EERP Infrastructure: Change Status
Grand Total | 4 | 3 | 4 | 6 | 3 | 3 | 1 | 2 | 4 | 2 | 32 |  |  |  |  |  |  |  | 1 | wintel |  | Change Type | Count |  | Change Type |  | Count |  |  |  | Change Type | Total | Completed | Pending
Row Labels | Count of Change Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emergency | 0 |  | Emergency |  | 0 |  |  |  | Normal | 2 | 1 | 1
Emergency | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expedite | 2 |  | Expedite |  | 5 |  |  |  | Expedited | 5 | 5 | 0
Expedite | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Normal | 0 |  | Normal |  | 0 |  |  |  | Emergency | 0 | 0 | 0
Normal | 21
Grand Total | 90
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Base Value | Element Values | Label Spaces | C1 | C2 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Total Changes | 0 |  | 10
Row Labels | Count of Change Number |  |  |  |  |  |  |  |  |  | Emergency |  |  | 10
[NAME] | 2 |  |  |  |  |  |  |  |  |  | Expedite |  |  | 10
Approved | 2 |  |  |  |  |  |  |  |  |  | Normal | 0 |  | 10
Cancelled | 16
Completed | 69
Grand Total | 89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duplicate | (Multiple Items)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Severity 1 | Grand Total
Graphs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002910268
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:21:27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 349 |  |  |  |  |  |  |  |  |  |  | 2012-01-17 09:44:32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  | INC000002910382
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  | 23:06:28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 214 |  |  |  |  |  |  |  |  |  |  | 2012-01-17 09:59:31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92 |  |  |  |  |  |  |  |  |  |  | INC000002912508
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:41:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-17 16:40:57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002914669
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:30:16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-18 08:52:20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002917436
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:33:56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-18 22:10:31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002933694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:14:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-24 13:20:31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002933791
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:44:58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-24 13:49:33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002936901
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:41:12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-25 09:59:08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INC000002944609
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:13:31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-27 12:07:35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duplicate | no
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Count of Ticket # | Sum of Hours to Resolve
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 71 | 180 days, 18:05:50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Severity 1 | 7 | 1 day, 21:01:13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Severity 2 | 4 | 11 days, 11:05:14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Severity 3 | 36 | 60 days, 8:01:47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Severity 4 | 24 | 107 days, 1:57:36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 71 | 180.7540509259295