Sheet — Superelevation Calculation Excel

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

= MIN( F2, D2 ) (check):

= (B2^2) / (127 * (D2 + E2)) (if e is limited): superelevation calculation excel sheet

=VLOOKUP(B2, $J$2:$K$11, 2, TRUE) (required e): = IF( F2 &lt;= D2, "OK", "e_max insufficient

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

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