Earthing Mat Design For Substation Spreadsheet
Earthing Mat Design For Substation Spreadsheet (photo by esgroundingsolutions.com)

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

What this Spreadsheed does?

  • Program is design as per ANSI/IEEE 80-1986 Code
  • Calculate Step Potential of Switch yard
  • Calculate Touch Potential of Switch yard
  • Calculate Total Length of Earthing Mat Conductor
  • Calculate Size of Earthing Mat Conductor
  • Calculate Total No of Earthing Rods

Software:Earthing Mat Design For Substation
Version:22.12.2012 New
Developer:Jignesh Parmar
Size:46 Kb
Price:Free
Download:Right here | Get Download Updates | Get Technical articles

Earthing Mat Design For Substation

Weekly Download Updates //

Once per week, we are releasing download update in following sections: MS Excel calculation spreadsheets, electrical software and guides and various engineering books.

Be first to get this download update!

Subscribe Now!

Page edited by E.C. (Google).

14 Comments


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


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


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


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


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


  6. esaivani
    Feb 12, 2014

    sir,

    explain the brief note for earth mat calculation


  7. Eric.Bernays
    Sep 07, 2013

    Is there a version for use in the UK?


  8. mcalderac
    Jul 17, 2013

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


  9. dieng
    Jun 20, 2013

    Great Job man! Thanks a lot!


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


  11. akira
    Oct 25, 2012

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


  12. 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?


  13. keLvinz0r
    May 31, 2012

    GREAAAAT JOB!
    I’M YOUR FAN!


  14. 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 Comment

Tell us what you're thinking... we care about your opinion!
and oh, not to forget - if you want a picture to show with your comment, go get a free Gravatar!

seven × six =

CONNECT //