• Author / Uploaded
• Ricardo Contreras B

• Categories
• Lenguaje de escritura
• Tabulador (Gui)
• Archivo de computadora
• Parámetro (programación de computadora)
• Ícono (Computación)

Citation preview

22nd Annual Seminar

Equipment Reporting in MineSight® Interactive Planner

An integral part of generating a short-term mining schedule is the calculation of the equipment requirements for a particular plan. Truck hours, number of trucks, shovel hours, and number of shovels are often required, as well as a means for loading this information back to the Attributed Geometry Data Model (AGDM). A recent enhancement to MineSight® Interactive Planner (IP) greatly simplifies this calculation, providing the short-term planning engineer with a convenient tool for computing and reporting this information.

Preliminary Requirements In order to utilize the MineSight® IP Equipment Reporting Options, the following steps are followed: • Prepare a Cycle Time File; this is an ASCII file with destination and truck/shovel information for each pushback. • Specify user attributes for storing pushback, bench, destination, and equipment data back to the AGDM; this is an optional step, but a recommended one. • Run the Python Equipment Setup Script (eq-setup.py) from within the MineSight® IP Tool. • Run the Python Equipment Reporting Script (eq-report.py) from within the MineSight® IP Tool for each cut.

Preparing the ASCII Cycle Time File This is a free format space-delimited ASCII file with a single header line and entries for the fields as shown below: This format and these input fields are the same as are required for the Cycle Time Input File that is used in MineSight® Strategic Planner (SP) for long-term planning.

Cycle times are entered in minutes for as many different truck types as are required for your plan. The example shown has cycle times for 240 ton and 300 ton trucks. The cycle time entered should include the entire cycle time with the exception of truck loading time. Alternatively, equipment productivities can be used instead of cycle times. Destinations are broken down into three possible levels of detail (DEST, LIFT, and SUBZONE), non-required fields can be entered with a value of none, as shown in the example file, currently sub zone is not used.

Specifying User Attributes for Cuts This step is performed within the MineSight® IP Tool, using the Attributes tab on the IP Cut Design dialog. It is adequate to simply specify the names of the attributes for the ® Page 1

Equipment Reporting in MineSight Interactive Planner

storage of pushback, bench, and destination information, as the eq-setup.py script will use the cycle time file to enter the valid text type values into the AGDM automatically.

22nd Annual Seminar

For this example, we’ve added the following cut attributes: bench, destination, pushback, truckhours, and shovelhours; these are not required, but if they are not added to the AGDM, there will of course be no fields available in which to store the data. Currently these user attributes must be of type text, even the ones that will accept the truck and shovel hours.

Running the Equipment Setup Script This step is also performed from within the MineSight® IP Tool, using the Scripts tab on the IP Cut Design dialog. The IP Equipment Setup script (eq-setup.py) must be run under the Additional Scripts portion of this tab. Navigate to the location of the script using the folder icon and then run the script by clicking the GO button. An open cut is not required to run the setup script.

Page 2

Equipment Reporting in MineSight® Interactive Planner

22nd Annual Seminar

The Equipment Setup script interface consists of four panels, which should be filled out as described below. Panel 1. Cycletime File. In this panel, click the Choose button and navigate to the cycle time file previously prepared. Check the Use productivity (tons/hr) box if you are entering Equipment Efficiency factors in terms of tons/hr rather than in percents (default units). The Period length... is the product of the number of days in the plan and the number of operating hours per day – in this example we are using a one-week period and a 24-hour operating day.

Panel 2. Equipment Setup. In this panel, we specify the truck and shovel names and the operating parameters associated with each. The Auxiliary equipment option is not available in this version of Equipment reporting. To add a piece of equipment to the plan, enter a Name for the equipment, select a Type from the drop-down field, and enter the production parameters for that piece of equipment (Capacity, Efficiency, and Availability). The Cycle file index indicates the position of the equipment in the cycle time file; this is a zero-index entry, so the first truck should have a value of 0 in this field, the second truck a value of 1, etc.

Equipment Reporting in MineSight® Interactive Planner

Page 3

22nd Annual Seminar

Fill in the fields for each piece of equipment, and then click the ADD button to insert that piece of equipment into the plan. Repeat as necessary for each piece of equipment.

Page 4

Equipment Reporting in MineSight® Interactive Planner

22nd Annual Seminar

Once the equipment has been specified, the second step in this panel is to match up trucks and shovels into Equipment Sets. The following illustration shows the panel arrangement for the definition of an equipment set named 240-Rope, which is the combination of the Rope shovel and the 240T truck. To create a new Equipment Set, enter an Equipment Set Name, highlight the members of the set in the respective equipment sections of the panel (Truck, Shovel), and then click the ADD SET button.

Panel 3. Destination Mapping. This panel is used to define destinations for each of the material types and the equipment set to be used for each material.

Equipment Reporting in MineSight® Interactive Planner

Page 5

First select the user-defined attributes to use for automatically storing the bench, pushback, and destination for the cut in the AGDM. (The attribute names in the pulldown list must be pre-specified under the Attributes tab in the IP Cut Design dialog; see Specifying User Attributes for Cuts, earlier in this article). Next, pick the Material Set and Material type; select the destination where you want to send each material type and specify the equipment set to use for each material. Click the Parse box to populate the pull-down list of destinations with names extracted from the cycle time file. Each destination can be limited with the From/ToCutoff fields. If unique destinations are not related to cutoffs then pick the maximum value for ToCutoff and all cutoffs in between FromCutoff and ToCutoff will be automatically entered with the same destination and equipment set.

22nd Annual Seminar

Click the ADD REC button to add each selection to the list; the CLEAR REC button clears all entry fields, and the DEL REC button deletes highlighted records from the list. The MAP RECS button performs a validity check on the mapping and displays a message with that information. Panel 4. Reporting. This panel is used to specify the values that will be stored back to the AGDM, and to customize the reports generated by the eq-report.py script. Reports can be generated in two formats: a text file and a Geometry Object label. The User Attrib portion of the panel allows you to choose the data that will be stored back to the AGDM and the attribute in which it will be stored. Currently, the values for Truck Hours and Shovel Hours for each cut are available for automatic database storage. Select the destination field in the database from the User Attrib drop-down; select the value to store back from the Value drop-down.

Page 6

Equipment Reporting in MineSight® Interactive Planner

22nd Annual Seminar

The second option available on the Reports panel is the Text Report; there are two format options available, text and gview. You can enter the name of the output file from the keyboard, or Browse to an existing file. If you browse to an existing file, the data there will be overwritten with the new report. The fields in the reports are not customizable, but it is possible to override the default settings when the report is generated using the eqreport.py script.

The third option available on the Reporting panel is the Viewer option. This will generate a Geometry Object with the equipment data displayed as a label. The position of the label relative to the centroid of the cut can be adjusted using the Location drop-down.

Equipment Reporting in MineSight® Interactive Planner

Page 7

Once all of the panels have been filled out, you can use the File menu to Save the responses you’ve filled in, and then Exit the script. This script is not actually run, rather the responses are used as input to the next script, eq-report.py.

Running the Equipment Reporting Python Script

The Equipment Reporting script, eq-report.py, calculates and reports the following equipment information: • Truck Hours and Number of Trucks by o Period, o Cut, and o Material type and cutoff within a cut. • Shovel Hours and Number of Shovels by o Period, o Cut, and o Material type and cutoff within a cut. In addition, this script will also populate the AGDM database with the following information: 1. Populate the user-defined variables for Pushback, Bench, Destination, Truck Hours, and Shovels Hours for each cut. Note: If the cut contains multiple material types with multiple destinations, then the Destination information will be incomplete (see Number 2 below for resolution of this situation). These user-defined variables and their values can be found in the GEOMSEGMENTVFD table in the AGDM. 2. Populate the standard database variables (i.e., already setup in the empty database provided by MINTEC, inc.) in Table IPRESERVES for storage of Truck Hours by Material Type and Cutoff, Shovel Hours by Material Type and Cutoff, and Destination by Material Type and Cutoff. The eq-report.py script will generally be specified as one of the accumulation scripts under the Scripts tab on the IP Cut Design dialogue in MineSight® IP. To run eq-report.py, a cut must be current or open. This can either be a new cut prior to saving it or an existing cut that you re-open. When the eq-report.py script is run, the initial dialog is the Material Routing Overrides dialog, which allows you to modify the destinations for the various material types and adjust the cycle times for any of the calculations. Once the overrides are correct, click the OK button run the script, generate the reports, and populate the AGDM.

22nd Annual Seminar

Any specified text or gview report will pop up on the screen for review. This file opens in a text editor making it available for editing and archiving.

Page 8

Equipment Reporting in MineSight® Interactive Planner

22nd Annual Seminar

The calculation of Equipment Hours is done with the following formulas: Truck hours = Tons/tons per trip * (load time + cycletime per trip)/60min per hour/(truck efficiency/100) Shovel hours = Tons/tons per trip * load time per trip/ 60min per hour/(shovel efficiency/100) For productivities, Truck Hours = (Tons/Truck Productivity) * (Truck efficiency/ 100) Shovel Hours = (Tons/Shovel Productivity) * (Shovel efficiency/ 100) The calculation of numbers of trucks and shovels is done with the following formulas when using cycletimes: Available hours per truck = Period length in hours * (Truck availability/100) Available hours per shovel = Period length in hours * (Shovel availability/100) Number of trucks = Truck Hours/Avail. Hours per truck Number of shovels = Shovel hours/Avail. Hours per shovel

Equipment Reporting in MineSight® Interactive Planner

Page 9

22nd Annual Seminar

If you have specified a Viewer display, you will be prompted for a Geometry Object in which to store the label information. A typical equipment routing label is shown below. Since this text information is in an editable MineSight® geometry object, it can be moved, portions deleted, etc. Note that the script can also be modified by MINTEC, inc. or by the client to customize the plotted result.

When you save this cut, the following equipment information is written to the IPRESERVES Table in the AGDM

As you add cuts, the reports and AGDM are continuously updated as illustrated below with cut 10 on bench 2630

Page 10

Equipment Reporting in MineSight® Interactive Planner

22nd Annual Seminar

Equipment Reporting in MineSight® Interactive Planner

Page 11

As you can see, this powerful new set of options greatly expands the utility of MineSight® for the short-term planning engineer, and provides a quick and convenient means of calculating and reporting detailed equipment routing and usage data. These Equipment Reporting options are just one of the many ways in which MINTEC demonstrates its commitment to constant improvement to MineSight®. Please try out the new options on your own planning scenarios and evaluate them. We welcome your comments.

Page 12

22nd Annual Seminar

Equipment Reporting in MineSight® Interactive Planner