Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates. This would be used with one address as an absolute or constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I am
trying to determine mileage from prospective customer addresses to a possible
store locaion.

Your help is appreciated!

Thanks,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC

That would require some custom programming.

If you use a Windows PC, one thing you may want to try is to use Google
Earth (the downloadable application, not the web-based google maps, which
allows you to enter two addresses and calculate the distance between them.

Again, though, if you wanted to integrate that with Excel, you'd have to
know how to program to call one application. I'm not sure how you would do
that.


--
Brevity is the soul of wit.


"Blue Max" wrote:

Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates. This would be used with one address as an absolute or constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I am
trying to determine mileage from prospective customer addresses to a possible
store locaion.

Your help is appreciated!

Thanks,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC

You could start with Chip Pearson's site below where there are
suggestions for simple great circle distances.

Obviously if you're looking for road distances you probably need some
dedicated software or a web site which will do the calcs for you.

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


HTH

On Wed, 30 Aug 2006 10:53:02 -0700, Blue Max
wrote:

Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates. This would be used with one address as an absolute or constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I am
trying to determine mileage from prospective customer addresses to a possible
store locaion.

Your help is appreciated!

Thanks,

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

I once designed a program called traveltimes where you enter the from city,
st to city state and you get miles and driving times. It uses yahoo maps
query. However, I just tried it and they must have changed something. But,
I'm sure it could be fixed. Take a look here for yahoo maps

http://tinyurl.com/m6asf
--
Don Guillett
SalesAid Software

"Blue Max" wrote in message
...
Does anyone know if there is a function or formula avaialble that can be
used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or
lat/lon
coordinates. This would be used with one address as an absolute or
constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I
am
trying to determine mileage from prospective customer addresses to a
possible
store locaion.

Your help is appreciated!

Thanks,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC

Thanks for the reply Don, I will give it a try! Will let you know if I find
something....
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC




"Don Guillett" wrote:

I once designed a program called traveltimes where you enter the from city,
st to city state and you get miles and driving times. It uses yahoo maps
query. However, I just tried it and they must have changed something. But,
I'm sure it could be fixed. Take a look here for yahoo maps

http://tinyurl.com/m6asf
--
Don Guillett
SalesAid Software

"Blue Max" wrote in message
...
Does anyone know if there is a function or formula avaialble that can be
used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or
lat/lon
coordinates. This would be used with one address as an absolute or
constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I
am
trying to determine mileage from prospective customer addresses to a
possible
store locaion.

Your help is appreciated!

Thanks,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC

Thanks for the reply, Richard! I will followup and let you know of any sucess
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC




"Richard Buttrey" wrote:

You could start with Chip Pearson's site below where there are
suggestions for simple great circle distances.

Obviously if you're looking for road distances you probably need some
dedicated software or a web site which will do the calcs for you.

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


HTH

On Wed, 30 Aug 2006 10:53:02 -0700, Blue Max
wrote:

Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates. This would be used with one address as an absolute or constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I am
trying to determine mileage from prospective customer addresses to a possible
store locaion.

Your help is appreciated!

Thanks,

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Thanks for the reply Dave,

I'll keep working on it and let you know if I find something.
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC




"Dave F" wrote:

That would require some custom programming.

If you use a Windows PC, one thing you may want to try is to use Google
Earth (the downloadable application, not the web-based google maps, which
allows you to enter two addresses and calculate the distance between them.

Again, though, if you wanted to integrate that with Excel, you'd have to
know how to program to call one application. I'm not sure how you would do
that.


--
Brevity is the soul of wit.


"Blue Max" wrote:

Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates. This would be used with one address as an absolute or constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I am
trying to determine mileage from prospective customer addresses to a possible
store locaion.

Your help is appreciated!

Thanks,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC