Suresh:
Thanks for sharing your spreadsheet, I like it.
For a preliminary analysis I think it provides a quick estimate.
However, keep in mind that the "Spectral Response Accelerations Ss and S1" in your spreadsheet represent the highest values whithin the given zip code, which result in highest "Seismic Response Coeffecient" (base shear.)
I strongly suggest that for each speicific project site, the corresponding Latitude & Longitude (1) to be used. By doing so the designer will get the accurate values that can be substatially lower than the max.
And I still prefer to directly use the USGS " Java Ground Motion Parameter Calculator " (2) for the fact that it gets updated on a regular basis, and not to use a separate spreadsheet.
Note:
(1) The links for finding Longitude & Latitude by address
http://stevemorse.org/jcal/latlon.php
(2) USGS Web page
http://earthquake.usgs.gov/research/hazmaps/design/index.php#install_java
Regards
Casey (Khashayar) Hemmatyar, SE
Private email k@hemmatyar.com
-----Original Message-----
From: Acharya, Suresh [mailto:Suresh.Acharya@ci.concord.ca.us ]
Sent: Thursday, October 25, 2007 12:21 PM
To: 'seaint@seaint.org'
Subject: Tool for calculation of Sesimic Design Categoty (SDC) per 2006 IBC / ASCE7-05
I would like to share with you an Excel spreadsheet to calculate SDC based
on ZIP codes, written for use by our staff.
Spreadsheet can be downloaded from here:
http://www.structural.freespaces.com/sdc.xls.class
I appreciate your feedback, including any bug report.
Notes:
1. Remove the .class extension after you download the file. It is an Excel
spreadsheet, works ok with OpenOffice Calc program also.
2. ZIP codes for CA only
Suresh Acharya, S.E.
******* ****** ******* ******** ******* ******* ******* ***
* Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
* http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. Remember, any email you
* send to the list is public domain and may be re-posted
* without your permission. Make sure you visit our web
* site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ******