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

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
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
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
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
Full Atterberg limits data reduction with live formulas: multipoint liquid limit flow curve, plastic limit, plasticity, liquidity and activity indices, Casagrande plastic…
Details
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
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
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
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
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
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
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
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
A ready inspection checklist for supervisors and contractors: 60 items in 10 sections (documents, excavation, shoring, dewatering, subgrade and lean concrete, reinforceme…
Details
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
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
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…
DetailsProctor 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 guideFoundation settlement step by step: elastic settlement, Terzaghi consolidation on clay, t50 and t90, the settlement–time curve and the allowable-settlement check.
Read guideSquare 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 guideSlope 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 guideHow 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 guideHow 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 guideHow 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 guideMessage 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