CYBER WEEK OFFER 💥 Save 20% on PRO Membership Plan and Video Courses with the coupon CYM23 and learn from experienced engineers.

# Distribution transformer calculations – MS Excel Spreadsheet

Home / Download Center / Electrical Software and MS Excel Spreadsheets (Calculations of cables, voltage drop etc.) / 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.)
• 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.

50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

1. nicolae
Jan 05, 2023

How can the parameter database be updated? I got a 1600kVA dry type transformer with lower losses than what is used as example.
Thanks

2. Eric Moluwoi
May 04, 2022

3. 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

4. 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

6. John Ledawo
Mar 03, 2021

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

Mar 01, 2021

it is simply great

8. 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

9. md.suzauddoula
Dec 17, 2020

it’s very good.

10. 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

11. Lakshman Rangaiah
Feb 05, 2020

I would like to have a low power transformer spread sheet work sheet

12. Kevin Njoroge
Sep 06, 2019

Hi..what could be the cause of mccb heating up and giving out a smell then one pole changes colour to darkish… your response will be highly appreciated

13. Mubinul Haque
Oct 05, 2018

sir, do you have single phase distribution transformer design excel file 6350/240 V, 50 Hz, it will very helpful for me. Thanks in advance .

14. Romano Trevinati
Jan 07, 2016

Good day!

How i can test the xls file? i’m not able to download….

Romano

Nov 25, 2015

16. Tony
Oct 24, 2015

EEP is very, very useful and it help me a lot.

Thank you very much for being part of my success.

Thank you.

17. Ankush Sable
May 16, 2015

Dear Sir,
Please tell me how to calculate tapping of distribution transformer. Please send the formulas for calculating tapp.
Thank You!!

18. aviran
Mar 04, 2015

please let me know how to design the foil of the distribution transformer , does any one have a design book?? if i have the power data what else i need to do? thank you all!!

19. aviran
Mar 02, 2015

i need to design distribution power transformer , and i need to know how!
do you have any books? sources of design?

20. Juan Miguel
Oct 14, 2014

Great website to all electrical engineering students and for my work.

21. K S P R M VITTAL
Sep 03, 2014

EEE is very very useful web site electrical engineers.I learnt more from this.

22. Bharathakumar Menon
Aug 25, 2014

It is very useful

23. Ryan
Aug 25, 2014

The link isn’t working for me :/

• Designer
Jun 12, 2015

If you want more proffesionally distribution transformer test report xls file please contackt with by e-mail transformersdesign hotmail.com

• Ivar Ling
Nov 08, 2020

I would like to get xls. Calculate sheet template

24. murugesan
Aug 24, 2014

good very useful thanks

25. Mehdi Hosseini
Aug 24, 2014

Very Useful
Thanks