Search

Premium Membership

Learn about power engineering and HV/MV/LV substations. Study specialized technical articles, electrical guides, and papers.

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

23 Comments


  1. George Brown
    Aug 05, 2020

    Thank you, nice work!!


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


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


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


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


  6. John Paul Laranja Tagari
    Dec 19, 2019

    sir what is the password to unprotect the workbook?


  7. Frank D. Nouahn
    Oct 05, 2019

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


  8. Tahir
    Oct 05, 2019

    Well, i got it. Thanks sir.


  9. James K
    Jan 19, 2018

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


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


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

  12. Edvard
    Edvard
    Feb 22, 2016

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


  13. ranko
    Feb 22, 2016

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


  14. kamlesh shah
    Jan 25, 2016

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


  15. nitin
    Jan 21, 2016

    I am unable to download the sheet.


  16. saugat poudel
    Jul 24, 2015

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


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


  18. Ramkumar
    Jul 13, 2014

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


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

EEP Academy Video Courses

The learning platform for LV/MV/HV electrical engineers. Learn from experienced engineers and sharpen up your knowledge.
Schneider Electric - Coming back stronger together!