Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 03:28 AM posted to microsoft.public.excel.worksheet.functions
Wes Lucas
 
Posts: n/a
Default Mileage calculator in EXCEL


Does anyone know of a plugin to compute mileage between two points in EXCEL
2002? I do audits and must travel to many different sites. I'd like to use
a spreadsheet to keep up with expenses including mileage between office and
the audit sites. I've looked at Mapquest, but didn't see anything that
looked promising.

Any help would be appreciated. Thanks.
--
23233-1434

  #2   Report Post  
Old December 12th 05, 11:15 AM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Mileage calculator in EXCEL

check out:

http://office.microsoft.com/en-us/te...884621033.aspx
--
Gary's Student


"Wes Lucas" wrote:


Does anyone know of a plugin to compute mileage between two points in EXCEL
2002? I do audits and must travel to many different sites. I'd like to use
a spreadsheet to keep up with expenses including mileage between office and
the audit sites. I've looked at Mapquest, but didn't see anything that
looked promising.

Any help would be appreciated. Thanks.
--
23233-1434

  #3   Report Post  
Old December 12th 05, 11:30 AM posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default Mileage calculator in EXCEL

On Sun, 11 Dec 2005 18:28:01 -0800, Wes Lucas
wrote:


Does anyone know of a plugin to compute mileage between two points in EXCEL
2002? I do audits and must travel to many different sites. I'd like to use
a spreadsheet to keep up with expenses including mileage between office and
the audit sites. I've looked at Mapquest, but didn't see anything that
looked promising.

Any help would be appreciated. Thanks.



How are your two points defined? Latitude/Longitude or some other grid
system?

Rgds
Richard Buttrey
__
  #4   Report Post  
Old December 12th 05, 02:37 PM posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Mileage calculator in EXCEL

MapPoint can calculate street mileage between two points, and can
be automated from Excel. If you need just the great circle
distance ("as the crow flies"), and your locations are latitude
and longitude data, you can use the formulas found on
www.cpearson.com/excel/latlong.htm to calculate the distance.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wes Lucas" wrote in message
...

Does anyone know of a plugin to compute mileage between two
points in EXCEL
2002? I do audits and must travel to many different sites.
I'd like to use
a spreadsheet to keep up with expenses including mileage
between office and
the audit sites. I've looked at Mapquest, but didn't see
anything that
looked promising.

Any help would be appreciated. Thanks.
--
23233-1434





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
how do i set up a mileage allowance on excel. spannerhappy Excel Discussion (Misc queries) 4 February 3rd 05 07:52 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 09:07 PM


All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017