Geotechnical Excel Tools

Ready-to-use, bilingual (English / Persian) Excel sheets for soil-mechanics tests and foundation design — open formulas, no macros, printable A4 reports.

Buy via WhatsApp — instant delivery

Complete Geotechnical Excel Package — 16 Sheets

Complete Geotechnical Excel Package — 16 Sheets

All RastaWorks Excel sheets in one package: 7 lab-test analyses, bearing capacity, settlement, piles, slope stability, retaining wall, lateral earth pressure, site class …

Details
Triaxial Test Analysis Excel Sheet (UU / CU / CD) — Bilingual

Triaxial Test Analysis Excel Sheet (UU / CU / CD) — Bilingual

Full triaxial data reduction with live formulas: effective c' and φ' and total-stress parameters from 3–5 specimens, Mohr circles, p'–q diagram, an A4 report sheet and c_…

Details
Consolidation (Oedometer) Test Analysis Excel Sheet — Cc, Cr, σ'p, cv and Settlement — Bilingual

Consolidation (Oedometer) Test Analysis Excel Sheet — Cc, Cr, σ'p, cv and Settlement — Bilingual

Full 1D consolidation data reduction with live formulas: e–log σ' curve, Cc, Cr, Cs, preconsolidation pressure and OCR, cv by √t and log t methods, permeability, secondar…

Details
Particle-Size Analysis Excel Sheet (Sieve + Hydrometer) — D10, Cu, Cc and Gradation Curve — Bilingual

Particle-Size Analysis Excel Sheet (Sieve + Hydrometer) — D10, Cu, Cc and Gradation Curve — Bilingual

Full grain-size data reduction with live formulas: sieve percent passing, hydrometer analysis by Stokes' law, combined gradation curve, D10, D30, D60, Cu, Cc and gravel, …

Details
Atterberg Limits and USCS Classification Excel Sheet — LL, PL, PI and Plasticity Chart — Bilingual

Atterberg Limits and USCS Classification Excel Sheet — LL, PL, PI and Plasticity Chart — Bilingual

Full Atterberg limits data reduction with live formulas: multipoint liquid limit flow curve, plastic limit, plasticity, liquidity and activity indices, Casagrande plastic…

Details
Direct Shear Test Analysis Excel Sheet — Peak and Residual c', φ', Stress–Displacement Curves — Bilingual

Direct Shear Test Analysis Excel Sheet — Peak and Residual c', φ', Stress–Displacement Curves — Bilingual

Full direct shear data reduction with live formulas: shear stress–displacement curves for 4 specimens, automatic peak and residual picking, Mohr–Coulomb envelopes, c', φ'…

Details
Unconfined Compression (UCS) Test Analysis Excel Sheet — qu, cu, E50 and Sensitivity — Bilingual

Unconfined Compression (UCS) Test Analysis Excel Sheet — qu, cu, E50 and Sensitivity — Bilingual

Full unconfined compression data reduction with live formulas: area correction, stress–strain curve, qu by peak or 15 % strain criterion, undrained shear strength cu, sec…

Details
Proctor Compaction Test Analysis Excel Sheet — Optimum Water Content, γd,max and Zero-Air-Voids — Bilingual

Proctor Compaction Test Analysis Excel Sheet — Optimum Water Content, γd,max and Zero-Air-Voids — Bilingual

Full compaction data reduction with live formulas: wet and dry densities of 6 points, fitted compaction curve, optimum water content and maximum dry unit weight, zero-air…

Details
Shallow Foundation Bearing Capacity Excel Sheet — Terzaghi and Meyerhof with Water Table — Bilingual

Shallow Foundation Bearing Capacity Excel Sheet — Terzaghi and Meyerhof with Water Table — Bilingual

Ultimate and allowable bearing capacity of strip, square, circular and rectangular footings with live formulas: Meyerhof and Terzaghi methods, shape and depth factors, lo…

Details
Foundation Settlement Excel Sheet — Immediate and Terzaghi Consolidation Settlement with Time — Bilingual

Foundation Settlement Excel Sheet — Immediate and Terzaghi Consolidation Settlement with Time — Bilingual

Total foundation settlement with live formulas: elastic immediate settlement, Terzaghi primary consolidation for up to 5 layers (normally and over-consolidated), 2:1 stre…

Details
Pile Capacity Excel Sheet — Axial (API) and Lateral (Broms) — Bilingual

Pile Capacity Excel Sheet — Axial (API) and Lateral (Broms) — Bilingual

Axial and lateral pile capacity with live formulas: shaft and tip resistance in clay (α method) and sand (β method with API limits), up to 5 layers, allowable capacity wi…

Details
Slope Stability Excel Sheet — Simplified Bishop with ru, Surcharge and Seismic Coefficient — Bilingual

Slope Stability Excel Sheet — Simplified Bishop with ru, Surcharge and Seismic Coefficient — Bilingual

Factor of safety of a homogeneous slope against a circular toe failure by the Simplified Bishop method (with Fellenius as a cross-check), with live formulas: 12 slices, a…

Details
Seismic Site Class (Vs30) and SPT Liquefaction Excel Sheet — Bilingual

Seismic Site Class (Vs30) and SPT Liquefaction Excel Sheet — Bilingual

Two linked tools in one workbook: Vs30 and site class per Standard 2800 with the PGA site factor, and SPT-based liquefaction triggering (simplified procedure) with factor…

Details
Foundation & Excavation Supervision Checklist Excel — 60 Items, Bilingual

Foundation & Excavation Supervision Checklist Excel — 60 Items, Bilingual

A ready inspection checklist for supervisors and contractors: 60 items in 10 sections (documents, excavation, shoring, dewatering, subgrade and lean concrete, reinforceme…

Details
Cantilever Retaining Wall Stability Excel — Overturning, Sliding, Bearing

Cantilever Retaining Wall Stability Excel — Overturning, Sliding, Bearing

Preliminary stability check of a cantilever retaining wall per metre run: Rankine active pressure with backfill slope and surcharge, factors of safety against overturning…

Details
CPT Liquefaction Triggering Excel — Robertson & Wride, FS and LPI

CPT Liquefaction Triggering Excel — Robertson & Wride, FS and LPI

Enter CPT data (qc, fs and optional u2) to get, for every depth, the soil behaviour index Ic, clean-sand equivalent resistance, CSR, CRR, liquefaction factor of safety, l…

Details
Lateral Earth Pressure Excel — Active, At-Rest and Passive with Groundwater, Surcharge and Cohesion

Lateral Earth Pressure Excel — Active, At-Rest and Passive with Groundwater, Surcharge and Cohesion

Enter up to 3 soil layers (unit weight, saturated weight, φ', c', OCR), surcharge and water-table depth to get active (Rankine), at-rest (Jaky) and passive pressure, tota…

Details

Free engineering guides

Laboratory testing

Proctor Compaction Test — Optimum Water Content and Maximum Dry Density Worked Example

Proctor compaction data reduction step by step: fitted curve, optimum water content, maximum dry unit weight, zero-air-voids check, 95% range, field relative compaction and oversize correction.

Read guide
Shallow foundations

Foundation Settlement Worked Example — Immediate and Consolidation Settlement

Foundation settlement step by step: elastic settlement, Terzaghi consolidation on clay, t50 and t90, the settlement–time curve and the allowable-settlement check.

Read guide
Shallow foundations

Bearing Capacity of a Square Footing — Terzaghi vs Meyerhof Worked Example

Square footing bearing capacity step by step: Meyerhof and Terzaghi side by side, shape and depth factors, water-table effect and factor-of-safety check.

Read guide
Slope stability

Slope Stability by the Simplified Bishop Method — Worked Example

Slope stability by the Simplified Bishop method: slices, pore pressure, iteration to F = 1.15, a Fellenius check and the value of drainage, with Excel formulas.

Read guide
Laboratory testing

Atterberg Limits Chart and USCS Classification — Four Worked Examples (CL, CH, ML, SC)

How to read the Atterberg limits chart (plasticity chart): LL, PL, PI, the A-line and U-line, and how to get the USCS symbol, with four worked examples: CL, CH, ML and SC.

Read guide
Retaining structures

Lateral Earth Pressure: Rankine Active, At-Rest and Passive — A Worked Example with Water and Surcharge

How to compute lateral earth pressure on a retaining wall: Ka, K0 and Kp, surcharge, groundwater and cohesion, with two fully worked numerical examples (128 kN/m and 140 kN/m) you can check by hand.

Read guide
Seismic geotechnics

CPT-Based Liquefaction Triggering: The Simplified Method Step by Step, with a Worked Example

How to evaluate liquefaction from CPT data: stress normalization, qc1N, CSR and CRR, magnitude scaling and the factor of safety — one fully worked depth (FS = 0.54) you can reproduce.

Read guide

How to buy

Message us on WhatsApp with the sheet (US$ 15 each) or the complete 16-sheet package (US$ 99) you want. We confirm the payment method and deliver the file immediately.

Chat on WhatsApp