Tolerance analysis template

1D tolerance analysis Excel template with support for multiple dimension types.

Screenshot of tolerance analysis template

While there are many ways to perform 1D tolerance analyses, spreadsheets are one of the most common. This template mimics many of the common features of these simple tools, with the addition of dimension types.

Release Downloads

VersionChangesDownload
v1Initial release.Download
v2Licensed into public domain.Download
v3Updated link to new documentation page.Download
v4Add ABS() to ignore negative symmetric tolerances. Use new drawing for reference assembly.Download

Columns

  • ID: row number
  • Description: more detail about dimension
  • P/N and Revision of part(s)
  • Type: see Types
  • a = 1 for additive or a = -1 for subtractive
  • Nom: nominal
  • T1: see Types
  • T2: see Types
  • Lower: lower service limit
  • Center: middle of dimension range
  • Upper: upper service limit
  • Shift: center shift
  • Tol: effective plus/minus tolerance
  • Tol^2: used for stats
  • %: percentage representation of total tolerance
  • Notes/Source: used to document additional information

Dimension Types

These types use the same NOM, T1, and T2 fields to model several kinds of dimensions.

  • Symmetric: NOM ± T1
  • Deviation: NOM +T1 +T2 (use negatives if necessary)
  • Limits: from T1 to T2
  • Band: NOM ± T1/2
  • Shift: T1 boss/shaft in T1 hole

Example

EXAMPLE ASSEMBLY 1
100087
V4
ANSI A / Letter
PDF
Inputs
d1=bilateral(0.75inch,0.01inch,-0.015inch) = 0.7475 inch ± 0.0125 inch
d2=band(3.25inch,0.005in) = 3.25 inch ± 0.0025 in
d3=shaft_hole(bilateral(0.625in,0in,-0.01inch),dim(0.75in,0.01in)) = 0 in ± 0.0725 in
d4=dim(1.75in,0.015in) = 1.75 in ± 0.015 in
d5=dim(0.75in,0.005in) = 0.75 in ± 0.005 in
d6=limit(0.12in,0.135in) = 0.1275 in ± 0.0075 in
d7=dim(1.25in,0.005in) = 1.25 in ± 0.005 in
Stack
stack=[-d1,d2,d3,-d4,d5,d6,-d7] = [-0.7475 inch ± 0.0125 inch, 3.25 inch ± 0.0025 in, 0 in ± 0.0725 in, -1.75 in ± 0.015 in, 0.75 in ± 0.005 in, 0.1275 in ± 0.0075 in, -1.25 in ± 0.005 in]
Analysis
worst_case(stack) = 0.38 inch ± 0.12 inch
rss(stack) = 0.38 inch ± 0.07583 inch
bender(stack) = 0.38 inch ± 0.1137 inch
monte_carlo(stack,100) = 0.3778 inch ± 0.08327 inch
NO ERRORS
Open

See also

Table of Contents