公差分析表格.xlsVIP

Summary Sheet (3) Summary Sheet (2) Summary Sheet \a \r \s ACD ADD COUNT DATA ECD Print_Area_MI RCD TOTAL DIMENSIONAL MANAGEMENT ANALYSIS SUMMARY Prepared For: Phone: DTS NUMBER: Prepared By: Report Date: REQUIREMENT DESCRIPTION: NOM +/- W/I MEAS. TYPE Subject: # Part/Process Description Tolerance Est 1 2 3 4 5 6 7 8 9 10 11 12 Assumptions: % Out of Spec = Status = Report Number: Revision Level: 3s RSS Variation Result = Nominal Mean Shift = Tol. Source % Contribution Gravity Bias Cells below used to calculate %OOS % In of Spec = Rango ProbFrec LSL USL Mean Mean Shifted Prob FrecShift NormDist Curva Constante Rango Shifted Curva Normal Curva Proporcional MaxLSL MaxUSL MaxMean MeanShift MaxMeanShift +/- 3s Cells bellow used to calculate plot Rigid parts with normally distributed ± 3 sigma tolerances centered nominals. All part features are assumed within spec with a process capability equal to the spec range Contributors are geometrically linear with result, unless noted and calculated trigonometrically. Weld distortion, thermal growth, bending or springback not considered. Results (3s)2 Comments: 4s RSS Variation Result = Limit Stack = Status Key: Input Data in Blue by Edmundo Reyes Vega Dimensional GMM developed on Oct 5, 2004 This spreadsheet with graphical output was 8-950-5662 edmundo.reyesvega@ Rev 002 (OCT04) DATA FOR PLOTTING Upr Lim Lwr Lim Direction Year: Program: Green = 0-5% Red = 5% Yu Jichang 021Yu Jichang 021Year: Program: 3s RSS Variation Result = 4s RSS Variation Result = Green = 0-5% Red = 5% .00 .00 .00 1.34E-04 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1.84E-04 .00 .00 .00 .00 .00 .00 .00 .50 .00 .00 .00 .00 .50 .00 .00 .50 .00 .00 .50 .00 .50 .00 .00 .00 .50 .00 .50 .00 .00 2.51E-04 .00 .00 .00 .00 .00 .00 100.00 .00 .00 100.00 .00 .00 3.40E-04 .00 .00 .00 .00 .00 .00 4.57E-04 .00 .00 .00 .00 .00 .00 6.12E-04 .00 .00 .00 .00 .00 .00 100.00 .00 .00 100.00 .00 .00 8.14E-04 .00 .00