From fb790880eb11552b2e7d1dcf6c09d2663712290f Mon Sep 17 00:00:00 2001 From: Winfried Donkers Date: Thu, 15 Sep 2016 13:39:35 +0200 Subject: tdf#94635 follow up; handle linear data properly when samples in period are to be calculated by function. Applies to all FORECAST.ETS functions with argument period_length having value 1. Change-Id: Icb5a0288670321caf0dd5b70bee4b8811b9ba4a9 Reviewed-on: https://gerrit.libreoffice.org/28923 Reviewed-by: Eike Rathke Tested-by: Eike Rathke --- .../data/functions/fods/forecast.ets.mult.fods | 4060 ++++++++++---------- 1 file changed, 2081 insertions(+), 1979 deletions(-) (limited to 'sc/qa/unit') diff --git a/sc/qa/unit/data/functions/fods/forecast.ets.mult.fods b/sc/qa/unit/data/functions/fods/forecast.ets.mult.fods index f5ae3532b2ad..37aa304d199b 100644 --- a/sc/qa/unit/data/functions/fods/forecast.ets.mult.fods +++ b/sc/qa/unit/data/functions/fods/forecast.ets.mult.fods @@ -1,13 +1,13 @@ - 2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/e1822c809b137859382139aace0c08be4547c157 + 2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7e1fd9aa86ab8d5e86f35df8615f438a3383af98 0 0 - 162119 - 145635 + 22009 + 4420 view1 @@ -31,8 +31,8 @@ false - 4 - 8 + 2 + 44 0 0 0 @@ -50,7 +50,7 @@ Sheet2 - 1241 + 1857 0 75 60 @@ -91,10 +91,12 @@ true true true + true + true false 12632256 false - Lexmark-E352dn + Generic Printer cs @@ -125,14 +127,12 @@ - true - true 3 1 true 1 true - sgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgBJbnB1dFNsb3Q6VHJheTEARHVwbGV4Ok5vbmUAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY= + iQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAqgAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERQ8ARHVwbGV4TW9kZTo6T2Zm false 0 @@ -2838,10 +2838,6 @@ - - - - @@ -2850,6 +2846,55 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -2967,27 +3012,27 @@ - + - + - + - + - + @@ -2995,7 +3040,7 @@ - + @@ -3003,7 +3048,7 @@ - + @@ -3011,135 +3056,142 @@ - + - - + + - + - + - + - + - + - + - + - + - + - + - - - + + + - + - + + + + + + + + - + - + - + - - - + + + - + - + - + - - + + - + - - - + + + - + - + - + @@ -3201,7 +3253,7 @@ ??? (???) - 00/00/0000, 00:00:00 + 00/00/0000, 00:00:00 @@ -3229,10 +3281,10 @@ - + - + FORECAST.ETS.MULT Function @@ -3241,10 +3293,10 @@ - + Result - + TRUE @@ -3253,13 +3305,13 @@ - + Sheet - + Result - + Description @@ -3267,7 +3319,7 @@ 1 - + TRUE @@ -3276,37 +3328,37 @@ - + - - + + - + - + - + - + - + @@ -3332,7 +3384,7 @@ - + @@ -3344,78 +3396,78 @@ - + Function - + Expected - + Correct - + FunctionString - + Comment - + - - + + 1 - + 2 - - + + Known Y - + Known X - - + + 2 - + 125.2 - + - + - + B - + C - - + + E - + 9 - + periods - - + + - - + + 1 - - + + 1 @@ -3427,132 +3479,132 @@ 11.908196123559 - + TRUE - + =FORECAST.ETS.MULT(6, N1:N5, M1:M5) - https://bugs.documentfoundation.org/show_bug.cgi?id=94635 + https://bugs.documentfoundation.org/show_bug.cgi?id=94635 - - + + 2 - + 4 - - + + 6 - + 20 - - + + 4 - + 118.9 - + target - + 34 - + - + 46 - + - + 49 - + 2002 - + - - - + + + - + 34 - - + + 2 - + 46 - - + + 2 - + #VALUE! - + #VALUE! - + TRUE - + =FORECAST.ETS.MULT(30,P2:P6,Q2:Q6) - - + + 3 - + 7 - - + + 7 - + 28 - - + + 6 - + 106.0 - + seasonality - + 4 - + 1 jaar - + 12 - + date @@ -3561,35 +3613,35 @@ sales - + 4 - + 1 jaar - + - - - + + + - + 4 - + 1 jaar - + 3 - + 12 - + 1 jaar - + 3 @@ -3605,154 +3657,154 @@ 125.226808384339 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - - + + 4 - + 8 - - + + 9 - + 31 - - + + 4 - + 118.9 - + datacompletion - + 1 - + - + 1 - + 1 - + 01/01/01 - + 3 240 325 - + - + 1 - + - - - + + + - + 1 - - + + 4 - + 1 - - + + 4 1 - - + + 3 240 325 - + - + 118.933231648245 118.933231648245 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - - + + 5 - + 11 - - + + 15 - + 38 - - + + 5 - + 111.5 - + aggregation - + 1 - + - + 1 - + 2 - + 02/01/01 - + 2 741 349 @@ -3763,40 +3815,40 @@ 1 - + 1 - - + + - + - - - + + + - + 1 - - + + 5 - + 1 - - + + 5 2 - - + + 2 741 349 @@ -3808,46 +3860,46 @@ - + 105.954105316101 105.954105316101 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 21 - + 40 - - + + 6 - + 106.0 - + - + 3 - + 03/01/01 - + 2 987 427 @@ -3858,32 +3910,32 @@ 2 - + - + 2 - + 125.2 - - + + - - + + 6 - - + + 6 3 - - + + 2 987 427 @@ -3895,16 +3947,16 @@ - + 118.933231648245 118.933231648245 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} @@ -3912,25 +3964,25 @@ - - + + 7 - + 105.0 - + - + 4 - + 04/01/01 - + 3 456 892 @@ -3941,38 +3993,38 @@ 3 - + period - + sales - + - + 4 - + 118.9 - - + + - - + + 7 - - + + 7 4 - - + + 3 456 892 @@ -3987,13 +4039,13 @@ 111.549667344589 - + 111.5496673445890000000 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} @@ -4001,38 +4053,38 @@ - - + + 8 - + 109.5 - + 01/01/01 - + 1 - + 41.7 - + 1 - + 112 5 - + 05/01/01 - + 3 740 738 @@ -4043,48 +4095,48 @@ 4 - + 1 - + 362 - + - + 6 - + 106.0 - - + + - + 1 - + 41.7 - + 8 - + 1 - + 112 - + 8 5 - - + + 3 740 738 @@ -4102,46 +4154,46 @@ 105.954105316101 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 9 - + 117.5 - + 04/01/01 - + 2 - + 24 - + 2 - + 118 6 - + 06/01/01 - + 3 979 178 @@ -4152,42 +4204,42 @@ 5 - + 2 - + 385 - + - + 4 - + 118.9 - - + + - + 2 - + 24 - + 2 - + 118 6 - - + + 3 979 178 @@ -4205,46 +4257,46 @@ 105.026989677408 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 10 - + 125.6 - + 07/01/01 - + 3 - + 32.3 - + 3 - + 132 7 - + 07/01/01 - + 4 160 454 @@ -4255,42 +4307,42 @@ 6 - + 3 - + 432 - + - + 5 - + 111.5 - - + + - + 3 - + 32.3 - + 3 - + 132 7 - - + + 4 160 454 @@ -4308,46 +4360,46 @@ 109.479384966668 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 11 - + 130.2 - + 10/01/01 - + 4 - + 37.3 - + 4 - + 129 8 - + 08/01/01 - + 4 162 013 @@ -4358,42 +4410,42 @@ 7 - + 4 - + 341 - + - + 6 - + 106.0 - - + + - + 4 - + 37.3 - + 4 - + 129 8 - - + + 4 162 013 @@ -4411,46 +4463,46 @@ 117.5 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 12 - + 129.3 - + 01/01/02 - + 5 - + 46.2 - + 5 - + 121 9 - + 09/01/01 - + 3 809 132 @@ -4461,42 +4513,42 @@ 8 - + 5 - + 382 - + - + 7 - + 105.0 - - + + - + 5 - + 46.2 - + 5 - + 121 9 - - + + 3 809 132 @@ -4514,46 +4566,46 @@ 125.584893794301 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 13 - + 123.6 - + 04/01/02 - + 6 - + 29.3 - + 6 - + 135 10 - + 10/01/01 - + 3 794 419 @@ -4564,42 +4616,42 @@ 9 - + 6 - + 409 - + - + 8 - + 109.5 - - + + - + 6 - + 29.3 - + 6 - + 135 10 - - + + 3 794 419 @@ -4617,46 +4669,46 @@ 130.169971873195 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 14 - + 115.9 - + 07/01/02 - + 7 - + 36.5 - + 7 - + 148 11 - + 11/01/01 - + 3 719 219 @@ -4667,42 +4719,42 @@ 10 - + 7 - + 498 - + - + 9 - + 117.5 - - + + - + 7 - + 36.5 - + 7 - + 148 11 - - + + 3 719 219 @@ -4720,46 +4772,46 @@ 129.305702305035 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 15 - + 110.1 - + 10/01/02 - + 8 - + 43 - + 8 - + 148 12 - + 12/01/01 - + 3 812 981 @@ -4770,42 +4822,42 @@ 11 - + 8 - + 387 - + - + 10 - + 125.6 - - + + - + 8 - + 43 - + 8 - + 148 12 - - + + 3 812 981 @@ -4823,47 +4875,47 @@ 123.587140712742 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + - + 16 - + 109.1 - + 01/01/03 - + 9 - + 48.9 - + 9 - + 136 13 - + 01/01/02 - + 3 480 451 @@ -4874,42 +4926,42 @@ 12 - + 9 - + 473 - + - + 11 - + 130.2 - - + + - + 9 - + 48.9 - + 9 - + 136 13 - - + + 3 480 451 @@ -4927,46 +4979,46 @@ 115.895758280092 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 17 - + 113.7 - + 04/01/03 - + 10 - + 31.2 - + 10 - + 119 14 - + 02/01/02 - + 3 183 133 @@ -4977,42 +5029,42 @@ 13 - + 10 - + 513 - + - + 12 - + 129.3 - - + + - + 10 - + 31.2 - + 10 - + 119 14 - - + + 3 183 133 @@ -5030,46 +5082,46 @@ 110.064393884398 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 18 - + 122.0 - + 07/01/03 - + 11 - + 37.7 - + 11 - + 104 15 - + 03/01/02 - + 3 764 529 @@ -5080,42 +5132,42 @@ 14 - + 11 - + 582 - + - + 13 - + 123.6 - - + + - + 11 - + 37.7 - + 11 - + 104 15 - - + + 3 764 529 @@ -5133,46 +5185,46 @@ 109.083826188552 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 19 - + 130.4 - + 10/01/03 - + 12 - + 40.4 - + 12 - + 118 16 - + 04/01/02 - + 3 500 189 @@ -5183,42 +5235,42 @@ 15 - + 12 - + 474 - + - + 14 - + 115.9 - - + + - + 12 - + 40.4 - + 12 - + 118 16 - - + + 3 500 189 @@ -5236,46 +5288,46 @@ 113.690130542309 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 20 - + 135.1 - + 01/01/04 - + 13 - + 51.2 - + 13 - + 115 17 - + 05/01/02 - + 3 389 811 @@ -5286,42 +5338,42 @@ 16 - + 13 - + 544 - + - + 15 - + 110.1 - - + + - + 13 - + 51.2 - + 13 - + 115 17 - - + + 3 389 811 @@ -5339,46 +5391,46 @@ 122 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 21 - + 134.2 - + 04/01/04 - + 14 - + 31.9 - + 14 - + 126 18 - + 06/01/02 - + 4 348 789 @@ -5389,42 +5441,42 @@ 17 - + 14 - + 582 - + - + 16 - + 109.1 - - + + - + 14 - + 31.9 - + 14 - + 126 18 - - + + 4 348 789 @@ -5442,46 +5494,46 @@ 130.37414821866 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 22 - + 128.2 - + 07/01/04 - + 15 - + 41 - + 15 - + 141 19 - + 07/01/02 - + 4 442 455 @@ -5492,45 +5544,45 @@ 18 - + 15 - + 681 - - + + 1 - + 17 - + 113.7 - - + + - + 15 - + 41 - + 15 - + 141 19 - - + + 4 442 455 @@ -5548,46 +5600,46 @@ 135.11313536205 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 23 - + 120.2 - + 10/01/04 - + 16 - + 43.8 - + 16 - + 135 20 - + 08/01/02 - + 4 593 383 @@ -5598,45 +5650,45 @@ 19 - + 16 - + 557 - - + + 2 - + 18 - + 122.0 - - + + - + 16 - + 43.8 - + 16 - + 135 20 - - + + 4 593 383 @@ -5654,46 +5706,46 @@ 134.195413736738 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 24 - + 114.2 - + 01/01/05 - + 17 - + 55.6 - + 17 - + 125 21 - + 09/01/02 - + 4 029 783 @@ -5704,45 +5756,45 @@ 20 - + 17 - + 628 - - + + 3 - + 19 - + 130.4 - - + + - + 17 - + 55.6 - + 17 - + 125 21 - - + + 4 029 783 @@ -5760,46 +5812,46 @@ 128.241049777238 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 25 - + 113.1 - + 04/01/05 - + 18 - + 33.9 - + 18 - + 149 22 - + 10/01/02 - + 4 211 211 @@ -5810,45 +5862,45 @@ 21 - + 18 - + 707 - - + + 4 - + 20 - + 135.1 - - + + - + 18 - + 33.9 - + 18 - + 149 22 - - + + 4 211 211 @@ -5866,46 +5918,46 @@ 120.241849215595 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 26 - + 117.9 - + 07/01/05 - + 19 - + 42.1 - + 19 - + 170 23 - + 11/01/02 - + 3 854 682 @@ -5916,45 +5968,45 @@ 22 - + 19 - + 773 - - + + 5 - + 21 - + 134.2 - - + + - + 19 - + 42.1 - + 19 - + 170 23 - - + + 3 854 682 @@ -5972,46 +6024,46 @@ 114.174682452695 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 27 - + 126.5 - + 10/01/05 - + 20 - + 45.6 - + 20 - + 170 24 - + 12/01/02 - + 3 554 831 @@ -6022,45 +6074,45 @@ 23 - + 20 - + 592 - - + + 6 - + 22 - + 128.2 - - + + - + 20 - + 45.6 - + 20 - + 170 24 - - + + 3 554 831 @@ -6078,46 +6130,46 @@ 113.140662699697 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 28 - + 135.2 - + 01/01/06 - + 21 - + 59.8 - + 21 - + 158 25 - + 01/01/03 - + 3 488 309 @@ -6128,45 +6180,45 @@ 24 - + 21 - + 627 - - + + 7 - + 23 - + 120.2 - - + + - + 21 - + 59.8 - + 21 - + 158 25 - - + + 3 488 309 @@ -6184,46 +6236,46 @@ 117.90087611795 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 29 - + 140.1 - + 04/01/06 - + 22 - + 35.2 - + 22 - + 133 26 - + 02/01/03 - + 3 270 444 @@ -6234,45 +6286,45 @@ 25 - + 22 - + 725 - - + + 8 - + 24 - + 114.2 - - + + - + 22 - + 35.2 - + 22 - + 133 26 - - + + 3 270 444 @@ -6290,46 +6342,46 @@ 126.5 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 30 - + 139.1 - + 07/01/06 - + 23 - + 44.3 - + 23 - + 114 27 - + 03/01/03 - + 3 709 943 @@ -6340,42 +6392,42 @@ 26 - + 23 - + 854 - + - + 25 - + 113.1 - - + + - + 23 - + 44.3 - + 23 - + 114 27 - - + + 3 709 943 @@ -6393,46 +6445,46 @@ 135.163402643019 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 31 - + 132.9 - + 10/01/06 - + 24 - + 47.9 - + 24 - + 140 28 - + 04/01/03 - + 3 655 530 @@ -6443,42 +6495,42 @@ 27 - + 24 - + 661 - + - + 26 - + 117.9 - - + + - + 24 - + 47.9 - + 24 - + 140 28 - - + + 3 655 530 @@ -6496,46 +6548,46 @@ 140.056298850906 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 32 - + 124.6 - + 01/01/07 - + 25 - + - + - + 25 - + 145 29 - + 05/01/03 - + 4 097 990 @@ -6546,27 +6598,27 @@ 28 - + 27 - + 126.5 - - + + - + 25 - + 145 29 - - + + 4 097 990 @@ -6584,46 +6636,46 @@ 139.085125168441 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 33 - + 118.3 - + 04/01/07 - + 26 - + - + - + 26 - + 150 30 - + 06/01/03 - + 4 472 583 @@ -6634,29 +6686,29 @@ 29 - + 28 - + 135.2 - - + + 1 - + 26 - + 150 30 - - + + 4 472 583 @@ -6674,46 +6726,46 @@ 132.894958841735 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 34 - + 117.2 - + 07/01/07 - + 27 - + - + - + 27 - + 178 31 - + 07/01/03 - + 4 531 711 @@ -6724,29 +6776,29 @@ 30 - + 29 - + 140.1 - - + + 2 - + 27 - + 178 31 - - + + 4 531 711 @@ -6764,46 +6816,46 @@ 124.587940151099 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 35 - + 122.1 - + 10/01/07 - + 28 - + - + - + 28 - + 163 32 - + 08/01/03 - + 4 504 466 @@ -6814,29 +6866,29 @@ 31 - + 30 - + 139.1 - - + + 3 - + 28 - + 163 32 - - + + 4 504 466 @@ -6854,46 +6906,46 @@ 118.284971020992 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 36 - + 131.0 - + 01/01/08 - + 29 - + - + - + 29 - + 172 33 - + 09/01/03 - + 4 054 338 @@ -6904,29 +6956,29 @@ 32 - + 31 - + 132.9 - - + + 4 - + 29 - + 172 33 - - + + 4 054 338 @@ -6944,43 +6996,43 @@ 117.197499210841 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 37 - + 140.0 - + 04/01/08 - + 30 - + - + - + 30 - + 178 34 - + 10/01/03 @@ -6991,28 +7043,28 @@ 33 - + 32 - + 124.6 - - + + 5 - + 30 - + 178 34 - + 71.978 @@ -7028,43 +7080,43 @@ 122.111621693591 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 38 - + 145.0 - + 07/01/08 - + 31 - + - + - + 31 - + 199 35 - + 11/01/03 @@ -7075,28 +7127,28 @@ 34 - + 33 - + 118.3 - - + + 6 - + 31 - + 199 35 - + 70.702 @@ -7112,43 +7164,43 @@ 131 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 39 - + 144.0 - + 10/01/08 - + 32 - + - + - + 32 - + 199 36 - + 12/01/03 @@ -7159,28 +7211,28 @@ 35 - + 34 - + 117.2 - - + + 7 - + 32 - + 199 36 - + 65.946 @@ -7196,36 +7248,36 @@ 139.952657067378 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 01/01/09 - + 33 - + - + - + 33 - + 184 37 - + 01/01/04 @@ -7236,28 +7288,28 @@ 36 - + 35 - + 122.1 - - + + 8 - + 33 - + 184 37 - + 55.274 @@ -7273,36 +7325,36 @@ 144.999462339761 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + 04/01/09 - + 34 - + - + - + 34 - + 162 38 - + 02/01/04 @@ -7313,26 +7365,26 @@ 37 - + 36 - + 131.0 - - + + - + 34 - + 162 38 - + 61.08 @@ -7348,30 +7400,30 @@ 143.974836600144 - + TRUE - + {=FORECAST.ETS.MULT(S1:S39,T1:T39,S1:S39)} - + - + - + 35 - + 146 39 - + 02/29/04 @@ -7382,26 +7434,26 @@ 38 - + 37 - + 140.0 - - + + - + 35 - + 146 39 - + 59.7 @@ -7411,36 +7463,36 @@ - + #NUM! - + #NUM! - + TRUE - + =FORECAST.ETS.MULT(0,P2:P6,Q2:Q6) - + - + - + 36 - + 166 40 - + 03/31/04 @@ -7451,26 +7503,26 @@ 39 - + 38 - + 145.0 - - + + - + 36 - + 166 40 - + 69.48 @@ -7480,34 +7532,34 @@ - + #NUM! - + #NUM! - + TRUE - + =FORECAST.ETS.MULT(-30,P2:P6,Q2:Q6) - + - + - + 37 - + 41 - + 04/30/04 @@ -7518,19 +7570,19 @@ 40 - + 39 - + 144.0 - - + + 41 - + 77.34 @@ -7539,36 +7591,36 @@ 40 - - - #VALUE! + + + 5 - - #VALUE! + + 5.000000 - + TRUE - + =FORECAST.ETS.MULT(8, {1,2,3}, {4,5,6}) - - + + - + - + 38 - + 42 - + 05/31/04 @@ -7582,7 +7634,7 @@ 42 - + 74.16 @@ -7592,36 +7644,36 @@ - + #VALUE! - + #VALUE! - + TRUE - + =FORECAST.ETS.MULT(7, {5.8,-1}, {2,-5}) - + - + - + - + 39 - + 43 - + 06/30/04 @@ -7635,7 +7687,7 @@ 43 - + 83.04 @@ -7645,35 +7697,35 @@ - + -5 - + -5.000000 - + TRUE - + =FORECAST.ETS.MULT(50, {-1,-2,-3,-4}, {10,20,30,40}) - - + + - + - + 40 - + 44 - + 07/31/04 @@ -7687,7 +7739,7 @@ 44 - + 80.16 @@ -7697,35 +7749,35 @@ - + 47.9 - + 47.900000 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - - + + - + - + 41 - + 45 - + 08/31/04 @@ -7739,7 +7791,7 @@ 45 - + 81.12 @@ -7752,32 +7804,32 @@ 61.9729295871504 - + 61.972930 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - - + + - + - + 42 - + 46 - + 09/30/04 @@ -7791,7 +7843,7 @@ 46 - + 84.12 @@ -7804,32 +7856,32 @@ 36.8217963889502 - + 36.821796 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - - + + - + - + 43 - + 47 - + 10/31/04 @@ -7843,7 +7895,7 @@ 47 - + 69 @@ -7856,32 +7908,32 @@ 46.4784787396254 - + 46.478479 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - + - + - + 44 - + 48 - + 11/30/04 @@ -7895,7 +7947,7 @@ 48 - + 68.4 @@ -7908,13 +7960,13 @@ 50.5782852506606 - + 50.578285 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} @@ -7922,17 +7974,17 @@ - + - + 45 - + 49 - + 01/01/05 @@ -7946,7 +7998,7 @@ 49 - + 54.54 @@ -7962,26 +8014,26 @@ 65.1381523477569 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - + - + 46 - + 50 - + 02/01/05 @@ -7995,7 +8047,7 @@ 50 - + 66.624 @@ -8011,26 +8063,26 @@ 38.6787327078871 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - + - + 47 - + 51 - + 03/01/05 @@ -8044,7 +8096,7 @@ 51 - + 58.048 @@ -8060,26 +8112,26 @@ 48.7932216644061 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - + - + 48 - + 52 - + 04/01/05 @@ -8093,7 +8145,7 @@ 52 - + 70.528 @@ -8106,27 +8158,27 @@ 53.0662321817619 - + 53.066232 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - + - + 49 - + 53 - + 05/01/05 @@ -8140,7 +8192,7 @@ 53 - + 79.424 @@ -8156,10 +8208,10 @@ 68.3033751083634 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} @@ -8169,20 +8221,20 @@ 11 - - + + - + - + 50 - + 54 - + 06/01/05 @@ -8196,7 +8248,7 @@ 54 - + 79.232 @@ -8212,27 +8264,27 @@ 40.535669026824 - + TRUE - + {=FORECAST.ETS.MULT(V31:V41,X8:X31,V8:V31,W3,W4,W5)} - - + + - + - + 51 - + 55 - + 07/01/05 @@ -8246,7 +8298,7 @@ 55 - + 93.056 @@ -8256,34 +8308,34 @@ - + 166 166 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + - + - + 52 - + 56 - + 08/01/05 @@ -8297,7 +8349,7 @@ 56 - + 93.76 @@ -8313,26 +8365,26 @@ 173.745949032818 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + - + 53 - + 57 - + 09/01/05 @@ -8346,7 +8398,7 @@ 57 - + 93.696 @@ -8362,26 +8414,26 @@ 183.787265957111 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + - + 54 - + 58 - + 10/01/05 @@ -8395,7 +8447,7 @@ 58 - + 94.08 @@ -8408,29 +8460,29 @@ 206.399165266807 - + 206.399165 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 55 - + 59 - + 11/01/05 @@ -8444,7 +8496,7 @@ 59 - + 82.624 @@ -8457,29 +8509,29 @@ 202.483337817381 - + 202.483338 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 56 - + 60 - + 12/01/05 @@ -8493,7 +8545,7 @@ 60 - + 75.776 @@ -8506,24 +8558,24 @@ 190.641123921524 - + 190.641124 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 57 - + 58.048 @@ -8543,31 +8595,31 @@ 213.483211306267 - + 213.483211 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 58 - + - + 61 - + 61 @@ -8576,31 +8628,31 @@ 234.886744883615 - + 234.886745 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 59 - + - + 62 - + 62 @@ -8609,35 +8661,35 @@ 235.718895043652 - + 235.718895 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + - + - + 60 - + - + 63 - + 63 @@ -8646,32 +8698,32 @@ 217.358909191697 - + 217.358909 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + - + 61 - + - + 64 - + 64 @@ -8680,30 +8732,30 @@ 190.836835067215 - + 190.836835 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 62 - + - + 65 - + 65 @@ -8712,31 +8764,31 @@ 167.338929526706 - + 167.338930 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 63 - + - + 66 - + 66 @@ -8745,26 +8797,26 @@ 190.487537765425 - + 190.487538 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 67 - + 67 @@ -8773,26 +8825,26 @@ 200.127359722618 - + 200.127360 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 68 - + 68 @@ -8801,26 +8853,26 @@ 211.344649681028 - + 211.344650 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 69 - + 69 @@ -8829,26 +8881,26 @@ 236.965090983393 - + 236.965091 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 70 - + 70 @@ -8857,26 +8909,26 @@ 232.103818773717 - + 232.103819 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 71 - + 71 @@ -8885,26 +8937,26 @@ 218.193378775663 - + 218.193379 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + - + 72 - + 72 @@ -8913,19 +8965,19 @@ 243.969532849646 - + 243.969533 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 73 @@ -8939,19 +8991,19 @@ 268.03510577085 - + 268.035106 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 74 @@ -8968,16 +9020,16 @@ 268.59802115122 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 75 @@ -8994,16 +9046,16 @@ 247.328741800136 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 76 @@ -9020,16 +9072,16 @@ 216.850852063095 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 77 @@ -9046,16 +9098,16 @@ 189.893605332791 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 78 @@ -9072,16 +9124,16 @@ 215.877108165921 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 79 @@ -9098,16 +9150,16 @@ 226.508770412417 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 80 @@ -9124,16 +9176,16 @@ 238.902033404945 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 81 @@ -9150,16 +9202,16 @@ 267.531016699979 - + TRUE - + {=FORECAST.ETS.MULT(AB43:AB70,AC8:AC43,AB8:AB43,AB3,AB4,AB5)} - + 82 @@ -9170,22 +9222,22 @@ - + 4054338 4054338 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 83 @@ -9202,16 +9254,16 @@ 4288601.49523545 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 84 @@ -9228,15 +9280,15 @@ 4091199.55229487 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 85 @@ -9253,15 +9305,15 @@ 4038561.97098737 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 86 @@ -9278,16 +9330,16 @@ 3779986.30181304 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 87 @@ -9304,16 +9356,16 @@ 3387827.28877104 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 88 @@ -9330,16 +9382,16 @@ 3815736.59044792 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 89 @@ -9356,16 +9408,16 @@ 3927934.74841799 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 90 @@ -9382,16 +9434,16 @@ 4208549.03819637 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 91 @@ -9408,16 +9460,16 @@ 4719235.05761799 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 92 @@ -9434,16 +9486,16 @@ 4846987.32895276 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 93 @@ -9460,16 +9512,16 @@ 4876844.61506186 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 94 @@ -9486,16 +9538,16 @@ 4465507.06401322 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 95 @@ -9512,16 +9564,16 @@ 4527918.73243619 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + 96 @@ -9538,16 +9590,16 @@ 4318444.40292735 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9557,16 +9609,16 @@ 4261849.53926211 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9576,16 +9628,16 @@ 3988019.019607 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9595,16 +9647,16 @@ 3573426.20589779 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9614,16 +9666,16 @@ 4023828.1062791 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9633,10 +9685,10 @@ 4141175.90652158 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} @@ -9644,7 +9696,7 @@ - + @@ -9654,10 +9706,10 @@ 4435995.31360509 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} @@ -9665,7 +9717,7 @@ - + @@ -9675,16 +9727,16 @@ 4973137.29338817 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9694,16 +9746,16 @@ 5106598.87797539 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9713,16 +9765,16 @@ 5136894.64204166 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9732,16 +9784,16 @@ 4702569.7504895 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9751,16 +9803,16 @@ 4767235.96963692 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9770,16 +9822,16 @@ 4545689.25355982 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + @@ -9789,35 +9841,35 @@ 4485137.10753685 - + TRUE - + {=FORECAST.ETS.MULT(AE36:AE63,AG4:AG36,AE4:AE36,12,1,1)} - + - + 58.048 58.048 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9827,16 +9879,16 @@ 72.8878084393463 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9846,16 +9898,16 @@ 65.1161691604337 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9865,15 +9917,15 @@ 78.8999773389802 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9883,15 +9935,15 @@ 88.5042604116374 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9901,16 +9953,16 @@ 87.6933650074125 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9920,16 +9972,16 @@ 100.948503826912 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9939,16 +9991,16 @@ 99.6314373472625 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9958,16 +10010,16 @@ 98.9096428541703 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9977,16 +10029,16 @@ 98.3876468889293 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -9996,16 +10048,16 @@ 84.9640709913307 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10015,16 +10067,16 @@ 78.739015079783 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10034,16 +10086,16 @@ 63.7346058009482 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10053,16 +10105,16 @@ 76.3548564418651 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10072,16 +10124,16 @@ 68.2013150391412 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10091,16 +10143,16 @@ 82.6234863486569 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10110,16 +10162,16 @@ 92.664660471513 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10129,16 +10181,16 @@ 91.7995612636688 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10148,16 +10200,16 @@ 105.656992361035 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10167,16 +10219,16 @@ 104.260502046929 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10186,16 +10238,16 @@ 103.487447166156 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10205,16 +10257,16 @@ 102.923796390283 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10224,16 +10276,16 @@ 88.8663355112766 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10243,16 +10295,16 @@ 82.341584335951 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10262,16 +10314,16 @@ 66.6395978382139 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10281,16 +10333,16 @@ 79.8219044443839 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10300,16 +10352,16 @@ 71.2864609178487 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10319,16 +10371,16 @@ 86.3469953583337 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10338,16 +10390,16 @@ 96.8250605313886 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10357,16 +10409,16 @@ 95.9057575199251 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10376,16 +10428,16 @@ 110.365480895159 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10395,16 +10447,16 @@ 108.889566746596 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10414,16 +10466,16 @@ 108.065251478142 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10433,14 +10485,14 @@ 107.459945891637 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10450,14 +10502,14 @@ 92.7686000312226 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10467,14 +10519,14 @@ 85.944153592119 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + @@ -10484,31 +10536,31 @@ 69.5445898754795 - + TRUE - + {=FORECAST.ETS.MULT(AJ64:AJ100,AI5:AI64,AJ5:AJ64,12,1,1)} - + - + 0.75 0.75 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10518,14 +10570,14 @@ 0.068359375 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10535,14 +10587,14 @@ 1 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10552,14 +10604,14 @@ 0.206559789330583 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10569,14 +10621,14 @@ 0.029831737360903 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10586,14 +10638,14 @@ 17.7641418824301 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10603,14 +10655,14 @@ 24.3772832609466 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + @@ -10620,1306 +10672,1306 @@ 1 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AM8:AM31,AL8:AL31,AO22:AO29,AL3,AL4,AL5)} - + - + 0.0625 - + 0.062500 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 0.1787109375 - + 0.178711 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 1 - + 1.000000 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 0.032390712391279 - + 0.032391 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 0.001374283909887 - + 0.001374 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 0.170847479986413 - + 0.170847 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 0.394116650892796 - + 0.394117 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + 1 - + 1.000000 - + TRUE - + {=FORECAST.ETS.STAT.MULT($AR$6:$AR$44,$AQ$6:$AQ$44,AT33:AT40,AQ1,1,1)} - + - + 0.46875 - + 0.468750 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 0.1279296875 - + 0.127930 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 1 - + 1.000000 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 0.112662710030113 - + 0.112663 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 0.027203133488256 - + 0.027203 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 1.14864753907974 - + 1.148648 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 1.7355926400562 - + 1.735593 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + 1 - + 1.000000 - + TRUE - + {=FORECAST.ETS.STAT.MULT(AW$8:AW$31,AV$8:AV$31,AX1:AX8,AV$3,AV$4,AV$5)} - + - + 0.51171875 - + 0.511719 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 0.0810546875 - + 0.081055 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 0 - + 0.000000 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 0.243024634011384 - + 0.243025 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 0.021052330482045 - + 0.021052 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 3.17361580885454 - + 3.173616 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 5.03536471769304 - + 5.035365 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + 1 - + 1.000000 - + TRUE - + {=FORECAST.ETS.STAT.MULT(BA$8:BA$43,AZ$8:AZ$43,BB1:BB8,AZ$3,AZ$4,AZ$5)} - + - + 4054338 - + 4054338.000000 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4288601.49523545 - + 4288601.495235 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4091199.55229487 - + 4091199.552295 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4038561.97098737 - + 4038561.970987 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 3779986.30181304 - + 3779986.301813 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 3387827.28877104 - + 3387827.288771 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 3815736.59044792 - + 3815736.590448 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 3927934.74841799 - + 3927934.748418 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4208549.03819637 - + 4208549.038196 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4719235.05761799 - + 4719235.057618 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4846987.32895276 - + 4846987.328953 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4876844.61506186 - + 4876844.615062 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4465507.06401322 - + 4465507.064013 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4527918.73243619 - + 4527918.732436 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4318444.40292735 - + 4318444.402927 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4261849.53926211 - + 4261849.539262 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 3988019.019607 - + 3988019.019607 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 3573426.20589779 - + 3573426.205898 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4023828.1062791 - + 4023828.106279 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4141175.90652158 - + 4141175.906522 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4435995.31360509 - + 4435995.313605 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4973137.29338817 - + 4973137.293388 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 5106598.87797539 - + 5106598.877975 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 5136894.64204166 - + 5136894.642042 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4702569.7504895 - + 4702569.750490 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4767235.96963692 - + 4767235.969637 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4545689.25355982 - + 4545689.253560 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + 4485137.10753685 - + 4485137.107537 - + TRUE - + {=FORECAST.ETS.MULT($BD$36:$BD63,$BF$4:$BF$36,$BD$4:$BD$36,12,1,1)} - + - + 58.048 - + 58.048000 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 72.8878084393463 - + 72.887808 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 65.1161691604337 - + 65.116169 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 78.8999773389802 - + 78.899977 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 88.5042604116374 - + 88.504260 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 87.6933650074125 - + 87.693365 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 100.948503826912 - + 100.948504 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 99.6314373472625 - + 99.631437 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 98.9096428541703 - + 98.909643 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 98.3876468889293 - + 98.387647 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 84.9640709913307 - + 84.964071 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 78.739015079783 - + 78.739015 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 63.7346058009482 - + 63.734606 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 76.3548564418651 - + 76.354856 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 68.2013150391412 - + 68.201315 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 82.6234863486569 - + 82.623486 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 92.664660471513 - + 92.664660 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 91.7995612636688 - + 91.799561 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 105.656992361035 - + 105.656992 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 104.260502046929 - + 104.260502 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 103.487447166156 - + 103.487447 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 102.923796390283 - + 102.923796 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 88.8663355112766 - + 88.866336 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + 82.341584335951 - + 82.341584 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -11929,14 +11981,14 @@ 66.6395978382139 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -11946,14 +11998,14 @@ 79.8219044443839 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -11963,14 +12015,14 @@ 71.2864609178487 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -11980,14 +12032,14 @@ 86.3469953583337 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -11997,14 +12049,14 @@ 96.8250605313886 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12014,14 +12066,14 @@ 95.9057575199251 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12031,14 +12083,14 @@ 110.365480895159 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12048,14 +12100,14 @@ 108.889566746596 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12065,14 +12117,14 @@ 108.065251478142 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12082,14 +12134,14 @@ 107.459945891637 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12099,14 +12151,14 @@ 92.7686000312226 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12116,14 +12168,14 @@ 85.944153592119 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + @@ -12133,27 +12185,27 @@ 69.5445898754795 - + TRUE - + {=FORECAST.ETS.MULT($BI$64:$BI100,$BH$5:$BH$64,$BI$5:$BI$64,12,1,1)} - + - + - + - + @@ -12163,67 +12215,117 @@ - + - + - + - + - + - + - + - + - + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + 4 -- cgit