Dimensional inspection report template: Excel and PDF, free blank
What goes in the table
| Column | Meaning |
|---|---|
| No. | The balloon number on the drawing |
| Requirement | The dimension as printed |
| Min and Max | The limits worked out from the tolerance |
| Result | What was measured |
| Verdict | In or out, in words |
| Tooling | The instrument used |
| Notes | A reason for any out-of-tolerance result |
Download
| Template | Excel | |
|---|---|---|
| Form 1-style: part identification sheet | ||
| Form 2-style: materials, processes and tests list | ||
| Form 3-style: characteristic report |
For a filled example, see the worked report.
Common mistakes
- Recording a result without its tooling.
- Mixing units between rows.
Using the template well
Print it on one landscape page for a short part, or use the Excel version for a long one. Fill the Requirement column from the drawing exactly as printed, including the tolerance, so a reader can check the limits against the print. Work out Min and Max once, and then record each result to the same number of decimal places as the tolerance.
A short worked row
Requirement: 20.0 plus or minus 0.2. Min 19.8, Max 20.2. Result 20.1. Verdict: within tolerance. Tooling: caliper. Notes: blank. The same row with a result of 20.3 would carry the verdict out of tolerance by 0.1 and a note saying what was done about it.
When to use something else
If the customer supplies their own report form, use theirs. If your job needs the three-form arrangement, use the Forms 1, 2 and 3 page. If you want the table built from the drawing instead of typed, use the tool.
Mistakes to avoid
- Typing limits by hand and miscalculating them. Let the tool work them out, or check each one.
- Leaving verdicts blank on in-tolerance rows. Blank is ambiguous.
- Recording results to more places than the instrument can resolve.
Worked example from the sample part
The sample drawing's seven characteristics fill the template like this. The limits come from the tolerances as printed, and the results are demonstration values.
| No. | Requirement | Min | Max | Result | Verdict |
|---|---|---|---|---|---|
| 1 | 20.0 ±0.2 | 19.8 | 20.2 | 20.08 | IN TOL |
| 2 | 70.0 ±0.3 | 69.7 | 70.3 | 69.91 | IN TOL |
| 3 | ⌀110.0 ±0.1 | 109.9 | 110.1 | 110.04 | IN TOL |
| 4 | ⌀70.0 +0.03/0 | 70.0 | 70.03 | 70.02 | IN TOL |
| 5 | ⌀30.00 +0.02/0 | 30.00 | 30.02 | 30.01 | IN TOL |
| 6 | 4X ⌀9.0 ±0.1 THRU | 8.9 | 9.1 | 9.05 | IN TOL |
| 7 | ⌀90.0 ±0.1 B.C. | 89.9 | 90.1 | 90.03 | IN TOL |
Row 4, diameter 70.0 with plus 0.03 and nothing below, has limits 70.0 and 70.03 and a demonstration result of 70.02, so it is in tolerance with 0.01 to spare. Row 6, the 4X hole callout, has limits 8.9 to 9.1 and could be split into 6.1 to 6.4 if each hole needs its own result.
Field by field
| Field | How to fill it |
|---|---|
| Part number, revision, date | From the drawing's title block and today's date |
| No. | The balloon number; use sub-numbers for split quantities |
| Requirement | Copy the dimension as printed, including its tolerance and any 4X |
| Min and Max | Work out once: nominal plus the lower tolerance and nominal plus the upper |
| Result | The reading as the instrument gave it, to the same decimals as the tolerance |
| Verdict | In or out, in words, never a colour only |
| Tooling | The instrument and, if your system asks, its identifier |
| Notes | For any out-of-tolerance result, what was found and what happened next |
Choosing between PDF and Excel
Use the PDF for a printed or emailed record and the Excel file when a reviewer will sort, filter or import the rows. Both come from the same table, so they cannot disagree. If you build the report from a drawing in the tool, the Excel export also carries the limits as numbers rather than text.
Mistakes people make
- Writing a verdict before comparing against limits, usually on the last few rows of a long list.
- Recording results to more decimals than the instrument can resolve, which implies a precision that does not exist.
- Mixing inches and millimetres in one table without a note.
- Leaving the revision blank so the report cannot be tied to a drawing issue.
- Is it only for aerospace?
- No. Any shop reporting dimensions to a drawing can use it.
- What is a dimensional inspection report?
- A dimensional inspection report lists the dimensions of a part with their tolerance limits and the measured value for each, with a pass or fail against every one. It is the core of a first article report and of PPAP dimensional results.
- What should a dimensional inspection report include?
- A header that identifies the part, drawing and revision, one numbered row per characteristic with the requirement, limits, result, verdict and tooling, and a note against every out-of-tolerance row. Our template has all of these columns.
- Is there a dimensional inspection report template in Excel?
- Yes. The template on this page downloads as Excel as well as PDF, generated in your browser, and the Excel version keeps the headings in a frozen header row.