{"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":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,3],[6,1,6,3],[1,10,1,12],[4,5,10,8]]}
[]
[null,"Eingabewerte",null,null,null,null,null,null,null,null,"Monatsplanung"]
[null,"Tagesverbrauch ",200,"Liter",null,null,null,null,null,null,"Tag","Bestand","Ereignis"]
[null,"Lieferzeit ",4,"Tage",null,null,null,null,null,null,0,{"$f":"Tabelle2!C5","v":2000},{"$f":"IF(Tabelle2!C5=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C5=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,"Vorratsdauer",8,{"$f":"D4","v":"Tage"},null,"Nach Klick auf \"Eingabe\" können der Tagesverbrauch sowie Lieferzeit, Vorratsdauer und Mindestreservezeit als Planungskonstanten eingegeben werden. Die Modellvariablen werden automatisch berechnet. Die Tabelle \"Monatsplanung\" zeigt den geplanten Lagerbestand sowie die Reihenfolge der Bestellungen und Lieferungen. Die Plangröße \"Vorratsdauer\" schließt die Mindestreservezeit nicht ein. Nach Klick auf \"Tabelle\" werden die Daten der Grafik angezeigt.",null,null,null,null,1,{"$f":"Tabelle2!C6","v":1800},{"$f":"IF(Tabelle2!C6=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C6=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,"Mindestreservezeit",2,{"$f":"D4","v":"Tage"},null,null,null,null,null,null,2,{"$f":"Tabelle2!C7","v":1600},{"$f":"IF(Tabelle2!C7=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C7=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,"Berechnungen",null,null,null,null,null,null,null,null,3,{"$f":"Tabelle2!C8","v":1400},{"$f":"IF(Tabelle2!C8=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C8=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,"Höchstbestand",{"$f":"(C3*C5)+(C3*C6)","v":2000},{"$f":"$D$3","v":"Liter"},null,null,null,null,null,null,4,{"$f":"Tabelle2!C9","v":1200},{"$f":"IF(Tabelle2!C9=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C9=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Bestellung"}]
[null,"Mindestbestand",{"$f":"C3*C6","v":400},{"$f":"$D$3","v":"Liter"},null,null,null,null,null,null,5,{"$f":"Tabelle2!C10","v":1000},{"$f":"IF(Tabelle2!C10=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C10=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,"Bestellmenge",{"$f":"(C8-C9)+C3","v":1800},{"$f":"$D$3","v":"Liter"},null,null,null,null,null,null,6,{"$f":"Tabelle2!C11","v":800},{"$f":"IF(Tabelle2!C11=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C11=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,"Meldebestand",{"$f":"(C3*C4)+C9","v":1200},{"$f":"$D$3","v":"Liter"},null,null,null,null,null,null,7,{"$f":"Tabelle2!C12","v":600},{"$f":"IF(Tabelle2!C12=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C12=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,8,{"$f":"Tabelle2!C13","v":400},{"$f":"IF(Tabelle2!C13=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C13=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Lieferung"}]
[null,null,null,null,null,null,null,null,null,null,9,{"$f":"Tabelle2!C14","v":2000},{"$f":"IF(Tabelle2!C14=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C14=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,10,{"$f":"Tabelle2!C15","v":1800},{"$f":"IF(Tabelle2!C15=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C15=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,11,{"$f":"Tabelle2!C16","v":1600},{"$f":"IF(Tabelle2!C16=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C16=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,12,{"$f":"Tabelle2!C17","v":1400},{"$f":"IF(Tabelle2!C17=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C17=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,13,{"$f":"Tabelle2!C18","v":1200},{"$f":"IF(Tabelle2!C18=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C18=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Bestellung"}]
[null,null,null,null,null,null,null,null,null,null,14,{"$f":"Tabelle2!C19","v":1000},{"$f":"IF(Tabelle2!C19=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C19=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,15,{"$f":"Tabelle2!C20","v":800},{"$f":"IF(Tabelle2!C20=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C20=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,16,{"$f":"Tabelle2!C21","v":600},{"$f":"IF(Tabelle2!C21=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C21=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,17,{"$f":"Tabelle2!C22","v":400},{"$f":"IF(Tabelle2!C22=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C22=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Lieferung"}]
[null,null,null,null,null,null,null,null,null,null,18,{"$f":"Tabelle2!C23","v":2000},{"$f":"IF(Tabelle2!C23=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C23=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,19,{"$f":"Tabelle2!C24","v":1800},{"$f":"IF(Tabelle2!C24=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C24=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,20,{"$f":"Tabelle2!C25","v":1600},{"$f":"IF(Tabelle2!C25=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C25=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,21,{"$f":"Tabelle2!C26","v":1400},{"$f":"IF(Tabelle2!C26=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C26=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,22,{"$f":"Tabelle2!C27","v":1200},{"$f":"IF(Tabelle2!C27=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C27=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Bestellung"}]
[null,null,null,null,null,null,null,null,null,null,23,{"$f":"Tabelle2!C28","v":1000},{"$f":"IF(Tabelle2!C28=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C28=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,24,{"$f":"Tabelle2!C29","v":800},{"$f":"IF(Tabelle2!C29=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C29=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,25,{"$f":"Tabelle2!C30","v":600},{"$f":"IF(Tabelle2!C30=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C30=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,26,{"$f":"Tabelle2!C31","v":400},{"$f":"IF(Tabelle2!C31=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C31=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Lieferung"}]
[null,null,null,null,null,null,null,null,null,null,27,{"$f":"Tabelle2!C32","v":2000},{"$f":"IF(Tabelle2!C32=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C32=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,28,{"$f":"Tabelle2!C33","v":1800},{"$f":"IF(Tabelle2!C33=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C33=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,29,{"$f":"Tabelle2!C34","v":1600},{"$f":"IF(Tabelle2!C34=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C34=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"Tabelle2!C35","v":1400},{"$f":"IF(Tabelle2!C35=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C35=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,31,{"$f":"Tabelle2!C36","v":1200},{"$f":"IF(Tabelle2!C36=Tabelle1!$C$11,\"Bestellung\",IF(Tabelle2!C36=Tabelle1!$C$9,\"Lieferung\",\"\"))","v":"Bestellung"}]

{"sheet":"Tabelle2","index":1,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lagerbestandsplanung/Monat"]
[]
[null,"Tage","Lagerbestand","Höchstbestand","Meldebestand","Mindestbestand","Abgang","Zugang"]
[null,0,{"$f":"Tabelle1!C8","v":2000},{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C4=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,1,{"$f":"C5-G6+H6","v":1800},{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C5=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,2,1600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C6=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,3,1400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C7=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,4,1200,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C8=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,5,1000,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C9=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,6,800,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C10=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,7,600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C11=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,8,400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C12=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,9,2000,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C13=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":1800}]
[null,10,1800,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C14=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,11,1600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C15=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,12,1400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C16=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,13,1200,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C17=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,14,1000,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C18=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,15,800,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C19=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,16,600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C20=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,17,400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C21=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,18,2000,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C22=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":1800}]
[null,19,1800,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C23=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,20,1600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C24=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,21,1400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C25=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,22,1200,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C26=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,23,1000,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C27=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,24,800,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C28=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,25,600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C29=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,26,400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C30=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,27,2000,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C31=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":1800}]
[null,28,1800,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C32=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,29,1600,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C33=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,30,1400,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C34=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]
[null,31,1200,{"$f":"Tabelle1!$C$8","v":2000},{"$f":"Tabelle1!$C$11","v":1200},{"$f":"Tabelle1!$C$9","v":400},{"$f":"Tabelle1!$C$3","v":200},{"$f":"IF(C35=Tabelle1!$C$9,Tabelle1!$C$10,0)","v":0}]

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