LocateXL is an open extensible Geocoder that works within Microsoft Excel or as a standalone application if you need to process more than a million records at a time.
LocateXL uses a revolutionary full text and structured approach to process all kinds of datasets. Datasets may be totally unstructured or have some or all address fields specified. LocateXL is able to work with fields holding possible two address fields in one column extending the precision of the geocoding and the range of datasets it can successfully process.
With LocateXL you are even able to build your own geocoding reference data for your country and region, from SQL databases, Shape Files or other sources.
We supply datasets for South Africa right out of the box.
Using the familiar Microsoft Excel environment you are able to filter out bad records, geocode subsets and change settings to match filtered subsets to easily geocode almost any dataset. During the geocoding process the correct canonical address is given back.
Reverse geocoding is also possible one on one or in batch at very high speed.
RouteXL now has a feature allowing bulk calculation of routes between points and central locations by shortest drive time.
This is a very expensive operation requiring calculations of thousands of routes, but is done efficiently in RouteXL using an algorithm that re-uses already calculated routes
In the example we allocated about 6000 points to 12 depots by shortest drive time. This needed a calculation of 72000 separate routes. RouteXL does this calculation in 20 minutes on a normal laptop computer.
In SpatialXL or any of our other Spatial products (SurveyXL, GeologXL, EvaluationXL) you can de-survey borehole data on the fly.
All one does is specify the borehole collars, the surveys and then the lithography data and assay data. These data sets can come right from an Excel workbook, a SQL Server or Oracle database or any data source supported by our spatial engine.
The data is rendered on the fly, so if the data source is updated, the boreholes are automatically updated when the layer is opened the next time.
SpatialXL allows you to develop custom spatial analytic applications in Microsoft Excel using VBA and custom worksheet formulae.
You can programmatically select features in the map, and detect what features are selected by the user in the map to create visual what if scenarios and dynamic calculations involving Spatial data.