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:
- Total capacitive charging current (It).
- Neutral earthing transformer secondary current.
- Required grounding resistor value at primary side (Rp).
- Required resistance value at secondary side (Rsec).
- Neutral earthing transformer X/R Ratio
- Fault current through neutral – single line to ground fault (If)
- 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 |
Version: | – |
Developer: | Jignesh Parmar |
Size: | 92 KB |
Price: | Free |
Download: | Right here | Video Courses | Membership | Download Updates |

Good morning Mr jignesh, i van not download the sheet. Can you send to my e-mail please: edsonfrancisco [email protected]
sir what is the password to unprotect the workbook?
what is maximum amperage rating for 3 phase 100KVA transformer at continue load?
Well, i got it. Thanks sir.
am unable to download please send the sheet to [email protected]
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.
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
Will be fixed very soon, please be patient… Tnx!
I am unable to download the sheet.
Can you kindly send the same to me at my email address
Try now, it’s fixed.
I am unable to download the sheet.
Can you kindly send the same to me at my email address
Try now, it’s fixed.
I am unable to download the sheet.
Try now, it’s fixed.
Sir, thanks for upload. How do you determine the transformer overloading factors?
Did you follow any standards? Please reply…
I am unable to download the sheet.
Can you kindly send the same to me at the following address.
[email protected]
with best regards
ugyen thinley
Try now, it’s fixed.
how to download, please give idea to download ur spread sheet
Dear Mr. Jignesh.
I am unable to download the sheet.
Can you kindly send the same to me at the following address.
[email protected]
regards
Deepak