Superelevation Calculation Excel Sheet < LIMITED ◎ >

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

= (B2^2) / (127 * (D2 + E2)) (if e is limited): 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 + f = \fracV^2g \cdot R

| 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): superelevation calculation excel sheet

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