You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

Quick and Dirty Bolt Sizing Calculation.xls
This location is for Registered Users Only.
Perhaps you need to login or register.


The following values are required as inputs to the calculation:
1) BOLT GRADE - Enter the two numbers comprise the bolt grade here and the approximate bolt ultimate strength and yield are calculated. The following grades of bolt can be obtained:
grade 3.6
grade 4.6
grade 4.8
grade 5.6
grade 5.8
grade 6.8
grade 8.8 - typical
grade 9.8
grade 10.9 - for high strength duties
grade 12.9

2) THREAD FACTOR - The Joint factor determines the amount of bolt pretension achieved for a given tightening torque. It depends upon thread geometry and friction conditions (thread and the nut rotating on the clamped plate). Detailed calculations are possible but you can use the following typical values:

  • 0.30 stainless steel bolts
  • 0.20 as received bolt (no surface treatment)
  • 0.16 cadmium plated bolts
  • 0.14 molybdenum-disulphide greased bolts
  • 0.12 PTFE lubricated bolts

Low Joint Factor means:
 • Low bolt friction (thread, head and nut).
 • Higher bolt preload for a given tightening torque.

Ω = T / (P x Φ)

3) STIFFNESS FACTOR - When an external load is applied to a pretensioned joint it increases the bolt tension and reduces the contact force between the clampled plates. The stiffness factor determines what proportion of the applied load on the joint increases bolt tension.

Two stiffness terms are important:
  • Kb - The stiffness of the tensile loadpath through the bolt.
  • Kf - the stiffness of the compressive loadpath through the clamped plates.

The stiffness factor K = Kb/(Kb+Kf).

For a steel bolt clamping steel plates this value is typically 0.24
For a steel bolt clamping Aluminium plates this value is typically 0.41

4) TIGHTENING FACTOR - The tightening factor is the ratio of the minimum preload to maximum preload when a batch of bolts are tested. Bolt pretension varies because of a spread in friction values and precision of tightening method. Some typical values are:
0.481 - Operator "Feel" (accuracy ±35%)
0.600 - Torque Wrench (accuracy ±25%)
0.739 - Angle Torquing or Turn of nut (accuracy ±15%)
0.818 - Load Indicating Washer (accuracy ±10%)
0.905 - Measuring Bolt elongation (accuracy ±5%)
0.980 - Strain Gauges / Ultrasonics (accuracy ±1%)

To assess strength of the bolt a maximum preload is considered but to assess the shear capacity of the joint or the separation load then the minimum preload should be considered.

5) PLATE FRICTION - This is the friction between clamped plates in the bolted joint. Never let a joint slip as this could initiate bolt loosening and loss of joint pretension.

0.15 to 0.25 - Steel On Steel - No treatment
0.18 to 0.30 - Steel On Cast Iron - No treatment
0.12 to 0.18 - Steel On Steel - Machined (Degreased)
0.15 to 0.25 - Steel On Cast Iron - Machined (Degreased)
0.48 to 0.55 - Grit - Sandblasted surfaces

The following values are calculated for M6 to M30 bolt sizes:
6) TIGHTENING TORQUE - The torque applied to the nut of a bolt during assembly of the joint.

Note: Nuts sometime include an anti-loosening feature (nylon inserts or deformable threads). A 'prevailing torque' is required just to rotate the nut on the bolt. The tightening torque equals the total torque applied minus the prevailing torque.

7) MAX BOLT PRELOAD - The bolt preload is the amount of tension that is generated in a bolt when the tightening torque is applied. It equals the contact force between the clamped plates. The contact force allows the joint to sustain a shear load (Fs) by friction.

The maximum pretension set by the calculation procedure so that when the separation load is applied to the joint the stress in the bolt is 95% of yield. This is called 'leak before break' and is good practise for all bolted joints.

8) NOMINAL BOLT SLIP LOAD - This is the nominal slip load shear loads applied to the joint should be below this value.

Note: tensile axial forces (Fa) applied to the joint will reduce the slip load. The lower calculation table considers simulaneous axial (Fa) and shear loads (Fs) on the joint which accounts for this.

9) THE JOINT SEPARATION LOAD - The separation load is the force applied to the joint (Fa) which reduces the contact force between the clamped plates to zero. At this point the joint can sustain no shear load in friction. Never allow joints to separate. Ideally the separation load should always occur just before the bolt yield load.

10) BOLT FATIGUE ENDURANCE LOAD RANGE - Provided the axial force range (ΔFa) applied on the joint is kept below this value. The joint will withstand 2E6 load cycles according to BS7608.

Note: ΔFa =  Famax  - Famin

11) THE BOLT YIELD LOAD - This is the load required to yield the bolt in direct tension. Good bolted joints should never sparate and therefore never yield.

12) THE BOLT SHEAR LOAD - This is the load required to shear through the bolt based on the shear strength of the bolt material. It may only be used to assess an ultimate strength loadcase only. Good bolted joints should carry all shear loads in friction to guard against loosening in service.

For a particular bolt size a joint load diagram is calculated. It requires some additional input:
14) BOLT SIZE - selected from a drop down list.

15) MAX TENSILE LOADCASE - input maximum tension and coincident shear forces applied to the joint for assessment.

16) MAX SHEAR LOADCASE - input maximum shear and coincident tensile forces applied to the joint for assessment.

Demand to capacity ratio's are calculated against:


If further consideration is required then proceed to the detailed bolt calculation.

Submitted By:
John Doyle (JohnDoyle[Admin])
Submitted On:
19 Apr 2017
File Size:
164.50 Kb
File Version:
File Author:
John Doyle
Total Votes:7
Comments: 11
PrasanthG 4 days ago
How to download this file? Please explain the download steps in detail.
akmalcheku 8 days ago
Hi there! I'm wondering how do I download this Excel calculator? Thanks!
richardnath 6 months ago
Not able to download file.?
JohnDoyle[Admin] 8 years ago
I have added a new drop down selector box for Separation Factor. Separation Factor is the ratio of the joint tension required to separate a joint to the tension required to yield the bolt.
Most people prefer working interactively using the chart so I display the bolt chart immediately after the selection boxes.The detailed calculations can still be found below the bolt chart.
JohnDoyle[Admin] 9 years ago
- If you want to raise a question use the 'HELP Forum Link' button above. I'll be happy to address your questions there. What 'weird' thing happens when you change the bolt grade from 8.8?
leandrobruno 9 years ago
Something weird happens when changing bolt grade to other than 8.8
JohnDoyle[Admin] 9 years ago
I have made some improvements to this download. Additional combo selection boxes have been added which helps to speed up the assessment process. Some typographical errors have also been corrected.
suresh_gs 9 years ago
suresh_gs 9 years ago
jigarmistry82 10 years ago
Its amazing file. Its like magic.
jigarmistry82 10 years ago
Its amazing file. Its like magic.

We have 394 guests and 4 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.