Spreadsheet: 96365d1295780568-rolling-12-months-data-question-new
Sheet: Tables

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E ) Last 12 Months - Problems Caused by Change Scorecard
 | D ) Total Annual Outages by Change Type |  |  |  |  |  |  |  |  | A) NA Total Events by Severity |  |  |  |  |  |  |  |  | Source from Raw Data 1
 | Source from Raw data 1 |  |  |  |  |  |  |  |  | Source from Raw Data 2 |  |  |  |  |  |  |  |  | Group | Jan'10 | Feb'10 | Mar'10 | Apr'10 | May'10 | Jun'10 | Jul'10 | Aug'10 | Sep'10 | Oct'10 | Nov'10 | Dec'10 | YTD Total
 | Last 12 Months | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | ASP - Release Related |  |  |  |  |  |  |  |  |  |  |  |  | 0
Change Type | BAU | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Jan'10 |  |  |  |  |  | 0 |  |  | aspna_ade |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Feb'10 |  |  |  |  |  | 0 |  |  | aspna_auto |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Mar'10 |  |  |  |  |  | 0 |  |  | aspna_client_serv |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Apr'10 |  |  |  |  |  | 0 |  |  | aspna_commerical |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0 |  |  | May'10 |  |  |  |  |  | 0 |  |  | aspna_crn |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Jun'10 |  |  |  |  |  | 0 |  |  | aspna_eagent |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Jul'10 |  |  |  |  |  | 0 |  |  | aspna_ecls |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Aug'10 |  |  |  |  |  | 0 |  |  | aspna_e-cms |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Jan'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Sep'10 |  |  |  |  |  | 0 |  |  | aspna_edge |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  | Oct'10 |  |  |  |  |  | 0 |  |  | aspna_facts |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  | Nov'10 |  |  |  |  |  | 0 |  |  | aspna_farmers_life |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  | Dec'10 |  |  |  |  |  | 0 |  |  | aspna_foremost |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  | Year-to-date Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | aspna_hpbs |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aspna_home |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aspna_qm |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | B) NA Total Problems caused by Change |  |  |  |  |  |  |  |  | aspna_rtd |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Source from Raw data 1 |  |  |  |  |  |  |  |  | aspna_servicepoint |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Feb'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Month | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | aspna_sap_dev |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  | Jan'10 |  |  |  |  |  | 0 |  |  | aspna_soa_admin |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  | Feb'10 |  |  |  |  |  | 0 |  |  | aspna_usams_ais |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  | Mar'10 |  |  |  |  |  | 0 |  |  | aspna_usams_ccweb |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  | Apr'10 |  |  |  |  |  | 0 |  |  | aspna_usams_ciid |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  | May'10 |  |  |  |  |  | 0 |  |  | aspna_usams_cms |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  | Jun'10 |  |  |  |  |  | 0 |  |  | aspna_usams_corpan |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Jul'10 |  |  |  |  |  | 0 |  |  | aspna_usams_dbl |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Aug'10 |  |  |  |  |  | 0 |  |  | aspna_usams_ddc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Mar'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Sep'10 |  |  |  |  |  | 0 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  | Oct'10 |  |  |  |  |  | 0 |  |  | aspna_usams_ezacce |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  | Nov'10 |  |  |  |  |  | 0 |  |  | aspna_usams_ezbyad |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  | Dec'10 |  |  |  |  |  | 0 |  |  | aspna_usams_iram |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  | Year-to-date Total | 0 | 0 | 0 | 0 | 0 | 0 |  |  | aspna_usams_pcr |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  | YTD Average | 0 | 0 | 0 | 0 | 0 | 0 |  |  | aspna_usams_rams |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aspna_usams_ri |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | C) NA Total Problems by LSA (OCM3) |  |  |  |  |  |  |  |  | aspna_usams_rie |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Source from Raw data 1 |  |  |  |  |  |  |  |  | aspna_usams_riskpro |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Apr'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Month | Canada | Exchg | Mngmt | ZNA | All |  |  |  | aspna_usams_workbench |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  | Jan'10 |  |  |  |  |  |  |  |  | aspna_usams_zcenter |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  | Feb'10 |  |  |  |  |  |  |  |  | aspna_usams_zsoa |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  | Mar'10 |  |  |  |  |  |  |  |  | aspna_usams_zspire |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  | Apr'10 |  |  |  |  |  |  |  |  | Bristol West |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  | May'10 |  |  |  |  |  |  |  |  | Foremost CSC |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  | Jun'10 |  |  |  |  |  |  |  |  | HelpPoint |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Jul'10 |  |  |  |  |  |  |  |  | ispna_caz_intel |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | Aug'10 |  |  |  |  |  |  |  |  | ispna_caz_oprs/prod |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | May'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  | Sep'10 |  |  |  |  |  |  |  |  | ispna_dcs_automation-dist |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  | Oct'10 |  |  |  |  |  |  |  |  | ispna_dcs_automation-mf |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  | Nov'10 |  |  |  |  |  |  |  |  | ispna_dcs_facilites_okc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  | Dec'10 |  |  |  |  |  |  |  |  | ispna_dcs_facilites_sch |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  | Year-to-date Total | 0 | 0 | 0 | 0 | 0 |  |  |  | ispna_dcs_ladc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_ops |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_dcs_prod_inet |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | ispna_dcs_tape-dist |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_dcs_tape-mf |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Jun'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc-sch_storage-dist |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_dist_security |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_gad |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_grdc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_internet |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_ladc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_notes |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_okdc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_storage-dist |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Jul'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc-sch_storage-dist |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_tech |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_termsvr |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_distsvc_unix |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ewp_swd |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_filenet_p8 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_firewall |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | ispna_netwksvc_engineering |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_netwksvc_support |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Aug'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  |  |  |  |  |  |  |  |  | ispna_netwksvc_telecom-w |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_netwkvoice_ops |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_netwkvoice_support |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ngito_datacenter_okdc |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_nt_platform_support |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_nt_terminal_server |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_servicepoint_telecom |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | ispna_ts_cics |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_dbase-mf |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Sep'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_dbal-bal |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_dbase-dist |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_dbase-specialty |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_dir_svc_ldap |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_notes |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_storage-mf |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_mq |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | ispna_ts_os390 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_vtam-tcp_ip |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Oct'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  |  |  |  |  |  |  |  |  | ispna_ts_websphere |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | BAU |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | supeu_csc-na-ewp2 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Minor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZDU/UUG |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Standard |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ZNA ASP |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Major |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vendor |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Emergency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wintel |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | No Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unknown - TBD |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | YTD Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Nov'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total
 | BAU
 | Minor
 | Standard
 | Major
 | Emergency
 | No Change
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Dec'10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total
 | BAU
 | Minor
 | Standard
 | Major
 | Emergency
 | No Change
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0