Wind loads are a primary lateral force for mid-rise and tall structures in most of the world, and in many low-seismicity regions they govern the design of the entire lateral system. The UBC 1997 wind load provisions (Chapter 16, Division III) use a straightforward static pressure approach that is easy to apply, transparent in its assumptions, and still widely used for assessment of existing pre-2000 buildings and in international jurisdictions that adopted UBC 1997.
This free Excel sheet automates all UBC 1997 wind pressure calculations. Below is a complete guide to the code method, its formulas, tables, and a fully worked example — so you understand exactly what the sheet is calculating and why.
🌬 HOW UBC 1997 BUILDS UP WIND PRESSURE
1. UBC 1997 Wind Load Method Overview
UBC 1997 Chapter 16 Division III (§§1613–1618) uses a static equivalent pressure approach. Unlike ASCE 7’s more complex directional or envelope methods, UBC 1997 applies a single design wind pressure p at each height zone on the windward wall, and a separate pressure on the leeward wall. The method is:
- Determine the basic wind speed V from UBC Figure 16-1 (fastest-mile wind speed in mph, or 3-second gust depending on edition — UBC 1997 uses fastest-mile)
- Compute the wind stagnation pressure qs from V
- Select the exposure category (B, C, or D) based on terrain
- Look up the combined height and exposure factor Ce from Table 16-G
- Select the pressure coefficient Cq from Table 16-H for the surface
- Apply the importance factor Iw
- Compute design pressure p and apply to the projected area
2. Exposure Categories (B, C, D) — UBC 1997 §1616
The terrain surrounding a building determines how turbulent and fast the wind is at low elevations. UBC 1997 uses three exposure categories (note: unlike ASCE 7, there is no Exposure A in UBC 1997):
| Exposure | Terrain Description | Wind Effect | Typical Settings |
|---|---|---|---|
| B | Terrain with buildings, forest, or surface irregularities 10 m or more in height covering >20% of the area extending 1.6 km from the site | Lowest wind pressures — most sheltered | Suburban areas, wooded terrain, urban centres |
| C | Terrain that is flat and generally open, extending ½ mile or more from the site in any full quadrant | Intermediate — default for most sites | Open farmland, airports, flat terrain |
| D | Flat, unobstructed areas exposed to wind flowing over large bodies of water (≥1.6 km) | Highest pressures — most exposed ⚠️ | Coastal sites, shores of large lakes, islands |
3. Basic Wind Speed & Stagnation Pressure qs
UBC 1997 uses the fastest-mile wind speed V (mph) from Figure 16-1 at a 10 m height in Exposure C for a 50-year mean recurrence interval. The wind stagnation pressure qs is:
4. Design Wind Pressure Formula (UBC 1997 §1614)
The complete design wind pressure p applied to any surface is:
5. Combined Height & Exposure Factor Ce (UBC 1997 Table 16-G)
Ce accounts for both the height-dependent wind speed profile (faster wind at greater height) and terrain roughness (exposure category):
| Height Above Ground (m) | Exposure B | Exposure C | Exposure D |
|---|---|---|---|
| 0–4.6 | 0.62 | 1.06 | 1.39 |
| 6.1 | 0.67 | 1.13 | 1.45 |
| 7.6 | 0.71 | 1.19 | 1.50 |
| 9.1 | 0.76 | 1.23 | 1.54 |
| 12.2 | 0.84 | 1.31 | 1.62 |
| 15.2 | 0.95 | 1.38 | 1.69 |
| 18.3 | 1.04 | 1.45 | 1.75 |
| 21.3 | 1.13 | 1.53 | 1.81 |
| 24.4 | 1.21 | 1.61 | 1.87 |
| 30.5 | 1.35 | 1.74 | 1.98 |
| 36.6 | 1.48 | 1.85 | 2.07 |
| 45.7 | 1.65 | 2.01 | 2.20 |
| 60.0 | 1.87 | 2.20 | 2.36 |
Intermediate values may be interpolated linearly. Values above 61 m: extrapolate using power law.
6. Pressure Coefficient Cq (UBC 1997 Table 16-H)
Cq reflects the shape of the building and the surface being loaded. Positive values indicate pressure toward the surface (inward); negative values indicate suction (outward):
| Surface / Condition | Cq |
|---|---|
| Primary frames and systems (Method 2 — projected area) | |
| Windward wall (all exposures) | +0.8 |
| Leeward wall (h/d ≤ 1) | −0.5 |
| Leeward wall (h/d > 1) | −0.6 |
| Roof (windward — slope <2:12) | −0.7 |
| Roof (windward — slope 2:12 to 9:12) | −0.9 to +0.3 |
| Roof (leeward — all slopes) | −0.7 |
| Components & cladding (local pressures) | |
| Wall elements — inward | +1.2 |
| Wall elements — outward (sheltered areas) | −1.2 |
| Corners & eaves — outward (high local suction) ⚠️ | −2.0 |
| Parapets — windward face | +1.3 |
| Parapets — leeward face | −1.0 |
7. Importance Factor Iw
| Occupancy Category | Building Type | Iw |
|---|---|---|
| Standard Occupancy | Most buildings (residential, commercial, industrial) | 1.00 |
| Essential Facilities | Hospitals, fire stations, emergency operations centres, schools | 1.15 |
| Hazardous Facilities | Structures storing toxic or explosive materials | 1.15 |
8. UBC 1997 vs ASCE 7 Wind — Key Differences
| Feature | UBC 1997 | ASCE 7-22 |
|---|---|---|
| Wind speed definition | Fastest-mile (mph) | 3-second gust (mph) — ~1.22× faster |
| Return period | 50-year | Risk-targeted MRI (300–3,000 yr depending on Risk Category) |
| Exposure categories | B, C, D | B, C, D (but more detailed fetch requirements) |
| Design pressure approach | p = CeCqqsI | p = qG Cp − qiG Cpi (includes internal pressure) |
| Gust effects | Embedded in Ce | Explicit gust factor G (0.85 rigid; varies for flexible) |
| Internal pressure | Not explicitly included | Explicitly required (GCpi = ±0.18 enclosed bldg) |
| Topographic effects | Not addressed | Topographic factor Kzt required for hills/escarpments |
| Directionality | Not addressed | Kd = 0.85 (most buildings) reduces design pressure |
9. Excel Sheet: Inputs, Outputs & How to Use
✅ You Enter (Yellow Cells)
- Building height (m or ft)
- Number of storeys & storey heights
- Building width (perpendicular to wind)
- Basic wind speed V (mph)
- Exposure category (B, C, or D)
- Occupancy (Iw = 1.0 or 1.15)
- Wall Cq (windward & leeward)
📊 Sheet Calculates
- qs wind stagnation pressure
- Ce at each storey height (interpolated)
- Windward + leeward design pressures
- Wind force per storey Fw,x
- Cumulative storey shear Vw,x
- Overturning moment MOT
- Base overturning moment & eccentricity
📌 Key Assumptions
- Static equivalent method (§1614)
- Enclosed building assumed
- Rectangular plan
- No topographic amplification
- Structural lateral system design not included — use forces as input to your frame/shear wall design
10. Worked Example: 10-Storey Commercial Building
Given:
- 10 storeys, each 3.6 m high; total hn = 36 m; width = 25 m
- Exposure C; V = 90 mph (fastest-mile); Iw = 1.0; h/d = 36/25 = 1.44 > 1
Step 1: Wind stagnation pressure
qs = 0.00256 × 90² = 20.7 psf = 991 Pa
Step 2: Cq selection
Windward: Cq = +0.8; Leeward (h/d > 1): Cq = −0.6; Net Cq = 0.8 + 0.6 = 1.4
Step 3: Wind force per storey (sample at Storey 8, midpoint h ≈ 27.5 m)
| Storey | Mid-Height (m) | Ce (Exp C, interp.) | p (Pa) | Area (m²) | Fw (kN) |
|---|---|---|---|---|---|
| 1 | 1.8 | 1.06 | 1,471 | 90.0 | 132 |
| 2 | 5.4 | 1.10 | 1,526 | 90.0 | 137 |
| 3 | 9.0 | 1.23 | 1,706 | 90.0 | 154 |
| 5 | 16.2 | 1.40 | 1,942 | 90.0 | 175 |
| 8 | 27.0 | 1.67 | 2,317 | 90.0 | 208 |
| 10 | 34.2 | 1.83 | 2,539 | 90.0 | 228 |
| TOTAL | — | — | — | 900.0 | ~1,740 kN |
Note: p = Ce × 1.4 × 991 × 1.0; Fw = p × (25 m × 3.6 m storey height)
11. Tips, Facts & Common Mistakes
✓ Top Tips
- Use the combined (windward + leeward) net Cq for calculating the total lateral force on the LFRS. For component design use individual surface pressures.
- Ce is evaluated at the top of each height zone (not the midpoint) for primary frame design using the projected area method.
- For coastal or waterfront sites, verify whether Exposure D applies — Ce values can be ~30% higher than Exposure C at low heights.
- Always check both wind and seismic — for buildings under ~4–6 storeys in Zone 4, seismic typically governs; wind may govern at greater heights or in Zones 1–2.
- UBC 1997 wind forces are already at strength level (multiplied by load factor 1.3 in the UBC load combinations).
❌ Common Mistakes
- Mixing UBC 1997 fastest-mile speeds with ASCE 7 3-second gust maps — they are NOT interchangeable. 80 mph fastest-mile ≠ 80 mph 3-second gust.
- Using Exposure B in urban areas without confirming the 1.6 km fetch of obstructions — most urban sites default to Exposure C.
- Forgetting the leeward pressure contribution — using only Cq = 0.8 (windward only) instead of 0.8 + 0.6 = 1.4 net for lateral forces.
- Applying wind and seismic at 100% simultaneously — UBC 1997 does not require this; check each separately.
- Ignoring parapet wind loads — Cq = ±1.3 on parapets can be critical for roof connections and cladding anchor design.
12. Free Download
The UBC 1997 Wind Analysis Excel sheet computes wind pressures and storey forces automatically once you input your building geometry, wind speed, exposure, and occupancy category. All formulas reference UBC 1997 Chapter 16 provisions and are fully visible.
Use the download button at the top of this page to access the free Excel sheet.
All code provisions referenced are from UBC 1997 (ICBO). Design must be verified by a licensed structural engineer. Wind speed data should be confirmed from the applicable regional seismic and wind hazard maps for the project jurisdiction.
