Distribution transformer calculations – MS Excel Spreadsheet
Field: Electrical Standards
China
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:
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.
Give a tip and encourage the author!
Recommended
Analysis of Transformer Grounding Protection Technology in Construction Sites
Currently, China has achieved certain accomplishments in this field. Relevant literature has designed typical configuration schemes for grounding fault protection in nuclear power plant low-voltage distribution systems. Based on the analysis of domestic and international cases where grounding faults in nuclear power plant low-voltage distribution systems have caused maloperation of transformer zero-sequence protection, the underlying causes have been identified. Furthermore, improvement suggesti
12/13/2025
H59/H61 Transformer Failure Analysis and Protection Measures
1.Causes of Damage to Agricultural H59/H61 Oil-Immersed Distribution Transformers1.1 Insulation DamageRural power supply commonly uses a 380/220V mixed system. Due to the high proportion of single-phase loads, H59/H61 oil-immersed distribution transformers often operate under significant three-phase load imbalance. In many cases, the degree of three-phase load imbalance far exceeds the limits permitted by operational regulations, causing premature aging, deterioration, and eventual failure of th
12/08/2025
Top 5 Faults Found in H61 Distribution Transformers
Five Common Defects of H61 Distribution Transformers1.Lead Wire DefectsInspection Method: The three-phase DC resistance imbalance rate significantly exceeds 4%, or one phase is essentially open-circuited.Remedial Measures: The core should be lifted for inspection to locate the defective area. For poor contacts, re-polish and tighten the connection. Poorly welded joints should be re-welded. If the welding surface area is insufficient, it should be enlarged. If the lead wire cross-section is inade
12/08/2025
How Voltage Harmonics Affect H59 Distribution Transformer Heating？
The Impact of Voltage Harmonics on Temperature Rise in H59 Distribution TransformersH59 distribution transformers are among the most critical equipment in power systems, primarily functioning to convert high-voltage electricity from the power grid into low-voltage electricity required by end users. However, power systems contain numerous nonlinear loads and sources, which introduce voltage harmonics that adversely affect the operation of H59 distribution transformers. This article will discuss i
12/08/2025
Related Products
