Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
how do i set up a mileage allowance on excel. | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |