jsb2505

Get_probability_of_exceedance = LAMBDA(return_period_years, 1 / return_period_years);

/**Uniform bridge contraction temperature range.
Ref: EC1-1-5 §6.1.3.3(3)
*/
Get_T_N_con = LAMBDA(T_0_con, T_e_min,
    T_0_con - T_e_min
);

/**Uniform bridge expansion temperature range.

jsb2505

/**Temperature coefficient based on CIRIA 108 - Derivation of Concrete Pressure in Formwork
*/
Get_Temperature_Coefficient_K = LAMBDA(concrete_temp_at_placing,
    LET(
        T, concrete_temp_at_placing,
        (36 / (T + 16))^2
    )
);

/**Max design pressure of concrete in formwork based on CIRIA 108 - Derivation of Concrete Pressure in Formwork

jsb2505

calculate_temperature_rise_from_20_degs_over_time = LAMBDA(binder_content, total_heat, concrete_density, time_elapsed_hrs,
    time_elapsed_hrs * binder_content / (total_heat * concrete_Density)
);

calculate_temperature = LAMBDA(temp_rise_from_20_deg, [test_mix_temp],
    LET(
        _test_mix_temp, IF(ISOMITTED(test_mix_temp), 20, test_mix_temp),
        _test_mix_temp + temp_rise_from_20_deg
    )
);

jsb2505

/**Design concrete moment of resistance in kNm from effective area, in kNm.
Ref: EC2 §Fig 3.5 Fig 6.1 (and first principles)
*/
Get_M_Rd_kNm = LAMBDA(f_ck, b_w_mm, d_mm,
    // (2091/12500) is the more exact coefficient than 0.167
    (2091/12500) * f_ck * b_w_mm * d_mm^2 / 10^6
);

/**The lever arm of the tensile steel or compression concrete about the neutral axis, in mm.
Ref: EC2 §Fig 3.5 Fig 6.1 (and first principles)