Learn from experienced engineers and study specialized technical articles, guides & courses. Save 50% on courses with the Enterprise Plan.

# Spreadsheet to calculate the size of neutral earthing transformer

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

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.

50% Discount ðŸ’¥ - Save 50% on all 90+ video courses with Enterprise Membership plan.

1. Kalyan
Dec 08, 2023

2. Shumbulo Shuta
Jan 10, 2023

thank you a lot.

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

4. George Brown
Aug 05, 2020

Thank you, nice work!!

5. ERIC KWAME ANTWI
Jun 05, 2020

Please kindly check the work EARTHING, it should be EARTHLING for engineering pronounce

Thanks

Truly

6. RAMESH KUMAR KAPUR
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

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

8. Edson Francisco Piloro
Apr 17, 2020

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

9. John Paul Laranja Tagari
Dec 19, 2019

sir what is the password to unprotect the workbook?

10. Frank D. Nouahn
Oct 05, 2019

what is maximum amperage rating for 3 phase 100KVA transformer at continue load?

11. Tahir
Oct 05, 2019

Well, i got it. Thanks sir.

12. James K
Jan 19, 2018

13. Thom James Kajawa
Jan 18, 2018

Good day sir

I have not yet used the spread sheet but is it able to calculate size of grounding wire of 3 phase transformers.

14. Navaneeth
Sep 16, 2016

Neutral to earth voltage is increasing from mV (no load) to 4V when the high pressure pumps are working ( total load reaches to 630 KW ).and the neutral current is 14 amps .Do u have any solution for the above .Using Generator for the source

15. Edvard
Feb 22, 2016

Will be fixed very soon, please be patient… Tnx!

16. ranko
Feb 22, 2016

Can you kindly send the same to me at my email address

• Edvard
Feb 22, 2016

Try now, it’s fixed.

17. kamlesh shah
Jan 25, 2016

Can you kindly send the same to me at my email address

• Edvard
Feb 22, 2016

Try now, it’s fixed.

18. nitin
Jan 21, 2016

• Edvard
Feb 22, 2016

Try now, it’s fixed.

19. saugat poudel
Jul 24, 2015

20. Ugyen Thinley
Jun 10, 2015

Can you kindly send the same to me at the following address.
[email protected]
with best regards
ugyen thinley

• Edvard
Feb 22, 2016

Try now, it’s fixed.

21. Ramkumar
Jul 13, 2014

22. Deepak Dubey
Jul 13, 2014

Dear Mr. Jignesh.