FINAL.PROJECT.xlsx

	A	B	C	D	E	F	G	H	L	M	T	U	W	X
1	Total Revenue	Peak_Trips_Percentage	Total Journeys	Average Ticket Price	Delay Rate %	Delayed Journeys	Top_Route_Name
2	741٫9K	58٫70%	31٫7K	23٫44	7٫18%	2274	London Kings Cross
3
4
5
6	Row Labels	Total Revenue					Row Labels	Total Revenue
7	April	$187٬782٫00					First Class	$149٬399٫00
8	February	$159٬374٫00					Standard	$592٬522٫00			Row Labels	Total Revenue	Row Labels	Total Revenue
9	January	$199٬618٫00					Grand Total	$741٬921٫00			Jan	308٫1K	Jan	308٫1K
10	March	$195٬147٫00									Feb	50٫7K	Feb	50٫7K
11	Grand Total	$741٬921٫00									Mar	194٫5K	Mar	194٫5K
12											Apr	182٫1K	Apr	182٫1K
13											Dec	6٫5K	Dec	6٫5K
14											Grand Total	741٫9K	Grand Total	741٫9K
15									Row Labels	Total Revenue
16									Online	$382٬754٫00
17	Row Labels	Total Revenue		Row Labels	Total Revenue				Station	$359٬167٫00
18	First Class			First Class					Grand Total	$741٬921٫00
19	Advance	$66٬886٫00		Advance	$66٬886٫00
20	Anytime	$37٬841٫00		Anytime	$37٬841٫00
21	Off-Peak	$44٬672٫00		Off-Peak	$44٬672٫00
22	Standard			Standard
23	Advance	$242٬388٫00		Advance	$242٬388٫00
24	Anytime	$171٬468٫00		Anytime	$171٬468٫00
25	Off-Peak	$178٬666٫00		Off-Peak	$178٬666٫00
26	Grand Total	$741٬921٫00		Grand Total	$741٬921٫00
27
28
29
30
31
32
33
34
35
36	Row Labels	Count of Transaction ID
37	0	853
38	1	644
39	2	942
40	3	543
41	4	1041
42	5	725
43	6	3112
44	7	2795
45	8	2179
46	9	1230
47	10	525
48	11	1143
49	12	773
50	13	1276
51	14	855
52	15	1220
53	16	2301
54	17	2888
55	18	3113
56	19	438
57	20	1058
58	21	570
59	22	788
60	23	641
61	Grand Total	31653
62
63
64
65
66
67	Row Labels	Total Revenue	Number of Passengers
68	Evening Peak	179٫3K	8٫7K
69	Morning Peak	308٫4K	9٫8K
70	Off-Peak	254٫3K	13٫1K
71	Grand Total	741٫9K	31٫7K
72
73
74
75
76
77
78
79
80	Row Labels	Total Revenue
81	London Kings Cross	199٫7K
82	Liverpool Lime Street	135٫3K
83	London Euston	112٫K
84	London Paddington	83٫8K
85	Manchester Piccadilly	75٫3K
86	London St Pancras	63٫K
87	Birmingham New Street	38٫1K
88	York	19٫5K
89	Reading	10٫1K
90	Oxford	2٫9K
91	Edinburgh Waverley	2٫1K
92	Bristol Temple Meads	98
93	Grand Total	741٫9K
94
95
96
97
98	--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
99
100