Working With Earthing and Grounding Design Spreadsheets
Most engineers working on substation or industrial earthing don't start from scratch every time. There are standardized calculation sheets that have been circulating for years, often shared between contractors and design firms. The ones commonly referred to involve step and touch potential calculations, earth resistance estimation, and conductor sizing per IEC 62305 or IEEE 80. People search for them constantly, and the results are a mixed bag of outdated files, partially broken sheets, and the occasional well-organized workbook that actually works. These spreadsheets are usually built around a few core equations. The ground potential rise (GPR) is calculated from fault current and soil resistivity. Step and touch voltages follow from the GPR with correction factors for grid density, burial depth, and soil layering. The worksheets typically handle the routine cases fine, but they stumble quickly when you hit anything non-standard. I remember trying to run one of these sheets for a solar farm installation where the site had highly layered soil with resistivity dropping from 800 ohm-meters at the surface to under 150 at three meters depth. The standard formula in the worksheet assumed a uniform half-space. The touch voltage it spit out was off by roughly 40 percent compared to what the field measurements later showed. The workaround was to manually compute an equivalent uniform resistivity using the weighted average approach before feeding the number into the sheet. You have to know when the sheet is lying to you.
The Practical Workflow
Here is how most people actually use these files in a real project, not the ideal version: The whole process on a typical small substation project runs about 3 to 5 hours if you have clean input data and a working template. Without it, you are looking at a full day of spreadsheet gymnastics and likely more errors. The biggest problem I see is people treating the output as final without verifying the assumptions baked into the sheet. Several versions floating around online still use the 1986 IEEE 80 methodology without the 2000 update. The difference shows up mainly in the touch voltage formula for shallow burial depths. If your grid is buried at 0.5 meters instead of the older default of 0.8 meters, the older version will give you a more conservative number, which might seem safer but can also lead to oversizing and unnecessary cost.
Another issue is the maximum grid length assumption. Some worksheets cap the valid application at roughly 250 by 250 meters. Beyond that, the conductor resistance and potential distribution change in ways the simplified formulas don't capture well. For larger substations, you need a software-based electromagnetic model like CDEGS or similar, not a spreadsheet.
Get the Full Details
Where to Find Them
There isn't a single official source. The worksheets tend to circulate through engineering forums, contractor internal libraries, and sometimes as attachments in project specifications. Some utilities provide their own customized versions as part of the design manual. If you are looking for a starting point, check industry discussion boards or reach out to a firm that does grounding design regularly. They often have cleaned-up templates they are willing to share if you ask properly. Be careful with files found on random download sites. I once opened a worksheet that looked professional but had a hardcoded fault current value from a completely different project buried in a hidden sheet. It didn't affect the main calculations visibly, but it would have tripped someone up during a peer review if they checked the inputs thoroughly. Always audit the file before relying on it.
When Spreadsheets Aren't Enough
If your site has complex topography, rocky terrain with variable resistivity, or multiple interconnected metallic structures, stop using the worksheet. These tools assume conditions they weren't built for. A proper modeling approach using finite element or method-of-images software will give you results you can actually stand behind. The cost of running a proper simulation is usually less than the cost of a field measurement that contradicts your spreadsheet output after construction. That said, for standard industrial and commercial projects with reasonable soil data and regular grid layouts, the worksheets are perfectly adequate. They cut design time down to something manageable and give you a defensible baseline before any detailed modeling is needed. Just treat them as a tool, not an authority.
