I'm trying to create an Excel spreadsheet that takes a 3D bolt group with x y and z coordinates, applied loading, and determines the distribution of forces into each bolt based on weighting by the distances from the centroid and bolt diameter. By "3D bolt group" I mean a pattern of bolts existing in 3 dimensions, not just in 2. I know this complicates the calculation because now there are 3 dimensions to consider. And I've seen quite a few spreadsheets that only take into account a 2D bolt group.

I found the following program (http://www.chestnutpens.co.uk/misc/boltgroup.html) that does exactly what I'm trying to do, but I'm having trouble replicating the results in my spreadsheet. I'm able to replicate almost the entire program, up until the last step that adds the forces due to direct loading and rotation. And I'm not sure why I'm getting the results I'm getting. Note: I've created in FEM the bolt group and matched the results of the program.

Has anyone ever tried to create something like this, or can help me understand where I'm going wrong? I know its a complicated method and its difficult to understand without seeing my spreadsheet. Actually, am I able to share my spreadsheet here? I'm not entire sure on all the rules here.


  • $\begingroup$ I would start with 1D then expand with all conditions to 2D and then include all conditions for 3D. Trying to do 3d straight off usually means missing something. $\endgroup$ – Solar Mike Oct 17 '20 at 7:34
  • $\begingroup$ Pretty sure the diagram would just involve coordinates and not bolt sizes. Putting in a bigger bolt doesn't mean it takes up more load. But beyond that, turning each bolt load and moment vector into x,y,z components should do what you want. To be clear, you are starting with 3 force vectors that are balanced, right? $\endgroup$ – Tiger Guy Oct 21 '20 at 2:42
  • $\begingroup$ The distance method is applicable for bot group subjected to in-plan (V & T) loads only, it does not work for out-plan moment, since the bolt is effective in resisting shear and tension, not compression. For example, consider a cantilever beam is connected to the concrete wall through end plate and 4 anchor bolts (one each corner). The beam is subjected to a load P, with a moment arm L, resulting in R = P, M = PL. Assume the bolt spacing are known, can you calculate the forces in the anchor bolts using the method you proposed? How, if you can. Why not, if you can't? $\endgroup$ – r13 Mar 17 at 0:32

After the emergence of software design programs, we all have become too nonchalant about the basics. I take a stab at it here.

Let's annotate the center of the bolt system, C. And call the bolts B_1 through B_n and assume there are differences between the bolt sizes areas hence their strength varies, but they are all set in fully and are not cantilever so they can either have direct compression, tension or shear only.

Then $$C_i=\frac{\Sigma Area B_n*i_n}{\Sigma Area B_n} $$

i is the indices for x,y,z, the distance of the bolt from our reference in respected direction.

If we apply load P at the distance Di from C, and call its projection passing through C, Pc the forces and shear reaction each bolt carry is:

Direct tension or compression loads tributary to each bolt,

$FB_n=Pc*Area B_n / \Sigma Area B_n$

And additional torque shear,

First, we define I of the bolt group as

$ \Sigma Area B_n*(d_in^2) $

$ Shear:\ \tau_i B_n= Pi*Di\frac{Area B_n*di_n}{\Sigma Area B_n*(d_in^2)}$

i is x, y, or z components, and d is the distance of the bolt to the centroid of the bolt group calculated above. I think these are easy to write to an excel sheet.

These algorithms do not apply to bolts applied in a cantilever configuration, More complication arises when dealing with cantilever bolts and their type of connection.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.