Search

Premium Membership

Study specialized technical articles, papers & video courses in low/high voltage areas. Save 50% on all courses at the EEP Academy with the Enterprise Plan.

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

24 Comments


  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

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


  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

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


  10. kamlesh shah
    Jan 25, 2016

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


  11. nitin
    Jan 21, 2016

    I am unable to download the sheet.


  12. saugat poudel
    Jul 24, 2015

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


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


  14. Ramkumar
    Jul 13, 2014

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


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

fifty five  +    =  57

EEP Academy Video Courses

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