Search

Premium Membership ♕

Limited Time Offer: Save 15% on PRO Plan with discount code: LRN15 and study specialized LV/MV/HV technical articles and studies.

Home / Download Center / Electrical Software and MS Excel Spreadsheets (Calculations of cables, voltage drop etc.) / Earthing mat design for a power substation (MS Excel Spreadsheet)

What does this spreadsheet do?

Program is designed as per ANSI/IEEE 80 Code, it calculates step potential of switchyard, touch potential of switchyard, total length of earthing mat conductor, size of earthing mat conductor and total number of earthing rods.

Earthing mat design for a power substation (MS Excel Spreadsheet)
Earthing mat design for a power substation (MS Excel Spreadsheet)

Input fields As per ANSI/IEEE Std 80-1986 code

  • Length of Area Occupied by Earthing Grid
  • Width of Area Occupied by Earthing Grid
  • Fault level at Incoming Bus
  • Incoming Voltage
  • Outgoing Voltage
  • Soil Resistivity
  • Resistance of Main Earthing Mat
  • Resistance of surface Material (Crushed Rock )
  • Thickness of Surface Material (Crushed Rock)
  • Depth of Earthing Grid Conductor
  • Diameter of Earthing Grid Conductor
  • Reference Depth of Grid
  • Spacing between Parallel Conductor of Grid
Software:Earthing Mat Design For Substation
Version:22.12.2012 New
Developer:Jignesh Parmar
Size:46 Kb
Price:Free
Download:Right here | Video Courses | Membership | Download Updates

Earthing Mat Design For Substation

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

30 Comments


  1. Omar Gatous
    Jul 09, 2023

    I am thinking and looking for something to learn about how to design primary and secondary earthing systems for any project.
    I am electrical engineer


  2. Nasir Mehmood
    Dec 27, 2022

    We are making 6700KVA hydel power station. Along 11KV/66KV Switch Yard. Is it necessary for both? Or just for switchyard area.


    • Daniel Kubelwa
      May 09, 2023

      how is the TFX is being link by used a direct or resistor or inductance?


  3. isaac serwadda
    Jun 14, 2022

    Great knowledge sharing


  4. Mohammed Haris Qurashi
    Apr 07, 2022

    Can anyone tell me soil treatment procedure for Single Grounding with reference to Standard…


  5. Anil
    Oct 11, 2021

    Please tell me what is the basis of selection of Ambient Temperature-35 Degree.


  6. Haytham Alloush
    Sep 18, 2021

    Are the step & touch voltages calculated for HV substations ? or they should be calculated for LV projects as street lighting poles or LV water pumps projects too ?


  7. Corpuz
    Sep 09, 2021

    It is better if you would show us how these are derived


  8. BENEDICT UKPEBOR
    Sep 09, 2021

    This portal is very informative. What are the requirement for premium membership?


  9. Koustav Saha
    Dec 26, 2018

    What is the tolarable value of GPR/EPR for earthing grid calculation?


  10. Amardeep Sah
    Sep 14, 2018

    Sir,
    Can u send me the details required to design an earth mat for 33/11 KV PSS


  11. hesham
    Jun 26, 2018

    thanks alot


  12. Khaled Ellithy
    Jan 25, 2018

    Excellent;

    Ellithy
    Professor in Power systems


  13. Mamata Patil
    Sep 25, 2016

    I want to give a seminar on grid Earthing..Can u give me detail info about it?


  14. NIDHI
    Jan 08, 2016

    Sir,

    In the design procedure for earthing it is said that as we doubles the length of the rod the resistance will be reduced by 40% and when we increase the size of the electrode the resistance decreases by 10%. i am getting this . with reference to what equation the above mentioned conclusions is reached


  15. Murugesan.C
    Jul 08, 2015

    I am not able to see the detailed drawing about construction of earth mat. A drawing shall be presented indicating driving/penetrating number of MS rod in ground and connecting all of them by a earthing flat/strip. Illustration of such drawing may help the young engineers to learn and execute.


  16. Nadun
    Jun 26, 2015

    Could u please explain me how to do the earth mat design for 220/132/33 kV Outdoor GSS which have 5 steps (135m, 138m, 141m, 144m, 147m).

    Can’t do the Earth mat design separately for each step and finally connect each steps together. OR is it must to do the design for all the steps together?

    Since their is huge civil work in step 144m and 147m it may take some time, so we can start lower 3 level works if we can lay the earth mat.

    Thank you!


  17. RAJEEV SINGH
    Dec 03, 2014

    I want to design the Earthmat of Solar Park of 10MW consisting of 10 Nos. step up transformers spreading over huge land area, which is evacuating the power at 11kV level. Please suggest:
    i) whether the each earth mat is to be connected.
    ii) for DC earthing separate mat is provided?
    iii) spacing between conductors and material??


  18. radixit
    Aug 14, 2014

    I want to design the earth mat of a 33/11 kv substationat kanpur for which i want to know the fault current the resistivity we have found 22 ohm met and IEEE80 formule is not available,there fore I WANT YOUR HELP


  19. ramesh
    Jun 30, 2014

    Among the inputs data, i don’t understand what you mean by the following, which is both required in your program:
    i) Reference Depth of Grid and Depth of Earthing Grid Conductor
    ii) Diameter of Earthing Grid Conductor or size of earthmat flat
    iii) Number of adjacent earthing mat conductors
    iv) How evaluate the values Ks, Df

    Kindly explain what you mean by these terminologies, and where to get such inputs.


  20. Robinson
    May 15, 2014

    Among the inputs data, i don’t understand what you mean by the following, which is both required in your program:
    (i) Number of adjacent earthing mat conductors
    (ii) Margin factor in earthing mat against corrosion and rusting.

    Kindly explain what you mean by these terminologies, and where to get such inputs.


  21. esaivani
    Feb 12, 2014

    sir,

    explain the brief note for earth mat calculation


  22. Eric.Bernays
    Sep 07, 2013

    Is there a version for use in the UK?


  23. mcalderac
    Jul 17, 2013

    thanks for this page. ***** five stars !!!!


  24. dieng
    Jun 20, 2013

    Great Job man! Thanks a lot!


  25. Roshan Mathew Verghese
    Nov 01, 2012

    Hi edvard,

    could you put up an article for measuring the Earth Resistance, Step & Touch potentials, using a Injection transformer ?


  26. akira
    Oct 25, 2012

    Dear Sir
    Thank you for this subject , i need to know how to determine required no. of earthing rods?
    Regards


  27. RAGHAVENDRA KUMAR
    Aug 28, 2012

    Can u send me the details required to design an earth mat for 132/33KV Substation which the area consist of 12400 Sqm and 13620 SqM?


  28. keLvinz0r
    May 31, 2012

    GREAAAAT JOB!
    I’M YOUR FAN!


  29. Pandiyan
    Dec 29, 2011

    Sir,
    Can u send me the details required to design an earth mat for 230/110KV GIS Substation which the area consist of 60by 75 mtrs?

Leave a Reply to mcalderac

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!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge