{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MSA_Verfahren_2"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"MSA_Verfahren_2","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[7,3,7,6],[7,7,7,8],[39,10,39,11],[4,9,4,12],[5,9,5,12],[6,9,6,12],[7,9,7,12],[4,7,4,8],[6,1,6,2],[6,7,6,8],[6,3,6,6],[3,1,3,2],[5,3,5,6],[4,3,4,6],[0,0,2,3],[0,4,2,11],[5,7,5,8],[4,1,4,2],[3,9,3,12],[0,12,0,13],[3,3,3,6],[3,7,3,8],[5,1,5,2]]}
[null,null,null,null,"PRÜFMITTEL-FÄHIGKEITSUNTERSUCHUNG  \nVerfahren 2",null,null,null,null,null,null,null,"Seite"]
[]
[]
[null,"Datum:",null,null,null,null,null,"X Normal:"]
[null,"Prüfer         :",null,null,null,null,null,"Toleranz"]
[null,"Prüfm.-Bez.   :",null,null,null,null,null,"Einheit:"]
[null,"Prüfm.-Nr.:",null,null,null,null,null,"Temp.:"]
[null,"Verwendungszweck",null,null,null,null,null,"Standartabw.:",null,{"$f":"IF(R_quer_B=0,\"\",STDEV(Messung_A,Messung_B))","v":""}]
[]
[]
[null,"Inspektor A",null,null,null,null,null,null,"Inspektor B"]
[null,"Teil-Nr.","M. 1","M. 2","M. 3","Range",null,null,"Teil-Nr.","M. 1","M. 2","M. 3","Range"]
[null,1,null,null,null,{"$f":"MAX(C13:E13)-MIN(C13:E13)","v":0},null,null,1,null,null,null,{"$f":"MAX(J13:L13)-MIN(J13:L13)","v":0}]
[null,2,null,null,null,0,null,null,2,null,null,null,0]
[null,3,null,null,null,0,null,null,3,null,null,null,0]
[null,4,null,null,null,0,null,null,4,null,null,null,0]
[null,5,null,null,null,0,null,null,5,null,null,null,0]
[null,6,null,null,null,0,null,null,6,null,null,null,0]
[null,7,null,null,null,0,null,null,7,null,null,null,0]
[null,8,null,null,null,0,null,null,8,null,null,null,0]
[null,9,null,null,null,0,null,null,9,null,null,null,0]
[null,10,null,null,null,0,null,null,10,null,null,null,0]
[null,"Summe",{"$f":"SUM(C13:C22)","v":0},{"$f":"SUM(D13:D22)","v":0},{"$f":"SUM(E13:E22)","v":0},{"$f":"SUM(F13:F22)","v":0},null,null,"Summe",{"$f":"SUM(J13:J22)","v":0},{"$f":"SUM(K13:K22)","v":0},{"$f":"SUM(L13:L22)","v":0},{"$f":"SUM(M13:M22)","v":0}]
[null,null,null,null,"R quer A",{"$f":"SUM(F13:F22)/COUNT(F13:F22)","v":0},null,null,null,null,null,"R quer B",{"$f":"SUM(M13:M22)/COUNT(M13:M22)","v":0}]
[]
[null,null,null,null,"Sum A",{"$f":"SUM(C23:E23)","v":0},null,null,null,null,null,"Sum B",{"$f":"SUM(J23:L23)","v":0}]
[]
[null,null,null,null,"xq A",{"$f":"IF(R_quer_B=0,\"\",SUM(C13:E22)/COUNT(C13:E22))","v":""},null,null,null,null,null,"xq B",{"$f":"IF(R_quer_B=0,\"\",SUM(J13:L22)/COUNT(J13:L22))","v":""}]
[]
[null,"Oberen Eingriffsgrenzen RANGE"]
[]
[null,null,null,null,"OEGR",{"$f":"_D4*R_quer","v":0},null,null,"D4",2.58,null,"R quer",{"$f":"(R_quer_A+R_quer_B)/2","v":0}]
[]
[null,"Totale Varianz"]
[null,null,null,null,"xq Diff",{"$f":"IF(R_quer_B=0,\"\",x_quer_A-x_quer_B)","v":""},null,null,null,"Prüfmittel-Wiederholpräzision"]
[null,null,null,null,null,null,null,null,null,null,null,"LV",{"$f":"_K1*R_quer","v":0}]
[null,null,null,null,null,null,null,null,null,"Inspektor-Vergleichspräzision"]
[null,null,null,null,"K1",3.05,null,null,null,null,null,"IV",{"$f":"IF(R_quer_B=0,\"\",_K2*x_quer_Diff)","v":""}]
[null,null,null,null,"K2",3.65]
[null,null,null,null,null,null,null,null,null,null,"Total Varia. TV",null,{"$f":"IF(R_quer_B=0,\"\",SQRT((IV^2+LV^2)))","v":""}]
[]
[null,"Ergebnis in %"]
[null,null,null,null,"Prüfmittel-Wiederholpräzision",{"$f":"IF(R_quer_B=0,\"\",100*(LV^2/(TV*Toleranz)))","v":""}]
[]
[null,null,null,null,"Inspektor-Vergleichspräzision",{"$f":"IF(R_quer_B=0,\"\",100*(IV^2/(TV*Toleranz)))","v":""}]
[]
[null,null,null,null,"Totale Varianz TV",{"$f":"IF(LVproz=\"\",\"\",LVproz+IVproz)","v":""}]
[]
["0-<10%  sehr gut / 10-30% ausreichend / >30% nicht annehmbar"]