If you’re trying to pick the right CDXTech product, the short version is this:

• CDXZipStream is for people who want to do location analysis directly in Excel (drive time, distance, routing, coverage, mapping, demographics).

• CDXGeoData is for teams that need location intelligence via apps or API (developers, analysts, automation, integrations).

• CDXStreamer is for anyone who wants web-based location tools (no install, no Excel required) including address correction + ZIP+4, plus browser workflows for driving distance, radius/proximity, and demographics—ideal for Mac/Linux users or teams working outside of Excel.

Below is the detailed breakdown and a quick decision path to choose confidently. 

Quick comparison

CDXZipStream is a powerful location analysis solution that brings routing, ZIP code distance, radius, and demographic analysis directly into Excel. It enables users to perform sophisticated location-based analysis without the need for specialized GIS software.

What many users don’t realize, however, is that much of this powerful functionality can be accessed with pre-built Automation Templates—making advanced analysis as simple as clicking a button.

What Are CDXZipStream Automation Templates?

Automation Templates are ready-to-use Excel workbooks that automate common CDXZipStream workflows. Rather than learning formulas or manually configuring calculations, users simply enter their data, click a button, and receive complete results.

These templates encapsulate proven logic and best practices, allowing users to take full advantage of CDXZipStream capabilities without needing to understand the underlying complexity.

Designed to Eliminate Complexity

While CDXZipStream supports a wide range of advanced functions, many users only scratch the surface because they assume deeper functionality requires technical expertise. Automation Templates remove that barrier entirely.

By handling configuration, formulas, and sequencing behind the scenes, templates let users focus on outcomes instead of setup.

Types of Templates Available

CDXZipStream Automation Templates cover the most commonly requested location analysis workflows, including:

Geocoding & Location Intelligence

Templates that convert address lists into latitude and longitude, return ZIP codes, cities, states, counties, census tract identifiers, and perform reverse geocoding from coordinates back to addresses.

Distance, Routing & Travel Time

Templates that calculate straight-line ZIP code distances, driving distance and time between locations, distance matrices between two lists, and optimized driving routes for multiple stops.

Radius & Proximity Analysis

Templates that identify ZIP codes within a defined radius, find the closest ZIP codes to a location, and perform bulk radius analysis across large datasets.

Demographics & Census-Based Reporting

Templates that generate demographic profiles for ZIP codes using census-based data, enabling quick insights into population, income, and other key characteristics.

Data Lookup & Quality Enhancement

Templates that improve data quality by resolving incomplete location data, identifying valid ZIP codes, and standardizing geographic information.

What These Templates Enable

Each template executes one or more CDXZipStream functions automatically, allowing users to:

• Run advanced multi-step analysis with a single click

• Avoid writing or maintaining complex formulas

• Produce consistent, repeatable results

• Reduce errors caused by manual configuration

• Access advanced functionality they may not know exists

In effect, templates allow users to operate CDXZipStream at an expert level with minimal effort.

View available templates here:

Why Many Users Haven’t Discovered Them

Many CDXZipStream users focus on individual functions and don’t realize that complete workflows are already built and ready to use. As a result, they spend time manually recreating processes that could be automated instantly.

Automation Templates exist specifically to bridge that gap.

Start Using Templates Today

If you’re using CDXZipStream without Automation Templates, you’re likely doing more work than necessary. These templates provide a faster, easier, and more reliable way to perform location analysis—often with nothing more than a single click.

Exploring the available templates is one of the quickest ways to unlock the full value of CDXZipStream.

Many CDX Technologies Excel templates rely on VBA macros to automate calculations, validations, and workflows. To protect users, Microsoft Excel displays security warnings when opening macro-enabled files from unknown or untrusted publishers. To ensure a seamless experience, CDX Technologies digitally signs its Excel templates using the Hughes Financial Services Inc. code-signing certificate. By adding this certificate as a Trusted Publisher, users can safely enable macros without repeated security prompts, subject to their organization’s security policies

This article explains why trusting the publisher matters and how to do it in just a few steps.

Why Excel Shows Macro Security Warnings

Excel macros can execute powerful commands, which is why Microsoft blocks them by default unless certain trust conditions are met. In particular, macros can run without warnings when:

• The file comes from a trusted location (such as a designated trusted folder), or

• The macro is signed by a publisher that has been added to Excel’s Trusted Publishers.

When a workbook is digitally signed but the publisher isn’t yet trusted, Excel displays a warning such as:

“Macros have been disabled” or “Security Warning: Macros have been disabled”

Adding the Hughes Financial Services Inc. certificate as a trusted publisher typically resolves these prompts for that user on that computer, as long as the certificate remains valid and organizational policies allow it.

Advantages of Adding Hughes Financial Services Inc. as a Trusted Publisher

Adding a trusted publisher provides both security and convenience.

1. Prevents Repeated Macro Execution Warnings

Once Hughes Financial Services Inc. is trusted, Excel will normally enable macros automatically in all CDX Technologies templates signed with that certificate, eliminating repeated prompts for those files. This behavior may still be constrained by your organization’s macro security policies or group policy settings.

2. Confirms File Authenticity

A trusted digital signature ensures:

• The template came from Hughes Financial Services Inc.

• The file has not been modified in a way that invalidates the signature since it was signed.

If a file is altered after signing so that the signature is no longer valid, Excel treats that signature as invalid and will not treat that file as trusted, even if the publisher itself is trusted

3. Improves User Experience

Users can:

• Open templates without constant security interruptions.

• Avoid confusion about whether it is safe to enable macros.

• Reduce training and support issues related to Excel security prompts

4. Aligns with Enterprise Security Best Practices

Enterprise administrators should also configure macro policies (for example, “Disable all macros except digitally signed macros”) and restrict trusted publishers to vetted sources.

Trusting a verified publisher is safer than broadly disabling macro security. This approach:

• Preserves Excel’s macro protection framework and default safeguards.

• Limits trust only to known, approved publishers, in line with recommended enterprise controls.Enterprise administrators should also configure macro policies (for example, “Disable all macros except digitally signed macros”) and restrict trusted publishers to vetted sources.

How to Add Hughes Financial Services Inc. as a Trusted Publisher in Excel

Follow these steps the first time you open a CDX Technologies macro-enabled template.

Step 1: Open the CDX Technologies Excel Template

Open the .xlsm file provided by CDX Technologies. If you have just downloaded the file from the internet, be sure to unblock the file.

You should see a Security Warning banner indicating that macros have been disabled.

Step 2: Review the Security Warning and Digital Signature

1. Click File → Info

2. Under Security Warning, click Enable Content → Advanced Options (or a similar option such as Enable Content → More Options, depending on your version).

3. In the security dialog, you can click Show Signature Details or View Signature to review the signature issued to Hughes Financial Services Inc. if you wish to verify the publisher.

4. Optionally, you can click View Certificate from the signature details window to inspect certificate information before proceeding.

Step 3: Trust the Publisher

1. In the security options dialog, select the option “Trust all documents from this publisher”.

2. Confirm the selection when prompted. This adds Hughes Financial Services Inc. to your Trusted Publishers list for your user profile.

Step 4: Reopen the Template

Reopen the Excel file. Macros signed by Hughes Financial Services Inc. should now run automatically without additional warning messages on that user profile, provided your organization’s macro policies permit this

All future CDX Technologies templates signed by Hughes Financial Services Inc. will normally be trusted on this user account on that computer. If you still see warnings, your organization’s IT policies may be blocking macros even from trusted publishers, and you may need assistance from your administrator.

Important Notes

• Trusting the publisher applies only to templates signed by Hughes Financial Services Inc.

• If a file is altered or corrupted in a way that breaks the digital signature, Excel will treat the signature as invalid and will not treat that file as trusted, even if Hughes Financial Services Inc. remains a trusted publisher.

• Trusted publishers are typically stored per user profile; in managed environments, IT may configure this centrally so you do not need to perform these steps yourself.

Need Help?

If you encounter issues trusting the certificate or if macros are still blocked after following these steps, contact CDX Technologies Support or your IT administrator for assistance. This ensures your templates run smoothly while remaining consistent with your organization’s security requirements

The American Community Survey (ACS) is an ongoing survey conducted by the U.S. Census Bureau that provides up-to-date demographic, social, economic, and housing data. Unlike the once-a-decade census, the ACS collects information continuously through mailed questionnaires, phone interviews, and in-person visits. This rolling approach produces detailed 1-year and 5-year estimates that give businesses and communities a clearer, more timely picture of population characteristics—from income and education levels to housing conditions and commuting patterns.

CDXZipStream makes it easy for Excel users to access and analyze this valuable ACS data. Using data feeds such from the latest 5-year ACS results, the software delivers detailed demographic variables for ZIP Codes, counties, cities, and other geographic areas. CDXZipStream also integrates 2020 and 2010 Census data, ZIP Code information, business statistics, and more, giving users a comprehensive demographic toolkit directly in Excel. For a complete listing of the data CDXZipStream covers download the file CDXZipStream Data Fields and Definitions.

For businesses, understanding ACS data is essential for making smarter decisions, whether evaluating new markets, optimizing sales territories, or profiling customers. CDXZipStream streamlines this process by bringing high-quality demographic insights directly into your workflow. With quick access to key indicators such as median income, housing values, age distribution, and employment characteristics, CDXZipStream empowers companies to identify opportunities, reduce risk, and build strategies grounded in real community data

Have you received a warning from Google that your Maps API key is unrestricted? This means your key could be used by unauthorized parties — leading to unexpected charges or service interruptions. Google now requires users to apply proper restrictions to prevent misuse.

To secure your key, log into the Google Cloud Console → APIs & Services → Credentials, select your key, and set both application restrictions (limit by website domain, IP address, or app) and API restrictions (only enable the APIs you actually use, such as Routing or Geocoding). Once saved, verify the key works from CDXZipStream and your authorized domains and confirm unauthorized referrers are blocked.

At CDX Technologies, your API key is always encrypted, securely stored, and never exposed in plain text. Our services use the key only within authorized systems, following Google’s security best practices. Together, these measures protect your data, control costs, and keep your location analytics running safely.