Data.xlsx

	A	B	C	D	G	H
1	Available Data				Expected Result
2	Financial Year	Month	Week	Score	Month-Week	4 weeks moving average
3	2021-22	6	W26	26	6-W26
4	2021-22	6	W27	22	6-W27
5	2021-22	7	W27	15	7-W27
6	2021-22	7	W28	30	7-W28	23.25
7	2021-22	7	W29	29	7-W29	24
8	2021-22	7	W30	16	7-W30	22.5
9	2021-22	7	W31	14	7-W31	22.25
10	2021-22	8	W32	20	8-W32	19.75
11	2021-22	8	W33	30	8-W33	20
12	2021-22	8	W34	19	8-W34	20.75
13	2021-22	8	W35	15	8-W35	21
14	2021-22	8	W36	28	8-W36	23
15	2021-22	9	W36	27	9-W36	22.25
16	2021-22	9	W37	23	9-W37	23.25
17	2021-22	9	W38	27	9-W38	26.25
18	2021-22	9	W39	24	9-W39	25.25
19	2021-22	9	W40	19	9-W40	23.25
20	2021-22	10	W40	15	10-W40	21.25
21	2021-22	10	W41	30	10-W41	22
22	2021-22	10	W42	15	10-W42	19.75
23	2021-22	10	W43	18	10-W43	19.5
24	2021-22	10	W44	14	10-W44	19.25
25	2021-22	11	W45	26	11-W45	18.25
26	2021-22	11	W46	24	11-W46	20.5
27	2021-22	11	W47	14	11-W47	19.5
28	2021-22	11	W48	12	11-W48	19
29	2021-22	11	W49	18	11-W49	17
30	2021-22	12	W49	28	12-W49	18
31	2021-22	12	W50	17	12-W50	18.75
32	2021-22	12	W51	15	12-W51	19.5
33	2021-22	12	W52	19	12-W52	19.75
34	2021-22	12	W53	13	12-W53	16
35	2021-22	1	W2	18	1-W2	16.25
36	2021-22	1	W3	20	1-W3	17.5
37	2021-22	1	W4	25	1-W4	19
38	2021-22	1	W5	21	1-W5	21
39	2021-22	1	W6	20	1-W6	21.5
40	2022-23	6	W26	28	6-W26
41	2022-23	6	W27	16	6-W27
42	2022-23	7	W27	18	7-W27
43	2022-23	7	W28	16	7-W28	19.5
44	2022-23	7	W29	15	7-W29	16.25
45	2022-23	7	W30	18	7-W30	16.75
46	2022-23	7	W31	24	7-W31	18.25
47	2022-23	8	W32	13	8-W32	17.5
48	2022-23	8	W33	27	8-W33	20.5
49	2022-23	8	W34	16	8-W34	20
50	2022-23	8	W35	24	8-W35	20
51	2022-23	8	W36	12	8-W36	19.75
52	2022-23	9	W36	25	9-W36	19.25
53	2022-23	9	W37	17	9-W37	19.5
54	2022-23	9	W38	19	9-W38	18.25
55	2022-23	9	W39	19	9-W39	20
56	2022-23	9	W40	16	9-W40	17.75
57	2022-23	10	W40	29	10-W40	20.75
58	2022-23	10	W41	14	10-W41	19.5
59	2022-23	10	W42	19	10-W42	19.5
60	2022-23	10	W43	16	10-W43	19.5
61	2022-23	10	W44	25	10-W44	18.5
62	2022-23	11	W45	20	11-W45	20
63	2022-23	11	W46	14	11-W46	18.75
64	2022-23	11	W47	18	11-W47	19.25
65	2022-23	11	W48	26	11-W48	19.5
66	2022-23	11	W49	17	11-W49	18.75
67	2022-23	12	W49	16	12-W49	19.25
68	2022-23	12	W50	29	12-W50	22
69	2022-23	12	W51	16	12-W51	19.5
70	2022-23	12	W52	16	12-W52	19.25
71	2022-23	12	W53	30	12-W53	22.75
72	2022-23	1	W2	27	1-W2	22.25
73	2022-23	1	W3	30	1-W3	25.75
74	2022-23	1	W4	21	1-W4	27
75	2022-23	1	W5	12	1-W5	22.5
76	2022-23	1	W6	25	1-W6	22
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100