Distribution transformer calculations – MS Excel Spreadsheet

Dyson
04/12/2025

Four Fast Transformer Calculations

The distribution transformer calculations spreadsheet enables rapid computations for the following: ascertaining the MV/LV transformer rating, calculating the rating of the overcurrent protection device on the low - voltage side of the transformer, determining the prospective short - circuit current, and computing the sizes of natural ventilation openings required for the transformer room.
Determining the MV/LV Transformer Rating
Input Parameters:
  • Primary Rated Voltage (kV)
  • Secondary Rated Voltage (kV)
  • Maximum Demand Load (kW)
  • Corrected Power Factor
  • Transformer Type
  • Permissible Loading Percentage (%)
  • Nearest Standard Transformer Rating (kVA)

Calculating the Rating of Overcurrent Protection Device on the Low - Voltage Side of the Transformer

Calculating the prospective short - circuit current on the low - voltage side of the transformer

Calculating the sizes of natural ventilation openings required for the transformer room.

 

 

 

Dyson

Focused on the design of electrical equipment, proficient in electrical principles and relevant specifications, and skilled in using design software. From intelligent substations to various types of electrical equipment, I am adept at optimizing design solutions, integrating new technologies. With practical experience and collaborative management capabilities, I deliver outstanding electrical design achievements.

Research on Low - Voltage Anti - DC Current Transformer and Detection Device
Research on Low - Voltage Anti - DC Current Transformer and Detection Device
1. Overview of Components and IssuesTA (low-voltage current transformer) and electric energy meters are key components of low-voltage electric energy metering. The load current of such meters is no less than 60A. Electric energy meters vary in type, model, and anti-DC performance, and are connected in series in the metering device. Due to the lack of anti-DC capability, they suffer from metering errors under DC component loads, usually caused by non-linear loads. With the increasing use of DC or
Dyson
07/16/2025
Anti - Theft Device for Low - Voltage Current Transformers
Anti - Theft Device for Low - Voltage Current Transformers
1. Innovation BackgroundWith the progress of society and economic development, the electricity demand of power users is expanding increasingly. Lawbreakers, aiming to save electricity costs and pursue high profits, gradually use high - tech methods to steal electricity, causing huge economic losses to power supply enterprises. Currently, popular electricity theft methods in the market include illegally opening the wiring cover of low - voltage transformers in electric energy metering boxes, alte
Dyson
07/16/2025
What aspects should be taken into consideration during the design of AIS voltage transformers?
What aspects should be taken into consideration during the design of AIS voltage transformers?
I. Key Elements of Mechanical Structure DesignThe mechanical structure design of AIS voltage transformers ensures long - term stable operation. For 66 kV outdoor AIS voltage transformers (pillar - type structure):Pillar Material: Use epoxy resin casting + metal frame for mechanical strength, pollution/weather resistance. Special design needed for 66 kV (vs 35 kV & below). Dry - type insulation (porcelain/epoxy shell) requires sufficient bending/impact resistance for harsh outdoors.Heat Dissi
Dyson
07/15/2025
Analysis of Gas Concentration in High - Voltage Reactors of Large - Scale Hydroelectric Generator Sets
Analysis of Gas Concentration in High - Voltage Reactors of Large - Scale Hydroelectric Generator Sets
1.Gas Generation and Analysis Principle of High - Voltage ReactorsHigh - voltage reactors use oil and insulating paper for insulation. Normal operation may see local overheating or discharges (e.g., iron core/winding issues, inter - turn short circuits), causing insulation cracking and producing gases like hydrocarbons (methane, etc.), CO, CO2, H2). These gases reflect internal insulation status, enabling real - time monitoring.For closed oil - filled reactors, insulation aging and oil oxidation
Oliver Watts
07/11/2025
Inquiry
Download
IEE-Business is dedicated to serving the personnel in the global power industry.
Join IEE-Business, not only can you discover power equipment and power knowledge, but also canhnd like - minded friends!