{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary and Calculation","Complexity_Emissions_Location","Operator Performance","References","XML Data","ProfileHeader","ProfileDetail"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":3,"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":"Summary and Calculation","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,21,4],[16,5,16,6],[15,2,15,4],[11,9,11,11],[15,5,15,6],[16,2,16,4],[13,2,13,4],[19,5,19,6],[15,9,15,10],[19,2,19,4],[16,9,16,10],[11,2,11,4],[12,2,12,4],[14,2,14,4],[11,5,11,6],[13,5,13,6],[14,5,14,6],[0,10,0,12],[6,4,6,5],[8,4,8,5],[6,6,6,7],[8,6,8,7],[8,8,8,11],[6,8,6,11]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2019-03-01T10:21:32.920"}]
["A"]
["B","Opra Spreadsheet",null,null,null,null,null,null,"Version:",1.9,"Release Date:","2014-04-01"]
["C","for Waste Facilities"]
["D"]
["E"]
["F",null,"Permit No:",null,null,null,"Site Name:"]
[]
[null,null,"Date:",null,null,null,"Operator:"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H18=0,\"Complete your profile to display charges\",\"\")","v":"Complete your profile to display charges"}]
[null,null,"Attribute",null,null,"Bands",null,"Points",null,"Fees and Charges"]
[null,null,"Complexity(s):",null,null,{"$f":"IF(ISNONTEXT(Complexity_Emissions_Location!F5),\"\",Complexity_Emissions_Location!F5)","v":""},{"$f":"Complexity_Emissions_Location!F7","v":0},{"$f":"(IF(Complexity_Emissions_Location!F5=0,0,HLOOKUP(F13,References!$H$8:$O$13,2,FALSE)))+(IF(Complexity_Emissions_Location!F7=0,0,HLOOKUP(G13,References!$H$8:$O$13,2,FALSE)))","v":0},null,"Application Fee",null,{"$f":"H17*App_factor","v":0}]
[null,null,"Emissions:",null,null,{"$f":"Complexity_Emissions_Location!O10","v":""},null,{"$f":"IF(F14=\"\",\"\",HLOOKUP(F14,References!$H$8:$O$13,3,FALSE))","v":""},null,"Normal Variation",null,{"$f":"H17*References!H4","v":0}]
[null,null,"Location:",null,null,{"$f":"Complexity_Emissions_Location!O22","v":""},null,{"$f":"IF(F15=\"\",\"\",HLOOKUP(F15,References!$H$8:$O$13,4,FALSE))","v":""},null,"Full Surrender",null,{"$f":"H17*References!J4","v":0}]
[null,null,"Operator Performance:",null,null,{"$f":"'Operator Performance'!H62","v":""},null,{"$f":"IF(F16=\"\",\"\",HLOOKUP(F16,References!$H$8:$O$13,5,FALSE))","v":""},null,"Part Surrender",null,{"$f":"H17*References!L4","v":0}]
[null,null,{"$f":"IF(H18=0,\"Incomplete\",\"\")","v":"Incomplete"},null,null,"Total:",null,{"$f":"SUM(H13:H16)","v":0},null,"Subsistence",null,"See Charge Tables"]
[null,null,null,null,null,null,null,{"$f":"IF(LEN(F13&F14&F15&F16)<4,0,H17)","v":0}]
[]
[null,null,"Compliance Rating",null,null,null,null,null,null,"Subsistence Multiplier",null,{"$f":"IF(F20=\"\",1,OFFSET(References!H13,,CODE(F20)-65))","v":1}]
[]
[null,null,"Reference Sheet"]

{"sheet":"Complexity_Emissions_Location","index":1,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,11,17,12],[15,2,15,3],[17,2,17,3],[8,2,11,6]]}
[]
[]
[null,null,"Complexity Attribute",null,null,null,null,null,"Emissions Attribute (Waste Input)"]
[]
[null,null,"Site Type:",1,"Complexity Band:",{"$f":"OFFSET(References!C3,D5-1,0)","v":0},null,null,null,"Waste Type","Annual Tonnage","Emission Threshold","Emission Index"]
[null,null,null,null,null,null,null,null,null,"Inert",null,1000,{"$f":"INT(K6/L6)","v":0}]
[null,null,"2nd Site Type:",1,"2nd Band:",{"$f":"OFFSET(References!C3,D7-1,0)","v":0},null,null,null,"Non Hazardous (Non Bio)",null,750,{"$f":"INT(K7/L7)","v":0}]
[null,null,"Complexity Bands are based on a lookup table (see References tab)",null,null,null,null,null,null,"Non Hazardous (Bio)",null,500,{"$f":"INT(K8/L8)","v":0}]
[null,null,"More than one Complexity (Site Type) is required only in circumstances where the permit in question covers a landfill activity and a treating/keeping activity.  In all other circumstances only one site type should be entered.  Where more than one site type applies, the one carrying the highest relevant complexity band is used.",null,null,null,null,null,null,"Hazardous",null,250,{"$f":"INT(K9/L9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(M6:M9)","v":0},"Band:",{"$f":"IF(D5=37,\"B\",IF(D5=41,\"A\",IF(K6 & K7 & K8 & K9=\"\",\"\",IF(M10<10,\"A\",IF(M10<100,\"B\",IF(M10<1000,\"C\",IF(M10<10000,\"D\",\"E\")))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Emission Bands are based on total index: <10=A, <100=B, <1000=C, <10000=D, >=10000=E"]
[]
[null,"Location Attribute"]
[null,null,"Question",null,"Answer","Points",null,null,"Question",null,"Answer",null,null,null,"Points"]
[null,null,"Proximity to Human Occupation:",null,4,{"$f":"OFFSET(References!E53,E16-1,0)","v":0},null,null,"Direct run-offs:",null,3,null,null,null,{"$f":"OFFSET(References!E67,K16-1,0)","v":0}]
[]
[null,null,"Assessment under wildlife, countryside or habitats legislation:",null,3,{"$f":"OFFSET(References!E57,E18-1,0)","v":0},null,null,"Air Quality Management Zone:",null,4,null,null,null,{"$f":"OFFSET(References!E70,K18-1,0)","v":0}]
[]
[null,null,"Groundwater/Aquifers:",null,3,{"$f":"OFFSET(References!E60,E20-1,0)","v":0},null,null,"Flood Plain:",null,2,null,null,null,{"$f":"OFFSET(References!E74,K20-1,0)","v":0}]
[]
[null,null,"Sensitivity of surface water:",null,4,{"$f":"OFFSET(References!E63,E22-1,0)","v":0},null,null,null,"Total Points:",{"$f":"SUM(F16:F22,O16:O20)","v":0},null,null,"Band:",{"$f":"IF(Q23=0,\"\",IF(D5=37,\"A\",IF(K22<=4,\"A\",IF(K22<=8,\"B\",IF(K22<=12,\"C\",IF(K22<=18,\"D\",\"E\"))))))","v":""}]
[null,null,null,null,null,null,null,null,"Location Bands are based on total points: 0-4=A, 5-8=B, 9-12=C, 13-18=D, >18=E",null,null,null,null,null,null,null,{"$f":"VALUE('Summary and Calculation'!H13&'Summary and Calculation'!H14&'Summary and Calculation'!H16)","v":0}]

{"sheet":"Operator Performance","index":2,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[[3,2,3,5],[12,2,12,5],[36,3,36,5],[13,4,14,4],[52,3,52,5],[50,2,50,5],[25,2,25,5],[35,2,35,5],[39,3,39,4],[13,5,14,5]]}
[]
[{"$f":"(IF(Complexity_Emissions_Location!F5=0,0,HLOOKUP(Complexity_Emissions_Location!F5,References!$H$8:$O$13,2,FALSE)))","v":0},null,null,"Complexity Band (Activity) Risk Level:",{"$f":"IF(A2>=50,\"HIGH\",IF(A2>=10,\"MEDIUM\",\"LOW\"))","v":"LOW"}]
[]
["Yes",null,"Operations & Maintenance"]
["No",null,1,"Do you have documented operating procedures for operations that may have an adverse impact on the environment?",null,{"$f":"IF(E5=\"yes\",HLOOKUP($E$2,EMS_Score_Card,G5+1,FALSE),0)","v":0},1]
["NA",null,2,"Is there a defined procedure for identifying, reviewing and prioritising items of plant for which a preventative maintenance regime is appropriate?",null,0,2]
[null,null,3,"Are there documented procedures for monitoring emissions or impacts?",null,0,3]
[null,null,4,"Do you have a preventative maintenance programme for items of plant whose failure could lead to impact on the environment? ",null,0,4,"Max = 12"]
[null,null,5,"Does the preventative maintenance programme include regular checks and formal inspections of infrastructure items such as tanks, pipework, retaining walls, bunds and ducts?",null,0,5,"Weight = 20%"]
[null,null,6,"Are the reports, results and recommendations arising from your own audits made available to senior management on a regular basis? ",null,0,6,"Weighted Score"]
[null,null,null,"Operations and Maintenance Total",null,{"$f":"SUM(F5:F10)","v":0},null,{"$f":"(F11/12)*2","v":0}]
[]
[null,null,"Competence and  Training - 20% "]
[null,null,1,"Has a training needs assessment  been carried out which: ",null,{"$f":"IF(E14=\"yes\",HLOOKUP($E$2,EMS_Score_Card,G14+1,FALSE),0)","v":0},7]
[null,null,null,"   Identifies all posts for which specific environmental awareness training is required; and                                                                         Identifies the scope and level to which such training is to be given?"]
[null,null,2,"Are training systems in place for all relevant staff that cover the following factors:"]
[null,null,null,"    the regulatory requirements associated with the Permit as they affect their roles and responsibilities; ",null,{"$f":"IF(E17=\"yes\",HLOOKUP($E$2,EMS_Score_Card,G17+1,FALSE),0)","v":0},8]
[null,null,null,"    likely potential environmental impacts which may be caused by plant under their control. This should cover both normal and abnormal circumstances; ",null,0,9]
[null,null,null,"    reporting procedures to inform supervisors or managers of deviations from  permit conditions;",null,0,10]
[null,null,null,"    procedures to be used by supervisors or managers for the reporting of deviations from permit conditions to the Environment Agency",null,0,11]
[null,null,null,"    prevention of accidental emissions and action to be taken when accidental emissions occur?",null,0,12,"Max = 17"]
[null,null,3,"Do you assess the potential environmental risks posed by the work of contractors and provide instructions to contractors about protecting the environment while working on site?",null,0,13,"Weight = 20%"]
[null,null,4,"If there are industry standards for training in this sector (e.g. WAMITAB) do you apply them? (If no industry standards please leave blank)",null,{"$f":"IF(E23=\"no\",HLOOKUP($E$2,EMS_Score_Card,G23+1,FALSE),0)","v":0},14,"Weighted Score"]
[null,null,null,"Competence Training Total",null,{"$f":"SUM(F14:F23)","v":0},null,{"$f":"(F24/17)*2","v":0}]
[]
[null,null,"Emergency planning - 20% "]
[null,null,1,"Is there an accident plan that complies with guidance covering the following aspects of foreseeable scenarios: likelihood, consequences,actions to prevent, action to take in the event it occurs?",null,{"$f":"IF(E27=\"yes\",HLOOKUP($E$2,EMS_Score_Card,G27+1,FALSE),0)","v":0},15]
[null,null,2,"Has the plan identified areas where improvement is needed? ",null,0,16]
[null,null,3,"Where improvement has been identified, does the plan include an implementation programme with acceptable timescales to the Agency? If not, points will be deducted. ",null,{"$f":"IF(E29=\"no\",HLOOKUP($E$2,EMS_Score_Card,G29+1,FALSE),0)","v":0},17]
[null,null,4,"Do you have written procedures for handling, investigating, communicating and reporting actual or potential non compliance with operating procedures or emission limits?  ",null,0,18]
[null,null,5,"Do you have written procedures for handling, investigating, communicating and reporting environmental complaints?",null,0,19,"Max = 12"]
[null,null,6,"Do you have written procedures for investigating incidents, (and near-misses) including identifying suitable corrective action and following up implementation of that action?",null,0,20,"Weight = 20%"]
[null,null,7,"Do you keep records of investigations into non compliance, complaints and incidents? Do they cover follow up actions? Do audit reports go to senior managers?  ",null,0,21,"Weighted Score"]
[null,null,null,"Emergency planning Total",null,{"$f":"SUM(F27:F33)","v":0},null,{"$f":"(F34/12)*2","v":0}]
[]
[null,null,"Organisation - 40% "]
[null,null,null,"Internal/External Environment Management Systems:\nAnswer either Question 1 or Question 2 \nNB: If  your externally audited system is ISO9001 but you also have an internal environmental management system, you may be able to obtain a better score by providing answers to question 2"]
[null,null,1,"Do you have a certified Environmental Management System, subject to external \naudit, which covers the activities allowed by this permit? If so which one?",1,{"$f":"OFFSET(References!G16,E38,0)","v":0},22]
[null,null,null,"Sub Total",null,{"$f":"MAX(F38:F38)","v":0}]
[null,null,2,"If you do not operate an externally audited environmental management system but have an internal one, assess your system against the criteria below:"]
[null,null,2.1,"Has your company adopted an environmental policy and programme which :    "]
[null,null,null,"   includes a commitment to continual improvement and prevention of pollution?",null,{"$f":"IF(E42=\"yes\",HLOOKUP($E$2,EMS_Score_Card,G42+1,FALSE),0)","v":0},26]
[null,null,null,"   includes a commitment to comply with relevant legislation, and with other requirements that the organisation subscribes to?",null,0,27]
[null,null,null,"   identifies, sets, monitors and reviews environmental objectives, independently of the permit?",null,0,28]
[null,null,2.2000000000000002,"Do you have an environmental policy and programme which is subject to audit by your company?",null,0,29]
[null,null,2.2999999999999998,"Are there annual reports on environmental performance, objectives and targets, future planned improvements and/or do you participate in local community liaison meetings?",null,0,30,"Max = 12"]
[null,null,3,"Does your company produce a public environmental statement?  You may score in this box for ISO 14001 and industry systems but not for EMAS as this is a requirement for EMAS.",null,0,31,"Weight = 40%"]
[null,null,4,"Within the past 5 years have you failed to meet an improvement condition set by the Agency in a Permit or Variation by the due date, without prior agreement? (minus 2 for each failure). ADD NUMBER OF FAILURES NOT Y OR N",null,{"$f":"E48*-2","v":0},32,"Weighted Score"]
[null,null,null,"Organisational Total:",null,{"$f":"IF(F39=20,F39+F48,IF(F39>=12,F39+SUM(F47:F48),IF(SUM(F42:F46)>F39,SUM(F42:F48),F39+SUM(F47:F48))))","v":0},null,{"$f":"(F49/20)*4","v":0}]
[]
[null,null,"Enforcement History (0 to -40% weighting)\n"]
[]
[null,null,null,"Please enter the number of times relevant enforcement actions have been pursued in connection with your site.  Note: the timescales over which action remains relevant depends on the type of enforcement action and is contained in the questions below"]
[null,null,1,"Number of Enforcement, Improvement, Works, Compliance or Restoration Notices issued in the past year by the Environment Agency under any legislation, by the Health and Safety Executive relevant to the COMAH Regulations or by local authorities under Part I of the Environmental Protection Act 1990 or relevant notice or Abatement Notices issued by local authorities or magistrates courts under Part III of the Environmental Protection Act 1990 (in all cases, other than any overturned on appeal by the Operator) ",null,{"$f":"IF(E54=0,\"\",IF(E54=1,-5,IF(E54=2,-10,-40)))","v":""}]
[null,null,2,"Number of Formal Cautions, Enforcement Undertakings or Fixed Monetary Penalties issued by the Environment Agency in respect of offences under relevant legislation in the last 3 years.",null,{"$f":"IF(E55=0,\"\",IF(E55=1,-5,IF(E55=2,-10,-40)))","v":""}]
[null,null,3,"Number of Prohibition, Stop, Suspension or Revocation Notices issued by the Environment Agency under any legislation, by the HSE relevant to the COMAH Regulations or by local authorities under Part I of the Environmental Protection Act 1990, (other than any overturned on appeal by the Operator) in the last 3 years ",null,{"$f":"IF(E56=0,\"\",IF(E56=1,-10,IF(E56=2,-40,-40)))","v":""}]
[null,null,4,"Number of Convictions on prosecutions brought by the Environment Agency under any legislation, by the HSE relevant to the COMAH regulations or by local authorities (in respect of offences under Parts I or III of the Environmental Protection Act 1990) in last 5 years (or 10 years where a term of imprisonment was imposed on the Operator) (other than any overturned on appeal).  Or number of any Variable Monetary Penalties issued.",null,{"$f":"IF(E57=0,\"\",IF(E57=1,-15,IF(E57=2,-40,-40)))","v":""},null,"Max = -40\n\nWeight = 40%\n\nWeighted Score"]
[null,null,null,null,null,{"$f":"SUM(F54:F57)","v":0},null,{"$f":"(F58/40)*4","v":0}]
[]
[null,null,null,null,"Overall Operator Performance Score:",null,null,{"$f":"H11+H24+H34+H49+H58","v":0}]
[]
[null,null,null,"Band E= less than 2  D= 2 to 3.99, C= 4 to 5.99, B= 6 to 7.99 , A= 8 to 11",null,"BAND=",null,{"$f":"IF(H60=0,\"\",IF(H60<2,\"E\",IF(H60<4,\"D\",IF(H60<6,\"C\",IF(H60<8,\"B\",\"A\")))))","v":""}]
[]
[]
[null,null,null,null,"Operator Performance Summary"]
[null,null,null,null,"Operations & Maintenance",null,null,null,{"$f":"H11","v":0}]
[null,null,null,null,"Competence & Training",null,null,null,{"$f":"H24","v":0}]
[null,null,null,null,"Emergency Planning",null,null,null,{"$f":"H34","v":0}]
[null,null,null,null,"Organisation",null,null,null,{"$f":"H49","v":0}]
[null,null,null,null,"Enforcement History",null,null,null,{"$f":"H58","v":0}]
[null,null,null,null,"Overall Weighted Score",null,null,null,{"$f":"H59+H60","v":0}]

{"sheet":"References","index":3,"n_rows":85,"n_cols":15,"rows_kept":85,"cut":false,"hidden":false,"merged":[[20,4,20,5],[11,4,11,6],[12,4,12,6],[16,4,16,5],[17,4,17,5],[18,4,18,5],[7,4,7,6],[8,4,8,6],[10,4,10,6],[9,4,9,6],[19,4,19,5]]}
[]
[null,"Complexity Bands",null,null,"2014/15"]
[null,"   …",null,null,"Charge Multipliers"]
[null,"A01","EEE",null,"App",172,"Nor Var",140,"Full Surr",125,"Part Surr",125]
[null,"A01-Closed","B",null,"Subs","NA"]
[null,"A02","EE"]
[null,"A02-Closed","B",null,"Converting Bands to Opra Score"]
[null,"A03","E",null,"Band",null,null,"A","B","C","D","E","DD","EE","EEE"]
[null,"A03-Closed","B",null,"Complexity",null,null,4,10,35,50,65,100,130,195]
[null,"A04","DD",null,"Emissions",null,null,3,7,15,30,40]
[null,"A04-Closed","B",null,"Location",null,null,1,2,3,5,7]
[null,"A04-Dredgings","B",null,"Op Perf",null,null,2,4,7,10,14]
[null,"A05","C",null,"Compliance Rating",null,null,0.95,1,1.1000000000000001,1.25,1.5,3]
[null,"A05-Closed","A",null,null,"Band",null,"A","B","C","D","E","F"]
[null,"A06","C"]
[null,"A06-Closed","A",null,"EMS",null,"Points"]
[null,"A07","C",null,"No",null,0]
[null,"A07-Closed","A",null,"EMAS",null,20]
[null,"A08","C",null,"ISO14001",null,15]
[null,"A08-Closed","A",null,"Other Accredited",null,12]
[null,"A09 ","D",null,"ISO 9001",null,8]
[null,"A10","B"]
[null,"A11","C"]
[null,"A12","D"]
[null,"A13 (non-haz)","B"]
[null,"A13 (haz)","C"]
[null,"A14","B"]
[null,"A15","A"]
[null,"A16 (non-haz)","A"]
[null,"A16a (haz)","D"]
[null,"A17","E"]
[null,"A18","D"]
[null,"A19","C"]
[null,"A19a","B"]
[null,"A20","C"]
[null,"A21","E"]
[null,"A22","C"]
[null,"A23","C"]
[null,"A24","B"]
[null,"A25","B"]
[null,"A26","n/a"]
[null,"A27","A"]
[null,"A29","B"]
[null,"L05","C"]
[null,"L05-Closed","A"]
[]
[]
[]
[]
[]
[null,"Location Attribute"]
[null,"Qu No","QID","Answer","Score","AnsID"]
[null,1,2,"<50m",5,1,null,"Yes",null,null,"High","Medium","Low",null,"RiskAnswerID"]
[null,1,2,"50m-250m",3,2,null,"No","Ops & Maintenance",1,2,4,4,null,24]
[null,1,2,"250m -1km",1,3,null,"NA",null,2,2,2,2,null,26]
[null,1,2,">1km",0,4,null,null,null,3,2,0,0,null,28]
[null,2,3,"Habitats",3,5,null,null,null,4,2,2,2,null,30]
[null,2,3,"CRoW",2,6,null,null,null,5,2,2,2,null,32]
[null,2,3,"No",0,7,null,null,null,6,2,2,2,null,36]
[null,3,4,"Yes - Within GPZ",2,8,null,null,"Comp & Training",7,3,3,3,null,42]
[null,3,4,"Yes - Outside GPZ",1,9,null,null,null,8,2,2,2,null,44]
[null,3,4,"No",0,10,null,null,null,9,2,2,2,null,46]
[null,4,5,"Grade 5",1,11,null,null,null,10,3,3,3,null,48]
[null,4,5,"Grade 3 or 4",2,12,null,null,null,11,2,2,2,null,50]
[null,4,5,"Grade 1 or 2",3,13,null,null,null,12,2,2,2,null,52]
[null,4,5,"None",0,14,null,null,null,13,3,3,3,null,65]
[null,5,6,"Yes - With interceptors",1,15,null,null,null,14,-2,-2,-2,null,69]
[null,5,6,"Yes - No interceptors",2,16,null,null,null,15,4,6,10,null,73]
[null,5,6,"No",0,17,null,null,null,16,1,2,2,null,75]
[null,6,7,"Yes - and emits declared pollutant",3,18,null,null,null,17,-2,-4,-4,null,77]
[null,6,7,"Within 2km and emits declared pollutant",2,19,null,null,null,18,1,4,0,null,79]
[null,6,7,"Yes - but does not emit declared pollutant",1,20,null,null,null,19,1,0,0,null,81]
[null,6,7,"No",0,21,null,null,null,20,2,0,0,null,83]
[null,7,8,"Yes",2,22,null,null,null,21,3,0,0,null,87]
[null,7,8,"No",0,23,null,null,null,22,20,20,20,null,89]
[null,null,null,null,null,null,null,null,null,23,15,15,15,null,90]
[null,null,null,null,null,null,null,null,null,24,12,12,12,null,91]
[null,null,null,null,null,null,null,null,null,25,8,8,8,null,92]
[null,null,null,null,null,null,null,null,null,26,3,3,3,null,93]
[null,null,null,null,null,null,null,null,null,27,3,3,3,null,95]
[null,null,null,null,null,null,null,null,null,28,3,3,3,null,97]
[null,null,null,null,null,null,null,null,null,29,2,2,2,null,107]
[null,null,null,null,null,null,null,null,null,30,1,1,1,null,111]
[null,null,null,null,null,null,null,null,null,31,1,1,1,null,113]
[null,null,null,null,null,null,null,null,null,32,-2,-2,-2,null,115]

{"sheet":"XML Data","index":4,"n_rows":129,"n_cols":6,"rows_kept":129,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"<?xml version=\"1.0\" encoding=\"utf-8\"?>"]
[null,null,null,null,null,"<CorticonRequest xmlns=\"urn:Corticon\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" decisionServiceName=\"InsertServiceNameHere\">"]
[null,null,null,null,null,"<WorkDocuments>"]
[null,null,null,null,null,"<EPOPRA id=\"EPOPRA_id_1\">"]
[null,null,null,null,null,"<summary>"]
["complexity_1_Band",{"$f":"\"<\"&A6&\">\"","v":"<complexity_1_Band>"},{"$f":"'Summary and Calculation'!F13","v":""},{"$f":"\"</\"&A6&\">\"","v":"</complexity_1_Band>"},null,{"$f":"CONCATENATE(B6,C6,D6)","v":"<complexity_1_Band></complexity_1_Band>"}]
["complexity_2_Band",{"$f":"\"<\"&A7&\">\"","v":"<complexity_2_Band>"},{"$f":"'Summary and Calculation'!G13","v":0},{"$f":"\"</\"&A7&\">\"","v":"</complexity_2_Band>"},null,{"$f":"CONCATENATE(B7,C7,D7)","v":"<complexity_2_Band>0</complexity_2_Band>"}]
["complexity_Score","<complexity_Score>",{"$f":"'Summary and Calculation'!H13","v":0},"</complexity_Score>",null,"<complexity_Score>0</complexity_Score>"]
["emissions_Band","<emissions_Band>",{"$f":"'Summary and Calculation'!F14","v":""},"</emissions_Band>",null,"<emissions_Band></emissions_Band>"]
["emissions_Score","<emissions_Score>",{"$f":"'Summary and Calculation'!H14","v":""},"</emissions_Score>",null,"<emissions_Score></emissions_Score>"]
["location_Band","<location_Band>",{"$f":"'Summary and Calculation'!F15","v":""},"</location_Band>",null,"<location_Band></location_Band>"]
["location_Score","<location_Score>",{"$f":"'Summary and Calculation'!H15","v":""},"</location_Score>",null,"<location_Score></location_Score>"]
["oP_Perf_Band","<oP_Perf_Band>",{"$f":"'Summary and Calculation'!F16","v":""},"</oP_Perf_Band>",null,"<oP_Perf_Band></oP_Perf_Band>"]
["oP_Perf_Score","<oP_Perf_Score>",{"$f":"'Summary and Calculation'!H16","v":""},"</oP_Perf_Score>",null,"<oP_Perf_Score></oP_Perf_Score>"]
["totalOPRAScore","<totalOPRAScore>",{"$f":"'Summary and Calculation'!H17","v":0},"</totalOPRAScore>",null,"<totalOPRAScore>0</totalOPRAScore>"]
["company_Name","<company_Name>",{"$f":"'Summary and Calculation'!I9","v":0},"</company_Name>",null,"<company_Name>0</company_Name>"]
["case_Number","<case_Number>",{"$f":"'Summary and Calculation'!E9","v":0},"</case_Number>",null,"<case_Number>0</case_Number>"]
[null,null,null,null,null,"</summary>"]
[null,null,null,null,null,"<emissions>"]
["wasteInput_Inert_Answer","<wasteInput_Inert_Answer>",{"$f":"Complexity_Emissions_Location!K6","v":0},"</wasteInput_Inert_Answer>",null,"<wasteInput_Inert_Answer>0</wasteInput_Inert_Answer>"]
["wasteInput_NonHazNonBio_Answer","<wasteInput_NonHazNonBio_Answer>",{"$f":"Complexity_Emissions_Location!K7","v":0},"</wasteInput_NonHazNonBio_Answer>",null,"<wasteInput_NonHazNonBio_Answer>0</wasteInput_NonHazNonBio_Answer>"]
["wasteInput_Haz_Answer","<wasteInput_Haz_Answer>",{"$f":"Complexity_Emissions_Location!K8","v":0},"</wasteInput_Haz_Answer>",null,"<wasteInput_Haz_Answer>0</wasteInput_Haz_Answer>"]
["wasteInput_NonHazBio_Answer","<wasteInput_NonHazBio_Answer>",{"$f":"Complexity_Emissions_Location!K9","v":0},"</wasteInput_NonHazBio_Answer>",null,"<wasteInput_NonHazBio_Answer>0</wasteInput_NonHazBio_Answer>"]
["wasteInput_total","<wasteInput_total>",{"$f":"Complexity_Emissions_Location!M10","v":0},"</wasteInput_total>",null,"<wasteInput_total>0</wasteInput_total>"]
["wasteInput_Band","<wasteInput_Band>",{"$f":"Complexity_Emissions_Location!O10","v":""},"</wasteInput_Band>",null,"<wasteInput_Band></wasteInput_Band>"]
[null,null,null,null,null,"</emissions>"]
[null,null,null,null,null,"<complexity>"]
["activity_AType_1","<activity_AType_1>",{"$f":"Complexity_Emissions_Location!D5","v":1},"</activity_AType_1>",null,"<activity_AType_1>1</activity_AType_1>"]
["complexity_Band_1","<complexity_Band_1>",{"$f":"Complexity_Emissions_Location!F5","v":0},"</complexity_Band_1>",null,"<complexity_Band_1>0</complexity_Band_1>"]
["activity_AType_2","<activity_AType_2>",{"$f":"Complexity_Emissions_Location!D7","v":1},"</activity_AType_2>",null,"<activity_AType_2>1</activity_AType_2>"]
["complexity_Band_2","<complexity_Band_2>",{"$f":"Complexity_Emissions_Location!F7","v":0},"</complexity_Band_2>",null,"<complexity_Band_2>0</complexity_Band_2>"]
[null,null,null,null,null,"</complexity>"]
[null,null,null,null,null,"<location>"]
["loc_Human_Answer","<loc_Human_Answer>",{"$f":"Complexity_Emissions_Location!E16","v":4},"</loc_Human_Answer>",null,"<loc_Human_Answer>4</loc_Human_Answer>"]
["loc_Human_Score","<loc_Human_Score>",{"$f":"Complexity_Emissions_Location!F16","v":0},"</loc_Human_Score>",null,"<loc_Human_Score>0</loc_Human_Score>"]
["loc_Habitats_Answer","<loc_Habitats_Answer>",{"$f":"Complexity_Emissions_Location!E18","v":3},"</loc_Habitats_Answer>",null,"<loc_Habitats_Answer>3</loc_Habitats_Answer>"]
["loc_Habitats_Score","<loc_Habitats_Score>",{"$f":"Complexity_Emissions_Location!F18","v":0},"</loc_Habitats_Score>",null,"<loc_Habitats_Score>0</loc_Habitats_Score>"]
["loc_AquGPZ_Answer","<loc_AquGPZ_Answer>",{"$f":"Complexity_Emissions_Location!E20","v":3},"</loc_AquGPZ_Answer>",null,"<loc_AquGPZ_Answer>3</loc_AquGPZ_Answer>"]
["loc_Aqu_Score","<loc_Aqu_Score>",{"$f":"Complexity_Emissions_Location!F20","v":0},"</loc_Aqu_Score>",null,"<loc_Aqu_Score>0</loc_Aqu_Score>"]
["loc_SW_Answer","<loc_SW_Answer>",{"$f":"Complexity_Emissions_Location!E22","v":4},"</loc_SW_Answer>",null,"<loc_SW_Answer>4</loc_SW_Answer>"]
["loc_SW_Score","<loc_SW_Score>",{"$f":"Complexity_Emissions_Location!F22","v":0},"</loc_SW_Score>",null,"<loc_SW_Score>0</loc_SW_Score>"]
["loc_RunOff_Answer","<loc_RunOff_Answer>",{"$f":"Complexity_Emissions_Location!K16","v":3},"</loc_RunOff_Answer>",null,"<loc_RunOff_Answer>3</loc_RunOff_Answer>"]
["loc_RunOff_Score","<loc_RunOff_Score>",{"$f":"Complexity_Emissions_Location!O16","v":0},"</loc_RunOff_Score>",null,"<loc_RunOff_Score>0</loc_RunOff_Score>"]
["loc_AQMZ_Answer","<loc_AQMZ_Answer>",{"$f":"Complexity_Emissions_Location!K18","v":4},"</loc_AQMZ_Answer>",null,"<loc_AQMZ_Answer>4</loc_AQMZ_Answer>"]
["loc_AQMZ_Score","<loc_AQMZ_Score>",{"$f":"Complexity_Emissions_Location!O18","v":0},"</loc_AQMZ_Score>",null,"<loc_AQMZ_Score>0</loc_AQMZ_Score>"]
["loc_FloodPlain_Answer","<loc_FloodPlain_Answer>",{"$f":"Complexity_Emissions_Location!K20","v":2},"</loc_FloodPlain_Answer>",null,"<loc_FloodPlain_Answer>2</loc_FloodPlain_Answer>"]
["loc_FloodPlain_Score","<loc_FloodPlain_Score>",{"$f":"Complexity_Emissions_Location!O20","v":0},"</loc_FloodPlain_Score>",null,"<loc_FloodPlain_Score>0</loc_FloodPlain_Score>"]
["loc_RawScore","<loc_RawScore>",{"$f":"Complexity_Emissions_Location!K22","v":0},"</loc_RawScore>",null,"<loc_RawScore>0</loc_RawScore>"]
["loc_Band","<loc_Band>",{"$f":"Complexity_Emissions_Location!O22","v":""},"</loc_Band>",null,"<loc_Band></loc_Band>"]
[null,null,null,null,null,"</location>"]
[null,null,null,null,null,"<operatorPerformance>"]
["docOpProcs_question1_answer","<docOpProcs_question1_answer>",{"$f":"'Operator Performance'!E5","v":0},"</docOpProcs_question1_answer>",null,"<docOpProcs_question1_answer>0</docOpProcs_question1_answer>"]
["docOpProcs_question1_score","<docOpProcs_question1_score>",{"$f":"'Operator Performance'!F5","v":0},"</docOpProcs_question1_score>",null,"<docOpProcs_question1_score>0</docOpProcs_question1_score>"]
["docOpProcs_question2_answer","<docOpProcs_question2_answer>",{"$f":"'Operator Performance'!E6","v":0},"</docOpProcs_question2_answer>",null,"<docOpProcs_question2_answer>0</docOpProcs_question2_answer>"]
["docOpProcs_question2_score","<docOpProcs_question2_score>",{"$f":"'Operator Performance'!F6","v":0},"</docOpProcs_question2_score>",null,"<docOpProcs_question2_score>0</docOpProcs_question2_score>"]
["docOpProcs_question3_answer","<docOpProcs_question3_answer>",{"$f":"'Operator Performance'!E7","v":0},"</docOpProcs_question3_answer>",null,"<docOpProcs_question3_answer>0</docOpProcs_question3_answer>"]
["docOpProcs_question3_score","<docOpProcs_question3_score>",{"$f":"'Operator Performance'!F7","v":0},"</docOpProcs_question3_score>",null,"<docOpProcs_question3_score>0</docOpProcs_question3_score>"]
["docOpProcs_question4_answer","<docOpProcs_question4_answer>",{"$f":"'Operator Performance'!E8","v":0},"</docOpProcs_question4_answer>",null,"<docOpProcs_question4_answer>0</docOpProcs_question4_answer>"]
["docOpProcs_question4_score","<docOpProcs_question4_score>",{"$f":"'Operator Performance'!F8","v":0},"</docOpProcs_question4_score>",null,"<docOpProcs_question4_score>0</docOpProcs_question4_score>"]
["docOpProcs_question5_answer","<docOpProcs_question5_answer>",{"$f":"'Operator Performance'!E9","v":0},"</docOpProcs_question5_answer>",null,"<docOpProcs_question5_answer>0</docOpProcs_question5_answer>"]
["docOpProcs_question5_score","<docOpProcs_question5_score>",{"$f":"'Operator Performance'!F9","v":0},"</docOpProcs_question5_score>",null,"<docOpProcs_question5_score>0</docOpProcs_question5_score>"]
["docOpProcs_question7_answer","<docOpProcs_question7_answer>",{"$f":"'Operator Performance'!E10","v":0},"</docOpProcs_question7_answer>",null,"<docOpProcs_question7_answer>0</docOpProcs_question7_answer>"]
["docOpProcs_question7_score","<docOpProcs_question7_score>",{"$f":"'Operator Performance'!F10","v":0},"</docOpProcs_question7_score>",null,"<docOpProcs_question7_score>0</docOpProcs_question7_score>"]
["trainingAssessment_question1_answer","<trainingAssessment_question1_answer>",{"$f":"'Operator Performance'!E14","v":0},"</trainingAssessment_question1_answer>",null,"<trainingAssessment_question1_answer>0</trainingAssessment_question1_answer>"]
["trainingAssessment_question1_score","<trainingAssessment_question1_score>",{"$f":"'Operator Performance'!F14","v":0},"</trainingAssessment_question1_score>",null,"<trainingAssessment_question1_score>0</trainingAssessment_question1_score>"]
["trainingAssessment_question2a_answer","<trainingAssessment_question2a_answer>",{"$f":"'Operator Performance'!E17","v":0},"</trainingAssessment_question2a_answer>",null,"<trainingAssessment_question2a_answer>0</trainingAssessment_question2a_answer>"]
["trainingAssessment_question2a_score","<trainingAssessment_question2a_score>",{"$f":"'Operator Performance'!F17","v":0},"</trainingAssessment_question2a_score>",null,"<trainingAssessment_question2a_score>0</trainingAssessment_question2a_score>"]
["trainingAssessment_question2b_answer","<trainingAssessment_question2b_answer>",{"$f":"'Operator Performance'!E18","v":0},"</trainingAssessment_question2b_answer>",null,"<trainingAssessment_question2b_answer>0</trainingAssessment_question2b_answer>"]
["trainingAssessment_question2b_score","<trainingAssessment_question2b_score>",{"$f":"'Operator Performance'!F18","v":0},"</trainingAssessment_question2b_score>",null,"<trainingAssessment_question2b_score>0</trainingAssessment_question2b_score>"]
["trainingAssessment_question2c_answer","<trainingAssessment_question2c_answer>",{"$f":"'Operator Performance'!E19","v":0},"</trainingAssessment_question2c_answer>",null,"<trainingAssessment_question2c_answer>0</trainingAssessment_question2c_answer>"]
["trainingAssessment_question2c_score","<trainingAssessment_question2c_score>",{"$f":"'Operator Performance'!F19","v":0},"</trainingAssessment_question2c_score>",null,"<trainingAssessment_question2c_score>0</trainingAssessment_question2c_score>"]
["trainingAssessment_question2d_answer","<trainingAssessment_question2d_answer>",{"$f":"'Operator Performance'!E20","v":0},"</trainingAssessment_question2d_answer>",null,"<trainingAssessment_question2d_answer>0</trainingAssessment_question2d_answer>"]
["trainingAssessment_question2d_score","<trainingAssessment_question2d_score>",{"$f":"'Operator Performance'!F20","v":0},"</trainingAssessment_question2d_score>",null,"<trainingAssessment_question2d_score>0</trainingAssessment_question2d_score>"]
["trainingAssessment_question2eanswer","<trainingAssessment_question2eanswer>",{"$f":"'Operator Performance'!E21","v":0},"</trainingAssessment_question2eanswer>",null,"<trainingAssessment_question2eanswer>0</trainingAssessment_question2eanswer>"]
["trainingAssessment_question2escore","<trainingAssessment_question2escore>",{"$f":"'Operator Performance'!F21","v":0},"</trainingAssessment_question2escore>",null,"<trainingAssessment_question2escore>0</trainingAssessment_question2escore>"]
["trainingAssessment_question5_answer","<trainingAssessment_question5_answer>",{"$f":"'Operator Performance'!E22","v":0},"</trainingAssessment_question5_answer>",null,"<trainingAssessment_question5_answer>0</trainingAssessment_question5_answer>"]
["trainingAssessment_question5_score","<trainingAssessment_question5_score>",{"$f":"'Operator Performance'!F22","v":0},"</trainingAssessment_question5_score>",null,"<trainingAssessment_question5_score>0</trainingAssessment_question5_score>"]
["trainingAssessment_question7_answer","<trainingAssessment_question7_answer>",{"$f":"'Operator Performance'!E23","v":0},"</trainingAssessment_question7_answer>",null,"<trainingAssessment_question7_answer>0</trainingAssessment_question7_answer>"]
["trainingAssessment_question7_score",{"$f":"\"<\"&A79&\">\"","v":"<trainingAssessment_question7_score>"},{"$f":"'Operator Performance'!F23","v":0},{"$f":"\"</\"&A79&\">\"","v":"</trainingAssessment_question7_score>"},null,{"$f":"CONCATENATE(B79,C79,D79)","v":"<trainingAssessment_question7_score>0</trainingAssessment_question7_score>"}]
["accidentPlan_question1_answer","<accidentPlan_question1_answer>",{"$f":"'Operator Performance'!E27","v":0},"</accidentPlan_question1_answer>",null,"<accidentPlan_question1_answer>0</accidentPlan_question1_answer>"]
["accidentPlan_question1_score","<accidentPlan_question1_score>",{"$f":"'Operator Performance'!F27","v":0},"</accidentPlan_question1_score>",null,"<accidentPlan_question1_score>0</accidentPlan_question1_score>"]
["accidentPlan_question2_answer","<accidentPlan_question2_answer>",{"$f":"'Operator Performance'!E28","v":0},"</accidentPlan_question2_answer>",null,"<accidentPlan_question2_answer>0</accidentPlan_question2_answer>"]
["accidentPlan_question2_score","<accidentPlan_question2_score>",{"$f":"'Operator Performance'!F28","v":0},"</accidentPlan_question2_score>",null,"<accidentPlan_question2_score>0</accidentPlan_question2_score>"]
["accidentPlan_question3_answer","<accidentPlan_question3_answer>",{"$f":"'Operator Performance'!E29","v":0},"</accidentPlan_question3_answer>",null,"<accidentPlan_question3_answer>0</accidentPlan_question3_answer>"]
["accidentPlan_question3_score","<accidentPlan_question3_score>",{"$f":"'Operator Performance'!F29","v":0},"</accidentPlan_question3_score>",null,"<accidentPlan_question3_score>0</accidentPlan_question3_score>"]
["accidentPlan_question4_answer","<accidentPlan_question4_answer>",{"$f":"'Operator Performance'!E30","v":0},"</accidentPlan_question4_answer>",null,"<accidentPlan_question4_answer>0</accidentPlan_question4_answer>"]
["accidentPlan_question4_score","<accidentPlan_question4_score>",{"$f":"'Operator Performance'!F30","v":0},"</accidentPlan_question4_score>",null,"<accidentPlan_question4_score>0</accidentPlan_question4_score>"]
["accidentPlan_question5_answer","<accidentPlan_question5_answer>",{"$f":"'Operator Performance'!E31","v":0},"</accidentPlan_question5_answer>",null,"<accidentPlan_question5_answer>0</accidentPlan_question5_answer>"]
["accidentPlan_question5_score","<accidentPlan_question5_score>",{"$f":"'Operator Performance'!F31","v":0},"</accidentPlan_question5_score>",null,"<accidentPlan_question5_score>0</accidentPlan_question5_score>"]
["accidentPlan_question6_answer","<accidentPlan_question6_answer>",{"$f":"'Operator Performance'!E32","v":0},"</accidentPlan_question6_answer>",null,"<accidentPlan_question6_answer>0</accidentPlan_question6_answer>"]
["accidentPlan_question6_score","<accidentPlan_question6_score>",{"$f":"'Operator Performance'!F32","v":0},"</accidentPlan_question6_score>",null,"<accidentPlan_question6_score>0</accidentPlan_question6_score>"]
["accidentPlan_question8_answer","<accidentPlan_question8_answer>",{"$f":"'Operator Performance'!E33","v":0},"</accidentPlan_question8_answer>",null,"<accidentPlan_question8_answer>0</accidentPlan_question8_answer>"]
["accidentPlan_question8_score","<accidentPlan_question8_score>",{"$f":"'Operator Performance'!F33","v":0},"</accidentPlan_question8_score>",null,"<accidentPlan_question8_score>0</accidentPlan_question8_score>"]
["organisation_question1part1_answer","<organisation_question1part1_answer>",{"$f":"'Operator Performance'!E38","v":1},"</organisation_question1part1_answer>",null,"<organisation_question1part1_answer>1</organisation_question1part1_answer>"]
["organisation_question1part1_score","<organisation_question1part1_score>",{"$f":"'Operator Performance'!F38","v":0},"</organisation_question1part1_score>",null,"<organisation_question1part1_score>0</organisation_question1part1_score>"]
["organisation_question1part2_answer","<organisation_question1part2_answer>",{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},"</organisation_question1part2_answer>",null,{"$error":"#REF!"}]
["organisation_question1part2_score","<organisation_question1part2_score>",{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},"</organisation_question1part2_score>",null,{"$error":"#REF!"}]
["organisation_question1part3_answer","<organisation_question1part3_answer>",{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},"</organisation_question1part3_answer>",null,{"$error":"#REF!"}]
["organisation_question1part3_score","<organisation_question1part3_score>",{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},"</organisation_question1part3_score>",null,{"$error":"#REF!"}]
["organisation_question1part4_answer","<organisation_question1part4_answer>",{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},"</organisation_question1part4_answer>",null,{"$error":"#REF!"}]
["organisation_question1part4_score","<organisation_question1part4_score>",{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},"</organisation_question1part4_score>",null,{"$error":"#REF!"}]
["organisation_question2_answer","<organisation_question2_answer>",{"$f":"'Operator Performance'!E42","v":0},"</organisation_question2_answer>",null,"<organisation_question2_answer>0</organisation_question2_answer>"]
["organisation_question2_score","<organisation_question2_score>",{"$f":"'Operator Performance'!F42","v":0},"</organisation_question2_score>",null,"<organisation_question2_score>0</organisation_question2_score>"]
["organisation_question3_answer","<organisation_question3_answer>",{"$f":"'Operator Performance'!E43","v":0},"</organisation_question3_answer>",null,"<organisation_question3_answer>0</organisation_question3_answer>"]
["organisation_question3_score","<organisation_question3_score>",{"$f":"'Operator Performance'!F43","v":0},"</organisation_question3_score>",null,"<organisation_question3_score>0</organisation_question3_score>"]
["organisation_question4_answer","<organisation_question4_answer>",{"$f":"'Operator Performance'!E47","v":0},"</organisation_question4_answer>",null,"<organisation_question4_answer>0</organisation_question4_answer>"]
["organisation_question4_score","<organisation_question4_score>",{"$f":"'Operator Performance'!F47","v":0},"</organisation_question4_score>",null,"<organisation_question4_score>0</organisation_question4_score>"]
["organisation_question5_answer","<organisation_question5_answer>",{"$f":"'Operator Performance'!E48","v":0},"</organisation_question5_answer>",null,"<organisation_question5_answer>0</organisation_question5_answer>"]
["organisation_question5_score","<organisation_question5_score>",{"$f":"'Operator Performance'!F48","v":0},"</organisation_question5_score>",null,"<organisation_question5_score>0</organisation_question5_score>"]
["enfNotice_answer","<enfNotice_answer>",{"$f":"'Operator Performance'!E49","v":0},"</enfNotice_answer>",null,"<enfNotice_answer>0</enfNotice_answer>"]
["enfNotice_score","<enfNotice_score>",{"$f":"'Operator Performance'!F49","v":0},"</enfNotice_score>",null,"<enfNotice_score>0</enfNotice_score>"]
["caution_answer","<caution_answer>",{"$f":"'Operator Performance'!E50","v":0},"</caution_answer>",null,"<caution_answer>0</caution_answer>"]
["caution_score","<caution_score>",{"$f":"'Operator Performance'!F50","v":0},"</caution_score>",null,"<caution_score>0</caution_score>"]
["prohibit_answer","<prohibit_answer>",{"$f":"'Operator Performance'!E51","v":0},"</prohibit_answer>",null,"<prohibit_answer>0</prohibit_answer>"]
["prohibit_score","<prohibit_score>",{"$f":"'Operator Performance'!F51","v":0},"</prohibit_score>",null,"<prohibit_score>0</prohibit_score>"]
["prosecution_answer","<prosecution_answer>",{"$f":"'Operator Performance'!E53","v":0},"</prosecution_answer>",null,"<prosecution_answer>0</prosecution_answer>"]
["prosecution_score","<prosecution_score>",{"$f":"'Operator Performance'!F53","v":0},"</prosecution_score>",null,"<prosecution_score>0</prosecution_score>"]
[null,null,null,null,null,"</operatorPerformance>"]
[null,null,null,null,null,"<compliance>"]
["cat1Events","<cat1Events>",null,{"$f":"\"</\"&A120&\">\"","v":"</cat1Events>"},null,{"$f":"CONCATENATE(B120,C120,D120)","v":"<cat1Events></cat1Events>"}]
["cat2Events","<cat2Events>",null,"</cat2Events>",null,"<cat2Events></cat2Events>"]
["cat3Events","<cat3Events>",null,"</cat3Events>",null,"<cat3Events></cat3Events>"]
["cat4Events","<cat4Events>",null,"</cat4Events>",null,"<cat4Events></cat4Events>"]
["complianceIndex","<complianceIndex>",null,"</complianceIndex>",null,"<complianceIndex></complianceIndex>"]
["complianceBand","<complianceBand>",null,"</complianceBand>",null,"<complianceBand></complianceBand>"]
[null,null,null,null,null,"</compliance>"]
[null,null,null,null,null,"</EPOPRA>"]
[null,null,null,null,null,"</WorkDocuments>"]
[null,null,null,null,null,"</CorticonRequest>"]

{"sheet":"ProfileHeader","index":5,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Profile Header"]
["ProfileID","MajVersionNo","CompletionDate","WML","Complexity1","Complexity2","LocationScore","EmissionIndex","OPScore","CompBand1","CompBand2","LocationBand","EmissionsBand","OPPerfBand","CompRating","EPOPRAScore","Status"]
[{"$f":"('Summary and Calculation'!E9*100000)+('Summary and Calculation'!E9 *RAND())","v":0},3,{"$f":"TODAY()","v":43525},{"$f":"'Summary and Calculation'!E9","v":0},{"$f":"OFFSET(References!B2,Complexity_Emissions_Location!D5,0)","v":"   …"},{"$f":"OFFSET(References!B2,Complexity_Emissions_Location!D7,0)","v":"   …"},{"$f":"Complexity_Emissions_Location!K22","v":0},{"$f":"Complexity_Emissions_Location!M10","v":0},{"$f":"'Operator Performance'!H60","v":0},{"$f":"'Summary and Calculation'!F13","v":""},{"$f":"'Summary and Calculation'!G13","v":0},{"$f":"'Summary and Calculation'!F15","v":""},{"$f":"'Summary and Calculation'!F14","v":""},{"$f":"'Summary and Calculation'!F16","v":""},null,{"$f":"'Summary and Calculation'!H17","v":0}]

{"sheet":"ProfileDetail","index":6,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["ID","ProfileID","QID","AnsID","AnsText","AnsScore"]
[{"$f":"FIXED(10000000000*RAND(),0,TRUE)","v":"9736754671"},{"$f":"ProfileHeader!$A$3","v":0},2,{"$f":"OFFSET(References!F$53,Complexity_Emissions_Location!E16-1,0)","v":4},{"$f":"OFFSET(References!D$53,Complexity_Emissions_Location!E16-1,0)","v":">1km"},{"$f":"OFFSET(References!E$53,Complexity_Emissions_Location!E16-1,0)","v":0}]
[{"$f":"FIXED(10000000000*RAND(),0,TRUE)","v":"4881099530"},{"$f":"ProfileHeader!$A$3","v":0},3,{"$f":"OFFSET(References!F$57,Complexity_Emissions_Location!E18-1,0)","v":7},{"$f":"OFFSET(References!D$57,Complexity_Emissions_Location!E18-1,0)","v":"No"},{"$f":"OFFSET(References!E$57,Complexity_Emissions_Location!E18-1,0)","v":0}]
["5026153071",{"$f":"ProfileHeader!$A$3","v":0},4,{"$f":"OFFSET(References!F$60,Complexity_Emissions_Location!E20-1,0)","v":10},{"$f":"OFFSET(References!D$60,Complexity_Emissions_Location!E20-1,0)","v":"No"},{"$f":"OFFSET(References!E$60,Complexity_Emissions_Location!E20-1,0)","v":0}]
["1107603317",{"$f":"ProfileHeader!$A$3","v":0},5,{"$f":"OFFSET(References!F$63,Complexity_Emissions_Location!E22-1,0)","v":14},{"$f":"OFFSET(References!D$63,Complexity_Emissions_Location!E22-1,0)","v":"None"},{"$f":"OFFSET(References!E$63,Complexity_Emissions_Location!E22-1,0)","v":0}]
["3395907729",{"$f":"ProfileHeader!$A$3","v":0},6,{"$f":"OFFSET(References!F$67,Complexity_Emissions_Location!K16-1,0)","v":17},{"$f":"OFFSET(References!D$67,Complexity_Emissions_Location!K16-1,0)","v":"No"},{"$f":"OFFSET(References!E$67,Complexity_Emissions_Location!K16-1,0)","v":0}]
["9063909293",{"$f":"ProfileHeader!$A$3","v":0},7,{"$f":"OFFSET(References!F$70,Complexity_Emissions_Location!K18-1,0)","v":21},{"$f":"OFFSET(References!D$70,Complexity_Emissions_Location!K18-1,0)","v":"No"},{"$f":"OFFSET(References!E$70,Complexity_Emissions_Location!K18-1,0)","v":0}]
["3319719718",{"$f":"ProfileHeader!$A$3","v":0},8,{"$f":"OFFSET(References!F$74,Complexity_Emissions_Location!K20-1,0)","v":23},{"$f":"OFFSET(References!D$74,Complexity_Emissions_Location!K20-1,0)","v":"No"},{"$f":"OFFSET(References!E$74,Complexity_Emissions_Location!K20-1,0)","v":0}]
["3884026195",{"$f":"ProfileHeader!$A$3","v":0},60,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G5-1,0)","v":24},{"$f":"'Operator Performance'!E5","v":0},{"$f":"'Operator Performance'!F5","v":0}]
["2965471959",{"$f":"ProfileHeader!$A$3","v":0},61,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G6-1,0)","v":26},{"$f":"'Operator Performance'!E6","v":0},{"$f":"'Operator Performance'!F6","v":0}]
["5083624227",{"$f":"ProfileHeader!$A$3","v":0},62,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G7-1,0)","v":28},{"$f":"'Operator Performance'!E7","v":0},{"$f":"'Operator Performance'!F7","v":0}]
["8031832752",{"$f":"ProfileHeader!$A$3","v":0},63,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G8-1,0)","v":30},{"$f":"'Operator Performance'!E8","v":0},{"$f":"'Operator Performance'!F8","v":0}]
[{"$f":"FIXED(10000000000*RAND(),0,TRUE)","v":"3426336424"},{"$f":"ProfileHeader!$A$3","v":0},64,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G9-1,0)","v":32},{"$f":"'Operator Performance'!E9","v":0},{"$f":"'Operator Performance'!F9","v":0}]
["675283787",{"$f":"ProfileHeader!$A$3","v":0},66,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G10-1,0)","v":36},{"$f":"'Operator Performance'!E10","v":0},{"$f":"'Operator Performance'!F10","v":0}]
["5112159031",{"$f":"ProfileHeader!$A$3","v":0},69,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G14-1,0)","v":42},{"$f":"'Operator Performance'!E14","v":0},{"$f":"'Operator Performance'!F14","v":0}]
["7853692343",{"$f":"ProfileHeader!$A$3","v":0},70,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G17-1,0)","v":44},{"$f":"'Operator Performance'!E17","v":0},{"$f":"'Operator Performance'!F17","v":0}]
["7181489678",{"$f":"ProfileHeader!$A$3","v":0},71,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G18-1,0)","v":46},{"$f":"'Operator Performance'!E18","v":0},{"$f":"'Operator Performance'!F18","v":0}]
["6659573943",{"$f":"ProfileHeader!$A$3","v":0},72,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G19-1,0)","v":48},{"$f":"'Operator Performance'!E19","v":0},{"$f":"'Operator Performance'!F19","v":0}]
["5473231441",{"$f":"ProfileHeader!$A$3","v":0},73,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G20-1,0)","v":50},{"$f":"'Operator Performance'!E20","v":0},{"$f":"'Operator Performance'!F20","v":0}]
["1757220321",{"$f":"ProfileHeader!$A$3","v":0},74,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G21-1,0)","v":52},{"$f":"'Operator Performance'!E21","v":0},{"$f":"'Operator Performance'!F21","v":0}]
["1057762411",{"$f":"ProfileHeader!$A$3","v":0},77,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G22-1,0)","v":65},{"$f":"'Operator Performance'!E22","v":0},{"$f":"'Operator Performance'!F22","v":0}]
["3295767608",{"$f":"ProfileHeader!$A$3","v":0},79,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G23-1,0)","v":69},{"$f":"'Operator Performance'!E23","v":0},{"$f":"'Operator Performance'!F23","v":0}]
["8650879410",{"$f":"ProfileHeader!$A$3","v":0},80,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G27-1,0)","v":73},{"$f":"'Operator Performance'!E27","v":0},{"$f":"'Operator Performance'!F27","v":0}]
["1773195722",{"$f":"ProfileHeader!$A$3","v":0},81,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G28-1,0)","v":75},{"$f":"'Operator Performance'!E28","v":0},{"$f":"'Operator Performance'!F28","v":0}]
["2950483229",{"$f":"ProfileHeader!$A$3","v":0},82,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G29-1,0)","v":77},{"$f":"'Operator Performance'!E29","v":0},{"$f":"'Operator Performance'!F29","v":0}]
["2532366238",{"$f":"ProfileHeader!$A$3","v":0},83,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G30-1,0)","v":79},{"$f":"'Operator Performance'!E30","v":0},{"$f":"'Operator Performance'!F30","v":0}]
["4918274393",{"$f":"ProfileHeader!$A$3","v":0},84,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G31-1,0)","v":81},{"$f":"'Operator Performance'!E31","v":0},{"$f":"'Operator Performance'!F31","v":0}]
["6600023300",{"$f":"ProfileHeader!$A$3","v":0},85,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G32-1,0)","v":83},{"$f":"'Operator Performance'!E32","v":0},{"$f":"'Operator Performance'!F32","v":0}]
["8114384039",{"$f":"ProfileHeader!$A$3","v":0},86,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G33-1,0)","v":87},{"$f":"'Operator Performance'!E33","v":0},{"$f":"'Operator Performance'!F33","v":0}]
["5969472547",{"$f":"ProfileHeader!$A$3","v":0},88,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G38-1,0)","v":89},{"$f":"'Operator Performance'!E38","v":1},{"$f":"'Operator Performance'!F38","v":0}]
["6299239138",{"$f":"ProfileHeader!$A$3","v":0},89,{"$f":"OFFSET(References!$O$54,'Operator Performance'!#REF!-1,0)","v":{"$error":"#REF!"}},{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}}]
["4220974073",{"$f":"ProfileHeader!$A$3","v":0},90,{"$f":"OFFSET(References!$O$54,'Operator Performance'!#REF!-1,0)","v":{"$error":"#REF!"}},{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}}]
["3573619477",{"$f":"ProfileHeader!$A$3","v":0},91,{"$f":"OFFSET(References!$O$54,'Operator Performance'!#REF!-1,0)","v":{"$error":"#REF!"}},{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Operator Performance'!#REF!","v":{"$error":"#REF!"}}]
["4378970913",{"$f":"ProfileHeader!$A$3","v":0},92,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G42-1,0)","v":93},{"$f":"'Operator Performance'!E42","v":0},{"$f":"'Operator Performance'!F42","v":0}]
["3655535598",{"$f":"ProfileHeader!$A$3","v":0},97,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G43-1,0)","v":95},{"$f":"'Operator Performance'!E43","v":0},{"$f":"'Operator Performance'!F43","v":0}]
["5701816723",{"$f":"ProfileHeader!$A$3","v":0},99,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G44-1,0)","v":97},{"$f":"'Operator Performance'!E44","v":0},{"$f":"'Operator Performance'!F44","v":0}]
["7826293609",{"$f":"ProfileHeader!$A$3","v":0},100,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G45-1,0)","v":107},{"$f":"'Operator Performance'!E45","v":0},{"$f":"'Operator Performance'!F45","v":0}]
["9961780648",{"$f":"ProfileHeader!$A$3","v":0},101,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G46-1,0)","v":111},{"$f":"'Operator Performance'!E46","v":0},{"$f":"'Operator Performance'!F46","v":0}]
["2180275067",{"$f":"ProfileHeader!$A$3","v":0},102,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G47-1,0)","v":113},{"$f":"'Operator Performance'!E47","v":0},{"$f":"'Operator Performance'!F47","v":0}]
["487884378",{"$f":"ProfileHeader!$A$3","v":0},103,{"$f":"OFFSET(References!$O$54,'Operator Performance'!G48-1,0)","v":115},{"$f":"'Operator Performance'!E48","v":0},{"$f":"'Operator Performance'!F48","v":0}]