Eccentrically Loaded Bolt Group - Instantaneous Centre Method
Description
Eccentrically Loaded Bolt Group: Instantaneous Centre of Rotation Method
This workbook finds the design strength of a bolt group loaded eccentrically in its own plane, using the instantaneous centre of rotation (ultimate strength) method. It handles up to 60 bolts in any pattern and a load at any inclination, and shows whether the connection can carry the factored load.
Method
The strength of a single bolt is the lesser of its shear strength and the bearing strength of the plate, with φ = 0.75. The bolt group is assumed to rotate about an instantaneous centre. Each bolt's deformation is proportional to its distance from that centre, the furthest bolt reaching the limiting deformation of 0.34 in (8.64 mm), and its force follows the load–deformation relation
R = Rult (1 − e−10Δ)0.55, with Δ in inches.
Excel's Solver moves the instantaneous centre until the resultant of the bolt forces has the direction and eccentricity of the applied load. The group strength is then φRn = C · φrn, where C is the bolt group coefficient.
Inputs
- Coordinates xi, yi of each bolt (mm), up to 60 bolts
- Bolt diameter (1/2 in to 1 1/2 in) and bolt grade (A307, A325, A490, rivets), from drop-down lists
- Plate thickness t and tensile strength Fu, bolt spacing s and end distance Lev
- Factored load Pu, its inclination α and its eccentricities ex, ey from the bolt group centroid
Outputs
- Design shear and bearing strength of a single bolt
- Position of the instantaneous centre
- Deformation, force and force components of every bolt
- Group strength φRn, the coefficient C, and an OK / not OK check against Pu
- A chart of the bolts, the load point and the instantaneous centre
Checked
An independent solution of the stored example (nine 7/8 in A325-X bolts at 175 mm × 125 mm, vertical load 10 mm off the centroid) gives the same instantaneous centre (−1,250 mm), the same coefficient C = 8.7006 and the same group strength, φRn = 1,050.6 kN.
Please note
- Solver is required. After changing any input, run Solver (Data › Solver) with the saved model to move the instantaneous centre, and check that the two CONTROL cells at the foot of the calculation read zero. Until then the result belongs to the previous inputs.
- The worksheet is in Spanish.
- Bolt strengths are from the Colombian code NSR-98, Table F.2-8 (AISC LRFD values). NSR-10 has since replaced them; the method is unaffected.
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- A clear top-to-bottom layout with numbered headings: inputs, bolt strength, equilibrium, then the bolt table.
- Every bolt's distance, deformation and force is shown, so the method can be followed.
- The chart of the bolts, the load point and the instantaneous centre is drawn from the inputs.
- Drop-down lists for bolt diameter, grade and direction of rotation.
**Suggestions that would make it even better**
- Say at the top that this is the instantaneous centre of rotation method, and that Solver must be run after every change.
- Add a warning when the Solver control cells (B63, B64) are not zero, so a stale result can't be mistaken for an answer.
- Say how it was validated, for example by comparing with the C coefficients tabulated in the AISC Manual.
- Cite the source of the load–deformation relation R = Rult (1 − e^(−10Δ))^0.55 and of the 0.34 in limit.
- Put units beside the single input cells, and remove the unused cells (C43, B61) and the defined names that link to another workbook.
- Consider updating the bolt strengths to NSR-10, which has replaced NSR-98.
- Try the XLC add-in, which shows each formula as an equation so readers can check it at a glance.
If you send in an updated version that covers these points, it would qualify for our 12-month XLC Pro award.