Premium Membership ♕

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

Home / Download Center / Electrical Software Reviews / Spreadsheet to calculate the size of neutral earthing transformer

Earthing transformer

When the system neutral may not available, earthing transformer may be used to obtain the neutral. The neutral point of transformer to the earth ground network provides a reference point of zero volts.

Spreadsheet to calculate the size of neutral earthing transformer
Spreadsheet to calculate the size of neutral earthing transformer

This spreadsheet calculates the following parameters of a neutral earthing transformer:

  1. Total capacitive charging current (It).
  2. Neutral earthing transformer secondary current.
  3. Required grounding resistor value at primary side (Rp).
  4. Required resistance value at secondary side (Rsec).
  5. Neutral earthing transformer X/R Ratio
  6. Fault current through neutral – single line to ground fault (If)
  7. Rating of neutral earthing transformer (P).

It might be interesting to read technical article about all types of neutral earthing in power distribution: Part 1 and Part 2.

Software:MS Excel Spreadsheet to calculate the size of neutral earthing transformer
Developer:Jignesh Parmar
Size:92 KB
Download:Right here | Video Courses | Membership | Download Updates
Spreadsheet to calculate the size of neutral earthing transformer
Spreadsheet to calculate the size of neutral earthing transformer

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


  1. Shumbulo Shuta
    Jan 10, 2023

    thank you a lot.

  2. Robert Rajan
    Aug 11, 2021

    Excellent work on the NGT sizing calculator. Do you have Low resistance Neutral grounding resistor sizing spread sheet? If so please send the file to [email protected]

  3. George Brown
    Aug 05, 2020

    Thank you, nice work!!

    Jun 05, 2020

    Please kindly check the work EARTHING, it should be EARTHLING for engineering pronounce
    so please make amend.



    Jun 04, 2020

    Dear Mr. Jignesh,
    From talk in your papers, it appears that you are talking sizing of Transformer for floating 3 phase system, but from spread sheet it appears, for single phase Grounding Transformer, for gounding 3 phase start connected Power Supply source with star point and star point of source grounded using 1 phase transformer with secondary Burdened via Resistance. Otherwise for floating system, it shall be 3 phase transformer or a 3 phase Reactor with impedence to limit phase to earth fault current to neutral. In case of 3 phase Transformer, it shall be Y-open delta (Say Y for floating system and open delta for , with Open Delta shorted via resistance to burden Primay in case of Earth Fault and Start of Primary solidly grounded. Your work sheet seems not correct, suggest review with Application of Earthing Transformer and fault current, giving system configuration in which you have designed the work sheet and details of Transformer connection etc. In all cases however, we can not size the Earthing Transformer on basis of charging system capacitance or giving short circuit path of Capacitive Current for 1 phase to earth fault. According to me it needs review.
    Best regards
    Ramesh Kapur

  6. Edson Francisco Piloro
    Apr 17, 2020

    Good morning Mr jignesh, i van not download the sheet. Can you send to my e-mail please: [email protected]

Leave a Comment

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!

eleven  −  ten  =  

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