Liquefaction Analysis Excel Sheet: Soil liquefaction occurs when saturated sands or silts lose strength under shaking. During an earthquake, these soils can behave like a liquid. Consequently, buried utilities may heave, foundations can tilt, and roadways might fail. Civil engineers working in seismic or high groundwater areas must assess this risk accurately.
Why Use This Spreadsheet
First, you avoid hunting through hand‑written formulas. Instead, you enter your soil data, groundwater depth, and seismic intensity into one workbook. Then, the sheet calculates factors of safety against liquefaction at various depths. It also highlights critical layers that require ground improvement. As a result, you gain clear insight into when to reinforce soils or redesign foundations.
How It Streamlines Your Workflow
Open the file and add borehole logs and earthquake thingy, workbook make graph of factor of safety vs depth, also make summary table for report or something, all formula is visible so you can see where result come from, you can also try mitigation option like densification or drainage by change few cell, its very helpful.
Download the Liquefaction Analysis Excel Sheet
To grab your free copy, click the Google Drive link on the original Engineering Community page. No sign‑in or subscription is needed—simply download, open in Excel or Google Sheets, and start your liquefaction assessment right away.