CUTTING EDGE CASE

Exponential with Trend

Template for Exponential Smoothing Forecasting Method with Trend
					Exponential						Range Name	Cells
	Time	True	Latest	Estimated	Smoothing	Forecasting					Alpha	J6
	Period	Value	Trend	Trend	Forecast	Error		Smoothing Constants			Beta	J7
	1	6,809		0.00	7,500	691		a =	0.3		EstimatedTrend	E6:E35
	2	6,465	-207.30	-62.19	7,231	766		b =	0.3		Forecast	F6:F35
	3	6,569	-291.84	-131.09	6,870	301					ForecastingError	G6:G35
	4	8,266	-221.32	-158.16	6,621	1,645		Initial Estimates			InitialEstimateAverage	J10
	5	7,257	335.23	-10.14	7,105	152		Average =	7,500		InitialEstimateTrend	J11
	6	7,064	35.57	3.57	7,154	90		Trend =	0		LatestTrend	D6:D35
	7	7,784	-23.40	-4.52	7,122	662					MAD	J14
	8	8,724	193.95	55.02	7,376	1,348		Mean Absolute Deviation			MSE	J17
	9	6,992	459.45	176.35	7,957	965		MAD =	833.4		TrueValue	C6:C35
	10	6,822	-113.06	89.53	7,757	935
	11	7,949	-190.92	5.40	7,482	467		Mean Square Error
	12	9,650	145.57	47.45	7,669	1,981		MSE =	1,007,557.6
	13		641.63	225.70	8,489
	14				ERROR:#N/A
	15				ERROR:#N/A
	16				ERROR:#N/A
	17				ERROR:#N/A
	18				ERROR:#N/A
	19				ERROR:#N/A
	20				ERROR:#N/A
	21				ERROR:#N/A
	22				ERROR:#N/A
	23				ERROR:#N/A
	24				ERROR:#N/A
	25				ERROR:#N/A
	26				ERROR:#N/A
	27				ERROR:#N/A
	28				ERROR:#N/A
	29				ERROR:#N/A
	30				ERROR:#N/A

True Value 6809 6465 6569 8266 7257 7064 7784 8724 6992 6822 7949 9650 Forecast 7500 7230.51 6869.7710999999999 6621.3844709999994 7104.6292283099983 7153.9139278790981 7122.4209640683484 7375.918002634673 7956.6933093939788 7756.8136262800344 7481.7646217350712 7669.38150259744 8489.2689839673294 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A

Time Period

Value