{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Forecast","Pivot","Administration"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":104,"comments":0,"pivot_tables":1},"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":"Forecast","index":0,"n_rows":38,"n_cols":97,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["Material Pl.E.","Bezeichnung","Version","Hier. Forecast","Superhierarchie","Aggr.Ebene 1","Aggr.Ebene 2","Bez. Aggr. 1","Langtext","Bez. Aggr. 2","Versionstyp","Ad-hoc Wert","Adhoc char","Adhoc Text 1","Adhoc Text 2","Adhoc Menge 1","Adhoc Menge 2","Adhoc Wert 1","Adhoc Wert 2","Adhoc Datum 1","Adhoc Datum 2","Periode","03.2020","04.2020","05.2020","06.2020","07.2020","08.2020","09.2020","10.2020","11.2020","12.2020","01.2021","02.2021","03.2021","04.2021","05.2021","06.2021","07.2021","08.2021","09.2021","10.2021","11.2021","12.2021","01.2022","02.2022","03.2022","04.2022","05.2022","06.2022","07.2022","08.2022","09.2022","10.2022","11.2022","12.2022","01.2023","02.2023","03.2023","04.2023","05.2023","06.2023","07.2023","08.2023","09.2023","10.2023","11.2023","12.2023","01.2024","02.2024","03.2024","04.2024","05.2024","06.2024","07.2024","08.2024","09.2024","10.2024","11.2024","12.2024","01.2025","02.2025","1. Stufe Produkthie.","2. Stufe Produkthie.","3. Stufe Produkthie.","Ø 3 Monate","Ø 6 Monate","Ø 12 Monate","Profitcenter","∑12 nächst. Monate","Budget akt. Jahr","Σ24 Rück. K.-Auftr.","Variante","Disponent","Menge/HU","Menge/HU_1","Menge/HU_2"]
["000000000000000058","","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000058","","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000058","","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000059","","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000059","","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000059","","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000078","","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000078","","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["000000000000000078","","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300015-OR","Lampe Orange","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300015-OR","Lampe Orange","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300015-OR","Lampe Orange","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,550,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,200,0,250,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300015-RO","Lampe Rot","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300015-RO","Lampe Rot","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,240,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300015-RO","Lampe Rot","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,267,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9,6,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300016-00","StangeGrau3","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300016-00","StangeGrau3","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300016-00","StangeGrau3","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,380,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,380,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300017-00","WinkelSchwarz135Grad","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300017-00","WinkelSchwarz135Grad","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300017-00","WinkelSchwarz135Grad","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300027-00","Motorhaube","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300027-00","Motorhaube","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300027-00","Motorhaube","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,-1.4999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1.4999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300028-00","Bumper","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300028-00","Bumper","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["300028-00","Bumper","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE100","RBE100 Test","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,78000,0,0,0,0,0,0,0,0,0,1000,1000,10000,1000,1000,10000,1000,1000,10000,1000,1000,1000,10000,1000,1000,1000,1000,10000,1000,1000,1000,10000,1000,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE100","RBE100 Test","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,28889,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3705,4470,3477,2983,4737,2842,3023,3652,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE100","RBE100 Test","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,14552.26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,0,456,200,0,764.71,1502.14,11529.41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE103","RBE103 Test","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,24000,0,0,0,0,0,0,0,0,0,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE103","RBE103 Test","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE103","RBE103 Test","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,1168.077,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,235.29400000000001,462.19499999999999,470.58800000000002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE107","RBE107 Test","AB0","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,2528.4969999999998,0,100,100,100,100,100,644.25300000000004,684.24400000000003,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,10,50,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE107","RBE107 Test","PRO","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22,33,44,"","","",0,0,0,"",0,0,0,"0","",0,0,0]
["RBE107","RBE107 Test","MAN","100740","0","","","","","","X",0,"","","",0,0,0,0,null,null,15000185.6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,62.533000000000001,125.06699999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12,22,22,"","","",0,0,0,"",0,0,0,"0","",0,0,0]

{"sheet":"Pivot","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Version"]
["Werte","AB0","MAN","PRO","Gesamtergebnis"]
["Summe von 01.2024",0,14,12,26]
["Summe von 02.2024",0,14,12,26]
["Summe von 03.2024",0,14,12,26]
["Summe von 04.2024",0,14,12,26]
["Summe von 05.2024",0,14,12,26]
["Summe von 06.2024",0,14,12,26]
["Summe von 07.2024",0,14,12,26]
["Summe von 08.2024",0,14,12,26]
["Summe von 09.2024",0,14,12,26]
["Summe von 10.2024",0,14,12,26]
["Summe von 11.2024",0,14,12,26]
["Summe von 12.2024",10,26,34,70]
["Summe von 01.2025",10,36,45,91]
["Summe von 02.2025",50,36,56,142]

{"sheet":"Administration","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Dezentraler Planungsprozess"]
["Für die rollierende Planungserfassung außerhalb des SAP Systems dient diese Excel Vorlage. So können auch Mitarbeiter ohne SAP Zugang aktiv am Planungsprozess eingebunden werden."]
[]
["Einrichtung SAP"]
["Zur Bereitstellung und Import der Daten, können die gewünschten Planungsinformationen über Transaktion /GIB/DCF_APF generiert werden."]
["Erstellen Sie eine Variante mit Planungshierarchie, -szenario und den relevanten Versionen für den Datenexport sowie eine für den Import und planen diese rollierend ein. "]
["Die Pfade für die Dateiablage können in Transaktion AL11 administriert werden."]
[]
["Einrichtung Excel"]
["Als initialer Einrichtungsschritt erfolgen die Verbindungen zu den rollierend aktualisierten Datenquellen. ",null,null,null,null,null,null,null,null,null,null,null,"Datenverbindungen"]
["Für den Import aus SAP unter \"Dateipfad Import\" den Dateifpfad festlegen.",null,null,null,null,null,null,null,null,null,null,"Dateipfad Import","Dateipfad hier eingeben \\\\server\\share\\folder\\file.xlsx"]
["Für den Transfer ins  SAP System den \"Dateipfad Export\" festlegen.",null,null,null,null,null,null,null,null,null,null,"Dateipfad Export","Dateipfad hier eingeben \\\\server\\share\\folder\\file.xlsx"]
[]
["Der Datenimport us SAP wird mit der Schaltfläche Planung initialisieren gestartet."]
["Alle bereits durchgeführten Änderungen im lokalen Sheet werden damit überschrieben."]
[]
["Nach Beendigung der dezentralen Planung, können die Planungsergebnisse über \"Planung exportieren\""]
["im Austauschpfad bereitgestellt und anschließend im SAP System importiert werden, die Option ist auch im Schnellzugriff hinterlegt."]
[]
["Datenänderungen wie ein Import oder manuelle Eingaben können mit der Option \"Datenmodell aktualisieren\" allen Pivot-Tabellen des Sheets "]
["bekannt gemacht werden. Die Option ist auch im Schnellzugriff hinterlegt."]