Spreadsheet: 96388d1295807133-condition-based-sumproduct-sumproduct
Sheet: Total Monthly Outages by Type

2011-01-01 00:00:00 | Total Annual Outages by Change Type
 | Last 12 Months | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total
 | BAU | 1 | 0 | 5 | 14 | 0 | 20
 | Minor | 1 | 3 | 8 | 10 | 0 | 22
 | Standard | 0 | 3 | 14 | 19 | 5 | 41
 | Major | 0 | 2 | 2 | 3 | 0 | 7
 | Emergency | 0 | 1 | 2 | 1 | 0 | 4
 | No Change | 0 | 1 | 2 | 3 | 0 | 6
 | Totals | 2 | 10 | 33 | 50 | 5 | 100 | 100
2010-01-01 00:00:00 | Jan-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 12
 | BAU | 0 | 0 | 0 | 2 | 0 | 2
 | Minor | 0 | 0 | 0 | 1 | 0 | 1
 | Standard | 0 | 0 | 1 | 3 | 2 | 6
 | Major | 0 | 0 | 0 | 0 | 0 | 0
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 0 | 1 | 6 | 2 | 9 | 9
2010-02-01 00:00:00 | Feb-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 11
 | BAU | 0 | 0 | 1 | 3 | 0 | 4
 | Minor | 0 | 0 | 2 | 1 | 0 | 3
 | Standard | 0 | 0 | 1 | 3 | 1 | 5
 | Major | 0 | 0 | 1 | 0 | 0 | 1
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 0 | 5 | 7 | 1 | 13 | 13
2010-03-01 00:00:00 | Mar-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 10
 | BAU | 0 | 0 | 1 | 2 | 0 | 3
 | Minor | 0 | 0 | 0 | 0 | 0 | 0
 | Standard | 0 | 1 | 1 | 1 | 0 | 3
 | Major | 0 | 0 | 0 | 1 | 0 | 1
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 0 | 1 | 0 | 1
 | Totals | 0 | 1 | 2 | 5 | 0 | 8 | 8
2010-04-01 00:00:00 | Apr-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 9
 | BAU | 0 | 0 | 2 | 1 | 0 | 3
 | Minor | 1 | 1 | 0 | 0 | 0 | 2
 | Standard | 0 | 0 | 1 | 0 | 1 | 2
 | Major | 0 | 1 | 0 | 1 | 0 | 2
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 1 | 0 | 1 | 0 | 2
 | Totals | 1 | 3 | 3 | 3 | 1 | 11 | 11
2010-05-01 00:00:00 | May-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 8
 | BAU | 0 | 0 | 1 | 0 | 0 | 1
 | Minor | 0 | 0 | 0 | 2 | 0 | 2
 | Standard | 0 | 1 | 0 | 0 | 0 | 1
 | Major | 0 | 0 | 0 | 0 | 0 | 0
 | Emergency | 0 | 0 | 1 | 0 | 0 | 1
 | No Change | 0 | 0 | 1 | 1 | 0 | 2
 | Totals | 0 | 1 | 3 | 3 | 0 | 7 | 7
2010-06-01 00:00:00 | Jun-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 7
 | BAU | 0 | 0 | 0 | 1 | 0 | 1
 | Minor | 0 | 0 | 1 | 1 | 0 | 2
 | Standard | 0 | 0 | 2 | 3 | 0 | 5
 | Major | 0 | 0 | 0 | 1 | 0 | 1
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 1 | 0 | 0 | 1
 | Totals | 0 | 0 | 4 | 6 | 0 | 10 | 10
2010-07-01 00:00:00 | Jul-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 6
 | BAU | 0 | 0 | 0 | 1 | 0 | 1
 | Minor | 0 | 0 | 1 | 0 | 0 | 1
 | Standard | 0 | 0 | 0 | 3 | 1 | 4
 | Major | 0 | 0 | 0 | 0 | 0 | 0
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 0 | 1 | 4 | 1 | 6 | 6
2010-08-01 00:00:00 | Aug-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 5
 | BAU | 1 | 0 | 0 | 1 | 0 | 2
 | Minor | 0 | 0 | 0 | 3 | 0 | 3
 | Standard | 0 | 1 | 3 | 3 | 0 | 7
 | Major | 0 | 1 | 0 | 0 | 0 | 1
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 1 | 2 | 3 | 7 | 0 | 13 | 13
2010-09-01 00:00:00 | Sep-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 4
 | BAU | 0 | 0 | 0 | 1 | 0 | 1
 | Minor | 0 | 0 | 1 | 1 | 0 | 2
 | Standard | 0 | 0 | 3 | 0 | 0 | 3
 | Major | 0 | 0 | 1 | 0 | 0 | 1
 | Emergency | 0 | 1 | 0 | 0 | 0 | 1
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 1 | 5 | 2 | 0 | 8 | 8
2010-10-01 00:00:00 | Oct-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 3
 | BAU | 0 | 0 | 0 | 2 | 0 | 2
 | Minor | 0 | 1 | 3 | 0 | 0 | 4
 | Standard | 0 | 0 | 0 | 2 | 0 | 2
 | Major | 0 | 0 | 0 | 0 | 0 | 0
 | Emergency | 0 | 0 | 0 | 1 | 0 | 1
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 1 | 3 | 5 | 0 | 9 | 9
2010-11-01 00:00:00 | Nov-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 2
 | BAU | 0 | 0 | 0 | 0 | 0 | 0
 | Minor | 0 | 0 | 0 | 0 | 0 | 0
 | Standard | 0 | 0 | 1 | 0 | 0 | 1
 | Major | 0 | 0 | 0 | 0 | 0 | 0
 | Emergency | 0 | 0 | 0 | 0 | 0 | 0
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 0 | 1 | 0 | 0 | 1 | 1
2010-12-01 00:00:00 | Dec-10 | Sev1 | Sev2 | Sev3 | Sev4 | Sev5 | Total |  |  |  | 1
 | BAU | 0 | 0 | 0 | 0 | 0 | 0
 | Minor | 0 | 1 | 0 | 1 | 0 | 2
 | Standard | 0 | 0 | 1 | 1 | 0 | 2
 | Major | 0 | 0 | 0 | 0 | 0 | 0
 | Emergency | 0 | 0 | 1 | 0 | 0 | 1
 | No Change | 0 | 0 | 0 | 0 | 0 | 0
 | Totals | 0 | 1 | 2 | 2 | 0 | 5 | 5