{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Daten","Tabelle"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Daten","index":0,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zu messen: Durchmesser A2"]
[null,"Stichprobe","Längen-messung",null,null,null,null,null,null,null,null,null,"Soll","Obere Grenze","Untere Grenze",null,"Mittelwert"]
[null,1,1000.2,null,null,null,null,null,null,null,null,null,30,30.3,29.7,null,{"$f":"AVERAGE($F$4:J$8)","v":{"$error":"#DIV/0!"}}]
[null,2,999.8,null,null,null,null,null,null,null,null,null,null,30.3,29.7,null,{"$f":"AVERAGE($F$4:J$8)","v":{"$error":"#DIV/0!"}}]
[null,3,1000.7,null,null,null,null,null,null,null,null,null,null,30.3,29.7,null,{"$f":"AVERAGE($F$4:J$8)","v":{"$error":"#DIV/0!"}}]
[null,4,1000.1,null,null,null,null,null,null,null,null,null,null,30.3,29.7,null,{"$f":"AVERAGE($F$4:J$8)","v":{"$error":"#DIV/0!"}}]
[null,5,1001.5,null,null,null,null,null,null,null,null,null,null,30.3,29.7,null,{"$f":"AVERAGE($F$4:J$8)","v":{"$error":"#DIV/0!"}}]
[null,6,1000.5]
[null,7,1001.3]
[null,8,1001.9,null,null,null,null,null,null,null,null,null,null,"S","Dynamische OG","Dynamische UG"]
[null,9,1001.8,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(((C4-Q4)^2+(C5-Q4)^2+(C6-Q4)^2+(C7-Q4)^2+(C8-Q4)^2+(D4-Q4)^2+(D5-Q4)^2+(D6-Q4)^2+(D7-Q4)^2+(D8-Q4)^2+(E4-Q4)^2+(E5-Q4)^2+(E6-Q4)^2+(E7-Q4)^2+(E8-Q4)^2)/14)","v":{"$error":"#DIV/0!"}},{"$f":"M4+N12","v":{"$error":"#DIV/0!"}},{"$f":"M4-N12","v":{"$error":"#DIV/0!"}}]
[null,10,1002.2]
[null,"MW",{"$f":"AVERAGE(C4:C13)","v":1001},"Mittelwert",null,null,null,null,null,null,null,null,null,0,49.8]
[null,"STA",{"$f":"STDEVP(C4:C13)","v":0.80374125189640089},"Standardabweichung",null,null,null,null,null,null,null,null,null,1,49.8]
[null,"Soll",1000,"Zielwert",null,null,null,null,null,null,null,null,null,"S Messschraube","Obere Spec","Untere Spec","Mittelwert","Dynamisch UG","Dynamisch OG","Dynamisch UG","Dynamisch OG","MW+3Sigma","MW-3Sigma"]
[null,"Spec",3,"Toleranz",null,null,null,null,null,null,null,null,null,{"$f":"SQRT(((C4-Q17)^2+(C5-Q17)^2+(C6-Q17)^2+(C7-Q17)^2+(C8-Q17)^2+(C9-Q17)^2+(C10-Q17)^2+(C11-Q17)^2+(C12-Q17)^2+(C13-Q17)^2)/10)","v":0.80374125189640089},{"$f":"$C$16+$C$17","v":1003},{"$f":"$C$16-$C$17","v":997},{"$f":"$C$14","v":1001},{"$f":"Q17-(1*($N$17))","v":1000.1962587481036},{"$f":"Q17+(1*($N$17))","v":1001.8037412518964},{"$f":"Q17-(2*($N$17))","v":999.39251749620723},{"$f":"Q17+(2*($N$17))","v":1002.6074825037928},{"$f":"Q17-(3*($N$17))","v":998.58877624431079},{"$f":"Q17+(3*($N$17))","v":1003.4112237556892}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$16+$C$17","v":1003},{"$f":"$C$16-$C$17","v":997},{"$f":"$C$14","v":1001},{"$f":"Q18-(1*($N$17))","v":1000.1962587481036},{"$f":"Q18+(1*($N$17))","v":1001.8037412518964},{"$f":"Q18-(2*($N$17))","v":999.39251749620723},{"$f":"Q18+(2*($N$17))","v":1002.6074825037928},{"$f":"Q18-(3*($N$17))","v":998.58877624431079},{"$f":"Q18+(3*($N$17))","v":1003.4112237556892}]
[null,"Cp",{"$f":"2*C17/(2*3*C15)","v":1.2441815044836049},"Prozesspotential",null,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,"Cpo",{"$f":"((C16+C17)-C14)/(3*C15)","v":0.82945433632240329},null,null,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,"Cpu",{"$f":"(-(C16-C17)+C14)/(3*C15)","v":1.6589086726448066},null,null,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,"Cpk",{"$f":"MIN(C20:C21)","v":0.82945433632240329},"Prozessfähigkeit",null,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,1,30.04,30.04,30.001000000000001,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,2,30.12,30.12,30.07,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,3,29.98,29.98,29.94,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,4,30.09,30.09,30.07,null,null,null,null,null,null,null,null,null,1003,997,1001,1000.1962587481036,1001.8037412518964,999.39251749620723,1002.6074825037928,998.58877624431079,1003.4112237556892]
[null,5,30.11,30.21,30.07]
[null,6,30.044,30.044,30.02]
[null,7,29.972999999999999,29.943000000000001,29.933]
[null,8,30.042000000000002,30.042000000000002,30.042000000000002]
[null,9,30.064,30.064,30.013999999999999]
[null,10,29.977,29.949000000000002,29.957000000000001]
[null,11,29.998000000000001,29.948,29.957999999999998]
[null,12,30.047000000000001,30.047000000000001,30.027000000000001]
[null,13,30.146000000000001,30.245999999999999,30.100999999999999]
[null,14,30.088000000000001,30.12,30.038]
[null,15,30.023,30.053000000000001,30.003]
[null,16,29.94445,29.648,29.902450000000002]
[null,17,30.050999999999998,30.050999999999998,30.030999999999999]
[null,18,30.140999999999998,30.140999999999998,30.100999999999999]
[null,19,30.07,30.07,30.03]
[null,20,30.039000000000001,30.039000000000001,29.99]
[null,"MW",{"$f":"AVERAGE(C24:C43)","v":30.049372500000004},{"$f":"AVERAGE(D24:D43)","v":30.042250000000003},{"$f":"AVERAGE(E24:E43)","v":30.014922499999994}]
[null,"STA",{"$f":"STDEVP(C24:C43)","v":5.508717063663731E-2},{"$f":"STDEVP(D24:D43)","v":0.1187412628364713},{"$f":"STDEVP(E24:E43)","v":5.4023320138158609E-2}]
[null,"Soll",30,30,30]
[null,"Spec",0.3,0.3,0.3]
[]
[null,"Cp",{"$f":"2*C47/(2*3*C45)","v":1.8153047042407386},{"$f":"2*D47/(2*3*D45)","v":0.8421672265497},{"$f":"2*E47/(2*3*E45)","v":1.8510524666803365}]
[null,"Cpo",{"$f":"((C46+C47)-C44)/(3*C45)","v":1.516550932540299},{"$f":"((D46+D47)-D44)/(3*D45)","v":0.7235620088106115},{"$f":"((E46+E47)-E44)/(3*E45)","v":1.7589780319002553}]
[null,"Cpu",{"$f":"(-(C46-C47)+C44)/(3*C45)","v":2.1140584759411873},{"$f":"(-(D46-D47)+D44)/(3*D45)","v":0.9607724442887926},{"$f":"(-(E46-E47)+E44)/(3*E45)","v":1.9431269014604269}]
[null,"Cpk",{"$f":"MIN(C50:C51)","v":1.516550932540299},{"$f":"MIN(D50:D51)","v":0.7235620088106115},{"$f":"MIN(E50:E51)","v":1.7589780319002553}]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"C60/10","v":-0.8},{"$f":"E60-D60","v":-8},100,92,{"$f":"E60+1005","v":1097},{"$f":"1001+B60","v":1000.2}]
[null,{"$f":"C61/10","v":-1.2},{"$f":"E61-D61","v":-12},100,88,{"$f":"E61+1005","v":1093},{"$f":"1001+B61","v":999.8}]
[null,-0.3,-3,100,97,1102,1000.7]
[null,-0.9,-9,100,91,1096,1000.1]
[null,0.5,5,100,105,1110,1001.5]
[null,-0.5,-5,100,95,1100,1000.5]
[null,0.3,3,100,103,1108,1001.3]
[null,0.9,9,100,109,1114,1001.9]
[null,0.8,8,100,108,1113,1001.8]
[null,1.2,12,100,112,1117,1002.2]

{"sheet":"Tabelle","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Stichprobe","Messwert \n[mm]","Sollwert [mm]","Toleranz [mm]","Abweichung des \nMesswertes \nvom Sollwert [mm]"]
[null,null,null,1,1000.2,1000.2,2]
[null,null,null,2,999.8,null,2]
[null,null,null,3,1000.7,null,2]
[null,null,null,4,1000.1,null,2]
[null,null,null,5,1001.5,null,2]
[null,null,null,6,1000.5,null,2]
[null,null,null,7,1001.3,null,2]
[null,null,null,8,1001.9,null,2]
[null,null,null,9,1001.8,null,2]
[null,null,null,10,1002.2,null,2]