Spreadsheet: 96399d1295815027-copy-paste-without-references-ocm
Sheet: 3) Events Roll-up

A) NA Total Events by Severity |  |  |  |  |  |  |  | E) NA Total % of Problems caused by Change
Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  | Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total
Jan'10 | 0 | 6 | 21 | 113 | 30 | 170 |  | Jan'10 | 0 | 0 | 0.04761904761904762 | 0.05309734513274336 | 0.06666666666666667 | 0.05294117647058823
Feb'10 | 0 | 1 | 27 | 99 | 21 | 148 |  | Feb'10 | 0 | 0 | 0.1851851851851852 | 0.0707070707070707 | 0.04761904761904762 | 0.08783783783783784
Mar'10 | 1 | 3 | 22 | 87 | 17 | 130 |  | Mar'10 | 0 | 0 | 0.1363636363636364 | 0.05747126436781609 | 0 | 0.06153846153846154
Apr'10 | 2 | 5 | 29 | 69 | 17 | 122 |  | Apr'10 | 0 | 0.6 | 0.103448275862069 | 0.04347826086956522 | 0.05882352941176471 | 0.09016393442622951
May'10 | 1 | 5 | 27 | 95 | 19 | 147 |  | May'10 | 0 | 0.2 | 0.1111111111111111 | 0.03157894736842105 | 0 | 0.04761904761904762
Jun'10 | 1 | 4 | 30 | 120 | 7 | 162 |  | Jun'10 | 0 | 0 | 0.1333333333333333 | 0.05 | 0 | 0.06172839506172839
Jul'10 | 1 | 4 | 29 | 122 | 9 | 165 |  | Jul'10 | 0 | 0 | 0.03448275862068965 | 0.03278688524590164 | 0.1111111111111111 | 0.03636363636363636
Aug'10 | 3 | 5 | 28 | 122 | 11 | 169 |  | Aug'10 | 0 | 0.4 | 0.1071428571428571 | 0.05737704918032787 | 0 | 0.07692307692307693
Sep'10 | 2 | 5 | 22 | 144 | 13 | 186 |  | Sep'10 | 0 | 0.2 | 0.2272727272727273 | 0.01388888888888889 | 0 | 0.04301075268817205
Oct'10 | 1 | 4 | 38 | 109 | 19 | 171 |  | Oct'10 | 0 | 0.25 | 0.07894736842105263 | 0.04587155963302753 | 0 | 0.05263157894736842
Nov'10 | 1 | 5 | 24 | 121 | 19 | 170 |  | Nov'10 | 0 | 0 | 0.04166666666666666 | 0 | 0 | 0.005882352941176471
Dec'10 | 2 | 6 | 32 | 85 | 12 | 137 |  | Dec'10 | 0 | 0.1666666666666667 | 0.0625 | 0.01176470588235294 | 0 | 0.0291970802919708
Year-to-date Total | 15 | 53 | 329 | 1286 | 194 | 1877 |  | Year-to-date % | 0.1333333333333333 | 0.169811320754717 | 0.1033434650455927 | 0.03810264385692069 | 0.02577319587628866 | 0.0527437400106553
B) NA Total Problems caused by Change |  |  |  |  |  |  |  | F) NA Total Attempted Changes per Month
Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  | Month | Total
Jan'10 | 0 | 0 | 1 | 6 | 2 | 9 |  | Jan'10 | 1874
Feb'10 | 0 | 0 | 5 | 7 | 1 | 13 |  | Feb'10 | 1773
Mar'10 | 0 | 0 | 3 | 5 | 0 | 8 |  | Mar'10 | 2083
Apr'10 | 1 | 3 | 3 | 3 | 1 | 11 |  | Apr'10 | 1972
May'10 | 0 | 1 | 3 | 3 | 0 | 7 |  | May'10 | 1790
Jun'10 | 0 | 0 | 4 | 6 | 0 | 10 |  | Jun'10 | 1677
Jul'10 | 0 | 0 | 1 | 4 | 1 | 6 |  | Jul'10 | 1612
Aug'10 | 1 | 2 | 3 | 7 | 0 | 13 |  | Aug'10 | 1610
Sep'10 | 0 | 1 | 5 | 2 | 0 | 8 |  | Sep'10 | 1500 | Total column on the USBC1100C_CM KPI totals Attempted Only.rpt
Oct'10 | 0 | 1 | 3 | 5 | 0 | 9 |  | Oct'10 | 1818 | Reconfirm all prior months totals
Nov'10 | 0 | 0 | 1 | 0 | 0 | 1 |  | Nov'10 | 1551
Dec'10 | 0 | 1 | 2 | 1 | 0 | 4 |  | Dec'10 | 1330
Year-to-date Total | 2 | 9 | 34 | 49 | 5 | 99 |  | Year-to-date Total | 20590
YTD Average | 0.1666666666666667 | 0.75 | 2.833333333333333 | 4.083333333333333 | 0.4166666666666667 | 8.25
C) NA Total Problems by LSA (OCM3) - CSC & Retained |  |  |  |  |  |  |  | G) NA % of Changes that caused Outage Events
Month | Canada | Exchg | Mngmt | ZNA | All |  |  | Month | Total
Jan'10 |  |  |  |  |  |  |  | Jan'10 | 0.0048025613660619
Feb'10 |  |  |  |  |  |  |  | Feb'10 | 0.007332205301748449
Mar'10 |  |  |  |  |  |  |  | Mar'10 | 0.003840614498319731
Apr'10 |  |  |  |  |  |  |  | Apr'10 | 0.005578093306288032
May'10 | 0 | 1 | 1 | 3 |  |  |  | May'10 | 0.003910614525139665
Jun'10 | 1 | 3 | 6 | 5 | 12 |  |  | Jun'10 | 0.005963029218843173
Jul'10 | 1 | 1 | 2 | 1 | 4 |  |  | Jul'10 | 0.003722084367245658
Aug'10 | 0 | 4 | 1 | 1 | 8 |  |  | Aug'10 | 0.008074534161490683
Sep'10 | 0 | 1 | 0 | 2 | 3 |  |  | Sep'10 | 0.005333333333333333
Oct'10 | 0 | 2 | 5 | 2 | 8 |  |  | Oct'10 | 0.004950495049504951
Nov'10 | 0 | 0 | 2 | 4 | 6 |  |  | Nov'10 | 0.0006447453255963894
Dec'10 | 1 | 0 | 3 | 2 | 5 |  |  | Dec'10 | 0.003007518796992481
Year-to-date Total | 3 | 12 | 20 | 20 | 46 |  |  | Year-to-date % | 0.004808159300631374
D) NA Total Problems - CSC ISP Trans. Only by LSA (SLA 2.4.2) ** |  |  |  |  |  |  |  | H) NA Total PIR Reports Due
 | LSA Affected |  |  |  |  |  |  |  | This Month |  | Next Month |  | Total for Month |  | Monthly | Monthly
Month | Canada | Exchg | Mngmt | ZNA | All |  |  | Month | Total | Late | Total | Late | Total | Late | % Late | % On Time
Jan'10 |  |  |  |  |  |  |  | Dec'09 | 8 | 5 | 8 | 6 | 8 | 5 | 0.625 | 0.375
Feb'10 |  |  |  |  |  |  |  | Jan'10 | 3 | 1 | 6 | 2 | 11 | 7 | 0.6363636363636364 | 0.3636363636363636
Mar'10 |  |  |  |  |  |  |  | Feb'10 | 2 | 1 | 11 | 2 | 8 | 3 | 0.375 | 0.625
Apr'10 |  |  |  |  |  |  |  | Mar'10 | 7 | 0 | 1 | 0 | 18 | 2 | 0.1111111111111111 | 0.8888888888888888
May'10 | 0 | 1 | 1 | 3 | 5 |  |  | Apr'10 | 4 | 1 | 7 | 0 | 5 | 1 | 0.2 | 0.8
Jun'10 | 1 | 3 | 3 | 4 | 8 |  |  | May'10 | 3 | 0 | 4 | 0 | 10 | 0 | 0 | 1
Jul'10 | 0 | 0 | 2 | 1 | 3 |  |  | Jun'10 | 8 | 0 | 2 | 0 | 12 | 0 | 0 | 1
Aug'10 | 0 | 1 | 0 | 0 | 4 |  |  | Jul'10 | 2 | 0 | 3 | 0 | 4 | 0 | 0 | 1
Sep'10 | 0 | 0 | 0 | 1 | 1 |  |  | Aug'10 | 7 | 0 | 3 | 0 | 10 | 0 | 0 | 1
Oct'10 | 0 | 2 | 5 | 2 | 7 |  |  | Sep'10 | 2 | 0 | 5 | 0 | 5 | 0 | 0 | 1
Nov'10 | 0 | 0 | 0 | 3 | 3 |  |  | Oct'10 | 3 | 0 | 4 | 0 | 8 | 0 | 0 | 1
Dec'10 | 1 | 0 | 1 | 2 | 3 |  |  | Nov'10 | 0 | 0 | 1 | 0 | 4 | 0 | 0 | 1
Year-to-date Total | 2 | 7 | 12 | 16 | 34 |  |  | Dec'10 | 4 | 0 | 0 | 0 | 5 | 0 | 0 | 1
 |  |  |  |  |  |  |  | Year-to-date Total |  |  |  |  | 100 | 13 | 0.13 | 0.87
NOTES: |  |  |  |  |  |  |  | Section H) | Note: Change the bolded months below to match the current reporting period:
** Since changes can affect more than one LSA, the totals above cannot be reconciled |  |  |  |  |  |  |  |  | J70 = December tab - PIR due in December minus retained groups
to any other count on these worksheets back.  [NAME] not added to the Tool until |  |  |  |  |  |  |  |  | K70 = Due in December completed late or not at all minus retained groups
05/01/10 and will not be reflected on changes before that time |  |  |  |  |  |  |  |  | L70 = December tab due in January minus retained groups
 |  |  |  |  |  |  |  |  | M70 = Calculated in January with December PIRs late minus retained groups
Section C) | 1) Take the events from the Rolling 13 file where the PIR Due Date is equal to the current report month and add up the LSA counts (“1”) from columns E-H and enter into the appropriate LSA column.  Remember that a change record can affect more than one LSA. 2) Enter the total number of changes for the current reporting period into column for ALL.
Section D) | 1) Take the events from the Rolling 13 file where the PIR Due Date is equal to the current report month minus any change where column T is set to “Y” and the assignment group begins with ASP.  Add up the LSA counts (“1”) from columns E-H and enter into the appropriate LSA column.  Remember that a change record can affect more than one LSA. 2) Enter the total number of changes for the current reporting period into column for ALL