Open topic with navigation

You are here: Publish Results > About > Custom Reports > Report Definition
GEOVIA MineSched

|  | Print

# Report Definition

You use the Report definition to control the information contained in the report.

In the Report definition, you choose the data you want to report and how you want to filter the data. Data can be filtered by location, material class, resource, and movement.

The Report definition section changes depending on the type of report selected, and whether the periods are reported by column or row. The orientation of the fields changes to match the layout of the report:

- if periods are reported by row, the fields are aligned so you select the values in rows
- if periods are reported by column, the fields are aligned so you select the values in columns

In the following descriptions of the Report definition section for different report types the fields are described according to the display of the interface when the periods are reported by row. If periods are reported by column, the fields in the interface are identical, but are aligned as columns across the Report definition section.

### Fields in the Report Definition Section for Summary, Detailed, and Location Reports

Field | Description
--- | ---
Production location filter | The production locations that are included in the report. The Production location filter applies to all reporting codes in the group. Notes: Mining locations are treated differently for Summary reports. For other reports, the average and aggregate values for each mining location are reported separately. For Summary reports, the average or aggregate values for the mining locations are combined and reported. Data for stockpiles and processes is only reported with Summary and Location reports. Tip: You can use wildcards to specify more than one location. To specify the locations using the Wildcard Expression Builder, click the Ellipsis button.
Development location filter | The development headings that are included in the report. The development location filter applies to all reporting codes in the group. Tip: You can use wildcards to specify more than one heading. To specify the headings using the Wildcard Expression Builder, click the Ellipsis button.
Report locations individually | Selected: The summary data for each mining location is reported separately. Each report code is reported separately for each heading and location in the development and production location filters, with the data grouped by heading or location. When you select Report locations individually, the heading or location name is written to the first title line, overwriting anything that is defined in the first title line. Cleared: The summary data for headings and mining locations is reported cumulatively. Note: This check box is available only if the Report type is Summary.
Title | If you selected Automatic titles, you cannot change this field. If you selected Custom titles, the number of Title lines defined are displayed. You can type the information you want to appear in each title line of the report in the fields. You can use MineSched keywords in the title. These keywords are used to represent values defined in other fields of the Report definitions section. The available keywords are described in the following table. #### Title Keywords
Keyword | Description
--- | ---
[Value] | The Value being reported in the column.
[Locations] | The Locations being reported in the column. If the report code group is being reported individually, the individual location name is used.
[Materials] | The Materials classes being reported in the column.
[Resources] | The Resources being reported in the column.
[Movement] | The Movement being reported in the column.
It is recommended that you specify the reporting code, the locations for which the code is reported, and the material classes being reported in the title. If you are reporting on fill locations, it is recommended that you specify in the title whether you are reporting the material added or the balance on the location. If you are reporting on stockpiles or processes, it is recommended that you specify in the title whether you are reporting the material added, removed, or the balance on the location.
Filtering
Value | The reporting code on which you want to report. The drop-down list provides the Standard codes, Qualities, User parameters, User calculations, and Ancillary activities. The standard report codes are described in the following table. Note: If you convert a Detailed or Summary report to a Bench report, the first Value in the converted report becomes the Property of the Bench report. If the first Value for the converted report was an ancillary activity, no data is generated and the report is blank. #### Standard Report Codes
Report Code | Description | Valid for Report Types
--- | --- | ---
AREA | The area mined. | All
DATE_FINISH | The date that the last activity finishes in a location, polygon, or solid. When reporting by bench, it is the date that mining finishes in the bench. | All
DATE_START | The date that the first activity starts in a location, polygon, or solid. When reporting by bench, it is the date that mining starts in the bench. | All
FRACTION | The fraction of the last block mined at the end of the period. | Summary
GROUP | If the mining method is Polygon or Bench Polygon, the polygon number mined. If the mining method is solids, the object number mined. | All
LENGTH | The length mined along the development heading or headings during the period. In a Summary report, the length is the total length mined in all headings in the period. In Detailed and Location reports, the length is the length mined in each individual heading. | All
LOCATION | The mining location name. | Detailed and Location
PERIOD_NUM | The period number. | All
POINT | The point number of the mining block reached at the end of the period. | Summary
POLY_D1 | The name of the polygon, if the name is stored in the description field of the polygon string file. Any description field value can be used. For example, POLY_D5 would use the text stored in description field five. | All
POLYGON | The polygon reached at the end of the period or, in detailed reports, the polygon number. | All
MASS | The mass. | All
VOLUME | The volume. | All
RESOURCE_TIME | The working time, in days,of the resource or resources that work in the location. If you report on more than one resource, the value written to the report is the sum of the working times for all resources that work in the location during the period. | Summary and Location
RESOURCES | The resources used. | All
SOLID | The object reached at the end of the period or, in Detailed reports, the object number. | All
TEXT= | Any text that you want to write to the field. You type the specific text you want to write to the field in the format TEXT=example. | All
TKM | When Haulage Routes are defined, you can report the tonnes per kilometre hauled. Tonnes per kilometre can be split into different gradient ranges. To specify that the TKM is to be split by gradient range, type the TKM code, followed by a colon, followed by a lower range value, a semi-colon, and an upper range value. For example, to report the TKM for gradient equal to or greater than 0% and less than 10%, the code would be TKM:0;10. All gradient values are percentages. | All
TRUCKS | The number of trucks required in the scheduling period to move the specified material. The number of trucks is calculated based on the: haulage capacity of the truck types full and empty velocities along the haul routes loading and dumping times availability, utilisation, and efficiency factors | All
TRUCK_HOURS | The total trucking time in hours in the scheduling period required to move the specified material. The truck hours is calculated based on the haulage capacity of the truck types, full and empty velocities along the haul routes, and loading and dumping times. | All
X | The easting of the last block mined in the period. | Summary
X_CENTROID | The X coordinate of the centroid of the polygon. | Detailed
Y | The northing of the last block mined in the period. | Summary
Y_CENTROID | The Y coordinate of the centroid of the polygon. | Detailed
Z | The elevation of the last block mined in the period or, in detailed reports, the elevation of the polygon or bench. | All
Production | The production locations for which you want to report on the Value report code. The specific location filter acts on locations that have already passed the global Production location filter. Locations which satisfy both filters are included in the report.
Development | The development headings for which you want to report on the Value report code. The specific heading filter acts on headings that have already passed the global Development location filter. Headings which satisfy both filters are included in the report.
Materials | The material classes on which you want to report. Tip: You can use wildcards to specify more than one material class. To specify the material classes using the Wildcard Expression Builder, click the Ellipsis button.
Resources | The resources on which you want to report. Tip: You can use wildcards to specify more than one resource. To specify the resources using the Wildcard Expression Builder, click the Ellipsis button. Note: When reporting RESOURCE_TIME, the resource working time is reported for the resources specified in the locations specified.
Movement | The type of movement you want to include in the report. Options are: Added: The material movement for fill locations, stockpiles, and processes. Removed: The material movement for mining locations, stockpiles, and processes. Balance: The material movement for fill location, stockpiles, and processes.
Miscellaneous
Factor | The multiplication factor applied to the data reported. The default value is 1, which has no effect on the data. You can use the Factor to convert values in the report to percentages or to convert to larger or smaller units. For example, by using a Factor of 0.001 you can convert from units to kilounits.
Gaps after | The number of blank rows or columns after the reported value for this code. The default value is 0, which means no rows or columns are left blank between this value and the next value in the report. You can use Gaps after to separate and organise the values in the report.

### Fields in the Report Definition for Bench Reports

Field | Description
--- | ---
Title | The title that is displayed above the reporting code group in the bench report. If you selected Automatic titles, you cannot change this field. If you selected Custom titles, you can type the information you want to appear in the title field. You can use MineSched keywords in the title. These keywords are used to represent values defined in other fields of the Report definitions section. The available keywords are described in the following table. #### Title Keywords
Keyword | Description
--- | ---
[Value] | The Value being reported in the column.
[Location] | The Locations being reported in the column.
[Material] | The Materials classes being reported in the column.
[Movement] | The Movement being reported in the column.
It is recommended that you specify the reporting code, the locations for which the code is reported, and the material classes being reported in the title.
Display title | Selected: The title is displayed above each code group in the report. If you selected Custom titles in the global group properties, when you select Display title, the Title field becomes available for you to define the title. Cleared: The title is not displayed above each code group in the report.
Display column heading | Selected: The grouping column headings are displayed above the code group. Cleared: The grouping column headings are not displayed above the code group.
Remove empty rows/columns | Selected: Rows or columns for which there are no values are removed from the report. Cleared: Rows or columns for which there are no values are included in the report.
Grouping | The fields by which the report data is grouped, and the order by which the report data is organised within the groups. The fields that you can group by are presented in four cells: Location Group/Polygon Elevation Material The Location grouping field is mandatory. You can clear the check boxes for the Group/Polygon, Elevation, and Material fields to stop the report being grouped by these fields. You change the order of the grouping fields using the position arrows at the top of each cell. You change the order of the grouping from Ascending to Descending, using the drop-down list below the field name.
Value | The reporting code on which you want to report. The drop-down list provides the Standard codes, Qualities, User calculations, and Ancillary activities. The standard report codes are described in the following table. #### Standard Report Codes
Report Code | Description | Valid for Report Types
--- | --- | ---
AREA | The area mined. | All
DATE_FINISH | The date that the last activity finishes in a location, polygon, or solid. When reporting by bench it is the date that mining finishes in the bench. | All
DATE_START | The date that the first activity starts in a location, polygon, or solid. When reporting by bench, it is the date that mining starts in the bench. | All
FRACTION | The fraction of the last block mined at the end of the period. | Summary
GROUP | If the mining method is Polygon or Bench Polygon, the polygon number mined. If the mining method is solids, the object number mined. | All
LENGTH | The length mined along the development heading or headings during the period. In a Summary report, the length is the total length mined in all headings in the period. In Detailed and Location reports, the length is the length mined in each individual heading. | All
LOCATION | The mining location name. | Detailed and Location
PERIOD_NUM | The period number. | All
POINT | The point number of the mining block reached at the end of the period. | Summary
POLY_D1 | The name of the polygon, if the name is stored in the description field of the polygon string file. Any description field value can be used. For example, POLY_D5 would use the text stored in description field five. | All
POLYGON | The polygon reached at the end of the period or, in detailed reports, the polygon number. | All
MASS | The mass. | All
VOLUME | The volume. | All
RESOURCE_TIME | The working time, in days, of the resource or resources that work in the location. If you report on more than one resource, the value written to the report is the sum of the working times for all resources that work in the location during the period. | Summary and Location
RESOURCES | The resources used. | All
SOLID | The object reached at the end of the period or, in Detailed reports, the object number. | All
TEXT= | Any text that you want to write to the field. You type the specific text you want to write to the field in the form TEXT=example. | All
TKM | When Haulage Routes are defined, you can report the tonnes per kilometre hauled. Tonnes per kilometre can be split into different gradient ranges. To specify that the TKM is to be split by gradient range, type the TKM code, followed by a colon, followed by a lower range value, a semi-colon, and an upper range value. For example, to report the TKM for gradient equal to or greater than 0% and less than 10%, the code would be TKM:0;10. All gradient values are percentages. | All
TRUCKS | The number of trucks required in the scheduling period to move the specified material. The number of trucks is calculated based on the haulage capacity of the truck types full and empty velocities along the haul routes loading and dumping times availability, utilisation, and efficiency factors | All
TRUCK_HOURS | The total trucking time in hours in the scheduling period required to move the specified material. The truck hours is calculated based on the haulage capacity of the truck types, full and empty velocities along the haul routes, and loading and dumping times. | All
X | The easting of the last block mined in the period. | Summary
X_CENTROID | The X coordinate of the centroid of the polygon. | Detailed
Y | The northing of the last block mined in the period. | Summary
Y_CENTROID | The Y coordinate of the centroid of the polygon. | Detailed
Z | The elevation of the last block mined in the period or, in detailed reports, the elevation of the polygon or bench. | All
Production | The production locations for which you want to report on the Value report code. Note: Mining and fill locations are the only valid locations for a Bench report.
Materials | The material classes on which you want to report. Tip: You can use wildcards to specify more than one material class. To specify the material classes using the Wildcard Expression Builder, click the Ellipsis button.
Movement | The type of movement you want to include in the report. Options are: Added: The material movement for fill locations, stockpiles, and processes. Removed: The material movement for mining locations, stockpiles, and processes.
Factor | The multiplication factor applied to the data reported. The default value is 1, which has no effect on the data. You can use the Factor to convert values in the report to percentages or to convert to larger or smaller units. For example, by using a Factor of 0.001 you can convert from units to kilounits.
Gap after | The number of blank rows or columns after the reported value for this code. The default value is 0, which means no rows or columns are left blank between this value and the next value in the report. You can use Gaps after to separate and organise the values in the report.

### See also

- Custom Reports
- Global Group Properties
- Global Report Properties

Open topic with navigation