Public - Example Deseasonalisation Calculations

	A	B	C	D	E	F	G	H
1	Raw Data		Deseasonalisation Process					Xmrit Link
2	Date	Value	Period	Grand Average	Period Average	Seasonal Factor	De-seasonalised Data

3	2020-01-01	242.5	1	389.1	245.30	0.63	384.64
4	2020-02-01	295.1	2		297.27	0.76	386.24
5	2020-03-01	377.9	3		382.67	0.98	384.23
6	2020-04-01	330.6	4		326.35	0.84	394.14
7	2020-05-01	425.0	5		421.90	1.08	391.94
8	2020-06-01	395.3	6		397.75	1.02	386.68
9	2020-07-01	384.3	7		394.00	1.01	379.50
10	2020-08-01	415.8	8		413.35	1.06	391.38
11	2020-09-01	380.8	9		381.80	0.98	388.06
12	2020-10-01	447.9	10		448.85	1.15	388.25
13	2020-11-01	525.0	11		522.85	1.34	390.68
14	2020-12-01	566.6	12		557.85	1.43	395.18
15	2021-01-01	241.0	1		245.30	0.63	382.26
16	2021-02-01	287.2	2		297.27	0.76	375.90
17	2021-03-01	365.0	3		382.67	0.98	371.12
18	2021-04-01	322.1	4		326.35	0.84	384.01
19	2021-05-01	418.8	5		421.90	1.08	386.22
20	2021-06-01	400.2	6		397.75	1.02	391.47
21	2021-07-01	403.7	7		394.00	1.01	398.66
22	2021-08-01	410.9	8		413.35	1.06	386.77
23	2021-09-01	382.8	9		381.80	0.98	390.10
24	2021-10-01	449.8	10		448.85	1.15	389.90
25	2021-11-01	520.7	11		522.85	1.34	387.48
26	2021-12-01	549.1	12		557.85	1.43	382.98
27	2022-01-01	252.4	1		245.30	0.63	400.34
28	2022-02-01	309.5	2		297.27	0.76	405.09
29	2022-03-01	405.1	3		382.67	0.98	411.89
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100