examples-of-index-functions-step-by-step.xlsx

	A	B	C	D	E	F	G
1
2		City
3	1	Cambridge
4	2	Manchester
5	3	London
6	4	Oxford
7	5	Liverpool
8
9		Manchester
10
11		1	2
12		City	Tourists, 2017
13	1	Cambridge	1 732
14	2	Manchester	564
15	3	London	11 345
16	4	Oxford	3 909
17	5	Liverpool	5 478
18
19		5 478
20
21
22		1	2			1	2
23		City of Great Britain	Tourists, 2017			City of France	Tourists, 2017
24	1	Cambridge	1 732		1	Marseille	2 456
25	2	Manchester	564		2	Liyon	1 987
26	3	London	11 345		3	Nice	4 561
27	4	Oxford	3 909		4	Naunnt	2 534
28	5	Liverpool	5 478		5	Paris	9 755
29
30		1	2
31		City of Italy	Tourists, 2017			Find: number of visitors in the city of Nice country France/number of visitors in the third row of the second column of the second table:
32	1	Rome	12 545
33	2	Milan	9 611
34	3	Naples	5 499
35	4	Turin	6 455			#ERROR!
36	5	Genoa	7 112
37
38
39
40
41			1	2	3
42		City of Great Britain	Tourists, 2017	Tourists, 2018	Tourists, 2019
43	1	Cambridge	1 732	17 645	2 331
44	2	Manchester	564	786	1 124
45	3	London	11 345	13 878	15 454
46	4	Oxford	3 909	4 356	6 880
47	5	Liverpool	5 478	4 322	7 698
48
49
50		sum of values for 2018:		40 987
51
52		sum of values for the city of Manchester for the entire period:
53				2 474
54
55
56			1	2	3
57		City of Great Britain	Tourists, 2017	Tourists, 2018	Tourists, 2019
58	1	Cambridge	1 732	17 645	2 331
59	2	Manchester	564	786	1 124
60	3	London	11 345	13 878	15 454
61	4	Oxford	3 909	4 356	6 880
62	5	Liverpool	5 478	4 322	7 698
63
64		Tourists in the first		3	cities:	13 641
65
66
67
68		Oxford tourists in the first		2	years	9 800
69
70
71
72
73		Tourists, 2017	City of Great Britain
74		1 732	Cambridge
75		564	Manchester
76		11 345	London
77		3 909	Oxford
78		5 478	Liverpool
79
80		Cambridge	1 732
81
82
83
84
85						value	criterion
86
87		Good	Quantity			Price/pack	Good
88		Hepilor	3	86,90		5,50	Ascorbin
89		Picolax	2	28,00		42,00	Levomekol
90		Revit	5	21,00		66,90	Nurofen
91		Amizon	6	105,30		33,00	Citramon
92		Cratal	19	83,00		44,00	Novirin
93		Corvalment	21	33,00		45,80	Atoxil
94		Ascorbin	6	5,50		86,90	Hepilor
95		Levomekol	4	42,00		28,00	Picolax
96		Nurofen	12	66,90		21,00	Revit
97		Citramon	14	33,00		105,30	Amizon
98		Novirin	7	44,00		83,00	Cratal
99		Atoxil	9	45,80		33,00	Corvalment
100