tolerance stackup template
TRANSCRIPT
-
8/12/2019 Tolerance Stackup Template
1/10
TOLERANCE STACK ANALYSIS Sheet 1 oStack Description: ________________________________________ Ref. No. _____
OBJECTIV
Date: _______
MAXIMUM MINIMUM COMPONENT FACTORED COMPONENT
+ MAX + MIN TOLERANCE TOTAL TOLERANCE
- MIN - MAX TOLERANCE SQUARED
SUB TOTALS
ANSWER WORST CASE MRSS RSS
OPTIMIZED?
YES NO
STEP ID DESCRIPTION FROM/TO
______________________________________________
______________________________________________
COMMENTS:
DESIGN GOAL:
Name: __________________________
gd-t.
-
8/12/2019 Tolerance Stackup Template
2/10
TOLERANCE STACK ANALYSIS Sheet 2 o
MONTE
CARLO
MC
________
gd-t.
-
8/12/2019 Tolerance Stackup Template
3/10
Stack Description: ________________________________________ Stack No. _____
OBJECTIV
Date: _______
MAXIMUM MINIMUM COMPONENT FACTORED
+ MAX + MIN TOLERANCE TOTAL
- MIN - MAX TOLERANCE
SUB TOTALS
ANSWER WORST CASE MRSS
OPTIMIZED?
YES NO
STEP ID DESCRIPTION FROM/TO
______________________________________________ Name: _______________
______________________________________________
Paste part sketch or drawing here. Sketch stack path on drawing.
COMMENTS:
DESIGN GOAL:
-
8/12/2019 Tolerance Stackup Template
4/10
COMPONENT
TOLERANCE MONTE
SQUARED CARLO
RSS MC
__________________
-
8/12/2019 Tolerance Stackup Template
5/10
Stack Description: ________________________________________ Ref No. _____
OBJ.: ______________________________________________
______________________________________________ Date: _______
POSITIVE NEGATIVECOMPONEN
NOMINAL NOMINAL TOLERANCE
+ / -
SUB TOTALS
+ tol - tol
OPTIMIZED
?
YES NO
Name: _____________
NOMINAL ANSWER
DESIGN GOAL:
COMMENTS:
STEP ID DESCRIPTION FROM / TO
-
8/12/2019 Tolerance Stackup Template
6/10
FACTORED COMPONENT
TOTAL TOLERANCE MONTE
TOLERANCE SQUARED CARLO
MRSS RSS MC
___________________
-
8/12/2019 Tolerance Stackup Template
7/10
Stack Description: ________________________________________ Ref No. _____
OBJECTIVE: _______________________________________
______________________________________________ Date: _______
POSITIVE NEGATIVECOMPONEN
NOMINAL NOMINAL TOLERANCE
+ / -
SUB TOTALS
+ tol - tol
OPTIMIZED
?
YES NO
DESIGN GOAL:
COMMENTS:
NOMINAL ANSWER
Name: _____________
Paste part sketch or drawing here. Sketch stack path on drawing.
STEP ID DESCRIPTION FROM / TO
-
8/12/2019 Tolerance Stackup Template
8/10
FACTORED COMPONENT
TOTAL TOLERANCE MONTE
TOLERANCE SQUARED CARLO
MRSS RSS MC
___________________
-
8/12/2019 Tolerance Stackup Template
9/10
This spreadsheet was developed by my colleague John Stolter, based on Alex Krulikowski's
calculating stacks, then embellished with columns to help users develop more realistic toler
Spreadsheet distributed with permission of Geometric Learning Systems and Stolter LLC.
There are two templates (see tabs at the bottom of the page): the "Limit Stack Form" is the
"Nom-Plus-Minus Form" is only included because many companies are used to that style of
involved, the Limit form is usually easier.)
The "Factored Total Tolerance" column adds a statistical element to the stack using the
methods known as Modified Root-Sum-Square (MRSS), as proposed by Bender and Gilson
The "Component Tolerance Squared" column finds the pure Root-Sum-Square (RSS) resul
can then be redistributed around the nominal (find the average of the Worst-Case columns
To make use of the Monte Carlo column, you need to have statistical data describing the tol
(Right now the column is just a place holder for you to play with and arrive at a simulated tol
on process capabilities; one algorithm to do this is the NORMINV function in Excel.)
You can use this template in any way you like, but be sure to refer your colleagues
to Geometric Learning Systems for training in GD&T and Tolerance Stacks!www.gdtseminars.com
http://www.gdtseminars.com/http://www.gdtseminars.com/ -
8/12/2019 Tolerance Stackup Template
10/10
method for
nces (MRSS and RSS).
ain one taught in our class. The
performing stacks. (When GD&T is
.
of the stack. Each column's result
nd add/subtract half of the MRSS or RSS).
erance.
erance based