[ e_required = \fracV^2127 \cdot R - f ]
= IF( F2 <= D2, "OK", "e_max insufficient – increase radius or reduce speed" ) (minimum radius for given speed and e_max): superelevation calculation excel sheet
= MIN( F2, D2 ) (check):
| 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 | [ e_required = \fracV^2127 \cdot R - f
=VLOOKUP(B2, $J$2:$K$11, 2, TRUE) (required e): TRUE) (required e):