I indicated that the Earthing Systems Design Steps process has (3) main steps:
Earthing Systems Design
Steps

And I explained the first step: Data Collection in the following Articles:
I explained the second step: Data Analysis in the following Articles:
And I explained What we are going to design for grounding system in any building in the following Articles:
And, in Article " Grounding Design Calculations – Part One ", I indicated the following:
Grounding System Design
Calculations according to type of the building
The procedures for performing the Grounding System Design
Calculations can differ slightly according to the type of the building
as follows:

First: Domestic,
commercial and industrial premises
We mean by domestic, commercial and
industrial premises, all installations up to 1,000 V ac and 1,500 V dc 
between phases, with some minor exceptions.

And I started discussion for Methods of Grounding Design Calculations of Domestic, commercial and industrial premises as follows:
Methods of Grounding Design
Calculations
There are many methods can be used for
performing Grounding System Design Calculations But the common methods
are:

In this Article and Article " Grounding Design Calculations – Part Two ", I explained the first method of grounding design calculations: Equations Method and solved examples.
Also, I explained the second method of grounding design calculations: Nomographs Method in Article " Grounding Design Calculations – Part Three".
Today, I will explain the Other Methods for Performing of Grounding System Design Calculations.
You can preview the following Articles for more info:
Third Method: Excel
Spreadsheets

Today, I will introduce to you, the most powerful excel spreadsheet for Grounding System Design Calculations of Domestic, commercial and industrial premises.
Important

Excel Spreadsheet For Grounding System Design Calculations Of Domestic, Commercial And Industrial Premises

why Using This Excel Spreadsheet
I recommend all electrical engineers to use this powerful excel spreadsheet because it has the following unique advantages than other similar ones:

Excel Spreadsheet Construction:
This excels spreadsheet includes (6) nos. worksheets and (22) nos. pages as follows:
S/N

Worksheet Name

No. of Pages

1

Table Of Contents

1

2

General Information

2

3

Grounding Design Concept

1

4

Grounding Installation Criteria

3

5

Grounding System Calculations

5

6

Grounding Specifications

7

Info Pages

3


Total

22

First: Table of Contents Worksheet
 This worksheet lists the other worksheets in an index as shown in above figure, you can go to a specific worksheet by just clicking on its name.
 On the other hand, you can return for any worksheet to the table of contents worksheet by clicking on the black box titled “Back to Table of Contents”.
 You email me directly by clicking on the phrase “Designed by: Ali Hassan” for any inquiries or notes.
Second: General Information Worksheet
This worksheet includes all the general data that must be known in the starting of Grounding System Design Calculations of Domestic, Commercial and Industrial Premises, so it includes the following sections:
 Project Data,
 Applied Standard and Codes,
 Electrical Utility Data,
 Required Earthing Resistance Value,
 Soil Characteristics,
 Info Page#1: Typical Values of Resistivity from BS 7430 and IEEE 142,
 Info Page#2: Calculation of Soil Resistivity by Measurements.
Important
Steps
for using Info page#2: Calculation of Soil Resistivity by Measurements are
included in the Help Guide below this info page.

Third: Grounding Design Concept Worksheet
This worksheet includes the general criteria that must be followed to determine what will be earthed, the shape and the size of earthing system, so it includes the following sections:
 Earthing System Include (what parts will be earthed),
 Function of the Earthing System,
 Configuration of the Earthing System,
 Neutral Point Connection to Earth,
 Earthing System Connection Method,
 Country Regulations Be Applied.
 Info Page#3: Steps for Choosing the Best Earthing System
Fourth: Grounding Installation Criteria Worksheet
This worksheet helps you to construct your grounding network in the project under design, it gives you the complete picture for all the items, conductors and accessories that you will need for providing a complete grounding network through the project, so it includes the following sections:
 Grounding Conductor (items that need a grounded conductor, grounded conductor type, size and identification),
 Grounding Stations (general criteria for earth electrodes and earth pit),
 Buried Grounding Mains (locations for Buried grounding main conductors and which parts must be connected to),
 Grounding Bus (locations for grounding buses, placement and which parts must be connected to),
 Connections (connections between conductors, terminations to equipment and terminations to columns & rails),
 Special Grounding (grounding criteria for high tension cables, for control cables and for static electricity),
 Deemed Grounded (grounding criteria for switches, panels, boxes, cable trays and conduits)
Fifth: Grounding System Calculations Worksheet
This worksheet helps you to calculate the following:
 Main Earthing Conductor from BS 7430:2011 and from IEEE std 80,
 Earthing rod resistance,
 Parallel earthing rods combined resistance,
 Earth resistance for three rods at the vertices of an equilateral triangle,
 Horizontal strip electrode (circular or rectangular section) resistance,
 Combined resistance for parallel earthing strips in straight lengths and connected together at one end only,
 Earth resistance for two strips set at right angles to each other meeting at one corner,
 Earth resistance for three strips set at 120° meeting at the star point all of equal length,
 Earth resistance for four strips set in a cruciform,
 Earthing plate resistance,
 Earthing resistance for a reinforced concrete foundation footing,
 Earthing resistance for an electrode surrounded by an infill of materials (such as bentonite or concrete).
Important

Sixth: Grounding Specifications Worksheet
This worksheet helps you to specify all the earthing system components that you will use to construct the grounding network through the building/project under design, so it includes the following sections:
1 Grounding conductor Specifications
 For buried grounding main conductor,
 For grounding bus conductor,
 For grounding branch conductor,
 For steel structure,
 For motors,
 For metal pipes (not carrying flammable gas or liquids), vessels and tanks.
2 Grounding stations Specifications
 Rod earth electrode,
 Earth pit,
 Conductor.
3 Buried grounding mains Specifications
 Connections to the earth rods,
 Connections to the indoor ground bus,
 Other buried grounding mains.
4 Types of earth enhancement materials
Important
Also,
In this worksheet, you will find multi choice check boxes for each item,
sometimes you need to check all of them, sometimes not while some items must
have one checked box only (one selection only), and in this case two or more
checked boxes will contradicted with other selections.

To download your copy of Excel Spreadsheet For Grounding
System Design Calculations Of Domestic,Commercial And Industrial Premises, please click on the link.
Note:
nonregistered members in ElectricalKnowhow website will not be able to open and use this excel spreadsheet.
To register as a member of ElectricalKnowhow website, do the following:
Notes for downloading our files:

In the next Article, I will explain Other Methods of Grounding Design Calculations. Please, keep following.
Post a Comment
Leave a comment to help all for better understanding