LG3DB: Optimum pit limit app

LG3DB is an application developed to determine the optimum final pit shell using an adaptation of the Lerchs-Grossmman algorithm for databases. The app performs the following tasks:

- Reads a parameter file where the user specifies the block model size (number of columns, rows, and levels), block size, model origin, block model file name (ASCII format), and slope configuration.

- Imports an ASCII file with the block model information to pre-defined tables of a database.

- Creates a gridded surface based on the block model info

- Determines block dependencies, based on slope regions.

- Creates an initial normalized graph by connecting all the blocks (strong and weak vertices) to the root of the tree.

- Performs the modified Lerch-Grossmann approach to the initial normalized graph on a bench by bench basis to determine the maximum closure, hence the optimum pit limit, along with intermediate pushbacks.

- Writes the results to the pre-defined tables on the database (strong branches, mined blocks, and block sequence).

MPROUTER: Optimum haul profile

MPROUTER determines the optimum route in terms of cycle time from a haulage network using graph theory. The app performs the following tasks:

- Reads the source/destinations nodes, and the haulage network from an ASCII file.

- Modelling of speed vs gradient curves based on historical truck performance

- Determines the optimal haulage profile and cycle time based on the required source and destination.

- Calculate loading and hauling fleet size based on a required mine production plan.