Where should we send it?

Mechanical Design Data Handbook: Formulas, Checked Tables and Worked Examples is free. Tell us who you are and the download unlocks right away.

We use your details to send this file and, if you ticked the box, the newsletter. No sharing, no spam. See the privacy policy.

Edition
BundlePersonal licence

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

Mechanical Design Pro Kit cover
Type
Bundle
Format
ZIP archive
Download size
2.4 MB zip
Price
$9.99
License
Personal licence
What's inside

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.

How to use it

Using the bundle

  1. 01

    Unzip

    The handbook, the workbook, the flashcards and the guide.

  2. 02

    Open a tab

    Replace the yellow example values with your own.

  3. 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.

The Pro kit: the handbook cover, the workbook open on its VDI 2230 tab and three flashcardsThe Pro kit: the handbook cover, the workbook open on its VDI 2230 tab and three flashcards

In the zip

  • The handbook, the full 69-page PDF.
  • Mechanical-Design-Workbook.xlsx with 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 L10L_{10} and L10hL_{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 a single-card-flashcards folder 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.

The VDI2230_Axial tab with the inputs of the guideline example B1The VDI2230_Axial tab with the inputs of the guideline example B1

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.

Questions or a design you want reviewed? Get in touch.

Preview

The bundle at a glance

Fastener_Preload: stress area, proof load, preload and torque for an M12 class 8.8 bolt.
VDI2230_Axial with the inputs of the guideline example B1.
VDI2230_Axial results: resilience, load factor, embedding loss and assembly preload.
VDI2230_Transverse for a friction grip joint with the inputs of example B2.
Bearing_Life: L10, L10h and the modified life of ISO 281.
Beam_Cases: deflection, maximum moment and bending stress of six cases.
Fits_ISO286: limits of size, clearance and type of fit.
Spring: rate, spring index, Wahl factor, stress and deflection.
Flashcards for the section properties and for stress.
Flashcards for beam deflection and buckling.
Flashcards for thread area, bolt classes, torque and bearing life.
Pages 1 and 2 of the guide.
Pages 3 and 4 of the guide.

Get the bundle

About 2.4 MB zip.

mechanical-design-pro-handbook-engineering-kit.zip

FAQ

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.

Mechanical DesignVDI 2230Bolted JointsExcel WorkbookFlashcardsEngineering ReferenceBundle

Share this engineering resource

Recommend this handbook to colleagues.