{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","DuPont-Schema"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"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","Strategisches Prozess-Controlling"]
[]
[null,"Inhalt","DuPont ROI"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"DuPont-Schema","index":1,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Umsatz",980000]
[]
["Herstellkosten",123900,null,null,"-","=","Gewinn",{"$f":"E2-E6","v":675600}]
[null,"+"]
["Vertriebskosten",56900,"=","Selbstkosten",{"$f":"B4+B6+B8","v":304400},null,null,":","=","Umsatz-",{"$f":"IF(H8<>0,H4/H8,0)","v":0.68938775510204087}]
[null,"+",null,null,null,null,null,null,null,"Rentabilität"]
["Verwaltungskosten",123600,null,null,null,null,"Umsatz",{"$f":"E2","v":980000}]
[null,null,null,null,null,null,null,null,null,null,"x","=","ROI",{"$f":"K6*K12","v":0.38917050691244248}]
["Immaterielles Vermögen",320000]
[null,"+"]
["Sachanlagen",200000,"=","Anlagevermögen",{"$f":"B10+B12+B14","v":700000},null,null,":","=","Kapital-",{"$f":"IF(H15<>0,H8/H15,0)","v":0.56451612903225812}]
[null,"+",null,null,null,null,null,null,null,"umschlag"]
["Finanzanlagen",180000]
[null,null,null,null,"+","=","Investiertes",{"$f":"E12+E18","v":1736000}]
["Vorräte",680000,null,null,null,null,"Kapital"]
[null,"+"]
["Forderungen",206000,"=","Umlaufvermögen",{"$f":"B16+B18+B20","v":1036000}]
[null,"+"]
["liquide Mittel",150000]