Menu
Search
Distribution Transformer Calculations – MS Excel Spreadsheet
Distribution Transformer Calculations – MS Excel Spreadsheet

4 Fast Transformer Calculations

Distribution transformer calculations spreadsheet provides fast calculations for the following:

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 | Get Download Updates | Get Technical articles
Distribution Transformer Calculations - MS Excel Spreadsheet
Distribution Transformer Calculations – MS Excel Spreadsheet

Shape Up Your Knowledge //

Want to be a better electrical engineer? Subscribe to professional technical articles. Sharpen up your knowledge in field of electrical engineering now!

Subscribe Now

Page edited by E.C. (Google).

13 Comments


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


  2. Madhavan
    Nov 25, 2015

    Please send lighting excell spread sheet


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


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


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


  6. 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?


  7. Juan Miguel
    Oct 14, 2014

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


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

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


  9. Bharathakumar Menon
    Aug 25, 2014

    It is very useful


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


  11. murugesan
    Aug 24, 2014

    good very useful thanks


  12. Mehdi Hosseini
    Aug 24, 2014

    Very Useful
    Thanks

Leave a Comment

Tell us what you're thinking... we care about your opinion!

Time limit is exhausted. Please reload CAPTCHA.