{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Umsatzdaten","Prognose1","Prognose2","Umsatzfragen"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":16,"defined_names":63,"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,"Stochastik"]
[]
[]
[null,"Kapitel",6]
[null,"Thema","Beobachtungen und Messungen"]
[]
[null,"Inhalt","Prognoseblatt"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Letzte Bearbeitung","2021-10-15"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Umsatzdaten","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Konfidenzgrenze"]
["Datum","Umsatz","Prognose","untere","obere"]
["2019-01-01",23546]
["2019-01-15",43122]
["2019-01-29",36210]
["2019-02-12"]
["2019-02-26",44768]
["2019-03-12",31556]
["2019-03-26",47358]
["2019-04-09",38689]
["2019-04-23"]
["2019-05-07",52100]
["2019-05-21",43333]
["2019-06-04",39111]
["2019-06-18",45360]
["2019-07-02"]
["2019-07-16"]
["2019-07-30"]
["2019-08-13"]
["2019-08-27"]
["2019-09-10"]
["2019-09-24"]
["2019-10-08"]
["2019-10-22"]
["2019-11-05"]
["2019-11-19"]
["2019-12-03"]
["2019-12-17"]
["2019-12-31"]

{"sheet":"Prognose1","index":2,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Schätzer(Umsatz)","Untere Konfidenzgrenze(Umsatz)","Obere Konfidenzgrenze(Umsatz)"]
["2019-01-01",23546]
["2019-01-15",43122]
["2019-01-29",36210]
["2019-02-12",40489]
["2019-02-26",44768]
["2019-03-12",31556]
["2019-03-26",47358]
["2019-04-09",38689]
["2019-04-23",45394.5]
["2019-05-07",52100]
["2019-05-21",43333]
["2019-06-04",39111]
["2019-06-18",45360,45360,45360,45360]
["2019-07-02",null,{"$f":"_xlfn.FORECAST.ETS(A15,$B$2:$B$14,$A$2:$A$14,1,1)","v":51989.948034550594},{"$f":"C15-_xlfn.FORECAST.ETS.CONFINT(A15,$B$2:$B$14,$A$2:$A$14,0.95,1,1)","v":37114.04257860042},{"$f":"C15+_xlfn.FORECAST.ETS.CONFINT(A15,$B$2:$B$14,$A$2:$A$14,0.95,1,1)","v":66865.853490500769}]
["2019-07-16",null,43563.496632636459,26918.402033491595,60208.59123178132]
["2019-07-30",null,48628.043162272916,30378.435376883528,66877.650947662303]
["2019-08-13",null,55363.336764788997,35628.004990686815,75098.668538891186]
["2019-08-27",null,46936.885362874869,25820.103975854039,68053.666749895696]
["2019-09-10",null,52001.431892511318,29583.195591635631,74419.668193387013]
["2019-09-24",null,58736.7254950274,35079.06367365105,82394.38731640375]
["2019-10-08",null,50310.274093113272,25474.964413801528,75145.583772425016]
["2019-10-22",null,55374.820622749721,29410.897471254859,81338.743774244591]
["2019-11-05",null,62110.114225265803,35056.289342359865,89163.939108171733]
["2019-11-19",null,53683.662823351675,25582.175742181935,81785.149904521415]
["2019-12-03",null,58748.209352988131,29632.850968735918,87863.567737240344]
["2019-12-17",null,65483.502955504206,35380.86679430907,95586.139116699342]
["2019-12-31",null,57057.051553590078,25998.505002549726,88115.598104630422]

{"sheet":"Prognose2","index":3,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Schätzer(Umsatz)","Konfidenzintervall(Umsatz)"]
["2019-01-01",23546]
["2019-01-15",43122]
["2019-01-29",36210]
["2019-02-12",40489]
["2019-02-26",44768]
["2019-03-12",31556]
["2019-03-26",47358]
["2019-04-09",38689]
["2019-04-23",45394.5]
["2019-05-07",52100]
["2019-05-21",43333]
["2019-06-04",39111]
["2019-06-18",45360]
["2019-07-02",null,{"$f":"_xlfn.FORECAST.ETS(A15,$B$2:$B$14,$A$2:$A$14,1,1)","v":51989.948034550594},{"$f":"_xlfn.FORECAST.ETS.CONFINT(A15,$B$2:$B$14,$A$2:$A$14,0.95,1,1)","v":14875.905455950176}]
["2019-07-16",null,43563.496632636459,16645.094599144864]
["2019-07-30",null,48628.043162272916,18249.607785389388]
["2019-08-13",null,55363.336764788997,19735.331774102182]
["2019-08-27",null,46936.885362874869,21116.78138702083]
["2019-09-10",null,52001.431892511318,22418.236300875687]
["2019-09-24",null,58736.7254950274,23657.66182137635]
["2019-10-08",null,50310.274093113272,24835.309679311744]
["2019-10-22",null,55374.820622749721,25963.923151494862]
["2019-11-05",null,62110.114225265803,27053.824882905938]
["2019-11-19",null,53683.662823351675,28101.48708116974]
["2019-12-03",null,58748.209352988131,29115.358384252213]
["2019-12-17",null,65483.502955504206,30102.636161195136]
["2019-12-31",null,57057.051553590078,31058.546551040352]

{"sheet":"Umsatzfragen","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["1. Geschätzter Umsatz am 2.1.2020:",{"$f":"_xlfn.FORECAST.ETS(\"2.1.2020\",Umsätze,Zeitraum,1,1)","v":57780.558200681}]
[]
["2. Konfidenzintervall zum 2.1.2020:",{"$f":"_xlfn.FORECAST.ETS.CONFINT(\"2.1.2020\",Umsätze,Zeitraum,0.95,1,1)","v":31193.235340602063}]
[]
["3. Saisonalität:",{"$f":"_xlfn.FORECAST.ETS.SEASONALITY(Umsätze, Zeitraum,1)","v":3}]
[]
["4. Alpha-Parameter des ETS-Algorithmus:",{"$f":"_xlfn.FORECAST.ETS.STAT(Umsätze,Zeitraum,1,1,1)","v":0.501}]
[]
["5. Schätzwert  durch lineare Regression:",{"$f":"_xlfn.FORECAST.LINEAR(\"2.1.2020\",Umsätze,Zeitraum)","v":60976.320006151218}]