Connecting Rod Bolts Calculation with VDI 2230 standards



I have calculated the Connecting rod bolt analysis with VDI 2230 standards.I still think I have made so many mistakes.Please help me update this.I will add graphical results later.

Sheet Name
List of sheets
list of all the variables
Table 1
Table 2
Table 3
Table 4
Table 5
Table 6
Table 7
Table A1
Table A2
Table A3
Table A4
Table A5
Table A6
Table A7
Table A8
Table A9
Table A10
Table A11
Table A12
Drop down data
Connecting rod inputs
General inputs
Advanced inputs

General Inputs
Max Inertia force + bearing load on each bolt [N] =
Application of the load   =
Type of clamping  =
Type of bolted joint  =
Type of tightening method =
Type of bolt  =
Type of bolt thread =

n,Bolt size and Validation check
The final load introduction factor given by linear interpolation =
Joint type =
Selected bolt size 
Selected bolt strength
Validation check in case of eccentric clamping or loading

Min clamp load
Total Minimum clamp load required [N] =

Resilience,Load factor
Total axial resilience of bolt is given as (mm/N) =
Total Bending resilience of bolt is given as (mm^-1*N^-1)
Total resilience of the plate in case of concentric clamping(mm/N) =
Axial load factor of bolt
Bending load factor of bolt in case of pure bending moment (MB)
Extra  load applied on BOLT due to external load application on bolted joint  (N)  =
Extra  load applied on JOINT due to external load application on bolted joint (N) =

Preload Losses
 The material of clamped part  =
The total amount of embedding for entire bolted joint [in μm] =
Resultant loss in preload due to embedding effects [in N] =
Change in preload due to temperature effect [N]  =

Min and Max Preload
Minimum assembly preload that need to be given to bolted joint =
Maximum assembly preload that is acheived w.r.t tightening in bolted joint  =

Assembly stresses
Utilization factor of yield point stress during tightening =
Allowable maximum stress for selected bolt is[Mpa]=
Permissible assembly preload to be applied for selected bolt is [N] =
Is the bolted joint sufficient for preload to be applied =

Working stresses,Yield point FOS
Comparative stresses in working state[MPa] = 
So did the joint preload is sufficient to maintain mimum required clamp load even in exceeded scenario of yield point of bolt =
Safety margin against exceeding Yield point =

Alternating stresses,Fatigue FOS
 The bolts are 
Endurance limit [Mpa] 
Continous alternating stress acting on the bolt [MPa] =
Safety margin against fatigue failure [Sd] =

Surface pressure and FOS
Actual surface pressure (pgmax) [Mpa or N/mm^2] =
Limiting surface pressure that can be given to the clamped parts [Mpa or N/mm^2] =
Safety margin against surface pressure [Sp] =

Min length of thread engagement
Which thread is critical 
Minimum length of engagement that should be present between bolt and nut(or internal threaded component) [mm]  =

Residual Clamp load,FOS slipping and shearing
Minimum residual clamp load in the bolted joint [N] =
Safety margin against slipping [Sg] = 
Safety margin against shearing of bolt [Sa] =

Tightening Torque
 Tightening torque that  can be given to the bolted joint [Nm] =

Calculation Reference
Bolted Joint Analysis
VDI 2230
Structural Assessment of Bolted Joints

Calculation Preview

Submitted On:
30 Dec 2015
File Size:
1,744.23 Kb
File Version:
File Author:
krishna praveen

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.
Comments: 3
JohnDoyle[Admin] 7 years ago
krishna_praveen I have uploaded an unprotected version of the file so that a password is not required. This makes it simpler for users.
krishna_praveen 7 years ago
Password for unlocking anysheet is "cre123" without the quotes.I have locked them so that user might not accidentally clear any formula.
JohnDoyle[Admin] 7 years ago
A very extensive calculation. I have awarded a free 6 month XLC Pro subscription by way of thanks. I appreciate the note that the calculation requires verification and I will do my best to chip in with comments. In any event the spreadsheet contains some very useful bolt data.