Description

Tolerance Stack-Up Analysis Excel Calculator

File Format: .xlsm

Requires Microsoft Excel 2007 or newer (Windows or Mac). Macros must be enabled.

🔍 Overview

This downloadable Excel tool performs comprehensive tolerance stack-up analysis using multiple methods, automated calculations, and visual feedback.

Explore the online version here: Tolerance Analysis Stack-Up Calculator

📊 Analysis type

• Worst Case
• RSS (Root Sum Square): 3 sigma assumption
• RSS (Root Sum Square) Shifted: 1.5 sigma shift in Mean

📈 Outputs and Calculated Results

• Assembly standard deviation
• Minimum and Maximum assembly limits
• Estimated Scrap Rate
• Cpk (process capability index)

⚙️ Features

• Fully automated via macros and embedded formulas
• Interactive input table with support for dimensional loops
• Dynamic resizing of dependent tables (e.g., for worst-case and RSS)
• Distribution plot automatically generated for visualizing assembly variation