Where (for metric units):
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. superelevation calculation excel sheet
In Excel (assuming B2 = speed, B3 = e_max decimal, B4 = friction): AASHTO Green Book
= (B2^2) / (127 * (B3 + B4))
This is where the user defines the project constraints. the step‑by‑step calculation procedure