Excel USA Add-in – 3digits ZIP-Code Map

 299,00  199,00

Choropleth US ZIP-Code Map (3-digits) with Excel – Clearly and Simply

SKU: Excel-Addin-US-Map-3-digit-Zip-Code Category: North America

Excel USA Add-in – 3digits ZIP-Code Map

 

The CityMarker – Excel USA Add-in – 3digits ZIP-Code Map (postcode area) is a smart and powerful Excel tool to transfer Excel data – based on the ZIP code numbers (Address-Data, KPI-Values and Labels) – automatically on an integrated Vector-Map for Excel-Worksheets and for PowerPoint Presentations.

Prepare Management decisions faster than ever. In just three steps you can transfer your locations on a map of US Excel template with postcode areas (3-digits) in Excel and PowerPoint.

 

Excel USA Add-in - 3digits ZIP-Code Map (xls-template) us postcode area color by excel-values

Choropleth US Maps with Excel – Clearly and Simply use ZIP-Code Values, Create Heatmaps, colorramp and set points

 

Protect your data, work offline with clear KPI-Values by Regions and geographic Layers. Increase your Sales and Marketing Activities by Heat maps – use Points, Shapes and Labels from Excel Data-Source to increase your KPI-Dashboards in PowerPoint.

1. In Excel: prepare data according to the supplied sample files
2. Select your Range and create your own heatmap, colorramp and set Points (CRM-System or Values)

 

The CityMarker Excel US Add-in  is suitable for business simulations – designed for sales and marketing presentations, potential analysis, CRM solutions or for your regional service center orientation. An intelligent algorithm ensures the highest precision in the geographical representation of your data and location points. Even large amounts of data can the CityMarker to be transferred to the Vector Map.

 

Use “The Golden Rule” and IBCS-Standards for Reporting:

Simple data structure in Excel + Digital Maps for PowerPoint + Your KPI Values = successful reports

 

Features at glance

Privacy – Protect your Data

Easy to use and totally offline – to protect your company data source. No Google-Map, Bing-Map or other web-based solutions or services.

 

Setting Locations – with postcode number or addresses from Excel Source

Cities and Points are displayed automatically and precisely on the basis of postal code numbers on the Excel  map and formatted according to your data (size and color ramp).

The Regions, Shapes and Areas can be automatically colored, depending on your data source (sum or number) and options.

prepare excel data sheet for maps, select zip-codes, range, cells to color maps and set points / locations

prepare excel data sheet for maps, select zip-codes, range, cells to color maps and set points / locations

 

 

Product features –  Excel USA Add-in – 3digits ZIP-Code Map

  • US Boundary Map – 3digits postcode areas as Vector-Shape – editable shapes
  • Macro to transfer Excel Data into Map, colorize Shapes automatically (Count, Sum)
  • Set individual Markers by Types (Circle, Rectangle, Triangle or own Icons – e.g. Company Icons and Pictures)
  • Marker size by Excel-Values – dynamic of fixed size
  • Marker Colors – individual or by color ramp, heatmap
  • Simple Redesign (CI-Conform) with classic Excel Functions
  • High display resolutions: Ideal for printing on large paper sizes or beamer presentations
  • Simple to use: No VBA or Programming skills required.
  • Security: No Bing-, Google or other web-based solutions
  • Handbook  – PDF-File – US/UK
  • Compatible with MS Office 2010, 2013, 2016, 2019 (365) – MS Office 32-bit System, not for MS Office for Mac.
  • Operation Systems: Windows XP, Windows Vista, Windows 7, Windows 10
  • License: 1 Single User

 

 

Example – Harvey-Balls:

excel map with harvey balls us 3-digits-zip-code areas, postcode map

Create Harveyballs

 

 

 

Example Map for Reporting

create heatmaps by excel values, ranges – point size by zip code (postcode-id)

All cities, postcode areas and labels can be edited with the simple Excel functions – thanks to the correct naming of forms.

heatmap us zip code map excel postcode boundary select

heatmap us zip code map excel postcode boundary select

 

Use  LAT-Lon – Values to Set Points …

Prepare Excel-Sheet

prepare excel data sheet for xls us maps use gis data lat - lon values

prepare excel data sheet for xls us maps use gis data lat – lon values

 

Output Excel US Map

set more points on us map - use excel range, cells - individual points - gis data

US Excel Map – individual points – use LAT – Lon – values

 

 

Export your Map – for great PowerPoint Presentations

ribbon export excel NL map to powerpoint presentation

ribbon export excel NL map to powerpoint presentation