For a structure or element, the wind force ( F_w ) is:
[ c_e(z) = c_r^2(z) \cdot c_t^2(z) \cdot \left[1 + \frac2 \cdot k \cdot \ln(z/z_0)c_r(z) \cdot c_t(z)\right] ]
| Cell | Formula | |------|---------| | v_b | =B7 * B9 * B10 | | q_b | =0.5 * B8 * (v_b^2) |
To create the Excel sheet, I started by setting up a table with the following columns:
The Eurocode provides a detailed methodology for calculating wind loads, including:
where σv is the standard deviation of the wind velocity.
q_p(z) = q_b * c_e(z) * c_o(z)*2