tolerance stackup template

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.


2/10

TOLERANCE STACK ANALYSIS Sheet 2 o

MONTE

CARLO

MC

________

gd-t.


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:


4/10

COMPONENT

TOLERANCE MONTE

SQUARED CARLO

RSS MC

__________________


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


6/10

FACTORED COMPONENT

TOTAL TOLERANCE MONTE

TOLERANCE SQUARED CARLO

MRSS RSS MC

___________________


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/10

FACTORED COMPONENT

TOTAL TOLERANCE MONTE

TOLERANCE SQUARED CARLO

MRSS RSS MC

___________________


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/


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

tolerance stackup template

Documents