Spreadsheet: 127809d1320588617-replacing-values-in-excel-sheet-trial-asset-management-ps-data-with-activity-roots
Sheet: PS 03

Location | Asset_ID | Description | Asset_Type | Condition | Performance | Reliability | Redundancy | Criticality | Installed_Date | Purchase_Price | Current_Value | Manufacturer | Model | SIZE | Comments | Owner | Attachments | Retired_Date
PS 3 | T24-11Q1 | Main Incomer Breaker | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | NS 160H/TM 125D | 125 Amp 4 Pole
PS 3 | T24-11Q2 | Generator Incomer Breaker | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | NS 160H/TM 125D | 125 Amp 4 Pole
PS 3 | T24-11P1 | Power Monitroing Unit | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Circutor | CVM 96,M51211
PS 3 | T24-11P2 | FEWA KWH Meter | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service
PS 3 | T24-11SA | Surge Arrestor | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Cirprote | [NAME]
PS 3 | T24-11UVR1 | Voltage Monitoring Relay | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Telemecanique | RM4 TR32
PS 3 | T24-21Q1 | Pump A - Incomer Breaker | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | NS 80H/MA 50 | 50 Amp 3 Pole
PS 3 | T24-21F0 | [NAME] | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | DF3FR100
PS 3 | T24-21SS1 | Soft Starter A | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | ATS48D47Q | 21 KW
PS 3 | T24-21KM1 | Line Contactor A | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | LC1-D80 F7
PS 3 | T24-21KM2 | By-Pass Contactor A | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | LC1-D80 F7
PS 3 | T24-21KC1 | Capacitor Contactor A | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Telemecanique | LC1-DLK11 F7
PS 3 | T24-21C1 | Capacitor Bank A | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | 51321 | 15 KVAR
PS 3 | T24-21P1 | Pump A - Ammeter | Electrical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for long periods without affecting normal operations |  |  |  | Circutor | EC-72,0-50/5A AMMETER (5P)
PS 3 | T24-21HC1 | Pump A - Run Hr Meter | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for long periods without affecting normal operations |  |  |  | Revalco | 110 V AC 72 MM SIZE
PS 3 | T24-31MC1 | Pump A- Moisture Relay | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | MK9151.11
PS 3 | T24-TH1 | Pump A - Thermistor Relay | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | BA9038
PS 3 | T24-31Q1 | Pump B - Incomer Breaker | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | NS 80H/MA 50 | 50 Amp 3 Pole
PS 3 | T24-31F0 | [NAME] | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | DF3FR100
PS 3 | T24-31SS1 | Soft Starter B | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | ATS48D47Q | 21 KW
PS 3 | T24-31KM1 | Line Contactor B | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | LC1-D80 F7
PS 3 | T24-31KM2 | By-Pass Contactor B | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telemecanique | LC1-D80 F7
PS 3 | T24-31KC1 | Capacitor Contactor B | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Telemecanique | LC1-DLK11 F7
PS 3 | T24-31C1 | Capacitor Bank B | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | 51321 | 15 KVAR
PS 3 | T24-31P1 | Pump B - Ammeter | Electrical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for long periods without affecting normal operations |  |  |  | Circutor | EC-72,0-50/5A AMMETER (5P)
PS 3 | T24-31HC1 | Pump B - Run Hr Meter | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for long periods without affecting normal operations |  |  |  | Revalco | 110 V AC 72 MM SIZE
PS 3 | T24-31MC1 | Pump B - Moisture Relay | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | MK9151.11
PS 3 | T24-31TH1 | Pump B - Thermistor Relay | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | [NAME] | BA9038
PS 3 | T24-21T01 | Control Transformer A | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Trafomodern | STN 0.4, 230/110V/50 HZ
PS 3 | T24-31T01 | Control Transformer B | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Trafomodern | STN 0.4 ,230/110V/50 HZ
PS 3 | T24-MC1A-CABLE | Pump A - Motor Cable | Electrical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | KSB | 19555973-KSB | 834
PS 3 | T24-MC1A-WINDING | Pump A - Motor Winding | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  | KSB
PS 3 | T24-MC1B-CAB | Pump B - Motor Cable | Electrical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | KSB | 19555973-KSB | 834
PS 3 | T24-MC1B-WINDING | Pump B- Motor Winding | Electrical | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  | KSB
PS 3 | T24-MC1A | Pump A | Mechanical | Minor Defects Only | Exceeds / Meets all Performance Targets | [NAME] | 50% standby | Moderatly affecting normal operations, if out of service |  |  |  | KSB | KRT E 150 – 315/234 XG-295
PS 3 | T24-MC1A-IMP | Pump A - Impeller | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | KSB | 18200355-KSB | Type - E 230
PS 3 | T24-MC1A-VC | Pump A - Volute Casing | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | KSB
PS 3 | T24-MC1A-WR | Pump A - Casing wear ring | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | KSB | 11303081-KSB | 502
PS 3 | T24-MC1A-MS | Pump A - Mechanical Seal | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | KSB | 19551930-KSB | 433
PS 3 | T24-MC1A-BRG | Pump A - Bearings | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | KSB
PS 3 | T24-MC1A-ROTOR | Pump A - Rotor | Mechanical | New or Excellent Condition | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  | KSB
PS 3 | T24-MC1B | Pump B | Mechanical | Minor Defects Only | Exceeds / Meets all Performance Targets | [NAME] | 50% standby | Moderatly affecting normal operations, if out of service |  |  |  | KSB | KRT E 150 – 315/234 XG-295
PS 3 | T24-MC1B-IMP | Pump B - Impeller | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | KSB | 18200355-KSB | Type - E 230
PS 3 | T24-MC1B-VC | Pump B - Volute Casing | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service
PS 3 | T24-MC1B-WR | Pump B - Casing Wear ring | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  |  | 11303081-KSB | 502
PS 3 | T24-MC1B-MS | Pump B - Mechanical Seal | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  |  | 19551930-KSB | 433
PS 3 | T24-MC1B-BRG | Pump B - Bearings | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service
PS 3 | T24-MC1B-ROTOR | Pump B - Rotor | Mechanical | New or Excellent Condition | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service
PS 3 | T24-MC1A-DF | Pump A - Duct footing | Mechanical | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service
PS 3 | T24-MC1A-GR | Pump A - Guide Railing | Mechanical | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Moderatly affecting normal operations, if out of service
PS 3 | T24-MC1A-DL | Pump A - Discharge Line | Mechanical | Minor Defects Only | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  |  |  | DN 250
PS 3 | T24-MC1A-CHAIN | Pump A - Chain | Mechanical | Minor Defects Only | Exceeds / Meets all Performance Targets | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | T24V1A | Pump A - NRV | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  | SAMSUN | Flanged with Lever & Counterweight | DN 250  PN 16
PS 3 | T24V2A | Pump A - Isolation Valve | Mechanical | Minor Defects Only | Exceeds / Meets all Performance Targets | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations |  |  |  | SAMSUN | Gate Valve with Flange Connection | DN 250  PN 16
PS 3 | T24-MC1B-DF | Pump B - Duct footing | Mechanical | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service
PS 3 | T24-MC1B-GR | Pump B - Guide Railing | Mechanical | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Moderatly affecting normal operations, if out of service
PS 3 | T24-MC1B-DL | Pump B - Discharge Line | Mechanical | Minor Defects Only | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  |  |  | DN 250
PS 3 | T24-MC1B-CHAIN | Pump B - Chain | Mechanical | Moderate Deterioration | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | T24V1B | Pump B - NRV | Mechanical | Moderate Deterioration | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  | SAMSUN | Flanged with Lever & Counterweight | DN 250  PN 16
PS 3 | T24V2B | Pump B - Isolation Valve | Mechanical | New or Excellent Condition | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations |  |  |  | SAMSUN | Gate Valve with Flange Connection | DN 250  PN 16
PS 3 | T24-MAIN DISCHARGE | Main Discharge Line | Mechanical | New or Excellent Condition | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service
PS 3 | T24Z1 | Air Release Auto Vent | Mechanical | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | AQUA-GAS/AVK | Blk Al. Self Acting, Double Orifice - Flanged | DN 80 PN 16
PS 3 | T24V4 | Pump Discharge AV Isolation | Mechanical | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby, but spares available (in store or locally) | Moderatly affecting normal operations, if out of service |  |  |  | SAMSUN | Gate Valve with Flange Connection | DN 80 PN 16
PS 3 | T24V6 | Incoming Penstock | Mechanical | Minor Defects Only | Considerable Performance Deficiencies | [NAME] | No standby and spares are not available | Normal operations severely hampered, if out of service |  |  |  | FONTAINE | Stainless Steel Wall Mounted | DN 600
PS 3 | T24-41LC3-SENSOR | Level Sensor | Instrumentation | Minor Defects Only | Exceeds / Meets all Performance Targets | As Specified by [NAME] | 50% standby | Asset can be out of service for short periods without affecting normal operations |  |  |  | Endress & Hauser | FDU 91 JG1AA
PS 3 | T24-41LC3-TRANS | Level Transmitter | Instrumentation | Minor Defects Only | Exceeds / Meets all Performance Targets | As Specified by [NAME] | 50% standby | Asset can be out of service for short periods without affecting normal operations |  |  |  | Endress & Hauser | FMU 90 -R12EA161AA1A
PS 3 | T24-41LC1 | Level Probes/Float Switch | Instrumentation | Minor Defects Only | Exceeds / Meets all Performance Targets | Occasional Breakdown | 50% standby | Asset can be out of service for short periods without affecting normal operations |  |  |  | Hawker/Flyte | ENM 10
PS 3 | T24P13 | Discharge Pressure Gauge | Instrumentation | Moderate Deterioration | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for long periods without affecting normal operations |  |  |  | PARKER | 0-06 BAR-0.5 LC | 1/2 " BSP x 4"
PS 3 | T24-41PLC | PLC unit | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | MICROLOGIX 1200 ,1762-L40BWAR
PS 3 | T24-41DIC | Input Card | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | 1762-IQ16
PS 3 | T24-41DOC | Output Card | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | 1762-OW16
PS 3 | T24-41IFC | AIC Convertor | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | 1761-NET-AIC
PS 3 | T24-41SM | SCADA Modem | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Siemens | MC35i
PS 3 | T24-41GM | GSM Modem | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | Occasional Breakdown | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Telic | STD 35
PS 3 | T24-41T02 | Control Transformer | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | Trafomodern | [NAME]
PS 3 | T24-41PS1 | Power Supply Unit | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | SN4050B17 (24 VOLT DC STABLISED SUPPLY)
PS 3 | T24-41VF1 | Ventilation Fan | Instrumentation | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | Himel | VF130+FS 130 (230 VOLT AC)
PS 3 | T24-41UPS | UPS | Instrumentation | Minor Defects Only | Minor Performance Deficiencies | Occasional Breakdown | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | APC | 500 VA, 230 volt AC
PS 3 | T24-41Q0 | [NAME] for Ins Panel | Instrumentation | New or Excellent Condition | Exceeds / Meets all Performance Targets | [NAME] | No standby, but spares available (in store or locally) | Normal operations severely hampered, if out of service |  |  |  | [NAME] | INS63-28902
PS 3 | T24-SC01 | Sump Covers | Civil | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | T24-SC02 | Sump Covers | Civil | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | T24-SC03 | Sump Covers | Civil | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | [NAME] | Cast Iron Covers | Civil | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | T24-TK2 | Valve Chamber | Civil | Minor Defects Only | Minor Performance Deficiencies | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | [NAME] | Wet Well | Civil | Minor Defects Only | Considerable Performance Deficiencies | [NAME] | No standby and spares are not available | Asset can be out of service for short periods without affecting normal operations
PS 3 | T24-KIOSK | Kiosk | Civil | Minor Defects Only | Exceeds / Meets all Performance Targets | As Specified by [NAME] | No standby, but spares available (in store or locally) | Asset can be out of service for short periods without affecting normal operations |  |  |  | GRP Industries