{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Visualization","Graphics","Values","Calculation","Settings","Directories","References"],"not_rendered":{"charts":9,"images":23,"macros":1,"external_links":0,"defined_names":64,"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":233,"n_cols":7,"rows_kept":233,"cut":false,"hidden":true,"merged":[[188,1,189,8],[201,1,202,8],[198,1,199,8],[374,1,379,8],[37,3,37,7],[113,1,113,2],[113,3,113,7],[146,1,146,2],[146,3,146,7],[148,3,148,7],[288,6,288,8],[290,6,292,8],[296,6,298,8],[330,2,332,7],[343,2,345,7],[356,6,360,8],[171,6,172,8],[116,1,116,2],[116,3,116,7],[147,1,147,2],[147,3,147,7],[148,1,148,2],[149,1,149,2],[149,3,149,7],[156,6,158,8],[160,6,162,8],[165,6,167,8],[62,2,63,7],[80,2,80,7],[114,1,114,2],[114,3,114,7],[115,1,115,2],[115,3,115,7],[60,2,61,7],[29,3,32,7],[33,3,34,7],[35,3,36,7],[38,3,39,7],[54,2,55,7],[56,2,56,7],[57,2,57,7],[58,2,58,7],[59,2,59,7],[4,2,4,8],[5,1,5,8],[9,3,9,6],[25,3,26,7],[27,3,28,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,"Real Value:","Enter the value of your Master."]
[null,"USL:","Enter Upper Sepcification Limit"]
[null,"LSL:","Enter Lower Specification Limit"]
[null,"Feature is limited:","Use the dropdown to select if the feature is limited on one side. An Example of a limited feature is the roughness of a surface (can not be smaller then 0)"]
[]
[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,"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,"%RE:",null,"Value is smaller or equal to 5%"]
[null,"Cg:",null,"Value is higher than 1.33."]
[null,"Cgk:",null,"Value is higher than 1.33."]
[null,"Test of normality:",null,"Values are normal distributed."]
[]
[null,"3.3 Bad Result"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"%RE:",null,"Value is bigger then 5%"]
[null,"Cg:",null,"Value is bigger then 1.33."]
[null,"Cgk:",null,"Value is smaller then 1.33."]
[null,"Test of normality:",null,"Values are normal distributed."]
[]
[]
[]
[null,"Open register \"Settings\""]
[]
[]
[null,null,null,null,null,null,"Specify what the chart should scale to (Tolerance; Max/Min value; Custom)"]
[]
[]
[]
[null,null,null,null,null,null,"Change the scaling factor to adapt the distance to the specification limits."]
[]
[]
[]
[]
[null,null,null,null,null,null,"Change the scaling factor to adapt the distance to the max and min value."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Enter the data to which the chart should scale on"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hide or Unhide registers to have a more detailed view into background processes."]
[]
[]
[]
[null,"Important: This function should only be used by an experienced user. Furthermore, these adjustments should rather be communicated to the quality department."]
[]
[null,"In some cased the Normal distribution test in the sheet fail."]
[]
[]
[]
[]
[]
[]
[]
[null,"The tab \"Calculation\" allows you to influence the distribution calculation. Therefore, it is possible to determine the type of distribution by a manual assessment. "]
[]
[null,"For this the field must be filled with the reason for the manual judgment. Then the test result switches to OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If any one of the normality tests ist OK, the result for the MSA1 with switsch to Approved, without any"]
[null,"index"]

{"sheet":"Visualization","index":1,"n_rows":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,1,72,15],[83,10,83,14],[61,4,61,5],[64,4,64,5],[86,10,86,14],[80,10,80,14],[35,4,35,6],[61,2,61,3],[59,2,59,3],[58,2,58,3],[58,4,58,5],[53,13,53,14],[66,2,66,14],[55,2,55,4],[54,2,54,4],[55,13,55,14],[54,13,54,14],[64,2,64,3],[51,5,51,8],[52,5,52,8],[53,5,53,8],[54,5,54,8],[55,5,55,8],[58,14,61,14],[1,1,2,12],[9,2,9,4],[9,5,9,10],[12,13,12,14],[10,2,10,4],[10,5,10,10],[61,6,61,11],[64,6,64,11],[34,10,34,14],[34,8,34,9],[51,13,51,14],[52,13,52,14],[36,8,36,10],[35,8,35,9],[34,2,34,3],[35,2,35,3],[34,4,34,6],[58,6,58,11],[63,6,63,8],[60,6,60,8],[53,10,53,12],[54,10,54,12],[55,10,55,12],[11,13,11,14],[13,13,13,14],[9,13,9,14],[8,2,8,4],[8,5,8,10],[10,13,10,14],[7,13,7,14],[8,13,8,14],[5,2,5,4],[5,5,5,10],[6,2,7,4],[6,5,7,10],[3,12,5,14],[12,2,12,4],[12,5,12,10],[11,2,11,4],[11,5,11,10],[16,5,17,12],[16,14,20,15],[18,2,18,4],[18,5,18,7],[18,9,18,10],[18,11,18,12],[19,2,19,4],[19,5,19,7],[19,9,19,10],[19,11,19,12],[20,2,20,4],[20,5,20,7],[20,9,20,10],[20,11,20,12],[16,2,17,4],[24,2,24,3],[24,7,24,10],[25,2,25,3],[25,7,25,10],[26,2,26,3],[26,7,26,10],[21,11,21,12],[21,2,22,5],[23,2,23,3],[23,7,23,10],[30,2,30,3],[30,7,30,10],[31,2,31,3],[31,7,31,10],[32,2,32,3],[32,7,32,10],[27,2,27,3],[27,7,27,10],[28,2,28,3],[28,7,28,10],[29,2,29,3],[29,7,29,10],[33,2,33,3],[33,7,33,10],[49,2,49,5],[51,10,51,12],[52,10,52,12],[51,2,51,4],[52,2,52,4],[53,2,53,4],[57,6,57,8],[56,2,57,5]]}
[]
[null,"   M1_Measurementsystemanalysis"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Feature Independent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($R$66=\"No\",$K$75<$K$87),1,\"\")","v":""}]
[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,"Resolution:",null,null,null,null,null,null,null,null,null,"Released by (ID):"]
[null,null,"Master Number:",null,null,null,null,null,null,null,null,null,"Released by:"]
[null,null,"Date of Data collection:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($R$65=\"No\",$K$68<$K$86),1,\"\")","v":""}]
[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,{"$f":"IF(AND(F21=\"Only USL/LSL is specified\",L20<>\"\"),\"\",\"USL:\")","v":"USL:"}]
[null,null,"Real Value:",null,null,null,null,null,null,{"$f":"IF(F21=\"One side is limited\",\"\",IF(AND(L19<>\"\",F21=\"One side is limited\"),\"\",IF(AND(F21=\"Only USL/LSL is specified\",L19<>\"\"),\"\",\"LSL:\")))","v":"LSL:"}]
[null,null,"Limitation:",null,null,null,null,null,null,"KPC:"]
[null,null,"Measurement data",null,null,null,null,null,null,null,null,{"$f":"IF(OR(L21<>\"\",M21<>\"\"),\"Feature is special\",\"No KPC feature\")","v":"No KPC feature"}]
[]
[null,null,"1 - 10",null,null,"11 - 20",null,"21 - 30",null,null,null,null,"31 - 40",null,"41 - 50"]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C4=\"\",Values!C4,IF(Calculation!$AJ$50=1,Values!C4,IF(Values!C4=\"\",\"\"\"\",FIXED(Values!C4,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C14=\"\",Values!C14,IF(Calculation!$AJ$50=1,Values!C14,IF(Values!C14=\"\",\"\"\"\",FIXED(Values!C14,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C24=\"\",,IF(Calculation!$AJ$50=1,Values!C24,IF(Values!C24=\"\",\"\"\"\",FIXED(Values!C24,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C34=\"\",Values!C34,IF(Calculation!$AJ$50=1,Values!C34,IF(Values!C34=\"\",\"\"\"\",FIXED(Values!C34,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C44=\"\",Values!C44,IF(Calculation!$AJ$50=1,Values!C44,IF(Values!C44=\"\",\"\"\"\",FIXED(Values!C44,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C5=\"\",Values!C5,IF(Calculation!$AJ$50=1,Values!C5,IF(Values!C5=\"\",\"\"\"\",FIXED(Values!C5,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C15=\"\",Values!C15,IF(Calculation!$AJ$50=1,Values!C15,IF(Values!C15=\"\",\"\"\"\",FIXED(Values!C15,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C25=\"\",,IF(Calculation!$AJ$50=1,Values!C25,IF(Values!C25=\"\",\"\"\"\",FIXED(Values!C25,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C35=\"\",Values!C35,IF(Calculation!$AJ$50=1,Values!C35,IF(Values!C35=\"\",\"\"\"\",FIXED(Values!C35,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C45=\"\",Values!C45,IF(Calculation!$AJ$50=1,Values!C45,IF(Values!C45=\"\",\"\"\"\",FIXED(Values!C45,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C6=\"\",Values!C6,IF(Calculation!$AJ$50=1,Values!C6,IF(Values!C6=\"\",\"\"\"\",FIXED(Values!C6,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C16=\"\",Values!C16,IF(Calculation!$AJ$50=1,Values!C16,IF(Values!C16=\"\",\"\"\"\",FIXED(Values!C16,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C26=\"\",,IF(Calculation!$AJ$50=1,Values!C26,IF(Values!C26=\"\",\"\"\"\",FIXED(Values!C26,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C36=\"\",Values!C36,IF(Calculation!$AJ$50=1,Values!C36,IF(Values!C36=\"\",\"\"\"\",FIXED(Values!C36,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C46=\"\",Values!C46,IF(Calculation!$AJ$50=1,Values!C46,IF(Values!C46=\"\",\"\"\"\",FIXED(Values!C46,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C7=\"\",Values!C7,IF(Calculation!$AJ$50=1,Values!C7,IF(Values!C7=\"\",\"\"\"\",FIXED(Values!C7,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C17=\"\",Values!C17,IF(Calculation!$AJ$50=1,Values!C17,IF(Values!C17=\"\",\"\"\"\",FIXED(Values!C17,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C27=\"\",,IF(Calculation!$AJ$50=1,Values!C27,IF(Values!C27=\"\",\"\"\"\",FIXED(Values!C27,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C37=\"\",Values!C37,IF(Calculation!$AJ$50=1,Values!C37,IF(Values!C37=\"\",\"\"\"\",FIXED(Values!C37,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C47=\"\",Values!C47,IF(Calculation!$AJ$50=1,Values!C47,IF(Values!C47=\"\",\"\"\"\",FIXED(Values!C47,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C8=\"\",Values!C8,IF(Calculation!$AJ$50=1,Values!C8,IF(Values!C8=\"\",\"\"\"\",FIXED(Values!C8,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C18=\"\",Values!C18,IF(Calculation!$AJ$50=1,Values!C18,IF(Values!C18=\"\",\"\"\"\",FIXED(Values!C18,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C28=\"\",,IF(Calculation!$AJ$50=1,Values!C28,IF(Values!C28=\"\",\"\"\"\",FIXED(Values!C28,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C38=\"\",Values!C38,IF(Calculation!$AJ$50=1,Values!C38,IF(Values!C38=\"\",\"\"\"\",FIXED(Values!C38,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C48=\"\",Values!C48,IF(Calculation!$AJ$50=1,Values!C48,IF(Values!C48=\"\",\"\"\"\",FIXED(Values!C48,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C9=\"\",Values!C9,IF(Calculation!$AJ$50=1,Values!C9,IF(Values!C9=\"\",\"\"\"\",FIXED(Values!C9,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C19=\"\",Values!C19,IF(Calculation!$AJ$50=1,Values!C19,IF(Values!C19=\"\",\"\"\"\",FIXED(Values!C19,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C29=\"\",,IF(Calculation!$AJ$50=1,Values!C29,IF(Values!C29=\"\",\"\"\"\",FIXED(Values!C29,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C39=\"\",Values!C39,IF(Calculation!$AJ$50=1,Values!C39,IF(Values!C39=\"\",\"\"\"\",FIXED(Values!C39,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C49=\"\",Values!C49,IF(Calculation!$AJ$50=1,Values!C49,IF(Values!C49=\"\",\"\"\"\",FIXED(Values!C49,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C10=\"\",Values!C10,IF(Calculation!$AJ$50=1,Values!C10,IF(Values!C10=\"\",\"\"\"\",FIXED(Values!C10,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C20=\"\",Values!C20,IF(Calculation!$AJ$50=1,Values!C20,IF(Values!C20=\"\",\"\"\"\",FIXED(Values!C20,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C30=\"\",,IF(Calculation!$AJ$50=1,Values!C30,IF(Values!C30=\"\",\"\"\"\",FIXED(Values!C30,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C40=\"\",Values!C40,IF(Calculation!$AJ$50=1,Values!C40,IF(Values!C40=\"\",\"\"\"\",FIXED(Values!C40,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C50=\"\",Values!C50,IF(Calculation!$AJ$50=1,Values!C50,IF(Values!C50=\"\",\"\"\"\",FIXED(Values!C50,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C11=\"\",Values!C11,IF(Calculation!$AJ$50=1,Values!C11,IF(Values!C11=\"\",\"\"\"\",FIXED(Values!C11,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C21=\"\",Values!C21,IF(Calculation!$AJ$50=1,Values!C21,IF(Values!C21=\"\",\"\"\"\",FIXED(Values!C21,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C31=\"\",,IF(Calculation!$AJ$50=1,Values!C31,IF(Values!C31=\"\",\"\"\"\",FIXED(Values!C31,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C41=\"\",Values!C41,IF(Calculation!$AJ$50=1,Values!C41,IF(Values!C41=\"\",\"\"\"\",FIXED(Values!C41,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C51=\"\",Values!C51,IF(Calculation!$AJ$50=1,Values!C51,IF(Values!C51=\"\",\"\"\"\",FIXED(Values!C51,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C12=\"\",Values!C12,IF(Calculation!$AJ$50=1,Values!C12,IF(Values!C12=\"\",\"\"\"\",FIXED(Values!C12,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C22=\"\",Values!C22,IF(Calculation!$AJ$50=1,Values!C22,IF(Values!C22=\"\",\"\"\"\",FIXED(Values!C22,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C32=\"\",,IF(Calculation!$AJ$50=1,Values!C32,IF(Values!C32=\"\",\"\"\"\",FIXED(Values!C32,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C42=\"\",Values!C42,IF(Calculation!$AJ$50=1,Values!C42,IF(Values!C42=\"\",\"\"\"\",FIXED(Values!C42,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C52=\"\",Values!C52,IF(Calculation!$AJ$50=1,Values!C52,IF(Values!C52=\"\",\"\"\"\",FIXED(Values!C52,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C13=\"\",Values!C13,IF(Calculation!$AJ$50=1,Values!C13,IF(Values!C13=\"\",\"\"\"\",FIXED(Values!C13,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C23=\"\",Values!C23,IF(Calculation!$AJ$50=1,Values!C23,IF(Values!C23=\"\",\"\"\"\",FIXED(Values!C23,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C33=\"\",,IF(Calculation!$AJ$50=1,Values!C33,IF(Values!C33=\"\",\"\"\"\",FIXED(Values!C33,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,null,null,null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C43=\"\",Values!C43,IF(Calculation!$AJ$50=1,Values!C43,IF(Values!C43=\"\",\"\"\"\",FIXED(Values!C43,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""},null,{"$f":"IF(OR($F$52=\"\",Calculation!$AJ$50=\"\"),\"\",IF(Values!C53=\"\",Values!C53,IF(Calculation!$AJ$50=1,Values!C53,IF(Values!C53=\"\",\"\"\"\",FIXED(Values!C53,LEN(Calculation!$AJ$50)-2,FALSE)))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Characteristics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($R$81=\"No\",#REF!<$K$80),1,\"\")","v":{"$error":"#REF!"}}]
[null,null,"Average:",null,null,{"$f":"IF(Values!B53=\"\",\"\",Calculation!O6)","v":""},null,null,null,null,"Max. Value:",null,null,{"$f":"IF(Values!B53=\"\",\"\",Calculation!AJ7)","v":""}]
[null,null,"Span:",null,null,{"$f":"IF(Values!B53=\"\",\"\",Calculation!AJ9)","v":""},null,null,null,null,"Min. Value:",null,null,{"$f":"IF(Values!B53=\"\",\"\",Calculation!AJ8)","v":""}]
[null,null,"Deviation:",null,null,{"$f":"IF(Values!B53=\"\",\"\",Calculation!AJ12)","v":""},null,null,null,null,"∆ critical:",null,null,{"$f":"IF(Values!B53=\"\",\"\",IF(Calculation!AJ6<2,\"\",(1.33*Calculation!AK44*F54)/0.2))","v":""}]
[null,null,"Cg (Min. Spec.):",null,null,{"$f":"IF(F54=\"\",\"\",(1.33*Calculation!AK44*F54)/0.2)","v":""},null,null,null,null,"Cg (Max. sigma):",null,null,{"$f":"IF(F54=\"\",\"\",((L19-L20)*0.2)/(1.33*Calculation!AK44))","v":""}]
[null,null,"Cgk (Max. Bi):",null,null,{"$f":"IF(F54=\"\",\"\",0.1*I35-1.33*Calculation!AK45*F54)","v":""},null,null,null,null,"Cgk (Max. sigma):",null,null,{"$f":"IF(F54=\"\",\"\",((0.1*(L19-L20))-((MAX(F52,F36)-MIN(F52,F36))))/(Calculation!AK45*1.33))","v":""}]
[null,null,"Specifications"]
[null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,{"$f":"IF(Calculation!K13=\"NG\",\"Normal distrib\",\"\")","v":"Normal distrib"}]
[null,null,{"$f":"IF(OR(F11=\"\",Calculation!AJ16=\"\",Calculation!AJ17=\"\"),\"%RE\",\"%RE = \"&Result_RE_1183)","v":"%RE"},null,{"$f":"IF(G59=\"\",\"\",IF(G59>5,\"VAL\",G59))","v":""},null,{"$f":"IFERROR(IF(F11=\"\",\"\",ROUND((Calculation!AJ50/Calculation!AJ18)*100,2)),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Calculation!K13=\"NG\",\"check manualy in Calculation sheet\",\"\")","v":"check manualy in Calculation sheet"}]
[]
[null,null,null,null,null,null,1.33]
[null,null,{"$f":"IFERROR(IF(AND(PRODSTRING17=\"\",PRODSTRING18=\"\"),\"Cg\",IF(Values!B53=\"\",\"Cg\",\"Cg = \"&ROUND(G62,2))),\"Cg\")","v":"Cg"},null,{"$f":"IFERROR(IF(G62=\"\",\"\",IF(G62>=G61,\"VAL\",G62)),\"\")","v":""},null,{"$f":"IFERROR(IF(AND(L20=\"\",L19=\"\"),\"\",ROUND(IF(F21=\"Only USL/LSL is specified\",Calculation!AJ38,IF(F21=\"Only USL is specified\",Calculation!AJ26,Calculation!AJ24)),2)),\"\")","v":""}]
[]
[null,null,null,null,null,null,1.33,null,null,null,null,null,null,null,"Capability"]
[null,null,{"$f":"IFERROR(IF(Result_Cgk_1183=\"\",\"Cgk\",IF(Values!B53=\"\",\"Cgk\",\"Cgk = \"&ROUND(Result_Cgk_1183,2))),\"Cgk\")","v":"Cgk"},null,{"$f":"IFERROR(IF(G65=\"\",\"\",IF(G65>=G64,\"VAL\",G65)),\"\")","v":""},null,{"$f":"IFERROR(IF(F52=\"\",\"\",IF(PRODSTRING16=\"\",\"\",ROUND(IF(F20=\"\",\"\",IF(F21=\"Only USL/LSL is specified\",\"\",IF(Values!B53=\"\",\"\",IF(F21=\"Only USL is specified\",IF(Visualization!F52>Visualization!F20,Calculation!AJ28,Calculation!AJ30),Calculation!AJ32)))),2))),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(F52=\"\",\"\",IFERROR(IF(F21=\"Only USL/LSL is specified\",IF(AND(G62>=G61,G65>=G64),\"Approved\",\"NG\"),IF(AND(Result_RE_1183<=5,Result_Cg_1183>=G61,Input_Limitation_1183>=G64),\"Approved\",\"NG\")),\"\"))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[null,"Please enter the collected measured values into the register \"Values\""]

{"sheet":"Graphics","index":2,"n_rows":158,"n_cols":22,"rows_kept":158,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1.33,1.33,1.33,1.33]

{"sheet":"Values","index":3,"n_rows":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Nr.","I - Values"]
[null,{"$f":"IF(C4=\"\",\"\",1)","v":""}]
[null,{"$f":"IF(C5=\"\",\"\",B4+1)","v":""}]
[null,{"$f":"IF(C6=\"\",\"\",B5+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":4,"n_rows":216,"n_cols":52,"rows_kept":216,"cut":false,"hidden":true,"merged":[[5,46,6,46],[5,47,6,47],[5,48,6,48],[5,29,6,29],[5,30,6,30],[5,31,6,31],[5,32,6,32],[5,40,6,40],[5,41,6,42],[8,2,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[5,43,6,43],[5,44,6,44],[5,45,6,45],[5,22,6,22],[5,24,6,24],[5,25,6,25],[5,26,6,26],[5,27,6,27],[5,28,6,28],[5,2,7,3],[5,4,7,4],[5,5,5,6],[5,7,7,7],[5,8,7,8],[5,21,6,21],[6,5,7,5],[6,6,7,6],[10,10,11,10],[10,17,10,18],[12,10,13,10],[10,2,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[15,13,15,14],[14,2,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[12,2,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[31,13,32,13],[31,14,32,14],[31,16,32,16],[31,17,32,17],[19,13,19,14],[18,2,19,8],[23,34,24,34],[23,35,24,36],[29,34,30,34],[29,35,30,36],[27,34,28,34],[27,35,28,36],[31,35,32,36],[31,34,32,34],[25,34,26,34],[25,35,26,36],[20,2,23,8],[52,2,53,2],[52,3,53,3],[52,4,53,4],[52,5,53,5],[52,6,53,6],[107,2,107,3],[107,8,107,9],[108,2,109,3],[108,8,108,9],[52,7,53,7],[52,8,53,8],[52,9,53,9],[123,2,124,3],[123,4,124,4],[123,5,124,5],[123,7,124,10],[127,2,127,3],[128,2,128,3],[110,8,110,10],[111,8,111,10],[112,2,112,3],[113,2,114,3],[114,5,115,10],[121,2,122,3],[134,2,135,2],[134,3,135,3],[134,4,135,4],[134,5,135,5],[134,6,135,6],[134,7,135,7],[134,9,135,10],[189,4,189,28],[191,2,215,2],[166,7,167,7],[171,7,172,7],[176,7,177,7],[180,7,181,7],[182,7,183,7],[182,9,182,10],[183,9,183,10],[37,34,38,34],[37,35,38,36],[33,34,34,34],[33,35,34,36],[35,34,36,34],[35,35,36,36],[43,34,43,35],[185,9,185,10],[186,9,186,10],[49,35,49,36],[50,35,50,36],[51,35,51,36],[52,35,52,36],[42,34,42,35],[52,10,53,10]]}
[]
[]
[]
[]
[]
[null,null,"Tests",null,null,"Requested to use",null,"Normel distribution is proved",null,null,null,null,null,"I - Bar",{"$f":"IF(Values!$B$53=\"\",\"\",AVERAGE(W8:W57))","v":""},null,"MR - Bar",{"$f":"IF(O6=\"\",\"\",AVERAGE(Y8:Y57))","v":""},null,null,null,"Nr.","I - Values",null,"MR -\nValues","I - Average","MR - Average","USL","LSL","I-UEL","I-LEL","MR-UEL","Real Value",null,"Number of values:",{"$f":"IF(W8=\"\",\"\",COUNT(W8:W57))","v":""},null,null,null,null,"Classes","Values per class",null,"Number of values per class [%]","Number of values per class [%] (accumulated)","USL","LSL","Amount of classes","Real Value",null,"Y- Values","Y- Values (accumulated)"]
[null,null,null,null,null,"System (Secondary)","User (Primary)",null,null,null,null,null,null,null,null,null,"MR sigma",{"$f":"IF(O6=\"\",\"\",R6/O12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max value",{"$f":"IF(W8=\"\",\"\",MAX(W8:W57))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO8=\"\",\"\",NORMDIST($AO8-$AJ$11,$O$6,$AJ$12,0))","v":""},{"$f":"IF(AO8=\"\",\"\",NORMDIST(AO8-$AJ$11,$O$6,$AJ$12,1)*100)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W8=\"\",\"\",1)","v":""},{"$f":"IF(Values!C4=\"\",\"\",Values!C4)","v":""},null,{"$f":"IF(W8=\"\",\"\",0)","v":""},{"$f":"IF(W8=\"\",\"\",AVERAGE($W$8:$W$57))","v":""},{"$f":"IF(Y8=\"\",\"\",AVERAGE($Y$8:$Y$57))","v":""},{"$f":"IF($AJ$16=\"\",\"\",$AJ$16)","v":""},{"$f":"IF($AJ$17=\"\",\"\",$AJ$17)","v":""},{"$f":"IF(W8=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W8=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W8=\"\",\"\",Calculation!$O$17)","v":""},{"$f":"IF($AJ$20=\"\",\"\",$AJ$20)","v":""},null,"Min value",{"$f":"IF(W8=\"\",\"\",MIN(W8:W57))","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",IF($AJ$6<15,\"\",AJ8-2*AJ11))","v":""},{"$f":"IF(AO8=\"\",\"\",IF(OR(COUNT($W$8:$W$57)=AP6,AP6=\"\"),\"\",FREQUENCY($W$8:$W$57,AO8)))","v":""},{"$f":"AP8","v":""},{"$f":"IF(AQ8=\"\",\"\",(100/(SUM($AQ$8:$AQ$27))*AQ8))","v":""},{"$f":"IF(AQ8=\"\",\"\",AR8)","v":""},{"$f":"IF(AS8=\"\",\"\",$AJ$16)","v":""},{"$f":"IF(AS8=\"\",\"\",$AJ$17)","v":""},{"$f":"IF(AP8=\"\",\"\",MAX($AR$8:$AR$27))","v":""},{"$f":"IF(AV8=\"\",\"\",IF($AJ$20=\"\",0,$AJ$20))","v":""},null,{"$f":"IF(AZ8=\"\",\"\",IF($AO9=\"\",\"\",NORMDIST($AO9-$AJ$11,$O$6,$AJ$12,0)))","v":""},{"$f":"IF(AO9=\"\",\"\",IF(AZ7>99.98,\"\",NORMDIST(AO8,$O$6,$AJ$12,1)*100))","v":""}]
[null,null,"Anderson Darling",null,null,{"$f":"IF(AJ6>5,\"OK\",\"NG\")","v":"OK"},null,{"$f":"IF(Values!B53=\"\",\"\",IF(O6=\"\",\"\",IF(MAX(G109:G112)>C114,\"OK\",\"NG\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W9=\"\",\"\",V8+1)","v":""},{"$f":"IF(Values!C5=\"\",\"\",Values!C5)","v":""},null,{"$f":"IF(W9=\"\",\"\",MAX(W8:W9)-MIN(W8:W9))","v":""},{"$f":"IF($Z$8=\"\",\"\",$Z$8)","v":""},{"$f":"IF($AA$8=\"\",\"\",$AA$8)","v":""},{"$f":"IF($AJ$16=\"\",\"\",$AJ$16)","v":""},{"$f":"IF($AJ$17=\"\",\"\",$AJ$17)","v":""},{"$f":"IF(W9=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W9=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W9=\"\",\"\",Calculation!$O$17)","v":""},{"$f":"IF($AJ$20=\"\",\"\",$AJ$20)","v":""},null,"Range:",{"$f":"IF(W8=\"\",\"\",AJ7-AJ8)","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO8+$AJ$11)","v":""},{"$f":"IF(AO9=\"\",\"\",IF(OR(COUNT($W$8:$W$57)=AP8,AP8=\"\"),\"\",FREQUENCY($W$8:$W$57,AO9)))","v":""},{"$f":"IF(AP9=\"\",\"\",AP9-AP8)","v":""},{"$f":"IF(AQ9=\"\",\"\",(100/(SUM($AQ$8:$AQ$27))*AQ9))","v":""},{"$f":"IF(AQ9=\"\",\"\",AS8+AR9)","v":""},{"$f":"IF(AS9=\"\",\"\",$AJ$16)","v":""},{"$f":"IF(AS9=\"\",\"\",$AJ$17)","v":""},{"$f":"IF(AP9=\"\",\"\",MAX($AR$8:$AR$27))","v":""},{"$f":"IF(AV9=\"\",\"\",IF($AJ$20=\"\",0,$AJ$20))","v":""},null,"",{"$f":"IF(AO10=\"\",\"\",IF(AZ8>99.98,\"\",NORMDIST(AO9,$O$6,$AJ$12,1)*100))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W10=\"\",\"\",V9+1)","v":""},{"$f":"IF(Values!C6=\"\",\"\",Values!C6)","v":""},null,"",{"$f":"IF($Z$8=\"\",\"\",$Z$8)","v":""},{"$f":"IF($AA$8=\"\",\"\",$AA$8)","v":""},"","",{"$f":"IF(W10=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W10=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W10=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Number of classes: ",{"$f":"IF(W8=\"\",\"\",IF(ROUNDUP(AJ6^(1/2),0)>20,20,ROUNDUP(AJ6^(1/2),0))+3)+1","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO9+$AJ$11)","v":""},{"$f":"IF(AO10=\"\",\"\",IF(OR(COUNT($W$8:$W$57)=AP9,AP9=\"\"),\"\",FREQUENCY($W$8:$W$57,AO10)))","v":""},"","",{"$f":"IF(AQ10=\"\",\"\",AS9+AR10)","v":""},"","","","",null,"",""]
[null,null,"Chi square",null,null,{"$f":"IF(AJ6>25,\"OK\",\"NG\")","v":"OK"},null,{"$f":"IF(Values!B53=\"\",\"\",IF(O6=\"\",\"\",IF(C124>F124,\"OK\",\"NG\")))","v":""},null,null,"Overall result",null,null,"n","d2","d3",null,"Limits",null,null,null,"",{"$f":"IF(Values!C7=\"\",\"\",Values!C7)","v":""},null,"","","","","",{"$f":"IF(W11=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W11=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W11=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Width of classes:",{"$f":"IF(W8=\"\",\"\",AJ9/(AJ10-3))","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO10+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.1279999999999999,null,null,"I - UEL",{"$f":"IF(O6=\"\",\"\",$O$6+(3*$R$6)/O12)","v":""},null,null,"",{"$f":"IF(Values!C8=\"\",\"\",Values!C8)","v":""},null,"","","","","",{"$f":"IF(W12=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W12=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W12=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Sigma",{"$f":"IF(AJ9=0,0,IF(Values!$B$53=\"\",\"\",_xlfn.STDEV.S(W8:W57)))","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO11+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,"Shapirov Wilks",null,null,"OK",null,{"$f":"IF(Values!B53=\"\",\"\",IF(O6=\"\",\"\",IF(H183>H177,\"NG\",\"OK\")))","v":""},null,null,{"$f":"IFERROR(VLOOKUP(\"OK\",H9:H16,1,FALSE),\"NG\")","v":"NG"},null,null,2,null,0.85250000000000004,null,"I - LEL",{"$f":"IF(O6=\"\",\"\",$O$6-(3*$R$6)/O12)","v":""},null,null,"",{"$f":"IF(Values!C9=\"\",\"\",Values!C9)","v":""},null,"","","","","",{"$f":"IF(W13=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W13=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W13=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO12+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C10=\"\",\"\",Values!C10)","v":""},null,"","","","","",{"$f":"IF(W14=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W14=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W14=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO13+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,"Manual decision",null,null,null,null,{"$f":"IF(C21=\"\",\"None\",\"OK\")","v":"None"},null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C11=\"\",\"\",Values!C11)","v":""},null,"","","","","",{"$f":"IF(W15=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W15=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W15=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO14+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Limits",null,null,null,null,null,null,null,"",{"$f":"IF(Values!C12=\"\",\"\",Values!C12)","v":""},null,"","","","","",{"$f":"IF(W16=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W16=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W16=\"\",\"\",Calculation!$O$17)","v":""},"",null,"USL",{"$f":"AJ52","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO15+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MR - UEL",{"$f":"IF(O6=\"\",\"\",O12*R7+3*P13*R7)","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C13=\"\",\"\",Values!C13)","v":""},null,"","","","","",{"$f":"IF(W17=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W17=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W17=\"\",\"\",Calculation!$O$17)","v":""},"",null,"LSL",{"$f":"IF(Visualization!F21=\"One side is limited\",0,AJ53)","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO16+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C14=\"\",\"\",Values!C14)","v":""},null,"","","","","",{"$f":"IF(W18=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W18=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W18=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Delta T",{"$f":"IF(Visualization!F21=\"One side is limited\",AJ16,AJ16-AJ17)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO17+$AJ$11)","v":""},{"$f":"IF(AO18=\"\",\"\",IF(OR(COUNT($W$8:$W$57)=AP17,AP17=\"\"),\"\",FREQUENCY($W$8:$W$57,AO18)))","v":""},"","","","","","","",null,"",""]
[null,null,"The decision which test of normalety will be done is handelt by the Worksheet itselfe. Factors of the decision is the amount of measurements. The user can switch manual decicion to \"OK\" !  But ist necessary to fill in the reason below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C15=\"\",\"\",Values!C15)","v":""},null,"","","","","",{"$f":"IF(W19=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W19=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W19=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO18+$AJ$11)","v":""},{"$f":"IF(AO19=\"\",\"\",IF(OR(COUNT($W$8:$W$57)=AP18,AP18=\"\"),\"\",FREQUENCY($W$8:$W$57,AO19)))","v":""},"","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C16=\"\",\"\",Values!C16)","v":""},null,"","","","","",{"$f":"IF(W20=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W20=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W20=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Real Value",{"$f":"AJ51","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO19+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I - Values",null,null,"I - Values",null,null,null,"",{"$f":"IF(Values!C17=\"\",\"\",Values!C17)","v":""},null,"","","","","",{"$f":"IF(W21=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W21=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W21=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Bi",{"$f":"(MAX(AJ20,O6)-MIN(O6,AJ20))","v":0},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO20+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",{"$f":"IF(O6=\"\",\"\",AJ7)","v":""},null,"Min",{"$f":"O26","v":""},null,null,null,"",{"$f":"IF(Values!C18=\"\",\"\",Values!C18)","v":""},null,"","","","","",{"$f":"IF(W22=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W22=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W22=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO21+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3",{"$f":"IF(O6=\"\",\"\",QUARTILE(W8:W57,3))","v":""},null,"∆ (Q1;Min)",{"$f":"IF(R22=\"\",\"\",O25-O26)","v":""},null,null,null,"",{"$f":"IF(Values!C19=\"\",\"\",Values!C19)","v":""},null,"","","","","",{"$f":"IF(W23=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W23=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W23=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO22+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Med",{"$f":"IF(O6=\"\",\"\",MEDIAN(W8:W57))","v":""},null,"∆ (Med;Q1)",{"$f":"IF(R22=\"\",\"\",O24-O25)","v":""},null,null,null,"",{"$f":"IF(Values!C20=\"\",\"\",Values!C20)","v":""},null,"","","","","",{"$f":"IF(W24=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W24=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W24=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cg",{"$f":"IFERROR(IF(AJ6<>50,\"\",(AL44*AJ18)/(AK44*AJ12)),\"\")","v":""},null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO23+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"IF(O6=\"\",\"\",QUARTILE(W8:W57,1))","v":""},null,"∆ (Q3;Med)",{"$f":"IF(R22=\"\",\"\",O23-O24)","v":""},null,null,null,"",{"$f":"IF(Values!C21=\"\",\"\",Values!C21)","v":""},null,"","","","","",{"$f":"IF(W25=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W25=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W25=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO24+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(O6=\"\",\"\",AJ8)","v":""},null,"∆ (Q3;Max)",{"$f":"IF(R22=\"\",\"\",O22-O23)","v":""},null,null,null,"",{"$f":"IF(Values!C22=\"\",\"\",Values!C22)","v":""},null,"","","","","",{"$f":"IF(W26=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W26=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W26=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO25+$AJ$11)","v":""},"","","","","","","","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum - Q3",{"$f":"IF(O22=\"\",\"\",O22-O26)","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C23=\"\",\"\",Values!C23)","v":""},null,"","","","","",{"$f":"IF(W27=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W27=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W27=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Values!$B$53=\"\",\"\",AO26+$AJ$11)","v":""},"","","","","","","","",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1-Minimum",{"$f":"IF(O22=\"\",\"\",O25-O26)","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C24=\"\",\"\",Values!C24)","v":""},null,"","","","","",{"$f":"IF(W28=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W28=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W28=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cgk x-bar > xm",{"$f":"((AL45*AJ18-(O6-AJ20))/(AK45*AJ12))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ28=\"\",\"\",IF($AO28=\"\",\"\",NORMDIST($AO28-$AJ$11,$O$6,$AJ$12,0)))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C25=\"\",\"\",Values!C25)","v":""},null,"","","","","",{"$f":"IF(W29=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W29=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W29=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C26=\"\",\"\",Values!C26)","v":""},null,"","","","","",{"$f":"IF(W30=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W30=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W30=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cgk x-bar < xm",{"$f":"((AL45*AJ18-(AJ20-O6))/(AK45*AJ12))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",{"$f":"MAX(AY7:AY27)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C27=\"\",\"\",Values!C27)","v":""},null,"","","","","",{"$f":"IF(W31=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W31=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W31=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I - Values (Sorted)","z",null,"Value","Sigma",null,null,null,"",{"$f":"IF(Values!C28=\"\",\"\",Values!C28)","v":""},null,"","","","","",{"$f":"IF(W32=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W32=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W32=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cgk",{"$f":"IFERROR(IF(Visualization!F21=\"One side is limited\",IF(AJ21>O6,AJ30,AJ28),IF(AJ6<>50,\"\",((AL45*AJ18)-(MAX(AJ20,O6)-MIN(O6,AJ20)))/(AK45*AJ12))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Values!C29=\"\",\"\",Values!C29)","v":""},null,"","","","","",{"$f":"IF(W33=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W33=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W33=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C4=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B4))","v":""},{"$f":"IF(Values!C4=\"\",\"\",NORMSINV((Values!B4-0.3)/(COUNT($N$34:$N$83))))","v":""},null,{"$f":"IF(Values!B18=\"\",\"\",Q35-(3*AJ12))","v":""},-3,null,null,null,"",{"$f":"IF(Values!C30=\"\",\"\",Values!C30)","v":""},null,"","","","","",{"$f":"IF(W34=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W34=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W34=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cg (only one side specified (USL))",{"$f":"IF(AJ16=\"\",\"\",IFERROR(IF((AJ7+3*AJ12)<=AJ16,1.33,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C5=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B5))","v":""},{"$f":"IF(Values!C5=\"\",\"\",NORMSINV((Values!B5-0.3)/(COUNT($N$34:$N$83))))","v":""},null,{"$f":"O6","v":""},0,null,null,null,"",{"$f":"IF(Values!C31=\"\",\"\",Values!C31)","v":""},null,"","","","","",{"$f":"IF(W35=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W35=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W35=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C6=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B6))","v":""},{"$f":"IF(Values!C6=\"\",\"\",NORMSINV((Values!B6-0.3)/(COUNT($N$34:$N$83))))","v":""},null,{"$f":"IF(Values!B18=\"\",\"\",Q35+(3*AJ12))","v":""},3,null,null,null,"",{"$f":"IF(Values!C32=\"\",\"\",Values!C32)","v":""},null,"","","","","",{"$f":"IF(W36=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W36=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W36=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cg (only one side specified (LSL))",{"$f":"IF(AJ17=\"\",\"\",IFERROR(IF((AJ8-3*AJ12)>=AJ17,1.33,1),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C7=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B7))","v":""},{"$f":"IF(Values!C7=\"\",\"\",NORMSINV((Values!B7-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C33=\"\",\"\",Values!C33)","v":""},null,"","","","","",{"$f":"IF(W37=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W37=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W37=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C8=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B8))","v":""},{"$f":"IF(Values!C8=\"\",\"\",NORMSINV((Values!B8-0.3)/(COUNT($N$34:$N$83))))","v":""},null,"USL",{"$f":"AJ16","v":""},null,null,null,"",{"$f":"IF(Values!C34=\"\",\"\",Values!C34)","v":""},null,"","","","","",{"$f":"IF(W38=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W38=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W38=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cg (only one side specified)",{"$f":"IF(AJ16<>\"\",Calculation!AJ34,Calculation!AJ36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C9=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B9))","v":""},{"$f":"IF(Values!C9=\"\",\"\",NORMSINV((Values!B9-0.3)/(COUNT($N$34:$N$83))))","v":""},null,"LSL",{"$f":"AJ17","v":""},null,null,null,"",{"$f":"IF(Values!C35=\"\",\"\",Values!C35)","v":""},null,"","","","","",{"$f":"IF(W39=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W39=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W39=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C10=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B10))","v":""},{"$f":"IF(Values!C10=\"\",\"\",NORMSINV((Values!B10-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C36=\"\",\"\",Values!C36)","v":""},null,"","","","","",{"$f":"IF(W40=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W40=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W40=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C11=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B11))","v":""},{"$f":"IF(Values!C11=\"\",\"\",NORMSINV((Values!B11-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C37=\"\",\"\",Values!C37)","v":""},null,"","","","","",{"$f":"IF(W41=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W41=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W41=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Standarddeviation for calculation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C12=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B12))","v":""},{"$f":"IF(Values!C12=\"\",\"\",NORMSINV((Values!B12-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C38=\"\",\"\",Values!C38)","v":""},null,"","","","","",{"$f":"IF(W42=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W42=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W42=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C13=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B13))","v":""},{"$f":"IF(Values!C13=\"\",\"\",NORMSINV((Values!B13-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C39=\"\",\"\",Values!C39)","v":""},null,"","","","","",{"$f":"IF(W43=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W43=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W43=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Indice",null,null,"T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C14=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B14))","v":""},{"$f":"IF(Values!C14=\"\",\"\",NORMSINV((Values!B14-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C40=\"\",\"\",Values!C40)","v":""},null,"","","","","",{"$f":"IF(W44=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W44=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W44=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cg (Capability gauge)",null,4,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C15=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B15))","v":""},{"$f":"IF(Values!C15=\"\",\"\",NORMSINV((Values!B15-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C41=\"\",\"\",Values!C41)","v":""},null,"","","","","",{"$f":"IF(W45=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W45=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W45=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Cgk (Capability gauge katojori)",null,2,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C16=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B16))","v":""},{"$f":"IF(Values!C16=\"\",\"\",NORMSINV((Values!B16-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C42=\"\",\"\",Values!C42)","v":""},null,"","","","","",{"$f":"IF(W46=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W46=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W46=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,{"$f":"AJ46 & \"/\" &AK46","v":"/"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C17=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B17))","v":""},{"$f":"IF(Values!C17=\"\",\"\",NORMSINV((Values!B17-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C43=\"\",\"\",Values!C43)","v":""},null,"","","","","",{"$f":"IF(W47=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W47=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W47=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,{"$f":"AJ47 & \"/\" &AK47","v":"/"},null,1.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C18=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B18))","v":""},{"$f":"IF(Values!C18=\"\",\"\",NORMSINV((Values!B18-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C44=\"\",\"\",Values!C44)","v":""},null,"","","","","",{"$f":"IF(W48=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W48=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W48=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Additional Pro.File variable",null,null,"/",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C19=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B19))","v":""},{"$f":"IF(Values!C19=\"\",\"\",NORMSINV((Values!B19-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C45=\"\",\"\",Values!C45)","v":""},null,"","","","","",{"$f":"IF(W49=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W49=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W49=\"\",\"\",Calculation!$O$17)","v":""},"",null,null,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C20=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B20))","v":""},{"$f":"IF(Values!C20=\"\",\"\",NORMSINV((Values!B20-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C46=\"\",\"\",Values!C46)","v":""},null,"","","","","",{"$f":"IF(W50=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W50=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W50=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Resolution",{"$f":"IF(Visualization!F11=\"\",\"\",VALUE(Visualization!F11))","v":""},null,"/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C21=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B21))","v":""},{"$f":"IF(Values!C21=\"\",\"\",NORMSINV((Values!B21-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C47=\"\",\"\",Values!C47)","v":""},null,"","","","","",{"$f":"IF(W51=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W51=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W51=\"\",\"\",Calculation!$O$17)","v":""},"",null,"Real Value",{"$f":"IF(Visualization!F20=\"\",\"\",VALUE(Visualization!F20))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C22=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B22))","v":""},{"$f":"IF(Values!C22=\"\",\"\",NORMSINV((Values!B22-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C48=\"\",\"\",Values!C48)","v":""},null,"","","","","",{"$f":"IF(W52=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W52=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W52=\"\",\"\",Calculation!$O$17)","v":""},"",null,"USL ",{"$f":"IF(Visualization!L19=\"\",\"\",VALUE(Visualization!L19))","v":""}]
[null,null,"Nr.","Value","Zi","ln[Zi]","Zn-i+1","1-Zn-i+1","ln[1-Zn-i+1]","lnZ +ln(1-Z)","(1-2i)/n",null,null,{"$f":"IF(Values!C23=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B23))","v":""},{"$f":"IF(Values!C23=\"\",\"\",NORMSINV((Values!B23-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C49=\"\",\"\",Values!C49)","v":""},null,"","","","","",{"$f":"IF(W53=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W53=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W53=\"\",\"\",Calculation!$O$17)","v":""},"",null,"LSL",{"$f":"IF(Visualization!L20=\"\",\"\",Visualization!L20)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Values!C24=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B24))","v":""},{"$f":"IF(Values!C24=\"\",\"\",NORMSINV((Values!B24-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C50=\"\",\"\",Values!C50)","v":""},null,"","","","","",{"$f":"IF(W54=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W54=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W54=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,1,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C55=\"\",\"\",SMALL($W$8:$W$57,C55)))","v":""},{"$f":"IF(D55=\"\",\"\",NORMDIST(D55,$O$6,$AJ$12,TRUE))","v":""},{"$f":"IF(D55=\"\",\"\",IF(C55>$AJ$6,0,LN(E55)))","v":""},{"$f":"IF(D55=\"\",\"\",LARGE(E$55:E$104,C55))","v":""},{"$f":"IF(D55=\"\",\"\",IF(G55=0,0,1-G55))","v":""},{"$f":"IF(D55=\"\",\"\",IF(H55=0,0,LN(H55)))","v":""},{"$f":"IF(D55=\"\",\"\",F55+I55)","v":""},{"$f":"IF(Values!$B$53=\"\",\"\",IF(C55=\"\",\"\",(1-2*C55)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C25=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B25))","v":""},{"$f":"IF(Values!C25=\"\",\"\",NORMSINV((Values!B25-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C51=\"\",\"\",Values!C51)","v":""},null,"","","","","",{"$f":"IF(W55=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W55=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W55=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,2,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C56=\"\",\"\",SMALL($W$8:$W$57,C56)))","v":""},{"$f":"IF(D56=\"\",\"\",NORMDIST(D56,$O$6,$AJ$12,TRUE))","v":""},{"$f":"IF(D56=\"\",\"\",IF(C56>$AJ$6,0,LN(E56)))","v":""},{"$f":"IF(D56=\"\",\"\",LARGE(E$55:E$104,C56))","v":""},{"$f":"IF(D56=\"\",\"\",IF(G56=0,0,1-G56))","v":""},{"$f":"IF(D56=\"\",\"\",IF(H56=0,0,LN(H56)))","v":""},{"$f":"IF(D56=\"\",\"\",F56+I56)","v":""},{"$f":"IF(Values!$B$53=\"\",\"\",IF(C56=\"\",\"\",(1-2*C56)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C26=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B26))","v":""},{"$f":"IF(Values!C26=\"\",\"\",NORMSINV((Values!B26-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C52=\"\",\"\",Values!C52)","v":""},null,"","","","","",{"$f":"IF(W56=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W56=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W56=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,3,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C57=\"\",\"\",SMALL($W$8:$W$57,C57)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C57=\"\",\"\",(1-2*C57)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C27=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B27))","v":""},{"$f":"IF(Values!C27=\"\",\"\",NORMSINV((Values!B27-0.3)/(COUNT($N$34:$N$83))))","v":""},null,null,null,null,null,null,"",{"$f":"IF(Values!C53=\"\",\"\",Values!C53)","v":""},null,"","","","","",{"$f":"IF(W57=\"\",\"\",Calculation!$S$12)","v":""},{"$f":"IF(W57=\"\",\"\",Calculation!$S$13)","v":""},{"$f":"IF(W57=\"\",\"\",Calculation!$O$17)","v":""},""]
[null,null,4,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C58=\"\",\"\",SMALL($W$8:$W$57,C58)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C58=\"\",\"\",(1-2*C58)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C28=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B28))","v":""},{"$f":"IF(Values!C28=\"\",\"\",NORMSINV((Values!B28-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,5,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C59=\"\",\"\",SMALL($W$8:$W$57,C59)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C59=\"\",\"\",(1-2*C59)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C29=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B29))","v":""},{"$f":"IF(Values!C29=\"\",\"\",NORMSINV((Values!B29-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,6,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C60=\"\",\"\",SMALL($W$8:$W$57,C60)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C60=\"\",\"\",(1-2*C60)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C30=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B30))","v":""},{"$f":"IF(Values!C30=\"\",\"\",NORMSINV((Values!B30-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,7,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C61=\"\",\"\",SMALL($W$8:$W$57,C61)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C61=\"\",\"\",(1-2*C61)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C31=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B31))","v":""},{"$f":"IF(Values!C31=\"\",\"\",NORMSINV((Values!B31-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,8,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C62=\"\",\"\",SMALL($W$8:$W$57,C62)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C62=\"\",\"\",(1-2*C62)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C32=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B32))","v":""},{"$f":"IF(Values!C32=\"\",\"\",NORMSINV((Values!B32-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,9,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C63=\"\",\"\",SMALL($W$8:$W$57,C63)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C63=\"\",\"\",(1-2*C63)/COUNT($C$55:$C$104)))","v":""},null," ",{"$f":"IF(Values!C33=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B33))","v":""},{"$f":"IF(Values!C33=\"\",\"\",NORMSINV((Values!B33-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,10,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C64=\"\",\"\",SMALL($W$8:$W$57,C64)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C64=\"\",\"\",(1-2*C64)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C34=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B34))","v":""},{"$f":"IF(Values!C34=\"\",\"\",NORMSINV((Values!B34-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,11,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C65=\"\",\"\",SMALL($W$8:$W$57,C65)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C65=\"\",\"\",(1-2*C65)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C35=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B35))","v":""},{"$f":"IF(Values!C35=\"\",\"\",NORMSINV((Values!B35-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,12,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C66=\"\",\"\",SMALL($W$8:$W$57,C66)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C66=\"\",\"\",(1-2*C66)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C36=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B36))","v":""},{"$f":"IF(Values!C36=\"\",\"\",NORMSINV((Values!B36-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,13,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C67=\"\",\"\",SMALL($W$8:$W$57,C67)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C67=\"\",\"\",(1-2*C67)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C37=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B37))","v":""},{"$f":"IF(Values!C37=\"\",\"\",NORMSINV((Values!B37-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,14,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C68=\"\",\"\",SMALL($W$8:$W$57,C68)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C68=\"\",\"\",(1-2*C68)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C38=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B38))","v":""},{"$f":"IF(Values!C38=\"\",\"\",NORMSINV((Values!B38-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,15,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C69=\"\",\"\",SMALL($W$8:$W$57,C69)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C69=\"\",\"\",(1-2*C69)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C39=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B39))","v":""},{"$f":"IF(Values!C39=\"\",\"\",NORMSINV((Values!B39-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,16,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C70=\"\",\"\",SMALL($W$8:$W$57,C70)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C70=\"\",\"\",(1-2*C70)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C40=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B40))","v":""},{"$f":"IF(Values!C40=\"\",\"\",NORMSINV((Values!B40-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,17,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C71=\"\",\"\",SMALL($W$8:$W$57,C71)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C71=\"\",\"\",(1-2*C71)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C41=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B41))","v":""},{"$f":"IF(Values!C41=\"\",\"\",NORMSINV((Values!B41-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,18,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C72=\"\",\"\",SMALL($W$8:$W$57,C72)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C72=\"\",\"\",(1-2*C72)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C42=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B42))","v":""},{"$f":"IF(Values!C42=\"\",\"\",NORMSINV((Values!B42-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,19,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C73=\"\",\"\",SMALL($W$8:$W$57,C73)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C73=\"\",\"\",(1-2*C73)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C43=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B43))","v":""},{"$f":"IF(Values!C43=\"\",\"\",NORMSINV((Values!B43-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,20,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C74=\"\",\"\",SMALL($W$8:$W$57,C74)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C74=\"\",\"\",(1-2*C74)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C44=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B44))","v":""},{"$f":"IF(Values!C44=\"\",\"\",NORMSINV((Values!B44-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,21,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C75=\"\",\"\",SMALL($W$8:$W$57,C75)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C75=\"\",\"\",(1-2*C75)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C45=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B45))","v":""},{"$f":"IF(Values!C45=\"\",\"\",NORMSINV((Values!B45-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,22,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C76=\"\",\"\",SMALL($W$8:$W$57,C76)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C76=\"\",\"\",(1-2*C76)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C46=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B46))","v":""},{"$f":"IF(Values!C46=\"\",\"\",NORMSINV((Values!B46-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,23,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C77=\"\",\"\",SMALL($W$8:$W$57,C77)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C77=\"\",\"\",(1-2*C77)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C47=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B47))","v":""},{"$f":"IF(Values!C47=\"\",\"\",NORMSINV((Values!B47-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,24,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C78=\"\",\"\",SMALL($W$8:$W$57,C78)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C78=\"\",\"\",(1-2*C78)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C48=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B48))","v":""},{"$f":"IF(Values!C48=\"\",\"\",NORMSINV((Values!B48-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,25,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C79=\"\",\"\",SMALL($W$8:$W$57,C79)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C79=\"\",\"\",(1-2*C79)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C49=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B49))","v":""},{"$f":"IF(Values!C49=\"\",\"\",NORMSINV((Values!B49-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,26,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C80=\"\",\"\",SMALL($W$8:$W$57,C80)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C80=\"\",\"\",(1-2*C80)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C50=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B50))","v":""},{"$f":"IF(Values!C50=\"\",\"\",NORMSINV((Values!B50-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,27,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C81=\"\",\"\",SMALL($W$8:$W$57,C81)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C81=\"\",\"\",(1-2*C81)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C51=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B51))","v":""},{"$f":"IF(Values!C51=\"\",\"\",NORMSINV((Values!B51-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,28,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C82=\"\",\"\",SMALL($W$8:$W$57,C82)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C82=\"\",\"\",(1-2*C82)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C52=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B52))","v":""},{"$f":"IF(Values!C52=\"\",\"\",NORMSINV((Values!B52-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,29,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C83=\"\",\"\",SMALL($W$8:$W$57,C83)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C83=\"\",\"\",(1-2*C83)/COUNT($C$55:$C$104)))","v":""},null,null,{"$f":"IF(Values!C53=\"\",\"\",SMALL(Values!$C$4:$C$53,Values!B53))","v":""},{"$f":"IF(Values!C53=\"\",\"\",NORMSINV((Values!B53-0.3)/(COUNT($N$34:$N$83))))","v":""}]
[null,null,30,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C84=\"\",\"\",SMALL($W$8:$W$57,C84)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C84=\"\",\"\",(1-2*C84)/COUNT($C$55:$C$104)))","v":""}]
[null,null,31,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C85=\"\",\"\",SMALL($W$8:$W$57,C85)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C85=\"\",\"\",(1-2*C85)/COUNT($C$55:$C$104)))","v":""}]
[null,null,32,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C86=\"\",\"\",SMALL($W$8:$W$57,C86)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C86=\"\",\"\",(1-2*C86)/COUNT($C$55:$C$104)))","v":""}]
[null,null,33,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C87=\"\",\"\",SMALL($W$8:$W$57,C87)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C87=\"\",\"\",(1-2*C87)/COUNT($C$55:$C$104)))","v":""}]
[null,null,34,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C88=\"\",\"\",SMALL($W$8:$W$57,C88)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C88=\"\",\"\",(1-2*C88)/COUNT($C$55:$C$104)))","v":""}]
[null,null,35,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C89=\"\",\"\",SMALL($W$8:$W$57,C89)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C89=\"\",\"\",(1-2*C89)/COUNT($C$55:$C$104)))","v":""}]
[null,null,36,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C90=\"\",\"\",SMALL($W$8:$W$57,C90)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C90=\"\",\"\",(1-2*C90)/COUNT($C$55:$C$104)))","v":""}]
[null,null,37,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C91=\"\",\"\",SMALL($W$8:$W$57,C91)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C91=\"\",\"\",(1-2*C91)/COUNT($C$55:$C$104)))","v":""}]
[null,null,38,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C92=\"\",\"\",SMALL($W$8:$W$57,C92)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C92=\"\",\"\",(1-2*C92)/COUNT($C$55:$C$104)))","v":""}]
[null,null,39,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C93=\"\",\"\",SMALL($W$8:$W$57,C93)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C93=\"\",\"\",(1-2*C93)/COUNT($C$55:$C$104)))","v":""}]
[null,null,40,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C94=\"\",\"\",SMALL($W$8:$W$57,C94)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C94=\"\",\"\",(1-2*C94)/COUNT($C$55:$C$104)))","v":""}]
[null,null,41,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C95=\"\",\"\",SMALL($W$8:$W$57,C95)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C95=\"\",\"\",(1-2*C95)/COUNT($C$55:$C$104)))","v":""}]
[null,null,42,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C96=\"\",\"\",SMALL($W$8:$W$57,C96)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C96=\"\",\"\",(1-2*C96)/COUNT($C$55:$C$104)))","v":""}]
[null,null,43,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C97=\"\",\"\",SMALL($W$8:$W$57,C97)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C97=\"\",\"\",(1-2*C97)/COUNT($C$55:$C$104)))","v":""}]
[null,null,44,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C98=\"\",\"\",SMALL($W$8:$W$57,C98)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C98=\"\",\"\",(1-2*C98)/COUNT($C$55:$C$104)))","v":""}]
[null,null,45,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C99=\"\",\"\",SMALL($W$8:$W$57,C99)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C99=\"\",\"\",(1-2*C99)/COUNT($C$55:$C$104)))","v":""}]
[null,null,46,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C100=\"\",\"\",SMALL($W$8:$W$57,C100)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C100=\"\",\"\",(1-2*C100)/COUNT($C$55:$C$104)))","v":""}]
[null,null,47,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C101=\"\",\"\",SMALL($W$8:$W$57,C101)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C101=\"\",\"\",(1-2*C101)/COUNT($C$55:$C$104)))","v":""}]
[null,null,48,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C102=\"\",\"\",SMALL($W$8:$W$57,C102)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C102=\"\",\"\",(1-2*C102)/COUNT($C$55:$C$104)))","v":""}]
[null,null,49,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C103=\"\",\"\",SMALL($W$8:$W$57,C103)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C103=\"\",\"\",(1-2*C103)/COUNT($C$55:$C$104)))","v":""}]
[null,null,50,{"$f":"IF(Values!$B$53=\"\",\"\",IF(C104=\"\",\"\",SMALL($W$8:$W$57,C104)))","v":""},"","","","","","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C104=\"\",\"\",(1-2*C104)/COUNT($C$55:$C$104)))","v":""}]
[]
[]
[]
[null,null,"Test value AD: ",null,null,"AD*",{"$f":"IF(C109=\"\",\"\",C109*(1+0.75/COUNT(D55:D104)+2.25/COUNT(D55:D104)^2))","v":""},null,"H1 = True If AD > SW"]
[null,null,{"$f":"IF(Values!$B$53=\"\",\"\",IF(D55=\"\",\"\",SUMPRODUCT(J55:J104,K55:K104)-COUNT(D55:D104)))","v":""},null,null,"p1",{"$f":"IF(G108=\"\",\"\",IF(AND(G108<13,G108>=0.6),EXP(1.2937-5.709*G108+0.0186*G108^2),0))","v":""},null,"H0 = True If AD < SW"]
[null,null,null,null,null,"p2",{"$f":"IF(G108=\"\",\"\",IF(AND(G108<0.6,G108>=0.34),EXP(0.9177-4.279*G108-1.38*G108^2),0))","v":""}]
[null,null,null,null,null,"p3",{"$f":"IF(G108=\"\",\"\",IF(AND(G108<0.34,G108>=0.2),1-EXP(-8.318+42.796*G108-59.938*G108^2),0))","v":""},null,"H1: Values are normal ditributed"]
[null,null,null,null,null,"p4",{"$f":"IF(G108=\"\",\"\",IF(G108<0.2,1-EXP(-13.436+101.14*G108-223.73*G108^2),0))","v":""},null,"H0: Values are not normal distributed"]
[null,null,"Threshold SW [95%]:"]
[null,null,0.05]
[null,null,null,null,null,"The Anderson Darling test of normalety is a powerful tool for small (6) until big (125) amount of values.\nThe Anderson Darling test evaluate the entire distribution with a focus on the peripheral areas."]
[]
[]
[]
[]
[]
[]
[null,null,"Test value (AD)"]
[]
[null,null,{"$f":"IF(Values!$B$53=\"\",\"\",IF(D55=\"\",\"\",_xlfn.CHISQ.TEST(Observed,Calculated)))","v":""},null,"≥",0.75,null,"The Chi-Square test focus on the peripheral areas of the distribution."]
[]
[]
[]
[null,null,"H1 = True If AD > SW",null,null,"H1: Values are normal ditributed"]
[null,null,"H0 = True If AD < SW",null,null,"H0: Values are not normal distributed"]
[]
[]
[]
[]
[]
[null,null,"Nr.","Value","Values (sorted according smallest)","Values (sorted according biggest)","n (i)","n (b)",null,"Threshold"]
[]
[null,null,1,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W8=\"\",\"\",W8))","v":""},{"$f":"IF(D137=\"\",\"\",SMALL($D$137:$D$186,C137))","v":""},{"$f":"IF(D137=\"\",\"\",LARGE($D$137:$D$186,C137))","v":""},{"$f":"IF(Values!$B$53=\"\",\"\",IF(C137=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C137+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C137+1,2))))","v":""},{"$f":"IF(G137=\"\",\"\",G137*(F137-E137))","v":""},null,"n",0.95]
[null,null,2,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W9=\"\",\"\",W9))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C138=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C138+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C138+1,2))))","v":""},{"$f":"IF(G138=\"\",\"\",G138*(F138-E138))","v":""},null,3,0.76700000000000002]
[null,null,3,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W10=\"\",\"\",W10))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C139=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C139+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C139+1,2))))","v":""},"",null,4,0.748]
[null,null,4,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W11=\"\",\"\",W11))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C140=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C140+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C140+1,2))))","v":""},"",null,5,0.76200000000000001]
[null,null,5,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W12=\"\",\"\",W12))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C141=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C141+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C141+1,2))))","v":""},"",null,6,0.78800000000000003]
[null,null,6,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W13=\"\",\"\",W13))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C142=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C142+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C142+1,2))))","v":""},"",null,7,0.8]
[null,null,7,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W14=\"\",\"\",W14))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C143=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C143+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C143+1,2))))","v":""},"",null,8,0.81799999999999995]
[null,null,8,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W15=\"\",\"\",W15))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C144=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C144+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C144+1,2))))","v":""},"",null,9,0.82899999999999996]
[null,null,9,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W16=\"\",\"\",W16))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C145=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C145+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C145+1,2))))","v":""},"",null,10,0.84199999999999997]
[null,null,10,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W17=\"\",\"\",W17))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C146=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C146+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C146+1,2))))","v":""},"",null,12,0.85899999999999999]
[null,null,11,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W18=\"\",\"\",W18))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C147=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C147+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C147+1,2))))","v":""},""," ",14,0.874]
[null,null,12,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W19=\"\",\"\",W19))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C148=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C148+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C148+1,2))))","v":""},"",null,16,0.88700000000000001]
[null,null,13,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W20=\"\",\"\",W20))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C149=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C149+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C149+1,2))))","v":""},"",null,18,0.89700000000000002]
[null,null,14,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W21=\"\",\"\",W21))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C150=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C150+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C150+1,2))))","v":""},"",null,20,0.90500000000000003]
[null,null,15,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W22=\"\",\"\",W22))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C151=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C151+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C151+1,2))))","v":""},"",null,21,0.90800000000000003]
[null,null,16,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W23=\"\",\"\",W23))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C152=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C152+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C152+1,2))))","v":""},"",null,22,0.91100000000000003]
[null,null,17,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W24=\"\",\"\",W24))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C153=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C153+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C153+1,2))))","v":""},"",null,23,0.91400000000000003]
[null,null,18,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W25=\"\",\"\",W25))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C154=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C154+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C154+1,2))))","v":""},"",null,24,0.91600000000000004]
[null,null,19,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W26=\"\",\"\",W26))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C155=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C155+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C155+1,2))))","v":""},"",null,25,0.91800000000000004]
[null,null,20,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W27=\"\",\"\",W27))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C156=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C156+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C156+1,2))))","v":""},"",null,26,0.92]
[null,null,21,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W28=\"\",\"\",W28))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C157=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C157+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C157+1,2))))","v":""},"",null,27,0.92300000000000004]
[null,null,22,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W29=\"\",\"\",W29))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C158=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C158+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C158+1,2))))","v":""},"",null,28,0.92400000000000004]
[null,null,23,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W30=\"\",\"\",W30))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C159=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C159+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C159+1,2))))","v":""},"",null,29,0.92600000000000005]
[null,null,24,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W31=\"\",\"\",W31))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C160=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C160+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C160+1,2))))","v":""},"",null,30,0.92700000000000005]
[null,null,25,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W32=\"\",\"\",W32))","v":""},"","",{"$f":"IF(Values!$B$53=\"\",\"\",IF(C161=\"\",\"\",IF(HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C161+1,2)=0,\"\",HLOOKUP(IF(ISEVEN(COUNT($C$137:$C$186)),COUNT($C$137:$C$186),COUNT($C$137:$C$186)-1),$E$191:$AC$216,C161+1,2))))","v":""},"",null,31,0.92900000000000005]
[null,null,26,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W33=\"\",\"\",W33))","v":""},"","",null,null,null,32,0.93]
[null,null,27,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W34=\"\",\"\",W34))","v":""},"","",null,null,null,33,0.93100000000000005]
[null,null,28,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W35=\"\",\"\",W35))","v":""},"","",null,null,null,34,0.93300000000000005]
[null,null,29,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W36=\"\",\"\",W36))","v":""},"","",null,null,null,35,0.93400000000000005]
[null,null,30,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W37=\"\",\"\",W37))","v":""},"","",null,"sigma:",null,36,0.93500000000000005]
[null,null,31,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W38=\"\",\"\",W38))","v":""},"","",null,{"$f":"IF(Values!$B$53=\"\",\"\",AJ12)","v":""},null,37,0.93600000000000005]
[null,null,32,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W39=\"\",\"\",W39))","v":""},"","",null,null,null,38,0.93799999999999994]
[null,null,33,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W40=\"\",\"\",W40))","v":""},{"$f":"IF(D169=\"\",\"\",SMALL($D$137:$D$186,C169))","v":""},{"$f":"IF(D169=\"\",\"\",LARGE($D$137:$D$186,C169))","v":""},null,null,null,39,0.93899999999999995]
[null,null,34,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W41=\"\",\"\",W41))","v":""},"","",null,null,null,40,0.94]
[null,null,35,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W42=\"\",\"\",W42))","v":""},"","",null,"ni (b)",null,41,0.94099999999999995]
[null,null,36,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W43=\"\",\"\",W43))","v":""},"","",null,{"$f":"IF(Values!$B$53=\"\",\"\",IF(H167=\"\",\"\",SUM(H137:H161)))","v":""},null,42,0.94199999999999995]
[null,null,37,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W44=\"\",\"\",W44))","v":""},"","",null,null,null,43,0.94299999999999995]
[null,null,38,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W45=\"\",\"\",W45))","v":""},"","",null,null,null,44,0.94399999999999995]
[null,null,39,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W46=\"\",\"\",W46))","v":""},"","",null,null,null,45,0.94499999999999995]
[null,null,40,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W47=\"\",\"\",W47))","v":""},"","",null,"Test value AD: ",null,46,0.94499999999999995]
[null,null,41,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W48=\"\",\"\",W48))","v":""},"","",null,{"$f":"IF(Values!$B$53=\"\",\"\",IF(H167=\"\",\"\",(SUMSQ(H172))/((COUNT(D137:D186)-1)*SUMSQ(H167))))","v":""},null,47,0.94599999999999995]
[null,null,42,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W49=\"\",\"\",W49))","v":""},"","",null,null,null,48,0.94699999999999995]
[null,null,43,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W50=\"\",\"\",W50))","v":""},"","",null,null,null,49,0.94699999999999995]
[null,null,44,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W51=\"\",\"\",W51))","v":""},"","",null,null,null,50,0.94699999999999995]
[null,null,45,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W52=\"\",\"\",W52))","v":""},"","",null,"Threshold SW [95%]:"]
[null,null,46,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W53=\"\",\"\",W53))","v":""},"",""]
[null,null,47,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W54=\"\",\"\",W54))","v":""},"","",null,{"$f":"IF(Values!$B$53=\"\",\"\",IF(H167=\"\",\"\",VLOOKUP(COUNT(D137:D186),J138:K180,2)))","v":""},null,"H1 = True If AD < SW"]
[null,null,48,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W55=\"\",\"\",W55))","v":""},"","",null,null,null,"H0 = True If AD > SW"]
[null,null,49,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W56=\"\",\"\",W56))","v":""},"",""]
[null,null,50,{"$f":"IF(Values!$B$53=\"\",\"\",IF(W57=\"\",\"\",W57))","v":""},"","",null,null,null,"H1: Values are normal ditributed"]
[null,null,null,null,null,null,null,null,null,"H0: Values are not normal distributed"]
[]
[]
[null,null,null,null,"n"]
[null,null,null,null,null,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46,48,50]
[null,null,"i",1,null,0.68720000000000003,0.6431,0.60519999999999996,0.57389999999999997,0.54749999999999999,0.52510000000000001,0.50560000000000005,0.18859999999999999,0.47339999999999999,0.45900000000000002,0.44929999999999998,0.44069999999999998,0.43280000000000002,0.4254,0.41880000000000001,0.41270000000000001,0.40679999999999999,0.40150000000000002,0.39639999999999997,0.39169999999999999,0.38719999999999999,0.38300000000000001,0.37890000000000001,0.37509999999999999]
[null,null,null,2,null,0.16769999999999999,0.28060000000000002,0.31640000000000001,0.3291,0.33250000000000002,0.33179999999999998,0.32900000000000001,0.32529999999999998,0.3211,0.31559999999999999,0.30980000000000002,0.30430000000000001,0.29920000000000002,0.2944,0.2898,0.28539999999999999,0.28129999999999999,0.27739999999999998,0.2737,0.27010000000000001,0.26669999999999999,0.26350000000000001,0.26040000000000002,0.25740000000000002]
[null,null,null,3,null,null,8.7499999999999994E-2,0.17430000000000001,0.21410000000000001,0.23469999999999999,0.246,0.25209999999999999,0.25530000000000003,0.25650000000000001,0.2571,0.25540000000000002,0.25330000000000003,0.251,0.2487,0.24629999999999999,0.24390000000000001,0.24149999999999999,0.23910000000000001,0.23680000000000001,0.23449999999999999,0.23230000000000001,0.23019999999999999,0.2281,0.22600000000000001]
[null,null,null,4,null,null,null,5.6099999999999997E-2,0.12239999999999999,0.15859999999999999,0.1802,0.19389999999999999,0.20269999999999999,0.20849999999999999,0.21310000000000001,0.2145,0.21510000000000001,0.21510000000000001,0.21479999999999999,0.21410000000000001,0.2132,0.21210000000000001,0.21099999999999999,0.20979999999999999,0.20849999999999999,0.2072,0.20580000000000001,0.20449999999999999,0.20319999999999999]
[null,null,null,5,null,null,null,null,3.9899999999999998E-2,9.2200000000000004E-2,0.124,0.1447,0.15809999999999999,0.1686,0.1764,0.1807,0.18360000000000001,0.1857,0.187,0.18779999999999999,0.1822,0.1883,0.18809999999999999,0.18779999999999999,0.18740000000000001,0.18679999999999999,0.1862,0.1855,0.1847]
[null,null,null,6,null,null,null,null,null,3.0300000000000001E-2,7.2700000000000001E-2,0.10050000000000001,0.1197,0.13339999999999999,0.14430000000000001,0.1512,0.15629999999999999,0.16009999999999999,0.16300000000000001,0.1651,0.16669999999999999,0.1678,0.1686,0.1691,0.1694,0.16950000000000001,0.16950000000000001,0.16950000000000001,0.1691]
[null,null,null,7,null,null,null,null,null,null,2.4E-2,5.9299999999999999E-2,8.3699999999999997E-2,0.1013,0.115,0.1245,0.13159999999999999,0.13719999999999999,0.14149999999999999,0.1449,0.14749999999999999,0.14960000000000001,0.15129999999999999,0.15260000000000001,0.1535,0.1542,0.15479999999999999,0.15509999999999999,0.15540000000000001]
[null,null,null,8,null,null,null,null,null,null,null,1.9599999999999999E-2,4.9599999999999998E-2,7.1099999999999997E-2,8.7800000000000003E-2,9.9699999999999997E-2,0.1089,0.1162,0.12189999999999999,0.1265,0.13009999999999999,0.1331,0.1356,0.1376,0.13919999999999999,0.14050000000000001,0.14149999999999999,0.14230000000000001,0.14299999999999999]
[null,null,null,9,null,null,null,null,null,null,null,null,1.6299999999999999E-2,4.2200000000000001E-2,6.1800000000000001E-2,7.6399999999999996E-2,8.7599999999999997E-2,9.6500000000000002E-2,0.1036,0.10929999999999999,0.114,0.1179,0.1211,0.1237,0.12590000000000001,0.1278,0.1293,0.13059999999999999,0.13170000000000001]
[null,null,null,10,null,null,null,null,null,null,null,null,null,1.4E-2,3.6799999999999999E-2,5.3900000000000003E-2,6.7199999999999996E-2,7.7799999999999994E-2,8.6199999999999999E-2,9.3100000000000002E-2,9.8799999999999999E-2,0.1036,0.1075,0.1108,0.11360000000000001,0.11600000000000001,0.11799999999999999,0.1197,0.1212]
[null,null,null,11,null,null,null,null,null,null,null,null,null,null,1.2200000000000001E-2,3.2099999999999997E-2,4.7600000000000003E-2,5.9799999999999999E-2,6.9699999999999998E-2,7.7700000000000005E-2,8.4400000000000003E-2,0.09,9.4700000000000006E-2,9.8599999999999993E-2,0.10199999999999999,0.10489999999999999,0.10730000000000001,0.1095,0.1113]
[null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,1.0699999999999999E-2,2.8400000000000002E-2,4.24E-2,5.3699999999999998E-2,6.2899999999999998E-2,7.0599999999999996E-2,7.6999999999999999E-2,8.2400000000000001E-2,8.6999999999999994E-2,9.0899999999999995E-2,9.4299999999999995E-2,9.7199999999999995E-2,9.98E-2,0.10199999999999999]
[null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,9.4000000000000004E-3,2.53E-2,3.8100000000000002E-2,4.8500000000000001E-2,5.7200000000000001E-2,6.4500000000000002E-2,7.0599999999999996E-2,7.5899999999999995E-2,8.0399999999999999E-2,8.4199999999999997E-2,8.7599999999999997E-2,9.06E-2,9.3200000000000005E-2]
[null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3999999999999995E-3,2.2700000000000001E-2,3.44E-2,4.41E-2,5.2299999999999999E-2,5.9200000000000003E-2,6.5100000000000005E-2,7.0099999999999996E-2,7.4499999999999997E-2,7.85E-2,8.1699999999999995E-2,8.4599999999999995E-2]
[null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.6E-3,2.06E-2,3.1399999999999997E-2,4.0399999999999998E-2,4.8099999999999997E-2,5.4600000000000003E-2,6.0199999999999997E-2,6.5100000000000005E-2,6.9400000000000003E-2,7.3099999999999998E-2,7.6399999999999996E-2]
[null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.7999999999999996E-3,1.8700000000000001E-2,2.87E-2,3.7199999999999997E-2,4.4400000000000002E-2,5.0599999999999999E-2,5.6000000000000001E-2,6.0699999999999997E-2,6.4799999999999996E-2,6.8500000000000005E-2]
[null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1999999999999998E-3,1.72E-2,2.64E-2,3.4299999999999997E-2,4.1099999999999998E-2,4.7100000000000003E-2,5.2200000000000003E-2,5.6800000000000003E-2,6.08E-2]
[null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.7000000000000002E-3,1.5800000000000002E-2,2.4400000000000002E-2,3.1800000000000002E-2,3.8300000000000001E-2,4.3900000000000002E-2,4.8899999999999999E-2,5.3199999999999997E-2]
[null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3E-3,1.46E-2,2.2700000000000001E-2,2.9600000000000001E-2,3.5700000000000003E-2,4.1099999999999998E-2,4.5900000000000003E-2]
[null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8999999999999998E-3,1.3599999999999999E-2,2.1100000000000001E-2,2.7699999999999999E-2,3.3500000000000002E-2,3.8600000000000002E-2]
[null,null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4999999999999997E-3,1.26E-2,1.9699999999999999E-2,2.5899999999999999E-2,3.1399999999999997E-2]
[null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1999999999999997E-3,1.18E-2,1.8499999999999999E-2,2.4400000000000002E-2]
[null,null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8999999999999998E-3,1.11E-2,1.7399999999999999E-2]
[null,null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7000000000000002E-3,1.04E-2]
[null,null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5000000000000001E-3]

{"sheet":"Settings","index":5,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":true,"merged":[[13,7,14,10],[6,7,8,13],[7,1,7,2],[7,3,7,5],[25,7,26,10],[25,11,26,13],[16,1,16,5],[17,4,18,5],[19,4,19,5],[21,7,22,10],[21,11,22,13],[23,7,24,10],[23,11,24,13],[22,1,22,3],[19,7,20,10],[19,11,20,13]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,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,"Scale on",null,"Values"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Print a pdf of the register \"Visualization\" to a folder of your choice."]
[]
[]
[null,"Scale on Values"]
[null,null,"Upper","Lower","Scale-Factor \n(Standart = 0,3)"]
[null,"Max/Min",{"$f":"Calculation!AJ7","v":""},{"$f":"Calculation!AJ8","v":""}]
[null,"Scale on",{"$f":"IF(C19=\"\",\"\",C19+(C19-D19)*E20)","v":""},{"$f":"IF(D19=\"\",\"\",D19-(C19-D19)*E20)","v":""},0.3,null,null,"Guide (A \"How to\" handle the document)"]
[]
[null,null,null,null,null,null,null,"Calculations (Distribution; Graphics; Indices)"]
[null,"Custom scaling"]
[null,null,"Lower","Upper",null,null,null,"Directories (Resolution, Measrumentdevices, Units)"]
[null,"Scale on"]
[null,null,null,null,null,null,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."]