{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Umsatzplanung","Umsatzszenario"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":9,"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":"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",2]
[null,"Thema","Aufgaben und Ziele"]
[]
[null,"Inhalt","Trendberechnungen"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","2.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Umsatzplanung","index":1,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,7,0,12]]}
[null,"Realisierte Umsätze",null,null,null,null,null,"Erwartete Umsätze"]
["Monat ","Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez"]
["Produkt A",2319.96,2765,2346.145,2910.66,2833.56,2918.51,3058.6003333333301,3166.1130476190501,3273.6257619047601,3381.1384761904801,3488.6511904761901,3596.1639047619101]
["Produkt B",1874.3510000000001,2098.732,1984.2339999999999,1389.0630000000001,2408.5630000000001,2397.8670000000002,2320.6585333333301,2404.9985904761902,2489.3386476190499,2573.67870476191,2658.0187619047601,2742.3588190476198]

{"sheet":"Umsatzszenario","index":2,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,7,0,12],[2,0,3,0],[4,0,5,0]]}
[null,"Realisierte Umsätze",null,null,null,null,null,"Erwartete Umsätze"]
["Monat ",1,2,3,4,5,6,7,8,9,10,11,12]
["Produkt A",2319.96,2765,2346.145,2910.66,2833.56,2918.51]
[null,null,null,null,null,null,2918.51,{"$f":"TREND(ProduktA,Halbjahr1,H2)","v":3058.6003333333333},3166.1130476190474,3273.6257619047619,3381.1384761904765,3488.6511904761905,3596.1639047619051]
["Produkt B",1874.3510000000001,2098.732,1984.2339999999999,1389.0630000000001,2408.5630000000001,2397.8670000000002]
["Planung B",null,null,null,null,null,2397.8670000000002,{"$f":"TREND(ProduktB,Halbjahr1,H2)","v":2320.6585333333333},2404.9985904761907,2489.3386476190481,2573.678704761905,2658.018761904762,2742.3588190476194]
["Produkt A",null,null,null,null,null,null,200,350,50,-200,-250,-150]
["Produkt B",null,null,null,null,null,null,-200,-300,-150,100,250,300]