Search

Premium Membership ♕

Save 10% on Pro Membership Plan with coupon DEC10 and study specialized LV/MV/HV technical articles and papers.

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.

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
Version:
Developer:Jignesh Parmar
Size:92 KB
Price:Free
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

26 Comments


  1. Kalyan
    Dec 08, 2023

    Could you please send the earthing transformer sizing spread sheet


  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
    so please make amend.

    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

    am unable to download please send the sheet to [email protected]


  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

    I am unable to download the sheet.
    Can you kindly send the same to me at my email address


  17. kamlesh shah
    Jan 25, 2016

    I am unable to download the sheet.
    Can you kindly send the same to me at my email address


  18. nitin
    Jan 21, 2016

    I am unable to download the sheet.


  19. saugat poudel
    Jul 24, 2015

    Sir, thanks for upload. How do you determine the transformer overloading factors?
    Did you follow any standards? Please reply…


  20. Ugyen Thinley
    Jun 10, 2015

    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


  21. Ramkumar
    Jul 13, 2014

    how to download, please give idea to download ur spread sheet


  22. Deepak Dubey
    Jul 13, 2014

    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

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!

eight  +  two  =  

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

EEP Hand-Crafted Video Courses

Check more than a hundred hand-crafted video courses and learn from experienced engineers. Lifetime access included.
Experience matters. Premium membership gives you an opportunity to study specialized technical articles, online video courses, electrical engineering guides, and papers written by experienced electrical engineers.