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 prospective short - circuit current on the low - voltage side of the transformer

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