Driving Distance and Time Calculations Using Microsoft Excel and MapPoint

Document Sample
Driving Distance and Time Calculations Using Microsoft Excel and MapPoint Powered By Docstoc
					Microsoft Excel "custom functions" are available to carry out and about many tasks pertaining to address
and zip-code based details, such just as importing demographic file, checking address accuracy, actually
identifying zip codes within a radius. Popular are discussed within the EzineArticle "Using Microsoft Excel
to be able to Manage Mailing Lists" by great colleague, Ian Roberts. Custom functions, additionally referred
to be able to as User Defined Functions (UDFs), perform complicated calculations on the other hand tasks
and are popular in pv cell formulas just simply like the standard Excel functions SUM, POPULAR,
LOOKUP, and many others. In this kind of article we may review exactly how custom functions may also
be used for calculating driving distance and driving period between addresses stated in the best Excel
worksheet. Let's say we have lists with addresses in Excel that need analysis based with driving distance,
driving period, or equally. Such the best analysis might support a variety with purposes - to be able to
estimate shipping costs towards your business, optimize delivery service plan routes, actually help strategy
sales calls. We are most likely familiar with internet-based mapping providers such just as MapQuest on the
other hand Google Maps in which you input begin and end items to obtain driving guidance, mileage, and
estimated driving period. This happens fine for a one pair with addresses, but for more substantial sets with
data the best automated approach is essential. A custom feature working in conjunction which includes a
mapping program together with Microsoft MapPoint could very well calculate driving distance on the other
hand time for numerous route preferences (such just as shortest distance on the other hand quickest driving
time) and automatically return the result in your Excel worksheet. It isn't needed to learn on a application,
since every one interactions with MapPoint happen within the background; we work only within the popular
Excel environment. As an example, to calculate driving period between addresses stated in worksheet cells
A1 and B1, simply input the best custom feature formula (inserted in pv cell C1, for instance) on a would
look some thing like this kind of: "= CustomFunction (A1, B1)". In case you have multiple pairs with
addresses in columns A and B, just copy and paste this kind of formula just as needed in column H - in that
way you could automatically obtain driving distance on the other hand time for literally thousands with sets
with addresses, without the time-consuming manuals input needed for popular mapping programs. This kind
of function could also calculate routes with particular stopping items along the best, to simulate a real-life
delivery route, as an example. In this kind of case, just list the addresses according to be able to their order
over the route, in a custom feature formula such just as "= CustomFunction (Address one, Address *,
Address a few, etc. )". To be able to optimize the route, you could change the address order to be able to see
the result on driving distance on the other hand time. In predicaments where exact addresses are not
attainable, custom functions could also return driving period or distance utilizing more primary addresses
based with street name, city, on the other hand zip code. The route computation uses the geographic center
in the given address. Address types use not need to be able to be reliable within a one custom feature
formula. Associated with valid addresses are: "20015" "Louisville, KY" "Washington Street 02121". To be
able to sum high, this certainly excellent example with how custom functions in Excel could very well tap in
to the run of additional programs, such just as Microsoft MapPoint, while allowing person to deliver the
results within the popular Excel environment. Coming from checking the accuracy with mailing lists to be
able to calculating driving distance and period, it's relatively easy to understand how custom functions may
be valuable equipment for analyzing address details in Excel.

continue reading

lurklot lurklot http://