Like us on FacebookFollow us on Twitter  Find us on Facebook and Twitter





Welcome to the CDXZipStream March 2012 Newsletter

This month we review how to incorporate rising fuel prices into the CDXRouteMP driving cost calculation.  We also cover how to access and use the CDXZipStream Data Examples resource available from the Windows Programs menu.  Here are the latest blog posts from the last month:


  - What You Get with the CDXZipStream Demo

Including Gas Prices in Route Calculations

With average gasoline prices across the U.S. approaching $4 a gallon, and expected to climb to record highs during the upcoming summer, it's important to carefully plan vehicle and other gas usage for your business or organization. Here's how you can use CDXZipStream settings to incorporate fuel prices when calculating transportation costs.


CDXZipStream MapPoint, Basic,and higher versions work in conjunction with Microsoft MapPoint to calculate driving distance, time, and cost. For the most accurate cost calculations, route settings can be based on your particular vehicle miles per gallon performance and current fuel prices.  First, access the MapPoint settings function one of two ways:


- From the CDXZipStream toolbar, click on the "Application Settings" icon (fourth from the left), and click on the Route Settings button, or


- After selecting the rigtht-click function CDXRouteMP from the worksheet, click on the Route Settings button


To set fuel usage click on the Fuel tab.  Input city and highway mpg performance, and specify the appropriate units (miles per gallon, liters per 100 kilometers, etc.) as shown below:


Driving Route Options


Click on the Driving Costs tab and select "Calculate driving costs based on fuel price" and enter the price and appropriate units, e.g. $3.84 per U.S. gallon.  Click OK.


Now you're ready to calculate driving cost.  From the main CDXRouteMP input box, select driving cost as the Route Calculation, or you can also select a Trip Summary output that will include driving cost calculations.


If you prefer to use one of our free, one-click Excel templates for driving calculations, please go to our links page and download the Driving Distance Template.  You can select driving cost as the calculation type.


For more how-to's when doing driving calculations, please see the following short tutorials:

         - Driving Distance Calculator in Excel

         - Driving Distance and Time Calculations in an Excel Template



CDXZipStream Data Examples Resource


When you first install our Excel add-in CDXZipStream, an Excel workbook called DataExamples automatically opens illustrating the range of functionality available with the software.  Since this is typically your first time using CDXZipStream, all these data examples may be a bit hard to digest in one sitting.   So, if you would like to refer to it later, there are a couple of ways to access it:


The DataExamples workbook is stored in the Program Files folder of your root directory, under CDXZipStream.  Go directly to its location (typically C://Program Files/CDXZipStream), or from the Start Menu, select All Programs, then CDXZipStream, and you'll see two versions available, an xls file (for Excel 2003 and lower) and an xlsx file for Excel 2007-2010: 


Here's what's included in the file:


-Direct links to our more popular YouTube video tutorials.  You can also view all our videos at our CDXZipStream channel.


-Example data from all the data fields associated with our demographic feeds (based on zip code, city, county, state, area code, and CBSA or Core-Based Statistical Area.)


-Examples of how to create location, route, and radius maps.


-Instructions and examples of all CDXZipStream right-click functions (CDXDistance, CDXRouteMP, CDXLocateMP, CDXDistance2WP, CDXRadius, CDXZiplist, CDXFindZip, CDXClosestZip)


Please also refer to additional resources available through our links page.


March Data Updates


Canadian and U.S. data feeds were updated as of March 29.  There were 85 changes to the U.S. zip code database.  If you would like to update your database to reflect these changes, click on the "License Information and Software Updates" icon on the CDXZipStream toolbar, and select "Data Updates" to login to your account.  If you've forgotten your user name or password, please contact us at


We hope you find the information here helpful for you and your organization.  Please contact us with your feedback and suggestions by replying to this email.


The Team at CDX Technologies 


March 2012



Map of the World


In This Issue 

Including Gas Prices in Route Calculations 


CDXZipStream Data Example Resource 


March Data Updates 












CDX Technologies | 2 West Hanover Avenue | Suite 212 | Randolph | NJ | 07869