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

{"sheet":"Forecast","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Monat","Plan","Ist","Übertrag","Trend","Schätzer","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=\"\",FORECAST(A2,$F1:F$2,$A1:A$2),C2)","v":3340},{"$f":"IF(C2=\"\",GROWTH($G1:G$2,$A1:A$2,A2),C2)","v":3340},{"$f":"IF(C2=\"\",AVERAGE($H1:H$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=\"\",FORECAST(A3,$F$2:F2,$A$2:A2),C3)","v":3850},{"$f":"IF(C3=\"\",GROWTH($G$2:G2,$A$2:A2,A3),C3)","v":3850},{"$f":"IF(C3=\"\",AVERAGE($H$2:H2)*(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=\"\",FORECAST(A4,$F$2:F3,$A$2:A3),C4)","v":3760},{"$f":"IF(C4=\"\",GROWTH($G$2:G3,$A$2:A3,A4),C4)","v":3760},{"$f":"IF(C4=\"\",AVERAGE($H$2:H3)*(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=\"\",FORECAST(A5,$F$2:F4,$A$2:A4),C5)","v":3990},{"$f":"IF(C5=\"\",GROWTH($G$2:G4,$A$2:A4,A5),C5)","v":3990},{"$f":"IF(C5=\"\",AVERAGE($H$2:H4)*(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=\"\",FORECAST(A6,$F$2:F5,$A$2:A5),C6)","v":3890},{"$f":"IF(C6=\"\",GROWTH($G$2:G5,$A$2:A5,A6),C6)","v":3890},{"$f":"IF(C6=\"\",AVERAGE($H$2:H5)*(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=\"\",FORECAST(A7,$F$2:F6,$A$2:A6),C7)","v":4020},{"$f":"IF(C7=\"\",GROWTH($G$2:G6,$A$2:A6,A7),C7)","v":4020},{"$f":"IF(C7=\"\",AVERAGE($H$2:H6)*(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=\"\",FORECAST(A8,$F$2:F7,$A$2:A7),C8)","v":4183.3333333333339},{"$f":"IF(C8=\"\",GROWTH($G$2:G7,$A$2:A7,A8),C8)","v":4208.1275177014923},{"$f":"IF(C8=\"\",AVERAGE($H$2:H7)*(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=\"\",FORECAST(A9,$F$2:F8,$A$2:A8),C9)","v":4290.4761904761908},{"$f":"IF(C9=\"\",GROWTH($G$2:G8,$A$2:A8,A9),C9)","v":4332.1895614871664},{"$f":"IF(C9=\"\",AVERAGE($H$2:H8)*(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=\"\",FORECAST(A10,$F$2:F9,$A$2:A9),C10)","v":4397.6190476190486},{"$f":"IF(C10=\"\",GROWTH($G$2:G9,$A$2:A9,A10),C10)","v":4459.9091443192547},{"$f":"IF(C10=\"\",AVERAGE($H$2:H9)*(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=\"\",FORECAST(A11,$F$2:F10,$A$2:A10),C11)","v":4504.7619047619055},{"$f":"IF(C11=\"\",GROWTH($G$2:G10,$A$2:A10,A11),C11)","v":4591.3940960502077},{"$f":"IF(C11=\"\",AVERAGE($H$2:H10)*(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=\"\",FORECAST(A12,$F$2:F11,$A$2:A11),C12)","v":4611.9047619047633},{"$f":"IF(C12=\"\",GROWTH($G$2:G11,$A$2:A11,A12),C12)","v":4726.7554255216601},{"$f":"IF(C12=\"\",AVERAGE($H$2:H11)*(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=\"\",FORECAST(A13,$F$2:F12,$A$2:A12),C13)","v":4719.0476190476202},{"$f":"IF(C13=\"\",GROWTH($G$2:G12,$A$2:A12,A13),C13)","v":4866.1074142859052},{"$f":"IF(C13=\"\",AVERAGE($H$2:H12)*(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":49557.142857142862},50034.483159365685,45914.932956658558]