RouteXL now supports advanced dynamic quantitive vehicle routing abilities

First step define your service points. You don’t need to specially format your data, just make sure it includes latitude and longitude columns. Just tell RouteXL which column means what and you are set to go.

Next define your fleet. This is also user formatted data, just tell RouteXL where to get the capacities, shift times, start and end points.

Now you need to build your matrix, which pre calculates all times and distances between the points to be used later in optimization. RouteXL can calculate millions of these pairs in minutes.

If you add new points to your point set, RouteXL only calculates the distances and times for the new points to save you time.

All this data is saved in a QVRW file, a project file for your routing exercise.

Now you are ready to segment your points and allocate trucks.

All you do is choose the “Dynamic optimize” option. RouteXL automatically plots your points and lets you select points.

Immediately after points are added or removed from the selection, RouteXL calculates the trucks needed and their routes. You can even have RouteXL display the routes, or just straight lines for clarity if needed.

If your selection has no solution, you can click the previous button to go back to the last working selection and try another.

When you are ready you can add these points to a cluster, say for example “Monday shift”

You can do what ifs, by selecting points and then adjusting truck capacities and shift times and clicking “Refresh routes” to calculate the best truck allocation and routes.

Once all clusters have been created you can recalculate all clusters and generate an output report in graphics and spreadsheet showing all the truck allocations, travel times shift times etc.

 

You can save your routes to any spatial format: shape files etc.

You can perform any spatial analysis on the results using themes and heat maps etcetera.

 

Please follow and like us:
error

Dashboards available on all our Spatial products

dashboardviewersxl

All our Spatial products now feature a built in dashboard designer. Create your mining dashboards right inside SpatialXL, or SamplingXL!

Any number of dashboards can be created. In SpatialXL the dashboards are saved with your workbook. In other packages the dashboards are saved with your data.

Dashboards can access all the local spatial data, plus any external source as desired.

Dashboards automatically update as data is changed. Also filters can be specified per dashboard.

Dashboard designer built into ALL our Spatial Products
Dashboard designer built into ALL our Spatial Products
Please follow and like us:
error

External database levels in Microstation!

MineModeller Version 4.0 allows Microstation Levels to store data from an external spatial database.

The data in the levels can be synchronised with the database after either database changes have been made or elements have been added, updated or deleted in Microstation.

When the level is synchronised, its data with all attributes is stored inside the Microstation design file, allowing it to be inspected and browsed offline from the database.

MMOracleLayers

The grid can be sorted, filtered and grouped and then selected rows can be selected in graphics.

Also selected elements in Microstation can be filtered in any open data grids for easy location of data spatially.

Each level can be individually configured to link to its own database and table.

MMLevelSettings

A query and link column is specified per level to link the tabular data with the Microstation elements.

MMLayerQuery

It is possible to link to Oracle native spatial columns, Oracle OGC Well Known Binary columns (WKB), as well as SQL Server native and WKB columns. Finally you can link to our famous full 3D spatial extension to SQL Server SpatialBase.

MMLayerTypes

This is an excellent solution for doing Geological modelling in Microstation. You can filter your geological data with complex attribute filters, and then spatially operate to build surfaces or model structures as needed. All the data can be stored in a central spatial database and thus securely shared within your organisation.

Also it is then possible to work offline and when ready then publish your results to the central database.

Please follow and like us:
error

SamplingXL – Underground sampling solution

SamplingXL is the most advanced underground sampling solution available.

Based on our high performance graphics engine SamplingXL allows you to view any other spatial data with your sampling data. Both Sql Server and Oracle are supported as database backends.

SamplingXL exports sample sections directly to graphics, and there is a hot link from graphics to your sampling sheets and vice versa.

Sample sheet reports can be exported as PDF and sample sheets can even be mailed via e-mail.SamplingXL

Sections can be coordinated by placing tape, relative to pegs, and the full construction is saved with the sample sheet.

Please follow and like us:
error

SpatialXL – Map Pivots

Link your Pivot Tables to your Map layers. Map layers will automatically update as your pivot changes.

You can pivot and link your spreadsheet data to any map layer you have open in SpatialXL

 

 Pivots

 

 

 

 

Please follow and like us:
error

SpatialXL – New Auto cluster feature

SpatialXL now supports auto clustering of data. Use this feature to group your point data into spatial contiguous areas with specified limits on some aggregated column.

This helps you partition your sales areas, marketing campaigns and logistic supply areas.

AutoCluster

 

Please follow and like us:
error