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 Resource Report. In the window that appears, click the Select Columns button to choose from the Category and Grade 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 metal content columns, Show empty rows, Show volume column and Show density column.

If you have an estimator that produces outside, blank, without_grade 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.

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 Grade 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 and Dollars per short ton. 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.

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

The Resource Report tab has Export and Copy options for making use of the 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.

 

Got a question? Visit the Seequent forums or Seequent support