Spreadsheet: 862890d1710461964-calculate-deadlines-and-costs-ticket-calculator-eba
Sheet: Tickets (current)

 | This KPI measures performance against the Service Provider requirement to Fix Incident Severity Levels 1, 2, 3, 4 and 5 Incidents within the applicable Maximum Time to Fix.
 | Requirements |  |  |  |  |  | Performance | SEV1 | SEV2 | SEV3 | SEV4 | SEV5
 | Total Incidents by Severity level |  |  |  |  |  |  | 0 | 0 | 19 | 39 | 7
 | Resolved |  |  |  |  |  |  | 0 | 0 | 18 | 36 | 3
 | Open |  |  |  |  |  |  | 0 | 0 | 1 | 3 | 4
 | Resolved in Time |  |  |  |  |  |  | 0 | 0 | 18 | 36 | 3
 | Open Out of time |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | Fix time [NAME] |  |  |  |  |  | 0
 | Thresholds |  |  |  |  |  | Performance |  | Sev Ticket Calulator | Fix Time Failures | Total Cost
 | Target Performance Level: |  |  | zero Fix Time Failures |  |  |  |  | 1 | 4
 | Minor KPI Failure: |  |  | 1 to 3 Fix Time Failures |  |  |  |  | 2 | 1
 | Serious KPI Failure: |  |  | 4 to 6 Fix Time Failures |  |  |  |  | 3 | 1
 | Severe KPI Failure: |  |  | 7 to 9 Fix Time Failures |  |  |  |  | 4 | 2
 | KPI Service Threshold: |  |  | 10 or more Fix Time Failures |  |  |  |  | 5
 | Threshold Met: |  |  |  |  |  | Points
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | Direct Service Credit
 |  |  |  |  |  |  | 0
 | Comment
 | Issue key | Issue Type | Summary | Status | Resolution | Assignee | Reporter | Severity | Created | Resolved | Due date | On Time
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-30 07:26:00 | 2024-01-30 08:16:00 | 2024-02-06 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-26 06:25:00 | 2024-01-26 08:31:00 | 2024-02-02 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-25 06:22:00 | 2024-01-25 09:26:00 | 2024-02-01 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-24 14:01:00 | 2024-01-24 16:43:00 | 2024-01-31 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-24 06:29:00 | 2024-01-24 09:20:00 | 2024-01-31 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-23 14:34:00 | 2024-01-23 17:12:00 | 2024-01-30 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-23 12:31:00 | 2024-01-23 18:02:00 | 2024-01-30 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-23 06:37:00 | 2024-01-23 09:26:00 | 2024-01-30 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-22 15:19:00 | 2024-01-23 12:30:00 | 2024-01-29 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-22 07:06:00 | 2024-01-22 16:46:00 | 2024-01-29 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-22 06:25:00 | 2024-01-22 09:20:00 | 2024-01-29 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-19 06:21:00 | 2024-01-19 08:21:00 | 2024-01-26 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-18 17:55:00 | 2024-01-18 19:14:00 | 2024-01-25 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-18 05:54:00 | 2024-01-18 09:30:00 | 2024-01-25 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-17 06:22:00 | 2024-01-17 10:11:00 | 2024-01-24 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-16 14:45:00 | 2024-01-17 11:03:00 | 2024-01-23 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-16 06:14:00 | 2024-01-16 09:21:00 | 2024-01-23 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-15 06:13:00 | 2024-01-15 09:19:00 | 2024-01-22 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-3 | 2024-01-11 09:19:00 | 2024-01-11 09:40:00 | 2024-01-18 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-4 | 2024-01-30 08:22:00 | 2024-01-30 12:12:00 | 2024-02-27 00:00:00 | YES
 |  |  |  |  |  |  |  | Severity-4 | 2024-01-29 10:59:00 | NULL | 2024-02-26 00:00:00 | Still Open