Home
ExcelCalcs
BEAMCOL9.xls (1 viewing) (1) Guest
This area of the Forum is reserved for notes about the Version history of items in the repository. A link to the related repository item is always included at the top of each thread.
 Favoured: 314
TOPIC: BEAMCOL9.xls
#560
(User)
Frog Prince (Platinum Boarder)
Posts: 232

 BEAMCOL9.xls 11 Years, 1 Month ago Karma: -2 This forum thread will track of the version history of the following download: BEAMCOL9.xls

Logged
The administrator has disabled public write access.
#1416
(User)
Frog Prince (Platinum Boarder)
Posts: 181

 Update to V3.5 9 Years, 8 Months ago Karma: 53 After all of these years in working on very my first all metric units project (haven't I been fortunate) the past several months, we in the group have been making use of the "BEAMCOL9.xls", "BMREINF9.xls", and BASEPLT9.xls" spreadsheet workbooks. We also have been working with structural steel with a de-rated yield stress value. Thus, I removed the input data validation pick boxes which originally limited the user to specific values of 'Fy', 33 (old steel), 36, and 50 ksi. I also added the "ROUND" command to the sketches which displayed the member dimensions, to truncate the display of the member dimensions (d, tw, bf, and tf) in case they were converted by formula from metric to English. I merely wanted to make these workbooks a bit more "friendly" toward metric units usage. By the way for us ASD 9th Edition "die-hards", the "BeamCol(Built-Up)" worksheet is a useful tool for doing AISC Code checks using metric shapes, in that all you need to do is enter a formula in the input cells for each of the dimensions (d, tw, bf, and tf) in millimeters divided by 25.4, and the worksheet will automatically calculate all of the properties for you. Keep in mind that the "fillets" of the member are not considered, so the calculated properties will be very close approximations.

Logged

The administrator has disabled public write access.
#1793
(User)
Egg (Fresh Boarder)
Posts: 1

Logged
The administrator has disabled public write access.
#3661
(User)
Frog Prince (Platinum Boarder)
Posts: 181

 BEAMCOL9.xls update to version 3.6 1 Year, 9 Months ago Karma: 53 In the "BEAMCOL9.xls" spreadsheet workbook it was discovered that in the "BeamCol(C)" worksheet for analysis of C-shaped members, the program logic was not correctly set up to make use the transition equation (AISC 9th Edition Eqn. F2-2) when applicable for determining the allowable minor axis bending stress (Fby) between a maximum value of 0.75*Fy and a minimum value of 0.6*Fy depending on the bf/tf ratio. The rationale/logic described in the comment box in Cell H33 was correctly depicted, but the programming logic was not correct, which would have produced conservative results by deferring to a value of Fby = 0.60*Fy. This has been corrected and the version number of this workbook is now 3.6. I know that we have long moved on from the AISC 9th Manual ("green book" that most of us "old timers" have clung on to tightly for so long. However, I'm aware that because of familiarity many of us still fall back on it for quick cross-checks and preliminary/estimate engineering, and thus I will continue to support it in the form of updates to spreadsheets if/when required.

Logged

The administrator has disabled public write access.
We have 3 guests and 36 members online
Email (preferred method of contact)
US +1 617 5008224
EU +44 113 8152220
Our Feeds