HoleBASE SI Extension for Microsoft Excel
Data Analysis

The Data Analysis and usage of Excel Dashboards in the Extension for Microsoft Excel will transform how you view and report your data to your team and clients.

Filtering and Grouping

Extracting subsets of data for a report or table can involve even more cutting and pasting than working with a full dataset.

HoleBASE SI Extension for Microsoft Excel allows you to set up which data filters are displayed when a report is run.  This allows one report to be used for whole datasets or any subset of data.

The system also allows multiple worksheets to be produced with each sheet containing a filtered group of data.

This makes plots and tables that show data for just one or two geology layers easy to set up and even easier to produce. Once a template has been set up the user can select what filters they want to apply with no training course.  The filter conditions can even be used in combination with location groups to allow easy reporting by physical zones on site.

Triggers

Highlighting areas of concern is important when reviewing site investigation data and if you must review high volumes of monitoring or contamination data then the Extension for Microsoft Excel will help.

HoleBASE SI Extension for Microsoft Excel allows you to access and report any trigger theme values you have assigned in HoleBASE SI within any worksheet enabling you to only report on values in exceedance of a trigger level.

As the system also allows you to combine the reported data with data on other workbooks and any Excel technique such as conditional formatting the options for streamlining the review of your data are endless.

Using the HoleBASE SI Extension for Excel with HoleBASE SI trigger sets and Excel’s conditional formatting features will enable you to quickly produce summary tables and charts for your client detailing any areas of concern on their site.

Dashboards

Analysing your data in multiple combinations (often called a dashboard view) will help to understand the best engineering parameters for each geology or location.  The time-consuming aspect of creating these dashboards means it is seldom done by organizations not using HoleBASE SI.

By combining the unlimited charting and grouping features in the HoleBASE SI Extension for Microsoft Excel it is possible to create Excel Dashboards that allow you to see everything for a geology layer or location on a single worksheet.

The unlimited combination of graphs, tables and statistics enable you to create a powerful dashboard into your site investigation data at the press of a single button.

Geology and Location Dashboards are the best way of combining the power of Excel with your data.

The HoleBASE SI Extension for Microsoft Excel makes the production of these powerful dashboards quick and easy for any project.

Once you have created your first Dashboard you will understand just how much time you have wasted cutting and pasting data.

Want to find out more?

For further information regarding this product and in particular this area of use we recommend that you view the following articles.

 

Get in touch…

Trialing new software can be time consuming without a knowledgeable guide, that’s why we offer a unique evaluation experience tailored to meet your exact requirements. Get in touch to speak to a member of our team who can help you learn more about our software and assist you in maximising the value of your Geotechnical data.

 

Contact the team   Arrange a demo    Setup a free trial