Resource Reports

The features described in this topic are only available if you have the Leapfrog Edge extension.

The resource report is a pivot table for reporting on resources and reserves in accordance with standards, with the freedom to customise the table to the unique needs of the project requirements. A resource report can display multiple categories and multiple numeric columns.

To create or view a resource report, right-click on a block model in the project tree and select Report. In the window that appears, click the Select Columns button to choose from the Category columns and Value columns evaluated onto the block model. If you wish to set a Cut-off value, select from any numeric column evaluated on the block model and set the cut-off value. The column selected for the Cut-off does not need to be a column included in the resource report. You can also apply a Filter to the report.

Select between Block size in metres and Block size in feet to ensure units are correctly converted. Select Constant value from the list of Density options and specify a numeric constant, or select a density data measurement from the numeric columns listed. Specify the appropriate Density unit to match the Density selection.

You can also choose to Show material content columns, Show empty rows, Show volume column and Show density column.

To only include blocks in the report that are beyond a specific threshold, select a data column from one of the options available in the Cut-off dropdown list, then specify the threshold in the adjacent numeric field. In many cases, the preferred behaviour is to report on blocks that exceed the specified threshold, but you can tick the Report below (<) cut-off box to select blocks under the threshold.

Only blocks that are selected by the Filter will be reported on. Filters created by Calculations and Filters will appear in this dropdown list, and

If you have an estimator that produces outside, blank, without_value or error statuses for blocks, these will result in #Invalid entries in the resource report table. To address this:

Create a filter (or modify your existing filter) to discard blocks with an invalid status, and select this filter in the Filter field above the resource report table, or
Create a calculation that sets invalid values to an appropriate acceptable value, and select this column instead.

If you select one of the options in the Volume filter dropdown, only blocks within the selected volume will be reported on in the report. If Entire block is selected, an entire block will be included in the report as long as the block centroid is within the volume being used as a filter. If Proportion of block is selected, only the proportion of a block that is within the selected volume will contribute to the report.

It is also possible to select None as a Volume filter so the reporting will not be restricted.

Click on a column to customise how the information is displayed. You can change the column title by editing the Heading field.

Enabling Show total will add a category row called Total with a summation for the categories. Any row that is a summation of categories will appear in bold in the table. It is possible to get a sub-total of some of the categories by grouping them, and these will also be shown in bold. To group categories, select multiple items in the Visible categories list by holding down the Ctrl key as you click the mouse. Click the Group button to add the new category.

Note that some of the Visible categories can be unticked to hide them; these hidden categories can still be included in a grouped category:

Select a category and click the up or down buttons to reorder them in the list. Delete a grouped category by selecting it and clicking the Delete button ().

If there are multiple category columns, these can be reordered to select one as the primary categorisation, with the others shown as sub-categories. Click anywhere in a category column and drag it to a new location. While you hold down the mouse button, a vertical bar will appear where the column will be inserted:

When Average Value columns are selected, it is possible to change:

The Heading
The Data unit
The Display unit to use in the table, which may be the Same as data or some other unit to convert to
The number of Decimal places to display in the table

Data unit has the options Unknown, Grams per tonne, Parts per million, Parts per billion, Percent, Troy ounces per short ton, Dollars per tonne, Dollars per short ton, Milligrams per kilogram, Micrograms per kilogram, Milligrams per gram and Micrograms per gram. The Data unit may be automatically set based on indicators in the selected column name, but must be checked for correctness. Make sure that the column data matches the Data unit selected. Note that "dollars" is used as a general term to refer to whichever currency you are using.

When Dollars per tonne or Dollars per short ton are selected as the Data unit, the Display unit option is not selectable, and must be Same as data.

Material Content columns can have the Heading changed, as well as the column’s Unit and Decimal places.

The Report tab has Export and Copy options for making use of the resource report in external documents.

Select Export to save the table as a Microsoft Excel spreadsheet, a CSV file, or an HTML file. Formatting is preserved in the spreadsheet and HTML file so the table will be arranged identically to the report in Leapfrog Geo. CSV files do not contain formatted data. If you select CSV, you will also be asked if you would like to use the Rounded numbers used in the table, or Full precision numbers. You can also select between ASCII characters only and Allow all characters, with UTF-8 encoding, as required by the software you are exporting to.
If you select Copy, then Copy Table, the table is copied to the operating system clipboard, and you can paste it into another application such as Microsoft Excel or Microsoft Word. Formatting is preserved so the table will be arranged identically to the report in Leapfrog Geo and only the column and row sizes need to be adjusted to your preferences.

Reports you create appear in the Graphs and Tables section under the relevant block model. To delete a report, right-click the report and select Delete from the context menu.

Block Model Query Filter Using Report

When you have a report open, you can use the category selections and other filters in the report to filter blocks in the scene.

Detach the dockable report tab and position the window so you can see both the report and the scene. With a block model selected in the shape list, the shape properties panel has a Query filter selector. The name of the report should appear in this dropdown list. When the report is selected, the blocks shown in the scene will only be the blocks the report is reporting based on the Visible categories selected, the Cut-off specified, that satisfies the Filter used by the report (if any), and is within any selected Volume filter.