{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Materialbedarf","Bestellauswertung","Kostenübersicht","Bestellübersicht"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":14,"comments":0,"pivot_tables":2},"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",9]
[null,"Thema","Operatives Prozess-Controlling"]
[]
[null,"Inhalt","Materialbedarf"]
[null,null,"Auswertung aus der Bedarfsplanung"]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Materialbedarf","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["AufNr","ProNr","Anzahl","Produktion","MatNr","Menge","Einheit","Bezeichnung","Preis","Liefertage"]
["A08","P01",2.4,"2019-04-05","M01",12,"kg","Material A",0.2311,14]
["A05","P01",8.1999999999999993,"2019-03-06","M01",12,"kg","Material A",0.2311,14]
["A01","P01",12,"2019-03-01","M01",12,"kg","Material A",0.2311,14]
["A08","P01",2.4,"2019-04-05","M02",4.5,"kg","Material B",0.214,14]
["A05","P01",8.1999999999999993,"2019-03-06","M02",4.5,"kg","Material B",0.214,14]
["A01","P01",12,"2019-03-01","M02",4.5,"kg","Material B",0.214,14]
["A04","P02",3.4,"2019-02-25","M03",3.4,"kg","Material C",8.2000000000000003E-2,7]
["A03","P03",1.8,"2019-04-12","M04",6.2,"kg","Material D",5.6000000000000001E-2,21]
["A07","P03",1.89,"2019-03-24","M04",6.2,"kg","Material D",5.6000000000000001E-2,21]
["A06","P04",6.2,"2019-05-22","M05",1.89,"kg","Material E",0.45100000000000001,21]
["A02","P04",4.5,"2019-05-01","M05",1.89,"kg","Material E",0.45100000000000001,21]
["A04","P02",3.4,"2019-02-25","M06",8.1999999999999993,"kg","Material F",0.35639999999999999,14]
["A06","P04",6.2,"2019-05-22","M07",1.45,"kg","Material G",0.22120000000000001,30]
["A02","P04",4.5,"2019-05-01","M07",1.45,"kg","Material G",0.22120000000000001,30]
["A05","P01",8.1999999999999993,"2019-03-06","M08",1.8,"m","Material H",3.45,7]
["A01","P01",12,"2019-03-01","M08",1.8,"m","Material H",3.45,7]
["A08","P01",2.4,"2019-04-05","M08",1.8,"m","Material H",3.45,7]
["A02","P04",4.5,"2019-05-01","M10",2.4,"m","Material J",3.1869000000000001,30]
["A06","P04",6.2,"2019-05-22","M10",2.4,"m","Material J",3.1869000000000001,30]

{"sheet":"Bestellauswertung","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["MatNr","Bezeichnung","Auftragsmenge","Materialkosten","Bestellung"]
[{"$f":"MatNr","v":"M01"},{"$f":"Bezeichnung","v":"Material A"},{"$f":"Anzahl*Menge","v":28.799999999999997},{"$f":"Auftragsmenge*Preis","v":6.6556799999999994},{"$f":"Produktion-Liefertage","v":"2019-03-22"}]
["M01","Material A",98.399999999999991,22.740239999999996,"2019-02-20"]
["M01","Material A",144,33.278399999999998,"2019-02-15"]
["M02","Material B",10.799999999999999,2.3111999999999999,"2019-03-22"]
["M02","Material B",36.9,7.8965999999999994,"2019-02-20"]
["M02","Material B",54,11.555999999999999,"2019-02-15"]
["M03","Material C",11.559999999999999,0.94791999999999998,"2019-02-18"]
["M04","Material D",11.16,0.62496000000000007,"2019-03-22"]
["M04","Material D",11.718,0.65620800000000001,"2019-03-03"]
["M05","Material E",11.718,5.2848180000000005,"2019-05-01"]
["M05","Material E",8.504999999999999,3.8357549999999998,"2019-04-10"]
["M06","Material F",27.879999999999995,9.9364319999999982,"2019-02-11"]
["M07","Material G",8.99,1.988588,"2019-04-22"]
["M07","Material G",6.5249999999999995,1.44333,"2019-04-01"]
["M08","Material H",14.76,50.922000000000004,"2019-02-27"]
["M08","Material H",21.6,74.52000000000001,"2019-02-22"]
["M08","Material H",4.32,14.904000000000002,"2019-03-29"]
["M10","Material J",10.799999999999999,34.418519999999994,"2019-04-01"]
["M10","Material J",14.879999999999999,47.421071999999995,"2019-04-22"]
[null,null,"Summe",{"$f":"SUM(D2:D20)","v":331.34172299999994}]

{"sheet":"Kostenübersicht","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Werte"]
["Bezeichnung","Gesamtmenge","Gesamtkosten"]
["Material A",271.2,62.674319999999994]
["Material B",101.69999999999999,21.763799999999996]
["Material C",11.559999999999999,0.94791999999999998]
["Material D",22.878,1.2811680000000001]
["Material E",20.222999999999999,9.1205730000000003]
["Material F",27.879999999999995,9.9364319999999982]
["Material G",15.515000000000001,3.431918]
["Material H",40.68,140.346]
["Material J",25.68,81.839591999999982]
["Gesamtergebnis",537.31599999999992,331.341723]

{"sheet":"Bestellübersicht","index":4,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Bestellmenge",null,"MatNr"]
["Bestellgruppe","Bestellung","M01","M02","M03","M04","M05","M06","M07","M08","M10","Gesamtergebnis"]
["Gruppe1","2019-02-11",null,null,null,null,null,27.879999999999995,null,null,null,27.879999999999995]
[null,"2019-02-15",144,54,null,null,null,null,null,null,null,198]
[null,"2019-02-18",null,null,11.559999999999999,null,null,null,null,null,null,11.559999999999999]
["Gruppe1 Ergebnis",null,144,54,11.559999999999999,null,null,27.879999999999995,null,null,null,237.44]
["Gruppe2","2019-02-20",98.399999999999991,36.9,null,null,null,null,null,null,null,135.29999999999998]
[null,"2019-02-22",null,null,null,null,null,null,null,21.6,null,21.6]
[null,"2019-02-27",null,null,null,null,null,null,null,14.76,null,14.76]
[null,"2019-03-03",null,null,null,11.718,null,null,null,null,null,11.718]
["Gruppe2 Ergebnis",null,98.399999999999991,36.9,null,11.718,null,null,null,36.36,null,183.37799999999996]
["Gruppe3","2019-03-22",28.799999999999997,10.799999999999999,null,11.16,null,null,null,null,null,50.759999999999991]
[null,"2019-03-29",null,null,null,null,null,null,null,4.32,null,4.32]
[null,"2019-04-01",null,null,null,null,null,null,6.5249999999999995,null,10.799999999999999,17.324999999999999]
[null,"2019-04-10",null,null,null,null,8.504999999999999,null,null,null,null,8.504999999999999]
[null,"2019-04-22",null,null,null,null,null,null,8.99,null,14.879999999999999,23.869999999999997]
[null,"2019-05-01",null,null,null,null,11.718,null,null,null,null,11.718]
["Gruppe3 Ergebnis",null,28.799999999999997,10.799999999999999,null,11.16,20.222999999999999,null,15.515000000000001,4.32,25.68,116.49799999999998]
["Gesamtergebnis",null,271.2,101.7,11.559999999999999,22.878,20.222999999999999,27.879999999999995,15.515000000000001,40.68,25.68,537.31599999999992]