×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Eccentric shear on bolt group connection

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

RE: Eccentric shear on bolt group connection

Hello Yakov,

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

(OP)
Server sometimes has problems, I guess... The site is accessible now. Thanks for the interest!

RE: Eccentric shear on bolt group connection

Thank you all for the tips, yes it works now.
The sheet is beautifull!

Cheers,

Eriksen

RE: Eccentric shear on bolt group connection

HI Yakov,

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

(OP)
gunther,
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

That's a pretty slick spreadshit, Yakov.  One problem...  When I run the program with one vertical line of bolts, it gives an error message if there are an odd number of rows of bolts (3, 5, 7, etc.).  The error message says that the solver add-in is not installed.  However, solver is installed and the program works fine if there are an even number of rows.  Do you have a fix for this problem?

RE: Eccentric shear on bolt group connection

(OP)

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources