{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Visualization","Values","Graphics","Calculation","Settings","Directories","References"],"not_rendered":{"charts":14,"images":12,"macros":1,"external_links":0,"defined_names":48,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":193,"n_cols":4,"rows_kept":193,"cut":false,"hidden":true,"merged":[[123,1,123,2],[123,3,123,7],[29,3,32,7],[35,3,36,7],[37,3,37,7],[38,3,39,7],[33,3,34,7],[4,2,4,8],[5,1,5,8],[9,3,9,6],[25,3,26,7],[27,3,28,7],[159,1,159,2],[159,3,159,7],[160,1,160,2],[160,3,160,7],[54,2,55,7],[56,2,56,7],[57,2,57,7],[58,2,58,7],[59,2,60,7],[124,1,124,2],[124,3,124,7],[158,1,158,2],[158,3,158,7],[85,2,85,7],[122,1,122,2],[122,3,122,7]]}
[]
[]
[]
[]
[null,"Important:"]
[null,"This file based on an Office 2010 version. For correct visualization and calculation use Office 2010 or higher."]
[]
[null,"Information:"]
[]
[null,null,null,"If a cell is gray, a input is mandatory"]
[]
[]
[]
[]
[null,"1.1 Open register \"Visualization\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Location: ",null,"Enter the location where the capability was done. \nFor Example: Germany; PMDM Villingen"]
[]
[null,"Line:",null,"Enter the line/place where your measurment system is located.\nFor Example: BLDC Line or QCArea"]
[]
[null,"Meas. System-Name:",null,"Enter a clear understandable name for your equipment. The name should correspond with your measurement equipment database.\nFor Example: Height gauge; Precision scale"]
[]
[]
[]
[null,"Meas. System-Nr.",null,"Enter the measurment equipment number where you can find in your measurement equipment database."]
[]
[null,"Resolution:",null,"Enter the Reolution of your System. \nFor Example: 0,001"]
[]
[null,"Master Number:",null,"Enter the number of your Master."]
[null,"Date of Datacollection:",null,"Enter the dates of start and end of your analysis."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"These cells will be filled out by ProFile. Not relevant for suppliers."]
[]
[]
[]
[]
[]
[]
[null,"Feature:","Enter the name of the feature you checked. \nFor Example: Distance between ball bearings"]
[]
[null,"Unit:","Enter the unit which you detect with your measurment system"]
[null,"USL:","Enter Upper Sepcification Limit"]
[null,"LSL:","Enter Lower Specification Limit"]
[null,"KPC:","Here you can enter the critical characteristic name in case the feature you are checking is a special characteristic. The DropDown allows you to chose several options."]
[]
[]
[]
[]
[]
[null,"2.1 Open register \"Values\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Values","Please enter all measured values to the related columns."]
[]
[]
[]
[null,"3.1 Open register \"Visualization\""]
[null,"3.2 Good Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"%RE:",null,"Value is smaller or equal to 5%"]
[null,"ndc:",null,"Values is higher or equal than 5"]
[null,"R&R:",null,"Value is smaller then 10%"]
[]
[null,"3.3 Bad Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"%RE:",null,"Value is smaller or equal to 5%"]
[null,"ndc:",null,"Values is smaller then 5"]
[null,"R&R:",null,"Value is higher than 10%"]
[]
[]
[]
[null,"Open register \"Settings\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hide or Unhide registers to have a more detailed view into background processes."]

{"sheet":"Visualization","index":1,"n_rows":72,"n_cols":23,"rows_kept":72,"cut":false,"hidden":false,"merged":[[64,9,64,13],[16,2,17,4],[63,9,63,11],[57,9,57,11],[54,9,54,11],[55,9,55,11],[56,9,56,11],[54,12,54,13],[55,12,55,13],[20,2,20,4],[57,6,57,8],[54,4,54,5],[56,12,56,13],[54,2,54,3],[55,2,55,3],[56,2,56,3],[56,6,56,8],[11,5,11,11],[19,5,19,7],[19,9,19,11],[19,13,19,14],[50,2,50,5],[18,9,18,11],[18,2,18,4],[19,2,19,4],[11,2,11,4],[12,2,12,4],[12,5,12,11],[21,2,22,5],[20,5,20,6],[53,4,53,5],[53,6,53,8],[11,13,11,14],[11,15,11,16],[54,6,54,8],[55,6,55,8],[18,13,18,14],[53,15,53,16],[16,5,17,14],[12,13,12,14],[18,5,18,7],[12,15,12,16],[16,15,19,17],[13,15,13,16],[7,15,7,16],[9,2,9,4],[9,5,9,11],[8,15,8,16],[10,2,10,4],[10,5,10,11],[9,15,9,16],[7,2,7,4],[7,5,7,11],[8,5,8,11],[7,13,7,14],[8,13,8,14],[8,2,8,4],[9,13,9,14],[10,13,10,14],[10,15,10,16],[1,1,2,14],[71,0,71,18],[4,2,5,5],[65,2,65,3],[64,2,64,3],[64,4,64,5],[55,4,55,5],[64,6,64,8],[60,2,60,3],[60,6,60,8],[60,4,60,5],[56,4,56,5],[57,4,57,5],[57,2,57,3],[59,6,59,7],[56,15,56,16],[64,15,64,16],[54,15,54,16],[60,14,60,15],[55,15,55,16],[62,15,63,16],[60,11,60,13],[24,10,24,12],[25,10,25,12],[27,10,27,12],[28,10,28,12],[29,10,29,12],[30,10,30,12],[31,10,31,12],[32,10,32,12],[33,10,33,12],[34,10,34,12],[26,10,26,11]]}
[]
[null,"   M2_Measurementsystemanalysis"]
[]
[]
[null,null,"Feature Independent"]
[]
[]
[null,null,"Location:",null,null,null,null,null,null,null,null,null,null,"Base ID:"]
[null,null,"Line:",null,null,null,null,null,null,null,null,null,null,"Revision:"]
[null,null,"Meas. System-Name:",null,null,null,null,null,null,null,null,null,null,"Version:"]
[null,null,"Meas. System-No.:",null,null,null,null,null,null,null,null,null,null,"Released by (ID):"]
[null,null,"Resolution:",null,null,null,null,null,null,null,null,null,null,"Released by:"]
[null,null,"Date of Datacollection:",null,null,null,null,null,null,null,null,null,null,"Date of release:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Doc. Status:"]
[]
[]
[null,null,"Feature:",null,null,null,null,null,null,null,null,null,null,null,null,"  Feature \n  Dependent"]
[]
[null,null,"Unit:",null,null,null,null,null,null,"USL:"]
[null,null,"KPC:",null,null,null,null,null,null,"LSL:"]
[null,null,null,null,null,{"$f":"IF(OR(F20<>\"\",G20<>\"\"),\"Feature is special\",\"No KPC feature\")","v":"No KPC feature"}]
[null,null,"Measurement data"]
[]
[null,null,{"$f":"IF(Values!C5=\"\",\"Inspector A\",\"Inspector:\")","v":"Inspector A"},null,{"$f":"IF(Values!C5=\"\",\"\",Values!C5)","v":""},null,{"$f":"IF(Values!E5=\"\",\"Inspector B\",\"Inspector:\")","v":"Inspector B"},null,null,null,null,{"$f":"IF(Values!E5=\"\",\"\",Values!E5)","v":""},null,null,{"$f":"IF(Values!G5=\"\",\"Inspector C\",\"Inspector:\")","v":"Inspector C"},null,{"$f":"IF(Values!G5=\"\",\"\",Values!G5)","v":""}]
[null,null,"Row A (1-10)",null,"Row B (1-10)",null,"Row A (1-10)",null,null,null,"Row B (1-10)",null,null,null,"Row A (1-10)",null,"Row B (1-10)"]
[null,null,{"$f":"IF(Calculation!C14=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C14,FIXED(Calculation!C14,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D14=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D14,FIXED(Calculation!D14,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E14=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E14,FIXED(Calculation!E14,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F14=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F14,FIXED(Calculation!F14,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G14=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G14,FIXED(Calculation!G14,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H14=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H14,FIXED(Calculation!H14,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C15=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C15,FIXED(Calculation!C15,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D15=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D15,FIXED(Calculation!D15,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E15=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E15,FIXED(Calculation!E15,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F15=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F15,FIXED(Calculation!F15,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G15=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G15,FIXED(Calculation!G15,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H15=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H15,FIXED(Calculation!H15,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C16=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C16,FIXED(Calculation!C16,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D16=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D16,FIXED(Calculation!D16,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E16=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E16,FIXED(Calculation!E16,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F16=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F16,FIXED(Calculation!F16,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G16=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G16,FIXED(Calculation!G16,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H16=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H16,FIXED(Calculation!H16,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C17=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C17,FIXED(Calculation!C17,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D17=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D17,FIXED(Calculation!D17,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E17=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E17,FIXED(Calculation!E17,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F17=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F17,FIXED(Calculation!F17,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G17=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G17,FIXED(Calculation!G17,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H17=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H17,FIXED(Calculation!H17,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C18=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C18,FIXED(Calculation!C18,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D18=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D18,FIXED(Calculation!D18,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E18=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E18,FIXED(Calculation!E18,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F18=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F18,FIXED(Calculation!F18,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G18=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G18,FIXED(Calculation!G18,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H18=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H18,FIXED(Calculation!H18,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C19=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C19,FIXED(Calculation!C19,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D19=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D19,FIXED(Calculation!D19,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E19=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E19,FIXED(Calculation!E19,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F19=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F19,FIXED(Calculation!F19,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G19=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G19,FIXED(Calculation!G19,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H19=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H19,FIXED(Calculation!H19,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C20=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C20,FIXED(Calculation!C20,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D20=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D20,FIXED(Calculation!D20,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E20=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E20,FIXED(Calculation!E20,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F20=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F20,FIXED(Calculation!F20,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G20=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G20,FIXED(Calculation!G20,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H20=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H20,FIXED(Calculation!H20,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C21=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C21,FIXED(Calculation!C21,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D21=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D21,FIXED(Calculation!D21,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E21=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E21,FIXED(Calculation!E21,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F21=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F21,FIXED(Calculation!F21,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G21=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G21,FIXED(Calculation!G21,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H21=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H21,FIXED(Calculation!H21,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C22=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C22,FIXED(Calculation!C22,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D22=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D22,FIXED(Calculation!D22,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E22=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E22,FIXED(Calculation!E22,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F22=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F22,FIXED(Calculation!F22,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G22=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G22,FIXED(Calculation!G22,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H22=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H22,FIXED(Calculation!H22,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Calculation!C23=\"\",\"\",IF(Calculation!$X$80=1,Calculation!C23,FIXED(Calculation!C23,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!D23=\"\",\"\",IF(Calculation!$X$80=1,Calculation!D23,FIXED(Calculation!D23,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!E23=\"\",\"\",IF(Calculation!$X$80=1,Calculation!E23,FIXED(Calculation!E23,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!F23=\"\",\"\",IF(Calculation!$X$80=1,Calculation!F23,FIXED(Calculation!F23,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Calculation!G23=\"\",\"\",IF(Calculation!$X$80=1,Calculation!G23,FIXED(Calculation!G23,LEN(Calculation!$X$80)-2,FALSE)))","v":""},null,{"$f":"IF(Calculation!H23=\"\",\"\",IF(Calculation!$X$80=1,Calculation!H23,FIXED(Calculation!H23,LEN(Calculation!$X$80)-2,FALSE)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Characteristics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($T$81=\"No\",#REF!<$L$80),1,\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"Varianz",null,"Sigma",null,null,null,null,null,null,null,null,0.1]
[null,null,"Repeatability",null,{"$f":"IF(J65=Calculation!H5,\"\",Calculation!O30)","v":""},null,{"$f":"IF(E55=\"\",\"\",Calculation!O33)","v":""},null,null,"%EV =",null,null,{"$f":"IF(Calculation!S4=\"ANOVA\",Calculation!S13,Calculation!S44)","v":""},null,{"$f":"IF(P55=\"\",\"\",IF(P55>10,\"VAL\",P55))","v":""},{"$f":"M55","v":""}]
[null,null,"Reproducibility",null,{"$f":"IF(J65=Calculation!H5,\"\",Calculation!N30)","v":""},null,{"$f":"IF(E55=\"\",\"\",Calculation!N33)","v":""},null,null,"%AV =",null,null,{"$f":"IF(Calculation!S4=\"ANOVA\",Calculation!S14,Calculation!S45)","v":""},null,{"$f":"IF(P56=\"\",\"\",IF(P56>10,\"VAL\",P56))","v":""},{"$f":"M56","v":""}]
[null,null,"Interaction",null,{"$f":"IF(J65=Calculation!H5,\"\",Calculation!Q30)","v":""},null,{"$f":"IF(E55=\"\",\"\",Calculation!Q33)","v":""},null,null,"%IA =",null,null,{"$f":"IF(Calculation!S4=\"ARM\",\"\",IF(J65=Calculation!H5,\"\",IF(Calculation!S15=0,\"\",Calculation!S15)))","v":""},null,{"$f":"IF(P57=\"\",\"\",IF(P57>10,\"VAL\",P57))","v":""},{"$f":"M57","v":""}]
[null,null,"Gauge distribution",null,{"$f":"IF(J65=Calculation!H5,\"\",Calculation!S30)","v":""},null,{"$f":"IF(E55=\"\",\"\",Calculation!S33)","v":""}]
[]
[null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,5]
[null,null,{"$f":"IFERROR(\"%RE = \" & ROUND(Result_RE_1184,2),\"%RE\")","v":"%RE"},null,{"$f":"IFERROR(IF(G61=\"\",\"\",IF(G61>5,\"VAL\",G61)),\"\")","v":""},null,{"$f":"ROUND(IF(F12=\"\",\"\",(Calculation!X80/(N19-N20))*100),2)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(Result_ndc_1184=\"\",\"ndc\",\"ndc = \" &Result_ndc_1184)","v":"ndc"},null,null,{"$f":"IF(Q61=\"\",\"\",IF(Q61>=5,\"VAL\",Q61))","v":""},null,{"$f":"Calculation!L36","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!R4 & \" \" & Calculation!S4","v":"Capability acc ANOVA"}]
[null,null,null,null,null,null,0.1,null,null,0.3]
[null,null,{"$f":"IFERROR(\"%R&R = \" & ROUND(Result_RuR_1184,2),\"%R&R\")","v":"%R&R"},null,{"$f":"IF(J65=\"\",\"\",IF(J65>30,\"VAL1\",IF(J65>10,\"VAL2\",J65)))","v":""},null,{"$f":"IF(J65=\"\",\"\",IF(J65>30,\"VAL\",J65))","v":""},null,null,{"$f":"IF(Calculation!S4=\"ANOVA\",Calculation!G5,Calculation!H5)","v":""},null,null,null,null,null,{"$f":"IF(AND(J65=\"\",O61<5),\"NG\",IF(J65=\"\",\"\",IF(AND(O61>=5,J65<=10),\"Approved\",\"NG\")))","v":""}]
[]
[]
[]
[]
[]
[]
["Please enter the collected measured values into the register \"Values\""]

{"sheet":"Values","index":2,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,1,1,2]]}
[null,"Values"]
[]
[]
[]
[null,"Inspector A",null,"Inspector B",null,"Inspector C"]
[null,"Row A (1-10)","Row B (1-10)","Row A (1-10)","Row B (1-10)","Row A (1-10)","Row B (1-10)"]

{"sheet":"Graphics","index":3,"n_rows":145,"n_cols":27,"rows_kept":145,"cut":false,"hidden":false,"merged":[[97,2,97,3],[97,10,97,11],[97,17,97,18],[122,13,122,14],[1,2,2,5],[30,2,31,5],[73,2,73,3],[73,10,73,11],[73,17,73,18],[122,2,122,4]]}
[]
[null,null,"Part Variation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Operator Variation"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"MAX(Calculation!C14,Calculation!E14,Calculation!G14)-MIN(Calculation!C14,Calculation!E14,Calculation!G14)","v":0}]
[]
[]
[null,null,null,{"$f":"MAX(Calculation!C15,Calculation!E15,Calculation!G15)-MIN(Calculation!C15,Calculation!E15,Calculation!G15)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C16,Calculation!E16,Calculation!G16)-MIN(Calculation!C16,Calculation!E16,Calculation!G16)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C17,Calculation!E17,Calculation!G17)-MIN(Calculation!C17,Calculation!E17,Calculation!G17)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C18,Calculation!E18,Calculation!G18)-MIN(Calculation!C18,Calculation!E18,Calculation!G18)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C19,Calculation!E19,Calculation!G19)-MIN(Calculation!C19,Calculation!E19,Calculation!G19)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C20,Calculation!E20,Calculation!G20)-MIN(Calculation!C20,Calculation!E20,Calculation!G20)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C21,Calculation!E21,Calculation!G21)-MIN(Calculation!C21,Calculation!E21,Calculation!G21)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C22,Calculation!E22,Calculation!G22)-MIN(Calculation!C22,Calculation!E22,Calculation!G22)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!C23,Calculation!E23,Calculation!G23)-MIN(Calculation!C23,Calculation!E23,Calculation!G23)","v":0}]
[]
[null,null,null,{"$f":"MAX(Calculation!D14,Calculation!F14,Calculation!H14)-MIN(Calculation!D14,Calculation!F14,Calculation!H14)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D15,Calculation!F15,Calculation!H15)-MIN(Calculation!D15,Calculation!F15,Calculation!H15)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D16,Calculation!F16,Calculation!H16)-MIN(Calculation!D16,Calculation!F16,Calculation!H16)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D17,Calculation!F17,Calculation!H17)-MIN(Calculation!D17,Calculation!F17,Calculation!H17)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D18,Calculation!F18,Calculation!H18)-MIN(Calculation!D18,Calculation!F18,Calculation!H18)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D19,Calculation!F19,Calculation!H19)-MIN(Calculation!D19,Calculation!F19,Calculation!H19)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D20,Calculation!F20,Calculation!H20)-MIN(Calculation!D20,Calculation!F20,Calculation!H20)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D21,Calculation!F21,Calculation!H21)-MIN(Calculation!D21,Calculation!F21,Calculation!H21)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D22,Calculation!F22,Calculation!H22)-MIN(Calculation!D22,Calculation!F22,Calculation!H22)","v":0}]
[null,null,null,{"$f":"MAX(Calculation!D23,Calculation!F23,Calculation!H23)-MIN(Calculation!D23,Calculation!F23,Calculation!H23)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"X-Bar-Chart  j1",null,null,null,null,null,null,null,"X-Bar-Chart  j2",null,null,null,null,null,null,"X-Bar-Chart  j3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"R-Chart  j1",null,null,null,null,null,null,null,"R-Chart  j2",null,null,null,null,null,null,"R-Chart  j3"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x quer quer",{"$f":"IF(Calculation!C14=\"\",\"\",AVERAGE(#REF!))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"F140","v":";;"},null,null,null,null,null,null,null,null,null,null,"               Boxplot"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Title",{"$f":"IF(Visualization!J65=Calculation!H5,Calculation!X121 & \";\" &Calculation!X123 & \";\" & Calculation!X125,Calculation!R13 &\";\"&Calculation!R14&\";\"&Calculation!R15&\";\"&Calculation!R16)","v":";;"}]
[]
[null,null,null,null,null,"%EV",{"$f":"IF(Visualization!J65=Calculation!H5,Calculation!S44,Calculation!S13)","v":""}]
[null,null,null,null,null,"%AV",{"$f":"IF(Visualization!J65=Calculation!H5,Calculation!S45,Calculation!S14)","v":""}]
[null,null,null,null,null,"%AI",{"$f":"IF(Visualization!J65=Calculation!H5,\"\",Calculation!S15)","v":""}]
[null,null,null,null,null,"%R&R",{"$f":"IF(Visualization!J65=Calculation!H5,Calculation!S46,Calculation!S16)","v":""}]

{"sheet":"Calculation","index":4,"n_rows":98,"n_cols":32,"rows_kept":98,"cut":false,"hidden":true,"merged":[[76,21,77,24],[79,21,79,22],[80,21,80,22],[81,21,81,22],[96,1,96,2],[97,1,97,2],[2,17,2,18],[95,8,95,9],[90,13,90,14],[91,13,91,14],[92,13,92,14],[93,13,93,14],[81,13,81,14],[75,2,75,3],[73,1,74,4],[96,8,96,9],[95,1,95,2],[79,13,79,14],[80,13,80,14],[82,13,82,14],[83,13,83,14],[84,13,84,14],[85,13,85,14],[86,13,86,14],[88,13,88,14],[89,13,89,14],[87,1,87,2],[88,1,88,2],[89,1,89,2],[91,1,91,2],[92,1,92,2],[90,7,90,10],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[89,8,89,9],[91,8,91,9],[2,21,3,24],[11,11,12,11],[11,10,12,10],[11,15,12,15],[11,14,12,14],[13,14,14,14],[13,15,14,15],[2,6,2,7],[27,18,28,18],[27,14,28,14],[15,15,16,15],[17,15,18,15],[5,23,6,23],[5,24,6,24],[3,17,4,17],[3,18,4,18],[3,1,3,3],[4,1,4,3],[2,1,2,3],[11,1,12,1],[0,1,1,4],[6,1,7,4],[27,11,28,12],[27,1,28,2],[15,14,16,14],[17,14,18,14],[8,1,9,4],[11,9,12,9],[11,12,12,12],[24,1,25,4],[24,9,25,12],[11,34,11,35],[49,34,49,36],[41,34,41,36],[31,9,31,10],[33,9,33,10],[33,1,33,2],[35,4,35,5],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[27,15,28,15],[27,16,28,16],[27,17,28,17],[11,36,11,37],[37,1,38,4],[42,1,43,1],[42,2,42,3],[42,4,42,5],[42,6,42,7],[39,1,40,4],[39,16,40,18],[120,21,121,21],[122,21,123,21],[124,21,125,21],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[60,10,60,11],[76,1,77,4],[76,7,77,10],[70,13,70,15],[71,13,71,15],[68,4,68,5],[69,4,69,5],[68,10,68,11],[69,10,69,11],[69,8,69,9],[70,7,70,11],[57,2,57,3],[49,13,49,14],[117,17,118,17],[129,1,129,2],[122,18,123,18],[42,12,42,13],[58,13,58,16],[71,1,71,5],[113,1,114,1],[113,2,113,3],[113,4,113,5],[70,1,70,5],[43,10,44,10],[59,10,59,11],[54,1,54,2],[76,13,77,16],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[5,31,6,31],[5,30,6,30],[5,29,6,29],[5,27,6,27],[5,26,6,26],[29,11,29,12],[30,11,30,12],[8,17,9,18],[27,13,28,13],[55,1,56,4],[5,21,6,21],[5,22,6,22],[31,11,31,12],[32,11,32,12],[33,11,33,12],[35,9,35,10],[35,11,35,12],[8,9,9,9],[27,9,28,10],[29,9,29,10],[30,9,30,10],[27,7,28,7],[27,6,28,6],[32,9,32,10],[11,2,11,3],[11,4,11,5],[11,6,11,7],[39,9,40,12],[42,9,42,10],[46,9,47,12],[49,9,49,12],[50,9,50,12],[50,13,50,14],[58,1,58,6],[59,8,59,9],[61,10,61,11],[62,10,62,11],[63,10,63,11],[64,10,64,11],[65,10,65,11],[66,10,66,11],[67,10,67,11],[59,1,59,2],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[71,7,71,11],[58,7,58,12],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[68,8,68,9]]}
[null,"Calculation method"]
[]
[null,"Analysis method",null,null,"Status",null,"%R&R",null,null,null,null,null,null,null,null,null,null,"Choosen method",null,null,null,"ANOVA Value Table"]
[null,"ANOVA (Analysis of variance)",null,null,"Active",null,"ANOVA","ARM",null,null,null,null,null,null,null,null,null,"Capability acc",{"$f":"IF(COUNTIF(E4:E5,\"Inactive\")=2,\"\",IF(OR(E5=\"Inactive\",E4=\"Inactive\"),IF(E4=\"Active\",\"ANOVA\",\"ARM\"),IF(G5>H5,\"ANOVA\",\"ARM\")))","v":"ANOVA"}]
[null,"ARM (Average range method)",null,null,"Inactive",null,{"$f":"IF(S16=\"\",\"\",ROUND(S16,2))","v":""},{"$f":"IF(S46=\"\",\"\",ROUND(S46,2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Values","i","j","r","X-Bar","Inspector (j)","Repeatability","Sigma","Inspector (j)","Repeatability","TOTAL"]
[null,"ANOVA (Analysis of variance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part (i)",null,null,"Part (i)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W8,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W8,$B$14:$H$23,2))","v":""},1,1,1,{"$f":"IF(V8=\"\",\"\",SUMIF($W$8:$W$67,\"=\"&W8,$V$8:$V$67)/($P$14*$P$18))","v":""},{"$f":"IF(V8=\"\",\"\",SUMIF($X$8:$X$67,\"=\"&X8,$V$8:$V$67)/($P$16*$P$18))","v":""},{"$f":"IF(V8=\"\",\"\",SUMIFS($V$8:$V$67,$W$8:$W$67,\"=\"&W8,$X$8:$X$67,\"=\"&X8)/($P$18))","v":""},{"$f":"IF(V8=\"\",\"\",(Z8-$M$14)^2)","v":""},{"$f":"IF(AA8=\"\",\"\",(AA8-$M$14)^2)","v":""},{"$f":"IF(V8=\"\",\"\",(V8-AB8)^2)","v":""},{"$f":"IF(V8=\"\",\"\",(V8-$M$14)^2)","v":""}]
[null,"Values",null,null,null,null,null,null,null,"General",null,null,null,null,null,null,null,"Influences in %",null,null,null,{"$f":"IF(VLOOKUP(W9,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W9,$B$14:$H$23,3))","v":""},1,1,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W10,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W10,$B$14:$H$23,2))","v":""},2,1,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W11,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W11,$B$14:$H$23,3))","v":""},2,1,2,"","","","","","",""]
[null,"i","j = 1 (Inspector A)",null,"j = 2 (Inspector B)",null,"j = 3 (Inspector C)",null,null,"Rang [j1j2j3]","Range [m1]","Range [m2]","X-Bar [j1j2j3]",null,"∆T",{"$f":"X81-X82","v":0},null,"Indice","Value",null,null,{"$f":"IF(VLOOKUP(W12,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W12,$B$14:$H$23,2))","v":""},3,1,1,"","","","","","",""]
[null,null,"m = 1 (Row A)","m =  2 (Row B)","m = 1 (Row A)","m =  2 (Row B)","m = 1 (Row A)","m =  2 (Row B)",null,null,null,null,null,null,null,null,null,"%EV",{"$f":"IF(P12=\"\",\"\",IF(O32=\"\",\"\",(100/P12)*5.15*SQRT(O30)))","v":""},null,null,{"$f":"IF(VLOOKUP(W13,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W13,$B$14:$H$23,3))","v":""},3,1,2,"","","","","","",""]
[null,1,{"$f":"IF(Values!B7=\"\",\"\",Values!B7)","v":""},{"$f":"IF(Values!C7=\"\",\"\",Values!C7)","v":""},{"$f":"IF(Values!D7=\"\",\"\",Values!D7)","v":""},{"$f":"IF(Values!E7=\"\",\"\",Values!E7)","v":""},{"$f":"IF(Values!F7=\"\",\"\",Values!F7)","v":""},{"$f":"IF(Values!G7=\"\",\"\",Values!G7)","v":""},null,{"$f":"IF(C14=\"\",\"\",MAX(C14:H14)-MIN(C14:H14))","v":""},{"$f":"IF(C14=\"\",\"\",MAX(C14,E14,G14)-MIN(G14,E14,C14))","v":""},{"$f":"IF(C14=\"\",\"\",MAX(D14,F14,H14)-MIN(H14,F14,D14))","v":""},{"$f":"IF(C14=\"\",\"\",AVERAGE(C14:H23))","v":""},null,"Inspectors (j)",{"$f":"IF(COUNT(C14,E14,G14)=0,\"\",COUNT(C14,E14,G14))","v":""},null,"%AV",{"$f":"IF(P12=\"\",\"\",IF(N32=\"\",\"\",(100/P12)*5.15*SQRT(N30)))","v":""},null,null,{"$f":"IF(VLOOKUP(W14,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W14,$B$14:$H$23,2))","v":""},4,1,1,"","","","","","",""]
[null,2,{"$f":"IF(Values!B8=\"\",\"\",Values!B8)","v":""},{"$f":"IF(Values!C8=\"\",\"\",Values!C8)","v":""},{"$f":"IF(Values!D8=\"\",\"\",Values!D8)","v":""},{"$f":"IF(Values!E8=\"\",\"\",Values!E8)","v":""},{"$f":"IF(Values!F8=\"\",\"\",Values!F8)","v":""},{"$f":"IF(Values!G8=\"\",\"\",Values!G8)","v":""},null,"","","",{"$f":"IF($M$14=\"\",\"\",$M$14)","v":""},null,null,null,null,"%IA",{"$f":"IF(P12=\"\",\"\",IF(Q32=\"\",\"\",(100/P12)*5.15*SQRT(Q30)))","v":""},null,null,{"$f":"IF(VLOOKUP(W15,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W15,$B$14:$H$23,3))","v":""},4,1,2,"","","","","","",""]
[null,3,{"$f":"IF(Values!B9=\"\",\"\",Values!B9)","v":""},{"$f":"IF(Values!C9=\"\",\"\",Values!C9)","v":""},{"$f":"IF(Values!D9=\"\",\"\",Values!D9)","v":""},{"$f":"IF(Values!E9=\"\",\"\",Values!E9)","v":""},{"$f":"IF(Values!F9=\"\",\"\",Values!F9)","v":""},{"$f":"IF(Values!G9=\"\",\"\",Values!G9)","v":""},null,"","","","",null,"Speciments (i)",{"$f":"IF(COUNT(C14:C23)=0,\"\",COUNT(C14:C23))","v":""},null,"%R&R",{"$f":"IF(P12=\"\",\"\",IF(S32=\"\",\"\",ROUND(((S32/P12)*100),1)))","v":""},null,null,{"$f":"IF(VLOOKUP(W16,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W16,$B$14:$H$23,2))","v":""},5,1,1,"","","","","","",""]
[null,4,{"$f":"IF(Values!B10=\"\",\"\",Values!B10)","v":""},{"$f":"IF(Values!C10=\"\",\"\",Values!C10)","v":""},{"$f":"IF(Values!D10=\"\",\"\",Values!D10)","v":""},{"$f":"IF(Values!E10=\"\",\"\",Values!E10)","v":""},{"$f":"IF(Values!F10=\"\",\"\",Values!F10)","v":""},{"$f":"IF(Values!G10=\"\",\"\",Values!G10)","v":""},null,"","","","",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W17,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W17,$B$14:$H$23,3))","v":""},5,1,2,"","","","","","",""]
[null,5,{"$f":"IF(Values!B11=\"\",\"\",Values!B11)","v":""},{"$f":"IF(Values!C11=\"\",\"\",Values!C11)","v":""},{"$f":"IF(Values!D11=\"\",\"\",Values!D11)","v":""},{"$f":"IF(Values!E11=\"\",\"\",Values!E11)","v":""},{"$f":"IF(Values!F11=\"\",\"\",Values!F11)","v":""},{"$f":"IF(Values!G11=\"\",\"\",Values!G11)","v":""},null,"","","","",null,"Amount of measurements (r)",{"$f":"IF(COUNT(C14:D14)=0,\"\",COUNT(C14:D14))","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(W18,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W18,$B$14:$H$23,2))","v":""},6,1,1,"","","","","","",""]
[null,6,{"$f":"IF(Values!B12=\"\",\"\",Values!B12)","v":""},{"$f":"IF(Values!C12=\"\",\"\",Values!C12)","v":""},{"$f":"IF(Values!D12=\"\",\"\",Values!D12)","v":""},{"$f":"IF(Values!E12=\"\",\"\",Values!E12)","v":""},{"$f":"IF(Values!F12=\"\",\"\",Values!F12)","v":""},{"$f":"IF(Values!G12=\"\",\"\",Values!G12)","v":""},null,"","","","",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W19,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W19,$B$14:$H$23,3))","v":""},6,1,2,"","","","","","",""]
[null,7,{"$f":"IF(Values!B13=\"\",\"\",Values!B13)","v":""},{"$f":"IF(Values!C13=\"\",\"\",Values!C13)","v":""},{"$f":"IF(Values!D13=\"\",\"\",Values!D13)","v":""},{"$f":"IF(Values!E13=\"\",\"\",Values!E13)","v":""},{"$f":"IF(Values!F13=\"\",\"\",Values!F13)","v":""},{"$f":"IF(Values!G13=\"\",\"\",Values!G13)","v":""},null,"","","","",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W20,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W20,$B$14:$H$23,2))","v":""},7,1,1,"","","","","","",""]
[null,8,{"$f":"IF(Values!B14=\"\",\"\",Values!B14)","v":""},{"$f":"IF(Values!C14=\"\",\"\",Values!C14)","v":""},{"$f":"IF(Values!D14=\"\",\"\",Values!D14)","v":""},{"$f":"IF(Values!E14=\"\",\"\",Values!E14)","v":""},{"$f":"IF(Values!F14=\"\",\"\",Values!F14)","v":""},{"$f":"IF(Values!G14=\"\",\"\",Values!G14)","v":""},null,"","","","",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W21,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W21,$B$14:$H$23,3))","v":""},7,1,2,"","","","","","",""]
[null,9,{"$f":"IF(Values!B15=\"\",\"\",Values!B15)","v":""},{"$f":"IF(Values!C15=\"\",\"\",Values!C15)","v":""},{"$f":"IF(Values!D15=\"\",\"\",Values!D15)","v":""},{"$f":"IF(Values!E15=\"\",\"\",Values!E15)","v":""},{"$f":"IF(Values!F15=\"\",\"\",Values!F15)","v":""},{"$f":"IF(Values!G15=\"\",\"\",Values!G15)","v":""},null,"","","","",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W22,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W22,$B$14:$H$23,2))","v":""},8,1,1,"","","","","","",""]
[null,10,{"$f":"IF(Values!B16=\"\",\"\",Values!B16)","v":""},{"$f":"IF(Values!C16=\"\",\"\",Values!C16)","v":""},{"$f":"IF(Values!D16=\"\",\"\",Values!D16)","v":""},{"$f":"IF(Values!E16=\"\",\"\",Values!E16)","v":""},{"$f":"IF(Values!F16=\"\",\"\",Values!F16)","v":""},{"$f":"IF(Values!G16=\"\",\"\",Values!G16)","v":""},null,"","","","",null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W23,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W23,$B$14:$H$23,3))","v":""},8,1,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W24,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W24,$B$14:$H$23,2))","v":""},9,1,1,"","","","","","",""]
[null,"Hypotheses test",null,null,null,null,null,null,null,"ANOVA Table",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W25,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W25,$B$14:$H$23,3))","v":""},9,1,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W26,$B$14:$H$23,2)=\"\",\"\",VLOOKUP(W26,$B$14:$H$23,2))","v":""},10,1,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W27,$B$14:$H$23,3)=\"\",\"\",VLOOKUP(W27,$B$14:$H$23,3))","v":""},10,1,2,"","","","","","",""]
[null,"Amount",null,"i","j","r","TOTAL","i *  j",null,"Indices",null,"VT",null,"VP","VE","TOTAL Variation","IA","Reproducibility","R&R",null,null,{"$f":"IF(VLOOKUP(W28,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W28,$B$14:$H$23,4))","v":""},1,2,1,"","","","","","",""]
[null,null,null,{"$f":"P16","v":""},{"$f":"P14","v":""},{"$f":"P18","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W29,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W29,$B$14:$H$23,5))","v":""},1,2,2,"","","","","","",""]
[null,"Sum of Squares",null,{"$f":"IF(SUM(AC8:AC67)=0,\"\",SUM(AC8:AC67))","v":""},{"$f":"IF(SUM(AD8:AD67)=0,\"\",SUM(AD8:AD67))","v":""},{"$f":"IF(SUM(AE8:AE67)=0,\"\",SUM(AE8:AE67))","v":""},{"$f":"IF(SUM(AF8:AF67)=0,\"\",SUM(AF8:AF67))","v":""},{"$f":"IF(SUM(D30:G30)=0,\"\",G30-F30-E30-D30)","v":""},null,"Variance",null,{"$f":"IF(D32=\"\",\"\",MAX(0,,(D32-H32)/(E29*F29)))","v":""},null,{"$f":"IF(E32=\"\",\"\",MAX(0,(E32-H32)/(D29*F29)))","v":""},{"$f":"IF(F32=\"\",\"\",MAX(0,,F32))","v":""},{"$f":"IF(L30=\"\",\"\",S30+L30)","v":""},{"$f":"IF(F32=\"\",\"\",MAX(0,(H32-F32)/F29))","v":""},{"$f":"IF(N30=\"\",\"\",N30+Q30)","v":""},{"$f":"IF(O30=\"\",\"\",R30+O30)","v":""},null,null,{"$f":"IF(VLOOKUP(W30,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W30,$B$14:$H$23,4))","v":""},2,2,1,"","","","","","",""]
[null,"Degrees of Freedom",null,{"$f":"IF(D29=\"\",\"\",D29-1)","v":""},{"$f":"IF(E29=\"\",\"\",E29-1)","v":""},{"$f":"IF(F30=\"\",\"\",(D29*E29*(F29-1)))","v":""},{"$f":"IF(G30=\"\",\"\",(D29*E29*F29)-1)","v":""},{"$f":"IF(D31=\"\",\"\",D31*E31)","v":""},null,"%Contribution",null,{"$f":"IF(L30=\"\",\"\",L30/($S$30+$L$30))","v":""},null,{"$f":"IF(N30=\"\",\"\",N30/($S$30+$L$30))","v":""},"","","","","",null,null,{"$f":"IF(VLOOKUP(W31,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W31,$B$14:$H$23,5))","v":""},2,2,2,"","","","","","",""]
[null,"Mean Squares",null,{"$f":"IF(D30=\"\",\"\",D30/D31)","v":""},{"$f":"IF(E30=\"\",\"\",E30/E31)","v":""},{"$f":"IF(F30=\"\",\"\",IF(F31=0,0,F30/F31))","v":""},null,{"$f":"IF(F32=\"\",\"\",IF(F32=0,0,H30/H31))","v":""},null,"Sigma (5,15)",null,{"$f":"IF(L30=\"\",\"\",SQRT(L30))","v":""},null,{"$f":"IF(N30=\"\",\"\",5.15*SQRT(N30))","v":""},{"$f":"IF(O30=\"\",\"\",5.15*SQRT(O30))","v":""},{"$f":"IF(P30=\"\",\"\",SQRT(P30))","v":""},{"$f":"IF(Q30=\"\",\"\",5.15*SQRT(Q30))","v":""},{"$f":"IF(R30=\"\",\"\",SQRT(R30))","v":""},{"$f":"IF(N32=\"\",\"\",IF(H34>G36,SQRT(O32^2+N32^2),SQRT(O32^2+N32^2+Q32^2)))","v":""},null,null,{"$f":"IF(VLOOKUP(W32,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W32,$B$14:$H$23,4))","v":""},3,2,1,"","","","","","",""]
[null,"F",null,{"$f":"IF(D29=\"\",\"\",IF(H32=0,0,D32/H32))","v":""},{"$f":"IF(E32=\"\",\"\",IF(H32=0,0,E32/H32))","v":""},null,null,{"$f":"IF(F32=\"\",\"\",IF(H32=0,0,H32/F32))","v":""},null,"Sigma",null,{"$f":"L32","v":""},null,{"$f":"IF(N30=\"\",\"\",SQRT(N30))","v":""},{"$f":"IF(O30=\"\",\"\",SQRT(O30))","v":""},{"$f":"IF(P30=\"\",\"\",SQRT(P30))","v":""},{"$f":"IF(Q30=\"\",\"\",SQRT(Q30))","v":""},{"$f":"IF(R30=\"\",\"\",SQRT(R30))","v":""},{"$f":"IF(N33=\"\",\"\",IF(H34>G36,SQRT(O33^2+N33^2),SQRT(O33^2+N33^2+Q33^2)))","v":""},null,null,{"$f":"IF(VLOOKUP(W33,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W33,$B$14:$H$23,5))","v":""},3,2,2,"","","","","","",""]
[null,"P-Value",null,{"$f":"IF(D29=\"\",\"\",IF(D33<=0,0,1-_xlfn.F.DIST(D33,D31,H31,TRUE)))","v":""},{"$f":"IF(E31=\"\",\"\",IF(E33<=0,0,1-_xlfn.F.DIST(E33,E31,H31,TRUE)))","v":""},null,null,{"$f":"IF(F31=\"\",\"\",IF(H33<=0,0,1-_xlfn.F.DIST(H33,H31,F31,TRUE)))","v":""},null,"%Study Varriation",null,{"$f":"IF(L32=\"\",\"\",L32/$P$32)","v":""},null,{"$f":"IF(N32=\"\",\"\",N32/$P$32)","v":""},{"$f":"IF(O32=\"\",\"\",O32/$P$32)","v":""},{"$f":"IF(P32=\"\",\"\",P32/$P$32)","v":""},null,null,null,null,null,{"$f":"IF(VLOOKUP(W34,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W34,$B$14:$H$23,4))","v":""},4,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W35,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W35,$B$14:$H$23,5))","v":""},4,2,2,"","","","","","",""]
[null,null,null,null,"Alpha to test interaction:",null,0.05,{"$f":"IF(H34=\"\",\"\",IF(H34>G36,\"H0 is false\",\"H0 is true\"))","v":""},null,"No. of Distinct Categories",null,{"$f":"IF(N30=\"\",\"\",ROUND(1.41*(P33/S33),0))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W36,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W36,$B$14:$H$23,4))","v":""},5,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W37,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W37,$B$14:$H$23,5))","v":""},5,2,2,"","","","","","",""]
[null,"ARM (Average Range Method)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W38,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W38,$B$14:$H$23,4))","v":""},6,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W39,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W39,$B$14:$H$23,5))","v":""},6,2,2,"","","","","","",""]
[null,"Values",null,null,null,null,null,null,null,"K-Factors",null,null,null,null,null,null,"Influences in %",null,null,null,null,{"$f":"IF(VLOOKUP(W40,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W40,$B$14:$H$23,4))","v":""},7,2,1,{"$f":"IF(V40=\"\",\"\",SUMIF($W$8:$W$67,\"=\"&W40,$V$8:$V$67)/($P$14*$P$18))","v":""},{"$f":"IF(V40=\"\",\"\",SUMIF($X$8:$X$67,\"=\"&X40,$V$8:$V$67)/($P$16*$P$18))","v":""},{"$f":"IF(V40=\"\",\"\",SUMIFS($V$8:$V$67,$W$8:$W$67,\"=\"&W40,$X$8:$X$67,\"=\"&X40)/($P$18))","v":""},{"$f":"IF(V40=\"\",\"\",(Z40-$M$14)^2)","v":""},{"$f":"IF(AA40=\"\",\"\",(AA40-$M$14)^2)","v":""},{"$f":"IF(V40=\"\",\"\",(V40-AB40)^2)","v":""},{"$f":"IF(V40=\"\",\"\",(V40-$M$14)^2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W41,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W41,$B$14:$H$23,5))","v":""},7,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W42,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W42,$B$14:$H$23,4))","v":""},8,2,1,"","","","","","",""]
[null,"i","j = 1 (Inspector A)",null,"j = 2 (Inspector B)",null,"j = 3 (Inspector C)",null,null,"K1",null,null,"K2 ",null,null,null,"Indice","Value","Value %",null,null,{"$f":"IF(VLOOKUP(W43,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W43,$B$14:$H$23,5))","v":""},8,2,2,"","","","","","",""]
[null,null,"m = 1 (Row A)","m =  2 (Row B)","m = 1 (Row A)","m =  2 (Row B)","m = 1 (Row A)","m =  2 (Row B)",null,"2 Inspectors",4.5670000000000002,null,"2 Inspectors",3.6539007092198501,null,null,"%EV",{"$f":"IF(D70=\"\",\"\",N51*K44)","v":""},{"$f":"IF(D70=\"\",\"\",(R44*100)/P12)","v":""},null,null,{"$f":"IF(VLOOKUP(W44,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W44,$B$14:$H$23,4))","v":""},9,2,1,"","","","","","",""]
[null,1,{"$f":"IF(Values!B7=\"\",\"\",Values!B7)","v":""},{"$f":"IF(Values!C7=\"\",\"\",Values!C7)","v":""},{"$f":"IF(Values!D7=\"\",\"\",Values!D7)","v":""},{"$f":"IF(Values!E7=\"\",\"\",Values!E7)","v":""},{"$f":"IF(Values!F7=\"\",\"\",Values!F7)","v":""},{"$f":"IF(Values!G7=\"\",\"\",Values!G7)","v":""},null,"3 Inspectors",null,null,"3 Inspectors",2.6973821989528801,null,null,"%AV",{"$f":"IF(D70=\"\",\"\",IF(G14=\"\",N50*N44,N50*N45))","v":""},{"$f":"IF(D70=\"\",\"\",(R45*100)/P12)","v":""},null,null,{"$f":"IF(VLOOKUP(W45,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W45,$B$14:$H$23,5))","v":""},9,2,2,"","","","","","",""]
[null,2,{"$f":"IF(Values!B8=\"\",\"\",Values!B8)","v":""},{"$f":"IF(Values!C8=\"\",\"\",Values!C8)","v":""},{"$f":"IF(Values!D8=\"\",\"\",Values!D8)","v":""},{"$f":"IF(Values!E8=\"\",\"\",Values!E8)","v":""},{"$f":"IF(Values!F8=\"\",\"\",Values!F8)","v":""},{"$f":"IF(Values!G8=\"\",\"\",Values!G8)","v":""},null,null,null,null,null,null,null,null,"%R&R",{"$f":"IF(D70=\"\",\"\",SQRT(R44^2+R45^2))","v":""},{"$f":"IF(D70=\"\",\"\",R46*100/P12)","v":""},null,null,{"$f":"IF(VLOOKUP(W46,$B$14:$H$23,4)=\"\",\"\",VLOOKUP(W46,$B$14:$H$23,4))","v":""},10,2,1,"","","","","","",""]
[null,3,{"$f":"IF(Values!B9=\"\",\"\",Values!B9)","v":""},{"$f":"IF(Values!C9=\"\",\"\",Values!C9)","v":""},{"$f":"IF(Values!D9=\"\",\"\",Values!D9)","v":""},{"$f":"IF(Values!E9=\"\",\"\",Values!E9)","v":""},{"$f":"IF(Values!F9=\"\",\"\",Values!F9)","v":""},{"$f":"IF(Values!G9=\"\",\"\",Values!G9)","v":""},null,"General",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W47,$B$14:$H$23,5)=\"\",\"\",VLOOKUP(W47,$B$14:$H$23,5))","v":""},10,2,2,"","","","","","",""]
[null,4,{"$f":"IF(Values!B10=\"\",\"\",Values!B10)","v":""},{"$f":"IF(Values!C10=\"\",\"\",Values!C10)","v":""},{"$f":"IF(Values!D10=\"\",\"\",Values!D10)","v":""},{"$f":"IF(Values!E10=\"\",\"\",Values!E10)","v":""},{"$f":"IF(Values!F10=\"\",\"\",Values!F10)","v":""},{"$f":"IF(Values!G10=\"\",\"\",Values!G10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W48,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W48,$B$14:$H$23,6))","v":""},1,3,1,"","","","","","",""]
[null,5,{"$f":"IF(Values!B11=\"\",\"\",Values!B11)","v":""},{"$f":"IF(Values!C11=\"\",\"\",Values!C11)","v":""},{"$f":"IF(Values!D11=\"\",\"\",Values!D11)","v":""},{"$f":"IF(Values!E11=\"\",\"\",Values!E11)","v":""},{"$f":"IF(Values!F11=\"\",\"\",Values!F11)","v":""},{"$f":"IF(Values!G11=\"\",\"\",Values!G11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W49,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W49,$B$14:$H$23,7))","v":""},1,3,2,"","","","","","",""]
[null,6,{"$f":"IF(Values!B12=\"\",\"\",Values!B12)","v":""},{"$f":"IF(Values!C12=\"\",\"\",Values!C12)","v":""},{"$f":"IF(Values!D12=\"\",\"\",Values!D12)","v":""},{"$f":"IF(Values!E12=\"\",\"\",Values!E12)","v":""},{"$f":"IF(Values!F12=\"\",\"\",Values!F12)","v":""},{"$f":"IF(Values!G12=\"\",\"\",Values!G12)","v":""},null,"Average difference [X-quer (difference)]",null,null,null,{"$f":"MAX(B72,H72,N72)-MIN(B72,H72,N72)","v":0},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W50,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W50,$B$14:$H$23,6))","v":""},2,3,1,"","","","","","",""]
[null,7,{"$f":"IF(Values!B13=\"\",\"\",Values!B13)","v":""},{"$f":"IF(Values!C13=\"\",\"\",Values!C13)","v":""},{"$f":"IF(Values!D13=\"\",\"\",Values!D13)","v":""},{"$f":"IF(Values!E13=\"\",\"\",Values!E13)","v":""},{"$f":"IF(Values!F13=\"\",\"\",Values!F13)","v":""},{"$f":"IF(Values!G13=\"\",\"\",Values!G13)","v":""},null,"Range [R-quer-quer]",null,null,null,{"$f":"AVERAGE(G61:G70,M61:M70,Q61:Q70)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W51,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W51,$B$14:$H$23,7))","v":""},2,3,2,"","","","","","",""]
[null,8,{"$f":"IF(Values!B14=\"\",\"\",Values!B14)","v":""},{"$f":"IF(Values!C14=\"\",\"\",Values!C14)","v":""},{"$f":"IF(Values!D14=\"\",\"\",Values!D14)","v":""},{"$f":"IF(Values!E14=\"\",\"\",Values!E14)","v":""},{"$f":"IF(Values!F14=\"\",\"\",Values!F14)","v":""},{"$f":"IF(Values!G14=\"\",\"\",Values!G14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W52,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W52,$B$14:$H$23,6))","v":""},3,3,1,"","","","","","",""]
[null,9,{"$f":"IF(Values!B15=\"\",\"\",Values!B15)","v":""},{"$f":"IF(Values!C15=\"\",\"\",Values!C15)","v":""},{"$f":"IF(Values!D15=\"\",\"\",Values!D15)","v":""},{"$f":"IF(Values!E15=\"\",\"\",Values!E15)","v":""},{"$f":"IF(Values!F15=\"\",\"\",Values!F15)","v":""},{"$f":"IF(Values!G15=\"\",\"\",Values!G15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W53,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W53,$B$14:$H$23,7))","v":""},3,3,2,"","","","","","",""]
[null,10,{"$f":"IF(Values!B16=\"\",\"\",Values!B16)","v":""},{"$f":"IF(Values!C16=\"\",\"\",Values!C16)","v":""},{"$f":"IF(Values!D16=\"\",\"\",Values!D16)","v":""},{"$f":"IF(Values!E16=\"\",\"\",Values!E16)","v":""},{"$f":"IF(Values!F16=\"\",\"\",Values!F16)","v":""},{"$f":"IF(Values!G16=\"\",\"\",Values!G16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W54,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W54,$B$14:$H$23,6))","v":""},4,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W55,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W55,$B$14:$H$23,7))","v":""},4,3,2,"","","","","","",""]
[null,"ARM Value Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W56,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W56,$B$14:$H$23,6))","v":""},5,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W57,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W57,$B$14:$H$23,7))","v":""},5,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W58,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W58,$B$14:$H$23,6))","v":""},6,3,1,"","","","","","",""]
[null,"Inspector A",null,null,null,null,null,"Inspector B",null,null,null,null,null,"Inspector C",null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(W59,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W59,$B$14:$H$23,7))","v":""},6,3,2,"","","","","","",""]
[null,"Inspection 1",null,"Inspection 2","Average \n[x-quer]",null,"Range [R]","Inspection 1","Inspection 2",null,"Average \n[x-quer]",null,"Range [R]","Inspection 1","Inspection 2","Average \n[x-quer]","Range [R]",null,null,null,null,{"$f":"IF(VLOOKUP(W60,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W60,$B$14:$H$23,6))","v":""},7,3,1,"","","","","","",""]
[null,{"$f":"C45","v":""},null,{"$f":"D45","v":""},{"$f":"IF(D61=\"\",\"\",AVERAGE(B61:D61))","v":""},null,{"$f":"IF(D61=\"\",\"\",MAX(B61:D61)-MIN(B61:D61))","v":""},{"$f":"E45","v":""},{"$f":"F45","v":""},null,{"$f":"IF(I61=\"\",\"\",AVERAGE(H61:J61))","v":""},null,{"$f":"IF(I61=\"\",\"\",MAX(H61:J61)-MIN(H61:K61))","v":""},{"$f":"G45","v":""},{"$f":"H45","v":""},{"$f":"IFERROR(AVERAGE(N61:O61),\"\")","v":""},{"$f":"IF(P61=\"\",\"\",MAX(N61:O61)-MIN(N61:O61))","v":""},null,null,null,null,{"$f":"IF(VLOOKUP(W61,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W61,$B$14:$H$23,7))","v":""},7,3,2,"","","","","","",""]
[null,"",null,"",{"$f":"IF(D62=\"\",\"\",AVERAGE(B62:D62))","v":""},null,{"$f":"IF(D62=\"\",\"\",MAX(B62:D62)-MIN(B62:D62))","v":""},"","",null,{"$f":"IF(I62=\"\",\"\",AVERAGE(H62:J62))","v":""},null,{"$f":"IF(I62=\"\",\"\",MAX(H62:J62)-MIN(H62:K62))","v":""},"","",{"$f":"IFERROR(AVERAGE(N62:O62),\"\")","v":""},{"$f":"IF(P62=\"\",\"\",MAX(N62:O62)-MIN(N62:O62))","v":""},null,null,null,null,{"$f":"IF(VLOOKUP(W62,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W62,$B$14:$H$23,6))","v":""},8,3,1,"","","","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","","",null,null,null,null,{"$f":"IF(VLOOKUP(W63,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W63,$B$14:$H$23,7))","v":""},8,3,2,"","","","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","","",null,null,null,null,{"$f":"IF(VLOOKUP(W64,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W64,$B$14:$H$23,6))","v":""},9,3,1,"","","","","","",""]
[null,"",null,"",{"$f":"IF(D65=\"\",\"\",AVERAGE(B65:D65))","v":""},null,"","","",null,{"$f":"IF(I65=\"\",\"\",AVERAGE(H65:J65))","v":""},null,"","","","","",null,null,null,null,{"$f":"IF(VLOOKUP(W65,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W65,$B$14:$H$23,7))","v":""},9,3,2,"","","","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","","",null,null,null,null,{"$f":"IF(VLOOKUP(W66,$B$14:$H$23,6)=\"\",\"\",VLOOKUP(W66,$B$14:$H$23,6))","v":""},10,3,1,"","","","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","","",null,null,null,null,{"$f":"IF(VLOOKUP(W67,$B$14:$H$23,7)=\"\",\"\",VLOOKUP(W67,$B$14:$H$23,7))","v":""},10,3,2,"","","","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","","",null,null,null,null,null,null,null,"Summ [Σ]",{"$f":"IF(SUM(Z8:Z67)=0,\"\",SUM(Z8:Z67))","v":""},"","","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","",""]
[null,"",null,"","",null,"","","",null,"",null,"","","","",""]
[null,"X-Bar",null,null,null,null,"R-Bar","X-Bar",null,null,null,null,"R-Bar","X-Bar",null,null,"R-Bar"]
[null,{"$f":"IFERROR(AVERAGE(B61:D70),\"\")","v":""},null,null,null,null,{"$f":"IF(G70=\"\",\"\",MAX(G61:G70)-MIN(G61:G70))","v":""},{"$f":"IFERROR(AVERAGE(H61:J70),\"\")","v":""},null,null,null,null,{"$f":"IF(M70=\"\",\"\",MAX(M61:M70)-MIN(M61:M70))","v":""},{"$f":"IFERROR(AVERAGE(N61:O70),\"\")","v":""},null,null,{"$f":"IF(Q61=\"\",\"\",MAX(Q61:Q70)-MIN(Q61:Q70))","v":""}]
[]
[null,"Graphics calculation"]
[]
[]
[null,"X-Bar Chart Data",null,null,null,null,null,"MR Chart Data",null,null,null,null,null,"Boxplot Data",null,null,null,null,null,null,null,"Additional Pro.File variables"]
[]
[]
[null,"Part",null,"X-Bar j1","X-Bar j2","X-Bar j3",null,"Part","R j1",null,"R j2","R j3",null,null,null,"j1","j2","j3",null,null,null,"Resolution",null,{"$f":"VALUE(PRODSTRING15)","v":0}]
[null,"i1",null,{"$f":"IF($C$14=\"\",\"\",AVERAGE(C14,D14))","v":""},{"$f":"IF($E$14=\"\",\"\",AVERAGE(E14,F14))","v":""},{"$f":"IF($G$14=\"\",\"\",AVERAGE(G14,H14))","v":""},null,"i1",{"$f":"IF(C14=\"\",\"\",MAX(C14:D14)-MIN(C14:D14))","v":""},null,{"$f":"IF(E14=\"\",\"\",MAX(E14:F14)-MIN(E14:F14))","v":""},{"$f":"IF(G14=\"\",\"\",MAX(G14:H14)-MIN(G14:H14))","v":""},null,"Max",null,{"$f":"IF(D70=\"\",\"\",MAX(B61:D70))","v":""},{"$f":"IF(D70=\"\",\"\",MAX(H61:J70))","v":""},{"$f":"IF(N61=\"\",\"\",MAX(N61:O70))","v":""},null,null,null,"USL",null,{"$f":"VALUE(PRODSTRING17)","v":0}]
[null,"i2",null,{"$f":"IF($C$14=\"\",\"\",AVERAGE(C15,D15))","v":""},{"$f":"IF($E$14=\"\",\"\",AVERAGE(E15,F15))","v":""},{"$f":"IF($G$14=\"\",\"\",AVERAGE(G15,H15))","v":""},null,"i2",{"$f":"IF(C15=\"\",\"\",MAX(C15:D15)-MIN(C15:D15))","v":""},null,{"$f":"IF(E15=\"\",\"\",MAX(E15:F15)-MIN(E15:F15))","v":""},{"$f":"IF(G15=\"\",\"\",MAX(G15:H15)-MIN(G15:H15))","v":""},null,"Q3",null,{"$f":"IF(D70=\"\",\"\",QUARTILE(B61:D70,3))","v":""},{"$f":"IF(D70=\"\",\"\",QUARTILE(H61:J70,3))","v":""},{"$f":"IF(N61=\"\",\"\",QUARTILE(N61:O70,3))","v":""},null,null,null,"LSL",null,{"$f":"VALUE(PRODSTRING18)","v":0}]
[null,"i3",null,"","","",null,"i3","",null,"","",null,"Med",null,{"$f":"IF(D70=\"\",\"\",MEDIAN(B61:D70))","v":""},{"$f":"IF(D70=\"\",\"\",MEDIAN(H61:J70))","v":""},{"$f":"IF(N61=\"\",\"\",MEDIAN(N61:O70))","v":""}]
[null,"i4",null,"","","",null,"i4","",null,"","",null,"Q1",null,{"$f":"IF(D70=\"\",\"\",QUARTILE(B61:D70,1))","v":""},{"$f":"IF(D70=\"\",\"\",QUARTILE(H61:J70,1))","v":""},{"$f":"IF(N61=\"\",\"\",QUARTILE(N61:O70,1))","v":""}]
[null,"i5",null,"","","",null,"i5","",null,"","",null,"Min",null,{"$f":"IF(D70=\"\",\"\",MIN(B61:D70))","v":""},{"$f":"IF(D70=\"\",\"\",MIN(H61:J70))","v":""},{"$f":"IF(N61=\"\",\"\",MIN(N61:O70))","v":""}]
[null,"i6",null,"","","",null,"i6","",null,"","",null,"Maximum - Q3",null,{"$f":"IF(P81=\"\",\"\",P81-P85)","v":""},{"$f":"IF(Q81=\"\",\"\",Q81-Q85)","v":""},{"$f":"IF(R81=\"\",\"\",R81-R85)","v":""}]
[null,"i7",null,"","","",null,"i7","",null,"","",null,"Q1-Minimum",null,{"$f":"IF(P81=\"\",\"\",P84-P85)","v":""},{"$f":"IF(Q81=\"\",\"\",Q84-Q85)","v":""},{"$f":"IF(R84=\"\",\"\",R84-R85)","v":""}]
[null,"i8",null,"","","",null,"i8","",null,"",""]
[null,"i9",null,"","","",null,"i9","",null,"","",null,null,null,"j1","j2","j3"]
[null,"i10",null,"","","",null,"i10","",null,"","",null,"Min",null,{"$f":"P85","v":""},{"$f":"Q85","v":""},{"$f":"R85","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q1;Min)",null,{"$f":"IF(P84=\"\",\"\",P84-P85)","v":""},{"$f":"IF(Q84=\"\",\"\",Q84-Q85)","v":""},{"$f":"IF(R84=\"\",\"\",R84-R85)","v":""}]
[null,"X - UEL",null,{"$f":"IF(P18=\"\",\"\",I96+(I97*(IF(P14=2,D97,D98))))","v":""},null,null,null,"R - UEL",{"$f":"IF(I97=\"\",\"\",I97*IF(P14=2,E97,E98))","v":""},null,null,null,null,"∆ (Med;Q1)",null,{"$f":"IF(P83=\"\",\"\",P83-P84)","v":""},{"$f":"IF(Q83=\"\",\"\",Q83-Q84)","v":""},{"$f":"IF(R83=\"\",\"\",R83-R84)","v":""}]
[null,"X - LEL",null,{"$f":"IF(P18=\"\",\"\",I96-(I97*(IF(P14=2,D97,D98))))","v":""},null,null,null,null,null,null,null,null,null,"∆ (Q3;Med)",null,{"$f":"IF(P82=\"\",\"\",P82-P83)","v":""},{"$f":"IF(Q82=\"\",\"\",Q82-Q83)","v":""},{"$f":"IF(R82=\"\",\"\",R82-R83)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Max)",null,{"$f":"IF(P81=\"\",\"\",P81-P82)","v":""},{"$f":"IF(Q81=\"\",\"\",Q81-Q82)","v":""},{"$f":"IF(R81=\"\",\"\",R81-R82)","v":""}]
[]
[null,"n",null,"A2","D4",null,null,"X-bar bar",{"$f":"AVERAGE(D81:F90)","v":{"$error":"#DIV/0!"}}]
[null,2,null,1.88,3.2669999999999999,null,null,"R ",{"$f":"IF(I81=\"\",\"\",AVERAGE(I81:L90))","v":""}]
[null,3,null,1.0229999999999999,2.5739999999999998]

{"sheet":"Settings","index":5,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,1,1,3],[13,1,14,3],[8,1,9,3],[2,1,3,3],[5,1,7,7],[11,1,12,4],[16,1,17,4],[16,5,17,7],[22,1,23,4],[22,5,23,7],[18,1,19,4],[18,5,19,7],[20,1,21,4],[20,5,21,7]]}
[null,"Settings"]
[]
[null,"Information"]
[]
[]
[null,"The integrated macros in this Worksheet are not required for the calculation. The macros just handle the scaling of the integrated charts. If you do not activate the macros, the sheet is still capable to calculate trustwothy indicies."]
[]
[]
[null,"PDF-Print"]
[]
[]
[null,"Print a pdf of the register \"Visualization\" to a folder of your choice."]
[]
[null,"Unhide/Hide register"]
[]
[]
[null,"Guide (A \"How to use\" this document)"]
[]
[null,"Calculations (Distribution; Graphics; Indices)"]
[]
[null,"Directories (Resolution, Measrumentdevices, Units)"]
[]
[null,"References (Calculation references)"]

{"sheet":"Directories","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Resolution",null,"Unit",null,"Measurement system"]
[null,1,null,"µm",null,"Height Gauge"]
[null,0.5,null,"mm",null,"Precision scale"]
[null,0.1,null,"m",null,"Packing scale"]
[null,0.05,null,"Nm",null,"Flux measurment"]
[null,0.01,null,"A",null,"Final Test"]
[null,5.0000000000000001E-3,null,"mA",null,"Noise chamber"]
[null,1E-3,null,"V",null,"Vibration sensor"]
[null,5.0000000000000001E-4,null,"Pa/s",null,"LDV"]
[null,1E-4,null,"µVs",null,"AOI Grease"]
[null,5.0000000000000002E-5,null,"bar",null,"AOI Soldering"]
[null,1.0000000000000001E-5,null,"mg"]
[null,null,null,"g"]
[null,null,null,"%"]
[null,null,null,"Pixel"]

{"sheet":"References","index":7,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,1,8,9],[12,1,13,7]]}
[]
[]
[]
[null,"Calculation according \"Measurement System Capability\" Reference Manual.\n\nHead of work group:\nDr. Edgar Dietrich\n\n(Status: 17. September 2002)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Detailed references and calculation information are located in the Managment System doc-nr. 1758."]