Distribution Transformers ANOPR Analytical Spreadsheets
The spreadsheets below provide the ANOPR findings and interactive tools for the Engineering Analysis, the Life-Cycle Cost Analysis and the National Impact Analysis. Instructions on how to use the Life-Cycle Cost Analysis and the National Impact Analysis spreadsheets can be found in the Technical Support Document.
The following documents are available as Adobe Acrobat PDFs. Download Adobe Reader.
The following documents are available as zipped files. Download WinZip.
Engineering Analysis
Life Cycle Cost Calculations by Design Line
Design Lines 1-5 are Liquid-Immersed, Medium-Voltage
- Design Line 1: 50kVA, Single-Phase
- Design Line 2: 25kVA, Single-Phase
- Design Line 3: 500kVA, Single-Phase
- Design Line 4: 150kVA, Three-Phase
- Design Line 5: 1500kVA, Three-Phase
Design Lines 6-8 are Dry-Type, Low-Voltage
- Design Line 6: 25kVA, Single-Phase
- Design Line 7: 75kVA, Three-Phase
- Design Line 8: 300kVA, Three-Phase
Design Lines 9-13 are Dry-Type, Medium-Voltage, Three-Phase
- Design Line 9: 300kVA, 20-45 kV BIL
- Design Line 10: 1500kVA, 20-45 kV BIL
- Design Line 11: 300kVA, 46-95 kV BIL
- Design Line 12: 1500kVA, 46-95 kV BIL
- Design Line 13: 2000kVA, >=96 kV BIL