Cyber Monday DealðŸ’¥

Save 20% with a coupon CYBM20 on PRO Membership Plan and 30% on courses at EEP Academy! Learn from experienced engineers!

# 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

Cyber Monday Deal ðŸ’¥ - Save 20% on Pro Membership Plan and 30% on courses at EEP Academy with a coupon CYBM20

Jun 14, 2022

Great knowledge sharing

2. Mohammed Haris Qurashi
Apr 07, 2022

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

3. Anil
Oct 11, 2021

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

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

5. Corpuz
Sep 09, 2021

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

6. BENEDICT UKPEBOR
Sep 09, 2021

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

7. Koustav Saha
Dec 26, 2018

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

8. Amardeep Sah
Sep 14, 2018

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

9. hesham
Jun 26, 2018

thanks alot

10. Khaled Ellithy
Jan 25, 2018

Excellent;

Ellithy
Professor in Power systems

11. Mamata Patil
Sep 25, 2016

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

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