ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

6 Free Templates for Microsoft Excel

Updated on May 31, 2011

Use Excel Templates For Address and Zip Code Analysis

Microsoft Excel is a powerful analytical tool that has helped set the standard for both home and business software. Excel templates, which are pre-formatted and automated spreadsheets designed for a particular task, can get you up and running in no time doing anything from bond yield calculations to birthday card design. We're going to highlight here six (free!) Microsoft Excel templates that, working with our software CDXZipStream, will help you get and analyze location-based information such as addresses and zip codes. Just about every organization, from the largest corporation to the corner store to the newest non-profit, needs to manage customer, employee, and competitor location data, and these templates will help you do exactly that.

Optimize Driving Routes - Save Time, Money, and the Environment with Route Optimization

Whether it's a delivery route, sales call schedule, or any other multiple-stop driving route, optimizing the order of stops can pay big dividends in saving employee time and reducing fuel usage. Our free Excel template for route optimization utilizes both CDXZipStream and Microsoft MapPoint to identify the order of intermediate stops that results in the shortest driving time. Just enter the list of addresses for the route into the template, click a button, and the optimized route is returned to the spreadsheet, with total driving time, duration, and cost already calculated. This easy-to-use, economical approach allows for multiple copies to be deployed among field office locations and sales representatives, and since the template can be installed on a laptop and doesn't require internet access, it can work remotely, especially important for last minute route changes. And the optimized route can then be exported to a GPX file that can be used with many GPS systems. View the tutorial to see how easy route optimization can be, both as a cost-saving measure and green initiative:

Zip Code Radius
Zip Code Radius

Find Addresses or Zip Codes Within a Radius

Perform Zip Code Radius Analysis around a Target Zip

Zip code radius analysis can be a critical tool in targeting key customers and competitors, scheduling employees among multiple offices, or identifying optimal store and real estate locations. Just enter the addresses (or even just zip codes) of interest into our Excel radius analysis template, specify the target zip code and radius distance, and the template will automatically filter the addresses, showing only those falling within the radius around the target. Distance calculations are performed based on the centroid (or central) location of each zip code; since this is a very fast calculation, thousands of addresses can be analyzed within a few seconds. For a quick demonstration, please view the YouTube tutorial Zip Code Radius Analysis in an Excel Template .

Calculate Driving Distance, Driving Time, and Cost - Do Driving Calculations Easily for Long Address Lists

This template works with CDXZipStream and Microsoft MapPoint to calculate driving time, driving distance, cost, or total trip duration between two lists of addresses. There's no need to input addresses individually into Google Maps or Mapquest - just copy and paste your address lists into our driving calculation template, which will provide the desired output (time, distance, cost or duration) for each address pair. Input the same address for one of the lists if you need complete driving data around a single location. This is a quick and easy way to validate travel expenses. For a quick overview please watch the tutorial below:

Driving Matrix Template
Driving Matrix Template

Perform Driving Calculations for a Matrix of Locations

Get Distance, Time, and Cost for All Combinations of Routes

Driving calculations in our driving matrix template are expanded to provide data for all combinations of routes between two groups of addresses or zip codes, especially useful for performing feasibility analyses. The input looks like a matrix, with addresses across a row and down a column like the example to the right.

Driving calculations are performed for the routes between Address 1 and Address A, Address 1 and Address B, Address 1 and Address C, etc., until all combinations calculated. This is a quick and easy way to assign driving routes for delivery, taxi, or limousine services. You can view the tutorial Driving Distance and Time for a Matrix of Addresses for more information.

Get Latitude and Longitude (Geocode) Data - Geocode Long Address Lists

Geocode (latitude and longitude) data is now frequently used by businesses to help find and identify current and new customers. The advantages of using geocode data are many, including better accuracy, the ability to calculate distances between points of latitude and longitude, and compatibility with GPS (Global Positioning Systems), now a common feature provided with the iPhone, iPad and many other mobile devices.

Our geocoding template works with CDXZipStream and MapPoint to provide latitude and longitude data for address lists. It can also be used to verify the accuracy of mailing lists based on the quality of the address match to the MapPoint database. Please view our tutorial below to see how it works:

Latitude and Longitude Template
Latitude and Longitude Template

Reverse Geocode

Get the Closest Address for Points of Latitude and Longitude

Working with Microsoft MapPoint, our reverse geocoding template reverse geocodes by finding the closest address to a geocode (latitude and longitude) point. This can be extremely useful for processing points from a gps device. See how easy it is in our tutorial Reverse Geocode Template for Microsoft Excel.

CDXZipStream
CDXZipStream

Try It!

All our templates are compatible with free trials of CDXZipStream and Microsoft MapPoint. CDXZipStream has received numerous awards including the prestigious "5 Cow" award at Tucows.com. We provide complete technical support for both trial and purchased versions. If you decide to buy, pricing starts at $39.95. Quantity discounts and site licensing are also available. Keep in mind CDXZipStream is not a subscription service - you buy it one time and purchase updates only if you need them - and if you aren't happy for any reason within 30 days after purchase, you'll get a full refund.

Bonus - Find the Closest Nuclear Facility - Use Zip Code Radius Analysis to Find Nuclear Plants in the U.S.

To demonstrate a practical application of our zip code radius template, we've input the locations of all U.S. nuclear facilities into the template, allowing for easy identification of plants that fall within a radius distance of a target zip code. See how our nuclear facility radius calculator works in this tutorial:

Tell us what you think ...

    0 of 8192 characters used
    Post Comment

    • profile image

      novalagoon 

      5 years ago

      Nice Share,

      thanks, I'm looking forward to test these templates. I like the videos!

    • profile image

      anonymous 

      5 years ago

      Here its only place where you can get free xbox points:

      FreeXboxPointCodes.com

      its free and you can request for a new code every day :)

      i hope this help.

    • profile image

      anonymous 

      5 years ago

      Here its only place where you can get free xbox points:

      FreeXboxPointCodes.com

      its free and you can request for a new code every day :)

      i hope this help.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)