Please reply to this topic to comment on or discuss Repository item:
ENDPLMC9.xls

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.

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.

Alex,

I was wondering what specific changes you made to the spreadsheet. I modified your previous version to handle an old Fluor Daniel moment connection to include a haunch. I want to be sure of the equations that need to be changed. Is it a simple copy and paste or is it more involved. Thanks in advance!

Mark

Mark,

Check out the steelutiltiesonline.com forum website. There is a thread there on my ENDPLMC9.xls workbook, and the revisions. I believe that the changes specifically pertained to the bolt shear and tension check calculations. I had tried to get too "cute" with it earlier and realized that there were situations where the #N/A error message occured. What I now did was determine what the allowable bolt shear is (without tension) and subsequently the allowable bolt tension is determined from the AISC interaction formulas. Just copy and paste those related cells, replacing the ones in the earlier version. That should fix you up.

http://steelutilitiesonline.com/forum/index.php?topic=208.0

Alex