Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
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.
Go to bottom Favoured: 232
TOPIC: BEAMCOL9.xls
#560
Katie (User)
Frog Prince (Platinum Boarder)
Posts: 232
graphgraph
User Offline Click here to see the profile of this user
BEAMCOL9.xls 10 Years, 4 Months ago Karma: -2  
This forum thread will track of the version history of the following download:
BEAMCOL9.xls
 
Logged Logged  
  The administrator has disabled public write access.
#1416
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Update to V3.5 8 Years, 11 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 Logged  
 
  The administrator has disabled public write access.
#1793
jopheim (User)
Egg (Fresh Boarder)
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Re:BEAMCOL9.xls 8 Years, 2 Months ago Karma: 0  
Alex,

Have you by chance been working on an update to your BEAMCOL9 for AISC 13th edition? I ask because I have been slowly updating your spreadsheet to AISC 13th edition as I need it and have time. If you would like, I can upload it to the site when I am complete. I thought it would help you out a little and be something everyone would find useful. However, I wanted to approve it with you first since this is still your original spreadsheet and you might be already working on an update.

By the way, thank you very much for all of your work on the many spreadsheets and for generously posting them for all of us to use. I have found them useful on many occasions.

Josh
 
Logged Logged  
  The administrator has disabled public write access.
#3661
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
BEAMCOL9.xls update to version 3.6 1 Year 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 Logged  
 
  The administrator has disabled public write access.
Go to top
We have 8 guests and 37 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.