Atch_10_Monthly_Substation_Report.xlsx

XLSX spreadsheet 62 KB Posted

Attached to
FA4610-19-Q-A001 Substation Maintenance Federal contract opportunity
Solicitation number
FA4610-19-Q-A001
Issued by
Department of the Air Force Space Command

About this file

Monthly Substation Report template. The first tab is an example of a filled out report. The most recent sanitized report will be given to the awardee.

View the file

Other files for this federal contract opportunity

Other files attached to FA4610-19-Q-A001 Substation Maintenance, newest first.
File Type Posted
QA_Substation_Maintenance_20190404.pdf PDF
Atch_8_Substation_Mnx_RFQ-R1.xlsx XLSX spreadsheet
Atch_2_PWS-R1_Sub_Mnx_20190403.pdf PDF
19QA001_Sub_Mnx_SV_Minutes.pdf PDF
Atch_4_Substations_Layout.PDF PDF
Atch_2_PWS_Substation_Maintenance_20181126.pdf PDF
Atch_8_Substation_Mnx_RFQ.xlsx XLSX spreadsheet
Atch_5_Environmental_Compliance.pdf PDF
Atch_7_Teaming_Arrangement.docx DOCX document
Atch_3_SCA_WD_15-5647_R7_20181226.PDF PDF
Atch_1_Clauses_20190227.pdf PDF
Atch_6_Technical_Questionnaire_Substation_Mnx_20190207.doc DOC document
Show all 12

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Examples Examples & Guidance

Exterior InspectionStatusDiscrepancies if any
PerimeterIn this field, enter "OK" or "Note #"Walk the perimeter. Annotate any erosion, missing signage etc.
FenceHoles in fabric, barbed wire etc.
Fence groundsAny fence grounds broken or disconnected?
GatesGates operable? Locks present? Signage present? Corrosion?
Gate groundsAny gate grounds broken or disconnected?
Building exteriorAny cracks in walls, evidence of water intrusion?
Front doorDoors corroded or evidence of water intrusion? Door is locked?
Back doorDoors corroded or evidence of water intrusion? Door is locked?
Exterior building lightsAre the lights operable? Replace light bulbs as necessary.
Switchyard lightsAre the lights operable? Replace light bulbs as necessary.
PhotocellsPhotocells appear working?
AC power wiringAny junction boxes found open, damaged, covers missing, corrosion etc.
Strobes
WeedsDoes the switchyard require weed abatement?
Switching structuresCorrosion or missing fasteners on the switching structures?
InsulatorsAny cracked, chipped or otherwise damaged insulators?
70 kV switchesAny visual problems with 70 kV gang switches or switch-blades?
Switch platform groundsAre the switching platform grounds broken or disconnected?
TransformersN1
N2 main tank PSIIn this field, record data as indicatedRecord the pressure in PSI for the N2 blanket on the main tank
N2 regulated PSIRecord the pressure in PSI at the output of the pressure regulator
N2 reserve tank PSIRecord the pressure in PSI for the N2 reserve tank. Replenish N2 as necessary
Main tank oil temperatureRecord the temperature in Deg C
Winding temperatureRecord the temperature in Deg C
Main tank oil levelRecord the temperature in Deg C
Bushing oil levelIn this field, enter "OK" or "Note #"Is the oil visible in the bushing sight glass? Is it at an acceptable level
Fan conditionFans corroded, disconnected?
Fan operationDo the fans work?
Heat exchangersDo the cooling fins show any signs of corrosion or failure?
FoundationIs the concrete slab intact?
Oil leak evidence?Any evidence under the cooling fins of oil leaks?
Control wiringAny evidence of corrosion or other failure on the control wiring conduits?
Bonding groundsAre the transformer grounds intact and connected?
Main tap settingAnnotate the current coarse tap setting on the transformer
Bushing connectionsIn this field, enter "OK" or "Note #"Any visual problems with the transformer bushings or arrestors?
Main tank ConditionDoes the transformer require corrosion control or other minor repairs?
Oil filtration unitIs the oil filtration unit OK? Replace dessicant filter as needed.
Load Tap ChangersB1
LTC tank oil levelIn this field, record data as indicatedRecord "OK" if the LTC tank level is good
LTC tap as foundRecord the position of the tap changer
Lowest tap since last readingRecord the position of the low-side limit arm, reset to current tap position
Highest tap since last readingRecord the position of the high-side limit arm, reset to current tap position
Tap operations counterAnnotate the current count on the LTC operations counter
LTC cabinet lightsIn this field, enter "OK" or "Note #"Do the lights work inside the control cabinet? Replace bulbs.
LTC tank conditionDoes the LTC oil tank appear to have any problems?
Oil leak evidenceAny evidence of oil leaks on the LTC?
70 kV BreakersSS70-1
Operations CounterIn this field, record data as indicatedAnnotate the current count on the breaker operations counter
PressureAnnotate the SF6 pressure (or dry-air at Subs C and D). Replenish gases as necessary
Mechanism typeAnnotate the mechanism type ("spring")
HeatersIn this field, enter "OK" or "Note #"Are the cabinet heaters working?
Control cabinetAny evidence of corrosion or water intrusion?
Interior lightDoes the cabinet lamp work? Replace light bulbs as necessary.
Pole conditionAny visual problems with the mechanical linkage to the breaker assembly?
System leaksDoes the SF6 (or dry-air) system appear to have any leaks?
Wiring and connectionsAny visual problems with the control wiring or terminal blocks in the cabinet?
70 kV PTsBus 1
Phase A oil levelIn this field, enter "OK" or "Note #"Observe the oil indicator and mark "OK" or "problem", describe any problems
Phase B oil levelObserve the oil indicator and mark "OK" or "problem", describe any problems
Phase C oil levelObserve the oil indicator and mark "OK" or "problem", describe any problems
Oil leak evidence?Any evidence on the ground or on the pedestal of an oil leak?
FusesAre fuses closed and intact? Annotate any blown or open fuses
70 kV CPTsBus 1
Oil levelIn this field, enter "OK" or "Note #"Observe the oil indicator and mark "OK" or "problem", describe any problems
General conditionAre the CPTs in good shape? Any evidence of leaks or failures?
FusesAre fuses closed and intact? Annotate any blown or open fuses
PG&E Meter YardSw 51
Switch platform groundsIn this field, enter "OK" or "Note #"Are the switching platform grounds intact and connected?
WeedsDoes the meter yard require weed abatement?
AF lock is presentIs there an Air Force lock on the gearbox? Mark "OK" if present.
PG&E lock is presentIs there a PG&E lock on the gearbox? Mark "OK" if present.
Meter pacakgesDo the two meter packages show any signs of corrosion, contamination or failure?
Oil leak evidenceAny evidence of oil leaks?
PerimeterWalk the perimeter. Annotate any erosion, missing signage etc.
FenceHoles in fabric, barbed wire etc.
Fence groundsAny fence grounds broken or disconnected?
GatesGates operable? Locks present? Signage present? Corrosion?
Gate groundsAny gate grounds broken or disconnected?

Problems Noted at Switching Station:

For any items not marked "OK" provide a numbered note to explain the discrepancy, in this section. See example below

(Example:)
Note 1: A fence post is missing in the northeast corner of the yard due to corrosion
Note 2: Numerous strands of barbed wire are broken and/or laying on the ground
Note 3: We replenished SF gas in B70-7 for the second month in a row. We need to do a leak investigation
during the next scheduled outage.

SS

Switching Station

Date inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
70 kV BreakersSS70-1SS70-2SS70-3SS70-4SS70-5SS70-6SS70-7
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV BreakersSS70-8SS70-9SS70-10SS70-11SS70-12SS70-13
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBus 1Bus 2
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses
70 kV CPTsBus 1Bus 2
Oil level
General condition
Fuses
PG&E Meter YardSw 51Sw 53Sw 61Sw 63
Switch platform grounds
Weeds
AF lock is present
PG&E lock is present
Meter pacakges
Oil leak evidence
Perimeter
Fence
Fence grounds
Gates
Gate grounds

Problems Noted at Switching Station:

Sub A Substation A

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
Switchyard CTs
TransformersA1A2
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersA1A2
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence

Problems Noted at Substation A:

Sub B Substation B

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersB1B2B3
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersB1B2B3
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence
70 kV BreakersB70-1B70-2B70-3B70-4B70-5B70-6B70-7
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay B1Bay B2Bay B3
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation B:

Sub C Substation C

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersC1
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence?
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersC1
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence?
70 kV BreakersC70-1C70-2C70-3
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay C1
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation C:

Sub D Substation D

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersD1D3
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersD1D3
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence
70 kV BreakersD70-1D70-2D70-3D70-4D70-5
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay D1Bay D3
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation D:

Sub E Substation E

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersE1
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence?
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersE1
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence?
70 kV BreakersE70-1E70-2E70-3
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay E1
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation E:

Sub F Substation F

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersF1F2
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence?
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersF1F2
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence?
70 kV BreakersF70-1F70-2F70-3F70-4F70-5
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay F1Bay F2
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation F:

Sub K Substation K

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersK1K2
Main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence?
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersK1K2
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence?
70 kV BreakersK70-1K70-2K70-3K70-4K70-5
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay K1Bay K2
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation K:

Sub N Substation N

Date Inspected

Exterior InspectionStatusDiscrepancies if any
Perimeter
Fence
Fence grounds
Gates
Gate grounds
Building exterior
Front door
Back door
Exterior building lights
Switchyard lights
Photocells
AC power wiring
Strobes
Weeds
Switching structures
Insulators
70 kV switches
Switch platform grounds
TransformersN1N2
N2 main tank PSI
N2 regulated PSI
N2 reserve tank PSI
Main tank oil temperature
Winding temperature
Main tank oil level
Bushing oil level
Fan condition
Fan operation
Heat exchangers
Foundation
Oil leak evidence?
Control wiring
Bonding grounds
Main tap setting
Bushing connections
Main tank Condition
Oil filtration unit
Load Tap ChangersN1N2
LTC tank oil level
LTC tap as found
Lowest tap since last reading
Highest tap since last reading
Tap operations counter
LTC cabinet lights
LTC tank condition
Oil leak evidence?
70 kV BreakersN70-1N70-2N70-3N70-4N70-5
Operations Counter
Pressure
Mechanism type
Heaters
Control cabinet
Interior light
Pole condition
System leaks
Wiring and connections
70 kV PTsBay N1Bay N2
Phase A oil level
Phase B oil level
Phase C oil level
Oil leak evidence?
Fuses

Problems Noted at Substation N:

File details come from the government source that posted it.