{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Jahresumsatz","ABC-Anteile","ABC-Analyse"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":7,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",8]
[null,"Thema","Operatives Prozess-Controlling"]
[]
[null,"Inhalt","ABC-Analyse"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-08-04"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Jahresumsatz","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Produkte","Stückzahl","Umsatz"]
["Besucherstühle",9674,2370130]
["Bürostühle",3053,1557030]
["Stehhilfen",3468,624240]
["Schreibtische",1215,3110400]
["Stehpulte",640,403200]
["PC-Tische",4350,1522500]
["Kombi-Tische",1045,564300]
["Aktenschränke",2750,5170000]
["Container",3370,2662300]
["Sideboards",5127,4768110]
["Aktenregale",4720,4484000]
["Garderoben",1985,3037050]
["Empfangstheken",1115,4727600]

{"sheet":"ABC-Anteile","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Anteil","kumuliert","Klasse"]
[0,0,"A"]
[0.75,{"$f":"B2+A3","v":0.75},"B"]
[0.2,{"$f":"B3+A4","v":0.95},"C"]
[0.05,1]

{"sheet":"ABC-Analyse","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Produkte","Stückzahl","Umsatz","Rang","Anteil [%]","kumuliert [%]","Klasse"]
["Aktenschränke",2750,5170000,1,0.14771065625244637,0.14771065625244637,"A"]
["Sideboards",5127,4768110,2,0.13622836696012613,0.28393902321257247,"A"]
["Empfangstheken",1115,4727600,3,0.13507096682767222,0.4190099900402447,"A"]
["Aktenregale",4720,4484000,4,0.12811113784061307,0.54712112788085776,"A"]
["Schreibtische",1215,3110400,5,8.8866387854469861E-2,0.63598751573532764,"A"]
["Garderoben",1985,3037050,6,8.6770725062184181E-2,0.72275824079751183,"A"]
["Container",3370,2662300,7,7.6063845288372914E-2,0.79882208608588479,"B"]
["Besucherstühle",9674,2370130,8,6.7716336112884079E-2,0.86653842219876887,"B"]
["Bürostühle",3053,1557030,9,4.4485478356817515E-2,0.91102390055558635,"B"]
["PC-Tische",4350,1522500,10,4.3498931169119848E-2,0.9545228317247062,"C"]
["Stehhilfen",3468,624240,11,1.7834990340237354E-2,0.97235782206494359,"C"]
["Kombi-Tische",1045,564300,12,1.6122460990958508E-2,0.98848028305590208,"C"]
["Stehpulte",640,403200,13,1.1519716944097945E-2,1,"C"]