1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Last-Value Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 1 25 45 Quarterly MAD K23
1 2 47 46 45 47 0 MSE K26
1 3 68 45 46 70 2
Quarter Seasonal Factor SeasonalFactor K9:K20
1 4 42 46 45 40 2 1 0.550 SeasonallyAdjustedForecast F6:F35
2 1 27 49 46 26 1 2 1.027 SeasonallyAdjustedValue E6:E35
2 2 46 45 49 50 4 3 1.519 TrueValue D6:D35
2 3 72 47 45 68 4 4 0.904 TypeOfSeasonality K6
2 4 39 43 47 43 41.000
3 1 24 44 43 24 01.000
3 2 49 48 44 45 41.000
3 3 70 46 48 72 21.000
3 4 44 49 46 42 21.000
4 1 #N/A 49 27 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A
5 1 #N/A #N/A Mean Absolute Deviation
5 2 #N/A #N/A MAD = 2.39
5 3 #N/A #N/A
5 4 #N/A #N/A Mean Square Error
6 1 #N/A #N/A MSE = 7.82
6 2 #N/A #N/A
6 3 #N/A #N/A
6 4 #N/A #N/A
7 1 #N/A #N/A
7 2 #N/A #N/A
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
40
41
42
43
44
45
46
47
48
49
50
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Averaging Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 1 25 45 Quarterly MAD K23
1 2 47 46 45 47 0 MSE K26
1 3 68 45 46 69 1
Quarter Seasonal Factor SeasonalFactor K9:K20
1 4 42 46 45 41 1 1 0.550 SeasonallyAdjustedForecast F6:F35
2 1 27 49 46 25 2 2 1.027 SeasonallyAdjustedValue E6:E35
2 2 46 45 46 48 2 3 1.519 TrueValue D6:D35
2 3 72 47 46 70 2 4 0.904 TypeOfSeasonality K6
2 4 39 43 46 42 31.000
3 1 24 44 46 25 11.000
3 2 49 48 46 47 21.000
3 3 70 46 46 70 01.000
3 4 44 49 46 41 31.000
4 1 #N/A 46 25 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A
5 1 #N/A #N/A Mean Absolute Deviation
5 2 #N/A #N/A MAD = 1.57
5 3 #N/A #N/A
5 4 #N/A #N/A Mean Square Error
6 1 #N/A #N/A MSE = 3.07
6 2 #N/A #N/A
6 3 #N/A #N/A
6 4 #N/A #N/A
7 1 #N/A #N/A
7 2 #N/A #N/A
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
40
41
42
43
44
45
46
47
48
49
50
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error periods to consider ForecastingError H6:H35
1 1 25 45 n = 4 MAD K26
1 2 47 46 #N/A MSE K29
1 3 68 45 #N/A
Type of Seasonality NumberOfPeriods K6
1 4 42 46 #N/A Quarterly SeasonalFactor K12:K23
2 1 27 49 46 25 2 SeasonallyAdjustedForecast F6:F35
2 2 46 45 47 48 2
Quarter Seasonal Factor SeasonallyAdjustedValue E6:E35
2 3 72 47 46 70 2 1 0.550 TrueValue D6:D35
2 4 39 43 47 42 3 2 1.027 TypeOfSeasonality K9
3 1 24 44 46 25 1 3 1.519
3 2 49 48 45 46 3 4 0.904
3 3 70 46 45 69 11.000
3 4 44 49 45 41 31.000
4 1 #N/A 47 26 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A 1.000
5 1 #N/A #N/A 1.000
5 2 #N/A #N/A 1.000
5 3 #N/A #N/A
5 4 #N/A #N/A Mean Absolute Deviation
6 1 #N/A #N/A MAD = 2.17
6 2 #N/A #N/A
6 3 #N/A #N/A Mean Square Error
6 4 #N/A #N/A MSE = 5.46
7 1 #N/A #N/A
7 2 #N/A #N/A
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error a = 0.1 Alpha K5
1 1 25 45 46 25 0 ForecastingError H6:H35
1 2 47 46 46 47 0
Initial Estimate InitialEstimate K8
1 3 68 45 46 70 2 Average = 46 MAD K28
1 4 42 46 46 41 1 MSE K31
2 1 27 49 46 25 2
Type of Seasonality SeasonalFactor K14:K25
2 2 46 45 46 47 1 Quarterly SeasonallyAdjustedForecast F6:F35
2 3 72 47 46 70 2 SeasonallyAdjustedValue E6:E35
2 4 39 43 46 42 3
Quarter Seasonal Factor TrueValue D6:D35
3 1 24 44 46 25 1 1 0.550 TypeOfSeasonality K11
3 2 49 48 46 47 2 2 1.027
3 3 70 46 46 70 0 3 1.519
3 4 44 49 46 41 3 4 0.904
4 1 #N/A 46 25 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A 1.000
5 1 #N/A #N/A 1.000
5 2 #N/A #N/A 1.000
5 3 #N/A #N/A 1.000
5 4 #N/A #N/A 1.000
6 1 #N/A #N/A
6 2 #N/A #N/A Mean Absolute Deviation
6 3 #N/A #N/A MAD = 1.42
6 4 #N/A #N/A
7 1 #N/A #N/A Mean Square Error
7 2 #N/A #N/A MSE = 2.75
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
40
41
42
43
44
45
46
47
48
49
50
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
A B C D E F G H I J
Template for Seasonal Factors
True Range Name Cells
Year Quarter Value Type of Seasonality SeasonalFactor G10:G21
1 1 23 Quarterly TrueValue D5:D41
1 2 22 TypeOfSeasonality F5
1 3 31
1 4 26
Estimate for
2 1 19 Quarter Seasonal Factor
2 2 21 1 0.84
2 3 27 2 0.92
2 4 24 3 1.20
3 1 21 4 1.04
3 2 26
3 3 32
3 4 28
4 1
4 2
4 3
4 4
5 1
5 2
5 3
5 4
6 1
6 2
6 3
6 4
7 1
7 2
7 3
7 4
8 1
8 2
8 3
8 4
9 1
9 2
9 3
9 4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Last-Value Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 1 23 27 Quarterly MAD K23
1 2 22 24 27 25 3 MSE K26
1 3 31 26 24 29 2
Quarter Seasonal Factor SeasonalFactor K9:K20
1 4 26 25 26 27 1 1 0.84 SeasonallyAdjustedForecast F6:F35
2 1 19 23 25 21 2 2 0.92 SeasonallyAdjustedValue E6:E35
2 2 21 23 23 21 0 3 1.20 TrueValue D6:D35
2 3 27 23 23 27 0 4 1.04 TypeOfSeasonality K6
2 4 24 23 23 23 11.000
3 1 21 25 23 19 21.000
3 2 26 28 25 23 31.000
3 3 32 27 28 34 21.000
3 4 28 27 27 28 01.000
4 1 #N/A 27 23 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A
5 1 #N/A #N/A Mean Absolute Deviation
5 2 #N/A #N/A MAD = 1.49
5 3 #N/A #N/A
5 4 #N/A #N/A Mean Square Error
6 1 #N/A #N/A MSE = 3.28
6 2 #N/A #N/A
6 3 #N/A #N/A
6 4 #N/A #N/A
7 1 #N/A #N/A
7 2 #N/A #N/A
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
0
5
10
15
20
25
30
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Averaging Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 1 23 27 Quarterly MAD K23
1 2 22 24 27 25 3 MSE K26
1 3 31 26 26 31 0
Quarter Seasonal Factor SeasonalFactor K9:K20
1 4 26 25 26 27 1 1 0.84 SeasonallyAdjustedForecast F6:F35
2 1 19 23 26 21 2 2 0.92 SeasonallyAdjustedValue E6:E35
2 2 21 23 25 23 2 3 1.20 TrueValue D6:D35
2 3 27 23 25 30 3 4 1.04 TypeOfSeasonality K6
2 4 24 23 24 25 11.000
3 1 21 25 24 20 11.000
3 2 26 28 24 22 41.000
3 3 32 27 25 30 21.000
3 4 28 27 25 26 21.000
4 1 #N/A 25 21 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A
5 1 #N/A #N/A Mean Absolute Deviation
5 2 #N/A #N/A MAD = 1.94
5 3 #N/A #N/A
5 4 #N/A #N/A Mean Square Error
6 1 #N/A #N/A MSE = 4.85
6 2 #N/A #N/A
6 3 #N/A #N/A
6 4 #N/A #N/A
7 1 #N/A #N/A
7 2 #N/A #N/A
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
0
5
10
15
20
25
30
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error periods to consider ForecastingError H6:H35
1 1 23 27 n = 4 MAD K26
1 2 22 24 #N/A MSE K29
1 3 31 26 #N/A
Type of Seasonality NumberOfPeriods K6
1 4 26 25 #N/A Quarterly SeasonalFactor K12:K23
2 1 19 23 26 21 2 SeasonallyAdjustedForecast F6:F35
2 2 21 23 24 22 1
Quarter Seasonal Factor SeasonallyAdjustedValue E6:E35
2 3 27 23 24 29 2 1 0.84 TrueValue D6:D35
2 4 24 23 23 24 0 2 0.92 TypeOfSeasonality K9
3 1 21 25 23 19 2 3 1.20
3 2 26 28 23 21 5 4 1.04
3 3 32 27 25 30 21.000
3 4 28 27 26 27 11.000
4 1 #N/A 27 22 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A 1.000
5 1 #N/A #N/A 1.000
5 2 #N/A #N/A 1.000
5 3 #N/A #N/A
5 4 #N/A #N/A Mean Absolute Deviation
6 1 #N/A #N/A MAD = 1.98
6 2 #N/A #N/A
6 3 #N/A #N/A Mean Square Error
6 4 #N/A #N/A MSE = 5.31
7 1 #N/A #N/A
7 2 #N/A #N/A
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G35
Year Quarter Value Value Forecast Forecast Error a = 0.25 Alpha K5
1 1 23 27 25 21 2 ForecastingError H6:H35
1 2 22 24 26 24 2
Initial Estimate InitialEstimate K8
1 3 31 26 25 30 1 Average = 25 MAD K28
1 4 26 25 25 26 0 MSE K31
2 1 19 23 25 21 2
Type of Seasonality SeasonalFactor K14:K25
2 2 21 23 25 23 2 Quarterly SeasonallyAdjustedForecast F6:F35
2 3 27 23 24 29 2 SeasonallyAdjustedValue E6:E35
2 4 24 23 24 25 1
Quarter Seasonal Factor TrueValue D6:D35
3 1 21 25 24 20 1 1 0.84 TypeOfSeasonality K11
3 2 26 28 24 22 4 2 0.92
3 3 32 27 25 30 2 3 1.20
3 4 28 27 25 26 2 4 1.04
4 1 #N/A 26 22 1.000
4 2 #N/A #N/A 1.000
4 3 #N/A #N/A 1.000
4 4 #N/A #N/A 1.000
5 1 #N/A #N/A 1.000
5 2 #N/A #N/A 1.000
5 3 #N/A #N/A 1.000
5 4 #N/A #N/A 1.000
6 1 #N/A #N/A
6 2 #N/A #N/A Mean Absolute Deviation
6 3 #N/A #N/A MAD = 1.66
6 4 #N/A #N/A
7 1 #N/A #N/A Mean Square Error
7 2 #N/A #N/A MSE = 3.56
7 3 #N/A #N/A
7 4 #N/A #N/A
8 1 #N/A #N/A
8 2 #N/A #N/A
0
5
10
15
20
25
30
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A B C D E F G H I J K L M N O P Q R S T U
Template for Exponential-Smoothing with Trend Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Latest Estimated Adjusted Actual Forecasting Smoothing Constant ActualForecast I6:I35
Year Quarter Value Value Trend Trend Forecast Forecast Error a = 0.25 Alpha M5
1 1 23 27 025 21 2b = 0.25 Beta M6
1 2 22 24 1 0 26 24 2 ForecastingError J6:J35
1 3 31 26 0 0 25 30 1Initial Estimate InitialEstimateAverage M9
1 4 26 25 0 0 26 27 1 Average = 25 InitialEstimateTrend M10
2 1 19 23 0 0 25 21 2 Trend = 0 MAD M30
2 2 21 23 -1 025 23 2 MSE M33
2 3 27 23 -1 024 29 2Type of Seasonality SeasonalFactor M16:M27
2 4 24 23 -1 023 24 0 Quarterly SeasonallyAdjustedForecast H6:H35
3 1 21 25 0 0 23 19 2 SeasonallyAdjustedValue E6:E35
3 2 26 28 0 0 23 21 5Quarter Seasonal Factor TrueValue D6:D35
3 3 32 27 1 0 25 29 3 1 0.84 TypeOfSeasonality M13
3 4 28 27 1 0 25 26 2 2 0.92
4 1 #N/A 1 0 26 22 3 1.20
4 2 #N/A #N/A 4 1.04
4 3 #N/A #N/A 1.00
4 4 #N/A #N/A 1.00
5 1 #N/A #N/A 1.00
5 2 #N/A #N/A 1.00
5 3 #N/A #N/A 1.00
5 4 #N/A #N/A 1.00
6 1 #N/A #N/A 1.00
6 2 #N/A #N/A 1.00
6 3 #N/A #N/A
6 4 #N/A #N/A Mean Absolute Deviation
7 1 #N/A #N/A MAD = 1.78
7 2 #N/A #N/A
7 3 #N/A #N/A Mean Square Error
7 4 #N/A #N/A MSE = 4.42
8 1 #N/A #N/A
8 2 #N/A #N/A
0
5
10
15
20
25
30
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Last-Value Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 Jan 68 76 Monthly MAD K23
1 Feb 71 81 76 66 5 MSE K26
1 Mar 66 73 81 73 7
Month Seasonal Factor SeasonalFactor K9:K20
1 Apr 72 77 73 67 5 Jan 0.90 SeasonallyAdjustedForecast F6:F35
1 May 77 80 77 74 3 Feb 0.88 SeasonallyAdjustedValue E6:E35
1 June 85 78 80 87 2 Mar 0.91 TrueValue D6:D35
1 July 94 80 78 91 3 Apr 0.93 TypeOfSeasonality K6
1 Aug 96 83 80 92 4 May 0.96
1 Sep 80 82 83 81 1 June 1.09
1 Oct 73 80 82 75 2 July 1.17
1 Nov 84 80 80 84 0 Aug 1.15
1 Dec 89 82 80 86 3 Sep 0.97
2 Jan #N/A 82 74 Oct 0.91
2 Feb #N/A #N/A Nov 1.05
2 Mar #N/A #N/A Dec 1.08
2 Apr #N/A #N/A
2 May #N/A #N/A Mean Absolute Deviation
2 June #N/A #N/A MAD = 3.07
2 July #N/A #N/A
2 Aug #N/A #N/A Mean Square Error
2 Sep #N/A #N/A MSE = 12.89
2 Oct #N/A #N/A
2 Nov #N/A #N/A
2 Dec #N/A #N/A
3 Jan #N/A #N/A
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
66
68
70
72
74
76
78
80
82
84
86
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Averaging Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 Jan 68 76 Monthly MAD K23
1 Feb 71 81 76 66 5 MSE K26
1 Mar 66 73 78 71 5
Month Seasonal Factor SeasonalFactor K9:K20
1 Apr 72 77 76 71 1 Jan 0.90 SeasonallyAdjustedForecast F6:F35
1 May 77 80 77 73 4 Feb 0.88 SeasonallyAdjustedValue E6:E35
1 June 85 78 77 84 1 Mar 0.91 TrueValue D6:D35
1 July 94 80 77 91 3 Apr 0.93 TypeOfSeasonality K6
1 Aug 96 83 78 89 7 May 0.96
1 Sep 80 82 79 76 4 June 1.09
1 Oct 73 80 79 72 1 July 1.17
1 Nov 84 80 79 83 1 Aug 1.15
1 Dec 89 82 79 86 3 Sep 0.97
2 Jan #N/A 79 71 Oct 0.91
2 Feb #N/A #N/A Nov 1.05
2 Mar #N/A #N/A Dec 1.08
2 Apr #N/A #N/A
2 May #N/A #N/A Mean Absolute Deviation
2 June #N/A #N/A MAD = 3.12
2 July #N/A #N/A
2 Aug #N/A #N/A Mean Square Error
2 Sep #N/A #N/A MSE = 13.07
2 Oct #N/A #N/A
2 Nov #N/A #N/A
2 Dec #N/A #N/A
3 Jan #N/A #N/A
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
66
68
70
72
74
76
78
80
82
84
86
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error periods to consider ForecastingError H6:H35
1 Jan 68 76 n = 3 MAD K26
1 Feb 71 81 #N/A MSE K29
1 Mar 66 73 #N/A
Type of Seasonality NumberOfPeriods K6
1 Apr 72 77 76 71 1 Monthly SeasonalFactor K12:K23
1 May 77 80 77 74 3 SeasonallyAdjustedForecast F6:F35
1 June 85 78 77 84 1
Month Seasonal Factor SeasonallyAdjustedValue E6:E35
1 July 94 80 79 92 2 Jan 0.90 TrueValue D6:D35
1 Aug 96 83 80 91 5 Feb 0.88 TypeOfSeasonality K9
1 Sep 80 82 81 78 2 Mar 0.91
1 Oct 73 80 82 75 2 Apr 0.93
1 Nov 84 80 82 86 2 May 0.96
1 Dec 89 82 81 87 2 June 1.09
2 Jan #N/A 81 73 July 1.17
2 Feb #N/A #N/A Aug 1.15
2 Mar #N/A #N/A Sep 0.97
2 Apr #N/A #N/A Oct 0.91
2 May #N/A #N/A Nov 1.05
2 June #N/A #N/A Dec 1.08
2 July #N/A #N/A
2 Aug #N/A #N/A Mean Absolute Deviation
2 Sep #N/A #N/A MAD = 2.18
2 Oct #N/A #N/A
2 Nov #N/A #N/A Mean Square Error
2 Dec #N/A #N/A MSE = 5.79
3 Jan #N/A #N/A
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error a = 0.2 Alpha K5
1 Jan 68 76 80 72 4 ForecastingError H6:H35
1 Feb 71 81 79 70 1
Initial Estimate InitialEstimate K8
1 Mar 66 73 79 72 6 Average = 80 MAD K28
1 Apr 72 77 78 73 1 MSE K31
1 May 77 80 78 75 2
Type of Seasonality SeasonalFactor K14:K25
1 June 85 78 78 85 0 Monthly SeasonallyAdjustedForecast F6:F35
1 July 94 80 78 92 2 SeasonallyAdjustedValue E6:E35
1 Aug 96 83 79 91 5
Month Seasonal Factor TrueValue D6:D35
1 Sep 80 82 80 77 3 Jan 0.90 TypeOfSeasonality K11
1 Oct 73 80 80 73 0 Feb 0.88
1 Nov 84 80 80 84 0 Mar 0.91
1 Dec 89 82 80 87 2 Apr 0.93
2 Jan #N/A 81 73 May 0.96
2 Feb #N/A #N/A June 1.09
2 Mar #N/A #N/A July 1.17
2 Apr #N/A #N/A Aug 1.15
2 May #N/A #N/A Sep 0.97
2 June #N/A #N/A Oct 0.91
2 July #N/A #N/A Nov 1.05
2 Aug #N/A #N/A Dec 1.08
2 Sep #N/A #N/A
2 Oct #N/A #N/A Mean Absolute Deviation
2 Nov #N/A #N/A MAD = 2.34
2 Dec #N/A #N/A
3 Jan #N/A #N/A Mean Square Error
3 Feb #N/A #N/A MSE = 9.31
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
66
68
70
72
74
76
78
80
82
84
86
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error periods to consider ForecastingError H6:H35
1 Jan 68 76 n = 3 MAD K26
1 Feb 71 81 #N/A MSE K29
1 Mar 66 73 #N/A
Type of Seasonality NumberOfPeriods K6
1 Apr 72 77 76 71 1 Monthly SeasonalFactor K12:K23
1 May 77 80 77 74 3 SeasonallyAdjustedForecast F6:F35
1 June 85 78 77 84 1
Month Seasonal Factor SeasonallyAdjustedValue E6:E35
1 July 94 80 79 92 2 Jan 0.90 TrueValue D6:D35
1 Aug 96 83 80 91 5 Feb 0.88 TypeOfSeasonality K9
1 Sep 80 82 81 78 2 Mar 0.91
1 Oct 73 80 82 75 2 Apr 0.93
1 Nov 84 80 82 86 2 May 0.96
1 Dec 89 82 81 87 2 June 1.09
2 Jan #N/A 81 73 July 1.17
2 Feb #N/A #N/A Aug 1.15
2 Mar #N/A #N/A Sep 0.97
2 Apr #N/A #N/A Oct 0.91
2 May #N/A #N/A Nov 1.05
2 June #N/A #N/A Dec 1.08
2 July #N/A #N/A
2 Aug #N/A #N/A Mean Absolute Deviation
2 Sep #N/A #N/A MAD = 2.18
2 Oct #N/A #N/A
2 Nov #N/A #N/A Mean Square Error
2 Dec #N/A #N/A MSE = 5.79
3 Jan #N/A #N/A
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Last-Value Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 Jan 68 76 Monthly MAD K23
1 Feb 71 81 76 66 5 MSE K26
1 Mar 66 73 81 73 7
Month Seasonal Factor SeasonalFactor K9:K20
1 Apr 72 77 73 67 5 Jan 0.90 SeasonallyAdjustedForecast F6:F35
1 May 77 80 77 74 3 Feb 0.88 SeasonallyAdjustedValue E6:E35
1 June 85 78 80 87 2 Mar 0.91 TrueValue D6:D35
1 July 94 80 78 91 3 Apr 0.93 TypeOfSeasonality K6
1 Aug 96 83 80 92 4 May 0.96
1 Sep 80 82 83 81 1 June 1.09
1 Oct 73 80 82 75 2 July 1.17
1 Nov 84 80 80 84 0 Aug 1.15
1 Dec 89 82 80 86 3 Sep 0.97
2 Jan 75 83 82 74 1 Oct 0.91
2 Feb 76 86 83 73 3 Nov 1.05
2 Mar 81 89 86 79 2 Dec 1.08
2 Apr 84 90 89 83 1
2 May 85 89 90 87 2Mean Absolute Deviation
2 June 99 91 89 97 2 MAD = 2.46
2 July 107 91 91 106 1
2 Aug 108 94 91 105 3Mean Square Error
2 Sep 94 97 94 91 3 MSE = 8.34
2 Oct 90 99 97 88 2
2 Nov 106 101 99 104 2
2 Dec 110 102 101 109 1
3 Jan #N/A 102 92
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
0
20
40
60
80
100
120
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Averaging Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H35
1 Jan 68 76 Monthly MAD K23
1 Feb 71 81 76 66 5 MSE K26
1 Mar 66 73 78 71 5
Month Seasonal Factor SeasonalFactor K9:K20
1 Apr 72 77 76 71 1 Jan 0.90 SeasonallyAdjustedForecast F6:F35
1 May 77 80 77 73 4 Feb 0.88 SeasonallyAdjustedValue E6:E35
1 June 85 78 77 84 1 Mar 0.91 TrueValue D6:D35
1 July 94 80 77 91 3 Apr 0.93 TypeOfSeasonality K6
1 Aug 96 83 78 89 7 May 0.96
1 Sep 80 82 79 76 4 June 1.09
1 Oct 73 80 79 72 1 July 1.17
1 Nov 84 80 79 83 1 Aug 1.15
1 Dec 89 82 79 86 3 Sep 0.97
2 Jan 75 83 79 71 4 Oct 0.91
2 Feb 76 86 80 70 6 Nov 1.05
2 Mar 81 89 80 73 8 Dec 1.08
2 Apr 84 90 81 75 9
2 May 85 89 81 78 7Mean Absolute Deviation
2 June 99 91 82 89 10 MAD = 7.06
2 July 107 91 82 96 11
2 Aug 108 94 83 95 13 Mean Square Error
2 Sep 94 97 83 81 13 MSE = 74.73
2 Oct 90 99 84 76 14
2 Nov 106 101 85 89 17
2 Dec 110 102 85 92 18
3 Jan #N/A 86 77
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
0
20
40
60
80
100
120
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast