The "P100-AddressValidation"  program is indispensable for your company !

Are you using?

ERP  -  Enterprise Resource Planning     CRM -  Customer Relation Management     GIS   -  Graphic Informaton System

->   SAP - ORACLE - SAGE - MICROSOFT - DATEV - INFOR -  etc.    ->   SAGE - ORACLE - CAS - MICROSOFT - COBRA - SuperOffice -  etc.    ->   MAPINFO  - ESRI(ArcGis) - CALIPER(Maptitude) - GFK (Regiograph) - etc.

---

 Are the addresses in the master data 100% correct and complete ?
Our experience shows: - they are almost always - incorrect.

With the Excel program "P100-AddressValidation" you can clean up the addresses easily and quickly.

---

The example   "P100-AddressValidation"  screenshot of the start window: 

---

How to find us: 


Travelling by car:

• From the A5 motorway take the exit to Darmstadt-Eberstadt
• Turn left at the first traffic light (north, direction of Darmstadt)
• Turn left again at the next traffic light (west, direction of Pfungstadt)
• Then turn right into the “Marienburgstraße”.
• Parking places are available in front of the office building

Travelling by train:

• Exit at the “Darmstadt Hauptbahnhof” (main station)
  Then take a taxi

Travelling by plane:

Fly to Frankfurt/Main airport

1. Take a taxi to Darmstadt-Eberstadt, Marienburgstr. 27 (approx. 25 min.). 
2. Take the bus (HEAG AirLiner), departing at arrival gate B to Darmstadt Hauptbahnhof (approx. 25 min.)
3. Take the train to Darmstadt Hauptbahnhof (approx. 20 min.) 
   Then take a taxi

SALES SPECIALISTS FOR THE GERMAN MARKET

Do you want to expand your products and services into the German market? For this, you need a team with qualitative know-how and broad experience.
We successfully work with companies in the automotive industry, the logistics industry,  and sales organizations. We differ from other consultants because we are there for you beyond our initial analysis. We actively support your organization in the implementation of our recommended strategies and offer long-term coaching if required. We analyze - market potential and competition. We find - the best locations and optimal sales areas. We help - in the search for suitable salesmen and train them. . .  and if you are already active in Germany, we optimize - your sales. For our analyses we use the program - Maptitude - of the US company Caliper Corp. Our clients are SMEs with complex products and services from the following sectors:  mechanical engineering / plant construction / automation / ITK / construction. For more information, please contact Mr. Jürgen Käsemann directly. E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it., phone: +49 0170 5346622

 

Strong   Extra-Funktions  for MS Excel

 

! Introduction - >>  Video  [9 min]  (please watch first)  

---

! Licensing:

You purchase an  unlimited user license  for one computer for 1 year. Unlimited, provided that you only use the addresses you have edited internally. 
A sale or rental of the addresses to third parties is forbidden and leads to the deactivation of the program via our license server. In this case there will be no refund of the rent.
If you want to use BING or Google in addition to OSM (OpenStreetMaps), you must confirm their usage rights and purchase the respective API additionally. 

Actualisation:

The functional scope of the program may change at any time without prior notice.
 

Structure of the Excel table (Microsoft Excel 2013 and higher - 32 Bit)

The Excel table - must begin - in the first row with the column headings. All columns must be labelled.
The addresses must start sequentially from the 2nd line and blank lines are not allowed between start and end row.
Blank lines and blank columns outside the address block must be removed.

Optimum set up
The first two columns ( A + B) should contain a consecutive number (for example, SAP number) and the name (for example, company).
The columns ( C + D + E + F + G ) contain necessary address information, but these can be distributed in the Excel table as required.
Please note that the street name must comply with the house number and the country code is in ISO format (US - UK - DE - CH - UK).
The postcode should be complete, e.g. - 5 digits - for USA, Germany, France, Italy, - 4 digits - for Austria, Switzerland, Netherlands etc. 
Further information is optional, e.g. telephone, e-mail, web address, sales, employees, imprint etc.

.
Pre-Validation:     Video    

All addresses are checked for plausibility. For example, post boxes instead of street names, missing house numbers, missing postal codes or city names.
In this way, corrections can be made in the master data in advance.
Attention: The Excel table must not contain empty columns or missing column captions. The column captions must be made in the first table row.

.
Entire-List:      Video    

All selected actions, e.g. Web Search, Batch Geocoding: - , refer to the  entire  Excel file.
Attention: The Excel table must not contain empty lines (inside and at the end).

.
Selected Rows:    Video  

All selected actions, e.g. Web Search, Batch Geocoding: - , refer to the  selected  rows.

.
Web Search:     Video   

Address search via OpenStreet Maps, BING Maps and Google Maps. Different views are applicable: Street, Satellite, Birds Eye.
Manual (move) adjustment of addresses. Internet (web search) for all address fields and their combinations.
(Almost) any number of address fields can be displayed, searched for and updated via Copy and Paste.

.
Selection for Batch search:       

Default setting for the batch search.

.
Status Filter:    

The status FIlter shows the quality of the address data found.

: one or more filters are set for batch post-geocoding or web search.

.
Auto Filter:     

The auto filter is switched on or off for all columns.

.
Show/Hide columns:     Video   

To compare the address requests and the results found (marked with *) directly, all columns that are - not address-relevant - are hidden.

.
Overwrite addresses:    Video   

You can copy the addresses found by OSM - BING - or Google to the original file (Excel). Incorrect spellings can thus be easily corrected.

.
Export KML:     Video   

Geocoded addresses can be displayed on an Internet web map, e.g. Google Earth. All or selected addresses.

.
Columns Assignment:    Video   

The column assignment is the most important step after completion of the "settings".
Here you define the address-relevant fields as well as all Excel fields that are to be used for display, search and change.

.
Settings:    Video    

Basic settings, such as default country or languages, Google or BING for web search and registration of Google or BING API keys can be done here.
Also which quality characteristics should be displayed, can be defined by selecting the respective fields.