Bond calculator installation and tips
The 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 our website to the hard drive of their PC.
The calculator should be used in conjunction with the associated guidelines:
We recommend reading the guidelines prior to using the calculator.
What is the macros security warning?
The 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:
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:
- On the Tools menu, click Options.
- Click the Security tab.
- Under Macro Security, click Macro Security.
- 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.
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:
- 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)
- Underground Mine.
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 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)
Source local material, cart and spread suitable material to cap the waste rock dump (cap thickness determined by approval/licence)
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 calculator?
The 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.
The guideline and calculator supplied are current as of 1 November 2010. The guideline and calculator may be updated in the future.
Please ensure you use the latest version of the calculator.
For assistance with the use of the rehabilitation liability calculator please phone a mining inspector at your relevant department district office:
Melbourne Office: (03) 5332 5000
South West District: (03) 5336 6805
Gippsland District: (03) 5160 9011
North East District: (03) 5761 1501
North West District: (03) 5430 4444
Page last updated: 22 Oct 2019