{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Visualization","Values","Graphics","Calculation","Settings","Directories","References"],"not_rendered":{"charts":8,"images":11,"macros":1,"external_links":0,"defined_names":40,"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":192,"n_cols":4,"rows_kept":192,"cut":false,"hidden":true,"merged":[[56,2,56,7],[4,2,4,8],[5,1,5,8],[9,3,9,6],[25,3,26,7],[27,3,28,7],[29,3,32,7],[33,3,34,7],[35,3,36,7],[37,3,37,7],[38,3,39,7],[54,2,55,7],[57,2,57,7],[58,2,58,7],[59,2,60,7],[82,2,82,7],[120,1,120,2],[120,3,120,7],[158,1,158,2],[158,3,158,7],[159,1,159,2],[159,3,159,7],[121,1,121,2],[121,3,121,7],[122,1,122,2],[122,3,122,7],[157,1,157,2],[157,3,157,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 than 10%"]
[]
[null,"3.3 Bad Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"%RE:",null,"Value is smaller or equal to 5%"]
[null,"ndc:",null,"Values is higher or equal to 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":74,"n_cols":21,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,2,17],[4,2,5,6],[7,2,7,5],[13,18,13,20],[11,18,11,20],[7,13,7,17],[8,13,8,17],[9,13,9,17],[10,13,10,17],[11,13,11,17],[12,13,12,17],[13,13,13,17],[10,18,10,20],[11,2,11,5],[11,6,11,11],[12,18,12,20],[7,6,7,11],[8,2,8,5],[34,12,34,14],[24,12,24,14],[73,0,73,22],[60,6,60,8],[60,9,60,10],[60,18,60,20],[61,2,61,5],[68,2,68,3],[67,2,67,4],[30,8,34,9],[67,8,67,10],[66,8,66,9],[64,8,64,10],[61,6,61,8],[61,9,61,10],[34,5,34,6],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[25,12,25,14],[26,12,26,14],[27,12,27,14],[28,12,28,14],[29,12,29,14],[30,12,30,14],[31,12,31,14],[32,12,32,14],[33,12,33,14],[26,2,26,3],[29,2,29,3],[10,2,10,5],[10,6,10,11],[28,2,28,3],[28,5,28,6],[28,8,28,9],[29,8,29,9],[29,5,29,6],[21,2,22,6],[23,2,23,9],[25,2,25,3],[27,2,27,3],[25,5,25,6],[27,5,27,6],[25,8,25,9],[26,8,26,9],[27,8,27,9],[24,2,24,3],[26,5,26,6],[24,5,24,6],[24,8,24,9],[60,12,60,13],[60,2,60,5],[59,9,59,10],[64,5,64,7],[64,15,64,17],[7,18,7,20],[8,6,8,11],[8,18,8,20],[9,2,9,5],[9,6,9,11],[9,18,9,20],[20,2,20,5],[20,6,20,8],[12,2,12,5],[12,6,12,11],[16,2,17,5],[16,6,17,17],[16,18,19,21],[18,2,18,5],[18,6,18,9],[19,2,19,5],[19,6,19,9],[18,13,18,17],[19,13,19,17],[67,5,67,7],[59,18,59,19],[67,11,67,14],[66,11,66,13],[64,18,64,19],[66,18,66,20],[23,13,23,20],[67,18,67,20],[25,17,25,18],[26,17,26,18],[27,17,27,18],[28,17,28,18],[29,17,29,18],[30,17,30,18],[31,17,31,18],[32,17,32,18],[33,17,33,18],[34,17,34,18],[24,17,24,18],[56,2,56,5],[59,6,59,8],[60,14,60,17],[63,8,63,9],[64,2,64,4]]}
[]
[null,"   M3_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,null,null,null,"  Feature \n  Dependent"]
[]
[null,null,"Unit:",null,null,null,null,null,null,null,null,"USL:"]
[null,null,"KPC:",null,null,null,null,null,null,null,null,"LSL:"]
[null,null,null,null,null,null,{"$f":"IF(OR(G20<>\"\",I20<>\"\"),\"Feature is special\",\"No KPC feature\")","v":"No KPC feature"}]
[null,null,"Measurement data"]
[]
[null,null,"Inspection A",null,null,null,null,null,null,null,null,null,null,"Inspection B"]
[null,null,"1-10",null,null,"11-20",null,null,"21-25",null,null,null,"1-10",null,null,null,null,"11-20",null,null,"21-25"]
[null,null,{"$f":"IF(Values!B6=\"\",\"\",IF(Visualization!$G$12=1,Values!B6,FIXED(Values!B6,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B16=\"\",\"\",IF(Visualization!$G$12=1,Values!B16,FIXED(Values!B16,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B26=\"\",\"\",IF(Visualization!$G$12=1,Values!B26,FIXED(Values!B26,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Values!C6=\"\",\"\",IF(Visualization!$G$12=1,Values!C6,FIXED(Values!C6,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C16=\"\",\"\",IF(Visualization!$G$12=1,Values!C16,FIXED(Values!C16,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!C26=\"\",\"\",IF(Visualization!$G$12=1,Values!C26,FIXED(Values!C26,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B7=\"\",\"\",IF(Visualization!$G$12=1,Values!B7,FIXED(Values!B7,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B17=\"\",\"\",IF(Visualization!$G$12=1,Values!B17,FIXED(Values!B17,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B27=\"\",\"\",IF(Visualization!$G$12=1,Values!B27,FIXED(Values!B27,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Values!C7=\"\",\"\",IF(Visualization!$G$12=1,Values!C7,FIXED(Values!C7,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C17=\"\",\"\",IF(Visualization!$G$12=1,Values!C17,FIXED(Values!C17,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!C27=\"\",\"\",IF(Visualization!$G$12=1,Values!C27,FIXED(Values!C27,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B8=\"\",\"\",IF(Visualization!$G$12=1,Values!B8,FIXED(Values!B8,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B18=\"\",\"\",IF(Visualization!$G$12=1,Values!B18,FIXED(Values!B18,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B28=\"\",\"\",IF(Visualization!$G$12=1,Values!B28,FIXED(Values!B28,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Values!C8=\"\",\"\",IF(Visualization!$G$12=1,Values!C8,FIXED(Values!C8,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C18=\"\",\"\",IF(Visualization!$G$12=1,Values!C18,FIXED(Values!C18,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!C28=\"\",\"\",IF(Visualization!$G$12=1,Values!C28,FIXED(Values!C28,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B9=\"\",\"\",IF(Visualization!$G$12=1,Values!B9,FIXED(Values!B9,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B19=\"\",\"\",IF(Visualization!$G$12=1,Values!B19,FIXED(Values!B19,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B29=\"\",\"\",IF(Visualization!$G$12=1,Values!B29,FIXED(Values!B29,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Values!C9=\"\",\"\",IF(Visualization!$G$12=1,Values!C9,FIXED(Values!C9,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C19=\"\",\"\",IF(Visualization!$G$12=1,Values!C19,FIXED(Values!C19,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!C29=\"\",\"\",IF(Visualization!$G$12=1,Values!C29,FIXED(Values!C29,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B10=\"\",\"\",IF(Visualization!$G$12=1,Values!B10,FIXED(Values!B10,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B20=\"\",\"\",IF(Visualization!$G$12=1,Values!B20,FIXED(Values!B20,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B30=\"\",\"\",IF(Visualization!$G$12=1,Values!B30,FIXED(Values!B30,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,{"$f":"IF(Values!C10=\"\",\"\",IF(Visualization!$G$12=1,Values!C10,FIXED(Values!C10,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C20=\"\",\"\",IF(Visualization!$G$12=1,Values!C20,FIXED(Values!C20,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!C30=\"\",\"\",IF(Visualization!$G$12=1,Values!C30,FIXED(Values!C30,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B11=\"\",\"\",IF(Visualization!$G$12=1,Values!B11,FIXED(Values!B11,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B21=\"\",\"\",IF(Visualization!$G$12=1,Values!B21,FIXED(Values!B21,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Calculation!E20=\"\",\"\",FIXED(Calculation!E20,LEN(#REF!)-2,FALSE))","v":""},null,null,null,{"$f":"IF(Values!C11=\"\",\"\",IF(Visualization!$G$12=1,Values!C11,FIXED(Values!C11,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C21=\"\",\"\",IF(Visualization!$G$12=1,Values!C21,FIXED(Values!C21,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B12=\"\",\"\",IF(Visualization!$G$12=1,Values!B12,FIXED(Values!B12,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B22=\"\",\"\",IF(Visualization!$G$12=1,Values!B22,FIXED(Values!B22,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF(Values!C12=\"\",\"\",IF(Visualization!$G$12=1,Values!C12,FIXED(Values!C12,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C22=\"\",\"\",IF(Visualization!$G$12=1,Values!C22,FIXED(Values!C22,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B13=\"\",\"\",IF(Visualization!$G$12=1,Values!B13,FIXED(Values!B13,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B23=\"\",\"\",IF(Visualization!$G$12=1,Values!B23,FIXED(Values!B23,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF(Values!C13=\"\",\"\",IF(Visualization!$G$12=1,Values!C13,FIXED(Values!C13,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C23=\"\",\"\",IF(Visualization!$G$12=1,Values!C23,FIXED(Values!C23,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B14=\"\",\"\",IF(Visualization!$G$12=1,Values!B14,FIXED(Values!B14,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B24=\"\",\"\",IF(Visualization!$G$12=1,Values!B24,FIXED(Values!B24,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF(Values!C14=\"\",\"\",IF(Visualization!$G$12=1,Values!C14,FIXED(Values!C14,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C24=\"\",\"\",IF(Visualization!$G$12=1,Values!C24,FIXED(Values!C24,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[null,null,{"$f":"IF(Values!B15=\"\",\"\",IF(Visualization!$G$12=1,Values!B15,FIXED(Values!B15,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,{"$f":"IF(Values!B25=\"\",\"\",IF(Visualization!$G$12=1,Values!B25,FIXED(Values!B25,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF(Values!C15=\"\",\"\",IF(Visualization!$G$12=1,Values!C15,FIXED(Values!C15,LEN(Visualization!$G$12)-2,FALSE)))","v":""},null,null,null,null,{"$f":"IF(Values!C25=\"\",\"\",IF(Visualization!$G$12=1,Values!C25,FIXED(Values!C25,LEN(Visualization!$G$12)-2,FALSE)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Characteristics"]
[]
[]
[null,null,null,null,null,null,"Varianz",null,null,"Sigma",null,null,null,null,null,null,null,null,0.1]
[null,null,"Repeatability",null,null,null,{"$f":"IF(L68=Calculation!H5,\"\",Calculation!K24)","v":""},null,null,{"$f":"IF(G61=\"\",\"\",Calculation!K28)","v":""},null,"%EV =",{"$f":"IF(L68=\"\",\"\",IF(Calculation!U4=\"ANOVA\",Calculation!O12,Calculation!J51))","v":""},null,{"$f":"IF(S61=\"\",\"\",IF(S61>10,\"VAL\",S61))","v":""},null,null,null,{"$f":"M61","v":""}]
[null,null,"Repeatability & Reproductivity",null,null,null,{"$f":"IF(L68=Calculation!H5,\"\",Calculation!K24)","v":""},null,null,{"$f":"IF(G62=\"\",\"\",Calculation!K28)","v":""}]
[]
[null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,"  5"]
[null,null,{"$f":"IF(Result_RE_1185=\"\",\"\",\"%RE = \"&ROUND(Result_RE_1185,2))","v":""},null,null,{"$f":"IF(OR(G12=\"\",N19=\"\",N20=\"\"),\"\",IF(I65>5,\"VAL\",I65))","v":""},null,null,{"$f":"IF(G12=\"\",\"\",ROUND((Calculation!AA48/(N19-N20))*100,2))","v":""},null,null,null,null,null,null,{"$f":"\"ndc = \" &Result_ndc_1185","v":"ndc = "},null,null,{"$f":"IF(U65=\"\",\"\",IF(U65>=5,\"VAL\",U65))","v":""},null,{"$f":"Calculation!K32","v":""}]
[]
[null,null,null,null,null,null,null,null,0.1,null,null,0.3,null,null,null,null,null,null,{"$f":"Calculation!T4 & \" \"  &Calculation!U4","v":"Capability acc. ANOVA"}]
[null,null,{"$f":"\"%R&R = \" &Result_RuR_1185","v":"%R&R = "},null,null,{"$f":"IF(L68=\"\",\"\",IF(L68>30,\"VAL1\",IF(L68>10,\"VAL2\",L68)))","v":""},null,null,{"$f":"IF(L68=\"\",\"\",IF(L68>30,\"VAL\",L68))","v":""},null,null,{"$f":"IF(Calculation!U4=\"ANOVA\",Calculation!G5,Calculation!H5)","v":""},null,null,null,null,null,null,{"$f":"IF(O61=\"\",\"\",IF(AND(L68<=10,U65>=5,I65<5),\"Approved\",\"NG\"))","v":""}]
[]
[]
[]
[]
[]
["Please enter the collected measured values into the register \"Values\""]

{"sheet":"Values","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,1,1,2]]}
[null,"Values"]
[]
[]
[]
[null,"m1 (1-25)","m2 (1-25)"]

{"sheet":"Graphics","index":3,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,2,1,3],[80,2,80,3],[80,10,80,11],[80,13,80,14],[80,17,80,18],[55,2,55,3],[55,10,55,11],[55,17,55,18],[55,13,55,14]]}
[]
[null,null,"Part Variation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"X-Bar Chart",null,null,null,null,null,null,null,null,null,null,"R-Chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"%EV; %R&R",null,null,null,null,null,null,null,null,null,null,"BoxPlot"]

{"sheet":"Calculation","index":4,"n_rows":72,"n_cols":27,"rows_kept":72,"cut":false,"hidden":true,"merged":[[3,20,4,20],[3,19,4,19],[9,26,11,26],[21,15,22,15],[41,29,41,31],[12,29,12,30],[12,31,12,32],[9,24,11,24],[9,25,11,25],[9,18,11,18],[9,19,10,20],[9,21,11,21],[9,22,11,22],[9,23,11,23],[49,29,49,31],[13,10,13,11],[47,14,47,15],[48,14,48,15],[44,18,45,19],[44,21,45,24],[21,12,21,14],[42,13,43,16],[0,1,1,4],[53,9,54,11],[46,8,46,9],[28,8,29,9],[21,10,21,11],[30,8,32,9],[31,10,32,10],[42,1,43,4],[45,1,46,1],[45,2,45,3],[45,5,46,5],[45,6,46,6],[2,6,2,7],[2,1,2,3],[3,1,3,3],[4,1,4,3],[11,8,11,9],[11,10,11,11],[21,8,27,9],[14,8,14,9],[14,10,14,11],[18,8,19,11],[12,8,12,9],[12,10,12,11],[13,8,13,9],[2,19,2,20],[50,14,50,15],[6,18,7,21],[6,1,7,4],[8,1,9,4],[8,5,9,5],[11,5,12,5],[11,6,12,6],[8,13,9,14],[44,13,45,16],[11,1,12,1],[41,2,41,3],[11,2,11,3],[40,2,40,3],[39,2,39,3],[45,8,45,9]]}
[null,"Calculation method"]
[]
[null,"Analysis method",null,null,"Status",null,"%R&R",null,null,null,null,null,null,null,null,null,null,null,null,"Choosen method"]
[null,"ANOVA (Analysis of variance)",null,null,"Active",null,"ANOVA","ARM",null,null,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(O14=\"\",\"\",ROUND(O14,2))","v":""},{"$f":"IF(J51=\"\",\"\",ROUND(J51,2))","v":""}]
[]
[null,"ANOVA (Analysis of variance)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANOVA Value Table"]
[]
[null,"Values",null,null,null,"General",null,null,null,null,null,null,null,"Influences in %"]
[null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"i","j = 1 (Inspection A)",null,null,"X-Bar","Range",null,"∆T",null,{"$f":"AA49-AA50","v":0},null,null,"%EV",{"$f":"P24","v":""},null,null,null,null,"m1","m2"]
[null,null,"m = 1 (Row A)","m =  2 (Row B)",null,null,null,null,"Inspection (j)",null,1,null,null,null,0,null,null,null,1,{"$f":"IF(C14=\"\",\"\",C14)","v":""},{"$f":"IF(D14=\"\",\"\",D14)","v":""},{"$f":"IF(T13=\"\",\"\",AVERAGE(T13:U13))","v":""},{"$f":"IF(T13=\"\",\"\",(T13-V13)^2)","v":""},{"$f":"IF(U13=\"\",\"\",(U13-V13)^2)","v":""},{"$f":"IF(T13=\"\",\"\",W13+X13)","v":""},{"$f":"IF(T13=\"\",\"\",(AVERAGE(T13:U13)-AVERAGE($T$13:$U$37))^2)","v":""},{"$f":"IF(T13=\"\",\"\",MAX(T13:U13)-MIN(T13:U13))","v":""}]
[null,1,{"$f":"IF(Values!B6=\"\",\"\",Values!B6)","v":""},{"$f":"IF(Values!C6=\"\",\"\",Values!C6)","v":""},null,{"$f":"IF(D14=\"\",\"\",AVERAGE(C14:D14))","v":""},{"$f":"IF(D14=\"\",\"\",MAX(C14:D14)-MIN(C14:D14))","v":""},null,"Speciments (i)",null,{"$f":"IF(COUNT(Values!B6:B30)=0,\"\",COUNT(Values!B6:B30))","v":""},null,null,"%R&R",{"$f":"P24","v":""},null,null,null,2,"","",{"$f":"IF(T14=\"\",\"\",AVERAGE(T14:U14))","v":""},{"$f":"IF(T14=\"\",\"\",(T14-V14)^2)","v":""},{"$f":"IF(U14=\"\",\"\",(U14-V14)^2)","v":""},{"$f":"IF(T14=\"\",\"\",W14+X14)","v":""},"",{"$f":"IF(T14=\"\",\"\",MAX(T14:U14)-MIN(T14:U14))","v":""}]
[null,2,{"$f":"IF(Values!B7=\"\",\"\",Values!B7)","v":""},{"$f":"IF(Values!C7=\"\",\"\",Values!C7)","v":""},null,{"$f":"IF(D15=\"\",\"\",AVERAGE(C15:D15))","v":""},{"$f":"IF(D15=\"\",\"\",MAX(C15:D15)-MIN(C15:D15))","v":""},null,"Amount of measurements (r)",null,2,null,null,null,0,null,null,null,3,"","",{"$f":"IF(T15=\"\",\"\",AVERAGE(T15:U15))","v":""},"","","","",""]
[null,3,{"$f":"IF(Values!B8=\"\",\"\",Values!B8)","v":""},{"$f":"IF(Values!C8=\"\",\"\",Values!C8)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,4,"","","","","","","",""]
[null,4,{"$f":"IF(Values!B9=\"\",\"\",Values!B9)","v":""},{"$f":"IF(Values!C9=\"\",\"\",Values!C9)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,5,"","","","","","","",""]
[null,5,{"$f":"IF(Values!B10=\"\",\"\",Values!B10)","v":""},{"$f":"IF(Values!C10=\"\",\"\",Values!C10)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,6,"","","","","","","",""]
[null,6,{"$f":"IF(Values!B11=\"\",\"\",Values!B11)","v":""},{"$f":"IF(Values!C11=\"\",\"\",Values!C11)","v":""},null,"","",null,"ANOVA Table",null,null,null,null,null,null,null,null,null,7,"","","","","","","",""]
[null,7,{"$f":"IF(Values!B12=\"\",\"\",Values!B12)","v":""},{"$f":"IF(Values!C12=\"\",\"\",Values!C12)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,8,"","","","","","","",""]
[null,8,{"$f":"IF(Values!B13=\"\",\"\",Values!B13)","v":""},{"$f":"IF(Values!C13=\"\",\"\",Values!C13)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,9,"","","","","","","",""]
[null,9,{"$f":"IF(Values!B14=\"\",\"\",Values!B14)","v":""},{"$f":"IF(Values!C14=\"\",\"\",Values!C14)","v":""},null,"","",null,"Based on Parts",null,"Measurementsystem",null,"Parts",null,null,"%R&R / %EV",null,null,10,"","","","","","","",""]
[null,10,{"$f":"IF(Values!B15=\"\",\"\",Values!B15)","v":""},{"$f":"IF(Values!C15=\"\",\"\",Values!C15)","v":""},null,"","",null,null,null,"Variance","EV","Variance","VT","PV",null,null,null,11,"","","","","","","",""]
[null,11,{"$f":"IF(Values!B16=\"\",\"\",Values!B16)","v":""},{"$f":"IF(Values!C16=\"\",\"\",Values!C16)","v":""},null,"","",null,null,null,{"$f":"IF(Y38=\"\",\"\",Y38/(K14*(K15-K13)))","v":""},{"$f":"IF(K24=\"\",\"\",5.15*SQRT(K24))","v":""},{"$f":"IF(Z38=\"\",\"\",Z38/(K14-1))","v":""},{"$f":"IF(Y38=\"\",\"\",(M24-Y38)/2)","v":""},{"$f":"IF(N24=\"\",\"\",5.15*SQRT(N24))","v":""},{"$f":"IF(L24=\"\",\"\",IF(K15=\"\",\"\",(L24/K12)*100))","v":""},null,null,12,"","","","","","","",""]
[null,12,{"$f":"IF(Values!B17=\"\",\"\",Values!B17)","v":""},{"$f":"IF(Values!C17=\"\",\"\",Values!C17)","v":""},null,"","",null,null,null,"Sigma",null,"Sigma",null,null,null,null,null,13,"","","","","","","",""]
[null,13,{"$f":"IF(Values!B18=\"\",\"\",Values!B18)","v":""},{"$f":"IF(Values!C18=\"\",\"\",Values!C18)","v":""},null,"","",null,null,null,{"$f":"IF(K24=\"\",\"\",SQRT(K24))","v":""},null,{"$f":"IF(M24=\"\",\"\",SQRT(M24))","v":""},null,null,null,null,null,14,"","","","","","","",""]
[null,14,{"$f":"IF(Values!B19=\"\",\"\",Values!B19)","v":""},{"$f":"IF(Values!C19=\"\",\"\",Values!C19)","v":""},null,"","",null,null,null,"Sigma (5,15)",null,null,null,null,null,null,null,15,"","","","","","","",""]
[null,15,{"$f":"IF(Values!B20=\"\",\"\",Values!B20)","v":""},{"$f":"IF(Values!C20=\"\",\"\",Values!C20)","v":""},null,"","",null,null,null,{"$f":"IF(K26=\"\",\"\",K26*5.15)","v":""},null,null,null,null,null,null,null,16,"","","","","","","",""]
[null,16,{"$f":"IF(Values!B21=\"\",\"\",Values!B21)","v":""},{"$f":"IF(Values!C21=\"\",\"\",Values!C21)","v":""},null,"","",null,"Based on Spec",null,"TV",null,null,null,null,null,null,null,17,"","","","","","","",""]
[null,17,{"$f":"IF(Values!B22=\"\",\"\",Values!B22)","v":""},{"$f":"IF(Values!C22=\"\",\"\",Values!C22)","v":""},null,"","",null,null,null,{"$f":"IF(K12=\"No specification limits!\",\"\",K12/6)","v":0},null,null,null,null,null,null,null,18,"","","","","","","",""]
[null,18,{"$f":"IF(Values!B23=\"\",\"\",Values!B23)","v":""},{"$f":"IF(Values!C23=\"\",\"\",Values!C23)","v":""},null,"","",null,"No. of Distinct Categories",null,"Based Parts",null,null,null,null,null,null,null,19,"","","","","","","",""]
[null,19,{"$f":"IF(Values!B24=\"\",\"\",Values!B24)","v":""},{"$f":"IF(Values!C24=\"\",\"\",Values!C24)","v":""},null,"","",null,null,null,{"$f":"IF(M24=\"\",\"\",ROUND(1.41*(M26/K26),0))","v":""},null,null,null,null,null,null,null,20,"","","","","","","",""]
[null,20,{"$f":"IF(Values!B25=\"\",\"\",Values!B25)","v":""},{"$f":"IF(Values!C25=\"\",\"\",Values!C25)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,21,"","","","","","","",""]
[null,21,{"$f":"IF(Values!B26=\"\",\"\",Values!B26)","v":""},{"$f":"IF(Values!C26=\"\",\"\",Values!C26)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,22,"","","","","","","",""]
[null,22,{"$f":"IF(Values!B27=\"\",\"\",Values!B27)","v":""},{"$f":"IF(Values!C27=\"\",\"\",Values!C27)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,23,"","","","","","","",""]
[null,23,{"$f":"IF(Values!B28=\"\",\"\",Values!B28)","v":""},{"$f":"IF(Values!C28=\"\",\"\",Values!C28)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,24,"","","","","","","",""]
[null,24,{"$f":"IF(Values!B29=\"\",\"\",Values!B29)","v":""},{"$f":"IF(Values!C29=\"\",\"\",Values!C29)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,25,"","","","","","","",""]
[null,25,{"$f":"IF(Values!B30=\"\",\"\",Values!B30)","v":""},{"$f":"IF(Values!C30=\"\",\"\",Values!C30)","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summ [Σ]",{"$f":"IF(T13=\"\",\"\",SUM(Y13:Y37))","v":""},{"$f":"IF(T13=\"\",\"\",SUM(Z13:Z37))","v":""}]
[]
[null,null,"X-Bar [j1j2j3]"]
[null,null,{"$f":"IF(C14=\"\",\"\",AVERAGE(C14:D38))","v":""}]
[]
[null,"ARM (Average Range Method)",null,null,null,null,null,null,null,null,null,null,null,"Graphics calculation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"X-Bar Chart",null,null,null,null,"R Chart",null,null,"Boxplot Data"]
[null,"i","j = 1 (Inspection A)",null,null,"X-Bar","Range",null,"Range [R-Bar]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Pro.File variables"]
[null,null,"m = 1 (Row A)","m =  2 (Row B)",null,null,null,null,{"$f":"IF(G72=\"\",\"\",AVERAGE(G48:G72))","v":""}]
[null,1,{"$f":"C14","v":""},{"$f":"D14","v":""},null,{"$f":"IF(D48=\"\",\"\",AVERAGE(C48:D48))","v":""},{"$f":"IF(D48=\"\",\"\",MAX(C48:D48)-MIN(C48:D48))","v":""},null,null,null,null,null,null,"X - UEL",{"$f":"IF(K14=\"\",\"\",O51+(I47*$J$59))","v":""},null,null,null,"R - UEL",{"$f":"IF(K14=\"\",\"\",I47*K59)","v":""},null,null,"m1","m2",null,"Resolution",{"$f":"VALUE(PRODSTRING15)","v":0}]
[null,2,{"$f":"C15","v":""},"",null,{"$f":"IF(D49=\"\",\"\",AVERAGE(C49:D49))","v":""},{"$f":"IF(D49=\"\",\"\",MAX(C49:D49)-MIN(C49:D49))","v":""},null,null,null,null,null,null,"X - LEL",{"$f":"IF(K14=\"\",\"\",O51-(I47*$J$59))","v":""},null,null,null,null,null,null,"Max",{"$f":"IF(F72=\"\",\"\",MAX(C48:C72))","v":""},{"$f":"IF(F72=\"\",\"\",MAX(D48:D72))","v":""},null,"USL",{"$f":"VALUE(PRODSTRING17)","v":0}]
[null,3,{"$f":"C16","v":""},"",null,"","",null,"R&R",{"$f":"IF(I47=\"\",\"\",I47*I55)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Q3",{"$f":"IF(F72=\"\",\"\",QUARTILE(C48:C72,3))","v":""},{"$f":"IF(F72=\"\",\"\",QUARTILE(D48:D72,3))","v":""},null,"LSL",{"$f":"VALUE(PRODSTRING18)","v":0}]
[null,4,{"$f":"C17","v":""},"",null,"","",{"$f":"I51","v":"%R&R"},"%R&R",{"$f":"IF(K14=\"\",\"\",(J50/Calculation!K12)*100)","v":""},{"$f":"J51","v":""},null,null,"x bar bar",{"$f":"IF(F72=\"\",\"\",AVERAGE(F14:F38))","v":""},null,null,null,null,null,null,"Med",{"$f":"IF(F72=\"\",\"\",MEDIAN(C48:C72))","v":""},{"$f":"IF(F72=\"\",\"\",MEDIAN(D48:D72))","v":""}]
[null,5,{"$f":"C18","v":""},"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"IF(F72=\"\",\"\",QUARTILE(C48:C72,1))","v":""},{"$f":"IF(F72=\"\",\"\",QUARTILE(D48:D72,1))","v":""}]
[null,6,{"$f":"C19","v":""},"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(F72=\"\",\"\",MIN(C48:C72))","v":""},{"$f":"IF(F72=\"\",\"\",MIN(D48:D72))","v":""}]
[null,7,{"$f":"C20","v":""},"",null,"","",null,"K1 ","Calculation according MSA Booklet (25 Specimens; 1 Inspector; 2 Repetitions)",null,null,null,null,null,null,null,null,null,null,null,"Maximum - Q3",{"$f":"IF(W49=\"\",\"\",W49-W53)","v":""},{"$f":"IF(X49=\"\",\"\",X49-X53)","v":""}]
[null,8,{"$f":"C21","v":""},"",null,"","",null,4.57,null,null,null,null,null,null,null,null,null,null,null,null,"Q1-Minimum",{"$f":"IF(W49=\"\",\"\",W52-W53)","v":""},{"$f":"IF(X49=\"\",\"\",X52-X53)","v":""}]
[null,9,{"$f":"C22","v":""},"",null,"",""]
[null,10,{"$f":"C23","v":""},"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m1","m2"]
[null,11,{"$f":"C24","v":""},"",null,"","",null,"n","A2","D4",null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"W53","v":""},{"$f":"X53","v":""}]
[null,12,{"$f":"C25","v":""},"",null,"","",null,2,1.88,3.2669999999999999,null,null,null,null,null,null,null,null,null,null,"∆ (Q1;Min)",{"$f":"IF(W58=\"\",\"\",W52-W53)","v":""},{"$f":"IF(X58=\"\",\"\",X52-X53)","v":""}]
[null,13,{"$f":"C26","v":""},"",null,"","",null,3,1.0229999999999999,2.5739999999999998,null,null,null,null,null,null,null,null,null,null,"∆ (Med;Q1)",{"$f":"IF(W58=\"\",\"\",W51-W52)","v":""},{"$f":"IF(X58=\"\",\"\",X51-X52)","v":""}]
[null,14,{"$f":"C27","v":""},"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Med)",{"$f":"IF(W58=\"\",\"\",W50-W51)","v":""},{"$f":"IF(X58=\"\",\"\",X50-X51)","v":""}]
[null,15,{"$f":"C28","v":""},"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∆ (Q3;Max)",{"$f":"IF(W58=\"\",\"\",W49-W50)","v":""},{"$f":"IF(X58=\"\",\"\",X49-X50)","v":""}]
[null,16,{"$f":"C29","v":""},"",null,"",""]
[null,17,{"$f":"C30","v":""},"",null,"",""]
[null,18,{"$f":"C31","v":""},"",null,"",""]
[null,19,{"$f":"C32","v":""},"",null,"",""]
[null,20,{"$f":"C33","v":""},"",null,"",""]
[null,21,{"$f":"C34","v":""},"",null,"",""]
[null,22,{"$f":"C35","v":""},"",null,"",""]
[null,23,{"$f":"C36","v":""},"",null,"",""]
[null,24,{"$f":"C37","v":""},"",null,"",""]
[null,25,{"$f":"C38","v":""},"",null,"",""]

{"sheet":"Settings","index":5,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[[22,1,23,4],[22,5,23,7],[16,1,17,4],[16,5,17,7],[18,1,19,4],[18,5,19,7],[20,1,21,4],[20,5,21,7],[13,1,14,3],[0,1,1,3],[2,1,3,3],[5,1,7,7],[8,1,9,3],[11,1,12,4]]}
[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."]