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

{"sheet":"Rockwell","index":0,"n_rows":59,"n_cols":26,"rows_kept":59,"merged":[[1,1,1,14],[3,1,3,6],[3,8,3,10],[4,1,4,6],[4,8,4,10],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[9,1,9,6],[9,12,9,14],[11,1,21,1],[23,13,23,14],[24,13,24,14],[25,13,25,14],[26,13,26,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[34,13,34,14],[35,13,35,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[43,13,43,14],[44,13,44,14],[45,13,45,14],[46,13,46,14],[47,13,47,14],[48,13,48,14],[49,13,49,14],[50,13,50,14],[51,13,51,14],[52,13,52,14],[53,13,53,14],[54,13,54,14],[55,13,55,14],[56,1,56,6],[56,13,56,14],[57,2,57,12],[58,2,58,12],[59,13,59,14],[60,13,60,14],[61,13,61,14],[62,13,62,14],[63,13,63,14],[64,13,64,14],[65,13,65,14],[66,13,66,14],[67,13,67,14],[68,13,68,14],[69,13,69,14],[70,13,70,14],[71,13,71,14],[72,13,72,14],[73,13,73,14],[74,13,74,14],[75,13,75,14],[76,13,76,14],[77,13,77,14],[78,13,78,14],[79,13,79,14],[80,13,80,14],[81,13,81,14],[82,13,82,14],[83,13,83,14],[84,13,84,14],[85,13,85,14],[86,13,86,14],[87,13,87,14],[88,13,88,14],[89,13,89,14],[90,13,90,14],[91,13,91,14],[92,13,92,14],[93,13,93,14],[94,13,94,14],[95,13,95,14],[96,13,96,14],[97,13,97,14],[98,13,98,14],[99,13,99,14],[100,13,100,14],[101,13,101,14],[102,13,102,14],[103,13,103,14],[104,13,104,14],[105,13,105,14],[106,13,106,14],[107,13,107,14],[108,13,108,14],[109,13,109,14],[110,13,110,14],[111,13,111,14],[112,13,112,14],[113,13,113,14],[114,13,114,14],[115,13,115,14],[116,13,116,14],[117,13,117,14],[118,13,118,14],[119,13,119,14],[120,13,120,14],[121,13,121,14],[122,13,122,14],[123,13,123,14],[124,13,124,14],[125,13,125,14],[126,13,126,14],[127,13,127,14],[128,13,128,14],[129,13,129,14],[130,13,130,14],[131,13,131,14],[132,13,132,14],[133,13,133,14],[134,13,134,14],[135,13,135,14],[136,13,136,14],[137,13,137,14],[138,13,138,14],[139,13,139,14],[140,13,140,14],[141,13,141,14],[142,13,142,14],[143,13,143,14]]}
[]
[null,"Periodische Prüfung zur Prüfmittelüberwachung nach Rockwell"]
[{"$nulls":19},"Rockwell-Härteskala","Härtebereich","B [±] HR","r"]
[null,"Prüfmaschine ",{"$nulls":16},{"$f":"IF(I6<=75,V4,V5)","v":{"v":2,"d":"2.0"}},"A","20 HRA bis 75 HRA",{"v":2,"d":"2.0"},"≤ 0,02 (100 - H) oder 0,8 HRA",{"$f":"0.02*(100-I6)","v":0.7000000000000001},0.8,{"$f":"MAX(X4:Y4)","v":0.8}]
[null,"MPA-Nummer der Härtevergleichsplatte",{"$nulls":18},"> 75 HRA bis 95 HRA",1.5]
[null,"Zertifizierte Härte der Härtevergleichsplatte",{"$nulls":6},{"v":65,"d":"65.00"},"[HR]","C",{"$nulls":7},{"$f":"IF(I6<=45,V6,IF(I6<=80,V7,V8))","v":{"v":3,"d":"3.0"}},null,"10 HRBW bis 45 HRBW",{"v":4,"d":"4.0"}]
[null,"zulässige Anzeigeabweichung in HR",{"$nulls":6},{"$f":"IF(K6=\"A\",S4,IF(K6=\"B\",S6,IF(K6=\"C\",S9,IF(K6=\"D\",S10,IF(K6=\"E\",S24,IF(K6=\"F\",S26,IF(K6=\"G\",S28,IF(K6=\"H\",S31,IF(K6=\"K\",S32,IF(K6=\"HR-N\",S35,IF(K6=\"HR-TW\",S36,\"\")))))))))))","v":1.5},"[HR]",{"$nulls":9},"B","> 45 HRBW bis 80 HRBW",{"v":3,"d":"3.0"},"≤ 0,04 (130 - H) HRBW",{"$f":"0.04*(130-I6)","v":2.6}]
[null,"zulässige Wiederholpräzision in HR",{"$nulls":6},{"$f":"IF(K6=\"A\",Z4,IF(K6=\"B\",X7,IF(K6=\"C\",Z9,IF(K6=\"D\",Z10,IF(K6=\"E\",X24,IF(K6=\"F\",X26,IF(K6=\"G\",X29,IF(K6=\"H\",X31,IF(K6=\"K\",X33,IF(K6=\"HR-N\",Z35,IF(K6=\"HR-TW\",Z36,\"\")))))))))))","v":{"v":0.8,"d":"0.80"}},"[HR]",{"$nulls":10},"> 80 HRBE bis 100 HRBW",{"v":2,"d":"2.0"}]
[null,"Obere Toleranzgrenze",{"$nulls":6},{"$f":"I6+I7","v":{"v":66.5,"d":"66.50"}},"[HR]",{"$nulls":8},{"$f":"V9","v":1.5},"C","10 HRC bis 70 HRC",1.5,"≤ 0,02 (100 - H) oder 0,8 HRC",{"$f":"0.02*(100-I6)","v":0.7000000000000001},0.8,{"$f":"MAX(X9:Y9)","v":0.8}]
[null,"Untere Toleranzgrenze",{"$nulls":6},{"$f":"I6-I7","v":{"v":63.5,"d":"63.50"}},"[HR]",null,null,"Tel.: +49 (0)2773 9169261                                                   www.siantec.de",{"$nulls":5},{"$f":"IF(I6<=70,V10,V23)","v":{"v":2,"d":"2.0"}},"D","40 HRD bis 70 HRD",{"v":2,"d":"2.0"},"≤ 0,02 (100 - H) oder 0,8 HRD",{"$f":"0.02*(100-I6)","v":0.7000000000000001},0.8,{"$f":"MAX(X10:Y10)","v":0.8}]
[]
[null,"Härtewerte in [HR]"]
[null,null,{"$f":"(C14-C17)/3*4+C17","v":{"v":67,"d":"67.0"}}]
[null,null,{"$f":"I9","v":66.5}]
[null,null,{"$f":"(C14-C17)/3*2+C17","v":{"v":66,"d":"66.0"}}]
[null,null,{"$f":"(C14-C17)/3*1+C17","v":65.5}]
[null,null,{"$f":"I6","v":{"v":65,"d":"65.0"}}]
[null,null,{"$f":"(C20-C17)/3*1+C17","v":64.5}]
[null,null,{"$f":"(C20-C17)/3*2+C17","v":{"v":64,"d":"64.0"}}]
[null,null,{"$f":"I10","v":63.5}]
[null,null,{"$f":"(C20-C17)/3*4+C17","v":{"v":63,"d":"63.0"}}]
[]
[{"$nulls":20},"> 70 HRD bis 77 HRD",1.5]
[null,"Lfd.\nNr.","Prüfer","Datum","KW","1.\nMess.","2.\nMess.","3.\nMess.","4.\nMess.","5.\nMess.","Mittel-wert","b","r","Bemerkungen",{"$nulls":4},{"$f":"IF(I6<=90,V24,V25)","v":2.5},"E","70 HREW bis 90 HREW",2.5,"≤ 0,04 (130 - H) HREW",{"$f":"0.04*(130-I6)","v":2.6}]
[null,1,"Herzog","2021-02-17",{"$f":"IF(ISBLANK($D25),\"\",TRUNC((D25-WEEKDAY(D25,2)-DATE(YEAR(D25+4-WEEKDAY(D25,2)),1,-10))/7))","v":7},{"v":65.2,"d":"65.20"},{"v":65.3,"d":"65.30"},{"v":65,"d":"65.00"},{"v":65.1,"d":"65.10"},{"v":65.5,"d":"65.50"},{"$f":"IF(ISBLANK($F25),\"\",AVERAGE(F25:J25))","v":65.22},{"$f":"IF(ISBLANK($F25),\"\",(K25-$I$6))","v":{"v":0.21999999999999886,"d":"0.22"}},{"$f":"IF(ISBLANK($G25),\"\",MAX(F25:J25)-MIN(F25:J25))","v":{"v":0.5,"d":"0.50"}},"Beispiel",null,null,{"$f":"(I7+L25)/I7*100-100","v":14.666666666666586},{"$f":"Q25*0.6","v":8.799999999999951},null,null,"> 90 HREW bis 100 HREW",{"v":2,"d":"2.0"}]
[null,2,null,null,{"$f":"IF(ISBLANK($D26),\"\",TRUNC((D26-WEEKDAY(D26,2)-DATE(YEAR(D26+4-WEEKDAY(D26,2)),1,-10))/7))","v":""},{"$nulls":5},{"$f":"IF(ISBLANK($F26),\"\",AVERAGE(F26:J26))","v":""},"",{"$f":"IF(ISBLANK($G26),\"\",MAX(F26:J26)-MIN(F26:J26))","v":""},{"$nulls":3},{"$f":"(I7+L26)/I7*100-100","v":{"$error":"#VALUE!"}},{"$f":"Q26*0.6","v":{"$error":"#VALUE!"}},{"$f":"IF(I6<=90,V26,V27)","v":{"v":3,"d":"3.0"}},"F","60 HRFW bis 90 HRFW",{"v":3,"d":"3.0"},"≤ 0,04 (130 - H) HRFW",{"$f":"0.04*(130-I6)","v":2.6}]
[null,3,null,null,"",{"$nulls":5},{"$f":"IF(ISBLANK($F27),\"\",AVERAGE(F27:J27))","v":""},{"$f":"IF(ISBLANK($F27),\"\",(K27-$I$6))","v":""},{"$f":"IF(ISBLANK($G27),\"\",MAX(F27:J27)-MIN(F27:J27))","v":""},{"$nulls":3},{"$f":"(I7+L27)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"> 90 HRFW bis 100 HRGW",{"v":2,"d":"2.0"}]
[null,4,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L28)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(I6<=50,V28,IF(I6<=75,V29,V30))","v":4.5},null,"30 HRGW bis 50 HRGW",{"v":6,"d":"6.0"}]
[null,5,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L29)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"G","> 50 HRGW bis 75 HRGW",4.5,"≤ 0,04 (130 - H) HRGW",{"$f":"0.04*(130-I6)","v":2.6}]
[null,6,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L30)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"> 75 HRGW bis 94 HRGW",{"v":3,"d":"3.0"}]
[null,7,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L31)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"V31","v":{"v":2,"d":"2.0"}},"H","80 HRHW bis 100 HRHW",{"v":2,"d":"2.0"},"≤ 0,04 (130 - H) HRHW",{"$f":"0.04*(130-I6)","v":2.6}]
[null,8,null,null,"",{"$nulls":5},"",{"$f":"IF(ISBLANK($F32),\"\",(K32-$I$6))","v":""},{"$f":"IF(ISBLANK($G32),\"\",MAX(F32:J32)-MIN(F32:J32))","v":""},{"$nulls":3},{"$f":"(I7+L32)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(I6<=60,V32,IF(I6<=80,V33,V34))","v":{"v":3,"d":"3.0"}},null,"40 HRKW bis 60 HRKW",{"v":4,"d":"4.0"}]
[null,9,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L33)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"K","> 60 HRKW bis 80 HRKW",{"v":3,"d":"3.0"},"≤ 0,04 (130 - H) HRKW",{"$f":"0.04*(130-I6)","v":2.6}]
[null,10,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L34)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"> 80 KRKW bis 100 HRKW",{"v":2,"d":"2.0"}]
[null,11,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L35)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"V35","v":{"v":2,"d":"2.0"}},"15N , 30 N , 45 N","Alle Bereiche",{"v":2,"d":"2.0"},"≤ 0,04 (130 - H) oder 1,2 HR-N",{"$f":"0.04*(130-I6)","v":2.6},1.2,{"$f":"MAX(X35:Y35)","v":2.6}]
[null,12,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L36)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"V36","v":{"v":3,"d":"3.0"}},"15T , 30T , 45T","Alle Bereiche ",{"v":3,"d":"3.0"},"≤ 0,06 (130 - H) oder 2,4 HR-TW",{"$f":"0.03*(130-I6)","v":1.95},2.4,{"$f":"MAX(X36:Y36)","v":2.4}]
[null,13,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L37)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,14,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L38)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,15,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L39)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,16,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L40)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,17,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L41)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,18,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L42)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,19,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L43)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,20,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L44)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,21,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L45)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,22,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L46)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,23,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L47)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,24,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L48)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,25,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L49)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,26,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L50)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,27,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L51)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,28,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L52)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,29,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L53)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,30,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L54)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,31,null,null,"",{"$nulls":5},"","","",{"$nulls":3},{"$f":"(I7+L55)/I7*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
[null,"Erläuterungen:"]
[null,"b","= Abweichung der Maschine in HR - Einheiten der angewandten Skala"]
[null,"r","= Wiederholpräzision der Härteprüfmaschine in HR - Einheiten der angewandten Skala."]

{"sheet":"Vickers","index":1,"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"}},{"v":0.0599922810568807,"d":"0.0600"},{"v":0.06028564359388902,"d":"0.0603"},{"v":0.060167782985373494,"d":"0.0602"},{"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":""},"","",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":""},"","",null,null,{"$f":"(I8+M29)/I8*100-100","v":{"$error":"#VALUE!"}},{"$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":""},"","",null,null,{"$f":"(I8+M30)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,5,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M31)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,6,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M32)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,7,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M33)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,8,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M34)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,9,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M35)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,10,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M36)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,11,null,null,"",{"$nulls":5},"","","","",null,null,{"$f":"(I8+M37)/I8*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"","","","","",""]
[null,12,null,null,"",{"$nulls":5},"","","","",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 %"]

{"sheet":"Brinell","index":2,"n_rows":141,"n_cols":31,"rows_kept":141,"merged":[[1,1,1,15],[3,1,3,6],[3,8,3,12],[4,1,4,6],[4,8,4,12],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[11,14,11,15],[13,1,23,1],[25,10,25,11],[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 Brinell"]
[{"$nulls":22},"Beanspruchungsgrad = 30"]
[null,"Prüfmaschine",{"$nulls":20},"Härtebereich","Härte","r rel [%]","Erel [%]"]
[null,"MPA-Nummer der Härtevergleichsplatte",{"$nulls":20},1,"HC< 250 HBW",{"v":3,"d":"3.0"},"± 3,0"]
[null,"Zertifizierte Härte der Härtevergleichsplatte",{"$nulls":6},250,"HBW",{"v":10,"d":"10.0"},"/",{"v":3000,"d":"3000.0"},{"$nulls":9},2,"250 HBW ≤ HC ≤450 HBW",2.5,"± 2,5",null,"Prüfverfahren","HBW",null,187.5]
[null,"Mittlere Eindruckdiagonale der Härtevergleichsplatte",{"$nulls":6},{"$f":"IF(ISBLANK(K6),\"\",SQRT((K6^2-(K6-((2*M6)/(I6*3.14*K6)))^2)))","v":{"v":3.8343737435139893,"d":"3.8344"}},"[mm]",{"$nulls":12},3,"HC > 450 HBW",{"v":2,"d":"2.0"},"± 2,0",null,"Sollwwert Härte HBW / Diagonale","HBW / mm",null,{"$f":"IF(ISBLANK(AD6),\"\",SQRT((AD6^2-(AD6-((2*AE6)/(AD7*3.14*AD6)))^2)))","v":""}]
[null,"zulässige Wiederholpräzision in %",{"$nulls":6},{"$f":"IF(I12<>30,Y11,IF(I6<250,Y5,IF(I6<=450,Y6,Y7)))","v":2.5},"%",{"$nulls":11},"0,102 x FID2 = 10","0,102 x FID2 = 5","0,102 x FID2 ≤ 2,5",{"$nulls":3},"Messwert H 1 / Diagonale d1","HBW / mm",{"$f":"IF(ISBLANK(AD6),\"\",(2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE8)^2))))","v":""},{"$f":"IF(ISBLANK(AD6),\"\",SQRT((AD6^2-(AD6-((2*AE6)/(AD8*3.14*AD6)))^2)))","v":""}]
[null,"zulässige Anzeigeabweichung in %",{"$nulls":6},{"$f":"IF(I12<>30,Y11,IF(I6<250,Y5,IF(I6<=450,Y6,Y7)))","v":2.5},"%",{"$nulls":10},"Härtebereich","Härte","Härte","Härte","r rel [%]","Erel [%]",null,"Messwert H 2 / Diagonale d2","HBW / mm",{"$f":"IF(ISBLANK(AD6),\"\",(2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE9)^2))))","v":""},{"$f":"IF(ISBLANK(AD6),\"\",SQRT((AD6^2-(AD6-((2*AE6)/(AD9*3.14*AD6)))^2)))","v":""}]
[null,"Obere Toleranzgrenze",{"$nulls":6},{"$f":"I6*(100+I8)/100","v":{"v":256.25,"d":"256.3"}},"[HBW]",{"$nulls":10},1,"HC < 100 HBW","HC < 70 HBW","HC < 70",{"v":3,"d":"3.0"},"± 3,0",null,"Messwert H 3 / Diagonale d3","HBW / mm",{"$f":"IF(ISBLANK(AD6),\"\",(2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE10)^2))))","v":""},{"$f":"IF(ISBLANK(AD6),\"\",SQRT((AD6^2-(AD6-((2*AE6)/(AD10*3.14*AD6)))^2)))","v":""}]
[null,"Untere Toleranzgrenze",{"$nulls":6},{"$f":"I6*(100-I8)/100","v":{"v":243.75,"d":"243.8"}},"[HBW]",{"$nulls":10},2,"100 HBW ≤ HC\n ≤ 200 HBW","70 HBW ≤ HC ≤ \n100 HBW","N/A",{"v":3,"d":"3.0"},"± 3,0",null,"Messwert H 4 / Diagonale d4","HBW / mm",{"$f":"IF(ISBLANK(AD6),\"\",(2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE11)^2))))","v":""},{"$f":"IF(ISBLANK(AD6),\"\",SQRT((AD6^2-(AD6-((2*AE6)/(AD11*3.14*AD6)))^2)))","v":""}]
[null,"Beanspruchungsgrad",{"$nulls":6},{"$f":"M6/K6^2","v":30},{"$nulls":5},"Tel.: +49 (0)2773 9169261                     www.siantec.de",{"$nulls":5},3,"HC >200 HBW","HC > 100 HBW","N/A",{"v":3,"d":"3.0"},"± 3,0",null,"Messwert H 5 / Diagonale d5","HBW / mm",{"$f":"IF(ISBLANK(AD6),\"\",(2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE12)^2))))","v":""},{"$f":"IF(ISBLANK(AD6),\"\",SQRT((AD6^2-(AD6-((2*AE6)/(AD12*3.14*AD6)))^2)))","v":""}]
[{"$nulls":27},"Mittelw. H 1-5 / Diagonale d 1-5","HBW / mm",{"$f":"IF(ISBLANK(AD6),\"\",AVERAGE(AD8:AD12))","v":""},{"$f":"IF(ISBLANK(AD6),\"\",AVERAGE(AE8:AE12))","v":""}]
[null,"Härtewerte in [HB]"]
[null,null,{"$f":"(C16-C19)/3*4+C19","v":{"v":258.3333333333333,"d":"258"}}]
[null,null,{"$f":"I10","v":{"v":256.25,"d":"256"}}]
[null,null,{"$f":"(C16-C19)/3*2+C19","v":{"v":254.16666666666666,"d":"254"}}]
[null,null,{"$f":"(C16-C19)/3*1+C19","v":{"v":252.08333333333334,"d":"252"}}]
[null,null,{"$f":"I6","v":250}]
[null,null,{"$f":"(C22-C19)/3*1+C19","v":{"v":247.91666666666666,"d":"248"}}]
[null,null,{"$f":"(C22-C19)/3*2+C19","v":{"v":245.83333333333334,"d":"246"}}]
[null,null,{"$f":"I11","v":{"v":243.75,"d":"244"}}]
[null,null,{"$f":"(C22-C19)/3*4+C19","v":{"v":241.66666666666666,"d":"242"}}]
[]
[]
[null,"Lfd.\nNr.","Prüfer","Datum","KW","1.\nMess.","2.\nMess.","3.\nMess.","4.\nMess.","5.\nMess.","Mittel-wert",null,"d","b","r","Bemerkungen",{"$nulls":4},"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,null,"rel. Anzeigeabweichung Härte","%",{"$f":"IF(ISBLANK(AD6),\"\",((AD13-AD7)/AD7)*100)","v":""}]
[null,1,"Herzog","2021-02-19",{"$f":"IF(ISBLANK(D27),\"\",TRUNC((D27-WEEKDAY(D27,2)-DATE(YEAR(D27+4-WEEKDAY(D27,2)),1,-10))/7))","v":7},251,252,255,251,253,{"$f":"IF(ISBLANK(F27),\"\",AVERAGE(F27:J27))","v":{"v":252.4,"d":"252"}},null,{"$f":"IF(ISBLANK(F27),\"\",AVERAGE(U27:Y27))","v":{"v":3.8168672479139807,"d":"3.8169"}},{"$f":"IF(ISBLANK(F27),\"\",((K27-$I$6)/$I$6)*100)","v":{"v":0.9600000000000023,"d":"1.0"}},{"$f":"IF(ISBLANK(G27),\"\",(MAX(U27:Y27)-MIN(U27:Y27))/M27*100)","v":{"v":0.7586420254746918,"d":"0.8"}},"Beispiel",null,{"$f":"(I9+N27)/I9*100-100","v":38.40000000000009},{"$f":"R27*0.6","v":23.040000000000052},null,{"$f":"IF(ISBLANK(F27),\"\",IF($F27<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(F27*3.14*$K$6)))^2))))","v":{"v":3.8270308130941793,"d":"3.8270"}},{"v":3.8197298129041335,"d":"3.8197"},{"v":3.7980744540949245,"d":"3.7981"},{"v":3.8270308130941793,"d":"3.8270"},{"v":3.812470346382486,"d":"3.8125"},null,null,"rel. Wiederholpräz. von Mittelw. d","%",null,{"$f":"IF(ISBLANK(AD6),\"\",(MAX(AE8:AE12)-MIN(AE8:AE12))/AE13*100)","v":""}]
[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},"",null,"","","",null,null,{"$f":"(I9+N28)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","","",null,null,"U Kal. der CRM aus dem Prüfzeugnis k=2","HBW",{"$f":"AD7*0.015","v":{"v":0,"d":"0.00"}}]
[null,3,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N29)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","","",null,null,"Härteänderung der HBWP seit der letzten Kalibrierung durch Drift","HBW",{"v":0,"d":"0.00"}]
[null,4,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N30)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","","",null,null,"u der Härteprüfm. auf der CRM (HBWP)","HBW",{"$f":"(1.14*(STDEV(AD8:AD12)))/SQRT(5)","v":{"$error":"#DIV/0!"}}]
[null,5,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N31)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","","",null,null,"u Auflösung Härteprüfm.","HBW",{"$f":"((2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE13)^2)))-(2*AE6)/(3.14*AD6*(AD6-SQRT(AD6^2-AVERAGE(AE13+AE31)^2))))/(2*SQRT(3))","v":{"$error":"#DIV/0!"}},{"$f":"0.005*AE7","v":{"$error":"#VALUE!"}}]
[null,6,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N32)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","","",null,null,"Messunsicherheit U Bei k=2","HBW",{"$f":"IF(ISBLANK(AD6),\"\",SQRT((0.5*AD28^2)+(AD29^2)+(AD30^2)+(AD31^2))*2)","v":""}]
[null,7,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N33)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,8,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N34)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,9,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N35)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,10,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N36)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,11,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N37)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,12,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N38)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,13,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N39)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,14,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N40)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,15,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N41)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,16,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N42)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,17,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N43)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,18,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N44)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,19,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N45)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,20,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N46)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,21,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N47)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,22,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N48)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,23,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N49)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,24,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N50)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,25,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N51)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,26,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N52)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,27,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N53)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,28,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N54)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,29,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N55)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,30,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N56)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[null,31,null,null,"",{"$nulls":5},"",null,"","","",null,null,{"$f":"(I9+N57)/I9*100-100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"","","","",""]
[{"$nulls":20},"","","","",""]
[null,"Erläuterungen:",{"$nulls":18},{"$f":"IF(ISBLANK(F59),\"\",IF($F59<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(F59*3.14*$K$6)))^2))))","v":""},"","","",""]
[null,"d","= mittlere Diagonale in mm",{"$nulls":17},"","","","",""]
[null,"b","= Abweichung der Maschine in %",{"$nulls":17},"","","","",""]
[null,"r","= Wiederholpräzision der Härteprüfmaschine in %",{"$nulls":17},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},{"$f":"IF(ISBLANK(F91),\"\",IF($F91<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(F91*3.14*$K$6)))^2))))","v":""},"","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},{"$f":"IF(ISBLANK(F123),\"\",IF($F123<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(F123*3.14*$K$6)))^2))))","v":""},"","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},"","","","",""]
[{"$nulls":20},{"$f":"IF(ISBLANK(H141),\"\",IF($F141<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(H141*3.14*$K$6)))^2))))","v":""},{"$f":"IF(ISBLANK(I141),\"\",IF($F141<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(I141*3.14*$K$6)))^2))))","v":""},{"$f":"IF(ISBLANK(J141),\"\",IF($F141<>0,SQRT(($K$6^2-($K$6-((2*$M$6)/(J141*3.14*$K$6)))^2))))","v":""}]