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





Welcome to the CDXZipStream October 2014 Newsletter


This month we look at how you can use the "Find nearby places" functionality of MapPoint to find a custom list of points along a driving route.  This can be done entirely within the MapPoint software.  We also provide some tips on how to protect Microsoft Excel from freezing when working with a large amount of data from CDXZipStream or CDXStreamer.


Our most recent blog articles:


Location-Based Marketing and Advertising

In the Spotlight: Right-click Function CDXLocateMP

Using MapPoint to Find Points Along a Route

As mentioned in previous newsletters, Microsoft will stop selling MapPoint at the end of this year, and we are now evaluating alternatives to MapPoint for CDXZipStream versions that perform driving calculations, route optimization, mapping, and geocoding.    Keep in mind that the retirement of MapPoint will not affect software already installed.  You can indefinitely continue to use Microsoft MapPoint as a stand-alone software and in conjunction with CDXZipStream.


MapPoint does (did?) provide a lot of bang for the buck, and for those of you who own it, we'd like to highlight here the "Find nearby places" functionality available from the main MapPoint toolbar.  This can be used to find nearby points along a specified driving route, which works not only for the points of interest in the MapPoint database, but for locations you can import into the software.  This kind of customized road trip planning can be done with some effort using GPS systems, but with MapPoint it can be done very easily in just a few steps (and no .gpx files are required):


1.  First, import your points of interest into MapPoint.  From the "Data" drop-down menu, select "Import Data Wizard" (which is compatible with Excel, Access, csv or text files) and follow the step-by-step instructions. Data can be in address form or latitude/longitude; just make sure to label the data columns correctly.  When you're done the points will be displayed as pushpins in the MapPoint map.  


2.  Specify the driving route.  Select "Display the route planner" from the MapPoint toolbar, and enter the beginning and end points of the route along with any intermediate stops.  Select "Get directions" and the route will now display on the map.  More than one route can also be entered.


3. Select "Find nearby places" on the MapPoint toolbar.  From here you can specify the search distance from the driving route in miles, specify the route from the dropdown list, and select whether the found points will be listed in alphabetical order or by distance from the route. 


Select "Refresh" and the points along the route within the specified search distance will be listed.  If the list also shows points of interest provided by MapPoint, select "Categories" to remove this data from the analysis.


How to Keep Excel Running Smoothly

 If Excel sometimes grinds to a halt when you're working with a lot of CDXZipStream or CDXStreamer data, here are a couple of suggestions.

CDXZipStream and CDXStreamer usually return data in the form of Excel formulas or array formulas.  Regardless of the sources of the formulas, however, Excel does tend to slow down, or even seem to freeze, when there are a lot of formulas in a worksheet.  Remember that Excel automatically recalculates all affected formulas whenever a change is made in a worksheet value, and depending upon the formulas and the number of affected cells, this can take a long time.


So first consider removing formulas from your worksheet if you don't need them anymore.  Formulas are great for copying and applying to new data, but if you are done using them you can copy the formula range and paste it back to the same location as values.  The formulas disappear, and no recalculation will occur again. (If desired, you can also retain a small part of the data as formulas for future use.)   For more detail on how to do this, please see this short tutorial from Microsoft.


When using the address verification function in CDXStreamer, you can also check the "Set Array to Values" option and all the data will be returned as values, not formulas.  


However, if you want to retain formulas in your worksheet, you can control when recalculation occurs by turning off automatic recalculation, and then recalculating only when it's convenient.  In later versions of Excel, click on the File tab (or Office button in Excel 2007), and from the "Options" area select "Formulas", and then the desired setting under "Workbook Calculation".   The workbook will recalculate only when saving, or you can force recalculation by using F9 or the "Calculate Now" command under the Formulas tab.  


Whenever you have a lot of data and related formulas in a worksheet, manual recalculation can save you a lot of waiting time.  Consider turning off automatic recalculation (whether you're using our add-ins or not) to be in full control of your worksheet data and make your Excel sessions less frustrating and more efficient.  For more information on using manual recalculation in all Excel versions, please see this Microsoft article.


Latest Data Updates


Canadian and U.S. data feeds were updated as of October 27.  There were 39 changes made to the U.S. database this month.  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.


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 

October 2014



Map of the World


In This Issue

Using MapPoint to Find Points Along a Route


How to Keep Excel Running Smoothly


Data Updates