{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Guide","Visualization","Values","Calculation","Settings","Directories","References"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":28,"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":147,"n_cols":4,"rows_kept":147,"cut":false,"hidden":true,"merged":[[242,2,244,7],[255,6,259,8],[273,1,278,8],[187,6,187,8],[189,6,191,8],[195,6,197,8],[229,2,231,7],[69,2,69,7],[30,3,31,7],[32,3,33,7],[48,2,49,7],[50,2,50,7],[51,2,52,7],[26,3,29,7],[4,2,4,8],[5,1,5,8],[9,3,9,6],[22,3,23,7],[24,3,25,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,"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,"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:","Enter all Reference values and results (\"OK\" or \"NG\") into the columns."]
[]
[]
[]
[null,"3.1 Open register \"Visualization\""]
[null,"3.2 Good Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.3 Bad Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Open register \"Settings\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hide or Unhide registers to have a more detailed view into background processes."]

{"sheet":"Visualization","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[47,2,47,13],[50,14,51,14],[30,2,31,6],[57,1,57,15],[1,1,3,12],[42,8,44,11],[42,12,44,13],[42,14,44,14],[45,8,46,11],[45,12,46,13],[45,14,46,14],[45,2,46,7],[35,12,35,13],[36,12,36,13],[37,2,37,13],[38,2,38,14],[42,2,42,6],[33,12,34,13],[32,12,32,13],[33,14,34,14],[33,8,34,11],[32,8,32,11],[32,2,32,6],[35,2,35,7],[36,2,36,7],[35,8,35,11],[36,8,36,11],[24,12,25,12],[24,13,25,14],[26,13,27,14],[26,12,27,12],[26,2,27,11],[24,2,24,7],[25,2,25,7],[24,8,24,9],[25,8,25,9],[24,10,25,11],[22,2,23,6],[4,12,6,14],[6,5,6,10],[7,2,8,4],[7,5,8,10],[8,13,8,14],[6,2,6,4],[11,13,11,14],[12,13,12,14],[9,2,9,4],[9,5,9,10],[9,13,9,14],[10,2,10,4],[19,2,19,4],[19,5,19,7],[10,5,10,10],[10,13,10,14],[11,2,11,4],[19,9,19,10],[19,11,19,12],[13,13,13,14],[14,13,14,14],[17,14,21,15],[20,2,20,4],[20,5,20,7],[21,2,21,4],[21,5,21,7],[11,5,11,10],[17,2,18,4],[17,5,18,12],[20,11,20,12]]}
[]
[null," Attr(3)_Attributive Measurementsystem Capability  \n Analysis: Inspection vs. Reference Value"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Feature Independent"]
[]
[null,null,"Location:"]
[null,null,"Line:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Base ID:"]
[null,null,"Meas. System-Name:",null,null,null,null,null,null,null,null,null,"Revision:"]
[null,null,"Meas. System-No.:",null,null,null,null,null,null,null,null,null,"Version:"]
[null,null,"Date of Datacollection:",null,null,null,null,null,null,null,null,null,"Released by (ID):"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Released by:"]
[null,null,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,"Doc. Status:"]
[]
[]
[null,null,"Feature:",null,null,null,null,null,null,null,null,null,null,null,"Feature \nDependent"]
[]
[null,null,"Unit:",null,null,null,null,null,null,"KPC:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(L20<>\"\",M20<>\"\"),\"Feature is special\",\"No KPC feature\")","v":"No KPC feature"}]
[]
[null,null,"Reference Condition"]
[]
[null,null,"Numbers of Reference samples OK",null,null,null,null,null,{"$f":"Calculation!E54","v":0},null,"NG \nratio",null,{"$f":"Calculation!Z28","v":""},{"$f":"\" Ʃ all reference samples = \" & Calculation!X28","v":" Ʃ all reference samples = 0"}]
[null,null,"Numbers of Reference samples NG",null,null,null,null,null,{"$f":"Calculation!G54","v":0}]
[null,null,{"$f":"Calculation!V30","v":"Limits for judgement minimum parts of NG (bigger than)"},null,null,null,null,null,null,null,null,null,{"$f":"Calculation!Z30","v":0.39},"Limits can be set in sheet \"Calculation\""]
[]
[]
[]
[null,null,"Measurment Results"]
[]
[null,null,"The kappa coefficient",null,null,null,null,null,{"$f":"Calculation!W3","v":"Po"},null,null,null,{"$f":"Calculation!X3","v":"Pc"},null,{"$f":"Calculation!Y3","v":"κ"}]
[null,null,null,null,null,null,null,null,{"$f":"Calculation!W4","v":"measured \nmatch score"},null,null,null,{"$f":"Calculation!X4","v":"randomly expected match score"},null,{"$f":"Calculation!Y4","v":"Fleiss \nKappa"}]
[]
[null,null,{"$f":"Calculation!V6","v":"Result within 5 measures of Inspection"},null,null,null,null,null,{"$f":"Calculation!W6","v":""},null,null,null,{"$f":"Calculation!X6","v":0},null,{"$f":"Calculation!Y6","v":""}]
[null,null,{"$f":"Calculation!V7","v":"Result Inspection vs Reference"},null,null,null,null,null,{"$f":"Calculation!W7","v":""},null,null,null,{"$f":"Calculation!X7","v":0},null,{"$f":"Calculation!Y7","v":""}]
[null,null,{"$f":"Calculation!V8","v":"Limits for judgement OK (bigger than)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!Y8","v":0.9}]
[null,null,"In case of orange coloring the set limit was violated but the standard AIAG limit was not violated (set limit > AIAG limit)"]
[]
[]
[]
[null,null,"Effectiveness of system",null,null,null,null,null,{"$f":"Calculation!W15","v":"bad/ good\ngood parts ranked as bad"},null,null,null,{"$f":"Calculation!X15","v":"good / bad\nbad parts ranked as good"},null,{"$f":"Calculation!Y15","v":"Total Effectiveness"}]
[]
[]
[null,null,{"$f":"Calculation!V18","v":"Result within 5 measures of Inspection vs Reference"},null,null,null,null,null,{"$f":"Calculation!W18","v":""},null,null,null,{"$f":"Calculation!X18","v":""},null,{"$f":"Calculation!Y18","v":""}]
[]
[null,null,{"$f":"Calculation!V19","v":"Limits for judgement OK (lower than)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calculation!Y19","v":0.9}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capability"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Result_Effectivenessofsystem_2304=\"\",\"\",IF(AND(M25>Calculation!Z30,O36>Calculation!Y8,O37>Calculation!Y8,O46>Calculation!Y19),\"Approved\",\"NG\"))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Please enter the collected measured values into the register \"Values\""]

{"sheet":"Values","index":2,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":true,"merged":[[2,1,3,1],[2,2,3,2],[2,3,2,4],[2,5,2,7]]}
[]
[]
[null,"Nr.","Reference defined by specialists","Operator"]
[null,null,null,"Measurement 1","Measurement 2","Measurement 3","Measurement 4","Measurement 5"]
[null,{"$f":"IF(C5=\"\",\"\",1)","v":""}]
[null,{"$f":"IF(C6=\"\",\"\",B5+1)","v":""}]
[null,{"$f":"IF(C7=\"\",\"\",B6+1)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Calculation","index":3,"n_rows":54,"n_cols":26,"rows_kept":54,"cut":false,"hidden":true,"merged":[[27,25,28,25],[14,23,16,23],[14,24,16,24],[14,22,16,22],[53,1,53,2],[14,21,15,21],[25,21,26,21],[29,25,30,25],[29,23,30,23],[29,22,30,22],[1,1,2,1],[1,3,1,7],[1,2,2,2],[49,21,51,21],[1,15,1,19],[1,9,1,14],[29,21,30,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[27,23,28,23],[27,24,28,24],[8,22,8,23],[19,22,20,22],[19,23,20,23]]}
[null,"Measurement Capability_Attributive"]
[null,"Part","Reference defined by specialists","Inspection System",null,null,null,null,null,{"$f":"V6","v":"Result within 5 measures of Inspection"},null,null,null,null,null,{"$f":"V7","v":"Result Inspection vs Reference"},null,null,null,null,null,"Measurement Result"]
[null,null,null,"Measurement 1","Measurement 2","Measurement 3","Measurement 4","Measurement 5",null,"Good\nA","Bad\nA","Pi","good\nas good","ranked as Bad","mixed decision","good are NG","NG are good","good are good","NG are NG","Pi",null,"The kappa coefficient","Po","Pc","κ"]
[null,1,{"$f":"IF(Values!C5=\"\",\"\",IF(Values!C5=\"OK\",1,0))","v":""},{"$f":"IF(Values!D5=\"\",\"\",IF(Values!D5=\"OK\",1,0))","v":""},{"$f":"IF(Values!E5=\"\",\"\",IF(Values!E5=\"OK\",1,0))","v":""},{"$f":"IF(Values!F5=\"\",\"\",IF(Values!F5=\"OK\",1,0))","v":""},{"$f":"IF(Values!G5=\"\",\"\",IF(Values!G5=\"OK\",1,0))","v":""},{"$f":"IF(Values!H5=\"\",\"\",IF(Values!H5=\"OK\",1,0))","v":""},null,{"$f":"IF(COUNT(D4:H4)=5,SUM(D4:H4),\"\")","v":""},{"$f":"IF(OR(D4=\"\",E4=\"\",F4=\"\",G4=\"\",H4=\"\"),\"\",IF(COUNT(D4:H4)=5,(5-SUM(D4:H4)),\"\"))","v":""},{"$f":"IF(COUNT(D4:H4)<5,\"\",(1/(COUNT(D4:H4)*((COUNT(D4:H4)-1)))*(((J4*J4)-J4)+((K4*K4)-K4))))","v":""},{"$f":"IF((J4=5),1,\"\")","v":""},{"$f":"IF((K4=0),\"\",1)","v":1},{"$f":"IF(OR(AND(J4=0,K4=5),AND(J4=5,K4=0)),\"\",1)","v":1},{"$f":"IF((AND(C4=1,K4>0)),1,\"\")","v":""},{"$f":"IF((AND(C4=0,J4>0)),1,\"\")","v":""},{"$f":"IF(COUNT(C4:H4)=6,SUM(C4:H4),\"\")","v":""},{"$f":"IF(OR(C4=\"\",D4=\"\",E4=\"\",F4=\"\",G4=\"\",H4=\"\"),\"\",IF(COUNT(C4:H4)=6,(6-SUM(C4:H4)),\"\"))","v":""},{"$f":"IF(C4=\"\",\"\",(1/(COUNT(C4:H4)*((COUNT(C4:H4)-1)))*(((R4*R4)-R4)+((S4*S4)-S4))))","v":""},null,null,"measured \nmatch score","randomly expected match score","Fleiss \nKappa"]
[null,2,{"$f":"IF(Values!C6=\"\",\"\",IF(Values!C6=\"OK\",1,0))","v":""},{"$f":"IF(Values!D6=\"\",\"\",IF(Values!D6=\"OK\",1,0))","v":""},{"$f":"IF(Values!E6=\"\",\"\",IF(Values!E6=\"OK\",1,0))","v":""},{"$f":"IF(Values!F6=\"\",\"\",IF(Values!F6=\"OK\",1,0))","v":""},{"$f":"IF(Values!G6=\"\",\"\",IF(Values!G6=\"OK\",1,0))","v":""},{"$f":"IF(Values!H6=\"\",\"\",IF(Values!H6=\"OK\",1,0))","v":""},null,"",{"$f":"IF(OR(D5=\"\",E5=\"\",F5=\"\",G5=\"\",H5=\"\"),\"\",IF(COUNT(D5:H5)=5,(5-SUM(D5:H5)),\"\"))","v":""},{"$f":"IF(COUNT(D5:H5)<5,\"\",(1/(COUNT(D5:H5)*((COUNT(D5:H5)-1)))*(((J5*J5)-J5)+((K5*K5)-K5))))","v":""},{"$f":"IF((J5=5),1,\"\")","v":""},{"$f":"IF((K5=0),\"\",1)","v":1},1,{"$f":"IF((AND(C5=1,K5>0)),1,\"\")","v":""},{"$f":"IF((AND(C5=0,J5>0)),1,\"\")","v":""},"","",{"$f":"IF(C5=\"\",\"\",(1/(COUNT(C5:H5)*((COUNT(C5:H5)-1)))*(((R5*R5)-R5)+((S5*S5)-S5))))","v":""}]
[null,3,{"$f":"IF(Values!C7=\"\",\"\",IF(Values!C7=\"OK\",1,0))","v":""},{"$f":"IF(Values!D7=\"\",\"\",IF(Values!D7=\"OK\",1,0))","v":""},{"$f":"IF(Values!E7=\"\",\"\",IF(Values!E7=\"OK\",1,0))","v":""},{"$f":"IF(Values!F7=\"\",\"\",IF(Values!F7=\"OK\",1,0))","v":""},{"$f":"IF(Values!G7=\"\",\"\",IF(Values!G7=\"OK\",1,0))","v":""},{"$f":"IF(Values!H7=\"\",\"\",IF(Values!H7=\"OK\",1,0))","v":""},null,"",{"$f":"IF(OR(D6=\"\",E6=\"\",F6=\"\",G6=\"\",H6=\"\"),\"\",IF(COUNT(D6:H6)=5,(5-SUM(D6:H6)),\"\"))","v":""},"",{"$f":"IF((J6=5),1,\"\")","v":""},1,1,{"$f":"IF((AND(C6=1,K6>0)),1,\"\")","v":""},{"$f":"IF((AND(C6=0,J6>0)),1,\"\")","v":""},"","","",null,"Result within 5 measures of Inspection",{"$f":"IFERROR((1/(COUNT(L4:L53))*(SUM(L4:L53))),\"\")","v":""},{"$f":"SUMSQ(J54,K54)","v":0},{"$f":"IFERROR((W6-X6)/(1-X6),\"\")","v":""}]
[null,4,{"$f":"IF(Values!C8=\"\",\"\",IF(Values!C8=\"OK\",1,0))","v":""},{"$f":"IF(Values!D8=\"\",\"\",IF(Values!D8=\"OK\",1,0))","v":""},{"$f":"IF(Values!E8=\"\",\"\",IF(Values!E8=\"OK\",1,0))","v":""},{"$f":"IF(Values!F8=\"\",\"\",IF(Values!F8=\"OK\",1,0))","v":""},{"$f":"IF(Values!G8=\"\",\"\",IF(Values!G8=\"OK\",1,0))","v":""},{"$f":"IF(Values!H8=\"\",\"\",IF(Values!H8=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,{"$f":"IF(Values!F3=\"\",\"Result Inspection vs Reference\",\"Result \" & Values!F3 & \" vs Reference\")","v":"Result Inspection vs Reference"},{"$f":"IFERROR((1/(COUNT(T4:T53))*(SUM(T4:T53))),\"\")","v":""},{"$f":"SUMSQ(R54,S54)","v":0},{"$f":"IFERROR((W7-X7)/(1-X7),\"\")","v":""}]
[null,5,{"$f":"IF(Values!C9=\"\",\"\",IF(Values!C9=\"OK\",1,0))","v":""},{"$f":"IF(Values!D9=\"\",\"\",IF(Values!D9=\"OK\",1,0))","v":""},{"$f":"IF(Values!E9=\"\",\"\",IF(Values!E9=\"OK\",1,0))","v":""},{"$f":"IF(Values!F9=\"\",\"\",IF(Values!F9=\"OK\",1,0))","v":""},{"$f":"IF(Values!G9=\"\",\"\",IF(Values!G9=\"OK\",1,0))","v":""},{"$f":"IF(Values!H9=\"\",\"\",IF(Values!H9=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,"Limits for judgement OK (bigger than)","not judged","not judged",0.9]
[null,6,{"$f":"IF(Values!C10=\"\",\"\",IF(Values!C10=\"OK\",1,0))","v":""},{"$f":"IF(Values!D10=\"\",\"\",IF(Values!D10=\"OK\",1,0))","v":""},{"$f":"IF(Values!E10=\"\",\"\",IF(Values!E10=\"OK\",1,0))","v":""},{"$f":"IF(Values!F10=\"\",\"\",IF(Values!F10=\"OK\",1,0))","v":""},{"$f":"IF(Values!G10=\"\",\"\",IF(Values!G10=\"OK\",1,0))","v":""},{"$f":"IF(Values!H10=\"\",\"\",IF(Values!H10=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,null,"General rule limit in AIAG for Kappa",null,0.75]
[null,7,{"$f":"IF(Values!C11=\"\",\"\",IF(Values!C11=\"OK\",1,0))","v":""},{"$f":"IF(Values!D11=\"\",\"\",IF(Values!D11=\"OK\",1,0))","v":""},{"$f":"IF(Values!E11=\"\",\"\",IF(Values!E11=\"OK\",1,0))","v":""},{"$f":"IF(Values!F11=\"\",\"\",IF(Values!F11=\"OK\",1,0))","v":""},{"$f":"IF(Values!G11=\"\",\"\",IF(Values!G11=\"OK\",1,0))","v":""},{"$f":"IF(Values!H11=\"\",\"\",IF(Values!H11=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,8,{"$f":"IF(Values!C12=\"\",\"\",IF(Values!C12=\"OK\",1,0))","v":""},{"$f":"IF(Values!D12=\"\",\"\",IF(Values!D12=\"OK\",1,0))","v":""},{"$f":"IF(Values!E12=\"\",\"\",IF(Values!E12=\"OK\",1,0))","v":""},{"$f":"IF(Values!F12=\"\",\"\",IF(Values!F12=\"OK\",1,0))","v":""},{"$f":"IF(Values!G12=\"\",\"\",IF(Values!G12=\"OK\",1,0))","v":""},{"$f":"IF(Values!H12=\"\",\"\",IF(Values!H12=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,9,{"$f":"IF(Values!C13=\"\",\"\",IF(Values!C13=\"OK\",1,0))","v":""},{"$f":"IF(Values!D13=\"\",\"\",IF(Values!D13=\"OK\",1,0))","v":""},{"$f":"IF(Values!E13=\"\",\"\",IF(Values!E13=\"OK\",1,0))","v":""},{"$f":"IF(Values!F13=\"\",\"\",IF(Values!F13=\"OK\",1,0))","v":""},{"$f":"IF(Values!G13=\"\",\"\",IF(Values!G13=\"OK\",1,0))","v":""},{"$f":"IF(Values!H13=\"\",\"\",IF(Values!H13=\"OK\",1,0))","v":""},null,"","","","",1,{"$f":"IF(OR(AND(J12=0,K12=5),AND(J12=5,K12=0)),\"\",1)","v":1},"","",{"$f":"IF(COUNT(C12:H12)=6,SUM(C12:H12),\"\")","v":""},{"$f":"IF(OR(C12=\"\",D12=\"\",E12=\"\",F12=\"\",G12=\"\",H12=\"\"),\"\",IF(COUNT(C12:H12)=6,(6-SUM(C12:H12)),\"\"))","v":""},""]
[null,10,{"$f":"IF(Values!C14=\"\",\"\",IF(Values!C14=\"OK\",1,0))","v":""},{"$f":"IF(Values!D14=\"\",\"\",IF(Values!D14=\"OK\",1,0))","v":""},{"$f":"IF(Values!E14=\"\",\"\",IF(Values!E14=\"OK\",1,0))","v":""},{"$f":"IF(Values!F14=\"\",\"\",IF(Values!F14=\"OK\",1,0))","v":""},{"$f":"IF(Values!G14=\"\",\"\",IF(Values!G14=\"OK\",1,0))","v":""},{"$f":"IF(Values!H14=\"\",\"\",IF(Values!H14=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,11,{"$f":"IF(Values!C15=\"\",\"\",IF(Values!C15=\"OK\",1,0))","v":""},{"$f":"IF(Values!D15=\"\",\"\",IF(Values!D15=\"OK\",1,0))","v":""},{"$f":"IF(Values!E15=\"\",\"\",IF(Values!E15=\"OK\",1,0))","v":""},{"$f":"IF(Values!F15=\"\",\"\",IF(Values!F15=\"OK\",1,0))","v":""},{"$f":"IF(Values!G15=\"\",\"\",IF(Values!G15=\"OK\",1,0))","v":""},{"$f":"IF(Values!H15=\"\",\"\",IF(Values!H15=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,12,{"$f":"IF(Values!C16=\"\",\"\",IF(Values!C16=\"OK\",1,0))","v":""},{"$f":"IF(Values!D16=\"\",\"\",IF(Values!D16=\"OK\",1,0))","v":""},{"$f":"IF(Values!E16=\"\",\"\",IF(Values!E16=\"OK\",1,0))","v":""},{"$f":"IF(Values!F16=\"\",\"\",IF(Values!F16=\"OK\",1,0))","v":""},{"$f":"IF(Values!G16=\"\",\"\",IF(Values!G16=\"OK\",1,0))","v":""},{"$f":"IF(Values!H16=\"\",\"\",IF(Values!H16=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,"Effectiveness of system ","bad/ good\ngood parts ranked as bad","good / bad\nbad parts ranked as good","Total Effectiveness"]
[null,13,{"$f":"IF(Values!C17=\"\",\"\",IF(Values!C17=\"OK\",1,0))","v":""},{"$f":"IF(Values!D17=\"\",\"\",IF(Values!D17=\"OK\",1,0))","v":""},{"$f":"IF(Values!E17=\"\",\"\",IF(Values!E17=\"OK\",1,0))","v":""},{"$f":"IF(Values!F17=\"\",\"\",IF(Values!F17=\"OK\",1,0))","v":""},{"$f":"IF(Values!G17=\"\",\"\",IF(Values!G17=\"OK\",1,0))","v":""},{"$f":"IF(Values!H17=\"\",\"\",IF(Values!H17=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,14,{"$f":"IF(Values!C18=\"\",\"\",IF(Values!C18=\"OK\",1,0))","v":""},{"$f":"IF(Values!D18=\"\",\"\",IF(Values!D18=\"OK\",1,0))","v":""},{"$f":"IF(Values!E18=\"\",\"\",IF(Values!E18=\"OK\",1,0))","v":""},{"$f":"IF(Values!F18=\"\",\"\",IF(Values!F18=\"OK\",1,0))","v":""},{"$f":"IF(Values!G18=\"\",\"\",IF(Values!G18=\"OK\",1,0))","v":""},{"$f":"IF(Values!H18=\"\",\"\",IF(Values!H18=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,15,{"$f":"IF(Values!C19=\"\",\"\",IF(Values!C19=\"OK\",1,0))","v":""},{"$f":"IF(Values!D19=\"\",\"\",IF(Values!D19=\"OK\",1,0))","v":""},{"$f":"IF(Values!E19=\"\",\"\",IF(Values!E19=\"OK\",1,0))","v":""},{"$f":"IF(Values!F19=\"\",\"\",IF(Values!F19=\"OK\",1,0))","v":""},{"$f":"IF(Values!G19=\"\",\"\",IF(Values!G19=\"OK\",1,0))","v":""},{"$f":"IF(Values!H19=\"\",\"\",IF(Values!H19=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,{"$f":"IF(Values!F3=\"\",\"Result within 5 measures of Inspection vs Reference\",\"Result within 5 measures of \" & Values!F3 & \" vs Reference\")","v":"Result within 5 measures of Inspection vs Reference"},{"$f":"IFERROR((P54)/(E54),\"\")","v":""},{"$f":"IFERROR((Q54)/(G54),\"\")","v":""},{"$f":"IFERROR(1-O54/(G54+E54),\"\")","v":""}]
[null,16,{"$f":"IF(Values!C20=\"\",\"\",IF(Values!C20=\"OK\",1,0))","v":""},{"$f":"IF(Values!D20=\"\",\"\",IF(Values!D20=\"OK\",1,0))","v":""},{"$f":"IF(Values!E20=\"\",\"\",IF(Values!E20=\"OK\",1,0))","v":""},{"$f":"IF(Values!F20=\"\",\"\",IF(Values!F20=\"OK\",1,0))","v":""},{"$f":"IF(Values!G20=\"\",\"\",IF(Values!G20=\"OK\",1,0))","v":""},{"$f":"IF(Values!H20=\"\",\"\",IF(Values!H20=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,"Limits for judgement OK (lower than)",0.1,1E-4,0.9]
[null,17,{"$f":"IF(Values!C21=\"\",\"\",IF(Values!C21=\"OK\",1,0))","v":""},{"$f":"IF(Values!D21=\"\",\"\",IF(Values!D21=\"OK\",1,0))","v":""},{"$f":"IF(Values!E21=\"\",\"\",IF(Values!E21=\"OK\",1,0))","v":""},{"$f":"IF(Values!F21=\"\",\"\",IF(Values!F21=\"OK\",1,0))","v":""},{"$f":"IF(Values!G21=\"\",\"\",IF(Values!G21=\"OK\",1,0))","v":""},{"$f":"IF(Values!H21=\"\",\"\",IF(Values!H21=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,null,"not judged but marked","not judged but \nmarked"]
[null,18,{"$f":"IF(Values!C22=\"\",\"\",IF(Values!C22=\"OK\",1,0))","v":""},{"$f":"IF(Values!D22=\"\",\"\",IF(Values!D22=\"OK\",1,0))","v":""},{"$f":"IF(Values!E22=\"\",\"\",IF(Values!E22=\"OK\",1,0))","v":""},{"$f":"IF(Values!F22=\"\",\"\",IF(Values!F22=\"OK\",1,0))","v":""},{"$f":"IF(Values!G22=\"\",\"\",IF(Values!G22=\"OK\",1,0))","v":""},{"$f":"IF(Values!H22=\"\",\"\",IF(Values!H22=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,19,{"$f":"IF(Values!C23=\"\",\"\",IF(Values!C23=\"OK\",1,0))","v":""},{"$f":"IF(Values!D23=\"\",\"\",IF(Values!D23=\"OK\",1,0))","v":""},{"$f":"IF(Values!E23=\"\",\"\",IF(Values!E23=\"OK\",1,0))","v":""},{"$f":"IF(Values!F23=\"\",\"\",IF(Values!F23=\"OK\",1,0))","v":""},{"$f":"IF(Values!G23=\"\",\"\",IF(Values!G23=\"OK\",1,0))","v":""},{"$f":"IF(Values!H23=\"\",\"\",IF(Values!H23=\"OK\",1,0))","v":""},null,{"$f":"IF(COUNT(D22:H22)=5,SUM(D22:H22),\"\")","v":""},"","","",1,1,"","","","",""]
[null,20,{"$f":"IF(Values!C24=\"\",\"\",IF(Values!C24=\"OK\",1,0))","v":""},{"$f":"IF(Values!D24=\"\",\"\",IF(Values!D24=\"OK\",1,0))","v":""},{"$f":"IF(Values!E24=\"\",\"\",IF(Values!E24=\"OK\",1,0))","v":""},{"$f":"IF(Values!F24=\"\",\"\",IF(Values!F24=\"OK\",1,0))","v":""},{"$f":"IF(Values!G24=\"\",\"\",IF(Values!G24=\"OK\",1,0))","v":""},{"$f":"IF(Values!H24=\"\",\"\",IF(Values!H24=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,21,{"$f":"IF(Values!C25=\"\",\"\",IF(Values!C25=\"OK\",1,0))","v":""},{"$f":"IF(Values!D25=\"\",\"\",IF(Values!D25=\"OK\",1,0))","v":""},{"$f":"IF(Values!E25=\"\",\"\",IF(Values!E25=\"OK\",1,0))","v":""},{"$f":"IF(Values!F25=\"\",\"\",IF(Values!F25=\"OK\",1,0))","v":""},{"$f":"IF(Values!G25=\"\",\"\",IF(Values!G25=\"OK\",1,0))","v":""},{"$f":"IF(Values!H25=\"\",\"\",IF(Values!H25=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,22,{"$f":"IF(Values!C26=\"\",\"\",IF(Values!C26=\"OK\",1,0))","v":""},{"$f":"IF(Values!D26=\"\",\"\",IF(Values!D26=\"OK\",1,0))","v":""},{"$f":"IF(Values!E26=\"\",\"\",IF(Values!E26=\"OK\",1,0))","v":""},{"$f":"IF(Values!F26=\"\",\"\",IF(Values!F26=\"OK\",1,0))","v":""},{"$f":"IF(Values!G26=\"\",\"\",IF(Values!G26=\"OK\",1,0))","v":""},{"$f":"IF(Values!H26=\"\",\"\",IF(Values!H26=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,23,{"$f":"IF(Values!C27=\"\",\"\",IF(Values!C27=\"OK\",1,0))","v":""},{"$f":"IF(Values!D27=\"\",\"\",IF(Values!D27=\"OK\",1,0))","v":""},{"$f":"IF(Values!E27=\"\",\"\",IF(Values!E27=\"OK\",1,0))","v":""},{"$f":"IF(Values!F27=\"\",\"\",IF(Values!F27=\"OK\",1,0))","v":""},{"$f":"IF(Values!G27=\"\",\"\",IF(Values!G27=\"OK\",1,0))","v":""},{"$f":"IF(Values!H27=\"\",\"\",IF(Values!H27=\"OK\",1,0))","v":""},null,{"$f":"IF(COUNT(D26:H26)=5,SUM(D26:H26),\"\")","v":""},"","","",{"$f":"IF((K26=0),\"\",1)","v":1},1,"","","","","",null,"Reference Conditions"]
[null,24,{"$f":"IF(Values!C28=\"\",\"\",IF(Values!C28=\"OK\",1,0))","v":""},{"$f":"IF(Values!D28=\"\",\"\",IF(Values!D28=\"OK\",1,0))","v":""},{"$f":"IF(Values!E28=\"\",\"\",IF(Values!E28=\"OK\",1,0))","v":""},{"$f":"IF(Values!F28=\"\",\"\",IF(Values!F28=\"OK\",1,0))","v":""},{"$f":"IF(Values!G28=\"\",\"\",IF(Values!G28=\"OK\",1,0))","v":""},{"$f":"IF(Values!H28=\"\",\"\",IF(Values!H28=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,25,{"$f":"IF(Values!C29=\"\",\"\",IF(Values!C29=\"OK\",1,0))","v":""},{"$f":"IF(Values!D29=\"\",\"\",IF(Values!D29=\"OK\",1,0))","v":""},{"$f":"IF(Values!E29=\"\",\"\",IF(Values!E29=\"OK\",1,0))","v":""},{"$f":"IF(Values!F29=\"\",\"\",IF(Values!F29=\"OK\",1,0))","v":""},{"$f":"IF(Values!G29=\"\",\"\",IF(Values!G29=\"OK\",1,0))","v":""},{"$f":"IF(Values!H29=\"\",\"\",IF(Values!H29=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,"Numbers of Reference samples OK",{"$f":"E54","v":0},{"$f":"W29+W28","v":0},"NG Ratio",{"$f":"IFERROR(W29/X28,\"\")","v":""}]
[null,26,{"$f":"IF(Values!C30=\"\",\"\",IF(Values!C30=\"OK\",1,0))","v":""},{"$f":"IF(Values!D30=\"\",\"\",IF(Values!D30=\"OK\",1,0))","v":""},{"$f":"IF(Values!E30=\"\",\"\",IF(Values!E30=\"OK\",1,0))","v":""},{"$f":"IF(Values!F30=\"\",\"\",IF(Values!F30=\"OK\",1,0))","v":""},{"$f":"IF(Values!G30=\"\",\"\",IF(Values!G30=\"OK\",1,0))","v":""},{"$f":"IF(Values!H30=\"\",\"\",IF(Values!H30=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,"Numbers of Reference samples NG",{"$f":"G54","v":0}]
[null,27,{"$f":"IF(Values!C31=\"\",\"\",IF(Values!C31=\"OK\",1,0))","v":""},{"$f":"IF(Values!D31=\"\",\"\",IF(Values!D31=\"OK\",1,0))","v":""},{"$f":"IF(Values!E31=\"\",\"\",IF(Values!E31=\"OK\",1,0))","v":""},{"$f":"IF(Values!F31=\"\",\"\",IF(Values!F31=\"OK\",1,0))","v":""},{"$f":"IF(Values!G31=\"\",\"\",IF(Values!G31=\"OK\",1,0))","v":""},{"$f":"IF(Values!H31=\"\",\"\",IF(Values!H31=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","","",null,"Limits for judgement minimum parts of NG (bigger than)",20,50,null,0.39]
[null,28,{"$f":"IF(Values!C32=\"\",\"\",IF(Values!C32=\"OK\",1,0))","v":""},{"$f":"IF(Values!D32=\"\",\"\",IF(Values!D32=\"OK\",1,0))","v":""},{"$f":"IF(Values!E32=\"\",\"\",IF(Values!E32=\"OK\",1,0))","v":""},{"$f":"IF(Values!F32=\"\",\"\",IF(Values!F32=\"OK\",1,0))","v":""},{"$f":"IF(Values!G32=\"\",\"\",IF(Values!G32=\"OK\",1,0))","v":""},{"$f":"IF(Values!H32=\"\",\"\",IF(Values!H32=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,29,{"$f":"IF(Values!C33=\"\",\"\",IF(Values!C33=\"OK\",1,0))","v":""},{"$f":"IF(Values!D33=\"\",\"\",IF(Values!D33=\"OK\",1,0))","v":""},{"$f":"IF(Values!E33=\"\",\"\",IF(Values!E33=\"OK\",1,0))","v":""},{"$f":"IF(Values!F33=\"\",\"\",IF(Values!F33=\"OK\",1,0))","v":""},{"$f":"IF(Values!G33=\"\",\"\",IF(Values!G33=\"OK\",1,0))","v":""},{"$f":"IF(Values!H33=\"\",\"\",IF(Values!H33=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,30,{"$f":"IF(Values!C34=\"\",\"\",IF(Values!C34=\"OK\",1,0))","v":""},{"$f":"IF(Values!D34=\"\",\"\",IF(Values!D34=\"OK\",1,0))","v":""},{"$f":"IF(Values!E34=\"\",\"\",IF(Values!E34=\"OK\",1,0))","v":""},{"$f":"IF(Values!F34=\"\",\"\",IF(Values!F34=\"OK\",1,0))","v":""},{"$f":"IF(Values!G34=\"\",\"\",IF(Values!G34=\"OK\",1,0))","v":""},{"$f":"IF(Values!H34=\"\",\"\",IF(Values!H34=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,31,{"$f":"IF(Values!C35=\"\",\"\",IF(Values!C35=\"OK\",1,0))","v":""},{"$f":"IF(Values!D35=\"\",\"\",IF(Values!D35=\"OK\",1,0))","v":""},{"$f":"IF(Values!E35=\"\",\"\",IF(Values!E35=\"OK\",1,0))","v":""},{"$f":"IF(Values!F35=\"\",\"\",IF(Values!F35=\"OK\",1,0))","v":""},{"$f":"IF(Values!G35=\"\",\"\",IF(Values!G35=\"OK\",1,0))","v":""},{"$f":"IF(Values!H35=\"\",\"\",IF(Values!H35=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,32,{"$f":"IF(Values!C36=\"\",\"\",IF(Values!C36=\"OK\",1,0))","v":""},{"$f":"IF(Values!D36=\"\",\"\",IF(Values!D36=\"OK\",1,0))","v":""},{"$f":"IF(Values!E36=\"\",\"\",IF(Values!E36=\"OK\",1,0))","v":""},{"$f":"IF(Values!F36=\"\",\"\",IF(Values!F36=\"OK\",1,0))","v":""},{"$f":"IF(Values!G36=\"\",\"\",IF(Values!G36=\"OK\",1,0))","v":""},{"$f":"IF(Values!H36=\"\",\"\",IF(Values!H36=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,33,{"$f":"IF(Values!C37=\"\",\"\",IF(Values!C37=\"OK\",1,0))","v":""},{"$f":"IF(Values!D37=\"\",\"\",IF(Values!D37=\"OK\",1,0))","v":""},{"$f":"IF(Values!E37=\"\",\"\",IF(Values!E37=\"OK\",1,0))","v":""},{"$f":"IF(Values!F37=\"\",\"\",IF(Values!F37=\"OK\",1,0))","v":""},{"$f":"IF(Values!G37=\"\",\"\",IF(Values!G37=\"OK\",1,0))","v":""},{"$f":"IF(Values!H37=\"\",\"\",IF(Values!H37=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,34,{"$f":"IF(Values!C38=\"\",\"\",IF(Values!C38=\"OK\",1,0))","v":""},{"$f":"IF(Values!D38=\"\",\"\",IF(Values!D38=\"OK\",1,0))","v":""},{"$f":"IF(Values!E38=\"\",\"\",IF(Values!E38=\"OK\",1,0))","v":""},{"$f":"IF(Values!F38=\"\",\"\",IF(Values!F38=\"OK\",1,0))","v":""},{"$f":"IF(Values!G38=\"\",\"\",IF(Values!G38=\"OK\",1,0))","v":""},{"$f":"IF(Values!H38=\"\",\"\",IF(Values!H38=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,35,{"$f":"IF(Values!C39=\"\",\"\",IF(Values!C39=\"OK\",1,0))","v":""},{"$f":"IF(Values!D39=\"\",\"\",IF(Values!D39=\"OK\",1,0))","v":""},{"$f":"IF(Values!E39=\"\",\"\",IF(Values!E39=\"OK\",1,0))","v":""},{"$f":"IF(Values!F39=\"\",\"\",IF(Values!F39=\"OK\",1,0))","v":""},{"$f":"IF(Values!G39=\"\",\"\",IF(Values!G39=\"OK\",1,0))","v":""},{"$f":"IF(Values!H39=\"\",\"\",IF(Values!H39=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,36,{"$f":"IF(Values!C40=\"\",\"\",IF(Values!C40=\"OK\",1,0))","v":""},{"$f":"IF(Values!D40=\"\",\"\",IF(Values!D40=\"OK\",1,0))","v":""},{"$f":"IF(Values!E40=\"\",\"\",IF(Values!E40=\"OK\",1,0))","v":""},{"$f":"IF(Values!F40=\"\",\"\",IF(Values!F40=\"OK\",1,0))","v":""},{"$f":"IF(Values!G40=\"\",\"\",IF(Values!G40=\"OK\",1,0))","v":""},{"$f":"IF(Values!H40=\"\",\"\",IF(Values!H40=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,37,{"$f":"IF(Values!C41=\"\",\"\",IF(Values!C41=\"OK\",1,0))","v":""},{"$f":"IF(Values!D41=\"\",\"\",IF(Values!D41=\"OK\",1,0))","v":""},{"$f":"IF(Values!E41=\"\",\"\",IF(Values!E41=\"OK\",1,0))","v":""},{"$f":"IF(Values!F41=\"\",\"\",IF(Values!F41=\"OK\",1,0))","v":""},{"$f":"IF(Values!G41=\"\",\"\",IF(Values!G41=\"OK\",1,0))","v":""},{"$f":"IF(Values!H41=\"\",\"\",IF(Values!H41=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,38,{"$f":"IF(Values!C42=\"\",\"\",IF(Values!C42=\"OK\",1,0))","v":""},{"$f":"IF(Values!D42=\"\",\"\",IF(Values!D42=\"OK\",1,0))","v":""},{"$f":"IF(Values!E42=\"\",\"\",IF(Values!E42=\"OK\",1,0))","v":""},{"$f":"IF(Values!F42=\"\",\"\",IF(Values!F42=\"OK\",1,0))","v":""},{"$f":"IF(Values!G42=\"\",\"\",IF(Values!G42=\"OK\",1,0))","v":""},{"$f":"IF(Values!H42=\"\",\"\",IF(Values!H42=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,39,{"$f":"IF(Values!C43=\"\",\"\",IF(Values!C43=\"OK\",1,0))","v":""},{"$f":"IF(Values!D43=\"\",\"\",IF(Values!D43=\"OK\",1,0))","v":""},{"$f":"IF(Values!E43=\"\",\"\",IF(Values!E43=\"OK\",1,0))","v":""},{"$f":"IF(Values!F43=\"\",\"\",IF(Values!F43=\"OK\",1,0))","v":""},{"$f":"IF(Values!G43=\"\",\"\",IF(Values!G43=\"OK\",1,0))","v":""},{"$f":"IF(Values!H43=\"\",\"\",IF(Values!H43=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,40,{"$f":"IF(Values!C44=\"\",\"\",IF(Values!C44=\"OK\",1,0))","v":""},{"$f":"IF(Values!D44=\"\",\"\",IF(Values!D44=\"OK\",1,0))","v":""},{"$f":"IF(Values!E44=\"\",\"\",IF(Values!E44=\"OK\",1,0))","v":""},{"$f":"IF(Values!F44=\"\",\"\",IF(Values!F44=\"OK\",1,0))","v":""},{"$f":"IF(Values!G44=\"\",\"\",IF(Values!G44=\"OK\",1,0))","v":""},{"$f":"IF(Values!H44=\"\",\"\",IF(Values!H44=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,41,{"$f":"IF(Values!C45=\"\",\"\",IF(Values!C45=\"OK\",1,0))","v":""},{"$f":"IF(Values!D45=\"\",\"\",IF(Values!D45=\"OK\",1,0))","v":""},{"$f":"IF(Values!E45=\"\",\"\",IF(Values!E45=\"OK\",1,0))","v":""},{"$f":"IF(Values!F45=\"\",\"\",IF(Values!F45=\"OK\",1,0))","v":""},{"$f":"IF(Values!G45=\"\",\"\",IF(Values!G45=\"OK\",1,0))","v":""},{"$f":"IF(Values!H45=\"\",\"\",IF(Values!H45=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,42,{"$f":"IF(Values!C46=\"\",\"\",IF(Values!C46=\"OK\",1,0))","v":""},{"$f":"IF(Values!D46=\"\",\"\",IF(Values!D46=\"OK\",1,0))","v":""},{"$f":"IF(Values!E46=\"\",\"\",IF(Values!E46=\"OK\",1,0))","v":""},{"$f":"IF(Values!F46=\"\",\"\",IF(Values!F46=\"OK\",1,0))","v":""},{"$f":"IF(Values!G46=\"\",\"\",IF(Values!G46=\"OK\",1,0))","v":""},{"$f":"IF(Values!H46=\"\",\"\",IF(Values!H46=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,43,{"$f":"IF(Values!C47=\"\",\"\",IF(Values!C47=\"OK\",1,0))","v":""},{"$f":"IF(Values!D47=\"\",\"\",IF(Values!D47=\"OK\",1,0))","v":""},{"$f":"IF(Values!E47=\"\",\"\",IF(Values!E47=\"OK\",1,0))","v":""},{"$f":"IF(Values!F47=\"\",\"\",IF(Values!F47=\"OK\",1,0))","v":""},{"$f":"IF(Values!G47=\"\",\"\",IF(Values!G47=\"OK\",1,0))","v":""},{"$f":"IF(Values!H47=\"\",\"\",IF(Values!H47=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,44,{"$f":"IF(Values!C48=\"\",\"\",IF(Values!C48=\"OK\",1,0))","v":""},{"$f":"IF(Values!D48=\"\",\"\",IF(Values!D48=\"OK\",1,0))","v":""},{"$f":"IF(Values!E48=\"\",\"\",IF(Values!E48=\"OK\",1,0))","v":""},{"$f":"IF(Values!F48=\"\",\"\",IF(Values!F48=\"OK\",1,0))","v":""},{"$f":"IF(Values!G48=\"\",\"\",IF(Values!G48=\"OK\",1,0))","v":""},{"$f":"IF(Values!H48=\"\",\"\",IF(Values!H48=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,45,{"$f":"IF(Values!C49=\"\",\"\",IF(Values!C49=\"OK\",1,0))","v":""},{"$f":"IF(Values!D49=\"\",\"\",IF(Values!D49=\"OK\",1,0))","v":""},{"$f":"IF(Values!E49=\"\",\"\",IF(Values!E49=\"OK\",1,0))","v":""},{"$f":"IF(Values!F49=\"\",\"\",IF(Values!F49=\"OK\",1,0))","v":""},{"$f":"IF(Values!G49=\"\",\"\",IF(Values!G49=\"OK\",1,0))","v":""},{"$f":"IF(Values!H49=\"\",\"\",IF(Values!H49=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,46,{"$f":"IF(Values!C50=\"\",\"\",IF(Values!C50=\"OK\",1,0))","v":""},{"$f":"IF(Values!D50=\"\",\"\",IF(Values!D50=\"OK\",1,0))","v":""},{"$f":"IF(Values!E50=\"\",\"\",IF(Values!E50=\"OK\",1,0))","v":""},{"$f":"IF(Values!F50=\"\",\"\",IF(Values!F50=\"OK\",1,0))","v":""},{"$f":"IF(Values!G50=\"\",\"\",IF(Values!G50=\"OK\",1,0))","v":""},{"$f":"IF(Values!H50=\"\",\"\",IF(Values!H50=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,47,{"$f":"IF(Values!C51=\"\",\"\",IF(Values!C51=\"OK\",1,0))","v":""},{"$f":"IF(Values!D51=\"\",\"\",IF(Values!D51=\"OK\",1,0))","v":""},{"$f":"IF(Values!E51=\"\",\"\",IF(Values!E51=\"OK\",1,0))","v":""},{"$f":"IF(Values!F51=\"\",\"\",IF(Values!F51=\"OK\",1,0))","v":""},{"$f":"IF(Values!G51=\"\",\"\",IF(Values!G51=\"OK\",1,0))","v":""},{"$f":"IF(Values!H51=\"\",\"\",IF(Values!H51=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,48,{"$f":"IF(Values!C52=\"\",\"\",IF(Values!C52=\"OK\",1,0))","v":""},{"$f":"IF(Values!D52=\"\",\"\",IF(Values!D52=\"OK\",1,0))","v":""},{"$f":"IF(Values!E52=\"\",\"\",IF(Values!E52=\"OK\",1,0))","v":""},{"$f":"IF(Values!F52=\"\",\"\",IF(Values!F52=\"OK\",1,0))","v":""},{"$f":"IF(Values!G52=\"\",\"\",IF(Values!G52=\"OK\",1,0))","v":""},{"$f":"IF(Values!H52=\"\",\"\",IF(Values!H52=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,49,{"$f":"IF(Values!C53=\"\",\"\",IF(Values!C53=\"OK\",1,0))","v":""},{"$f":"IF(Values!D53=\"\",\"\",IF(Values!D53=\"OK\",1,0))","v":""},{"$f":"IF(Values!E53=\"\",\"\",IF(Values!E53=\"OK\",1,0))","v":""},{"$f":"IF(Values!F53=\"\",\"\",IF(Values!F53=\"OK\",1,0))","v":""},{"$f":"IF(Values!G53=\"\",\"\",IF(Values!G53=\"OK\",1,0))","v":""},{"$f":"IF(Values!H53=\"\",\"\",IF(Values!H53=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,50,{"$f":"IF(Values!C54=\"\",\"\",IF(Values!C54=\"OK\",1,0))","v":""},{"$f":"IF(Values!D54=\"\",\"\",IF(Values!D54=\"OK\",1,0))","v":""},{"$f":"IF(Values!E54=\"\",\"\",IF(Values!E54=\"OK\",1,0))","v":""},{"$f":"IF(Values!F54=\"\",\"\",IF(Values!F54=\"OK\",1,0))","v":""},{"$f":"IF(Values!G54=\"\",\"\",IF(Values!G54=\"OK\",1,0))","v":""},{"$f":"IF(Values!H54=\"\",\"\",IF(Values!H54=\"OK\",1,0))","v":""},null,"","","","",1,1,"","","","",""]
[null,"Sum [Ʃ]",null,"Reference OK",{"$f":"SUM(C4:C53)","v":0},"Reference NG",{"$f":"COUNT(C4:C53) -SUM(C4:C53)","v":0},null,"Pj",{"$f":"IFERROR((1/(COUNT(J4:J53)*5)*(SUM(J4:J53))),\"\")","v":""},{"$f":"IFERROR((1/(COUNT(K4:K53)*5)*(SUM(K4:K53))),\"\")","v":""},null,{"$f":"SUM(M4:M53)","v":0},{"$f":"SUM(N4:N53)","v":50},{"$f":"SUM(O4:O53)","v":50},{"$f":"SUM(P4:P53)","v":0},0,{"$f":"IFERROR((1/(COUNT(R4:R53)*6)*(SUM(R4:R53))),\"\")","v":""},{"$f":"IFERROR((1/(COUNT(S4:S53)*6)*(SUM(S4:S53))),\"\")","v":""}]

{"sheet":"Settings","index":4,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[[6,1,8,7],[13,1,14,4],[23,1,24,4],[23,5,24,7],[25,1,26,4],[25,5,26,7],[19,1,20,4],[19,5,20,7],[21,1,22,4],[21,5,22,7]]}
[]
[]
[]
[]
[]
[]
[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,"Print a pdf of the register \"Visualization\" to a folder of your choice."]
[]
[]
[]
[]
[]
[null,"Guide (A \"How to\" handle the document)"]
[]
[null,"Calculations (Distribution; Graphics; Indices)"]
[]
[null,"Directories (Resolution, Measrumentdevices, Units)"]
[]
[null,"References (Calculation references)"]

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

{"sheet":"References","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,1,8,9],[12,1,13,7]]}
[]
[]
[]
[null,"Calculation in accordance with \"AIAG- MSA fourth edition\", Chapter III, Section C, Page 131 ff."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Detailed references and calculation information are located in the Managment System doc-nr. 1758."]