Back
to Top

 
  • Share this page on Facebook
  • Print this page

Bond calculator Installation and Hints

Explanatory Notes

The Rehabilitation Liability Calculator is a Microsoft Excel workbook that enables the assessment of rehabilitation bonds for the mining and extractive industries.  To use the calculator, users must first download the file from the Department of Economic Development, Jobs, Transport and Resources (DEDJTR) - Earth Resources website to the hard drive of their PC.

The calculator should be used in conjunction with the associated guidelines: Establishment and Management of Rehabilitation Bonds for the Mining and Extractive Industries also available at the Energy and Earth Resources website.

Earth Resources recommends reading the guideline prior to using the Rehabilitation Liability Calculator.

What is the macros security warning

The Rehabilitation Liability Calculator contains macros.  Because macros can contain viruses, Microsoft Excel will automatically prompt a security warning when opening the calculator.  If the security level in Microsoft Excel is set too high an error message will appear:

Macro warning message

Disabling the macros will lose the functionality described below.  In order to run the macros, the security level in Microsoft Excel needs to be set to medium.  To change the security level for macro virus protection complete the following:

  1. On the Tools menu, click Options. 
  2. Click the Security tab. 
  3. Under Macro Security, click Macro Security. 
  4. Click the Security Level tab, and then select the security level you want to use.

Note:  Setting the security level to medium enables the user to choose whether or not to run the macros.

Setting the security level to medium enables the user to choose whether or not to run the macros.

How do I select a worksheet for my operation

Upon opening the spreadsheet an introduction page will appear.  This lists seven typical categories of mining or extractive operations, based on type and size:

  • Exploration;
  • Open Cut and Underground Mines;
  • Open Cut Coal Mines; 
  • Quarries > 5 ha disturbed 
  • Small Open Cut Mines and Quarries (≤ 5 ha disturbed and ≤ 5 m in depth);
  • Small Underground Mines (≤ 5ha disturbed); and
  • Underground Mine.

Instructions; Step 1. Select the type of operation. Step 2. After clicking the  

Step 1.  Select the type of operation that most closely corresponds to your site and the appropriate workbook will be automatically generated.  Each workbook consists of several worksheets.

Step 2.  After clicking the "Create New Rehabilitation Liability Workbook" button you will be prompted for a Filename for the new workbook.  This file will then be saved and the appropriate worksheets added into it.  After creating your document this file will be closed.

Note: by clicking on the "Create New Rehabilitation Liability Worksheet" button you are agreeing to the Terms and Conditions of Use.

How do I input data into the rehabilitation calculator

Activity / Description

Applicable (Y or N)

Quantity

Unit

Default Unit Rate

Alternative Unit Rate

Minor pushing, final trim, rock rake & deep rip (minor shaping and landscaping)

Y

 

Ha

$1,210.00

 

Source local material, cart and spread suitable material to cap the waste rock dump (cap thickness determined by approval/licence)

Y

 

m3

Select from List

 

The calculator contains default unit rates that are locked and cannot be edited by the user. However the user has the option to insert alternative unit rates provided evidence / quotations are available to demonstrate the rates are realistic.

How accurate is the Earth Resources calculator

The Earth Resources calculator has been designed to allow non specialist’s to undertake a self assessment of site rehabilitation.  However the accuracy of the calculator depends on:

  • The quality of the rehabilitation plan for the operation.
  • The quality of the volume and area data input by the user
  • The user having some knowledge of rehabilitation techniques.

To assist the user there are description notes for each activity that provide further detail on the scope of the works. The input of area and volume data provided by the user will have a significant effect on the accuracy of the end result.  The use of survey techniques to determine areas and volumes will significantly improve the accuracy of the result.

Currency

The guideline and calculator supplied are current as of 1 November 2010.  The guideline and calculator may be updated in the future.

The user should ensure that the latest version of the calculator is used by checking the downloadable version on the Energy and Earth Resources website.

More Information

For assistance with the use of the rehabilitation liability calculator please contact a mining inspector at your relevant DEDJTR district office:

Melbourne Office

Ph: (03) 53325000

South West District

Ph: (03) 5336 6805

Gippsland District

Ph: (03) 51609011

North East District

Ph: (03) 5761 1501

North West District

Ph: (03) 5430 4444

Disclaimer

This production may be of assistance to you but the State of Victoria and its employees do not guarantee that the publication is without flaw of any kind or is wholly appropriate for your particular purposes and therefore disclaims all liability for any error, loss or other consequences that may arise from you relying on any information in this publication.