Test - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	R	S	T	U	V	W
1	Date	Traction	Headcode	Time	From	Destination	Miles	Chains		Carriage	TOC	Class	Month / Year	Year					80
2									.
3									.
4									.
5									.
6									.
7	14/04/2022	220027	1G91	21:27	Manchester Piccadilly	Stafford	54	01	54.01	60227	Cross Country	220	Apr 2022	2022	Unique Traction	Total Journeys	Total Miles	Total Chains	Chains/80	Miles.Chains
8	14/04/2022	150150	2K83	20:10	Bolton	Manchester Piccadilly	11	20	11.20	57150	Northern Trains	150	Apr 2022	2022	150150	1	11	20	0.2	11.20
9	24/03/2022	390044	1A65	18:47	Liverpool Lime Street	Stafford	60	02	60.02	69944	Avanti West Coast	390	Mar 2022	2022	175103	1	39	69	0.69	39.69
10	24/03/2022	390141	1F12	09:27	Stafford	Liverpool Lime Street	59	66	59.66	68941	Avanti West Coast	390	Mar 2022	2022	195130	1	18	0		18.00
11	09/03/2022	221108	9M61	20:51	Crewe	Stafford	24	37	24.37	60858	Avanti West Coast	221	Mar 2022	2022	220027	1	54	0		54.00
12	09/03/2022	390127	1M18	20:23	Warrington Bank Quay	Crewe	24	11	24.11	68927	Avanti West Coast	390	Mar 2022	2022	221108	1	24	37	0.37	24.37
13	09/03/2022	195130	1E 76	19:22	Chester	Warrington Bank Quay	18	01	18.01	102130	Northern Trains	195	Mar 2022	2022	221119	1	30	71	0.71	30.71
14	09/03/2022	175103	1D32	17:52	Manchester Piccadilly	Chester	39	69	39.69	50753	Transport for Wales	175	Mar 2022	2022	390044	1	60	0		60.00
15	14/01/2022	221119	1M42	13:26	Coventry	Wolverhampton	30	71	30.71	60369	Cross Country	221	Jan 2022	2022	390127	1	24	11	0.11	24.11
16	14/01/2022	390134	1B46	12:50	Birmingham New Street	Coventry	18	74	18.74	68934	Avanti West Coast	390	Jan 2022	2022	390134	1	18	74	0.74	18.74
17									.						390141	1	59	66	0.66	59.66
18									.							0	0	0
19									.							0	0	0
20									.							0	0	0
21									.							0	0	0
22									.							0	0	0
23									.							0	0	0
24									.							0	0	0
25									.							0	0	0
26									.							0	0	0
27									.							0	0	0
28									.							0	0	0
29									.							0	0	0
30									.							0	0	0
31									.							0	0	0
32									.							0	0	0
33									.							0	0	0
34									.							0	0	0
35									.							0	0	0
36									.							0	0	0
37									.							0	0	0
38									.							0	0	0
39									.							0	0	0
40									.							0	0	0
41									.							0	0	0
42									.							0	0	0
43									.							0	0	0
44									.							0	0	0
45									.							0	0	0
46									.							0	0	0
47									.							0	0	0
48									.							0	0	0
49									.							0	0	0
50									.							0	0	0
51									.							0	0	0
52									.							0	0	0
53									.							0	0	0
54									.							0	0	0
55									.							0	0	0
56									.							0	0	0
57									.							0	0	0
58									.							0	0	0
59									.							0	0	0
60									.							0	0	0
61									.							0	0	0
62									.							0	0	0
63									.							0	0	0
64									.							0	0	0
65									.							0	0	0
66									.							0	0	0
67									.							0	0	0
68									.							0	0	0
69									.							0	0	0
70									.							0	0	0
71									.							0	0	0
72									.							0	0	0
73									.							0	0	0
74									.							0	0	0
75									.							0	0	0
76									.							0	0	0
77									.							0	0	0
78									.							0	0	0
79									.							0	0	0
80									.							0	0	0
81									.							0	0	0
82									.							0	0	0
83									.							0	0	0
84									.							0	0	0
85									.							0	0	0
86									.							0	0	0
87									.							0	0	0
88									.							0	0	0
89									.							0	0	0
90									.							0	0	0
91									.							0	0	0
92									.							0	0	0
93									.							0	0	0
94									.							0	0	0
95									.							0	0	0
96									.							0	0	0
97									.							0	0	0
98									.							0	0	0
99									.							0	0	0
100									.							0	0	0