JA23 MSPR Water.xlsx
XLSX spreadsheet 88 KB Posted
- Attached to
- Utilities Privatization of the Water System at U. S. Army Garrison-Hawaii (USAG-HI), Island of Oahu
- Solicitation number
- SP060026R0813
- Issued by
-
Defense Logistics Agency Energy
About this file
Summary of JA23 MSPR Water.xlsx
This file is a Monthly System Performance Report (MSPR) template for water utility systems at military installations. The template is designed to capture comprehensive operational data across multiple functional areas, including project status, customer information, work requests, reliability metrics, water quality, usage, and environmental compliance. The reporting structure includes detailed tabs for tracking emergency and urgent work requests, unscheduled interruptions, maintenance activities, and performance indices such as System Average Interruption Duration Index (SAIDI), System Average Interruption Frequency Index (SAIFI), Customer Average Interruption Duration Index (CAIDI), Average Service Availability Index (ASAI), and Connections Interrupted per Interruption Index (CIII).
The template requires installation-specific data including the number of water service connections, critical facilities, preventative and corrective work orders issued and closed, meter installations and reporting status, response times for emergency and urgent repairs (measured separately for duty and non-duty hours), and detailed information on unscheduled interruptions by component type (mains/laterals, backflow preventers, pumps, hydrants, valves) and cause (system-related or non-system-related). Additionally, the form captures water quality compliance data, boil water advisories, Notices of Violation (NOVs), regulatory sampling results, backflow preventer inventories, fire hydrant flushing and testing results, and customer satisfaction survey responses. The template includes similar reporting structures for wastewater systems, covering collection system reliability, treatment plant availability, leakage summaries, and maintenance activities. All data entry fields include specific instructions and dropdown menus to standardize reporting across military installations.
View the file
Other files
Show all 16
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Electric Reports
| Unplanned Outages | |||||
| Base Name/GSU | Unique Outage Identifier # | Year | Month Notified | Day Notified | Time Notified |
Author: Author:
Instructions: military time Time Arrived on Site Author: Author:
Instructions: military time Month Service Restoration Completed Day Service Restoration Completed Time Service Restoration Completed Author: Author:
Instructions: military time # Customers Affected Total # of Customers Base-identifed Critical / Non-Critical Building (CB/NCB/Both) Author: Author:
Add Drop down Cause Code Author: Author:
Added the actual descriptions instead of numbers because no one is going to remember all 43 codes Outage Type Author: Author:
Preventable (equip failure) Preventable (human error) Major Event Non-preventable (Supplier) Non-preventable (equip damage by others) Non-preventable (human damage by others) Other Remarks
Scheduled Interruptions Author: Author:
In instruction: insert one line for each) Author: Author:
| Instructions: military time | Emergency Generator Testing and Availability | Customer Satisfaction | |
| Month/Year | Requestor |
Author: Author:
Drop-down: System Owner; Installation; Power Provider; Other Author: Author:
Instructions: military time Purpose Author: Author:
Drop-down: Construction; Demolition; Inspection;Testing; Connection; Disconnection Other Author: Author:
Instructions: military time Author: Author:
Add Drop down Author: Author:
Added the actual descriptions instead of numbers because no one is going to remember all 43 codes Author: Author:
Preventable (equip failure) Preventable (human error) Major Event Non-preventable (Supplier) Non-preventable (equip damage by others)
Other Remarks Facility # Emergency Generator # Test Date (Month/Day/Year) Test Result Remarks Month/Year # of Surveys Conducted # of Positive Responses # of Negative Responses Remarks
| Metering Report | Maintenance Activities | |||||||||||
| Month/Year | Toal # AMR Meters Installed | % of Meters Reporting | Total # Analog Meters Installed | # Meters Calibrated | Remarks | Month/Year | # Preventative/Predictive Work Orders Issued | # Preventative/Predictive Work Orders Closed | # Corrective Work Orders Issued | # Corrective Work Orders Closed | # Line Locates | Remarks |
| Service Average Interruption Duration Index (SAIDI) - Minutes | Service Average Interruption Frequency Index (SAIFI) - # of Interruptions/Customer | ||||||||||||||
| Year | Total Customer Minutes of Interruption (Duration) | Total # of Customers Served | SAIDI | Month | Total # of Customers Interrupted | Total # of Customers Served | SAIDI | Year | Total # of Customers Interrupted | Total # of Customers Served | SAIFI | Month | Total # of Customers Interrupted | Total # of Customers Served | SAIFI |
| 0 | 0 | ||||||||||||||
| Total | 0 | ERROR:#DIV/0! | Total | 0 | 0 | 0.00 |
| Average Service Availability Index (ASAI) - % | Connections Interupted per Interuption Index (CIII) - Number | ||||||||||||||
| Year | Total Customer-hours Service Available (12-month avg) | Total # of Customer-hours Demanded | ASAI | Month | Total Customer-hours Service Available | Total # of Customer-hours Demanded | ASAI | Year | Total # of Customers (Connections) Interrupted | Total # of Interruptions | CIII | Month | Total # of Customers (Connections) Interrupted | Total # of Interruptions | CIII |
| 0 | 8760 |
Author: Author:
(Drop-down for 8760 (non-leap year & 8784 (leap year) 0.000 8760 Author: Author:
| (Drop-down for 8760 (non-leap year & 8784 (leap year) | 0 | 0 | 0 | |
| Total | 8760 |
Author: Author:
(Drop-down for 8760 (non-leap year & 8784 (leap year) Total
Annual Customer Average Interruption Duration Index (CAIDI) - Minutes Author: Author:
This just annual since we have the monthly SAIDI and SAIFI numbers below. The CAIDI cells will has a formula that duplicates SAIDI and SAIFI annual quantities.
Author: Author:
(Drop-down for 8760 (non-leap year & 8784 (leap year) Author: Author:
| (Drop-down for 8760 (non-leap year & 8784 (leap year) | Year | SAIDI | SAIFI | CAIDI |
| 0.00 | 0.00 | ERROR:#DIV/0! |
&"-,Bold"ELECTRIC MONTHLY SYSTEM PERFORMANCE REPORT
Electric Instructions
A. Project Status
| System Owner POC: (Name/e-mail) | |
| Contract Administering Officer (Name/e-mail): | |
| COR (Name/e-mail): | |
| Contract #: | |
| Contract Award Date: | |
| Contract Start Date: | |
| Project Title | |
| Author: Projects that reach 100% completion in the reported month should be removed from the following month's MSPR. | Project Type |
| Author: Initial System Deficiency Correction (ISDC), System Deficiency Correction (SDC), or Future Capital Upgrade (FCU). R&R is not captured on this tab. | CLIN # | Year Work Started | Est. Year of Completion | % Complete |
| Author: As of the reported month. | COR |
Comments
&"-,Bold"&10[SYSTEM OWNER]
[MONTH/YEAR] WATER SYSTEM - MONTHLY SYSTEM PERFORMANCE REPORT
Tab A - Project Status
Sheet2
B. Summary Information
| 1. CUSTOMER INFORMATION | 2. WORK REQUESTS & INSPECTIONS | 3. METERS | |||||
| Total # of water service connections | |||||||
| Author: Regardless of whether or not there's a meter at the connection | # Preventative/Predictive Work Requests Issued | # Meters Installed | |||||
| Total # of critical facilities | |||||||
| Author: As designated by the installation. | # Preventative/Predictive Work Requests Closed | # Meters Reporting | |||||
| Customer service feedback requested? | |||||||
| Author: "Customer" is defined here as one or more representatives of the organization served through the Work Request. Provide examples below if desired. | # Corrective Work Requests Issued | Meters Reporting as % | |||||
| Customer service feedback received? | |||||||
| Author: "Customer" is defined here as one or more representatives of the organization served through the Work Request. Provide examples below if desired. | # Corrective Work Requests Closed | # Meters not Reporting | |||||
| Primary means of customer service feedback requests | |||||||
| Author: This could be through written or online surveys, follow-up phone calls, or other. | # Regulatory inspections with significant deficiencies | ||||||
| # Water line locates conducted |
| 4. AVERAGE TIME (MINUTES) FROM RESPONSE TO REMEDY/DOWNGRADE | |||||||
| Emergency | Urgent | ||||||
| Repair crew on site | Remedy/Downgrade | Repair crew on site | Remedy/Downgrade | ||||
| DH | |||||||
| Author: Duty hours; R = Required by contract & A = average during the reporting period. | NDH | ||||||
| Author: Non-duty hours; R = required by contract & A = average in the reporting period. | DH | NDH | DH | NDH | DH | NDH | |
| R |
Author: Required per contract
| Author: Non-duty hours; R = required by contract & A = average in the reporting period. | A | |||||||||||||
| Author: Average minutes in reported month | R | A | R | A | R | A | R | A | R | A | R | A | R | A |
5. COMMENTS
Tab B - Summary Information
C. Reliability Data Notes Author: per IEEE Zoom worksheet to >/= 100% to enlarge fonts in dropdown menus.
- Outage/Interruption of service: an instance when water service, or a portion of the service, provided to one or more connections/customers is lost, interrupted, or curtailed, regardless of whether the water service supports base occupants or activities. The requirement to stop water delivery due to noncompliance with a code or regulation-driven requirement loss of ability of a distribution system component to deliver water is considered an unscheduled outage regardless of whether it was planned in advance. An outage may or may not cause an interruption of service.
- Planned outage: intentional disabling of a component’s capability to deliver utility service done at a pre-selected time, usually for the purposes of construction, preventative maintenance, or repair.
| 1. WORK REQUESTS ASSOCIATED WITH UNSCHEDULED INTERRUPTIONS | |||||
| WR ID # | |||||
| Author: As assigned by base's work request (WR) system. | Priority of WR | ||||
| Author: E = emergency; U = urgent (Note: routine/scheduled WRs are not included in the MSPR) | SO notified of interruption | SO's repair crew on site | Service restored | Duration | |
| Author: # of minutes of an interruption from time of notification to restoration of service. | # of customers experiencing interruption | ||||
| Author: Customer is defined as a facility with water service connection | Total customer minutes of interruption | Did critical facility/ies experience interruption? | |||
| Author: Based on base's designation of which facilities are "critical." | Did critical infrastructure connection experience interruption? | ||||
| Author: Interruption could cause an inability to continue successful delivery of any utility service. | Was interruption due to utility system malfunction? | Was interruption due to loss water from supplier? | |||
| Date | |||||
| Author: MO/DAY/YEAR | Time | ||||
| Author: Military format | Date | ||||
| Author: MO/DAY/YEAR | Time | ||||
| Author: Military format | Date |
Author: MO/DAY/YEAR Author: # of minutes of an interruption from time of notification to restoration of service. Time Author: Military format
Author: Customer is defined as a facility with water service connection Author: Based on base's designation of which facilities are "critical."
Author: Interruption could cause an inability to continue successful delivery of any utility service. TOTALS 0 0 0
2. NATURE OF UNSCHEDULED INTERRUPTIONS 3. # of EMERGENCY and URGENT WORK REQUESTS WITHOUT INTERRUPTIONS Author: This information indicates significant deficiencies on the installation and can be aggregated across the enterprise. It also indicates whether a reliability issue included an outage.
| 4a. BY COMPONENT | |||||||||
| Author: Use drop-down menu to indicate 1st, 2nd, 3rd, & 4th most problemmatic components. | 4b. BY CAUSE | ||||||||
| Author: Use drop-down menu to indicate 1st, 2nd, 3rd, & 4th most prevalent causes of component failures. | WR # | Primary Reason for WR | E | U | |||||
| #1 Issue | #2 Issue | #3 Issue | #4 Issue | #1 Issue | #2 Issue | #3 Issue | #4 Issue |
| 4. RELIABILITY INDICES | ||
| # of days in reported month | SAIDI | |
| Author: System Average Interruption Duration Index (SAIDI): avg outage duration in minutes experienced by all connections (service points). | SAIFI | |
| Author: System Average Interruption Frequency Index (SAIFI): # of interruptions per service point for all customers. | CIII | |
| Author: Connections interrupted per Interruption Index (CIII): average # of connections impacted per outage. | CAIDI | |
| Author: Customer Average Interruption Duration Index (CAIDI): avg minutes interrupted per interrupted connection/customer. | ASAI |
Author: Average Service Availability Index (ASAI): percentage of time water service was available to all connections/customers.
Total customer minutes Author: Based on # of days in the reported month: # of minutes of required service availability in the reported month) x (# of customers/connections).
Author: This information indicates significant deficiencies on the installation and can be aggregated across the enterprise. It also indicates whether a reliability issue included an outage.
Author: System Average Interruption Duration Index (SAIDI): avg outage duration in minutes experienced by all connections (service points).
Author: System Average Interruption Frequency Index (SAIFI): # of interruptions per service point for all customers.
Author: Connections interrupted per Interruption Index (CIII): average # of connections impacted per outage.
Author: Customer Average Interruption Duration Index (CAIDI): avg minutes interrupted per interrupted connection/customer.
Author: Average Service Availability Index (ASAI): percentage of time water service was available to all connections/customers. Totals 0 0
Tab C - Reliability Data
D. Work Requests
1. # OF EMERGENCY & URGENT WORK REQUESTS WITH/WITHOUT UNSCHEDULED INTERRUPTIONS
Author: Example: an Emergency WR was called in to repair a leak, the source of the leak was at a main, and the cause was solely related to the main (not external to it). In th is case an interruption in water service did not result, so put "1" in the cell under "Mains/Laterals," "Without Interruption," on the row for "System Related." Data for the cause of the leak is not gathered in this table.
| Emergency WRs | ||||||||
| Mains/Laterals | Backflow Preventers | Pumps | Hydrants | Valves | Multiple | |||
| Author: Provide information for this in space below. | Other - Natural | |||||||
| Author: Earthquakes, subsidence, lightning, heavy rains/floods, washouts, flotation, mudslides, scouring, temperature, frost heave, frozen components, high winds, or similar natural causes. Provide details in Table 2. | Other | |||||||
| Author: Loss of power to lift station nearby industrial cause, human error, fire or explosion; damage by vehicles or other equipment, intentional damage, including vandalism and terrorism. Provide details in Table 2. | Totals | |||||||
| Interruption | Without interruption | |||||||
| Author: # without associated interruption. | Interruption | Without interruption | ||||||
| Author: # without associated interruption. | Interruption | Without interruption | ||||||
| Author: # without associated interruption. | Interruption | Without interruption | ||||||
| Author: # without associated interruption. | Interruption | Without interruption | ||||||
| Author: # without associated interruption. | Interruption | Without interruption | ||||||
| Author: # without associated interruption. | Interruption | Without interruption | ||||||
| Author: # without associated interruption. | Interruption | Without interruption |
Author: # without associated interruption.
| System-related | 0 | ||||||||||||||||
| Non-system-related | 0 | ||||||||||||||||
| Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Urgent WRs Author: Example: an urgent/P2 WR was called in to repair a leak, the source of the leak was at a lateral, and the cause was solely related to the lateral (not external to it). In th is case an interruption in water service did not result, so put "1" in the cell under "Mains/Laterals," "Without Interruption," on the row for "System Related." Data for the cause of the leak is not gathered in this table.
Author: # without associated interruption.
| Author: # without associated interruption. | Mains/Laterals | Backflow Preventers | Pumps | Hydrants | Valves | Multiple | |
| Author: Provide information for this in space below. | Other - Natural | ||||||
| Author: Earthquakes, subsidence, lightning, heavy rains/floods, washouts, flotation, mudslides, scouring, temperature, frost heave, frozen components, high winds, or similar natural causes. Provide details in Table 2. | Other | ||||||
| Author: Loss of power, nearby industrial cause, human error, fire or explosion; damage by vehicles or other equipment, intentional damage, including vandalism and terrorism. Provide details in Table 2. | Totals | ||||||
| Interruption | Without interruption |
Author: # without associated interruption.
Author: Provide information for this in space below.
Author: # without associated interruption. Interruption Without interruption Author: # without associated interruption.
Author: Earthquakes, subsidence, lightning, heavy rains/floods, washouts, flotation, mudslides, scouring, temperature, frost heave, frozen components, high winds, or similar natural causes. Provide details in Table 2.
Author: # without associated interruption. Interruption Without interruption Author: # without associated interruption.
Author: Loss of power to lift station nearby industrial cause, human error, fire or explosion; damage by vehicles or other equipment, intentional damage, including vandalism and terrorism. Provide details in Table 2.
Author: # without associated interruption. Interruption Without interruption Author: # without associated interruption.
Author: # without associated interruption.
Author: Provide information for this in space below. Interruption Without interruption Author: # without associated interruption.
Author: Earthquakes, subsidence, lightning, heavy rains/floods, washouts, flotation, mudslides, scouring, temperature, frost heave, frozen components, high winds, or similar natural causes. Provide details in Table 2. Interruption Without interruption Author: # without associated interruption.
| Author: Loss of power, nearby industrial cause, human error, fire or explosion; damage by vehicles or other equipment, intentional damage, including vandalism and terrorism. Provide details in Table 2. | Interruption | Without interruption |
| Author: # without associated interruption. | Interruption | Without interruption |
Author: # without associated interruption.
| System-related | 0 | ||||||||||||||||
| Non-system-related | 0 | ||||||||||||||||
| Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
2. ADDITIONAL INFORMATION FOR "MULTIPLE" AND "OTHER"
Tab D - Work Requests (WRs)
E. Water Quality_Usage
1. WATER QUALITY 2. WATER QUALITY WRs Author: Enter the # of WRs submitted for each aspect of water quality.
| Water Quality WRs | Boil Water Advisories (BWAs) | Sampling | |||||||
| Author: Based on total of all tests taken for regulatory reporting and compliance | # reports for odor | # of reports for taste | # of reports for appearance | # testing requests | |||||
| # Opened | # Closed | # Issued | |||||||
| # Closed | % of acceptable compliance results |
| 3. NOVs | ||
| # in effect in reported month | # issued in reported month | # closed in reported month |
| Description of NOVs in effect prior to reported month | ||
| Author: Describe aspects such as: the rule for which the NOV was issued, complexity of closing, estimated time required to close, and whether or not it was in effect three years prior to conveyance. Text will wrap for additional space and Table 5 can be used if necessary. | Description of NOVs issued in reported month |
Author: Describe aspects such as: the rule for which the NOV was issued, complexity of closing, estimated time required to close, and whether or not it was in effect three years prior to conveyance. Text will wrap for additional space and Table 5 can be used if necessary.
Author: Describe aspects such as: the rule for which the NOV was issued, complexity of closing, estimated time required to close, and whether or not it was in effect three years prior to conveyance. Text will wrap for additional space and Table 5 can be used if necessary.
Author: Based on total of all tests taken for regulatory reporting and compliance
| Author: Enter the # of WRs submitted for each aspect of water quality. | 1 | 1 |
| 2 | 2 | |
| 3 | 3 |
| 4. METERS, BACKFLOW PREVENTERS, WATER USAGE | ||||
| # of meters in inventory | # of meters not in inventory | # of backflow preventers in inventory | # of backflow preventers not in inventory | |
| (base-owned) | System delivery (gals) |
5. REMARKS
&"Arial,Bold"&10&K000000[SYSTEM OWNER]
Tab E - Water Quality and Usage
F. Additional Information
| Instructions |
| Enter "N/A" in WR ID # column if remarks do not pertain to a WR. Rows will expand to accommodate text entered. Add rows/pages if necessary. |
WR ID # ADDITIONAL INFORMATION
INFORMATION ABOUT SIGNIFICANT R&R WORK PERFORMED IN THE REPORTED PERIOD
Tab F - Additional Information
Water Reports
| Unplanned Outages | ||||||||||||||
| Base Name/GSU | Unique Outage Identifier # | Year | Month Notified | Day Notified | Time Notified | Time Arrived on Site | Month Service Restoration Completed | Day Service Restoration Completed | Time Service Restoration Completed | # Customers Affected | Total # of Customers | Critical / Non-Critical Building (C/NC) | Failure Type | |
| Author: ROBINS, AISHA C GS-13 USAF AFMC AFCEC/CIMI: Total loss of service (all upstream pipes); Insufficient pressure-mechanical; Insufficient pressure-hydraulic; Excessive pressure-mechanical; Excessive pressure-hydraulic; Tank supply | Cascading Failures? (Y/N) | Outage Cause |
Author: Author:
Water main leak; Water service line leak; frozen line; loss of power to lift/pump station(s); damage to water system (equip cause); damage to system (human cause); damage to hydrant; major event Outage Type Author: Author:
Preventable (equip failure) Preventable (human error) Major Event Non-preventable (Supplier) Non-preventable (equip damage by others)
Other
| Scheduled Interruptions | ||
| Period | # of Scheduled Distribution Outages | # of Unplanned Full Loss of Water Delivery to Single Point of Service |
Author: Author:
Instruction: describe repairs & action taken or explain postponement in remarks. # of Unplanned, Sustained Water Pressure Reductions at Single Point of Service Author: Author:
| Instruction: describe repairs & action taken or explain postponement in remarks. | # of Unplanned Water Delivery Failures and/or Reductions Resulting in Cascading Failures | Total # of Affected Poins of Service | Remarks |
| < Month/Year> |
| Leakages | Service Connections Inspections | ||||||||||
| Period | Water Main Leaks | Service Lateral Leaks | Estimated Gallons Leaked | Remarks | Period | # Service Connections by Government | Inspection Date | Repair Date | # Service Connections by SO | Inspection Date | Remarks (results of inspections) |
| < Month> | < Month/Year> |
| Environmental Compliance | Customer Satisfaction Surveys - Water Service | ||||
| Date of Inspection | Inspecting Agency | Type of Inspection | Finding | Result |
Author: Author:
Drop down: Developed Plan for Remediation; Administrative Action (Notice of Enforcement or Notice of Violation); Civil Judicial Action Action Taken Date of Compliance Remarks Author: Author:
Instruction: describe nature of environmental issue(s) and NOV(s) and provide Government with all correspondence.
Author: Author:
Instruction: describe repairs & action taken or explain postponement in remarks.
Author: Author:
| Instruction: describe repairs & action taken or explain postponement in remarks. | Period | # of Surveys Conducted | # of Positive Responses | # of Negative Responses | |||
| < Month/Day/Year> | < Month/Day/Year> | <Month> |
| Water Metering Report | Boil Water Notices | |||||||
| Period | # Water Meters Installed | # Meters Reporting | Meters Reporting as % | Remarks | Notice Issued | Notice Recalled | Cause | Resolution |
| <Month> | 0.00 | <Month/Day/Year> | <Month/Day/Year> |
| Regulatory Bacteriological Sampling/Testing Report | Fire Hydrant Flushing & Testing | ||||
| Period | # Tests Conducted | % of Required Tests Conducted | % of Tests Passing | Remarks |
Author: Author:
Instructions: describe results and follow-up actions.
| Author: ROBINS, AISHA C GS-13 USAF AFMC AFCEC/CIMI: Total loss of service (all upstream pipes); Insufficient pressure-mechanical; Insufficient pressure-hydraulic; Excessive pressure-mechanical; Excessive pressure-hydraulic; Tank supply | Period | # Hydrants Flushed | % of Hydrant Inventory Flushed | # Hydrants Flow Tested (hydraulic model) | % of Hydrant Inventory Tested | Remarks | |
| <Month> | 0.00 | 0.00 | <Month> |
| Maintenance Activities | Backflow Preventer Inspection & Testing | |||||||||
| Period | # Preventative/ Predictive Work Orders Issued | # Preventative/ Predictive Work Orders Closed | # Corrective Work Orders Issued | # Corrective Work Orders Closed | Remarks | Period | # SO-owned Backflow Preventers | # SO-owned Backflow Preventers Inspected & Tested | DoD Backflow Preventers Inspected & Tested | Remarks |
| < Month/Year> | <Month> |
| Service Average Interruption Duration Index (SAIDI) | Service Average Interruption Frequency Index (SAIFI) | ||||||||||||||
| Reporting Period (Year) | Total Customer Minutes of Interruption (Duration) | Total # of Customers Served | Resulting SAIDI (minutes) | Month | Total # of Customers Interrupted | Total # of Customers Served | Resulting SAIDI (#) | Reporting Period (Year) | Total # of Customers Interrupted | Total # of Customers Served | Resulting SAIFI (number) | Month | Total # of Customers Interrupted | Total # of Customers Served | Resulting SAIFI (%) |
| 2014 | 8 | 67 | 0.12 | 3 | 2 | 67 | 0.03 | 2014 | 8 | 67 | 0.12 | 3 | 2 | 67 | 2.99% |
| 5 | 4 | 67 | 0.06 | 5 | 4 | 67 | 5.97% | ||||||||
| 7 | 2 | 67 | 0.03 | 7 | 2 | 67 | 2.99% | ||||||||
| Monthly Total | 8 | 67 | 0.12 | Monthly Total | 8 | 67 | 11.94% |
| Average Service Availability Index (ASAI) | Connections Interupted per Interuption Index (CIII) | ||||||||||||||
| Reporting Period (Year) | Total Customer-hours Service Available (12-month avg) | Total # of Customer-hours Demanded | Resulting ASAI (%) | Month | Total Customer-hours Service Available (12-month avg) | Total # of Customer-hours Demanded | Resulting ASAI (%) | Reporting Period (Year) | Total # of Customers (Connections) Interrupted | Total # of Interruptions | Resulting CIII (number) | Month | Total # of Customers Interrupted | Total # of Interruptions | Resulting CIII (#) |
| 2014 | 8760 | 8760 | 1.0000 | 3 | 8760 | 8760 | 100.000 | 2014 | 8 | 4 | 2 | 3 | 2 | 4 | 0.5 |
| 5 | 8400 | 8760 | 95.890 | 5 | 4 | 4 | 1.0 | ||||||||
| 7 | 8692 | 8760 | 99.224 | 7 | 2 | 4 | 0.5 | ||||||||
| 25852 | 8760 | Monthly Total | 8 | 4 | 2.0 |
| Customer Average Interruption Duration Index (CAIDI) | |||||||
| Reporting Period (Year) | Total Customer Minutes of Sustained Interruption (Duration) | Total # of Customers Interrupted | Resulting CAIDI (minutes) | Month | Total Customer Minutes of Interruption (Duration) | Total # of Customers Interrupted | Resulting CAIDI (#) |
| 2014 | 46 | 12 | 3.83 | 3 | 20 | 4 | 5.0 |
| 5 | 20 | 6 | 3.3 | ||||
| 7 | 6 | 2 | 3.0 | ||||
| Monthly Total | 46 | 12 | 3.83 |
&"-,Bold"Water Monthly System Performance Report
Wastewater Reports Base Name GSU? (Geographically Seperated Unit) Author: Author:
What does GSU stand for? Geographically seperated Unit Start Year Start Month Start Day Start Time Month Notified Day Notified Time Notified Time Arrived on Site Completion Month Completion Day Completion Time Complete Restoration of Service? (drop down Y/N) Cause Resolved or Needs Additional Work? (drop down R=resolved; AW=additional work) # Customers. Affected Critical / Non-Critical Building (C/NC) Cause Code Type Author: Author:
| Awaiting Types from Aisha | Remarks | |||||||||||||||||
| Pentagon | N | 2016- | 1 | 3 | 7:59 | 1 | 3 | 8:00 | NA | 1 | 3 | 8:02 | 1 | NC | DR | C | Resolved remotely; inspected equipment after event | |
| Pentagon | N | 2016- | 1 | 10 | 11:30 | 1 | 10 | 13:00 | 13:49 | 1 | 10 | 13:58 | 2 | NC | FF | NC | Downed power line off base | |
| Pentagon | N | 2016- | 3 | 14 | 9:00 | 3 | 14 | 10:00 | 14:19 | 3 | 14 | 17:25 | 15 | NC | EF | M | Roads to base impassable | |
| Pentagon | Y | 2016- | 6 | 18 | 5:15 | 6 | 18 | 7:00 | 7:30 | 6 | 18 | 9:30 | 4 | C | EC | NC | Additional time required for locating point of outage origin; building not occupied when outage occurred | |
| Pentagon | N | 2016- | 10 | 3 | 9:00 | 10 | 3 | 7:30 | 7:41 | 10 | 3 | 10:07 | 3 | C | TN | NC | Work by CES impacted transformer; awaiting parts; power supplied by emergency generator as work-around | |
| Pentagon | Y | 2016 | 12 | 31 | UNK | 1 | 2 | 7:00 | 7:45 | 1 | 2 | 8:15 | 1 | NC | WS | NC | Outage occurred over New Year’s holiday; delayed notification by CES |
| Drop-down list | ||||||||
| Wastewater Utility Reliability Analysis | Wastewater Collection Connections | Wastewater Collection Average Service Availability Index (ASAI) | ||||||
| Period | SAIDI | Period | CIII | Period | ASAI | |||
| <Month>/<Year> | 0.00 | Minutes | <Month>/<Year> | 0.00 | Connections | <Month>/<Year> | 0.00 | % |
| Avg Year to Date | 0.00 | Minutes | Avg Year to Date | 0.00 | Connections | Avg Year to Date | 0.00 | % |
| <Month> Prior Year | 0.00 | Minutes | <Month> Prior Year | 0.00 | Connections | <Month> Prior Year | 0.00 | % |
| Total Prior Year | 0.00 | Minutes | Total Prior Year | 0.00 | Connections | Total Prior Year | 0.00 | % |
Wastewater Collection System Inflow and Infiltration (I&I) Author: Author:
| If metered | Wastewater Collection Outage | |||||||||||||
| Period | Potable Water to Distribution (kgals) | Wastewater Collected | Wastewater kgals | Remarks | Period | # of Scheduled Outages | # of Unscheduled Outages | Cause of Unscheduled Outage(s) | # of After-hours Outages | Total Outage Minutes | Total # of Affected Services | Remarks | ||
| <Month> | <Month> |
Wastewater Collection, Treatment, and Lift Stations Maintenance Activities
| Instructions: Treatment only as applicable. | Water Treatment Plant Availability Summary | ||||||
| Period | Preventative/Predictive Work Order Issued | Preventative/Predictive Work Order Closed | Corrective Work Orders Issued | Corrective Work Orders Closed | # of Significant Maintenance Issues |
Author: Author:
| Instructions: "Where applicable/Describe below." | Wastewater Line Locates | Period | # of Scheduled Equipment Outages | # of Unscheduled Equipment Outages | Cause of Unscheduled Equipment Outage(s) | # of After-hours Outages | % of Time System Available | |
| < Month/Year> | <Month> |
Waste Treatment Maintenance Summary
Instructions: Treatment only as applicable.
Period Preventative/Predictive Work Order Issued Preventative/Predictive Work Order Closed Corrective Work Orders Issued Corrective Work Orders Closed # of Significant Maintenance Issues Author: Author:
| Instructions: "Where applicable/Describe below." | Wastewater Line Locates |
| Wastewater Collection Leakage Summary |
Author: Author:
Instructions: Treatment only as applicable.
Author: Author:
What does GSU stand for? Geographically seperated Unit Author: Author:
| Awaiting Types from Aisha | < Month/Year> | ||||
| Period | Wastewater Main Leaks | Service Lateral Leaks | Estimated Gallons Spilled | Remarks | |
| < Month/Year> |
Wastewater Flushing & Inspection
| Instructions: Treatment only as applicable. | Customer Satisfaction Surveys - Wastewater System | |||||||||
| Period | Wastewater Main Flushed (ft) | Service Lateral Flushed | Piping Inspected via CCTV (ft) | Remarks | Period | # of Surveys Conducted | # of Responses | # of Customer Interactions |
Author: Author:
Other than Surveys Author: Author:
Instructions: Treatment only as applicable.
Author: Author:
Instructions: Treatment only as applicable.
Author: Author:
Instructions: Treatment only as applicable.
Author: Author:
Instructions: "Where applicable/Describe below."
Author: Author:
| Instructions: "Where applicable/Describe below." | # of Positive Responses | # of Negative Responses | ||
| < Month/Year> | <Month> | |||
| <Year> to Date |
Wastewater Instructions
File details come from the government source that posted it. Updated .