Slope Stability Analysis Input Sheet (Excel)
The Slope Stability Analysis Input Sheet is an Excel-based engineering tool designed to systematically collect, organize, and preprocess geotechnical and geometric data required for quantitative slope stability assessments in mining operations. It serves as a standardized interface between field data collection and analytical methods (e.g., limit equilibrium or numerical modeling), ensuring consistency, traceability, and auditability of input parameters. Primarily used by mine ground control engineers and rock mechanics specialists, it bridges observational data with computational analysis workflows.
📖 Overview
📑 Key Components
🎯 Applications
- ✓ Pre-feasibility and detailed mine design slope optimization
- ✓ Quarterly geotechnical risk reviews and stability audits
- ✓ Emergency response assessment following seismic events or heavy rainfall
📐 Key Formulas
Factor of Safety (FoS) – Bishop Simplified
FoS = [c' * L + (W * cosα - u * L) * tanφ'] / [W * sinα]
Calculates the factor of safety against circular or planar sliding using effective stress parameters; commonly implemented in spreadsheet-based limit equilibrium calculations.
Pore Pressure Ratio (ru)
ru = u / (γ * h)
Quantifies pore water pressure relative to overburden stress; used to adjust effective normal stress in stability computations.
Slope Angle (β)
β = arctan(H / L) * (180/π)
Derives overall slope angle from vertical height (H) and horizontal run (L); critical for kinematic feasibility and limit equilibrium boundary definition.