Search

Premium Membership

Learn about power engineering and HV/MV/LV substation design. Study specialized technical articles, papers & video courses. Apply 15% off code on Pro plan: ZX21F

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.

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.
More Information

20 Comments


  1. md.suzauddoula
    Dec 17, 2020

    it’s very good.


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

Leave a Comment

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

EEP Academy Video Courses

The learning platform for LV/MV/HV electrical engineers. Learn from experienced engineers and sharpen up your knowledge.