Superelevation Calculation Excel Sheet -

[ e + f = \fracV^2g \cdot R ]

Introduction Superelevation (also known as cant or banking) is the transverse slope provided to a road or railway curve to counteract the effect of centrifugal force on vehicles. Properly designed superelevation ensures safety, comfort, and stability for vehicles negotiating a horizontal curve.

Extend the sheet to calculate superelevation runoff lengths and pavement cross‑section elevations at stations along the curve. With Excel’s built‑in functions, you can also generate banking diagrams automatically. superelevation calculation excel sheet

= IF( F2 <= D2, "OK", "e_max insufficient – increase radius or reduce speed" ) (minimum radius for given speed and e_max):

= (B2^2) / (127 * (D2 + E2)) (if e is limited): [ e + f = \fracV^2g \cdot R

| Speed (km/h) | f_max | |--------------|-------| | 30 | 0.17 | | 40 | 0.17 | | 50 | 0.16 | | 60 | 0.15 | | 70 | 0.14 | | 80 | 0.14 | | 90 | 0.13 | | 100 | 0.12 | | 110 | 0.11 | | 120 | 0.09 |

= MIN( F2, D2 ) (check):

=VLOOKUP(B2, $J$2:$K$11, 2, TRUE) (required e):

= (B2^2) / (127 * C2) - E2 (adopted e):

[ e_required = \fracV^2127 \cdot R - f ]

| 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): With Excel’s built‑in functions, you can also generate