Estimated rehabilitation cost (ERC) calculator training videos

Welcome to the training for the 2022 edition of the Estimated Rehabilitation Cost Calculator for mining. This training course will take you through all aspects of the Calculator. While these modules do go into some detail, they are generally designed to be an overview. So if at any time you need more information or specific instructions, please consult the User Guide, which is also available on the Business Queensland website below the download for the calculator. Let's get started.

Module one. This module will cover the purpose of the Calculator, some key definitions, and the major changes from the latest review. The Calculator was designed to provide a tool to calculate the Estimated Rehabilitation Cost as required by the Environmental Protection Act 1994. It allows a consistent yet generic approach to calculating the estimated rehabilitation cost for mining activities. It is also used by the Queensland Government to estimate the full cost to decommission, rehabilitate and close costing an operation.

Here are some key definitions to be aware of while using the tool. Please pause the video as required and carefully read through the definitions.

Throughout 2021 and 2022, the Calculator underwent a major revision with some key changes being made. All macros have been removed to improve functionality and stability. Several User Input Sheets have been added for the following activities: Water Storage; Water Treatment and Pumping; Ports; and Investigation Contamination.

The General Land Rehabilitation sheet is what used to be called 'Miscellaneous Activities', and is designed to collect activities that aren't included in other sheets. A Subrates and Capping Alert sheet has been added for reference. And the scope and key assumptions column in the Table of Values has been expanded to provide greater transparency for rate defaults and calculator assumptions.

A Waste Register has been added to itemised quantities multiplied by the Waste Levy. This will be covered in more detail in a later module. Rates have been reviewed, updated and made consistent across the mining and the petroleum and gas Calculators. Rates for dismantling drag lines were added and a medium risk, low permeability layer category was added to waste structures.

Welcome back to the training for the 2022 edition of the Estimated Rehabilitation Cost Calculator for mining.

Module 2. In this module we will cover how to prepare an Estimated Rehabilitation Cost.

To get started, go to the Business Queensland website and download the calculator.

You may be prompted to save this to a particular location, or it will appear down the bottom, depending on which browser you're using. Open the Calculator once it is downloaded and you will be taken to the Terms and Conditions of Use pages. By downloading the Calculator, the User agrees to the terms and conditions. Please read these carefully.

In the next tab you will find the Contents page. This tab will allow you to navigate around the Calculator and each subsequent sheet gives you the ability to come back to the Contents page.

The first tab required for starting a calculation is the Registration tab. Here you fill in some of the more general details for the mining activity. This includes: the EA number and holder; tenure IDs and site or project name; as well as the last ERC decision date and current ERC amount, which is used to calculate the difference between the total cost of this ERC and previous ERC amounts.

Further down, the User enters site details and contact information. Specifically the name and details of the assessor, who is the person preparing the Calculator and the name and details of the authorised person who is the person within your organisation who is authorised to submit this calculation to the government.

Below this is the selection of the Waste Levy. The User must select one of the options from the drop-down menu. The options are: Waste levy applies – metro zone or regional zone; waste levy does not apply because the site is not in a waste levy zone; or waste levy does not apply for another reason, in which case the User must add comments.

Once registration is complete, the User can work through the numbered User Input Sheets, entering all the details relevant for their mining activity. We will cover data entry into these sheets in later modules.

Once the data entry is complete, the user can return to the Summary tab to review the rolled-up totals. If site specific Project Management and or Environmental Maintenance and Monitoring values are justified, enter these into the cells in the Summary sheet and provide justification in the space provided. Again, these will be explained further in a later module.

Then at the end of all the sheets the user can review the Quantity Summary sheet. Filters can be used to reduce the number of rows visible.

As always, for more information or specific instructions, please consult the User Guide, which is also available on the Business Queensland website below the download for the Calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining. Module 3. This module will go over some general use concepts which are important to understand when using the calculator.

There are various ways quantities can be added to the user input sheet. However, quantities for a specific item only need to be added into one table. In most cases, the first option is the default rate table where the calculator uses the default rate as a simple cost per unit. For example, dollars per hectare for a waste rock dump. In this example, the calculator has made a number of assumptions and produced a rate that is reasonable to cover the cost to rehabilitate a waste rock dump. Some user input sheets have multiple default rate tables for the same category but allow for different units. For example, you can enter roads by length or by area in the corresponding default rate table. Each road only needs to be added to one or the other, not both.

Then there are user defined tables which allow the users the flexibility to change specific aspects of the calculation to ultimately create a cost specific to that item. Again, if you enter an item into the user defined table, you do not need to add it to the default rate table and vice versa. The default rates included in the calculator generally include all activities reasonably anticipated to be required for a particular activity. Specifically, decommissioning, demolition, removal, disposal and storage rehabilitation of land are all included unless otherwise stated.

Arid environments are now included in the calculator as an alternative to pasture or native. The rates for arid do not include growth media and seeding. Arid environments are desert, whereby vegetation is absent. For example, Southwest Qld.

While a lot of Excel functionality is locked to prevent changes being made to the format and layout of the calculator, the standard freeze panes function is accessible so the user is able to freeze or unfreeze columns and rows to assist with viewing and use.

The calculator is colour-coded to visually assist the user in identifying which cells are for user entered data and which cells are for reference, calculation, error, etc. The key to the colour code is located in the contents tab of the calculator and displayed here. Of note, the green and yellow cells are the only cells that will allow user entering.

Much of the data entry is quantity of different units. The unit of the quantity the user is required to enter can be found in the next column on the same row or in the title of the field. It is important to check the unit you are required to enter to avoid any miscalculations. The calculator includes numerous areas that allow the user to add comments. These are important in justifying to the department why you have chosen certain values, or why alternate rates have been entered. At the top of all user input sheets there is space available to enter any general comments about the items in that sheet that will help the department with their assessment. In the pits sheet, the user must describe how the pit area was calculated at the end of the first table. In the capping alerts sheet, the user must justify capping thicknesses less than the defaults, if used. In the registration sheet, the user must explain why the waste levy does not apply to that site, if this is selected. In the summary sheet, the user must explain why an alternate project management or maintenance and monitoring rate was used if entered.

And as mentioned earlier, the yellow cells allowed the user to enter an alternate rate as an alternative to the default rate. The calculator will check if an alternate rate has been entered and if so, use that in the calculations instead of the default rate. The cell will turn red to highlight to the department that an alternate rate has been used and to remind the user that a justification is required. If an alternate rate is entered, the user must provide a justification for this rate in the space provided at the end of the corresponding table.

The calculator uses hyperlinks throughout the workbook to allow for easy navigation between sheets. The contents page which we looked at earlier is a great place to start. As mentioned, all sheets have a hyperlink back to the contents page located at the top of the sheet. Sheets that require the user to Scroll down a long way have hyperlinks at the top of each table that will quickly return the user to the top of the sheet. Some sheets also have handy hyperlinks to jump to specific parts of the sheet. To search for something in the calculator, simply use Excel search function or control F to find specific words.

Some field headings throughout the calculator have additional popup text that displays when the cell is clicked on to help the user better understand what is required to be entered into that field. These cells are identified with an asterisk. Drop down menus feature throughout the calculator and are a quick, easy way of selecting options. Drop down menus are identified by the red text at the top of the column.

Each user input sheet includes a column on the left hand side of the table for each activity to allow the entry of a map ID. The map ID allows an entry which corresponds to a company specific GIS or other referencing system. A map ID must be entered where spatial data is provided which aligns with that line item of the calculator. Multiple map IDs can be entered, separated by commas, if there is more than one identifying code or number for a particular item.

Most user input tables allow space for additional user entered items that fit within the category of the table but are not otherwise included in the calculator. The user must enter the quantity, the units and the rate for the user entered item. The user must also include a description of the rate used in the justification for alternate rate space at the end of the table.

The mobilization and user sheet allows space for additional user entered items that do not fit anywhere else in the calculator. As these items will form part of the final cost, the user must enter the quantity, the units and the rate for the user entered item. The user must also include a description of the item in the comment space at the end of the table.

As always, for more information or specific instructions, please consult the user guide, which is also available on the business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining.

Module 4. In this module we will go into a bit more detail about all of the sheets.

There are 15 user input sheets that allow user input for each of the domains as well as several other sheets summarising information, reporting errors, listing default values, or simply for reference or look up.

The user input sheets comprise of rolled up rates, which we've been referring to as defaults, in single line or user defined input tables that build up the activity to calculate the total cost of the element. All user input sheets are filled out from left to right and only information relevant to a particular element needs to be entered. Where defaults are listed and no information is entered by the user, the default value will be used in the calculation.

The structure of each input sheet is similar with header rows providing the domain name, a hyperlink back to contents, and the total cost for the individual sheet and the total ERC for the site. Each table then has its own header containing the field headings. Each sheet has a use and notes section at the top explaining what the sheet is for. Later we will look at some of these sheets in more detail in the worked examples, but for more information on each sheet please consult the user guide.

As always, for more information or specific instructions, please consult the user guide, which is also available on the business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining.

Module 5. In this module we will focus on some particular items in more detail as they are important to understand while using the calculator.

Firstly, there are several multipliers that get applied to the total cost. These can be found in the summary sheet and were briefly mentioned in Module 2. The first is the project management multiplier, which is calculated at 10% of the total ERC amount. Generally, this covers the cost to government for the management and the rehabilitation activity, and includes things like planning and permits, procurement, stakeholder engagement and legal costs. The user can specify their own project management multiplier, and if so, must provide justification in the space provided and attach the relevant quotes to their ERC calculation. The environmental maintenance and monitoring multiplier is calculated at 5% of the total ERC amount. This covers post closure maintenance activities like minor repairs, revegetation, weed management, and fence and signage repairs. It also covers a wide range of post closure monitoring activities, which include inspections, assessments, surveys, and reporting. Again, the user can specify their own environmental maintenance and monitoring multiplier, and if so must provide justification in the space provided and attach the relevant quotes to their ERC application. The calculator also applies a contingency of 10% to account for general uncertainties in the cost estimation and recognise that assumptions are being made for the default rates.

The waste levy is a new addition in the 2022 version of the calculator, and it is designed to account for specific types of waste that go to landfill in Queensland. This levy only applies if your mining activity falls within one of the specified areas. For the ERC, concrete, bitumen, asbestos (free and within soil), solid salt and contaminated soil are the primary wastes to which the levy may apply. Steel, copper, and other metals are not considered a waste as they have value as scrap. Consistent with the policy decision on scrap, scrap value is not offset. The calculator does not charge a gate fee or levy on these materials but does allow for transport to a facility. We will go into more detail on the waste levy register as a worked example in a later module.

Capping is relevant for overburden dumps and waste rock dumps, heap leach pads and tailings storage facilities. Capping is the layers placed over the top of these items to make them safe and generally consist of a working rock layer, capillary break layer, a low permeability layer and growth media. The makeup and thickness of these layers is dependent on the risk category chosen by the user for that item. The user must provide notes for the rationale behind the risk category selected. For details on the characteristics of waste rock, heap leach and tailings for each category, please see the detailed descriptions in the user guide. The calculator allows the flexibility for the user to enter capping thicknesses less than the defaults. If this occurs, it will raise an alert in the capping alert sheet and the user must provide justification against this alert.

Revegetation is primarily broken into two categories with a third option for certain circumstances. They are Pasture, Native and Arid. The default rates throughout the calculator generally include the cost of seeding, so the user is not required to enter additional revegetation costs elsewhere. If seeding is not included, it is specifically stated in the rate scope. The General Land Rehabilitation sheet includes additional rows to cover revegetation of land not covered by other sheets. Such occurrences are likely rare and may include land where preliminary work like clearing for an activity was undertaken, but the activity did not go ahead.

The calculator applies a haulage rate in numerous locations throughout to take into account the transport of materials or decommissioned equipment. The default rates that include haulage, as described in their scope and assumptions, calculate the cost for transport for several material or item types and for both ways out and back. Where a distance selection is made, this distance is considered one way as the back-end calculations account for the return trip.

A range of fleet sizes is included in several input sheets to reflect the varying size of rehabilitation projects. The fleet size selected depends on the activity being undertaken and the quantity of material being moved. For more detail on the types of activities for different fleet sizes, please consult the user guide. Mobilisation of fleet is calculated based on a round trip or mobilisation and demobilisation. However, the distance the users select is the one way distance. The user must decide what is reasonably appropriate to this mining activity and choose a distance range and fleet size. For example, if the closest major centre where fleet would be sourced is 280 kilometres away, the user would select the 150 to 500 kilometre range. Then for each range there is a corresponding fleet size. If the total cost of the ERC is less than $1,000,000 then the small project mobilisation rate can be used by placing a 1 in the summary sheet.

As always, for more information or specific instructions, please consult the user guide, which is also available on the business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining. This is Module 6. In this module we will work through examples for the eligible mining activities and exploration sheets.

As per the ERC guideline, certain resource activities are authorised with standard conditions if they satisfy the eligibility criteria for the relevant ERA standard under the Environmental Protection Act 1994. The relevant standards are prescribed under the Environmental Protection Regulation 2019. The eligible mining activity sheet can be used to calculate the ERC for an eligible mining activity on a mining lease only. As such, if the user's environmental authority was approved through a standard or variation EA application, and relates to mining lease activities, the user can choose to use the calculator and should enter all elements for the site in this sheet.

The eligible mining activity sheet is straightforward to use. Quantities added to the quantity column are multiplied by the default rate or an alternative rate if entered by the user. As for all the sheets, if an alternate rate is added, the user must provide justification. Please note the units for each of the line items. Some are dimension quantities, such as length and area, and others are item quantities, such as number of holes. At the bottom of the sheet, there are several rows available for the user to enter elements that are not included in the above line items. If a quantity is entered without a unit rate, an alert is raised. All the costs are summed up and reported to the summary sheet. One minor change from the previous revision of the calculator is that the rates do not include land rehabilitation, and these must be added to the seeding of past areas and seeding of native areas rows. The user adds up all the land that will require rehabilitation and enters the total quantities to these rows. The user is encouraged to explain the breakup of the entries. Land rehabilitation of drill holes has separate rows as the areas are typically small.

The exploration user input sheet includes tables for activities typical to the exploration phase of a mining project, including seismic surveys, drill holes, roads and tracks, small water structures and disturbances from contractor owned infrastructure and equipment such as camps and water treatment plants. Some users may only need to use this sheet to complete their ERC calculation. The first two tables are for seismic easements, gridlines, and minor tracks. The first has default rates based on the length of disturbance and the second is based on the area of disturbance. The general principle throughout the calculator is that if a quantity is entered into one table, it does not then need to be added into a second table. This is a good example of that concept in that the user does not have to enter quantities to both the by length and by area tables for the same disturbance. The inclusion of two tables, one by length and one by area, recognises that companies have data in different formats. Some maintain GIS systems that output area-based polygons and others may have lengths measured in the field. The user enters the total area or length of disturbance, and the default calculation multiplies the total disturbance area or length by the default proportion shown. This recognises that disturbances associated with such activities are typically minor. The user can also enter their own rehabilitation area or length if it can be justified. There are three options depending on the land type, pasture, native and arid, or desert land.

The next two tables are for tracks and roads. Similar to the seismic easement tables, the first has default rates based on the length of road with a default width and the second requires just the area disturbed by the track or road to be entered. For the by length table, it is not expected that the roads and tracks have exactly the width mentioned but should be close to. For example, if the average width of a track is five metres, the six-metre-wide selection should be used.

The next table has a selection of bores with several different treatments, including plugging, backfilling with cuttings, and grouting. The user selects the most applicable treatment based on their knowledge of the bores on the site and their experience. The last row of the default rates is exploration sump, which has a different unit to the bores.

The next table is for dams and ponds and includes a range of lined and unlined structures by size category. The area to be entered is the crest area of the water structure. Where multiple water structures fit in the same category, the user can enter the total area for all water structures of that category in the relevant row. So, for example, if a site has three lined four megalitre ponds, each of a crest area of one hectare, the entry is three hectares into the three point five to seven point five megalitre category. The default rate does not include any water to be pumped and or treated. If water is to be pumped or treated, it must be entered into the water treatment sheet.

The next table is for rehabilitation of land upon which third party plant and equipment are installed. The primary examples are camps owned by a contractor and water treatment plants owned by a vendor. The assumption in these cases is the contractor and vendor is responsible for costs associated with the removal of the infrastructure and plant, and the environmental authority holder is only responsible for costs associated with the land rehabilitation. Similar to the other sheets, the total costs for each table are summed and sent to the summary table to be added to the total estimated rehabilitation cost.

As always, for more information or specific instructions, please consult the user guide, which is also available on the business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the Estimated Rehabilitation Cost Calculator for mining. This is Module 7. In this module we will work through examples for the Infrastructure sheet and Process Equipment sheet.

The Infrastructure sheet includes several tables to account for costs associated with disconnection of services and decommissioning of camps, buildings and ancillary infrastructure, and the restoration of disturbances associated with tracks and roads, lay down areas and borrow pits.

This sheet is the longest in the workbook and has a set of hyperlinks at the top to quickly access each table. The tables then have a hyperlink that will take the User back to the top of the sheet. Most of the tables are simple to use, with entered quantities multiplied by either the Default Rate or an Alternate Rate entered by the User with justification.

The first table is for disconnection of services, which includes electrical power, gas, water and communications. The table has an entry for major suppliers to a site and a second row for other remote areas of the site with dedicated services.

The next two tables are for tracks and roads. The first has Default Rates based on the length of a road with a default width and the second requires just the area disturbed by the track or road to be entered. The general principles throughout the calculator is that if a quantity is entered into one table, it does not then need to be entered into a second table. This is a good example of that concept in that the user does not have to enter quantities to both the by length and by area tables for the same disturbance.

The inclusion of two tables, one by length and one by area, recognises that companies have data in different formats. Some maintain GIS systems that output area based polygons and others may have lengths measured in the field. For the by length tables, it is not expected that the roads and tracks have exactly the width mentioned, but should be close to. For example, if the average width of a track is five meters, the six meter wide selection should be used.

The next table allows the user to build their own road or track rate. As is typical for user build tables throughout the Calculator, the table starts with map ID and the name of the road or track. Groups of roads or tracks can be entered here, and if this is the case, the total length of all the roads must be entered. If a grouping is applied to a row, the road and track must have similar characteristics.

The first entry is the width of the road and a default is used if the user does not enter a width. The total length of the road or track or groups of roads and tracks is the key entry for this table. The next column allows the user to select the surface covering. The tracks and roads table in infrastructure have more options than those in exploration with default rates for tracks and roads covered with gravel, bitumen or waste rock, and for tracks and roads where the rock is removed with the assumption that it is contaminated and then replaced with clean rock to restore the road function.

The assumption with earthen tracks is that they only require ripping and revegetation if in pasture or native land. Earthen tracks in arid desert environments do not require growth media or seeding. For the purpose of the calculator gravel, rock and bitumen are treated in the same manner. The default assumption in this table is that surface covering is not replaced, however this can be set to 0 if the surface covering is to be replaced.

The next default is the thickness of the surface covering and the user can enter their own that will supersede the default. The volume of surface covering to remove is then calculated. The next section is used if the surface covering such as rock will be replaced. As an example, if a 10 kilometre gravel road will have the gravel removed because it is contaminated and then replaced with new, the user must enter 10 kilometres into this column.

The thickness of return rock uses a similar default method. The volume of rock to replace is calculated using either the defaults or the user entered values. For growth media and vegetation the default assumption is that the area is the total area of the road or track or group of roads or tracks, but the user can set this to 0 if, for example, the disturbance is in arid desert land.

The next section of the table works similar to all other tables in that the user can select the proportion of land that will be returned to pasture and native, or set both of those to 0 if the land is in the desert. If the total proportion of land allocated by the user does not equal 100%, an alert will be raised in this column.

The next section of the table is for fleet selection, with the first grouping being the distance to haul the material removed from the track or road, and the fleet size that will undertake the work. Keep in mind that anywhere there is a distant selection for fleet, it is for a one-way trip as the Calculator will calculate the return trip in the background. For example, if the distance to haul is 1.5 kilometres, the user would select the >1000 to <=1500 metre range.

The next fleet selection is for the distance that the surface cover material will be returned to recover the road, and the fleet size that will undertake the work. The final fleet selection is haulage of growth media, and the fleet size that will undertake that work. The selections of haulage distance and fleet sizes determine the unit rates in the next section and these rates are multiplied by the volume calculated in the earlier part of the table, to arrive at the total for each activity. The total of the activities are then summed to create a total for each row.

Above the table in this area are opportunities for the user to enter alternate rates for various activities if they can be justified. Justification for any alternate rates is entered into the justification for alternate rates column. The next table works similarly to the table just described, but the main input is the area of the road rather than the length and width. The next table is to account for costs associated with road and watercourse overpasses and is a simple enter the quantity approach.

The mine haul road set of tables works the same as the tracks and roads tables described previously, just with different assumptions. For example, a mine haul road is assumed to be much wider and have thicker surface covering than typical light vehicle access roads.

The lay down yard tables also work similarly to the tracks and roads tables. The first table is a default rate table where the user need only enter the area of the lay down or group of lay down areas, and the next table is a user build table which works similarly to the user build tables described previously.

The borrow pit table is a simple enter the area for each pit or group of pits in the different types of land. The next two tables are for pipelines not associated with plants and facilities. The general assumption is pipelines associated with processing facilities, for example, are included in those rates.

These pipeline tables are for pipelines that cannot reasonably be associated with a particular plant, for example, pipelines running from a pit to a processing plant. The user build table requires the length of pipe or group of pipes to be entered. The user then selects whether the pipe is to be flushed, whether each end will be cut and capped, and whether the pipe will be removed. The final part of the table is growth media and vegetation that works exactly the same as the other tables.

Two tables are available for camps. The first has default rates by size and type, that is temporary or permanent camp, and the second table by area. The by size category default rates include all the activities that can be reasonably associated with decommissioning and demolition of a camp and subsequent land rehabilitation. The camps do not include major refueling systems or land investigations, with the assumption that such activities are not always associated with camps. If these activities are associated with the camp, they must be entered separately.

The by area default rates for the camps account for typical infrastructure associated with the camp and an allowance for the vacant space between modules. Typically, it is reasonable to assume the land on which the camps sits is included in the rates.

The user will make the decision as to whether a camp is temporary or permanent, but typically any camp that is in use for more than two years should be considered permanent for the purposes of the ERC. The user can make a case for a camp being temporary if they can demonstrate things such as surface coverings are gravel or compressed earth with no concrete or bitumen and the absence of recreational facilities, such as tennis courts and gymnasiums.

For small mining operations and where camps are designed for a few people only, five or less, and comprised of simple infrastructure, the user can either enter alternate rates, use the small portable structures rate, or use the small temporary camp by area rate.

For a camp comprising of a caravan or one or two tents, one entry of the small portable structures rate may be sufficient. For larger but still simple and small camps, the small temporary camp by area rate is most likely more appropriate. The portable buildings table is for demountable type items, typically associated with temporary offices or crib rooms.

As with all default rates, transport of waste, scrap and reusable material is included in the rate and does not need to be added separately. Consistent with the ERC policy, the calculator does not offset the value of reusable material or scrap against the cost of demolition. The calculator does acknowledge that scrap steel will have a value and recognises this in setting the gate fee to zero. Similarly, equipment and structures that will likely have a reuse are assumed to be stored at zero cost rather than demolished and disposed.

The remaining tables are simple to use and understand. Consistent with the approach taken throughout the calculator, tables such as concrete and bitumen do not need to account for costs associated with plants and infrastructure included in other tables. Rather, it is to capture any disturbance that is clearly separate to the other items. For example, airstrips are not included in the assumptions for any of the default rates and must be entered into the concrete hard stand table.

The approach to the calculation of a default rate for sewage treatment plants has changed for this revision, with the unit being the capacity in kiloliters per day of the plant. This accounts for the plant infrastructure and equipment and land rehabilitation. Consistent with the approach throughout the calculator, the fencing table is not designed to capture fencing around plants and facilities as those default rates include an allowance.

The small ancillary table is for discrete facilities separate to major plant facilities, or which cannot be reasonably assumed to be included in those facilities. For example, fuel filling stations are not included in the default rates for camps. Consequently, if a filling station is associated with a camp, it must be included in this table. Similarly, the tanks table is for discrete tanks that cannot reasonably be assumed to be included in other plants and facilities. As in other sheets, the subtotals for each table are summed and then those totals are added to the total for the sheet and then displayed in the summary sheet.

The process equipment sheet is simple to use in that quantities entered to each row are multiplied by either the default rate or the user entered alternative rate with justification. Consistent with the general approach in the calculator, the rates include all activities that can be reasonably expected to be associated with the particular item. For example, the dragline rates include dismantling and demolishing the machine and managing waste and reusable materials.

The sheet includes an optional table below the main costing table whereby the user can collate quantities. The intent is to clearly show where the quantities have come from, as the user can list that item in the table and assign quantities accordingly. These quantities are automatically populated into the cost table above and added to any additional entries made in the cost table. Consistent with the general concepts throughout the calculator, if entries are made into one table, in this case the quantities table below the cost table, they do not then need to be added to the cost table. Note there is one exception to this rule and that will be discussed in the ports sheet.

As in the other sheets, the totals for each row are added up and the overall total reported to the summary sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining. This is Module 8. In this module we will work through some examples in the water storage and the water treatment and pumping sheets.

The water storage sheet includes three tables. The first is water storage by category and capacity, the second is by crest area, and the third allows the user to build their own rate. The first two rows in the first table are different to the remainder of the table and allow for any small clean water type structures.

Rows in the remainder of the table include three drop-down menus defining the water structure or group of structures. The first drop-down menu determines the type of dam or pond. This selection primarily determines the thickness of sediment or sludge and whether the dam or pond is lined. The assumption is process and raw water dams are lined, and evaporation and other dams are not lined.

The next column is the selection of the water capacity at crest level and this determines quantities such as the volume of soil in bund walls that has to be moved. The last drop-down column is for the land type. If arid is selected because the site is in a desert area, no growth media or vegetation are included in the costs. The combination of the selections determines the default rates and this is multiplied by the number of structures in the row to get the total cost for that row.

The next table allows the user to enter dams and ponds based on whether they are lined or unlined and by area. The area quantity is the crest area of the dam or pond, or group of dams and ponds. The last table allows the user to build their own rate using some defaults set by the calculator. The calculation works out the cost of one dam or pond in the row and then multiplies it by the number of structures entered into this column. This is important because the entries throughout the table are for one dam or pond and only at the very end is the cost multiplied by the number of structures entered by the user in that row.

This is different to the other tables in this sheet. The user must enter at least a 1 in the number of structures column to make this calculation work. The top of water structure area, as in the crest area, is a key entry required to make the calculation work. The user then selects whether the dam is lined or unlined and can enter a specific liner area or accept the default. If the user enters a liner area less than the crest area an alert is shown and either the user needs to change the entries or explain why the liner area is less than the crest area. The liner area is multiplied by the default rates to calculate the cost for demolishing the liner and managing the waste.

The wall push in section is the bunds being demolished and pushed in for backfill. The wall height above ground service, width at top, and slope are key parameters that make the calculation work. The user can enter a specific cross-sectional area, in which case those values do not need to be entered. The linear length of bund wall is calculated by a simple square root of the area, but the user can enter a specific linear length of bunds. From these entries, the volume of soil in the bunds is calculated and this is multiplied by the default rate to obtain the total cost for this activity. The next section of the table is for sediment or sludge removal and management, and the user can enter their own thickness or accept the default as shown. The combination of crest area and sediment thickness calculate the sediment volume and this is multiplied by the default rate to calculate the total cost for sediment and sludge removal.

The growth media and revegetation section of the calculator works the same as the other tables in other sheets. The growth media area defaults to the crest area, but the user can enter a specific value or a specific growth media thickness. The combination of entries creates the growth media volume and this is multiplied by the default rate to calculate the cost associated with the application of growth media. Similarly with the seeding area, the default is to the crest area, but the user can enter a specific seeding area.

The selection of land for rehabilitation works the same as the other sheets in that the user enters percentages to pasture and/or native or sets these to 0 if the land is in arid desert land. The land investigation section requires the entry of the area to investigate and the share or fraction of the upfront cost of the investigation. This second column allows for campaign type investigations whereby full upfront costs are not necessarily applicable if, for example, small dams are grouped together and the cost would be shared across those structures. This is further explained in the user guide.

In its simplest form, the share fraction of upfront cost is set to 1 and this means all the upfront costs associated with the investigation are assigned to that row. If, for example, the share is set to 0.5, the calculator assigns half of the upfront cost to the investigation for that row.

The next section of the calculator is fleet selections, with the first being the haulage distance and fleet size for sediment removal. Keep in mind that anywhere there is a distance selection for fleet it is for a one way trip as the calculator will calculate the return trip in the background. For example, if the distance to haul is 1.5 kilometres, the user would select the greater than 1000 to less than or equal to 1500 meter range.

The next is the push lengthened dozer size for pushing in the bund walls, and the last set of selections are associated with growth media. The volumes calculated at the beginning of the table are multiplied by the default rates determined by the fleet selections to get the total cost for each activity for that row. If the best assumption is that water will be present in the dam and it must be pumped, this can be added to this column. The totals for both tables are added together and reported to the summary sheet for addition to the ERC total.

The water treatment and pumping user input sheet has several options for water treatment, including adjustment of low pH water and removal of salt and organics. Correction of low pH water assumes the use of neutralisers and two rates are available, one for initial pH of 4.5 or greater and one for pH of 5.5 or greater. If a site has lower pH water, the user must supply an alternate rate.

Removal of salt is assumed to be by reverse osmosis equipment, and if this rate is used, the user must also enter the mass of salt to be loaded and hauled and disposed to a waste facility by entering the salt disposal gate fee and adding a mobilisation entry to account for the cost of implementing and decommissioning the mobile treatment unit. Removal of organics assumes the use of an oil/water separator and activated carbon.

Two evaporation rates are included for reduction of water in ponds and dams. The first assumes natural evaporation and the rate allows for a technician visiting the site periodically to monitor water levels. The rate is by dam or pond and assumes a time period to set a rate. The second rate is enhanced evaporation using a device such as an atomiser. The rate allows for power, and a technician visiting the site periodically to monitor water levels and maintain equipment. The selection of either of these rates is the choice of the user. If there is likely to be obvious time pressure on the removal of water from the ponds, then enhanced evaporation is likely to be a more appropriate rate to use.

The water pumping and transfer rate allows for water that must be managed and is not included in other input sheets. Pumping and treatment requirements for pits can be included in the user input sheet for pits. Pumping of water from dams and ponds can be entered to the user build for water structures, but treatment is not included and the default rates do not include pumping or treatment of water. If preferred, the user can enter all water management requirements in the water treatment sheet.

Rates are included for removal of evaporation fans and other water management infrastructure, dewatering plant decommissioning, and an allowance for management, establishment, engineering and operation and maintenance costs.

The dewatering plant rate is for decommissioning of company owned dewatering plants. The entry is by capacity of the system. If multiple systems are present, the user can enter the sum. For example two times 1 megaliter per day plant would require an entry of 2. There is also a user build dewatering table that we will talk about later.

In general, if any of the water treatment and management options in this table are selected, the water management, engineering, establishment, and operation and maintenance rate should also be used unless the user can justify its emission. The entries to this table are simple quantity based, but please take note of the units for each column with salt disposal by mass, the treatment and pumping rates being by volume, and the evaporation rates by dam or pond.

Mobilisation of the reverse osmosis plant if salt removal is selected is typically a 1, with these costs being adequate to support multiple mobilisations to separate sites. The quantities part of the table allows multiple entries. For example, if water contains organics and low pH, the user enters quantities to both these columns. The total for all treatments in management options is added up in the total cost column and the user can enter an alternate rate with justification for the entire area, which bypasses all the individual treatment and management options. Water management scenarios will vary from site to site depending on the mine type and degree of processing undertaken.

The user should provide sufficient information to support the determination of the volume of water to be pumped, and selection of water treatment options which will be informed by water quality results and an understanding of the mine processes. The user can enter alternate rates for each treatment or management option in the cost part of the table, and as usual, must provide justification to the right of the table if they are used.

The dewatering table allows the user to build their own rate for a company owned dewatering system for which they will be responsible for decommissioning. The table requires entries including the number of downwell pipes, the type and length of piping, and the type and number of any tanks or dams and ponds specifically associated with the dewatering system that are not included in other sheets. There is also an option for a diesel generator if this is how the dewatering system is powered. If the dewatering system is powered from the site grid, then the decommissioning of services rate in the infrastructure sheet is assumed to cover disconnection of this item. If there are no other services on the site, then it is reasonable to either use the remote services rate in the infrastructure sheet or assume a diesel generator.

As in other sheets, the totals in each table are added up and the total for the sheet or domain reported to the summary sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022  edition of the estimated rehabilitation cost calculator for mining. This is Module 9. This module covers: sheets 7 – waste rock dumps, overburden dumps, spoil piles and stockpiles; sheet 8 – heap leach pads; and sheet 9 – tailing storage facilities.

The waste rock dumps, overburden dumps, and spoil piles and stockpiles sheet has four tables. The first is the default rates of five risk categories of waste rock dump. The second is a user build table for waste rock dumps, and the third is a user build table for overburden dumps and spoil piles, and the fourth is a user build table for growth media stockpiles. The total cost is summed at the bottom of each table and the total cost for the sheet or domain is shown in the top ribbon. The total estimated rehabilitation cost is also shown at the top of the ribbon so the user can see how the overall estimated rehabilitation cost is changing with inputs into this specific sheet.

Let's look at the waste rock dump default table first. As for all input sheets, the first column is the map identification for that particular item. Column D allows the user to enter the name of the waste rock dump. The area column requires the user to input the total area of the waste rock dump that will require rehabilitation. This is a key entry to this table and must be entered for any line the user inputs to. The user must select a risk category from the drop-down menu in the risk category column. The presence of a drop-down menu is indicated by the red ‘select from dropdown’ text.

The risk categories are described further in the user guide. The selection of the risk category is a critical part of the calculation, and the user is encouraged to provide information to support their selection. As you can see, the use of this table is easy. You enter an area and select a risk category and the cost is calculated. As in other input sheets, if an alternate rate is justified for that line item, the user enters it into the alternate rate column and the cost for the line item is calculated based on the alternate rate. Note that the unit for the alternate rate in this case is dollars per hectare, and this gets multiplied by the area. Don't forget to add a justification in the alternate rate justification cell and the user is encouraged to provide sufficient detail to inform the department as to why an alternate rate is justified.

Now we move on to the second table, which is the user build for waste rock dumps. If you enter a waste rock dump into the defaults table we just spoke about, you do not need to enter it into any other table, including this user build table. This is a general principle throughout the calculator, in that you should not have to enter any quantities into more than one table. The user enters the map ID and the name of the waste rock dump. Like all other user build tables in the calculator, this table is broken into sections across the columns to aid understanding. The first set of columns is general details and dimensions associated with the waste rock dump. This is where the user enters the total footprint of the waste rock dump and selects the risk category, which in turn selects an appropriate default for capping thicknesses. The user enters areas and thicknesses of flat areas such as tops and benches, the slopes and batters, and the area of the ramps. You will see that the flat areas is linked to the total footprint of the waste rock dump and that is because generally the flat area will be approximately the total footprint area. However, if the user has more detailed information, they can change the flat area.

This is a general concept throughout the calculator in that if a quantity is typically equal to another quantity, it will be linked, but if the cell is green, the calculator acknowledges the user may have more detailed information and can enter it.

The next section in the table is focused on reshaping and dozing the waste rock dump. The user selects the reprofiled slope angle from the drop-down menu. If the user has specific volume quantities, they can enter it directly. Otherwise the calculator calculates the volume based on the entries added earlier. Similarly, the user can enter their own quantity into the user volume to push slopes column. Otherwise the calculator calculates that quantity. In the reshaped length of dozer push and fleet for reshaped columns, the user selects the dozer size and length of push specific to the reshaping activities.

The selection of these two items determines the dollars per cubic meter rate that will be applied to the total column, and the dozer and slope angle determined the unit rate for slope areas. The first of these comes from subrates table 2 and the user can click on the hyperlink to reference the full range of those rates. Similarly for the slope dollars per hectare rate, the hyperlink takes the user to this table, subrates table 3. The next two columns are the totals for these activities. The cost for dozer push all areas being the volume of material to be pushed by the dozer multiplied by that unit rate. The cost to doze and shape slopes and ramps column is the dollars per hectare rate multiplied by the total area to reshape.

One thing to note for dozer selections, which is common throughout the calculator, is that the smaller dozers cannot push as far as larger ones. So if the user selects a dozer that is not capable of achieving the selected length of dozer push the calculator will communicate an error and the cost totals will also be in error. In this case the user must reselect a larger dozer that can achieve the selected push length.

The next section is the rock armour placed over the waste material to provide stability. The first column, default slope break rock armour cover thickness shows the default thickness drawn from the capping table at the top of the sheet. The user can access this table through the hyperlink shown. The user can enter their own cover thickness in the user slope armour cover thickness column, and if a thickness less than the default is entered, they must provide justification in the capping alert sheet. You can see if we enter 0.5 instead of 1 an alert will be reported against that dump in the capping alert sheet and the user must provide the justification.

You can easily move between sheets as indicated previously by clicking on the contents hyperlink and then navigating back to the waste rock dump sheet. The rest of the rock armour table proceeds similarly to the previous table whereby the user can enter their own rock volume if they can justify it or accept the calculation. The user then selects the fleet size from the drop-down menu, which then selects the appropriate dollars per cubic meter rate and this is multiplied by the rock cover volume to get the total cost for that cover.

The capillary break layer is the next section of the table and operates similarly to the previous sections, whereby the user can enter the area that will be covered with the capillary break layer, and if so provide justification or accept the calculation, which defaults to the area of the waste rock dump. The default capillary break layer thickness is shown and the user can hyperlink to the table to see the range of values against each risk category. The user can enter their site-specific capillary break layer thickness and if it is less than the default, they must provide justification in the capping alert sheet. The user can enter a specific capillary break volume or accept the calculation, and this is multiplied by the dollars per cubic meter rate determined by the fleet selections to obtain a total for the source and prepare capillary break layer material.

This table also includes costs for the haulage of the capillary break layer material, starting with fleet size selection, which determines the appropriate unit rate, and this is multiplied by the volume again to get the costs for that activity. The last bit of this section for capillary break layers is the dozer push for the material and the total cost of which is determined by the fleet selections which determines the unit rate. The total cost for the capillary break layer is the sum of the three activities determined in the preceding columns.

The low permeability layer is the next section of the table and operates similarly to the previous sections, whereby the user can enter the area that will be covered with the low permeability layer and if so provide justification or accept the calculation, which defaults to the area of the waste rock dump. The default low permeability layer thickness is shown in this box and the user can hyperlink to the table to see the range of values against each risk category.

The user can then enter a specific low permeability layer volume or accept the calculation, and this is multiplied by the dollars per cubic meter rate determined by the fleet selections to obtain a total for sourcing and preparing the low permeability layer material. The next section of this table allows the user to select whether the low permeability clay will be obtained locally or must be sourced some distance from the site. If local is selected in the source for low permeability capping column, the calculator sets the long haul rates to zero and accepts the calculation in the source, prepare, place and compact low permeability layer material column.

If long haul is selected, the rate in low permeability unit rate is reduced and the long haul rates are used. For long haul the user must select the one-way distance from the drop-down menu in distance one-way for low permeability capping. The distance to the source site is one way and this selection determines the unit rate in dollars per cubic meter per kilometre. The user can hyperlink to subrates table 9 to see how these rates change with distance. For long haul, the transport costs just calculated is then added to the purchase cost dollars per cubic meter to obtain a total cost for the long haul of the capping material. The user can bypass this calculation and directly enter their own delivered to site costs in dollars per cubic meter in the user clay delivered to site column. If this is entered, they must provide justification. The combination of costs are then added to obtain the total cost for the low permeability layers.

The next section of the table is the top rock capping and this works similarly to the other sections. The surface area for top rock defaults to the surface area footprint for the waste rock dump, but the user can enter a site-specific value if they can justify it. The default layer thickness is determined by the risk category and the range of values is in the capping values table at the top of the sheets accessed by the hyperlink. Similarly to other sheets the user can enter specific thicknesses and volumes with justification or accept the calculations. The load and haul top rock unit rates are determined by the fleet selections and the sub cost determined by multiplication of the rate with the volume.

The next section of the table is for additional capping that may be entered. The additional capping will be determined by the user. The entries here are very simple in that the area for each particular type of capping, geofabric, geosynthetic layer, and geomembrane are entered and the rate for those is drawn from subrates table 5. The total is then displayed in the total for geo layers column. The next section of the table is for management of drains and water management, and again these are simple entries whereby the total area is entered and multiplied by the default unit rates. The user can enter a water management earthworks cost as a total cost, and justification must be supplied.

The next section of the table is for the application of growth media, soil amendments, and vegetation. The growth media section of the table works similarly to other sheets. A default thickness is supplied and reference from the capping values table at the top of the sheet. The user can enter their own thickness or their own volume, and the calculation uses whichever combination is entered. The growth media load and haul rate is drawn from subrates table 1, depending on the selection of haulage distance and fleet size the user selects. The growth media table includes a local and long haul selection similar to that described previously, and allows an alternate rate of dollars per cubic meter for growth media to be entered directly. The combinations of entries entered determines the total cost for growth media.

The next section of the table is for soil amendments and includes the options you can see in the drop-down menu. The table allows three soil amendments to be added, so the user can enter a combination of amendments and enter the specific area upon which that soil amendment will be added. In each case, the user can enter a site-specific dollars per hectare rate and provide justification for its use. The soil amendments include assumptions for the application rates, and these are shown in subrates table 14. The user cannot change the application rate in the waste structures table, but can enter a site-specific example to the general land rehabilitation sheet and change the application rate in that sheet. Consequently if required, the user could add the soil amendment for a waste rock dump or other structure in the general land rehabilitation sheet and enter their own application rate there. If the user chooses to do this, please provide information for the department to review.

The default for seeding is pastureland, but the user can change the mix depending on what the specific land type that area will be returned. The alert if land types do not equal 100% column alerts the user if they have added numbers that are greater than 100% of the land area. If the waste rock structure is in a desert area where vegetation is not expected, the user enter 0% in the proportion pasture land and proportion native land and this will create 100% proportion arid land, setting the seeding cost to 0. Depending on the selection the calculator uses the rates for seeding of pasture or native land, or zero if 100% arid, or takes the alternate rate entered by the user. If an alternate rate is added, the user must provide justification. The last section of the table is for permeability testing, engineering and other activities. The area for the permeability testing column defaults to the footprint of the waste rock dump and the number of points per hectare defaults to the number shown. The user can enter their own number of points per hectare and must provide justification.

Depending on these selections, the total cost for permeability testing is then calculated. The rate for engineering, which includes items such as groundwater assessments, modelling studies, landform design, engineering plans, work plans, and supervision references the capping values table at the top of the sheet. The user can enter their own dollars per hectare rate with justification. The user other activity columns allows the user to enter any other costs that must be attributed to the waste rock dump, and the user is encouraged to provide information to alert the department as to what these costs are. The total cost for waste rock dump is then shown in the total cost waste rock dump column and that cost is divided by the total footprint area to give a dollar per hectare rate. There is a check column which shows an error if incorrect entries have been added. This is primarily an incorrect dozer selection, which will be shown in those sections. If an error is shown, the user must go back and rectify. Justification for alternate rates can be added to the next column. The third and fourth tables in the waste rock dump, overburden dump, spoil piles and stockpiles are simple versions of the waste rock dump user build and use the same concepts as described for the user build table.

The heap leach pad and tailing storage facility sheets operate almost identically to the first two tables in the waste rock dump and piles sheet. There is one addition to heap leach pads and that is flushing. The flushing of the heap leach pads assumes the area is the footprint of the pad, but the user can enter their site-specific area. The user enters the thickness of the pad to be flushed and the calculator calculates the volume. If the user enters a site-specific volume the calculator uses that volume. The volume is multiplied by the heap leach pad flushing default rate to obtain the total cost for flushing, and this is added to the heap leach pad total. As with all the sheets, the totals in each table are added up and the total for each sheet or domain reported to the summary sheet.

As always, for more information or specific instructions, please consult the user guide, which is also available on the Business Queensland website below the download for the calculator.

See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining.

This is Module 10. In this module we'll work through examples in the user input sheets for pits and underground mines.

The pits sheet comprises of five treatments including safety bunding and fencing, blasting of benches and highwall, reshaping and making safe low walls, backfilling open pits, and backfilling/rehabilitating open pit ramps. The sheet works a little differently to others in that pit inputs such as backfill volume entered to the top table, flow down into the appropriate treatment tables. The calculated cost flows back up from the treatment tables to the basic pit information to give a total cost for each pit and the overall total cost for the pit domain. As in other sheets, the total cost for this input sheet is shown at the very top of the sheet as well as the overall total estimated rehabilitation cost.

The treatment tables can be accessed by hyperlinks in the top ribbon of the sheet. We will enter inputs and then use the hyperlinks to go down to each treatment table. As in all the sheets the user enters the map ID and then the name of the element, the pit in this case. The open pit void surface area is the first input in the basic information section and this is used in the backfill open pit table and as a general reference in other tables.

The next input is the safety bund or highwall length, and this is used in the safety bund and fencing table that we will go to now via the hyperlink at the top ribbon. You can see the map ID, the name of the pit, the open pit void surface area, and the safety bund length automatically populate in the safety bund and fencing table from the basic pit information. For bund construction, there are defaults as shown, but the user can enter their own bund height, bund base width, and bund top, and the bund specific volume in cubic meters per meter of bund length is calculated from these inputs multiplied by a swell allowance as shown. If the user enters these values the calculation uses those entries, otherwise the defaults are used. The next column calculates the volume of material in the bund. The bund surface preparation column calculates the cost to prepare the surface using the footprint calculated from the safety bund length and the bund base width. The safety bund construction method column allows the user to select whether the bund will be constructed by hauling material and placing it, or whether a local excavation will be undertaken to construct the bund.

If excavate and place is selected, the next column excavate and place calculates the cost to undertake this activity, multiplying the bund length by the default unit rate or the alternate rate if the user enters one. As in other sheets, if the user enters an alternate rate, they must provide justification in the column to the far right. For the hall in place option, the user can either select the distance from which they will source the material or accept the default of four kilometres. The user selects no from the drop-down menu in the user input haulage distance column if they wish to accept the default. If the user selects yes in the user input haulage distance column, they then must select the distance from which material will be sourced and the appropriate fleet size. The selections determine the load and haul rate in dollars per cubic meter, and this is multiplied by the total volume of the bund to get the total cost to load and haul the material to the construction site. The total cost for safety bund construction is then shown in the next column.

The next part of the table is for fencing and signage, and the default length for fencing is 1.2 times the length of the bund input by the user, to account for the offset distance of the fence from the bund. The user can change this length and is encouraged to provide information to the department if they do so. The next input is for highwall security fencing. These inputs are multiplied by the default rates for fencing and signage, or highwall security, or alternate rates if the user enters these. The last column, the blue one shows the total for this treatment and the individual total cost is populated back to the basic pit information table at the top of the sheet.

The next treatment is benches, highwall, drill, and blast which includes dozing to reshape and make the area safe. As in the previous table, the map ID and name of the pit are automatically populated from the basic pit information table. As is the high wall bench area and volume requiring blasting, and highwall bench volume requiring bulk push. The drill and blast costs are calculated using the default rate or alternate rate if the user enters one, multiplied by inputs populated from the basic pit information table. For the dozer shape, high wall to make safe section, the user must select a slope, angle, length of dozer, push and dozer size. The length of dozer push and dozer size determines the dozer push rate and this is multiplied by the high wall bench volume to get the cost for that activity. The slope angle and dozer size determine the reprofile unit rate and this is multiplied by the area to be reshaped to get the cost for that activity. As for all slope angles for dozer push, the higher the number, the steeper the slope and consequently the less effort the dozer has to exert and the lower the unit rate cost. Further, unit rates for dozers are typically lower for larger machines because the productivity increase typically outweigh the increase in hourly cost.

The next section of this table is for growth media, soil amendments and vegetation, and these work similarly to the tables described previously for the waste structures. As a recap, an automatic calculation of growth media volume is made by multiplying the default thickness by the footprint, and the user can change the volume by entering the growth media volume directly or entering a growth media thickness. The growth media load and haul rate is determined by the load and haul distance and the fleet size, and this gets multiplied by the volume of growth media to get the total cost for that activity. The amendment section works the same as for all other sheets. There are three soil amendment applications available and several material types that can be added, including gypsum and lime. The user enters the area over which each amendment will be applied and this gets multiplied by the default rate or the alternative rate if entered to gain the total cost for each amendment. The three amendments are added together to get the total cost for soil amendment. If no amendments are to be added, the user either leaves the area entirely blank, or selects no amendment in the dropdown selection for each.

The seeding part of the table works the same as for all other sheets, in that the user either accepts the area or enters the area to be seeded, then enters the proportion of land that is pasture or native, or makes both those 0's if the land is desert. If the total land area exceeds 100%, an alert is raised and the user must adjust the proportions. At the end of the table, the totals for each activity are added and those totals populated into the basic pit information for each pit.

The next treatment is for low wall shaping and the map ID, the name of the pit, the area of low wall to make safe, and the volume that will require pushing are automatically populated from the basic pit information table. This activity comprises primarily reshaping and pushing and the calculations work the same as for others previously described. The user selects the reprofile slope angle, which is downslope, the length of dozer push, and the dozer size and these select the appropriate unit rate which are multiplied by the volume and area to get the cost for those activities. The growth media and soil amendment section work exactly the same as previously described. The total for low wall shaping for each pit is summed in the right-hand column, and this is populated into the basic pit information table for each pit.

The next treatment is backfill open pit with waste rock or other material, and this includes some additional items not yet spoken about. As in the other tables, the map ID, name of the pit, and the key input quantities like open pit void area and open pit backfill volume in this case are automatically populated from the basic pit information table. The first bit of this table is associated with pumping and treatment of water from the pit and various water treatment options are available.

The first column is pumping water from the pit and the user enters the total volume to be pumped, which is multiplied by the unit rate or alternate rate if one is entered. The next two columns are adjusting acidic water to neutral, and again the user enters the volume to be adjusted and these are multiplied by the default or alternate rate. The next column is for removal of salt, which assumes the application of reverse osmosis, and if this section is used, entries must be made to the mobilization of reverse osmosis column and the mass of salt which will be required to be managed from the operation of reverse osmosis. Organics removal is for constituents like petroleum hydrocarbons and work similarly with the user entering the volume which is multiplied by the default or alternate rate. The next two columns are per dam with the first being the cost associated with monitoring natural evaporation from a pond. The user enters the number of dams from which monitoring will be applied to evaluate ongoing natural evaporation of water. The next column assumes the addition of an atomiser or other enhancement of evaporation and the entry is similarly number of dams. With these kinds of item entries, the calculator restricts the entry to whole numbers, and if this is the case, it is indicated by a whole number in this row. The last water management entry is establishment and engineering of the water treatment system and is entered by the volume of water anticipated to be managed. Each pit could have several water treatment options applied, and these are all added up to get the total water management cost for that pit.

The next part of the table is associated with sourcing and hauling the rock material to backfill the pit and work similarly to the other tables in other sheets. The rate for load and haul of locally sourced rock or other material is determined by the one-way distance for backfill rock and fleet size. If the source of rock is selected as long haul, this rate is set to 0 and the calculator looks at the distance one-way for rock if not local column to determine the cost for load and haul. The user selects the one-way distance and this is used to source from subrates table 9 the dollars per cubic meter per kilometre cost, which is then multiplied by the distance to the source of rock and the volume of rock to get the total cost for sourcing rock that is not local.

The next section of the table is backfill tip head and doze and this works similarly to the other dozer tables whereby the user selects the length of push and the dozer size, and this determines a rate that is multiplied by the volume to get the cost of that activity. The growth media, soil amendments and vegetation sections of the table work exactly the same as for those previously described. The total cost to backfill the open pit is summed and the number populated back into the basic pit information table against each specific pit.

The last table is for open pit ramp backfill or rehabilitate. The table allows two treatments. The first, backfill open pit ramp, and the second, removal of contaminated material. If the user enters the backfill volume in the basic pit information, the calculator uses this to determine the backfill requirements. Alternatively, the user can enter the average ramp depth, roadway width, ramp length, and number of ramps in the pit, in the open pit ramp backfill table and the calculator calculates the volume to be backfilled from these entries. The user can enter the contaminated material thickness which will override the default, or directly enter the volume of contaminated ramp material to remove. The rest of the remove and dispose ramp material table is the push of the material with the rate determined by the user selections of dozer push length, and fleet, and the haulage of the spoil to a distance and fleet size selected by the user. These selections and imports then determine the total cost to remove and dispose the roadway material. The remainder of the open pit ramp backfill rehabilitate table is calculating the cost of backfill and operates the same as for the open pit ramp backfill table. The total for each pit for open pit ramp backfill and rehabilitate activities is populated back to the basic pit information table. All the treatments applied to each pit are then summed to get a total cost for each pit, and these totals are summed to provide the total for the pit domain and are reported back to the summary sheet.

In the underground mines sheet, the user enters details in the first part of the table and the costs are calculated in the second part of the table. The sheet allows for termination of services, management of shafts, adits and declines, and rehabilitation of damaged land. The shaft options include backfill, plug, and cover and the user decides which options to use. These options are available for ventilation and hoisting shafts. If the backfill option is selected, the total depth for all the shafts in the row must be entered. The options for adits are cover and or seal, and the user again makes the decision as to which one is most appropriate. The user enters the number to be treated by each method. For declines and drifts, the number is entered and if these contain conveyors, the length is also required in the next column. For small historical shafts that would be closed, the user just enters the number of them.

The next section of the quantity part of the table is for rehabilitation of damaged land, including subsidence. The table of values description provides further information on which may be appropriate to use. As in other tables similar to this one, the quantities are multiplied by the default rates above the cost portion of the table and the user can enter an alternate rate which will override the default if they can justify its entry. The user can also enter an alternate rate for the whole row, which bypasses all of the default rates for the row and must provide justification. As with all the sheets, the total for that sheet or domain is reported to the summary sheet.

As always, for more information or specific instructions, please consult the user guide, which is also available on the Business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining.

This is Module 11. This module will work through the user input sheet for ports.

Ports is a new addition to the calculator for 2022. The sheet includes a table of default rates and a user build table. The default rate table operates similarly to other tables in that the user enters the map ID, facility, or item name, selects the item which includes jetties, wharves, and reclaimers, and then the quantities are multiplied by the default rate or alternate rate if the user can justify one. Please note the units associated with each item.

The user build table is similar to other tables throughout the calculator and is specific to ports with sections focused on particular aspects of the port or marine facility. The table begins as usual with the map ID and name of the facility, and then has the key entry, total land area in hectares. This quantity determines various things throughout the rest of the table. The export quantity is an optional entry and provides some information to the reviewer as to the nature and magnitude of the item being costed.

The first major section of the table is for the wharf, and this requires the total surface area of the wharf and then whatever type of surface covering is present. The surface cover options are concrete, bitumen or asphalt, and gravel. A wharf may comprise a mix of these, in which case the user enters the area for each specific type of surface cover in each section. As is typical throughout the calculator, the user can override thickness defaults. For the gravel section, the user must select the distance from which the gravel will be retrieved. For all three surface coverings, the quantity entered is multiplied by the default rate or an alternate rate entered above the table if one can be justified. If the wharf surface is earthen, the user does not enter quantities into the surface cover sections.

The next section of the table is for dolphins, and this has an allowance cost as the default rate recognises costs associated with such items are varied. The user can enter an alternate rate with justification. The next section of the table is for major equipment, including jetty and land conveyors, ship and stockpile loaders, and reclaimers. The user simply enters the quantity. Alternate rates, as usual, can be entered above the table. The next section of the table is for rail infrastructure, and this operates similarly to the other tables and also allows alternate rates above the table.

The next section of the table is for buildings and structures and includes area-based rates for substations and switchyards and for various types of buildings and a number entry for portable demountable type items. These rates are the same as those in the infrastructure sheet. The building section of this table has a drop-down menu so the user can mix and match. As this table has several rows, the user could split up their port into sections, allowing selections of different buildings for example.

The camp section of the table is similar to the buildings whereby the user selects the camp from the drop-down menu and the appropriate rate is selected by the calculator. The user can again enter an alternate rate with justification. The pipe, tanks and dams and ponds section of the table operates similarly with dropdown menus allowing a range of options. The quantities, for example, length of pipe or number of tanks, are multiplied by the default rate or alternate rate if entered by the user.

The next major section is for land rehabilitation and this table operates the same as for other tables throughout the calculator. The default of land to rehabilitate, defaults to the total footprint entered at the beginning of the table, but the user can change this if justification is provided. The table starts with growth media and as in other tables throughout the calculator, the user can set their own area and thickness or accept the defaults and a growth medium volume is calculated based on whichever selections are made. The user must select whether the growth media is locally sourced, that is within 5 kilometres, or whether it will be transported via long haul. If local is selected, the long-haul rates are set to 0. For locally sourced growth media, the user selects the haulage distance for growth media and the fleet size. No fleet size selection is required for long haul. The user can enter their own growth media rate in dollars per cubic meter if it can be justified and if this is entered, the total growth media cost uses this rate. Whichever combination is entered, the total volume of growth media is multiplied by the rate to get a total cost for growth media.

The amendment section of the table works the same as the other sheets with three amendment areas available and several amendment materials in drop down menus. The user enters the area over which the amendment would be applied in each case and can enter on alternate dollars per hectare rate if it can be justified. In each case, the area of amendment is multiplied by the default rate or alternate rate if entered. The last section of the land rehabilitation part of the table is for seeding, and again this operates the same as the other tables, whereby the user enters the proportion of land in each land type. Alternate rates can again be entered with justification.

The last section of the table allows the user to enter items not included elsewhere in the table, and then all the costs for all the sections are added to provide the total for the row. As for other similar tables, the user can enter an alternate rate for the entire row and must provide justification. The cost in the default rate and user build tables are added together and reported to the summary sheet. Beneath the user build table is an optional quantities table where the user can show where quantities come from. The totals for this table are not reported automatically to the default or user build table. If the user enters quantity into this table, they must make sure the reviewer can see the connection between the quantities documented and the cost table, that is that the numbers match.

As always, for more information or specific instructions, please consult the user guide, which is also available on the business Queensland website below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for mining. This is Module 12. In this module, we'll work through examples for the investigation and contamination, general land rehabilitation and mobilisation and additional items sheets.

The investigation and contamination sheet is used to cost for contaminated land investigations and treatment and disposal of contaminated material and scrap. The rolled up rates for facilities and infrastructure includes land investigation where one would be expected, example process dams, and allows for soil and scrap associated with demolition of process plants and draglines. The land investigation, contamination and scrap removal tables in this sheet are for isolated areas not associated with such facilities. The rolled up rates do not allow for any known significant contamination that may be present on the site and tables, example soil bioremediation, in this sheet can be used to account for such occurrences.

The preliminary site investigation unit rate is a one-off cost. A preliminary site investigation in the context of mine closure is typically a part of planning activities and aims to identify areas of known, suspected and reasonably probable contamination resulting from the mine operations. The preliminary site investigation comprises a review of the site setting, site history, operational history, including any accidents and incidents, hazardous liquids and solids storage schedules, and sources of potential impacts and receptors. To apply a cost for a preliminary site investigation, the user inputs the proportion of one-off cost to apply to each area, the number of investigations needed in the preliminary site investigations, together with the relevant dimensions to allow the investigation area and costs to be calculated. The proportion of one-off costs field is the multiplier on the one cost for investigation. This value is typically set to one, but there can be less if it is reasonable to assume several areas will be investigated during the same mobilisation.

An intrusive site investigation would be targeted and may not be required for all contaminated or preliminary investigation areas. The intrusive investigation rate should be applied considering risk, site history, past incidents and the planned rehabilitation program. An intrusive investigation should be considered if a site has contaminated land on the EMR or CLR, and scalping and disposal of contaminated material is not accounted for in key areas with potential for contamination, example process areas, maintenance yards, go lines. The cost of intrusive investigations is based on default rates and is calculated using the proportion of one-off cost field and the dimensions of the site. The user must add entries for both to cost an intrusive side investigation.

The entry made in the proportion of one one-off column must be made as a decimal, for example, 50% must be entered as 0.5. These entries trigger the calculation of both the land investigation one-off cost and the land investigation per unit area cost fields. The approach to estimating costs for site investigations recognises that most investigations of this nature comprise a single campaign or one mobilisation taking in multiple areas. The one-off cost allows for planning and preparation, ongoing project management, health and safety plans, work plans, and reporting. A combination of these factors must be considered in determining the number of one-off costs to apply. Examples of areas that may individually comprise one campaign are service facility areas, including fuel or chemical stores, workshops, vehicle wash downs, and sewage treatment, processing plants, including ore and product storage, mine waste storage and disposal rail loadout, and remote pit facilities like vehicle refueling, sewage treatment, secondary workshop and chemical storage. The user should enter a one for the one-off entry demonstrating the areas described in the line will be investigated in one campaign. The user can enter a fraction of one if they want to list individual areas that will be investigated in the one campaign. The by area rate accounts for activities undertaken on site.

The rate includes cost for field staff to collect soil samples, sampling equipment and consumables, and laboratory analytical costs. The user can describe the area for a land investigation by entering width and length or diameter or the area. This recognises that users will have different quantity types. Some users may use GIS that outputs area and others may measure length and width off a plan. If both length, width and diameter are added, the calculator uses length and width and ignores diameter. The calculated area column shows the calculation of area based on the user entered dimensions and if a value is entered directly to the user area column, the area for calculations column will default to that entry. The per area rate is applied only to the area to be investigated, for example a tank farm within a processing facility. In this case, only the area of the tank farm to be investigated is entered.

The next table is for removal of material from beneath the footprint of stockpiles and processing facilities that may not have been included in other input sheets. The removal of scrap and waste disposal to offsite facility tables are for miscellaneous areas not included in other input sheets. As mentioned, the rates for processing facilities and infrastructure include the removal of scrap and waste and consequently these tables are not to cover items already entered into other sheets, but for discrete, isolated items that cannot reasonably be expected to be included in the other sheets.

The management of soil contamination is not included in other sheets and the soil bioremediation table allows for the entry of specific areas whereby management of organic impacted soil is accounted for. The three different rates acknowledge that significant economies of scale will come from managing larger volumes.

The disposal to offsite facility waste levy table captures quantities from the waste register sheet if the waste levy is applicable to the site. The waste levy is now different from metro and regional zones, and the table multiplies by the rate associated with the user selection in registration. The user does not have to enter quantities to this table, but can add an optional area name description.

The General Land rehabilitation sheet accounts for activities associated with land rehabilitation that are not captured elsewhere in the calculator and can be used for buffer and fire safety areas. The default rates and user input tables in the other sheets include land rehabilitation, including footprint of facilities and access directly associated with facilities, so the general land rehabilitation sheet does not need to capture such activities for these items. For example, the default rates for waste rock dumps include grade and seed and the user input table has entries for soil amendment and long distance haul of materials if required, so the general land rehabilitation sheet is not used for these items. Rather the general land rehabilitation sheet is used for miscellaneous land areas that are not included in other input sheets. An example, maybe a rehabilitated pit that is known to require further land rehabilitation.

This sheet can be used for all areas requiring any of the following - land rehabilitation and repair of subsidence and land management, natural drainage and diversions, general grade and rip, general doze and rip, miscellaneous soil amelioration and seeding, bores, long distance carting of amendments, long distance carting of growth media, and long distance carting of clay. These tables all require a variety of user inputs to allow the areas or volumes of material to be calculated before this is multiplied by the default rates to give the total cost. Users may enter alternative rates and where this is done justification for the proposed rate must be included in the space provided at the end each table.

The long distance haul tables are for carting of materials from greater than 6 kilometres of the intended use area for items not covered by other input sheets. The distance is selected from the drop down menu which has increments extending up to 200 kilometres one way. The user enters the mass of material required and this is multiplied by the distance and the default rate to obtain the total cost for that area. The purchase price is separate to the transport cost and this is shown in the adjacent column.

The mobilisation and user input sheet allows entries for mobilisation and demobilisation, and any additional site specific items that do not have a space elsewhere in the calculator. Mobilisation and demobilisation is the process of transporting earthmoving machinery to the site for the rehabilitation work and transporting the machinery back to the supply centre. Typically, the supply centre for earthmoving equipment is a major centre such as Brisbane or Rockhampton. The mobilisation and demobilisation costs reflect the effort required for safe transport of earthmoving equipment, which typically includes floats and convoys. The calculator includes mobilisation and demobilisation rates for small, medium, large and truck and shovel fleets and in several distance ranges as shown. The default rates allow for transport both ways and therefore the user should use the one way distance from supply centre to source when determining the appropriate line to select. The default rates include costs for utility and service vehicles to support the earth moving equipment.

The number of mobilisation and demobilisation units entered is dependent on the activities selected throughout the calculator. Typically, the expectation is for only 1 entry, with the fleet size reflecting the predominant size used through the calculation. For large projects, 2 entries may be required, for example, a small fleet source from a local centre and a large fleet source from a major centre. The users who justified the distance and fleet size selected in the user notes section of the mobilisation and user sheet. Irrespective at least 1 of these rates must be applied once for every submitted ERC. This sheet requires only the input of quantities next to the appropriate line. If alternate rates are justifiable, they can be entered into the yellow cells with an explanation in the justification for alternate rate section of each line.

For small projects where the total ERC is less than $1,000,000 before mobilisation costs and multipliers, the user may choose to apply mobilisation and demobilisation costs by using the 10% flat rate option contained on the summary sheet. The user can choose this option by entering a 1 into the line titled mobilisation and demobilisation, small projects here in the summary sheet. Using this functionality will apply a mobilisation and demobilisation cost of 10% of the premobilisation and multiplies amount. If using this approach, the user should not enter quantities into the mobilisation sheet.

The additional items table allows space for the user to enter items which do not have a place elsewhere in the calculator. The cost calculated in the additional items table will contribute to the total cost and flow through to the summary sheet. All items entered into this table need to be justified in the comments space provided at the end of the table.

The user input sheet allows for users to enter free text data, which may include granular disturbance quantities and other miscellaneous supporting information. The values entered into this sheet are not linked through the workbook and the user must ensure all disturbance values are separately entered into the relevant sheets. This sheet and the associated user notes box can be used to communicate to the department where and why any disturbance areas are different between the ERC and the progressive rehabilitation and closure plan or EA.

As always, for more information or specific instructions, please consult the user guide, which is also available on the business Queensland website below the download for the calculator. And this completes the last module in the training. Thanks for joining me.

Welcome to the training for the 2022 edition of the Estimated Rehabilitation Cost Calculator for petroleum and gas. This training course will take you through all aspects of the Calculator and consists of 13 modules, including four introductory modules, and nine worked examples. While these modules do go into some detail, they are generally designed to be an overview. So if at any time you need more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the Calculator.

Join me now for Module 1. This module will cover the purpose of the Calculator, some key definitions, and the major changes from the latest review.

The Calculator was designed to provide a tool to calculate the Estimated Rehabilitation Cost as required by the Environmental Protection Act 1994. It allows a consistent yet generic approach to calculating the Estimated Rehabilitation Cost for petroleum and gas activities. It is also used by the Queensland Government to estimate the full cost to decommission, rehabilitate, and close an operation. Here are some key definitions to be aware of while using the tool. Please pause this video as required and carefully read through the definitions.

Throughout 2021 and 2022 the Calculator underwent a major revision with some key changes being made. All macros have been removed to improve functionality and stability. Headers for each sheet have been decluttered by removing the user information and user comments, which are now located in the Information sheet, and the legend which can now be found on the Contents sheet. The Table of Values has been removed and incorporated into the Main sheet. This is because the Main sheet merely replicated the values and words in the Table of Values. Several User Input Sheets have been added for the following activities: Wells, LNG Plants, Water Storage defaults and Process Facilities defaults. Many of the sheets have also been redesigned to improve consistency between the spatial data supplied with ERC calculations and the ERC quantities.

User input tables have been added to the Process Facilities input sheet and Process Facilities User Build input sheet for Liquified Petroleum Facilities, Conventional Oil Facilities, and Conventional Gas Facilities. Assumptions, Information and user notes, and Subrates sheet have been added for reference to provide greater transparency for rate defaults and Calculator assumptions. A Waste Register has been added in order to itemise the quantities that are multiplied by the Waste Levy.

The range of rates available has been expanded for several groups including wells, tracks and roads, dams, and facilities. To improve consistency with the spatial data, area-based rates have also been expanded in addition to the per length or number of/category methods. Arid has been added as a land type, in addition to pasture and native, primarily to account for facilities where the land is desert, for example some operations in South West Queensland. All rates have been reviewed, updated, and made consistent across the mining and the petroleum and gas calculators.

Again for more information or specific instructions, please consult the User Guide, which is also available on the Business Queensland website, below the download for the Calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the Estimated Rehabilitation Cost Calculator for petroleum and gas. This is Module 2. In this module we will cover how to prepare an Estimated Rehabilitation Cost.

To get started, go to the Business Queensland website and download the Calculator.

You may be prompted to save this to a particular location, or it will appear down the bottom, depending on which browser you are using. Open the Calculator once it is downloaded and you will be taken to the Terms and Conditions of use pages. By downloading the Calculator, the user agrees to the terms and conditions.

In the next tab, you will find the Contents sheet. This tab will allow you to navigate around the Calculator and each subsequent sheet gives you the ability to come back to the Contents sheet.

The first tab required for starting a calculation is the Registration sheet. Here you will fill in some of the more general details for the activity. This includes the EA number and holder; the tenure numbers and site or project name; as well as the last ERC decision date and current ERC amount, which is used to calculate the difference between the total cost of this ERC and previous ERC amounts.

Further down the User enters site details and contact information. Below this is the selection of the Waste Levy. The user must select one of the options from the drop-down menu. The options are: Waste levy applies, for regional or metro zones; Waste levy does not apply because the site is not in a waste levy zone; or Waste levy does not apply for another reason, in which case the User must add comments.

The final part is the name and details of the assessor who is the person preparing the Calculator, and the name and details of the authorised person or site manager, who is the person within your organisation who is authorised to submit this calculation to the government.

The User can then choose to either complete the Main sheet, which includes rolled up rates for petroleum and gas activities, or work through all the user input sheets, entering all the details relevant to their activity. We will cover data entry into these sheets in later modules.

If the user chooses to complete the Main sheet, they simply enter the quantity for the relevant activity and the Calculator uses the rolled up or default rate to calculate the cost.

The user input sheets allow the User to build a rate, based on the specifics of individual infrastructure. Generally, default rates are still relied on, but the User has the option to add alternate rates with justification into the Main sheet. The User simply works through the user input sheets, entering quantities to input cells and selecting options from drop-down menus as required.

Once this data entry is complete the User can return to the Summary sheet to review the rolled-up totals. If site-specific Project Management and/or Environmental Maintenance and Monitoring values are justified, enter these into the cells in the Summary sheet and provide justification in the cells below the table. These will be explained further in a later module.

As always, for more information or specific instructions, please consult the User Guide which is also available on the Business Queensland website, below the download for the Calculator.

See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 3. This module will go over some general use concepts which are important to understand when using the calculator.

There are various ways quantities can be added into the calculator, however quantities for a specific item only need to be added in to one place. Most users will likely only use the Main sheet for quantity entry. The user input sheets are primarily used to tally area-based quantities. This achieves two primary purposes, the first that entries should better align with other spatial data, and the second is that the user and department can more readily view the disturbances.

Each user input sheet reports quantities and costs a little differently. The General Land Rehabilitation sheet sums the total quantity for each disturbance type, for example total area of existing disturbance requiring minor rehabilitation, or total number of water supply bores requiring plugging. The total quantities for each column in the input sheet are automatically reported against the appropriate line item in the Main sheet. For this sheet, only the quantities are displayed. The quantity totals are automatically reported to the Main sheet and displayed in the input sheet column against the appropriate line item, where the cost is then calculated. Any additional quantities added directly to the Main sheet are added, and the total cost calculated for each line item.

The Investigation Contamination sheet works similarly to the General Land Rehabilitation sheet, summing the total quantity for each disturbance type and reporting that to Main. For example, the total mass of asbestos in soil from the Investigation Contamination sheet is reported to the input sheet column against the asbestos in soil line item in the Main sheet.

The sheets Seismic and Infrastructure, Process Facilities, Process Facilities User Build, and Water Facilities User Build all report the total cost for each sub-category for that sheet to the relevant line item in Main. For example, in the Process Facilities input sheet the total cost for unconventional gas, conventional gas, oil storage, LPG, water treatment plants, and water transfer stations are calculated in the sheet and then reported separately to the corresponding row in the Main sheet.

The sheets Wells, Pipelines, LNG Facilities User Build, and Water Storage report the total cost for all the disturbances in the sheet to the relevant line item in Main. For example the total cost of the wells entered to the Wells input sheet is reported to Wells input sheet row in Main. The sheets Process Facilities, LNG Facilities, and Water Facilities User Build tables allow the users the flexibility to change specific aspects of the calculation to ultimately create a cost specific to that item.

As explained earlier, there are several places where items can be entered, but each item only needs to be entered once. For example, if you add a specific pond to the Main sheet, you do not then need to add it the Water Storage input sheet.

The default rates included in the calculator generally include all activities reasonably anticipated to be required for a particular activity. Specifically, decommissioning, demolition, removal, disposal and storage, rehabilitation of land ('grade and seed'), are included unless otherwise stated.

While a lot of the calculator's functionality is locked to prevent changes being made to the format or layout, the standard Freeze Pane function is accessible so the user is able to freeze or unfreeze columns and rows to assist with viewing and use.

The calculator is colour coded to visually assist the user in identifying which cells are for user entered data and which cells are for reference, calculation, error, etc. The key to the colour code is in the contents tab of the calculator and displayed here. Of note, the green and yellow cells are the only cells that will allow user entry.

Much of the data entry in the calculator is for inputting quantities of different units. The unit of the quantity the user is required to enter can either be found in the next column on the same row, or in the title of the field. It is important to check the unit you are required to enter to avoid any miscalculations.

Default rates are all listed as numbered cost rates in the Main sheet. Where applicable these rates are also used in the user input sheets, but in most cases the land rehabilitation rate is separate from all the activities such as demolition. This is to allow the area-based component of the disturbance to be separate to improve consistency with other spatial data. The user can enter an alternate rate with justification for the default rates in the Main sheet and the LNG Facility User Build sheet. Subrates are shown in the Subrates sheet and are used in building default rates, and some are used in the user input sheets. The user cannot enter alternate rates for Subrates unless they are also default rates.

Default values, or assumptions, are used throughout the calculator to calculate costs. These, as opposed to the default rates, are things like thickness of material, distance to travel, etc. In some cases the user can over-ride these where they are used in the input sheets. The user simply enters a quantity where a default is present and the calculator will use the user entry instead of the default. The defaults are summarised in the Assumptions sheet.

As mentioned earlier, the user can enter alternate rates for the default rates in the Main sheet. These are entered in column K and justification or rational for the alternate rate must be provided in column N. When entered, the cell will turn red to alert the department that an alternate rate has been used. The calculator will then use this user entered rate to calculate costs. Where third-party quotes are used, they must comply with the ERC guideline requirements. The only exception is the LNG Plant User Build sheet where alternate rates and justifications are required to be entered to that sheet.

The calculator includes numerous areas that allow the user to add comments. These are important in justifying to the department why you have chosen certain values, or why alternate rates have been entered. The Main sheet allows for user comment and justification of alternate rates. In the Summary sheet, the user must explain why an alternate project management or maintenance and monitoring rate was used if entered. The LNG Processing Facilities User Build sheet allows for justification of alternate rates. In the Registration sheet, the user must explain why the waste levy does not apply to the site if this is selected. In the Information sheet the user can enter notes applicable to individual input sheets in the spaces provided.

Any comments or justification added needs to be useful, succinct information that will assist the department in its review. When entering comments it is good practice to add blank rows at the beginning and end of text to ensure the text is properly displayed. To add a blank line, use the Alt + Enter key on your keyboard while editing the cell.

The calculator uses hyperlinks throughout the workbook to allow for easy navigation between sheets. The Contents page which we looked at earlier is a great place to start. As mentioned, all sheets have a hyperlink back to the Contents page at the top of the sheet.

To search for something in the calculator, simply use Excel’s search function (Ctrl + F) to find specific words. Some field headings throughout the calculator have addition pop up text that displays when the cell is clicked on. This is to help the user better understand what is required to be entered into that field. These cells are identified with an asterisk. Drop-down menus feature throughout the calculator and are a quick easy way of selecting options.

Each input sheet includes a column on the left-hand side of the table for each activity to allow the entry of a map ID. Where spatial data is provided, the map ID should align with the spatial data for the relevant line item in the calculator. Multiple map IDs can be entered, separated by commas, if there is more than one identifying code or number for a particular item.

Most user input tables allow space for additional user entered items that fit within the category of the table, but are not otherwise included in the calculator. The user must enter the quantity, the units and the rate for the user entered item.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 4. In this module we will go into a bit more detail about the Summary, Main, and user input sheets.

In addition to the Main sheet, there are 11 user input sheets that allow user input for each of the domains, as well as several other sheets summarising information, listing default values, or simply for reference or lookup. The user input sheets comprise of rolled-up rates, also referred to as default rates, in single line, or user defined input tables that build up the activity to calculate the total cost of the element.

Most of the user input sheets are filled out from left to right, and only information relevant to a particular element needs to be entered. Process Facilities, Water Facilities and LNG Facility User Build sheets are filled out from top to bottom for each facility. Where defaults are listed and no information is entered by the user, the default value will be used in the calculation.

The structure of each input sheet is similar, with header rows providing the domain name, a hyperlink back to the contents, and the total cost for the individual sheet and the total ERC amount for the site. Each table then has its own header containing the field headings. We will go through these sheets in more detail in later modules, but for further information on the purpose of each sheet, please refer to the user guide.

The totals from the input sheets are then fed into the Main sheet. Each section in the Main sheet has a row for the total from the user input sheet if applicable. This is then added to any other items that are added directly into the Main sheet to give a subtotal for that section. Each of these section subtotals then flows through to the Summary sheet. The total for each section is shown and totalled at the bottom to produce a pre-multiplier cost. The multipliers are then added to give the overall ERC amount. The last value in the Summary sheet is the difference between the current ERC value initially entered into the Registration sheet, and the total with multipliers calculated above.

The first multiplier is the project management multiplier which is calculated at 10% of the total ERC amount. Generally, this covers the cost to government to project manage, schedule, and oversee the required rehabilitation works. The user can specify their own project management multiplier, and if so, must provide justification in the space provided and attach the relevant quotes to their ERC application.

The environmental maintenance and monitoring multiplier is calculated at 5% of the total ERC amount. This covers post-closure activities like minor repairs, revegetation, weed management, and fence and signage repairs. It also covers a wide range of post-closure monitoring activities including inspections, assessments, surveys and reporting. Again, the user can specify their own environmental maintenance and monitoring multiplier, and if so, must provide justification in the space provided and attach the relevant quotes to their ERC application. The calculator also applies a contingency of 10% to account for general uncertainties in the cost of estimation and recognises that assumptions are being made for the default rates.

The Waste Levy is a new addition in the 2022 version of the calculator and is designed to account for specific types of waste that go to landfill in Queensland. This levy only applies if your activity falls within one of the specified areas. For the ERC, concrete, bitumen, asbestos (free and within soil), solid salt, and contaminated soil are the primary wastes to which the levy may apply. Steel, copper, and other materials are not considered a waste as they have value as scrap. Consistent with the policy decision on scrap, scrap value is not offset. The calculator does not charge a gate fee or levy against these materials, but does allow for transport to a facility.

Revegetation is primarily broken into two categories, with a third option for certain circumstances. These are pasture, native, and arid. The default rates throughout the calculator generally include the cost of seeding so the user is not required to enter additional revegetation costs elsewhere. If seeding is not included it is specifically stated in the rates scope. The General Land Rehabilitation sheet includes additional rows to cover revegetation of land not covered by the other sheets. Such occurrences are likely rare and may include land where preliminary work, e.g. clearing for an activity was undertaken but the activity did not go ahead.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas.

This is Module 5. This module will work through entering data into the Main sheet. Users can prepare their whole ERC submission using just the Main sheet and not use the user input sheets. The Main sheet groups activities into sections. For most of the activities discussed below, further detail will be provided in the module for the corresponding input sheet.

The first section is Exploration, which contains rates from other sections and is split out so that smaller exploration only companies need only view this section. If the exploration project has activities not included in this section, the user can use the additional line item rows and reference the rate number in the comments. Otherwise, the user must enter those quantities to other sections in Main.

The next section is roads, tracks, laydown, and borrow pits; followed by camps, buildings, and sewerage treatment plants; power generation and distribution; well pads and associated infrastructure; pipelines; gas processing and oil storage facilities, which include unconventional gas facility types, conventional gas and oil facility types and LPG facilities; LNG plants; water treatment plants and transfer stations, which includes water management items such as salt reduction by reverse osmosis; then water storage infrastructure including a range of different dam and pond options, as well various tanks including panel tanks; general land rehabilitation to allow for items like rehabilitation of subsidence or erosion as well as allowance for miscellaneous activities to include things like additional soil amendments not already covered by other activities, or if soil amendment activities are known to be beyond those reasonably expected. It is important to keep in mind that default rate will cover seeding and soil amendments unless specifically stated that they do not.

Following this is the land investigation and contamination section. Where they are required, costs for investigation are included in rolled-up rates for items such as dams and ponds. So this section allows for activities not covered elsewhere, or where activities are known to be in excess of what is reasonably expected, or if the user wishes to list out investigation areas. This section is also where the Waste Levy costs are applied. Finally there are sections for mobilisation and demobilisation and additional activities.

At the bottom of each section there is an allowance to add additional items not covered by any other activities in that section. To use an additional item, provide a clear activity description, enter the quantity and unit for the item, and add your own rate in the alternative rate column with justification. You then provide a detailed scope for that item to clearly define what the additional item does and does not cover. Each of the sections has a subtotal which is reported to the Summary sheet. At the top is the total ERC amount. That is not the total for the Main sheet, but the total from the Summary sheet, including multipliers.

As discussed briefly in an earlier module, some sections in the Main sheet have a row or rows that draw from the total costs calculated in the user input sheets. For example, the total costs for quantities entered into the Seismic and Infrastructure user input sheet are reported to the Main sheet here for seismic (row 7), here for tracks and roads (row 51), and here for camps (row 88). Here is another example, where the total costs for quantities entered to the Wells user input sheet are reported to the Main sheet here (for presenter: row 151). To enter data into the Main Sheet simply input the quantities as they are in your disturbance schedule.

Throughout the calculator, there are now additional area-based rates in addition to the length and number based. For example, in the exploration section there are options to enter the area of the track in addition to total length of a track. Remember that you only need to enter an item once, so if you enter the total length of a track in the length item, you do not need to enter the road again in the area item.

Each item in the Main sheet has a corresponding use and scope definition. The use box describes how a rate is intended to be used, and sometimes contains additional information defining the quantity. For example, here (cell O572) this cell informs the user that the area to be entered is the crest area of the dam. The scope details what is covered in the rate, which generally includes what is reasonably expected to cover an activity. This is where items specifically included are identified, for example costs for management of any residual water in ponds are not included in those rates.

The Main sheet also offers the user the ability to enter an alternate rate. If you have suitable justification for using a rate different from the default rates provided, for example third party quotes, you can enter that rate in the alternate rate column. The calculator will then use the alternate rate to calculate the cost instead of the default rate. The cell will turn red to visually indicate to the department that an alternate rate has been used, and the user must provide a justification in the justification for alternate rate column. Remember to include a blank line before and after your justification using Alt + Enter key to ensure the text displays properly.

In the exploration section, there are two items for the selection of camps. The user selects an option from the drop-down, which selects the appropriate rate, and then enters a quantity to allow calculation of the total for those line items. There are two rows allowing two types of camps to be selected. If more camps are required, the user can enter these in the additional rows in the exploration section or use the camps rates further down.

The items in the Main sheet are generally for groups of items. For example, if you are entering the length for 6 metre wide, earthen track to be revegetated to pasture, then you enter the total length for all roads in that category. Then add a comment in the user comments column to describe the item, like 'group of tracks in area A'. If you would rather itemise out items such as tracks, use the input sheets.

You will notice here the different rates for pasture, native and arid. These are present throughout the calculator for a range of items as the cost to rehabilitate for each land type is different. That is, it costs more to replace with native vegetation than with pasture, and it costs less in arid, desert environments as the natural state in arid environments does not include vegetation, for example in South West Queensland.

For camps there are two options. The first is that the user can enter the area of a camp, whereby the default rate assumes an amount of space between and around components of the camp, as well as decommissioning of all reasonably expected camp components. If the area disturbed by a camps is significantly larger than what might reasonably be expected, the additional area will need to be added separately in the general land rehabilitation section. This may happen for example if an area of land has been set aside for camp expansion.

Alternatively you can enter camps by number of people, where the assumption is that the more people the camp accommodates the more components will be present, like a larger or multiple mess areas and recreation areas. A temporary camp is typically constructed for relatively short-term activities such as drilling campaigns or one-off activities such as construction of a process facility. Permanent camps are typically anticipated to be required for more than five years, and include more hardstand such as asphalt and concrete and facilities such as recreation modules with well stocked exercise equipment, tennis and basketball courts. It is up to the user to determine the type of camp that is applicable in each case. The user may make a case that a camp that has been in use for more than five years is a temporary camp by demonstrating the absence of hardstand. That is, the surface is predominantly compacted earth and gravel and only has simple facilities, such as very basic recreational facilities.

The building items have been significantly improved. Buildings associated with camps, process facilities, and the like are included in those rates so additional entries do not need to be added in the buildings section. These rates only cover the footprint of the building, so if for example the disturbance from a building impacts an area of land around the building, this area will need to be captured in the general land rehabilitation section. Check the use and scope for each building item to ensure you are applying the correct building type. Note that the unit for portable skid mounted or portable building is per item, not per area like the building items above. Also note that sewerage treatment plants have changed from an area based calculation to a kilolitres per day calculation. The rates for power generation and distribution have been revised and many changed to bring them in line with industry rates across petroleum and gas, and mining.

The options for wells, pads and associated infrastructure have been expanded to reflect the characteristics associated with the different resources. For example, conventional gas wells typically have less wellhead infrastructure than coal seam gas wells. The stage of each well is now better accommodated with sets for plugged and abandoned, suspended, shut-in, appraisal or development, and production or operation. As always, carefully read the use and scope of each item to ensure the correct items are being used. Towards the end of this section there is now a selection of items to cover wells in arid land as the rate to rehabilitate these items is less than their equivalents above.

For pipelines, the user input sheet only covers land rehabilitation for pipelines and does not include allowance for additional activities like flushing or purging. These additional activities need to be entered into the Main sheet in addition to the lengths or areas in the user input sheet.

In the Main sheet, the options for pipeline land rehabilitation include the rehabilitation of the full width of the easement, rehabilitation of operational area, which is generally less than the full width, and an inspection only option where the easement has already been rehabilitated and only ongoing inspections are required to monitor performance. These inspection-only items are for pre-department sign-off of rehabilitation as once the disturbance is formally certified rehabilitated, further costs are assumed to be part of the overall ERC maintenance and monitoring allowance. For each of these options there are several width categories, however if the user wishes to improve the accuracy, there is a user defined option where you can enter your own width to be calculated. In these cases, the calculator is based on the specific width entered rather than an average of the range.

The number of road, rail, and stream crossings needs to be counted for all pipelines and the total number included in the relevant item. At the end of the pipeline section there is allowance for pipeline facilities and hubs. It is up to the user to choose the most appropriate item and further details on these can be found in the user guide.

As with pipelines, in gas processing and oil storage facilities the user can either use one of the provided categories, or enter their own item. There are some limitations on what values are appropriate in these items so please carefully read the use section to ensure appropriate values are entered. LNG Facilities are now separate and are specific to the Curtis Island facilities, but could be used if new LNG Facilities are constructed elsewhere in the state assuming the general characteristics are similar.

For water treatment plants, the user can enter their own rate in megalitres per day and a quantity specific to their activity, or use the selection of different size items available for each facility type. The Main sheet includes rates for management of residual water and salt. Petroleum and gas projects typically manage liquids as part of their routine operation and management practice and consequently, the inclusion of quantities for these items is not always expected. Oily water in process ponds is typically routinely disposed of off site or processed. For coal seam gas activities, large quantities of brine and salt can be generated, and it is not typical to transport these off-site during routine activities. Consequently, the inclusion of salt is likely to be required for coal seam gas operations. The default method used in the calculator is load, haul, and dispose at an off-site facility. If a different method will be used, the user must develop an alternate rate.

The water transfer items are for facilities separate to water treatment plants and are typically comprised of tanks and pumps and piping. For guidance on what constitutes a small, medium or large facility, the user can check the user input sheet for water storage to see what elements make up the different sized facilities.

The water storage infrastructure section includes a wide range of items with the cost determined by the capacity or size of the item, whether sediments are assumed contaminated, whether the item is lined or unlined, and the land rehabilitation type. This section includes a range by capacity and by footprint area. In both cases these are the crest values for dams and ponds or full height for tanks. It is up to the user to make the decision as to whether dams, ponds and tanks are clean or contaminated and enter values into the appropriate items. The user is encouraged to provide notes that will support their selection.

The general land rehabilitation section includes a range of treatments and it is up to the user to determine whether these are needed. In general, the land rehabilitation costs are included in the rolled-up rates for the other items. For example the rehabilitation of the land upon which a camp was constructed is included in the camp rates.

In the investigation and contamination section, you will notice a range of items where the waste levy is applied. These are reporting from the user input sheet in column G, and quantities from the rows above reported in column H. The sum of these two values for each line are multiplied by the levy for that item to get the total.

The mobilisation and demobilisation section requires a simple quantity entry against the appropriate category. The user guide provides further explanation on the use of the mobilisation and demobilisation rates. In general it is intended that only one rate need be used and this should reflect the fleet that would most likely be used across the project. For example if the project is mostly wells then a small fleet is likely appropriate. If the project has several large process facilities and large dams a larger fleet is likely appropriate. The distance selection shown in each rate description is the one-way distance to the site. If the project is all wells and located less than 150 kilometres from an appropriate equipment supply centre, rate #13.01 is appropriate.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 6. This module will work through entering data into the General Land Rehabilitation input sheet.

The default rates in other sheets include land rehabilitation so the General Land Rehabilitation sheet does not need to capture such activities for these items. For example the default rates for camps and process facilities include grade and seed.

The General Land Rehabilitation user input sheet may be used to record areas that are in the total footprint of a facility but not in the disturbance area such as buffer/fire safety areas. Discrepancies between areas reported in the Plan of Operations and the ERC submission can be explained on this sheet. ERC costs should only be applied to areas where the environmental holder has a rehabilitation obligation or liability.

The General Land Rehabilitation sheet includes a range of activities – rehabilitation and repair of subsidence and general land management, construction/maintenance of natural drainage and diversions, general doze or grade and rip, miscellaneous soil amelioration and seeding, and decommissioning of bores.

The first table is land rehabilitation and repair of subsidence and land management. The appropriate category selection depends on the type and severity of land repair or maintenance required. The maintenance of rehabilitated areas applies to land that has undergone rehabilitation but requires minor attention to improve revegetation performance.

The existing rehabilitation repair – minor category is applicable to land experiencing minor cracking and/or drainage issues. The existing rehabilitation repair – moderate category is applicable to land experiencing surface expression of subsidence such as cracking and sink holes and where remedial works have not been successful. The existing rehabilitation repair – major category is applicable to land experiencing widespread surface expression of subsidence effects such as extensive cracking and multiple sink holes or where remedial works have not been successful. The existing rehabilitation repair – total failure of intended landform category assumes major reconstruction of a significant feature.

The rehabilitation of miscellaneous footprints category assumes extensive rehabilitation including reshaping, establishment of natural drainage, replacement of growth media, grading and seeding. The land management of undisturbed areas category is for items such as weed management, feral animal control, and minor erosion and sediment control. The pest management on buffer lands, non-disturbed, and rehabilitated areas is used if the proponent has responsibility for such activities.

The second table is for maintenance and/or construction of natural drainage diversions to ensure surface water flows in a manner that does not cause damage to rehabilitated and non-project related areas. The engineered cut-through drain category is used if a significant drain is required to manage subsidence and assumes a rip-rap and liner construction. The repairs and/or stabilisation of new or compromised water course diversion is to address failures of such features. The long term maintenance of water course diversion options allow the user to select whether the ground is competent and therefore more likely to retain integrity or through backfilled material that may be more prone to wear. The installation of rock armouring category allows the user to enter a specific area that may just require the installation of a protective layer.

The next two tables are for general earthmoving using either a dozer or grader to re-shape land to achieve drainage or other objectives. The miscellaneous soil amelioration and seeding table has specific treatments for amendment of land and revegetation and can be used for land areas not covered in the Main or other input sheets. The last table is for bores and includes water, monitoring, and reinjection bores decommissioned by either plugging, backfilling with cuttings, or grouting with cement. The user makes the decision as to which is the most appropriate form of decommissioning.

The totals under each category in each table are summed at the bottom of each table and the individual quantities reported back to the corresponding row in the Main sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 7. This module will work through entering data into the Wells input sheet.

The Wells input sheet allows the user to list out wells or groups of wells and enter the disturbance area, improving consistency with the spatial data. The sheet calculates the cost for decommissioning, dismantling and demolition of wells, and the land rehabilitation associated with the pads, separately. The user enters the area of the well pad or group of well pads separately from the number of well heads.

The quantity entry to the sheet is straightforward. As is for all the sheets the first column is for the map ID, followed by the name of the well or group of wells. The user then selects the type of well or wells from the drop-down menu. The options for well types in this drop-down list is the same as that in the Main sheet, spanning the various resource types and stages of wells. The user then enters the number of wellheads in the line category, followed by the total disturbance area of the pad into which those wells are drilled. The final selection determines the revegetation cost.

The drop-down menu is slightly different to the other sheets in that the selections are seed or no seed. If no seed is selected the user is communicating that the well pad is in a desert environment whereby vegetation did not previously exist. If seed is selected, an average of the cost of pasture and native is used to calculate the revegetation cost. The columns to the right of the user entries show the quantities entered for each category, and the total cost is found at the top of the table. The first table shows the decommissioning, dismantling, and demolition cost for each category and the next two tables show the cost for land rehabilitation when seed is required and where seed is not required.

One thing to be aware of is that the land rehabilitation rate is very high for well categories, whereas the assumed disturbance area used to calculate the unit rate is very small. For example, the area assumed for a plugged and abandoned well is very small and therefore the per hectare rate is disproportionately large. Consequently, if in the unusual circumstance a plugged and abandoned well has a very large disturbance associated with it, the overall cost may not be an accurate representation of the true cost. In this case the user is encouraged to use the Main sheet for these entries.

The totals for each category are summed to create the total for the sheet, and this total is fed through to the relevant row in the Main sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 8. This module will work through entering data into the Seismic and Infrastructure input sheet.

This sheet includes two options for seismic easements - by length and by area. In both cases the disturbance to be entered is only the length or area disturbed by the seismic equipment. Typically, such a disturbance is lineal and contemporary techniques cause minimal disturbance to the environment. For this reason, the calculator applies a default multiplier, currently 5%, to the entered quantity to determine the amount that will be multiplied by the default rate acknowledging that rehabilitation requirements are likely to be minor. The user can override the 5% default by entering a value into the rehab length column directly.

If the value is entered here, this gets multiplied by the rate. If a value is directly entered into the rehab length column, the formula is deleted. If the user wishes to return the formula, they can copy and paste from an unaltered cell. For both the by length and by area table, the user selects the land type and the calculator assigns the appropriate default rate accordingly. The column to the right of the user entries shows how the calculator has allocated disturbance quantities. These are summed at the bottom of each table and multiplied by the default rate to get the total. The totals for both seismic tables are summed and reported to the top of the sheet and this total is reported to the Seismic (Infrastructure Input Sheet) row in the Main sheet. Acknowledging that the actual disturbance is linear for both 2D and 3D seismic, the calculator no longer makes the distinction between the two.

The next table is for tracks and roads. The user can enter either the track or road length and width or the area directly. If the user enters an area, the calculation defaults to this entry. The user then selects the type of road surface from the drop-down menu with options for earthen, gravel, rock, or bitumen. The rate for earthen includes ripping costs and does not include costs for removal of material. From a rehabilitation perspective, the effort associated with the removal of gravel, rock, and bitumen is similar and the rates for these do not make a distinction. So the selection of gravel, rock, or bitumen serves as information only. Similarly to the seismic tables, the user selects the land type and the calculator assigns the appropriate default rate. The column to the right of the user entries shows how the calculator has allocated disturbance quantities. These are summed at the bottom of each table and multiplied by the default rate to get a total. The totals are summed and reported to the top of the sheet and this total is reported to the Tracks (Infrastructure Sheet) row in the Main sheet.

The last table is for camps. To allow alignment with other spatial data, costs for decommissioning/demolition/dismantling the camp are separate from the land rehabilitation. The user selects from the drop-down menu of camps with the selection determined by whether the facility is temporary or permanent, and the capacity i.e. the number of people the camp can house. A temporary camp is typically constructed for relatively short-term activities such as drilling campaigns or one-off activities such as construction of a process facility. Permanent camps are typically anticipated to be required for more than five years and include more hardstand, such as asphalt and concrete, and facilities, such as recreational modules with well stocked exercise equipment, tennis, and basketball courts.

It is up to the user to determine the type of camp applicable in each case. The user may make a case that a camp that has been in use for more than five years is a temporary camp by demonstrating the absence of hardstand, i.e. that the surface is predominantly compacted earth and gravel and only has simple facilities, like very basic recreational facilities. The user enters the number of camps in each category, and then the total land area disturbed by all facilities in the category. For each camp the land area is the total area including buildings and structures and open space that form the camp.

The columns to the right of the user entries shows how the calculator has allocated quantities for each row. These are summed at the bottom of the table and multiplied by the default rate to get a total. The totals are summed and reported to the top of the sheet and this total is reported to the Camps from Infrastructure Input Sheet row in the Main sheet.

The total costs for each table are summed and displayed at the top of the sheet and this total reported to the Main sheet as one line item. The total ERC amount is displayed at the top of the sheet so the user can see how the total changes with quantity entries.

The default rates for the land rehabilitation and decommissioning/dismantling/demolition components are shown at the bottom of the table. The hyperlinks to land subrates and camps subrates take the user to the Subrates tab which lists all the rates used in the camps table. Alternate rates are not available in this sheet. The user should use the Main sheet if alternate rates are justified.

As for all the sheets the first column is for the map ID followed by the name of the seismic area or track or groups of tracks or camp or group of camps. Let’s enter quantities to the seismic by length table first. When we enter a length you can see the calculator automatically applies the 5% to calculate the actual rehabilitation length. To override that calculation, the user enters a value directly and you can see the calculator now takes that entered value. As we enter values to more rows you can see how the selection of the land type changes the cost. The by area seismic table operates in a similar way.

Let's now go to the tracks and roads and demonstrate how the length and width and area entries work. If we enter a length and width and an area, you can see the calculator defers to the area entry. As we look down the table, you can see the effect on cost of the different surface covering and land type selections.

In the camps table we will assume the first row is for Camp 1 and it is a temporary camp of 80 people and the 3 hectares of land disturbed by the camp will be rehabilitated to pasture. So we select Temporary camp – > 50 and <= 100 persons from the drop-down menu and enter 3 hectares to the pasture column. For the next row, we will assume the user wants to enter a group of camps within a desert project area. The camps must all have the same characteristics in terms of temporary or permanent, capacity, and land type. We will assume three small camps in the project area, the first is ten people and an area of 0.5 hectares; the second is nineteen people and an area of 0.7 hectares; and the third, eleven people with area 0.5 hectares. As all the camps are temporary and the capacities all fit within the <= 20 people, the Temporary camp – <= 20 persons item is appropriate. The user enters three for the three camps to the number column and then 1.7 hectares, being 0.5 + 0.7 + 0.5 to the arid column.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator.

See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 9. This module will work through entering data into the Pipelines input sheet.

The Pipelines input sheet allows the user to list out pipelines or groups of pipelines and enter the disturbance area, improving consistency with the spatial data. The sheet calculates the cost for land rehabilitation only with totals for each category shown at the bottom right of the table. The sum of all these categories is shown at the top of the sheet under the total sheet cell, and this is reported to the relevant line item in the Main sheet.

The category is defined by the status of the easement. For example a newly constructed easement will require full rehabilitation. In most cases, the construction easement is rehabilitated to an operational easement and therefore only final rehabilitation is required. If the easement is rehabilitated but yet to be signed off by the department, the appropriate category is inspection only which allows for monitoring of rehabilitation performance. Once an easement is certified rehabilitated by the department, no further costs are required for pipeline easement with any ongoing costs assumed to be part of the ERC maintenance and monitoring allowance. While the sheet allows selection for above ground/below ground, oil, water, and gas, the costs in this sheet do not allow for purging and flushing, demolition of pipeline facilities, removal of high point vents and low point drains, and restoration of road, rail, and stream crossings. These items must be added to the Main sheet.

The quantity entry to the sheet is straightforward. As for all the sheets the first column is for the map ID followed by the name of the pipeline or group of pipelines. The user then selects from the drop-down menu for above or below ground and the type of fluid. Remember that these are for information only and costs associated with the flushing and purging and so on must be entered separately into the main sheet. The primary purpose of this sheet is again to align with other spatial data sets. The user can then either enter the easement length and width or the area directly. If the user enters an area the calculation defaults to this entry.

The user then selects the rehabilitation status of the easement, with none indicating a construction easement whereby no rehabilitation has occurred; partial indicating an operational easement remains; and rehabilitated indicating the easement is rehabilitated but yet to be signed off by the department. The final selection is the land type, that is pasture, native or arid. If arid is selected the user is communicating that the easement is in a desert environment whereby vegetation did not previously exist. The columns to the right of the user entries show the quantities entered for each category, and the total cost is found at the bottom of the table. The total for all the pipeline easements is then reported to the top of the sheet and to the line item in Main.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator.

See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 10. This module will work through entering data into the Process Facilities, Process Facilities User Build, and Water Facilities User Build input sheets.

The Process Facilities user input sheet allows the user to itemise disturbances associated with process facilities. This sheet can also improve alignment with other spatial data sets as the land rehabilitation component is by area and separate from the decommissioning/dismantling/demolition components.

The sheet includes tables for the same groups as in the Main sheet, that is: unconventional gas processing facilities, conventional gas plants, water treatment plants, water transfer stations, bulk oil storage facilities, and liquefied petroleum gas facilities. The layout of each table is similar with the user selecting a capacity or size of facility from the drop-down menu, the quantity in that category, and the land disturbance area in the appropriate land type column. The total land area entry in each row is the total for all the facilities.

The columns to the right of the user entries shows how the calculator has allocated quantities for each row. These are summed at the bottom of the table and multiplied by the default rate to get a total. The totals for the decommission/dismantle/and demolish, and land rehabilitation components, are added together and reported to the top of the sheet and this total reported to the Main sheet. For example, the cost total for the conventional gas plants entered into the input sheet is reported to the conventional gas plants from input sheet line in the Main sheet. The total ERC amount is also displayed at the top of the sheet so the user can see how the total changes with quantity entries.

The rates in the Process Facilities sheet are separated into decommission/dismantle/demolish and land rehabilitation. In the Main sheet, these two activities are rolled into one rate and therefore the rates in the Process Facilities sheet and Main sheet are not the same.

The default rates for decommissioning/dismantling/demolition and land rehabilitation components are shown at the bottom of the table. The hyperlinks for land subrates and process facilities take the user to the Subrates tab which lists all the rates used in the Process Facilities tables. Alternate rates are not available in this sheet. The user should use the Main sheet if alternate rates are justified.

Let's start with the gas processing facilities table. This table is intended for unconventional gas processing facilities such as those associated with coal seam gas operations. As for all the sheets, the first column is for the map ID followed by the name of the facility or group of facilities. In this case we are going to select the first option in the drop-down menu which is a stand-alone gas compressor. This item is different to the rest of the selections as it is the only one that is by single unit whereas the reminder of the selections are by capacity range. We are assuming this row comprises five gas compressors in the project area, so we enter five to the number column. As there are five units, the entry to the land disturbance column must be the sum of all those disturbances. Typically, stand-alone gas compressors disturb a relatively small land area so in this case we will assume each compressor is installed to a 20 metre by 20 metre compound. The entry to be made is then 5 by 20 by 20 divided by 10,000. The divide by 10,000 converts the square metres into hectares as there are 10,000 square metres in one hectare. For this entry we're assuming the stand-alone gas compressors are in a desert area so we enter a 0.2 in the arid column.

For the next three entries we take advantage of the ability to list out all the gas processing facilities in the area. Let's assume the first plant has a capacity 10 terajoules per day and its name is Facility 1. The facility disturbs a land area of 3 hectares and is in a pasture area. The second facility is Facility 2, has a capacity of 450 terajoules per day and disturbs a land area of 10 hectares and again is in a pasture area. The last plant is called Facility 3, has a capacity 800 terajoules per day and disturbs 12 hectares and is in a native area. Looking to the right you can see how the calculator has allocated entries and in the top row you can see how the costs are increasing as we enter each. Down at the bottom of the table you can see how the quantities are multiplied by the default rate to get the total for each column.

The remainder of the tables are used in the same manner. The next table is for conventional gas facilities. Such facilities are typically a smaller capacity than large coal seam gas facilities and consequently the ranges are lower.

The next table is for water treatment plants and these are typically for reduction of salinity and are focused on plants associated with coal seam gas activities. The rates can be used to represent water treatment plants for other resources as the costs associated with modules will generally be similar for similar capacities. The 80 megalitre per day and 100 megalitre per day categories have much higher costs because they assume equipment to further concentrate and crystallise salt. These rates include brine concentrators and thermal crystallizers (BC and TC). All the rates in the table (and the other tables) can be used in a modular fashion, so if a facility includes five by one megalitre reverse osmosis units, five can be entered into the one megalitre per day row. Remember to enter the total land disturbance in the land disturbance columns.

Water transfer stations are typically a collection of tanks, pipes and pumps and serve to move water around fields. They do not include any significant processing facilities so if you have a water transfer station that also has a reverse osmosis unit, the reverse osmosis unit must be added to the water treatment plant table. The scope description in the Main sheet and the Water Facilities User Build sheet provide further information on what constitutes a small, medium, and large water transfer station.

For conventional oil storage facilities, the selection is by oil storage capacity, that is the volume of oil stored in tanks at the facility. Consistent with the general rule throughout the calculator, the oil storage rates include all infrastructure and equipment reasonably associated with such a facility. Items not included in the rates and that must be added separately include: major water treatment plants; major water storage; major power generation facilities that exist to provide power beyond the plant; large camps, for example over 100 person capacity; camps installed to support construction or expansion; and large evaporation ponds, for example greater than 20 megalitres.

For further clarity, items that are included in the rates include: small process ponds; wastewater plants and landfills directly associated with the facility; minor accommodation and offices directly associated with the facility; and open space, laydown, and roads within the facility boundary.

The last table is for liquefied petroleum gas plants of which there are only a few across Queensland. For integrated facilities processing various resources and products, the quantities must be applied to the separate tables.

The Process Facilities User Build sheet is included to allow the user to build a rate for specific facilities whereby the quantities are clearly understood. The sheet is not intended to be used for large complex plants but rather facilities where the quantities are well defined and can be transparently communicated and articulated to the sheet. This would typically be smaller facilities. The sheet operates differently to most of the other sheets in that the entries are made vertically. The cost rates for each item cannot be changed by the user.

Entry to the sheet starts at the top by selecting the appropriate processing plant type. This entry does not affect any of the other quantities, it merely serves to collect costs for the same type of facility for reporting back to the Main sheet. While the sheet is titled Process Facilities, in this case the sheet is only for oil and gas plants. We will discuss a similar sheet for water plants later. One way to undertake the entry is to use process flow diagrams, photographs, and images supported by field visits or communication from operational staff to ground truth the entries.

We will enter quantities for a typical small oil storage facility as an example. The first step is to pick oil storage from the drop-down menu, then enter the name of the facility and any notes that may assist the user and/or the reviewer. This facility has four horizontal 40 kilolitres storage tanks so we enter four to this cell. The facility includes two oil water separators, one pig launcher to clean out pipes downstream, and four pump sets to move oil around the facility and to load trucks. Terminations are pipes that go into or out of the ground and that would require cutting and capping to decommission the facility. This facility has 10 such items so we would enter 10 into this cell. For this facility, the length of piping was measured from a general layout drawing supported by aerial imagery, and confirmed by the operational staff at the facility. The liquid pump and dispose row is for wastewater. For this facility we assume there are generally 10 kilolitres at the facility at any point in time. The facility is remote and does not have any on-site constructed buildings. It has three portable buildings which are a crib room, ablutions block, and a control room. We enter three to the portable buildings row. The last selection are for land rehabilitation which would typically include ripping, placement of growth media, unless the site is in an arid region.

For this facility, the compound is 100 metres by 100 metres, which is one hectare. The land requires ripping, so we enter one to this cell. Growth media is required to support revegetation and the thickness is 150 millimetres. For the volume of growth media, we can enter this as a formula to show how it was derived, which would be 1 times 100 times 100 times 0.15, which equals 1,500 cubic metres. The land is in pasture so we enter one to this cell.

Most oil storage facilities would require a land investigation. This facility is remote and there is no other facilities close by that might otherwise share mobilisation and lump sum costs of the investigation. Consequently we must enter one to the land investigation one off costs row. If a second facility was close by and required investigation this entry could just be 0.5. The land investigation area is only the area that would require investigation. For an oil storage facility this would typically be in and around the oil storage tanks, in-ground separators, and any loadout facilities. For this facility we measured an area of one hectare requiring investigation, so one gets entered into to the land investigation area row. The summary table groups the costs from the quantities entered above and then the total is shown at the top of the sheet. The total for each type of plant is summed and reported to the Main sheet. For example, the cost for all the oil storage facilities entered to the Process Facilities User Build sheet are reported to the conventional oil facilities from user build row in the Main sheet.

Like the Process Facilities User Build sheet, the Water Facilities User Build sheet is included to allow the user to build a rate for specific facilities whereby the quantities are clearly understood. The sheet is not intended to be used for large complex plants but rather facilities where the quantities are well defined and can be transparently communicated and articulated to the sheet. This would typically be smaller facilities. The sheet operates the same as the Process Facilities User Build sheet where entries are made vertically. The cost rates for each item cannot be changed by the user.

Similarly to the Process Facilities User Build, one way to undertake the entry to the sheet is to use process flow diagrams with photographs and images supported by field visits or communication from operational staff to ground truth the entries.

The first step is to enter a map ID, then enter the name and the facility and any notes that may assist the user and/or the reviewer. This facility has four horizontal 40 kilolitres storage tanks so we enter four to this cell. This example facility comprises several panel tanks of varying size and associated piping and pumps. We scroll down to the 7.6 megalitre panel tank and enter the quantity for these, in this case one and then one for the bigger 40 megalitre tank. The facility is continually processing water and in this case we will assume 1,000 kilolitres will remain. The facility does not have any major modules, that is large process units that would require separation into two or more sections for transport or any separators or small process units. The facility does have two pump units so we enter two to the pumps and controls, and has about 200 metres of piping between tanks and pumps. The facility is located in the field and does not have any on-site constructed buildings. It has one portable building which is for storage and a small office. We enter one to the portable buildings row. The last sections are for land rehabilitation which would typically include ripping, placement of growth media unless the site is in an arid region. For this example the land area for rehabilitation is three hectares, obtained from layout drawings and confirmed by aerial imagery. The calculator automatically calculates the volume of growth media required assuming a thickness of 150 millimetres, but the user can over-ride this entry with justification. Water transfer facilities do not generally require land investigation. The summary table groups the costs from the quantities entered above and then the total is shown at the top of the sheet. The total cost for water transfer facilities entered to this sheet is reported to the water transfer stations - user build row in the Main sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 11. This module will work through entering data into the LNG Facilities input sheet.

This sheet is intended for use with Curtis Island facilities if the user does not want to use the default rates in the Main sheet. The sheet includes most activities associated with an LNG plant, and where items are not included that will be decommissioned, dismantled, and/or demolished they must be added to the extra rows at the end of the table, or added to other input sheets or the Main sheet.

The LNG Facilities User Build sheet is included to allow the user to build a rate for specific facilities whereby the quantities are clearly understood. The sheet operates differently to most of the other sheets in that the entries are made vertically, similarly to the Process Facilities User Build sheet. As LNG plants are typically bigger and more complex than other facilities in the calculator, the user can enter alternate cost rates.

Entry to the sheet starts at the top by selecting the number of LNG trains. This entry does not affect any of the other quantities but feeds into the Waste Register calculations and provides context for the reviewer. The facility for this example is a two train.

The first entry is for the number of LNG tanks. The units for each row are in column H, number of tanks for the first row. This facility has two tanks so we enter two to this cell. The next two rows allow the user to pick between a candle flare and ground flare or enter quantities to both if both types are present on the facility. This facility has one ground flare. The next two entries are for process modules and skids whereby modules are large process units that would typically require splitting into sub-sections for transport off the island. Skids are assumed to be smaller units that can be lifted in one go, for example pump and small separator units. All the LNG rates incorporating equipment, scrap steel and other metals, include costs to transport material off the island and to disposal or storage on the mainland. For this example, our review of drawings and registers indicates the two train facility has a total of 200 major modules and 100 skids.

The next group of rows are green indicating selections are available. This group allows the user to select four different types of tanks and enter quantities against each. This facility has two 200 kilolitre vertical tanks for diesel fuel back up fuel, two 50 megalitres open top panel tanks for water storage, and seven horizontal 20 kilolitre steel tanks for storage of miscellaneous liquids. The site has one communications tower, one refuelling facility for small vehicles, twelve on-site constructed steel buildings, and thirty demountable type portable buildings. The camp row is green indicating a selection is available. The full range of camps available in the Main and Seismic and Infrastructure sheets are available here. If additional camps are required, for example if a construction camp is required for an expansion, the user can enter to the user item row at the bottom of the table and either use and reference a default rate or enter an alternate rate and provide justification.

The rates for modules and skids includes piping and fittings associated with those units, so the piping not associated with modules is for, typically longer, runs connecting areas of the plant. For this plant we have assumed 1 kilometre of piping. This concept applies to electrical cable and tray and for this plant we assume 500 metres. The pipe to ground penetrations are for cut and capping of piping that will be left in the ground. For this plant we assume everything is above ground so no entry is made to this row.

The next group of rates are for removal of surface covering. The default assumption is concrete will be crushed and re-used around the site, avoiding costly and high emission transport off-site. This assumption is also made for asphalt and gravel. For this plant we assume 3 hectares of concrete or 30,000 square metres of 250 millimetre concrete at a density of 2.4 tonnes per cubic metre, making 18,000 tonnes which will be crushed and placed around the site. We will assume the majority of the site not covered by plant or concrete is gravelled, and assume it is 50 hectares which is 500,000 square metres.

The mass of incidental waste to take off-site is any refuse not included in other rates. An allowance for general waste is included in rates such as process modules, so this row is for quantities that cannot reasonably be expected to be included in other rates. For this example we will assume the equivalent of about ten truckloads or 300 tonnes. There is no allowance for fencing in any of the other rates so any fencing such as boundary security must be added to the security fencing row. We will assume a boundary fence of 6 kilometres which is 6,000 metres.

The next group of rates is for land rehabilitation. These rates do not apply to hardstand that will be retained, or where crushed concrete will be placed to create a hardstand. For land to be returned to vegetation, the user will typically need to enter quantities to the reshape for drainage, level, growth media, and the appropriate revegetation row. For this example we will assume 50 hectares will require reshaping and placement of growth media for rehabilitation back to native vegetation.

The purging row is an allowance to flush gases out of the process units and piping and typically one unit would be entered here. The last two defined rows are for investigations and these work the same as for the other sheets, with a one off rate to cover mobilisation of investigation equipment and personnel and prepare documentation such as work plans and health and safety plans, and a separate rate for the area to be investigated. Remember the area to be investigated is just the area where the intrusive investigation will occur, not the whole site. The rates are higher than the rates for activities on the mainland to account for mobilisation offshore. For our example, we will add one for the one-off cost and assume an area of 3 hectares will require investigation.

The bottom of the table has spare rows for any additional items the user wants to enter. This example is theoretical and the quantities entered should not be taken as representative of an actual facility. The total for the sheet is reported to the top of the sheet, and then reported to the Main sheet to the LNG plant from user build row.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator.

See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 12. This module will work through entering data into the Water Storage and Water Storage User Build input sheets.

The Water Storage input sheet uses the same by area rates as the Main sheet. The default view of this sheet shows the range of options across the drop-down menus in columns E through H. For example the first twelve rows show the 0 to 50 megalitre size with selections for contaminated or clean, lined or unlined, and the three land types. The key utility of this sheet is that it allows a listing of all dams and ponds either individually or by group so the user and the department can clearly see the disturbance footprint assigned to each. Further, as the calculation is by area, it improves alignment with other spatial data.

The user selects whether the dam or pond is contaminated or clean, the size or capacity in megalitres, whether the dam or pond is in pasture, native, or arid land, whether it is lined or unlined, and whether it is regulated or non-regulated. The selections except for regulated/non-regulated, determine the per area rate applied to the row. The user then enters the number of dams and ponds in that category or row. The entry to this column must be a whole number, that is no decimals, and the calculator will communicate an error if a whole number is not entered. The user then enters the disturbance area for the dams and ponds in that row. For clarity, if more than one dam or pond is entered to a row, the user must enter the sum of the disturbance areas for each dam or pond. The area is the crest area of the structure. The per area rate is multiplied by the total disturbance area to get the total cost for each dam or pond in the category.

The number of dams and ponds in the category is for information only and does not feature in the calculation. It is not mandatory to enter the number but will assist the department to understand what is being costed. The regulated/non-regulated selection also does not feature in the calculation. Whether a dam is regulated or non-regulated is dependent upon the consequence category for the structure. Further information can be found in department's guidance document Structures which are dams or levees constructed as part of environmentally relevant activities (ESR/2016/1934). This regulated or non-regulated selection provides information needed by the department to reconcile spatial data, assist in assessment and compliance, and improve overall data and reporting of authorised water storages. The selection should be consistent with any regulated dam register required to be kept as part of the environmental authority.

The selection of contaminated or clean contents is a decision for the user. Generally, dams and ponds such as interceptors receiving oily water should be considered contaminated. The difference between contaminated and clean is the assumed sediment thickness which can be seen in the Assumptions sheet. A lined dam is assumed to have a plastic liner like high density polyethylene. Clay lined dams without a plastic liner are considered unlined.

For large dams where the land type may change, the user may need to split the disturbance between two land categories. The number of dam or ponds in each category, for example 0 to <= 50 megalitres contaminated, lined, pasture, are summed on the right hand side of the sheet and multiplied by the associated rate to get a total cost for the category. The cost for all categories is summed and displayed at the top of the sheet and reported to the Water Storage input sheet row in the Main sheet. The Water Storage input sheet rates do not include an allowance for water management, and this must be entered into the Main sheet if applicable. Entry to this sheet starts as usual with the map ID and then the name of the dam or pond or group of dams or ponds. The user then works across the drop-down menu columns selecting the item that best represents the item being costed. Remember, the number of dams and ponds in the category or row does not feature in the calculation but provides context for the reviewer. Further, if more than one dam or pond is entered to a row, the user must enter the sum of the disturbance areas for each dam or pond. We will work through an example with one row of a group of dams or ponds and three individual line items.

After entering the map ID we enter the name. For this first row, we are assuming there are five small ponds in an area. For a group entry to be made, the pond characteristics must be similar and fit within the drop-down categories. Our five ponds are ponds associated with drilling supply water and clean, so we select clean from the first drop-down menu. The next selection is the capacity. The capacities can be different as long as they all fall within the capacity range selected for that row. Our five ponds have crest capacities of 1, 1.5, 2, 3.5, and 4 megalitres so they all fit within the zero to fifty megalitre section. The land in which they are situated is pasture so we select pasture in the land type column, and the ponds are lined to conserve water so we select lined in the lined column. The ponds are also non-regulated. We enter five into the number column. Three of the ponds have a crest area of 10 by 10 metres and the other two are 20 by 20 metres. We can enter the calculation for the total disturbance area to the cell to make it easier for us and to show the reviewer how the number was arrived at. So in this case, we enter brackets as we will divide by ten thousand to convert to hectares, three by ten by ten plus two by twenty by twenty, close brackets and then divide by ten thousand to get hectares. That’s it for this row and you can see the total disturbance area for the group of ponds is allocated to the zero to less than or equal to fifty megalitres, clean, lined, pasture column.

The next three entries will be individual dams. They are called Ochre 1, 2, and 3. We can enter all the names first. Ochre 1 is a lined evaporation pond containing clean water with a capacity of two thousand megalitres and crest area of thirty hectares in an arid environment. It is non-regulated. Ochre 2 is a lined process water pond receiving oily water of ten megalitres capacity and crest area of thirty by thirty metres (or 0.09 hectares) in an arid environment. It is regulated. Ochre 3 is a lined brine pond of two hundred megalitre capacity and a crest area of seven hectares in an arid environment. It is also regulated. On the right you can see how the calculator has allocated the quantities and at the bottom how the areas are multiplied by the per hectare rates. The total is shown at the top and reported to the Main sheet.

The Water Storage User Build sheet allows the user to construct a rate by defining specific items to the dams or ponds. The sheet has similar selections to the Water Storage user input sheet but allows the user more flexibility on specific items such as sediment thickness and liner area. The sheet uses the same underlying default rates as the Main sheet and the Water Storage user input sheet.

The sheet requires the user to input or select the dam or pond type, for example interceptor, oily/water, raw/produced water, brine, evaporation etc. The user also selects whether the structure is regulated or non-regulated, the number of structures in each category, the land type, the crest area, whether the structure is lined or unlined, the width, height and slope of walls, and the number of dams to share upfront cost.

The user must enter these elements for the calculation to work correctly and for the department to have sufficient information for review. The key elements required for the calculation to work are indicated by 'Key Input' in the row beneath the header, and the department will query the user if any of these are absent.

The user has the option to override defaults and calculated values for the following:

Liner area. If the user does not enter a liner area the calculation assumes a multiplier as shown within the formula cell. The calculation checks the liner section and sets the liner area to zero if unlined is selected. If the user enters a liner area less than the crest area, the cell in the 'Liner Warning' column turns red and displays an 'E'. If this was not an error, the user must provide justification.

User entered area of the wall. The area is calculated based on the dimension values already entered, however the user can over-ride this in this cell. The volume of dirt in bunds column will then use this value instead of the calculated value.

Bund wall perimeter. If the user does not enter a perimeter, the calculation simply calculates the average length of a wall and multiplies it by four.

Sediment thickness. If the user does not enter a sediment thickness, the calculation uses the default as shown in the Assumption sheet and linked to by a hyperlink in that column.

Growth media area. If the user does not enter a growth media area, the calculation assumes the entire crest area will receive growth media and be revegetated. If the user selects arid in the land type selection, the growth media area is automatically set to zero.

Growth media thickness. If the user does not enter a growth media thickness, the calculation uses the default as shown in the Assumption sheet and linked by a hyperlink in that column.

Area to investigate. If the user does not enter an area to investigate area, the calculation assumes the entire crest area will be investigated. In some cases, the user may determine that investigation is not required, in which case, justification must be provided.

The user can select the haulage distance and fleet size for sediment removal, dozer push in walls, and growth media. Further information on fleet selection is included in the user guide. The rate associated with each selection is sourced from the Subrates sheet which can be accessed by the hyperlinks.

The capacity or volume of the dam or pond in megalitres serves to indicate the cost in dollars per megalitre on the right-hand side of the table and is not mandatory to enter.

The calculator calculates the sum for each sub-activity, for example application of growth media associated with the structure, and adds these together to reach a total cost. The total for the structure is multiplied by the total number of structures in that category to obtain the total for the row. It is important that the entries made in each row are by a dam or pond, which is different to the Water Storage sheet where the total area for all the structures in that row are entered.

The 'number of dams to share upfront cost' column associated with land investigation acknowledges that one-off type costs associated with the investigation, for example preparation of health and safety and work plans, is typically shared among items that can be reasonably assumed to be visited in one investigation campaign. Omitting this entry is a common cause of error in this calculation.

An example of its use is where a single dam or pond is entered to a row and it is the only dam or pond in that area that will be investigated. In this case the entry will be one, indicating that the full one-off costs are applied to that dam or pond.

Another example is five dams of similar characteristics and in the same local area are added to a row. In this case it is reasonable to enter five indicating that the one-off costs will be split between all the dams.

Another example is where four dams of similar characteristics are entered to the row but are separated by hundreds of kilometres. In this case it may be reasonable to enter 2 indicating that two separate investigation campaigns will be undertaken.

Let's go through an example. As always, the map ID and name are entered first. Our example is one dam called Ochre 4. It is an evaporation pond with a crest capacity of one thousand megalitres and is a regulated structure. We enter one in the number of structures column and select native as this dam is in an area of native grasses. The crest area is 30 hectares and it is lined with a total liner area as per the drawings of 34 hectares. You can see the calculator assumes a liner area equal to the crest area multiplied by 1.2 to account for slopes unless the user overrides this. As an example if we entered 29 hectares for the liner area we see an error is communicated. Let's change it back to 34 and continue on. The next section is for pushing in the dam or pond walls which is basically an earthmoving activity. From the drawings we know the wall height is four metres, the wall width at the top is two metres, and the slope of the wall is one in three. You can see the cross-sectional area calculated based on these inputs. We accept this calculation rather than enter a specific cross-sectional area as it looks correct based on our other inputs. The calculator outputs a linear length of bund walls but we know from the drawings the actual length is 2,005 metres so we enter this to the user entered linear length of bunds cell to override the calculator. The calculator calculates the volume of soil in the bunds and this value will be used with the rates determined by selections made later in the row.

The next section is about the sediment of the dam. For this example, we are assuming we don't know the sediment depth so we accept the default thickness and subsequent calculation of sediment volume. As for the bund soil volume, this value will be used with the rates determined by selections made later in the row.

The next section is the application of growth media, and the calculated area and default thickness of 150 mm are appropriate for this dam. Consequently we accept the calculated volume for growth media which again will be used with the rates determined by selections made later in the row.

The next section is for land investigations. In this case we determined that an investigation is required so we accept the default area to investigate produced by the calculator.

The next columns are for fleet size and distance selections for each of the rehabilitation activities. There is further information on these items in the user guide and if the user is unsure they can leave the default selections. In general larger dams are likely to use larger fleets and have longer distances to transport quantities such as sediment. In this example we will be transporting sediment on average 2 kilometres and will be using a medium fleet. The walls will be pushed in with a maximum push length of 40 metres and using a large D10 dozer. The distance between source and average placement for growth media is 2 kilometres and we will be using the same fleet as for the sediment. In the unit rates section you can see the rates determined by the selections made by the user, and then the next section shows the results for multiplication of these by the corresponding quantities.

The final section shows the total cost for the dam and the total cost for all the dams in the row, and cost rates dollar per megalitre and per unit area. The cost rates are for context only and show an error message if the user has neglected to enter the required information, though the volume entry is not mandatory. The land investigation column indicates if the user has not entered the number of dams to share upfront cost item. The totals for each row are summed, reported to the top of the sheet, and then reported to the water storage user defined row in the Main sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator. See you in the next module.

Welcome back to the training for the 2022 edition of the estimated rehabilitation cost calculator for petroleum and gas. This is Module 13. This module will work through entering data into the Investigation Contamination user input sheet.

The Investigation Contamination user input sheet allows the user to list out investigation areas and waste quantities for disposal off-site. The Main sheet has default rates for contaminated land investigations, including preliminary and detailed site or intrusive investigations, treatment of hydrocarbon impacted soil, and disposal off-site to a licensed facility. The default rates for activities in other domains including dams and ponds and process facilities include land investigation. Similarly, waste management including off-site disposal where required, is included in rates for those domains and activities such as wells.

Consequently, the rates in the Investigation Contamination user input sheet are unlikely to be commonly required. An example of where they may be used are a camp with an associated refuelling facility of material size, for example greater than a 5 kilolitre tank and associated pump or pumps. In this case, the sheet may be used to show the investigation. Another example is a separate land treatment facility where material volumes, for example greater than 500 cubic metres of soil, are being treated on a one-off or routine basis. Another example is a stockpile of metal or asbestos contaminated soil either on or off-site. Contaminated soil management is not included in the default rates. A further example is stockpiles of asbestos containing materials, for example from asbestos pipe.

The first table in the sheet is for site investigations. In general, an area will require one preliminary site investigation. The preliminary site investigation unit rate is a one-off cost. A preliminary site investigation in the context of a facility or site closure is typically a part of planning activities and aims to identify areas of known, suspected or reasonably probable contamination resulting from petroleum and gas operations. The preliminary site investigation comprises a review of the site settings, the site history, operational history including any incidents and accidents, hazardous liquids, solids storage schedules, and sources of potential impacts and the receptors.

If the user enters a preliminary site investigation but not subsequent intrusive site investigation quantities, the user should identify why in the user information column on the Main sheet or in the Information sheet.

The approach to estimating costs for site investigations recognises that most investigations of this nature comprise a single campaign, as in one mobilisation taking in multiple areas. The one-off cost allows for planning and preparation, ongoing project management, health and safety plans, work plans and reporting. A combination of the factors including risk, the nature and extent of the rehabilitation program, site history and grouping, and relative proximity of infrastructure must be considered in determining the number of one-off costs to apply. One example of an area that may individually comprise one campaign is a service facility area such as fuel or chemical stores, workshop, vehicle washdown, or sewage treatment. Another example is the oil storage at a processing plant.

The default rates for intrusive investigations assume several soil bores per area and a specific suite of analytes. The area is applied only to the area to be investigated. For example, for a tank farm within a processing facility, only the tank farm area is entered. The user can describe the area for a land investigation by entering width and length, diameter, or the area. This recognises that users will have different quantity types. Some users may use area outputs from GIS data and others may measure length and width off a plan. The hierarchy is user entered area, followed by width and length and then diameter. So if an area is entered, the calculator ignores any length and width and diameter entries. If area is not entered and length, width, and diameter are added, the calculator uses length and width and ignores diameter. The 'Calculated Area (ha)' column shows the calculation of area based on the user entered dimensions and if a value is entered directly to the 'User Area (ha)' column, the 'Area for calculations (ha)' column will default to that entry. If a group of investigation areas is entered to one row, the total area or sum of diameters or sum of widths and lengths must be entered so that all areas are captured.

The table summarises the quantities for preliminary investigations, one-off costs for site investigations, and the area of site investigations and reports these separately to section 12 of the Main sheet. These quantities are added to any entries made directly to the Main sheet and multiplied by the default rates to get the total for each line.

The next table is the disposal to off-site facility table. The user can select the contamination from the drop-down menu and enter the mass of that contaminant. Sludge can be used for tank bottoms or brine type material. Where applicable, the calculator will add the quantities entered to the off-site disposal table in the Waste Register and apply the levy. The columns to the right of the user entries show how the calculator has allocated the quantities and these are summed at the bottom of the table and reported separately to section 12 of the Main sheet, as for the investigation quantities.

Let's look at some examples. For investigations we will use the various different ways to enter dimensions. As always we first enter the map ID and then the name of the area. Let's call the areas Remote vehicle filling station, Legacy sludge pond area, and Remote landfarming area. For the first area, we have proof that a recent preliminary site investigation was undertaken so we will not enter a quantity. For the others a preliminary site investigation is required so we enter a one. The remote vehicle filling station is almost a perfect square and we have length and width measurements of 20 metres each. So we enter twenty to length and twenty to width. The legacy sludge pond area is almost a circle of a diameter 50 metres so we use the diameter. The remote landfarming area is an irregular area but we have a GIS generated polygon of two hectares.

For the disposal to off-site facility table, we again enter the map ID and name of the area. In each case we just enter the mass of the contaminated material to dispose and then select the contaminant from the drop-down menu. In some cases such as contaminated soil, a material may contain several contaminants. For the purpose of this calculator, the predominant contaminant is selected. Lets add 1 tonnes to each row to demonstrate how the quantities are reported to the right of the table and then through to the Main sheet.

As always, for more information or specific instructions, please consult the user guide which is also available on the Business Queensland website, below the download for the calculator.

That concludes the final module in the training, thanks for joining me.