Spreadsheet: 96398d1295815027-copy-paste-without-references-sumproduct
Sheet: Events Rollup

 | 2011-01-01 00:00:00
 |  |  |  |  | A) NA Total Events by Severity |  |  |  |  |  |  |  |  | E) NA Total % of Problems caused by Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00
 |  |  | Key1 | Month | Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Totals |  |  | Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
 |  |  | 12 | 2010-01-01 00:00:00 | Jan-10 | 0 | 6 | 21 | 113 | 30 | 170 |  |  | Jan-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00
 |  |  | 11 | 2010-02-01 00:00:00 | Feb-10 | 0 | 1 | 27 | 99 | 21 | 148 |  |  | Feb-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00
 |  |  | 10 | 2010-03-01 00:00:00 | Mar-10 | 1 | 3 | 22 | 87 | 17 | 130 |  |  | Mar-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00
 |  |  | 9 | 2010-04-01 00:00:00 | Apr-10 | 2 | 5 | 29 | 69 | 17 | 122 |  |  | Apr-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00
 |  |  | 8 | 2010-05-01 00:00:00 | May-10 | 1 | 5 | 27 | 95 | 19 | 147 |  |  | May-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  | 7 | 2010-06-01 00:00:00 | Jun-10 | 1 | 4 | 30 | 120 | 7 | 162 |  |  | Jun-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  | 6 | 2010-07-01 00:00:00 | Jul-10 | 1 | 4 | 29 | 122 | 9 | 165 |  |  | Jul-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  | 5 | 2010-08-01 00:00:00 | Aug-10 | 3 | 5 | 28 | 122 | 11 | 169 |  |  | Aug-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
 |  |  | 4 | 2010-09-01 00:00:00 | Sep-10 | 2 | 5 | 22 | 144 | 13 | 186 |  |  | Sep-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00
 |  |  | 3 | 2010-10-01 00:00:00 | Oct-10 | 1 | 4 | 38 | 109 | 19 | 171 |  |  | Oct-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00
 |  |  | 2 | 2010-11-01 00:00:00 | Nov-10 | 1 | 5 | 24 | 121 | 19 | 170 |  |  | Nov-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00
 |  |  | 1 | 2010-12-01 00:00:00 | Dec-10 | 2 | 6 | 32 | 85 | 12 | 137 |  |  | Dec-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00
 |  |  |  |  | YTD Totals | 15 | 53 | 329 | 1286 | 194 | 1877 |  |  | % YTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
 |  |  |  |  | B) NA Total Problems Caused by Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-01 00:00:00
 |  |  | Key1 | Month | Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Totals |  |  | F) NA Total Attempted Changes per Month | Month | Totals |  | G) NA % of Changes that caused Outage Events | Month | Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-01 00:00:00
 |  |  | 12 | 2010-01-01 00:00:00 | Jan-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Jan-10 | #N/A |  |  | Jan-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00
 |  |  | 11 | 2010-02-01 00:00:00 | Feb-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Feb-10 |  |  |  | Feb-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
 |  |  | 10 | 2010-03-01 00:00:00 | Mar-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Mar-10 |  |  |  | Mar-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-01 00:00:00
 |  |  | 9 | 2010-04-01 00:00:00 | Apr-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Apr-10 |  |  |  | Apr-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-01 00:00:00
 |  |  | 8 | 2010-05-01 00:00:00 | May-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | May-10 |  |  |  | May-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-01 00:00:00
 |  |  | 7 | 2010-06-01 00:00:00 | Jun-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Jun-10 |  |  |  | Jun-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-01 00:00:00
 |  |  | 6 | 2010-07-01 00:00:00 | Jul-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Jul-10 |  |  |  | Jul-10
 |  |  | 5 | 2010-08-01 00:00:00 | Aug-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Aug-10 |  |  |  | Aug-10
 |  |  | 4 | 2010-09-01 00:00:00 | Sep-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Sep-10 |  |  |  | Sep-10
 |  |  | 3 | 2010-10-01 00:00:00 | Oct-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Oct-10 |  |  |  | Oct-10
 |  |  | 2 | 2010-11-01 00:00:00 | Nov-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Nov-10 |  |  |  | Nov-10
 |  |  | 1 | 2010-12-01 00:00:00 | Dec-10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | Dec-10 |  |  |  | Dec-10
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | C) NA Total Problems by LSA (OCM3) - CSC & Retained |  |  |  |  |  |  |  |  | H) NA Total PIR Reports Due
 |  |  | Key1 | Month | Month | Canada | Exchange | Management | ZNA | All |  |  |  |  | This Month |  | Next Month |  | Total for Month |  | Monthly | Monthly
 |  |  | 12 | 2010-01-01 00:00:00 | Jan-10 | 0 | 0 | 0 | 0 |  |  |  |  | Month | Total | Late | Total | Late | Total | Late | % Late | % On Time
 |  |  | 11 | 2010-02-01 00:00:00 | Feb-10 | 0 | 0 | 0 | 0 |  |  |  |  | Jan-10
 |  |  | 10 | 2010-03-01 00:00:00 | Mar-10 | 0 | 0 | 0 | 0 |  |  |  |  | Feb-10
 |  |  | 9 | 2010-04-01 00:00:00 | Apr-10 | 0 | 0 | 0 | 0 |  |  |  |  | Mar-10
 |  |  | 8 | 2010-05-01 00:00:00 | May-10 | 0 | 1 | 1 | 1 |  |  |  |  | Apr-10
 |  |  | 7 | 2010-06-01 00:00:00 | Jun-10 | 1 | 3 | 6 | 5 |  |  |  |  | May-10
 |  |  | 6 | 2010-07-01 00:00:00 | Jul-10 | 0 | 1 | 2 | 1 |  |  |  |  | Jun-10
 |  |  | 5 | 2010-08-01 00:00:00 | Aug-10 | 1 | 5 | 4 | 3 |  |  |  |  | Jul-10
 |  |  | 4 | 2010-09-01 00:00:00 | Sep-10 | 0 | 1 | 1 | 6 |  |  |  |  | Aug-10
 |  |  | 3 | 2010-10-01 00:00:00 | Oct-10 | 0 | 2 | 5 | 3 |  |  |  |  | Sep-10
 |  |  | 2 | 2010-11-01 00:00:00 | Nov-10 | 0 | 0 | 2 | 4 |  |  |  |  | Oct-10
 |  |  | 1 | 2010-12-01 00:00:00 | Dec-10 | 1 | 0 | 3 | 2 |  |  |  |  | Nov-10
 |  |  |  |  |  | 3 | 13 | 24 | 25 |  |  |  |  | Dec-10
 |  |  |  |  | D) NA Total Problems - CSC ISP Trans. Only by LSA (SLA 2.4.2) **
 |  |  | Key1 | Month | Month | Canada | Exchange | Management | ZNA | All
 |  |  | 12 | 2010-01-01 00:00:00 | Jan-10
 |  |  | 11 | 2010-02-01 00:00:00 | Feb-10
 |  |  | 10 | 2010-03-01 00:00:00 | Mar-10
 |  |  | 9 | 2010-04-01 00:00:00 | Apr-10
 |  |  | 8 | 2010-05-01 00:00:00 | May-10
 |  |  | 7 | 2010-06-01 00:00:00 | Jun-10
 |  |  | 6 | 2010-07-01 00:00:00 | Jul-10
 |  |  | 5 | 2010-08-01 00:00:00 | Aug-10
 |  |  | 4 | 2010-09-01 00:00:00 | Sep-10
 |  |  | 3 | 2010-10-01 00:00:00 | Oct-10
 |  |  | 2 | 2010-11-01 00:00:00 | Nov-10
 |  |  | 1 | 2010-12-01 00:00:00 | Dec-10
 |  |  |  |  |  | 0 | 0 | 0 | 0