danielhitch
New Member
- Joined
- Sep 8, 2008
- Messages
- 48
Hi.
I will start off by stating what I want to achieve.
I do a lot of road collision analysis at work and I want to be able to plot accident locations in Google Earth.
I have put together a spreadsheet that has the collision locations in an OS Grid Reference form (Eastings & Northings). Google Earth works in Latitude & Longitude values so I cannot just drop the data into Google Earth.
The conversion process from Eastings & Northings to Latitude & Longitude is one hell of a mathematical process and one in which I dont think can be done easily in a single excel cell.
I have found a spreadsheet which offers the capability of converting East/North into Lat/Long but only one set at a time. (see below):
http://www.ordnancesurvey.co.uk/gps/osnetfreeservices/furtherinfo/spreadsheet.html
I have got tens of thousands of co-ordinates to convert so this isnt a practical option hence question number 1:
1) Can the above spreadsheet be adapted to automate the process for all co-ordinates?
If the above can be done, there is then another problem that I to deal with.
Google Earth can plot points but it uses its own file convention (KML). From detailed research on the internet, I have found that it is a form of XML document. Here comes question number 2:
2) Is there a way of converting the excel spreadsheet to a KML file?
Whilst my knowledge of Excel is relatively good, my knowledge of VBA runtimes is nil so all help will be greatly recieved!!
Thanks!!
- Dan
I will start off by stating what I want to achieve.
I do a lot of road collision analysis at work and I want to be able to plot accident locations in Google Earth.
I have put together a spreadsheet that has the collision locations in an OS Grid Reference form (Eastings & Northings). Google Earth works in Latitude & Longitude values so I cannot just drop the data into Google Earth.
The conversion process from Eastings & Northings to Latitude & Longitude is one hell of a mathematical process and one in which I dont think can be done easily in a single excel cell.
I have found a spreadsheet which offers the capability of converting East/North into Lat/Long but only one set at a time. (see below):
http://www.ordnancesurvey.co.uk/gps/osnetfreeservices/furtherinfo/spreadsheet.html
I have got tens of thousands of co-ordinates to convert so this isnt a practical option hence question number 1:
1) Can the above spreadsheet be adapted to automate the process for all co-ordinates?
If the above can be done, there is then another problem that I to deal with.
Google Earth can plot points but it uses its own file convention (KML). From detailed research on the internet, I have found that it is a form of XML document. Here comes question number 2:
2) Is there a way of converting the excel spreadsheet to a KML file?
Whilst my knowledge of Excel is relatively good, my knowledge of VBA runtimes is nil so all help will be greatly recieved!!
Thanks!!
- Dan