Skip to main content
Jan 8, 2015 9:31 PM UTC
Question

3D Bolt Pattern

Does anybody have a 3D bolt pattern analysis already programed in Excel?

 

    14 replies

    Jan 26, 2015 5:18 PM UTC

    Hi Steven,

    have you been able to get a sheet for this purpose from another source or have you been forced to create it on your own?

    Gunter

    Feb 2, 2015 9:26 PM UTC

    Hi Gunter,

    I'm having to create it on my own. We have a 3D bolt analysis spreadsheet tool based upon the equations in Bruhn, but the values won't match the ones attached, not even close.

    Feb 3, 2015 3:49 PM UTC

    Can you tell us a bit more about the spreadsheet that you are trying to recreate? Do you have it? What application do you use it for? Do you know what method it uses? Do you need all its features (such as weighting factors)?

    If I'm being too nosy just tell me

    Feb 3, 2015 4:17 PM UTC

    Patrick,

    The only information I have is from the screenshot that I uploaded. I noticed that when a weighting factor is not used, the reaction point will always be zero (difficult to understand). This spreadsheet was created by a major aerospace company, and we have our own spreadsheet, but our answers are very different. I requested the spreadsheet from the company, but they will not release it.

    The 750-pound load is applied at the shown CG, and all the reactions are computed at the 16 points using "weighting factors".

    The below image is our own version along with the attached instructions.

    bolt_3d_analysis.jpg

    Feb 4, 2015 10:28 AM UTC

    Well for one thing your Z-values are wrong, but that still won't help you with the weighting factors

    According to some MSC documentation I found, the weighting factors work as follows:

    normal:

    Forces derived from force at CG: F_i = Fcg /number_of_points

    Forces derived from moment at CG: F_i = M_cg * distance_i / (distance1^2+distance2^2+distance3^2)

    weighted

    Forces derived from force at CG: F_i = Fcg * weight_i / sum(weights)

    Forces derived from moment at CG: F_i = M_cg * weight_i * distance_i / (weight1*distance1^2+weight2*distance2^2+weight3*distance3^2)

    I'm playing around in excel trying to replicate the numbers from your first picture, but no success so far... I suspect there are still some mistakes in my sheet.

    btw: I have to say I'm having trouble getting my head around how you can have a lateral weighting factor 0 for inboard and outboard points?

    Feb 14, 2017 9:31 PM UTC

    Steven,

    Did you ever get this figured out? I'm fighting a similar battle right now.

    I've found a spreadsheet for download that looks a lot like the one from your screenshot. What I need to do is fully understand what it does so I can write up the calculations for a structural substantiation report. The methodology looks to be similar to Bruhn's but there's got to be more to it, I see product of inertia terms so it must be pretty complicated .

    I'll look into the RBE3 element and see if that explains what the heck is going on in this spreadsheet...