{"text_format":"1","workbook":"xlsx","n_sheets":49,"sheets":["Instructions","Info","Cover Sheet","Contact details","Environmental Outcomes","Environ Outcomes code","Land  Use - Site and Surrounds","Land use code","Piggery Description","Piggery Description code","Environmental Risk Assessment","ERA Vulnerability of Soils","ERA Vulnerability of soils Code","ERA Vulnerability Groundwater","ERA Vul groundwater code","ERA Vulnerability Surface Water","ERA Vul surface water code","ERA Vulnerability Community","ERA Vul community code","D&O RA Nutrient Monitoring","RA Nutrient Monitor code","D&O RA Manure Distribution","RA Manure Distr code","D&O RA Nutrient Loss Prevention","RA Nutrient Loss Preven code","D&O RA Paddock Rehab","RA Paddock Rehab code","D&O RA Mortalities Management","RA Mortalities Mgt code","D&O RA Odour, Dust, Noise","RA Odour, Dust, Noise code","Overall RA","Environmental Monitoring","Contingency Plans","Contingency Plans code","Records to be Kept","Records to be Kept code","EMP Review","Action Plans","Environ Training Record","Complaints Record","Complaints code","Environmental Monitoring Record","Manure Reuse Record","Manure Exports Record","Duty of Care","Pesticide Use Record","Environmental Incident Record","Pollution Data Monitoring Rpt"],"not_rendered":{"charts":0,"images":50,"macros":1,"external_links":1,"defined_names":153,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":77,"n_cols":6,"rows_kept":77,"cut":false,"hidden":false,"merged":[[37,1,37,4],[36,1,36,4],[0,1,0,4],[1,2,1,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[17,2,17,3],[11,2,11,3],[19,1,19,4]]}
[null,"Environmental Management Plan\n\nInstructions"]
[null,null,"Welcome to your EMP spreadsheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"There are four ways to enter data into this EMP:"]
[null,null,"Manually enter data"]
[null,null,"Data comes from another cell"]
[null,null,"Single selection only. Please don't overwrite. Press the delete key to clear selections"]
[null,null,"Multiple selections available. Please don't overwrite. Press the delete key to clear selections"]
[]
[]
[]
[null,"Table of Contents"]
[null,"General information","Environmental Risk Assessment","Design and Operation Risk Assessment","Records  "]
[null,"Cover Sheet","Environmental Risk Assessment","Nutrient Monitoring","Records to be Kept"]
[null,"Contact details","ERA Vulnerability of Soils","Manure Distribution","EMP Review"]
[null,"Environmental Outcomes","ERA Vulnerability Groundwater","Nutrient Loss Prevention","Action Plans"]
[null,"Land  Use - Site and Surrounds","ERA Vulnerability Surface Water","Paddock Rehabilitation","Environmental Training Record"]
[null,"Piggery Description","ERA Vulnerability Community","Mortalities Management","Complaints Record"," "]
[null,null,null,"Odour, Dust, Noise","Environmental Monitoring Record"]
[null,null,null,"Overall Risk Assessment","Manure Reuse Record"]
[null,null,null,"Environmental Monitoring","Manure Exports Record"]
[null,null,null,"Contingency Plans","Duty of Care"]
[null,null,null,null,"Pesticide Use Record"]
[null,null,null,null,"Environmental Incident Record"]
[null,null,null,null,"Pollution Data Monitoring Report"]
[]
[]
[]
[null,"You can also use the “back to instruction”, “previous page\", \"next page\", \"go to the end\" buttons at the bottom of each page to move around the EMP."]
[null,"At the end of the EMP, please SAVE the workbook and print the whole workbook for your record."]
[]
[null,null,null," "]
[null,null,null,null,"ERA Vul groundwater code"]
[null,null,null,null,"ERA Vulnerability Surface Water"]
[null,null,null,null,"ERA Vul surface water code"]
[null,null,null,null,"ERA Vulnerability Community"]
[null,null,null,null,"ERA Vul community code"]
[null,null,null,null,"D&O RA Nutrient Monitoring"]
[null,null," ",null,"RA Nutrient Monitor code"]
[null,null,null,null,"D&O RA Manure Distribution"]
[null,null,null,null,"RA Manure Distr code"]
[null,null,null,null,"D&O RA Nutrient Loss Prevention"]
[null,null,null,null,"RA Nutrient Loss Preven code"]
[null,null,null,null,"D&O RA Paddock Rehab"]
[null,null,null,null,"RA Paddock Rehab code"]
[null,null,null,null,"D&O RA Mortalities Management"]
[null,null,null,null,"RA Mortalities Mgt code"]
[null,null,null,null,"D&O RA Odour, Dust, Noise"]
[null,null,null,null,"RA Odour, Dust, Noise code"]
[null,null,null,null,"Overall RA"]
[null,null,null,null,"Environmental Monitoring"]
[null,null,null,null,"Contingency Plans"]
[null,null,null,null,"Contingency Plans code"]
[null,null,null,null,"Records to be Kept"]
[null,null,null,null,"Records to be Kept code"]
[null,null,null,null,"EMP Review"]
[null,null,null,null,"Action Plans"]
[null,null,null,null,"Environmental Training Record"]
[null,null,null,null,"Environ Training Record"]
[null,null,null,null,"Complaints Record"]
[null,null,null,null,"Complaints code"]
[null,null,null,null,"Environmental Monitoring Record"]
[null,null,null,null,"Manure Reuse Record"]
[null,null,null,null,"Manure Exports Record"]
[null,null,null,null,"Duty of Care"]
[null,null,null,null,"Pesticide Use Record"]
[null,null,null,null,"Environmental Incident Record"]
[null,null,null,null,"Pollution Data Monitoring Rpt"]
[null,null,null,null,"Report"]

{"sheet":"Info","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,1,15,2],[17,1,17,2],[19,1,19,2],[13,1,13,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Template developed by Robyn Tucker, Mingjia Yan and Bradley Warren, FSA Consulting, June 2014."]
[]
[null,"Australian Pork Ltd Project No: 2013/032 - Upgrade and Development of Environmental Management Plans (EMP's) for Conventional and Outdoor Production Systems"]
[]
[null,"Project Leader: Robyn Tucker, FSA Consulting, Private Bag 260, Horsham, 3400."]
[]
[null,"The assistance of Aeger Kingma and Tim Croagh in developing the template is acknowledged."]
[]
[null,"© Australian Pork Ltd"]
[null,"Level 2, 2 Brisbane Avenue         PO Box 4746"]
[null,"BARTON  ACT  2600                      KINGSTON  ACT  2604"]

{"sheet":"Cover Sheet","index":2,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Environmental Management Plan"]
[]
[null,null,"please insert piggery name",null," "]
[]
[]
[null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"Contact details","index":3,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Contact Details"]
[null,{"$f":"B4","v":"h1"},{"$f":"C4","v":"Piggery operator: "},"insert details"]
[null,">0"]
[null,"h1","Piggery operator: ","insert details"]
[null,1,"Street address:","insert details"]
[null,1,null,"insert details"]
[null,1,null,"insert details"]
[null,1,null,null,null,null,null," "]
[null,{"$f":"IF(D9=D5,0,1)","v":0},"Postal address:",{"$f":"D4","v":"insert details"}]
[null,{"$f":"IF(D10=D6,0,1)","v":0},"(if different from street address)",{"$f":"D5","v":"insert details"}]
[null,0,null,{"$f":"D6","v":"insert details"}]
[null,1,null,null,null,null,null," "]
[null,1,"Piggery Manager: ","insert details"]
[null,1,"Contact phone number:","insert details"]
[null,1,"Contact email address:","insert details"]
[null,1]
[null,{"$f":"IF(D17=D13,0,1)","v":0},"Environmental Manager (if different):",{"$f":"D13","v":"insert details"},null,null,null," "]
[null,{"$f":"IF(D18=D14,0,1)","v":0},"Contact phone number:",{"$f":"D14","v":"insert details"}]
[null,{"$f":"IF(D19=D15,0,1)","v":0},"Contact email address:",{"$f":"D15","v":"insert details"}]
[null,1]
[null,1,"Land Details"]
[null,1]
[null,1,"Real property description:","insert details"]
[null,0,null,"e.g. Lot 1 on Plan 4350, County of X, Parish of Y, Z Regional Council",null," "]
[]
[null,null,"Land area (ha):","insert details"]
[null,null,"Land owner:","insert details"]
[null,null,"Tenure:","insert details"]
[]
[null,null,"Licences & Approvals"]
[]
[null,null,"Piggery licence no.:","insert details"]
[null,null,"Licenced capacity:","insert details",null," "]
[null,null,null,null,null," "]
[null,null,"Planning approval no.:","insert details"]
[null,null,"Approved capacity:","insert details",null," "]
[]
[null,null,"Actual operating capacity (No. of pigs):",{"$f":"'Piggery Description'!D19","v":0},"pigs"]
[null,null,"Actual no. of SPU:",{"$f":"'Piggery Description'!E19","v":0},"SPU"]
[]
[null,null,"Stock intensive water licence no.'s:","insert details"]
[null,null,"Water available under licences:","insert details","ML"]
[null,null,"Water available from other supply/to buy","insert details","ML"]
[]
[null,null,"Irrigation water licence no.'s:","insert details"]
[null,null,"Water available under licences:","insert details","ML"]
[]
[null,null,"Comments","Please leave your comments here, if any"]

{"sheet":"Environmental Outcomes","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,4],[21,2,21,3]]}
[null,"Environmental Outcomes"]
[" ",null,null,null,{"$f":"E4","v":0}]
[]
[null,null,"To operate in an ecologically sustainable manner"]
[null,null,true]
[]
[null,null,"To reuse manure sustainably"]
[null,null,true]
[null,null," "]
[null,null,"To protect groundwater"]
[null,null,false]
[]
[null,null,"To protect surface waters"]
[null,null,true]
[]
[null,null,"To protect community amenity"]
[null,null,true]
[]
[null,null,"To protect flora species or communities, and fauna species and habits"]
[null,null,false]
[]
[null,null,"To protect items, sites or places of cultural heritage significance, both to Aboriginal and to other people"]
[null,null,true]
[]
[null,null,"Comments:","please leave your comments here, if any"]

{"sheet":"Environ Outcomes code","index":5,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
[]
["Environmental Outcomes"]
[]
[]
[null,null,"Please tick one or more boxes if applicable"]
[]
[null,null,"To operate in an ecologically sustainable manner",null,"To operate in an ecologically sustainable manner"]
[null,false,"- by suitable siting taking into account the location of sensitive land uses, watercourses, shallow groundwater and land suitable for waste reuse ",null,null,"by suitable siting taking into account the location of sensitive land uses, watercourses, shallow groundwater and land suitable for reuse."]
[null,false,"- through suitable size for location",null,null,"through suitable size for location."]
[null,false,"- through good management",null,null,"through good management."]
[]
[null,null,"To reuse manure sustainably:",null,"To reuse manure sustainably"]
[null,false,"- by maintaining or improving the productive qualities of land on-farm.",null,null,"by maintaining or improving the productive qualities of land on-farm."]
[null,false,"- by planning paddock rotations to ensure nutrients are applied at sustainable rates.",null,null,"by planning paddock rotations to ensure nutrients are applied at sustainable rates."]
[null,false,"- by promoting their even distribution over paddock areas.",null,null,"by promoting its even distribution over paddock areas."]
[null,false,"- through exercising a duty of care in relation to piggery manure going off-farm.",null,null,"through exercising a duty of care in relation to piggery manure going off-farm."]
[]
[null,null,"To protect groundwater:",null,"To protect groundwater"]
[null,false,"- through good siting - no shallow groundwater beneath pig paddocks",null,null,"through good siting - no shallow groundwater beneath pig paddocks."]
[null,false,"- through good siting – no shallow groundwater beneath pig paddocks or areas used to spread spent bedding",null,null,"through providing good buffers between pig paddocks and bores."]
[null,false,"- through good buffers between pig paddocks",null,null,"through good buffers between reuse areas and bores."]
[null,false,"- through good buffers between piggery and reuse areas and bores",null,null,"through good design and construction - impermeable bases under all areas of the piggery used to store manure."]
[null,false,"- through good design and construction - impermeable bases under all areas of the piggery used to store manure",null,null,"through good design and construction - impermeable bases under all areas of the piggery used to store manure or compost mortalities."]
[null,false,"- through good design and construction - impermeable bases under all areas of the piggery used to store manure or compost mortalities",null,null,"through good design and construction - impermeable bases under all areas of the piggery used to compost mortalities."]
[null,false,"- through good design and construction - impermeable bases under all areas of the piggery used to compost manure or mortalities",null,null,"through sustainable reuse of manure nutrients."]
[null,false,"- through good control all manure and effluent and sustainable reuse of manure nutrients"]
[null,null,null,null,"To protect surface waters"]
[null,null,"To protect surface waters:",null,null,"through good siting - adequate buffers to watercourses."]
[null,false,"-through good siting - adequate buffers to watercourses",null,null,"through good siting - vegetative filter strips to waterways."]
[null,false,"-through good siting - vegetative filter strips to waterways",null,null,"through good siting - pig paddocks are above the 1 in 100 year flood line."]
[null,false,"-through good siting - pig paddocks are above the 1 in 100 year flood line",null,null,"through good siting - reuse areas are above the 1 in 5 year flood line.\n"]
[null,false,"-through good siting - reuse areas are above the 1 in 5 year flood line\n",null,null,"through good design and construction - the manure storage areas are bunded."]
[null,false,"- through good design and construction - the manure storage areas are bunded",null,null,"through good design and construction - the mortalities composting area is bunded to control drainage."]
[null,false,"- through good design and construction - the mortalities composting area is bunded to control drainage"]
[null,null,null,null,"To protect community amenity"]
[null,null,"To protect community amenity:",null,null,"through providing suitable separation distances."]
[null,false,"- through providing  suitable separation distances",null,null,"through good paddock management that prevents odour and dust becoming an issue."]
[null,false,"- through good paddock management that prevents odour and dust becoming an issue",null,null,"through good paddock and bedding management that prevents odour and dust from becoming an issue."]
[null,false,"- through good paddock and bedding management that prevents odour and dust from becoming an issue",null,null,"through good paddock and wallow management that prevents odour and dust from becoming an issue."]
[null,false,"- through good paddock and wallow management that prevents odour and dust from becoming an issue",null,null,"through good paddock, bedding and wallow management that prevents odour and dust from becoming an issue."]
[null,false,"- through good paddock, bedding and wallow management that prevents odour and dust from becoming an issue"]
[null,null,null,null,"To protect flora species or communities, and fauna species and habits"]
[null,null,"To protect flora species or communities, and fauna species and habits:",null,null,"by managing vegetation clearing and replacing removed vegetation with appropriate plantings of suitable species."]
[null,false,"- by managing vegetation clearing and replacing removed vegetation with appropriate plantings of suitable species.",null,null,"by protecting remnant vegetation and native trees with suitable fencing."]
[null,false,"- by protecting remnant vegetation and native trees with suitable fencing",null,null,"by excluding areas with native vegetation from piggery use"]
[null,false,"- by managing reuse aappropriately.",null,null,"by managing reuse appropriately."]
[]
[null,null,"To protect items, sites or places of cultural heritage significance, both to Aboriginal and to other people:",null,"To protect items, sites or places of cultural heritage significance, both to Aboriginal and to other people"]
[null,false,"- by identifying and protecting these items.",null,null,"by identifying and protecting these items."]
[null,null,null,null,null,"by excluding these areas from piggery use"]

{"sheet":"Land  Use - Site and Surrounds","index":6,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Land  Use - Site and Surrounds"]
[]
[]
[null,null,"The land use zoning of the farm is"]
[]
[]
[null,null,"Other than the piggery, land uses on-farm include"]
[null,null,true]
[null,null,"Comments"]
[]
[null,null,"Surrounding land uses include"]
[null,null,true,null," "]
[null,null,"Comments"]
[]
[null,null,"The closest houses belonging to others are:"]
[null,null,null,null,null,null,null,null," "]
[]
[null,null,"The closest houses belonging to others are to the:"]
[null,null,false]
[]
[null,null,"Climate"]
[null,null,"The annual rainfall is"]
[null,null,null,null,"mm"]
[]
[null,null,"The temperature zone in which the piggery is located is "]
[null,null,null,null,null,null,null," "]
[null,null,null,{"$f":"IF(D26=0,\"temperature zone examples\", VLOOKUP(D26,'Land use code'!C47:D49,2,FALSE))","v":"temperature zone examples"},null,null," "]
[null,null,null," "]
[null,null,"The predominant wind direction in Summer is from the",null,null,null,null,null,null,null," "]
[null,null,true]
[null,null,null," "]
[null,null,"The predominant wind direction in Winter is from the"]
[null,null,true]
[]
[]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[null,null," "]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Land use code","index":7,"n_rows":118,"n_cols":11,"rows_kept":118,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[]
[null,"Site Description"]
[]
[]
[]
[null,"Nearby land uses"]
[]
[null,"Farm zoning","suitable - farm / rural zoning."]
[null,null,"suitable - piggeries are a permissible use."]
[null,null,"unsuitable."]
[null,"Land uses on-farm (other than the piggery)","grazing","grazing"]
[null,null,"broadacre farming","broadacre farming",null," "]
[null,null,"other agricultural / horticultural uses","other agricultural / horticultural uses",null," "]
[null,null,"non-agricultural uses","non-agricultural uses"]
[null,"Surrounding land uses","grazing","other intensive livestock (please specify below)"]
[null,null,"broadacre farming",null,null," "]
[null,null,"other agricultural / horticultural uses"]
[null,null,"non-agricultural uses"]
[null,"Are there nearby residential zones?","Yes "]
[null,null,"No"]
[null,"Are there nearby rural residential zones?","yes / no",null,null,null,null,null,null,null," "]
[null,"The closest houses belonging to others are","within about 1 km of the piggery.",null,null," "]
[null,null,"about 1 to 2 km of the piggery."]
[null,null,"within about 2 km of the piggery."]
[null,null,"more than 3 km from the piggery."]
[]
[null,"How many houses are located fairly close to the piggery?","are no houses belonging to others near the piggery."]
[null,null,"is one house belonging to others fairly close to the piggery."]
[null,null,"are two houses belonging to others fairly close to the piggery."]
[null,null,"are a few houses belonging to others fairly close to the piggery."]
[null,null,"are several houses belonging to others fairly close to the piggery."]
[null,null,"are many houses belonging to others fairly close to the piggery."]
[null,null,null,null,null,null,null,null,null," "]
[null,"How many?","enter number"]
[null,"If \"yes\", in which direction are these?","N","north"]
[null,null,"NE","north-east"]
[null,null,"E ","east"]
[null,null,"SE","south-east"]
[null,null,"S ","south"]
[null,null,"SW","south-west"]
[null,null,"W","west"]
[null,null,"NW","north-west"]
[null,null," ",null,null," "]
[null,"Climate"]
[null,null,null,null,null," "]
[null,"Annual Rainfall (mm)"]
[null,"Temperature zone","Cool.","e.g. Armidale NSW, southern and central Victoria, southern SA, Tas"]
[null,null,"Warm.","e.g. inland NSW, SE Qld, SA, southern WA"]
[null,null,"Hot.","e.g. central to N Qld, Moree, Goondiwindi"]
[]
[null,"Predominant wind direction - Summer"," "]
[null,null,"east"]
[null,null,"north-east"]
[null,null,"south-east"]
[null,"Predominant wind direction - Winter"]
[null,null,"west",null,null," "]
[null,null,"north-west"]
[null,null,"south-west"]
[null," "]
[null,null,null,null,null," "]
[null,"Land Resources"]
[]
[null,"Overall farm topography 1","Flat"]
[null,null,"Gently sloping"]
[null,null,"Gently undulating"]
[null,null,"Undulating"]
[null,null,"Hilly",null,null,null," "]
[]
[null,"Overall farm topography 2"]
[]
[null,"Topography at piggery site","choose from flat, gently sloping, gently undulating, undulating, hilly"]
[]
[null,"Soil type","Sand"]
[null,null,"Sandy loam"]
[null,null,"Loam"]
[null,null,"Clay loam"]
[null,null,"Light clay",null," "]
[null,null,"Medium clay"]
[null,null,"Heavy clay"]
[]
[null,"Soil suitability for building impermeable pond and pads","good "]
[null,null,"reasonable"]
[null,null,"poor"]
[null," "," "]
[null,"Are there on-farm reuse areas?  (If \"Yes\" complete below)","Yes / No"]
[null,"Topography 1 of on-farm effluent reuse areas","choose from flat, gently sloping, gently undulating, undulating, hilly"]
[null,"Topography 2 of on-farm effluent reuse areas","choose from flat, gently sloping, gently undulating, undulating, hilly"]
[null,"Soil type 1","choose from sand, sandy loam, loam, clay loam, light clay, medium clay, heavy clay"]
[null,"Soil type 2","choose from sand, sandy loam, loam, clay loam, light clay, medium clay, heavy clay"]
[null,"Land use capability, suitability for:","Light grazing"]
[null,null,"Grazing"]
[null,null,"Grazing and could be sown"]
[null,null,"Cut pasture or forage"]
[null,null,"Bbroadacre cropping without regular cultivation"]
[null,null,"Broadacre cropping with regular cultivation"]
[]
[]
[]
[null,"Specific land use constraints",null,null,null," "]
[null,"Overall vulnerability rating - soils in reuse areas","7-28"]
[null," "," "]
[null,"Are there on-farm manure reuse areas?  (If \"Yes\" complete below)","Yes "]
[null,null,"No"]
[null,"Topography 1 of on-farm effluent reuse areas","choose from flat, gently sloping, gently undulating, undulating, hilly"]
[null,"Topography 2 of on-farm effluent reuse areas","choose from flat, gently sloping, gently undulating, undulating, hilly"]
[null,"Soil type 1","choose from sand, sandy loam, loam, clay loam, light clay, medium clay, heavy clay"]
[null,"Soil type 2","choose from sand, sandy loam, loam, clay loam, light clay, medium clay, heavy clay"]
[null,"Land use capability, suitability for:","choose from: light grazing; grazing; grazing and could be sown; cut pasture or forage;  broadacre cropping without regular cultivation; broadacre cropping with regular cultivation"]
[null,"Specific land use constraints","No specific constraints"]
[null,null,"Stony"]
[null,null,"Erosion prone"]
[null,null,"Saline"]
[null,null,"Sodic"," "]
[null,null,"Acidic",null,null,null," "]
[null,null,"Subject to waterlogging",null,null,null,null," "]
[null,null,"Subject to flooding"]
[]
[null,"Overall vulnerability rating - soils in reuse areas","7-28"]

{"sheet":"Piggery Description","index":8,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,6],[20,3,20,6],[6,2,6,6]]}
[null,"Piggery Description"]
[null,{"$f":"B4","v":"h1"},{"$f":"C4","v":"The piggery unit type is "},{"$f":"D4","v":0}]
[null,">0",null,"breeder-weaner"]
[null,"h1","The piggery unit type is "]
[]
[]
[null,null,"The piggery herd composition, and housing type for each class of pigs, is shown below."]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Pig Class","No. of Pigs","No. of SPU","Shelter","Spent Bedding Management"]
[null,null,"Replacement gilts",null,{"$f":"D10*1.8","v":0},null,null,null,null,null,null,null," "]
[null,null,"Boars",null,{"$f":"D11*1.6","v":0}]
[null,null,"Gestating sows",null,{"$f":"D12*1.6","v":0}]
[null,null,"Lactating sows",null,{"$f":"D13*2.5","v":0}]
[null,null,"Suckers (0-4 weeks)",null,{"$f":"D14*0.1","v":0},"with sows"]
[null,null,"Weaners (4-10 weeks)",null,{"$f":"D15*0.5","v":0}]
[null,null,"Growers (10-16 weeks)",null,{"$f":"D16","v":0}]
[null,null,"Finisher (16-24 weeks)",null,{"$f":"D17*1.6","v":0}]
[null,null,"Finisher 2 (24+ weeks)",null,{"$f":"D18*1.8","v":0}]
[null,null,"Total",{"$f":"SUM(D10:D18)","v":0},{"$f":"SUM(E10:E18)","v":0}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[null,null,null,null,null,null,null,null,null," "]
[null,null," "]
[null,null,null,"weaner-grower-finisher"]

{"sheet":"Piggery Description code","index":9,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":true,"merged":[[1,1,1,5]]}
[]
[null,"Piggery Description"]
[null," "]
[null,"The piggery is a farrow-to-finish system with a total of 5000 pigs or 5000 SPU."]
[null,"The pigs are housed in a combination of conventional sheds and deep litter shelters."]
[]
[null,"Table 1 sets out the pig numbers and housing details.  (May not need housing type if all same)"]
[]
[null,"Pig Class","No. of","No. of","Housing","Totals"]
[null,null,"Pigs","SPU"," "," "]
[null,null,null,null,null," "]
[null,"Gilts"," ",null,"conv / deep litter","Total in"]
[null,"Boars"," ",null," ","conv"]
[null,"Gestating sows"," ",null," "," "]
[null,"Lactating sows"," ",null," ","Total on"]
[null,"Suckers"," ",null," ","litter"]
[null,"Weaners"," ",null," "," "]
[null,"Growers"," ",null," "," "]
[null,"Finisher"," ",null," "," "]
[null,"Finisher 2"," ",null," "," "]
[null,null,null,null,null," "]
[null,"Total",null," ",null," "]
[]
[]
[null,"Piggery Description"]
[]
[null,"Piggery Type 1","farrow-to-finish.","farrow-to-finish"]
[null,"Piggery Type 2","farrow-to-wean.","breeder"]
[null,null,"breeding.","breeder-weaner",null,null," "]
[null,null,"weaning.","weaner"]
[null,null,"weaner grow-out.","weaner-grower"]
[null,null,"grow-out.","weaner-grower-finisher",null,null,null,null,null,null,null," "]
[null,"Herd Description"," ","grower-finisher"]
[null,null,null,"finisher"]
[null,"Pig Class","Age range","No. of","SPU","No. of"]
[null,null,"(weeks)","Pigs","Multiplier","SPU"]
[]
[null,"Gilts","24-30","enter data",1.8,{"$f":"+D38*E38","v":{"$error":"#VALUE!"}}]
[null,"Boars",null,"enter data",1.6,{"$f":"+D39*E39","v":{"$error":"#VALUE!"}}]
[null,"Gestating sows",null,"enter data",1.6,{"$f":"+D40*E40","v":{"$error":"#VALUE!"}}]
[null,"Lactating sows",null,"enter data",2.5,{"$error":"#VALUE!"}]
[null,"Suckers","0-4","enter data",0.1,{"$error":"#VALUE!"}]
[null,"Weaners","4-10","enter data",0.5,{"$error":"#VALUE!"}]
[null,"Growers","10-16","enter data",1,{"$error":"#VALUE!"}]
[null,"Finisher","16-24","enter data",1.6,{"$error":"#VALUE!"}]
[null,"Finisher 2","24+","enter data",1.8,{"$error":"#VALUE!"}]
[]
[null,"Total",null,{"$f":"SUM(D38:D46)","v":0},null,{"$f":"SUM(F38:F46)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Housing"]
[]
[null,"Pig Class",null,"Manure"," "]
[null,null,"Housing","Management"," "]
[null,"Gilts",null,null,null,null,null,"Housing","Manure Management"]
[null,"Boars",null,null," ",null,null,"individual huts","burnt."]
[null,"Gestating sows","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks.",null,null,null,null,"small group shelters","left when shelter removed."]
[null,"Lactating sows","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks.",null,null,null,null,"large group shelters","dispersed over paddock."]
[null,"Suckers","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks.",null,null,null,null,null,"taken from paddock for reuse elsewhere on-farm."]
[null,"Weaners","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks.",null,null,null,null,null,"taken from paddock for reuse elsewhere on-farm or off-farm."]
[null,"Growers","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks.",null,null,null,null," ","taken from paddock for reuse off-farm."]
[null,"Finisher","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks."]
[null,"Finisher 2","choose from individual huts in paddocks, small group shelters in paddocks and large group shelters in paddocks."]
[]
[null," "]

{"sheet":"Environmental Risk Assessment","index":10,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Environmental Risk Assessment"]
[]
[null,null,"The purpose of this environmental risk assessment is to identify any actual or likely impact that the piggery may pose to the environment."]
[null,null,"This provides the basis for reducing impacts (or risks of impacts) through improved design, improved management or monitoring."]
[null,null,"There are three steps in this process:"]
[null,null,"·  describe the vulnerability of the four amenity and natural resource areas: soils, groundwater, surface water and community amenity.  Each of these areas includes a number of statements that are used to determine the overall risk.  A risk rating is assigned to each statement within each area; a rating of 1 represents a very low level of vulnerability and 4 represents a very high level of vulnerability.  The overall vulnerability of each amenity or natural resource area is equal to the highest rating (1-4) recorded for a statement about that area."]
[null,null,"·  describe the risk protection afforded by the major design and operational features of the piggery.  A number of statements are provided for each major design and operational area.  A risk rating is assigned to each of these statements with a rating of 1 representing a very low level of risk (i.e. a high level of protection) and 4 representing a very high level of risk.  An overall risk rating for each design and operational area, equivalent to the highest individual risk rating (1-4) from the statements, is assigned."]
[null,null,"·  evaluate the likelihood of an environmental impact.  The risk of an impact depends on the vulnerability of any natural resource or amenity and the protection afforded by design and operational measures.  Hence, the vulnerability rating for each natural resource or amenity area is multiplied by applicable design and operational risk ratings to gauge the overall risk.  Ratings ranging from 1 to 16 are possible, where 1-4 is a very low risk, 5-11 is a medium risk that might trigger investigation or action and 12-16 is a high risk and would trigger investigation or action."]
[]
[null,null,"The following sections use this process to determine areas where there is a risk of environmental impacts."]

{"sheet":"ERA Vulnerability of Soils","index":11,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Environmental Risk Assessment - Vulnerability Ratings\n\nSoils"]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"Paddocks used to run pigs are:",null,{"$f":"VLOOKUP(D5,'ERA Vulnerability of soils Code'!B12:C14,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"These paddocks have a soil depth of:",null,{"$f":"VLOOKUP(D7,'ERA Vulnerability of soils Code'!B16:C19,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"The soils of these paddocks are:",null,{"$f":"VLOOKUP(D9,'ERA Vulnerability of soils Code'!B21:C29,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"The soils are:",null,{"$f":"VLOOKUP(D11,'ERA Vulnerability of soils Code'!B31:C38,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"The paddocks are:",null,{"$f":"VLOOKUP(D13,'ERA Vulnerability of soils Code'!B40:C41,2,FALSE)","v":{"$error":"#N/A"}},null,null," "]
[]
[null,null,"Paddocks used to run pigs are:",null,{"$f":"VLOOKUP(D15,'ERA Vulnerability of soils Code'!B43:C46,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Paddocks used to run pigs",null,{"$f":"VLOOKUP(D17,'ERA Vulnerability of soils Code'!B48:C52,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null," "," "]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E19, 'ERA Vulnerability of soils Code'!B54:C58,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E5),VALUE(E7),VALUE(E11),VALUE(E9),VALUE(E13),VALUE(E15),VALUE(E17))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[]
[]
[null,null,null," ",null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"ERA Vulnerability of soils Code","index":12,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Environmental Risk Assessment - Vulnerability Ratings"]
[null," "]
["Soils","All tables in the risk assessment will be set up with pull down menus for each category."]
[null,"The highest number recorded for an individual item will transpose down to the overall rating."]
[]
[]
["There","are reuse areas on the farm that are separate and additional to the pig paddocks."]
[null,"are no reuse areas on the farm that are separate and additional to the pig paddocks."]
[]
["Rating Criteria",null,"Rating"]
[]
["Paddocks used to run pigs are:","suited to growing a broad range of broadacre crops and pastures.",1,null,null,null," "]
[null,"suited to growing crops or pastures that can be cut and carted.",3]
[null,"unsuited to growing or harvesting crops or pastures that can be cut and carted.",4]
[null,null,null,null," "]
["Paddocks used to run pigs have a soil depth of:","at least 1 m.",1]
[null,"at least 0.75 m.",2]
[null,"at least 0.5 m.",3,null,null," "]
[null,"less than 0.5 m.",4]
[]
["Paddocks used to run pigs have soils that are:","well structured, non-rocky, non-saline and non-sodic.",1]
[null,"non-rocky, non-saline and non-sodic.",2]
[null,"rocky.",4]
[null,"saline.",4]
[null,"sodic.",4]
[null,"rocky and sodic",4]
[null,"rocky and saline           ",4]
[null,"sodic and saline          ",4]
[null,"rocky, saline and sodic",4]
[]
["Paddocks used to run pigs have soils that are:","loams",1]
[null,"light clays.",1]
[null,"loams to light clays",1]
[null,"sandy loams",2]
[null,"medium clays",2]
[null,"sandy loams to medium clays.",2]
[null,"heavy clays.",3]
[null,"sandy.",4]
[]
["Paddocks used to run pigs are:","not prone to waterlogging.",1]
[null,"prone to waterlogging.",4]
[]
["Paddocks used to run pigs are:","above the 1 in 100 year flood line.",1]
[null,"above the 1 in 50 year flood line.",2]
[null,"above the 1 in 20 year flood line.",3]
[null,"lower than the 1 in 20 year flood line.",4]
[]
["Paddocks used to run pigs","generally have slopes of 2–4%.",1]
[null,"generally have slopes of 0–2%",2]
[null,"generally have slopes of 4–6%.",3]
[null,"have slopes that exceed 6%.",4]
[null,"have variable slopes but they range between 0-6%.             ",3]
[]
["OVERALL RATING",4,"Soils of pig paddocks are considered to be very vulnerable."]
[null,3,"Soils of pig paddocks are considered to be vulnerable."]
[null,2,"Soils of pig paddocks are considered to be somewhat vulnerable."]
[null,1,"Soils of pig paddocks are considered to have low vulnerability."]
[null,0,"Vulnerability of soils not assessed."]
[]
[]
[]
[null," "]
[null," "]
[null," "]

{"sheet":"ERA Vulnerability Groundwater","index":13,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Environmental Risk Assessment - Vulnerability Ratings\n\nGoundwater"]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"The depth to groundwater is:",null,{"$f":"VLOOKUP(D5,'ERA Vul groundwater code'!B7:C12,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Water for potable use is:",null,{"$f":"VLOOKUP(D7,'ERA Vul groundwater code'!B14:C15,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Groundwater is:",null,{"$f":"VLOOKUP(D9,'ERA Vul groundwater code'!B17:C22,2,FALSE)","v":{"$error":"#N/A"}}," "]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E11,'ERA Vul groundwater code'!B24:C27,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E5),VALUE(E7),VALUE(E9))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]

{"sheet":"ERA Vul groundwater code","index":14,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Environmental Risk Assessment - Vulnerability Ratings"]
[]
["Groundwater"]
[]
["Rating Criteria",null,"Rating"]
[]
["The depth to groundwater is:","always at least 20 m below the ground surface.",1]
[null,"always at least 10 m beneath the surface, and protected by a significant rock or clay band .",1]
[null,"always at least 10 m below the ground surface.",2]
[null,"always at least 2 m beneath the surface and protected by a significant rock or clay band.",2]
[null,"always at least 2 m below the ground surface.",3]
[null,"sometimes less than 2 m below the ground surface.",4]
[]
["Water for potable use is:","not sourced from bores located within 1 km of the piggery.",1]
[null,"sourced from bores located within 1 km of the piggery.",4]
[]
["If groundwater is used in the piggery, there is:","not used in the piggery.",1,null,null," "]
[null,"used in the piggery and there is ample allocation and supply that is of suitable quality.",1]
[null,"used in the piggery and there is sufficient allocation and supply that is of a suitable quality.",3]
[null,"used in the piggery but there is marginal allocation or supply to meet requirements.",4]
[null,"used in the piggery but is of marginal quality to meet requirements.",4]
[null,"used in the piggery but is of marginal allocation or supply and quality to meet requirements.",4]
[]
[null,4,"Groundwater resources are considered  to be very vulnerable."]
[null,3,"Groundwater resources are considered to be vulnerable."]
[null,2,"Groundwater resources are considered to be somewhat vulnerable."]
[null,1,"Groundwater resources are considered to have low vulnerability.",null,null,null,null," "]
[]
[]
["OVERALL RATING","This will be the highest individual rating selected above  (1-4, with 4 being the highest possible value)."]

{"sheet":"ERA Vulnerability Surface Water","index":15,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Environmental Risk Assessment - Vulnerability Ratings\n\nSurface Waters"]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"Paddocks used to run pigs are located:",null,{"$f":"VLOOKUP(D5,'ERA Vul surface water code'!B10:C12,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"They are:",null,{"$f":"VLOOKUP(D7,'ERA Vul surface water code'!B14:C15,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Paddocks used to run pigs",null,{"$f":"VLOOKUP(D9,'ERA Vul surface water code'!B17:C24,2,FALSE)","v":{"$error":"#N/A"}}," "]
[]
[null,null,"The piggery is located:",null,{"$f":"VLOOKUP(D11,'ERA Vul surface water code'!B26:C28,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Surface water is:",null,{"$f":"VLOOKUP(D13,'ERA Vul surface water code'!B35:C41,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(D15=\"not used at this piggery\",0,1)","v":1},"On-farm reuse areas are",null,{"$f":"VLOOKUP(D15,'ERA Vul surface water code'!B30:C33,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Reuse areas",null,{"$f":"VLOOKUP(D17,'ERA Vul surface water code'!B17:C24,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E19,'ERA Vul surface water code'!B43:C46,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(B15=0,MAX(VALUE(E15),VALUE(E5),VALUE(E7),VALUE(E9),VALUE(E13),VALUE(E11)),MAX(VALUE(E5),VALUE(E7),VALUE(E9),VALUE(E13),VALUE(E11),VALUE(E17)))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]

{"sheet":"ERA Vul surface water code","index":16,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["Environmental Risk Assessment - Vulnerability Ratings"]
[]
["Surface Water"]
[]
["You re-use on-farm surface waters",true]
[null,false]
[]
["Rating Criteria",null,"Rating"]
[]
["Paddocks used to run pigs are located:","at least 200 m from the closest watercourse.",1]
[null,"at least 100 m from the closest watercourse.",2]
[null,"within 100 m of a watercourse.",4]
[]
["Paddocks used to run pigs are located:","at least 800 m from the closest major water supply storage.",1]
[null,"within 800 m of the closest major water supply storage.",4]
[null,null,null,null,null,null," "]
["Paddocks used to run pigs","comply with the National Guidelines buffer distances and vegetative strips separate these areas from watercourses.",1]
[null,"comply with the National Guidelines buffer distances and there are also terminal ponds below them.",1]
[null,"comply with the National Guidelines buffer distances and there are terminal ponds or vegetative strips below them.",1]
[null,"comply with the National Guidelines buffer distances.",2]
[null,"don't comply with the National Guidelines buffer distances but effective vegetative strips separate these areas from watercourses.",3]
[null,"don't comply with the National Guidelines buffer distances but there are terminal ponds below them.",3]
[null,"don't comply with the National Guidelines buffer distances but there are effective vegetative strips or terminal ponds below them.",3]
[null,"don't comply with buffer distances in the National Guidelines or provide other effective watercourse protection measures.",4]
[]
["Paddocks used to run pigs are located:","above the 1-in-100 year flood line.",1]
[null,"above the 1-in-50 year flood line.",3]
[null,"within the 1-in-50 year flood line.",4,null," "]
[]
["On-farm reuse areas are:","not used at this piggery",0]
[null,"located above the 1-in-10 year flood line.",1]
[null,"located above the 1-in-5 year flood line.",2]
[null,"located within the 1-in-5 year flood line.",4]
[]
["Surface water is:","not used in the piggery",1]
[null,"used in the piggery and there are no concerns about supply or quality",1]
[null,"used in the piggery and supply and quality are good",2]
[null,"used in the piggery and there is sufficient allocation and suitable quality",3]
[null,"used in the piggery and water supply is sometimes a concern",4]
[null,"used in the piggery but quality is marginal",4]
[null,"used in the piggery but supply and quality are marginal",4]
[null," "]
["OVERALL RATING",4,"Surface waters are considered to be very vulnerable."]
[null,3,"Surface waters are considered to be vulnerable."]
[null,2,"Surface waters are considered to be somewhat vulnerable."]
[null,1,"Surface waters are considered to have low vulnerability."]

{"sheet":"ERA Vulnerability Community","index":17,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Environmental Risk Assessment - Vulnerability Ratings\n\nCommunity Amenity"]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"The piggery has received:",null,{"$f":"VLOOKUP(D5,'ERA Vul community code'!B7:C10,2,FALSE)","v":{"$error":"#N/A"}},null,null,null," "]
[]
[null,null,"The pig paddocks:",null,{"$f":"VLOOKUP(D7,'ERA Vul community code'!B12:C13,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Surrounding land is:",null,{"$f":"VLOOKUP(D9,'ERA Vul community code'!B15:C17,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E11,'ERA Vul community code'!B19:C22,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E5),VALUE(E7),VALUE(E9))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]

{"sheet":"ERA Vul community code","index":18,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Environmental Risk Assessment - Vulnerability Ratings"]
[]
["Community Amenity"]
[]
["Rating Criteria",null,"Rating"]
[]
["The piggery has received:","no complaints from the public or regulators for at least five years.",1]
[null,"less than two complaints per year (on average) over the past five years.",2]
[null,"less than four complaints per year (on average) over the past five years.",3]
[null,"four or more complaints per year (on average) over the past five years.",4]
[]
["The pig paddocks:","always meet the minimum fixed separation distances to a town, rural residential area and rural dwelling in the National Guidelines.",1]
[null,"don’t always meet the minimum fixed separation distances to a town, rural residential area and rural dwelling  in the National Guidelines.            ",4]
[]
["Surrounding land is:","all designated rural, and is not designated for future development or rezoning.",1]
[null,"all designated rural, but some designated for either future development or rezoning.",3]
[null,"not all designated rural.",4]
[]
["OVERALL RATING",4,"Overall, community amenity is considered to be very vulnerable."]
[null,3,"Overall, community amenity is considered to be vulnerable."]
[null,2,"Overall, community amenity is considered to be somewhat vulnerable."]
[null,1,"Overall, community amenity is considered to have low vulnerability."]

{"sheet":"D&O RA Nutrient Monitoring","index":19,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Design and Operation Risk Assessment\n\nNutrient Monitoring"]
[]
[null,null,"The usual length of the pig phase on an area of land is:",null,"months"]
[]
[null,null,"The usual length of a paddock rotation (pig phase and crop / pasture / forage phase) is",null,"years"]
[]
[null,null,"Rating Criteria",null,"Rating"]
[]
[null,null,"The quantity of nutrients deposited manure and bedding is:",null,{"$f":"VLOOKUP(D9,'RA Nutrient Monitor code'!C7:D13,2,FALSE)","v":{"$error":"#N/A"}},null," "]
[]
[null,null,"Before a pig phase expected to exceed 2 years in length begins:",null,{"$f":"VLOOKUP(D11,'RA Nutrient Monitor code'!C30:D35,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Soil sampling:",null,{"$f":"VLOOKUP(D13,'RA Nutrient Monitor code'!C15:D18,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Soil sampling:",null,{"$f":"VLOOKUP(D15,'RA Nutrient Monitor code'!C20:D22,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Soil sampling depths and analysis parameters:",null,{"$f":"VLOOKUP(D17,'RA Nutrient Monitor code'!C24:D28,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E19,'RA Nutrient Monitor code'!D39:E42,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E9),VALUE(E13),VALUE(E15),VALUE(E17),VALUE(E11))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]

{"sheet":"RA Nutrient Monitor code","index":20,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Risk Assessment - Nutrient Budgeting and Monitoring"]
[]
[]
[null,"Nutrient Budget and Monitoring","Rating Criteria","Rating"]
[]
[null,"The quantity of nutrients deposited over the paddocks as pig manure is:","estimated within 12 months of the pig phase starting and a sustainable land use rotation of up to 6 years is planned.    ",1]
[null,null,"well understood and supported by a sustainable land use rotation of up to 6 years.    ",1]
[null,null,"estimated within 12 months of a pig phase starting and a sustainable land use rotation of up to 8 years is planned. ",2]
[null,null,"well understood and supported by a sustainable land use rotation of up to 8 years. ",2]
[null,null,"estimated within 2 years of a pig phase starting and a sustainable land use rotation of up to 8 years is planned.    ",3]
[null,null,"not estimated within the first 2 years of the pig phase.",4]
[null,null,"not matched by a land use rotation of up to 8 years in length that will achieve sustainable soil nutrient levels.",4]
[]
[null,"Soil sampling:","occurs before a pig phase expected to exceed 2 years starts; at the end of any 2 year period when pigs are on an area; and at the end of any later 2 year period including a pig phase.",1]
[null,null,"occurs at the end of any 2 year period in which pigs are stocked on an area; and at the end of any subsequent 2 year period that includes a pig phase.",2]
[null,null,"occurs at the end of any 3 year period in which pigs are stocked on an area; and at the end of any subsequent 3 year period that includes a pig phase.   ",3]
[null,null,"does not regularly occur.",4]
[null,null," "]
[null,"Soil sampling:","produces samples that represent the nutrient-rich area of the paddocks (soil sampled between shelter and feeder).",1]
[null,null,"produces samples that are an average of the whole paddock (i.e. soil is collected from all parts of the paddock).",3]
[null,null,"does not regularly occur",4]
[]
[null,"Soil sampling depths and analysis parameters:","match Table 15.1 of the National Guidelines.",1]
[null,null,"meet the requirements of a planning or development consent, approval, permit or licence.",1]
[null,null,"include topsoil pH, EC, ESP, nitrate-N, available P, K; and subsoil EC, ESP and nitrate-N.         ",2]
[null,null,"include topsoil pH, EC, ESP, nitrate-N, available P, K; and subsoil nitrate-N.         ",3]
[null,null,"do not include the usual environmental indicator parameters.",4]
[]
[null,"Before the commencement of a pig phase expected to exceed 24 months in length:","soil testing shows that nutrients levels are below the trigger values suggested in the National Guidelines.",1]
[null,null,"soil testing shows that nutrients levels are similar to those of a background plot.",1]
[null,null,"soil testing shows that nutrients levels are satisfactory according to an independent soil scientist or agronomist.           ",1]
[null,null,"soil testing shows that nutrients levels are satisfactory according to the licensing authority.   ",1]
[null,null,"soil testing is undertaken but the results aren’t used to decide whether the area is suitable for a pig phase.  ",4]
[null,null,"soil testing is not routinely undertaken.",4]
[]
[null,"OVERALL RATING","This will be the highest individual rating selected above  (1-4, with 4 being the highest possible value)."]
[]
[null,null,null,1,"Overall, soil nutrient monitoring minimises the likelihood of risks to the environment."]
[null,null,null,2,"Overall, soil nutrient monitoring limits the likelihood of risks to the environment."]
[null,null,null,3,"Overall, soil nutrient monitoring offers some protection against risks to the environment."]
[null,null,null,4,"Overall, soil nutrient monitoring does not provide much protection against risks to the environment."]

{"sheet":"D&O RA Manure Distribution","index":21,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Design and Operation Risk Assessment\n\nDistribution of Manure Nutrients"]
[]
[null,{"$f":"IF(breeder=\"has a breeder unit\",1,0)","v":0},"This piggery"]
[]
[null,{"$f":"IF(grower=\"has a grower unit\",1,0)","v":0},"This piggery"]
[]
[null,null,"Rating Criteria","Response","Rating","h4"]
[]
[null,null,"In breeder paddocks:",null,{"$f":"VLOOKUP(D9,'RA Manure Distr code'!C7:D34,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF('Piggery Description'!D5=\"weaning.\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF('Piggery Description'!D5=\"breeding.\",1,0)","v":0}]
[null,null,"In grower paddocks:",null,{"$f":"VLOOKUP(D11,'RA Manure Distr code'!C36:D63,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF('Piggery Description'!D5=\"grow-out.\",1,0)","v":0}]
[]
[null,null,"Significant quantities of spent bedding are:"]
[null,{"$f":"IF(D13=\"not generated by the piggery.\",1,0)","v":0},null,null,null," "]
[null,null,"Large amount of spent bedding are:",null,{"$f":"VLOOKUP(D15,'RA Manure Distr code'!C65:D71,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E17,'RA Manure Distr code'!D81:E84,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(IF(B3>0,VALUE(E9),0),IF(B5>0,VALUE(E11),0),IF(B14=0,VALUE(E15),0))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[]
[null,null,null,null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"RA Manure Distr code","index":22,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":true,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["Design and Operation Risk Assessment"]
[]
["Distribution of Manure Nutrients"]
[null,null,null,null,null,null,"has a breeder unit"]
[null,"Distribution of Manure Nutrients","Rating Criteria","Rating",null,null,"doesn't have a breeder unit"]
[null,"In breeder paddocks:","feeding points are moved at least every 3 months to promote nutrient dispersion.",1]
[null,null,"shelters and feeding points are moved at least every 3 months to promote nutrient dispersion.",1,null,null,"has a grower unit"]
[null,null,"shelters are moved at least every 3 months to promote nutrient dispersion.",1,null,null,"doesn't have a grower unit"]
[null,null,"the pig phase is less than 3 months long and feeding points are moved before pigs return.",1]
[null,null,"the pig phase is less than 3 months long and shelters are moved before pigs return.",1]
[null,null,"the pig phase is less than 3 months long and shelters and feeding points are moved before pigs return.",1]
[null,null,"feeding points are moved at least every 6 months to promote nutrient dispersion.",2]
[null,null,"shelters are moved at least every 6 months to promote nutrient dispersion.",2]
[null,null,"shelters and feeding points are moved at least every 6 months to promote nutrient dispersion.",2]
[null,null,"the pig phase is less than 6 months long and feeding points are moved before pigs return.",2]
[null,null,"the pig phase is less than 6 months long and shelters are moved before pigs return.",2]
[null,null,"the pig phase is less than 6 months long and shelters and feeding points are moved before pigs return.",2]
[null,null,"feed is delivered right along the length of the paddock fenceline which is well separated from shelters.",2]
[null,null,"feed is dispersed over a significant area of the paddock that is separated from shelters.",2]
[null,null,"feed is delivered along the length of the paddock fenceline or dispersed over a significant area of the paddock area that is well separated from shelters.",2]
[null,null,"waterers are moved at least every 6 months to promote nutrient dispersion.",3]
[null,null,"wallows are moved at least every 6 months to promote nutrient dispersion.",3]
[null,null,"spray or drip coolers are moved at least every 6 months to promote nutrient dispersion.",3]
[null,null,"waterers and spray / drip coolers are moved at least every 6 months to promote nutrient dispersion.",3]
[null,null,"wallows and spray or drip coolers are moved at least every 6 months to promote nutrient dispersion.",3]
[null,null,"waterers, wallows and spray or drip coolers are moved at least every 6 months to promote nutrient dispersion.",3]
[null,null,"with a pig phase of less than 6 months, waterers are repositioned before pigs return.",3]
[null,null,"with a pig phase of less than 6 months, wallows are repositioned before pigs return.",3]
[null,null,"with a pig phase of less than 6 months, spray coolers are repositioned before pigs return.",3]
[null,null,"with a pig phase of less than 6 months, waterers and wallows are repositioned before pigs return.",3]
[null,null,"with a pig phase of less than 6 months, waterers and spray or drip coolers are repositioned before pigs return.",3]
[null,null,"with a pig phase of less than 6 months, waterers, wallows and spray or drip coolers are repositioned before pigs return.",3]
[null,null,"shelters, feeding points, waterers, wallows and spray or drip coolers are not frequently moved.",4]
[]
[null,"In grower paddocks:","feeding points are moved at least every 6 weeks to promote nutrient dispersion.         ",1]
[null,null,"shelters and feeding points are moved at least every 6 weeks to promote nutrient dispersion.   ",1]
[null,null,"shelters are moved at least every 6 weeks to promote nutrient dispersion.   ",1]
[null,null,"the pig phase is less than 6 weeks long and feeding points are moved before pigs return.         ",1]
[null,null,"the pig phase is less than 6 weeks long and shelters are moved before pigs return.  ",1]
[null,null,"the pig phase is less than 6 weeks long and shelters and feeding points are moved before pigs return.          ",1]
[null,null,"feeding points are moved at least every 6 weeks to promote nutrient dispersion.         ",2]
[null,null,"shelters are moved at least every 3 months to promote nutrient dispersion.   ",2]
[null,null,"shelters and feeding points are moved at least every 3 months to promote nutrient dispersion.   ",2]
[null,null,"the pig phase is less than 3 months long and feeding points are moved before pigs return.         ",2]
[null,null,"the pig phase is less than 3 months long and shelters are moved before pigs return.        ",2]
[null,null,"the pig phase is less than 3 months long and shelters and feeding points are moved before pigs return.   ",2]
[null,null,"feed is delivered right along the length of the paddock fenceline which is well separated from shelters.    ",2]
[null,null,"feed is dispersed over a significant area of the paddock that is separated from shelters.   ",2]
[null,null,"feed is delivered along the length of the paddock fenceline or dispersed over a significant area of the paddock area that is well separated from shelters.             ",2]
[null,null,"waterers are moved at least every 3 months to promote nutrient dispersion.         ",3]
[null,null,"wallows are moved at least every 3 months to promote nutrient dispersion.         ",3]
[null,null,"spray or drip coolers are moved at least every 3 months to promote nutrient dispersion.      ",3]
[null,null,"waterers and spray / drip coolers are moved at least every 3 months to promote nutrient dispersion.",3]
[null,null,"wallows and spray or drip coolers are moved at least every 3 months to promote nutrient dispersion.     ",3]
[null,null,"waterers, wallows and spray or drip coolers are moved at least every 3 months to promote nutrient dispersion.              ",3]
[null,null,"with a pig phase of less than 3 months, waterers are repositioned before pigs return.        ",3]
[null,null,"with a pig phase of less than 3 months, wallows are repositioned before pigs return.   ",3]
[null,null,"with a pig phase of less than 3 months, spray coolers are repositioned before pigs return.     ",3]
[null,null,"with a pig phase of less than 3 months, waterers and wallows are repositioned before pigs return.    ",3]
[null,null,"with a pig phase of less than 3 months, waterers and spray or drip coolers are repositioned before pigs return.       ",3]
[null,null,"with a pig phase of less than 3 months, waterers, wallows and spray or drip coolers are repositioned before pigs return.  ",3]
[null,null,"shelters, feeding points, waterers, wallows and spray or drip coolers are not frequently moved.",4]
[]
[null,"If significant quantities of spent bedding are produced from the shelters, this material is:","taken off-site for reuse with duty of care explained to the recipient.   ",1,"off"]
[null,null,"spread on other parts of the farm that meet the fixed buffer criteria in the National Guidelines.        ",1]
[null,null,"spread on-farm on areas that may not meet the National Guidelines fixed buffers. ",4]
[null,null,"dispersed over parts of the pig paddocks likely to have lower nutrient levels.    ",2]
[null,null,"dispersed over all parts of the pig paddocks.",4]
[null,null,"dispersed on other parts of the farm (not pig paddocks).",4]
[null,null,"dispersed over parts of the farm that don’t meet the fixed buffer criteria in the National Guidelines.  ",4]
[]
[]
[]
[]
[null,"OVERALL RATING","This will be the highest individual rating selected above  (1-4, with 4 being the highest possible value)."]
[]
[]
[null,"Significant quantities of spent bedding:","generated by the piggery."]
[null,null,"not generated by the piggery."]
[null,null," ",1,"Overall, the management of manure nutrient distribution minimises the likelihood of risks to the environment."]
[null,null," ",2,"Overall, the management of manure nutrient distribution limits the likelihood of risks to the environment."]
[null,null," ",3,"Overall, the management of manure nutrient distribution offers some protection against risks to the environment."]
[null,null,null,4,"Overall, the management of manure nutrient distribution does not provide much protection against risks to the environment."]

{"sheet":"D&O RA Nutrient Loss Prevention","index":23,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Design and Operation Risk Assessment\n\nNutrient Loss Prevention"]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"Potential nutrient loss pathways:",null,{"$f":"VLOOKUP(D5,'RA Nutrient Loss Preven code'!C7:D12,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Nutrient export from pig paddocks is:",null,{"$f":"VLOOKUP(D7,'RA Nutrient Loss Preven code'!C14:D23,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Nutrients in runoff or soil eroded from the pig paddocks are:",null,{"$f":"VLOOKUP(D9,'RA Nutrient Loss Preven code'!C23:D26,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"The bases of wallows are:",null,{"$f":"VLOOKUP(D11,'RA Nutrient Loss Preven code'!C28:D31,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E13,'RA Nutrient Loss Preven code'!D35:E38,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E5),VALUE(E7),VALUE(E9),VALUE(E11))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[]
[]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"RA Nutrient Loss Preven code","index":24,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["Design and Operation Risk Assessment"]
[]
["Nutrient Loss Prevention"]
[]
[null,"Rating Criteria","Response","Rating"]
[null,"Potential nutrient loss pathways:","are identified in an NMP which includes an Action Plan for addressing these concerns as appropriate. ",1]
[null,null,"are identified in this EMP which includes an Action Plan for addressing these concerns as appropriate. ",1]
[null,null,"are identified in this EMP and an NMP which includes an Action Plan for addressing these concerns as appropriate.         ",1]
[null,null,"have been identified and there is a written Action Plan for addressing these concerns.               ",2]
[null,null,"have been identified.     ",3]
[null,null,"have not been identified. ",4]
[]
[null,"Nutrient export from pig paddocks is:","minimised by selecting sites with a gentle slope and continually maintaining good levels of groundcover over the paddocks.",1]
[null,null,"minimised by selecting sites with a gentle slope, maintaining groundcover for most of the year and using runoff and erosion limiting structures.",2]
[null,null,"minimised by selecting sites with a gentle to moderate slope and maintaining sufficient groundcover over the paddocks most of the year.",3]
[null,null,"minimised by selecting sites with a gentle to moderate slope and installing runoff and erosion limiting structures.",3]
[null,null,"minimised by selecting sites with a gentle to moderate slope, maintaining groundcover for most of the year and using runoff and erosion limiting structures.",3]
[null,null,"a concern because the land has excess slope.",4]
[null,null,"a concern because of the slope of the land and lack of groundcover.",4]
[null,null,"a concern because of the slope of the land and the absence of effective structures to limit erosion and runoff.",4]
[]
[null,"Nutrients in runoff or soil eroded from the pig paddocks are:","controlled by providing the buffers specified in the National Guidelines; and appropriately designed VFS at least 10 m wide.",1]
[null,null,"controlled by providing the buffers specified in the National Guidelines; and terminal ponds that catch the first 12 mm of runoff.",1]
[null,null,"controlled by providing the buffers specified in the National Guidelines",2]
[null,null,"not specifically prevented.",4]
[]
[null,"The bases of wallows are:","clay-loam to clay soils   ",1]
[null,null,"lined with impermeable material           ",1]
[null,null,"loam soils          ",2]
[null,null,"permeable        ",4]
[]
[null,"OVERALL RATING"]
[]
[null,null,null,1,"Overall, nutrient loss prevention measures minimise the likelihood of risks to the environment."]
[null,null," ",2,"Overall, nutrient loss prevention measures limit the likelihood of risks to the environment."]
[null,null," ",3,"Overall, nutrient loss prevention measures offer some protection against risks to the environment."]
[null,null," ",4,"Overall, nutrient loss prevention measures does not provide much protection against risks to the environment."]

{"sheet":"D&O RA Paddock Rehab","index":25,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Design and Operation Risk Assessment\n\nPaddock Rehabilitation"]
[]
[null,{"$f":"IF(erosion=\"not generally an issue.\",0,1)","v":1},"Soil erosion from the pig paddocks is"]
[]
[null,{"$f":"IF(compaction=\"not generally an issue.\",0,1)","v":1},"Soil compaction in the pig paddocks is "]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"Inspection of each block of paddocks to identify soil erosion or structural issues:",null,{"$f":"VLOOKUP(D9,'RA Paddock Rehab code'!C8:D18,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Where significant soil erosion has resulted from the pig phase, the site would be remediated by",null,{"$f":"VLOOKUP(D11,'RA Paddock Rehab code'!C24:D26,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Where significant soil compaction has resulted from the pig phase, the site is remediated by",null,{"$f":"VLOOKUP(D13,'RA Paddock Rehab code'!C31:D37,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Wallows are:",null,{"$f":"VLOOKUP(D15,'RA Paddock Rehab code'!C40:D47,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null," "]
[null,null,"Before a new pig phase commences:",null,{"$f":"VLOOKUP(D17,'RA Paddock Rehab code'!C49:D50,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E19,'RA Paddock Rehab code'!D54:E57,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(IF(B3+B5>0,VALUE(E9),0),IF(B3>0,VALUE(E11),0),IF(B5>0,VALUE(E13),0),VALUE(E15),VALUE(E17))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[]
[]
[]
[]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"RA Paddock Rehab code","index":26,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":true,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["Design and Operation Risk Assessment"]
[]
["Paddock Rehabilitation"]
[]
[null,"Rating Criteria","Response","Rating"]
[]
[null,"Inspection of each block of paddocks to identify soil erosion or structural issues:","occurs continually          ",1]
[null,null,"occurs at least monthly ",1]
[null,null,"occurs at least quarterly              ",1]
[null,null,"occurs at least every six months              ",1]
[null,null,"occurs at least annually               ",1]
[null,null,"occurs at least every 2 years.  Issues are identified and an action plan developed and implemented within one month.",1]
[null,null,"occurs at the end of each pig phase of 2 years or less.  Issues are identified and an action plan developed and implemented within three months.",2]
[null,null,"occurs at least every 2 years.  Issues are identified and an action plan developed and implemented within three months.",2]
[null,null,"does not occur at the end of each pig phase (where a pig phase last for 2 years or less).",4]
[null,null,"occurs less than once every two years.",4]
[null,null,"does not result in the identification and correction of concerns within an acceptable time frame.",4]
[]
[null,"Soil erosion from the pig paddocks is","often an issue."]
[null,null,"sometimes an issue."]
[null,null,"not generally an issue."]
[]
[null,"Where significant soil erosion has resulted from the pig phase, the site would be remediated by","back-filling the eroded area with soil and growing a pasture ley crop in the first year after the pig phase",1]
[null,null,"back-filling the eroded area with soil before growing a crop in the first year after the pig phase",2]
[null,null,"back-filling the eroded area with soil ",2,null,null," ",null," "]
[]
[null,"Soil compaction in the pig paddocks is ","often an issue."]
[null,null,"sometimes an issue."]
[null,null,"not generally an issue."]
[]
[null,"Where significant soil compaction has resulted from the pig phase, the site is remediated by"]
[null,null,"only cultivating soil when its moisture content is suitable, applying gypsum and growing a pasture ley crop",1]
[null,null,"only cultivating soil when its moisture content is suitable, deep ripping and growing a pasture ley crop",1]
[null,null,"only cultivating soil when its moisture content is suitable, deep ripping, applying gypsum and growing a pasture ley crop",1]
[null,null,"deep ripping; Cultivation occurs only when the moisture content is suitable",2]
[null,null,"applying gypsum;  Cultivated occurs only when the moisture content is suitable",2]
[]
[]
[null,"Wallows are:","remediated when replaced and (if needed) within 3 months of the end of the pig phase by deep ripping or excavating, applying gypsum, backfilling and levelling",1]
[null,null,"remediated when replaced and (if needed) within 3 months of the end of the pig phase by deep ripping or excavating, backfilling and levelling",1]
[null,null,"remediated when replaced and (if needed) within 3 months of the end of the pig phase by applying gypsum, backfilling and levelling",1]
[null,null,"remediated when replaced and (if needed) within 3 months of the end of the pig phase by deep ripping or excavating, backfilling and levelling",2]
[null,null,"remediated when replaced and (if needed) within 3 months of the end of the pig phase by applying gypsum, backfilling and levelling",2]
[null,null,"not remediated at the end of the pig phase as this is not necessary given the intended future land use",2]
[null,null,"remediated when they are replaced and (if needed) within 3 months of completion of the pig phase by filling with soil",3]
[null,null,"not remediated although this would be desirable.",4]
[]
[null,"Before a new pig phase commences:","pasture or a forage crop is well established over the whole paddock area.",1]
[null,null,"pasture or a forage crop is not well established over the whole paddock area.",4]
[]
[null,"OVERALL RATING"]
[]
[null,null,null,1,"Overall, paddock rehabilitation minimises the likelihood of risks to the environment."]
[null,null," ",2,"Overall, paddock rehabilitation limits the likelihood of risks to the environment."]
[null,null," ",3,"Overall, paddock rehabilitation offers some protection against risks to the environment."]
[null,null," ",4,"Overall, paddock rehabilitation does not provide much protection against risks to the environment."]

{"sheet":"D&O RA Mortalities Management","index":27,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Design and Operation Risk Assessment\n\nMortalities Management\n\n"]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"Dead pigs are:",null,{"$f":"VLOOKUP(D5,'RA Mortalities Mgt code'!C7:D10,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Mortalities management ",null,{"$f":"VLOOKUP(D7,'RA Mortalities Mgt code'!C12:D15,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Mortalities management is by:",null,{"$f":"VLOOKUP(D9,'RA Mortalities Mgt code'!C17:D22,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Mortalities management areas:",null,{"$f":"VLOOKUP(D11,'RA Mortalities Mgt code'!C24:D28,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Carcasses are:",null,{"$f":"VLOOKUP(D13,'RA Mortalities Mgt code'!C30:D36,2,FALSE)","v":{"$error":"#N/A"}}," "]
[]
[null,null,"Mortalities management:",null,{"$f":"VLOOKUP(D15,'RA Mortalities Mgt code'!C38:D39,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"In the event of mass mortalities, there is:",null,{"$f":"VLOOKUP(D17,'RA Mortalities Mgt code'!C41:D45,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E19,'RA Mortalities Mgt code'!D49:E52,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E5),VALUE(E7),VALUE(E9),VALUE(E11),VALUE(E13),VALUE(E15),VALUE(E17))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[]
[]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"RA Mortalities Mgt code","index":28,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["Design and Operation Risk Assessment"]
[]
["Mortalities Management"]
[]
[null,"Rating Criteria","Response","Rating"]
[null,"Dead pigs are:","always removed from the paddocks daily.",1]
[null,null,"always left in the paddocks for more than 24 hours.",4]
[null,null,"sometimes left in the paddocks for more than 24 hours.",4]
[null,null,"ocasionally left in the paddocks for more than 24 hours.",4]
[]
[null,"Mortalities management ","always occurs within 24 hours of death.",1]
[null,null,"always occurs within 36 hours of death.",2]
[null,null,"always occurs within 48 hours of death.",3]
[null,null,"does not always occur within 48 hours of death.",4]
[]
[null,"Mortalities management is by:","composting.",1]
[null,null,"rendering.",1]
[null,null,"burial.",3]
[null,null,"proper incineration.",3]
[null,null,"burning.",4]
[null,null,"dumping.",4]
[]
[null,"Mortalities management areas:","always provide at least 2 m depth to groundwater; and are concreted or compacted to a design permeability of 1 X 10-9 for 300 mm depth.         ",1]
[null,null,"always provide at least 2 m depth to groundwater; and are lined with compacted clay or gravel.           ",2]
[null,null,"always provide at least 2 m depth to groundwater",3]
[null,null,"are not on a well-sealed site",4]
[null,null,"sometimes provide less than 2 m depth to groundwater",4]
[]
[null,"Carcasses are:","always promptly covered with at least 300 mm of high carbon material and continuously kept covered.",1]
[null,null,"always promptly covered with at least 300 mm of soil and continuously kept covered.",1]
[null,null,"generally promptly covered with at least 300 mm of high carbon material and continuously kept covered.",2]
[null,null,"generally promptly covered with at least 300 mm of soil and continuously kept covered.",2]
[null,null,"not always promptly covered",4]
[null,null,"not always continuously kept covered",4]
[null,null,"not always promptly covered or continuously kept covered",4]
[]
[null,"Where mortalities management is by composting, burial or burning this:","occurs within a controlled drainage area with stormwater diverted away from the area.",1]
[null,null,"does not occur within a controlled drainage area.",4]
[]
[null,"In the event of mass mortalities, there is:","a suitable site selected and a detailed plan for managing mass mortalities.",1]
[null,null,"a suitable site selected and a plan for managing mass mortalities.",2]
[null,null,"a suitable site selected but no real plan for managing mass mortalities.",3]
[null,null,"plan for managing mass mortalities but no site has been selected.",3]
[null,null,"no site selected or plan for managing mass mortalities.",4]
[]
[null,"OVERALL RATING"]
[]
[null,null,null,1,"Overall, mortalities management practices minimise the likelihood of risks to the environment."]
[null,null," ",2,"Overall, mortalities management practices limit the likelihood of risks to the environment."]
[null,null," ",3,"Overall, mortalities management practices offer some protection against risks to the environment."]
[null,null," ",4,"Overall, mortalities management practices does not provide much protection against risks to the environment."]

{"sheet":"D&O RA Odour, Dust, Noise","index":29,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Design and Operation Risk Assessment\n\nOdour, Dust and Noise"]
[]
[]
[null,null,"Rating Criteria","Response","Rating"]
[]
[null,null,"Odour, dust and noise are:",null,{"$f":"VLOOKUP(D6,'RA Odour, Dust, Noise code'!C7:D9,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"A complaints management procedure",null,{"$f":"VLOOKUP(D8,'RA Odour, Dust, Noise code'!C11:D12,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"The complaints management procedure includes",null,{"$f":"VLOOKUP(D10,'RA Odour, Dust, Noise code'!C14:D20,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"Mediation is:",null,{"$f":"VLOOKUP(D13,'RA Odour, Dust, Noise code'!C24:D26,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"OVERALL RATING",{"$f":"VLOOKUP(E15,'RA Odour, Dust, Noise code'!D30:E33,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MAX(VALUE(E6),VALUE(E10),VALUE(E13))","v":{"$error":"#N/A"}}]
[]
[null,null,"Comments:","please leave your comments here, if any"]
[]
[]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]

{"sheet":"RA Odour, Dust, Noise code","index":30,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["Design and Operation Risk Assessment"]
[]
["Odour, Dust and Noise"]
[]
[null,"Rating Criteria","Response","Rating"]
[null,"Odour, dust and noise are:","minimised by maintaining dry bedding; promptly addressing odorous wallows; ensuring noisy activities only occur during the day; and ensuring dust does not create nuisance off-farm.              ",1]
[null,null,"managed by maintaining dry bedding; addressing odorous wallows; and scheduling noisy activities to occur during the day.          ",2]
[null,null,"not actively managed.",4]
[]
[null,"A complaints management procedure","exists at this piggery.",1]
[" ",null,"doesn't exist at this piggery.",4]
[null," "]
[null,"The complaints management procedure includes","complaints recording, investigation, corrective action as needed, and appropriate consultation.",1]
[null,null,"complaints recording, investigation and corrective action as needed. ",2]
[null,null,"complaints recording and investigation.",4]
[null,null,"taking corrective action as needed.  ",4]
[null,null,"investigation of potential sources of complaints.   ",4]
[null,null,"recording details.   ",4]
[null," ","no recording, investigation, corrective action, or consultation, but other approaches.",4]
[]
[null,null," "]
[]
[null,"Mediation is:","used to try to settle disputes with neighbours (or would be if there were issues).",1]
[null,null,"generally used to try to settle disputes with neighbours (or would be if there were issues).",2]
[null,null,"not generally used to try to settle disputes with neighbours.",4]
[]
[null,"OVERALL RATING"]
[]
[null,null,null,1,"Overall,odour dust and noise management minimises the likelihood of risks to the environment."]
[null,null," ",2,"Overall, odour dust and noise management limits the likelihood of risks to the environment."]
[null,null," ",3,"Overall, odour dust and noise management offers some protection against risks to the environment."]
[null,null," ",4,"Overall, odour dust and noise management does not provide much protection against risks to the environment."]

{"sheet":"Overall RA","index":31,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,8],[3,4,3,7],[7,2,7,3]]}
[null,"Overall  Risk Assessment"]
[]
[null,null," "]
[null,null,null,null,"Natural Resource Vulnerability Ratings (1-4)"]
[null,null,null,null,"Soils","Groundwater","Surface","Community"]
[null,null,null,null,null,"Quality &","Quality &","Amenity"]
[null,null,null,null,null,"Availability","Availability"]
[null,null,"Design and Operation Risk Ratings (1-4)",null,{"$f":"'ERA Vulnerability of Soils'!E19","v":{"$error":"#N/A"}},{"$f":"'ERA Vulnerability Groundwater'!E11","v":{"$error":"#N/A"}},{"$f":"'ERA Vulnerability Surface Water'!E19","v":{"$error":"#N/A"}},{"$f":"'ERA Vulnerability Community'!E11","v":{"$error":"#N/A"}}]
[null,null,"Nutrient monitoring",{"$f":"'D&O RA Nutrient Monitoring'!E19","v":{"$error":"#N/A"}},{"$f":"D9*E8","v":{"$error":"#N/A"}},{"$f":"+F8*D9","v":{"$error":"#N/A"}},{"$f":"+$G$8*D9","v":{"$error":"#N/A"}},"-"]
[null,null,"Distribution of manure nutrients",{"$f":"'D&O RA Manure Distribution'!E17","v":{"$error":"#N/A"}},{"$f":"+E8*D10","v":{"$error":"#N/A"}},{"$f":"+$F$8*D10","v":{"$error":"#N/A"}},{"$f":"+$G$8*D10","v":{"$error":"#N/A"}},"-"]
[null,null,"Nutrient loss prevention",{"$f":"'D&O RA Nutrient Loss Prevention'!E13","v":{"$error":"#N/A"}},{"$f":"D11*E8","v":{"$error":"#N/A"}},"-",{"$f":"+$G$8*D11","v":{"$error":"#N/A"}},{"$f":"H8*D11","v":{"$error":"#N/A"}}]
[null,null,"Paddock rehabilitation",{"$f":"'D&O RA Paddock Rehab'!E19","v":{"$error":"#N/A"}},{"$f":"D12*E8","v":{"$error":"#N/A"}},{"$f":"D12*F8","v":{"$error":"#N/A"}},{"$f":"D12*G8","v":{"$error":"#N/A"}},{"$f":"H8*D12","v":{"$error":"#N/A"}}]
[null,null,"Mortalities management",{"$f":"'D&O RA Mortalities Management'!E19","v":{"$error":"#N/A"}},{"$f":"D13*E8","v":{"$error":"#N/A"}},"-","-","-"]
[null,null,"Odour, dust and noise",{"$f":"'D&O RA Odour, Dust, Noise'!E15","v":{"$error":"#N/A"}},"-","-","-",{"$f":"H8*D14","v":{"$error":"#N/A"}}]
[]
[null,null," "]
[null,null,"Ratings within the grid are the combined ratings"]
[null,null,"A combined rating of 1-4 means a low risk and would not trigger any action."]
[null,null,"A combined rating of 5-11 means a medium risk and may trigger explanation or action."]
[null,null,"A combined rating of 12-16 means a low risk and would trigger explanation or action."]
[null,null,"Improving environmental performance might involve changes to design or management or further monitoring."]

{"sheet":"Environmental Monitoring","index":32,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,2,8,3],[23,2,24,2],[28,2,28,3],[31,2,31,3],[0,1,0,4],[3,2,3,3],[11,2,12,2],[13,2,14,2],[15,2,16,2],[17,2,18,2],[20,2,21,2]]}
[null,"Environmental Monitoring and Assessment of Sustainability"]
[]
[null,null,"Community Amenity"]
[null,null,"Management aims for the piggery to operate in harmony with the nearby community."]
[null,null,"One measure of the impact of the piggery on nearby residents is the number of complaints received."]
[null,null,"Details of complaints management are documented in the \"Complaints Register\""]
[]
[null,null,"Soils"]
[null,null,"Most rotational outdoor piggeries are net accumulators of nutrients since nutrients imported as pigs, feed and bedding during the pig phase are not matched by removals through pig grazing and gaseous losses.  Surplus nutrients can be removed by growing and harvesting crops, forage or pastures after the pig phase.  For most rotational outdoor piggeries, it is useful to sample and analyse the soil of paddocks before the pigs move onto an area; and also when the pigs leave an area as this helps in managing the crop / forage / pasture phase.  For systems with a pig phase that exceeds two years in length, soil monitoring should usually be undertaken at least every two years, although this depends on the risk.  Where a risk assessment shows high risk, annual monitoring is warranted.  If ongoing monitoring shows that the risk is low, monitoring at three yearly intervals may be justified.  Samples should be collected from random locations in the areas between the shelters and the feeding, watering and wallowing facilities as these areas are likely to have the highest soil nutrient levels and pose the greatest risk to the environment.  One composite (bulked) sample per block of paddocks is generally sufficient.  If spent bedding is applied to separate reuse areas soil monitoring of these areas may also be warranted.  The recommended soil monitoring parameters are given below."]
[null,null,null,null,null,null," "]
[null,null,"Soil test parameter","Depth (down profile)"]
[null,null,"pH","0-0.1 m"]
[null,null,null,"0.3-0.6 m OR bottom 0.3 m of soil profile or base of root zone"]
[null,null,"ECse (Can measure EC1:5 and convert to ECse)+","0-0.1 m"]
[null,null,null,"0.3-0.6 m OR bottom 0.3 m of soil profile or base of root zone"]
[null,null,"Nitrate-nitrogen","0-0.1 m"]
[null,null,null,"0.3-0.6 m OR bottom 0.3 m of soil profile or base of root zone"]
[null,null,"Available phosphorus  (Colwell or Olsen or Bray or BSES) or lactate or calcium chloride or other","0-0.1 m"]
[null,null,null,"0.3-0.6 m OR bottom 0.3 m of soil profile or base of root zone b"]
[null,null,"Phosphorus sorption capacity or phosphorus sorption index","0 –0.6 m OR bottom 0.3 m of soil profile or base of root zone c"]
[null,null,"Potassium","0-0.1 m"]
[null,null,null,"0.3-0.6 m OR bottom 0.3 m of soil profile or base of root zone"]
[null,null,"Organic carbon","0-0.1 m"]
[null,null,"Exchangeable cations and CEC (Calcium, sodium, potassium, magnesium).","0-0.1 m"]
[null,null,null,"0.3-0.6 m OR bottom 0.3 m of soil profile or base of root zone"]
[]
[]
[null,null,"Surface Water"]
[null,null,"Surface water monitoring is not warranted because there is no direct discharge to waterways and because secondary protection measures are in place."]
[]
[null,null,"Spent Bedding"]
[null,null,"Before reuse, manure products are tested at least annually for the following parameters before the main reuse period."]
[]
[null,null,"Manure"]
[]
[null,null,"Dry matter"]
[null,null,"Total nitrogen or TKN"]
[null,null,"Ammonium-nitrogen"]
[null,null,"Nitrage-nitrogen"]
[null,null,"Total phosphorus"]
[null,null,"Ortho-phosphorus"]
[null,null,"Potassium"]
[null,null,"EC"]
[null,null,"Chloride"]
[null,null,"Organic carbon"]

{"sheet":"Contingency Plans","index":33,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3],[0,1,0,5]]}
[null,"Contingency Plans"]
[]
[null,null,"Contingency plans are needed to address potential emergency situations that pose a risk to the environment."]
[null,null,"It is not possible to identify all possible emergency situations and further situations may be identified in the future."]
[]
[null,null,"In the event of an emergency situation, the 24 hour contact phone number is: ","Enter phone number"]
[]
[null,null,"Loss of Water Supply"]
[null,null,"A constant water supply is integral to the operation of the piggery.  "]
[]
[null,null,"To ensure a constant water supply, the piggery has"]
[]
[null,null,"The water storage can provide"]
[]
[null,{"$f":"INT(#REF!)","v":{"$error":"#REF!"}},"The piggery has"]
[null,1]
[null,1,"Loss of Power"]
[null,1,"Power: "]
[null,1]
[null,1,"Interruption to Feed Supply"]
[null,{"$f":"INT(#REF!)","v":{"$error":"#REF!"}},"To ensure a constant supply of feed:"]
[]
[null,{"$f":"INT(#REF!)","v":{"$error":"#REF!"}},"Commonly needed spare parts and tools for basic repairs are kept on-site for "]
[null,1]
[null,{"$f":"INT(#REF!)","v":{"$error":"#REF!"}},"If feed supply system is broken down"]
[null,1]
[null,1,"Flooding"]
[null,1,"Flooding:"]
[null,1]
[null,1,"Fire"]
[null,1,"In the event of a fire in, or near the piggery, staff safety is the highest priority."]
[null,1,"The local rural fire bridgade will be called on:","Enter phone number"]
[null,1]
[null,{"$f":"INT(#REF!)","v":{"$error":"#REF!"}},"If it considered safe enough, piggery staff will"]
[]
[null,null,"Disease Outbreak"]
[null,null,"In the event of a disease outbreak, piggery management will contact:"]
[]
[null,null,"by telephoning:","Enter phone numbers"]
[null,null,null," "]
[null,null,"Mass Mortalities"," "]
[null,null,"In the event of mass mortalities, piggery management will contact: "]
[]
[null,null,"by telephoning:","Enter phone numbers"]
[null,null,null," "]
[null,null,"Chemical Spill"]
[null,null,"Chemical spills are"]
[]
[null,null,"Manure"]
[null,null,"In the event of a breakdown in contractual arrangements with an offsite reuser, manure is:"]
[]
[null,null,"Comments:","please leave your comments here, if any"]

{"sheet":"Contingency Plans code","index":34,"n_rows":87,"n_cols":5,"rows_kept":87,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["Contingency Plans"]
[]
[null,"Contingency plans are needed to address potential emergency situations that pose a risk to the environment."]
[null,"It is not possible to identify all possible emergency situations and further situations may be identified in the future."]
[]
[null,"In the event of an emergency situation, the 24 hour contact phone number is: ","Enter phone number"]
[]
[null,"Loss of Water Supply"]
[null,"A constant water supply is integral to the operation of the piggery.  "]
[null,"To ensure a constant supply, the piggery has:","a reliable primary source of water."]
[null,null,"a reliable alternative source of water."]
[null,null,"arrangements in place to obtain water from an alternative source."]
[]
[]
[null,null,"at least a full days’ water supply for all requirements always stored"]
[null,null,"at least 2 days water supply for all requirements always stored."]
[null,null,"at least 3 days water supply for all requirements always stored."]
[null,null,"at least 4 days water supply for all requirements always stored."]
[null,null,"at least a week water supply for all requirements always stored."]
[null,null,"at least 32 days water supply for all requirements always stored"]
[]
[null,null,"gravity feed from storage.",null,"milling equipment"]
[null,null,"basic repair parts and tools kept on-site.",null,"feed distribution equipment"]
[null,null,"basic repair parts, tools and pumps available.",null,"an arrangement is in place with a contractor for emergency repairs to equipment"]
[null,null,"spare pump kept on-site.",null,"an arrangement is in place with an off-site feedmill for emergency delivery of feed"]
[null,null,"spare pump readily available."]
[null,null,"generator kept on-site."]
[null,null,"generator reliably available if needed."]
[]
[null,"Loss of Power"]
[null,"Power: ","is not needed to operate the piggery."]
[null,null,"is needed but short outages are not a concern.  A generator is used for longer outages."]
[null,null,"is needed and a back-up generator can be accessed."]
[null,null,"is needed and a back-up generator is kept on-site."]
[]
[null,"Interruption to Feed Supply"]
[null,"To ensure a constant supply of feed:","at least two days feed commodities are kept on-site.  "]
[null,null,"at least two days prepared feed is kept on-site."]
[null,null,"commonly needed spare parts and tools for basic repairs to milling equipment are kept on-site. "]
[null,null,"commonly needed spare parts and equipment for repairing feed distribution equipment are kept on-site."]
[null,null,"an arrangement is in place with a contractor for emergency repairs to equipment."]
[null,null,"an arrangement is in place with an off-site feedmill for emergency delivery of feed."]
[]
[null,"Flooding"]
[null,"Flooding:","is not a concern due to the location of the piggery."]
[null,null,"can make the piggery inaccessible.  Generous feed and water storage is in place to cover the risk."]
[null,null,"could enter the piggery in an extreme event.  Pigs would be moved to higher ground"]
[]
[]
[]
[null,"Fire"]
[null,"In the event of a fire in, or near the piggery, staff safety is the highest priority."]
[null,"The local rural fire bridgade will be called on:","enter phone number"]
[null,"If it is safe, piggery staff will:","fight the fire."]
[null,null,"move pigs to a safer area (if possible)."]
[null,null,"take action to prevent the spread of the fire to buildings."]
[]
[null,"Disease Outbreak"]
[null,"In the event of a disease outbreak, piggery management will contact:","a pig specialist veterinarian."]
[null,null,"a pig specialist veterinarian who would contact the Chief Veterinary Officer."]
[]
[]
[null,"by telephoning:","Enter phone numbers"]
[null,null," "]
[null,"Mass Mortalities"," "]
[null,"In the event of mass mortalities, piggery management will contact: ","a local veterinarian","a pig specialist veterinarian."]
[null,null,"a local veterinarian who is authorised to the Chief Veterinary Officer","a pig specialist veterinarian who would contact the Chief Veterinary Officer."]
[null,null,"a local veterinarian, the Chief Veterinary Officer and state agriculture department","the Chief Veterinary Officer "]
[null,null,"a local veterinarian, the Chief Veterinary Officer, state agriculture department and Council","state agriculture department"]
[null," ","a local veterinarian, the Chief Veterinary Officer and EPA","the Council"]
[null,null,"a local veterinarian, the Chief Veterinary Officer, EPA and Council.","EPA"]
[]
[null,null,"Enter phone numbers"]
[null,null," "]
[null,"Chemical Spill"]
[null,"Chemical spills are","not an issue as no chemicals are used at the site."]
[null,null,"not a concern as very few chemicals are used at the site."]
[null,null,"cleaned up using a spill kit."]
[null,null,"managed by following the emergency response plan."]
[null,null,"managed by following the emergency plan and using the spill kit."]
[null,null,"handled by taking appropriate clean up action."]
[null," "]
[null,"Manure"]
[null,"In the event of a breakdown in contractual arrangements with an offsite reuser, manure is:","temporarily stored on-site."]
[null,null,"provided to other interested parties."]
[null,null,"temporarily stored on-site and provided to other interested parties."]
[null,null,"reused on-farm."]

{"sheet":"Records to be Kept","index":35,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,2,14,3],[0,1,0,5],[3,3,3,4],[9,2,9,4],[10,2,10,4],[12,2,12,4]]}
[null,"Records to be Kept"]
[]
[]
[null,null,null,"Please select the records that you already keep or intend to keep/develop"]
[null,null,null,"Records","Note"]
[null,null,null,null,"Environmental Management Plan (EMP) Review: all EMPs should include this record. \nAction Plans: plans to improve design or management to reduce risk. \nEnvironmental Training Record: all EMPs should include this record. \nComplaints Record: all EMPs should include this record. \nEnvironmental Monitoring Record: if enviromental monitoring is undertaken then this record should be kept. \nManure Reuse Record: uou should keep this record if you spread spent bedding on reuse areas that are separate from the pig paddocks. \nManure Export Record: you should keep this record if you are exporting any spent bedding for reuse. \nDuty of Care for Off-site users: you should keep this record if you are exporting any manure for reuse. \nPesticide Use Record: this applies if you use herbicides, insecticides or baits. \nEnvironmental Incident Record: all EMPs should include this record. \nPollution Monitoring Data Report: applicable for licenced NSW operations. \nNGERS on-line reporting: refer below"]
[]
[null,null,"NGERS Reporting"]
[]
[null,null,"NGERS reporting is triggered by facilities that produce 25 kt of C02-e/yr of Scope 1 or 2 emissions or which use or produce over 100 TJ/yr of energy."]
[null,null,"Further information is provided in Chapter 20 of the National Environmental Guidelines for Piggeries and at www.cleanenergyregulator.gov.au."]
[]
[null,null,"All reporting under the National Greenhouse and Energy Reporting Act 2007 is done through the Emissions and Energy Reporting System (EERS)."]
[null,null,"For more information, and to report, go to "]
[null,null,"www.cleanenergyregulator.gov.au"]

{"sheet":"Records to be Kept code","index":36,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,5],[3,6,14,6]]}
["Records to be Kept"]
[null,null," "," "]
[null,null," "," "]
[null,"EMP Review","All EMPs should include this record.",null,"EMP Review All EMPs should include this record.",null,"EMP Review: all EMPs should include this record. \nAction Plans: plans to improve design or management to reduce risk. \nEnvironmental Training Record: all EMPs should include this record. \nComplaints Record: all EMPs should include this record. \nEnvironmental Monitoring Record: if enviromental monitoring is undertaken then this record should be kept. \nManure Reuse Record: uou should keep this record if you spread spent bedding on reuse areas that are separate from the pig paddocks. \nManure Export Record: you should keep this record if you are exporting any spent bedding for reuse. \nDuty of Care for Off-site users: you should keep this record if you are exporting any manure for reuse. \nPesticide Use Record: this applies if you use herbicides, insecticides or baits. \nEnvironmental Incident Record: all EMPs should include this record. \nPollution Monitoring Data Report: applicable for licenced NSW operations. \nNGERS on-line reporting: refer below"]
[null,"Action Plans","Plans to improve design or management to reduce risk",null,"Action Plans Plans to improve design or management to reduce risk"]
[null,"Environmental Training Record","All EMPs should include this record.",null,"Environmental Training Record All EMPs should include this record."]
[null,"Complaints Record","All EMPs should include this record.",null,"Complaints Record All EMPs should include this record."]
[null,"Environmental Monitoring Record","If enviromental monitoring is undertaken then this record should be kept.",null,"Environmental Monitoring Record If enviromental monitoring is undertaken then this record should be kept."]
[null,"Manure Reuse Record","You should keep this record if you spread spent bedding on reuse areas that are separate from the pig paddocks.",null,"Manure Reuse Record You should keep this record if you spread spent bedding on reuse areas that are separate from the pig paddocks."]
[null,"Manure Export Record","You should keep this record if you are exporting any spent bedding for reuse.",null,"Manure Export Record You should keep this record if you are exporting any spent bedding for reuse."]
[null,"Duty of Care for Off-site users","You should keep this record if you are exporting any manure for reuse.",null,"Duty of Care for Off-site users You should keep this record if you are exporting any manure for reuse."]
[null,"Pesticide Use Record","Applies if you use herbicides, insecticides or baits.",null,"Pesticide Use Record Applies if you use herbicides, insecticides or baits."]
[null,"Environmental Incident Record","All EMPs should include this record.",null,"Environmental Incident Record All EMPs should include this record."]
[null,"Pollution Monitoring Data Report","Applicable for licenced NSW operations.",null,"Pollution Monitoring Data Report Applicable for licenced NSW operations."]
[null,"NGERS on-line reporting","Refer below",null,"NGERS on-line reporting Refer below"]
[null,null,null,null," "]
[null," "," "]
[]
[]
[null,"NGERS Reporting"]
[]
[null,"NGERS reporting is triggered by facilities that produce 25 kt of C02-e/yr of Scope 1 or 2 emissions or which use or produce over 100 TJ/yr of energy."]
[null,"Further information is provided in Chapter 20 of the National Environmental Guidelines for Piggeries and at www.cleanenergyregulator.gov.au."]
[]
[null,"All reporting under the National Greenhouse and Energy Reporting Act 2007 is done through the Emissions and Energy Reporting System (EERS)."]
[null,"For more information, and to report, go to www.cleanenergyregulator.gov.au."]

{"sheet":"EMP Review","index":37,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"EMP Review"]
[]
[null,null,"This EMP will be reviewed annually and also whenever significant changes in piggery design or management occur."]
[null,null," "]
[null,null,"Records will be updated as needed."]
[]
[null,null,"EMP Review Record"]
[]
[null,null,"Review Date:","Reviewer Name:","Findings:","Changes Made (section of EMP, details of change)","Reviewer Signature:"]
[null,null,null,null,null,null," "]

{"sheet":"Action Plans","index":38,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Action Plans"]
[]
[null,null,"Date","Contact name","Need identified","Proposed actions (including dates)","Actions taken (including dates)","Signature"]

{"sheet":"Environ Training Record","index":39,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,10]]}
[null,"Environmental Training Record"]
[]
[]
[null,null,"Date of Training","Trainee Name","Training Type","Training Provider","Training Hours","Training Outcomes","Supervisor Signature (Signature & Date)","Trainee (Signature & Date)"]
[null,null,null," ",null," "," ","e.g. approval to use chemicals"]

{"sheet":"Complaints Record","index":40,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[36,3,36,4],[0,1,0,5],[3,3,3,4],[5,3,5,4],[7,3,7,4],[9,3,9,4],[11,3,11,4],[17,3,19,4],[28,3,28,4],[30,3,30,4],[32,3,32,4],[34,3,34,4],[56,3,56,4],[58,3,58,4],[38,3,38,4],[41,3,41,4],[43,3,43,4],[48,3,48,4],[50,3,50,4],[54,3,54,4]]}
[null,"Complaints Record"]
[]
[null,null,"Complaint Details"]
[null,null,"Date of complaint:","insert details"]
[]
[null,null,"Time of complaint:","insert details"]
[]
[null,null,"Name of person advising of complaint:","insert details"]
[]
[null,null,"Complainant name (if known):","insert details"]
[]
[null,null,"Complainant phone number (if known):","insert details"]
[]
[null,null,"Method of complaint:"]
[]
[null,null,"Nature of complaint:",null,null,null,null,null," "]
[]
[null,null,"Details: ","insert details"]
[]
[]
[]
[null,null,"Investigation Details"]
[null,null,"Temperature at time of alleged nuisance:"]
[]
[null,null,"Wind strength at time of alleged nuisance:"]
[]
[null,null,"Wind direction at time of alleged nuisance:"]
[]
[null,null,"Direction from piggery (or reuse area) to complainant (if known): ","insert details"]
[]
[null,null,"Approximate distance from piggery to complainant (if known):","insert details"]
[]
[null,null,"Person responsible for investigating complaint: ","insert details"]
[]
[null,null,"Investigating method (description, date): ","insert details"]
[]
[null,null,"Signficant activities at time of alleged nuisance: ","insert details"]
[]
[null,null,"Findings of investigation: ","insert details"]
[]
[null,null,"Action Taken"]
[null,null,"Corrective / preventative actions and date actions taken:","insert details"]
[]
[null,null,"Communications with person advising of complaint and / or complainant (content and date):","insert details"]
[]
[null,null,"Issue resolved?"]
[]
[null,null,"If no:"]
[null,null,"Further investigation and corrective / preventative actions (if warranted):","insert details"]
[]
[null,null,"Further communications with complainant:","insert details"]
[]
[null,null,"Issue resolved?"]
[]
[null,null,"If no, continue with investigation and corrective / preventative actions (if warranted)","insert details"]
[]
[null,null,"Signature of investigator: ","insert details"]
[]
[null,null,"Date investigation closed: ","insert details"]

{"sheet":"Complaints code","index":41,"n_rows":93,"n_cols":18,"rows_kept":93,"cut":false,"hidden":true,"merged":[[69,3,69,13],[0,1,0,14],[4,3,4,13],[6,3,6,13],[8,3,8,13],[10,3,10,13],[12,3,12,13],[27,3,29,13],[61,3,61,13],[63,3,63,13],[65,3,65,13],[67,3,67,13],[90,3,90,13],[92,3,92,13],[71,3,71,13],[75,3,75,13],[77,3,77,13],[82,3,82,13],[84,3,84,13],[88,3,88,13]]}
[null,"Complaints Record"]
[]
[null,null,"Complaint Details"]
[]
[null,null,"Date of complaint:"," "]
[]
[null,null,"Time of complaint:"]
[]
[null,null,"Name of person advising of complaint:"]
[]
[null,null,"Complainant name (if known):"]
[]
[null,null,"Complainant phone number (if known):"]
[]
[null,null,"Method of complaint:","phone call"]
[null,null,true,"fax",false,null,false,null,false,null,true]
[null,null,null,"email",null,null,null,null,null,null,null,null," "]
[null,null,null,"in-person"]
[null,null,null,"other"]
[null,null,"Nature of complaint:"]
[]
[null,null,false,"odour",false,null,false,null,true,null,true,null,null,null,null,null,null," "]
[null,null,null,"noise"]
[null,null,null,"water"]
[null,null,null,"dust"]
[null,null,null,"other"]
[]
[null,null,"Details: "]
[]
[]
[]
[null,null,"Investigation Details"]
[]
[null,null,"Temperature at time of alleged nuisance:"]
[]
[null,null,true,"cold",false,null,null,null,null,null,null,null,false]
[null,null,null,"cool"]
[null,null,null,"mild"]
[null,null,null,"warm"]
[null,null,null,"hot"]
[null,null,null,"very hot"]
[]
[null,null,"Wind strength at time of alleged nuisance:"]
[]
[null,null,true,"calm",false,null,true,null,false,null,false,null,false]
[null,null,null,"light"]
[null,null,null,"moderate"]
[null,null,null,"fresh"]
[null,null,null,"strong"]
[null,null,null,"gale"]
[]
[null,null,"Wind direction at time of alleged nuisance:"]
[null,null,null,"north."]
[null,null,null,"north-east."]
[null,null,null,"east."]
[null,null,null,"south-east."]
[null,null,null,"south."]
[null,null,null,"south-west."]
[null,null,null,"west."]
[null,null,null,"north-west."]
[]
[null,null,"Direction from piggery (or reuse area) to complainant (if known): "]
[]
[null,null,"Approximate distance from piggery (or reuse area) to complainant (if known):"]
[]
[null,null,"Person responsible for investigating complaint: "]
[]
[null,null,"Investigating method (description, date): "]
[]
[null,null,"Signficant activities at time of alleged nuisance: "]
[]
[null,null,"Findings of investigation: "]
[]
[null,null,"Action Taken"]
[]
[null,null,"Corrective / preventative actions and date actions taken:"]
[]
[null,null,"Communications with person advising of complaint and / or complainant (content and date):"]
[]
[null,null,"Issue resolved?","Yes",false,"Yes",false,"No"]
[null,null,null,"No",null," "]
[null,null,"If no:"]
[null,null,"Further investigation and corrective / preventative actions (if warranted):"]
[]
[null,null,"Further communications with complainant:"]
[]
[null,null,"Issue resolved?","Yes",false,"Yes",false,"No"]
[null,null,null,"No"]
[null,null,"If no, continue with investigation and corrective / preventative actions (if warranted)"]
[]
[null,null,"Signature of investigator: "]
[]
[null,null,"Date investigation closed: "]

{"sheet":"Environmental Monitoring Record","index":42,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Environmental Monitoring Record"]
[]
[null,null,"Date","Element","Action","Further Actions Needed","Name","Signature"]
[null,null,null,"e.g. soil, spent bedding, manure, surface water, groundwater","e.g. sampling, sample dispatch, results received, results sent to regulators, results filed (where), results put on website"]

{"sheet":"Manure Reuse Record","index":43,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,15]]}
[null,"Manure Reuse Record"]
[]
[null,null,"Date ","Mass of  Manure (t)","Paddock for Spreading","Area  Spread (ha)","Spreading Rate (DM t/ha)","N Concentration (kg/t DM)","P  Concentration (kg/t DM)","K  Concentration (kg/t DM)","N Application (kg/ha)","P Application (kg/ha)","K Application (kg/ha)","Name ","Signature "]
[null,null,null,null,null,null,{"$f":"+D4/F4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+G4*$H4","v":{"$error":"#DIV/0!"}},{"$f":"+H4*$H4","v":0},{"$f":"+I4*$H4","v":0}]
[null,null,null,null,null,null,{"$f":"+D5/F5","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+G5*$H5","v":{"$error":"#DIV/0!"}},{"$f":"+H5*$H5","v":0},{"$f":"+I5*$H5","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},0,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},0,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},0,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"Manure Exports Record","index":44,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,1,0,13]]}
[null,"Manure Exports Record"]
[]
[null,null,"Date ","Description e.g. aged spent bedding","Quantity (t / m3)","Recipient Name","Recipient Address","Recipient Phone No.","Intended Use","Analysis Provided?","Duty of Care Statement Provided?","Name ","Signature "]

{"sheet":"Duty of Care","index":45,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Duty of Care for Off-Site Users"]
[]
[null,null,"Aged spent bedding and bedding compost from piggeries are great sources of nutrients for plant growth and carbon for building soil structure.  "]
[null,null,"However, like inorganic fertilisers, they need to be spread on suitable areas and applied at sustainable rates to ensure the environment is protected.  "]
[null,null,"Those utilising spent bedding or compost must take all reasonable and practical steps to prevent harm to the environment and to areas of cultural heritage sensitivity.  "]
[null,null,"Each state has its own Acts detailing duty of care provisions.  These typically require: "]
[null,null,"·       sustainable use of natural resources"]
[null,null,"·       conservation of biological diversity"]
[null,null,"·       avoidance of harm to Indigenous cultural heritage."]
[]
[null,null,"In particular, spreading of spent bedding or compost needs to be managed to avoid:"]
[null,null,"·       land degradation (e.g. soil erosion, decline in soil structure, nutrient overloading)"]
[null,null,"·       odour and dust nuisance"]
[null,null,"·       surface water and groundwater pollution with nutrients and sediment"," "]
[null,null,"·       increased weeds"]
[null,null,"·       noise nuisance"]
[]
[null,null,"To minimise the likelihood of these potential impacts:"]
[null,null,"·       minimise the risk of spent bedding or compost spillage during transportation by not overfilling the truck and by covering the load."]
[null,null,"·       where practical, avoid transport routes with a large number of houses close to the road."]
[null,null,"·       spent bedding and compost should not be stored or spread on areas that are flood-prone.  Nor should they be stored or spread on areas where they will pose a significant risk of nutrient transfer to watercourses (e.g. sloping land immediately abutting a watercourse).  "]
[null,null,"·       check the weather forecast before spreading spent bedding or compost and delay spreading if heavy rain is expected or the soil is still very wet following heavy rain.  Also check the wind speed and direction to ensure the prevailing wind is not blowing directly towards nearby residences.  "]
[null,null,"·       plan to spread spent bedding or compost from mid-morning to early-afternoon when good odour dispersion is likely.  Avoid spreading from mid-afternoon to evening.  Avoid spreading just before weekends or during holiday periods, particularly if close to a public area."]
[null,null,"·       determine a suitable spreading rate based on the N, P and K content of the spent bedding or compost, soil properties and the intended land use of the reuse area.  The rate should be consistent with the ability of soils and plants grown on the area to sustainably use the applied nutrients, salts and carbon in the spent bedding or compost."]
[null,null,"·       calibrate the spreader to spread at the target rate."]
[null,null,"·       monitor reuse areas for weeds and control these if necessary.  Although the aging and composting processes can destroy most weed seeds, some seeds may remain viable.  "]
[null,null,"·       avoid spreading spent bedding or compost close to sensitive neighbours at night when noise may create nuisance."]
[null,null,"·       do not allow grazing stock to access stored manure or reuse areas for at least three weeks after spreading."]

{"sheet":"Pesticide Use Record","index":46,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,2,11]]}
[null,"Pesticide Use Record"]
[]
[]
[]
[null,null,"Date","Name","Type of Pesticide","Product Name","Location Used","Method of Use","Quantity Used","Name","Signature"]
[null,null,null,null,"e.g. herbicide, rat bait, insecticide"]

{"sheet":"Environmental Incident Record","index":47,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,2,10]]}
[null,"Environmental Incident Record"]
[]
[]
[]
[null,null,"Date","Name","Incident Description","Actions Taken (including regulator contact)","Corrective / Preventative Actions Needed","Corrective / Preventative Actions Taken (including date)","Name","Signature"]

{"sheet":"Pollution Data Monitoring Rpt","index":48,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,7],[0,1,2,9],[10,2,10,8],[4,2,4,8],[6,2,6,8],[8,2,8,8],[9,2,9,8],[19,3,19,8],[11,2,11,8],[14,3,14,8],[15,3,15,8],[16,3,16,8],[17,3,17,8],[18,3,18,8],[12,2,12,4]]}
[null,"Pollution Data Monitoring Report"]
[]
[]
[]
[null,null,"Under the NSW Protection of the Environment Operations Act 1997 (POEO Act), holders of environment protection licences (licensees) must publish or make pollution monitoring data available to members of the public."]
[null,null," "]
[null,null,"The specific requirements for providing monitoring results are set out in section 66(6) of the POEO Act. In summary, this provision requires that:"]
[]
[null,null,"·  licensees who undertake monitoring as a result of a licence condition must publish or make available pollution monitoring data within 14 days of obtaining the data and/or receiving a specific request for a copy of the data·  "]
[null,null,"·  licensees who maintain a website must make the monitoring data related to pollution available in a prominent position on their website"]
[null,null,"·  licensees who do not maintain a website must provide a free of charge copy of the pollution monitoring data on reasonable written request from any person"]
[null,null,"·  the data must be published in accordance with requirements issued in writing by the EPA. Licensees must make themselves aware of all the requirements and ensure they comply.  The template below is a summary that may meet requirements.  However, the current requirements are set out in the EPA’s Requirements for publishing pollution monitoring data available online at - \n"]
[null,null,"http://www.epa.nsw.gov.au/resources/licensing/130742reqpubpmdata.pdf"]
[]
[null,null,"Date:"]
[null,null,"Monitoring Location:"]
[null,null,"Material for Sampling:"]
[null,null,"Monitoring Frequency Required by Licence:"]
[null,null,"Monitoring Frequency Requirement Met:"]
[null,null,"If not, when and why?"]
[]
[null,null,"Pollutant","Units of Measurement","Min. Value (for year)","Mean Value (for year)","Max. Value (for year)","Discharge / Emissions limit","If Discharge / Emission limit not met, why?"," "," "]
[null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This is the end of the EMP spreadsheet. Please SAVE it and print the whole workbook for your record."]