You can Print it as a professional calculations report for grounding system design for Domestic, commercial and industrial premises.Materials selected by grounding design process like Grounding conductors, Grounding stations and buried grounding mains, Provide grounding installation criteria for earth electrodes,Įarth pit, ground buses, grounding conductors, grounding of switches/ panels/ boxes/ cable trays / conduits and special groundingįor high tension cables/ control cables /static electricity,Ĭalculations for different cases, shapes and types of earth electrodes,.Soil Resistivity by using ground testers that apply The Wenner 4-Point Method ,Ī professional design concept for any Grounding System, The spreadsheet can also be used to design an MSE wall with a bridge abutment on top. The spreadsheet can be used to design simple MSE walls with flat, sloped or broken back slopes. Earthing conductor size calculation Formula: Earth conductor size PE (Sqmm) in sqmm is equal to the square root of maximum operating time t (S) in Seconds times of fault current square I (fault-A) divided by material constant k. There are three basic Excel tools that can work for you, no matter how you want to manipulate your geographic coordinates. The earthwork volume calculation sheet, shown in image, is divided into columns for recording and calculating information. They provide a means of tabulating earthwork quantities for use in the mass diagram discussed. If you have a long list of geographic coordinates to work with, a Microsoft Excel spreadsheet is sure to be useful. The earthwork volume sheets allow you to systematically record this information and make the neccessary calculations.
In either case, the volume is calculated by multiplying the cut or fill depth by the area of the grid cell. Latitude and Longitude in Excel: Calculate Distance, Convert Degrees, and Geocode Addresses. If the resultant depth is positive then this is a fill cell, while a negative value indicates a cut cell. List typical Values of Resistivity from BS 7430 and IEEE 142,Īll applicable standards for Grounding System Design Calculations for Domestic, Commercial and Industrial Premises,Īcceptable values for Earthing Resistance, The spreadsheet calculates the both the external stability of the MSE wall and the internal design of the soil reinforcement. The cut or fill depth for each cell is found by subtracting the average existing level of the cell from the average proposed level.OF ELECTRODES IN LINE or IN SQUARE or IN RECTANGLE or IN TRIANGLE36(4, 8,12.16,20, 24, 28, 32, 36, 44, 52, 60, 68, 76 for S or R) data that must be known in the starting of Grounding System Design Calculations for Domestic, Commercial and Industrial Premises like ARRANGMENT OF ELECTRODES, LINE or SQUARE or RECTANGLE or TRIANGLE ( L or S or R or T)R(2,3,4,5,6,7,8,9,10 for L)00123.32005.