The handbook, the workbook and a deck of flashcards
The full Mechanical Design Data Handbook plus a protected Excel workbook (bolted joints to VDI 2230 axial and transverse, fastener preload and torque, bearing life, beam cases, ISO 286 fits and a helical spring), 27 printable flashcards and a guide. Zip.
mechanical-design-pro-handbook-engineering-kit.zip


- Type
- Bundle
- Format
- ZIP archive
- Download size
- 2.4 MB zip
- Price
- $9.99
- License
- Personal licence
What is in the bundle
VDI 2230 bolted joints
Axial and transverse tabs that follow the guideline and agree with the printed results of its examples B1 and B2.
Fastener preload and torque
Stress area, proof load, preload and tightening torque from the thread and the class.
Bearings, beams and springs
Rating life to ISO 281, six beam cases and a helical spring.
ISO 286 fits
Limits, clearances and the type of fit from 3 to 400 mm.
27 flashcards
Print them on A4, two-sided, or use each card as its own PDF.
Protected and checked
Yellow cells are inputs, green cells are formulas, every tab is protected and recalculated in LibreOffice.
Using the bundle
- 01
Unzip
The handbook, the workbook, the flashcards and the guide.
- 02
Open a tab
Replace the yellow example values with your own.
- 03
Check against the standard
Take the guideline and standard values from your own copy.
The full Mechanical Design Data Handbook plus a protected Excel workbook, 27 printable flashcards and a guide. The workbook turns the handbook’s formulas into tabs that you fill in and check against the standard: a bolted joint to VDI 2230, bearing life to ISO 281, beam cases, ISO 286 fits and a helical spring.


In the zip
- The handbook, the full 69-page PDF.
Mechanical-Design-Workbook.xlsxwith seven protected tabs:- Fastener_Preload: thread and ISO 898-1 class give the stress area, proof load, preload and tightening torque.
- VDI2230_Axial: the steps R3 to R10 and R12 of VDI 2230 Part 1 for a concentrically clamped and loaded bolted joint, pre-filled with the guideline’s example B1.
- VDI2230_Transverse: the same procedure for a friction grip joint, pre-filled with the guideline’s example B2.
- Bearing_Life: the rating life and and the modified life of ISO 281:2007.
- Beam_Cases: six beam cases with the deflection, the maximum moment and the bending stress.
- Fits_ISO286: limits of size, clearances and the type of fit for hole and shaft classes from 3 to 400 mm.
- Spring: rate, spring index, Wahl factor, stress and deflection of a helical compression spring.
mechanical-flashcards.pdf, 27 cards for printing on A4, two-sided, and asingle-card-flashcardsfolder with each card as its own PDF (front and back separately).- A guide that walks through the workbook tab by tab: read the guide first (PDF, 5 pages, free).
How the workbook behaves
Yellow cells are inputs, green cells are formulas, and every tab is protected so only the yellow cells change (Review, Unprotect Sheet: there is no password). OK is green and OUT is red wherever a result is tested against a limit. There are no macros, and it runs in Excel 2010 or later and in LibreOffice.
The two VDI 2230 tabs are checked against the results printed for the guideline’s examples B1 and B2 (the examples themselves are not reproduced in the workbook) and agree within the rounding of the printed values. What a standard or a guideline table gives is an input: the tightening factor, the embedding amounts and the permissible assembly preload of VDI 2230 are not printed in the workbook, so take them from your copy of the guideline. The tabs do not cover eccentric loads, several bolts or thermal effects.


Who it is for
Design engineers who size bolted joints, bearings, beams, fits and springs and want a worksheet that shows every step, and anyone who reviews such calculations.
The workbook does not replace the standards and guidelines that apply to your product, the data sheet of a material or a component, or a qualified engineer’s review. Rules of thumb are starting values; worked examples are illustrative unless they are the standard’s own.
Related
- Mechanical Design Data Handbook: the tables and worked examples behind the workbook.
- ISO 286-2 Tolerances Wall Chart: what each size grade allows.
- GD&T Handbook: geometric tolerances in depth.
Questions or a design you want reviewed? Get in touch.
The bundle at a glance
Get the bundle
About 2.4 MB zip.
mechanical-design-pro-handbook-engineering-kit.zip
Questions, answered
How do I get the files?
Buy it once at the price shown. Your download link appears right after checkout and is emailed to you. The link is valid for 24 hours and you can request a new one from your order page.
Does it replace VDI 2230?
No. The tabs follow steps R3 to R10 and R12 of VDI 2230 Part 1 for a concentrically clamped and loaded joint and agree with the printed results of the guideline's examples (the examples themselves are not reproduced). The tightening factor, the embedding amounts and the permissible preload are inputs you take from the guideline, and eccentric loads, several bolts and thermal effects are not covered.
Which spreadsheet programs does it work in?
Excel 2010 or later and LibreOffice. There are no macros. Every tab is protected without a password.
What about gears, hydraulics and pneumatics?
They are not in the kit: they could not be checked against a standard, so they are left out.
Share this engineering resource
Recommend this handbook to colleagues.
Keep Exploring
Related Resources

ASME Y14.5-2018 GD&T Handbook: Feature Control Frames, Datums, and Tolerance Zones
A 92-page handbook for reading, writing and inspecting GD&T callouts to ASME Y14.5-2018, with notes where ISO 1101 differs: feature control frames, datum reference frames, modifiers and bonus tolerance, every control family, worked drawings with CMM inspection, and a practice exam. PDF.

DFMA Design Handbook: Part Count Reduction, Assembly Efficiency, and Process Rules
A 68-page handbook for design for manufacturing and assembly: the three part-count questions, design efficiency, handling and insertion, joining and line balance, process rules for machining, molding, casting, sheet metal, welding, forging, extrusion and printing, tolerance stack-up, process choice by volume, injection mold design in depth and a complete redesign. PDF.

