Most of our customers who use our Microsoft Excel add-ins CDXZipStream and CDXStreamer for address and location analysis, are working with a lot of data in an Excel worksheet.  And if CDXZipStream or CDXStreamer are used to provide additional information for each point of data, it can be quite a task managing and analyzing all the results.  Here are some tips on how to approach data in a large Excel worksheet, particularly on how to find the data you need within a large data set.

First, if the data returned from the add-in is in formula form, get rid of the formulas by copying them to values.  Just select the area containing the formulas, and use the paste special option to paste values only.  The formulas will be replaced with their values; if a worksheet contains a lot of formulas, this will significantly speed up subsequent worksheet processing you’ll be doing later.  As an alternative, you can use the “Set Array to Values” option in the address verification function of CDXStreamer.   (You can also check out the navigation shortcuts described in our blog article 5 Tips all Excel User Should Know, which can help you move around and select large data sets.)

But how do you find just the data you need, in a very large worksheet?  Here are three ways available to do this efficiently and easily through Excel:

FILTERING:  This is Excel’s version of sorting on steroids.  The filter option allows you to look for items in a list based on lots of different criteria (that apply to both text and numeric values), and then hides the rows that don’t apply.  Select a cell within your data, and in Excel 2007 and up, from the Data tab on the ribbon, click the filter icon:

You’ll notice that drop-down arrows are now visible next to each column of data.  (You should make sure to label each column, so the first row of data is also part of the filtering process.)  Then click on the arrow in the column you’d like to filter, and based on the type of data present, you’ll be presented with text or numeric filter options.  You’ll also be able to do straight-on  sorting as well from here, but we’ll focus here on the filter functions.  For instance, if we just used CDXZipStream to calculate distances from a target destination, we can find all locations within a 50 mile radius by selecting the following options in the custom filter dialog:

A nice bonus is if you copy and paste the filtered data to another worksheet, the hidden rows are not included.  To remove the filter and show all rows of data, just click on the filter icon again.  For more information on filtering in Excel, please refer to the following Microsoft article: Filter Data in a Range or Table.

CONDITIONAL FORMATTING:  You can change the font, fill, and border colors and formatting depending upon the cell value.  From the Home tab, click on Conditional Formatting:

Using the example above, click on Highlight Cells Rules, and specify formatting for values less than 50:

For more information, check out the Microsoft article Add, change, find, or clear conditional formats.  

You can also combine conditional formatting with filtering, by using the “sort by color” option available in each column drop-down menu.  Please refer to the article Filter by cell formatting.

VLOOKUP/HLOOKUP:  Excel VLOOKUP or HLOOKUP are great worksheet functions that can link tables together when they have a common column or row of data.  For this example we’ll use VLOOKUP, which is applied to column-oriented data.  Let’s say we have a list of routes which have all been optimized using CDXZipStream; we would like to list all the destinations with their contact telephone numbers, but the optimization process has changed their order from their original list.  To find the telephone numbers in the original list associated with each destination, we create another column with the formula:

=VLOOKUP( LOOKUP_VALUE, TABLE_ARRAY,COL_INDEX,[RANGE_LOOKUP]) where

LOOKUP_VALUE  =  the destination address (in the optimized list)

TABLE_ARRAY = the range of cells that contains the destination addresses and telephone numbers in the original list.  The first column of this range should contain the destination addresses.

COL_INDEX = the column number of the TABLE_ARRAY that contains the telephone numbers

RANGE_LOOKUP = A logical value, where “FALSE” indicates an exact match is required

If we use a cell address for the first lookup value, we can copy this formula along all the optimized destinations to find their telephone numbers.  Make sure however, that the TABLE_ARRAY range is defined by either a named range, or by using an absolute cell range with dollar signs (e.g $A$1:$D$500).

For a list of optimized destinations in column A, we can search for the corresponding telephone number in the range $H$1:$K$200, where the destination addresses are in column H and the telephone numbers are in column K, with the formula:

=VLOOKUP(A1, $H$1:$K$200,2,FALSE)

Then just copy this all along the list to find all telephone numbers.

For more information, please refer to these articles about VLOOKUP and HLOOKUP.

We have often been asked if CDXZipStream can apportion a large number of destinations into individual routes, then optimize the order of stops along each of these routes.  Unfortunately the route optimization function of CDXZipStream, which relies on the use of Microsoft MapPoint, is not sophisticated enough to do this kind of calculation.  The vast number of permutations that could occur here requires a lot of computational muscle, and if there are rules (such as geographic constraints) that must be followed in apportioning the destinations, these must be programmed into the selection process as well.

But this is also a case where the human eye and a little brain power, with some help from Microsoft MapPoint, can compete pretty well with even the more sophisticated (and expensive) software.  The trick is to be able to quickly and easily visualize and manage the data, which is right up MapPoint’s alley.   So let’s get started.

Let’s say we have a list of 100 destinations, which we need to divide into 10 routes (of about 10 destinations each), followed by optimization of each route.     First we import all the destinations into MapPoint using the data import wizard available from the “Data” menu on the MapPoint toolbar:

From here you can then select the Excel file that contains the destination list; you can also select other file types here such as text or Access database files.  After selecting the desired file, you will also be asked to select the appropriate worksheet (assuming the file was an Excel workbook). Then click “Next”, and you’ll see a MapPoint dialog like this:

You can also choose to import data beyond just address information, which may be useful if this data is part of the decision-making process in apportioning routes.  (You can display all information associated with a destination by right-clicking on it later on the MapPoint map.)  Click on “Finish”, then select the pushpin map type in the next dialog:

Once the data is displayed as pushpins in MapPoint, you can use MapPoint drawing tools to apportion the data into routes.  The freeform tool was used to draw the area below:

You may also want to try the radius tool so you can specify the radius distance of the area.  Once an area has been drawn, right-click on the area boundary line and select “Import to Excel”.  You’ll immediately see all the points within the area in an Excel spreadsheet, ready to optimize with the CDXZipStream function CDXRouteMP.  You can also cut and paste these points into our Route Optimization template, available for free download from our links page.

This technique may not be appropriate in cases where there are many criteria for apportioning routes.  In the case above, we used logical boundaries to define the route area, such major highways and the river to the northwest.  (This is very easy for us humans to do, but can be pretty complicated for a computer.)   As mentioned previously, you can also import other data into the spreadsheet which can be used as criteria in apportioning.   This data can be displayed by right-clicking on a destination on the map, or even better, can be used to define the appearance of the destinations when selecting the map type, by selecting options such as color-coded pushpins or sized or shaded areas.  

Keep in mind that before optimizing each defined route, you may need to modify the beginning and end point destinations.  CDXZipStream assumes these points are fixed and only optimizes the order of the intermediate points.   In the majority of cases this assumption works, but you may also want to add one or more addresses that represent the true beginning and end points if they fall outside the area you just defined in MapPoint.

For more information on using CDXStreamer for route optimization, please watch the following tutorials:

Route Optimization in Excel

Route Optimization with One Click

A major priority for CDX Technologies is to provide excellent support for all of our software.  We find that first-class support not only (obviously) improves our customers experience with our products, but also gives us the opportunity to learn about the myriad ways our software is used and how we can improve it.

But the ever-changing world of PC’s can provide a real challenge for developers, and problems can and do arise with even the most carefully designed software.  If you start having a problem with CDXZipStream, we’d like to provide some advice here on how to proceed.

First, check the product support articles on the website.  They cover the most common problems, including:

• CDXZipStream Toolbar Location in Excel 2007/2010

• Filtering Addresses with Radius Distance Returns #NA for all entries

• CDXZipStream Custom Functions Return #NAME?

• Error 1303 During CDXZipStream Installation

• CDXZipStream Toolbar Not Visible

• CDXZipStream Returns "Address is Ambiguous or Invalid" Error

Another common issue is how to reinstall CDXZipStream on a new computer, which is covered in our blog article The CDXZipStream Licensing Agreement. 

If the resources above don’t quickly solve the problem, send us an email at support@CDXTech.com or call 973-895-5542.   It always helps to describe the problem in as much detail as possible, including 

- A description of what you were attempting to do at the time the problem occurred

- The text of any error message (or a screen shot attached to an email if convenient)

- Your PC and software configuration

If appropriate, it can also be extremely helpful to email us your Excel file or a screenshot of the worksheet showing the problem.  This can really speed up the process of troubleshooting issues associated with using CDXZipStream worksheet functions, since the nature of the input data plays an important role in how well the functions work.   In this case, if you must send sensitive or proprietary information, please do not use regular email; you can contact us for access to our secure server.

CDXStreamer is our Microsoft Excel add-in that performs address verification and correction as well as data retrieval for ZIP+4, ZIP+4/TIGER and Canadian postal codes.  Here we will walk through the simple process of performing address verification and correction, which can virtually eliminate undeliverable addresses and significantly reduce the costs associated with incorrect address data.

Let’s say we have a long address list in Microsoft Excel, which could be addresses of customers, service call locations, delivery points, or other locations.  Here’s a portion of the list (in Column A):  

Select an empty cell next to your address list, and then use the cursor to click on the "Verify Address" icon on the CDXStreamer toolbar, as seen here in Excel 2010:

A dialog box will pop up:

Input the cell location of the first address in your list, in this case cell A2.  In this example the addresses are each listed within a single cell, but CDXStreamer can also handle addresses where the components are in separate cells.  In this situation, just select the “Multi-Line Address” option, and input the separate cell locations for the street, city, state and ZIP code. 

Now we choose the type of data to return to the worksheet.  Here we request the ZIP+4 code, also referred to as the 9digit_zip.  We also select the AutoCopy option so data will be returned for all the addresses in our list (so long as it doesn’t contain any empty rows).  Click OK, and the returned data in our worksheet looks like this:

In cases where an address match could not be found in the database, an error is returned.  All addresses that return N/A (an example in row 11 is highlighted in red) should be manually checked.

CDXZipStream will also correct addresses that contain limited errors, such as misspellings, incorrect or missing zip codes, cities, or states, and incorrect street suffixes and directionals.  Standard US Postal Service formatting, such as abbreviations and capitalization, will be also included.   To perform address correction, repeat the process described above, but specify that the entire address (full_address_out) be returned. This will also include the full ZIP+4.  For the list shown above, the corrected addresses are:

Besides formatting and abbreviation issues, here are some of the corrections made using CDXStreamer:

91 Gurnet Road, Brunswick, Maine (Missing ZIP code)
Correction - 91 GURNET RD, BRUNSWICK, ME 04011-9328

41 Sherman Road, St. Johnsbury, VT 05819 (Incorrect street suffix)
Correction - 41 SHERMAN DR, SAINT JOHNSBURY, VT 05819-9280

46 Cheltingham Ave., Schenectady, New York 12308 (Incorrect ZIP code)
Correction - 46 CHELTINGHAM AVE, SCHENECTADY, NY 12306-5106

200 MacIntyre Road, Pittsburgh, NJ 15237 (Street name misspelled)
Correction - 200 MCINTYRE RD, PITTSBURGH, PA 15237-4035

202 Kings Highway West, Haddonfield, NJ 08033 (Incorrect directional)
Correction - 202 KINGS HWY E, HADDONFIELD, NJ 08033-1905

320 W Ottawa St., Lansing, MN 48922 (Incorrect state abbreviation)
Correction - 320 W OTTAWA ST, LANSING, MI 48933-1590

3810 Forbes Ave., Philadelphia, Pennsylvania 15260 (Incorrect city)
Correction - 3810 FORBES AVE, PITTSBURGH, PA 15260-6995

Street address correction in CDXStreamer follows the US Postal Service "one component failure rule" to find a correct address match.  If not more than one address component mismatch exists, where a "component" is defined as a predirectional, street name, street suffix, or a postdirectional, then a correct address can be returned.  For instance, the address  “500 North Main Street West” has four components.  If one of the components has to be added, changed, or deleted to achieve a unique match, CDXStreamer will correct the address and return the ZIP+4 code.  If more than one component is incorrect, no match is allowed.  Also, no match can be returned if adding, changing or deleting a component results in multiple matches.  The priority is to add a suffix first before adding a directional.  If no match exists, the suffix is changed or deleted, and then the directional.

If there is not an exact match within the city, the "one component failure rule" is applied within the input ZIP code. If there is still no match, the rule is applied to all addresses within the postal finance number, and is only considered invalid if there is no match within that.

For a short tutorial covering address verification and address correction using CDXZipStream, please refer to the YouTube video “Address Correction and ZIP+4 Analysis in Microsoft Excel”.

An Excel array can be a powerful tool when dealing with a larger number of calculations, and can be especially well-suited to handling the large amount of data that gets imported into Excel by our products CDXZipStream and CDXStreamer.  Excel arrays can be used, for instance, to identify zip codes within a radius area (using the CDXRadius function  in CDXZipStream), and are especially important when performing address verification or correction in CDXStreamer.

We always recommend that arrays be used when working with large address lists, because all the data can be effectively handled through arrays acting as a bulk data call, instead of individual data calls for each address or zip code entry.  The end result is a much faster response time during the data import process.  When using CDXStreamer, you can make sure that arrays are used by getting data via the standard dialog that opens when performing address verification, then using the “Autocopy” option which applies the array to all contiguous items in your address list.  

Alternatively, it is possible to enter or return a non-array formula, then manually copy this formula down an address list, but this constitutes a new data call for each item and will take a much longer time to return all the data.

Another advantage of using arrays is that formulas within the array will dynamically update the returned data whenever changes are made.  For example, you can update your address list with new entries or changes in the existing data, and the array formulas will automatically update to reflect these changes; no second data call needs to be done by the user.

If you’re not familiar with Excel arrays, they can easily be identified by curly brackets { and } around each worksheet formula.  For arrays that cover a range of cells, those cells act as a unit and cannot be modified in part; you must delete or change the entire array at one time.

Keep in mind, however, that very large arrays can slow down Excel just due to the sheer number of calculations being performed every time a change is made in a worksheet.  You do have a few easy options to avoid this problem.  First, you can specify “Set array to values” in the address verification dialog, and CDXStreamer will automatically remove all array formulas and show only the final values in the worksheet.  You can also do this manually, by copying the entire array and pasting values to the same location.  And finally, if recalculation is not necessary for your data, you can also disable automatic workbook calculation (in Excel 2007 from the File tab, select Options, then Formulas, and deselect Automatic under Workbook Calculation).   Changing the arrays to values has the added advantage that you can modify or delete part of the returned data, which the original array does not allow.  However, please note that all of options mentioned here will remove dynamic data updating.

Arrays work well for software add-ins such as CDXStreamer and CDXZipStream, but arrays are also excellent tools for the end user regardless of the application.  If you know how to use formulas in Excel, you can easily supercharge those formulas by using either single-cell or multi-cell arrays.  To get started using arrays, please refer to the following Microsoft articles:

Introducing array formulas in Excel

More arrays: Introducing array constants in Excel

See also our blog posting about how to apply array formulas when using the CDXZipStream functions CDXRadius and CDXZipList:

Applying CDXZipStream Arrays to Large Data Sets

Our newest version of CDXStreamer provides address correction, ZIP+4, ZIP+4/TIGER, and Canadian postal code data, all within Microsoft Excel.  But to the casual user of the US Postal Service (which covers most of us) ZIP+4 codes seem to be just extraneous information, and in fact, there is certainly no requirement from the USPS to use them when addressing mail.  So why the interest in ZIP+4 codes?

The use of ZIP+4 is intended mostly for business mailers that use computerized or machine-printed labels that can be read by automated scanners.  The 4-digit add-on number identifies a much more specific geographic segment, such as a city block, office building floor, or other high-volume mail receiver, as compared to the 5-digit ZIP code alone, and as a result, helps the USPS deliver mail more efficiently and accurately.  Since it reduces handling and decreases the possibility of mis-delivered mail, mail can get there sooner and even better, can also be eligible for reduced rates.

But ZIP+4 codes also provide a way to access valuable data that can help identify potential customers and markets.  With the millions of ZIP+4 codes assigned in the United States, they can be used to very accurately pinpoint an address and link it to specific demographic information available from the U.S. Census Bureau.  For instance, CDXStreamer can identify the ZIP+4 codes for a list of addresses, and then find the latitude, longitude, census tract, and block number associated with each of those codes.  These data are the keys to the extensive demographics available from the 10-year and annual American Community Surveys performed by the U.S. Census.

CDXStreamer specifically uses a USPS data product that matches the information on the Census Bureau's TIGER File to the United States Postal Service's ZIP+4 database. TIGER (Topologically Integrated Geographic Encoding and Referencing) data is used by the Census Bureau to describe physical land attributes, such as lakes and rivers, as well as other areas such as census tracts, to support the process of taking the decennial census. The resulting USPS file contains over 33 million data records from more than 27,000 5-digit ZIP Codes. The records relate ZIP+4 codes to state, county, Standard Metropolitan Statistical Areas (SMSA) codes, tract number, block number, and geographic coordinate information. Coverage of the file is limited to the address ranges in ZIP+4 database that could be successfully matched to the address ranges in the Census Bureau's TIGER File.

The end result is an effective way to help identify and develop market opportunities using one of the most extensive demographic databases available for the U.S. market.

For a short tutorial showing how CDXStreamer works, see the YouTube video Address Correction and ZIP+4 Analysis in Microsoft Excel.

Also available is a complete listing of all datafeeds and formulas provided with CDXStreamer in the downloadable Excel file CDXStreamer Example Data.

CDX Technologies also has a companion product, CDXZipStream, that provides extensive demographics based on census tract and is available as an add-in in Microsoft Excel.  The CDXZipStream Premium version includes census tract demographics covering population, age, income, household size, educational level, school enrollment, and marital status.  You can download an Excel file with a complete list of available demographics from CDXZipStream here.

Our Microsoft Excel add-in for zip code and location analysis, CDXZipStream, can generate zip and postal code lists for various geographies like state, county, and city.  But if you need to compare two lists of zip or postal codes from CDXZipstream, you can use the computational power of Excel to do the job.  Here’s a couple of different approaches, depending upon the version of Excel you are running:

VLOOKUP:  The worksheet function VLOOKUP works with Microsoft Excel 2003 and higher versions.  For example, let's say we have two zip codes lists like this:

And we want to find which zip codes are in List 1 but not List 2, and vice versa.  Just to the right of the first zip code in List 1, in cell C3,we input the formula:

=VLOOKUP(B3,E:E, 1, FALSE)

This indicates that we are trying to find the value of cell B3 (ZIP code 95229) in Column E (the location of List 2).  If the value is found, the value in the first column (the Zip code) will be returned; if not, “#N/A” is returned.  The input value of FALSE indicates an exact match must be made.

We copy this formula all along List 1.  We also input a similar formula to the right of List 2 that will search List 1:  

=VLOOKUP(E3,B:B, 1, FALSE)

The final result is:

For long lists you may want to use Excel’s sort function to sort these results and more easily identify where the lists are different.

Previously we’ve also shown how you can use VLOOKUP to compare results of zip code radius analysis; for example, identifying the zip codes where two radius areas intersect.  Please refer to the blog post ZIP Code Radius Analysis for Multiple Areas for more information.

CONDITIONAL FORMATTING: This method comes to us from Chandoo.org, and can be used in Microsoft Excel 2007 and up:  

1. Use the cursor to select the cells in both lists.  (After selecting cells in List 1, hold down the CTRL key and select List 2.)

2. From the Home tab, select Conditional Formatting, then Highlight Cells Rules, then Duplicates.

3. You can select to conditionally format unique or duplicate values, and also select color combinations. 

Here is the result, where we highlight duplicate values:

Again, the data can be sorted (based on cell color here) to more easily group and identify differences between the lists.

Our zip code and location analysis add-in for Microsoft Excel, CDXZipStream, can be combined with the computational power of Excel to do a variety of interesting things.  For instance, we’ve just recently introduced an easy-to-use bulk radius analysis template for Excel that can take a matrix of X and Y locations (these could be stores, customers, warehouses, delivery points, etc.) and create a comprehensive report showing which X locations are closest to all Y locations, or vice versa. 

Let’s say we have a list of customer addresses and would like to determine which store locations are within a 10 miles radius of each customer.  This could be used to support, for example, a direct mail campaign to alert customers to the closest stores in their area.  But in cases where there may thousands of customers and thousands of stores, determining the closest stores for every single customer is not a trivial calculation.

So how does the template work?  First we copy and paste all store and customer addresses into the Excel template where they can be verified using the address verification function of CDXZipStream (MapPoint version).  Just click a button in the template, and CDXZipStream automatically determines if each address can be matched to a location in Microsoft MapPoint running in the background.  If a match can be found,  CDXZipStream geocodes the location to find its latitude and longitude.   These points of latitude and longitude are used to calculate straight-line distances between all combinations of stores and customers.  So to obtain a report showing the closest stores within radius of each customer, all we need to do is specify the radius distance (in this case, 10 miles) , click one more button, and a listing of all customers, along with the store locations within 10 miles, is automatically created in a worksheet.

The template can work with either full addresses (street, city, state, zip code) or zip codes alone if full addresses are not available.  The user can also bypass the address verification step by inputting latitude and longitude data directly, if it is available from a gps or other source.  And if you need to do the reverse calculation, i.e. find the closest customers for all store locations, just reverse the order of the data input.

For a short tutorial about the template, please watch the YouTube Video Store Locator Analysis in Microsoft Excel.  For more information, contact us at sales@cdxtech.com or 1-877-CDX-TEC1 (1-877-239-8321).  For current CDXZipStream clients, you can login to your on-line account and select "Buy Data Updates" from the Product Management Area.  Select the Bulk Radius Template from the drop-down list and proceed through the purchasing process.  You must own the CDXZipStream MapPoint, Basic, or one of the premium demographic versions to see this as an option.

Our Microsoft Excel add-in, CDXZipStream, contains demographic data feeds based on data from the American Community Survey.  The ACS is a survey performed by the U.S. Census Bureau which has replaced the old “long form” of the 10-year census.  Please see our article ZIP Code Census Demographic Data in Microsoft Excel about our newest data feed, CDXACSZCTA, which provides for the first time comprehensive ACS data based on ZIP code.

Since the American Community Survey is performed annually, all the ACS data feeds in CDXZipStream are updated annually too.  However, the smaller the geography, the longer the span of data required.  For small geographies like census tract and ZCTA, the data must be aggregated over a five-year period to get statistically significant results; as of this writing the most recent set of five year data spans the years 2007 to 2011.  Therefore, in these cases every annual update does need to incorporate some older data as well. 

For some geographies, such as places (or cities), deciding what span of data to use is a balance between including as many geographies as possible versus using the most recent data.  For CDXZipStream feeds, here are the data spans we use, along with the number of geographies for each feed:

State:  1-year data, 52 geographies (all states, including Washington D.C. and Puerto Rico)

CBSA’s*:  5-year data, 955 geographies (all CBSA’s)

Counties:  5-year data, 3,221 geographies (all counties)

Places (Cities):  3-year data, 3,128 geographies (only places with populations greater than 20,000)

ZCTA’s**:  5-year data, 33,120 geographies (all ZCTA’s)

All geographies were not included for places (cities), excluding those with populations of less than 20,000.  In this case, it is generally a better choice to use ZCTA’s, which do cover a smaller population (averaging about 8,000) and is generally an easier index to use due to the availability of zip codes.  

  *CBSA’s (Core Based Statistical Areas) are the U.S. Census Bureau term for an urban area of at least 10,000 people.

**ZCTA’s (ZIP Code Tabulation Areas) are the U.S. Census Bureau version of a ZIP Code area.  For more information please see our article What’s a ZCTA?

Our Microsoft Excel add-in for zip code analysis, CDXZipStream, now includes a new feed that provides extensive demographic data based on ZIP Code Tabulation Areas. (ZCTA's are the U.S. Census Bureau version of ZIP codes.)  This is the first time ZIP code-based data has been released from the American Community Survey.   The ACS is an annual survey of about 3 million households performed by the U.S. Census Bureau. It has replaced the old "long form" version of the census, and includes many social, economic, and housing questions that were not part of the 2010 Census. The over 200 data fields in this feed cover: 

- Age

- Individual Earnings

- Educational Attainment

- Household Size

- Household Income

- Housing Value and Rent

- Marital Status

- Mortgage Status

- Population

- Race/Ethnicity

- School Enrollment

Click here if you would like to download a complete listing of the data feeds and fields provided in CDXZipStream, including the new feed listed under the name "CDXACSZCTA".

CDXZipStream includes a patented user interface that makes importing demographic data into Excel both fast and easy.  For a short tutorial on how to use our newest data feed, please refer to the YouTube video ZIP Code Census Demographic Data in Microsoft Excel.

The new feed is available with the Premium ACS version of CDXZipStream, which includes all demographic data feeds and data analysis functions.  Pricing for all versions of CDXZipStream is available on our pricing page. If you already have this version, the new feed is included in the most recent Premium ZIP Code data update.    Other current users of CDXZipStream can upgrade to this version by logging into their CDXTech.com account and selecting “Upgrade Licenses”.  In both cases, be sure to also get the newest 11.2.2 (free) update of CDXZipStream, available by clicking on the "License Information and Software Updates" button on the toolbar, then selecting "Software Updates".