Manually calculating superelevation for multiple curves is time‑prone to errors. An automates the process based on the governing design standards (e.g., AASHTO Green Book, IRC, AS 5100). This article explains the theory, the step‑by‑step calculation procedure, and how to build a reusable Excel sheet. Key Parameters for Superelevation Calculation | Parameter | Symbol | Typical unit | Description | |-----------|--------|--------------|-------------| | Design speed | V | km/h or mph | Regulates the curve’s radius and superelevation | | Curve radius | R | m or ft | Centreline radius of the horizontal curve | | Side friction factor | f | dimensionless | Coefficient of lateral friction between tyre and pavement | | Superelevation rate | e | m/m or % | Transverse slope (e.g., 0.07 = 7%) | | Acceleration due to gravity | g | 9.81 m/s² | Constant | Fundamental Equation For a vehicle on a curved path, the equilibrium of forces gives the basic superelevation formula:
= IF( F2 <= D2, "OK", "e_max insufficient – increase radius or reduce speed" ) (minimum radius for given speed and e_max): superelevation calculation excel sheet
| A | B | C | D | E | F | G | H | I | |---|---|---|---|---|---|---|---|---| | Curve ID | Design Speed (km/h) | Radius (m) | e_max (max superelevation) | f (from table) | Required e (calc) | Adopted e | Check (e ≤ e_max) | R_min (m) | In a separate sheet (or same sheet, columns J–L), create a lookup table for side friction factor (f) vs design speed (AASHTO Green Book 2018): Key Parameters for Superelevation Calculation | Parameter |
[ e + f = \fracV^2g \cdot R ]
[ e_required = \fracV^2127 \cdot R - f ] AASHTO Green Book