Instantaneous Center of Rotation Method

[E720]

Does anyone know of a good software/spreadsheet that checks bolt capacity under eccentric loads with the Instantaneous Center of Rotation (IC) Method. I made a VBA function that calculates it and it comes up with the same thing that the Steel Manual Tables has but that is a very limited set and I would like to test my function with different bolt configurations. My company has most of the major structural software.

 

[Celt83]

If you know how to use python I have a program that solves for the C coefficient. Link'

bolt_group_istantaneous_center.py is the program
bolts_IC_gui.py is a graphical interface for the program

to run the gui you need both files in the same directory

or alternatively I've attached a compiled version in a zip file, run the .exe once extracted

Open Source Structural Applications:

https://github.com/buddyd16/Structural-Engineering

 

[Guest090822]

ICC can be done with a spreadsheet. Personally, I use the elastic vector method. If it works for that it will work for anything!

 

[Agent666]

check these links

https://engineersviewpoint.blogspot.com/2010/01/test.html

https://engineersviewpoint.blogspot.com/2011/03/analysis-of-bolts-modified-visual-basic.html

https://engineersviewpoint.blogspot.com/2018/06/bolt-coefficient-calculator-spreadsheet.html

Last link has a spreadsheet implementing the method. Theres probably a few other posts on the blog regarding the method if you go searching, including implementation for a similar thing for using the IC method with welds.

He has since moved onto creating an online version of the tool here:-

https://engineersviewpoint.blogspot.com/p/notes.html

 

[dik]

A knock-off I wrote several years ago. Extract and rename the *.X to *.exe There are no viruses in the program.

Dik

 

[E720]

Thank you so much everybody for the help. It really is nice of everyone to help out fellow engineers. I have been using Celt83's python program.

The VBA function I wrote works well for my office because it can be used just as a regular function in a spreadsheet, albeit with a long list of input parameters.

We currently use the elastic method but we feel that we can get rid of some unneeded conservatism and use a more technically accurate method by switching to the IC method. My VBA function usually only takes 3-4 iterations to converge to within 0.5% but even if it runs 100 iterations you would never notice. We really see no down side.