{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Read me","Ammonia"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Read me","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Version Date - December 2021"]
[]
[]
["Air Quality Modelling and Assessement Unit (AQMAU) AMMONIA SCREENING TOOL"]
[]
["VERSION 4.6"]
[]
[]
["COPYRIGHT © 2021 ENVIRONMENT AGENCY ALL RIGHTS RESERVED"]
["Redistribution of this tool and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: "]
["1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer."]
["2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution."]
[]
["DISCLAIMER:"]
["THIS SOFTWARE IS PROVIDED BY THE ENVIRONMENT AGENCY, AND CONTRIBUTORS \"AS IS\" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE ENVIRONMENT AGENCY OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE."]
[]
["LICENCE:"]
["Open Government Licence for public sector information"]
["http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/"]

{"sheet":"Ammonia","index":1,"n_rows":126,"n_cols":13,"rows_kept":126,"cut":false,"hidden":false,"merged":[[70,6,70,8],[71,6,71,8],[35,2,35,4],[6,12,7,12],[4,1,5,1],[4,2,5,4],[33,1,34,1],[33,2,34,4],[69,6,69,8]]}
[null,"Screening ammonia emissions from pig and poultry farms"]
[null,"Air Quality Modelling and Assessment Unit (AQMAU), The Environment Agency"]
[null,"AQMAU Ammonia Screening Tool, version 4.6"]
[]
[null,"STEP 1 ","ENTER EMISSION DATA IN THE BLUE BOXES"]
[]
[null,null,"Enter data in the blue boxes.",null,null,null,null,null,null,null,null,null,"Sub total ammonia emission rate (g/s)"]
[null,null,"High velocity fans, height ≥ 5.5m",null,"Source 1","Source 2","Source 3","Source 4","Source 5","Source 6","Source 7"]
[null,null,"Number of animal places",null,225000,null,null,null,null,null,null,25000]
[null,null,"Housing emission factor (kg NH3 /animal place/year)",null,3.4000000000000002E-2,null,null,null,null,null,null,3.4000000000000002E-2,{"$f":"D12","v":0.24257990867579915}]
[null,null,"Exit Velocity (For speeds between 7 and 14 m/s)",null,11]
[null,null,null,{"$f":"(E9*E10+F9*F10+G9*G10+H9*H10+I9*I10+J9*J10+K9*K10)*1000/3600/8760","v":0.24257990867579915},{"$f":"E9*E10*1000/365/24/3600","v":0.24257990867579909},{"$f":"F9*F10*1000/365/24/3600","v":0},0,0,0,0,0]
[null,null,"Low velocity fans, exit velocity ≥ 2 and <7m/s, height ≥ 3.5m,"]
[null,null,"Number of animal places"]
[null,null,"Housing emission factor (kg NH3 /animal place/year)",null,null,null,null,null,null,null,null,null,{"$f":"D16","v":0}]
[null,null,null,{"$f":"(E14*E15+F14*F15+G14*G15+H14*H15+I14*I15+J14*J15+K14*K15)*1000/3600/8760","v":0}]
[null,null,"Other animal houses"]
[null,null,"Number of animal places"]
[null,null,"Housing emission factor (kg NH3 /animal place/year)",null,null,null,null,null,null,null,null,null,{"$f":"D20","v":0}]
[null,null,null,{"$f":"(E18*E19+F18*F19+G18*G19+H18*H19+I18*I19+J18*J19+K18*K19)*1000/3600/8760","v":0}]
[null,null,"Slurry storage area (m2)"]
[null,null,"Slurry storage emission factor (kg NH3 /m2/year)",null,null,null,null,null,null,null,null,null,{"$f":"D23","v":0}]
[null,null,null,{"$f":"(E21*E22+F21*F22+G21*G22+H21*H22+I21*I22+J21*J22+K21*K22)*1000/3600/8760","v":0}]
[null,null,"Manure storage (tonne)"]
[null,null,"Manure storage emission factor (kg NH3 / tonne/year)",null,null,null,null,null,null,null,null,null,{"$f":"D26","v":0}]
[null,null,null,{"$f":"(E24*E25+F24*F25+G24*G25+H24*H25+I24*I25+J24*J25+K24*K25)*1000/3600/8760","v":0}]
[null,null,"Sub total ammonia emission rate (g/s)",{"$f":"(E18*E19+E21*E22+E24*E25+F18*F19+F21*F22+F24*F25+G18*G19+G21*G22+G24*G25+H18*H19+H21*H22+H24*H25+I18*I19+I21*I22+I24*I25+J18*J19+J21*J22+J24*J25+K18*K19+K21*K22+K24*K25)*1000/3600/8760","v":0},{"$f":"(E9*E10+E14*E15+E18*E19+E21*E22+E24*E25)*1000/3600/8760","v":0.24257990867579915},0,0,0,0,0,0]
[]
[]
[null,null,"Total ammonia emission rate (g/s)",null,{"$f":"(E27+F27+G27+H27+I27+J27+K27)","v":0.24257990867579915}]
[]
[]
[]
[null,"STEP 2 ","ENTER DISTANCE IN THE BLUE BOX AND FIND RESULTS"]
[]
[null,null,"20% (EU sites), 50% (SSSI sites) and 100% (Non-statutory sites)"]
[]
[]
[null,null,"Annual mean NH3 concentration (for comparison with the annual mean critical level)"]
[]
[null,null,"Distance (m)","Concentration (ug/m3) due to 1 g/s","Concentration (ug/m3) due to farm"]
[null,null,250,10.244999999999999,{"$f":"D42*$D$27","v":0}]
[null,null,500,3.6513300000000002,{"$f":"D43*$D$27","v":0}]
[null,null,750,1.8684099999999999,0]
[null,null,1000,1.5323500000000001,0]
[null,null,1250,1.1456200000000001,0]
[null,null,1500,0.78508699999999998,0]
[null,null,1750,0.69012200000000001,0]
[null,null,2000,0.51725299999999996,0]
[null,null,2250,0.44617299999999999,0]
[null,null,2500,0.37829000000000002,0]
[null,null,2750,0.32759100000000002,0]
[null,null,3000,0.29488999999999999,0]
[null,null,3250,0.24796399999999999,0]
[null,null,3500,0.22991200000000001,0]
[null,null,3750,0.19770099999999999,0]
[null,null,4000,0.18393999999999999,0]
[null,null,4250,0.169185,0]
[null,null,4500,0.15184500000000001,0]
[null,null,4750,0.14310400000000001,0]
[null,null,5000,0.12795799999999999,0]
[null,null,6000,0.1,0]
[null,null,7000,7.6999999999999999E-2,0]
[null,null,8000,6.3E-2,0]
[null,null,9000,5.2999999999999999E-2,0]
[null,null,10000,4.4999999999999998E-2,0]
[]
[]
[]
[]
[null,null,"Distance (m)",null,3449]
[null,null,"Concentration due to farm (ug/m3)",null,3.7514181705116667E-2]
[null,null,"N Deposition due to farm (kg N/ha/yr)",null,0.19484865977637597]
[null,null,"Acid deposition due to farm (keq/ha/yr)",null,1.3917650070506984E-2]
[]
[]
["Note: the results can be used in the screening assessment with the current thresholds:"]
["20% of relevant critical load/level for EU sites, 50% for SSSI sites and 100% for non-statutory sites"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Optional: distance to screening criteria from source"]
[]
[null,null,"Screening criteria  Ú   Associated distance"]
[null,null,"Critical Level (ug/m3)",null,"% of CLe","<250m"]
[null,null,1,null,4,3305]
[null,null,1,null,20,1133]
[null,null,1,null,100,388]
[null,"Where Critical level of 3ug/m3 is applied, assess impact of nutrient nitrogen and acid deposition."]
[null,null,"Minimum nitrogen depostion critical load"]
[null,null,"Minimum acid deposition critcal load (minCLmaxN)"]
[]
[null,null,"Critical Level (ug/m3)",null,"% of CLe","Distance (m)"]
[null,null,3,null,4]
[null,null,3,null,20]
[null,null,3,null,100]
[null,null,"Nutrient Nitrogen Critical Load (KgN/ha/yr)",null,"% of Clo","Distance (m)"]
[null,null,null,null,4]
[null,null,null,null,20]
[null,null,null,null,100]
[null,null,"Nitrogen Acid Deposition Critical Load (keq/ha/yr)",null,"% of Clo","Distance (m)"]
[null,null,null,null,4]
[null,null,null,null,20]
[null,null,null,null,100]
[]
[null,null,"Critical loads can be found at:",null,"www.apis.ac.uk"]