Working with Grids

The majority of data in OpenGround Cloud Professional can be viewed using a spreadsheet style grid. These grids have been designed to give you maximum flexibility on what data is displayed and how the data is ordered.

When a grid is opened the data displayed is controlled by the Project Explorer Filter Box. For example, if the Project Explorer Filter Box displays "All Data" then the grid will be opened will every row displayed, if however, a Borehole ID has been selected in the Project Explorer Filter Box then the grid will open with only data for that borehole.

If the grid is opened with partial data, then the description of the initial filter is displayed in the grid title as shown below. It is possible to open the same grid more than once with different initial filters.

The data grids only use the Project Explorer Filter Box to determine the initial data displayed and are not dynamically connected to the filter box. Once a grid is opened changing the Project Explorer Filter will have no effect on the data displayed. You can however use the grid filtering tools to refine the filter further.

Filtering

OpenGround Cloud Professional offers a variety of filter conditions and tools to allow for complex searching and filtering of the data.

To apply a filter to a grid, select the Filter icon next to the column name and enter the criteria for the filter. If a filter is currently applied, then the filter icon will turn blue to represent this. More than one filter can be applied to any one grid at a time.

To remove a filter, select the same option again followed by the Clear Filter option.

Pick lists – Pick list filters allow for a selection box to be checked to allow for the user to decide if the data should be displayed or not. Note the option to select all and empty fields.

Text -Users can filter text values with the standard filter conditions found in applications like Excel. In addition to these it is worth noting the Empty option. This option has been made available to allow for users to quickly show/hide data that has no values entered within a column.

As well as the option to filter empty data, there is also room for two conditions to be setup to further refine the data. Under the 'Show rows with value that' option there is a drop-down allowing for a condition to be selected. See the section on Filter Conditions for further information.

Numeric -Are slightly different to a text filter as data can be filtered with simple calculations rather than text searches. It is worth noting the Empty option. This option has been made available to allow for users to quickly show/hide data that has no values entered within a column.

As well as the option to filter empty data, there is also room for two conditions to be setup to further refine the data. Under the 'Show rows with value that' option there is a drop-down allowing for a condition to be selected. See the section on Filter Conditions for further information.

As well as the option to filter empty data there is also the option to filter by date. This can be using either just one condition (e.g., after a certain date) or two conditions (e.g., between two date periods). To use the filters, select the first drop-down list and select the first condition. See the section on Filter Conditions for further information on filter conditions. Then select the calendar icon next to the first filter box and a date dialogue will appear in a calendar format allowing for the date to be selected as required.

A further condition can then be added by repeating the above process using the second drop-down list and calendar options.

Date/Time – Date/Time filters are the same as the date filter but also allow the user to specify times within a specific data

A further condition can then be added by repeating the above process using the second drop-down list and calendar/time options.

Filters for a particular column can be cleared by selecting the filter option within the column header and then selecting the Clear Filter option.

Filters for all columns can be cleared by selecting the grid, then from the context sensitive ribbon, selecting the Clear Filters option.

Filter Conditions

OpenGround Cloud Professional allows for many different types of conditions to be set. Most of the conditions are fairly self-explanatory, some of the more complex ones are explained further below. Not all of the filter conditions will be available for each data type.

• Is equal to – Does the data exactly match the value entered in the filter box?
• Is not equal to – Does the data not match the value entered in the filter box?
• Starts with – Does the data contain the value entered in the filter box at the start of the data?
• Ends with – Does the data contain the value entered in the filter box at the end of the data?
• Contains – Does the data contain the value entered in the filter box anywhere in the data? Does not contain – Does the data not contain any reference through to the value entered in the filter box?
• Is contained in – Does the data contain the values entered in the filter box anywhere in the data? This is a multiple entry value so any data that matches any of the values entered in the filter box will be returned (E.g. entering 'BH127, BH128' will return all of the values matched to either BH127 or BH128).
• Is not contained in – Does the data not contain the values entered in the filter box anywhere in the data? This is a multiple entry value so any data that does not match any of the values entered in the filter box will be returned (E.g. entering 'BH127, BH128' will return all of the values that do not match BH127 or BH128).
• Is less than – Is the data less than the value entered within the filter box?
• Is less than or equal to – Is the data less than or equal to the value entered within the filter box?
• Is greater than – Is the data greater than the value entered within the filter box?
• Is greater than or equal to – Is the data greater than or equal to the value entered within the filter box?

It is also worth noting the difference between an 'And' and an 'Or' selection when using a second condition when filtering.

If using the 'And' condition, both the first condition and the second condition must be matched for a result to return. If either of these conditions is not matched, then no results will return.

If using the 'Or' condition, either the first condition or the second one need to match for a result to return. If both criteria match, then these results will also be shown.

Ordering Columns

One of the features of the data grids is the ability to order columns in ascending or descending order. To do this just click on the header for the column that you wish to sort by, the column will then be set to order by increasing values and the header will turn grey with the blue bar at the top. Click the header again and the order will reverse, and the blue bar will be at the bottom of the header to show that the column is now ordered in descending order. Click a third time and the order is removed.

Hiding Columns

By default, OpenGround Cloud Professional will show all columns that are available within a grid. This can lead to more data being displayed then is necessarily needed by a user. To enable for easier use, the columns that are shown within the program can be shown/hidden as needed. To show/hide a column, simply click anywhere within the grid that you wish to adjust and select the Manage Columns option from within the context sensitive ribbon.

The Grid Columns option will then appear with a list of all the columns currently available within the grid. To show or hide a column, simply adjust the checkbox next to the column name.

There are non-data columns available within OpenGround Cloud Professional to enable for more advanced auditing. In the above screenshot these are columns available for showing the last actions made on the data.

This will enable a data manager to determine who was the last user to make any changes to the data, and also determine what has been changed.

Grouping Data

Data can also be grouped within a grid to give a quick overview and breakdown of what is available. To quickly group data within a grid, select the grid that is to be adjusted, then choose the header that is to be grouped upon. Select the furthest most right icon within the header, this will then group the data.

A list of all the different values will then appear within a grid showing a count of the amount of times the value appears within that heading. Clicking on a value will open a new grid with all of the data containing that value.

This process can be repeated multiple times to allow for data to be drilled into. Just simply select the group heading option from within the filtered set of results and the above process will repeat.

Exporting CSV Data

When exporting the data to a CSV file, any filters that are currently applied to the grid will apply. Therefore any data that does not match the filter criteria will not be exported.

Exporting XYZ and XYZZ Data

Any grid view within OpenGround Cloud Professional can be used to export XYZ data by selecting the Export XYZ icon from the Grid Tools Ribbon.

The XYZ export feature is a very powerful option in OpenGround Cloud Professional and it may help to understand what this option can do before you learn how to do it.

An XYZ file is simply a text file with three columns (X, Y and Z) on each row. The X and Y refer to coordinates of a location, which in the majority of times would be the Easting and Northing for the location, and the Z value can be anything you like.

The simplest XYZ file you could produce from OpenGround Cloud Professional is for the ground level of each borehole. In this example the Z value would be the Ground Level field. To create this XYZ file you would open the Location Details grid and set up the XYZ form as shown below.

This would then create a simple text file like the one below.

In the above example there was only one value that could be exported. However, when you look at creating XYZ data from other grids it is important to understand how the grid filters and the output drop-down options can work together.

For example, if you wish to create an XYZ file where the Z value is the depth to the top of a geology layer then you can specify a filter condition in the grid and use the "minimum" option in the output drop-down. The steps below detail this process:

• Open the Field Geological Descriptions grid
• Select the Geology Code in the filter box that you wish to create the XYZ data for Open the XYZ output form and set up the following options. Value = Depth Top; Output = Min.
  
• The grid in the middle of this form displays a preview of the output. As can be seen from the above image, the Z values have now been set to be the first top depth for the selected geology code.
• The process could be repeated to give an XYZ file for the base of a layer by selecting the following options. Value = Depth Base; Output = Max.

The output drop-down contains the following options which should be sufficient to cover all options you need to use to create any XYZ data:

• Max
• Min
• Count
• Average
• Sum

The final area of XYZ data to discuss is the option to create an XYZZ file (sometimes called XYZ Value file). This also produces a simple text file, but this time it will have 4 columns, X and Y are the same as above, Z is the depth for a value and the final column is the value at that depth.

This type of file could be used to export a data for the depth and maximum values of all Arsenic in a project by following the steps below.

• Open the Environmental Contamination Testing grid
• Set the Determinand filter to be Arsenic
• Set the XYZ output form as shown below
  
• The grid in the middle of this form displays a preview of the output. As can be seen from the above image, the third column now has each depth in each location that contains an arsenic result and the forth column contains the maximum value of arsenic at that depth.

Other Parameters

The file name box is used to define a file name – if this box is left blank then a filename will be automatically assigned when the Export button is pressed.

Some applications require XYZ files to have headers on the top of each column or each value to be enclosed in quotes. If you are using one of these programs, then you can select these options on the base of the form.

There is the option to also Include Location ID with the csv output file so you can relate the data to its parent location and the option to open the file after export for ease of use.