{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Materialbedarf","Kostenübersicht","Tabelle4","Bestellanalyse"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":4,"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",8]
[null,"Thema","Operatives Prozess-Controlling"]
[]
[null,"Inhalt","Materialbedarf - Zwischenergebnis"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-27"]
[]
[]
[null,"Springer Verlag"]

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

{"sheet":"Kostenübersicht","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Werte"]
["MatName","Gesamtmenge","Gesamrkosten"]
["Material A",271.2,62.674319999999987]
["Material B",101.7,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.34172299999994]

{"sheet":"Tabelle4","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Summen",null,"MatNr"]
["Bestelltermin2","Bestelltermin","M01","M02","M03","M04","M05","M06","M07","M08","M10","Summe"]
["Gruppe1","2022-02-11",null,null,null,null,null,27.879999999999995,null,null,null,27.879999999999995]
[null,"2022-02-15",144,54,null,null,null,null,null,null,null,198]
[null,"2022-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","2022-02-21",98.399999999999991,36.9,null,null,null,null,null,null,null,135.29999999999998]
[null,"2022-02-22",null,null,null,null,null,null,null,21.6,null,21.6]
[null,"2022-02-28",null,null,null,null,null,null,null,14.76,null,14.76]
[null,"2022-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","2022-03-22",28.799999999999997,10.799999999999999,null,11.16,null,null,null,null,null,50.759999999999991]
[null,"2022-03-29",null,null,null,null,null,null,null,4.32,null,4.32]
[null,"2022-04-02",null,null,null,null,null,null,6.5249999999999995,null,10.799999999999999,17.324999999999999]
[null,"2022-04-11",null,null,null,null,8.504999999999999,null,null,null,null,8.504999999999999]
[null,"2022-04-23",null,null,null,null,null,null,8.99,null,14.879999999999999,23.869999999999997]
[null,"2022-05-02",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]
["Summe",null,271.2,101.7,11.559999999999999,22.878,20.222999999999999,27.879999999999995,15.515000000000001,40.68,25.68,537.31599999999992]

{"sheet":"Bestellanalyse","index":4,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["MatNr","MatName","Anzahl","Menge","Summe","Einheit","Preis","Kosten","Bestelltermin",null,"Gesamtkosten"]
[{"$f":"Materialbedarf[MatNr]","v":"M01"},{"$f":"Materialbedarf[MatName]","v":"Material A"},{"$f":"Materialbedarf[Anzahl]","v":12},{"$f":"Materialbedarf[Menge]","v":12},{"$f":"_xlfn.ANCHORARRAY(C2)*_xlfn.ANCHORARRAY(D2)","v":144},{"$f":"Materialbedarf[Einheit]","v":"kg"},{"$f":"Materialbedarf[Preis]","v":0.2311},{"$f":"_xlfn.ANCHORARRAY(E2)*_xlfn.ANCHORARRAY(G2)","v":33.278399999999998},{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-15"},null,{"$f":"SUM(_xlfn.ANCHORARRAY(H2))","v":331.34172299999994}]
["M01","Material A",8.1999999999999993,12,98.399999999999991,"kg",0.2311,22.740239999999996,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-21"}]
["M01","Material A",2.4,12,28.799999999999997,"kg",0.2311,6.6556799999999994,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-03-22"}]
["M02","Material B",12,4.5,54,"kg",0.214,11.555999999999999,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-15"}]
["M02","Material B",8.1999999999999993,4.5,36.9,"kg",0.214,7.8965999999999994,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-21"}]
["M02","Material B",2.4,4.5,10.799999999999999,"kg",0.214,2.3111999999999999,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-03-22"}]
["M08","Material H",12,1.8,21.6,"m ",3.45,74.52000000000001,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-22"}]
["M08","Material H",8.1999999999999993,1.8,14.76,"m ",3.45,50.922000000000004,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-28"}]
["M08","Material H",2.4,1.8,4.32,"m ",3.45,14.904000000000002,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-03-29"}]
["M05","Material E",4.5,1.89,8.504999999999999,"kg",0.45100000000000001,3.8357549999999998,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-04-11"}]
["M10","Material J",4.5,2.4,10.799999999999999,"m",3.1869000000000001,34.418519999999994,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-04-02"}]
["M07","Material G",4.5,1.45,6.5249999999999995,"kg",0.22120000000000001,1.44333,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-04-02"}]
["M05","Material E",6.2,1.89,11.718,"kg",0.45100000000000001,5.2848180000000005,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-05-02"}]
["M10","Material J",6.2,2.4,14.879999999999999,"m",3.1869000000000001,47.421071999999995,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-04-23"}]
["M07","Material G",6.2,1.45,8.99,"kg",0.22120000000000001,1.988588,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-04-23"}]
["M03","Material C",3.4,3.4,11.559999999999999,"kg",8.2000000000000003E-2,0.94791999999999998,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-18"}]
["M06","Material F",3.4,8.1999999999999993,27.879999999999995,"kg",0.35639999999999999,9.9364319999999982,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-02-11"}]
["M04","Material D",1.8,6.2,11.16,"kg",5.6000000000000001E-2,0.62496000000000007,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-03-22"}]
["M04","Material D",1.89,6.2,11.718,"kg",5.6000000000000001E-2,0.65620800000000001,{"$f":"Materialbedarf[[#This Row],[Termin]]-Materialbedarf[[#This Row],[Liefertage]]","v":"2022-03-03"}]