{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Process Capability Analysis","Gauge R & R","Machine Capability Analysis"],"not_rendered":{"external_links":1,"defined_names":13},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Process Capability Analysis","index":0,"n_rows":74,"n_cols":11,"rows_kept":74,"flags":["formulas_cached_only"]}
["PART NUMBER",null,"DISCRIPTION",null,"OPERATION",null,null,"MACHINE",null,"DEPARTMENT"]
[]
[]
[null,"UPPER SPEC LIMIT",null,{"v":0.03,"d":"0.0300"},{"$nulls":3},"NOMINAL",null,{"v":0.015,"d":"0.0150"}]
[null,"LOWER SPEC LIMIT",null,{"v":0,"d":"0.0000"},{"$nulls":3},"TOTAL TOLERANCE",null,{"v":0.03,"d":"0.0300"}]
[null," "," "," "," "," "," "," "," "," "," "]
["1",{"v":0.021,"d":"0.0210"},0.0115,0.0202,0.0147,0.0199,0.0146,0.0125,0.0147,0.0212,0.0155]
["2",0.0198,0.0158,0.0204,0.0211,0.0187,0.0168,0.0133,0.0153,0.0198,0.0145]
["3",0.0128,0.0204,0.0122,0.0189,{"v":0.01142,"d":"0.0114"},0.0198,0.0141,0.0185,0.0147,0.0163]
["4",0.0203,0.0184,0.0167,0.0154,0.0208,0.0187,0.0188,0.0203,0.0136,0.0169]
["5",0.0181,0.0199,0.0228,0.0166,0.0125,0.0161,0.0209,0.0201,{"v":0.012,"d":"0.0120"},0.0174]
[null," ",{"$nulls":4}," "]
["SUM",{"v":0.092,"d":"0.0920"},{"v":0.08600000000000001,"d":"0.0860"},{"v":0.09230000000000001,"d":"0.0923"},0.0867,{"v":0.08331999999999999,"d":"0.0833"},{"v":0.086,"d":"0.0860"},0.0796,0.0889,0.0813,{"v":0.08059999999999999,"d":"0.0806"}]
[]
["AVG",0.0184,0.0172,{"v":0.01846,"d":"0.0185"},{"v":0.01734,"d":"0.0173"},{"v":0.016663999999999998,"d":"0.0167"},0.0172,{"v":0.01592,"d":"0.0159"},{"v":0.01778,"d":"0.0178"},{"v":0.01626,"d":"0.0163"},{"v":0.01612,"d":"0.0161"}]
[]
["RANGE",0.0082,{"v":0.008900000000000002,"d":"0.0089"},0.0106,{"v":0.006400000000000001,"d":"0.0064"},{"v":0.00938,"d":"0.0094"},{"v":0.0052000000000000015,"d":"0.0052"},{"v":0.008399999999999998,"d":"0.0084"},{"v":0.005599999999999999,"d":"0.0056"},0.0092,{"v":0.002899999999999998,"d":"0.0029"}]
[{"$nulls":4},10,0.171344,{"$nulls":3},10,0.07478]
[]
[null,"AVERAGE OF AVERAGE",null,null,{"v":0.0171344,"d":"0.0171"},null,"AVERAGE OF RANGE",null,null,{"v":0.007478,"d":"0.0075"}]
[" ",{"$nulls":8},50]
[]
["STANDARD DEVIATION OR SIGMA"]
[]
["STANDARD DEVIATION = (SD) =",{"$nulls":3},"AVERAGE OF RANGES",null,"=",{"v":0.007478,"d":"0.0075"},"=",{"v":0.0032149613069647463,"d":"0.0032"}]
[{"$nulls":4},"CONSTANT",null,null,2.326]
[]
[null,null,"1 SD =",null,null,"3 SD =",null,null,"6 SD ="]
[null,null,{"v":0.0032149613069647463,"d":"0.0032"},null,null,{"v":0.00964488392089424,"d":"0.0096"},null,null,{"v":0.01928976784178848,"d":"0.0193"}]
[]
[null,null,"SUBGROUP SIZE",null,null,"2","3","4","5"]
[null,null,"CONSTANT",null,null,1.128,1.693,2.059,2.326]
[]
[]
["CONTROL LIMIT CALCULATION"]
[]
[null,"RANGE UCL ",null,"=","CONSTANT * AVERAGE OF RANGE",{"$nulls":3},"UCL =",{"v":0.01577858,"d":"0.0158"}]
[]
[null,"RANGE LCL",null,"="," \"NONE\"",{"$nulls":3},"LCL =","NONE"]
[]
[null,"PROCESS AVERAGE UCL",null,"=","NOMINAL + (CONSTANT * AVE OF RANGE)",{"$nulls":3},"UCL =",{"v":0.01933724,"d":"0.0193"}]
[]
[null,"PROCESS AVERAGE LCL ",null,"=","NOMINAL - (CONSTANT * AVE OF RANGE)",{"$nulls":3},"LCL =",{"v":0.01066276,"d":"0.0107"}]
[]
[null,null,"CONSANTS FOR CONTROL LIMITS"]
[null,null,"SUB GROUP",null,"2","3","4","5"]
[null,null,"PROCESS",null,"1.88","1.02","0.73","0.58"]
[null,null,"RANGE",null,"3.27","2.57","2.28","2.11"]
[]
[]
["CAPABILITY (CP)"]
["(CP) indicates the probable overall spread of results"]
[{"$nulls":9},"CP"]
[null,"CAPABILITY","(CP)","=","TOTAL TOLERANCE",null,"=",{"v":0.03,"d":"0.0300"},"=",{"v":1.5552286707675849,"d":"1.56"}]
[{"$nulls":4},"6 SD",null,null,{"v":0.01928976784178848,"d":"0.0193"}]
[]
[]
["CAPABILITY (CPK)"]
["(CPK) is the probable spread of results relative to the setting"]
[]
[null,"USL - AVERAGE OF AVERAGE",null,null,"=",{"v":0.03,"d":"0.0300"},"-",{"v":0.0171344,"d":"0.0171"},1.3339299991084959]
[null," ","3SD",{"$nulls":3},{"v":0.00964488392089424,"d":"0.0096"},null,null,"CPK"]
[{"$nulls":8},"=",{"v":1.3339299991084959,"d":"1.33"}]
[{"$nulls":4}," "," "]
[null,"AVERAGE OF AVERAGE - LSL",null,null,"=",{"v":0.0171344,"d":"0.0171"},"-",{"v":0,"d":"0.0000"},1.7765273424266739]
[null," ","3SD",{"$nulls":3},{"v":0.00964488392089424,"d":"0.0096"}]
[null," ",null,null," "," "]
[]
[]
[]
[]
[null,"SIGNED BY :",{"$nulls":5},"DATE :"]
[]
["Scaroni Consulting",null,"http:/www.scaroniconsulting.it",{"$nulls":3},"info@scaroniconsulting.it"]

{"sheet":"Gauge R & R","index":1,"n_rows":100,"n_cols":14,"rows_kept":100,"flags":["formulas_cached_only"]}
[null,"To complete the gauge R & R  you require three operators. Operator A, B, and C, plus five components. "]
[null,"These components should  vary in size within the tolerance specified on the print."]
[]
[null,"Number the components 1 to 5"]
[]
[null,"Operator A then measures the five components in random order, recording the sizes against "]
[null,"the corresponding identification number on the sheet"]
[]
[null,"Operator B and C also complete the measuring sequence."]
[null," "]
[null,"This task is then performed twice more by each operator using the same 5 components."]
[null," "]
[null,"Note:The operators should not be allowed to see the recordings of the other operators"]
[]
[]
[null,"When the task is completed the information / recordings are then entered onto the computer together"]
[null,"with the tolerance / print size. The computer will then calculate a percentage."]
[]
[null,"Percentage acceptance guideline ",{"$nulls":3},"Less than 10%           excellent"]
[{"$nulls":5},"10% to 30%                capable"]
[{"$nulls":5},"More than 30%         incapable"]
[]
[null,"If the study proves to be incapable i.e. more than 30%, it is possible by looking at the results to"]
[null,"determine whether it is the actual gauge that is incapable or whether an operator is introducing"]
[null,"excessive variation by the way he uses the gauge."]
[]
[]
[]
[]
[{"$nulls":6},"Tolerance"]
[{"$nulls":6},"center","+ / -","width"]
[{"$nulls":6},20,10,20]
[]
[]
[]
[{"$nulls":7}," "]
[null,"Operator:","A",{"$nulls":3},"B",{"$nulls":3},"C"]
[null,"Trials:","1","2","3","Range","1","2","3","Range","1","2","3","Range"]
[null,"Part No:"]
[null," 1",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null," 2",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null," 3",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null," 4",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null," 5",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[null,"Totals:",{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[]
[]
[]
[null,"R(operator) bar:  ",{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Operator Total:  ",{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0]
[null,"X(operator) bar:  ",{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"}]
[]
[]
[]
[null,"R(operator) bar bar:  ",{"$nulls":3},{"v":0,"d":"0.00"},null," = R(ABC) barbar"]
[null,"R(X(operator) bar):  ",{"$nulls":3},{"v":0,"d":"0.00"},null," = R(x bar)"]
[]
[]
[]
[null,"Repeatability = Repeat = R(ABC) barbar * K(1)",{"$nulls":10},"Repeat:  ",{"v":0,"d":"0.00"}]
[null,"(Repeatability = Equipment Variation)"]
[]
[null,null,"number of trials",null,"2","3","4","5"]
[null,null,"K(1)",null,4.56,3.05,{"v":2.5,"d":"2.50"},2.21]
[]
[]
[]
[null,"Reproducibility = Reprod = SQRT [(R(x bar) * K(2))^2 - Repeat^2/((number of parts) * (number of trials))]",{"$nulls":10},"Reprod:  ",{"v":0,"d":"0.00"}]
[null,"(Reproducibility = Operator Variation)",{"$nulls":5},"If (SQRT < 0), Reprod = 0"]
[]
[null,null,"Operator","2","3","4","5","number of parts=",null,5]
[null,null,"K(2)",3.65,{"v":2.7,"d":"2.70"},{"v":2.3,"d":"2.30"},2.08,"number of trials=",null,3]
[]
[]
[]
[null,"Repeatability & Reproducibility (R&R) = SQRT [(Repeat)^2 + (Reprod)^2]",{"$nulls":10},"R&R:  ",{"v":0,"d":"0.00"}]
[]
[]
[]
[null,"% R&R = 100*(R&R/tolerance width)",{"$nulls":10},"% R&R:  ",0]
[]
[]
[]
[]
[{"$nulls":5},"The equipment variation Takes up "]
[]
[{"$nulls":7},0]
[]
[{"$nulls":5},"of the tolerance width"]
[]
[]
[]
[]
[{"$nulls":5},"% R&R Acceptance  ",null,"> 30 %","10 - 30 %","< 10 %"]
[{"$nulls":5},"Guidelines",null,"Insufficient","Acceptable","Excellent"]

{"sheet":"Machine Capability Analysis","index":2,"n_rows":80,"n_cols":7,"rows_kept":80,"flags":["formulas_cached_only"]}
["PART NUMBER","   ","OPERATION",null,null,"MACHINE","DEPARTMENT"]
[]
[]
[null," "]
["NUMBER OF","COMPONENT","SQAURE OF  "]
["READINGS","DIMENSION SIZE","DIMENSION SIZE"]
[]
["1",{"v":10,"d":"10.00000"},{"v":100,"d":"100.00000000"},null," "]
["2",null,{"v":0,"d":"0.00000000"},null," ","TOLERANCES"]
["3",null,{"v":0,"d":"0.00000000"}]
["4",null,{"v":0,"d":"0.00000000"},null," ","USL"]
["5",null,{"v":0,"d":"0.00000000"},null," ","LSL"]
["6",null,{"v":0,"d":"0.00000000"},null," "]
["7",null,{"v":0,"d":"0.00000000"},null," ","NOMINAL",0]
["8",null,{"v":0,"d":"0.00000000"},null," ","TOTAL TOL",{"v":0,"d":"0.0000"}]
["9",null,{"v":0,"d":"0.00000000"}]
["10",null,{"v":0,"d":"0.00000000"}]
["11",null,{"v":0,"d":"0.00000000"}]
["12",null,{"v":0,"d":"0.00000000"},null,null,"CALCULATIONS"]
["13",null,{"v":0,"d":"0.00000000"}]
["14",null,{"v":0,"d":"0.00000000"},null,null,"(X)2",{"v":100,"d":"100.000000"}]
["15",null,{"v":0,"d":"0.00000000"},{"$nulls":3},1]
["16",null,{"v":0,"d":"0.00000000"},null,null,"(X)2/n",100]
["17",null,{"v":0,"d":"0.00000000"}]
["18",null,{"v":0,"d":"0.00000000"}]
["19",null,{"v":0,"d":"0.00000000"}]
["20",null,{"v":0,"d":"0.00000000"},null,null,"STANDARD DEVIATION = SD"]
["21",null,{"v":0,"d":"0.00000000"},{"$nulls":3},0]
["22",null,{"v":0,"d":"0.00000000"},null,null,"1SD",{"$error":"#DIV/0!"}]
["23",null,{"v":0,"d":"0.00000000"}]
["24",null,{"v":0,"d":"0.00000000"},null,null,"3SD",{"$error":"#DIV/0!"}]
["25",null,{"v":0,"d":"0.00000000"}]
["26",null,{"v":0,"d":"0.00000000"},null,null,"6SD",{"$error":"#DIV/0!"}]
["27",null,{"v":0,"d":"0.00000000"},{"$nulls":3}," "]
["28",null,{"v":0,"d":"0.00000000"}]
["29",null,{"v":0,"d":"0.00000000"}]
["30",null,{"v":0,"d":"0.00000000"},null,null,"CAPABILITY (CM)"]
["31",null,{"v":0,"d":"0.00000000"}]
["32",null,{"v":0,"d":"0.00000000"},null,null,"TOTAL TOLERANCE"]
["33",null,{"v":0,"d":"0.00000000"},null,null,"6SD"]
["34",null,{"v":0,"d":"0.00000000"},null,null," ",{"$error":"#DIV/0!"}]
["35",null,{"v":0,"d":"0.00000000"},null,null,"= CM",{"$error":"#DIV/0!"}]
["36",null,{"v":0,"d":"0.00000000"}]
["37",null,{"v":0,"d":"0.00000000"}]
["38",null,{"v":0,"d":"0.00000000"}]
["39",null,{"v":0,"d":"0.00000000"},null,null,"CAPABILITY (CMK)"]
["40",null,{"v":0,"d":"0.00000000"},null,null," "]
["41",null,{"v":0,"d":"0.00000000"},null,null,"USL - X AVERAGE"]
["42",null,{"v":0,"d":"0.00000000"},null,null,"3SD"]
["43",null,{"v":0,"d":"0.00000000"},{"$nulls":3},{"$error":"#DIV/0!"}]
["44",null,{"v":0,"d":"0.00000000"},null,null,"OR"]
["45",null,{"v":0,"d":"0.00000000"}]
["46",null,{"v":0,"d":"0.00000000"},null,null,"X AVERAGE - LSL"]
["47",null,{"v":0,"d":"0.00000000"},null,null,"3SD"]
["48",null,{"v":0,"d":"0.00000000"},null,null," ",{"$error":"#DIV/0!"}]
["49",null,{"v":0,"d":"0.00000000"},null,null,"= CMK",{"$error":"#DIV/0!"}]
["50",null,{"v":0,"d":"0.00000000"}]
[]
[]
[]
[]
[{"$nulls":5},"MAX VALUE",10]
[]
[{"$nulls":5},"MIN VALUE",10]
[]
[]
[]
[]
["X SUM",{"v":10,"d":"10.000000"},{"v":100,"d":"100.000000"},null," "]
["X AVERAGE",{"v":10,"d":"10.000000"},{"$nulls":3},"Date:"]
["RANGE",{"v":0,"d":"0.000000"}]
[]
[]
["Scaroni Consulting",null,"http:/www.scaroniconsulting.it",null,null,"Signed:"]
["NOTE: DO NOT USE SPACE BAR TO DELETE DATA FROM"]
["COMPONENT DIMENSION SIZE CELLS (ERROR WILL OCCUR)"]
["TO CHECK:THE NUMBER OF SAMPLES YOU HAVE: "]
["                ENETERED IN THIS ANALYSIS IS",null,null,1]
["IF THIS IS NOT CORRECT ENSURE ALL BLANK CELLS ARE "]
["CLEARED BY HIGHLIGHTING THEM AND USING DELETE KEY."]