Bolt types
size, grade and torque; preload range from αABolts
Loads
z from the lowest interface · moments act anywherePaste straight from Excel, Sheets or a CSV: click a cell and press ⌘V / Ctrl+V. Headers like x, y [mm], Fz (kN), Mz [lbf·ft] or Name are recognised, units are converted, and decimal commas, thousands separators and fractions (1 1/4") are understood. Without headers, the paste fills down from the clicked cell.
Margins per bolt
MS = allowable ÷ (FS × actual) − 1. Zero or more passes. Click a row to inspect.Calculation
Assumptions and sources
Assumptions
- Rigid flange. While the joint stays closed, the axial bolt load varies linearly across the pattern and the plate tilts about the bolt centroid. Prying and flange bending are not modelled.
- With different bolt types, the axial load is shared in proportion to each bolt's local joint stiffness (bolt plus clamped body) about the stiffness-weighted centroid, and shear in proportion to bolt area. Equal bolts give the classic bolt-group result.
- Loads are resolved to the bolt centroid in the lowest interface (z = 0). A moment the pattern cannot react, for example bolts on one line, is reported and ignored.
- Preload scatter is symmetric about the nominal friction case, with FM,max = αA·FM,min. Hex head and nut bear directly on the parts unless hardened washers are selected. Embedding is for machined surfaces, Rz 10–40 µm.
- Not included: thermal load, thread stripping, creep. The limiting surface pressures pG are indicative values.
- There is no plate-size input. The plate is assumed to be at least the minimum size shown, so no free edge narrows a bolt's clamped body. D′A is the distance to the nearest bolt, capped at 3·dW.
- The colour field is the clamp force left at the interface as a share of preload, interpolated linearly between bolts.
Sources
- VDI 2230 Part 1:2015-11. Systematic calculation of highly stressed bolted joints — Joints with one cylindrical bolt. VDI / Beuth. Steps R0–R13, compliances §5.1, embedding §5.4.
- ISO 898-1:2013. Mechanical properties of fasteners made of carbon steel and alloy steel — Part 1. Strengths and stress area As.
- SAE J429. Mechanical and Material Requirements for Externally Threaded Fasteners. Grades 5 and 8.
- ISO 3506-1:2020. Corrosion-resistant stainless steel fasteners — Part 1. A2-70, A4-80.
- ISO 261, ISO 724 and ISO 68-1. ISO general purpose metric screw threads. Coarse and fine series, basic profile, d2, d3.
- ASME B1.1-2019. Unified Inch Screw Threads. UNC and UNF series; As = π/4·(d − 0.9743/n)².
- ISO 4014, ISO 273, ISO 7089, ASME B18.2.1, ASME B18.2.8, ASTM F436. Head bearing diameter dW, clearance holes dh, hardened washers.
- Budynas and Nisbett. Shigley's Mechanical Engineering Design, 11th ed., McGraw-Hill, 2020, ch. 8. Joint stiffness, shear joints with eccentric load.
- Bickford. Introduction to the Design and Behavior of Bolted Joints, 4th ed., CRC Press, 2008. Joint diagrams, separation.
- ECSS-E-HB-32-23A (2010). Threaded fasteners handbook. ESA. Bolt-group loads, margins of safety.
- ISO 16047:2005. Fasteners — Torque/clamp force testing. Friction coefficients μG, μK.
- AISC 360-16. Specification for Structural Steel Buildings. §J3.3 minimum spacing, Table J3.4 / J3.4M minimum edge distance.
- EN 1993-1-8:2005. Eurocode 3 — Design of steel structures — Part 1-8: Design of joints. Table 3.3, minimum end, edge distances and spacing.
For design studies. Check results against the full VDI 2230 procedure before relying on them.