{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Rockwell"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"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."]