{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":1,"images":2,"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":"Tabelle1","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,3,5,7]]}
[]
[null,"Lagerkennziffern",null,null,null,null,"Kalenderjahr",2017]
[]
[null,"Lagerkosten je Stück in €",15]
[null,"Stückpreis in €",4]
[null,"Marktzinssatz in %",6]
[]
[null,"Jahresanfangsbestand",50,"Stück",{"$f":"Tabelle2!H6","v":200},"€","Umschlagshäufigkeit",{"$f":"Tabelle2!E27","v":13}]
[null,"Jahresendbestand",{"$f":"Tabelle2!E19","v":40},"Stück",{"$f":"Tabelle2!H19","v":160},"€","durchschnittliche Lagerdauer",{"$f":"Tabelle2!E28","v":27.692307692307693}]
[null,"Wareneinsatz",{"$f":"Tabelle2!E26","v":400},"Stück",{"$f":"Tabelle2!F26","v":1600},"€","Lagerzinssatz",{"$f":"Tabelle2!E29","v":0.46153846153846156}]
[null,"durchschnittlicher Lagerbestand",{"$f":"Tabelle2!E25","v":30.76923076923077},"Stück",{"$f":"Tabelle2!F25","v":123.07692307692308},"€","Lagerzinsen",{"$f":"Tabelle2!F31","v":56.804733727810657}]
[null,"durchschnittliche Lagerkosten",null,null,{"$f":"Tabelle2!F32","v":461.53846153846155},"€","durchschnittliche Kapitalbindung",{"$f":"Tabelle2!F30","v":123.07692307692308}]

{"sheet":"Tabelle2","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,2,3,4],[3,5,3,7],[20,5,22,7]]}
[]
[null,"Berechnungen"]
[]
[null,null,"Mengen",null,null,"Werte"]
[null,null,"Zugänge","Abgänge","Bestand","Zugänge","Abgänge","Bestand"]
[null,"Anfangsbestand",null,null,{"$f":"Tabelle1!C8","v":50},null,null,{"$f":"E6*$E$21","v":200}]
[null,"Monate"]
[null,"Januar",30,40,{"$f":"E6+C8-D8","v":40},{"$f":"C8*$E$21","v":120},{"$f":"D8*$E$21","v":160},{"$f":"H6+F8-G8","v":160}]
[null,"Februar",30,50,{"$f":"E8+C9-D9","v":20},120,200,{"$f":"H8+F9-G9","v":80}]
[null,"März",20,10,{"$f":"E9+C10-D10","v":30},80,40,{"$f":"H9+F10-G10","v":120}]
[null,"April",30,40,20,120,160,80]
[null,"Mai",60,50,30,240,200,120]
[null,"Juni",20,10,40,80,40,160]
[null,"Juli",30,40,30,120,160,120]
[null,"August",40,50,20,160,200,80]
[null,"September",20,10,30,80,40,120]
[null,"Oktober",30,40,20,120,160,80]
[null,"November",60,50,30,240,200,120]
[null,"Dezember",20,10,40,80,40,160]
[]
[null,"Preis in €",null,null,{"$f":"Tabelle1!C5","v":4}]
[null,"Lagerkosten je Stück in €",null,null,{"$f":"Tabelle1!C4","v":15}]
[null,"Marktzinssatz in %",null,null,{"$f":"Tabelle1!C6","v":6}]
[]
[null,"Durchschnittlicher Lagerbestand",null,"Stück",{"$f":"SUM(E6:E19)/13","v":30.76923076923077},{"$f":"SUM(H6:H19)/13","v":123.07692307692308},"€"]
[null,"Wareneinsatz",null,"Stück",{"$f":"E6+SUM(C8:C19)-E19","v":400},{"$f":"H6+SUM(F8:F19)-H19","v":1600},"€"]
[null,"Umschlagshäufigkeit",null,null,{"$f":"E26/E25","v":13}]
[null,"Durchschnittliche Lagerdauer",null,"Tage",{"$f":"360/E27","v":27.692307692307693}]
[null,"Lagerzinssatz",null,null,{"$f":"E28*E23/360","v":0.46153846153846156}]
[null,"durchschnittliche Kapitalbindung",null,null,null,{"$f":"E25*E21","v":123.07692307692308},"€"]
[null,"Lagerzinsen",null,null,null,{"$f":"F30*E29","v":56.804733727810657},"€"]
[null,"durchschnittliche Lagerkosten",null,null,null,{"$f":"E25*E22","v":461.53846153846155},"€"]

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}