Search

Premium Membership ♕

Limited Time Offer: Save 15% on PRO Plan with discount code: LRN15 and study specialized LV/MV/HV technical articles and studies.

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.

Distribution transformer calculations - MS Excel Spreadsheet
Distribution transformer calculations – MS Excel Spreadsheet

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
  • Permissible loading percentage (%)
  • The nearest standard transformer rating (KVA)

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

Calculating overcurrent protection device rating
Calculating overcurrent protection device rating

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

Calculating the prospective short circuit current
Calculating the prospective short circuit current

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

Calculating natural ventilation openings sizes

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

Premium Membership

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.

More Information

32 Comments


  1. Simbo Jonathan
    Feb 20, 2024

    will appreciate to receive tranfomer calculations file


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


  3. Eric Moluwoi
    May 04, 2022

    Try downloading it, but have restrictions


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


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


  6. Muhammad Bilal
    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


  7. John Ledawo
    Mar 03, 2021

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


  8. Muhammad Asim Hussain
    Mar 01, 2021

    it is simply great


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


  10. md.suzauddoula
    Dec 17, 2020

    it’s very good.


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


  12. Lakshman Rangaiah
    Feb 05, 2020

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


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


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


  15. Romano Trevinati
    Jan 07, 2016

    Good day!

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

    thanks for your attention
    Romano


  16. Madhavan
    Nov 25, 2015

    Please send lighting excell spread sheet


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


  18. 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!!


  19. 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!!


  20. aviran
    Mar 02, 2015

    this is great portal , i need your help please.

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


  21. Juan Miguel
    Oct 14, 2014

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


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

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


  23. Bharathakumar Menon
    Aug 25, 2014

    It is very useful


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


  25. murugesan
    Aug 24, 2014

    good very useful thanks


  26. Mehdi Hosseini
    Aug 24, 2014

    Very Useful
    Thanks

Leave a Reply to Bharathakumar Menon

Tell us what you're thinking. We care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

thirty nine  −    =  thirty three

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge