ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
1If you wish to filter, alter currencies or view hidden columns where additional calculations can be found, the first thing you'll need to do is 'Make a copy' of the original sheet. You can do this from the file menu...
3
4
2Once a copy is made you will be able to filter by your own geographical region if you so choose. You can do this by selecting the filter in column D and either deselecting the regions you do not wish to be included in the list, or clicking 'clear' then selecting the region or regions you wish to view
5
6
3If you wish to view the list in your own local currency rather than USD, select if from the dropdown menu in column L. Note that the USD conversions in column J will stay in USD, but column L will change to whatever currency you select (converted back from USD)
7
8
4Note that no matter how you re-order or filter the list the worldwide ranking will remain constant. If you were to look at just Caribbean countries, for example, the ranking numbers in column A would still represent the rank of each country worldwide, not the rank within the region. Likewise, if you were to reorder the list most expensive first (or even alphabetically) the numbers in column A will always count from 1 upwards...
9
10
5Hopefully all of this makes sense, but if you have any questions, please don't heistate to ask via email: eran@existent.co.uk
11
12
13
14
15
16
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