Eccentric shear on bolt group connection
Eccentric shear on bolt group connection
(OP)
Hi, everybody!
I just completed the MS Excel spreadsheet calculating bolt group ultimate shear capacity according to LRFD 2nd Edition. I checked it against the tables and ... they match! I cannot attach the file, but you can find it on my website http://yakpol.net I tried to make this spreadsheet as simple and friendly as possible.
The weld group connection is due in the middle of june!
Cheers,
Yakov
I just completed the MS Excel spreadsheet calculating bolt group ultimate shear capacity according to LRFD 2nd Edition. I checked it against the tables and ... they match! I cannot attach the file, but you can find it on my website http://yakpol.net I tried to make this spreadsheet as simple and friendly as possible.
The weld group connection is due in the middle of june!
Cheers,
Yakov





RE: Eccentric shear on bolt group connection
I have tried to get to your homepage 'http:\\yakpol.net' to have a look at your spread sheet, but it seems like it is not existing. Is the path you have written, see above, correct?
An interested fellow member.
Cheers,
Eriksen
RE: Eccentric shear on bolt group connection
http://yakpol.net/
RE: Eccentric shear on bolt group connection
RE: Eccentric shear on bolt group connection
The sheet is beautifull!
Cheers,
Eriksen
RE: Eccentric shear on bolt group connection
found this web site when I searched for +bolts +eccentric +connection.
I have used the same method of finding the ultimate joint capability using LOTUS 123 many years ago.
The input to the program was more complicated. Not only did we had to use various fastener sizes, also the minimum thicknesses at each bolt location was different, furthermore fasteners could be bearing or shear critical. In regard to applied loads a could be input besides the vertical and horizontal shear load (partial fixed end moments on a beam !).
The convertion from LOTUS 123 to Excel was never completed. Therefore I am very interested in your spreadsheet. Unfortunately I am getting an error message that the solver add-in is not available. But other programms (i.e. diagonal tension shear beam analysis) using this add-in are running fine.
Any idea what the problem could be ?
Greetings from the North-West of the USA
Fritz-Gunther
RE: Eccentric shear on bolt group connection
Thanks for the complitments... Are you getting an error message from Excel or from boltgroup? The last time I ran boltgroup on Excel 2000 it worked fine. Check if Solver library is still check marked in VBA-tools-references. Try to run original file as is, if you still getting error message sent me the file: yakpol@hotmail.com
RE: Eccentric shear on bolt group connection
RE: Eccentric shear on bolt group connection
Taro,
The message about Solver maybe at false... As I see the number of rows of bolts should not make any difference. Be sure you are using the latest download and if still having the same problem send me a file.