ASCE702S.xls

(5/7)

Description


"ASCE702S.xls" is a MS-Excel spreadsheet workbook for the analysis of snow loading (including snow drift) per the ASCE 7-02 Code. There is also a copy of the ground snow load map. The attempt here was to make the program self contained to the point where one does not even need to have a copy of the code at hand.

All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.

Please read the "DOC" worksheet for program details as well as assumptions and limitations.

Useful Web Resource
I was given a couple of websites which you might find convenient for determining the basic wind speed and ground snow load
for any location in the continental United States per the ASCE/SEI 7-05 Code, so I thought I'd pass them along.

The website links are as follows:
http://www.windspeedbyzip.com/
http://www.groundsnowbyzip.com/

You must register to make use of either website, but you only have to register at one, not both of the websites.   
Once you register at one of them, you will automatically have access to information from the other one.

The two websites allow you to input either the street/city/state address or just the zip code.   
The resulting location latitude and longitude are given.  Regular (street), satellite, and hybrid maps are available as well.

 

Calculation Reference
ASCE |Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Calculation Preview

23 Nov 2009
File Size: 426.50 Kb
Downloads: 820
File Version: 1.3
File Author: Alex Tomanovich, P.E.
File Rating (5/7)

 
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: 1
atomanovich 15 years ago
It was discovered in all 3 snow loading workbooks (ASCE705S.xls, ASCE702S.xls, and ASCE798.xls) that the sketch at the bottom of the calculation page as well as the sketch off of the calculation page to the right were displaying the calculated snow drift length, "w", when they should have been displaying the actual snow drift length to be used, "w(use)". The actual snow drift length to be used is the minimum of either the calculated value "w" or the maximum value "w(max)" per the Code.
At some point I will just drop the ASCE798.xls workbook, since most folks are probably using either the ASCE 7-05 or ASCE 7-02 Codes in their work.
For now I have made the corrections to the sketches in all three workbooks, and they are all now version 1.3
Web Analytics