{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Guide","Visualization","Graphics","Calculation","Macro","References","Directories"],"not_rendered":{"charts":8,"images":15,"macros":1,"external_links":0,"defined_names":6,"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":193,"n_cols":7,"rows_kept":193,"cut":false,"hidden":false,"merged":[[30,3,31,7],[6,2,7,8],[12,2,12,7],[14,4,14,6],[15,4,15,6],[16,4,16,6],[112,1,112,2],[112,3,112,7],[32,3,33,7],[34,3,37,7],[38,3,39,7],[40,3,41,7],[42,3,42,7],[48,2,49,7],[50,2,50,7],[51,2,51,7],[74,2,75,7],[111,1,111,2],[111,3,111,7],[52,2,53,7],[161,6,163,8],[192,1,194,7],[146,1,146,2],[146,3,146,7],[147,1,147,2],[147,3,147,7],[152,1,152,6],[156,1,157,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 cycle 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% and bigger than 30%"]
[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":[[0,0,0,16],[14,4,14,5],[11,2,11,5],[52,12,52,13],[47,5,47,6],[47,7,47,8],[49,13,49,14],[47,13,47,14],[24,13,28,14],[46,7,46,8],[46,5,46,6],[47,10,47,11],[48,10,48,11],[48,2,49,4],[48,13,48,14],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[6,6,6,10],[7,6,7,10],[8,6,8,10],[9,6,9,7],[11,6,11,7],[18,9,18,14],[10,6,10,7],[55,12,55,14],[24,6,28,7],[50,5,50,6],[55,6,55,8],[54,6,54,7],[52,6,52,8],[49,10,49,11],[48,5,49,6],[48,7,49,8],[52,4,52,5],[15,10,15,11],[14,2,14,3],[13,2,13,3],[56,2,56,3],[55,2,55,3],[55,4,55,5],[50,2,50,4],[52,2,52,3],[47,2,47,4],[15,2,15,3],[13,4,13,11],[14,8,14,9],[14,10,14,11],[55,9,55,10],[54,9,54,10],[15,6,15,9]]}
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,1,{"$f":"IF(Calculation!C6=\"\",\"\",FIXED(Calculation!C6,LEN($G$11)-2,FALSE))","v":""},11,{"$f":"IF(Calculation!C16=\"\",\"\",FIXED(Calculation!C16,LEN($G$11)-2,FALSE))","v":""},21,{"$f":"IF(Calculation!C26=\"\",\"\",FIXED(Calculation!C26,LEN($G$11)-2,FALSE))","v":""},null,1,{"$f":"IF(Calculation!D6=\"\",\"\",FIXED(Calculation!D6,LEN($G$11)-2,FALSE))","v":""},11,{"$f":"IF(Calculation!D16=\"\",\"\",FIXED(Calculation!D16,LEN($G$11)-2,FALSE))","v":""},21,{"$f":"IF(Calculation!D26=\"\",\"\",FIXED(Calculation!D26,LEN($G$11)-2,FALSE))","v":""},null,0]
[0,null,2,{"$f":"IF(Calculation!C7=\"\",\"\",FIXED(Calculation!C7,LEN($G$11)-2,FALSE))","v":""},12,{"$f":"IF(Calculation!C17=\"\",\"\",FIXED(Calculation!C17,LEN($G$11)-2,FALSE))","v":""},22,{"$f":"IF(Calculation!C27=\"\",\"\",FIXED(Calculation!C27,LEN($G$11)-2,FALSE))","v":""},null,2,{"$f":"IF(Calculation!D7=\"\",\"\",FIXED(Calculation!D7,LEN($G$11)-2,FALSE))","v":""},12,{"$f":"IF(Calculation!D17=\"\",\"\",FIXED(Calculation!D17,LEN($G$11)-2,FALSE))","v":""},22,{"$f":"IF(Calculation!D27=\"\",\"\",FIXED(Calculation!D27,LEN($G$11)-2,FALSE))","v":""},null,0]
[0,null,3,{"$f":"IF(Calculation!C8=\"\",\"\",FIXED(Calculation!C8,LEN($G$11)-2,FALSE))","v":""},13,{"$f":"IF(Calculation!C18=\"\",\"\",FIXED(Calculation!C18,LEN($G$11)-2,FALSE))","v":""},23,{"$f":"IF(Calculation!C28=\"\",\"\",FIXED(Calculation!C28,LEN($G$11)-2,FALSE))","v":""},null,3,{"$f":"IF(Calculation!D8=\"\",\"\",FIXED(Calculation!D8,LEN($G$11)-2,FALSE))","v":""},13,{"$f":"IF(Calculation!D18=\"\",\"\",FIXED(Calculation!D18,LEN($G$11)-2,FALSE))","v":""},23,{"$f":"IF(Calculation!D28=\"\",\"\",FIXED(Calculation!D28,LEN($G$11)-2,FALSE))","v":""},null,{"$f":"IF($M$56=\"NG\",1,0)","v":0}]
[0,null,4,{"$f":"IF(Calculation!C9=\"\",\"\",FIXED(Calculation!C9,LEN($G$11)-2,FALSE))","v":""},14,{"$f":"IF(Calculation!C19=\"\",\"\",FIXED(Calculation!C19,LEN($G$11)-2,FALSE))","v":""},24,{"$f":"IF(Calculation!C29=\"\",\"\",FIXED(Calculation!C29,LEN($G$11)-2,FALSE))","v":""},null,4,{"$f":"IF(Calculation!D9=\"\",\"\",FIXED(Calculation!D9,LEN($G$11)-2,FALSE))","v":""},14,{"$f":"IF(Calculation!D19=\"\",\"\",FIXED(Calculation!D19,LEN($G$11)-2,FALSE))","v":""},24,{"$f":"IF(Calculation!D29=\"\",\"\",FIXED(Calculation!D29,LEN($G$11)-2,FALSE))","v":""},null,0]
[0,null,5,{"$f":"IF(Calculation!C10=\"\",\"\",FIXED(Calculation!C10,LEN($G$11)-2,FALSE))","v":""},15,{"$f":"IF(Calculation!C20=\"\",\"\",FIXED(Calculation!C20,LEN($G$11)-2,FALSE))","v":""},25,{"$f":"IF(Calculation!C30=\"\",\"\",FIXED(Calculation!C30,LEN($G$11)-2,FALSE))","v":""},null,5,{"$f":"IF(Calculation!D10=\"\",\"\",FIXED(Calculation!D10,LEN($G$11)-2,FALSE))","v":""},15,{"$f":"IF(Calculation!D20=\"\",\"\",FIXED(Calculation!D20,LEN($G$11)-2,FALSE))","v":""},25,{"$f":"IF(Calculation!D30=\"\",\"\",FIXED(Calculation!D30,LEN($G$11)-2,FALSE))","v":""},null,0]
[0,null,6,{"$f":"IF(Calculation!C11=\"\",\"\",FIXED(Calculation!C11,LEN($G$11)-2,FALSE))","v":""},16,{"$f":"IF(Calculation!C21=\"\",\"\",FIXED(Calculation!C21,LEN($G$11)-2,FALSE))","v":""},{"$f":"IF(Calculation!E11=\"\",\"\",FIXED(Calculation!E11,LEN($G$11)-2,FALSE))","v":""},null,null,6,{"$f":"IF(Calculation!D11=\"\",\"\",FIXED(Calculation!D11,LEN($G$11)-2,FALSE))","v":""},16,{"$f":"IF(Calculation!D21=\"\",\"\",FIXED(Calculation!D21,LEN($G$11)-2,FALSE))","v":""},null,null,null,0]
[0,null,7,{"$f":"IF(Calculation!C12=\"\",\"\",FIXED(Calculation!C12,LEN($G$11)-2,FALSE))","v":""},17,{"$f":"IF(Calculation!C22=\"\",\"\",FIXED(Calculation!C22,LEN($G$11)-2,FALSE))","v":""},null,null,null,7,{"$f":"IF(Calculation!D12=\"\",\"\",FIXED(Calculation!D12,LEN($G$11)-2,FALSE))","v":""},17,{"$f":"IF(Calculation!D22=\"\",\"\",FIXED(Calculation!D22,LEN($G$11)-2,FALSE))","v":""},null,null,null,0]
[0,null,8,{"$f":"IF(Calculation!C13=\"\",\"\",FIXED(Calculation!C13,LEN($G$11)-2,FALSE))","v":""},18,{"$f":"IF(Calculation!C23=\"\",\"\",FIXED(Calculation!C23,LEN($G$11)-2,FALSE))","v":""},null,null,null,8,{"$f":"IF(Calculation!D13=\"\",\"\",FIXED(Calculation!D13,LEN($G$11)-2,FALSE))","v":""},18,{"$f":"IF(Calculation!D23=\"\",\"\",FIXED(Calculation!D23,LEN($G$11)-2,FALSE))","v":""},null,null,null,0]
[0,null,9,{"$f":"IF(Calculation!C14=\"\",\"\",FIXED(Calculation!C14,LEN($G$11)-2,FALSE))","v":""},19,{"$f":"IF(Calculation!C24=\"\",\"\",FIXED(Calculation!C24,LEN($G$11)-2,FALSE))","v":""},null,null,null,9,{"$f":"IF(Calculation!D14=\"\",\"\",FIXED(Calculation!D14,LEN($G$11)-2,FALSE))","v":""},19,{"$f":"IF(Calculation!D24=\"\",\"\",FIXED(Calculation!D24,LEN($G$11)-2,FALSE))","v":""},null,null,null,0]
[0,null,10,{"$f":"IF(Calculation!C15=\"\",\"\",FIXED(Calculation!C15,LEN($G$11)-2,FALSE))","v":""},20,{"$f":"IF(Calculation!C25=\"\",\"\",FIXED(Calculation!C25,LEN($G$11)-2,FALSE))","v":""},null,null,null,10,{"$f":"IF(Calculation!D15=\"\",\"\",FIXED(Calculation!D15,LEN($G$11)-2,FALSE))","v":""},20,{"$f":"IF(Calculation!D25=\"\",\"\",FIXED(Calculation!D25,LEN($G$11)-2,FALSE))","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,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,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,"Variance",null,"Sigma",null,null,null,null,null,0.1,null,null,0]
[0,null,"Repeatability",null,null,{"$f":"Calculation!L38","v":""},null,{"$f":"Calculation!L42","v":""},null,"%EV =",{"$f":"Calculation!U37","v":""},null,{"$f":"K48","v":""},{"$f":"K48","v":""},null,null,0]
[0,null,"Repeatability & Reproductivity",null,null,{"$f":"Calculation!L38","v":""},null,{"$f":"Calculation!L42","v":""},null,null,null,null,{"$f":"K49","v":0},{"$f":"K49","v":0},null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K50","v":0},{"$f":"K50","v":0},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":"Calculation!L46","v":""},null,{"$f":"Calculation!L46","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!U37","v":""},null,{"$f":"Calculation!U37","v":""},null,null,{"$f":"Calculation!U37","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":24,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part","X-Bar","Part","X-Bar","Part","X-Bar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i1",{"$f":"IF(Calculation!M6=\"\",\"\",Calculation!M6)","v":""},"i11",{"$f":"IF(Calculation!M16=\"\",\"\",Calculation!M16)","v":""},"i21",{"$f":"IF(Calculation!M26=\"\",\"\",Calculation!M26)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i2",{"$f":"IF(Calculation!M7=\"\",\"\",Calculation!M7)","v":""},"i12",{"$f":"IF(Calculation!M17=\"\",\"\",Calculation!M17)","v":""},"i22",{"$f":"IF(Calculation!M27=\"\",\"\",Calculation!M27)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i3",{"$f":"IF(Calculation!M8=\"\",\"\",Calculation!M8)","v":""},"i13",{"$f":"IF(Calculation!M18=\"\",\"\",Calculation!M18)","v":""},"i23",{"$f":"IF(Calculation!M28=\"\",\"\",Calculation!M28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i4",{"$f":"IF(Calculation!M9=\"\",\"\",Calculation!M9)","v":""},"i14",{"$f":"IF(Calculation!M19=\"\",\"\",Calculation!M19)","v":""},"i24",{"$f":"IF(Calculation!M29=\"\",\"\",Calculation!M29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i5",{"$f":"IF(Calculation!M10=\"\",\"\",Calculation!M10)","v":""},"i15",{"$f":"IF(Calculation!M20=\"\",\"\",Calculation!M20)","v":""},"i25",{"$f":"IF(Calculation!M30=\"\",\"\",Calculation!M30)","v":""},null,"x quer quer",{"$f":"IF(P41=\"\",\"\",AVERAGE(P41:P50,R41:R50,T41:T45))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i6",{"$f":"IF(Calculation!M11=\"\",\"\",Calculation!M11)","v":""},"i16",{"$f":"IF(Calculation!M21=\"\",\"\",Calculation!M21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i7",{"$f":"IF(Calculation!M12=\"\",\"\",Calculation!M12)","v":""},"i17",{"$f":"IF(Calculation!M22=\"\",\"\",Calculation!M22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i8",{"$f":"IF(Calculation!M13=\"\",\"\",Calculation!M13)","v":""},"i18",{"$f":"IF(Calculation!M23=\"\",\"\",Calculation!M23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i9",{"$f":"IF(Calculation!M14=\"\",\"\",Calculation!M14)","v":""},"i19",{"$f":"IF(Calculation!M24=\"\",\"\",Calculation!M24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i10",{"$f":"IF(Calculation!M15=\"\",\"\",Calculation!M15)","v":""},"i20",{"$f":"IF(Calculation!M25=\"\",\"\",Calculation!M25)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X - UEL",{"$f":"IF(P41=\"\",\"\",$W$45+($W$64*(IF(COUNT(2)=2,$W$58,$W$59))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X - LEL",{"$f":"IF(P41=\"\",\"\",$W$45-($W$64*(IF(COUNT(2)=2,$W$58,$W$59))))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part","R","Part","R","Part","R",null,"n","A2","D4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i1",{"$f":"IF(Calculation!R6=\"\",\"\",Calculation!R6)","v":""},"i11",{"$f":"IF(Calculation!R16=\"\",\"\",Calculation!R16)","v":""},"i21",{"$f":"IF(Calculation!R26=\"\",\"\",Calculation!R26)","v":""},null,2,1.88,3.2669999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i2",{"$f":"IF(Calculation!R7=\"\",\"\",Calculation!R7)","v":""},"i12",{"$f":"IF(Calculation!R17=\"\",\"\",Calculation!R17)","v":""},"i22",{"$f":"IF(Calculation!R27=\"\",\"\",Calculation!R27)","v":""},null,3,1.0229999999999999,2.5739999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i3",{"$f":"IF(Calculation!R8=\"\",\"\",Calculation!R8)","v":""},"i13",{"$f":"IF(Calculation!R18=\"\",\"\",Calculation!R18)","v":""},"i23",{"$f":"IF(Calculation!R28=\"\",\"\",Calculation!R28)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i4",{"$f":"IF(Calculation!R9=\"\",\"\",Calculation!R9)","v":""},"i14",{"$f":"IF(Calculation!R19=\"\",\"\",Calculation!R19)","v":""},"i24",{"$f":"IF(Calculation!R29=\"\",\"\",Calculation!R29)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i5",{"$f":"IF(Calculation!R10=\"\",\"\",Calculation!R10)","v":""},"i15",{"$f":"IF(Calculation!R20=\"\",\"\",Calculation!R20)","v":""},"i25",{"$f":"IF(Calculation!R30=\"\",\"\",Calculation!R30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i6",{"$f":"IF(Calculation!R11=\"\",\"\",Calculation!R11)","v":""},"i16",{"$f":"IF(Calculation!R21=\"\",\"\",Calculation!R21)","v":""},null,{"$f":"IF(Calculation!R31=\"\",\"\",Calculation!R31)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i7",{"$f":"IF(Calculation!R12=\"\",\"\",Calculation!R12)","v":""},"i17",{"$f":"IF(Calculation!R22=\"\",\"\",Calculation!R22)","v":""},null,null,null,"R ",{"$f":"IF(P58=\"\",\"\",AVERAGE(T58:T62,R58:R67,P58:P67))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i8",{"$f":"IF(Calculation!R13=\"\",\"\",Calculation!R13)","v":""},"i18",{"$f":"IF(Calculation!R23=\"\",\"\",Calculation!R23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i9",{"$f":"IF(Calculation!R14=\"\",\"\",Calculation!R14)","v":""},"i19",{"$f":"IF(Calculation!R24=\"\",\"\",Calculation!R24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i10",{"$f":"IF(Calculation!R15=\"\",\"\",Calculation!R15)","v":""},"i20",{"$f":"IF(Calculation!R25=\"\",\"\",Calculation!R25)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R - UEL",{"$f":"IF(P58=\"\",\"\",W64*IF(COUNT(2)=2,X58,X59))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m1","m2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",{"$f":"IF(Calculation!K6=\"\",\"\",MAX(Calculation!K6:K30))","v":""},{"$f":"IF(Calculation!L6=\"\",\"\",MAX(Calculation!L6:L30))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",{"$f":"IF(Calculation!K6=\"\",\"\",QUARTILE(Calculation!K6:K30,3))","v":""},{"$f":"IF(Calculation!L6=\"\",\"\",QUARTILE(Calculation!L6:L30,3))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Med",{"$f":"IF(Calculation!K6=\"\",\"\",MEDIAN(Calculation!K6:K30))","v":""},{"$f":"IF(Calculation!L6=\"\",\"\",MEDIAN(Calculation!L6:L30))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"IF(Calculation!K6=\"\",\"\",QUARTILE(Calculation!K6:K30,1))","v":""},{"$f":"IF(Calculation!L6=\"\",\"\",QUARTILE(Calculation!L6:L30,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(Calculation!K6=\"\",\"\",MIN(Calculation!K6:K30))","v":""},{"$f":"IF(Calculation!L6=\"\",\"\",MIN(Calculation!L6:L30))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum - Q3",{"$f":"IF(V76=\"\",\"\",V76-V80)","v":""},{"$f":"IF(W76=\"\",\"\",W76-W80)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1-Minimum",{"$f":"IF(V76=\"\",\"\",V79-V80)","v":""},{"$f":"IF(W76=\"\",\"\",W79-W80)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m1","m2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"V80","v":""},{"$f":"W80","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q1;Min)",{"$f":"IF(V84=\"\",\"\",V79-V80)","v":""},{"$f":"IF(W84=\"\",\"\",W79-W80)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Med;Q1)",{"$f":"IF(V84=\"\",\"\",V78-V79)","v":""},{"$f":"IF(W84=\"\",\"\",W78-W79)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Med)",{"$f":"IF(V84=\"\",\"\",V77-V78)","v":""},{"$f":"IF(W84=\"\",\"\",W77-W78)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Max)",{"$f":"IF(V84=\"\",\"\",V76-V77)","v":""},{"$f":"IF(W84=\"\",\"\",W76-W77)","v":""}]

{"sheet":"Calculation","index":3,"n_rows":46,"n_cols":21,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,26,3,27],[3,28,3,29],[2,17,4,17],[35,16,36,16],[35,17,36,17],[33,26,33,28],[1,18,3,18],[3,1,4,1],[38,1,38,2],[38,3,38,4],[39,1,39,2],[33,2,33,3],[33,4,33,5],[3,2,3,3],[3,4,3,5],[32,5,32,7],[31,2,31,3],[33,6,33,7],[41,26,41,28],[39,3,39,4],[40,1,41,2],[40,3,41,4],[37,1,37,2],[37,3,37,4],[35,9,41,10],[38,19,39,19],[38,20,39,20],[2,9,4,9],[2,10,3,11],[2,12,4,12],[2,13,4,13],[2,14,4,14],[2,15,4,15],[2,16,4,16],[28,18,28,20],[36,20,37,20],[36,19,37,19],[42,9,43,10],[35,11,35,12],[35,13,35,15],[44,9,46,10],[45,11,46,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,"i","Values",null,"X-Bar","(X1i - Xje)\n^2","(X2i - Xje)\n^2","E","T","Range"]
[null,"i","j = 1 (Inspection A)"]
[null,null,"m = 1 (Row A)","m =  2 (Row B)",null,null,null,null,null,null,"m1","m2"]
[null,1,null,null,null,null,null,null,null,1,{"$f":"IF(C6=\"\",\"\",C6)","v":""},{"$f":"IF(D6=\"\",\"\",D6)","v":""},{"$f":"IF(K6=\"\",\"\",AVERAGE(K6:L6))","v":""},{"$f":"IF(K6=\"\",\"\",(K6-M6)^2)","v":""},{"$f":"IF(L6=\"\",\"\",(L6-M6)^2)","v":""},{"$f":"IF(K6=\"\",\"\",N6+O6)","v":""},{"$f":"IF(K6=\"\",\"\",(AVERAGE(K6:L6)-AVERAGE($K$6:$L$30))^2)","v":""},{"$f":"IF(K6=\"\",\"\",MAX(K6:L6)-MIN(K6:L6))","v":""}]
[null,2,null,null,null,null,null,null,null,2,"","",{"$f":"IF(K7=\"\",\"\",AVERAGE(K7:L7))","v":""},{"$f":"IF(K7=\"\",\"\",(K7-M7)^2)","v":""},{"$f":"IF(L7=\"\",\"\",(L7-M7)^2)","v":""},{"$f":"IF(K7=\"\",\"\",N7+O7)","v":""},"",{"$f":"IF(K7=\"\",\"\",MAX(K7:L7)-MIN(K7:L7))","v":""}]
[null,3,null,null,null,null,null,null,null,3,"","",{"$f":"IF(K8=\"\",\"\",AVERAGE(K8:L8))","v":""},"","","","",""]
[null,4,null,null,null,null,null,null,null,4,"","","","","","","",""]
[null,5,null,null,null,null,null,null,null,5,"","","","","","","",""]
[null,6,null,null,null,null,null,null,null,6,"","","","","","","",""]
[null,7,null,null,null,null,null,null,null,7,"","","","","","","",""]
[null,8,null,null,null,null,null,null,null,8,"","","","","","","",""]
[null,9,null,null,null,null,null,null,null,9,"","","","","","","",""]
[null,10,null,null,null,null,null,null,null,10,"","","","","","","",""]
[null,11,null,null,null,null,null,null,null,11,"","","","","","","",""]
[null,12,null,null,null,null,null,null,null,12,"","","","","","","",""]
[null,13,null,null,null,null,null,null,null,13,"","","","","","","",""]
[null,14,null,null,null,null,null,null,null,14,"","","","","","","",""]
[null,15,null,null,null,null,null,null,null,15,"","","","","","","",""]
[null,16,null,null,null,null,null,null,null,16,"","","","","","","",""]
[null,17,null,null,null,null,null,null,null,17,"","","","","","","",""]
[null,18,null,null,null,null,null,null,null,18,"","","","","","","",""]
[null,19,null,null,null,null,null,null,null,19,"","","","","","","",""]
[null,20,null,null,null,null,null,null,null,20,"","","","","","","",""]
[null,21,null,null,null,null,null,null,null,21,"","","","","","","",""]
[null,22,null,null,null,null,null,null,null,22,"","","","","","","",""]
[null,23,null,null,null,null,null,null,null,23,"","","","","","","",""]
[null,24,null,null,null,null,null,null,null,24,"","","","","","","",""]
[null,25,null,null,null,null,null,null,null,25,"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summ [Σ]",{"$f":"IF(K6=\"\",\"\",SUM(P6:P30))","v":""},{"$f":"IF(K6=\"\",\"\",SUM(Q6:Q30))","v":""}]
[null,null,"All Inpectors"]
[null,null,"X-Bar [j1j2j3]",{"$f":"IF(C6=\"\",\"\",AVERAGE(C6:D30))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Based on Parts",null,"Measurementsystem",null,"Parts",null,null,null,"%R&R / %EV"]
[null,null,null,null,null,null,null,null,null,null,null,"Variance","EV","Variance","VT","PV",null,null,null,"%EV",{"$f":"IF(R38=\"\",\"\",ROUNDUP(R38,2))","v":""}]
[null,"∆T",null,{"$f":"IF(Visualization!K16=\"\",\"No specification limits!\",Visualization!K16)","v":0},null,null,null,null,null,null,null,{"$f":"IF(P31=\"\",\"\",P31/(D40*(D41-D39)))","v":""},{"$f":"IF(L38=\"\",\"\",5.15*SQRT(L38))","v":""},{"$f":"IF(Q31=\"\",\"\",Q31/(D40-1))","v":""},{"$f":"IF(P31=\"\",\"\",(N38-P31)/2)","v":""},{"$f":"IF(O38=\"\",\"\",5.15*SQRT(O38))","v":""},null,{"$f":"IF(M38=\"\",\"\",(M38/D38)*100)","v":""}]
[null,"Inspection (j)",null,1,null,null,null,null,null,null,null,"Sigma",null,"Sigma",null,null,null,null,null,"%R&R",{"$f":"IF(R38=\"\",\"\",ROUNDUP(R38,2))","v":""}]
[null,"Speciments (i)",null,{"$f":"IF(COUNT(C6:C30)=0,\"\",COUNT(C6:C30))","v":""},null,null,null,null,null,null,null,{"$f":"IF(L38=\"\",\"\",SQRT(L38))","v":""},null,{"$f":"IF(N38=\"\",\"\",SQRT(N38))","v":""}]
[null,"Amount of measurements (r)",null,2,null,null,null,null,null,null,null,"Sigma (5,15)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L40=\"\",\"\",L40*5.15)","v":""}]
[null,null,null,null,null,null,null,null,null,"Based on Spec",null,"TV"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38=\"No specification limits!\",\"\",D38/6)","v":0}]
[null,null,null,null,null,null,null,null,null,"No. of Distinct Categories",null,"Based Parts"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N38=\"\",\"\",MAX(1,TRUNC(SQRT(2*(1/((R38/100)^2))-1))))","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"]