{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Fehlersammelliste","Berechnung","Pareto-Diagramm"],"not_rendered":{"charts":2,"images":9,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Pareto-Diagramm","index":2,"reason":"not_a_worksheet"}],"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":"Fehlersammelliste","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Pareto-Diagramm",null,null,null,"www.emilQ.com"]
[]
[]
[]
["Fehlerart","absolute Häufigkeit"]
[]
[]
["Sonstige"]
["Gesamt",{"$f":"SUM(B7:B9)","v":0}]

{"sheet":"Berechnung","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,null,"kumulierte Häufigkeiten in %","Fehlerindikatoren"]
["Fehlerart","absolute Häufigkeiten",{"$f":"#N/A","v":{"$error":"#N/A"}},{"$f":"#N/A","v":{"$error":"#N/A"}},{"$f":"#N/A","v":{"$error":"#N/A"}},"Summe abs. Häufigkeiten",{"$f":"SUM(B3:B5)","v":{"$error":"#NUM!"}}]
[{"$f":"INDEX(Fehlerart,MATCH(Berechnung!B3,absH,0))","v":{"$error":"#NUM!"}},{"$f":"LARGE(absH,ROW(Fehlersammelliste!A6))","v":{"$error":"#NUM!"}},{"$f":"SUM($B$3:B3)/$B$6*100","v":{"$error":"#NUM!"}},{"$f":"100-C3","v":{"$error":"#NUM!"}},{"$f":"0","v":0}]
[{"$f":"INDEX(Fehlerart,MATCH(Berechnung!B4,absH,0))","v":{"$error":"#NUM!"}},{"$f":"LARGE(absH,ROW(Fehlersammelliste!A7))","v":{"$error":"#NUM!"}},{"$f":"SUM($B$3:B4)/$B$6*100","v":{"$error":"#NUM!"}},{"$f":"100-C4","v":{"$error":"#NUM!"}},{"$f":"C3","v":{"$error":"#NUM!"}}]
[{"$f":"Fehlersammelliste!A9","v":"Sonstige"},{"$f":"Fehlersammelliste!B9","v":0},{"$f":"SUM($B$3:B5)/$B$6*100","v":{"$error":"#NUM!"}},{"$f":"100-C5","v":{"$error":"#NUM!"}},{"$f":"C4","v":{"$error":"#NUM!"}}]
["Summe",{"$f":"SUM(B3:B5)","v":{"$error":"#NUM!"}}]