{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Guidance Notes","Version History","NAT","Additional Evidence","ValidationLists","Supporting Evidence","FAQ","Location Definitions","DfR Inert Landfill","Power Generation","Waste Handling","Anaerobic Digestion"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":13,"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":"Guidance Notes","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Version History","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Version","Date of change","Changes made to NAT (full description)"]
[1]
[1.1000000000000001,"2024-03-01","Step to variation score changed from 9 to 7. testing showed that a score of 9 led to applications screening out which if looked at by a PO would have screened in."]
[1.2,"2024-05-17","NAT updated to include definition of night time (23:00-07:00). Nearest receptor distance options changed from 101-150 to 100-150."]
[1.3,"2024-06-28","Variation score updated for nightime and >100% increase in throughput to change scoring. If either are included in the NAT assessment will now automatically trigger the need for a NIA."]
[1.4,"2024-07-19","Evening operations inlcuded within 'Will the time operations occur change tab' (11). IF statement included within step 2 evaluation for variations. For variations when step 1 outcomes states 'NIA and NMP not required' this overides the results of options chosen in step 2. Rows can now be formatted. Version History tab added to NAT."]

{"sheet":"NAT","index":2,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,5,25,10],[66,0,66,1],[39,0,42,0],[39,1,42,1],[43,0,46,0],[43,1,46,1],[47,0,50,0],[47,1,50,1],[51,0,54,0],[51,1,54,1],[62,1,62,2],[63,1,63,2],[65,0,65,3],[26,5,26,10],[27,5,27,10],[30,6,35,10],[18,0,18,1],[19,1,19,4],[27,0,30,0],[31,0,34,0],[35,0,38,0],[35,1,38,1],[23,1,24,1],[22,0,23,0],[24,0,26,0],[30,2,30,4],[26,2,26,4],[27,2,27,4],[25,2,25,4],[23,2,24,4],[22,2,22,4],[31,2,32,4],[14,6,19,10],[21,2,21,4],[21,5,21,10],[8,2,8,4],[8,5,8,10],[9,2,9,4],[9,5,9,10],[10,2,10,4],[10,5,10,10],[15,2,16,4],[11,2,11,4],[11,5,11,10],[14,2,14,4],[28,2,28,4],[12,2,12,4],[0,1,0,10],[1,2,1,3],[1,4,1,5],[1,6,1,10],[4,2,4,4],[4,5,4,10],[23,5,24,10],[22,5,22,10],[5,2,5,4],[5,5,5,10],[6,2,6,4],[6,5,6,10],[7,2,7,4],[7,5,7,10]]}
["Version: 1.4","Noise Advisory Tool"]
[null,"Site Name:","J. Fisher & Sons Limited, Arley Way, Atherton, M46 9BP",null,"Application Reference:",null,"EPR/FB3001SS/V002"]
["Step 1: To be completed for all applications"]
[null,"input details of the site AFTER the variation is complete"]
[null,null,"Select from the drop-down lists",null,null,"Evidence your decision here",null,null,null,null,null,null,{"$f":"VLOOKUP(C6,ValidationLists!B10:C21,2,FALSE)","v":3}]
[null,"1. Activity Type","Waste recycling transfer/treatment/processing",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C7,ValidationLists!B3:C5,2,FALSE)","v":3}]
[null,"2. Activity Containment","External operations with processing and storage",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C8,Night_operation,2,FALSE)","v":2}]
[null,"3. Operation at night","Yes but ENCLOSED",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C9,Operation_size,2,FALSE)","v":3}]
[null,"4. Operation Size","large",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C10,ValidationLists!B61:C73,2,FALSE)","v":3},null,{"$f":"(SUM(M5+M6+M8+M7+M10+M11))*M9","v":42},"Yes"]
[null,"5. Input distance from site to the nearest (or proposed) noise sensitive receptor (m) ","151-200",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C11,Rec_location,2,FALSE)","v":1},null,null,"No"]
[null,"6. Residential receptor Location","urban",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C12,Rec_disto_mainsource,2,FALSE)","v":2},null,30]
[null,"7. Residential receptor proximity to other major noise source (m) e.g. busy road, other industrial activities, etc.","101-200"]
[null,null,"The result will automatically update when the values are selected from the drop down menus"]
[]
[null,"Evaluation",{"$f":"IF(O9<O11,\"NIA and NMP are not required*\",\"New bespoke application: Submit an NIA & NMP                                                              Variation application: Go to step 2\")","v":"New bespoke application: Submit an NIA & NMP                                                              Variation application: Go to step 2"}]
[null,null,"*The Environment Agency reserves the right to request the submission of an NIA or NMP independent of the outcome of noise advisory tool"]
[]
[]
["Step 2: Variation applications only"]
[null,"Answer these questions in relation to a variation application only"]
[]
[null,null,"Select from the drop-down lists",null,null,"Evidence your decision here"]
[null,"8. Has a NIA or NMP been previously requested by the EA?","No",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C23,ValidationLists!B80:C81,2,FALSE)","v":1}]
[null,"9. Will new noise generating sources/activities be introduced?","No",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C24,ValidationLists!B85:C86,2,FALSE)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M23*(M24+M26+M27+M28)","v":2}]
[null,"10. Will annual throughput increase?","0-25%",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C26,ValidationLists!B89:C93,2,FALSE)","v":0}]
[null,"11. Will the time operations occur change?","No",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C27,ValidationLists!B96:C100,2,FALSE)","v":0}]
[null,"12. Will the variation change how activities are enclosed?","No change",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C28,ValidationLists!B103:C105,2,FALSE)","v":1},null,7]
[null,null,"The result will automatically update when the values are selected from the drop down menus"]
[]
[null,"Evaluation",{"$f":"IF(O9<O11,\"NIA and NMP are not required*\",IF(O25<O28,\"NIA and NMP are not required*\",\"Submit an NIA & NMP\"))","v":"NIA and NMP are not required*"}]
[null,null,"*The Environment Agency reserves the right to request the submission of an NIA or NMP independent of the outcome of noise advisory tool"]

{"sheet":"Additional Evidence","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ValidationLists","index":4,"n_rows":105,"n_cols":4,"rows_kept":105,"cut":false,"hidden":true,"merged":[[82,1,83,1]]}
[null,"ACTIVITY CRITERIA","SCORE"]
[null,"activity containment"]
[null,"External operations with processing and storage",3]
[null,"Internal operations with external deliveries, goods handling and storage, no processing",2]
[null,"Internal operations with external deliveries / External storage, no processing",1]
[]
[]
[]
[null,"activity type (score from NIRS noise data) "]
[null,"Waste recycling transfer/treatment/processing",3]
[null,"Hard material handling and/or recycling (e.g. ELV, scrap metals and glass)",3]
[null,"Wood processing and recycling",3]
[null,"Landfill that includes the processing of waste/DFR with waste processing",3]
[null,"Carbon Capture",3]
[null,"Soil and aggregates",2]
[null,"Power generation backup/peaking (see notes)",2]
[null,"Energy from waste",2]
[null,"Food Processing",2]
[null,"Waste transfer and storage with no processing",1]
[null,"Anaerobic digestion / Waste Water Treatment Works",1]
[null,"Manufacturing",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operation size"]
[null,"small",1]
[null,"medium",2]
[null,"large",3]
[]
[null,"RECEPTOR CRITERIA","SCORE"]
[null,"Nearest Receptor distance (m)"]
[]
[]
[null,"Receptor location"]
[null,"rural",3]
[null,"suburban",2]
[null,"urban",1]
[]
[]
[null,"Receptor proximity to other major noise source, e.g. busy road, other industrial activities (m)"]
[null,">200",3]
[null,"101-200",2]
[null,"<100",1]
[]
[]
[null,"OPERATION AT NIGHT","SCORE"]
[null,"Yes",3]
[null,"Yes but ENCLOSED",2]
[null,"No",1]
[]
[]
[null,"Distance (metres)","Multiplier","Multiplier"]
[null,"<50",6,6]
[null,"51-<100",4,4]
[null,"100-150",3.6,3.6]
[null,"151-200",3,3]
[null,"201-300",2.6,2.6]
[null,"301-400",2.4,2.4]
[null,"401-500",2.2000000000000002,2.2000000000000002]
[null,"501-600",2.1,2.1]
[null,"601-700",2,2]
[null,"701-800",1.9,1.9]
[null,"801-900",1.8,1.8]
[null,"901-1000",1.7,1.7]
[null,">1000",1,1]
[]
[]
[]
[null,"Variation"]
[]
[null,"Has a NIA been previously requested?"]
[null,"Yes ",2]
[null,"No",1]
[]
[null,"Will new noise generating sources/activities be introduced?"]
[]
[null,"Yes",3]
[null,"No",1]
[]
[null,"Will annual throughput increase?"]
[null,"0-25%",0]
[null,"26-50%",1]
[null,"51-75%",2]
[null,"76-100%",3]
[null,">100%",10]
[]
[null,"Will the time operations occur change?"]
[null,"No",0]
[null,"Yes, variation changes daytime operating times only",1]
[null,"Yes, variation includes the addition of weekend operations",2]
[null,"Yes, the variation includes the addition of evening operations",3]
[null,"Yes, variation includes the addition of night time activities",10]
[]
[null,"Will the variation change how activities are are enclosed?"]
[null,"Yes, new external operations",3]
[null,"Yes, new operations but operations but enclosed",2]
[null,"No change",1]

{"sheet":"Supporting Evidence","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Write any notes / paste any useful pictures to provide additional evidence into this tab"]

{"sheet":"FAQ","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Location Definitions","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DfR Inert Landfill","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Power Generation","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Waste Handling","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Anaerobic Digestion","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}