2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/36de6c50684c8241969a2064d30aff41e0bc5d97 0 0 100804 85760 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 2 1 0 0 0 0 2 0 0 0 0 0 75 60 true false Sheet2 1044 0 75 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true true true false 12632256 false Generic Printer cs CZ de DE en US nl NL 3 1 true 1 true lQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAtgAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKRHVwbGV4Ok5vbmUAUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERQ8ARHVwbGV4TW9kZTo6T2Zm false 0 Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ DM - DM DM - DM DM - DM DM - DM DM - DM € € - tan aa / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 FORECAST.ETS.ADD Function Result TRUE Sheet Result Description 1 TRUE Simple FORECAST.ETS.ADD formulas with local references and values Function Expected Correct FunctionString Comment 1 2 Known Y Known X 2 125.2 12.5 12.5 TRUE =FORECAST.ETS.ADD(6, N1:N5, M1:M5) Check 5.3 2 4 6 20 4 118.9 target 34 46 #VALUE! #VALUE! TRUE =FORECAST.ETS.ADD(30,P2:P6,Q2:Q6) 3 7 7 28 6 106.0 seasonality 4 1 jaar 12 date sales 125.226808384339 125.226808384339 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 4 8 9 31 4 118.9 datacompletion 1 1 1 01/01/01 3 240 325 118.933231648245 118.933231648245 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 5 11 15 38 5 111.5 aggregation 1 1 2 02/01/01 2 741 349 48.4 1 105.954105316101 105.954105316101 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 21 40 6 106.0 3 03/01/01 2 987 427 48.5 2 118.933231648245 118.933231648245 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 7 105.0 4 04/01/01 3 456 892 57.45 3 111.549667344589 111.549667344589 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 8 109.5 01/01/01 1 41.7 1 112 5 05/01/01 3 740 738 64.95 4 105.954105316101 105.954105316101 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 9 117.5 04/01/01 2 24 2 118 6 06/01/01 3 979 178 62.55 5 105.026989677408 105.026989677408 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 10 125.6 07/01/01 3 32.3 3 132 7 07/01/01 4 160 454 60.15 6 109.479384966668 109.479384966668 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 11 130.2 10/01/01 4 37.3 4 129 8 08/01/01 4 162 013 69.25 7 117.5 117.5 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 12 129.3 01/01/02 5 46.2 5 121 9 09/01/01 3 809 132 68.6 8 125.584893794301 125.584893794301 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 13 123.6 04/01/02 6 29.3 6 135 10 10/01/01 3 794 419 65.05 9 130.169971873195 130.169971873195 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 14 115.9 07/01/02 7 36.5 7 148 11 11/01/01 3 719 219 64.4 10 129.305702305035 129.305702305035 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 15 110.1 10/01/02 8 43 8 148 12 12/01/01 3 812 981 56.45 11 123.587140712742 123.587140712742 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 16 109.1 01/01/03 9 48.9 9 136 13 01/01/02 3 480 451 48 12 115.895758280092 115.895758280092 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 17 113.7 04/01/03 10 31.2 10 119 14 02/01/02 3 183 133 53.583 13 110.064393884398 110.064393884398 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 18 122.0 07/01/03 11 37.7 11 104 15 03/01/02 3 764 529 48.018 14 109.083826188552 109.083826188552 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 19 130.4 10/01/03 12 40.4 12 118 16 04/01/02 3 500 189 62.116 15 113.690130542309 113.690130542309 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 20 135.1 01/01/04 13 51.2 13 115 17 05/01/02 3 389 811 67.681 16 122 122 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 21 134.2 04/01/04 14 31.9 14 126 18 06/01/02 4 348 789 66.78 17 130.37414821866 130.37414821866 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 22 128.2 07/01/04 15 41 15 141 19 07/01/02 4 442 455 70.066 18 135.11313536205 135.11313536205 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 23 120.2 10/01/04 16 43.8 16 135 20 08/01/02 4 593 383 71.073 19 134.195413736738 134.195413736738 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 24 114.2 01/01/05 17 55.6 17 125 21 09/01/02 4 029 783 76.691 20 128.241049777238 128.241049777238 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 25 113.1 04/01/05 18 33.9 18 149 22 10/01/02 4 211 211 66.992 21 120.241849215595 120.241849215595 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 26 117.9 07/01/05 19 42.1 19 170 23 11/01/02 3 854 682 61.533 22 114.174682452695 114.174682452695 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 27 126.5 10/01/05 20 45.6 20 170 24 12/01/02 3 554 831 62.275 23 113.140662699697 113.140662699697 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 28 135.2 01/01/06 21 59.8 21 158 25 01/01/03 3 488 309 51.675 24 117.90087611795 117.90087611795 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 29 140.1 04/01/06 22 35.2 22 133 26 02/01/03 3 270 444 60.146 25 126.5 126.5 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 30 139.1 07/01/06 23 44.3 23 114 27 03/01/03 3 709 943 56.434 26 135.163402643019 135.163402643019 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 31 132.9 10/01/06 24 47.9 24 140 28 04/01/03 3 655 530 67.222 27 140.056298850906 140.056298850906 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 32 124.6 01/01/07 25 25 145 29 05/01/03 4 097 990 70.76 28 139.085125168441 139.085125168441 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 33 118.3 04/01/07 26 26 150 30 06/01/03 4 472 583 73.95 29 132.894958841735 132.894958841735 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 34 117.2 07/01/07 27 27 178 31 07/01/03 4 531 711 79.286 30 124.587940151099 124.587940151099 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 35 122.1 10/01/07 28 28 163 32 08/01/03 4 504 466 77.372 31 118.284971020992 118.284971020992 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 36 131.0 01/01/08 29 29 172 33 09/01/03 4 054 338 79.808 32 117.197499210841 117.197499210841 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 37 140.0 04/01/08 30 30 178 34 10/01/03 71.978 33 122.111621693591 122.111621693591 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 38 145.0 07/01/08 31 31 199 35 11/01/03 70.702 34 131 131 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 39 144.0 10/01/08 32 32 199 36 12/01/03 65.946 35 139.952657067378 139.952657067378 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 01/01/09 33 33 184 37 01/01/04 55.274 36 144.999462339761 144.999462339761 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 04/01/09 34 34 162 38 02/01/04 61.08 37 143.974836600144 143.974836600144 TRUE {=FORECAST.ETS.ADD(S1:S39,T1:T39,S1:S39)} 35 146 39 02/29/04 59.7 38 #NUM! #NUM! TRUE =FORECAST.ETS.ADD(0,P2:P6,Q2:Q6) 36 166 40 03/31/04 69.48 39 #NUM! #NUM! TRUE =FORECAST.ETS.ADD(-30,P2:P6,Q2:Q6) 37 41 04/30/04 77.34 40 5 5.000000 TRUE =FORECAST.ETS.ADD(8, {1,2,3}, {4,5,6}) 38 42 05/31/04 74.16 41 #VALUE! #VALUE! TRUE =FORECAST.ETS.ADD(7, {5.8,-1}, {2,-5}) 39 43 06/30/04 83.04 42 -5 -5.000000 TRUE =FORECAST.ETS.ADD(50, {-1,-2,-3,-4}, {10,20,30,40}) "Not a Number", but that shouldn't be the final result and indicates baderror handling. 40 44 07/31/04 80.16 43 47.9 47.900000 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} Problem seems to be caused by linear data for which the period length must be calculated. I changed the code to recognise linear data and switch from ETS to EDS, which is _much_ cheaper and returns an expected result (-5 in the above example).However, this is no longer compatible with Excel, which doesn't recognise this and returns #N/A.What to do, follow Excel or opt for the neater solution, resulting in a valid forecast? 41 45 08/31/04 81.12 44 60.5496314322673 60.5496314322673 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 42 46 09/30/04 84.12 45 36.6603356411902 36.6603356411902 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 43 47 10/31/04 69 46 46.015291770592 46.015291770592 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 44 48 11/30/04 68.4 47 49.8968323640595 49.8968323640595 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 45 49 01/01/05 54.54 48 62.3855834572025 62.3855834572025 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 46 50 02/01/05 66.624 49 38.4962876661254 38.4962876661254 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 47 51 03/01/05 58.048 50 47.8512437955272 47.8512437955272 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 48 52 04/01/05 70.528 51 51.7327843889948 51.7327843889948 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 49 53 05/01/05 79.424 52 64.2215354821377 64.2215354821377 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 50 54 06/01/05 79.232 53 40.3322396910606 40.3322396910606 TRUE {=FORECAST.ETS.ADD(V31:V41,X8:X31,V8:V31,W3,W4,W5)} 51 55 07/01/05 93.056 54 166 166 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 52 56 08/01/05 93.76 55 165.563797808596 165.563797808596 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 53 57 09/01/05 93.696 56 174.139252403617 174.139252403617 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 54 58 10/01/05 94.08 57 195.278082026658 195.278082026658 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 55 59 11/01/05 82.624 58 185.339158243359 185.339158243359 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 56 60 12/01/05 75.776 59 185.286794596348 185.286794596348 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 57 58.048 60 196.644723155341 196.644723155341 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 58 61 215.059081287518 215.059081287518 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 59 62 213.233880889475 213.233880889475 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 60 63 198.870060704206 198.870060704206 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 61 64 177.979089522812 177.979089522812 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 62 65 163.021991570337 163.021991570337 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 63 66 184.246477235911 184.246477235911 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 67 183.063925853482 183.063925853482 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 68 191.639380448504 191.639380448504 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 69 212.778210071544 212.778210071544 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 70 202.839286288246 202.839286288246 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 71 202.786922641234 202.786922641234 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 72 214.144851200228 214.144851200228 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 73 232.559209332405 232.559209332405 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 74 230.734008934362 230.734008934362 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 75 216.370188749093 216.370188749093 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 76 195.479217567699 195.479217567699 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 77 180.522119615224 180.522119615224 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 78 201.746605280797 201.746605280797 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 79 200.564053898369 200.564053898369 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 80 209.13950849339 209.13950849339 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 81 230.278338116431 230.278338116431 TRUE {=FORECAST.ETS.ADD(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} 82 4054338 4054338 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 83 4299395.20860622 4299395.20860622 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 84 4132679.8845827 4132679.8845827 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 85 4100196.91382762 4100196.91382762 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 86 3855816.71930321 3855816.71930321 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 87 3487433.71978657 3487433.71978657 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 88 3868249.92342637 3868249.92342637 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 89 4006468.54357238 4006468.54357238 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 90 4256968.92405459 4256968.92405459 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 91 4698102.21412853 4698102.21412853 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 92 4820462.29017543 4820462.29017543 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 93 4845679.99679883 4845679.99679883 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 94 4479965.92570079 4479965.92570079 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 95 4528488.54193955 4528488.54193955 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 96 4361773.21791604 4361773.21791604 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4329290.24716095 4329290.24716095 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4084910.05263654 4084910.05263654 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 3716527.05311991 3716527.05311991 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4097343.25675971 4097343.25675971 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4235561.87690572 4235561.87690572 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4486062.25738793 4486062.25738793 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4927195.54746187 4927195.54746187 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 5049555.62350877 5049555.62350877 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 5074773.33013216 5074773.33013216 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4709059.25903412 4709059.25903412 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4757581.87527288 4757581.87527288 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4590866.55124937 4590866.55124937 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 4558383.58049429 4558383.58049429 TRUE {=FORECAST.ETS.ADD(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} 58.048 58.048 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 73.8271964689978 73.8271964689978 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 65.9998482820766 65.9998482820766 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 78.7673298175085 78.7673298175085 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 87.7119624164518 87.7119624164518 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 87.2147667931694 87.2147667931694 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 100.060313229535 100.060313229535 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 99.4195799467331 99.4195799467331 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 98.3758252309232 98.3758252309232 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 98.0950982126688 98.0950982126688 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 85.6547546297499 85.6547546297499 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 78.8518128530024 78.8518128530024 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 65.7936722790212 65.7936722790212 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 77.5549464689978 77.5549464689978 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 69.7275982820766 69.7275982820766 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 82.4950798175085 82.4950798175085 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 91.4397124164518 91.4397124164518 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 90.9425167931694 90.9425167931694 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 103.788063229535 103.788063229535 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 103.147329946733 103.147329946733 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 102.103575230923 102.103575230923 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 101.822848212669 101.822848212669 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 89.3825046297499 89.3825046297499 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 82.5795628530024 82.5795628530024 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 69.5214222790212 69.5214222790212 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 81.2826964689978 81.2826964689978 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 73.4553482820766 73.4553482820766 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 86.2228298175085 86.2228298175085 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 95.1674624164518 95.1674624164518 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 94.6702667931694 94.6702667931694 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 107.515813229535 107.515813229535 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 106.875079946733 106.875079946733 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 105.831325230923 105.831325230923 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 105.550598212669 105.550598212669 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 93.1102546297499 93.1102546297499 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 86.3073128530024 86.3073128530024 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 73.2491722790212 73.2491722790212 TRUE {=FORECAST.ETS.ADD(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} 4