The handbook, the workbook and a deck of flashcards
The full DFMA Design Handbook plus a protected Excel workbook with design for assembly, design for manufacturing and DFMA kept apart (scorers, molded-part checks, cooling and clamp, ISO 20457 note, stack-up, process cost at three volumes, a learning curve and a dashboard), 27 printable flashcards, a guide and a weld calculator. A zip.
dfma-pro-handbook-design-kit.zip


- Type
- Bundle
- Format
- ZIP archive
- Download size
- 3 MB zip
- Price
- $9.99
- License
- Personal licence
What is in the bundle
Design for assembly
A baseline and a redesign scorer with the handbook's own weights, takt time and line balance.
Design for manufacturing
Molded-part ratios, cooling time, clamp force, shrinkage, an ISO 20457 note and a stack-up.
DFMA on one page
Process cost at three volumes, every crossover, a learning curve and baseline against redesign.
Checklists
Pass, Fail or N/A for each rule, by method, with the share passed.
27 printable flashcards
The three questions, the formulas and the process rules, each citing its handbook section.
Weld calculator and a guide
A Python module for fillet welds, a weld checklist, and how to use each tab.
Using the bundle
- 01
Score the baseline
List the parts, answer the three questions, score handling and insertion.
- 02
Check the parts and the process
Test molded-part ratios, cooling, clamp force and the stack-up.
- 03
Judge the redesign
Read the dashboard: efficiency, cost at three volumes and the payback volume.
The kit puts the handbook’s method into tools you can use at the desk and in the design review.
In the zip
- The handbook, the full 68-page PDF.
DFMA-Design-Workbook.xlsxwith thirteen tabs in three groups, kept apart: DFA (design for assembly: a baseline and a redesign scorer, a comparison, takt time and line balance, a checklist), DFM (design for manufacturing: molded-part checks, cooling time and clamp force, moulding shrinkage and the ISO 20457 note, a tolerance stack-up, manufacturing checklists) and DFMA (cost per unit of up to three processes at three volumes and every crossover, a learning curve, a one-page baseline against redesign dashboard, a release checklist).dfma-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 the handbook’s worked examples through each tab: read the guide first (PDF, 7 pages, free).
weld-calculator, a Python module for fillet weld size, filler, arc time and cost, with a weld checklist and a sample file.
How the workbook behaves
Yellow cells are inputs and green cells are formulas. Every tab is protected, so only the yellow cells can be edited. All lengths are in millimetres, and there are no macros. OK is green and OUT is red wherever a result is tested against a limit.
No resin, material or process data is built in: diffusivity, cavity pressure, shrinkage, piece cost and tooling are inputs that you take from your data sheet, your quote or a measurement. The design for assembly scoring uses the handbook’s own weights, not the published Boothroyd and Dewhurst tables.
The workbook and the calculator are aids. Your supplier’s data, the standards that apply to your product and your contract govern.
Related
- Sheet Metal Bend Calculator: bend allowance and flat length for the sheet metal tabs.
- GD&T Handbook: how to tolerance the parts you simplify.
- Bolt and Screw Size Chart: sizes for the fasteners that remain.
The bundle at a glance
Get the bundle
About 3 MB zip.
dfma-pro-handbook-design-kit.zip
Questions, answered
What do I need to open the workbook?
Excel 2010 or later, or LibreOffice. There are no macros.
Why are the sheets protected?
So a formula cannot be overwritten by accident. Only the yellow input cells can be edited. Review, Unprotect Sheet turns protection off; there is no password.
Is a resin or material database built in?
No. Diffusivity, cavity pressure, shrinkage, piece cost and tooling are inputs that you take from your data sheet or your quote.
Do I get the handbook too?
Yes, the full handbook PDF is in the zip.
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.

Mechanical Design Data Handbook: Formulas, Checked Tables and Worked Examples
A 69-page mechanical design data handbook: SI units, sections and beams, stress and fatigue, water, steam, air and R134a tables, pipe flow, ISO fits and tolerance grades, bolts, springs, gears, bearings, heat exchangers, pumps, fillet welds and process capability, with worked examples. PDF.

