{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Risk Assessment","Critical Odour Issues","Guidance for Users"],"not_rendered":{"charts":0,"images":2,"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":"Risk Assessment","index":0,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["SITE NAME:","Deephams STW",null,null,null,"ODOUR RISK ASSESSMENT"]
["DATE:","2022-09-23"]
[null,null,null,"Normal ",null,"Abnormal"]
["Process Stage","Process Unit ","Applicable Legislation","Odour Description","Constant/ Intermittent/ Occasional/ Rare","Event Description","Likelihood of Event Frequent/ Rare/ Planned","Length of Time of Release","Nearest Customer/ Receptor","Offensive-ness (0-5)","Likelihood of Impact (0-5)","Odour Risk\n(<5 Low, >15 High)","Odour Impact","Mitigation Measures","Residual Odour Impact (L/M/H)","Responsibility for Mitigation Measures","Customer Communication Needed?","Notes"]
["ADD EXTRA ROWS BELOW THIS ROW IF REQUIRED"]
["Works Inlet","Incoming Sewers & Reception Wet Well","UWWTD","Fresh Sewage","C",null,null,null,"Nightingale Rd residents. Users of Meridian Way",1,1,{"$f":"J6*K6","v":1},"Low","Covered. ","-","Tech 1s","-"]
["Works Inlet","Cess Reception, Discharge, Wash down & Drainage","UWWTD","Sewage","C",null,null,null,"Nightingale Rd residents. Users of Meridian Way",1,1,{"$f":"J7*K7","v":1},"Low","Locked off and covered. Washdown.","-","Tech 1s / Tanker Drivers","-"]
["Works Inlet","Cess Reception, Discharge, Wash down & Drainage","UWWTD","Sewage",null,"Spillage","R","Hours","Nightingale Rd residents. Users of Meridian Way",1,1,1,"Low","Clean up ASAP as per section 4.3.3 in OMP","L","Tech 1s","N"]
["Storm Separation","Storm & Balancing Tanks ","UWWTD","Fresh Sewage","O",null,null,null,"Nightingale Rd residents. Users of Meridian Way",1,1,1,"Low","The TLL Storm Tanks have been installed with a cleaning system, this will activate once the flows to treatment allow.\nThe old Storm Tanks have a cleaning system and are emptied automatically and cleaned as soon as flows to treatment allow.\nIf/when deemed necessary storm tanks will also be manually cleaned via entry to the tank basins by a competent contractor","-","-","-"]
["Storm Separation","Storm & Balancing Tanks ","UWWTD","Fresh Sewage",null,"Amajets fail. ","R","Weeks","Nightingale Rd residents",4,3,12,"Medium","Wash down, drain tank.","L","TM","N","This would breach requirements of Local Authority."]
["Preliminary Treatment","Screens & Screening Conditioning, Drainage & Rag Skip Management","UWWTD","Sewage","C",null,null,null,"Nightingale Rd residents. Ardra Rd Industrial warehouses.",2,1,2,"Low","Coarse screenings from the Bosker Screens below the PHLL PS are removed using the grab; these are removed from the point of deposition, adjacent to the Meridian Way boundary, to a skip. Connected to OCU. ","-","Tech 1s","-"]
["Preliminary Treatment","Screens & Screening Conditioning, Drainage & Rag Skip Management","UWWTD","Foul sewage",null,"Failure of screen handling systen","R","Hours","Nightingale Rd residents. Ardra Rd Industrial warehouses.",2,2,4,"Low","Shut down, clean up, lock off. ","L","PCE","N"]
["Preliminary Treatment","Grit Removal Equipment, Drainage & Grit Skip Management","UWWTD","Foul sewage","C",null,null,null,"Nightingale Rd residents. Ardra Rd Industrial warehouses.",2,1,2,"Low","General housekeeping. Covered. Connected to OCU. ","-","Tech 1s","-"]
["Preliminary Treatment","Grit Removal Equipment, Drainage & Grit Skip Management","UWWTD","Foul sewage",null,"Spillage","R","Hours","Nightingale Rd residents. Ardra Rd Industrial warehouses.",2,1,2,"Low","Clean up ASAP as per section 4.3.3 in OMP","L","Tech 1s","N"]
["Crude Sewage Transfer ","Flow & Distribution to Primary Settlement Tanks","UWWTD","Fresh Sewage","C",null,null,null,"Nightingale Rd residents",1,1,1,"Low","Covered. Connected to OCU.","-","Tech 1s","-"]
["Primary Settlement","Primary Settlement Tanks","UWWTD","Sewage","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",1,2,2,"Low","Minimum sludge levels are maintained at all times\nTanks to remain covered at all operational times.\nTanks are periodically drained to the inlet works for cleaning and maintenance.\nKeep covers in place during operation ","-","Tech 1s","-"]
["Primary Settlement","Primary Settlement Tanks","UWWTD","Raw Sludge",null,"Sludge processes downstream unavailable","R","Days","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",4,4,16,"High","Tanker off site. Job raised with biorecycling and removed from site as soon as possible. ","H","PM","Y","Local groups may need to be contacted. This would breach requirements of Local Authority."]
["Primary Settlement","Fats, Oil & Grease Scum Removal System","UWWTD","Sewage","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",2,0,0,"Low","General housekeeping - clean out once a week. Covered. Connected to OCU. ","-","Tech 1s","-"]
["Primary Settlement","Fats, Oil & Grease Scum Removal System","UWWTD","Sewage",null,"Scraper and pump failure.","R","Days","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",2,2,{"$f":"J19*K19","v":4},"Low","Possible tanker. Raised with M&E to review, M&E to carry out replacement/repair.","L","PM & PCE","N"]
["Primary Settlement","Primary Raw Desludge Pumping","UWWTD","Fresh Sludge","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",2,1,2,"Low","Sludge is automatically removed. On failure, manual intervention is used to avoid accumulation. If necessary, tanks are drained and cleaned. \nProcess failures in the sludge process downstream may impact on the ability to accept further sludge from the PSTs. Manual intervention is required to minimise the impact of odour nuisance in selection of prioritisation of the PST sequencing.","-","Tech 1s","-"]
["Primary Settlement","Primary Raw Desludge Pumping","UWWTD","Raw Sludge",null,"Sludge processes downstream unavailable","R","Hours","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",2,2,{"$f":"J21*K21","v":4},"Low","Tanker off site. Job raised with biorecycling and removed from site as soon as possible. ","L","PM","Y","This would breach requirements of Local Authority."]
["Primary Settlement","Primary Raw Desludge Pumping","UWWTD","Raw Sludge",null,"Scraper failure","R","Hours","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",2,2,4,"Low","Tank taken out of service and funding sought to overhaul.","L","PM & PCE","N","Two PSTs can be taken out of service with the process uneffected. "]
["Settled Sewage Transfer ","Flow & Distribution to Secondary Treatment","UWWTD","Sewage","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,0,"Low","Covered. Connected to OCU. ","-","Tech 1s","-"]
["Secondary Treatment (Biological)","Activated Sludge Plant Lanes & Zones","UWWTD","Earthy","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",1,1,1,"Low","Anoxic zones connected to OCU. ","-","Tech 1s","-"]
["Secondary Treatment (Biological)","Activated Sludge Plant Lanes & Zones","UWWTD","Earthy",null,"Air main failure","R","Days","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",3,2,6,"Medium","Take tank out of service. Job raised with contractor as soon as possible to repair pipework. ","M","PM & PCE","N","6 ASPs, process can run as normal with 5. Customer communication depends on severity / weather."]
["Secondary Treatment (Biological)","Flow & Distribution to Secondary Settlement","UWWTD","Earthy","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",1,1,{"$f":"J26*K26","v":1},"Low","Covered and connected to OCU","-","Tech 1s","-"]
["Secondary Settlement ","Final Settlement Tanks","UWWTD","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,0,"Low","N/A","-","-","-"]
["Secondary Settlement ","Scum Removal System","UWWTD","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,0,"Low","N/A","-","-","-"]
["Secondary Settlement ","RAS Chambers & Pumping","UWWTD","Earthy","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",1,1,1,"Low","Mostly covered, low surface area. General housekeeping. ","-","Tech 1s","-"]
["Secondary Settlement ","SAS Chambers & Pumping","UWWTD","Earthy","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",1,1,1,"Low","Mostly covered, low surface area. General housekeeping. ","-","Tech 1s","-"]
["Tertiary Treatment 1","Filtration - Disc","UWWTD","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,0,"Low","Covered. General housekeeping. ","-","Tech 1s","-"]
["Tertiary Treatment 2","Filtration - Meccnao","UWWTD","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,{"$f":"J32*K32","v":0},"Low","Covered. General housekeeping. ","-","Tech 1s","-"]
["Tertiary Treatment","Back Wash Returns","UWWTD","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,{"$f":"J33*K33","v":0},"Low","Covered. General housekeeping. ","-","Tech 1s","-"]
["Final Effluent","Final Effluent","UWWTD","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,{"$f":"J34*K34","v":0},"Low","General housekeeping. ","-","Tech 1s","-"]
["Sludge Imports","Sludge Reception, Screening, Wash down & Drainage","EPR","Sludge","I",null,null,null,"Ardra Rd Industrial Warehouses",3,1,3,"Low","Follow normal procedures for imports.","-","Tech 1s","-","Fed to Raw Sludge Blending Tank."]
["Sludge Imports","Sludge Reception, Screening, Wash down & Drainage","EPR","Sludge",null,"Spillage.","R","Hours","Ardra Rd Industrial Warehouses",3,2,6,"Medium","Housekeeping. Tech 1s clean up ASAP as per section 4.3.3 in OMP. ","L","Tech 1s","N"]
["Sludge Imports","Skip Management","EPR","None","C",null,null,null,"Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",0,0,0,"Low","Collected by contractors when full - daily. ","-","Tech 1s / Contractors","-"]
["Sludge Imports","Skip Management","EPR","Sludge",null,"Not collected","R","Days","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",3,3,9,"Medium","Chase contractors.","L","PM","N"]
["Sludge Conditioning (Indigenous)","Primary Raw Sludge Thickening & Pumping","EPR","Sludge","C",null,null,null,"Ardra Rd Industrial Warehouses",2,2,4,"Low","Iron dosing (primarily for phosphorus removal) is critical in limiting the odour emission from the primary sludge thickening and holding.\nThe doors to the Gravity Belt Press enclosure are kept closed.\nCovers on the Buffer Tanks are kept closed and the OCU is operating correctly.",null,"Tech 1s"]
["Sludge Conditioning (Indigenous)","Primary Raw Sludge Thickening & Pumping","EPR","Sludge",null,"Failure of chemical dosing on sewage stream.","R","Hours","Ardra Rd Industrial Warehouses",2,2,4,"Low","Replace pumps. Restore dosing.","L","PM","N","Minimal impact if OCU operational."]
["Sludge Conditioning (Indigenous)","Primary Raw Sludge Thickening & Pumping","EPR","Sludge",null,"Covers/ doors left open.","R","Hours","Ardra Rd Industrial Warehouses",3,2,6,"Medium","Housekeeping.","L","Tech 1s","N","Minimal impact if Dosing is OK. This would breach requirements of Local Authority."]
["Sludge Conditioning (Indigenous)","Thickened Primary Sludge Storage Tank","EPR","Sludge","C",null,null,null,"Ardra Rd Industrial Warehouses",1,1,1,"Low","Covered. Connected to OCU. ",null,"Tech 1s"]
["Sludge Conditioning (Indigenous)","Thickened Primary Sludge Storage Tank","EPR","Sludge",null,"Tank failure","R","Months","Ardra Rd Industrial Warehouses",5,3,15,"High","Tank inspections as per TW standard. ","M","PM / Area Services Manager","N"]
["Sludge Conditioning (Indigenous)","SAS Thickening & Pumping","EPR","Earthy","C",null,null,null,"Ardra Rd Industrial Warehouses",2,2,4,"Low","2 tanks inside ventilated building with tanks connected to OCU, 2 tanks outside building but partially covered. ",null,"Tech 1s"]
["Sludge Conditioning (Indigenous)","SAS Thickening & Pumping","EPR","Earthy",null,"Spillage","R","Hours","Ardra Rd Industrial Warehouses",2,2,4,"Low","Clean up ASAP as per section 4.3.3 in OMP","L","Tech 1s","N"]
["Sludge Conditioning (Indigenous)","Sludge Blending & Mixing","EPR","Sludge","C",null,null,null,"Ardra Rd Industrial Warehouses",2,2,4,"Low","Covers to tanks to be kept closed. Connected to OCU. ",null,"Tech 1s"]
["Sludge Conditioning (Indigenous)","Sludge Blending & Mixing","EPR","Sludge",null,"Damage to vent line.","R","Days","Ardra Rd Industrial Warehouses",3,2,6,"Medium","Contractor to repair. Job raised on same day. ","L","PM & PCE","N"]
["Sludge Conditioning (Indigenous)","Sludge Blending & Mixing","EPR","Sludge",null,"Covers open","R","Hours","Ardra Rd Industrial Warehouses",3,2,6,"Medium","Cover ASAP","L","Tech 1s","N"]
["Sludge Conditioning (Indigenous)","Return Liquors","EPR","Sludge","C",null,null,null,"Ardra Rd Industrial Warehouses",3,1,3,"Low","Covered pipes. General housekeeping. ",null,"Tech 1s",null,"Inside covered chamber."]
["Sludge Conditioning (Indigenous)","Return Liquors","EPR","Sludge ",null,"Blockage.","R","Hours","Ardra Rd Industrial Warehouses",3,1,3,"Low","Tech 1s to repair ASAP","L","Tech 1s & M&E","N"]
["Sludge Treatment","Primary Digestion","EPR","Digested sludge.","I",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",3,2,6,null,"-","-","-","-"]
["Sludge Treatment","Primary Digestion","EPR","Digested sludge.",null,"Blockage causing limpet to overflow.","R","Days","Ardra Rd Industrial warehouses. Chingford.",3,2,6,"-","Unblock. Housekeeping.","L","TM","N"]
["Sludge Treatment","Primary Digestion","EPR","Digested sludge.",null,"Gas venting","R","Days","Ardra Rd Industrial warehouses. Chingford.",2,1,2,null,"Alarmed, process addressed.","L","PM","N","Illegal emission."]
["Sludge Treatment","Primary Digestion","EPR","Digested sludge.",null,"Digester taken out of service","P","Days","Ardra Rd Industrial warehouses. Chingford.",3,2,6,null,"Risk assessments. Method statements.","L","PM","N"]
["Sludge Treatment","Secondary Digestion and Mixing","EPR","Digested sludge.","C",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",3,3,9,null,"Tanks are now covered","L","-","-"]
["Sludge Treatment","Secondary Digestion and Mixing","EPR","Digested sludge.",null,"Crusting. Overflow down road.","R","Days","Ardra Rd Industrial warehouses. Chingford.",3,4,12,null,"Keep mixers operational. ","L","TM","N","This would breach requirements of Local Authority."]
["Sludge Dewatering","Beltpress","EPR","Digested sludge.","C",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",3,2,6,null,"-","L","-","-","In well ventilated building."]
["Sludge Dewatering","Beltpress","EPR",null,null,"Ventilation failure. Building failure.",null,null,"Ardra Rd Industrial warehouses. Chingford.",3,3,9,null,"Repair. ","M","PM","N","This would breach requirements of Local Authority."]
["Sludge Dewatering","Centrifuge ","EPR","Digested sludge.","C",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",3,2,6,null,"-","-","-","-"]
["Sludge Dewatering","Centrifuge ","EPR",null,null,"Nothing to impact odour release",null,null,"Ardra Rd Industrial warehouses. Chingford.",3,2,6,"-","-","-","-","-"]
["Sludge Dewatering","Liquor Return","EPR","Foul liquor.","C",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",2,1,2,"-","-","-","-","-"]
["Sludge Dewatering","Liquor Return","EPR",null,null,"Nothing to impact odour release",null,null,"Ardra Rd Industrial warehouses. Chingford.",2,1,{"$f":"J62*K62","v":2},"-","-","-","-","-"]
["Sludge Storage & Movements","Cake Pad & Drainage","EPR","Digested sludge.","C",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",2,2,4,null,"Operations are limited to the working day.\nOperations are programmed and where possible adverse weather conditions are avoided.\nMeasures are taken where possible to avoid waterlogging of cake stockpiles - not holding stockpiles to avoid water logging of cake",null,"-","-"]
["Sludge Storage & Movements","Cake Pad & Drainage","EPR",null,null,"Nothing to impact odour release",null,null,"Ardra Rd Industrial warehouses. Chingford.",2,2,4,"-","-","-","-","-"]
["Sludge Storage & Movements","Vehicle Movements & Wash Down ","EPR","Digested sludge.","I",null,null,null,"Ardra Rd Industrial warehouses. Chingford.",2,3,6,null,"Covered wagons. Wheelwash.",null,"Biorecycling."]
["Sludge Storage & Movements","Vehicle Movements & Wash Down ","EPR",null,null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",null,null,0,"-","-","-","-","-"]
["Biogas Systems","Biogas Storage","EPR","Gas",null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",1,1,1,"-","-","-","-","-"]
["Biogas Systems","Biogas Storage","EPR","Gas",null,"Nothing to impact odour release",null,null,"Ardra Rd Industrial warehouses. Chingford.",1,1,1,"-","-","-","-","-"]
["Biogas Systems","CHP","EPR","Gas",null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",null,null,0,"-","-","-","-","-"]
["Biogas Systems","CHP","EPR","Gas",null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",null,null,0,"-","-","-","-","-"]
["Biogas Systems","Boilers","EPR","Gas",null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",0,0,0,"-","-","-","-","-"]
["Biogas Systems","Boilers","EPR","Gas",null,"Nothing to impact odour release",null,null,"Ardra Rd Industrial warehouses. Chingford.",0,0,0,"-","-","-","-","-"]
["Biogas Systems","Waste Gas Burner","EPR","Gas",null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",1,1,1,"-","-","-","-","-"]
["Biogas Systems","Waste Gas Burner","EPR","Gas",null,"Nothing to impact odour release",null,null,"Ardra Rd Industrial warehouses. Chingford.",1,1,1,"-","-","-","-","-"]
["Power Generation","Standby Generators","EPR","Slightly of oil","O",null,null,null,"Nightingale Rd residents. Ardra Rd Industrial warehouses.",2,1,2]
["Power Generation","Standby Generators","EPR",null,null,"Nothing to impact odour release",null,null,"Nightingale Rd residents. Ardra Rd Industrial warehouses.",2,1,2]
["Odour Control Unit","OCU (Sludge holding tanks)","EPR","None",null,null,null,null,"Ardra Rd Industrial warehouses. Chingford.",0,0,0,"-","Hydrogen sulphide measurement on outlet of stack.\nVisual checks to ensure fans, pumps and H2s Monitors are operational.\nEnsure water dosing is maintained\nFramework maintenance company twice yearly routine visits to check compliance and service plant","-","-","-"]
["Odour Control Unit","OCU (Sludge holding tanks)","EPR","Sludge","C","Failure of fans.","R","Weeks","Ardra Rd Industrial warehouses. Chingford.",4,3,12,"Possible complaints","Maintenance contract ","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU (Sludge holding tanks)","EPR","Sludge","C","Failure of media.","R","Weeks","Ardra Rd Industrial warehouses. Chingford.",4,3,{"$f":"J79*K79","v":12},"Possible complaints","Replace media.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 1","UWWTD","Foul sewage",null,null,null,null,"Nightingale Rd residents. Users of Meridian Way",1,1,1,"-","Hydrogen sulphide measurement on outlet of stack.\nVisual checks to ensure fans, pumps and H2s Monitors are operational.\nEnsure water dosing is maintained\nFramework maintenance company twice yearly routine visits to check compliance and service plant","-","-","-"]
["Odour Control Unit","OCU1","UWWTD","Foul sewage","C","Failure of fans.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints","Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 1","UWWTD","Foul sewage","C","Failure of media.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints","Replace media.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 2","UWWTD","Foul sewage",null,null,null,null,"Nightingale Rd residents. Users of Meridian Way",1,1,{"$f":"J83*K83","v":1},"-","Hydrogen sulphide measurement on outlet of stack.\nVisual checks to ensure fans, pumps and H2s Monitors are operational.\nEnsure water dosing is maintained\nFramework maintenance company twice yearly routine visits to check compliance and service plant","-","-","-"]
["Odour Control Unit","OCU 2","UWWTD","Foul sewage","C","Failure of fans.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints","Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 2","UWWTD","Foul sewage","C","Failure of media.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints","Replace media.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 3","UWWTD","Foul sewage",null,null,null,null,"Nightingale Rd residents. Users of Meridian Way",1,1,{"$f":"J86*K86","v":1},"-","Hydrogen sulphide measurement on outlet of stack.\nVisual checks to ensure fans, pumps and H2s Monitors are operational.\nEnsure water dosing is maintained\nFramework maintenance company twice yearly routine visits to check compliance and service plant","-","-","-"]
["Odour Control Unit","OCU 3","UWWTD","Foul sewage","C","Failure of fans.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints","Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 3","UWWTD","Foul sewage","C","Failure of media.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints","Replace media.","M","TM","N","This would breach requirements of Local Authority."]

{"sheet":"Critical Odour Issues","index":1,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Risk Assessment'!A1","v":"SITE NAME:"},{"$f":"'Risk Assessment'!B1","v":"Deephams STW"},null,"CRITICAL ODOUR ISSUES"]
["DATE:","2022-09-23"]
[null,null,"Normal ",null,"Abnormal"]
["Storm Separation","Storm & Balancing Tanks ",null,null,"Amajets fail. ","R","Weeks","Nightingale Rd residents",4,3,12,"Possible complaints","Plant monitored","Daily","SCADA","PCE","Wash down, drain tank.","L","TM","N","This would breach requirements of Local Authority."]
["Primary Settlement","Primary Settlement Tanks","Raw Sludge","C","Sludge processes downstream unavailable","F","Days","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",4,4,16,"Possible complaints","Plant monitored","Daily","SCADA","PCE","Boxed spares. Service contracts. Cleaning of tanks.","H","PM","Y","Local groups may need to be contacted. This would breach requirements of Local Authority."]
["Primary Settlement","Primary Raw Desludge Pumping","Raw Sludge","C","Sludge processes downstream unavailable","F","Days","Pickets Lock, Nightingale Rd, Ardra Rd, Chingford.",4,4,16,"Possible complaints","Plant monitored","Daily","SCADA","PCE","Boxed spares. Service contracts. Cleaning of tanks.","-","-","-","This would breach requirements of Local Authority."]
["Sludge Treatment","Secondary Digestion and Mixing","Raw Sludge","C","Crusting. Overflow down road.","R","Days","Ardra Rd Industrial warehouses. Chingford.",3,4,12,"Possible complaints","-","-","-","-","Keep mixers operational. ","L","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU (Sludge holding tanks)","Sludge","C","Failure of fans.","R","Weeks","Ardra Rd Industrial warehouses. Chingford.",4,3,12,"Possible complaints",null,null,null,null,"Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU (Sludge holding tanks)","Sludge","C","Failure of media.","R","Weeks","Ardra Rd Industrial warehouses. Chingford.",4,3,12,"Possible complaints","-","-","-","-","Replace media.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU1","Foul sewage","C","Failure of fans.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints",null,null,null,null,"Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 1","Foul sewage","C","Failure of media.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints",null,null,null,null,"Replace media.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 2","Foul sewage","C","Failure of fans.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints",null,null,null,null,"Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 2","Foul sewage","C","Failure of media.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints",null,null,null,null,"Replace media.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 3","Foul sewage","C","Failure of fans.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints",null,null,null,null,"Maintenance contract.","M","TM","N","This would breach requirements of Local Authority."]
["Odour Control Unit","OCU 3","Foul sewage","C","Failure of media.","R","Weeks","Nightingale Rd residents. Users of Meridian Way",4,3,12,"Possible complaints",null,null,null,null,"Replace media.","M","TM","N","This would breach requirements of Local Authority."]

{"sheet":"Guidance for Users","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["GUIDANCE FOR USERS"]
[]
["1.","To use the spreadsheet, you first of all need to click 'Enable Content' so that the macros will work (see below)."]
[]
[]
[]
[]
[]
[]
[]
["2.","Then click the 'Display Critical Odour Issues' button."]
[]
["3.","Then go to 'Critical Odour Issues' sheet to see the list of odour critical plant and issues etc."]
[]
["4.","When saving the document, make sure you save it as 'Excel Macro-Enabled Workbook (*.xlsm)' (see below)"]