{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover","Assessment","Results","Definitions","<Test>","AnnexVI","PickLists","GHG_Lookup","Env Score","Eco Score","Soc Score"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":45,"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":"Cover","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Biomass Sustainability Framework Assessment"]
[]
[null,"Version 1.1"]
[]
[null,"2020-05-15"]
[]
[null,"Sustainable Energy Authority of Ireland"]
[null,"SEAI is Ireland’s national energy authority investing in, and delivering, appropriate, effective and sustainable solutions to help Ireland’s transition to a clean energy future. We work with Government, homeowners, businesses and communities to achieve this, through expertise, funding, educational programmes, policy advice, research and the development of new technologies. SEAI is part-financed by Ireland’s EU Structural Funds Programme co-funded by the Irish Government and the European Union."]
[]
[null,"Acknowledgements"]
[null,"The Sustainability Framework Assessment was commissioned by SEAI and prepared Byrne Ó Cléirigh."]
[]
[null,"© Sustainable Energy Authority of Ireland"]
[null,"Reproduction of the contents is permissible provided the source is acknowledged."]
[]
[null,"Guidance"]
[null,"The Sustainability Framework Assessment spreadsheet is designed to assess the sustainability risk of biomass fuel; it is not suitable for the assessing biofuels or bioliquids."]
[null,"The framework is built on a 'decision tree' approach, whereby answering specific questions determines where the risks may lie; it is designed to:\n1. examine biomass sustainability under the RED II criteria and then, contingent on meeting the RED II sustainability criteria,\n2. identify other potential sustainability risks (categorised as environmental, economic or social indicators)."]
[null,"Unless otherwise stated, all references to articles and annexes refer to those contained in Directive (EU) 2018/2001 of the European Parliament and of the Council of 11 December 2018 on the promotion of the use of energy from renewable sources (recast) (RED II)."]
[null,"Please refer to the accompanying report for further guidance: Sustainability Criteria Options and Impacts for Irish Bioenergy Resources, commissioned by SEAI, prepared by Byrne Ó Cléirigh and Navigant, 2018:"]
[null,"https://www.seai.ie/sustainable-solutions/renewable-energy/bioenergy/sustainability-criteria-o/"]
[]
[null,">>> Go to assessment"]

{"sheet":"Assessment","index":1,"n_rows":230,"n_cols":9,"rows_kept":230,"cut":false,"hidden":false,"merged":[[148,0,228,0],[32,2,32,6],[10,2,10,6],[13,2,13,6],[14,5,14,6],[15,5,17,6],[12,2,12,6],[4,0,22,0],[23,0,147,0],[33,2,33,6],[11,2,11,5],[157,2,158,2],[157,4,158,4],[8,2,8,6],[5,2,5,6]]}
[]
[null,null,"Biomass Sustainability Framework  Assessment"]
[]
[null,"Show","No.","Condition","Question","Answer","Comment","PickList","Blank text"]
["Guidance",1]
[null,1,"The recast Renewable Energy Directive (RED II) sets out the EU's scheme for the promotion of energy from renewable resources and a binding EU-wide target for the overall share of energy from renewable sources in gross final consumption of energy in 2030."]
[null,1,{"$f":"HYPERLINK(\"https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=uriserv:OJ.L_.2018.328.01.0082.01.ENG\",\">>> Directive (EU) 2018/2001 of the European Parliament and of the Council of 11 December 2018 on the promotion of the use of energy from renewable sources (recast)\")","v":">>> Directive (EU) 2018/2001 of the European Parliament and of the Council of 11 December 2018 on the promotion of the use of energy from renewable sources (recast)"}]
[null,1]
[null,1,"From 2021, biomass fuels must meet the environmental sustainability criteria set out in RED II (Article 29) in order to contribute towards the renewable energy target or qualify for financial support from a Member State.  However, there are other factors that could be considered when assessing the sustainability of a biomass fuel that go beyond the environmental criteria set out in RED II, and include economic and social criteria. "]
[null,1]
[null,1,"In this context, SEAI developed this framework for assessing sustainabilty risk.  The framework is built on a 'decision tree' approach, whereby answering specific questions determines where the risks may lie.  Please refer to the accompanying report for further guidance, Sustainability Criteria Options and Impacts for Irish Bioenergy Resources, commissioned by SEAI, prepared by Byrne Ó Cléirigh and Navigant, 2018:"]
[null,1,"https://www.seai.ie/sustainable-solutions/renewable-energy/bioenergy/sustainability-criteria-o/"]
[null,1]
[null,1,"The Sustainability Framework Assessment consists of four sections which the user must complete in turn."]
[null,1,1,null,"Sustainability under RED II","This section guides the user in assessing a biomass fuel against the sustainability criteria of RED II.  At a minimum, the biomass fuel must meet the RED II criteria in order to continue with the assessment."]
[null,1,2,null,{"$f":"E149","v":"Environmental Indicators"},"These sections aid the user in examining additional sustainability and identifying where sustainability risks may exist, which is more subjective than examing the RED II requirements. Based on the answers to the questions in these sections, a score is assigned under each indicator."]
[null,1,3,null,{"$f":"E186","v":"Economic Indicators"}]
[null,1,4,null,{"$f":"E215","v":"Social Indicators"}]
[null,1]
[null,1,"This framework is not a legal interpretation of RED II."]
[null,1,"The results of an assessment conducted using this framework should not be interpreted as SEAI’s position on the sustainability of a biomass fuel."]
[null,1]
[null,1]
["RED II Assessment",1,1,null,"Sustainability under RED II"]
[null,1,1.1000000000000001,null,"Introduction"]
[null,1]
[null,1,"1.1.1","Always","Is the biomass fuel a solid or gas?","-- Select from dropdown --","-","SolGas","-- Select from dropdown --"]
[null,{"$f":"B29","v":0},"<BLANK>","If below is on"]
[null,{"$f":"IF(OR(ISBLANK(F27),NOT(ISERROR(FIND(\"--\",F27)))),0,1)","v":0},"1.1.2","Q1.1.1 <> BLANK","The biomass feedstock is produced from:","-- Select from dropdown --","'Residue*' excludes residues arising directly from agricutural, aquaculture, fisheries and forestry residues, but includes residues from related industries or processing (e.g. sawmill residue).\n'Waste' includes any waste that may arise from agriculture or forestry (e.g. wet manure).\nResidues that arise directly from agriculture or forestry are included in agriculture and forestry, respectively.","Source","-- Select from dropdown --"]
[null,1,null,"Always on"]
[null,1,1.2,null,"GHG Savings"]
[null,1,"<BLANK>","Always on"]
[null,1,"All biomass fuels must achieve a GHG savings of at least 70%.  The feedstock from which the biomass fuel is produced is critical to determining the GHG savings.  Annex VI of RED II is central to determining GHG savings and it includes a selection of 'default' values, i.e. values that have already been determined by the Commission, for a range of biomasss fuel pathways.  The framework model will use default values where available. "]
[null,1,"The framework also contains 'indicative' values for GHG savings for selected biomass fuel chains (e.g. grass silage, wet manure, willow, imported and domestic residues) in an Irish context, which do not appear in RED II.  The indicative GHG savings have been calculated based on various assumptions regarding the biomass fuel production pathway and should be treated as informative only; they are denoted by 'IE - indicative' in the feedstock drop-down menu below.  The indicative savings were calculated as part of the accompanying work commissioned by SEAI, Sustainability Criteria Options and Impacts for Irish Bioenergy Resources:"]
[null,1,"https://www.seai.ie/sustainable-solutions/renewable-energy/bioenergy/sustainability-criteria-o/"]
[null,1]
[null,0,"1.2.1.0","Hidden","Feedstock:",{"$f":"IFERROR(INDEX($F$38:$F$44,MATCH(1,$B$38:$B$44,0)),0)","v":0}]
[null,{"$f":"--AND(OR($F$29=PickLists!$C$2,$F$29=PickLists!$C$3),$F$27=PickLists!$B$2)","v":0},"1.2.1.1","1.1.2=Waste/residue AND 1.1.1=Solid","Feedstock:","-- Select from dropdown --","Sawmill residue is an example of a wood industry residue.","WR_Solid_Feed","-- Select from dropdown --"]
[null,{"$f":"--AND(OR($F$29=PickLists!$C$2,$F$29=PickLists!$C$3),$F$27=PickLists!$B$3)","v":0},"1.2.1.2","1.1.2=Waste/residue AND 1.1.1=Gaseous","Feedstock:","-- Select from dropdown --","* Biowaste as defined in the Waste Framework Directive: biodegradable garden and park waste, food and kitchen waste from households, restaurants, caterers and retail premises and comparable waste from food processing plants.","WR_Gas_Feed","-- Select from dropdown --"]
[null,{"$f":"--AND($F$29=PickLists!$C$4,$F$27=PickLists!$B$2)","v":0},"1.2.1.3","1.1.2=Agriculture AND 1.1.1=Solid","Feedstock:","-- Select from dropdown --",null,"Ag_Solid_Feed","-- Select from dropdown --"]
[null,{"$f":"--AND($F$29=PickLists!$C$4,$F$27=PickLists!$B$3)","v":0},"1.2.1.4","1.1.2=Agriculture AND 1.1.1=Gaseous","Feedstock:","-- Select from dropdown --",null,"Ag_Gas_Feed","-- Select from dropdown --"]
[null,{"$f":"--AND($F$29=PickLists!$C$5,$F$27=PickLists!$B$2)","v":0},"1.2.1.5","1.1.2=Forestry AND 1.1.1=Solid","Feedstock:","-- Select from dropdown --",null,"F_Solid_Feed","-- Select from dropdown --"]
[null,{"$f":"--AND($F$29=PickLists!$C$5,$F$27=PickLists!$B$3)","v":0},"1.2.1.6","1.1.2=Forestry AND 1.1.1=Gaseous","Feedstock:","Other"]
[null,{"$f":"--AND($F$29=PickLists!$C$6,NOT(OR(ISBLANK($F$27),NOT(ISERROR(FIND(\"--\",$F$27))))))","v":0},"1.2.1.7","1.1.2=Other AND 1.1.1 <> BLANK","Feedstock:","Other"]
[]
[null,null,"1.2.1.8",null,"Is feedstock IE - indicative?",{"$f":"IF(IFERROR(FIND(\"IE - indicative\",F37),0)>0,1,0)","v":0}]
[null,{"$f":"B49","v":0},"<BLANK>","1.2.1.1 IS ON"]
[null,0,null,"Hidden","Form of biomass fuel:",{"$f":"IF($B$49>0,$F$49,0)","v":0}]
[null,{"$f":"IF(OR(AND($B$38=1,$F$38=PickLists!$I$2,$F$46<>1),$B$42>0),1,0)","v":0},"1.2.2.1","(1.2.1.1 IS ON AND 1.2.1.1=Wood industry residues AND 1.2.1.8 <> 1) OR (1.2.1.5 IS ON)","Form of biomass fuel:","-- Select from dropdown --",null,"Wood_form","-- Select from dropdown --"]
[null,{"$f":"--($B$52+$B$53+$B$54>0)","v":0},"<BLANK>","(1.2.3.1 IS ON) OR (1.2.3.2 IS ON) OR (1.2.3.3 IS ON)"]
[null,0,null,"Hidden","Energy input to processing of fuel:",{"$f":"IFERROR(INDEX($F$52:$F$54,MATCH(1,$B$52:$B$54,0)),0)","v":0}]
[null,{"$f":"$B$49*--($F$49=PickLists!$S$3)*--($F$46<>1)","v":0},"1.2.3.1","1.2.2.1=Pellets / briquettes AND 1.2.2.1 IS ON  AND 1.2.1.8 <> 1","Energy input to processing of fuel:","-- Select from dropdown --",null,"Pellet_processing","-- Select from dropdown --"]
[null,{"$f":"$B$39*--($F$39=PickLists!$K$3)*--($F$46<>1)","v":0},"1.2.3.2","1.2.1.2=Biowaste AND 1.2.1.2 IS ON AND 1.2.1.8 <> 1","Energy input to processing of fuel:","-- Select from dropdown --",null,"Biogas_processing","-- Select from dropdown --"]
[null,{"$f":"$B$41*SUMPRODUCT(--(PickLists!$N$2:$N$8=$F$41))*--($F$46<>1)","v":0},"1.2.3.3","1.2.1.4<>Other AND 1.2.1.4 <> BLANK AND 1.2.1.4 IS ON AND 1.2.1.8 <> 1","Energy input to processing of fuel:","-- Select from dropdown --",null,"Biogas_processing","-- Select from dropdown --"]
[null,{"$f":"$B$57","v":0},"<BLANK>","1.2.4.1 IS ON"]
[null,0,null,"Hidden","Transport distance:",{"$f":"IF($B$57>0,$F$57,0)","v":0}]
[null,{"$f":"--($F$27=PickLists!$B$2)*--($F$37<>PickLists!$I$3)*--($F$37<>0)*--($F$46<>1)","v":0},"1.2.4.1","1.1.1=Solid AND 1.2.1.0<>Other AND 1.2.1.0<>0","Transport distance:","-- Select from dropdown --","How far has the biomass feedstock and fuel been transported?",{"$f":"GHG_Lookup!D17","v":{"$error":"#N/A"}},"-- Select from dropdown --"]
[null,{"$f":"$B$60","v":0},"<BLANK>","1.2.5.1 IS ON"]
[null,0,null,"Hidden","Digestate storage:",{"$f":"IF($B$60>0,$F$60,0)","v":0}]
[null,{"$f":"--($F$27=PickLists!$B$3)*--($F$37<>PickLists!$I$3)*--($F$37<>0)*--($F$46<>1)","v":0},"1.2.5.1","1.1.1=Gaseous AND 1.2.1.0<>Other AND 1.2.1.0<>0","Digestate storage:","-- Select from dropdown --",null,"Open_closed","-- Select from dropdown --"]
[null,{"$f":"$B$64","v":0},"<BLANK>","1.2.6.1 IS ON"]
[null,0,"1.2.6.-1","Hidden","Other:",{"$f":"--OR($F$37=\"Other\",$F$48=\"Other\",$F$51=\"Other\",$F$56=\"Other\",$F$59=\"Other\")","v":0}]
[null,0,"1.2.6.0","Hidden","Info for default:",{"$f":"--AND(NOT(F62=1),OR($F$59<>0,$F$56<>0))","v":0}]
[null,{"$f":"--OR($F$62=1,$F$63=1,$F$46=1)","v":0},"1.2.6.1","1.2.6.-1=1 OR 1.2.6.0=1 OR 1.2.1.8=1","Fuel use:","-- Select from dropdown --","-","Biomass_use","-- Select from dropdown --"]
[null,{"$f":"$B$64*--OR($F$64=PickLists!$AF$2,$F$64=PickLists!$AF$4)","v":0},"1.2.6.2","1.2.6.1 IS ON AND (1.2.6.1='Heat' OR 1.2.6.1 ='Heat and electricity')",{"$f":"IF($F$46=1,\"Indicative GHG saving for heat:\", \"Default GHG saving for heat:\")","v":"Default GHG saving for heat:"},{"$f":"IFERROR(IF($F$46=1,GHG_Lookup!$D$33,IF(GHG_Lookup!D29>0,GHG_Lookup!D29,\"No default available\")),\"No default available\")","v":"No default available"},{"$f":"IF($F$46=1,\"This is an indicative GHG saving calculated using typical assumptions for biomass fuels in an Irish context - please see accompanying report for futher details.\",\"From Annex VI\")","v":"From Annex VI"}]
[null,{"$f":"$B$64*--OR($F$64=PickLists!$AF$3,$F$64=PickLists!$AF$4)","v":0},"1.2.6.3","1.2.6.1 IS ON AND (1.2.6.1='Electricity' OR 1.2.6.1 ='Heat and electricity')",{"$f":"IF($F$46=1,\"Indicative GHG saving for electricity:\",\"Default GHG saving for electricity:\")","v":"Default GHG saving for electricity:"},{"$f":"IFERROR(IF($F$46=1,GHG_Lookup!$D$34,IF(GHG_Lookup!D29>0,GHG_Lookup!D30,\"No default available\")),\"No default available\")","v":"No default available"},{"$f":"IF($F$46=1,\"This is an indicative GHG saving calculated using typical assumptions for biomass fuels in an Irish context - please see accompanying report for futher details.\",\"From Annex VI\")","v":"From Annex VI"}]
[null,{"$f":"IF(B68+B69>0,1,0)","v":0},"<BLANK>","1.2.7.0 IS ON"]
[null,{"$f":"$B$65*--($F$65>=0.7)*--ISNUMBER($F$65)","v":0},"1.2.7.1","(1.2.6.2 IS ON) AND (1.2.6.2 >= 70%)",{"$f":"IF($F$46=1,\"Indicative GHG saving for heat meets the RED II criteria.  You may enter the calculated GHG saving for heat, if known (optional):\",\"Default GHG saving for heat meets the RED II criteria.  You may enter the calculated GHG saving for heat, if known (optional):\")","v":"Default GHG saving for heat meets the RED II criteria.  You may enter the calculated GHG saving for heat, if known (optional):"},"-- Enter value (optional) --",{"$f":"IF($F$46=1,\"The GHG saving calculated in accordance with Annex VI can be used in place of the indicative value.\",\"The GHG saving calculated in accordance with Annex VI can be used in place of the default value.\")","v":"The GHG saving calculated in accordance with Annex VI can be used in place of the default value."},null,"-- Enter value (optional) --"]
[null,{"$f":"$B$66*--($F$66>=0.7)*--ISNUMBER($F$66)","v":0},"1.2.7.2","(1.2.6.3 IS ON) AND (1.2.6.3 >= 70%)",{"$f":"IF($F$46=1,\"Indicative GHG saving for electricity meets the RED II criteria.  You may enter the calculated GHG saving for heat, if known (optional):\",\"Default GHG saving for electricity meets the RED II criteria.  You may enter the calculated GHG saving for electricity, if known (optional):\")","v":"Default GHG saving for electricity meets the RED II criteria.  You may enter the calculated GHG saving for electricity, if known (optional):"},"-- Enter value (optional) --",{"$f":"IF($F$46=1,\"The GHG saving calculated in accordance with Annex VI can be used in place of the indicative value.\",\"The GHG saving calculated in accordance with Annex VI can be used in place of the default value.\")","v":"The GHG saving calculated in accordance with Annex VI can be used in place of the default value."},null,"-- Enter value (optional) --"]
[null,{"$f":"IF(B71+B72>0,1,0)","v":0},"<BLANK>","1.2.7.0 IS ON"]
[null,{"$f":"$B$65*--($F$65=\"No default available\")","v":0},"1.2.8.1","(1.2.6.2 IS ON) AND (1.2.6.2 =\"No default available\")","No default GHG saving for heat is provided in RED II.  The calculated GHG saving for heat is:","-- Enter value --","Where no default GHG saving is provided for the biomass in RED II, the GHG saving must be calculated in accordance with Annex VI.",null,"-- Enter value --"]
[null,{"$f":"$B$66*--($F$66=\"No default available\")","v":0},"1.2.8.2","(1.2.6.3 IS ON) AND (1.2.6.3 =\"No default available\")","No default GHG saving for electricity is provided in RED II.  The calculated GHG saving for electricity is:","-- Enter value --","Where no default GHG saving is provided for the biomass in RED II, the GHG saving must be calculated in accordance with Annex VI.",null,"-- Enter value --"]
[null,{"$f":"IF(B74+B75>0,1,0)","v":0},"<BLANK>","1.2.9.0 IS ON"]
[null,{"$f":"$B$65*--($F$65<0.7)","v":0},"1.2.9.1","(1.2.6.2 IS ON) AND (1.2.6.2 <>\"No default available\") AND (1.2.6.2<70%)","Default / indicative GHG saving for heat does not meet the RED II criterion.  Calculated GHG saving for heat:","-- Enter value --","Where the default / indicative GHG saving is less than 70%, a GHG saving calculated in accordance with Annex VI can be used instead.",null,"-- Enter value --"]
[null,{"$f":"$B$66*--($F$66<0.7)","v":0},"1.2.9.2","(1.2.6.3 IS ON) AND (1.2.6.3 <>\"No default available\") AND (1.2.6.3<70%)","Default / indicatve GHG saving for electricity does not meet the RED II criterion.  Calculated GHG saving for electricity:","-- Enter value --","Where the default / indicative GHG saving is less than 70%, a GHG saving calculated in accordance with Annex VI can be used instead.",null,"-- Enter value --"]
[null,{"$f":"$B$77","v":0},"<BLANK>","1.2.10.0 IS ON"]
[null,{"$f":"IF(ISERROR(GHG_Lookup!G50),0,1)","v":0},"1.2.10",null,{"$f":"IFERROR(GHG_Lookup!G50,\"No result\")","v":"No result"},{"$f":"IFERROR(GHG_Lookup!$D$50,0)","v":0},{"$f":"IF(IFERROR(FIND(\"does not\",E77),0)>0,\"Biomass fuel must have a GHG saving of at least 70% in order to proceed with the assessment.\",\"\")","v":""}]
[null,1,"<BLANK>","Always on"]
[null,1,1.3,null,"Origin of Feedstock"]
[null,1,"<BLANK>","Always on"]
[null,{"$f":"$B$77*$F$77","v":0},"1.3.1","(1.2.10 IS ON) AND (1.2.10 <> 0)","Country of origin of the feedstock:","-- Select from dropdown --",null,"Countries","-- Select from dropdown --"]
[null,1,"<BLANK>","Always on"]
[null,1,1.4,null,"Biodiversity & Carbon Stock"]
[null,1,"<BLANK>","Always on"]
[null,{"$f":"--OR($F$29=PickLists!$C$2,$F$29=PickLists!$C$3)*$B$81*NOT(OR(ISBLANK($F$81),NOT(ISERROR(FIND(\"--\",$F$81)))))","v":0},"1.4.1","(1.1.2 = \"Waste/residue*\") AND (1.3.1 IS ON) AND (1.3.1 IS NOT BLANK)","Is it a waste in accordance with Article 3(1) of the Waste Framework Directive (Directive 2008/98/EC)?","-- Select from dropdown --","Substances that have been intentionally modified or contaminated in order to meet this definition are excluded.","YesNo","-- Select from dropdown --"]
[null,{"$f":"$B$85*--($F$85=\"Yes\")","v":0},"1.4.1.2","(1.4.1.1 IS ON) AND (1.4.1.1 = \"Yes\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"$B$88","v":0},"<BLANK>","1.4.2.1 IS ON"]
[null,{"$f":"$B$85*--($F$85=\"No\")","v":0},"1.4.2","(1.4.1.1 IS ON) AND (1.4.1.1 = \"No\")","Is it a residue in accordance with RED II definition?","-- Select from dropdown --","‘residue’ means a substance that is not the end product(s) that a production process directly seeks to produce; it is not a primary aim of the production process and the process has not been deliberately modified to produce it.","YesNo","-- Select from dropdown --"]
[null,{"$f":"$B$88*--($F$88=\"Yes\")","v":0},"1.4.2.2","(1.4.2.1 IS ON) AND (1.4.2.1 = \"Yes\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"$B$88*--($F$88=\"No\")","v":0},"1.4.2.3","(1.4.2.1 IS ON) AND (1.4.2.1 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,{"$f":"B92","v":0},null,"1.4.3.1 IS ON"]
[null,{"$f":"--($F$29=PickLists!$C$4)*$B$81*($F$81=PickLists!$D$2)","v":0},"1.4.3","(1.1.2 = \"Agriculture\") AND (1.3.1 IS ON) AND (1.3.1 = \"Ireland\")","Has the land been in agricultural use since January 2008?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"$B$92*--($F$92=\"Yes\")","v":0},"1.4.3.1","(1.4.3 IS ON) AND (1.4.3 = \"Yes\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"B95","v":0},"<BLANK>"]
[null,{"$f":"$B$92*--($F$92=\"No\")","v":0},"1.4.3.2","(1.4.3 IS ON) AND (1.4.3 = \"No\")","Does the biomass comply with biodiversity criteria in Article 29(3)?","-- Select from dropdown --","Article 29(3) rules out out biomass produced from land with a high biodiversity value, e.g. primary forests, highly biodiverse grassland and areas designated as SACs or SPAs.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B97","v":0},"<BLANK>"]
[null,{"$f":"$B$95*--($F$95=\"Yes\")","v":0},"1.4.3.2.1","(1.4.3.2 IS ON) AND (1.4.3.2 = \"Yes\")","Does the biomass comply with carbon stock criteria in Article 29(4)?","-- Select from dropdown --","Article 29(4) rules out out biomass produced from land with a high carbon stock, e.g. wetlands and continously forested areas.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B99","v":0},"<BLANK>"]
[null,{"$f":"$B$97*--($F$97=\"Yes\")","v":0},"1.4.3.2.1.1","(1.4.3.2.1 IS ON) AND (1.4.3.2.1 = \"Yes\")","Was the biomass sourced from land that was peatland in January 2008?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B101","v":0},"<BLANK>"]
[null,{"$f":"$B$99*--($F$99=\"Yes\")","v":0},"1.4.3.2.1.1.1","(1.4.3.2.1.1 IS ON) AND (1.4.3.2.1.1 = \"Yes\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,{"$f":"B103","v":0},"<BLANK>"]
[null,{"$f":"$B$99*--($F$99=\"No\")","v":0},"1.4.3.2.1.1.2","(1.4.3.2.1.1 IS ON) AND (1.4.3.2.1.1 = \"No\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"B105","v":0},"<BLANK>"]
[null,{"$f":"$B$97*--($F$97=\"No\")","v":0},"1.4.3.2.1.2","(1.4.3.2.1 IS ON) AND (1.4.3.2.1 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,{"$f":"B107","v":0},"<BLANK>"]
[null,{"$f":"$B$95*--($F$95=\"No\")","v":0},"1.4.3.2.2","(1.4.3.2 IS ON) AND (1.4.3.2 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[]
[null,{"$f":"B110","v":0},"<BLANK>","1.4.4 IS ON"]
[null,{"$f":"--($F$29=PickLists!$C$4)*$B$81*($F$81<>PickLists!$D$2)*--NOT(OR(ISBLANK($F$81),NOT(ISERROR(FIND(\"--\",$F$81)))))","v":0},"1.4.4","(1.1.2 = \"Agriculture\") AND (1.3.1 IS ON) AND (1.3.1 IS NOT BLANK) AND (1.3.1 <> \"Ireland\")","Does the biomass comply with biodiversity criteria in Article 29(3)?","-- Select from dropdown --","Article 29(3) rules out out biomass produced from land with a high biodiversity value, e,g, primary forests, highly biodiverse grassland and areas designated as SACs or SPAs.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B112","v":0},"<BLANK>"]
[null,{"$f":"$B$110*--($F$110=\"Yes\")","v":0},"1.4.4.1","(1.4.4 IS ON) AND (1.4.4 = \"Yes\")","Does the biomass comply with carbon stock criteria in Article 29(4)?","-- Select from dropdown --","Article 29(4) rules out out biomass produced from land with a high carbon stock, e.g. wetlands and continously forested areas.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B114","v":0},"<BLANK>"]
[null,{"$f":"$B$112*--($F$112=\"Yes\")","v":0},"1.4.4.1.1","(1.4.4.1 IS ON) AND (1.4.4.1 = \"Yes\")","Was the biomass sourced from land that was peatland in January 2008?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B116","v":0},"<BLANK>"]
[null,{"$f":"$B$114*--($F$114=\"Yes\")","v":0},"1.4.4.1.1.1","(1.4.4.1.1 IS ON) AND (1.4.4.1.1 = \"Yes\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,{"$f":"B118","v":0},"<BLANK>"]
[null,{"$f":"$B$114*--($F$114=\"No\")","v":0},"1.4.4.1.1.2","(1.4.4.1.1 IS ON) AND (1.4.4.1.1 = \"No\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"B120","v":0},"<BLANK>"]
[null,{"$f":"$B$112*--($F$112=\"No\")","v":0},"1.4.4.1.2","(1.4.4.1 IS ON) AND (1.4.4.1 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,{"$f":"B122","v":0},"<BLANK>"]
[null,{"$f":"$B$110*--($F$110=\"No\")","v":0},"1.4.4.2","(1.4.4 IS ON) AND (1.4.4 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[]
[null,{"$f":"B125","v":0},"<BLANK>","1.4.5 IS ON"]
[null,{"$f":"--($F$29=PickLists!$C$5)*$B$81*($F$81=PickLists!$D$2)","v":0},"1.4.5","(1.1.2 = \"Forestry\") AND (1.3.1 IS ON) AND (1.3.1 = \"Ireland\")","Biomass fuel complies with RED II sustainability criteria."]
[]
[null,{"$f":"B128","v":0},"<BLANK>","1.4.6 IS ON"]
[null,{"$f":"--($F$29=PickLists!$C$5)*$B$81*($F$81<>PickLists!$D$2)*--NOT(OR(ISBLANK($F$81),NOT(ISERROR(FIND(\"--\",$F$81)))))","v":0},"1.4.5","(1.1.2 = \"Agriculture\") AND (1.3.1 IS ON) AND (1.3.1 IS NOT BLANK) AND (1.3.1 <> \"Ireland\")","Does the country of origin have harvesting laws and systems of monitoring and enforcement to ensure compliance with Article 29(6)(a)?","-- Select from dropdown --","Article 26(6)(a) states that the laws and systems must ensure the legality of harvesting, forest regeneration, protection of areas of conservation, maintenance of soil quality and biodiversity, and maintenance of long-term production capacity.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B130","v":0},"<BLANK>"]
[null,0,"1.4.5.1","Hidden","Proceed to 1.4.6",{"$f":"$B$128*--(F128=\"Yes\")","v":0}]
[null,{"$f":"B132","v":0},"<BLANK>"]
[null,{"$f":"$B$128*--($F$128=\"No\")","v":0},"1.4.5.2","(1.4.5 IS ON) AND (1.4.5 = \"No\")","Is there a forestry management system in place in the source area that meets the requirements of Article 29(6)(b)?","-- Select from dropdown --","Article 26(6)(b) states that the forestry management sytem must ensure the legality of harvesting, forest regeneration, protection of areas of conservation, maintenance of soil quality and biodiversity, and maintenance of long-term production capacity.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B134","v":0},"<BLANK>"]
[null,0,"1.4.5.2.1","Hidden","Proceed to 1.4.6",{"$f":"$B$132*--(F132=\"Yes\")","v":0}]
[null,{"$f":"B136","v":0},"<BLANK>"]
[null,{"$f":"$B$132*--($F$132=\"No\")","v":0},"1.4.5.2.2","(1.4.5.2 IS ON) AND (1.4.5.2 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,{"$f":"B138","v":0},"<BLANK>"]
[null,{"$f":"--OR($F$134>0,$F$130>0)","v":0},"1.4.6","(1.4.5.1 = 1) OR (1.4.5.2.1 = 1)","Does the country of origin meet the LULUCF (land use, land-use change, and forestry) criteria in Article 29(7)(a)?","-- Select from dropdown --","To meet the requirements of Article 27(7)(a), the country of origin:\n- must be a party to the Paris Agreement\n- have submitted a nationally determined contribution (NDC) to the United Nations Framework Convention on Climate Change (UNFCCC) covering emissions from land-use change\n- have laws in place (in the source area), in accordance with the Paris Agreement, to conserve and enhance carbon stocks and sinks, and providing evidence that LULUCF-sector emissions do not exceed removals.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B140","v":0},"<BLANK>"]
[null,{"$f":"$B$138*--($F$138=\"Yes\")","v":0},"1.4.6.1","(1.4.6 IS ON) AND (1.4.6 = \"Yes\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"B142","v":0},"<BLANK>"]
[null,{"$f":"$B$138*--($F$138=\"No\")","v":0},"1.4.6.2","(1.4.6 IS ON) AND (1.4.6 = \"No\")","Is there a forestry management system in place in the source area that ensures that carbon stock and sink levels in the forest are maintained, or strengthened over the long term?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B144","v":0},"<BLANK>"]
[null,{"$f":"$B$142*--($F$142=\"Yes\")","v":0},"1.4.6.2.1","(1.4.6.2 IS ON) AND (1.4.6.2 = \"Yes\")","Biomass fuel complies with RED II sustainability criteria."]
[null,{"$f":"B146","v":0},"<BLANK>"]
[null,{"$f":"$B$142*--($F$142=\"No\")","v":0},"1.4.6.2.2","(1.4.6.2 IS ON) AND (1.4.6.2 = \"No\")","Biomass fuel does not comply with RED II sustainability criteria.",null,"Biomass fuel must comply with RED II in order to continue the assessment."]
[null,1,"<BLANK>","Always on"]
[null,0,1.5,"Hidden","Biomass complies with RED II?",{"$f":"IF(B144+B125+B118+B103+B93+B86+B89>0,1,0)","v":0}]
["Additional Indicators",1,2,null,"Environmental Indicators"]
[null,1,"<BLANK>","Always on"]
[null,{"$f":"--($F$27=PickLists!$B$2)*($F$29=PickLists!$C$2)*($F$148>0)","v":0},"2.1.1","(1.5 = 1) AND (1.1.1 = \"Solid\") AND (1.1.2=\"Waste/Residue\")","Is it a sawmill residue?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"$B$151*--($F$151=\"Yes\")","v":0},"2.1.1.1","Yes","Are all sawmills certified by Forest Stewardship Council (FSC) or Programme for the Endorsement of Forest Certificaiton (PEFC)?","-- Select from dropdown --","FSC and PEFC promote sustainable forest management through independent third part certification.","YesNo","-- Select from dropdown --"]
[null,null,"2.1.1.1.1","Yes","<Empty>"]
[null,{"$f":"$B$152*--($F$152=\"No\")","v":0},"2.1.1.1.2","No","Is the wood harvested from source areas where there are laws, monitoring systems or forestry management systems in place that meet the requirements of Article 29(6) of RED II?","-- Select from dropdown --","Article 29(6) states that laws, monitoring systems or forestry management sytem must ensure the legality of harvesting, forest regeneration, protection of areas of conservation, maintenance of soil quality and biodiversity, and maintenance of long-term production capacity.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B156","v":0},"<BLANK>"]
[null,{"$f":"--($F$29=PickLists!$C$5)*($F$148>0)","v":0},"2.2.1","(1.5 = 1) AND (1.1.2=\"Forestry\")","Is the rotation period of the forest ≥ 40 years and is ≥ 50% of the annual production of round wood used for biomass?","-- Select from dropdown --","This is a requirement of sustainability criteria set out in Verification Protocol for Sustainable Solid Biomass, Netherlands Enterprise Agency, 2017.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B158","v":0},"<BLANK>"]
[null,{"$f":"--($F$29=PickLists!$C$5)*($F$148>0)","v":0},"2.2.2","(1.5 = 1) AND (1.1.2=\"Forestry\")","Does the biomass include roots / stumbs, removed for no other reason than wood/biomass production?","-- Select from dropdown --","A 2015 study for the European Commission identified the harvesting of stumps as ‘high risk’ for negatively impacting soil carbon stock and biodiversity (Carbon impacts of biomass consumed in the EU: quantitative assessment, Forest Research, 2015). ","YesNo","-- Select from dropdown --"]
[null,{"$f":"B158","v":0},null,null,null,null,"The harvesting of stumps is prohibited under the Netherland’s Verification Protocol for Sustainable Biomass, unless for reasons other than wood or fuel production."]
[null,{"$f":"B161","v":0},"<BLANK>"]
[null,{"$f":"--IF(COUNTIF(PickLists!$E$2:$E$3,Assessment!$F$81)<1,1,0)*$F$148","v":0},"2.3.1","1.3.1 IS NOT EU) AND (1.5 = 1)","Does the country of origin have laws and systems in place relating to the monitoring and enforcement of air quality?","-- Select from dropdown --","For biomass sourced from countries outside the EU, the laws must be comparable to those enforce within the EU.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B163","v":0},"<BLANK>"]
[null,{"$f":"--IF(COUNTIF(PickLists!$E$2:$E$3,Assessment!$F$81)<1,1,0)*$F$148","v":0},"2.4.1","1.3.1 IS NOT EU) AND (1.5 = 1)","Does the country of origin have laws and systems in place relating to the monitoring and enforcement of water quality?","-- Select from dropdown --","For biomass sourced from countries outside the EU, the laws must be comparable to those enforce within the EU.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B165","v":0},"<BLANK>"]
[null,{"$f":"--AND($F$29<>PickLists!$C$2,$F$29<>PickLists!$C$3)*($F$148>0)","v":0},"2.5.1","(1.5 = 1) AND (1.1.2<>\"Waste/Residue*\")","Is the biomass cultivated on irrigated lands?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"$B$165*--($F$165=\"Yes\")","v":0},"2.5.1.1","Yes","What is the baseline water stress indicator in the country of origin (or region, if data is available) ?","-- Select from dropdown --","An interactive map can be used to find the baseline water stress score (http://www.wri.org/our-work/project/aqueduct/). ","BWS_Indicator","-- Select from dropdown --"]
[null,{"$f":"B168","v":0},"<BLANK>"]
[null,{"$f":"--($F$148>0)","v":0},"2.5.2","1.5 = 1","In your view, is the use of water in processing the biomass in excess of industrial norms?","-- Select from dropdown --","Data needs to be gathered on what is a ‘normal’ quantity of water.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B170","v":0},"<BLANK>"]
[null,{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,Assessment!$F$81)<1)*--($F$29=PickLists!$C$4)*--$F$148","v":0},"2.6.1","(1.5 = 1) AND (1.1.2=\"Agriculture\") AND (1.3.1 IS NOT EU)","Is there a soil management plan in place in the area of origin?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B172","v":0},"<BLANK>"]
[null,{"$f":"--(F151=\"Yes\")*$B$151*($F$148>0)","v":0},"2.7.1","Sawmill residue","Is the wood harvested in accordance with the biodiversity criteria (Article 29(6)(a) )of RED II?","-- Select from dropdown --","Article 29(6) states that laws, monitoring systems or forestry management sytem must ensure the legality of harvesting, forest regeneration, protection of areas of conservation, maintenance of soil quality and biodiversity, and maintenance of long-term production capacity.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B174","v":0},"<BLANK>"]
[null,{"$f":"--AND(OR($F$29=PickLists!$C$2,$F$29=PickLists!$C$3),Assessment!$F$151<>\"No\")*$B$151*--($F$148>0)","v":0},"2.7.2","Waste/residue, not sawmill residue","Is the material, from which the waste/residue is generated, cultivated in accordance with the biodiversity requirements of RED II?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B176","v":0},"<BLANK>"]
[null,{"$f":"--($F$148>0)","v":0},"2.8.1","Always","Which of the following provides the largest share of the energy input to the biomass processing step?","-- Select from dropdown --",null,"Process_Energy","-- Select from dropdown --"]
[null,{"$f":"B178","v":0},"<BLANK>"]
[null,{"$f":"--($F$148>0)","v":0},"2.9.1","Always","Are non-renewable resources used in cultivating or processing the biomass?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B180","v":0},"<BLANK>"]
[null,{"$f":"--($F$148>0)","v":0},"2.9.2","Always","Are non-renewable resources used in the combustion of the biomass?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B182","v":0},"<BLANK>"]
[null,{"$f":"--($F$148>0)","v":0},"2.10.1","Always","What is the risk of significant land use change (LUC) emissions?  Risk can be assessed based upon LUC factors:\n- Low: < 0 gCO2/MJ (e.g. perennials, waste & residue)\n- Medium: 0 - 20 gCO2/MJ (e.g. forest residues, certain stemwood, straw with sustainable removal rate)\n- High: > 20 gCO2/MJ (maize)","-- Select from dropdown --","LUC factors are available for a selection of biomass sources in the 2015 report on the GLOBIOM model: Ecofys, IIASA and E4tech (2015), The land use change impact of biofuels consumed in the EU: Quantification of area and GHG impacts","HiMedLow","-- Select from dropdown --"]
[null,{"$f":"B184","v":0},"<BLANK>"]
[null,{"$f":"--AND(COUNTIF(EU,$F$81)=0,$F$29<>PickLists!$C$5)*$F$148","v":0},"2.10.2","(1.5=1) Not forestry & Not EU","Does the country of origin meet the LULUCF (land use, land-use change, and forestry) criteria in RED II (Article 29(7)a)?","-- Select from dropdown --","To meet the requirements of Article 27(7)(a), the country of origin:\n- must be a party to the Paris Agreement\n- have submitted a nationally determined contribution (NDC) to the United Nations Framework Convention on Climate Change (UNFCCC) covering emissions from land-use change\n- have laws in place (in the source area), in accordance with the Paris Agreement, to conserve and enhance carbon stocks and sinks, and providing evidence that LULUCF-sector emissions do not exceed removals.","YesNo","-- Select from dropdown --"]
[null,1,"<BLANK>","Always on"]
[null,1,3,null,"Economic Indicators"]
[null,1,"<BLANK>","Always on"]
[null,{"$f":"IF($F$81<>PickLists!$D$2,1,0)*$F$148","v":0},"3.1.1","Not Ireland","Approximately what percentage of Ireland's consumption of biomass is provided by the country of origin?","-- Select from dropdown --",null,"Origin_share","-- Select from dropdown --"]
[null,{"$f":"B190","v":0},"<BLANK>"]
[null,{"$f":"IF($F$81=PickLists!$D$2,1,0)*$F$148","v":0},"3.2.1","Ireland","At current and foreseeable production levels, is there a potential for Ireland to become a net exporter of the biomass or biomass fuel?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B192","v":0},"<BLANK>"]
[null,{"$f":"$F$148","v":0},"3.3.1","Always","Is biomass production supported by the country of origin (e.g. via grants or other financial support)?","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"$F$148","v":0},"3.3.2","Always","Is biomass consumption supported in Ireland by the State? (e.g. tax breaks or other financial support)","-- Select from dropdown --",null,"YesNo","-- Select from dropdown --"]
[null,{"$f":"B195","v":0},"<BLANK>"]
[null,{"$f":"$F$148","v":0},"3.4.1","Always","Rate the economic competitiveness of the biomass fuel with its fossil fuel equivalent.","-- Select from dropdown --","The levelized cost of energy (LCOE) is an appropriate means of comparing the cost of different fuels and technologies:\n- Low: the cost of biomass fuel is significantly higher than fossil fuel.\n- Medium: the cost of biomass is broadly similar to fossil fuel.\n- High: the cost of biomass fuel is significantly lower than fossil fuel.","HiMedLow","-- Select from dropdown --"]
[null,{"$f":"B197","v":0},"<BLANK>"]
[null,{"$f":"$F$148","v":0},"3.5.1","Always","In your view, what form of final energy consumption will be displaced by the biomass fuel?","-- Select from dropdown --",null,"Replacing","-- Select from dropdown --"]
[null,{"$f":"B199","v":0},"<BLANK>"]
[null,{"$f":"$F$148","v":0},"3.6.1","Always","In your view, what is the required level of development or modification of existing distribution infrastructure?","-- Select from dropdown --","- High: requires extensive development of new infrastructure\n- Medium: requires significant modification of existing infrastructure\n- Low: Minor or no modification to exisitng infrastructure","HiMedLow","-- Select from dropdown --"]
[null,{"$f":"B201","v":0},"<BLANK>"]
[null,{"$f":"IF($F$81=PickLists!$D$2,1,0)*$F$148","v":0},"3.7.1","Ireland","In your view, what is the current availability and short-term-term capacity to cultivate / extract the feedstock in Ireland?","-- Select from dropdown --",null,"HiMedLow","-- Select from dropdown --"]
[null,{"$f":"IF($F$81=PickLists!$D$2,1,0)*$F$148","v":0},"3.7.2","Ireland","In your view, what is the current and short-term capacity to process the feedstock in Ireland?","-- Select from dropdown --",null,"HiMedLow","-- Select from dropdown --"]
[null,{"$f":"IF($F$81<>PickLists!$D$2,1,0)*$F$148","v":0},"3.7.3","Not Ireland","In your view, what is the current availability and short-term capacity, globally, to cultivate / extract and process the biomass fuel?","-- Select from dropdown --",null,"HiMedLow","-- Select from dropdown --"]
[null,{"$f":"--AND($F$81=PickLists!$D$2,$F$29<>PickLists!$C$2,$F$29<>PickLists!$C$3)*$F$148","v":0},"3.7.4","Ireland and not a WR (excl. ag and for)","How long is the growth period of the biomass?","-- Select from dropdown --",null,"Growth_period","-- Select from dropdown --"]
[null,{"$f":"$F$148","v":0},"3.7.5","Always","In you view, in order to change from the fossil fuel equivalent, the final energy consumer requires:","-- Select from dropdown --",null,"Equipment","-- Select from dropdown --"]
[null,{"$f":"B207","v":0},"<BLANK>"]
[null,{"$f":"IF($F$81=PickLists!$D$2,1,0)*$F$148","v":0},"3.8.1","Ireland","Is additional training or qualifications required for processing the biomass in Ireland?","-- Select from dropdown --","No score assigned for this question. This is included as an aid to prompt policy makers to identify where additional training maybe required.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B209","v":0},"<BLANK>"]
[null,{"$f":"IF($F$81=PickLists!$D$2,1,0)*$F$148","v":0},"3.8.2","Ireland","Is additional training or qualifications required for cultivating the biomass in Ireland?","-- Select from dropdown --","No score assigned for this question. This is included as an aid to prompt policy makers to identify where additional training maybe required.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B211","v":0},"<BLANK>"]
[null,{"$f":"$F$148","v":0},"3.8.3","Always","Is additional training or qualifications required for distributing the biomass in Ireland?","-- Select from dropdown --","No score assigned for this question. This is included as an aid to prompt policy makers to identify where additional training maybe required.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B213","v":0},"<BLANK>"]
[null,{"$f":"$F$148","v":0},"3.8.4","Always","Is additional training required for the final consumer?","-- Select from dropdown --","No score assigned for this question. This is included as an aid to prompt policy makers to identify where additional training maybe required.","YesNo","-- Select from dropdown --"]
[null,1,"<BLANK>","Always on"]
[null,1,4,null,"Social Indicators"]
[null,1,"<BLANK>","Always on"]
[null,{"$f":"$F$148","v":0},"4.1.1","Always","In your view, what is stakeholder opinion towards cultivating and processing the biomass?","-- Select from dropdown --",null,"Opinion","-- Select from dropdown --"]
[null,{"$f":"B219","v":0},"<BLANK>"]
[null,0,"4.1.2","Always","In your view, what is public opinion towards using (i.e. consuming) the biomass?","-- Select from dropdown --",null,"Opinion","-- Select from dropdown --"]
[null,{"$f":"B221","v":0},"<BLANK>"]
[null,0,"4.1.3","Always","Are additional measures required to raise awareness amongst end users of the biomass as an alternative to non-renewable energy consumption?","-- Select from dropdown --","No score assigned for this question. This is included as an aid to prompt policy makers to identify where measures may be required to address concerns or lack of information on the part of end users or the public.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B223","v":0},"<BLANK>"]
[null,{"$f":"IF(COUNTIF(EU,$F$81)=0,1,0)*$F$148","v":0},"4.2.1","not EU","Has the country of origin ratified and implemented each of the Conventions of the International Labour Organisation?","-- Select from dropdown --","Under RED, the Commission reports every two years on the whether a country that is a significant source of raw material for biofuel has ratified each of the conventions of the International Labour Organisation.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B225","v":0},"<BLANK>"]
[null,{"$f":"IF(COUNTIF(EU,$F$81)=0,1,0)*$F$148","v":0},"4.3.1","not EU","Has the production of biomass diverted feedstock from the food chain and impaired food security (e.g. price volatility in country of origin)?","-- Select from dropdown --","Under RED, the Commission reports every two years on the impact of EU biofuel policy on the availability of foodstuffs at affordable prices, in particular for people living in developing countries.","YesNo","-- Select from dropdown --"]
[null,{"$f":"B227","v":0},"<BLANK>"]
[null,{"$f":"IF($F$81=PickLists!$D$2,1,0)*$F$148","v":0},"4.4.1","Ireland","Are people in Ireland directly employed in cultivating / extracting or processing the biomass?","-- Select from dropdown --","‘Yes’ where the biomass is cultivated / extracted and processed in Ireland, otherwise ‘No’.","YesNo","-- Select from dropdown --"]
[null,1,"<BLANK>","Always on"]
[]
[null,1,">>> Go to results"]

{"sheet":"Results","index":2,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Results"]
[]
[null,"1 Sustainability Under RED II"]
[null,"Biomass fuel is compliant with RED II criteria:",{"$f":"IF(Assessment!$F$148>0,\"Yes\",\"No\")","v":"No"}]
[]
[null,"The risk scores below indicate where a risk to sustainability may exist; the risk under different indicators are not comparable."]
[null,"2 Environmental Indicators","Score","Risk"]
[null,"GHG emissions (RED II methodology)",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E9)=0),INDIRECT(\"'Env Score'!N\"&$E9),\"-\")","v":"-"},{"$f":"_xlfn.IFS(C9=\"-\",Risk_message,C9<(1/3),\"Low\",AND(C9>=(1/3),C9<(2/3)),\"Moderate\",C9>=(2/3),\"Investigate\")","v":"No score.  Please answer all relevant questions on the Assessment sheet."},20]
[null,"Carbon debt / reduction in carbon stock of land",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E10)=0),INDIRECT(\"'Env Score'!N\"&$E10),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",26]
[null,"Air quality",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E11)=0),INDIRECT(\"'Env Score'!N\"&$E11),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",33]
[null,"Water quality",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E12)=0),INDIRECT(\"'Env Score'!N\"&$E12),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",39]
[null,"Water use",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E13)=0),INDIRECT(\"'Env Score'!N\"&$E13),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",47]
[null,"Soil quality",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E14)=0),INDIRECT(\"'Env Score'!N\"&$E14),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",53]
[null,"Biodiversity",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E15)=0),INDIRECT(\"'Env Score'!N\"&$E15),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",59,null,null,"Default weight"]
[null,"Biomass use",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E16)=0),INDIRECT(\"'Env Score'!N\"&$E16),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",66]
[null,"Non-renewable resource use",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E17)=0),INDIRECT(\"'Env Score'!N\"&$E17),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",71]
[null,"Land use and land use change ",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Env Score'!I\"&$E18)=0),INDIRECT(\"'Env Score'!N\"&$E18),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",81]
[null,"3 Economic Indicators","Score","Risk"]
[null,"Energy diversity & security",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E20)=0),INDIRECT(\"'Eco Score'!N\"&$E20),\"-\")","v":"-"},{"$f":"_xlfn.IFS(C20=\"-\",Risk_message,C20<(1/3),\"Low\",AND(C20>=(1/3),C20<(2/3)),\"Moderate\",C20>=(2/3),\"Investigate\")","v":"No score.  Please answer all relevant questions on the Assessment sheet."},18]
[null,"Gross value added",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E21)=0),INDIRECT(\"'Eco Score'!N\"&$E21),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",25]
[null,"Economic sustainability",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E22)=0),INDIRECT(\"'Eco Score'!N\"&$E22),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",34]
[null,"Macroeconomic impact",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E23)=0),INDIRECT(\"'Eco Score'!N\"&$E23),\"-\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Market demand",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E24)=0),INDIRECT(\"'Eco Score'!N\"&$E24),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",40]
[null,"Change in consumption of fossil fuels ",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E25)=0),INDIRECT(\"'Eco Score'!N\"&$E25),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",46]
[null,"Infrastructure and logistics for distribution of bioenergy",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E26)=0),INDIRECT(\"'Eco Score'!N\"&$E26),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",52]
[null,"Capacity and flexibility of use of bioenergy",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Eco Score'!I\"&$E27)=0),INDIRECT(\"'Eco Score'!N\"&$E27),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",70]
[null,"Training and requalification of workforce"]
[null,"4 Social Indicators","Score","Risk"]
[null,"Acceptability",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E30)=0),INDIRECT(\"'Soc Score'!N\"&$E30),\"-\")","v":"-"},{"$f":"_xlfn.IFS(C30=\"-\",Risk_message,C30<(1/3),\"Low\",AND(C30>=(1/3),C30<(2/3)),\"Moderate\",C30>=(2/3),\"Investigate\")","v":"No score.  Please answer all relevant questions on the Assessment sheet."},19]
[null,"Labour rights",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E31)=0),INDIRECT(\"'Soc Score'!N\"&$E31),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",27]
[null,"Food security",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E32)=0),INDIRECT(\"'Soc Score'!N\"&$E32),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",35]
[null,"Unpaid labour",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E33)=0),INDIRECT(\"'Soc Score'!N\"&$E33),\"-\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Access to bioenergy (as a means to improving access to energy)",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E34)=0),INDIRECT(\"'Soc Score'!N\"&$E34),\"-\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Mortality and disease attributed to indoor smoke",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E35)=0),INDIRECT(\"'Soc Score'!N\"&$E35),\"-\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Occupational injury, illness and fatality",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E36)=0),INDIRECT(\"'Soc Score'!N\"&$E36),\"-\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Employment in bioenergy",{"$f":"IF(AND(Assessment!$F$148>0,INDIRECT(\"'Soc Score'!I\"&$E37)=0),INDIRECT(\"'Soc Score'!N\"&$E37),\"-\")","v":"-"},"No score.  Please answer all relevant questions on the Assessment sheet.",40]
[]
[null,"Legend"]
[null,"Risk","Score","Note"]
[null,"Low / negligible","< 0.33","Risk is not considered to be significant."]
[null,"Moderate","≥ 0.33,<0.67","A potential risk exists."]
[null,"Investigate","≥ 0.67","A more detailed examination of how the risk arises is advisable."]

{"sheet":"Definitions","index":3,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Definitions"]
[null,"The following are the RED II definitions that apply to this framework."]
[]
[null,"agricultural biomass","biomass produced from agriculture"]
[null,"agricultural, aquaculture, fisheries and forestry residues","residues that are directly generated by agriculture, aquaculture, fisheries and forestry and that do not include residues from related industries or processing"]
[null,"biofuels","liquid fuel for transport produced from biomass"]
[null,"biogas","gaseous fuels produced from biomass"]
[null,"bioliquids","liquid fuel for energy purposes other than for transport, including electricity and heating and cooling, produced from biomass"]
[null,"biomass","the biodegradable fraction of products, waste and residues from biological origin from agriculture, including vegetal and animal substances, from forestry and related industries, including fisheries and aquaculture, as well as the biodegradable fraction of waste, including industrial and municipal waste of biological origin"]
[null,"biomass fuel","gaseous and solid fuels produced from biomass"]
[null,"biowaste","biowaste as defined in point (4) of Article 3 of Directive 2008/98/EC [Waste Framework Directive]"]
[null,"default value [for GHG saving]","a value [for GHG saving] derived from a typical value by the application of pre-determined factors and that may, in circumstances specified in this Directive, be used in place of an actual value"]
[null,"forest biomass","biomass produced from forestry"]
[null,"forest regeneration","the re-establishment of a forest stand by natural or artificial means following the removal of the previous stand by felling or as a result of natural causes, including fire or storm"]
[null,"renewable energy obligation","(6) ‘renewable energy obligation’ means a support scheme requiring energy producers to include a given share of energy from renewable sources in their production, requiring energy suppliers to include a given share of energy from renewable sources in their supply, or requiring energy consumers to include a given share of energy from renewable sources in their consumption, including schemes under which such requirements may be fulfilled by using green certificates;"]
[null,"residue","a substance that is not the end product(s) that a production process directly seeks to produce; it is not a primary aim of the production process and the process has not been deliberately modified to produce it"]
[null,"sourcing area","the geographically defined area from which the forest biomass feedstock is sourced, from which reliable and independent information is available and where conditions are sufficiently homogeneous to evaluate the risk of the sustainability and legality characteristics of the forest biomass"]
[null,"support scheme","(5) ‘support scheme’ means any instrument, scheme or mechanism applied by a Member State, or a group of Member States, that promotes the use of energy from renewable sources by reducing the cost of that energy, increasing the price at which it can be sold, or increasing, by means of a renewable energy obligation or otherwise, the volume of such energy purchased, including but not restricted to, investment aid, tax exemptions or reductions, tax refunds, renewable energy obligation support schemes including those using green certificates, and direct price support schemes including feed-in tariffs and sliding or fixed premium payments;"]
[null,"waste","waste as defined in point (1) of Article 3 of Directive 2008/98/EC [Waste Framework Directive], excluding substances that have been intentionally modified or contaminated in order to meet this definition"]

{"sheet":"<Test>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"AnnexVI","index":5,"n_rows":141,"n_cols":6,"rows_kept":141,"cut":false,"hidden":true,"merged":[]}
["Field 1","Field 2","Field 3","Field 4","Default"]
["Type","Production system","Case","Transport distance  or biogas type","Heat ","Electricity "]
["Woodchips","Forest residues",null,"1 to 500 km",0.91,0.87]
["Woodchips","Forest residues",null,"500 to 2,500 km",0.87,0.81]
["Woodchips","Forest residues",null,"2,500 to 10,000 km",0.78,0.67]
["Woodchips","Forest residues",null,"Above 10,000 km",0.6,0.41]
["Woodchips","Short Rotation Coppice (eucalyptus)",null,"2,500 to 10,000 km",0.73,0.6]
["Woodchips","Short Rotation Coppice (poplar - fertilised)",null,"1 to 500 km",0.87,0.81]
["Woodchips","Short Rotation Coppice (poplar - fertilised)",null,"500 to 2,500 km",0.84,0.76]
["Woodchips","Short Rotation Coppice (poplar - fertilised)",null,"2,500 to 10,000 km",0.74,0.62]
["Woodchips","Short Rotation Coppice (poplar - fertilised)",null,"Above 10,000 km",0.56999999999999995,0.35]
["Woodchips","Short Rotation Coppice (poplar - no fertilisation)",null,"1 to 500 km",0.9,0.85]
["Woodchips","Short Rotation Coppice (poplar - no fertilisation)",null,"500 to 2,500 km",0.86,0.79]
["Woodchips","Short Rotation Coppice (poplar - no fertilisation)",null,"2,500 to 10,000 km",0.77,0.65]
["Woodchips","Short Rotation Coppice (poplar - no fertilisation)",null,"Above 10,000 km",0.59,0.39]
["Woodchips","Stemwood",null,"1 to 500 km",0.92,0.88]
["Woodchips","Stemwood",null,"500 to 2,500 km",0.88,0.82]
["Woodchips","Stemwood",null,"2,500 to 10,000 km",0.79,0.68]
["Woodchips","Stemwood",null,"Above 10,000 km",0.61,0.42]
["Woodchips","Wood industry residues",null,"1 to 500 km",0.93,0.9]
["Woodchips","Wood industry residues",null,"500 to 2,500 km",0.9,0.85]
["Woodchips","Wood industry residues",null,"2,500 to 10,000 km",0.8,0.71]
["Woodchips","Wood industry residues",null,"Above 10,000 km",0.63,0.44]
["Pellets / briquettes","Forest residues","Case 1","1 to 500 km",0.49,0.24]
["Pellets / briquettes","Forest residues","Case 1","500 to 2,500 km",0.49,0.25]
["Pellets / briquettes","Forest residues","Case 1","2,500 to 10,000 km",0.47,0.21]
["Pellets / briquettes","Forest residues","Case 1","Above 10,000 km",0.4,0.11]
["Pellets / briquettes","Forest residues","Case 2a","1 to 500 km",0.72,0.59]
["Pellets / briquettes","Forest residues","Case 2a","500 to 2,500 km",0.72,0.59]
["Pellets / briquettes","Forest residues","Case 2a","2,500 to 10,000 km",0.7,0.55000000000000004]
["Pellets / briquettes","Forest residues","Case 2a","Above 10,000 km",0.63,0.45]
["Pellets / briquettes","Forest residues","Case 3a","1 to 500 km",0.9,0.85]
["Pellets / briquettes","Forest residues","Case 3a","500 to 2,500 km",0.9,0.86]
["Pellets / briquettes","Forest residues","Case 3a","2,500 to 10,000 km",0.88,0.81]
["Pellets / briquettes","Forest residues","Case 3a","Above 10,000 km",0.81,0.72]
["Pellets / briquettes","Short Rotation Coppice (eucalyptus)","Case 1","2,500 to 10,000 km",0.43,0.15]
["Pellets / briquettes","Short Rotation Coppice (eucalyptus)","Case 2a","2,500 to 10,000 km",0.66,0.49]
["Pellets / briquettes","Short Rotation Coppice (eucalyptus)","Case 3a","2,500 to 10,000 km",0.83,0.75]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 1","1 to 500 km",0.46,0.2]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 1","500 to 10,000 km",0.44,0.16]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 1","Above 10,000 km",0.37,7.0000000000000007E-2]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 2a","1 to 500 km",0.69,0.54]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 2a","500 to 10,000 km",0.67,0.5]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 2a","Above 10,000 km",0.6,0.41]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 3a","1 to 500 km",0.87,0.81]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 3a","500 to 10,000 km",0.84,0.77]
["Pellets / briquettes","Short Rotation Coppice (poplar - fertilised)","Case 3a","Above 10,000 km",0.78,0.67]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 1","1 to 500 km",0.48,0.23]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 1","500 to 10,000 km",0.46,0.2]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 1"," Above 10,000 km",0.4,0.1]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 2a","1 to 500 km",0.72,0.57999999999999996]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 2a","500 to 10,000 km",0.69,0.54]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 2a","Above 10,000 km",0.63,0.45]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 3a","1 to 500 km",0.9,0.85]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 3a","500 to 10,000 km",0.87,0.81]
["Pellets / briquettes","Short Rotation Coppice (poplar - no fertilisation)","Case 3a","Above 10,000 km",0.81,0.71]
["Pellets / briquettes","Stemwood","Case 1","1 to 500 km",0.49,0.24]
["Pellets / briquettes","Stemwood","Case 1","500 to 2,500 km",0.49,0.25]
["Pellets / briquettes","Stemwood","Case 1","2,500 to 10,000 km",0.47,0.21]
["Pellets / briquettes","Stemwood","Case 1","Above 10,000 km",0.4,0.11]
["Pellets / briquettes","Stemwood","Case 2a","1 to 500 km",0.73,0.6]
["Pellets / briquettes","Stemwood","Case 2a","500 to 2,500 km",0.73,0.6]
["Pellets / briquettes","Stemwood","Case 2a","2,500 to 10,000 km",0.7,0.56000000000000005]
["Pellets / briquettes","Stemwood","Case 2a"," Above 10,000 km",0.64,0.46]
["Pellets / briquettes","Stemwood","Case 3a","1 to 500 km",0.91,0.86]
["Pellets / briquettes","Stemwood","Case 3a","500 to 2,500 km",0.91,0.87]
["Pellets / briquettes","Stemwood","Case 3a","2,500 to 10,000 km",0.88,0.83]
["Pellets / briquettes","Stemwood","Case 3a","Above 10,000 km",0.82,0.73]
["Pellets / briquettes","Wood industry residues","Case 1","1 to 500 km",0.69,0.55000000000000004]
["Pellets / briquettes","Wood industry residues","Case 1","500 to 2,500 km",0.7,0.55000000000000004]
["Pellets / briquettes","Wood industry residues","Case 1","2,500 to 10,000 km",0.67,0.51]
["Pellets / briquettes","Wood industry residues","Case 1","Above 10,000 km",0.61,0.42]
["Pellets / briquettes","Wood industry residues","Case 2a","1 to 500 km",0.84,0.76]
["Pellets / briquettes","Wood industry residues","Case 2a","500 to 2,500 km",0.84,0.77]
["Pellets / briquettes","Wood industry residues","Case 2a","2,500 to 10,000 km",0.82,0.73]
["Pellets / briquettes","Wood industry residues","Case 2a","Above 10,000 km",0.75,0.63]
["Pellets / briquettes","Wood industry residues","Case 3a","1 to 500 km",0.94,0.91]
["Pellets / briquettes","Wood industry residues","Case 3a","500 to 2,500 km",0.94,0.92]
["Pellets / briquettes","Wood industry residues","Case 3a","2,500 to 10,000 km",0.92,0.88]
["Pellets / briquettes","Wood industry residues","Case 3a","Above 10,000 km",0.85,0.78]
["Agri biomass","Agri residues, density <0.2 t/m^3",null,"1 to 500 km",0.93,0.9]
["Agri biomass","Agri residues, density <0.2 t/m^3",null,"500 to 2,500 km",0.86,0.8]
["Agri biomass","Agri residues, density <0.2 t/m^3",null,"2,500 to 10,000 km",0.73,0.6]
["Agri biomass","Agri residues, density <0.2 t/m^3",null,"Above 10,000 km",0.48,0.23]
["Agri biomass","Agri residues, density >0.2 t/m^3",null,"1 to 500 km",0.93,0.9]
["Agri biomass","Agri residues, density >0.2 t/m^3",null,"500 to 2,500 km",0.92,0.87]
["Agri biomass","Agri residues, density >0.2 t/m^3",null,"2,500 to 10,000 km",0.85,0.78]
["Agri biomass","Agri residues, density >0.2 t/m^3",null,"Above 10,000 km",0.74,0.61]
["Agri biomass","Straw pellets",null,"1 to 500 km",0.85,0.78]
["Agri biomass","Straw pellets",null,"500 to 10,000 km",0.83,0.74]
["Agri biomass","Straw pellets",null,"Above 10,000 km",0.76,0.64]
["Agri biomass","Bagasse briquettes",null,"500 to 10,000 km ",0.91,0.87]
["Agri biomass","Bagasse briquettes",null,"Above 10,000 km",0.85,0.77]
["Agri biomass","Palm kernel meal",null,"Above 10,000 km",0.11,-0.33]
["Agri biomass","Palm kernel meal (no CH4 emission from oil mill)",null,"Above 10,000 km",0.42,0.14000000000000001]
["Biogas","Wet manure","Case 1","Open",null,0.94]
["Biogas","Wet manure","Case 1","Closed",null,2.4]
["Biogas","Wet manure","Case 2","Open",null,0.85]
["Biogas","Wet manure","Case 2","Closed",null,2.19]
["Biogas","Wet manure","Case 3","Open",null,0.86]
["Biogas","Wet manure","Case 3","Closed",null,2.35]
["Biogas","Maize whole plant","Case 1","Open",null,0.21]
["Biogas","Maize whole plant","Case 1","Closed",null,0.53]
["Biogas","Maize whole plant","Case 2","Open",null,0.18]
["Biogas","Maize whole plant","Case 2","Closed",null,0.47]
["Biogas","Maize whole plant","Case 3","Open",null,0.1]
["Biogas","Maize whole plant","Case 3","Closed",null,0.43]
["Biogas","Biowaste","Case 1","Open",null,0.26]
["Biogas","Biowaste","Case 1","Closed",null,0.78]
["Biogas","Biowaste","Case 2","Open",null,0.21]
["Biogas","Biowaste","Case 2","Closed",null,0.68]
["Biogas","Biowaste","Case 3","Open",null,0.14000000000000001]
["Biogas","Biowaste","Case 3","Closed",null,0.66]
["Biogas","Manure - Maize, 80% - 20%","Case 1","Open",null,0.45]
["Biogas","Manure - Maize, 80% - 20%","Case 1","Closed",null,1.1399999999999999]
["Biogas","Manure - Maize, 80% - 20%","Case 2","Open",null,0.4]
["Biogas","Manure - Maize, 80% - 20%","Case 2","Closed",null,1.03]
["Biogas","Manure - Maize, 80% - 20%","Case 3","Open",null,0.35]
["Biogas","Manure - Maize, 80% - 20%","Case 3","Closed",null,1.06]
["Biogas","Manure - Maize, 70% - 30%","Case 1","Open",null,0.37]
["Biogas","Manure - Maize, 70% - 30%","Case 1","Closed",null,0.94]
["Biogas","Manure - Maize, 70% - 30%","Case 2","Open",null,0.32]
["Biogas","Manure - Maize, 70% - 30%","Case 2","Closed",null,0.85]
["Biogas","Manure - Maize, 70% - 30%","Case 3","Open",null,0.27]
["Biogas","Manure - Maize, 70% - 30%","Case 3","Closed",null,0.85]
["Biogas","Manure - Maize, 60% - 40%","Case 1","Open",null,0.32]
["Biogas","Manure - Maize, 60% - 40%","Case 1","Closed",null,0.82]
["Biogas","Manure - Maize, 60% - 40%","Case 2","Open",null,0.28000000000000003]
["Biogas","Manure - Maize, 60% - 40%","Case 2","Closed",null,0.73]
["Biogas","Manure - Maize, 60% - 40%","Case 3","Open",null,0.22]
["Biogas","Manure - Maize, 60% - 40%","Case 3","Closed",null,0.72]
["Agri biomass","Miscanthus bales (IE - indicative)",null,null,0.89,0.88]
["Agri biomass","Miscanthus pellets (IE - indicative)",null,null,0.85,0.82]
["Agri biomass","Straw pellets (IE - indicative)",null,null,0.92,0.91]
["Biogas","Grass silage (IE - indicative)",null,"Closed",0.43,0.3]
["Biogas","Wet manure (IE - indicative)",null,"Closed",1.59,1.73]
["Biogas","Grass silage - wet manure, 40% - 60% (IE - indicative)",null,"Closed",0.76,0.71]
["Pellets / briquettes","Forest residues (IE - indicative)",null,null,0.85,0.83]
["Pellets / briquettes","Forest residues imported from USA (IE - indicative)",null,null,0.73,0.69]
["Pellets / briquettes","Short rotation coppice (willow) pellets (IE - indicative)",null,null,0.75,0.71]
["Woodchips","Short rotation coppice (willow) chips (IE - indicative)",null,null,0.81,0.79]

{"sheet":"PickLists","index":6,"n_rows":11,"n_cols":42,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["YesNo","SolGas","Source","Countries","EU",null,null,"Process_Energy","WR_Solid_Feed","WR_solid_dist_list","WR_Gas_Feed","Ag_Solid_Feed","Ag_solid_dist_list","Ag_Gas_Feed","F_Solid_Feed","Woodchip_dist_list","Wood_pellet_dist_list","F_Gas_Feed","Wood_form",null,"Solid_dist_1","Solid_dist_2","Solid_dist_3","Heat_Elec","Open_closed","MM_ratio","Pellet_processing","Pellet_processing_case","Biogas_processing","Biogas_processing_case","Other","Biomass_use","Replacing","Infrastructure","Growth period","Origin_share","YesNoUnknown","HiMedLow","Equipment","Opinion","BWS_Indicator","Risk_message"]
["Yes","Solid","Waste","Ireland","Ireland","< 40 years","<= 50%","Biomass","Wood industry residues","Solid_dist_1","Wet manure","Agri residues, density <0.2 t/m^3","Solid_dist_1","Maize whole plant","Forest residues","Solid_dist_1","Solid_dist_1","Other","Woodchips","Woodchips","1 to 500 km","2,500 to 10,000 km","1 to 500 km","Heat","Open","80% - 20%","Natural gas boiler, grid electricity","Case 1","Heat and elec from biogas CHP","Case 1","Other","Heat","Fossil fuel","Extensive development of new infratructure","<= 2 year","<=10%","Yes","Low","Significant capital investment","Favourable","> 3","No score.  Please answer all relevant questions on the Assessment sheet."]
["No","Gas","Residue*","EU (other than IE)","EU (other than IE)",">= 40 years","> 50%","On-site renewables","Other","Other","Biowaste","Agri residues, density >0.2 t/m^3","Solid_dist_1","Manure - Maize, 80% - 20%","Short Rotation Coppice (eucalyptus)","Solid_dist_2","Solid_dist_2",null,"Pellets / briquettes","Wood pellets","500 to 2,500 km","Other","500 to 10,000 km","Electricity","Closed","70% - 30%","Woodchip boiler, grid electricity","Case 2a","Elec from grid, heat from biogas CHP","Case 2",null,"Electricity","Grid electricity","Significant modification of existing infrastructure","> 2 years","> 10%, <= 50%","No","Medium","Moderate capital investment","Neutral","≤ 3"]
[null,null,"Agriculture (incl. agri residue)","EEA or CH (other than EU)",null,null,null,"Grid electricity",null,null,{"$f":"AnnexVI!B136","v":"Wet manure (IE - indicative)"},"Straw pellets","Solid_dist_3","Manure - Maize, 70% - 30%","Short Rotation Coppice (poplar - fertilised)","Solid_dist_1","Solid_dist_3",null,null,null,"2,500 to 10,000 km",null,"Above 10,000 km",null,null,"60% - 40%","Woodchip in CHP","Case 3a","Elec from grid, heat from biogas boiler","Case 3",null,"Heat and electricity","Other renewables","Minor or no modification of existing infrastructure",null,"> 50%","Unknown","High","Minor or no capital investment","Unfavourable"]
[null,null,"Forestry (incl. forestry residue)","Other",null,null,null,"Fossil fuel",null,null,"Other","Bagasse briquettes","Solid_dist_3","Manure - Maize, 60% - 40%","Short Rotation Coppice (poplar - no fertilisation)","Solid_dist_1","Solid_dist_3",null,null,null,"Above 10,000 km",null,null,null,null,"Other","Other",null,"Other"]
[null,null,"Other",null,null,null,null,null,null,null,null,"Palm kernel meal","Solid_dist_3",{"$f":"AnnexVI!B135","v":"Grass silage (IE - indicative)"},"Stemwood","Solid_dist_1","Solid_dist_1"]
[null,null,null,null,null,null,null,null,null,null,null,"Palm kernel meal (no CH4 emission from oil mill)","Solid_dist_3",{"$f":"AnnexVI!B137","v":"Grass silage - wet manure, 40% - 60% (IE - indicative)"},{"$f":"AnnexVI!B138","v":"Forest residues (IE - indicative)"},"Other","Other"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AnnexVI!B132","v":"Miscanthus bales (IE - indicative)"},"Other","Other",{"$f":"AnnexVI!B139","v":"Forest residues imported from USA (IE - indicative)"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AnnexVI!B133","v":"Miscanthus pellets (IE - indicative)"},null,null,{"$f":"AnnexVI!B140","v":"Short rotation coppice (willow) pellets (IE - indicative)"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AnnexVI!B134","v":"Straw pellets (IE - indicative)"},null,null,{"$f":"AnnexVI!B141","v":"Short rotation coppice (willow) chips (IE - indicative)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Other"]

{"sheet":"GHG_Lookup","index":7,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Solid/gaseous",null,{"$f":"Assessment!F27","v":"-- Select from dropdown --"},{"$f":"MATCH(D2,SolGas,0)","v":{"$error":"#N/A"}}]
[null,"Source type",null,{"$f":"Assessment!F29","v":"-- Select from dropdown --"},{"$f":"MATCH(D3,Source,0)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"PickLists!$C$2","v":"Waste"},{"$f":"PickLists!$C$4","v":"Agriculture (incl. agri residue)"},{"$f":"PickLists!$C$5","v":"Forestry (incl. forestry residue)"}]
[null,"Form",null,{"$f":"Assessment!F49","v":"-- Select from dropdown --"},{"$f":"MATCH(D4,Wood_form,0)","v":{"$error":"#N/A"}},null,null,null,{"$f":"PickLists!$B$2","v":"Solid"},{"$f":"PickLists!$I$1","v":"WR_Solid_Feed"},{"$f":"PickLists!$L$1","v":"Ag_Solid_Feed"},{"$f":"PickLists!$O$1","v":"F_Solid_Feed"}]
[null,"Feedstock list",null,{"$f":"HLOOKUP($D$3,$J$3:$L$5,MATCH($D$2,I3:I5,0),FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"PickLists!$B$3","v":"Gas"},{"$f":"PickLists!$K$1","v":"WR_Gas_Feed"},{"$f":"PickLists!$N$1","v":"Ag_Gas_Feed"},{"$f":"PickLists!$R$1","v":"F_Gas_Feed"}]
["F2","Feedstock pick",null,{"$f":"Assessment!F37","v":0},{"$f":"MATCH(D6,INDIRECT(D5),0)","v":{"$error":"#N/A"}}]
[]
[null,"Processing energy list",null,{"$f":"_xlfn.IFS(Assessment!$F$27=PickLists!$B$3,PickLists!$AC$1,AND(Assessment!$F$27=PickLists!$B$2,Assessment!$F$48=PickLists!$S$3),PickLists!$AA$1,\"TRUE\",PickLists!$AE$1)","v":"Other"}]
[null,"Processing energy",null,{"$f":"Assessment!F51","v":0},{"$f":"MATCH(D9,INDIRECT(D8),0)","v":{"$error":"#REF!"}}]
[null,"Processing case list",null,{"$f":"IF(D8=PickLists!AA1,PickLists!AB1,IF(D8=PickLists!$AC$1,PickLists!$AD$1,\"\"))","v":""}]
["F3","Processing case",null,{"$f":"IFERROR(INDEX(INDIRECT(D10),E9),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,{"$f":"PickLists!$J$1","v":"WR_solid_dist_list"},{"$f":"PickLists!M1","v":"Ag_solid_dist_list"},{"$f":"PickLists!P1","v":"Woodchip_dist_list"},{"$f":"PickLists!Q1","v":"Wood_pellet_dist_list"}]
[null,"Use",null,{"$f":"Assessment!F64","v":"-- Select from dropdown --"},{"$f":"MATCH(D14,Biomass_use,0)","v":{"$error":"#N/A"}},null,null,{"$f":"MATCH(1,I14:L14,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(D3=PickLists!$C$2,D6=PickLists!$I$2),1,0)","v":0},{"$f":"IF(AND(D3=PickLists!$C$4,D2=PickLists!$B$2),1,0)","v":0},{"$f":"IF(AND(D2=PickLists!$B$2,D3=PickLists!$C$5,D4=PickLists!$S$2),1,0)","v":0},{"$f":"IF(AND(D2=PickLists!$B$2,D3=PickLists!$C$5,D4=PickLists!$S$3),1,0)","v":0}]
[]
[null,"List of Distance lists",null,{"$f":"CHOOSE(H14,I13,J13,K13,L13)","v":{"$error":"#N/A"}}]
[null,"Distance list",null,{"$f":"INDEX(INDIRECT(D16),E6)","v":{"$error":"#N/A"}}]
[null,"Distance pick",null,{"$f":"IF(Assessment!$B$57>0,Assessment!$F$57,0)","v":0}]
[null,"Digestate pick",null,{"$f":"IF(Assessment!$B$60>0,Assessment!$F$60,0)","v":0}]
["F4","Field 4",null,{"$f":"IF(D2=PickLists!$B$2,D18,IF(D2=PickLists!$B$3,D19,\"Select solid or gas\"))","v":"Select solid or gas"}]
[null,null,null,null,null,null,null,null,"Woodchips","Pellets / briquettes","Agri biomass","Biogas"]
["F1","Field 1",null,{"$f":"INDEX(I21:L21,H22)","v":{"$error":"#N/A"}},null,null,null,{"$f":"MATCH(1,I22:L22,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND(D2=PickLists!$B$2,OR(D3=PickLists!$C$2,D3=PickLists!$C$5),D4=PickLists!$S$2),1,0)","v":0},{"$f":"IF(AND(D2=PickLists!$B$2,OR(D3=PickLists!$C$2,D3=PickLists!$C$5),D4=PickLists!$S$3),1,0)","v":0},{"$f":"IF(AND(D2=PickLists!$B$2,D3=PickLists!$C$4),1,0)","v":0},{"$f":"IF(D2=PickLists!$B$3,1,0)","v":0}]
[]
[null,"Other?",null,{"$f":"Assessment!F62","v":0}]
[]
[]
[]
[null,"Annex VI"]
[null,"GHG saving heat",null,{"$f":"_xlfn.IFNA(SUMPRODUCT(AnnexVI!E3:E131,--(AnnexVI!A3:A131=D22),--(AnnexVI!B3:B131=D6),--(AnnexVI!C3:C131=D11),--(AnnexVI!D3:D131=D20)),0)","v":0}]
[null,"GHG saving elec",null,{"$f":"_xlfn.IFNA(SUMPRODUCT(AnnexVI!F3:F131,--(AnnexVI!A3:A131=D22),--(AnnexVI!B3:B131=D6),--(AnnexVI!C3:C131=D11),--(AnnexVI!D3:D131=D20)),0)","v":0}]
[]
[null,"IE - calculated"]
[null,"GHG saving heat",{"$f":"Assessment!$F$46","v":0},{"$f":"IF(C33,VLOOKUP($D$6,AnnexVI!$B$132:$F$141,4,FALSE),0)","v":0}]
[null,"GHG saving elec",{"$f":"Assessment!$F$46","v":0},{"$f":"IF(C34,VLOOKUP($D$6,AnnexVI!$B$132:$F$141,5,FALSE),0)","v":0}]
[]
[null,"User input"]
[null,"GHG saving heat",null,{"$f":"MAX(Assessment!F68,Assessment!F71,Assessment!F74)","v":0}]
[null,"GHG saving elec",null,{"$f":"MAX(Assessment!F69,Assessment!F72,Assessment!F75)","v":0}]
[]
[null,"GHG for Env Score"]
[null,"GHG saving, heat",null,{"$f":"MAX(D37,D33,D29)","v":0}]
[null,"GHG saving, elec",null,{"$f":"MAX(D38,D34,D30)","v":0}]
[]
[null,"Compliant?",null,null,"Pass","Fail","Message"]
[null,{"$f":"PickLists!AF2","v":"Heat"},null,{"$f":"IF(D41>=0.7,1,0)","v":0},"GHG saving for heat complies with RED II","GHG saving for heat does not comply with RED II",{"$f":"IF(D45=1,E45,F45)","v":"GHG saving for heat does not comply with RED II"}]
[null,{"$f":"PickLists!AF3","v":"Electricity"},null,{"$f":"IF(D42>=0.7,1,0)","v":0},"GHG saving for electricity complies with RED II","GHG saving for electricity does not comply with RED II",{"$f":"IF(D46=1,E46,F46)","v":"GHG saving for electricity does not comply with RED II"}]
[null,{"$f":"PickLists!AF4","v":"Heat and electricity"},null,{"$f":"IF(AND(D41>=0.7,D42>=0.7),1,0)","v":0},"GHG saving for heat and electricity complies with RED II","GHG saving for heat and/or electricity does not comply with RED II",{"$f":"IF(D47=1,E47,F47)","v":"GHG saving for heat and/or electricity does not comply with RED II"}]
[]
[]
[null,"Output",null,{"$f":"INDEX(D45:D47,$E$14)","v":{"$error":"#N/A"}},null,null,{"$f":"INDEX(G45:G47,$E$14)","v":{"$error":"#N/A"}}]

{"sheet":"Env Score","index":8,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
[null,null,"Fuel type",{"$f":"Assessment!F27","v":"-- Select from dropdown --"}]
[null,null,"Country of Origin",{"$f":"Assessment!F81","v":"-- Select from dropdown --"}]
[null,null,"Biomass source",{"$f":"Assessment!F29","v":"-- Select from dropdown --"}]
[null,null,"Use",{"$f":"Assessment!$F$64","v":"-- Select from dropdown --"}]
[null,null,"GHG saving, heat",{"$f":"GHG_Lookup!D41","v":0}]
[null,null,"GHG saving, elec",{"$f":"GHG_Lookup!D42","v":0}]
[null,null,"GHG saving",{"$f":"_xlfn.IFS($D$4=PickLists!$AF$2,$D$5,$D$4=PickLists!$AF$3,$D$6,$D$4=PickLists!$AF$4,AVERAGE($D$5:$D$6))","v":{"$error":"#N/A"}}]
[null,null,"RED II compliant",{"$f":"Assessment!$F$148","v":0}]
[null,null,null,null,null,null,"B","F"]
["Section.","Assessment No.","Indicator","Q #","Question / means of assessment","Row","Q 'on'?","A blank?","A outstanding?",null,null,"Modifier","Value","Risk score",null,"Warning"]
["7.4.1.1",2.1,"GHG emissions",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.2.10","What is the GHG saving, as calculated using the RED II methodology?",{"$f":"ROW(Assessment!C77)","v":77},null,null,null,"< 70%",{"$f":"--($D$7<0.7)","v":{"$error":"#N/A"}},"Add",1,{"$f":"N11+M12*K12","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,"≥ 70%, < 80%",{"$f":"--AND($D$7>=0.7,$D$7<0.8)","v":{"$error":"#N/A"}},"Add",{"$f":"2/3","v":0.66666666666666663},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"≥ 80%, < 90%",{"$f":"--AND($D$7>=0.8,$D$7<0.9)","v":{"$error":"#N/A"}},"Add",{"$f":"1/3","v":0.33333333333333331},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,"≥ 90%",{"$f":"--(D7>=0.9)","v":{"$error":"#N/A"}},"Add",0,{"$error":"#N/A"}]
[null,null,null,"2.1.1","Sawmill residue?",{"$f":"ROW(Assessment!C151)","v":151},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F16)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F16)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F16)))))","v":1},{"$f":"G16*H16","v":0},null,{"$f":"--(Assessment!F151=\"Yes\")","v":0},null,null,{"$error":"#N/A"}]
[null,null,null,"2.1.1.1","Certified to FSC or PEFC?",{"$f":"ROW(Assessment!C152)","v":152},0,{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F17)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F17)))))","v":1},{"$f":"G17*H17","v":0},null,{"$f":"--(Assessment!F152=\"Yes\")","v":0},null,null,{"$error":"#N/A"},null,"Saw-mill residue: mill not certified to FSC or PEFC"]
[null,null,null,"2.1.1.1.2","Evidence of sustainable harvesting?",{"$f":"ROW(Assessment!C154)","v":154},0,1,{"$f":"G18*H18","v":0},null,{"$f":"--(Assessment!F154=\"Yes\")","v":0},null,null,{"$error":"#N/A"},null,"Saw-mill residue: no evidence of sustainable wood harvesting"]
[null,null,null,null,"Increase score to 1?",null,null,null,null,"If sawmill residue and no evidence of sustainable harvesting",{"$f":"IF(AND(K16=1,K17=0,K18=0),1,0)","v":0},"Add",{"$f":"1-N18","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I12:I19)","v":0},null,null,null,null,{"$error":"#N/A"}]
[]
["7.4.1.2",2.2000000000000002,"Carbon debt / reduction in carbon stock of land",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.1.2","Is the biomass from forestry?",{"$f":"ROW(Assessment!C29)","v":29},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F23)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F23)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F23)))))","v":1},{"$f":"G23*H23","v":0},"Yes",{"$f":"--($D$3=PickLists!$C$5)","v":0},"Add",1,{"$f":"N22+K23*M23","v":0}]
[null,null,null,"2.2.1","Harvest period ≥ 40 years and ≥ 50% of the annual production of round wood used for biomass?",{"$f":"ROW(Assessment!C156)","v":156},0,1,{"$f":"G24*H24","v":0},"No",{"$f":"--(Assessment!$F$156=J24)","v":0},"Add",-0.5,{"$f":"N23+K24*M24","v":0},null,"Carbon debt: high use of round wood production from forest stands with long harvest periods"]
[null,null,null,"2.2.2","Does the biomass contain stumps?",{"$f":"ROW(Assessment!C158)","v":158},0,1,{"$f":"G25*H25","v":0},"No",{"$f":"--(Assessment!$F$158=J25)","v":0},"Add",-0.5,{"$f":"N24+K25*M25","v":0},null,"Carbon debt: use of stumps"]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I23:I25)","v":0},null,null,null,null,{"$f":"N25","v":0}]
["7.4.1.3",2.2999999999999998,"Air quality",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","EU?",{"$f":"ROW(Assessment!C81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F28)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F28)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F28)))))","v":1},{"$f":"G28*H28","v":0},"No",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<1)","v":1},null,null,{"$f":"N27+K28*M28","v":0}]
[null,null,null,"2.3.1","Laws in place relating to air quality?",{"$f":"ROW(Assessment!C161)","v":161},0,1,{"$f":"G29*H29","v":0},"No",{"$f":"--(Assessment!$F$161=J29)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"--(K29*K28=1)","v":0},"Add",0.5,0,null,"Air quality: no laws / sytem for monitoring and enforcement"]
[null,null,null,"1.1.1","Fuel type",{"$f":"ROW(Assessment!C27)","v":27},1,{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F31)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F31)))))","v":1},1,{"$f":"PickLists!B2","v":"Solid"},{"$f":"--($D$1=J31)","v":0},"Add",0.5,0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!B3","v":"Gas"},{"$f":"--($D$1=J32)","v":0},"Add",0,0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I28:I32)","v":1},null,null,null,null,0]
[]
["7.4.1.4",2.4,"Water quality",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","EU?",{"$f":"ROW(Assessment!C81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F36)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F36)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F36)))))","v":1},{"$f":"G36*H36","v":0},"No",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<1)","v":1},null,null,{"$f":"N35+K36*M36","v":0}]
[null,null,null,"2.4.1","Laws in place relating to waterquality?",{"$f":"ROW(Assessment!C163)","v":163},0,1,{"$f":"G37*H37","v":0},"No",{"$f":"--(Assessment!$F$163=J37)","v":0},null,null,{"$f":"N36+K37*M37","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"--(K37*K36=1)","v":0},"Add",1,{"$f":"N37+K38*M38","v":0},null,"Water quality: no laws / sytem for monitoring and enforcement"]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I36:I38)","v":0},null,null,null,null,{"$f":"N38+K39*M39","v":0}]
[]
["7.4.1.5",2.5,"Water use",null,null,null,null,null,null,null,null,null,null,{"$f":"E41","v":0}]
[null,null,null,"2.5.1","Irrigated?",{"$f":"ROW(Assessment!C165)","v":165},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F42)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F42)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F42)))))","v":1},{"$f":"G42*H42","v":0},"Yes",{"$f":"--(Assessment!$F$165=J42)","v":0},null,null,{"$f":"N41+K42*M42","v":0}]
[null,null,null,"2.5.1.1","BWS indicator",{"$f":"ROW(Assessment!C166)","v":166},0,1,{"$f":"G43*H43","v":0},{"$f":"PickLists!$AO$2","v":"> 3"},{"$f":"--(Assessment!$F$166=J43)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!$AO$3","v":"≤ 3"},{"$f":"--(Assessment!$F$166=J44)","v":0},null,null,0]
[null,null,null,null,"Irrigated and BWS > 3",null,null,null,null,null,{"$f":"K43*K42","v":0},"Add",0.5,0,null,"Water use: biomass irrigated in region with high water stress"]
[null,null,null,"2.5.2","Is the use of water in processing the biomass in excess of industrial norms?",{"$f":"ROW(Assessment!C168)","v":168},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F46)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F46)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F46)))))","v":1},{"$f":"G46*H46","v":0},"Yes",{"$f":"--(Assessment!$F$168=J46)","v":0},"Add",0.5,0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I42:I46)","v":0},null,null,null,null,0]
[]
["7.4.1.6",2.6,"Soil quality",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.1.2","Is the biomass sourced from forestry or wastes",{"$f":"ROW(Assessment!$C$29)","v":29},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F50)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F50)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F50)))))","v":1},{"$f":"G50*H50","v":0},"No",{"$f":"--NOT(OR($D$3=PickLists!$C$5,$D$3=PickLists!$C$2))","v":1},"Add",1,{"$f":"N49+K50*M50","v":1}]
[null,null,null,"1.1.2 & 1.3.1","Agri and EU?",{"$f":"ROW(Assessment!F81)","v":81},0,1,0,"Yes",{"$f":"--AND(COUNTIF(PickLists!$E$2:$E$3,$D$2)>0,$D$3=PickLists!$C$4)","v":0},"Add",-1,{"$f":"N50+K51*M51","v":1}]
[null,null,null,"2.6.1","Soil management plan?",{"$f":"ROW(Assessment!C170)","v":170},0,1,0,"Yes",{"$f":"--(Assessment!F170=J52)","v":0},"Add",-1,{"$f":"N51+K52*M52","v":1}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I50:I52)","v":0},null,null,null,null,{"$f":"N52+K53*M53","v":1}]
[]
["7.4.1.7",2.7,"Biodiversity",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.1.2","Forestry or agriculture?",{"$f":"ROW(Assessment!$C$29)","v":29},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F56)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F56)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F56)))))","v":1},{"$f":"G56*H56","v":0},"No",{"$f":"--NOT(OR($D$3=PickLists!$C$5,$D$3=PickLists!$C$4))","v":1},"Add",1,{"$f":"N55+K56*M56","v":1}]
[null,null,null,"2.7.1","For sawmill residues, is the wood harvested in accordance with the biodiversity criteria of RED II?  ",{"$f":"ROW(Assessment!$C$172)","v":172},0,1,{"$f":"G57*H57","v":0},"Yes",{"$f":"--(Assessment!$F$172=J57)","v":0},"Add",-1,{"$f":"N56+K57*M57","v":1}]
[null,null,null,"2.7.2","Was the material from which the waste or residue was generated cultivated in accordance with the biodiversity requirements of RED II?",{"$f":"ROW(Assessment!$C$174)","v":174},0,1,0,"Yes",{"$f":"--(Assessment!$F$174=J58)","v":0},"Add",-1,{"$f":"N57+K58*M58","v":1}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I56:I58)","v":0},null,null,null,null,{"$f":"N58+K59*M59","v":1}]
[]
["7.4.1.8",2.8,"Biomass use",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"2.8.1","Which of the following provides the largest share of the energy input to the biomass processing step?",{"$f":"ROW(Assessment!$C$176)","v":176},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F62)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F62)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F62)))))","v":1},{"$f":"G62*H62","v":0},{"$f":"PickLists!H2","v":"Biomass"},{"$f":"--(Assessment!$F$176=J62)","v":0},"Add",0,{"$f":"N61+K62*M62","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!H3","v":"On-site renewables"},{"$f":"--(Assessment!$F$176=J63)","v":0},"Add",0,{"$f":"N62+K63*M63","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!H4","v":"Grid electricity"},{"$f":"--(Assessment!$F$176=J64)","v":0},"Add",0.5,{"$f":"N63+K64*M64","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!H5","v":"Fossil fuel"},{"$f":"--(Assessment!$F$176=J65)","v":0},"Add",1,{"$f":"N64+K65*M65","v":0}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I62:I65)","v":0},null,null,null,null,{"$f":"N65+K66*M66","v":0}]
[]
["7.4.1.9",2.9,"Non-renewable resource use",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"2.9.1","Non-renewable resources used in the extraction/cultivation or processing?",{"$f":"ROW(Assessment!C178)","v":178},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F69)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F69)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F69)))))","v":1},{"$f":"G69*H69","v":0},"Yes",{"$f":"--(Assessment!$F$178=J69)","v":0},"Add",0.5,{"$f":"N68+K69*M69","v":0},null,"Non-renewable resource use: extraction/cultivation or processing"]
[null,null,null,"2.9.2","Non-renewable resources used in the combustion?",{"$f":"ROW(Assessment!C180)","v":180},0,1,0,"Yes",{"$f":"--(Assessment!$F$180=J70)","v":0},"Add",0.5,{"$f":"N69+K70*M70","v":0},null,"Non-renewable resource use: combustion"]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I69:I70)","v":0},null,null,null,null,{"$f":"N70+K71*M71","v":0}]
[]
["7.4.1.10","2.10","Land use and land use change ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"2.10.1","Risk of significant LUC emissions?",{"$f":"ROW(Assessment!C184)","v":184},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F74)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F74)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F74)))))","v":1},{"$f":"G74*H74","v":0},"Low",{"$f":"--(Assessment!F182=J74)","v":0},"Add",0,{"$f":"N73+K74*M74","v":0}]
[null,null,null,null,null,null,null,null,null,"Medium",{"$f":"--(Assessment!F184=J75)","v":0},"Add",{"$f":"1/3","v":0.33333333333333331},0]
[null,null,null,null,null,null,null,null,null,"High",{"$f":"--(Assessment!F186=J76)","v":0},"Add",{"$f":"2/3","v":0.66666666666666663},0]
[null,null,null,"1.1.2","Forestry?",{"$f":"ROW(Assessment!C29)","v":29},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F77)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F77)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F77)))))","v":1},{"$f":"G77*H77","v":0},"No",{"$f":"--($D$3<>PickLists!$C$5)","v":1},null,null,0]
[null,null,null,"1.3.1","EU?",{"$f":"ROW(Assessment!C81)","v":81},0,1,0,"No",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<1)","v":1},null,null,0]
[null,null,null,"2.10.2","Does country of origin meet the LULUCF requirements of RED II?",{"$f":"ROW(Assessment!C184)","v":184},0,1,0,"No",{"$f":"--(Assessment!$F$184=J79)","v":0},null,null,0]
[null,null,null,null,"Does not meet LULUCF criteria",null,null,null,null,null,{"$f":"K79*K78*K77","v":0},"Add",{"$f":"1/3","v":0.33333333333333331},0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I74:I80)","v":0},null,null,null,null,0]

{"sheet":"Eco Score","index":9,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
[null,null,"Fuel type",{"$f":"Assessment!F27","v":"-- Select from dropdown --"}]
[null,null,"Country of Origin",{"$f":"Assessment!F81","v":"-- Select from dropdown --"}]
[null,null,"Biomass source",{"$f":"Assessment!F29","v":"-- Select from dropdown --"}]
[null,null,"Use",{"$f":"Assessment!$F$64","v":"-- Select from dropdown --"}]
[null,null,"GHG saving, heat",{"$f":"GHG_Lookup!D41","v":0}]
[null,null,"GHG saving, elec",{"$f":"GHG_Lookup!D42","v":0}]
[null,null,"GHG saving",{"$f":"_xlfn.IFNA(_xlfn.IFS($D$4=PickLists!$AF$2,$D$5,$D$4=PickLists!$AF$3,$D$6,$D$4=PickLists!$AF$4,MIN($D$5:$D$6)),0)","v":0}]
[]
[null,null,null,null,null,null,"B","F"]
["Section.","Assessment No.","Indicator","Q #","Question / means of assessment","Row","Q 'on'?","A blank?","A outstanding?",null,null,"Modifier","Value","Risk score",null,"Warning"]
["7.4.2.1",null,"Energy security & diversity",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","Country of Origin:",{"$f":"ROW(Assessment!$C$81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F12)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F12)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F12)))))","v":1},{"$f":"G12*H12","v":0},"Ireland",{"$f":"--($D$2=J12)","v":0},"Add",0,{"$f":"N11+M12*K12","v":0}]
[null,null,null,null,null,null,null,null,null,"Not Ireland",{"$f":"--($D$2<>J12)","v":1},"Add",1,1]
[null,null,null,"1.3.1","Another MS",{"$f":"ROW(Assessment!$C$81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F14)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F14)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F14)))))","v":1},{"$f":"G14*H14","v":0},null,{"$f":"--($D$2=PickLists!$D$3)","v":0},"Add",-0.25,1]
[null,null,null,"3.1.1","For non IE, Proportion of Ireland's biomass consumption provided by the country of origin",{"$f":"ROW(Assessment!C188)","v":188},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F15)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F15)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F15)))))","v":1},{"$f":"G15*H15","v":0},{"$f":"PickLists!AJ2","v":"<=10%"},{"$f":"$K$13*(--(Assessment!$F$188=J15))","v":0},"Add",-0.5,1]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AJ3","v":"> 10%, <= 50%"},{"$f":"$K$13*(--(Assessment!$F$188=J16))","v":0},"Add",-0.25,1]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AJ4","v":"> 50%"},{"$f":"$K$13*(--(Assessment!$F$188=J17))","v":0},"Add",0,1]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I12:I17)","v":0},null,null,null,null,1]
[]
["7.4.2.2",null,"Gross value added",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","Extracted / cultivated and processed in:",{"$f":"ROW(Assessment!$C$81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F21)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F21)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F21)))))","v":1},{"$f":"G21*H21","v":0},"Ireland",{"$f":"K12","v":0},"Add",0,{"$f":"N20+M21*K21","v":0}]
[null,null,null,null,null,null,null,null,null,"Not Ireland",{"$f":"K13","v":1},"Add",1,{"$f":"N21+M22*K22","v":1}]
[null,null,null,"3.2.1","For IE biomass, potential for IE to become a net exporter of the biomass or biomass fuel?",{"$f":"ROW(Assessment!$C$81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F23)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F23)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F23)))))","v":1},{"$f":"G23*H23","v":0},"Yes",{"$f":"$K$21*(--(Assessment!$F$190=J23))","v":0},null,0,{"$f":"N22+M23*K23","v":1}]
[null,null,null,null,null,null,null,null,null,"No",{"$f":"$K$21*(--(Assessment!$F$190=J24))","v":0},null,0.25,{"$f":"N23+M24*K24","v":1}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I21:I24)","v":0},null,null,null,null,{"$f":"N24+M25*K25","v":1}]
[]
["7.4.2.3",null,"Economic sustainability",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","Country of Origin:",{"$f":"ROW(Assessment!$C$81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F28)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F28)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F28)))))","v":1},{"$f":"G28*H28","v":0},"Ireland",{"$f":"--($D$2=J28)","v":0},null,null,{"$f":"N27+M28*K28","v":0}]
[null,null,null,null,null,null,null,null,null,"Not Ireland",{"$f":"--($D$2<>J28)","v":1},null,null,0]
[null,null,null,"3.3.1 & 3.3.2","No support from Ireland or other state",{"$f":"ROW(Assessment!C192)","v":192},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F30)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F30)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F30)))))","v":1},{"$f":"G30*H30","v":0},null,{"$f":"--AND(Assessment!$F$192=\"No\",Assessment!$F$193=\"No\")","v":0},"Add",0,0]
[null,null,null,null,"Biomass is extracted / cultivated & processed in Ireland and is supported by the state (on supply and/or demand side).",{"$f":"ROW(Assessment!C193)","v":193},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F31)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F31)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F31)))))","v":1},{"$f":"G31*H31","v":0},null,{"$f":"K28*--OR(Assessment!$F$192=\"Yes\",Assessment!$F$193=\"Yes\")","v":0},"Add",0.5,0]
[null,null,null,null,"Biomass is extracted / cultivated & processed in another country, but is not supported by that state.  Biomass consumption is provided with state support in Ireland.",null,null,null,null,null,{"$f":"K29*--(Assessment!$F$192=\"No\")*--(Assessment!$F$193=\"Yes\")","v":0},"Add",0.5,0]
[null,null,null,null,"Biomass is extracted / cultivated & processed in another country and the production is supported by that state (e.g. subsidies or mandates).",null,null,null,null,null,{"$f":"K29*--(Assessment!$F$192=\"Yes\")","v":0},"Add",1,0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I28:I33)","v":0},null,null,null,null,0]
[]
["7.4.2.4",null,"Market Demand",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"3.4.1","Economic competitiveness",{"$f":"ROW(Assessment!C195)","v":195},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F37)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F37)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F37)))))","v":1},{"$f":"G37*H37","v":0},{"$f":"PickLists!AL2","v":"Low"},{"$f":"--(Assessment!$F$195=J37)","v":0},"Add",1,{"$f":"N36+M37*K37","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL3","v":"Medium"},{"$f":"--(Assessment!$F$195=J38)","v":0},"Add",0.5,{"$f":"N37+M38*K38","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL4","v":"High"},{"$f":"--(Assessment!$F$195=J39)","v":0},"Add",0,{"$f":"N38+M39*K39","v":0}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I37:I39)","v":0},null,null,null,null,{"$f":"N39+M40*K40","v":0}]
[]
["7.4.2.5",null,"Change in consumption of fossil fuels",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"3.5.1","Form of final energy consumption displaced ",{"$f":"ROW(Assessment!C197)","v":197},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F43)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F43)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F43)))))","v":1},{"$f":"G43*H43","v":0},{"$f":"PickLists!AG2","v":"Fossil fuel"},{"$f":"--(Assessment!$F$197=J43)","v":0},"Add",0,{"$f":"N42+M43*K43","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AG3","v":"Grid electricity"},{"$f":"--(Assessment!$F$197=J44)","v":0},"Add",0.5,{"$f":"N43+M44*K44","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AG4","v":"Other renewables"},{"$f":"--(Assessment!$F$197=J45)","v":0},"Add",1,{"$f":"N44+M45*K45","v":0}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I43:I45)","v":0},null,null,null,null,{"$f":"N45+M46*K46","v":0}]
[]
["7.4.2.6",null,"Infrastructure and logistics for distribution of bioenergy",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"3.6.1","Required level of development or modification of existing distribution infrastructure: ",{"$f":"ROW(Assessment!C199)","v":199},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F49)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F49)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F49)))))","v":1},{"$f":"G49*H49","v":0},{"$f":"PickLists!AL2","v":"Low"},{"$f":"--(Assessment!$F$199=J49)","v":0},"Add",0,{"$f":"N48+M49*K49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL3","v":"Medium"},{"$f":"--(Assessment!$F$199=J50)","v":0},"Add",0.5,{"$f":"N49+M50*K50","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL4","v":"High"},{"$f":"--(Assessment!$F$199=J51)","v":0},"Add",1,{"$f":"N50+M51*K51","v":0}]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I49:I51)","v":0},null,null,null,null,{"$f":"N51+M52*K52","v":0}]
[]
["7.4.2.7",null,"Capacity and flexibility of use of bioenergy",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"3.7.1","If IE, current availability of feedstock",{"$f":"ROW(Assessment!C201)","v":201},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F55)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F55)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F55)))))","v":1},{"$f":"G55*H55","v":0},{"$f":"PickLists!AL2","v":"Low"},{"$f":"$K$12*--(Assessment!$F$201=J55)","v":0},null,{"$f":"1/3","v":0.33333333333333331},{"$f":"N54+M55*K55","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL3","v":"Medium"},{"$f":"$K$12*--(Assessment!$F$201=J56)","v":0},null,{"$f":"1/6","v":0.16666666666666666},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL4","v":"High"},{"$f":"$K$12*--(Assessment!$F$201=J57)","v":0},null,0,0]
[null,null,null,"1.1.2","Waste or residue?",null,null,null,null,"No",{"$f":"--($D$3<>PickLists!$C$2)","v":1},null,null,0]
[null,null,null,"3.7.4","If IE and not WR, what is the growth period of the feedstock?",{"$f":"ROW(Assessment!C204)","v":204},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F59)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F59)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F59)))))","v":1},{"$f":"G59*H59","v":0},{"$f":"PickLists!AI2","v":"<= 2 year"},{"$f":"$K$58*$K$12*--(Assessment!$F$204=J59)","v":0},null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AI3","v":"> 2 years"},{"$f":"$K$58*$K$12*--(Assessment!$F$204=J60)","v":0},null,{"$f":"1/6","v":0.16666666666666666},0]
[null,null,null,"3.7.2","If IE, what is the current and short-term capacity to process the feedstock?",{"$f":"ROW(Assessment!C202)","v":202},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F61)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F61)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F61)))))","v":1},{"$f":"G61*H61","v":0},{"$f":"PickLists!AL2","v":"Low"},{"$f":"$K$12*--(Assessment!$F$202=J61)","v":0},null,{"$f":"1/3","v":0.33333333333333331},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL3","v":"Medium"},{"$f":"$K$12*--(Assessment!$F$202=J62)","v":0},null,{"$f":"1/6","v":0.16666666666666666},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL4","v":"High"},{"$f":"$K$12*--(Assessment!$F$202=J63)","v":0},null,0,0]
[null,null,null,"3.7.3","Not IE, what is the current availability and short-term capacity to cultivate / extract and process the biomass fuel?",{"$f":"ROW(Assessment!C203)","v":203},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F64)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F64)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F64)))))","v":1},{"$f":"G64*H64","v":0},{"$f":"PickLists!AL2","v":"Low"},{"$f":"$K$13*--(Assessment!$F$203=J64)","v":0},null,{"$f":"2/3","v":0.66666666666666663},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL3","v":"Medium"},{"$f":"$K$13*--(Assessment!$F$203=J65)","v":0},null,{"$f":"1/3","v":0.33333333333333331},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AL4","v":"High"},{"$f":"$K$13*--(Assessment!$F$203=J66)","v":0},null,0,0]
[null,null,null,"3.7.5","To change from fossil fuel equivalent, the FE consumer will require:",{"$f":"ROW(Assessment!C205)","v":205},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F67)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F67)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F67)))))","v":1},{"$f":"G67*H67","v":0},{"$f":"PickLists!AM2","v":"Significant capital investment"},{"$f":"--(Assessment!$F$205=J67)","v":0},null,{"$f":"1/3","v":0.33333333333333331},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AM3","v":"Moderate capital investment"},{"$f":"--(Assessment!$F$205=J68)","v":0},null,{"$f":"1/6","v":0.16666666666666666},0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AM4","v":"Minor or no capital investment"},{"$f":"--(Assessment!$F$205=J69)","v":0},null,0,0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I55:I69)","v":0},null,null,null,null,0]
[]
[null,null,"Training"]
[null,null,null,null,"Additional training or qualifications required for the processing of the biomass within Ireland:",null,null,null,null,"Yes",{"$f":"--(Assessment!$F$207=J73)","v":0}]
[null,null,null,null,"Additional training or qualifications required for the cultivation of the biomass within Ireland:",null,null,null,null,"Yes",{"$f":"--(Assessment!$F$207=J74)","v":0}]
[null,null,null,null,"Additional training or qualifications required for the distribution of the biomass within Ireland:",null,null,null,null,"Yes",{"$f":"--(Assessment!$F$207=J75)","v":0}]

{"sheet":"Soc Score","index":10,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[null,null,"Fuel type",{"$f":"Assessment!F27","v":"-- Select from dropdown --"}]
[null,null,"Country of Origin",{"$f":"Assessment!F81","v":"-- Select from dropdown --"}]
[null,null,"Biomass source",{"$f":"Assessment!F29","v":"-- Select from dropdown --"}]
[null,null,"Use",{"$f":"Assessment!$F$64","v":"-- Select from dropdown --"}]
[null,null,"GHG saving, heat",{"$f":"GHG_Lookup!D41","v":0}]
[null,null,"GHG saving, elec",{"$f":"GHG_Lookup!D42","v":0}]
[null,null,"GHG saving",{"$f":"_xlfn.IFNA(_xlfn.IFS($D$4=PickLists!$AF$2,$D$5,$D$4=PickLists!$AF$3,$D$6,$D$4=PickLists!$AF$4,MIN($D$5:$D$6)),0)","v":0}]
[]
[null,null,null,null,null,null,"B","F"]
["Section.","Assessment #","Indicator","Q #","Question / means of assessment","Row","Q 'on'?","A blank?","A outstanding?",null,null,"Modifier","Value","Risk score",null,"Warning"]
[]
["7.4.3.1",4.0999999999999996,"Acceptability",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"4.1.1","What is stakeholder opinion towards extracting / cultivating, processing and using the biomass?",{"$f":"ROW(Assessment!C217)","v":217},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F13)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F13)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F13)))))","v":1},{"$f":"G13*H13","v":0},{"$f":"PickLists!AN2","v":"Favourable"},{"$f":"--(Assessment!$F$217=J13)","v":0},"Add",0,{"$f":"N12+M13*K13","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AN3","v":"Neutral"},{"$f":"--(Assessment!$F$217=J14)","v":0},"Add",0.25,0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AN4","v":"Unfavourable"},{"$f":"--(Assessment!$F$217=J15)","v":0},"Add",0.5,0]
[null,null,null,"4.1.2","What is public opinion towards the use (consumption) of the biomass?",{"$f":"ROW(Assessment!C219)","v":219},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F16)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F16)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F16)))))","v":1},{"$f":"G16*H16","v":0},{"$f":"PickLists!AN2","v":"Favourable"},{"$f":"--(Assessment!$F$219=J16)","v":0},"Add",0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AN3","v":"Neutral"},{"$f":"--(Assessment!$F$219=J17)","v":0},"Add",0.25,0]
[null,null,null,null,null,null,null,null,null,{"$f":"PickLists!AN4","v":"Unfavourable"},{"$f":"--(Assessment!$F$219=J18)","v":0},"Add",0.5,0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I13:I18)","v":0},null,null,null,null,0]
[]
["7.4.3.2",4.2,"Labour rights",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","Is the cultivation / extraction and processing carried out within the EU?",{"$f":"ROW(Assessment!C81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F22)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F22)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F22)))))","v":1},{"$f":"G22*H22","v":0},"Yes",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<>0)","v":0},"Add",0,{"$f":"N21+M22*K22","v":0}]
[null,null,null,null,null,null,null,null,null,"No",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<1)","v":1},"Add",1,1]
[null,null,null,"4.2.1","Implemented each of the conventions of the International Labour Organisation",{"$f":"ROW(Assessment!C223)","v":223},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F24)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F24)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F24)))))","v":1},{"$f":"G24*H24","v":0},"Yes",{"$f":"--(Assessment!$F$223=J24)","v":0},null,null,1]
[null,null,null,null,null,null,null,null,null,"No",{"$f":"--(Assessment!$F$223=J25)","v":0},null,null,1]
[null,null,null,null,"Non EU and implemented each of the conventions",null,null,null,null,null,{"$f":"K24*K23","v":0},"Add",-1,1]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I22:I26)","v":0},null,null,null,null,1]
[]
["7.4.3.3",4.3,"Food security",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"1.3.1","Is the cultivation / extraction and processing carried out within the EU?",{"$f":"ROW(Assessment!C81)","v":81},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F30)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F30)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F30)))))","v":1},{"$f":"G30*H30","v":0},"Yes",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<>0)","v":0},"Add",0,{"$f":"N29+M30*K30","v":0}]
[null,null,null,null,null,null,null,null,null,"No",{"$f":"--(COUNTIF(PickLists!$E$2:$E$3,$D$2)<1)","v":1},"Add",1,1]
[null,null,null,"4.3.1","Has the production of biomass diverted feedstock from the food chain and impaired food security",{"$f":"ROW(Assessment!C225)","v":225},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F32)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F32)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F32)))))","v":1},{"$f":"G32*H32","v":0},"Yes",{"$f":"--(Assessment!$F$225=J32)","v":0},null,null,1]
[null,null,null,null,null,null,null,null,null,"No",{"$f":"--(Assessment!$F$225=J33)","v":0},null,null,1]
[null,null,null,null,"Non EU and not impaired food security",null,null,null,null,null,{"$f":"K33*K31","v":0},"Add",-1,1]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I30:I34)","v":0},null,null,null,null,1]
[]
["7.4.3.4",4.4000000000000004,"Employment in bioenergy",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"4.4.1","Are people in Ireland directly employed in the cultivation / extraction or processing of the biomass?",{"$f":"ROW(Assessment!C227)","v":227},{"$f":"INDIRECT(\"Assessment!\"&G$9&$F38)","v":0},{"$f":"--OR(ISBLANK(INDIRECT(\"Assessment!\"&H$9&$F38)),NOT(ISERROR(FIND(\"--\",INDIRECT(\"Assessment!\"&H$9&$F38)))))","v":1},{"$f":"G38*H38","v":0},"Yes",{"$f":"--(Assessment!$F$227=J38)","v":0},"Add",0,{"$f":"N37+M38*K38","v":0}]
[null,null,null,null,null,null,null,null,null,"No",{"$f":"--(Assessment!$F$227=J39)","v":0},"Add",1,0]
[null,null,null,null,"Subtotal",null,null,null,{"$f":"SUM(I38:I39)","v":0},null,null,null,null,0]