CDXGeoStream Technologies

Video tutorials

Short walkthroughs of CDXGeoStream: the basics, installing it in your app, and the bulk tools in Excel. Each takes a minute or two.

General

Installation

Bulk Tools

1:31

11 Bulk Tools in Excel: Distance, Routes, ZIP Codes and Geocoding

A 90-second tour of the eleven bulk tools in the Excel add-in. Select your data, capture it and run; the results go to a new sheet.

1:02

How to Build a Distance Matrix in Excel in 4 Steps

Every distance between two lists of addresses or ZIP codes, written to a new worksheet as a grid. No formulas.

1:01

Straight-Line vs Driving Distance in Excel: Which to Use

The same trip measured both ways, straight-line and by road, and when to use each in the Excel distance matrix.

1:03

Route Optimization in Excel in 4 Steps

Turn a column of stops into a short visiting order, written to a new sheet with the distance for every leg.

1:03

From Address List to Planned Route in Excel

Verify an address list with USPS, then plan a driving route through the same addresses, with a map, all inside Excel.

1:19

Plan Your Service or Delivery Route in Excel

A plumbing company with eight service calls and one van: fix the addresses, put the stops in order, and hand the driver a map or a GPS file.

1:02

Find the Closest Location to Each Customer in Excel

Match every customer ZIP code to your nearest store, branch or depot in Excel, with the distance and the second and third closest.

1:02

Clean a Mailing List in Excel: USPS Verify, Dedupe and Map

Verify a mailing list against USPS data, remove the duplicates, flag what is undeliverable and map the addresses, all inside Excel.

1:00

Geocode Addresses in Excel and Sort by Distance

Turn a column of addresses into latitude and longitude, then sort the whole list by distance from any point, nearest first.

0:57

Census Demographics by ZIP Code in Excel

Census figures for every ZIP code in a territory, written to an Excel sheet with one row per ZIP code and one column per field.

0:59

Find Every ZIP Code in a Radius or County in Excel

Build a list of every ZIP code in a territory in Excel, drawn by distance from a center or by state, county and city.