Save 50% on all Video Courses with Enterprise Membership Plan and study specialized LV/MV/HV technical articles and guides.

# Spreadsheet to calculate the size of neutral earthing transformer

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.

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

2. John Paul Laranja Tagari
Dec 19, 2019

sir what is the password to unprotect the workbook?

3. Frank D. Nouahn
Oct 05, 2019

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

4. Tahir
Oct 05, 2019

Well, i got it. Thanks sir.

5. James K
Jan 19, 2018

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

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

8. Edvard
Feb 22, 2016

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

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

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

11. nitin
Jan 21, 2016

• Edvard
Feb 22, 2016

Try now, it’s fixed.

12. saugat poudel
Jul 24, 2015

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

14. Ramkumar
Jul 13, 2014

15. Deepak Dubey
Jul 13, 2014

Dear Mr. Jignesh.