{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Vickers"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Vickers","index":0,"n_rows":62,"n_cols":33,"rows_kept":62,"merged":[[1,1,1,14],[2,27,2,30],[3,1,3,6],[3,8,3,11],[4,1,4,6],[4,8,4,11],[5,1,5,6],[5,8,5,9],[6,1,6,6],[6,8,6,9],[6,27,6,30],[7,1,7,6],[7,8,7,9],[8,1,8,6],[8,8,8,9],[9,1,9,6],[9,8,9,9],[10,1,10,6],[10,8,10,9],[11,1,11,6],[11,8,11,9],[11,13,11,14],[13,1,23,1],[58,1,58,6],[59,2,59,12],[60,2,60,12],[61,2,61,12]]}
[]
[null,"Periodische Prüfung zur Prüfmittelüberwachung nach Vickers"]
[{"$nulls":27},"r rel %"]
[null,"Prüfmaschine",{"$nulls":26},"HV 5-100","HV 0,2-<5","<HV 0,2","% d","HV aus %"]
[null,"MPA-Nummer der Härtevergleichsplatte",{"$nulls":24},{"$f":"0.21/I7+1.5","v":{"v":4.949096196530926,"d":"4.9"}},"<=250",6,12,18,{"$f":"IF(I6<=225,IF(L6<0.2,AE5,IF((L6>=0.2)*(L6<5),AD5,IF((L6>=5)*(L6<=125),AC5))))","v":false},{"$f":"IF(AF5>1,AF5%*I6,0)","v":0}]
[null,"Zertifizierte Härte der Härtevergleichsplatte",{"$nulls":6},{"v":500,"d":"500.00"},null,"[HV]",{"v":1,"d":"1.000"},{"$nulls":15},">250",4,8,12,{"$f":"IF(I6>225,IF(L6<0.2,AE6,IF((L6>=0.2)*(L6<5),AD6,IF((L6>=5)*(L6<=125),AC6))))","v":8},{"$f":"IF(AF6>1,AF6%*I6,0)","v":40}]
[null,"Mittlere Eindruckdiagonale der Härtevergleichsplatte",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\"\",SQRT((L6*9.807)/(I6/0.189)))","v":{"v":0.060885515518881834,"d":"0.0609"}},null,"[mm]",{"$nulls":16},"r in HV"]
[null,"zulässige Anzeigeabweichung in %",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\"\",IF(I7<0.14,0.21/I7+1.5,IF(I7>0.14,\"3\",)))","v":{"v":4.949096196530926,"d":"4.9"}},null,"%"]
[null,"zulässige Wiederholpräzision in HV",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\"\",IF(I6<=250,AG5,IF(I6>250,AG6,500)))","v":40},null,"[HV]"]
[null,"zulässige Wiederholpräzision in %",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\"\",IF(I6<=225,AF5,IF(I6>225,AF6,500)))","v":{"v":8,"d":"8.0"}},null,"%"]
[null,"Obere Toleranzgrenze",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\"\",((1+(I8/100))*I6))","v":{"v":524.7454809826546,"d":"525"}},null,"[HV]"]
[null,"Untere Toleranzgrenze",{"$nulls":6},{"$f":"IF(ISBLANK(L6),\"\",((1-(I8/100))*I6))","v":{"v":475.2545190173454,"d":"475"}},null,"[HV]",null,null,"Tel.: +49 (0)2773 9169261                                               www.siantec.de"]
[]
[null,"Härtewerte in [HV]"]
[null,null,{"$f":"(C16-C19)/3*4+C19","v":{"v":532.9939746435394,"d":"533"}}]
[null,null,{"$f":"I11","v":{"v":524.7454809826546,"d":"525"}}]
[null,null,{"$f":"(C16-C19)/3*2+C19","v":{"v":516.4969873217698,"d":"516"}}]
[null,null,{"$f":"(C16-C19)/3*1+C19","v":{"v":508.2484936608849,"d":"508"}}]
[null,null,{"$f":"I6","v":500}]
[null,null,{"$f":"(C22-C19)/3*1+C19","v":{"v":491.7515063391151,"d":"492"}}]
[null,null,{"$f":"(C22-C19)/3*2+C19","v":{"v":483.5030126782303,"d":"484"}}]
[null,null,{"$f":"I12","v":{"v":475.2545190173454,"d":"475"}}]
[null,null,{"$f":"(C22-C19)/3*4+C19","v":{"v":467.0060253564605,"d":"467"}}]
[]
[]
[null,"Lfd.\nNr.","Prüfer","Datum","KW","1.\nMess.","2.\nMess.","3.\nMess.","4.\nMess.","5.\nMess.","Mittel-wert","d","b","r","Bemerkungen",{"$nulls":5},"Relative Anzeigeabweichung der mittleren Diagonale","Messwert Diagonale d1 in mm","Messwert Diagonale d2 in mm","Messwert Diagonale d3 in mm","Messwert Diagonale d4 in mm","Messwert Diagonale d5 in mm"]
[null,1,"Herzog","2021-02-17",{"$f":"IF(ISBLANK(D27),\"\",TRUNC((D27-WEEKDAY(D27,2)-DATE(YEAR(D27+4-WEEKDAY(D27,2)),1,-10))/7))","v":7},505,515,510,512,508,{"$f":"IF(ISBLANK(F27),\"\",AVERAGE(F27:J27))","v":{"v":510,"d":"510.0"}},{"$f":"IF(ISBLANK(F27),\"\",AVERAGE(V27:Z27))","v":{"v":0.06028665189377659,"d":"0.0603"}},{"$f":"IF(ISBLANK(F27),\"\",((K27-$I$6)/$I$6)*100)","v":{"v":2,"d":"2.0"}},{"$f":"IF(ISBLANK(G27),\"\",(MAX(V27:Z27)-MIN(V27:Z27))/L27*100)","v":{"v":0.9804346583313457,"d":"1.0"}},"Beispiel",null,{"$f":"(I8+M27)/I8*100-100","v":40.41141898599389},{"$f":"Q27*0.6","v":24.246851391596334},null,null,{"$f":"IF(ISBLANK(F27),\"\",((L27-$I$7)/$I$7)*100)","v":{"v":-0.9835896436148653,"d":"-0.98"}},{"$f":"IF(ISBLANK(F27),\"\",IF(F27<>0,SQRT(($L$6*9.807)/(F27/0.189))))","v":{"v":0.06058335228639486,"d":"0.0606"}},{"$f":"IF(ISBLANK(G27),\"\",IF(G27<>0,SQRT(($L$6*9.807)/(G27/0.189))))","v":{"v":0.0599922810568807,"d":"0.0600"}},{"$f":"IF(ISBLANK(H27),\"\",IF(H27<>0,SQRT(($L$6*9.807)/(H27/0.189))))","v":{"v":0.06028564359388902,"d":"0.0603"}},{"$f":"IF(ISBLANK(I27),\"\",IF(I27<>0,SQRT(($L$6*9.807)/(I27/0.189))))","v":{"v":0.060167782985373494,"d":"0.0602"}},{"$f":"IF(ISBLANK(J27),\"\",IF(J27<>0,SQRT(($L$6*9.807)/(J27/0.189))))","v":{"v":0.060404199546344836,"d":"0.0604"}}]
[null,2,null,null,{"$f":"IF(ISBLANK(D28),\"\",TRUNC((D28-WEEKDAY(D28,2)-DATE(YEAR(D28+4-WEEKDAY(D28,2)),1,-10))/7))","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(F28),\"\",AVERAGE(F28:J28))","v":""},{"$f":"IF(ISBLANK(F28),\"\",AVERAGE(V28:Z28))","v":""},{"$f":"IF(ISBLANK(F28),\"\",((K28-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M28)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,3,null,null,{"$f":"IF(ISBLANK(D29),\"\",TRUNC((D29-WEEKDAY(D29,2)-DATE(YEAR(D29+4-WEEKDAY(D29,2)),1,-10))/7))","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(F29),\"\",AVERAGE(F29:J29))","v":""},{"$f":"IF(ISBLANK(F29),\"\",AVERAGE(V29:Z29))","v":""},{"$f":"IF(ISBLANK(F29),\"\",((K29-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M29)/I8*100-100","v":{"$error":"#VALUE!"}},{"$f":"Q29*0.6","v":{"$error":"#VALUE!"}},null,null,"","","","","",""]
[null,4,null,null,{"$f":"IF(ISBLANK(D30),\"\",TRUNC((D30-WEEKDAY(D30,2)-DATE(YEAR(D30+4-WEEKDAY(D30,2)),1,-10))/7))","v":""},{"$nulls":5},{"$f":"IF(ISBLANK(F30),\"\",AVERAGE(F30:J30))","v":""},{"$f":"IF(ISBLANK(F30),\"\",AVERAGE(V30:Z30))","v":""},{"$f":"IF(ISBLANK(F30),\"\",((K30-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M30)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,5,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F31),\"\",((K31-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M31)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,6,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F32),\"\",((K32-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M32)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,7,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F33),\"\",((K33-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M33)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,8,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F34),\"\",((K34-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M34)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,9,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F35),\"\",((K35-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M35)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,10,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F36),\"\",((K36-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M36)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,11,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F37),\"\",((K37-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M37)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,12,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F38),\"\",((K38-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M38)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,13,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M39)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,14,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M40)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,15,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M41)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,16,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M42)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,17,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M43)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,18,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M44)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,19,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M45)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,20,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M46)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,21,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M47)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,22,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M48)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,23,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M49)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,24,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M50)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,25,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M51)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,26,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M52)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,27,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M53)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,28,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M54)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,29,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M55)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,30,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M56)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,31,null,null,"",{"$nulls":5},"","",{"$f":"IF(ISBLANK(F57),\"\",((K57-$I$6)/$I$6)*100)","v":""},"",null,null,{"$f":"(I8+M57)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[]
[null,"Erläuterungen:"]
[null,"d","= mittlere Diagonale in mm"]
[null,"b","= Abweichung der Maschine in %"]
[null,"r","= Wiederholpräzision der Härteprüfmaschine in %"]