I created an Excel formula to calculate I:
Here's an example of a wind load calculation Excel sheet based on Eurocode: wind load calculation excel sheet eurocode
Eurocode requires different velocity profiles based on whether building height is less than zminz sub m i n end-sub . To evaluate the functional height in cell B8 : =IF(B8 < z_min, z_min, B8) Use code with caution. Peak Velocity Pressure Assuming cell E12 contains Turbulence Intensity ( Ivcap I sub v ), cell E13 contains Air Density ( ), and cell E14 contains Mean Wind Velocity ( =(1 + 7 * E12) * 0.5 * E13 * (E14^2) / 1000 Use code with caution. I created an Excel formula to calculate I:
(Roughness Factor): Accounts for the variability of the ground surface (e.g., sea, countryside, town, city). It depends on the Terrain Category (I to IV). is determined, you must calculate the pressures exerted
is determined, you must calculate the pressures exerted on the building surfaces: Internal Pressure ( ): cpec sub p e end-sub cpic sub p i end-sub
where A2 is the terrain type, vb_table is a reference table with vb,0 values, B2 is the directional factor, and C2 is the seasonal factor.
| Input Parameter | Value | Unit | | --- | --- | --- | | Location (latitude, longitude) | | | | Terrain type | | | | Building height | | m | | Building width | | m | | Building length | | m | | Roof slope | | ° |