Inserting Data and Functions
Previous  Top  Next


To insert data for a single ZIP Code or other index, right-click on any cell in your Microsoft Excel worksheet and select the appropriate menu item, in this case "Insert CDXZipCode Data":

clip0427


Next you'll see the "Insert CDXZipCode Data" interface:

clip0322

(The list of available fields shown above is available with the premium data version of CDXZipStream.)

For the Data Index, you may use the actual value of the index here, such as "90210", or you may use the worksheet cell address of the index, "C4". Then double-click on one of the available fields, or select one and click "OK", and the returned value will fill the selected cell:

clip0347

Note: If the selected cell is formatted as text, the resulting formula for the custom function:

=CDXZipCode(C4, "City")

will appear as text in the cell, and the value of the data field will not be returned. Please use a non-text cell format, such as "general" or "number" format, to see the data field value.

If you have purchased premium data feeds, area code, state, county, city, and CBSA data are available as well. These additional data feeds operate similarly to "Insert CDXZipCode Data" previously discussed, and are accessed as shown below in the Additonal Data Feeds menu:

clip0429


By using the right-click option you can also insert other special functions in your worksheet. The example shown below is the CDXDistance function for calculating the distance between two ZIP Codes:

clip0430

The CDXDistance Function calculates straight line ("as the crow flies") distance. To calculate driving distance, please use the CDXRouteBing or CDXRouteMP functions.

After selecting the CDXDistance Function from the right-click drop-down menu, the following interface appears:

clip0349


Input two ZIP Codes (or their respective worksheet cell addresses), select the distance in miles, kilometers, or nautical miles, and the calculated distance between the two ZIP Codes will be inserted in the selected cell:

clip0350

For more information please refer to the separate help sections on CDXDistance and other functions CDXFindZip, CDXRadius, CDXRouteBing, CDXLocateBing, CDXRouteMP, CDXLocateMP, CDXDistance2WP, CDXClosestZip, and CDXZipList.