Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs Calculation Repository Repository Discussion
ENDPLMC9.xls (1 viewing) (1) Guest
This area of the Forum is Reserved for comments and discussion of specific Calculation Repository items. There is one topic for every document in the Repository. Generally authors like to receive feedback, to let them know that you value their contribution or to help them make improvements to their calculations. You might also like to make other users aware of other resources and references relating to this topic. I would encourage all users to leave some feedback when ever possible.
Go to bottom Post Reply Favoured: 0
TOPIC: ENDPLMC9.xls
#549
Katie (Admin)
Admin
Posts: 232
graphgraph
User Offline Click here to see the profile of this user
ENDPLMC9.xls 11 Months, 4 Weeks ago Karma: -5  
Please reply to this topic to comment on or discuss Repository item:
ENDPLMC9.xls
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1083
mdmichiels (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:ENDPLMC9.xls 1 Month, 3 Weeks ago Karma: 0  
Alex,

Recently I was using this spreadsheet (4 Tension Bolt MC tab)and had a question about one of the checks. For local flange bending, you calculate Pfb based on actual flange thickness. Shouldn't this have been Ff instead, therefore rendering Pfb = (4/3) or (5/3) * Ff?

By the way, I love this spreadsheet.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1122
ATomanovich (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:ENDPLMC9.xls 3 Weeks, 2 Days ago Karma: 4  
Attached is an update to the "ENDPLMC9.xls" (end plate moment connection) spreadsheet workbook. I added/revised some additional programming logic to eliminate the #NUM! errors that were being displayed in situations where the program was trying to take the square root of a negative number. There were also some bolt size/loading scenarios where a #VALUE! error would be displayed. Again, some additional programming logic was added to eliminate those display errors as well.

I know this stuff is still good old "ASD" and not the AISC 13th Edition, but its tough for some of us (myself included) to let go. Hopefully stuff like this is still an aid in preliminary engineering, estimates, and checking.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop