{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Umsatzplanung","Umsatzszenario","Forecast"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":15,"defined_names":58,"comments":1,"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,"Stochastik"]
[]
[]
[null,"Kapitel",6]
[null,"Thema","Beobachtungen und Messungen"]
[]
[null,"Inhalt","Trendbestimmung"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2021-10-15"]
[]
[]
[null,"Springer Vieweg 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":6,"n_cols":13,"rows_kept":6,"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]

{"sheet":"Forecast","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Monat","Plan","Ist","Übertrag","Trend","Variation","Mittelwert"]
["1900-01-01",3450,3340,3340,{"$f":"IF(C2=\"\",TREND($E1:E$2,$A1:A$2,A2),C2)","v":3340},{"$f":"IF(C2=\"\",GROWTH($F1:F$2,$A1:A$2,A2),C2)","v":3340},{"$f":"IF(C2=\"\",AVERAGE($G1:G$2)*(B2/B1),C2)","v":3340}]
["1900-01-02",4680,3850,3850,{"$f":"IF(C3=\"\",TREND($E$2:E2,$A$2:A2,A3),C3)","v":3850},{"$f":"IF(C3=\"\",GROWTH($F$2:F2,$A$2:A2,A3),C3)","v":3850},{"$f":"IF(C3=\"\",AVERAGE($G$2:G2)*(B3/B2),C3)","v":3850}]
["1900-01-03",3820,3760,3760,{"$f":"IF(C4=\"\",TREND($E$2:E3,$A$2:A3,A4),C4)","v":3760},{"$f":"IF(C4=\"\",GROWTH($F$2:F3,$A$2:A3,A4),C4)","v":3760},{"$f":"IF(C4=\"\",AVERAGE($G$2:G3)*(B4/B3),C4)","v":3760}]
["1900-01-04",4260,3990,3990,{"$f":"IF(C5=\"\",TREND($E$2:E4,$A$2:A4,A5),C5)","v":3990},{"$f":"IF(C5=\"\",GROWTH($F$2:F4,$A$2:A4,A5),C5)","v":3990},{"$f":"IF(C5=\"\",AVERAGE($G$2:G4)*(B5/B4),C5)","v":3990}]
["1900-01-05",4970,3890,3890,{"$f":"IF(C6=\"\",TREND($E$2:E5,$A$2:A5,A6),C6)","v":3890},{"$f":"IF(C6=\"\",GROWTH($F$2:F5,$A$2:A5,A6),C6)","v":3890},{"$f":"IF(C6=\"\",AVERAGE($G$2:G5)*(B6/B5),C6)","v":3890}]
["1900-01-06",5210,4020,4020,{"$f":"IF(C7=\"\",TREND($E$2:E6,$A$2:A6,A7),C7)","v":4020},{"$f":"IF(C7=\"\",GROWTH($F$2:F6,$A$2:A6,A7),C7)","v":4020},{"$f":"IF(C7=\"\",AVERAGE($G$2:G6)*(B7/B6),C7)","v":4020}]
["1900-01-07",5050,null,4183.3333333333303,{"$f":"IF(C8=\"\",TREND($E$2:E7,$A$2:A7,A8),C8)","v":4183.3333333333339},{"$f":"IF(C8=\"\",GROWTH($F$2:F7,$A$2:A7,A8),C8)","v":4208.1275177014923},{"$f":"IF(C8=\"\",AVERAGE($G$2:G7)*(B8/B7),C8)","v":3691.3787587971851}]
["1900-01-08",4930,null,4290.4761904761899,{"$f":"IF(C9=\"\",TREND($E$2:E8,$A$2:A8,A9),C9)","v":4290.4761904761908},{"$f":"IF(C9=\"\",GROWTH($F$2:F8,$A$2:A8,A9),C9)","v":4332.1895614871664},{"$f":"IF(C9=\"\",AVERAGE($G$2:G8)*(B9/B8),C9)","v":3701.5275044093387}]
["1900-01-09",5360,null,4397.6190476190504,{"$f":"IF(C10=\"\",TREND($E$2:E9,$A$2:A9,A10),C10)","v":4397.6190476190486},{"$f":"IF(C10=\"\",GROWTH($F$2:F9,$A$2:A9,A10),C10)","v":4459.9091443192547},{"$f":"IF(C10=\"\",AVERAGE($G$2:G9)*(B10/B9),C10)","v":4110.0907091984527}]
["1900-01-10",5280,null,4504.7619047619,{"$f":"IF(C11=\"\",TREND($E$2:E10,$A$2:A10,A11),C11)","v":4504.7619047619055},{"$f":"IF(C11=\"\",GROWTH($F$2:F10,$A$2:A10,A11),C11)","v":4591.3940960502077},{"$f":"IF(C11=\"\",AVERAGE($G$2:G10)*(B11/B10),C11)","v":3760.0295193677093}]
["1900-01-11",5490,null,4611.9047619047597,{"$f":"IF(C12=\"\",TREND($E$2:E11,$A$2:A11,A12),C12)","v":4611.9047619047633},{"$f":"IF(C12=\"\",GROWTH($F$2:F11,$A$2:A11,A12),C12)","v":4726.7554255216601},{"$f":"IF(C12=\"\",AVERAGE($G$2:G11)*(B12/B11),C12)","v":3962.8885499968196}]
["1900-01-12",5510,null,4719.0476190476202,{"$f":"IF(C13=\"\",TREND($E$2:E12,$A$2:A12,A13),C13)","v":4719.0476190476202},{"$f":"IF(C13=\"\",GROWTH($F$2:F12,$A$2:A12,A13),C13)","v":4866.1074142859052},{"$f":"IF(C13=\"\",AVERAGE($G$2:G12)*(B13/B12),C13)","v":3839.0179148890543}]
["Gesamt",{"$f":"SUM(B2:B13)","v":58010},{"$f":"SUM(C2:C13)","v":22850},{"$f":"SUM(D2:D13)","v":49557.142857142855},{"$f":"SUM(E2:E13)","v":49557.142857142862},{"$f":"SUM(F2:F13)","v":50034.483159365685},45914.932956658558]