{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["OVERALL RATING (avg)","Clean Air","Efficiency","Greenhouse","RESULTS","SPECS","LIMITS Clean Air","LIMITS Efficiency","LIMITS Greenhouse","WEBSITE SUMMARY"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":19,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OVERALL RATING (avg)","index":0,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,6,69,7],[48,3,48,8],[49,4,49,5],[49,6,49,8],[50,7,50,8],[51,4,51,5],[51,6,51,8],[53,4,53,5],[53,6,53,8],[54,3,54,5],[54,6,54,8],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,3,58,5],[58,6,58,8],[65,6,65,7],[66,3,66,5],[66,6,66,8],[67,6,67,7],[68,6,68,7],[61,6,61,7],[62,3,62,5],[62,6,62,8],[63,6,63,7],[64,6,64,7],[59,6,59,7],[60,6,60,7],[54,15,54,18],[56,15,56,18],[2,1,3,1],[2,2,3,2],[21,2,21,4],[21,5,21,7],[6,2,6,4],[6,5,6,7],[9,1,13,1],[15,1,18,1],[41,2,41,4],[42,5,42,7],[6,8,6,10],[21,8,21,10],[41,8,41,10],[42,8,42,10],[41,5,41,7],[42,2,42,4],[22,2,22,4],[22,5,22,7],[22,8,22,10],[23,2,23,10],[40,5,40,7],[40,8,40,10],[40,2,40,4],[43,8,43,10],[44,8,44,10],[44,5,44,7],[44,2,44,4],[43,5,43,7],[43,2,43,4]]}
[]
[]
[null,{"$f":"CONCATENATE(E50,\" \",H50)","v":"0 "}]
[]
[]
[]
[null,null,"Clean Air Index\n",null,null,"Energy Efficiency Index\n",null,null,"Greenhouse Gas Index\n"]
[]
[null,null,32.6,"CD mode","CS mode",40.5,"CD mode","CS mode",null,"CD mode","CS mode"]
[null,"Standard Testing",{"$f":"'Clean Air'!B6","v":"WLTC+ warm engine"},{"$f":"IF('Clean Air'!$H$14=0,\"-\",'Clean Air'!$H$14)","v":"-"},{"$f":"'Clean Air'!F14","v":10},{"$f":"C10","v":"WLTC+ warm engine"},"-",{"$f":"SUM(Efficiency!F12:F14)","v":10},{"$f":"F10","v":"WLTC+ warm engine"},"-",{"$f":"Greenhouse!F32","v":10}]
[null,null,{"$f":"'Clean Air'!B15","v":"WLTC+ cold engine (23°C)"},{"$f":"'Clean Air'!H23","v":10},{"$f":"'Clean Air'!F23","v":10},{"$f":"C11","v":"WLTC+ cold engine (23°C)"},{"$f":"Efficiency!H10","v":10},{"$f":"Efficiency!F10","v":10},{"$f":"F11","v":"WLTC+ cold engine (23°C)"},{"$f":"Greenhouse!H14","v":10},{"$f":"Greenhouse!F14","v":10}]
[null,null,{"$f":"'Clean Air'!B24","v":"BAB130 Motorway"},{"$f":"IF('Clean Air'!$H$32=0,\"-\",'Clean Air'!$H$32)","v":"-"},{"$f":"'Clean Air'!F32","v":10},"BAB130 Motorway","-",{"$f":"Efficiency!F15","v":10},"BAB130 Motorway","-",{"$f":"Greenhouse!F43","v":10}]
[null,null,{"$f":"'Clean Air'!B33","v":"PEMS+ cold engine 1"},{"$f":"IF('Clean Air'!$H$41=0,\"-\",'Clean Air'!$H$41)","v":10},{"$f":"'Clean Air'!F41","v":10},"PEMS+ cold engine 1","-",{"$f":"IF(Efficiency!F13=0,\"-\",Efficiency!F13)","v":"-"},"PEMS+ cold engine 1"]
[null,null,{"$f":"'Clean Air'!$B$50","v":"Short trip / cold start 1"},{"$f":"IF('Clean Air'!$H$57=0,\"-\",'Clean Air'!$H$57)","v":5},{"$f":"'Clean Air'!F57","v":5},"Short trip / cold start 1","-","-","Short trip / cold start 1"]
[null,"Eligible for \nadditional robustness testing?",null,null,null,{"$f":"IF(AND(AVERAGE('Clean Air'!H100,Efficiency!I25,Greenhouse!I49)>='LIMITS Clean Air'!P20,MIN('Clean Air'!H100,Efficiency!I25,Greenhouse!I49)>='LIMITS Clean Air'!P24),\"YES\",\"NO\")","v":"YES"}]
[null,"Additional Robustness Testing",{"$f":"'Clean Air'!B60","v":"WLTC+ CAT (-7°C)"},{"$f":"IF('Clean Air'!$H$68=0,\"-\",'Clean Air'!$H$68)","v":"-"},{"$f":"'Clean Air'!$F$68","v":10},{"$f":"C16","v":"WLTC+ CAT (-7°C)"},"-",{"$f":"Efficiency!F11","v":10},{"$f":"Greenhouse!B15","v":"WLTC+ CAT (-7°C)"},"-",{"$f":"Greenhouse!F23","v":10}]
[null,null,{"$f":"'Clean Air'!$B$69","v":"PEMS+ Eco / light"},{"$f":"IF('Clean Air'!$H$77=0,\"-\",'Clean Air'!$H$77)","v":5},{"$f":"IF('Clean Air'!F77=0,\"-\",'Clean Air'!F77)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$78","v":"PEMS+ Heavy load"},{"$f":"IF('Clean Air'!$H$86=0,\"-\",'Clean Air'!$H$86)","v":8},{"$f":"IF('Clean Air'!F86=0,\"-\",'Clean Air'!F86)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$87","v":"PEMS Congestion"},{"$f":"IF('Clean Air'!$H$96=0,\"-\",'Clean Air'!$H$96)","v":"-"},{"$f":"'Clean Air'!F96","v":2}]
[null,"Total Score",null,{"$f":"'Clean Air'!G102","v":38},{"$f":"'Clean Air'!E102","v":57},null,{"$f":"Efficiency!H27","v":10},{"$f":"Efficiency!F27","v":40},null,{"$f":"Greenhouse!H51","v":10},{"$f":"Greenhouse!F51","v":40}]
[null,"Max Points available",null,{"$f":"IF(F15=\"YES\",'Clean Air'!F100+'Clean Air'!F101,'Clean Air'!F100)","v":38},{"$f":"IF(F15=\"YES\",'Clean Air'!D100+'Clean Air'!D101,'Clean Air'!D100)","v":57},null,{"$f":"IF(F15=\"YES\",Efficiency!G27,Efficiency!G25)","v":10},{"$f":"IF(F15=\"YES\",Efficiency!E27,Efficiency!E25)","v":40},null,{"$f":"IF(F15=\"YES\",Greenhouse!G51,Greenhouse!G49)","v":10},{"$f":"IF(F15=\"YES\",Greenhouse!E51,Greenhouse!E49)","v":40},null,null,null,null,"CA",{"$f":"IF(AND(F15=\"YES\",ROUNDDOWN((C22*C23+F23*F22+I23*I22)/100,1)<5),'Clean Air'!H100,$C$22)","v":10}]
[null,"Index",{"$f":"'Clean Air'!E106","v":10},null,null,{"$f":"Efficiency!I29","v":10},null,null,{"$f":"Greenhouse!I53","v":10},null,null,null,null,null,null,"EE",{"$f":"IF(AND(F15=\"YES\",ROUNDDOWN((C22*C23+F23*F22+I23*I22)/100,1)<5),Efficiency!I25,$F$22)","v":10}]
[null,"Weighting Factors",{"$f":"100/3","v":33.333333333333336},null,null,{"$f":"100/3","v":33.333333333333336},null,null,{"$f":"100/3","v":33.333333333333336},null,null,null,null,null,null,"GHG",{"$f":"IF(AND(F15=\"YES\",ROUNDDOWN((C22*C23+F23*F22+I23*I22)/100,1)<5),Greenhouse!I49,$I$22)","v":10}]
[null,"Weighted Overall Index",{"$f":"IF(AND(F15=\"YES\",ROUNDDOWN((C22*C23+F23*F22+I23*I22)/100,1)<5),5,ROUNDDOWN((C22*C23+F23*F22+I23*I22)/100,1))","v":10},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(MAX(IF(C24>=H27:H36,F27:F36)),1)","v":5}]
[]
[null,null,null,null,null,"Stars",null,"Threshold"]
[null,null,null,null,null,5,null,9]
[null,null,null,null,null,4.5,null,8]
[null,null,null,null,null,4,null,7]
[null,null,null,null,null,3.5,null,6]
[null,null,null,null,null,3,null,5]
[null,null,null,null,null,2.5,null,4]
[null,null,null,null,null,2,null,3]
[null,null,null,null,null,1.5,null,2]
[null,null,null,null,null,1,null,1]
[null,null,null,null,null,0,null,0]
[]
[]
[]
[null,"RATING REQUIREMENTS 2021"]
[null,null,9,null,null,7.5,null,null,4,null,null,null,null,null,{"$f":"IF(AND($C$22:$K$22>=C41:K41),1,0)","v":1}]
[null,null,7,null,null,6,null,null,{"$f":"I41-1","v":3},null,null,null,null,null,{"$f":"IF(AND($C$22:$K$22>=C42:K42),1,0)","v":1}]
[null,null,5,null,null,4.5,null,null,{"$f":"I42-1","v":2},null,null,null,null,null,{"$f":"IF(AND($C$22:$K$22>=C43:K43),1,0)","v":1}]
[null,null,3,null,null,3,null,null,1,null,null,null,null,null,{"$f":"IF(AND($C$22:$K$22>=C44:K44),1,0)","v":1}]
[null,null,1,null,null,1.5,null,null,0,null,null,null,null,null,{"$f":"IF(AND($C$22:$K$22>=C45:K45),1,0)","v":1}]
[]
[null,"1): test not operational yet",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O41:O45)","v":5}]
[]
[null,null,null,"TEST DETAILS"]
[null,null,null,"Vehicle",{"$f":"SPECS!B1","v":0},null,{"$f":"SPECS!$B$2","v":0}]
[null,null,null," Specs (cc/kW)",{"$f":"IF(SPECS!B27=0,\"-\",SPECS!B27)","v":"-"}," cc",{"$f":"IF(SPECS!B28=0,\"-\",SPECS!B28)","v":"-"}," kW"]
[null,null,null,"Applies to VIN:",{"$f":"IF(SPECS!B24=0,\"-\",SPECS!B24)","v":"-"}]
[null,null,null,"Powerunit(s)",{"$f":"IF(Petrol_PHEV,\"Petrol PHEV\",IF(Diesel_PHEV,\"Diesel PHEV\",))","v":"Petrol PHEV"}]
[null,null,null,"Actual mass (kg)",{"$f":"SPECS!B31","v":0}]
[null,null,null,"Average Energy Use",null,null,"Average Driving Range"]
[null,null,null,"liquid fuel ",{"$f":"Efficiency!P106","v":0},"l/100km",{"$f":"Efficiency!P113","v":0},null,"km"]
[null,null,null," gaseous fuel ",null,"kg/100km",null,null,"km"]
[null,null,null,"electric energy",{"$f":"Efficiency!S106","v":0},"kWh/100km",{"$f":"Efficiency!S113","v":0},null,"km"]
[null,null,null,"Warm Test (Lab) Energy Use ",null,null,"Warm Test (Lab) Driving range"]
[null,null,null,"liquid fuel ",{"$f":"IF(AND($F$15=\"YES\",Efficiency!$P$35>0),Efficiency!$P$35,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(AND($F$15=\"YES\",Efficiency!P$55>0),Efficiency!P$55,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,null," gaseous fuel ",null,"kg/100km",null,null,"km"]
[null,null,null,"electric energy",null,"kWh/100km",null,null,"km"]
[null,null,null,"Highway Energy Use",null,null,"Highway Driving Range"]
[null,null,null,"liquid fuel ",{"$f":"IF(AND($F$15=\"YES\",Efficiency!$P$36>0),Efficiency!$P$36,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(AND($F$15=\"YES\",Efficiency!P$56>0),Efficiency!P$56,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,null," gaseous fuel ",null,"kg/100km",null,null,"km"]
[null,null,null,"electric energy",null,"kWh/100km",null,null,"km"]
[null,null,null,"Cold Ambient Test (-7°C) Energy Use",null,null,"Cold Ambient Test (-7°C) Driving Range"]
[null,null,null,"liquid fuel ",{"$f":"IF(AND($F$15=\"YES\",Efficiency!$P$37>0),Efficiency!$P$37,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(AND($F$15=\"YES\",Efficiency!P$59>0),Efficiency!P$59,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,null," gaseous fuel ",null,"kg/100km",null,null,"km"]
[null,null,null,"electric energy",null,"kWh/100km",null,null,"km"]

{"sheet":"Clean Air","index":1,"n_rows":106,"n_cols":33,"rows_kept":106,"cut":false,"hidden":false,"merged":[[4,1,4,2],[97,5,97,6],[97,9,98,9],[99,9,100,9],[99,7,99,8],[100,7,100,8],[40,1,40,2],[100,1,100,2],[98,1,98,2],[97,3,97,4],[58,1,58,3],[85,1,85,2],[95,1,95,2],[97,1,97,2],[99,1,99,2],[101,1,101,2],[69,11,75,11],[78,11,84,11],[1,10,3,10],[22,1,22,2],[1,4,1,5],[2,4,2,5],[1,6,1,7],[2,6,2,7],[1,8,2,9],[1,1,2,2],[3,1,3,2],[13,1,13,2],[67,1,67,2],[76,1,76,2],[97,7,98,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"1. Clean Air Index",null,null,"Test Results",null,"Test Results",null,"Thresholds",null,"Max score"]
[null,null,null,null,"CS mode",null,"CD mode"]
[null,null,null,null,"Value","Points","Value","Points","lower","upper"]
[null,"Standard",null,"Weighting",{"$f":"Sliding_Scale(RESULTS!Z26,'LIMITS Clean Air'!H32,'LIMITS Clean Air'!H33,'LIMITS Clean Air'!$H$34,(1-'LIMITS Clean Air'!$H$34),2)","v":0.8},null,{"$f":"1-E5","v":0.19999999999999996}]
[null,"WLTC+ warm engine",null,"max points",null,{"$f":"SUM(K7:K13)","v":10}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$8-RESULTS!$P$8","v":0},{"$f":"Sliding_Scale(E7,I7,J7,K7,0,Slide_Type)","v":2},null,null,{"$f":"'LIMITS Clean Air'!$D$20","v":0.5},{"$f":"'LIMITS Clean Air'!$D$6","v":58},2]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$8","v":0},{"$f":"Sliding_Scale(E8,I8,J8,K8,0,Slide_Type)","v":3},null,null,{"$f":"'LIMITS Clean Air'!$D$21","v":0.5},{"$f":"'LIMITS Clean Air'!$D$7","v":60},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$8","v":0},{"$f":"Sliding_Scale(E9,I9,J9,K9,0,Slide_Type)","v":0},null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$D$8","v":20},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$8","v":0},{"$f":"Sliding_Scale(E10,I10,J10,K10,0,Slide_Type)","v":1},null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$D$9","v":10},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$8","v":0},{"$f":"Sliding_Scale(E11,I11,J11,K11,0,Slide_Type)","v":1},null,null,{"$f":"'LIMITS Clean Air'!$D$24","v":5},{"$f":"'LIMITS Clean Air'!$D$10","v":500},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$8","v":0},{"$f":"Sliding_Scale(E12,I12,J12,K12,0,Slide_Type)","v":0},null,null,{"$f":"'LIMITS Clean Air'!$D$25","v":0},{"$f":"'LIMITS Clean Air'!$D$11","v":4.5},0]
[null,{"$f":"IF(E13=0,0,LOG10(E13))","v":0},"PN23 #/km",null,{"$f":"RESULTS!$K$8","v":0},{"$f":"Sliding_Scale(B13,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K13,0,Slide_Type)","v":3},null,null,{"$f":"'LIMITS Clean Air'!$D$26","v":100000000},{"$f":"'LIMITS Clean Air'!$D$12","v":600000000000},3]
[null,"total",null,null,null,{"$f":"IF(OR(E7:E9>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!E11:E13>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!F7:F13),0))","v":10}]
[null,"WLTC+ cold engine (23°C)",null,"max points",null,{"$f":"SUM(K16:K22)","v":10},null,{"$f":"SUM(K16:K22)","v":10},null,null,null,null,{"$f":"B15","v":"WLTC+ cold engine (23°C)"},"Averaged","max points",10]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O4-RESULTS!$P4","v":0},{"$f":"Sliding_Scale(E16,I16,J16,K16,0,Slide_Type)","v":2},{"$f":"RESULTS!$O$26-RESULTS!$P$26","v":0},{"$f":"Sliding_Scale(G16,I16,J16,K16,0,Slide_Type)","v":2},{"$f":"'LIMITS Clean Air'!$D$20","v":0.5},{"$f":"'LIMITS Clean Air'!$D$6","v":58},2,null,null,"NMHC","scored",{"$f":"$E$5*F16+$G$5*H16","v":2},{"$f":"K16","v":2}]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$4","v":0},{"$f":"Sliding_Scale(E17,I17,J17,K17,0,Slide_Type)","v":3},{"$f":"RESULTS!$H$26","v":0},{"$f":"Sliding_Scale(G17,I17,J17,K17,0,Slide_Type)","v":3},{"$f":"'LIMITS Clean Air'!$D$21","v":0.5},{"$f":"'LIMITS Clean Air'!$D$7","v":60},3,null,null,"NOx","scored",{"$f":"$E$5*F17+$G$5*H17","v":3},{"$f":"K17","v":3}]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$4","v":0},{"$f":"Sliding_Scale(E18,I18,J18,K18,0,Slide_Type)","v":0},{"$f":"RESULTS!$M$26","v":0},{"$f":"Sliding_Scale(G18,I18,J18,K18,0,Slide_Type)","v":0},{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$D$8","v":20},0,null,null,"NO2","scored",0,0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$4","v":0},{"$f":"Sliding_Scale(E19,I19,J19,K19,0,Slide_Type)","v":1},{"$f":"RESULTS!$N$26","v":0},{"$f":"Sliding_Scale(G19,I19,J19,K19,0,Slide_Type)","v":1},{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$D$9","v":10},1,null,null,"NH3","scored",1,1]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$4","v":0},{"$f":"Sliding_Scale(E20,I20,J20,K20,0,Slide_Type)","v":1},{"$f":"RESULTS!$G$26","v":0},{"$f":"Sliding_Scale(G20,I20,J20,K20,0,Slide_Type)","v":1},{"$f":"'LIMITS Clean Air'!$D$24","v":5},{"$f":"'LIMITS Clean Air'!$D$10","v":500},1,null,null,"CO","scored",1,1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$4","v":0},{"$f":"Sliding_Scale(E21,I21,J21,K21,0,Slide_Type)","v":0},{"$f":"RESULTS!$L$26","v":0},{"$f":"Sliding_Scale(G21,I21,J21,K21,0,Slide_Type)","v":0},{"$f":"'LIMITS Clean Air'!$D$25","v":0},{"$f":"'LIMITS Clean Air'!$D$11","v":4.5},0,null,null,"PM","scored",0,0]
[null,{"$f":"IF(E22=0,0,LOG10(E22))","v":0},"PN23 #/km",{"$f":"IF(G22=0,0,LOG10(G22))","v":0},{"$f":"RESULTS!$K$4","v":0},{"$f":"Sliding_Scale(B22,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K22,0,Slide_Type)","v":3},{"$f":"RESULTS!$K$26","v":0},{"$f":"Sliding_Scale(D22,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K22,0,Slide_Type)","v":3},{"$f":"'LIMITS Clean Air'!$D$26","v":100000000},{"$f":"'LIMITS Clean Air'!$D$12","v":600000000000},3,null,null,"PN23 #/km","scored",3,3]
[null,"total",null,null,null,{"$f":"IF(OR(E16:E18>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!E20:E22>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!F16:F22),0))","v":10},null,{"$f":"IF(OR(G16:G18>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!G20:G22>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!H16:H22),0))","v":10},null,null,null,null,null,null,"total AVG",10]
[null,"BAB130 Motorway",null,"max points",null,{"$f":"SUM(K25:K31)","v":10}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$10-RESULTS!$P$10","v":0},{"$f":"Sliding_Scale(E25,I25,J25,K25,0,Slide_Type)","v":2},null,null,{"$f":"'LIMITS Clean Air'!$D$20","v":0.5},{"$f":"'LIMITS Clean Air'!$D$6","v":58},2]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$10","v":0},{"$f":"Sliding_Scale(E26,I26,J26,K26,0,Slide_Type)","v":3},null,null,{"$f":"'LIMITS Clean Air'!$D$21","v":0.5},{"$f":"'LIMITS Clean Air'!$D$7","v":60},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$10","v":0},{"$f":"Sliding_Scale(E27,I27,J27,K27,0,Slide_Type)","v":0},null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$D$8","v":20},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$10","v":0},{"$f":"Sliding_Scale(E28,I28,J28,K28,0,Slide_Type)","v":1},null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$D$9","v":10},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$10","v":0},{"$f":"Sliding_Scale(E29,I29,J29,K29,0,Slide_Type)","v":1},null,null,{"$f":"'LIMITS Clean Air'!$D$24","v":5},{"$f":"'LIMITS Clean Air'!$D$10","v":500},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$10","v":0},{"$f":"Sliding_Scale(E30,I30,J30,K30,0,Slide_Type)","v":0},null,null,{"$f":"'LIMITS Clean Air'!$D$25","v":0},{"$f":"'LIMITS Clean Air'!$D$11","v":4.5},0]
[null,{"$f":"IF(E31=0,0,LOG10(E31))","v":0},"PN23 #/km",null,{"$f":"RESULTS!$K$10","v":0},{"$f":"Sliding_Scale(B31,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K31,0,Slide_Type)","v":3},null,null,{"$f":"'LIMITS Clean Air'!$D$26","v":100000000},{"$f":"'LIMITS Clean Air'!$D$12","v":600000000000},3]
[null,null,null,null,null,{"$f":"IF(OR(E25:E27>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!E29:E31>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!F25:F31),0))","v":10}]
[null,"PEMS+ cold engine 1",null,"max points",null,{"$f":"SUM(K35:K40)","v":10},null,{"$f":"SUM(K35:K40)","v":10},null,null,null,null,{"$f":"B33","v":"PEMS+ cold engine 1"},"Averaged","max points",10]
[null,null,"NMHC","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},null,null,null,"NMHC","scored"]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$11","v":0},{"$f":"Sliding_Scale(E35,I35,J35,K35,0,Slide_Type)","v":4},{"$f":"RESULTS!$H$33","v":0},{"$f":"Sliding_Scale(G35,I35,J35,K35,0,Slide_Type)","v":4},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},4,null,null,"NOx","scored",{"$f":"$E$5*F35+$G$5*H35","v":4},{"$f":"K35","v":4}]
[null,null,"NO2","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0,null,null,"NO2","scored"]
[null,null,"NH3","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},0,null,null,"NH3","scored"]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$11","v":0},{"$f":"Sliding_Scale(E38,I38,J38,K38,0,Slide_Type)","v":2},{"$f":"RESULTS!$G$33","v":0},{"$f":"Sliding_Scale(G38,I38,J38,K38,0,Slide_Type)","v":2},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},2,null,null,"CO","scored",2,2]
[null,null,"PM","mg/km",null,null,null,null,null,null,null,null,null,"PM","scored"]
[null,{"$f":"IF(E40=0,0,LOG10(E40))","v":0},"PN23 #/km",{"$f":"IF(G40=0,0,LOG10(G40))","v":0},{"$f":"RESULTS!$K$11","v":0},{"$f":"Sliding_Scale(B40,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K40,0,Slide_Type)","v":4},{"$f":"RESULTS!$K$33","v":0},{"$f":"Sliding_Scale(D40,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K40,0,Slide_Type)","v":4},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},4,null,null,"PN23 #/km","scored",4,4]
[null,"total",null,null,null,{"$f":"IF(OR(E34:E40>'LIMITS Clean Air'!$I$6:$I$12),0,MAX(SUM('Clean Air'!F34:F40),0))","v":10},null,{"$f":"IF(OR(G34:G40>'LIMITS Clean Air'!$I$6:$I$12),0,MAX(SUM('Clean Air'!H34:H40),0))","v":10},null,null,null,null,null,null,"total AVG",10]
[null,"PEMS+ cold engine 2","max points"]
[null,null,"NMHC","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56}]
[null,null,"NOx","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},4]
[null,null,"NO2","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},0]
[null,null,"CO","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},2]
[null,null,"PM","mg/km"]
[null,{"$f":"IF(E49=0,0,LOG10(E49))","v":0},"PN",null,null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},4]
[null,"Short trip / cold start 1",null,"max points",null,{"$f":"SUM(K51:K53)","v":5},null,{"$f":"SUM(K51:K53)","v":5},null,null,null,null,{"$f":"B50","v":"Short trip / cold start 1"},"Averaged","max points",10]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$13","v":0},{"$f":"IF(F35=0,0,IF(OR($E$51>='LIMITS Clean Air'!$M$7,$E$54>='LIMITS Clean Air'!M7),0,K51-(E51/'LIMITS Clean Air'!$M$7)*K51))","v":2.25},{"$f":"RESULTS!$H$35","v":0},{"$f":"IF(H35=0,0,IF(OR($E$51>='LIMITS Clean Air'!$M$7,$E$54>='LIMITS Clean Air'!M7),0,K51-(G51/'LIMITS Clean Air'!$M$7)*K51))","v":2.25},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},{"$f":"2.25","v":2.25},null,null,"NOx","scored",{"$f":"$E$5*F51+$G$5*H51","v":2.25},{"$f":"K51","v":2.25}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$13","v":0},{"$f":"IF(F38=0,0,IF(OR($E$52>'LIMITS Clean Air'!$M$10,$E$55>='LIMITS Clean Air'!$M$10),0,K52-(E52/'LIMITS Clean Air'!$M$10)*K52))","v":0.5},{"$f":"RESULTS!$G$35","v":0},{"$f":"IF(H38=0,0,IF(OR($E$52>'LIMITS Clean Air'!$M$10,$E$55>='LIMITS Clean Air'!$M$10),0,K52-(G52/'LIMITS Clean Air'!$M$10)*K52))","v":0.5},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},{"$f":"0.5","v":0.5},null,null,"CO","scored",{"$f":"$E$5*F52+$G$5*H52","v":0.5},0.5]
[null,{"$f":"IF(E53=0,0,LOG10(E53))","v":0},"PN23 #/km",{"$f":"IF(G53=0,0,LOG10(G53))","v":0},{"$f":"RESULTS!$K$13","v":0},{"$f":"Sliding_Scale(B53,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K53,0,Slide_Type)","v":2.25},{"$f":"RESULTS!$K$35","v":0},{"$f":"Sliding_Scale(D53,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K53,0,Slide_Type)","v":2.25},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},{"$f":"2.25","v":2.25},null,null,"PN23 #/km","scored",2.25,2.25]
[null,"PEMS 8km (2)","NOx","mg/km",{"$f":"RESULTS!H14","v":0},null,{"$f":"'LIMITS Clean Air'!D21","v":0.5},null,0,null,null,null,null,"NH3","scored",0]
[null,"(cold start / short trip)","CO","mg/km",{"$f":"RESULTS!$G$14","v":0},null,{"$f":"'LIMITS Clean Air'!D24","v":5},null,0]
[null,{"$f":"IF(E56=0,0,LOG10(E56))","v":0},"PN",null,{"$f":"RESULTS!$K$14","v":0},null,{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},null,0]
[null,"total",null,null,null,{"$f":"SUM(F51:F53)","v":5},null,{"$f":"SUM(H51:H53)","v":5},null,null,null,null,null,null,"total AVG",{"$f":"$E$5*F57+$G$5*H57","v":5}]
[]
[null,"Additional Robustness"]
[null,"WLTC+ CAT (-7°C)",null,"max points",null,{"$f":"SUM(K61:K67)","v":10}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$7-RESULTS!$P$7","v":0},{"$f":"Sliding_Scale(E61,I61,J61,K61,0,Slide_Type)","v":2},null,null,{"$f":"'LIMITS Clean Air'!$L$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},2]
[null,null,"NOx ","mg/km",{"$f":"RESULTS!$H$7","v":0},{"$f":"Sliding_Scale(E62,I62,J62,K62,0,Slide_Type)","v":3},null,null,{"$f":"'LIMITS Clean Air'!$L$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$7","v":0},{"$f":"Sliding_Scale(E63,I63,J63,K63,0,Slide_Type)","v":0},null,null,{"$f":"'LIMITS Clean Air'!$L$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$7","v":0},{"$f":"Sliding_Scale(E64,I64,J64,K64,0,Slide_Type)","v":1},null,null,{"$f":"'LIMITS Clean Air'!$L23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$7","v":0},{"$f":"Sliding_Scale(E65,I65,J65,K65,0,Slide_Type)","v":1},null,null,{"$f":"'LIMITS Clean Air'!$L$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$7","v":0},{"$f":"Sliding_Scale(E66,I66,J66,K66,0,Slide_Type)","v":0},null,null,{"$f":"'LIMITS Clean Air'!$L$25","v":0},{"$f":"'LIMITS Clean Air'!$H$11","v":5.94},0]
[null,{"$f":"IF(E67=0,0,LOG10(E67))","v":0},"PN23 #/km",null,{"$f":"RESULTS!$K$7","v":0},{"$f":"Sliding_Scale(B67,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K67,0,Slide_Type)","v":3},null,null,{"$f":"'LIMITS Clean Air'!$L$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},3]
[null,"total",null,null,null,{"$f":"IF(J100=\"yes\",IF(OR(E61:E63>'LIMITS Clean Air'!$M$6:$M$8,E65:E67>'LIMITS Clean Air'!$M$10:$M$12),0,MAX(SUM('Clean Air'!F61:F67),0)),0)","v":10}]
[null,"PEMS+ Eco / light",null,"max points",null,null,null,{"$f":"SUM(K70:K76)","v":5}]
[null,null,"NMHC","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},0,"Original formula in F65 is \"=IF(E65<=G36,K65,IF(E65<'Clean Air'!J36,(0.5*K65),0))\". Changed G36 (result in CD mode) to E36 (result in CS mode PEMS cold 1).\n\nOriginal formula in H68 is \"=IF(G68<=G39,K68,IF(G68<'Clean Air'!L39,(0.5*M68),0))\". Changed L39 to J39 and changed M68 to K68."]
[null,null,"NOx","mg/km",null,null,{"$f":"RESULTS!$H$37","v":0},{"$f":"IF(G71<=G35,K71,IF(G71<'Clean Air'!J35,(0.5*K71),0))","v":2.25},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},2.25]
[null,null,"NO2","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},0]
[null,null,"CO","mg/km",null,null,{"$f":"RESULTS!$G$37","v":0},{"$f":"IF(G74<=G38,K74,IF(G74<'Clean Air'!J38,(0.5*K74),0))","v":0.5},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},0.5]
[null,null,"PM","mg/km"]
[null,{"$f":"IF(E76=0,0,LOG10(E76))","v":0},"PN23 #/km",{"$f":"IF(G76=0,0,LOG10(G76))","v":0},null,null,{"$f":"RESULTS!$K$37","v":0},{"$f":"Sliding_Scale(D76,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!K76,0,Slide_Type)","v":2.25},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},2.25]
[null,"total",null,null,null,null,null,{"$f":"IF(J100=\"yes\",IF(OR(G70:G76>'LIMITS Clean Air'!$I$6:$I$12),0,MAX(SUM('Clean Air'!H70:H76),0)),0)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test","Upper limit","Distribution of points"]
[null,"PEMS+ Heavy load",null,"max points",null,null,null,{"$f":"SUM(K79:K85)","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light test","Same as PEMS+","100% of the points when result is lower than PEMS+ regular result"]
[null,null,"NMHC","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},0,"Originally inconsistent between NOx and CO: one was applying half points, the other full points.  Changed both to be in line with ICE way of calculating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50% of the points when result is between PEMS+ regular result and PEMS+ limit"]
[null,{"$f":"Sliding_Scale(E80,J35,'LIMITS Clean Air'!L12,K80,0,Slide_Type)","v":3.6},"NOx","mg/km",null,null,{"$f":"RESULTS!$H$38","v":0},{"$f":"Sliding_Scale(G80,I80,J80,K80,0,Slide_Type)","v":3.6},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},3.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No points when PEMS+ limits are exceeded"]
[null,null,"NO2","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heavy test","Same as PEMS+","100% of the points when result is between PEMS+ regular result and lower than PEMS+ regular limits"]
[null,null,"NH3","mg/km",null,null,null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0-100% of the points (sliding scale), depending on the location between the PEMS+ regular limits and and the PEMS+ heavy limits"]
[null,{"$f":"Sliding_Scale(E83,J38,'LIMITS Clean Air'!L15,K83,0,Slide_Type)","v":0.8},"CO","mg/km",null,null,{"$f":"RESULTS!$G$38","v":0},{"$f":"Sliding_Scale(G83,I83,J83,K83,0,Slide_Type)","v":0.8},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},0.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No points when PEMS+ heavy limits (CF2.1) regular are exceeded or when the PEMS+ regular test has 0 points"]
[null,null,"PM","mg/km",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heavy test and short trip with cold start","Conformity factor of 2,1 instead of 1.5","100% of the points when result is between PEMS+ regular result and below PEMS+ regular limits"]
[null,{"$f":"IF(E85=0,0,LOG10(E85))","v":0},"PN23 #/km",{"$f":"IF(G85=0,0,LOG10(G85))","v":0},null,null,{"$f":"RESULTS!$K$38","v":0},{"$f":"Sliding_Scale(D85,'LIMITS Clean Air'!$H$27,'LIMITS Clean Air'!$H$13,'Clean Air'!K85,0,Slide_Type)","v":3.6},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},3.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross excess limit","0-100% of the points (sliding scale), depending on the location between the PEMS+ regular limits and and the PEMS+ heavy gross excess limits"]
[null,"total",null,null,null,null,null,{"$f":"IF(J100=\"yes\",IF(OR(G79:G85>'LIMITS Clean Air'!$M$6:$M$12),0,MAX(SUM('Clean Air'!H79:H85),0)),0)","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No points when PEMS+ heavy gross excess limits are exceeded or when the PEMS+ regular test has 0 points"]
[null,"PEMS Congestion",null,"max points",null,{"$f":"SUM(K88:K95)","v":2},null,null,"max","avg"]
[null,null,"NMHC","mg/s",null,null,null,null,null,null,0]
[null,null,"NOx  AVG","mg/s",{"$f":"RESULTS!$H$19","v":0},{"$f":"IF(E89<J89,K89,0)","v":1},null,null,null,{"$f":"'LIMITS Clean Air'!Q7","v":0.5},1]
[null,null,"NOx MAX","mg/s",{"$f":"RESULTS!$H$18","v":0},{"$f":"IF(E90<J90,K90,0)","v":1},null,null,null,{"$f":"'LIMITS Clean Air'!P7","v":1},1]
[null,null,"NO2","mg/s",null,null,null,null,null,null,0]
[null,null,"NH3","mg/s",null,null,null,null,null,null,0]
[null,null,"CO","mg/s",null,null,null,null,null,null,0]
[null,null,"PM","mg/s"]
[null,{"$f":"IF(E95=0,0,LOG10(E95))","v":0},"PN23 #/km",null,null,null,null,null,null,null,0]
[null,"total",null,null,null,{"$f":"IF(J100=\"yes\",SUM(F89:F95),0)","v":2}]
[]
[null,"SUMMARY",null,"CS mode",null,"CD mode",null,"Subscore",null,"Stage 2?",null,"Stage 2?"]
[null,null,null,"max points","scored points","max points","scored points"]
[null,"Standard Testing",null,{"$f":"F50+F33+F15+F6+F24","v":45},{"$f":"F41+F32+F14+F23+F57","v":45},{"$f":"H15+H33+H50","v":25},{"$f":"H23+H41++H57","v":25},{"$f":"ROUNDDOWN(((10*(E100/D100))*$E$5+(10*(G100/F100))*$G$5),1)","v":10},null,{"$f":"IF(AND(AVERAGE(H100,Efficiency!F29,Greenhouse!F93)>='LIMITS Clean Air'!P20,(MIN(Greenhouse!F93,Efficiency!F29,'Clean Air'!H100)>='LIMITS Clean Air'!P24)),\"YES\",\"NO\")","v":"YES"},null,{"$error":"#REF!"}]
[null,"Additional Robustness Testing",null,{"$f":"F87+F78+F69+F60","v":12},{"$f":"IF(J100=\"yes\",F96+F86+F78+F68,0)","v":12},{"$f":"H69+H78","v":13},{"$f":"IF(J100=\"yes\",H77+H86,0)","v":13},{"$f":"ROUNDDOWN(((10*(E101/D101))*$E$5+(10*(G101/F101))*$G$5),1)","v":10}]
[null,"Sum",null,{"$f":"SUM(D100,D101)","v":57},{"$f":"SUM(E100,E101)","v":57},{"$f":"SUM(F100,F101)","v":38},{"$f":"SUM(G100,G101)","v":38}]
[]
[]
[null,"Total",null,{"$f":"D102+F102","v":95},{"$f":"E102+G102","v":95}]
[null,"TOTAL SCORE CLEAN AIR",null,"(0-10pts)",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",ROUNDDOWN(((10*(G101+G100)/(F100+F101))*G5+((10*(E101+E100)/(D100+D101))*E5)),1),ROUNDDOWN(((10*(G100)/(F100))*G5+((10*(E100)/(D100))*E5)),1))","v":10}]

{"sheet":"Efficiency","index":2,"n_rows":115,"n_cols":31,"rows_kept":115,"cut":false,"hidden":false,"merged":[[28,6,28,7],[28,8,28,9],[22,10,23,10],[24,8,24,9],[22,6,22,7],[24,10,25,10],[25,8,25,9],[22,8,23,9],[26,1,26,2],[22,1,22,2],[22,4,22,5],[28,1,28,5],[23,1,23,3],[24,1,24,3],[25,1,25,3],[1,10,3,10],[1,1,2,2],[18,1,18,2],[1,4,1,5],[1,6,1,7],[2,4,2,5],[2,6,2,7],[3,1,3,2],[1,8,1,9]]}
[]
[null,"2. Efficiency",null,null,"Test Results",null,"Test Results",null,"Thresholds"]
[null,null,null,null,"CS mode",null,"CD mode"]
[]
[null,null,null,"Weighting",{"$f":"'Clean Air'!E5","v":0.8},null,{"$f":"'Clean Air'!G5","v":0.19999999999999996}]
[null,"2.1","Test cycle measurements",null,"Value","Points","Value","Points","Lower","Upper","Max score"]
[]
[null,"2.1.2","Energy Consumption (total)"]
[null,null,"max points",50,"Value","Points","Value","Points","Lower","Upper","Max score",null,null,"Scored"]
[null,"Standard",{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"Z25+AC25","v":0},{"$f":"MAX(0,Sliding_Scale(E10,I10,J10,K10,0,Slide_Type))","v":10},{"$f":"Z67+AC67","v":0},{"$f":"MAX(0,Sliding_Scale(G10,I10,J10,K10,0,Slide_Type))","v":10},{"$f":"'LIMITS Efficiency'!E6","v":20},{"$f":"'LIMITS Efficiency'!F6","v":90},10,null,"Averaged",{"$f":"F10*$E$5+H10*$G$5","v":10}]
[null,"Additional",{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"Z26+AC26","v":0},{"$f":"MAX(0,Sliding_Scale(E11,I11,J11,K11,0,Slide_Type))","v":10},{"$f":"Z68+AC68","v":0},null,{"$f":"'LIMITS Efficiency'!E7","v":20},{"$f":"'LIMITS Efficiency'!F7","v":90},10]
[null,"Standard",{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"kWh/100km",0,{"$f":"MAX(0,Sliding_Scale(E12,I12,J12,K12,0,Slide_Type))","v":10},0,null,{"$f":"'LIMITS Efficiency'!E8","v":20},{"$f":"'LIMITS Efficiency'!F8","v":90},10]
[null,null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"kWh/100km",0,null,0,null,{"$f":"'LIMITS Efficiency'!E11","v":20},{"$f":"'LIMITS Efficiency'!F11","v":90},0]
[null,null,{"$f":"RESULTS!D12","v":"PEMS+ cold engine 2"},"kWh/100km",0,null,0,null,{"$f":"'LIMITS Efficiency'!E10","v":20},{"$f":"'LIMITS Efficiency'!F10","v":90},0]
[null,"Standard",{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"kWh/100km",0,{"$f":"MAX(0,Sliding_Scale(E15,I15,J15,K15,0,Slide_Type))","v":10},0,null,{"$f":"'LIMITS Efficiency'!E12","v":20},{"$f":"'LIMITS Efficiency'!F12","v":90},10]
[null,null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"kWh/100km",0,null,0,null,{"$f":"'LIMITS Efficiency'!$E$13","v":20},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0]
[null,null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"kWh/100km",0,null,0,null,{"$f":"'LIMITS Efficiency'!$E$13","v":20},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0]
[null,null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"kWh/100km",0,null,0,null,{"$f":"'LIMITS Efficiency'!$E$13","v":20},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conversion from l/100km or kg/100km to kWh/100km for different energy carriers"]
[null,"SUMMARY",null,null,"CS mode",null,"CD mode",null,"Subscore",null,"Stage 2?",null,null,"2.1.2.1 Charge Sustaining",null,null,"2.1.2.2 Charge Sustaining",null,null,"2.1.2.3 Charge Sustaining",null,null,null,"2.1.2.4 Charge Sustaining",null,null,"2.1.2.5 Charge Sustaining",null,null,"2.1.2.6 Charge Sustaining"]
[null,null,null,null,"max points","scored points","max points","scored points",null,null,null,null,null,"Fuel Consumption (liquid fuel)",null,null,"Energy Consumption (electric energy)",null,null,"Gas Consumption (CNG, Hydrogen)",null,null,null,"Fuel Consumption (liquid fuel)",null,null,"Energy Consumption (electric energy)",null,null,"Gas Consumption (CNG, Hydrogen)"]
[null,"Standard Testing",null,null,{"$f":"K10+K12+K15","v":30},{"$f":"F10+F12+F15","v":30},{"$f":"K10","v":10},{"$f":"H10","v":10},{"$f":"ROUNDDOWN((10*(H25/G25)*$G$5+(10*(F25/E25)*$E$5)),1)","v":10},null,{"$f":"IF(AND(AVERAGE(Greenhouse!I49,I25,'Clean Air'!H100)>='LIMITS Clean Air'!$P$20,MIN(Greenhouse!I49,I25,'Clean Air'!H100)>='LIMITS Clean Air'!$P$24),\"YES\",\"NO\")","v":"YES"},null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"l/100km",{"$f":"RESULTS!$Q$4","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"RESULTS!$R$4","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kg/100km",null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"P25*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"S25","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km"]
[null,"Additional Robustness Testing",null,null,{"$f":"K11","v":10},{"$f":"IF(K25=\"YES\",F11,0)","v":10},null,null,{"$f":"ROUNDDOWN(10*(F26/E26),1)","v":10},null,null,null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"l/100km",{"$f":"RESULTS!$Q$7","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"RESULTS!$R$7","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kg/100km",null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"P26*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"S26","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km"]
[null,"Sum",null,null,{"$f":"SUM(E25,E26)","v":40},{"$f":"SUM(F25,F26)","v":40},{"$f":"SUM(G25,G26)","v":10},{"$f":"SUM(H25,H26)","v":10},null,null,null,null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"l/100km",{"$f":"RESULTS!$Q$8","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",{"$f":"RESULTS!$R$8","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"kg/100km",null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",{"$f":"P27*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",0,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"l/100km",{"$f":"RESULTS!$Q$11","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"RESULTS!$R$11","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kg/100km",null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"P28*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",0,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km"]
[null,"TOTAL SCORE ENERGY EFFICIENCY",null,null,null,null,"(0-10pts)",null,{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",ROUNDDOWN(((10*H27/G27*$G$5)+(10*F27/E27*$E$5)),1),ROUNDDOWN(((10*H25/G25*$G$5)+(10*F25/E25*$E$5)),1))","v":10},null,null,null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"l/100km",{"$f":"RESULTS!$Q$12","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",{"$f":"RESULTS!$R$12","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kg/100km",null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",{"$f":"P29*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",0,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"l/100km",{"$f":"RESULTS!$Q$10","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",{"$f":"RESULTS!$R$10","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"kg/100km",null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",{"$f":"P30*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",0,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"l/100km",{"$f":"RESULTS!$Q$15","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",{"$f":"RESULTS!$R$15","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kg/100km",null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",{"$f":"P31*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",0,{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"l/100km",{"$f":"RESULTS!$Q$16","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",{"$f":"RESULTS!$R$16","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kg/100km",null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",{"$f":"P32*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",0,{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"l/100km",{"$f":"RESULTS!$Q$13","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",{"$f":"RESULTS!$R$13","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kg/100km",null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",{"$f":"P33*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",0,{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","l/100km",{"$f":"AVERAGE(P$25,P$27,P$30)","v":0},"Average","kWh/100km",{"$f":"AVERAGE(S$25,S$27,S$30)","v":0},"Average","kg/100km",null,null,"Average","kWh/100km",{"$f":"AVERAGE(Z$25,Z$27,Z$30)","v":0},"Average","kWh/100km",{"$f":"AVERAGE(AC$25,AC$27,AC$30)","v":0},"Average","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm Test (Lab)","l/100km",{"$f":"P27","v":0},"Warm Test (Lab)","kWh/100km",{"$f":"S27","v":0},"Warm Test (Lab)","kg/100km",null,null,"Warm Test (Lab)","kWh/100km",{"$f":"Z27","v":0},"Warm Test (Lab)","kWh/100km",{"$f":"AC27","v":0},"Warm Test (Lab)","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway","l/100km",{"$f":"P30","v":0},"Highway","kWh/100km",{"$f":"S30","v":0},"Highway","kg/100km",null,null,"Highway","kWh/100km",{"$f":"Z30","v":0},"Highway","kWh/100km",{"$f":"AC30","v":0},"Highway","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cold Ambient Test","l/100km",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",P26,\"-\")","v":0},"Cold Ambient Test","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",S26,\"-\")","v":0},"Cold Ambient Test","kg/100km",null,null,"Cold Ambient Test","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",Z26,\"-\")","v":0},"Cold Ambient Test","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",AC26,\"-\")","v":0},"Cold Ambient Test","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Best Case for LCA","l/100km",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",MIN(Efficiency!P25:P28),MIN(Efficiency!P25,Efficiency!P27,Efficiency!P28,Efficiency!P30))","v":0},"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",MIN(Efficiency!S25:S28),MIN(Efficiency!S25,Efficiency!S27,Efficiency!S28,Efficiency!S30))","v":0},"Best Case for LCA","kg/100km",null,null,"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",MIN(Efficiency!Z25:Z28),MIN(Efficiency!Z25,Efficiency!Z27,Efficiency!Z28,Efficiency!Z30))","v":0},"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",MIN(Efficiency!AC25:AC28),MIN(Efficiency!AC25,Efficiency!AC27,Efficiency!AC28,Efficiency!AC30))","v":0},"Best Case for LCA","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case for LCA","l/100km",{"$f":"MAX(P25:P28,P30:P32)","v":0},"Worst Case for LCA","kWh/100km",{"$f":"MAX(S25:S28,S30:S32)","v":0},"Worst Case for LCA","kg/100km",null,null,"Worst Case for LCA","kWh/100km",{"$f":"MAX(Z25:Z28,Z30)","v":0},"Worst Case for LCA","kWh/100km",{"$f":"MAX(AC25:AC28,AC30:AC32)","v":0},"Worst Case for LCA","kWh/100km"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.2.1 Charge Sustaining",null,null,"2.2.2 Charge Sustaining",null,null,"2.2.3 Charge Sustaining"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Driving Range (liquid fuel)",null,null,"Driving Range (electric energy)",null,null,"Driving Range (CNG, Hydrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",{"$f":"IF(P25>0,100*SPECS!$B$9/P25,0)","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",{"$f":"IF(S25>0,100*SPECS!$B$34/S25,0)","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",{"$f":"IF(P26>0,100*SPECS!$B$9/P26,0)","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",{"$f":"IF(S26>0,100*SPECS!$B$34/S26,0)","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"km",{"$f":"IF(P27>0,100*SPECS!$B$9/P27,0)","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"km",{"$f":"IF(S27>0,100*SPECS!$B$34/S27,0)","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",{"$f":"IF(P28>0,100*SPECS!$B$9/P28,0)","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",{"$f":"IF(S28>0,100*SPECS!$B$34/S28,0)","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",{"$f":"IF(P29>0,100*SPECS!$B$9/P29,0)","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",{"$f":"IF(S29>0,100*SPECS!$B$34/S29,0)","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"km",{"$f":"IF(P30>0,100*SPECS!$B$9/P30,0)","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"km",{"$f":"IF(S30>0,100*SPECS!$B$34/S30,0)","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",{"$f":"IF(P31>0,100*SPECS!$B$9/P31,0)","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",{"$f":"IF(S31>0,100*SPECS!$B$34/S31,0)","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",{"$f":"IF(P32>0,100*SPECS!$B$9/P32,0)","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",{"$f":"IF(S32>0,100*SPECS!$B$34/S32,0)","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"km",{"$f":"IF(P33>0,100*SPECS!$B$9/P33,0)","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"km",{"$f":"IF(S33>0,100*SPECS!$B$34/S33,0)","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","km",{"$f":"AVERAGE(P45,P47,P50)","v":0},"Average","km",{"$f":"AVERAGE(S45,S47,S50)","v":0},"Average","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm Test (Lab)","km",{"$f":"P47","v":0},"Warm Test (Lab)","km",{"$f":"S47","v":0},"Warm Test (Lab)","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway","km",{"$f":"P50","v":0},"Highway","km",{"$f":"S50","v":0},"Highway","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cold Ambient Test","km",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",P46,\"-\")","v":0},"Cold Ambient Test","km",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",S46,\"-\")","v":0},"Cold Ambient Test","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Best Case for LCA","km",{"$f":"MAX(P45:P48,P50)","v":0},"Best Case for LCA","km",{"$f":"MAX(S45:S48,S50)","v":0},"Best Case for LCA","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case for LCA","km",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",MIN(Efficiency!P45:P48,Efficiency!P50),MIN(Efficiency!P45,Efficiency!P47,Efficiency!P48,Efficiency!P50))","v":0},"Worst Case for LCA","km",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",MIN(Efficiency!S45:S48,Efficiency!S50),MIN(Efficiency!S45,Efficiency!S47,Efficiency!S48,Efficiency!S50))","v":0},"Worst Case for LCA","km"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conversion from l/100km or kg/100km to kWh/100km for different energy carriers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.3.1 Charge Depleting",null,null,"2.3.2 Charge Depleting",null,null,"2.3.3 Charge Depleting",null,null,null,"2.3.4 Charge Depleting",null,null,"2.3.5 Charge Depleting",null,null,"2.3.6 Charge Depleting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Consumption (liquid fuel)",null,null,"Energy Consumption (electric energy)",null,null,"Gas Consumption (CNG, Hydrogen)",null,null,null,"Fuel Consumption (liquid fuel)",null,null,"Energy Consumption (electric energy)",null,null,"Gas Consumption (CNG, Hydrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"l/100km",{"$f":"RESULTS!$Q$26","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"RESULTS!$R$26","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kg/100km",null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"P67*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"S67","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"l/100km",null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kg/100km",null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"l/100km",null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kg/100km",null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"l/100km",{"$f":"RESULTS!$Q$33","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"RESULTS!$R$33","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kg/100km",null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"P70*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"S70","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"l/100km",null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kg/100km",null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"l/100km",null,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",null,{"$f":"$C$15","v":"BAB130 Motorway"},"kg/100km",null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",null,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",null,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"l/100km",{"$f":"RESULTS!$Q$37","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",{"$f":"RESULTS!$R$37","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kg/100km",null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",{"$f":"P73*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",0,{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"l/100km",{"$f":"RESULTS!$Q$38","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",{"$f":"RESULTS!$R$38","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kg/100km",null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",{"$f":"P74*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",0,{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"l/100km",{"$f":"RESULTS!$Q$35","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",{"$f":"RESULTS!$R$35","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kg/100km",null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",{"$f":"P75*IF(Petrol_PHEV,'LIMITS Efficiency'!$C$19,IF(Diesel_PHEV,'LIMITS Efficiency'!$C$20))","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",0,{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","l/100km",{"$f":"P67","v":0},"Average","kWh/100km",{"$f":"S67","v":0},"Average","kg/100km",null,null,"Average","kWh/100km",{"$f":"AVERAGE(Z67)","v":0},"Average","kWh/100km",{"$f":"AVERAGE(AC67)","v":0},"Average","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm Test (Lab)","l/100km",null,"Warm Test (Lab)","kWh/100km",null,"Warm Test (Lab)","kg/100km",null,null,"Warm Test (Lab)","kWh/100km",null,"Warm Test (Lab)","kWh/100km",null,"Warm Test (Lab)","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway","l/100km",null,"Highway","kWh/100km",null,"Highway","kg/100km",null,null,"Highway","kWh/100km",null,"Highway","kWh/100km",null,"Highway","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cold Ambient Test","l/100km",null,"Cold Ambient Test","kWh/100km",null,"Cold Ambient Test","kg/100km",null,null,"Cold Ambient Test","kWh/100km",null,"Cold Ambient Test","kWh/100km",null,"Cold Ambient Test","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Best Case for LCA","l/100km",null,"Best Case for LCA","kWh/100km",null,"Best Case for LCA","kg/100km",null,null,"Best Case for LCA","kWh/100km",null,"Best Case for LCA","kWh/100km",null,"Best Case for LCA","kWh/100km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case for LCA","l/100km",null,"Worst Case for LCA","kWh/100km",null,"Worst Case for LCA","kg/100km",null,null,"Worst Case for LCA","kWh/100km",null,"Worst Case for LCA","kWh/100km",null,"Worst Case for LCA","kWh/100km"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.3.7 Charge Depleting",null,null,"2.3.8 Charge Depleting",null,null,"2.3.9 Charge Depleting"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Driving Range (liquid fuel)",null,null,"Driving Range (electric energy)",null,null,"Driving Range (CNG, Hydrogen)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"km",null,{"$f":"$C$12","v":"WLTC+ warm engine"},"km",null,{"$f":"$C$12","v":"WLTC+ warm engine"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"km",null,{"$f":"$C$15","v":"BAB130 Motorway"},"km",null,{"$f":"$C$15","v":"BAB130 Motorway"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"km",null,{"$f":"$C$18","v":"Short trip / cold start 1"},"km",null,{"$f":"$C$18","v":"Short trip / cold start 1"},"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average","km",null,"Average","km",null,"Average","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm Test (Lab)","km",null,"Warm Test (Lab)","km",null,"Warm Test (Lab)","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway","km",null,"Highway","km",null,"Highway","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cold Ambient Test","km",null,"Cold Ambient Test","km",null,"Cold Ambient Test","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Best Case for LCA","km",null,"Best Case for LCA","km",null,"Best Case for LCA","km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case for LCA","km",null,"Worst Case for LCA","km",null,"Worst Case for LCA","km"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.4 Total PHEV Consumption Figures"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liquid Fuel",null,null,"Electric Energy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average PHEV","l/100km",{"$f":"$E$5*P34+$G$5*P76","v":0},null,"kWh/100 km",{"$f":"$E$5*S34+$G$5*S76","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case PHEV","l/100km",{"$f":"P39","v":0},null,"kWh/100 km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Best Case PHEV","l/100km",{"$f":"P73","v":0},null,"kWh/100 km",{"$f":"S73","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.5 Total PHEV Driving Range Figures"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liquid Fuel",null,null,"Electric Energy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average PHEV","km",{"$f":"P54","v":0},null,"km",{"$f":"RESULTS!AA26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst Case PHEV","km",{"$f":"P59","v":0},null,"km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Best Case PHEV","km",{"$f":"P58","v":0},null,"km",{"$f":"RESULTS!AA37","v":0}]

{"sheet":"Greenhouse","index":3,"n_rows":53,"n_cols":26,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,8,52,9],[48,9,49,9],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[46,4,46,5],[46,6,46,7],[50,1,50,2],[52,1,52,2],[52,6,52,7],[46,8,47,8],[46,9,47,9],[42,1,42,2],[31,1,31,2],[22,1,22,2],[21,17,21,25],[23,17,23,18],[23,20,23,21],[23,23,23,24],[33,17,33,25],[3,1,3,2],[1,1,2,2],[1,8,2,9],[1,10,3,10],[13,1,13,2],[1,6,1,7],[1,4,1,5],[2,4,2,5],[2,6,2,7],[4,17,4,25],[6,17,6,18],[6,20,6,21],[6,23,6,24],[16,17,16,25]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"3.Greenhouse gasses",null,null,"Test Results",null,"Test Results",null,"Thresholds",null,"Max score"]
[null,null,null,null,"CS mode",null,"CD mode",null,null,null,null,null,null,null,null,null,null,"3.2 Charge Sustaining Mode"]
[null,null,null,null,"Value","Points","Value","Points","Lower","Upper",null,null,null,null,null,null,null,"Conversion from local consumption kWh/100km to upstream GHG emissions in g/km for different energy carriers"]
[null,"3.1","Weighting",null,{"$f":"'Clean Air'!E5","v":0.8},null,{"$f":"'Clean Air'!G5","v":0.19999999999999996},null,null,null,null,null,{"$f":"B6","v":"WLTC+ cold engine (23°C)"},null,null,null,null,"CO2 equivalent upstream (Well-to-Tank+)"]
[null,{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"max points",null,null,{"$f":"K9","v":10},null,{"$f":"K9","v":10},null,null,null,null,"Averaged","max points",10,null,null,"Liquid Fuel",null,"Factor","Electricity",null,"Factor","Gaseous Fuel",null,"Factor"]
[null,"Standard","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$4","v":0},{"$f":"IF(E7<=J7,K7,0)","v":0.5},{"$f":"RESULTS!$M$26","v":0},{"$f":"IF(G7<=J7,K7,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$12","v":0},{"$f":"'LIMITS Greenhouse'!$D$6","v":10},0.5,null,"N2O tailpipe","scored",{"$f":"$E$5*F7+$G$5*H7","v":0.5},null,null,{"$f":"IF(Petrol_PHEV,\"Petrol\",IF(Diesel_PHEV,\"Diesel\",\"-\"))","v":"Petrol"},null,{"$f":"IF(Petrol_PHEV,'LIMITS Greenhouse'!$D$21,IF(Diesel_PHEV,'LIMITS Greenhouse'!$D$22,0))","v":0.85607812995876598},{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"Electricity\",\"-\")","v":"Electricity"},null,{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),'LIMITS Greenhouse'!D23,0)","v":2.8202228762269628}]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$4","v":0},{"$f":"IF(E8<=J8,K8,0)","v":0.5},{"$f":"RESULTS!$P$26","v":0},{"$f":"IF(G8<=J8,K8,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$13","v":0},{"$f":"'LIMITS Greenhouse'!$D$7","v":32},0.5,null,"CH4 tailpipe","scored",{"$f":"$E$5*F8+$G$5*H8","v":0.5},null,null,{"$f":"Efficiency!$C$10","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!Z25*T$7","v":0},{"$f":"Efficiency!$C$10","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!AC25*$W$7","v":0},{"$f":"Efficiency!$C$10","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!AF25*Greenhouse!$Z$7","v":0}]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E10:E13)","v":0},{"$f":"Sliding_Scale(E9,I9,J9,K9,0,Slide_Type)","v":10},{"$f":"SUM(G10:G13)","v":0},{"$f":"Sliding_Scale(G9,I9,J9,K9,0,Slide_Type)","v":10},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!$N$8","v":225},10,null,"Total CO2 equivalent","scored",{"$f":"$E$5*F9+$G$5*H9","v":10},null,null,{"$f":"Efficiency!$C$11","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!Z26*T$7","v":0},{"$f":"Efficiency!$C$11","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!AC26*$W$7","v":0},{"$f":"Efficiency!$C$11","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!AF26*Greenhouse!$Z$7","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"RESULTS!$F$4","v":0},null,{"$f":"RESULTS!$F$26","v":0},null,null,null,null,null,"CO2 tailpipe",null,null,null,null,{"$f":"Efficiency!$C$12","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!Z27*T$7","v":0},{"$f":"Efficiency!$C$12","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!AC27*$W$7","v":0},{"$f":"Efficiency!$C$12","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!AF27*Greenhouse!$Z$7","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M4*'LIMITS Greenhouse'!$B$14/1000","v":0},null,{"$f":"G7*'LIMITS Greenhouse'!$B$14/1000","v":0},null,null,null,null,null,"N2O CO2-eq (from tailpipe)",null,null,null,null,{"$f":"Efficiency!$C$13","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!Z28*T$7","v":0},{"$f":"Efficiency!$C$13","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!AC28*$W$7","v":0},{"$f":"Efficiency!$C$13","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!AF28*Greenhouse!$Z$7","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P4*'LIMITS Greenhouse'!$B$15/1000","v":0},null,{"$f":"G8*'LIMITS Greenhouse'!$B$15/1000","v":0},null,null,null,null,null,"CH4 CO2-eq (from tailpipe)",null,null,null,null,{"$f":"Efficiency!$C$14","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!Z29*T$7","v":0},{"$f":"Efficiency!$C$14","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!AC29*$W$7","v":0},{"$f":"Efficiency!$C$14","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!AF29*Greenhouse!$Z$7","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T8+W8+Z8-(1-(IF(Petrol_PHEV,'LIMITS Greenhouse'!D31,IF(Diesel_PHEV,'LIMITS Greenhouse'!D32,1))))*E10","v":0},null,{"$f":"T25+W25+Z25-(1-(IF(Petrol_PHEV,'LIMITS Greenhouse'!D31,IF(Diesel_PHEV,'LIMITS Greenhouse'!D32,1))))*G10","v":0},null,null,null,null,null,"CO2-eq upstream (Well-to-Tank+)",null,null,null,null,{"$f":"Efficiency!$C$15","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!Z30*T$7","v":0},{"$f":"Efficiency!$C$15","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!AC30*$W$7","v":0},{"$f":"Efficiency!$C$15","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!AF30*Greenhouse!$Z$7","v":0}]
[null,"total",null,null,null,{"$f":"MIN(MAX(SUM(F7:F9),0),10)","v":10},null,{"$f":"MIN(MAX(SUM(H7:H9),0),10)","v":10},null,null,null,null,null,"total AVG",{"$f":"$E$5*F14+$G$5*H14","v":10},null,null,{"$f":"Efficiency!$C$16","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!Z31*T$7","v":0},{"$f":"Efficiency!$C$16","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!AC31*$W$7","v":0},{"$f":"Efficiency!$C$16","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!AF31*Greenhouse!$Z$7","v":0}]
[null,{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"max points",null,null,{"$f":"K18","v":10},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$17","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!Z32*T$7","v":0},{"$f":"Efficiency!$C$17","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!AC32*$W$7","v":0},{"$f":"Efficiency!$C$17","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!AF32*Greenhouse!$Z$7","v":0}]
[null,"Additional Robustness","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$7","v":0},{"$f":"IF(E16<=J16,K16,0)","v":0.5},null,null,{"$f":"'LIMITS Greenhouse'!$E$12","v":0},{"$f":"'LIMITS Greenhouse'!$D$6","v":10},0.5,null,null,null,null,null,null,{"$f":"Efficiency!$C$18","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!Z33*T$7","v":0},{"$f":"Efficiency!$C$18","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!AC33*$W$7","v":0},{"$f":"Efficiency!$C$18","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!AF33*Greenhouse!$Z$7","v":0}]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$7","v":0},{"$f":"IF(E17<=J17,K17,0)","v":0.5},null,null,{"$f":"'LIMITS Greenhouse'!$E$13","v":0},{"$f":"'LIMITS Greenhouse'!$D$7","v":32},0.5]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E19:E22)","v":0},{"$f":"Sliding_Scale(E18,I18,J18,K18,0,Slide_Type)","v":10},null,null,{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!$N$8","v":225},10]
[null,null,"CO2 tailpipe","g/km",{"$f":"RESULTS!$F$7","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M7*'LIMITS Greenhouse'!$B$14/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"3.3 Charge Depleting Mode"]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P7*'LIMITS Greenhouse'!$B$15/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Conversion from local consumption kWh/100km to upstream GHG emissions in g/km for different energy carriers"]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T9+W9+Z9-(1-(IF(Petrol_PHEV,'LIMITS Greenhouse'!D31,IF(Diesel_PHEV,'LIMITS Greenhouse'!D32,1))))*E19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"CO2 equivalent upstream (Well-to-Tank+)"]
[null,"total",null,null,null,{"$f":"MIN(MAX(SUM(F16:F18),0),10)","v":10},null,null,null,null,null,null,null,null,null,null,null,"Liquid Fuel",null,"Factor","Electricity",null,"Factor","Gaseous Fuel",null,"Factor"]
[null,{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"max points",null,null,{"$f":"K27","v":10},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Petrol_PHEV,\"Petrol\",IF(Diesel_PHEV,\"Diesel\",\"-\"))","v":"Petrol"},null,{"$f":"IF(Petrol_PHEV,'LIMITS Greenhouse'!$D$21,IF(Diesel_PHEV,'LIMITS Greenhouse'!$D$22,0))","v":0.85607812995876598},{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"Electricity\",\"-\")","v":"Electricity"},null,{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),'LIMITS Greenhouse'!D23,0)","v":2.8202228762269628}]
[null,"Standard","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$8","v":0},{"$f":"IF(E25<=J25,K25,0)","v":0.5},null,null,{"$f":"'LIMITS Greenhouse'!$E$12","v":0},{"$f":"'LIMITS Greenhouse'!$D$6","v":10},0.5,null,null,null,null,null,null,{"$f":"Efficiency!$C$10","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!Z67*T$24","v":0},{"$f":"Efficiency!$C$10","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!AC67*$W$24","v":0},{"$f":"Efficiency!$C$10","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!AF42*Greenhouse!$Z$7","v":0}]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$8","v":0},{"$f":"IF(E26<=J26,K26,0)","v":0.5},null,null,{"$f":"'LIMITS Greenhouse'!$E$13","v":0},{"$f":"'LIMITS Greenhouse'!$D$7","v":32},0.5,null,null,null,null,null,null,{"$f":"Efficiency!$C$11","v":"WLTC+ CAT (-7°C)"},"g/km",null,{"$f":"Efficiency!$C$11","v":"WLTC+ CAT (-7°C)"},"g/km",null,{"$f":"Efficiency!$C$11","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!AF43*Greenhouse!$Z$7","v":0}]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E28:E31)","v":0},{"$f":"Sliding_Scale(E27,I27,J27,K27,0,Slide_Type)","v":10},null,null,{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!$N$8","v":225},10,null,null,null,null,null,null,{"$f":"Efficiency!$C$12","v":"WLTC+ warm engine"},"g/km",null,{"$f":"Efficiency!$C$12","v":"WLTC+ warm engine"},"g/km",null,{"$f":"Efficiency!$C$12","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!AF44*Greenhouse!$Z$7","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"RESULTS!$F$8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$13","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!Z70*T$24","v":0},{"$f":"Efficiency!$C$13","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!AC70*$W$24","v":0},{"$f":"Efficiency!$C$13","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!AF45*Greenhouse!$Z$7","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M8*'LIMITS Greenhouse'!$B$14/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$14","v":"PEMS+ cold engine 2"},"g/km",null,{"$f":"Efficiency!$C$14","v":"PEMS+ cold engine 2"},"g/km",null,{"$f":"Efficiency!$C$14","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!AF46*Greenhouse!$Z$7","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P8*'LIMITS Greenhouse'!$B$15/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$15","v":"BAB130 Motorway"},"g/km",null,{"$f":"Efficiency!$C$15","v":"BAB130 Motorway"},"g/km",null,{"$f":"Efficiency!$C$15","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!AF47*Greenhouse!$Z$7","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T10+W10+Z10-(1-(IF(Petrol_PHEV,'LIMITS Greenhouse'!D31,IF(Diesel_PHEV,'LIMITS Greenhouse'!D32,1))))*E28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$16","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!Z73*T$24","v":0},{"$f":"Efficiency!$C$16","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!AC73*$W$24","v":0},{"$f":"Efficiency!$C$16","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!AF48*Greenhouse!$Z$7","v":0}]
[null,"total",null,null,null,{"$f":"MIN(MAX(SUM(F25:F27),0),10)","v":10},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$17","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!Z74*T$24","v":0},{"$f":"Efficiency!$C$17","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!AC74*$W$24","v":0},{"$f":"Efficiency!$C$17","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!AF49*Greenhouse!$Z$7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Efficiency!$C$18","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!Z75*T$24","v":0},{"$f":"Efficiency!$C$18","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!AC75*$W$24","v":0},{"$f":"Efficiency!$C$18","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!AF50*Greenhouse!$Z$7","v":0}]
[]
[null,{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"max points",null,null,{"$f":"K38","v":10}]
[null,"Standard","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$10","v":0},{"$f":"IF(E36<=J36,K36,0)","v":0.5},null,null,{"$f":"'LIMITS Greenhouse'!$E$12","v":0},{"$f":"'LIMITS Greenhouse'!$D$6","v":10},0.5]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$10","v":0},{"$f":"IF(E37<=J37,K37,0)","v":0.5},null,null,{"$f":"'LIMITS Greenhouse'!$E$13","v":0},{"$f":"'LIMITS Greenhouse'!$D$7","v":32},0.5]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E39:E42)","v":0},{"$f":"Sliding_Scale(E38,I38,J38,K38,0,Slide_Type)","v":10},null,null,{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!$N$8","v":225},10]
[null,null,"CO2 tailpipe","g/km",{"$f":"RESULTS!$F$10","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M10*'LIMITS Greenhouse'!$B$14/1000","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P10*'LIMITS Greenhouse'!$B$15/1000","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T13+W13+Z13-(1-(IF(Petrol_PHEV,'LIMITS Greenhouse'!D31,IF(Diesel_PHEV,'LIMITS Greenhouse'!D32,1))))*E58","v":0}]
[null,null,null,null,null,{"$f":"MIN(MAX(SUM(F36:F38),0),10)","v":10}]
[]
[]
[]
[null,"SUMMARY",null,null,"CS mode",null,"CD mode",null,"Subscore","Stage 2?"]
[null,null,null,null,"max points","scored points","max points","scored points"]
[null,"Standard Testing",null,null,{"$f":"F6+F24+F35","v":30},{"$f":"F14+F32+F43","v":30},{"$f":"H6","v":10},{"$f":"H14","v":10},{"$f":"ROUNDDOWN(((10*H49/G49*G5)+(10*F49/E49*E5)),1)","v":10},{"$f":"IF(AND(AVERAGE(I49,Efficiency!I25,'Clean Air'!H100)>='LIMITS Clean Air'!$P$20,MIN(I49,Efficiency!I25,'Clean Air'!H100)>='LIMITS Clean Air'!$P$24),\"YES\",\"NO\")","v":"YES"}]
[null,"Additional Robustness Testing",null,null,{"$f":"F15","v":10},{"$f":"IF(J49=\"yes\",F23,0)","v":10},null,null,{"$f":"ROUNDDOWN(((10*F50/E50)),1)","v":10}]
[null,"Sum",null,null,{"$f":"SUM(E49,E50)","v":40},{"$f":"SUM(F49,F50)","v":40},{"$f":"SUM(G49,G50)","v":10},{"$f":"SUM(H49,H50)","v":10}]
[]
[null,"TOTAL SCORE GREENHOUSE GAS",null,null,null,null,"(0-10pts)",null,{"$f":"IF('OVERALL RATING (avg)'!F15=\"YES\",ROUNDDOWN((10*H51/G51*$G$5+10*F51/E51*$E$5),1),ROUNDDOWN((10*H49/G49*$G$5+10*F49/E49*$E$5),1))","v":10}]

{"sheet":"RESULTS","index":4,"n_rows":46,"n_cols":29,"rows_kept":46,"cut":false,"hidden":false,"merged":[[41,1,43,1],[42,2,42,3],[43,2,43,3],[23,0,43,0],[1,0,21,0],[32,1,40,1],[25,1,31,1],[10,1,18,1],[3,1,9,1],[34,2,35,2],[12,2,13,2],[25,2,28,2],[29,2,31,2],[3,2,6,2],[7,2,9,2],[1,1,1,3],[36,2,40,2],[32,2,33,2],[10,2,11,2],[23,1,23,3],[14,2,18,2],[19,1,21,1],[19,2,19,3],[20,2,20,3],[21,2,21,3]]}
[]
["CHARGE SUSTAINING MODE","RESULTS CHARGE SUSTAINING MODE",null,null,"CO2\ntailpipe","CO2                RCB corr.","CO","NOx","NO","NO2","PN","PM","N2O","NH3","THC","CH4","Fuel Consumption","Energy Consumption from Grid","Fuel consumpt.","Energy consumpt.","Gas Consumption","Board Comp.\n fuel consumpt.","Board Comp.\n energy consumpt.","Board Comp.\ngas consumpt.","Driving Range\n(ICE mode)","Driving Range\n(electr. mode)\nEAER","Gross Battery Capacity (from grid)","Measured Netto Battery Capacity"]
[null,null,null,null,"g/km","g/km","mg/km","mg/km","mg/km","mg/km","#/km","mg/km","mg/km","mg/km","mg/km","mg/km","l/100km","kWh/100km","g/s","Wh/s","kg/100km","l/100km","kWh/100km","kg/100km","km","km","kWh","kWh"]
[null,"Laboratory Tests","WLTC+ appr.","WLTC+ cold engine (23°C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,null,null,null,null,"n.a."]
[null,null,null,"WLTC+ cold engine 2 (not rated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a."]
[null,null,null,"WLTC+ cold engine average (not rated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a."]
[null,null,null,"WLTC+ CAT (-7°C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,null,null,null,null,"n.a."]
[null,null,"Robustness","WLTC+ warm engine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,null,null,null,null,"n.a."]
[null,null,null,"WLTC+ reg. warm engn. rep. (not rated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a."]
[null,null,null,"BAB130 Motorway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,null,null,null,null,"n.a."]
[null,"Real-World tests","Approval","PEMS+ cold engine 1",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.",null,null,null,null,null,"n.a."]
[null,null,null,"PEMS+ cold engine 2",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,null,null,null,null,null,null,null,"n.a."]
[null,null,"Short urban trip","Short trip / cold start 1",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.",null,"n.a.","n.a.","n.a.",null,"n.a."]
[null,null,null,"Short trip / cold start 2",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,"Robustness","PEMS+ Eco / light",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,null,null,null,null,null,null,null,"n.a."]
[null,null,null,"PEMS+ Heavy load",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,null,null,null,null,null,null,null,"n.a."]
[]
[null,null,null,"Congestion MAX value",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,null,"Congestion AVG value",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
[null,"DPF Regene-ration",null,null,"g/km ↓","g/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","#/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","l/100km ↓","kWh/100km ↓","g/s ↓","Wh/s ↓","kg/100km ↓","l/100km ↓","kWh/100km ↓","kg/100km ↓","km ↓","n.a."]
[null,null,"Insert name of test with particle filter regeneration occurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a."]
[null,null,"Impact of regen. compared to the non-regenerating test [%]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a."]
[]
["CHARGE DEPLETING MODE","RESULTS CHARGE DEPLETING MODE",null,null,"CO2\ntailpipe","CO2                RCB corr.","CO","NOx","NO","NO2","PN","PM","N2O","NH3","THC","CH4","Fuel Consumption","Energy Consumption from grid","Fuel consumpt.","Energy consumpt.","Gas Consumption","BC fuel consumpt.","BC energy consumpt.","BC gas consumpt.","Driving Range\n(ICE mode)","Driving Range\n(electr. mode)\nEAER","Driving range electr. Mode (Pure EV)",null,"Electr. energy consumpt. from battery"]
[null,null,null,null,"g/km","g/km","mg/km","mg/km","mg/km","mg/km","#/km","mg/km","mg/km","mg/km","mg/km","mg/km","l/100km","kWh/100km","g/s","Wh/s","kg/100km","L/100km","kWh/100km","kg/100km","km","km","km",null,"kWh/100km"]
[null,"Laboratory Tests","WLTC+ appr.","WLTC+ cold engine CD sequence (23 degr C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,null,null,null,"n.a."]
[]
[]
[]
[null,null,"Robustness"]
[]
[]
[null,"Real-World tests","Approval","PEMS+ Cold Engine 1 CD",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.",null,null,null,null,"n.a."]
[]
[null,null,"Short urban trip","Short trip / cold start 1  CD",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.",null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[]
[null,null,"Robustness","Eco / light  CD",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a.",null,null,null,null,"n.a."]
[null,null,null,"Heavy Load  CD",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.",null,null,"n.a.","n.a."]
[null,null,null,null,"g/s ↓",null,"mg/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","#/s ↓",null,null,null,null,null,null,null,"g/s ↓","Wh/s ↓","g/s ↓"]
[]
[]
[null,"DPF Regene-ration",null,null,"g/km ↓","g/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","#/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","mg/km ↓","l/100km ↓","kWh/100km ↓","g/s ↓","Wh/s ↓","kg/100km ↓","l/100km ↓","kWh/100km ↓","kg/100km ↓","km ↓","n.a."]
[null,null,"Insert name of test with particle filter regeneration occurance"]
[null,null,"Impact of regen. compared to the non-regenerating test [%]"]
[null,null,null," "]
[null,null,null,"EAER",{"$f":"Z26","v":0}]

{"sheet":"SPECS","index":5,"n_rows":46,"n_cols":21,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Brand",null,"CoC p.0.1. (e.g. Mercedes-Benz)",null,null,null,null,null,null,null,null,"Petrol PHEV",{"$f":"IF(ICE_Type=1,TRUE,FALSE)","v":true},1,"Version","Euro 6b"]
["Model",null,"CoC p.0.2.1. (e.g. V-Class)",null,null,null,null,null,null,null,null,"Diesel PHEV",{"$f":"IF(ICE_Type=2,TRUE,FALSE)","v":false},true,"2022v1.4","Euro 6c"]
["Variant Name",null,"Model data (e.g. V250d, 9G-Tronic, Avantgarde)",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(EngineType,\"False\")","v":1},null,null,"Euro 6d-Temp"]
["Green NCAP Test Reference Number",null,"(e.g. 20-FOR-0023)",null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d"]
["Drivetrain (FWD/AWD/RWD/4WD)",null,"CoC p.3. (e.g. RWD)",null,null,null,null,null,null,null,null,null,null,null,null,"Euro AX"]
["Fuel Type"]
["Primary fuel source"]
["Secondary fuel source (if applicable)"]
["Fuel tank size liquid fuel [l]",null,"Tech data (e.g. 70 l)"]
["Fuel tank size gaseous fuel [kg]",null,"Tech data (e.g. 15 kg)"]
["Declared Battery Capacity [kWh]",null,"Tech data (e.g. 52 kWh)"]
["Declared CO2 emissions (WLTP, combined for PHEV) [g/km]",null,"CoC p.49.4. (e.g. 132 g/km)"]
["Declared Fuel Consumption (WLTP, combined for PHEV) [l(kg)/100km]",null,"CoC p.49.4. (e.g. 6.2 l/100km)"]
["Declared Fuel Consumption 2nd fuel source (WLTP, combined for PHEV) [l(kg)/100km]",null,"CoC p.49.4. (e.g. 6.2 l/100km)"]
["Declared Electric Energy Consumption (for BEV) [kWh/100km]",null,"CoC p.49.5.1 (e.g. 19.5 kWh/100km)"]
["Declared Electric Range (for BEV) [km]",null,"CoC p.49.5.1 (e.g. 400 km)"]
["Declared Electric Range City (for BEV) [km]",null,"CoC p.49.5.1 (e.g. 480 km)"]
["Declared Electric Energy Consumption (for PHEV) [kWh/100km]",null,"CoC p.49.5.2 (e.g. 13.9 kWh/100km)"]
["Declared Electric Range (EAER, for PHEV) [km]",null,"CoC p.49.5.2 (e.g. 50 km)"]
["Declared Electric Range City (for PHEV) [km]",null,"CoC p.49.5.2 (e.g. 61 km)"]
["Gearbox type",null,"CoC p.48. (e.g. automatic)"]
["Chassis Version",null,"CoC p.38. may help (e.g. hatchback, check https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX:32011R0678)"]
["Number of doors",null,"CoC p.41. (e.g. 5 doors)",null,null,null,null,"AA","Saloon"]
["VIN tested vehicle",null,"CoC p.0.10. (e.g. WDF44781313651756)",null,null,null,null,"AB","Hatchback"]
["Emissions class",null,"CoC p.47. (e.g. Euro 6d AP)",null,null,null,null,"AC","Station wagon",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AJ"]
["Engine code",null,"CoC p.21. (e.g. BS654T)",null,null,null,null,"AD","Coupe",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AK"]
["Engine capacity [cm3]",null,"CoC p.25. (e.g. 1950 cm3)",null,null,null,null,"AE","Convertible",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AL"]
["Engine/System Power [kW]",null,"CoC p.27. (e.g. 140 kW, for HEV/PHEV see tech data)",null,null,null,null,"AF","Multi-purpose vehicle",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AM"]
["Engine/System Torque [Nm]",null,"See tech data (e.g. 250 Nm)",null,null,null,null,"AG","Truck station wagon",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AN"]
["Tyre size (front and rear if different)",null,"For the actal vehicle (e.g. 245/45, 255/30 R19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AO"]
["Actual Vehicle Mass [kg] = CoC 13.2 - 75 kg",null,"Calculate: CoC p.13.2 - 75 kg (e.g. 1550 kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AR"]
["Measured Gross Battery Capacity (BEV and PHEV, from grid) [kWh]",{"$f":"RESULTS!AA4","v":0},"Don't enter here. Will be taken from Results AA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6 AX"]
["Measured Netto Battery Capacity (BEV and PHEV) [kWh]",{"$f":"RESULTS!AB4","v":0},"Don't enter here. Will be taken from Results AB4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6 AY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6 AZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp AG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp AH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp AI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp BG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp BH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp BI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp CG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp CH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp CI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp DG"]

{"sheet":"LIMITS Clean Air","index":6,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,5,33,6],[30,5,30,7],[1,1,1,12],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,16],[8,14,8,16],[14,10,14,11],[15,10,15,11],[17,2,18,3],[17,6,18,7],[17,10,18,11],[17,14,18,15]]}
[]
[null,"Clean Air (Pollutants)"]
[]
[null,null,"Upper Thresholds (labtests \nw/o WLTC+ CAT (-7°C))",null,"gross excess",null,"Upper Thresholds\n(PEMS+ tests)",null,"gross excess",null,"Upper Thresholds\n WLTC+ CAT (-7°C)\n (extended bouderies)",null,"gross excess",null,"Congestion Simulation\nUpper Thresholds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max","Average"]
[null,null,"NMHC",{"$f":"90-32","v":58},{"$f":"1.5*D6","v":87},null,"NMHC",{"$f":"D6*$I$14","v":76.56},{"$f":"1.5*H6","v":114.84},null,"NMHC",{"$f":"D6*$M$14","v":76.56},{"$f":"1.5*L6","v":114.84},null,null,"mg/s","mg/s"]
[null,null,"NOx",60,{"$f":"1.5*D7","v":90},null,"NOx",79.2,{"$f":"1.5*H7","v":118.80000000000001},null,"NOx",79.2,{"$f":"1.5*L7","v":118.80000000000001},null,"NOx",1,0.5]
[null,null,"NO2",20,{"$f":"1.5*D8","v":30},null,"NO2",26.400000000000002,39.6,null,"NO2",26.400000000000002,39.6]
[null,null,"NH3",10,15,null,"NH3",13.200000000000001,19.8,null,"NH3",13.200000000000001,19.8,null,"Eligible for Stage 2 (Clean Air Only)"]
[null,null,"CO",500,750,null,"CO",660,990,null,"CO",660,990,null,"score",{"$f":"'Clean Air'!H100","v":10},{"$f":"'Clean Air'!J100","v":"YES"}]
[null,null,"PM",4.5,6.75,null,"PM",5.94,8.91,null,"PM",5.94,8.91,null,"threshold",{"$f":"P21","v":5}]
[null,null,"PN23",600000000000,6000000000000,null,"PN23",792000000000,1188000000000,null,"PN23",792000000000,1188000000000]
[null,null,"log10 (PN23) = ",{"$f":"LOG10(D12)","v":11.778151250383644},{"$f":"LOG10(E12)","v":12.778151250383644},null,"log10 (PN23) = ",{"$f":"LOG10(H12)","v":11.898725181589494},{"$f":"LOG10(I12)","v":12.074816440645174},null,"log10 (PN23) = ",{"$f":"LOG10(L12)","v":11.898725181589494},{"$f":"LOG10(M12)","v":12.074816440645174}]
[null,null,null,null,null,null,null,"CF:",1.32,null,null,"CF:",1.32]
[null,null,null,null,null,null,null,null,null,null,"extended bounderies applicable to:"]
[null,null,null,null,null,null,null,null,null,null,"WLTC+ CAT (-7°C)"]
[]
[null,null,"Lower Thresholds",null,null,null,"Lower Thresholds",null,null,null,"Lower Thresholds ",null,null,null,"Stage 2 Index Requierments"]
[]
[null,null,"NMHC",0.5,null,null,"NMHC",{"$f":"D20","v":0.5},null,null,"NMHC",{"$f":"H20","v":0.5},null,null,"Average ",5]
[null,null,"NOx",0.5,null,null,"NOx",0.5,null,null,"NOx",0.5,null,null,"CA",5]
[null,null,"NO2",0,null,null,"NO2",0,null,null,"NO2",0,null,null,"EE",5]
[null,null,"NH3",0.1,null,null,"NH3",0.1,null,null,"NH3",0.1,null,null,"GHG",5]
[null,null,"CO",5,null,null,"CO",5,null,null,"CO",5,null,null,"Min.",3.5]
[null,null,"PM",0,null,null,"PM",0,null,null,"PM",0]
[null,null,"PN23",100000000,null,null,"PN23",100000000,null,null,"PN23",100000000]
[null,null,"log10 (PN23) = ",{"$f":"LOG10(D26)","v":8},null,null,"log10 (PN23) = ",{"$f":"LOG10(H26)","v":8},null,null,"log10 (PN23) = ",{"$f":"LOG10(L26)","v":8}]
[]
[]
[]
[null,null,null,null,null,"PHEV: EAER (km)"]
[null,null,null,null,null,"lower threshold",null,25]
[null,null,null,null,null,"upper threshold",null,100]
[null,null,null,null,null,"ICE FACTOR",null,0.8]

{"sheet":"LIMITS Efficiency","index":7,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5],[3,1,3,5],[16,1,16,5],[24,1,24,3]]}
[]
[null,"Energy Efficiency"]
[]
[null,"Energy Consumption Thresholds"]
[null,null,null,null,"Lower","Upper"]
[null,null,{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"E6","v":20},{"$f":"F6","v":90}]
[null,null,{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"kWh/100km",{"$f":"E7","v":20},{"$f":"F7","v":90}]
[null,null,{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"kWh/100km",20,90]
[]
[]
[null,"Fuel / Energy Consumption"]
[null,"Multiplication liquid fuel (l/100km) or gaseous fuel (kg/100km) --> energy (kWh/100km)"]
[null,"Energy Carrier","Factor (default)",null,"Override"]
[null,"Petrol E10",{"$f":"IF(H19>0,H19,E19)","v":8.64},null,8.64]
[null,"Diesel B7",{"$f":"IF(H20>0,H20,E20)","v":9.7899999999999991},null,9.7899999999999991]
[null,"CNG",{"$f":"IF(H21>0,H21,E21)","v":13.8925},null,13.8925]
[null,"Electric",1,null,1]
[null,"Hydrogene",33.61,null,33.61]
[]
[null,"Eligible for Stage 2 (based on EE only)"]
[null,"score",{"$f":"Efficiency!I29","v":10},{"$f":"Efficiency!K25","v":"YES"}]
[null,"threshold",{"$f":"'LIMITS Clean Air'!P22","v":5}]

{"sheet":"LIMITS Greenhouse","index":8,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,2,3,4],[3,7,3,9],[11,2,11,4],[11,8,11,10],[11,13,11,15],[14,13,14,14],[15,13,15,14],[25,1,25,2],[24,1,24,2],[15,2,15,3],[18,6,18,8],[18,1,18,3],[19,1,19,3],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[14,2,14,3],[27,1,28,3],[29,1,29,3],[30,1,30,2],[31,1,31,2],[1,1,1,15],[16,8,16,9],[12,8,12,10],[13,8,13,9],[14,8,14,9],[16,2,16,3],[16,13,16,14],[12,13,12,15],[12,2,12,4],[13,2,13,3],[13,13,13,14],[15,8,15,9]]}
[]
[null,"Greenhouse gases"]
[]
[null,"GWP","Upper Thresholds (labtests w/o WLTC+ CAT (-7°C))",null,null,"gross excess",null,"Upper Thresholds (PEMS+ tests)",null,null,"gross excess",null,"Upper Thresholds (WLTC+ CAT (-7°C))",null,null,"gross excess"]
[]
[null,298,"N2O mg/km",10,10,{"$f":"1.5*D6","v":15},null,"N2O mg/km",{"$f":"D6*$K$10","v":15},null,22.5,null,"N2O mg/km",{"$f":"D6*$P$10","v":16},{"$f":"E6*$P$10","v":16},24]
[null,25,"CH4 mg/km ",32,32,{"$f":"1.5*D7","v":48},null,"CH4 mg/km ",48,null,72,null,"CH4 mg/km ",{"$f":"D7*$P$10","v":51.2},{"$f":"E7*$P$10","v":51.2},76.800000000000011]
[null,1,"CO2 g/km",225,225,{"$f":"1.5*D8","v":337.5},null,"CO2 g/km",337.5,null,337.5,null,"CO2 g/km",{"$f":"D8","v":225},{"$f":"E8","v":225},337.5]
[]
[null,null,null,null,null,null,null,null,null,"CF:",1.5,null,null,null,"CF:",1.6]
[]
[null,"GWP","Lower Thresholds",null,null,null,null,null,"Lower Thresholds",null,null,null,null,"Lower Thresholds"]
[]
[null,298,"N2O mg/km",null,0,null,null,null,"N2O mg/km",null,{"$f":"E14","v":0},null,null,"N2O mg/km",null,{"$f":"K14","v":0}]
[null,25,"CH4 mg/km ",null,0,null,null,null,"CH4 mg/km ",null,{"$f":"E15","v":0},null,null,"CH4 mg/km ",null,{"$f":"K15","v":0}]
[null,1,"CO2 g/km",null,50,null,null,null,"CO2 g/km",null,50,null,null,"CO2 g/km",null,{"$f":"K16","v":50}]
[]
[]
[null,"CO2-eq upstream factor",null,null,null,null,"Eligible for Stage 2 (based on GHG only)"]
[null,"kWh/100km > gCO2-eq./km ",null,null,null,null,"score",{"$f":"Greenhouse!I49","v":10},{"$f":"Greenhouse!J49","v":"YES"}]
[null,"Petrol E10",null,0.85607812995876598,null,null,"threshold",{"$f":"'LIMITS Clean Air'!P23","v":5}]
[null,"Diesel B7",null,0.66842444188992434]
[null,"Electricity EU27+UK","NO2",2.8202228762269628]
[null,"CNG",null,0.42340500949537657]
[null,"Hydrogen (nat. gas)",null,3.6351490393498231]
[]
[]
[null,"Upstream CO2 reduction factor due to neutral bio-fuel share combustion carbon balance"]
[]
[null,"-"]
[null,"Petrol E10",null,0.93100000000000005]
[null,"Diesel B7",null,0.93500000000000005]

{"sheet":"WEBSITE SUMMARY","index":9,"n_rows":167,"n_cols":4,"rows_kept":167,"cut":false,"hidden":true,"merged":[]}
["Car Model",{"$f":"CONCATENATE(SPECS!B1,\" \",SPECS!B2)","v":" "},null,"Type"]
["Type",{"$f":"SPECS!B3","v":0}]
["Release Date"]
["Year of Test",2022]
["Engine",{"$f":"SPECS!B6","v":0}]
["Gearbox",{"$f":"SPECS!B21","v":0}]
["Emissions Class",{"$f":"SPECS!B25","v":0}]
["Stars",{"$f":"Stars","v":5}]
["Test #",{"$f":"SPECS!B4","v":0}]
["Engine Size 2",{"$f":"SPECS!B27","v":0}]
["Mass",{"$f":"SPECS!B31","v":0}]
["Clean Air Index",{"$f":"'OVERALL RATING (avg)'!$Q$21","v":10}]
["Clean Air Lab Tests - Overall Performance",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",(Colour_Local(((SUM('Clean Air'!F14,'Clean Air'!F23,'Clean Air'!F32,'Clean Air'!F68)/(SUM('Clean Air'!F6,'Clean Air'!F15,'Clean Air'!F24,'Clean Air'!F60))*'Clean Air'!$E$5+('Clean Air'!$G$5*'Clean Air'!$H$23/'Clean Air'!$H$15))),1)),(Colour_Local(((SUM('Clean Air'!F14,'Clean Air'!F23,'Clean Air'!F32)/(SUM('Clean Air'!F6,'Clean Air'!F15,'Clean Air'!F24))*'Clean Air'!$E$5+('Clean Air'!$G$5*'Clean Air'!$H$23/'Clean Air'!$H$15))),1)))","v":"Green"}]
["CA Cold Test - Score",{"$f":"ROUND('Clean Air'!P23,1)","v":10}]
["CA Cold Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!P16,'Clean Air'!Q16)","v":"Green"}]
["CA Cold Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!P17,'Clean Air'!Q17)","v":"Green"}]
["CA Cold Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!P19,'Clean Air'!Q19)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Test - CO Colour",{"$f":"Colour_Local('Clean Air'!P20,'Clean Air'!Q20)","v":"Green"}]
["CA Cold Test - PN Colour",{"$f":"Colour_Local('Clean Air'!P22,'Clean Air'!Q22)","v":"Green"}]
["CA Warm Test - Score",{"$f":"ROUND('Clean Air'!F14,1)","v":10}]
["CA Warm Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F7,'Clean Air'!K7)","v":"Green"}]
["CA Warm Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F8,'Clean Air'!K8)","v":"Green"}]
["CA Warm Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Warm Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F10,'Clean Air'!K10)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Warm Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F11,'Clean Air'!K11)","v":"Green"}]
["CA Warm Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F13,'Clean Air'!K13)","v":"Green"}]
["CA Eco Test - Score",null,"only 2019"]
["CA Eco Test - HC Colour",null,"only 2019"]
["CA Eco Test - NOx Colour",null,"only 2019"]
["CA Eco Test - CO Colour",null,"only 2019"]
["CA Eco Test - PN Colour",null,"only 2019"]
["CA Sport Test - Score",null,"only 2019"]
["CA Sport Test - HC Colour",null,"only 2019"]
["CA Sport Test - NOx Colour",null,"only 2019"]
["CA Sport Test - CO Colour",null,"only 2019"]
["CA Sport Test - PN Colour",null,"only 2019"]
["CA Cold Ambient Test - Score",{"$f":"ROUND('Clean Air'!F68,1)","v":10},null,"Number - 1 decimal place"]
["CA Cold Ambient Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F61,'Clean Air'!K61)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F62,'Clean Air'!K62)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F64,'Clean Air'!K64)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F65,'Clean Air'!K65)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F67,'Clean Air'!I67)","v":"Brown"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - Score",{"$f":"ROUND('Clean Air'!F32,1)","v":10}]
["CA Highway Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F25,'Clean Air'!K25)","v":"Green"}]
["CA Highway Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F26,'Clean Air'!K26)","v":"Green"}]
["CA Highway Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F28,'Clean Air'!K28)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F29,'Clean Air'!K29)","v":"Green"}]
["CA Highway Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F31,'Clean Air'!K31)","v":"Green"}]
["CA Road Test - Overall Performance Colour",{"$f":"IF('OVERALL RATING (avg)'!$F$15=\"YES\",Colour_Local(((SUM('Clean Air'!F41,'Clean Air'!F57,'Clean Air'!F96)/SUM('Clean Air'!F33,'Clean Air'!F50,'Clean Air'!F87))*'Clean Air'!$E$5+('Clean Air'!$G$5*SUM('Clean Air'!$H$41,'Clean Air'!H57,'Clean Air'!H77,'Clean Air'!H86)/SUM('Clean Air'!$H$33,'Clean Air'!H50,'Clean Air'!H69,'Clean Air'!H78))),1),Colour_Local(((SUM('Clean Air'!F41,'Clean Air'!F57)/SUM('Clean Air'!F33,'Clean Air'!F50))*'Clean Air'!$E$5+('Clean Air'!$G$5*SUM('Clean Air'!$H$41,'Clean Air'!H57)/SUM('Clean Air'!$H$33,'Clean Air'!H50))),1))","v":"Green"}]
["CA On Road Drive - Score",{"$f":"ROUND('Clean Air'!P41,1)","v":10}]
["CA On Road Drive - NMHC Colour","Grey"]
["CA On Road Drive - NOx Colour",{"$f":"Colour_Local('Clean Air'!P35,'Clean Air'!Q35)","v":"Green"}]
["CA On Road Drive - NO2 Colour","Grey",null,"Brown - Green - Orange - Red - Yellow"]
["CA On Road Drive - NH3 Colour","Grey",null,"Brown - Green - Orange - Red - Yellow"]
["CA On Road Drive - CO Colour",{"$f":"Colour_Local('Clean Air'!P38,'Clean Air'!Q38)","v":"Green"}]
["CA On Road Drive - PN Colour",{"$f":"Colour_Local('Clean Air'!P40,'Clean Air'!Q40)","v":"Green"}]
["CA Robustness - Overall Performance Colour"]
["CA Light Load - Score",{"$f":"ROUND('Clean Air'!H77,1)","v":5}]
["CA Light Load - NMHC Colour","Grey"]
["CA Light Load - NOx Colour",{"$f":"Colour_Local('Clean Air'!H71,'Clean Air'!K71)","v":"Green"}]
["CA Light Load - NO2 Colour","Grey"]
["CA Light Load - NH3 Colour","Grey"]
["CA Light Load - CO Colour",{"$f":"Colour_Local('Clean Air'!H74,'Clean Air'!K74)","v":"Green"}]
["CA Light Load - PN Colour",{"$f":"Colour_Local('Clean Air'!H76,'Clean Air'!K76)","v":"Green"}]
["CA Heavy Load - Score",{"$f":"ROUND('Clean Air'!H86,1)","v":8}]
["CA Heavy Load - NMHC Colour","Grey"]
["CA Heavy Load - NOx Colour",{"$f":"Colour_Local('Clean Air'!H80,'Clean Air'!K80)","v":"Green"}]
["CA Heavy Load - NO2 Colour","Grey"]
["CA Heavy Load - NH3 Colour","Grey"]
["CA Heavy Load - CO Colour",{"$f":"Colour_Local('Clean Air'!H83,'Clean Air'!K83)","v":"Green"}]
["CA Heavy Load - PN Colour",{"$f":"Colour_Local('Clean Air'!H85,'Clean Air'!K85)","v":"Green"}]
["CA Short Trip - Score",{"$f":"ROUND('Clean Air'!P57,1)","v":5}]
["CA Short Trip - NMHC Colour","Grey"]
["CA Short Trip - NOx Colour",{"$f":"Colour_Local('Clean Air'!P51,'Clean Air'!Q51)","v":"Green"}]
["CA Short Trip - NO2 Colour","Grey"]
["CA Short Trip - NH3 Colour","Grey"]
["CA Short Trip - CO Colour",{"$f":"Colour_Local('Clean Air'!P52,'Clean Air'!Q52)","v":"Green"}]
["CA Short Trip - PN Colour",{"$f":"Colour_Local('Clean Air'!P53,'Clean Air'!Q53)","v":"Green"}]
["CA Congestion - Score",{"$f":"ROUND('Clean Air'!F96,1)","v":2}]
["CA Congestion - NMHC Colour","Grey"]
["CA Congestion - NOx Colour",{"$f":"Colour_Local(SUM('Clean Air'!F89,'Clean Air'!F90),SUM('Clean Air'!K89,'Clean Air'!K90))","v":"Green"}]
["CA Congestion - NO2 Colour","Grey"]
["CA Congestion - NH3 Colour","Grey"]
["CA Congestion - CO Colour","Grey"]
["CA Congestion - PN Colour","Grey"]
["Clean Air Comments"]
["Energy Efficiency Index",{"$f":"'OVERALL RATING (avg)'!Q22","v":10}]
["Energy Efficiency Lab Tests - Overall performance",{"$f":"Colour_Local('OVERALL RATING (avg)'!Q22,10)","v":"Green"}]
["EE Cold Test - Score",{"$f":"ROUND(Efficiency!N10,1)","v":10}]
["EE Cold Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!N10,Efficiency!K10)","v":"Green"}]
["EE Cold Test - Electric Efficiency Value"]
["EE Warm Test - Score",{"$f":"ROUND(Efficiency!F12,1)","v":10}]
["EE Warm Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F12,Efficiency!K12)","v":"Green"}]
["EE Warm Test - Electric Efficiency Value"]
["EE Eco Test - Score","-"]
["EE Eco Test - Energy Eff Colour","-"]
["EE Eco Test - Electric Efficiency Value","-"]
["EE Sport Test - Score","-"]
["EE Sport Test - Energy Eff Colour","-"]
["EE Sport Test - Electric Efficiency Value","-"]
["EE Cold Ambient Test - Score",{"$f":"ROUND(Efficiency!F11,1)","v":10},null,"Number - 1 decimal place"]
["EE Cold Ambient Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F11,Efficiency!K11)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["EE Cold Ambient Test - Electric Efficiency Value",null,null,"Number"]
["EE Highway Test - Score",{"$f":"ROUND(Efficiency!F15,1)","v":10}]
["EE Highway Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F15,Efficiency!K15)","v":"Green"}]
["EE Highway Test - Electric Efficiency Value"]
["Average Consumption (1st fuel source)",{"$f":"ROUND(Efficiency!P106,2)","v":0},null,"Number - 2 decimal places (cfr Joanneum calculation)"]
["Worst-Case Consumption (1st fuel source)",{"$f":"ROUND(Efficiency!P107,2)","v":0},null,"Number - 2 decimal places (cfr Joanneum calculation)"]
["Average Consumption (2nd fuel source)",{"$f":"ROUND(Efficiency!S106,2)","v":0},null,"Number - 2 decimal places (cfr Joanneum calculation)"]
["Worst-Case Consumption (2nd fuel source)","-",null,"Number - 2 decimal places (cfr Joanneum calculation)"]
["Driving Range - Average (1st fuel source)",{"$f":"ROUND(Efficiency!P113,2)","v":0}]
["Driving Range - Worst-Case (1st fuel source)",{"$f":"ROUND(Efficiency!P114,2)","v":0}]
["Driving Range - Average (2nd fuel source)",{"$f":"ROUND(Efficiency!S113,2)","v":0}]
["Driving Range - Worst-Case (2nd fuel source)","-"]
["Energy Efficiency Comment"]
["Greenhouse Gas Index",{"$f":"'OVERALL RATING (avg)'!Q23","v":10},null,"Number - 1 decimal place"]
["Greenhouse Gas - Overall Performance",{"$f":"Colour_Local('OVERALL RATING (avg)'!Q23,10)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Test - Score",{"$f":"ROUND(Greenhouse!O14,1)","v":10},null,"Number - 1 decimal place"]
["GG Cold Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!O9,Greenhouse!K9)","v":"Green"}]
["GG Cold Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!O7,Greenhouse!K7)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!O8,Greenhouse!K8)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Warm Test - Score",{"$f":"ROUND(Greenhouse!F32,1)","v":10},null,"Number - 1 decimal place"]
["GG Warm Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F27,Greenhouse!K27)","v":"Green"}]
["GG Warm Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F25,Greenhouse!K25)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Warm Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F26,Greenhouse!K26)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["Eco Test - CO2 Colour","-"]
["Sport Test - CO2 Colour","-"]
["GG Cold Ambient Test - Score",{"$f":"ROUND(Greenhouse!F23,1)","v":10},null,"Number - 1 decimal place"]
["GG Cold Ambient Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F18,Greenhouse!K18)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Ambient Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F16,Greenhouse!K16)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Ambient Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F17,Greenhouse!K17)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Highway Test - Score",{"$f":"ROUND(Greenhouse!F43,1)","v":10},null,"Number - 1 decimal place"]
["GG Highway Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F38,Greenhouse!K38)","v":"Green"}]
["GG Highway Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F36,Greenhouse!K36)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["GG Highway Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F37,Greenhouse!K37)","v":"Green"},null,"Brown - Green - Orange - Red - Yellow"]
["Greenhouse Gas Comment"]
["Verdict"]
["VIN of Tested Car",{"$f":"SPECS!B24","v":0}]
["Mass",{"$f":"SPECS!B31","v":0}]
["Engine Size",{"$f":"SPECS!B27","v":0}]
["Engine Power",{"$f":"SPECS!B28","v":0}]
["Torque",{"$f":"SPECS!B29","v":0}]
["Tyres",{"$f":"SPECS!B30","v":0}]
["Published CO2",{"$f":"SPECS!B12","v":0}]
["Rating Validity"]
["Consumption type (l - kg - kW)",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"l\",\"???\")","v":"l"}]
["Consumption per","100km"]
["Primary fuel source",{"$f":"IF(Petrol_PHEV,\"Petrol\",IF(Diesel_PHEV,\"Diesel\",\"???);\"\"???\"))","v":"Petrol"}]
["Secondary fuel source",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"Electric\",\"\")","v":"Electric"}]
["Published Driving Range",{"$f":"CONCATENATE(\"Electric (WLTP) \",ROUND(SPECS!B19,1))","v":"Electric (WLTP) 0"},"= declared driving range"]
["Declared Driving Range City",{"$f":"ROUND(SPECS!B20,1)","v":0},null,"Number - no decimal place"]
["Declared Consumption (1st Energy Source)",{"$f":"IF(SPECS!B13>0,ROUND(SPECS!B13,1),ROUND(SPECS!B15,1))","v":0},null,"Number - 1 decimal place"]
["Declared Consumption (2nd Energy Source)",{"$f":"ROUND(SPECS!B18,1)","v":0},null,"Number - 1 decimal place"]
["Primary fuel consumption units",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"l/100km\",\"???\")","v":"l/100km"}]
["Secondary fuel consumption units",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"kWh/100km\",\"???\")","v":"kWh/100km"}]
["Single/Dual Fuel source",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"Dual\",\"???\")","v":"Dual"}]
["Battery capacity",{"$f":"SPECS!B11","v":0}]
["Drivetrain",{"$f":"SPECS!B5","v":0}]
["Short_Variant"]
["Chassis",{"$f":"VLOOKUP(SPECS!B22,SPECS!H23:I29,2,FALSE)","v":{"$error":"#N/A"}},null,"Saloon - Hatchback - Station wagon - Coupe - Convertible - Multi-purpose vehicle - Truck station wagon"]
["Test stage",{"$f":"\"Stage \"&IF('OVERALL RATING (avg)'!F15=\"yes\",2,1)","v":"Stage 2"}]
["Internal Combustion Engine",{"$f":"IF(Petrol_PHEV,\"Petrol\",IF(Diesel_PHEV,\"Diesel\",\"???);\"\"???\"))","v":"Petrol"}]
["Electric Engine",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"PHEV\",\"???\")","v":"PHEV"}]
["EE_PHEV_Comment",{"$f":"CONCATENATE(\"Consumption in WLTC+ Battery Depleting Cycle: \",ROUNDDOWN(Efficiency!P67,1),\" l/100km fuel + \",ROUNDDOWN(Efficiency!S67,1), \" kWh/100km electricity\")","v":"Consumption in WLTC+ Battery Depleting Cycle: 0 l/100km fuel + 0 kWh/100km electricity"}]