Spreadsheet for the design and verification of a bolted connection using angles on support plate. Angle connected together.

The spreadsheet verifies a bolted connection with angle sections tacking into account the Eurocode 3 norm EN 1993-1-8: 2005. The verification can be used to design wind bracing connections in steel building structures.

Spreadsheet for the design and verification of a bolted connection using angles on supported plate. Angles connected separately on the supported plate.

The spreadsheet verifies a bolted connection with angle sections tacking into account the Eurocode 3 norm EN 1993-1-8: 2005. The verification can be used to design wind bracing connections in steel building structures. 

Simple tool to verify the position of a bolted connection with respect to the adjacent elements, such as fillet welds and H section internal radius.

The spreadsheet allows to calculate the mechanical characteristics of sections used in a lot of engineering problems.
It is possible to calculate the inertia and resistance parameters of the sections and the elastic/plastic characteristics.

Open xls version, not protected.

Spreadsheet for the design and verification of a beam to beam bolted connection with clip angles tacking into account the Eurocode norms.

The spreadsheet verifies a connection composed by plates jointed with pin. It is performed taking into account the Eurocode norm EN 1993-1-8:2005 § 3.13 Tab. 3.10. Different cases are covered by the spreadsheet: Connection composed by 3 plates in a standard pin configuration Connection composed by 2 plates Connection composed by 4 plates equally spaced. Verification of one single plate with pin. It allows to verify the pin connection inserting directly the forces on the pin section (shear and bending).

Package composed by the following products: - Hertz contact of cylinders and spheres - Constrained rectangular plates - Supported rectangular plates - Verification of sections in torsion - Thin wall cylinder in pressure

The spreadsheet allows to verify bolted connection using standard technical literature and Eurocode norms. It gives some tools for a complete design of a bolted joint reported in different woorksheet sections: - Calculus of bolt distances from edges - Verification of the bolted joint at Eurocode EN 1933-8 both in shear and friction modes. It allows to verify up to 6 connected plates providing the results separated tables depending by the joint categories (A, B, C and D) as per EN 1933-8 - Complete dimensioning of bolted connections using standard and Eurocode norms taking into account the stiffness of the connected plates to evaluate the forces distribution between bolts and flanges and tightening torque parameters. Bolts in shear and friction modes with one or two shear sections. It allows also to design the case of bolt in threaded holes. - Calculation of tightening torques and bolts parameters in table format - Listing of the minimum clearances needed for practical screwing operations

The spreadsheet allows to verify a riveted connection using the Eurocode norm EN 1933-8. In particular the following verifications are performed: - One or two shear sections configurations - Verification of distances between rivets and edges - Shear, tension and combined strength verification of the rivet - Bearing verification of the connected plates - Plates tear out verification to design pulling force

The spreadsheet verifies a forged eyebar to pulling force.

The verification is performed considering the reference " Specification for Structural Steel Buildings”, American Institute of Steel Construction, Inc. (AISC) 2005.

Spreadsheet for the design and verification of a beam to beam bolted connection with fin plate, tacking into account the Eurocode norms.

The spreadsheet calculates the forces on the bolts in a bolted connection inserting the coordinates of each bolt composing the joint.

Detailed calculation of the forces due to shear, tension, bending and torque moments.

Useful graphical output for forces.

The spreadsheet reports some verifications of contact Hertz problems in applications with spheres and cylinders. A number of 6 investigated cases are reported. The calculation is done considering the formulas in "Roark's Formulas for Stress and Strain" 7th Ed

Package composed by the following products:

• Design and verification of pin connections as per Eurocode
• Design and verification of lifting lugs and padeyes

The spreadsheet verifies some configurations of lifting lugs and padeyes. Different worksheets are reported for a complete verification of common configurations.

The verification is performed considering the following reference:

"Design and Construction of Lifting Beams"  David T. Ricker, PE, AISC Engineering Journal, Fourth Quarter/1991 and its updating to 2005 AISC Manual of Steel Construction

"Rules for Classification and Construction Industrial Services IV" Germanischer Lloyd Aktiengesellschaft  Edition 2007

Eurocode 3 1993-1-8:2005

Norme Tecniche delle Costruzioni NTC 2008

Package composed by the following products:

• Design and verification of pin connections as per Eurocode
• Design and verification of lifting lugs and padeyes
• Pin-bolt connection to shear (standard)
• Design and verification of Eyebar 

Simple spreadsheet for the verification of the shear connection with pin using standard technical formulation.

Spreadsheet for the verification of contact condition between wheels and rail as per FEM Booklet and DIN norms.

The spreadsheet verifies the retaining rings for a shaft/hole system as per DIN 471 and DIN 472.

It offers a simple design tool for a fast and detailed selection and verification of this type of connections, offering a detailed visualization of the main characteristics of the joint in terms of dimensions, tolerances, strength capacity.

Set composed by the following products:

• Dimensioning of Bolts
• Verification of welding
• Threaded hole verification
• Verification of thread of screw and shaft
• Dimensioning of riveted joint
• Forces on bolted connections

Spreadsheet for the calculation and verification of different mechanical springs types using standard formulas from literature.

The spreadsheet reports some verifications for a thin cylinder in pressure in different load conditions. The aim is to offer a design tool for fast and detailed calculation of this common application. The calculation is done considering the formulas in "Roark's Formulas for Stress and Strain" 7th Ed.

The spreadsheet has the purpose to offer a design tool both for fast and detailed calculation for the verification of general metric threaded holes. It calculates the minimum engaged length of the threaded hole needed to transfer the external loads. Moreover it calculates the minimum length of the threaded hole needed to have the same strength of thebolt foreseen in the connection. A dedicated sheet reports a list of the drilling holes dimensions needed to realized the thread of the hole.

The spreadsheet reports some verifications for a rectangular plate in different boundary conditions and applied loads. A number of 9 investigated cases are reported. The calculation is done considering the formulas in "Roark's Formulas for Stress and Strain" 7th Ed

The spreadsheet reports some verifications for a simply supported rectangular plate in different load conditions. A number of 5 investigated cases are reported. The calculation is done considering the formulas in "Roark's Formulas for Stress and Strain" 7th Ed.

The worksheet reports some verifications for a connection of shaft in hub. Three sections are reported: Max pressing fitting force between shaft and hub It in this section it is calculated the maximum pressing fitting force of the shaft in the hub considering a value for the interference. It is calculated the maximum pressure between the hub and the shaft, the relevant force, the maximum transferring torque moment and the deformation of the elements with the stress status

The spreadsheet is a design tool both for fast and detailed calculation for the verification of general metric thread of a screw application. It allows to specify a specific diameter for the screw, in order to coveralso special cases as for example thread realized on shafts. The following sections are reported in the calculation: Verification under the applied loads Thread stripping strength verification Verification at applied loads as per Eurocode 3 - EN 1993-1-8:2005 Verification during the tightening operation

Verifications of sections in torsion loading. The aim is to offer a design tool both for fast and detailed calculation for common practical mechanical sections. A number of 15 investigated cases are reported. The calculation is done considering the formulas in "Roark's Formulas for Stress and Strain" 7th Ed

Package for welded and bolted connections dimensioning. It is composed by the following products:

- Dimensiong of Bolts

- Verification of welding

- Threaded hole verification

- Verification of thread of screw and shaft

The spreadsheet verifies the welding of a rectangular tube section to a supporting plate or flange tacking into account the Eurocode norms.

The spreadsheet verifies the welding of different fillet welding shapes tacking into account the Eurocode and NTC 2008 norms.

The spreadsheet verifies the welding connection using standard technical literature and Eurocode norms.

The spreadsheet verifies the welding of a H section connected to a supporting plate or flange tacking into account the Eurocode norms.