{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Guide","Visualization","Graphics","Calculation","Macro","References","Directories"],"not_rendered":{"charts":12,"images":17,"macros":1,"external_links":0,"defined_names":21,"comments":0,"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":194,"n_cols":7,"rows_kept":194,"cut":false,"hidden":false,"merged":[[48,2,49,7],[6,2,7,8],[14,4,14,6],[15,4,15,6],[16,4,16,6],[30,3,31,7],[12,2,12,7],[32,3,33,7],[34,3,37,7],[38,3,39,7],[40,3,41,7],[42,3,42,7],[193,1,194,7],[50,2,50,7],[51,2,51,7],[111,1,111,2],[111,3,111,7],[157,1,158,7],[73,2,74,7],[153,1,153,6],[162,6,164,8],[147,1,147,2],[147,3,147,7],[148,1,148,2],[148,3,148,7],[112,1,112,2],[112,3,112,7],[52,2,53,7]]}
[]
[]
[]
[]
[]
[]
[null,"Important:","This file based on a Office 2010 version. For correct visualization and calculation use \nOffice 2010 or higher."]
[]
[]
[]
[]
[]
[null,"Information:","For a better understanding, which cell you can edit, the cells are colored."]
[]
[null,null,null,"<<","You can/have to edit the cell"]
[null,null,null,"<<","The cell calculate a value"]
[null,null,null,"<<","Fix data/information"]
[]
[]
[]
[]
[null,"1.1 Open register \"Visualization\""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Location: ",null,"Enter the location where was capability was done. \nFor Example: Germany; PMDM Villingen"]
[]
[null,"Line:",null,"Enter the line/place where your measurement system is located. For Example: BLDC Line or QCArea"]
[]
[null,"Device-Typ:",null,"Please enter a clear understandable name for your equipment. The name should correspond with your measurement equipment database.\nFor Example: Height gauge; Precision scale"]
[]
[]
[]
[null,"Device-Number:",null,"Enter the measurement equipment number where you can find in your measurement equipment database."]
[]
[null,"Resolution:",null,"Enter the Resolution of your System. \nFor Example: 0,001"]
[]
[null,"Date:",null,"Enter the date where you did your analysis."]
[]
[]
[]
[]
[]
[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 measurement system."]
[null,"∆ Spec:","Enter the smallest Delta Spec you will measure with this equipment."]
[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 several options."]
[]
[]
[]
[]
[]
[null,"2.1 Open register \"Calculation\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Values:","Enter the values for each operator into the table. Be aware that the measurement chronicle of the data will not be change."]
[]
[]
[]
[]
[null,"3.1 Open register \"Visualization\""]
[null,"3.2 Good Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"%R&R:",null,"Value is smaller than 10%"]
[null,"ndc:",null,"Value is bigger than 5"]
[]
[null,"3.3 Bad Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"%R&R:",null,"Value is bigger than 10%"]
[null,"ndc:",null,"Value is smaller than 5"]
[]
[]
[]
[]
[null,"Info: This is totally optional. The sheet will calculate the result anyway."]
[]
[]
[]
[null,"Info: Macros will not influence the calculation. If you do not turn on the macros, the sheet will calculate properly anyway."]
[]
[]
[null,"1. Open register \"Macro\""]
[]
[null,null,null,null,null,null,"Export function"]
[]
[]
[]
[]
[]
[]
[null,"1. Open register \"Directories\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You can enter terms you use often through analysis. After entering you can find these terms in the Drop Downs of the cells (Register \"Visualization\")."]

{"sheet":"Visualization","index":1,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[15,2,15,3],[15,6,15,9],[18,3,18,4],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[20,5,20,6],[18,5,18,6],[18,7,18,8],[46,5,46,6],[46,7,46,8],[22,11,22,12],[23,11,23,12],[21,5,21,6],[22,5,22,6],[27,7,27,8],[18,11,18,12],[45,7,45,8],[45,5,45,6],[20,7,20,8],[56,2,56,3],[55,2,55,3],[55,4,55,5],[55,9,55,10],[54,9,54,10],[50,5,50,6],[50,2,50,4],[47,5,47,6],[55,6,55,8],[54,6,54,7],[52,2,52,3],[52,6,52,8],[52,4,52,5],[48,7,48,8],[49,7,49,8],[48,10,48,11],[49,10,49,11],[48,2,48,4],[49,2,49,4],[47,2,47,4],[48,5,48,6],[49,5,49,6],[47,10,47,11],[24,13,24,14],[18,13,18,14],[0,0,0,15],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[23,5,23,6],[24,5,24,6],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[6,6,6,10],[7,6,7,10],[8,6,8,10],[11,6,11,7],[10,6,10,7],[9,6,9,7],[13,4,13,11],[28,3,28,4],[19,7,19,8],[52,12,52,13],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[19,5,19,6],[25,13,25,14],[26,13,26,14],[27,13,27,14],[28,13,28,14],[19,13,19,14],[20,13,20,14],[21,13,21,14],[22,13,22,14],[23,13,23,14],[19,11,19,12],[20,11,20,12],[21,11,21,12],[46,13,46,14],[46,2,46,4],[28,7,28,8],[47,13,47,14],[46,10,46,11],[47,7,47,8],[55,12,55,14],[14,2,14,3],[14,8,14,9],[14,10,14,11],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[48,13,48,14],[49,13,49,14],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[14,4,14,5],[15,10,15,11],[18,9,18,10]]}
["Please enter the collected measured values into the register \"Calculation\""]
[{"$f":"IF($M$56=\"NG\",1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF($M$56=\"NG\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$56=\"NG\",1,0)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Line:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Device-Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Device-Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Resolution:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$56=\"NG\",1,0)","v":0}]
[0,null,"Feature",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,"Unit",null,null,null,null,null,"∆ Spec",null,null,null,null,null,null,null,0]
[0,null,"KPC",null,null,null,{"$f":"IF(OR(E16<>\"\",F16<>\"\"),\" Feature is critical\",\" No KPC feature\")","v":" No KPC feature"},null,null,null,{"$f":"K15","v":0},null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,"Row A",null,"Row B",null,"Row A",null,"Row B",null,"Row A",null,"Row B",null,null,0]
[0,null,1,{"$f":"IF(Calculation!C7=\"\",\"\",FIXED(Calculation!C7,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D7=\"\",\"\",FIXED(Calculation!D7,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E7=\"\",\"\",FIXED(Calculation!E7,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F7=\"\",\"\",FIXED(Calculation!F7,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G7=\"\",\"\",FIXED(Calculation!G7,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H7=\"\",\"\",FIXED(Calculation!H7,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,2,{"$f":"IF(Calculation!C8=\"\",\"\",FIXED(Calculation!C8,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D8=\"\",\"\",FIXED(Calculation!D8,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E8=\"\",\"\",FIXED(Calculation!E8,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F8=\"\",\"\",FIXED(Calculation!F8,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G8=\"\",\"\",FIXED(Calculation!G8,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H8=\"\",\"\",FIXED(Calculation!H8,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,3,{"$f":"IF(Calculation!C9=\"\",\"\",FIXED(Calculation!C9,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D9=\"\",\"\",FIXED(Calculation!D9,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E9=\"\",\"\",FIXED(Calculation!E9,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F9=\"\",\"\",FIXED(Calculation!F9,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G9=\"\",\"\",FIXED(Calculation!G9,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H9=\"\",\"\",FIXED(Calculation!H9,LEN($G$11)-2,FALSE))","v":""},null,null,{"$f":"IF($M$56=\"NG\",1,0)","v":0}]
[0,null,4,{"$f":"IF(Calculation!C10=\"\",\"\",FIXED(Calculation!C10,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D10=\"\",\"\",FIXED(Calculation!D10,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E10=\"\",\"\",FIXED(Calculation!E10,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F10=\"\",\"\",FIXED(Calculation!F10,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G10=\"\",\"\",FIXED(Calculation!G10,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H10=\"\",\"\",FIXED(Calculation!H10,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,5,{"$f":"IF(Calculation!C11=\"\",\"\",FIXED(Calculation!C11,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D11=\"\",\"\",FIXED(Calculation!D11,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E11=\"\",\"\",FIXED(Calculation!E11,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F11=\"\",\"\",FIXED(Calculation!F11,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G11=\"\",\"\",FIXED(Calculation!G11,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H11=\"\",\"\",FIXED(Calculation!H11,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,6,{"$f":"IF(Calculation!C12=\"\",\"\",FIXED(Calculation!C12,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D12=\"\",\"\",FIXED(Calculation!D12,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E12=\"\",\"\",FIXED(Calculation!E12,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F12=\"\",\"\",FIXED(Calculation!F12,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G12=\"\",\"\",FIXED(Calculation!G12,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H12=\"\",\"\",FIXED(Calculation!H12,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,7,{"$f":"IF(Calculation!C13=\"\",\"\",FIXED(Calculation!C13,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D13=\"\",\"\",FIXED(Calculation!D13,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E13=\"\",\"\",FIXED(Calculation!E13,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F13=\"\",\"\",FIXED(Calculation!F13,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G13=\"\",\"\",FIXED(Calculation!G13,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H13=\"\",\"\",FIXED(Calculation!H13,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,8,{"$f":"IF(Calculation!C14=\"\",\"\",FIXED(Calculation!C14,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D14=\"\",\"\",FIXED(Calculation!D14,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E14=\"\",\"\",FIXED(Calculation!E14,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F14=\"\",\"\",FIXED(Calculation!F14,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G14=\"\",\"\",FIXED(Calculation!G14,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H14=\"\",\"\",FIXED(Calculation!H14,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,9,{"$f":"IF(Calculation!C15=\"\",\"\",FIXED(Calculation!C15,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D15=\"\",\"\",FIXED(Calculation!D15,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E15=\"\",\"\",FIXED(Calculation!E15,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F15=\"\",\"\",FIXED(Calculation!F15,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G15=\"\",\"\",FIXED(Calculation!G15,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H15=\"\",\"\",FIXED(Calculation!H15,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,10,{"$f":"IF(Calculation!C16=\"\",\"\",FIXED(Calculation!C16,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!D16=\"\",\"\",FIXED(Calculation!D16,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!E16=\"\",\"\",FIXED(Calculation!E16,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!F16=\"\",\"\",FIXED(Calculation!F16,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!G16=\"\",\"\",FIXED(Calculation!G16,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF(Calculation!H16=\"\",\"\",FIXED(Calculation!H16,LEN($G$11)-2,FALSE))","v":""},null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF($M$56=\"NG\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$56=\"NG\",1,0)","v":0}]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,"Varianz",null,"Sigma",null,null,null,null,null,0.1,null,null,0]
[0,null,"Repeatability",null,null,{"$f":"Calculation!N35","v":""},null,{"$f":"Calculation!N38","v":""},null,"%EV =",{"$f":"Calculation!R44","v":""},null,{"$f":"K47","v":""},{"$f":"K47","v":""},null,null,0]
[0,null,"Reproducibility",null,null,{"$f":"Calculation!M35","v":""},null,{"$f":"Calculation!M38","v":""},null,"%AV =",{"$f":"Calculation!R45","v":""},null,{"$f":"K48","v":""},{"$f":"K48","v":""},null,null,0]
[0,null,"Interaction",null,null,{"$f":"Calculation!P35","v":""},null,{"$f":"Calculation!P38","v":""},null,"%IA =",{"$f":"IF(Calculation!R46=0,\"\",Calculation!R46)","v":""},null,{"$f":"K49","v":""},{"$f":"K49","v":""},null,null,0]
[0,null,"Gauge distribution",null,null,{"$f":"Calculation!R35","v":""},null,{"$f":"Calculation!R38","v":""},null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$56=\"NG\",1,0)","v":0}]
[0,null,"%RE",null,{"$f":"IF($G$11=\"\",\"\",($G$11/K16)*100)","v":""},null,{"$f":"IF($G$11=\"\",\"\",($G$11/K16)*100)","v":""},null,null,null,null,null,{"$f":"IF(Calculation!L41=\"\",\"\",Calculation!L41)","v":""},null,{"$f":"Calculation!L41","v":""},null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,0.1,null,null,0.3,null,null,null,null,null,null,0]
[0,null,"%R&R",null,{"$f":"Calculation!R47","v":""},null,{"$f":"Calculation!R47","v":""},null,null,{"$f":"Calculation!R47","v":""},null,null,{"$f":"IF(J56=\"\",\"\",IF(AND(M53>5,J56<10),\"Approved\",\"NG\"))","v":""},null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,{"$f":"IF($M$56=\"NG\",1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Graphics","index":2,"n_rows":88,"n_cols":28,"rows_kept":88,"cut":false,"hidden":false,"merged":[[50,18,50,21],[51,19,51,21],[52,19,52,21],[68,19,68,21]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part","X-Bar j1","X-Bar j2","X-Bar j3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i1",{"$f":"IF(Calculation!C7=\"\",\"\",AVERAGE(Calculation!C7:D7))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",AVERAGE(Calculation!E7:F7))","v":""},{"$f":"IF(Calculation!G7=\"\",\"\",AVERAGE(Calculation!G7:H7))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i2",{"$f":"IF(Calculation!C8=\"\",\"\",AVERAGE(Calculation!C8:D8))","v":""},{"$f":"IF(Calculation!E8=\"\",\"\",AVERAGE(Calculation!E8:F8))","v":""},{"$f":"IF(Calculation!G8=\"\",\"\",AVERAGE(Calculation!G8:H8))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i3",{"$f":"IF(Calculation!C9=\"\",\"\",AVERAGE(Calculation!C9:D9))","v":""},{"$f":"IF(Calculation!E9=\"\",\"\",AVERAGE(Calculation!E9:F9))","v":""},{"$f":"IF(Calculation!G9=\"\",\"\",AVERAGE(Calculation!G9:H9))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i4",{"$f":"IF(Calculation!C10=\"\",\"\",AVERAGE(Calculation!C10:D10))","v":""},{"$f":"IF(Calculation!E10=\"\",\"\",AVERAGE(Calculation!E10:F10))","v":""},{"$f":"IF(Calculation!G10=\"\",\"\",AVERAGE(Calculation!G10:H10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i5",{"$f":"IF(Calculation!C11=\"\",\"\",AVERAGE(Calculation!C11:D11))","v":""},{"$f":"IF(Calculation!E11=\"\",\"\",AVERAGE(Calculation!E11:F11))","v":""},{"$f":"IF(Calculation!G11=\"\",\"\",AVERAGE(Calculation!G11:H11))","v":""},null,null,null,"x quer quer",{"$f":"IF(Calculation!C7=\"\",\"\",AVERAGE(T41:V50))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i6",{"$f":"IF(Calculation!C12=\"\",\"\",AVERAGE(Calculation!C12:D12))","v":""},{"$f":"IF(Calculation!E12=\"\",\"\",AVERAGE(Calculation!E12:F12))","v":""},{"$f":"IF(Calculation!G12=\"\",\"\",AVERAGE(Calculation!G12:H12))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i7",{"$f":"IF(Calculation!C13=\"\",\"\",AVERAGE(Calculation!C13:D13))","v":""},{"$f":"IF(Calculation!E13=\"\",\"\",AVERAGE(Calculation!E13:F13))","v":""},{"$f":"IF(Calculation!G13=\"\",\"\",AVERAGE(Calculation!G13:H13))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i8",{"$f":"IF(Calculation!C14=\"\",\"\",AVERAGE(Calculation!C14:D14))","v":""},{"$f":"IF(Calculation!E14=\"\",\"\",AVERAGE(Calculation!E14:F14))","v":""},{"$f":"IF(Calculation!G14=\"\",\"\",AVERAGE(Calculation!G14:H14))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i9",{"$f":"IF(Calculation!C15=\"\",\"\",AVERAGE(Calculation!C15:D15))","v":""},{"$f":"IF(Calculation!E15=\"\",\"\",AVERAGE(Calculation!E15:F15))","v":""},{"$f":"IF(Calculation!G15=\"\",\"\",AVERAGE(Calculation!G15:H15))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i10",{"$f":"IF(Calculation!C16=\"\",\"\",AVERAGE(Calculation!C16:D16))","v":""},{"$f":"IF(Calculation!E16=\"\",\"\",AVERAGE(Calculation!E16:F16))","v":""},{"$f":"IF(Calculation!G16=\"\",\"\",AVERAGE(Calculation!G16:H16))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X - UEL",{"$f":"IF(AA45=\"\",\"\",$AA$45+($AA$64*(IF(COUNT($T$41:$V$41)=2,$AA$58,$AA$59))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X - LEL",{"$f":"IF(AA45=\"\",\"\",$AA$45-($AA$64*(IF(COUNT($T$41:$V$41)=2,$AA$58,$AA$59))))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part","R j1","R j2","R j3",null,null,null,"n","A2","D4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i1",{"$f":"IF(Calculation!C7=\"\",\"\",MAX(Calculation!C7:D7)-MIN(Calculation!C7:D7))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",MAX(Calculation!E7:F7)-MIN(Calculation!E7:F7))","v":""},{"$f":"IF(V41=\"\",\"\",MAX(Calculation!G7:H7)-MIN(Calculation!G7:H7))","v":""},null,null,null,2,1.88,3.2669999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i2",{"$f":"IF(Calculation!C8=\"\",\"\",MAX(Calculation!C8:D8)-MIN(Calculation!C8:D8))","v":""},{"$f":"IF(Calculation!E8=\"\",\"\",MAX(Calculation!E8:F8)-MIN(Calculation!E8:F8))","v":""},{"$f":"IF(V42=\"\",\"\",MAX(Calculation!G8:H8)-MIN(Calculation!G8:H8))","v":""},null,null,null,3,1.0229999999999999,2.5739999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i3",{"$f":"IF(Calculation!C9=\"\",\"\",MAX(Calculation!C9:D9)-MIN(Calculation!C9:D9))","v":""},{"$f":"IF(Calculation!E9=\"\",\"\",MAX(Calculation!E9:F9)-MIN(Calculation!E9:F9))","v":""},{"$f":"IF(V43=\"\",\"\",MAX(Calculation!G9:H9)-MIN(Calculation!G9:H9))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i4",{"$f":"IF(Calculation!C10=\"\",\"\",MAX(Calculation!C10:D10)-MIN(Calculation!C10:D10))","v":""},{"$f":"IF(Calculation!E10=\"\",\"\",MAX(Calculation!E10:F10)-MIN(Calculation!E10:F10))","v":""},{"$f":"IF(V44=\"\",\"\",MAX(Calculation!G10:H10)-MIN(Calculation!G10:H10))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i5",{"$f":"IF(Calculation!C11=\"\",\"\",MAX(Calculation!C11:D11)-MIN(Calculation!C11:D11))","v":""},{"$f":"IF(Calculation!E11=\"\",\"\",MAX(Calculation!E11:F11)-MIN(Calculation!E11:F11))","v":""},{"$f":"IF(V45=\"\",\"\",MAX(Calculation!G11:H11)-MIN(Calculation!G11:H11))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i6",{"$f":"IF(Calculation!C12=\"\",\"\",MAX(Calculation!C12:D12)-MIN(Calculation!C12:D12))","v":""},{"$f":"IF(Calculation!E12=\"\",\"\",MAX(Calculation!E12:F12)-MIN(Calculation!E12:F12))","v":""},{"$f":"IF(V46=\"\",\"\",MAX(Calculation!G12:H12)-MIN(Calculation!G12:H12))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i7",{"$f":"IF(Calculation!C13=\"\",\"\",MAX(Calculation!C13:D13)-MIN(Calculation!C13:D13))","v":""},{"$f":"IF(Calculation!E13=\"\",\"\",MAX(Calculation!E13:F13)-MIN(Calculation!E13:F13))","v":""},{"$f":"IF(V47=\"\",\"\",MAX(Calculation!G13:H13)-MIN(Calculation!G13:H13))","v":""},null,null,null,"R ",{"$f":"IF(Calculation!C7=\"\",\"\",AVERAGE(T58:V67))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i8",{"$f":"IF(Calculation!C14=\"\",\"\",MAX(Calculation!C14:D14)-MIN(Calculation!C14:D14))","v":""},{"$f":"IF(Calculation!E14=\"\",\"\",MAX(Calculation!E14:F14)-MIN(Calculation!E14:F14))","v":""},{"$f":"IF(V48=\"\",\"\",MAX(Calculation!G14:H14)-MIN(Calculation!G14:H14))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i9",{"$f":"IF(Calculation!C15=\"\",\"\",MAX(Calculation!C15:D15)-MIN(Calculation!C15:D15))","v":""},{"$f":"IF(Calculation!E15=\"\",\"\",MAX(Calculation!E15:F15)-MIN(Calculation!E15:F15))","v":""},{"$f":"IF(V49=\"\",\"\",MAX(Calculation!G15:H15)-MIN(Calculation!G15:H15))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i10",{"$f":"IF(Calculation!C16=\"\",\"\",MAX(Calculation!C16:D16)-MIN(Calculation!C16:D16))","v":""},{"$f":"IF(Calculation!E16=\"\",\"\",MAX(Calculation!E16:F16)-MIN(Calculation!E16:F16))","v":""},{"$f":"IF(V50=\"\",\"\",MAX(Calculation!G16:H16)-MIN(Calculation!G16:H16))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R - UEL",{"$f":"IF(AA64=\"\",\"\",AA64*IF(COUNT(T58:V58)=2,AB58,AB59))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"j1","j2","j3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",{"$f":"IF(Calculation!C7=\"\",\"\",MAX(Calculation!C7:D16))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",MAX(Calculation!E7:F16))","v":""},{"$f":"IF(Calculation!G7=\"\",\"\",MAX(Calculation!G7:H16))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",{"$f":"IF(Calculation!C7=\"\",\"\",QUARTILE(Calculation!C7:D16,3))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",QUARTILE(Calculation!E7:F16,3))","v":""},{"$f":"IF(V76=\"\",\"\",QUARTILE(Calculation!G7:H16,3))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Med",{"$f":"IF(Calculation!C7=\"\",\"\",MEDIAN(Calculation!C7:D16))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",MEDIAN(Calculation!E7:F16))","v":""},{"$f":"IF(Calculation!G7=\"\",\"\",MEDIAN(Calculation!G7:H16))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"IF(Calculation!C7=\"\",\"\",QUARTILE(Calculation!C7:D16,1))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",QUARTILE(Calculation!E7:F16,1))","v":""},{"$f":"IF(V76=\"\",\"\",QUARTILE(Calculation!G7:H16,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(Calculation!C7=\"\",\"\",MIN(Calculation!C7:D16))","v":""},{"$f":"IF(Calculation!E7=\"\",\"\",MIN(Calculation!E7:F16))","v":""},{"$f":"IF(Calculation!G7=\"\",\"\",MIN(Calculation!G7:H16))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum - Q3",{"$f":"IF(T76=\"\",\"\",T76-T80)","v":""},{"$f":"IF(U76=\"\",\"\",U76-U80)","v":""},{"$f":"IF(V76=\"\",\"\",V76-V80)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1-Minimum",{"$f":"IF(T76=\"\",\"\",T79-T80)","v":""},{"$f":"IF(U76=\"\",\"\",U79-U80)","v":""},{"$f":"IF(V79=\"\",\"\",V79-V80)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"j1","j2","j3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"T80","v":""},{"$f":"U80","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q1;Min)",{"$f":"IF(T79=\"\",\"\",T79-T80)","v":""},{"$f":"IF(U79=\"\",\"\",U79-U80)","v":""},{"$f":"IF(V79=\"\",\"\",V79-V80)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Med;Q1)",{"$f":"IF(T78=\"\",\"\",T78-T79)","v":""},{"$f":"IF(U78=\"\",\"\",U78-U79)","v":""},{"$f":"IF(V78=\"\",\"\",V78-V79)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Med)",{"$f":"IF(T77=\"\",\"\",T77-T78)","v":""},{"$f":"IF(U77=\"\",\"\",U77-U78)","v":""},{"$f":"IF(V77=\"\",\"\",V77-V78)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Max)",{"$f":"IF(T76=\"\",\"\",T76-T77)","v":""},{"$f":"IF(U76=\"\",\"\",U76-U77)","v":""},{"$f":"IF(V76=\"\",\"\",V76-V77)","v":""}]

{"sheet":"Calculation","index":3,"n_rows":66,"n_cols":30,"rows_kept":66,"cut":false,"hidden":false,"merged":[[32,14,33,14],[32,15,33,15],[32,16,33,16],[32,17,33,17],[32,13,33,13],[42,34,42,36],[25,3,25,4],[26,1,27,2],[26,3,27,4],[23,1,23,2],[23,3,23,4],[34,34,34,36],[36,9,36,10],[38,9,38,10],[38,1,38,2],[41,1,41,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[24,1,24,2],[24,3,24,4],[25,1,25,2],[18,8,18,13],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[4,1,5,1],[2,23,3,25],[2,26,3,29],[2,22,4,22],[2,21,4,21],[2,20,4,20],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,36,4,37],[6,8,6,9],[6,10,6,11],[6,12,6,13],[8,8,8,9],[8,10,8,11],[8,12,8,13],[7,8,7,9],[7,10,7,11],[7,12,7,13],[2,19,4,19],[4,10,4,13],[32,6,33,6],[40,9,41,10],[40,11,41,11],[37,9,37,10],[4,34,4,35],[12,10,12,11],[12,12,12,13],[11,8,11,9],[11,10,11,11],[11,12,11,13],[14,8,14,9],[14,10,14,11],[14,12,14,13],[13,8,13,9],[13,10,13,11],[13,12,13,13],[32,11,33,11],[32,12,33,12],[34,9,34,10],[35,9,35,10],[32,7,33,7],[9,12,9,13],[12,8,12,9],[15,8,15,9],[15,10,15,11],[15,12,15,13],[10,8,10,9],[10,10,10,11],[10,12,10,13],[17,2,17,7],[18,2,18,4],[18,5,18,7],[9,8,9,9],[9,10,9,11],[47,1,47,2],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3]]}
[]
[]
[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",null,null,"Sigma"]
[]
[null,"i","j = 1 (Inspector A)",null,"j = 2 (Inspector B)",null,"j = 3 (Inspector C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part (i)","Inspector (j)","Repeatability","Part (i)","Inspector (j)","Repeatability","TOTAL"]
[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,null,null,{"$f":"IF(VLOOKUP(U6,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U6,$B$7:$H$16,2))","v":""},1,1,1,{"$f":"IF(T6=\"\",\"\",SUMIF($U$6:$U$65,\"=\"&U6,$T$6:$T$65)/($D$25*$D$27))","v":""},{"$f":"IF(T6=\"\",\"\",SUMIF($V$6:$V$65,\"=\"&V6,$T$6:$T$65)/($D$26*$D$27))","v":""},{"$f":"IF(T6=\"\",\"\",SUMIFS($T$6:$T$65,$U$6:$U$65,\"=\"&U6,$V$6:$V$65,\"=\"&V6)/($D$27))","v":""},{"$f":"IF(T6=\"\",\"\",(X6-$F$19)^2)","v":""},{"$f":"IF(Y6=\"\",\"\",(Y6-$F$19)^2)","v":""},{"$f":"IF(T6=\"\",\"\",(T6-Z6)^2)","v":""},{"$f":"IF(T6=\"\",\"\",(T6-$F$19)^2)","v":""}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U7,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U7,$B$7:$H$16,3))","v":""},1,1,2,"","","",{"$f":"IF(T7=\"\",\"\",(X7-$F$19)^2)","v":""},{"$f":"IF(Y7=\"\",\"\",(Y7-$F$19)^2)","v":""},{"$f":"IF(T7=\"\",\"\",(T7-Z7)^2)","v":""},{"$f":"IF(T7=\"\",\"\",(T7-$F$19)^2)","v":""}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U8,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U8,$B$7:$H$16,2))","v":""},2,1,1,"","","","","","",""]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U9,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U9,$B$7:$H$16,3))","v":""},2,1,2,"","","","","","",""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U10,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U10,$B$7:$H$16,2))","v":""},3,1,1,"","","","","","",""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U11,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U11,$B$7:$H$16,3))","v":""},3,1,2,"","","","","","",""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U12,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U12,$B$7:$H$16,2))","v":""},4,1,1,"","","","","","",""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U13,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U13,$B$7:$H$16,3))","v":""},4,1,2,"","","","","","",""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U14,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U14,$B$7:$H$16,2))","v":""},5,1,1,"","","","","","",""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U15,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U15,$B$7:$H$16,3))","v":""},5,1,2,"","","","","","",""]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U16,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U16,$B$7:$H$16,2))","v":""},6,1,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U17,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U17,$B$7:$H$16,3))","v":""},6,1,2,"","","","","","",""]
[null,null,"All Inpectors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U18,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U18,$B$7:$H$16,2))","v":""},7,1,1,"","","","","","",""]
[null,null,"X-Bar [j1j2j3]",null,null,{"$f":"IF(C7=\"\",\"\",AVERAGE(C7:H16))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U19,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U19,$B$7:$H$16,3))","v":""},7,1,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U20,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U20,$B$7:$H$16,2))","v":""},8,1,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U21,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U21,$B$7:$H$16,3))","v":""},8,1,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U22,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U22,$B$7:$H$16,2))","v":""},9,1,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U23,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U23,$B$7:$H$16,3))","v":""},9,1,2,"","","","","","",""]
[null,"∆T",null,{"$f":"IF(Visualization!K15=\"\",\"No specification limits!\",Visualization!K16)","v":"No specification limits!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U24,$B$7:$H$16,2)=\"\",\"\",VLOOKUP(U24,$B$7:$H$16,2))","v":""},10,1,1,"","","","","","",""]
[null,"Inspectors (j)",null,{"$f":"IF(COUNT(C7,E7,G7)=0,\"\",COUNT(C7,E7,G7))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U25,$B$7:$H$16,3)=\"\",\"\",VLOOKUP(U25,$B$7:$H$16,3))","v":""},10,1,2,"","","","","","",""]
[null,"Speciments (i)",null,{"$f":"IF(COUNT(C7:C16)=0,\"\",COUNT(C7:C16))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U26,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U26,$B$7:$H$16,4))","v":""},1,2,1,"","","","","","",""]
[null,"Amount of measurements (r)",null,{"$f":"IF(COUNT(C7:D7)=0,\"\",COUNT(C7:D7))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U27,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U27,$B$7:$H$16,5))","v":""},1,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U28,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U28,$B$7:$H$16,4))","v":""},2,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U29,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U29,$B$7:$H$16,5))","v":""},2,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U30,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U30,$B$7:$H$16,4))","v":""},3,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U31,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U31,$B$7:$H$16,5))","v":""},3,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U32,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U32,$B$7:$H$16,4))","v":""},4,2,1,"","","","","","",""]
[null,null,null,"i","j","r","TOTAL","i *  j",null,null,null,"VT","VP","VE","TOTAL Variation","IA","Reproducibility","R&R",null,{"$f":"IF(VLOOKUP(U33,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U33,$B$7:$H$16,5))","v":""},4,2,2,"","","","","","",""]
[null,"Amount",null,{"$f":"D26","v":""},{"$f":"D25","v":""},{"$f":"D27","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U34,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U34,$B$7:$H$16,4))","v":""},5,2,1,"","","","","","",""]
[null,"Sum of Squares",null,{"$f":"IF(SUM(AA6:AA65)=0,\"\",SUM(AA6:AA65))","v":""},{"$f":"IF(SUM(AB6:AB65)=0,\"\",SUM(AB6:AB65))","v":""},{"$f":"IF(SUM(AC6:AC65)=0,\"\",SUM(AC6:AC65))","v":""},{"$f":"IF(SUM(AD6:AD65)=0,\"\",SUM(AD6:AD65))","v":""},{"$f":"IF(SUM(D35:G35)=0,\"\",G35-F35-E35-D35)","v":""},null,"Variance",null,{"$f":"IF(D37=\"\",\"\",MAX(0,,(D37-H37)/(E34*F34)))","v":""},{"$f":"IF(E37=\"\",\"\",MAX(0,(E37-H37)/(D34*F34)))","v":""},{"$f":"IF(F37=\"\",\"\",MAX(0,,F37))","v":""},{"$f":"IF(L35=\"\",\"\",R35+L35)","v":""},{"$f":"IF(F37=\"\",\"\",MAX(0,(H37-F37)/F34))","v":""},{"$f":"IF(M35=\"\",\"\",M35+P35)","v":""},{"$f":"IF(N35=\"\",\"\",Q35+N35)","v":""},null,{"$f":"IF(VLOOKUP(U35,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U35,$B$7:$H$16,5))","v":""},5,2,2,"","","","","","",""]
[null,"Degrees of Freedom",null,{"$f":"IF(D34=\"\",\"\",D34-1)","v":""},{"$f":"IF(E34=\"\",\"\",E34-1)","v":""},{"$f":"IF(F35=\"\",\"\",(D34*E34*(F34-1)))","v":""},{"$f":"IF(G35=\"\",\"\",(D34*E34*F34)-1)","v":""},{"$f":"IF(D36=\"\",\"\",D36*E36)","v":""},null,"%Contribution",null,{"$f":"IF(L35=\"\",\"\",L35/($R$35+$L$35))","v":""},"","","","","","",null,{"$f":"IF(VLOOKUP(U36,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U36,$B$7:$H$16,4))","v":""},6,2,1,"","","","","","",""]
[null,"Mean Squares",null,{"$f":"IF(D35=\"\",\"\",D35/D36)","v":""},{"$f":"IF(E35=\"\",\"\",E35/E36)","v":""},{"$f":"IF(F35=\"\",\"\",IF(F36=0,0,F35/F36))","v":""},null,{"$f":"IF(F37=\"\",\"\",IF(F37=0,0,H35/H36))","v":""},null,"Sigma (5,15)",null,{"$f":"IF(L35=\"\",\"\",SQRT(L35))","v":""},{"$f":"IF(M35=\"\",\"\",5.15*SQRT(M35))","v":""},{"$f":"IF(N35=\"\",\"\",5.15*SQRT(N35))","v":""},{"$f":"IF(O35=\"\",\"\",SQRT(O35))","v":""},{"$f":"IF(P35=\"\",\"\",5.15*SQRT(P35))","v":""},{"$f":"IF(Q35=\"\",\"\",SQRT(Q35))","v":""},{"$f":"IF(M37=\"\",\"\",IF(H39>D42,SQRT(N37^2+M37^2),SQRT(N37^2+M37^2+P37^2)))","v":""},null,{"$f":"IF(VLOOKUP(U37,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U37,$B$7:$H$16,5))","v":""},6,2,2,"","","","","","",""]
[null,"F",null,{"$f":"IF(D34=\"\",\"\",IF(H37=0,0,D37/H37))","v":""},{"$f":"IF(E37=\"\",\"\",IF(H37=0,0,E37/H37))","v":""},null,null,{"$f":"IF(F37=\"\",\"\",IF(H37=0,0,H37/F37))","v":""},null,"Sigma",null,{"$f":"L37","v":""},{"$f":"IF(M35=\"\",\"\",SQRT(M35))","v":""},{"$f":"IF(N35=\"\",\"\",SQRT(N35))","v":""},{"$f":"IF(O35=\"\",\"\",SQRT(O35))","v":""},{"$f":"IF(P35=\"\",\"\",SQRT(P35))","v":""},{"$f":"IF(Q35=\"\",\"\",SQRT(Q35))","v":""},{"$f":"IF(M38=\"\",\"\",IF(H40>D43,SQRT(N38^2+M38^2),SQRT(N38^2+M38^2+P38^2)))","v":""},null,{"$f":"IF(VLOOKUP(U38,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U38,$B$7:$H$16,4))","v":""},7,2,1,{"$f":"IF(T38=\"\",\"\",SUMIF($U$6:$U$65,\"=\"&U38,$T$6:$T$65)/($D$25*$D$27))","v":""},{"$f":"IF(T38=\"\",\"\",SUMIF($V$6:$V$65,\"=\"&V38,$T$6:$T$65)/($D$26*$D$27))","v":""},"","","","",""]
[null,"P-Value",null,{"$f":"IF(D34=\"\",\"\",IF(D38<=0,0,1-_xlfn.F.DIST(D38,D36,H36,TRUE)))","v":""},{"$f":"IF(E36=\"\",\"\",IF(E38<=0,0,1-_xlfn.F.DIST(E38,E36,H36,TRUE)))","v":""},null,null,{"$f":"IF(F36=\"\",\"\",IF(H38<=0,0,1-_xlfn.F.DIST(H38,H36,F36,TRUE)))","v":""},null,"%Study Varriation",null,{"$f":"IF(L37=\"\",\"\",L37/$O$37)","v":""},{"$f":"IF(M37=\"\",\"\",M37/$O$37)","v":""},{"$f":"IF(N37=\"\",\"\",N37/$O$37)","v":""},{"$f":"IF(O37=\"\",\"\",O37/$O$37)","v":""},null,null,null,null,{"$f":"IF(VLOOKUP(U39,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U39,$B$7:$H$16,5))","v":""},7,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U40,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U40,$B$7:$H$16,4))","v":""},8,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,"No. of Distinct Categories",null,{"$f":"IF(M35=\"\",\"\",MAX(1,TRUNC(SQRT(2*(1/((R47/100)^2))-1))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U41,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U41,$B$7:$H$16,5))","v":""},8,2,2,"","","","","","",""]
[null,"Alpha to test interaction:",null,0.05,{"$f":"IF(H39=\"\",\"\",IF(H39>D42,\"H0 is false\",\"H0 is true\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U42,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U42,$B$7:$H$16,4))","v":""},9,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U43,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U43,$B$7:$H$16,5))","v":""},9,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%EV",{"$f":"IF(N37=\"\",\"\",(100/D24)*5.15*SQRT(N35))","v":""},null,{"$f":"IF(VLOOKUP(U44,$B$7:$H$16,4)=\"\",\"\",VLOOKUP(U44,$B$7:$H$16,4))","v":""},10,2,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%AV",{"$f":"IF(M37=\"\",\"\",(100/D24)*5.15*SQRT(M35))","v":""},null,{"$f":"IF(VLOOKUP(U45,$B$7:$H$16,5)=\"\",\"\",VLOOKUP(U45,$B$7:$H$16,5))","v":""},10,2,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%IA",{"$f":"IF(P37=\"\",\"\",(100/D24)*5.15*SQRT(P35))","v":""},null,{"$f":"IF(VLOOKUP(U46,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U46,$B$7:$H$16,6))","v":""},1,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%R&R",{"$f":"IF(R37=\"\",\"\",ROUND(((R37/D24)*100),1))","v":""},null,{"$f":"IF(VLOOKUP(U47,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U47,$B$7:$H$16,7))","v":""},1,3,2,"","","","","","",""]
[null,"Inspectors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U48,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U48,$B$7:$H$16,6))","v":""},2,3,1,"","","","","","",""]
[null,"Nr.","Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U49,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U49,$B$7:$H$16,7))","v":""},2,3,2,"","","","","","",""]
[null,"j1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U50,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U50,$B$7:$H$16,6))","v":""},3,3,1,"","","","","","",""]
[null,"j2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U51,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U51,$B$7:$H$16,7))","v":""},3,3,2,"","","","","","",""]
[null,"j3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U52,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U52,$B$7:$H$16,6))","v":""},4,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U53,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U53,$B$7:$H$16,7))","v":""},4,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U54,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U54,$B$7:$H$16,6))","v":""},5,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U55,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U55,$B$7:$H$16,7))","v":""},5,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U56,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U56,$B$7:$H$16,6))","v":""},6,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U57,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U57,$B$7:$H$16,7))","v":""},6,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U58,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U58,$B$7:$H$16,6))","v":""},7,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U59,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U59,$B$7:$H$16,7))","v":""},7,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U60,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U60,$B$7:$H$16,6))","v":""},8,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U61,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U61,$B$7:$H$16,7))","v":""},8,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U62,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U62,$B$7:$H$16,6))","v":""},9,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U63,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U63,$B$7:$H$16,7))","v":""},9,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U64,$B$7:$H$16,6)=\"\",\"\",VLOOKUP(U64,$B$7:$H$16,6))","v":""},10,3,1,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(U65,$B$7:$H$16,7)=\"\",\"\",VLOOKUP(U65,$B$7:$H$16,7))","v":""},10,3,2,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summ [Σ]",{"$f":"IF(SUM(X6:X65)=0,\"\",SUM(X6:X65))","v":""},"","","","","",""]

{"sheet":"Macro","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,1,8,8],[13,4,14,5],[13,7,15,8],[13,9,15,9],[13,10,15,11],[15,4,15,5]]}
[]
[]
[]
[]
[]
[null,"The integrated macro in this Worksheet are not required for the calculation. The macro just handle an easy way to print the a .pdf of the register \"Visualization\"."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Export Worksheet \"Visualization\" as PDF",null,null,"The .pdf will be saved in the same folder as the excel file."]

{"sheet":"References","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,1,9,9],[13,1,15,4]]}
[]
[]
[]
[]
[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. 1785."]

{"sheet":"Directories","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Resolution","Line","Location","Unit","Measurement system"]
[null,1,null,null,"µm","Height Gauge"]
[null,0.5,null,null,"mm","Precision scale"]
[null,0.1,null,null,"m"]
[null,0.05,null,null,"Nm"]
[null,0.01,null,null,"A"]
[null,5.0000000000000001E-3,null,null,"mA"]
[null,1E-3,null,null,"V"]
[null,5.0000000000000001E-4,null,null,"Pa/s"]
[null,1E-4,null,null,"µVs"]
[null,5.0000000000000002E-5,null,null,"bar"]
[null,1.0000000000000001E-5,null,null,"mg"]
[null,null,null,null,"g"]
[null,null,null,null,"%"]
[null,null,null,null,"Pixel"]