{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["GAGE R&R"],"not_rendered":{"charts":6,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"GAGE R&R","index":0,"n_rows":60,"n_cols":26,"rows_kept":60,"merged":[[1,3,1,7],[1,11,1,14],[1,22,1,24],[2,3,2,7],[2,11,2,14],[2,22,2,24],[3,3,3,7],[3,11,3,14]],"flags":["formulas_cached_only"]}
[]
[null,null,"CUSTOMER:",{"$nulls":7},"GAGE NAME:",{"$nulls":4},"NOMINAL:",{"$nulls":5},"DATE:"]
[null,null,"PART NO.:",{"$nulls":7},"GAGE NO.:",{"$nulls":5},"TOL(+):",{"$nulls":4},"PERFORMED BY:"]
[null,null,"CHARACTERISTIC:",{"$nulls":7},"GAGE TYPE:",{"$nulls":5},"TOL(-):"]
[]
[]
[null,"APPRAISER A","NAME:"]
[null,null,1,2,3,4,5,6,7,8,9,10,null,"AVERAGE"]
[null,1,{"$nulls":11},"N/A"]
[null,2,{"$nulls":11},"N/A"]
[null,3,{"$nulls":11},"N/A",null,"MEASUREMENT UNIT ANALYSIS"]
[]
[null,"AVERAGE","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","XBARA",null,"N/A"]
[null,"RANGE","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","RBARA",null,"N/A",{"$nulls":6},{"$error":"#DIV/0!"}]
[]
[null,"APPRAISER B","NAME:",{"$nulls":18},{"$error":"#DIV/0!"}]
[null,null,1,2,3,4,5,6,7,8,9,10,null,"AVERAGE"]
[null,1,{"$nulls":11},"N/A",{"$nulls":7},{"$error":"#DIV/0!"}]
[null,2,{"$nulls":11},"N/A"]
[null,3,{"$nulls":11},"N/A",{"$nulls":5},"PART VARIATION (PV):",null,{"$error":"#DIV/0!"}]
[]
[null,"AVERAGE","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","XBARB",null,"N/A",{"$nulls":4},"TOTAL VARIATION (TV):",null,{"$error":"#DIV/0!"}]
[null,"RANGE","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","RBARB",null,"N/A"]
[{"$nulls":20},"    % PROCESS",null,null,"% TOLERANCE"]
[null,"APPRAISER C","NAME:",{"$nulls":17},"VARIATION  (TV)",null,null,"VARIATION  (TOL)"]
[null,null,1,2,3,4,5,6,7,8,9,10,null,"AVERAGE"]
[null,1,{"$nulls":11},"N/A",{"$nulls":5},"% EQUIPMENT VARIATION:",null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,2,{"$nulls":11},"N/A",{"$nulls":5},"% APPRAISER VARIATION:",null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,3,{"$nulls":11},"N/A",{"$nulls":5},"% R & R:",null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
[null,"AVERAGE","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","XBARC",null,"N/A",{"$nulls":4},"% PART VARIATION:",null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,"RANGE","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","RBARC",null,"N/A"]
[]
["REPEATABILITY RANGE CONTROL CHART"]
[]
[null,"XBARp","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",null,"# PARTS",0,{"$nulls":5},"M (FOR EV(K1) = # OF TRIALS)(FOR AV(K2) = # APPR AND G=1)(FOR PV(K3) = # OF PARTS AND G=1)"]
[null,"UCL-R",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"OP1?",0,null,"d2",2,3,4,5,6,"7","8","9",10]
[null,"LCL-R",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"OP2?",0,null,1,{"v":1.41,"d":"1.410"},{"v":1.91,"d":"1.910"},{"v":2.24,"d":"2.240"},{"v":2.48,"d":"2.480"},{"v":2.67,"d":"2.670"},{"v":2.83,"d":"2.830"},{"v":2.96,"d":"2.960"},{"v":3.08,"d":"3.080"},{"v":3.18,"d":"3.180"}]
[null,"RBARBAR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"OP3?",0,null,2,{"v":1.28,"d":"1.280"},{"v":1.81,"d":"1.810"},{"v":2.15,"d":"2.150"},{"v":2.4,"d":"2.400"},{"v":2.6,"d":"2.600"},{"v":2.77,"d":"2.770"},{"v":2.91,"d":"2.910"},{"v":3.02,"d":"3.020"},{"v":3.13,"d":"3.130"}]
[null,"XBARBAR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"# OPER",0,null,3,{"v":1.23,"d":"1.230"},{"v":1.77,"d":"1.770"},{"v":2.12,"d":"2.120"},{"v":2.38,"d":"2.380"},{"v":2.58,"d":"2.580"},{"v":2.75,"d":"2.750"},{"v":2.89,"d":"2.890"},{"v":3.01,"d":"3.010"},{"v":3.11,"d":"3.110"}]
[null,"UCL-XBAR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"# TRIALS (M)",0,null,4,{"v":1.21,"d":"1.210"},{"v":1.75,"d":"1.750"},{"v":2.11,"d":"2.110"},{"v":2.37,"d":"2.370"},{"v":2.57,"d":"2.570"},{"v":2.74,"d":"2.740"},{"v":2.88,"d":"2.880"},{"v":3,"d":"3.000"},{"v":3.1,"d":"3.100"}]
[null,"LCL-XBAR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"(G)",{"v":0,"d":"0.000"},"G",5,{"v":1.19,"d":"1.190"},{"v":1.74,"d":"1.740"},{"v":2.1,"d":"2.100"},{"v":2.36,"d":"2.360"},{"v":2.56,"d":"2.560"},{"v":2.73,"d":"2.730"},{"v":2.87,"d":"2.870"},{"v":2.99,"d":"2.990"},{"v":3.1,"d":"3.100"}]
[{"$nulls":10},"d2A(EV)=",{"v":0,"d":"0.000"},null,"d2(EV)=",{"v":0,"d":"0.000"},null,6,{"v":1.18,"d":"1.180"},{"v":1.73,"d":"1.730"},{"v":2.09,"d":"2.090"},{"v":2.35,"d":"2.350"},{"v":2.56,"d":"2.560"},{"v":2.73,"d":"2.730"},{"v":2.87,"d":"2.870"},{"v":2.99,"d":"2.990"},{"v":3.1,"d":"3.100"}]
[{"$nulls":10},"d2(PV)=",{"v":0,"d":"0.000"},null,"d2(AV)=",{"v":0,"d":"0.000"}]
[]
[]
["PART APPRAISER AVERAGE CHART"]
[{"$nulls":16},7,{"v":1.17,"d":"1.170"},{"v":1.73,"d":"1.730"},{"v":2.09,"d":"2.090"},{"v":2.35,"d":"2.350"},{"v":2.55,"d":"2.550"},{"v":2.72,"d":"2.720"},{"v":2.87,"d":"2.870"},{"v":2.99,"d":"2.990"},{"v":3.1,"d":"3.100"}]
["COUNT","D4","D3","A2","3/d2","SIZE","A2","D3","D4","3/d2","TOLERANCE",{"$nulls":3},"XDiff (Ro):",{"v":0,"d":"0.000"},8,{"v":1.17,"d":"1.170"},{"v":1.72,"d":"1.720"},{"v":2.08,"d":"2.080"},{"v":2.35,"d":"2.350"},{"v":2.55,"d":"2.550"},{"v":2.72,"d":"2.720"},{"v":2.87,"d":"2.870"},{"v":2.98,"d":"2.980"},{"v":3.09,"d":"3.090"}]
[0,0,0,0,0,2,1.88,0,3.268,2.659,0,{"$nulls":3},"Rp:",{"v":0,"d":"0.000"},9,{"v":1.16,"d":"1.160"},{"v":1.72,"d":"1.720"},{"v":2.08,"d":"2.080"},{"v":2.34,"d":"2.340"},{"v":2.55,"d":"2.550"},{"v":2.72,"d":"2.720"},{"v":2.86,"d":"2.860"},{"v":2.98,"d":"2.980"},{"v":3.09,"d":"3.090"}]
[{"$nulls":5},3,1.023,0,2.574,1.772,null,null,0,null,"AV1:",{"$error":"#DIV/0!"},10,{"v":1.16,"d":"1.160"},{"v":1.72,"d":"1.720"},{"v":2.08,"d":"2.080"},{"v":2.34,"d":"2.340"},{"v":2.55,"d":"2.550"},{"v":2.72,"d":"2.720"},{"v":2.86,"d":"2.860"},{"v":2.98,"d":"2.980"},{"v":3.09,"d":"3.090"}]
[{"$nulls":5},4,0.729,0,2.282,1.457,{"$nulls":4},"AV2:",{"$error":"#DIV/0!"},11,{"v":1.16,"d":"1.160"},{"v":1.71,"d":"1.710"},{"v":2.08,"d":"2.080"},{"v":2.34,"d":"2.340"},{"v":2.55,"d":"2.550"},{"v":2.72,"d":"2.720"},{"v":2.86,"d":"2.860"},{"v":2.98,"d":"2.980"},{"v":3.09,"d":"3.090"}]
[{"$nulls":5},5,0.577,0,2.114,1.29,{"$nulls":6},12,{"v":1.15,"d":"1.150"},{"v":1.71,"d":"1.710"},{"v":2.07,"d":"2.070"},{"v":2.34,"d":"2.340"},{"v":2.55,"d":"2.550"},{"v":2.72,"d":"2.720"},{"v":2.85,"d":"2.850"},{"v":2.98,"d":"2.980"},{"v":3.09,"d":"3.090"}]
[{"$nulls":15},"G",13,{"v":1.15,"d":"1.150"},{"v":1.71,"d":"1.710"},{"v":2.07,"d":"2.070"},{"v":2.34,"d":"2.340"},{"v":2.55,"d":"2.550"},{"v":2.71,"d":"2.710"},{"v":2.85,"d":"2.850"},{"v":2.98,"d":"2.980"},{"v":3.09,"d":"3.090"}]
[{"$nulls":16},14,{"v":1.15,"d":"1.150"},{"v":1.71,"d":"1.710"},{"v":2.07,"d":"2.070"},{"v":2.34,"d":"2.340"},{"v":2.54,"d":"2.540"},{"v":2.71,"d":"2.710"},{"v":2.85,"d":"2.850"},{"v":2.98,"d":"2.980"},{"v":3.08,"d":"3.080"}]
[{"$nulls":16},15,{"v":1.15,"d":"1.150"},{"v":1.71,"d":"1.710"},{"v":2.07,"d":"2.070"},{"v":2.34,"d":"2.340"},{"v":2.54,"d":"2.540"},{"v":2.71,"d":"2.710"},{"v":2.85,"d":"2.850"},{"v":2.98,"d":"2.980"},{"v":3.08,"d":"3.080"}]
[{"$nulls":16},">15",1.128,1.693,2.059,2.326,2.534,2.704,2.847,{"v":2.97,"d":"2.970"},3.078]
[]
["All calculations are based upon predicting 5.15 sigma (99% of the area under the normal distribution curve)."]
["AV - If a negative value is calculated under the square root sign, the appraiser variation (AV) defaults to zero (0)."]