U.S. Department of Energy - Energy Efficiency and Renewable Energy

Building Technologies Office – Appliance & Equipment Standards

Distribution Transformers Preliminary Analytical Tools

The spreadsheets below provide the preliminary analysis findings and interactive tools for the Engineering Analysis, the Life-Cycle Cost Analysis and the National Impacts Analysis. Instructions on how to use the Life-Cycle Cost Analysis and National Impacts Analysis spreadsheets can be found in the Technical Support Document.

Some of the following files are zipped files. Download Winzip

Engineering Analysis

• Liquid-Immersed Engineering Analysis Results (ZIP 2.7 MB)
• Low-Voltage Dry-Type Engineering Analysis Results (ZIP 3.5 MB
• Medium-Voltage Dry-Type Engineering Analysis Results (ZIP 4.9 MB)

Life Cycle Cost Analysis by Design Line

Spreadsheets:

Design Lines 1-5 are Liquid-Immersed, Medium-Voltage

• Design Line 1: 50kVA, Single-Phase (ZIP 5.1 MB)
• Design Line 2: 25kVA, Single-Phase (ZIP 5.1 MB)
• Design Line 3: 500kVA, Single-Phase (ZIP 5.1 MB) 
• Design Line 4: 150kVA, Three-Phase (ZIP 5.0 MB)
• Design Line 5: 1500kVA, Three-Phase (ZIP 4.8 MB)

Design Lines 6-8 are Dry-Type, Low-Voltage

• Design Line 6: 25kVA, Single-Phase (ZIP 5.4 MB)
• Design Line 7: 75kVA, Three-Phase (ZIP 5.5 MB)
• Design Line 8: 300kVA, Three-Phase (ZIP 5.2 MB)

Design Lines 9-13 are Dry-Type, Medium Voltage, Three-Phase

• Design Line 9: 300kVA, 20-45 kV BIL (ZIP 5.2 MB)
• Design Line 10: 1500kVA, 20-45 kV BIL (ZIP 4.3 MB)
• Design Line 11: 300kVA, 46-95 kV BIL (ZIP 4.2 MB)
• Design Line 12: 1500kVA, 46-95 kV BIL (ZIP 4.6 MB)
• Design Line 13: 2000kVA, >=96 kV BIL (ZIP 5.0 MB)

National Impact Analysis

• National Impact Analysis (ZIP 714 KB)

Contact Information

James Raba
Project Manager
(202) 586-8654