View Document

 

All files are subject to the Terms of Agreement of this site
#312 -

IBC2006E

Posted by: Alex Tomanovich
October 07, 2009 08:25 am
Posted in: steelTOOLS

File(s) in this Document

IBC2006E   1.81 MB
  • Average Rating: 4/5
  • User Rating: 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
Score 5/5
 
8 Ratings
20 Favorited
5 Comments
3348 Views
1 Files
0 Shares
2280 Downloads
Analysis of seismic loading per IBC 2006 / ASCE 7-05 Codes, using Equivalent Lateral Force method
Tags/Keywords
Categories: Seismic   Load Analysis   ASCE7-05   IBC2006  

Comments

In the "Multi-Level Bldg. (Drift)" worksheet, I discovered that the allowable drift ratios were incorrectly presented. I had originally used the 2003 IBC Code version of this workbook, and merely edited it as required to create the 2006 Code version workbook. For some reason, I had inadvertently forgotten to edit the values for the allowable story drift ratios. I still had the ASCE 7-02 Code Table 9.5.2.8 values in that worksheet, when it should have reflected the values from the ASCE 7-05 Code Table 12.12-1. The values in those two tables are for the most the same. However, the significant difference in those two tables is that in the older code, the term "Seismic Use Group" (I, II, or III) is used, whereas in the newer code the term "Occupancy Category" (I, II, III, or IV) is used.

The comment box in cell G69 had the correct values shown based on "Occupancy Category".

The current version of the updated workbook is now version 1.3.

Alex
Alex Tomanovich
July 01, 2010 08:13 am
It was brought to my attention that I had a typo error in 3 of the worksheets. In input cell C15 of the “Multi-Level (Drift)” worksheet, as well as input cell 17 in both the “Arch. Components” and "M & E Components” worksheets, the displayed input data validation erroneously was referring to the ASCE 7-02 Code, when it should have been the ASCE 7-05 Code. These typo errors were obviously “left-overs” from me using the ASCE 7-02 workbook as a starting point to create the newer workbook.

The important thing was that the reference table and page number from ASCE 7-05 was correctly displayed in the body of each of those 3 worksheets.

I did not change the version number of the workbook for these very minor changes. It is still version 1.2.

Alex
Alex Tomanovich
January 11, 2010 07:42 am
An operational "glitch" was discovered in the "Multi-Level Bldg." worksheet of the "IBC2006E.xls" seismic workbook. In cells C64 and C65 for determining the structure fundamental period parameters, "CT" and "x", the array logic for the VLOOKUP command was not encompassing the entire table. As a result, structural system items G4 through G7 and H1 at the bottom of Table 12.2-1 from the ASCE 7-05 Code were not being included. Thus, if any of those items were selected from the user input pick box in cell C17, several "#N/A" error messages resulted. This problem did not occur with any of the other coefficients and factors pulled from that table in this worksheet, and did not occur at all in either the "Single-Level Bldg." or "Multi-Level Bldg. (Drift)" worksheets.

The corrections have been made and this workbook is now version 1.2.

Alex
Alex Tomanovich
December 17, 2009 08:47 am
Another great workbook from Alex. Thanks again!
Michael Jones
October 19, 2009 07:43 am
Thanks , I really admire your work & organized sheets.
Ahmed Alghamry
October 17, 2009 12:56 am

Related Documents and Links

 No related URLs or files
© Copyright 2010 American Institute of Steel Construction