ASCE702S.xls
![](/components/com_remository_files/file_image_251/img_251_01.png)
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
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.
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