Ultimate Pit Limit Design Using Microsoft© Excel Spreadsheet

Microsoft Excel based ultimate pit limit (UPL) optimiser has been developed to determine the greatest economic value of an orebody. UPL manipulates a given geological block model to define an ultimate pit limit using either the moving cone, method or Korobov algorithm or Lerchs-Grossman technique. UPL is designed to be an adjunct to MS Excel; the cells in Excel are excellent analogue to the blocks in a geological model, providing X-Y dimensions in an easily viewable and editable state. The use of individual worksheets within an Excel workbook provides the necessary depth to a 3-D block model.