Mechanical Design Pro Handbook and Engineering Kit
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.
$9.99
- Digital download, delivered on your order page right after payment
- Licence: End User Licence Agreement
- Refunds: refund policy
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 $L_{10}$ and $L_{10h}$ 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.
[!NOTE] 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.