I am looking for an Excel formula that I can use to convert Longitude
& Latitude to Vertical & Horizontal Coordinates? If you are not
aware, Vertical & Horizontal (V&H) Coordinates are used by the Bell
Operating Companies to help determine airline miles between Central
Offices.

Thanks,


Bill

Bill,

Could this page be a pointer in the right direction?

http://www.cpearson.com/excel/latlong.ht

--
Message posted from http://www.ExcelForum.com

Kieran, what you pointed me to is what I found but I now need to
convert Lon & Lat to V & H. Any idea?

Thanks,

Bill


Kieran wrote in message ...
Bill,

Could this page be a pointer in the right direction?

http://www.cpearson.com/excel/latlong.htm


---
Message posted from http://www.ExcelForum.com/

By V&H do you mean UTM coordinates (metres or feet)?

Kenneth Cruikshank at Portland State University has an excellent (pun
intended) work sheet.

http://geomechanics.geol.pdx.edu/

I converted over 50,000 points in one spread sheet.


"Bill" wrote:

Kieran, what you pointed me to is what I found but I now need to
convert Lon & Lat to V & H. Any idea?

Thanks,

Bill


Kieran wrote in message ...
Bill,

Could this page be a pointer in the right direction?

http://www.cpearson.com/excel/latlong.htm


---
Message posted from http://www.ExcelForum.com/