Solved

Converting Grid Reference to Latitude+Longitude Info

Posted on 2014-03-01
4
444 Views
Last Modified: 2014-06-04
Hi ,

How can I convert Grid Reference to Latitude+Longitude Info.

Can you share me the formula or ..

VBA Code to enable in the worksheet...

I am attaching a sample file...
LATLONG-GRID.xlsx
0
Comment
Question by:sunil1982
4 Comments
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 20 total points
ID: 39897588
I think you ought to ask this question in the maths forum and not in excel forum.

In any case, the coordinates you have provided are connected to a local system and you have to provide the parameters of that local system to be able to convert to the longitude/latitude.
0
 
LVL 5

Assisted Solution

by:Lawrence Barnes
Lawrence Barnes earned 240 total points
ID: 39897704
Without a grid reference point and and scale there is not a way to correlate this to latitude/longitude.  Below is an article explaining how this could be done manually.

http://www.ehow.com/how_8788145_convert-grid-coordinates-latitude-longitude.html
0
 
LVL 32

Accepted Solution

by:
Rob Henson earned 240 total points
ID: 39900179
0
 

Author Closing Comment

by:sunil1982
ID: 40113711
All are just information only, no proper solution
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now