{"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":33,"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":134,"n_cols":4,"rows_kept":134,"cut":false,"hidden":true,"merged":[[26,3,29,7],[4,2,4,8],[5,1,5,8],[9,3,9,6],[22,3,23,7],[24,3,25,7],[52,2,52,7],[53,2,53,7],[54,2,55,7],[78,2,78,7],[30,3,31,7],[32,3,33,7],[49,2,50,7],[51,2,51,7],[229,2,231,7],[242,6,246,8],[260,1,265,8],[77,2,77,7],[174,6,174,8],[176,6,178,8],[182,6,184,8],[216,2,218,7],[116,1,116,2],[117,1,117,2],[98,1,98,2],[99,1,99,2],[98,3,98,5],[99,3,99,5],[116,3,116,5],[117,3,117,5]]}
[]
[]
[]
[]
[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,"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 choose several options."]
[]
[]
[]
[]
[]
[null,"2.1 Open register \"Values\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Inspector:","Please enter the name of the Inspector"]
[null,"I-Values:","Please enter all values into the column I-Values. The VDA standard is 50 values."]
[]
[]
[]
[null,"3.1 Open register \"Visualization\""]
[null,"3.2 Good Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bowker",null,"Value is smaller than 7,82"]
[null,"Kappa",null,"Value is higher than 0,75"]
[]
[null,"3.3 Bad Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bowker",null,"Value is higher than 7,82"]
[null,"Kappa",null,"Value is smaller than 0,75"]
[]
[]
[]
[null,"Open register \"Settings\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hide or Unhide registers to have a more detailed view into background processes."]

{"sheet":"Visualization","index":1,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[38,2,38,16],[9,14,9,16],[52,0,52,18],[40,2,41,3],[33,2,33,3],[34,2,34,3],[33,4,33,6],[46,8,46,9],[43,2,43,3],[42,2,42,3],[46,13,46,16],[46,5,46,6],[32,10,32,11],[30,11,30,12],[30,8,30,10],[30,5,30,7],[32,2,32,7],[25,2,26,4],[47,2,47,4],[47,5,47,6],[47,10,47,11],[27,2,29,2],[46,2,46,4],[46,10,46,11],[32,8,32,9],[1,2,3,11],[5,12,7,16],[12,2,12,4],[12,5,12,10],[18,2,19,4],[20,2,20,4],[20,5,20,7],[20,9,20,10],[12,14,12,16],[13,14,13,16],[10,2,10,4],[10,5,10,10],[11,2,11,4],[11,5,11,10],[10,14,10,16],[11,14,11,16],[7,2,7,4],[7,5,7,10],[8,2,9,4],[27,8,27,10],[28,8,28,10],[30,3,30,4],[29,8,29,10],[27,11,27,12],[28,11,28,12],[29,11,29,12],[27,3,27,4],[28,3,28,4],[29,3,29,4],[27,5,27,7],[28,5,28,7],[29,5,29,7],[25,5,25,12],[26,5,26,7],[26,8,26,10],[26,11,26,12],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[20,11,20,13],[21,11,21,13],[22,11,22,13],[22,5,22,7],[22,9,22,10],[23,11,23,12],[23,2,24,7],[21,2,21,4],[21,5,21,7],[21,9,21,10],[22,2,22,4],[8,5,9,10],[18,5,19,13],[14,14,14,16],[15,14,15,16],[45,13,45,16],[45,2,45,7],[30,13,30,15],[39,2,39,16],[43,4,43,16],[42,13,42,16],[42,4,42,8],[42,9,42,12],[40,13,41,16],[40,4,41,8],[40,9,41,12],[18,15,22,17],[25,13,26,15],[37,2,37,7],[34,4,34,6],[33,7,33,9],[34,7,34,9],[33,10,33,12],[34,10,34,12],[27,13,27,15],[28,13,28,15],[29,13,29,15]]}
[]
[null,null,"Attr(1)_Attributive Measurementsystem capability analysis: Without 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,null,"Feature \nDependent"]
[]
[null,null,"Unit:",null,null,null,null,null,null,{"$f":"IF(AND(F23=\"Only USL/LSL is specified\",L22<>\"\"),\"\",\"USL:\")","v":"USL:"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F23=\"One side is limited\",\"\",IF(AND(L21<>\"\",F23=\"One side is limited\"),\"\",IF(AND(F23=\"Only USL/LSL is specified\",L21<>\"\"),\"\",\"LSL:\")))","v":"LSL:"}]
[null,null,null,null,null,null,null,null,null,"KPC:"]
[null,null,"Measurment Results",null,null,null,null,null,null,null,null,{"$f":"IF(OR(L23<>\"\",M23<>\"\"),\"Feature is special\",\"No KPC feature\")","v":"No KPC feature"}]
[]
[null,null,"Decision combinations",null,null,{"$f":"IF(Values!D5=\"\",\"Inspector A\",Values!D5)","v":"Inspector A"},null,null,null,null,null,null,null,"Ʃ"]
[null,null,null,null,null,"Good",null,null,"Mixed",null,null,"Bad"]
[null,null,{"$f":"IF(Values!G5=\"\",\"Inspector B\",Values!G5)","v":"Inspector B"},"Good",null,{"$f":"Calculation!AI4","v":""},null,null,{"$f":"Calculation!AK4","v":""},null,null,{"$f":"Calculation!AM4","v":""},null,{"$f":"IF(SUM(F28:M28)=0,\"\",SUM(F28:M28))","v":""}]
[null,null,null,"Mixed",null,{"$f":"Calculation!AI6","v":""},null,null,{"$f":"Calculation!AK6","v":""},null,null,{"$f":"Calculation!AM6","v":""},null,{"$f":"IF(SUM(F29:M29)=0,\"\",SUM(F29:M29))","v":""}]
[null,null,null,"Bad",null,{"$f":"Calculation!AI8","v":""},null,null,{"$f":"Calculation!AK8","v":""},null,null,{"$f":"Calculation!AM8","v":""},null,""]
[null,null,null,"Ʃ",null,{"$f":"IF(SUM(F28:H30)=0,\"\",SUM(F28:H30))","v":""},null,null,{"$f":"IF(SUM(I28:K30)=0,\"\",SUM(I28:K30))","v":""},null,null,{"$f":"IF(SUM(L28:M30)=0,\"\",SUM(L28:M30))","v":""}]
[]
[null,null,"Valuation numbers"]
[null,null,"X1",null,"X2",null,null,"X3",null,null,"Ʃ"]
[null,null,{"$f":"Calculation!AG16","v":""},null,{"$f":"Calculation!AI16","v":""},null,null,{"$f":"Calculation!AK16","v":""},null,null,{"$f":"IF(AND(C35=\"\",E35=\"\",H35=\"\"),\"\",SUM(C35:J35))","v":""}]
[]
[]
[null,null,"Bowker test of symetry"]
[null,null,"H1: Both Inspectors do not measured compareble results"]
[null,null,"H0: Both Inspectors measured compareble results"]
[null,null,"Test level",null,"Critical values",null,null,null,null,null,null,null,null,"Test value"]
[]
[null,null,"α = 5 %",null,7.8150000000000004,null,null,null,null,"<",null,null,null,{"$f":"IF(Calculation!D45<240,\"\",IF(AND(F31=0,I31=0,L31=0,N30=0,N29=0,N28=0),\"\",K35))","v":""}]
[null,null,"Test result",null,{"$f":"IF(Calculation!D45<240,\"\",IF(N43=\"\",\"\",IF(N43>E43,\"H1 can not be refuted\",\"H0 can not be refuted\")))","v":""}]
[]
[null,null,"Kappa coefficient test",null,null,null,null,null,null,null,null,null,null,"Capability"]
[null,null,"κ",null,null,{"$f":"IF(Calculation!D45<240,\"\",IF(Calculation!AI34=\"\",\"\",Calculation!AI34))","v":""},null,">",0.75,null,null,null,null,{"$f":"IF(Calculation!D45<240,\"\",IF(OR(N43>E43,F47<I47),\"NG\",\"Approved\"))","v":""}]
[]
[]
[]
[]
[]
["Please enter the collected results into the register \"Values\""]

{"sheet":"Values","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,1,1,4],[4,1,6,1],[4,3,4,4],[4,6,4,7]]}
[null,"Values"]
[]
[]
[]
[null,"Nr.","Inspector A",null,null,"Inspector B"]
[]
[null,null,"Measurment 1","Measurment 2","Measurment 3","Measurment 1","Measurment 2","Measurment 3"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]

{"sheet":"Calculation","index":3,"n_rows":45,"n_cols":41,"rows_kept":45,"cut":false,"hidden":true,"merged":[[44,1,44,2],[44,3,44,4],[1,2,1,4],[1,5,1,7],[1,1,2,1],[1,16,1,18],[1,10,1,12],[1,13,1,15],[44,6,44,7],[35,34,35,36],[37,32,39,32],[1,21,1,29],[1,32,2,33],[1,34,1,39],[7,34,8,35],[7,36,8,37],[7,38,8,39],[13,32,14,33],[13,34,14,35],[13,36,14,37],[13,38,14,39],[3,32,8,32],[3,33,4,33],[3,34,4,35],[3,36,4,37],[3,38,4,39],[7,33,8,33],[5,33,6,33],[5,34,6,35],[5,36,6,37],[5,38,6,39],[33,34,33,36],[24,38,26,40],[24,32,26,33],[15,38,16,39],[20,32,20,40],[21,32,21,40],[22,32,23,33],[22,38,23,40],[15,32,16,33],[15,34,16,35],[15,36,16,37],[9,38,9,39],[9,40,9,41],[1,40,2,41],[2,34,2,35],[32,34,32,36],[2,36,2,37],[2,38,2,39],[3,40,4,41],[5,40,6,41],[40,32,41,36],[42,33,42,35],[43,33,43,35],[44,33,44,35],[0,1,0,13],[11,32,12,39],[18,32,19,39],[30,32,31,36],[24,34,26,37],[22,34,23,37],[27,32,28,33],[27,34,28,40],[7,40,8,41],[9,32,9,33],[9,34,9,35],[9,36,9,37]]}
[null,"Measurement Capability_Attributive",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,"Measurement Result"]
[null,"Part","Inspector A",null,null,"Inspector B",null,null,null,null,"Result Inspector A",null,null,"Result Inspector B",null,null,"Result of both Inspectors",null,null,null,null,"Special calculation",null,null,null,null,null,null,null,null,null,null,"Decision combinations",null,"Inspector A",null,null,null,null,null,"Ʃ"]
[null,null,"Measurement 1","Measurement 2","Measurement 3","Measurement 1","Measurement 2","Measurement 3",null,null,"Good","Mixed","Bad","Good","Mixed","Bad","Good","Mixed","Bad",null,null,"Good-Good","Mixed-Good","Bad-Good","Good-Mixed","Mixed-Mixed","Bad-Mixed","Good-Bad","Mixed-Bad","Bad-Bad",null,null,null,null,"Good",null,"Mixed",null,"Bad"]
[null,1,{"$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,null,{"$f":"IF(SUM(C4:E4)=3,1,\"\")","v":""},{"$f":"IF(AND(0<SUM(C4:E4),3>SUM(C4:E4)),1,\"\")","v":""},{"$f":"IF(OR(C4=\"\",D4=\"\",E4=\"\"),\"\",IF(SUM(C4:E4)=0,1,\"\"))","v":""},{"$f":"IF(SUM(F4:H4)=3,1,\"\")","v":""},{"$f":"IF(AND(0<SUM(F4:H4),3>SUM(F4:H4)),1,\"\")","v":""},{"$f":"IF(OR(F4=\"\",G4=\"\",H4=\"\"),\"\",IF(SUM(F4:H4)=0,1,\"\"))","v":""},{"$f":"IF(SUM(C4:H4)=6,1,\"\")","v":""},{"$f":"IF(AND(0<SUM(C4:H4),6>SUM(C4:H4)),1,\"\")","v":""},{"$f":"IF(OR(C4=\"\",D4=\"\",E4=\"\",F4=\"\",G4=\"\",H4=\"\"),\"\",IF(SUM(C4:H4)=0,1,\"\"))","v":""},null,null,{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(K4=\"\",N4=\"\"),0,IF(K4=N4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(L4=\"\",N4=\"\"),0,IF(L4=N4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(M4=\"\",N4=\"\"),0,IF(M4=N4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(K4=\"\",O4=\"\"),0,IF(K4=O4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(L4=\"\",O4=\"\"),0,IF(L4=O4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(M4=\"\",O4=\"\"),0,IF(M4=O4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(K4=\"\",P4=\"\"),0,IF(K4=P4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(L4=\"\",P4=\"\"),0,IF(L4=P4,1,0)))","v":""},{"$f":"IF(SUM(K4:S4)=0,\"\",IF(OR(M4=\"\",S4=\"\"),0,IF(M4=S4,1,0)))","v":""},null,null,"Inspector B","Good",{"$f":"$V$45","v":""},"",{"$f":"$W$45","v":""},"",{"$f":"$X$45","v":""},"",{"$f":"AI4+AK4+AM4","v":{"$error":"#VALUE!"}}]
[null,2,{"$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,null,"","","","","","","","","",null,null,{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(K5=\"\",N5=\"\"),0,IF(K5=N5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(L5=\"\",N5=\"\"),0,IF(L5=N5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(M5=\"\",N5=\"\"),0,IF(M5=N5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(K5=\"\",O5=\"\"),0,IF(K5=O5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(L5=\"\",O5=\"\"),0,IF(L5=O5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(M5=\"\",O5=\"\"),0,IF(M5=O5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(K5=\"\",P5=\"\"),0,IF(K5=P5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(L5=\"\",P5=\"\"),0,IF(L5=P5,1,0)))","v":""},{"$f":"IF(SUM(K5:S5)=0,\"\",IF(OR(M5=\"\",S5=\"\"),0,IF(M5=S5,1,0)))","v":""},null,null,null,null,"","","","","",""]
[null,3,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,null,"Mixed",{"$f":"$Y$45","v":""},"",{"$f":"$Z$45","v":""},"",{"$f":"$AA$45","v":""},{"$f":"$AA$45","v":""},{"$f":"AI6+AK6+AM6","v":{"$error":"#VALUE!"}}]
[null,4,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,null,null,"","","","","",""]
[null,5,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,null,"Bad",{"$f":"$AB$45","v":""},{"$f":"$AB$45","v":""},{"$f":"$AC$45","v":""},{"$f":"$AC$45","v":""},{"$f":"$AD$45","v":""},"",{"$f":"AI8+AK8+AM8","v":{"$error":"#VALUE!"}}]
[null,6,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,null,null,"","","","","",""]
[null,7,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"Ʃ",null,{"$f":"AI4+AI6+AI8","v":{"$error":"#VALUE!"}},null,{"$f":"(AK4+AK6+AK8)","v":{"$error":"#VALUE!"}},null,{"$f":"AM4+AM6+AM8","v":{"$error":"#VALUE!"}},null,{"$f":"IF(SUM(AO4:AP9)=0,\"\",AO4+AO6+AO8)","v":{"$error":"#VALUE!"}}]
[null,8,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,9,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"Valuation numbers"]
[null,10,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,11,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"X1",null,"X2",null,"X3",null,"Ʃ"]
[null,12,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,13,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,{"$f":"IFERROR(IF(AND($AK$4=0,$AI$6=0),0,((($AK$4-$AI$6)^2)/($AK$4+$AI$6))),\"\")","v":""},{"$f":"((($AJ$38-$AI$39)^2)/($AJ$38+$AI$39))","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(IF(AND($AM$4=0,$AI$8=0),0,((($AM$4-$AI$8)^2)/($AM$4+$AI$8))),\"\")","v":""},{"$f":"((($AK$38-$AI$40)^2)/($AK$38+$AI$40))","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(IF(AND($AM$6=0,$AK$8=0),0,((($AM$6-$AK$8)^2)/($AM$6+$AK$8))),\"\")","v":""},{"$f":"((($AK$39-$AJ$40)^2)/($AK$39+$AJ$40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(AG16=\"\",AI16=\"\",AK16=\"\"),\"\",(SUM(AK16,AI16,AG16)))","v":""}]
[null,14,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,15,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,16,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"Bowker test of symetry"]
[null,17,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,18,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"H0: Both Inspector do not measured compareble results"]
[null,19,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"H1: Both Inspector measured compareble results"]
[null,20,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"test level",null,"critical value",null,null,null,"test value"]
[null,21,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,22,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"α = 5 %",null,7.8150000000000004,null,null,null,{"$f":"AM16","v":""}]
[null,23,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,24,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,25,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"Test result",null,{"$f":"IF(AM25=\"\",\"\",IF(AM25<AI25,\"H1 can not be refuted\",\"H0 can not be refuted\"))","v":""}]
[null,26,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,27,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,28,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"The kappa coeffient"]
[null,29,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,30,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"Po","Pe","κ"]
[null,31,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,{"$f":"IFERROR(IF(AO10=\"\",\"\",IF(AO10=0,\"\",(AI4+AK6+AM8)/AO10)),\"\")","v":""},{"$f":"IFERROR(IF(AO10=\"\",\"\",IF(AO10=0,\"\",((AO4/AO10)*(AI10/AO10))+((AO6/AO10)*(AK10/AO10))+((AO8/AO10)*(AM10/AO10)))),\"\")","v":""},{"$f":"IF(AG34=\"\",\"\",(AG34-AH34)/(1-AH34))","v":""}]
[null,32,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,33,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,34,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,35,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,36,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,37,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,38,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"The kappa coeffient"]
[null,39,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","",""]
[null,40,{"$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,null,"","","","","","","","","",null,null,"","","","","","","","","",null,null,"USL",{"$f":"VALUE(Visualization!L21)","v":0}]
[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,"LSL",{"$f":"VALUE(Visualization!L22)","v":0}]
[null,"Entered results",null,{"$f":"COUNT(C4:H43)","v":0},null,null,"Sum [Ʃ]",null,null,null,{"$f":"IF(SUM($K$4:$S$43)=0,\"\",SUM(K4:K43))","v":""},{"$f":"IF(SUM($K$4:$S$43)=0,\"\",SUM(L4:L43))","v":""},"","","","","","","",null,"","","","","","","","",{"$f":"IF(SUM($K$4:$S$43)=0,\"\",SUM(AC4:AC43))","v":""},""]

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