Mock up.xlsx

	A	B	C	D	E	F	G
1	Customer	Type	Serial Number	2022 Usage	2022 Read date	2023 Usage	2023 Read Date
2	Customer A	Type A	A123	10000	19/12/2022	14200	1/11/2023
3	Customer A	Type A	A225	2500	19/12/2022	3000	1/11/2023
4	Customer B	Type A	A369	3000	19/12/2022	5000	14/11/2023
5	Customer B	Type B	B001	50000	19/12/2022	51000	10/10/2023
6	Customer B	TypeC	C991	6500	19/12/2022	7000	10/10/2023
7	Customer C	Type D	D523	7000	5/5/2022	9500	14/9/2023
8	Customer C	Type D	D555	18000	18/11/2022	20000	14/9/2023
9	Customer D	Type B	B269	55000	7/10/2022	55050	5/8/2023
10	Customer D	Type B	B756	50	7/10/2022	3000	5/8/2023
11	Customer D	Type B	B698	8000	7/10/2022	8500	31/3/2023
12	Customer D	Type B	B548	9500	6/6/2022	11000	4/7/2023
13	Customer D	Type B	B221	40000	6/6/2022	41000	4/7/2023
14	Customer E	Type A	A002	45000	1/2/2022	48000	30/11/2023
15	Customer E	Type A	A589	30000	1/3/2022	32000	25/11/2023
16	Customer E	Type A	A698	3500	24/4/2022	5000	25/11/2023
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
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