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

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

Home / Download Center / Electrical Software Reviews / 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.

## 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

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

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!

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

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

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

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

7. esaivani
Feb 12, 2014

sir,

explain the brief note for earth mat calculation

8. Eric.Bernays
Sep 07, 2013

Is there a version for use in the UK?

9. mcalderac
Jul 17, 2013

10. dieng
Jun 20, 2013

Great Job man! Thanks a lot!

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

12. akira
Oct 25, 2012

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

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

14. keLvinz0r
May 31, 2012

GREAAAAT JOB!