A module of loading functions for Excel's AFE

Loading.txt

Get_Bending_Moment = LAMBDA(permanent_UDL, imposed_UDL, length_mm,
    LET(
        g_k, permanent_UDL,
        q_k, imposed_UDL,
        L, length_mm,
        γ_g, 1.35,
        γ_q, 1.5,
        (γ_g * g_k + γ_q * q_k) * (L / 1000) ^ 2 / 8
    )
);

Get_Shear_Force = LAMBDA(permanent_UDL, imposed_UDL, length_mm,
    LET(
        g_k, permanent_UDL,
        q_k, imposed_UDL,
        L, length_mm,
        γ_g, 1.35,
        γ_q, 1.5,
        (γ_g * g_k + γ_q * q_k) * (L / 1000) / 2
    )
);