Both 5.15 and 6.0 are commonly used and so both are displayed. You can do Gage R&R in Excel just fine. The Variance, Standard Deviation and Percent of Variance for each variation component are displayed. White cells are for data entry, yellow cells provide instruction, turquoise cells are headings and light green cells display data that can't / shouldn't be changed. Gauge Chart in Excel. This template is part of QI Macros SPC Software for Excel. The spreadsheet will count the number of parts and appraisers automatically. The Percent of Tolerance is calculated using 5.15 standard deviations (99% of the variation) and 6.0 standard deviations (99.7% of the variation.) You can think of this as speed values on a speedometer. Gauge Chart Excel Prep. The math is shown below: Hole Size =.250 +.004" Product Tolerance = .004".004 x 10% = .0004".0004 X .5 = .0002".0002" = Class ZZ Tolerance per ASME B89.1.5 (See Tolerance Chart Below) GO Plug Gage = .250 +.0002" (Suggested) NO-GO Plug Gage = .254 -.0002" (Suggested) You take a sample from your process and measure it. Click Create Custom Combo Chart. Awesome Free Excel Gauge chart Tool – 3 easy steps! However, this … Shaft (external) tolerances are lower case and Hole (Internal) deviation are upper case. At the factory when the inspector checked the caliper on a standard for a 6” nominal dimension, the gage could have displayed 5.999”, 6.000”or 6.001” and it would have passed inspection. Engineering Calculators Say operators are checking a shaft diameter on the computer numerical control (CNC) lathe after the manufacturing process is complete. 3) The Graphical Summary provides a full graphical analysis of the data. Cheers, Chris What do you do? This Microsoft Excel tutorial provides formulas to both deviation (actual−expected) and within tolerance percent.If deviation is not calculated on your sheet, see How to Find Within Tolerance for Percents for the correct formula. 1) Generally the coloring of the cells indicate their use. 1. There are two calculation options available, general engineering use or custom use. (.005+.20)In this same way, I substract the enetered MIN. The new K factors are just the old factors divided by 5.15 sigma. 4) The Numerical Summary displays the results of all calculations used in the ANOVA and Xbar/Range method of analysis.