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.
Engineering Analysis
- Dry-Type Engineering Analysis Results (Excel 2.7 MB)
- Liquid Engineering Analysis Results (Excel 1.8 MB)
Life Cycle Cost Calculations by Design Line
Design Lines 1-5 are Liquid-Immersed, Medium-Voltage
- Design Line 1: 50kVA, Single-Phase
- LCC Analytical Spreadsheet (Excel 6.1 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 2.0 MB)
- Design Line 2: 25kVA, Single-Phase
- LCC Analytical Spreadsheet (Excel 6.3 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 2.0 MB)
- Design Line 3: 500kVA, Single-Phase
- LCC Analytical Spreadsheet (Excel 5.9 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.9 MB)
- Design Line 4: 150kVA, Three-Phase
- LCC Analytical Spreadsheet (Excel 6.1 MB)
- Average LCC Results (TSD Appendix 8E) (Winzip 2.2 MB)
- Design Line 5: 1500kVA, Three-Phase
- LCC Analytical Spreadhseet (Excel 6.2 MB)
- Average LCC Results (TSD Appendix 8E) (Winzip 2.0 MB)
Design Lines 6-8 are Dry-Type, Low-Voltage
- Design Line 6: 25kVA, Single-Phase
- LCC Analytical Spreadsheet (Excel 4.2 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.9 MB)
- Design Line 7: 75kVA, Three-Phase
- LCC Analytical Spreadsheet (Excel 3.8 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.9 MB)
- Design Line 8: 300kVA, Three-Phase
- LCC Analytical Spreadsheet (Excel 3.6 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 2.0 MB)
Design Lines 9-13 are Dry-Type, Medium-Voltage, Three-Phase
- Design Line 9: 300kVA, 20-45 kV BIL
- LCC Analytical Spreadsheet (Excel 3.7 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.9 MB)
- Design Line 10: 1500kVA, 20-45 kV BIL
- LCC Analytical Spreadsheet (Excel 3.6 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.8 MB)
- Design Line 11: 300kVA, 46-95 kV BIL
- LCC Analytical Spreadsheet (Excel 3.5 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.8 MB)
- Design Line 12: 1500kVA, 46-95 kV BIL
- LCC Analytical Spreadsheet (Excel 3.5 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.8 MB)
- Design Line 13: 2000kVA, >=96 kV BIL
- LCC Analytical Spreadsheet (Excel 3.5 MB)
- Average LCC Results (TSD Appendix 8E) (WinZip 1.8)
National Impact Analysis
- National Impact Analysis Spreadsheets (Excel 6.03 MB)