Save 50% on all EEP Academy courses with Enterprise Membership Plan and study specialized LV/MV/HV technical articles & guides.

# Distribution transformer calculations – MS Excel Spreadsheet

Home / Download Center / Electrical Software Reviews / Distribution transformer calculations – MS Excel Spreadsheet

## Four Fast Transformer Calculations

Distribution transformer calculations spreadsheet provides fast calculations for the following: Determining the MV/LV transformer rating, calculating overcurrent protection device rating on the low voltage side of the transformer, calculating the prospective short circuit current and Calculating natural ventilation openings sizes required for the transformer room.

1. Determining the MV/LV transformer rating

Input parameters:

• Primary rated voltage (kV.)
• Secondary rated voltage (kV.)
• Max. demand load (kW)
• Power factor after correction
• Transformer type
• The nearest standard transformer rating (KVA)

2. Calculating overcurrent protection device rating on the low voltage side of the transformer

3. Calculating the prospective short circuit current across the low voltage side of the transformer

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

 Software: Distribution Transformer Calculations – MS Excel Spreadsheet Version: – Developer: Mahmoud Salama Size: 278 KB Price: FREE Download: Right here | Video Courses | Membership | Download Updates

Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

1. Eric Moluwoi
May 04, 2022

2. Kelvin
Sep 30, 2021

Could anyone share the password of this Distribution Transformer Calculation sheet? It’s in protected mode. Need to unprotect it to understand calculations…

Thanks

• Amit D
Aug 24, 2022

Have you received the password, if yes, let me know also.

3. sanjay sharma
Aug 21, 2021

Useful. However some basic mistakes are there like the unit of Impedance has been given in Ohm.mile which could not be correct. It should be just Ohm. Further the bottommost table(left side) is presented in a way which can not be called user friendly and technically not correct also.

Aug 19, 2021

I want detail calculations related to the electrical LT HT panels
CT/ VT calculations
Breaker sizing
Cable rating calculation
If any one have please email me
I em beginner level

5. John Ledawo
Mar 03, 2021

I desire that you will help me improve based on the how technology has advanced.

6. Muhammad Asim Hussain
Mar 01, 2021

it is simply great

7. Hervin Hugo Colmenares Quiñones
Feb 28, 2021

EEP is the best way I have to update my knowledge in electrical engineering. This article is a sample of the great value of EEP in the world.

• Fehintola Samson Olusola
Mar 01, 2021

This is so helpful. Thank you for this.
But is would be better if you can define the terms use next time because of beginners. Thank you once again.

• Ishfaq Ahmed
May 05, 2022

Please anyone send me in Email

8. md.suzauddoula
Dec 17, 2020

it’s very good.

9. Hakim Walya
Apr 14, 2020

I do recommend fellow technicians to make use of the portal. it has been of great value

• muzaffar khan
Apr 16, 2020

How can i down load the templates

### Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).