The Wind Analysis According to the UBC 1997 Excel sheet provides an easy way to compute loads due to wind, as per the Uniform Building Code (UBC) 1997. It enables the engineer to enter the critical factors — structure height, exposure category, importance factor, and basic wind speed — to calculate design wind pressure over different surfaces of a building.
About UBC 1997 Wind Load Provisions
The 1997 Uniform Building Code (UBC) was the dominant building code in the western United States and many international jurisdictions before being superseded by the International Building Code (IBC). Its wind load provisions in Chapter 16 provide a straightforward static pressure approach based on wind stagnation pressure and shape coefficients.
Despite newer codes being available, UBC 1997 wind provisions are still referenced for:
- Renovation and retrofit projects on older structures
- Jurisdictions that have not yet fully adopted IBC
- Academic and training purposes
- Comparison studies between code generations
Key UBC 1997 Wind Load Parameters
- Basic wind speed (V) — from UBC wind speed map in mph
- Exposure type — B (urban/suburban), C (open terrain), or D (coastal)
- Combined height, exposure, and gust factor (Ce) — tabulated per height and exposure
- Pressure coefficient (Cq) — for windward wall, leeward wall, and roof
- Importance factor (Iw) — 1.00 for standard occupancies, 1.15 for essential facilities
Wind Pressure Formula (UBC 1997)
Design wind pressure: p = Ce × Cq × qs × Iw
Where qs is the wind stagnation pressure at the standard height, calculated from the basic wind speed.
What This Excel Sheet Does
- Calculates qs from the entered basic wind speed
- Applies Ce values for each building level based on height and exposure
- Computes design pressure on windward wall, leeward wall, and roof
- Outputs total lateral wind force for structural analysis
Download the UBC 1997 Wind Analysis Sheet
This sheet remains a widely used reference tool for engineers reviewing legacy structures, preparing retrofit designs, or working in jurisdictions where UBC 1997 is still the applicable code. The step-by-step calculation layout makes it easy to follow the code logic and verify each result independently. Download the free Excel sheet below.
