ASCE710W - ASCE 7-10 CODE WIND ANALYSIS PROGRAM

(5/28)

Description

ASCE710W – ASCE 7-10 Wind Load Analysis

A workbook for wind loads on buildings and open structures to ASCE 7-10. It selects or calculates the velocity pressure, gust effect factor and pressure coefficients and gives the net design wind pressures for the main wind force resisting system (MWFRS) and for wall and roof components and cladding (C&C).

Worksheets

  • MWFRS (Low-Rise) – envelope procedure (Chapter 28, Part 1) for enclosed or partially enclosed low-rise buildings, load cases A and B, with a check that the building qualifies as low-rise
  • MWFRS (Any Ht.) – directional procedure (Chapter 27) for buildings up to 500 ft, rigid or flexible, with pressures at user-chosen height steps
  • Wall C&C and Roof C&C – component and cladding pressures for flat, gable (up to 45°) and monoslope (up to 3°) roofs
  • Open Structures (no roof) – open frames, pipe racks and similar structures up to 500 ft
  • Wind Map – the basic wind speed map, Figure 26.5-1

Method

qz = 0.00256KzKztKdV² with Kz from the exposure constants α and zg; net pressure p = qh[(GCpf) − (±GCpi)]. For rigid structures G is the lesser of 0.85 and the Section 26.9.3 value; for flexible ones Gf follows Section 26.9.4 with the period from T = Cth0.75. C&C coefficients GCp are taken from equations in the ASCE 7-02 wind guide.

Inputs

Wind speed, risk category, exposure, building dimensions, roof type, Kzt, Kd and enclosure.

The stored low-rise example, an enclosed 20 × 60 ft monoslope building 12.5 ft high in Exposure C at 110 mph, gives Kh = 0.849, qh = 22.35 psf and, for zone 1 in load case A, net pressures of +4.9 and +13.0 psf with positive and negative internal pressure. US customary units.

Please note

  • Sheets are protected and formulas hidden. No macros. Version 2.4 (20 October 2015).

Based on Alex Tomanovich’s ASCE705W program, modified by David Taylor and William Fultz.

Calculation Preview

David (sumnerdave)
19 Apr 2023
File Size 1,472.75 Kb
Downloads: 1208
File Version: 2.4
File Author: David
File Rating (5/28)

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 6
johndoyle-admin 4 years ago
Thanks for updating the calculation Dave. I trust you are enjoying your free lifetime membership in recognition of the good work you have posted here!
dkpf32 6 years ago
Great spreadsheet and very easy to use. Any plans to update to ASCE 16?
johndoyle-admin 12 years ago
I have extended both your XLC Pro subscriptions as a thank you for working this issue through and keeping your calculations up to date.
sumnerdave 12 years ago
I see the problem. I had forgotten to update this file to version 2.2. I apologize. Current file has been uploaded but may be delayed if site administrator approval is required.
sumnerdave 12 years ago
Kevin,I'm not clear on your comment. I've double checked both GCpf Load Case tables (Figure 28.4-1) with the spreadsheet's tables and they match exactly. The example you gave does not make sense as well. Could you check the attached clip picture with GCpf values from a zero slope?
![Image uploaded by user](http://i238.photobucket.com/albums/ff316/sumnerdave/Capture-1.png)
Thanks, David Taylor
johndoyle-admin 13 years ago
Where Alex goes we all follow. Homage to a great engineer to another great engineer. Your free lifetime membership is assured. Thank you once again.