{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["About","Versions","Site details","NOx compliance","PM compliance","Phases Compliance","Project emissions breakdown","GLA Compliance","Carbon Compliance","Carbon Breakdown","Scenario Comparison","NOx comparison","PM comparison","CO2 comparison","GLA NRMM Policy","Retrofit abatement","Emission Factors","Hybrid assumption","Lists"],"not_rendered":{"charts":13,"images":6,"macros":1,"external_links":0,"defined_names":15,"comments":4,"pivot_tables":11},"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":"About","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,5,31,7],[33,5,39,7],[10,0,12,12],[21,1,21,4],[17,1,17,4],[19,1,19,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Purpose"]
["This tool has been produced to: provide evidence of on-site NRMM compliance with GLA NRMM policy; and/or compare emissions between scenarios to help make decisions on the equipment used; and/or evidence any emission reductions as a result of plant selection or operation."]
[]
[]
["The detailed User Guide can be found here:",null,null,null,null,null,null,"<Link not yet available, please request>"]
[]
["Cell Formatting Guide"]
[]
[null,"Required input"]
[]
[null,"Optional input"]
[]
[null,"Output"]
[]
["Working Towards UN Sustainable Development Goals"]
[]
[null,null,null,null,null,"11.6 By 2030, reduce the adverse per capita environmental impact of cities, including by paying special attention to air quality and municipal and other waste management"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"13.2 Integrate climate change measures into national policies, strategies and planning\n13.3 Improve education, awareness-raising and human and institutional capacity on climate change mitigation, adaptation, impact reduction and early warning"]

{"sheet":"Versions","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Modification Date","Update By","Comment"]
[]
[null,null,null,1,null,"2022-01-01","SAB, JB","First NRMM emissions tool"]
[null,null,null,2,null,"2023-03-31","SAB, JB","V2 - Carbon emissions calculations. Scenario comparison"]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]

{"sheet":"Site details","index":2,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[18,21,19,22],[21,21,22,22],[1,1,1,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[7,2,7,6],[2,1,3,1],[2,2,3,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[4,8,17,22]]}
[]
[null,"USER INPUTS",null,null,null,null,null,null,"London's 'Low Emission Zone' for Non-Road Mobile Machinery (NRMM)"]
[null,"Is the site located in the Central Activity Zone or an Opportunity Area:",null,null,null,null,null,null,"https://www.london.gov.uk/programmes-and-strategies/environment-and-climate-change/pollution-and-air-quality/nrmm#development-zones-map-title"]
[]
[null,"Development name:",null,null,null,null,null,null,"The NRMM Low Emission Zone requires that all engines with a power rating between 37 kW and 560 kW meet an emission standard based on the engine emission “stage”.\nThe standards that need to be met depend on where the construction site is:\n- The current standards are stage IV for construction machinery operating in the Central Activities Zone and Opportunity Areas (including Canary Wharf) and stage IIIB in the rest of London.\n- Stages IIIB and IV have not been defined for machines with constant speed engines, such as generators. This means that these machines will need to meet stage V.\n- Stage IV has also not been directly defined for variable speed engines smaller than 56 kW. In most cases these engines will need to meet stage V if they are in the Central Activities Zone and Opportunity Areas (OAs).\n\nFuture changes to the standards\nThe standards for the NRMM Low Emission Zone will get progressively tighter over time:\n- From 1 January 2025 the standards will be stage IV throughout London;\n- From 1 of January 2030 the standards will be stage V throughout London; and\n- From 1 of January 2040 only zero emission machinery will be allowed.\n\nDevelopment zones map"]
[null,"Landowner:"]
[null,"Principal contractor:"]
[null,"Site addess:"]
[null,"Site postcode:"]
[null,"Type of project:","Building"]
[null,"Type of construction:"]
[null,"State of current site:"]
[]
[null,"Construction phases"]
[null,{"$f":"IF($C$10=\"Building\", $I43, IF($C$10=\"Infrastructure\", $J43, \"Select Project Type Above\"))","v":"Site setup and demolition"}]
[null,"Basement excavation and piling"]
[null,"Sub-structure"]
[null,"Super-structure"]
[null,"Cladding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central Activity Zone and Opportunity Areas"]
[null,"Fit-out, testing and commissioning"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other areas of Greater London"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Building","Renovation of existing building","Vacant"]
[null,null,null,null,null,null,null,null,"Infrastructure","New build","Structures to be demolished"]
[null,null,null,null,null,null,null,null,null,null,"Structures to be retained"]
[null,null,null,null,null,null,null,null,"Site setup and demolition","Site establishment, clearance & alterations"]
[null,null,null,null,null,null,null,null,"Basement excavation and piling","Excavation and foundations"]
[null,null,null,null,null,null,null,null,"Sub-structure","Sub-structure","Sub-structure relates to the part of the building that is constructed below ground level"]
[null,null,null,null,null,null,null,null,"Super-structure","Super-structure","Super-structure is the part of the building that is above ground"]
[null,null,null,null,null,null,null,null,"Cladding","Services & systems installation "]
[null,null,null,null,null,null,null,null,"Fit-out, testing and commissioning","Fit-out, testing and commissioning"]
[null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,"No"]

{"sheet":"NOx compliance","index":3,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Project NOx (kg)","Sum of Benchmark NOx (kg)"]
[15.55046341632,74.067840000000004,null,{"$f":"(GETPIVOTDATA(\"Sum of Project NOx (kg)\",$A$3)-GETPIVOTDATA(\"Sum of Benchmark NOx (kg)\",$A$3))/GETPIVOTDATA(\"Sum of Benchmark NOx (kg)\",$A$3)","v":-0.79005107457811652},{"$f":"IF(D4>0,\" over benchmark\", \" under benchmark\")","v":" under benchmark"},{"$f":"_xlfn.CONCAT(ROUND(D4*100,0),\"%\",E4)","v":"-79% under benchmark"}]

{"sheet":"PM compliance","index":4,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Project PM (kg)","Sum of Benchmark PM (kg)"]
[1.3582809688320001,3.2523840000000002,null,{"$f":"(GETPIVOTDATA(\"Sum of Project PM (kg)\",$A$3)-GETPIVOTDATA(\"Sum of Benchmark PM (kg)\",$A$3))/GETPIVOTDATA(\"Sum of Benchmark PM (kg)\",$A$3)","v":-0.58237373913043478},{"$f":"IF(D4>0,\" over benchmark\", \" under benchmark\")","v":" under benchmark"},{"$f":"_xlfn.CONCAT(ROUND(D4*100,0),\"%\",E4)","v":"-58% under benchmark"}]

{"sheet":"Phases Compliance","index":5,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels","Sum of Project NOx (kg)","Sum of Project PM (kg)",null,null,"Row Labels","Sum of Project carbon (kg)"]
["1) Site setup and demolition",2.36960059392,0.12985199683199999,null,null,"1) Site setup and demolition",4634.3052226598402]
["3) Sub-structure",4.032,0.36825000000000008,null,null,"5) Cladding",7733.8694999999998]
["6) Fit-out, testing and commissioning",5.1168628223999999,0.49192897200000002,null,null,"3) Sub-structure",7733.8694999999998]
["5) Cladding",4.032,0.36825000000000008,null,null,"6) Fit-out, testing and commissioning",683.69135127300001]
["Grand Total",15.55046341632,1.3582809688320001,null,null,"Grand Total",20785.735573932838]

{"sheet":"Project emissions breakdown","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels","Sum of Project NOx (kg)",null,null,"Row Labels","Sum of Project PM (kg)",null,null,"Row Labels","Sum of Project carbon (kg)"]
["Excavator",4.032,null,null,"Excavator",0.36825000000000008,null,null,"Excavator",7733.8694999999998]
["Telehandler",4.032,null,null,"Telehandler",0.36825000000000008,null,null,"Telehandler",7733.8694999999998]
["Constant speed engine (e.g. Generator)",2.36960059392,null,null,"Constant speed engine (e.g. Generator)",0.12985199683199999,null,null,"Constant speed engine (e.g. Generator)",4634.3052226598402]
["Cleaning equipment",5.1168628223999999,null,null,"Cleaning equipment",0.49192897200000002,null,null,"Cleaning equipment",683.69135127300001]
["Grand Total",15.55046341632,null,null,"Grand Total",1.3582809688320001,null,null,"Grand Total",20785.735573932838]

{"sheet":"GLA Compliance","index":7,"n_rows":34,"n_cols":28,"rows_kept":34,"cut":false,"hidden":false,"merged":[[26,0,28,1],[27,4,27,5],[26,6,28,6],[26,9,28,10]]}
[]
[null,null,null,"GLA NRMM Policy Compliance Tracker",null,null,null,null,null,null,"NOx emissions",{"$f":"'NOx compliance'!F4","v":"-79% under benchmark"},null,"PM emissions",{"$f":"'PM compliance'!F4","v":"-58% under benchmark"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Input",null,null,null,null,null,"Construction year:",null,null,"Output"]
[null,null,"GLA NRMM policy area:",null,"Other areas of Greater London",null,null,2023]
[]
["Unique ID","Construction Phase","Equipment type","Estimated usage (hrs)","Power rating (kW)","Technology/ fuel type","EU Stage","Abatement technology","Resultant EU Stage","Compliance check","Project assumed EU stage","Project NOx (kg)","Project PM (kg)","Benchmark assumed EU stage","Benchmark NOx (kg)","Benchmark PM (kg)","Power rating range","Project EU Stage","Project Diesel NOx emission factor g/kWh","Project Diesel PM emission factor g/kWh","Project LPG NOx EF g/kWh","Project LPG PM EF g/kWh","Project Hybrid NOx EF g/kWh","Project Hybrid PM EF g/kWh","Project Biodiesel NOx EF g/kWh","Project Biodiesel PM EF g/kWh","Benchmark NOx EF g/kWh","Benchmark PM EF g/kWh"]
[1,"1) Site setup and demolition","Constant speed engine (e.g. Generator)",100,72,"Hybrid","EU Stage V",null,"n/a",{"$f":"IF(MATCH(GLA_Input[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(GLA_Input[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\",GLA_Input[[#This Row],[Resultant EU Stage]]=0),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid NOx EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":2.36960059392},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid PM EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.12985199683199999},{"$f":"IF(GLA_Input[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(GLA_Input[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$C$6,VLOOKUP('GLA Compliance'!$E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage V"},{"$f":"GLA_Input[[#This Row],[Benchmark NOx EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":2.9030399999999998},{"$f":"GLA_Input[[#This Row],[Benchmark PM EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.15908399999999998},{"$f":"IF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"56≤ kW <75"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\"),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":2.2095E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]","v":0.32911119360000002},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]","v":1.8034999560000001E-2},{"$f":"GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":1.98855E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":2.2095E-2}]
[2,"3) Sub-structure","Excavator",100,100,"Diesel","EU Stage IV",null,"n/a",{"$f":"IF(MATCH(GLA_Input[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(GLA_Input[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\",GLA_Input[[#This Row],[Resultant EU Stage]]=0),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid NOx EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":4.032},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid PM EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.36825000000000008},{"$f":"IF(GLA_Input[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(GLA_Input[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$C$6,VLOOKUP('GLA Compliance'!$E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage IIIB"},{"$f":"GLA_Input[[#This Row],[Benchmark NOx EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":29.937600000000003},{"$f":"GLA_Input[[#This Row],[Benchmark PM EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.36825000000000008},{"$f":"IF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\"),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":2.9937600000000004},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":3.6825000000000004E-2}]
[3,"5) Cladding","Telehandler",100,100,"Diesel","EU Stage IV",null,"n/a",{"$f":"IF(MATCH(GLA_Input[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(GLA_Input[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\",GLA_Input[[#This Row],[Resultant EU Stage]]=0),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid NOx EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":4.032},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid PM EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.36825000000000008},{"$f":"IF(GLA_Input[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(GLA_Input[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$C$6,VLOOKUP('GLA Compliance'!$E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage IIIB"},{"$f":"GLA_Input[[#This Row],[Benchmark NOx EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":29.937600000000003},{"$f":"GLA_Input[[#This Row],[Benchmark PM EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.36825000000000008},{"$f":"IF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\"),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":2.9937600000000004},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":3.6825000000000004E-2}]
[4,"6) Fit-out, testing and commissioning","Cleaning equipment",100,10,"Hybrid","EU Stage V",null,"n/a",{"$f":"IF(MATCH(GLA_Input[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(GLA_Input[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\",GLA_Input[[#This Row],[Resultant EU Stage]]=0),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel NOx EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid NOx EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":5.1168628223999999},{"$f":"IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$8,GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$9,GLA_Input[[#This Row],[Project LPG PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$10,GLA_Input[[#This Row],[Project Biodiesel PM EF g/kWh]],IF(GLA_Input[[#This Row],[Technology/ fuel type]]=Lists!$N$11,GLA_Input[[#This Row],[Project Hybrid PM EF g/kWh]],0))))*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":0.49192897200000002},{"$f":"IF(GLA_Input[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(GLA_Input[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$C$6,VLOOKUP('GLA Compliance'!$E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF('GLA Compliance'!$H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage IIIB"},{"$f":"GLA_Input[[#This Row],[Benchmark NOx EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":11.2896},{"$f":"GLA_Input[[#This Row],[Benchmark PM EF g/kWh]]*GLA_Input[[#This Row],[Estimated usage (hrs)]]*GLA_Input[[#This Row],[Power rating (kW)]]/1000","v":2.3568000000000002},{"$f":"IF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(GLA_Input[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"8≤ kW <19"},{"$f":"IF(OR(GLA_Input[[#This Row],[Resultant EU Stage]]=\"n/a\",GLA_Input[[#This Row],[Resultant EU Stage]]=\"\"),GLA_Input[[#This Row],[EU Stage]],GLA_Input[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":6.1286399999999999},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Project EU Stage]])","v":0.58920000000000006},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]","v":5.1168628223999999},{"$f":"(1-(((0.0301*GLA_Input[[#This Row],[Power rating (kW)]])+16.208)/100))*GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]","v":0.49192897200000008},{"$f":"GLA_Input[[#This Row],[Project Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":6.2512128000000002},{"$f":"GLA_Input[[#This Row],[Project Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":0.53028000000000008},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":11.2896},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,GLA_Input[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,GLA_Input[[#This Row],[Benchmark assumed EU stage]])","v":2.3568000000000002}]

{"sheet":"Carbon Compliance","index":8,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Project carbon (kg)","Sum of Benchmark carbon (kg)"]
[20785.735573932838,21964.18938]

{"sheet":"Carbon Breakdown","index":9,"n_rows":34,"n_cols":29,"rows_kept":34,"cut":false,"hidden":false,"merged":[[26,0,28,1],[26,6,28,6],[26,9,28,10],[27,4,27,5]]}
[]
[null,null,null,"Carbon Breakdown"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Input",null,null,null,null,null,"Construction year:",null,null,"Output"]
[null,null,"GLA NRMM policy area:",null,"Other areas of Greater London",null,null,2023]
[]
["Unique ID","Construction Phase","Equipment type","Estimated usage (hrs)","Power rating (kW)","Technology/ fuel type","EU Stage","Abatement technology","Resultant EU Stage","Compliance check","Project assumed EU stage","Project carbon (kg)","Benchmark assumed EU stage","Benchmark carbon (kg)","Power rating range","Project EU Stage","Project Fuel factor g/kWh","Project fuel use g","Diesel Project Carbon factor kg CO2 per g fuel","Diesel Project Carbon emissions kg","LPG Project CO2 emissions kg","Hybrid Project fuel use g","Hybrid Project Carbon emissions kg","Biodiesel Project Carbon factor kg CO2 per g fuel","Biodiesel Project Carbon emissions kg","Electric /battery Project Carbon emissions kg","Benchmark fuel factor g/kWh","Benchmark fuel use g","Benchmark Carbon factor kg CO2 per g fuel"]
[1,"1) Site setup and demolition","Constant speed engine (e.g. Generator)",100,72,"Hybrid","EU Stage V",{"$f":"GLA_Input[[#This Row],[Abatement technology]]","v":0},{"$f":"GLA_Input[[#This Row],[Resultant EU Stage]]","v":"n/a"},{"$f":"IF(MATCH(Carbon[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(Carbon[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\",Carbon[[#This Row],[Resultant EU Stage]]=0),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"IF(F31=Lists!$N$8,Carbon[[#This Row],[Diesel Project Carbon emissions kg]],IF(F31=Lists!$N$9,Carbon[[#This Row],[LPG Project CO2 emissions kg]],IF(F31=Lists!$N$10,Carbon[[#This Row],[Biodiesel Project Carbon emissions kg]],IF(F31=Lists!$N$11,Carbon[[#This Row],[Hybrid Project Carbon emissions kg]],Carbon[[#This Row],[Electric /battery Project Carbon emissions kg]]))))","v":4634.3052226598402},{"$f":"IF(Carbon[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(Carbon[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF($H$28<'GLA NRMM Policy'!$C$6,VLOOKUP($E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF($H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF($H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage V"},{"$f":"Carbon[[#This Row],[Benchmark fuel use g]]*Carbon[[#This Row],[Benchmark Carbon factor kg CO2 per g fuel]]","v":5677.5700799999995},{"$f":"IF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"56≤ kW <75"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\"),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[EU Stage]])","v":260},{"$f":"Carbon[[#This Row],[Project Fuel factor g/kWh]]*Carbon[[#This Row],[Power rating (kW)]]*Carbon[[#This Row],[Estimated usage (hrs)]]","v":1872000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":5677.5700799999995},{"$f":"Carbon[[#This Row],[Power rating (kW)]]*'Emission Factors'!$X$10*Carbon[[#This Row],[Estimated usage (hrs)]]","v":1658.232},{"$f":"(1-(((0.0301*Carbon[[#This Row],[Power rating (kW)]])+16.208)/100))*Carbon[[#This Row],[Project fuel use g]]","v":1528016.2560000001},{"$f":"Carbon[[#This Row],[Hybrid Project fuel use g]]*Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]","v":4634.3052226598402},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Carbon[[#This Row],[Biodiesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":85.400639999999981},{"$f":"'Emission Factors'!$X$13*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":1392.336},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[Benchmark assumed EU stage]])","v":260},{"$f":"Carbon[[#This Row],[Benchmark fuel factor g/kWh]]*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":1872000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3}]
[2,"3) Sub-structure","Excavator",100,100,"Diesel","EU Stage IV",{"$f":"GLA_Input[[#This Row],[Abatement technology]]","v":0},{"$f":"GLA_Input[[#This Row],[Resultant EU Stage]]","v":"n/a"},{"$f":"IF(MATCH(Carbon[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(Carbon[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\",Carbon[[#This Row],[Resultant EU Stage]]=0),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(F32=Lists!$N$8,Carbon[[#This Row],[Diesel Project Carbon emissions kg]],IF(F32=Lists!$N$9,Carbon[[#This Row],[LPG Project CO2 emissions kg]],IF(F32=Lists!$N$10,Carbon[[#This Row],[Biodiesel Project Carbon emissions kg]],IF(F32=Lists!$N$11,Carbon[[#This Row],[Hybrid Project Carbon emissions kg]],Carbon[[#This Row],[Electric /battery Project Carbon emissions kg]]))))","v":7733.8694999999998},{"$f":"IF(Carbon[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(Carbon[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF($H$28<'GLA NRMM Policy'!$C$6,VLOOKUP($E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF($H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF($H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage IIIB"},{"$f":"Carbon[[#This Row],[Benchmark fuel use g]]*Carbon[[#This Row],[Benchmark Carbon factor kg CO2 per g fuel]]","v":7733.8694999999998},{"$f":"IF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\"),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[EU Stage]])","v":255},{"$f":"Carbon[[#This Row],[Project Fuel factor g/kWh]]*Carbon[[#This Row],[Power rating (kW)]]*Carbon[[#This Row],[Estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":7733.8694999999998},{"$f":"Carbon[[#This Row],[Power rating (kW)]]*'Emission Factors'!$X$10*Carbon[[#This Row],[Estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Carbon[[#This Row],[Power rating (kW)]])+16.208)/100))*Carbon[[#This Row],[Project fuel use g]]","v":2059941},{"$f":"Carbon[[#This Row],[Hybrid Project fuel use g]]*Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Carbon[[#This Row],[Biodiesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":1933.8000000000002},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[Benchmark assumed EU stage]])","v":255},{"$f":"Carbon[[#This Row],[Benchmark fuel factor g/kWh]]*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3}]
[3,"5) Cladding","Telehandler",100,100,"Diesel","EU Stage IV",{"$f":"GLA_Input[[#This Row],[Abatement technology]]","v":0},{"$f":"GLA_Input[[#This Row],[Resultant EU Stage]]","v":"n/a"},{"$f":"IF(MATCH(Carbon[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(Carbon[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\",Carbon[[#This Row],[Resultant EU Stage]]=0),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(F33=Lists!$N$8,Carbon[[#This Row],[Diesel Project Carbon emissions kg]],IF(F33=Lists!$N$9,Carbon[[#This Row],[LPG Project CO2 emissions kg]],IF(F33=Lists!$N$10,Carbon[[#This Row],[Biodiesel Project Carbon emissions kg]],IF(F33=Lists!$N$11,Carbon[[#This Row],[Hybrid Project Carbon emissions kg]],Carbon[[#This Row],[Electric /battery Project Carbon emissions kg]]))))","v":7733.8694999999998},{"$f":"IF(Carbon[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(Carbon[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF($H$28<'GLA NRMM Policy'!$C$6,VLOOKUP($E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF($H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF($H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage IIIB"},{"$f":"Carbon[[#This Row],[Benchmark fuel use g]]*Carbon[[#This Row],[Benchmark Carbon factor kg CO2 per g fuel]]","v":7733.8694999999998},{"$f":"IF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\"),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[EU Stage]])","v":255},{"$f":"Carbon[[#This Row],[Project Fuel factor g/kWh]]*Carbon[[#This Row],[Power rating (kW)]]*Carbon[[#This Row],[Estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":7733.8694999999998},{"$f":"Carbon[[#This Row],[Power rating (kW)]]*'Emission Factors'!$X$10*Carbon[[#This Row],[Estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Carbon[[#This Row],[Power rating (kW)]])+16.208)/100))*Carbon[[#This Row],[Project fuel use g]]","v":2059941},{"$f":"Carbon[[#This Row],[Hybrid Project fuel use g]]*Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Carbon[[#This Row],[Biodiesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":1933.8000000000002},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[Benchmark assumed EU stage]])","v":255},{"$f":"Carbon[[#This Row],[Benchmark fuel factor g/kWh]]*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3}]
[4,"6) Fit-out, testing and commissioning","Cleaning equipment",100,10,"Hybrid","EU Stage V",{"$f":"GLA_Input[[#This Row],[Abatement technology]]","v":0},{"$f":"GLA_Input[[#This Row],[Resultant EU Stage]]","v":"n/a"},{"$f":"IF(MATCH(Carbon[[#This Row],[Project assumed EU stage]],Lists!$C$8:$C$14,0)>=MATCH(Carbon[[#This Row],[Benchmark assumed EU stage]],Lists!$C$8:$C$14,0),\"Compliant\",\"Non-compliant\")","v":"Compliant"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\",Carbon[[#This Row],[Resultant EU Stage]]=0),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"IF(F34=Lists!$N$8,Carbon[[#This Row],[Diesel Project Carbon emissions kg]],IF(F34=Lists!$N$9,Carbon[[#This Row],[LPG Project CO2 emissions kg]],IF(F34=Lists!$N$10,Carbon[[#This Row],[Biodiesel Project Carbon emissions kg]],IF(F34=Lists!$N$11,Carbon[[#This Row],[Hybrid Project Carbon emissions kg]],Carbon[[#This Row],[Electric /battery Project Carbon emissions kg]]))))","v":683.69135127300001},{"$f":"IF(Carbon[[#This Row],[Estimated usage (hrs)]]=0,\"\",IFERROR(IF(Carbon[[#This Row],[Equipment type]]=Lists!$A$31,'GLA NRMM Policy'!$B$11,IF($H$28<'GLA NRMM Policy'!$C$6,VLOOKUP($E$28,'GLA NRMM Policy'!$A$7:$B$9,2,0),\nIF($H$28<'GLA NRMM Policy'!$D$6,'GLA NRMM Policy'!$C$7,\nIF($H$28<'GLA NRMM Policy'!$E$6,'GLA NRMM Policy'!$D$7,'GLA NRMM Policy'!$E$7)))),\"\"))","v":"EU Stage IIIB"},{"$f":"Carbon[[#This Row],[Benchmark fuel use g]]*Carbon[[#This Row],[Benchmark Carbon factor kg CO2 per g fuel]]","v":818.88029999999992},{"$f":"IF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Carbon[[#This Row],[Power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"8≤ kW <19"},{"$f":"IF(OR(Carbon[[#This Row],[Resultant EU Stage]]=\"n/a\",Carbon[[#This Row],[Resultant EU Stage]]=\"\"),Carbon[[#This Row],[EU Stage]],Carbon[[#This Row],[Resultant EU Stage]])","v":"EU Stage V"},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[EU Stage]])","v":270},{"$f":"Carbon[[#This Row],[Project Fuel factor g/kWh]]*Carbon[[#This Row],[Power rating (kW)]]*Carbon[[#This Row],[Estimated usage (hrs)]]","v":270000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":818.88029999999992},{"$f":"Carbon[[#This Row],[Power rating (kW)]]*'Emission Factors'!$X$10*Carbon[[#This Row],[Estimated usage (hrs)]]","v":230.30999999999997},{"$f":"(1-(((0.0301*Carbon[[#This Row],[Power rating (kW)]])+16.208)/100))*Carbon[[#This Row],[Project fuel use g]]","v":225425.7},{"$f":"Carbon[[#This Row],[Hybrid Project fuel use g]]*Carbon[[#This Row],[Diesel Project Carbon factor kg CO2 per g fuel]]","v":683.69135127300001},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Carbon[[#This Row],[Biodiesel Project Carbon factor kg CO2 per g fuel]]*Carbon[[#This Row],[Project fuel use g]]","v":12.317399999999997},{"$f":"'Emission Factors'!$X$13*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":193.38},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Carbon[[#This Row],[Power rating range]],'Emission Factors'!$J:$J,Carbon[[#This Row],[Benchmark assumed EU stage]])","v":270},{"$f":"Carbon[[#This Row],[Benchmark fuel factor g/kWh]]*Carbon[[#This Row],[Estimated usage (hrs)]]*Carbon[[#This Row],[Power rating (kW)]]","v":270000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3}]

{"sheet":"Scenario Comparison","index":10,"n_rows":28,"n_cols":62,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,7,1,8],[1,10,1,11],[1,13,1,14],[20,12,22,12]]}
[]
[null,null,null,"Scenario comparison",null,null,null,{"$f":"'NOx comparison'!F4","v":"NOx: Baseline 22% more than Alternative Scenario"},null,null,{"$f":"'PM comparison'!F4","v":"PM: Baseline 16% more than Alternative Scenario"},null,null,{"$f":"'CO2 comparison'!F4","v":"Carbon: Baseline 69% less than Alternative Scenario"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Alternative scenario"]
["Baseline",null,null,null,null,null,null,null,"% reduction",0,0,0,null,null,null,null,null,null,"% reduction",0,0,0]
[]
["Unique ID","Construction Phase","Baseline equipment type ","Baseline estimated usage (hrs)","Baseline power rating  (kW)","Baseline technology/ fuel type","Baseline EU Stage ","Baseline abatement technology","Baseline resultant EU Stage","Baseline NOx kg","Baseline PM kg","Baseline Carbon kg","Alternative scenario equipment type","Alternative scenario estimated usage (hrs)","Alternative scenario power rating (kW)","Alternative scenario technology/ fuel type","Alternative scenario EU Stage","Alternative scenario abatement technology","Alternative scenario resultant EU Stage","Alternative scenario NOx kg","Alternative secenario PM kg","Alternative scenario Carbon kg","Power rating range A","Power rating range B","Final EU Stage A","Final EU Stage B","A Diesel NOx emission factor g/kWh","A Diesel PM emission factor g/kWh","A LPG NOx EF g/kWh","A LPG PM EF g/kWh","A Hybrid NOx EF g/kWh","A Hybrid PM EF g/kWh","A Biodiesel NOx EF g/kWh","A Biodiesel PM EF g/kWh","B Diesel NOx emission factor g/kWh","B Diesel PM emission factor g/kWh","B LPG NOx EF g/kWh","B LPG PM EF g/kWh","B Hybrid NOx EF g/kWh","B Hybrid PM EF g/kWh","B Biodiesel NOx EF g/kWh","B Biodiesel PM EF g/kWh","A Fuel factor g/kWh","A fuel use g","A Diesel Carbon factor kg CO2 per g fuel","A Diesel Carbon emissions kg","A LPG CO2 emissions kg","A Hybrid fuel use g","A Hybrid Carbon emissions kg","A Biodiesel Carbon factor kg CO2 per g fuel","A Biodiesel Carbon emissions kg","A Electric /battery Carbon emissions kg","B Fuel factor g/kWh","B fuel use g","B Diesel Carbon factor kg CO2 per g fuel","B Diesel Carbon emissions kg","B LPG CO2 emissions kg","B Hybrid fuel use g","B Hybrid Carbon emissions kg","B Biodiesel Carbon factor kg CO2 per g fuel","B Biodiesel Carbon emissions kg","B Electric /battery Carbon emissions kg"]
[1,"1) Site setup and demolition","Crusher",100,100,"Diesel","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$J$22)","v":4.032},{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$K$22)","v":0.36825000000000008},{"$f":"IF(F31=Lists!$N$8,Scenarios[[#This Row],[A Diesel Carbon emissions kg]],IF(F31=Lists!$N$9,Scenarios[[#This Row],[A LPG CO2 emissions kg]],IF(F31=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel Carbon emissions kg]],IF(F31=Lists!$N$11,Scenarios[[#This Row],[A Hybrid Carbon emissions kg]],Scenarios[[#This Row],[A Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":1933.8000000000002},"Crusher",100,100,"Hybrid","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$T$22)","v":3.25713024},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$U$22)","v":0.29747971499999998},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG CO2 emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid Carbon emissions kg]],Scenarios[[#This Row],[B Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":6247.5744594899998},{"$f":"IF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Baseline EU Stage ]],Scenarios[[#This Row],[Baseline resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(OR(Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Alternative scenario EU Stage]],Scenarios[[#This Row],[Alternative scenario resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":255},{"$f":"Scenarios[[#This Row],[A Fuel factor g/kWh]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":7733.8694999999998},{"$f":"Scenarios[[#This Row],[Baseline power rating  (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A fuel use g]]","v":2059941},{"$f":"Scenarios[[#This Row],[A Hybrid fuel use g]]*Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[A Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]","v":1933.8000000000002},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Alternative scenario EU Stage]])","v":255},{"$f":"Scenarios[[#This Row],[B Fuel factor g/kWh]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":7733.8694999999998},{"$f":"Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B fuel use g]]","v":2059941},{"$f":"Scenarios[[#This Row],[B Hybrid fuel use g]]*Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[B Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]","v":1933.8000000000002}]
[2,"3) Sub-structure","Excavator",100,100,"Diesel","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$J$22)","v":4.032},{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$K$22)","v":0.36825000000000008},{"$f":"IF(F32=Lists!$N$8,Scenarios[[#This Row],[A Diesel Carbon emissions kg]],IF(F32=Lists!$N$9,Scenarios[[#This Row],[A LPG CO2 emissions kg]],IF(F32=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel Carbon emissions kg]],IF(F32=Lists!$N$11,Scenarios[[#This Row],[A Hybrid Carbon emissions kg]],Scenarios[[#This Row],[A Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":1933.8000000000002},"Excavator",100,100,"Hybrid","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$T$22)","v":3.25713024},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$U$22)","v":0.29747971499999998},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG CO2 emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid Carbon emissions kg]],Scenarios[[#This Row],[B Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":6247.5744594899998},{"$f":"IF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Baseline EU Stage ]],Scenarios[[#This Row],[Baseline resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(OR(Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Alternative scenario EU Stage]],Scenarios[[#This Row],[Alternative scenario resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":255},{"$f":"Scenarios[[#This Row],[A Fuel factor g/kWh]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":7733.8694999999998},{"$f":"Scenarios[[#This Row],[Baseline power rating  (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A fuel use g]]","v":2059941},{"$f":"Scenarios[[#This Row],[A Hybrid fuel use g]]*Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[A Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]","v":1933.8000000000002},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Alternative scenario EU Stage]])","v":255},{"$f":"Scenarios[[#This Row],[B Fuel factor g/kWh]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":7733.8694999999998},{"$f":"Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B fuel use g]]","v":2059941},{"$f":"Scenarios[[#This Row],[B Hybrid fuel use g]]*Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[B Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]","v":1933.8000000000002}]
[3,"6) Fit-out, testing and commissioning","Cranes/lifts/platform",100,100,"Diesel","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$J$22)","v":4.032},{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$K$22)","v":0.36825000000000008},{"$f":"IF(F33=Lists!$N$8,Scenarios[[#This Row],[A Diesel Carbon emissions kg]],IF(F33=Lists!$N$9,Scenarios[[#This Row],[A LPG CO2 emissions kg]],IF(F33=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel Carbon emissions kg]],IF(F33=Lists!$N$11,Scenarios[[#This Row],[A Hybrid Carbon emissions kg]],Scenarios[[#This Row],[A Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":1933.8000000000002},"Cranes/lifts/platform",100,100,"Hybrid","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$T$22)","v":3.25713024},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$U$22)","v":0.29747971499999998},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG CO2 emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid Carbon emissions kg]],Scenarios[[#This Row],[B Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":6247.5744594899998},{"$f":"IF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"75≤ kW <130"},{"$f":"IF(OR(Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Baseline EU Stage ]],Scenarios[[#This Row],[Baseline resultant EU Stage]])","v":"EU Stage IV"},{"$f":"IF(OR(Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Alternative scenario EU Stage]],Scenarios[[#This Row],[Alternative scenario resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":0.4032},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]","v":0.32571302400000002},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]","v":2.9747971500000001E-2},{"$f":"Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":0.41126400000000002},{"$f":"Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":255},{"$f":"Scenarios[[#This Row],[A Fuel factor g/kWh]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":7733.8694999999998},{"$f":"Scenarios[[#This Row],[Baseline power rating  (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A fuel use g]]","v":2059941},{"$f":"Scenarios[[#This Row],[A Hybrid fuel use g]]*Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[A Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]","v":1933.8000000000002},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Alternative scenario EU Stage]])","v":255},{"$f":"Scenarios[[#This Row],[B Fuel factor g/kWh]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":2550000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":7733.8694999999998},{"$f":"Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":2303.1},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B fuel use g]]","v":2059941},{"$f":"Scenarios[[#This Row],[B Hybrid fuel use g]]*Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]","v":6247.5744594899998},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[B Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":116.33099999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]","v":1933.8000000000002}]
[4,"6) Fit-out, testing and commissioning","Cleaning equipment",100,50,"Diesel","EU Stage V",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$J$22)","v":19.202400000000001},{"$f":"IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[A LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Baseline technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[A Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]/1000*(1-$K$22)","v":0.11047499999999999},{"$f":"IF(F34=Lists!$N$8,Scenarios[[#This Row],[A Diesel Carbon emissions kg]],IF(F34=Lists!$N$9,Scenarios[[#This Row],[A LPG CO2 emissions kg]],IF(F34=Lists!$N$10,Scenarios[[#This Row],[A Biodiesel Carbon emissions kg]],IF(F34=Lists!$N$11,Scenarios[[#This Row],[A Hybrid Carbon emissions kg]],Scenarios[[#This Row],[A Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":966.90000000000009},"Cleaning equipment",100,50,"Hybrid","EU Stage IV",null,"n/a",{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel NOx EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid NOx EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$T$22)","v":15.801078887999999},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel PM EF g/kWh]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid PM EF g/kWh]],0))))*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]/1000*(1-$U$22)","v":0.15151093875000002},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$8,Scenarios[[#This Row],[B Diesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$9,Scenarios[[#This Row],[B LPG CO2 emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$10,Scenarios[[#This Row],[B Biodiesel Carbon emissions kg]],IF(Scenarios[[#This Row],[Alternative scenario technology/ fuel type]]=Lists!$N$11,Scenarios[[#This Row],[B Hybrid Carbon emissions kg]],Scenarios[[#This Row],[B Electric /battery Carbon emissions kg]]))))*(1-$L$22)","v":3244.3764525900001},{"$f":"IF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Baseline power rating  (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"37≤ kW <56"},{"$f":"IF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$8,Lists!$E$8,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$9,Lists!$E$9,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$10,Lists!$E$10,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$11,Lists!$E$11,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$12,Lists!$E$12,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$13,Lists!$E$13,\nIF(Scenarios[[#This Row],[Alternative scenario power rating (kW)]]<Lists!$F$14,Lists!$E$14,Lists!$E$15)))))))","v":"37≤ kW <56"},{"$f":"IF(OR(Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Baseline resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Baseline EU Stage ]],Scenarios[[#This Row],[Baseline resultant EU Stage]])","v":"EU Stage V"},{"$f":"IF(OR(Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"n/a\",Scenarios[[#This Row],[Alternative scenario resultant EU Stage]]=\"\"),Scenarios[[#This Row],[Alternative scenario EU Stage]],Scenarios[[#This Row],[Alternative scenario resultant EU Stage]])","v":"EU Stage IV"},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":3.8404799999999999},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":2.2095E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]","v":3.1602157775999999},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]","v":1.818131265E-2},{"$f":"Scenarios[[#This Row],[A Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":3.9172896000000001},{"$f":"Scenarios[[#This Row],[A Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":1.98855E-2},{"$f":"SUMIFS('Emission Factors'!$K:$K,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":3.8404799999999999},{"$f":"SUMIFS('Emission Factors'!$L:$L,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Final EU Stage B]])","v":3.6825000000000004E-2},{"$f":"'Emission Factors'!$P$10","v":10},{"$f":"'Emission Factors'!$R$10","v":7.0000000000000007E-2},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]","v":3.1602157775999999},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]","v":3.0302187750000001E-2},{"$f":"Scenarios[[#This Row],[B Diesel NOx emission factor g/kWh]]*'Emission Factors'!$Q$11","v":3.9172896000000001},{"$f":"Scenarios[[#This Row],[B Diesel PM emission factor g/kWh]]*'Emission Factors'!$S$11","v":3.3142500000000005E-2},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range A]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Baseline EU Stage ]])","v":260},{"$f":"Scenarios[[#This Row],[A Fuel factor g/kWh]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":1300000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":3942.7570000000001},{"$f":"Scenarios[[#This Row],[Baseline power rating  (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]","v":1151.55},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Baseline power rating  (kW)]])+16.208)/100))*Scenarios[[#This Row],[A fuel use g]]","v":1069731},{"$f":"Scenarios[[#This Row],[A Hybrid fuel use g]]*Scenarios[[#This Row],[A Diesel Carbon factor kg CO2 per g fuel]]","v":3244.3764525900001},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[A Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[A fuel use g]]","v":59.30599999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Baseline estimated usage (hrs)]]*Scenarios[[#This Row],[Baseline power rating  (kW)]]","v":966.90000000000009},{"$f":"SUMIFS('Emission Factors'!$M:$M,'Emission Factors'!$I:$I,Scenarios[[#This Row],[Power rating range B]],'Emission Factors'!$J:$J,Scenarios[[#This Row],[Alternative scenario EU Stage]])","v":260},{"$f":"Scenarios[[#This Row],[B Fuel factor g/kWh]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":1300000},{"$f":"'Emission Factors'!$W$9","v":3.0328899999999999E-3},{"$f":"Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":3942.7570000000001},{"$f":"Scenarios[[#This Row],[Alternative scenario power rating (kW)]]*'Emission Factors'!$X$10*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]","v":1151.55},{"$f":"(1-(((0.0301*Scenarios[[#This Row],[Alternative scenario power rating (kW)]])+16.208)/100))*Scenarios[[#This Row],[B fuel use g]]","v":1069731},{"$f":"Scenarios[[#This Row],[B Hybrid fuel use g]]*Scenarios[[#This Row],[B Diesel Carbon factor kg CO2 per g fuel]]","v":3244.3764525900001},{"$f":"'Emission Factors'!$W$11","v":4.5619999999999994E-5},{"$f":"Scenarios[[#This Row],[B Biodiesel Carbon factor kg CO2 per g fuel]]*Scenarios[[#This Row],[B fuel use g]]","v":59.30599999999999},{"$f":"'Emission Factors'!$X$13*Scenarios[[#This Row],[Alternative scenario estimated usage (hrs)]]*Scenarios[[#This Row],[Alternative scenario power rating (kW)]]","v":966.90000000000009}]

{"sheet":"NOx comparison","index":11,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Baseline NOx kg","Sum of Alternative Scenario NOx kg"]
[31.298400000000001,25.572469607999999,null,{"$f":"(GETPIVOTDATA(\"Sum of Baseline NOx kg\",$A$3)-GETPIVOTDATA(\"Sum of Alternative Scenario NOx kg\",$A$3))/GETPIVOTDATA(\"Sum of Alternative Scenario NOx kg\",$A$3)","v":0.22390995002722469},{"$f":"IF(D4>0,\" more than Alternative Scenario\", \" less than Alternatvie Scenario\")","v":" more than Alternative Scenario"},{"$f":"_xlfn.CONCAT(\"NOx: Baseline \",ABS(ROUND(D4*100,0)),\"%\",E4)","v":"NOx: Baseline 22% more than Alternative Scenario"}]

{"sheet":"PM comparison","index":12,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Baseline PM kg","Sum of Alternative Scenario PM kg"]
[1.2152250000000002,1.04395008375,null,{"$f":"(GETPIVOTDATA(\"Sum of Baseline PM kg\",$A$3)-GETPIVOTDATA(\"Sum of Alternative Scenario PM kg\",$A$3))/GETPIVOTDATA(\"Sum of Alternative Scenario PM kg\",$A$3)","v":0.16406427751292399},{"$f":"IF(D4>0,\" more than Alternative Scenario\", \" less than Alternative Scenario\")","v":" more than Alternative Scenario"},{"$f":"_xlfn.CONCAT(\"PM: Baseline \",ABS(ROUND(D4*100,0)),\"%\",E4)","v":"PM: Baseline 16% more than Alternative Scenario"}]

{"sheet":"CO2 comparison","index":13,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Sum of Baseline Carbon kg","Sum of Alternative Scenario Carbon kg"]
[6768.3000000000011,21987.099831060001,null,{"$f":"(GETPIVOTDATA(\"Sum of Baseline Carbon kg\",$A$3)-GETPIVOTDATA(\"Sum of Alternative Scenario Carbon kg\",$A$3))/GETPIVOTDATA(\"Sum of Alternative Scenario Carbon kg\",$A$3)","v":-0.69216949702303232},{"$f":"IF(D4>0,\" more than Alternative Scenario\", \" less than Alternative Scenario\")","v":" less than Alternative Scenario"},{"$f":"_xlfn.CONCAT(\"Carbon: Baseline \",ABS(ROUND(D4*100,0)),\"%\",E4)","v":"Carbon: Baseline 69% less than Alternative Scenario"}]

{"sheet":"GLA NRMM Policy","index":14,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["GLA NRMM policy areas",null,2025,2030,2040]
["Central Activity Zone and Canary Wharf","EU Stage IV","EU Stage IV","EU Stage V","Electric"]
["Opportunity Area","EU Stage IV","EU Stage IV","EU Stage V","Electric"]
["Other areas of Greater London","EU Stage IIIB","EU Stage IV","EU Stage V","Electric"]
[]
["Constant Speed Engines (Generators)","EU Stage V","EU Stage V","EU Stage V","Electric"]

{"sheet":"Retrofit abatement","index":15,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Refer to guidance on resultant EU Stage from certified abatement:"]
["https://energysavingtrust.org.uk/service/non-road-mobile-machinery-certification/"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["             Diesel Particulate Filter (DPF)"]
["             Selective Catalytic Reduction (SCR)"]

{"sheet":"Emission Factors","index":16,"n_rows":88,"n_cols":24,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["1.A.2.g vii","EMEP/EEA 2019",null,null,null,null,null,"Adjusted with deterioration factor and \"Middle\" Load factor",null,null,null,null,null,null,null,null,null,null,null,null,null,"g to tonne",9.9999999999999995E-7]
["Tier 3",null,null,null,null,null,null,"Tier 3",null,null,null,null,null,null,"Alternative Fuels"]
["Fuel","Engine Power","Stage","NOx\ng/kWh","PM\ng/kWh","Fuel Consumption (FC)\ng/kWH",null,"Fuel","Engine Power","Stage","NOx\ng/kWh","PM\ng/kWh","Fuel Consumption (FC)\ng/kWH",null,"Fuel","NOx\ng/kWh","NOx factor","PM\ng/kWh","PM factor","Fuel Consumption (FC)\ng/kWH","FC factor","Carbon factor\nkg CO2e per tonne fuel","Carbon factor\nkg CO2e per g fuel","Carbon factor\nkg CO2e per kWh "]
["Diesel","kW <8","EU Stage I",11.2,1.6,270,null,"Diesel","kW <8","EU Stage I",{"$f":"D9*_xlfn.XLOOKUP(J9,$H$61:$H$67,$I$61:$I$67,,0,)*_xlfn.XLOOKUP(J9,$H$77:$H$82,$K$77:$K$82,,0,)","v":11.755519999999999},{"$f":"E9*_xlfn.XLOOKUP(J9,$H$61:$H$67,$J$61:$J$67,,0,)*_xlfn.XLOOKUP(J9,$H$77:$H$82,$L$77:$L$82,,0,)","v":3.7708800000000005},{"$f":"F9*_xlfn.XLOOKUP(J9,$H$77:$H$82,$M$77:$M$82,,0,)","v":295.64999999999998},null,"Diesel","-","-","-","-","-","-",3032.89,{"$f":"V9*$W$6","v":3.0328899999999999E-3}]
[null,"kW <8","EU Stage II",{"$f":"D9","v":11.2},{"$f":"E9","v":1.6},270,null,null,"kW <8","EU Stage II",{"$f":"D10*_xlfn.XLOOKUP(J10,$H$61:$H$67,$I$61:$I$67,,0,)*_xlfn.XLOOKUP(J10,$H$77:$H$82,$K$77:$K$82,,0,)","v":11.583319999999997},{"$f":"E10*_xlfn.XLOOKUP(J10,$H$61:$H$67,$J$61:$J$67,,0,)*_xlfn.XLOOKUP(J10,$H$77:$H$82,$L$77:$L$82,,0,)","v":3.7708800000000005},{"$f":"F10*_xlfn.XLOOKUP(J10,$H$77:$H$82,$M$77:$M$82,,0,)","v":295.64999999999998},null,"LPG",10,"-",7.0000000000000007E-2,"-",311,"-",2939.29,{"$f":"V10*$W$6","v":2.9392899999999998E-3},0.23030999999999999]
[null,"kW <8","EU Stage IIIA",{"$f":"D10","v":11.2},1.6,270,null,null,"kW <8","EU Stage IIIA",{"$f":"D11*_xlfn.XLOOKUP(J11,$H$61:$H$67,$I$61:$I$67,,0,)*_xlfn.XLOOKUP(J11,$H$77:$H$82,$K$77:$K$82,,0,)","v":12.700800000000001},4.5250560000000002,295.64999999999998,null,"Biodiesel","-",1.02,"-",0.9,"-","-",{"$f":"  0.04562*1000","v":45.62},{"$f":"V11*$W$6","v":4.5619999999999994E-5}]
[null,"kW <8","EU Stage IIIB",{"$f":"D11","v":11.2},1.6,270,null,null,"kW <8","EU Stage IIIB",11.2896,2.3568000000000002,270,null,"Hybrid","-","-","-","-","-","-","-","-","-"]
[null,"kW <8","EU Stage IV",11.2,1.6,270,null,null,"kW <8","EU Stage IV",11.2896,2.3568000000000002,270,null,"Electric/battery",null,0,null,0,null,0,0,0,0.19338]
[null,"kW <8","EU Stage V",6.08,0.4,270,null,null,"kW <8","EU Stage V",6.1286399999999999,0.58920000000000006,270,null,"Below not used"]
[null,"8≤ kW <19","EU Stage I",11.2,1.6,270,null,null,"8≤ kW <19","EU Stage I",11.755519999999999,3.7708800000000005,295.64999999999998,null,"Petrol","-","-","-","-","-","-",2903.08,{"$f":"V15*$W$6","v":2.9030799999999997E-3}]
[null,"8≤ kW <19","EU Stage II",{"$f":"D15","v":11.2},1.6,{"$f":"F15","v":270},null,null,"8≤ kW <19","EU Stage II",11.583319999999997,3.7708800000000005,295.64999999999998,null,"Natural Gas",null,null,null,null,null,null,2539.25,{"$f":"V16*$W$6","v":2.5392499999999998E-3}]
[null,"8≤ kW <19","EU Stage IIIA",11.2,1.6,270,null,null,"8≤ kW <19","EU Stage IIIA",12.700800000000001,4.5250560000000002,295.64999999999998,null,"Hydrogen",null,null,null,null,null,null,"?"]
[null,"8≤ kW <19","EU Stage IIIB",11.2,1.6,270,null,null,"8≤ kW <19","EU Stage IIIB",11.2896,2.3568000000000002,270,null,"Fuel Cell",null,0,null,0,null,0,0,0]
[null,"8≤ kW <19","EU Stage IV",11.2,1.6,270,null,null,"8≤ kW <19","EU Stage IV",11.2896,2.3568000000000002,270]
[null,"8≤ kW <19","EU Stage V",6.08,0.4,270,null,null,"8≤ kW <19","EU Stage V",6.1286399999999999,0.58920000000000006,270]
[null,"19≤ kW <37","EU Stage I",9.8000000000000007,1.4,262,null,null,"19≤ kW <37","EU Stage I",10.28608,3.2995199999999998,286.89]
[null,"19≤ kW <37","EU Stage II",6.5,0.4,262,null,null,"19≤ kW <37","EU Stage II",6.7224624999999989,0.94272000000000011,286.89]
[null,"19≤ kW <37","EU Stage IIIA",6.08,0.4,262,null,null,"19≤ kW <37","EU Stage IIIA",6.8947199999999995,1.131264,{"$f":"F23*_xlfn.XLOOKUP(J23,$H$77:$H$82,$M$77:$M$82,,0,)","v":286.89}]
[null,"19≤ kW <37","EU Stage IIIB",{"$f":"D23","v":6.08},0.4,{"$f":"F23","v":262},null,null,"19≤ kW <37","EU Stage IIIB",6.1286399999999999,0.58920000000000006,262]
[null,"19≤ kW <37","EU Stage IV",6.08,0.4,{"$f":"F24","v":262},null,null,"19≤ kW <37","EU Stage IV",6.1286399999999999,0.58920000000000006,262]
[null,"19≤ kW <37","EU Stage V",3.81,1.4999999999999999E-2,262,null,null,"19≤ kW <37","EU Stage V",3.8404799999999999,2.2095E-2,262]
[null,"37≤ kW <56","EU Stage I",7.7,0.4,260,null,null,"37≤ kW <56","EU Stage I",8.0819200000000002,0.94272000000000011,284.7]
[null,"37≤ kW <56","EU Stage II",5.5,0.2,260,null,null,"37≤ kW <56","EU Stage II",5.6882374999999987,0.47136000000000006,284.7]
[null,"37≤ kW <56","EU Stage IIIA",3.81,0.2,260,null,null,"37≤ kW <56","EU Stage IIIA",4.3205400000000003,0.56563200000000002,284.7]
[null,"37≤ kW <56","EU Stage IIIB",3.81,2.5000000000000001E-2,260,null,null,"37≤ kW <56","EU Stage IIIB",3.8404799999999999,3.6825000000000004E-2,260]
[null,"37≤ kW <56","EU Stage IV",{"$f":"D30","v":3.81},{"$f":"E30","v":2.5000000000000001E-2},{"$f":"F30","v":260},null,null,"37≤ kW <56","EU Stage IV",3.8404799999999999,3.6825000000000004E-2,260]
[null,"37≤ kW <56","EU Stage V",3.81,1.4999999999999999E-2,260,null,null,"37≤ kW <56","EU Stage V",3.8404799999999999,2.2095E-2,260]
[null,"56≤ kW <75","EU Stage I",7.7,0.4,260,null,null,"56≤ kW <75","EU Stage I",8.0819200000000002,0.94272000000000011,284.7]
[null,"56≤ kW <75","EU Stage II",5.5,0.2,260,null,null,"56≤ kW <75","EU Stage II",5.6882374999999987,0.47136000000000006,284.7]
[null,"56≤ kW <75","EU Stage IIIA",3.81,0.2,260,null,null,"56≤ kW <75","EU Stage IIIA",4.3205400000000003,0.56563200000000002,284.7]
[null,"56≤ kW <75","EU Stage IIIB",2.97,2.5000000000000001E-2,260,null,null,"56≤ kW <75","EU Stage IIIB",2.9937600000000004,3.6825000000000004E-2,260]
[null,"56≤ kW <75","EU Stage IV",0.4,2.5000000000000001E-2,260,null,null,"56≤ kW <75","EU Stage IV",0.4032,3.6825000000000004E-2,260]
[null,"56≤ kW <75","EU Stage V",0.4,1.4999999999999999E-2,260,null,null,"56≤ kW <75","EU Stage V",0.4032,2.2095E-2,260]
[null,"75≤ kW <130","EU Stage I",8.1,0.2,255,null,null,"75≤ kW <130","EU Stage I",8.5017599999999991,0.47136000000000006,279.22499999999997]
[null,"75≤ kW <130","EU Stage II",5.2,0.2,255,null,null,"75≤ kW <130","EU Stage II",5.3779699999999986,0.47136000000000006,279.22499999999997]
[null,"75≤ kW <130","EU Stage IIIA",3.24,0.2,255,null,null,"75≤ kW <130","EU Stage IIIA",3.6741600000000005,0.56563200000000002,279.22499999999997]
[null,"75≤ kW <130","EU Stage IIIB",2.97,2.5000000000000001E-2,255,null,null,"75≤ kW <130","EU Stage IIIB",2.9937600000000004,3.6825000000000004E-2,255]
[null,"75≤ kW <130","EU Stage IV",0.4,2.5000000000000001E-2,255,null,null,"75≤ kW <130","EU Stage IV",0.4032,3.6825000000000004E-2,255]
[null,"75≤ kW <130","EU Stage V",0.4,1.4999999999999999E-2,255,null,null,"75≤ kW <130","EU Stage V",0.4032,2.2095E-2,255]
[null,"130≤ kW <560","EU Stage I",7.6,0.2,250,null,null,"130≤ kW <560","EU Stage I",7.9769599999999992,0.47136000000000006,273.75]
[null,"130≤ kW <560","EU Stage II",5.2,0.1,250,null,null,"130≤ kW <560","EU Stage II",5.3779699999999986,0.23568000000000003,273.75]
[null,"130≤ kW <560","EU Stage IIIA",3.24,0.1,250,null,null,"130≤ kW <560","EU Stage IIIA",3.6741600000000005,0.28281600000000001,273.75]
[null,"130≤ kW <560","EU Stage IIIB",1.8,2.5000000000000001E-2,250,null,null,"130≤ kW <560","EU Stage IIIB",1.8144,3.6825000000000004E-2,250]
[null,"130≤ kW <560","EU Stage IV",0.4,2.5000000000000001E-2,250,null,null,"130≤ kW <560","EU Stage IV",0.4032,3.6825000000000004E-2,250]
[null,"130≤ kW <560","EU Stage V",0.4,1.4999999999999999E-2,250,null,null,"130≤ kW <560","EU Stage V",0.4032,2.2095E-2,250]
[null,"kW >560","EU Stage I",{"$f":"D52","v":3.5},4.4999999999999998E-2,250,null,null,"kW >560","EU Stage I",3.6736,0.106056,273.75]
[null,"kW >560","EU Stage II",3.5,4.4999999999999998E-2,250,null,null,"kW >560","EU Stage II",3.6197874999999993,0.106056,273.75]
[null,"kW >560","EU Stage IIIA",3.5,4.4999999999999998E-2,250,null,null,"kW >560","EU Stage IIIA",3.9689999999999999,0.1272672,273.75]
[null,"kW >560","EU Stage IIIB",3.5,4.4999999999999998E-2,250,null,null,"kW >560","EU Stage IIIB",3.528,6.6284999999999997E-2,250]
[null,"kW >560","EU Stage IV",{"$f":"D56","v":3.5},4.4999999999999998E-2,250,null,null,"kW >560","EU Stage IV",3.528,6.6284999999999997E-2,250]
[null,"kW >560","EU Stage V",3.5,4.4999999999999998E-2,250,null,null,"kW >560","EU Stage V",3.528,6.6284999999999997E-2,250]
[]
[]
[null,null,null,null,null,null,null,"Deterioration factor adjustment for diesel NRMM"]
[null,null,null,null,null,null,null,null,"NOx","TSP"]
[null,null,null,null,null,null,null,"Pre EU Stage I",{"$f":"1+0.024","v":1.024},1.4730000000000001]
[null,null,null,null,null,null,null,"EU Stage I",{"$f":"1+0.024","v":1.024},1.4730000000000001]
[null,null,null,null,null,null,null,"EU Stage II",{"$f":"1+0.009","v":1.0089999999999999},1.4730000000000001]
[null,null,null,null,null,null,null,"EU Stage IIIA",1.008,1.4730000000000001]
[null,null,null,null,null,null,null,"EU Stage IIIB",1.008,1.4730000000000001]
[null,null,null,null,null,null,null,"EU Stage IV",1.008,1.4730000000000001]
[null,null,null,null,null,null,null,"EU Stage V",1.008,1.4730000000000001]
[]
[null,null,null,null,null,null,null,"Load adjustment factor for diesel NRMM"]
[null,null,null,null,null,null,null,null,"Load","Load factor","NOx","TSP","FC"]
[null,null,null,null,null,null,null,"EU Stage I","High",">0.45",0.95,1.23,1.01]
[null,null,null,null,null,null,null,"EU Stage II","High",">0.45",0.95,1.23,1.01]
[null,null,null,null,null,null,null,"EU Stage IIIA","High",">0.45",1.04,1.47,1.01]
[null,null,null,null,null,null,null,"EU Stage IIIB","High",">0.45",1,1,1]
[null,null,null,null,null,null,null,"EU Stage IV","High",">0.45",1,1,1]
[null,null,null,null,null,null,null,"EU Stage V","High",">0.45",1,1,1]
[null,null,null,null,null,null,null,"EU Stage I","Middle","0.25<LF<0.45",1.0249999999999999,1.6,1.095]
[null,null,null,null,null,null,null,"EU Stage II","Middle","0.25<LF<0.45",1.0249999999999999,1.6,1.095]
[null,null,null,null,null,null,null,"EU Stage IIIA","Middle","0.25<LF<0.45",1.125,1.92,1.095]
[null,null,null,null,null,null,null,"EU Stage IIIB","Middle","0.25<LF<0.45",1,1,1]
[null,null,null,null,null,null,null,"EU Stage IV","Middle","0.25<LF<0.45",1,1,1]
[null,null,null,null,null,null,null,"EU Stage V","Middle","0.25<LF<0.45",1,1,1]
[null,null,null,null,null,null,null,"EU Stage I","Low","<0.25",1.1000000000000001,1.97,1.18]
[null,null,null,null,null,null,null,"EU Stage II","Low","<0.25",1.1000000000000001,1.97,1.18]
[null,null,null,null,null,null,null,"EU Stage IIIA","Low","<0.25",1.21,2.37,1.18]
[null,null,null,null,null,null,null,"EU Stage IIIB","Low","<0.25",1,1,1]
[null,null,null,null,null,null,null,"EU Stage IV","Low","<0.25",1,1,1]
[null,null,null,null,null,null,null,"EU Stage V","Low","<0.25",1,1,1]

{"sheet":"Hybrid assumption","index":17,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":true,"merged":[[2,6,2,10]]}
["Fuel use data collected for hybrid equipment. Sample population then used to produce a trend. The reduction in fuel use was directly translated into emission reductions."]
[]
["Name","Equipment type","Power rating (kW)","% reduction","Notes",null,"Least square line"]
["Kobelco SK210H-LC large excavator","Excavator",124,{"$f":"AVERAGE(13.9,16.7,12.1)","v":14.233333333333334},"MACE reported 20% reduction in fuel used",null,"x","y1","%","y2","%"]
["HB365LC-3 Komatsu","Excavator",202,{"$f":"AVERAGE(30,22,20)","v":24},"Komatsu reported reduction per typical work pattern vs various other plant equivalents. Average taken.",null,100,{"$f":"G5*$D$14","v":11.464102130827575},{"$f":"100-H5","v":88.53589786917243},{"$f":"G5*$D$13+16.208","v":19.217999999999996},{"$f":"100-J5","v":80.782000000000011}]
["John Deere 644L wheel loader","Loader",194,25,"The average customer can expect about a 25% reduction in fuel consumption using the 644K",null,150,{"$f":"G6*$D$14","v":17.196153196241362},{"$f":"100-H6","v":82.803846803758631},{"$f":"G6*$D$13+16.208","v":20.722999999999999},79.277000000000001]
["Volvo EC300E Hybrid ","Excavator",188,15,"15% lower fuel consumption ",null,200,{"$f":"G7*$D$14","v":22.92820426165515},{"$f":"100-H7","v":77.071795738344846},22.227999999999998,77.772000000000006]
["Volvo EC350 Hybrid ","Excavator",219,15,"15% lower fuel consumption ",null,250,{"$f":"G8*$D$14","v":28.660255327068938},71.339744672931062,23.732999999999997,76.266999999999996]
["Hitachi ZH 210 Hybrid","Excavator",122,{"$f":"AVERAGE(31,36)","v":33.5},"31% reduction in fuel consumption (PWR mode vs ZX-3 P-mode)\n36% reduction in fuel consumptuon (ECO mode vs ZX-3 P-mode)",null,300,{"$f":"G9*$D$14","v":34.392306392482723},65.607693607517277,25.238,74.762]
["HB215LC-3 hydrid ","Excavator",110,{"$f":"AVERAGE(22,20,5)","v":15.666666666666666},"Reported reduction per typical work pattern vs various other plant equivalents. Average taken."]
["Sennebogen 860 E hybrid ","Material handler",261,30]
[]
[null,null,"Line of best fit ",3.0099999999999998E-2,"This figure has been produced from plotting hybrid plant power ratings and their average % reduction in fuel. This is the more conservative assumption on fuel savings as the power rating increases.\nTherefore the emissions calculated in the tool are directly based on the fuel savings, in the absence of more detailed data."]
[null,null,"Line of best fit using \"least squares\" method",{"$f":"LINEST(D4:D11,C4:C11,0,0)","v":0.11464102130827575},0]
[]
[]
[null,null,"x","y"]
[null,null,0,{"$f":"((0.0301*C18)+16.208)/100","v":0.16207999999999997}]
[]
[null,null,"Reduction"]
[null,null,{"$f":"1-(((0.0301*C18)+16.208)/100)","v":0.83792}]

{"sheet":"Lists","index":18,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["Equipment type",null,"EU Stage",null,"Power rating",null,null,null,null,null,"Construction phase",null,null,"Technology/fuel type",null,"GLA NRMM policy areas"]
["[Select type]",null,"[Select Stage]",null,"[Select rating]",null,null,"Constant speed engine (e.g. Generator)","EU Stage V (Generator)",null,"[Select phase]",null,null,"[Select type]",null,"Central Activity Zone and Canary Wharf"]
["Agitator/mixer",null,"EU Stage I",null,"kW <8",8,null,"<56kW","EU Stage V",null,{"$f":"_xlfn.CONCAT(L8,'Site details'!B15)","v":"1) Site setup and demolition"},"1) ",null,"Diesel",null,"Opportunity Area"]
["Articulated dump truck",null,"EU Stage II",null,"8≤ kW <19",19,null,"Southwark Baseline","EU Stage IV",null,{"$f":"_xlfn.CONCAT(L9,'Site details'!B16)","v":"2) Basement excavation and piling"},"2) ",null,"LPG",null,"Other areas of Greater London"]
["Bulldozer",null,"EU Stage IIIA",null,"19≤ kW <37",37,null,null,null,null,{"$f":"_xlfn.CONCAT(L10,'Site details'!B17)","v":"3) Sub-structure"},"3) ",null,"Biodiesel"]
["Cleaning equipment",null,"EU Stage IIIB",null,"37≤ kW <56",56,null,null,null,null,{"$f":"_xlfn.CONCAT(L11,'Site details'!B18)","v":"4) Super-structure"},"4) ",null,"Hybrid"]
["Compactors/tampers/rammers",null,"EU Stage IV",null,"56≤ kW <75",75,null,null,null,null,{"$f":"_xlfn.CONCAT(L12,'Site details'!B19)","v":"5) Cladding"},"5) ",null,"Electric/battery"]
["Compressor",null,"EU Stage V",null,"75≤ kW <130",130,null,null,null,null,{"$f":"_xlfn.CONCAT(L13,'Site details'!B20)","v":"6) Fit-out, testing and commissioning"},"6) "]
["Concrete equipment",null,"n/a",null,"130≤ kW <560",560]
["Cranes/lifts/platform",null,null,null,"kW >560"]
["Crusher"]
["Drilling rig"]
["Dumper"]
["Excavator"]
["Forklift"]
["Grader"]
["Lighting"]
["Loader"]
["Material handler"]
["Paving equipment"]
["Piling rig"]
["Pump"]
["Telehandler"]
["Tractor"]
["Truck"]
["Constant speed engine (e.g. Generator)"]
["Other"]