I am trying to find out the distance between the capital cities of the
following countries. I found this website that looks very similar to
how I would like the final solution presented:
http://www.infoplease.com/ipa/A0759496.html.
However, instead of naming the cities on the left and top of the
spreadsheet, please can you just use each country name in alphabetical
order. Can the distance be in straight line miles, and could I have
the final format be an excel spreadsheet (emailed if your prefer),
that would be excellent. Here are the countries in question:
1 Afghanistan
2 Albania
3 Algeria
4 Angola
5 Argentina
6 Armenia
7 Australia 1
8 Austria
9 Bangladesh
10 Belarus
11 Belgium
12 Benin
13 Bolivia
14 Bosnia and Herzegovina
15 Brazil
16 Bulgaria
17 Burkina Faso
18 Cambodia
19 Cameroon
20 Canada
21 Central African Republic
22 Chad
23 Chile
24 China
25 Colombia
26 Congo
27 Costa Rica
28 Côte d'Ivoire
29 Croatia
30 Cuba
31 Cyprus
32 Czech Republic
33 Denmark
34 Egypt
35 El Salvador
36 Estonia
37 Ethiopia
38 Finland
39 France
40 Gambia
41 Georgia
42 Germany
43 Ghana
44 Greece
45 Greenland
46 Guatemala
47 Guinea
48 Hungary
49 Iceland
50 India
51 Indonesia
52 Iran (Islamic Republic of)
53 Iraq
54 Ireland
55 Israel
56 Italy
57 Jamaica
58 Japan
59 Jordan
60 Kazakhstan
61 Kenya
62 Kuwait
63 Latvia
64 Lebanon
65 Liberia
66 Lithuania
67 Luxembourg
68 Madagascar
69 Malawi
70 Malaysia
71 Mali
72 Malta
73 Mexico
74 Mongolia
75 Morocco
76 Mozambique
77 Namibia
78 Nepal
79 Netherlands
80 New Zealand
81 Niger
82 Nigeria
83 Norway
84 Oman
85 Pakistan
86 Panama
87 Papua New Guinea
88 Paraguay
89 Peru
90 Philippines
91 Poland
92 Portugal
93 Puerto Rico
94 Republic of Korea
95 Republic of Moldova
96 Romania
97 Russian Federation
98 Rwanda
99 Saudi Arabia
100 Senegal
101 Sierra Leone
102 Singapore
103 Slovakia
104 Slovenia
105 Somalia
106 South Africa
107 Spain
108 Sri Lanka
109 Sudan
110 Sweden
111 Switzerland
112 Thailand
113 Tunisia
114 Turkey
115 Uganda
116 Ukraine
117 United Arab Emirates
118 United Kingdom
119 United States of America
120 Unites republic of Tanzania
121 Uruguay
122 Uzbekistan
123 Venezuela
124 Vietnam
125 Yemen
126 Yugoslavia
127 Zambia
128 Zimbabwe
Thank you. |
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 11:35 PDT
Correct me if I'm wrong: you are requesting the distance between the
capital cities of the countries listed and the other capitals of all
the other countries listed? For example you want the distance between
the capital of Afghanistan and the capitals of the remaining 127
countries? And so on?
Best regards,
Rainbow
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 11:48 PDT
Yes please, sorry for being vague. Basically, the same layout as the
website link I gave but it needs to contain all the countries I listed
rather than just their selection. If you feel it warrants a higher
fee please say.
|
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 11:58 PDT
Thank you for your clarification.
I do believe it warrants a much higher fee as this data would take
hours, if not days to compile.
Best regards,
Rainbow
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 12:11 PDT
I have increased the fee (hopefully to a more satisfactory level, I
shall add a generous tip at end). I realise it is a lot of data to
gather but I am very pushed for time and would appreciate you looking
at it soon.
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 12:55 PDT
I just read you spend more time on it if its $100. Please imagine
that it is if the question requires longer and I will be sure to make
the tip exceed that.
|
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 12:57 PDT
How soon do you need this information?
Also please explain this: "please can you just use each country name
in alphabetical order."
Thanks,
Rainbow
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 13:00 PDT
I need this information asap. Sorry for being vague, the alphabetical
order was purely a formatting thing. Like in the instance of the
website, I want the countries to go alphabetically top to bottom (left
hand side of spreadsheet) and alphabetically left to right (top of
spreadsheet). I hope this helps. Thanks.
|
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 13:23 PDT
Hi wrangle,
Upon consideration of the scale of your request, I estimate it will
take me 2-3 days to compile this data (over 16,000 entries). I also
believe the amount of time this research would take deserves a higher
price.
Waiting to hear your views.
Best regards,
Rainbow
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 13:26 PDT
I need time to think of a way around this problem. I appreciate what
you are saying and hadn't quite realised the scale of the problem. In
the mean time, I have a tariff question that is fairly urgent, I just
increased the fee on that a little, but I doubt it will require
anywhere near as much research as the distances question. I will let
you know soon what to do about this question. Thanks a lot for the
quick responses.
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 13:47 PDT
Upon consideration, I realise this was a very time consuming and
arduous task. I would therefore like to cancel the question. I
apologise for wasting your time and if I am allowed to leave some sort
of compensation I shall. Thanks again for trying.
|
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 14:50 PDT
Although not in the layout you have requested, I located this
informative file you may be interested in.
I have saved it in excel format and uploaded it at the following site
for you to download:
http://s57.yousendit.com/d.aspx?id=0JGIIMS9DZA3P10YXF10FGUB8A
Please let me know if this suffices as an answer to your question.
Best wishes,
Rainbow
|
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 14:53 PDT
After posting my previous clarification, I noticed you want to close
the question. Hopefully the file I have provided will help.
Best wishes,
Rainbow
|
Clarification of Question by
wrangle-ga
on
23 Sep 2005 15:19 PDT
I'm not quite sure what to say. I looked at the file and whilst the
data is sort of what I needed, unfortunately it will take far too much
of my time to format to the correct layout, so I will not be able to
use it. I appreciate you taking the time to look for this and feel
that rather than you get nothing by me cancelling the question, I have
re-valued it to a more appropriate level. Thanks again.
|
Request for Question Clarification by
rainbow-ga
on
23 Sep 2005 15:33 PDT
Hi wrangle,
Thank you for your generous offer to pay me for my research. However,
since I have provided you with something you will not use, I feel it
would not be right for me to accept payment.
All the best,
Rainbow
|
