Distribution Transformers Final Rule Analytical Spreadsheets
The spreadsheets below provide the Final Rule 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 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.8 MB)
- Liquid Engineering Analysis Results (Excel 4.9 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 9.2 MB)
- Design Line 2: 25kVA, Single-Phase
- LCC Analytical Spreadsheet (Excel 10.1 MB)
- Design Line 3: 500kVA, Single-Phase
- LCC Analytical Spreadsheet (Excel 8.2 MB)
- Design Line 4: 150kVA, Three-Phase
- LCC Analytical Spreadsheet (Excel 9 MB)
- Design Line 5: 1500kVA, Three-Phase
- LCC Analytical Spreadhseet (Excel 8.7 MB)
Design Lines 9-13 are Dry-Type, Medium-Voltage, Three-Phase
- Design Line 9: 300kVA, 20-45 kV BIL
- LCC Analytical Spreadsheet (Excel 4.7 MB)
- Design Line 10: 1500kVA, 20-45 kV BIL
- LCC Analytical Spreadsheet (Excel 4.3 MB)
- Design Line 11: 300kVA, 46-95 kV BIL
- LCC Analytical Spreadsheet (Excel 3.8 MB)
- Design Line 12: 1500kVA,46-95 kV BIL
- LCC Analytical Spreadsheet (Excel 4.7 MB)
- Design Line 13: 2000kVA, >=96 kV BIL
- LCC Analytical Spreadsheet (Excel 4.7 MB)
National Impact Analysis
- National Impact Analysis with Regulatory Impact Analysis (Excel 4.9 MB)
Manufacturer Impact Analysis
- Government Regulatory Impact Model (GRIM) (Excel 7.9 MB)