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

Building Technologies Office – Appliance & Equipment Standards

Distribution Transformers NOPR Analytical Spreadsheets

The spreadsheets below provide the NOPR findings and interactive tools for the Engineering Analysis, the Life-Cycle Cost Analysis, the National Impact Analysis, the Manufacturer Impact Analysis and Regulatory 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.

Engineering Analysis

• Dry-Type Engineering Analysis Results
• Liquid Engineering Analysis Results

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
• Design Line 2: 25kVA, Single-Phase
  • LCC Analytical Spreadsheet
• Design Line 3: 500kVA, Single-Phase
  • LCC Analytical Spreadsheet
• Design Line 4: 150kVA, Three-Phase
  • LCC Analytical Spreadsheet
• Design Line 5: 1500kVA, Three-Phase
  • LCC Analytical Spreadhseet

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

• Design Line 9: 300kVA, 20-45 kV BIL
  • LCC Analytical Spreadsheet
• Design Line 10: 1500kVA, 20-45 kV BIL
  • LCC Analytical Spreadsheet
• Design Line 11: 300kVA, 46-95 kV BIL
  • LCC Analytical Spreadsheet
• Design Line 12: 1500kVA, 46-95 kV BIL
  • LCC Analytical Spreadsheet
• Design Line 13: 2000kVA, 46-95 kV BIL
  • LCC Analytical Spreadsheet

National Impact Analysis

• National Impact Analysis Spreadsheet

Manufacturer Impact Analysis

• Government Regulatory Impact Model (GRIM)

Regulatory Impact Analysis (RIA)

• RIA Spreadsheet