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

{"sheet":"OVERALL RATING","index":0,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,5,59,6],[60,5,60,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[57,5,57,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7],[58,5,58,6],[47,2,47,7],[48,3,48,4],[48,5,48,7],[49,6,49,7],[43,4,43,5],[40,4,40,5],[43,2,43,3],[42,4,42,5],[42,2,42,3],[41,2,41,3],[6,6,6,7],[7,6,7,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[2,1,3,1],[2,2,3,2],[20,2,20,3],[20,4,20,5],[52,3,52,4],[6,2,6,3],[6,4,6,5],[19,4,19,5],[7,2,7,3],[19,2,19,3],[18,2,18,3],[7,4,7,5],[18,4,18,5],[39,2,39,3],[40,2,40,3],[41,4,41,5],[53,12,53,15],[54,12,54,15],[53,2,53,4],[57,2,57,4],[50,3,50,4],[52,5,52,7],[53,5,53,7],[50,5,50,7],[21,2,21,3],[21,4,21,5],[21,6,21,7],[22,2,22,7],[39,4,39,5],[39,6,39,7]]}
[]
[]
[null,{"$f":"CONCATENATE(D49,\" \",F49)","v":"0 0"}]
[]
[]
[]
[null,null,"Clean Air Index\n",null,"Energy Efficiency Index\n",null,"Greenhouse Gas Index\n"]
[null,null,32.6,null,40.5]
[null,null,{"$f":"'Clean Air'!B6","v":"WLTC"},{"$f":"'Clean Air'!F14","v":10},"Energy Consumption \n(WLTC-cold  14o C)",{"$f":"Efficiency!F10","v":10},{"$f":"Greenhouse!B6","v":"WLTC"},{"$f":"Greenhouse!F12","v":7}]
[null,null,{"$f":"'Clean Air'!B15","v":"WLTC-CAT"},{"$f":"'Clean Air'!$F$23","v":10},"Energy Consumption \n(WLTC-cold  -7o C)",{"$f":"Efficiency!F11","v":10},{"$f":"Greenhouse!B13","v":"WLTC-CAT"},{"$f":"Greenhouse!F19","v":7}]
[null,null,{"$f":"'Clean Air'!B24","v":"WLTC-warm"},{"$f":"'Clean Air'!F32","v":10},"Energy Consumption \n(WLTC-warm)",{"$f":"SUM(Efficiency!F12:F14)","v":10},{"$f":"Greenhouse!B20","v":"WLTC-warm"},{"$f":"Greenhouse!F26","v":7}]
[null,null,{"$f":"'Clean Air'!B54","v":"BAB130"},{"$f":"'Clean Air'!F62","v":10},"Energy Consumption \n(BAB130)",{"$f":"Efficiency!F15","v":10},{"$f":"Greenhouse!B44","v":"BAB130"},{"$f":"Greenhouse!F50","v":7}]
[null,null,{"$f":"'Clean Air'!B34","v":"PEMS+ cold engine 1"},{"$f":"'Clean Air'!F42","v":5},{"$f":"Efficiency!C13","v":"PEMS+ cold engine1"},{"$f":"IF(Efficiency!F13=0,\"-\",Efficiency!F13)","v":"-"},{"$f":"Greenhouse!B28","v":"PEMS+ cold engine 1"},{"$f":"IF(Greenhouse!D28=0,\"-\",Greenhouse!F34)","v":"-"}]
[null,null,{"$f":"'Clean Air'!B43","v":"PEMS+ cold engine 2"},{"$f":"'Clean Air'!F51","v":5},{"$f":"Efficiency!C14","v":"PEMS+ cold engine2"},{"$f":"IF(Efficiency!F14=0,\"-\",Efficiency!F14)","v":"-"},{"$f":"Greenhouse!$B$35","v":"PEMS+ cold engine 2"},{"$f":"IF(Greenhouse!D35=0,\"-\",Greenhouse!F41)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$63","v":"PEMS light test"},{"$f":"'Clean Air'!F71","v":5},null,null,{"$f":"'Clean Air'!$B$63","v":"PEMS light test"},{"$f":"IF(Greenhouse!D51=0,\"-\",Greenhouse!F57)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$72","v":"PEMS heavy test"},{"$f":"'Clean Air'!F80","v":8},null,null,{"$f":"'Clean Air'!$B$72","v":"PEMS heavy test"},{"$f":"IF(Greenhouse!D58=0,\"-\",Greenhouse!F64)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$81","v":"PEMS 8km (1)"},{"$f":"'Clean Air'!F88","v":5},"Driving Range 1)",{"$f":"IF(Efficiency!F47=0,\"-\",Efficiency!F47)","v":"-"},{"$f":"'Clean Air'!$B$81","v":"PEMS 8km (1)"},{"$f":"IF(Greenhouse!D65=0,\"-\",Greenhouse!F71)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$89","v":"PEMS Congestion"},{"$f":"'Clean Air'!F98","v":2},"Driving Resistance 1)",{"$f":"IF(Efficiency!F48=0,\"-\",Efficiency!F48)","v":"-"}]
[null,"Total Score",{"$f":"'Clean Air'!F109","v":70},null,{"$f":"Efficiency!E50","v":40},null,{"$f":"Greenhouse!F82","v":28}]
[null,"Max Points available",{"$f":"'Clean Air'!D109","v":70},null,{"$f":"Efficiency!D50","v":40},null,{"$f":"Greenhouse!D82","v":28}]
[null,"Index",{"$f":"ROUNDDOWN(10*C19/C20,1)","v":10},null,{"$f":"ROUNDDOWN(10*E19/E20,1)","v":10},null,{"$f":"ROUNDDOWN(10*G19/G20,1)","v":10}]
[null,"Weighting Factors",{"$f":"100/3","v":33.333333333333336},null,{"$f":"100/3","v":33.333333333333336},null,{"$f":"100/3","v":33.333333333333336}]
[null,"Weighted Overall Index",{"$f":"ROUNDDOWN((C21*C22+E22*E21+G22*G21)/100,1)","v":10},null,null,null,null,null,null,{"$f":"ROUND(MAX(IF(C23>=F26:F35,E26:E35)),1)","v":5}]
[]
[null,null,null,null,"Stars","Threshold"]
[null,null,null,null,5,9]
[null,null,null,null,4.5,8]
[null,null,null,null,4,7]
[null,null,null,null,3.5,6]
[null,null,null,null,3,5]
[null,null,null,null,2.5,4]
[null,null,null,null,2,3]
[null,null,null,null,1.5,2]
[null,null,null,null,1,1]
[null,null,null,null,0,0]
[]
[]
[]
[null,"RATING REQUIREMENTS 2021"]
[null,null,9,null,7.5,null,4,null,null,null,null,{"$f":"IF(AND($C$21:$H$21>=C40:H40),1,0)","v":1}]
[null,null,7,null,6,null,{"$f":"G40-1","v":3},null,null,null,null,{"$f":"IF(AND($C$21:$H$21>=C41:H41),1,0)","v":1}]
[null,null,5,null,4.5,null,{"$f":"G41-1","v":2},null,null,null,null,{"$f":"IF(AND($C$21:$H$21>=C42:H42),1,0)","v":1}]
[null,null,3,null,3,null,1,null,null,null,null,{"$f":"IF(AND($C$21:$H$21>=C43:H43),1,0)","v":1}]
[null,null,1,null,1.5,null,0,null,null,null,null,{"$f":"IF(AND($C$21:$H$21>=C44:H44),1,0)","v":1}]
[]
[null,"1): test not operational yet",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L40:L44)","v":5}]
[]
[null,null,"TEST DETAILS"]
[null,null,"Vehicle",{"$f":"SPECS!B1","v":0},null,{"$f":"SPECS!$B$2","v":0}]
[null,null," Specs (cc/kW)",{"$f":"IF(SPECS!B22=0,\"-\",SPECS!B22)","v":"-"}," cc",{"$f":"IF(SPECS!B23=0,\"-\",SPECS!B23)","v":"-"}," kW"]
[null,null,"Applies to VIN:",{"$f":"IF(SPECS!B18=0,\"-\",SPECS!B18)","v":"-"}]
[null,null,"Powerunit(s)",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\", \"-\"))","v":"petrol"},{"$f":"IF(Electric,\"electric\",\"-\")","v":"-"},{"$f":"IF(CNG_Dual,\"CNG Bi-Fuel\",\"-\")","v":"-"},{"$f":"IF(CNG_Mono,\"CNG monovalent\",\"-\")","v":"-"}]
[null,null,"Actual mass (kg)",{"$f":"SPECS!B26","v":0}]
[null,null,"Average Energy Use (Lab tests)",null,null,"Driving Range (avg Lab tests)"]
[null,null,"liquid fuel ",{"$f":"IF(Efficiency!M$19>0,Efficiency!M$19,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(Efficiency!M32>0,Efficiency!M34,\"n.a.\")","v":"n.a."},null,"km"]
[null,null," gaseous fuel ",{"$f":"IF(Efficiency!S$19>0,Efficiency!S$19,\"n.a.\")","v":"n.a."},"kg/100km",{"$f":"IF(Efficiency!S32>0,Efficiency!S34,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"electric energy",{"$f":"IF(Efficiency!P$19>0,Efficiency!P$19,\"n.a.\")","v":"n.a."},"kWh/100km",{"$f":"IF(Efficiency!P32>0,Efficiency!P34,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"Worst case Energy Use (Lab tests) ",null,null,"Driving range (worst case Lab tests)"]
[null,null,"liquid fuel ",{"$f":"IF(Efficiency!M$20>0,Efficiency!M$20,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(Efficiency!M33>0,Efficiency!M35,\"n.a.\")","v":"n.a."},null,"km"]
[null,null," gaseous fuel ",{"$f":"IF(Efficiency!S$20>0,Efficiency!S$20,\"n.a.\")","v":"n.a."},"kg/100km",{"$f":"IF(Efficiency!S33>0,Efficiency!S35,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"electric energy",{"$f":"IF(Efficiency!P$20>0,Efficiency!P$20,\"n.a.\")","v":"n.a."},"kWh/100km",{"$f":"IF(Efficiency!P33>0,Efficiency!P35,\"n.a.\")","v":"n.a."},null,"km"]

{"sheet":"Clean Air","index":1,"n_rows":113,"n_cols":31,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,10,2,10],[1,8,3,8],[13,1,13,2],[41,1,41,2],[1,6,2,7],[1,4,2,5],[1,1,2,2],[3,1,3,2],[31,1,31,2],[22,1,22,2],[50,1,50,2],[79,1,79,2],[97,1,97,2],[109,7,109,8],[70,1,70,2],[104,1,104,2],[87,1,87,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"1. Pollutants",null,null,"Test Results",null,"Limits",null,"Max score",null,"Fall Back Fuel"]
[]
[null,null,null,null,"Value","Points","lower","upper",null,null,"Value"]
[null,"1.1","Regulatory Tailpipe Emission Lab Tests"]
[null,"WLTC","max points",{"$f":"SUM(I7:I13)","v":10}]
[null,"(14 degr C)","NMHC","mg/km",{"$f":"RESULTS!$O4-RESULTS!$P4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I7,IF(E7=0,Sliding_Scale(E7,G7,H7,I7,0,Slide_Type),IF(K7/E7>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E7,G7,H7,I7,0,Slide_Type),Sliding_Scale(E7,G7,H7,I7,0,Slide_Type))))","v":2},{"$f":"'LIMITS Clean Air'!$D$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$5,IF(Diesel,'LIMITS Clean Air'!D5,0))","v":58},2,null,{"$f":"RESULTS!$O$26","v":0}]
[null,null,"NOx ","mg/km",{"$f":"RESULTS!$H$4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I8,IF(E8=0,Sliding_Scale(E8,G8,H8,I8,0,Slide_Type),IF(K8/E8>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E8,G8,H8,I8,0,Slide_Type),Sliding_Scale(E8,G8,H8,I8,0,Slide_Type))))","v":3},{"$f":"'LIMITS Clean Air'!$D$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$6,IF(Diesel,'LIMITS Clean Air'!D$6,0))","v":60},3,null,{"$f":"RESULTS!$H$26","v":0}]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I9,IF(E9=0,Sliding_Scale(E9,G9,H9,I9,0,Slide_Type),IF(K9/E9>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E9,G9,H9,I9,0,Slide_Type),Sliding_Scale(E9,G9,H9,I9,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$7,IF(Diesel,'LIMITS Clean Air'!D$7,0))","v":20},0,null,{"$f":"RESULTS!$M$26","v":0}]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I10,IF(E10=0,Sliding_Scale(E10,G10,H10,I10,0,Slide_Type),IF(K10/E10>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E10,G10,H10,I10,0,Slide_Type),Sliding_Scale(E10,G10,H10,I10,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$8,IF(Diesel,'LIMITS Clean Air'!D$8,0))","v":10},1,null,{"$f":"RESULTS!$N$26","v":0}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I11,IF(E11=0,Sliding_Scale(E11,G11,H11,I11,0,Slide_Type),IF(K11/E11>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E11,G11,H11,I11,0,Slide_Type),Sliding_Scale(E11,G11,H11,I11,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$D$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!D$9,IF(Diesel,'LIMITS Clean Air'!D$9,0))","v":500},1,null,{"$f":"RESULTS!$G$26","v":0}]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I12,IF(E12=0,Sliding_Scale(E12,G12,H12,I12,0,Slide_Type),IF(K12/E12>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E12,G12,H12,I12,0,Slide_Type),Sliding_Scale(E12,G12,H12,I12,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$D$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$10,IF(Diesel,'LIMITS Clean Air'!D$10,0))","v":4.5},0,null,{"$f":"RESULTS!$L$26","v":0}]
[null,{"$f":"IF(E13=0,0,LOG10(E13))","v":0},"PN",null,{"$f":"RESULTS!$K$4","v":0},{"$f":"IF(E13=0,I13,PN_Score(B13,I13))","v":3},{"$f":"'LIMITS Clean Air'!$D$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$11,IF(Diesel,'LIMITS Clean Air'!D$11,0))","v":600000000000},3,null,{"$f":"RESULTS!$K$26","v":0}]
[null,"total",null,null,null,{"$f":"IF(OR(E7:E9>'LIMITS Clean Air'!$E$5:$E$7,'Clean Air'!E11:E13>'LIMITS Clean Air'!$E$9:$E$11,K7:K9>'LIMITS Clean Air'!$E$5:$E$7,'Clean Air'!K11:K13>'LIMITS Clean Air'!$E$9:$E$11),0,MAX(SUM('Clean Air'!F7:F13),0))","v":10}]
[null,"WLTC-CAT","max points",{"$f":"SUM(I16:I22)","v":10}]
[null,"(-7 degr C)","NMHC","mg/km",{"$f":"RESULTS!$O$7-RESULTS!$P$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I16,IF(E16=0,Sliding_Scale(E16,G16,H16,I16,0,Slide_Type),IF(K16/E16>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E16,G16,H16,I16,0,Slide_Type),Sliding_Scale(E16,G16,H16,I16,0,Slide_Type))))","v":2},{"$f":"'LIMITS Clean Air'!$O$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$5,IF(Diesel,'LIMITS Clean Air'!N$5,0))","v":76.56},2]
[null,null,"NOx ","mg/km",{"$f":"RESULTS!$H$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I17,IF(E17=0,Sliding_Scale(E17,G17,H17,I17,0,Slide_Type),IF(K17/E17>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E17,G17,H17,I17,0,Slide_Type),Sliding_Scale(E17,G17,H17,I17,0,Slide_Type))))","v":3},{"$f":"'LIMITS Clean Air'!$O$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$6,IF(Diesel,'LIMITS Clean Air'!N$6,0))","v":79.2},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I18,IF(E18=0,Sliding_Scale(E18,G18,H18,I18,0,Slide_Type),IF(K18/E18>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E18,G18,H18,I18,0,Slide_Type),Sliding_Scale(E18,G18,H18,I18,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$O$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$7,IF(Diesel,'LIMITS Clean Air'!N$7,0))","v":26.400000000000002},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I19,IF(E19=0,Sliding_Scale(E19,G19,H19,I19,0,Slide_Type),IF(K19/E19>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E19,G19,H19,I19,0,Slide_Type),Sliding_Scale(E19,G19,H19,I19,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$O18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$8,IF(Diesel,'LIMITS Clean Air'!N$8,0))","v":13.200000000000001},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I20,IF(E20=0,Sliding_Scale(E20,G20,H20,I20,0,Slide_Type),IF(K20/E20>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E20,G20,H20,I20,0,Slide_Type),Sliding_Scale(E20,G20,H20,I20,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$O$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$9,IF(Diesel,'LIMITS Clean Air'!N$9,0))","v":660},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I21,IF(E21=0,Sliding_Scale(E21,G21,H21,I21,0,Slide_Type),IF(K21/E21>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E21,G21,H21,I21,0,Slide_Type),Sliding_Scale(E21,G21,H21,I21,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$O$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$10,IF(Diesel,'LIMITS Clean Air'!N$10,0))","v":5.94},0]
[null,{"$f":"IF(E22=0,0,LOG10(E22))","v":0},"PN",null,{"$f":"RESULTS!$K$7","v":0},{"$f":"IF(E22=0,I22,PN_Score(B22,I22))","v":3},{"$f":"'LIMITS Clean Air'!$O$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$11,IF(Diesel,'LIMITS Clean Air'!N$11,0))","v":792000000000},3]
[null,"total",null,null,null,{"$f":"IF(OR(E16:E18>'LIMITS Clean Air'!$O$5:$O$7,E20:E22>'LIMITS Clean Air'!$O$9:$O$11),0,MAX(SUM('Clean Air'!F16:F22),0))","v":10}]
[null,"WLTC-warm","max points",{"$f":"SUM(I25:I31)","v":10}]
[null,"(warm)","NMHC","mg/km",{"$f":"RESULTS!$O$8-RESULTS!$P$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I25,IF(E25=0,Sliding_Scale(E25,G25,H25,I25,0,Slide_Type),IF(K25/E25>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E25,G25,H25,I25,0,Slide_Type),Sliding_Scale(E25,G25,H25,I25,0,Slide_Type))))","v":2},{"$f":"'LIMITS Clean Air'!$D$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$5,IF(Diesel,'LIMITS Clean Air'!D$5,0))","v":58},2]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I26,IF(E26=0,Sliding_Scale(E26,G26,H26,I26,0,Slide_Type),IF(K26/E26>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E26,G26,H26,I26,0,Slide_Type),Sliding_Scale(E26,G26,H26,I26,0,Slide_Type))))","v":3},{"$f":"'LIMITS Clean Air'!$D$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$6,IF(Diesel,'LIMITS Clean Air'!D$6,0))","v":60},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I27,IF(E27=0,Sliding_Scale(E27,G27,H27,I27,0,Slide_Type),IF(K27/E27>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E27,G27,H27,I27,0,Slide_Type),Sliding_Scale(E27,G27,H27,I27,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$7,IF(Diesel,'LIMITS Clean Air'!D$7,0))","v":20},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I28,IF(E28=0,Sliding_Scale(E28,G28,H28,I28,0,Slide_Type),IF(K28/E28>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E28,G28,H28,I28,0,Slide_Type),Sliding_Scale(E28,G28,H28,I28,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$8,IF(Diesel,'LIMITS Clean Air'!D$8,0))","v":10},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!G8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I29,IF(E29=0,Sliding_Scale(E29,G29,H29,I29,0,Slide_Type),IF(K29/E29>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E29,G29,H29,I29,0,Slide_Type),Sliding_Scale(E29,G29,H29,I29,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$D$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$9,IF(Diesel,'LIMITS Clean Air'!D$9,0))","v":500},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I30,IF(E30=0,Sliding_Scale(E30,G30,H30,I30,0,Slide_Type),IF(K30/E30>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E30,G30,H30,I30,0,Slide_Type),Sliding_Scale(E30,G30,H30,I30,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$D$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$10,IF(Diesel,'LIMITS Clean Air'!D$10,0))","v":4.5},0]
[null,{"$f":"IF(E31=0,0,LOG10(E31))","v":0},"PN",null,{"$f":"RESULTS!$K$8","v":0},{"$f":"IF(E31=0,I31,PN_Score(B31,I31))","v":3},{"$f":"'LIMITS Clean Air'!$D$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$11,IF(Diesel,'LIMITS Clean Air'!D$11,0))","v":600000000000},3]
[null,"total",null,null,null,{"$f":"IF(OR(E25:E27>'LIMITS Clean Air'!$E$5:$E$7,'Clean Air'!E29:E31>'LIMITS Clean Air'!$E$9:$E$11),0,MAX(SUM('Clean Air'!F25:F31),0))","v":10}]
[null,"1.2","Regulatory performance PEMS+ "]
[null,"PEMS+ cold engine 1","max points",{"$f":"SUM(I36:I41)","v":5}]
[null,null,"HC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$J$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$5,IF(Diesel,'LIMITS Clean Air'!I$5,0))","v":76.56}]
[null,null,"NOx","mg/km",{"$f":"RESULTS!H11","v":0},{"$f":"IF(OR(Hydrogen,Electric),I36,IF(E36=0,Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),IF(K36/E36>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),Sliding_Scale(E36,G36,H36,I36,0,Slide_Type))))","v":2},{"$f":"'LIMITS Clean Air'!$J$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$6,IF(Diesel,'LIMITS Clean Air'!I$6,0))","v":79.2},2,null,{"$f":"RESULTS!H33","v":0}]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$7,IF(Diesel,'LIMITS Clean Air'!I$7,0))","v":26.400000000000002},0,null,{"$f":"RESULTS!$M$33","v":0}]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$8,IF(Diesel,'LIMITS Clean Air'!I$8,0))","v":13.200000000000001},0,null,{"$f":"RESULTS!$N$33","v":0}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$11","v":0},{"$f":"IF(OR(Hydrogen,Electric),I39,IF(E39=0,Sliding_Scale(E39,G39,H39,I39,0,Slide_Type),IF(K39/E39>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E39,G39,H39,I39,0,Slide_Type),Sliding_Scale(E39,G39,H39,I39,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$J$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$9,IF(Diesel,'LIMITS Clean Air'!I$9,0))","v":660},1,null,{"$f":"RESULTS!$G$33","v":0}]
[null,null,"PM","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$J$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$10,IF(Diesel,'LIMITS Clean Air'!I$10,0))","v":5.94},0]
[null,{"$f":"IF(E41=0,0,LOG10(E41))","v":0},"PN",null,{"$f":"RESULTS!$K$11","v":0},{"$f":"IF(E41=0,I41,PN_Score(B41,I41))","v":2},{"$f":"'LIMITS Clean Air'!$J$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$11,IF(Diesel,'LIMITS Clean Air'!I$11,0))","v":792000000000},2,null,{"$f":"RESULTS!$K$33","v":0}]
[null,"Regulatory performance PEMS+ ",null,null,null,{"$f":"IF(OR(E35:E41>'LIMITS Clean Air'!$J$5:$J$11),0,MAX(SUM('Clean Air'!F35:F41),0))","v":5}]
[null,"PEMS+ cold engine 2","max points",{"$f":"SUM(I45:I50)","v":5}]
[null,null,"HC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$J$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$5,IF(Diesel,'LIMITS Clean Air'!I$5,0))","v":76.56}]
[null,null,"NOx","mg/km",{"$f":"RESULTS!H12","v":0},{"$f":"IF(OR(Hydrogen,Electric),I45,IF(E45=0,Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),IF(K45/E45>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),Sliding_Scale(E45,G45,H45,I45,0,Slide_Type))))","v":2},{"$f":"'LIMITS Clean Air'!$J$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$6,IF(Diesel,'LIMITS Clean Air'!I$6,0))","v":79.2},2]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$7,IF(Diesel,'LIMITS Clean Air'!I$7,0))","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$8,IF(Diesel,'LIMITS Clean Air'!I$8,0))","v":13.200000000000001},0]
[null,null,"CO","mg/km",{"$f":"RESULTS!G12","v":0},{"$f":"IF(OR(Hydrogen,Electric),I48,IF(E48=0,Sliding_Scale(E48,G48,H48,I48,0,Slide_Type),IF(K48/E48>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E48,G48,H48,I48,0,Slide_Type),Sliding_Scale(E48,G48,H48,I48,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$J$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$9,IF(Diesel,'LIMITS Clean Air'!I$9,0))","v":660},1]
[null,null,"PM","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$J$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$10,IF(Diesel,'LIMITS Clean Air'!I$10,0))","v":5.94},0]
[null,{"$f":"IF(E50=0,0,LOG10(E50))","v":0},"PN",null,{"$f":"RESULTS!$K$12","v":0},{"$f":"IF(E50=0,I50,PN_Score(B50,I50))","v":2},{"$f":"'LIMITS Clean Air'!$J$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$11,IF(Diesel,'LIMITS Clean Air'!I$11,0))","v":792000000000},2]
[null,"Regulatory performance PEMS+ ",null,null,null,{"$f":"IF(OR(E44:E50>'LIMITS Clean Air'!$J$5:$J$11),0,MAX(SUM('Clean Air'!F44:F50),0))","v":5}]
[]
[null,"1.3","Robustness "]
[null,"BAB130","max points",{"$f":"SUM(I55:I61)","v":10}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$10-RESULTS!$P$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I55,IF(E55=0,Sliding_Scale(E55,G55,H55,I55,0,Slide_Type),IF(K55/E55>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E55,G55,H55,I55,0,Slide_Type),Sliding_Scale(E55,G55,H55,I55,0,Slide_Type))))","v":2},{"$f":"'LIMITS Clean Air'!$D$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$5,IF(Diesel,'LIMITS Clean Air'!D$5,0))","v":58},2,null,{"$f":"RESULTS!$O$32","v":0}]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I56,IF(E56=0,Sliding_Scale(E56,G56,H56,I56,0,Slide_Type),IF(K56/E56>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E56,G56,H56,I56,0,Slide_Type),Sliding_Scale(E56,G56,H56,I56,0,Slide_Type))))","v":3},{"$f":"'LIMITS Clean Air'!$D$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$6,IF(Diesel,'LIMITS Clean Air'!D$6,0))","v":60},3,null,{"$f":"RESULTS!$H$32","v":0}]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I57,IF(E57=0,Sliding_Scale(E57,G57,H57,I57,0,Slide_Type),IF(K57/E57>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E57,G57,H57,I57,0,Slide_Type),Sliding_Scale(E57,G57,H57,I57,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$7,IF(Diesel,'LIMITS Clean Air'!D$7,0))","v":20},0,null,{"$f":"RESULTS!$M$32","v":0}]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I58,IF(E58=0,Sliding_Scale(E58,G58,H58,I58,0,Slide_Type),IF(K58/E58>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E58,G58,H58,I58,0,Slide_Type),Sliding_Scale(E58,G58,H58,I58,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$8,IF(Diesel,'LIMITS Clean Air'!D$8,0))","v":10},1,null,{"$f":"RESULTS!$N$32","v":0}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I59,IF(E59=0,Sliding_Scale(E59,G59,H59,I59,0,Slide_Type),IF(K59/E59>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E59,G59,H59,I59,0,Slide_Type),Sliding_Scale(E59,G59,H59,I59,0,Slide_Type))))","v":1},{"$f":"'LIMITS Clean Air'!$D$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$9,IF(Diesel,'LIMITS Clean Air'!D$9,0))","v":500},1,null,{"$f":"RESULTS!$G$32","v":0}]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I60,IF(E60=0,Sliding_Scale(E60,G60,H60,I60,0,Slide_Type),IF(K60/E60>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E60,G60,H60,I60,0,Slide_Type),Sliding_Scale(E60,G60,H60,I60,0,Slide_Type))))","v":0},{"$f":"'LIMITS Clean Air'!$D$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$9,IF(Diesel,'LIMITS Clean Air'!D$9,0))","v":500},0,null,{"$f":"RESULTS!$L$32","v":0}]
[null,{"$f":"IF(E61=0,0,LOG10(E61))","v":0},"PN",null,{"$f":"RESULTS!$K$10","v":0},{"$f":"IF(E61=0,I61,PN_Score(B61,I61))","v":3},{"$f":"'LIMITS Clean Air'!$D$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!C$11,IF(Diesel,'LIMITS Clean Air'!D$11,0))","v":600000000000},3,null,{"$f":"RESULTS!$K$32","v":0}]
[null,null,null,null,null,{"$f":"IF(OR(E55:E57>'LIMITS Clean Air'!$E$5:$E$7,'Clean Air'!E59:E61>'LIMITS Clean Air'!$E$9:$E$11,K55:K57>'LIMITS Clean Air'!$E$5:$E$7,'Clean Air'!K59:K61>'LIMITS Clean Air'!$E$9:$E$11),0,MAX(SUM('Clean Air'!F55:F61),0))","v":10}]
[null,"PEMS light test","max points",{"$f":"SUM(I64:I70)","v":5}]
[null,null,"NMHC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$J$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$5,IF(Diesel,'LIMITS Clean Air'!I$5,0))","v":76.56},0]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$15","v":0},{"$f":"IF(E65<=E36,I65,IF(E65<'Clean Air'!H36,(0.5*I65),0))","v":2.25},{"$f":"'LIMITS Clean Air'!$J$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$6,IF(Diesel,'LIMITS Clean Air'!I$6,0))","v":79.2},2.25]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$7,IF(Diesel,'LIMITS Clean Air'!I$7,0))","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$8,IF(Diesel,'LIMITS Clean Air'!I$8,0))","v":13.200000000000001},0]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$15","v":0},{"$f":"IF(E68<=E39,I68,IF(E68<'Clean Air'!H39,(0.5*I68),0))","v":0.5},{"$f":"'LIMITS Clean Air'!$J$19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$9,IF(Diesel,'LIMITS Clean Air'!I$9,0))","v":660},0.5]
[null,null,"PM","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$J$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$10,IF(Diesel,'LIMITS Clean Air'!I$10,0))","v":5.94},0]
[null,{"$f":"IF(E70=0,0,LOG10(E70))","v":0},"PN",null,{"$f":"RESULTS!$K$15","v":0},{"$f":"IF(E70=0,I70,PN_Score(B70,I70))","v":2.25},{"$f":"'LIMITS Clean Air'!$J$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$11,IF(Diesel,'LIMITS Clean Air'!I$11,0))","v":792000000000},2.25]
[null,null,null,null,null,{"$f":"IF(OR(E64:E70>'LIMITS Clean Air'!$J$5:$J$11),0,MAX(SUM('Clean Air'!F64:F70),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 test","max points",{"$f":"SUM(I73:I79)","v":8},null,null,null,null,null,null,null,null,0,{"$f":"IF(M72=0,0,LOG(M72,$Y$1))","v":0},3,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,{"$f":"'LIMITS Clean Air'!$J$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$5,IF(Diesel,'LIMITS Clean Air'!N$5,0))","v":76.56},0,null,null,null,10,{"$f":"LOG10(M73)","v":1},{"$f":"PN_Score(N73,3)","v":2.875},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(E74,H36,'LIMITS Clean Air'!O6,I74,0,Slide_Type)","v":3.6},"NOx","mg/km",{"$f":"RESULTS!H16","v":0},{"$f":"IF(F36=0,0,IF(E74<=H36,I74,0))","v":3.6},{"$f":"'LIMITS Clean Air'!D16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$6,IF(Diesel,'LIMITS Clean Air'!N$6,0))","v":79.2},3.6,null,null,null,100,{"$f":"LOG10(M74)","v":2},{"$f":"PN_Score(N74,3)","v":2.75},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,{"$f":"'LIMITS Clean Air'!$D$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$7,IF(Diesel,'LIMITS Clean Air'!N$7,0))","v":26.400000000000002},0,null,null,null,1000,3,2.625,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,{"$f":"'LIMITS Clean Air'!$D$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$8,IF(Diesel,'LIMITS Clean Air'!N$8,0))","v":13.200000000000001},0,null,null,null,10000,4,2.5,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(E77,H39,'LIMITS Clean Air'!O9,I77,0,Slide_Type)","v":0.8},"CO","mg/km",{"$f":"RESULTS!$G$16","v":0},{"$f":"IF(F39=0,0,IF(E77<=H39,I77,0))","v":0.8},{"$f":"'LIMITS Clean Air'!D19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$9,IF(Diesel,'LIMITS Clean Air'!N$9,0))","v":660},0.8,null,null,null,100000,5,2.375,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,{"$f":"'LIMITS Clean Air'!$J$20","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$10,IF(Diesel,'LIMITS Clean Air'!N$10,0))","v":5.94},0,null,null,null,1000000,6,2.25,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(E79=0,0,LOG10(E79))","v":0},"PN",null,{"$f":"RESULTS!$K$16","v":0},{"$f":"IF(E79=0,I79,PN_Score(B79,I79))","v":3.6},{"$f":"'LIMITS Clean Air'!$J$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!M$11,IF(Diesel,'LIMITS Clean Air'!N$11,0))","v":792000000000},3.6,null,null,null,10000000,7,2.125,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,null,null,null,null,{"$f":"IF(OR(E73:E79>'LIMITS Clean Air'!$O$5:$O$11),0,MAX(SUM('Clean Air'!F73:F79),0))","v":8},null,null,null,null,null,null,100000000,8,2,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 8km (1)","max points",{"$f":"SUM(I82:I87)","v":5},null,null,null,null,null,null,null,null,1000000000,9,1.470619375330863]
[null,"(cold start / short trip)","NOx","mg/km",{"$f":"RESULTS!H13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I82,IF(F36=0,0,IF(OR($E$82>='LIMITS Clean Air'!$O$6,$E$85>='LIMITS Clean Air'!O6),0,I82-(E82/'LIMITS Clean Air'!$O$6)*I82)))","v":1.125},{"$f":"'LIMITS Clean Air'!D16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$6,IF(Diesel,'LIMITS Clean Air'!I$6,0))","v":79.2},{"$f":"2.25/2","v":1.125},null,null,null,10000000000,10,0.94123875066172569]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I83,IF(F39=0,0,IF(OR($E$83>'LIMITS Clean Air'!$O$9,$E$86>='LIMITS Clean Air'!$O$9),0,I83-(E83/'LIMITS Clean Air'!$O$9)*I83)))","v":0.25},{"$f":"'LIMITS Clean Air'!D19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$9,IF(Diesel,'LIMITS Clean Air'!I$9,0))","v":660},{"$f":"0.5/2","v":0.25},null,null,null,100000000000,11,0.41185812599258864]
[null,{"$f":"IF(E84=0,0,LOG10(E84))","v":0},"PN",null,{"$f":"RESULTS!$K$13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I84,IF(OR($E$84>=$H$84,$E$87>=$H$87),0,I84-(E84/H84)*I84))","v":1.125},{"$f":"'LIMITS Clean Air'!$J$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$11,IF(Diesel,'LIMITS Clean Air'!I$11,0))","v":792000000000},{"$f":"2.25/2","v":1.125},null,null,null,600000000000,11.778151250383644,-8.0069022574846827E-5]
[null,"PEMS 8km (2)","NOx","mg/km",{"$f":"RESULTS!H14","v":0},{"$f":"IF(OR(Hydrogen,Electric),I85,IF(F36=0,0,IF(OR($E$82>='LIMITS Clean Air'!$O$6,$E$85>='LIMITS Clean Air'!$O$6),0,I85-(E85/'LIMITS Clean Air'!$O$6)*I85)))","v":1.125},{"$f":"'LIMITS Clean Air'!D16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$6,IF(Diesel,'LIMITS Clean Air'!I$6,0))","v":79.2},{"$f":"2.25/2","v":1.125}]
[null,"(cold start / short trip)","CO","mg/km",{"$f":"RESULTS!$G$14","v":0},{"$f":"IF(OR(Hydrogen,Electric),I86,IF(F39=0,0,IF(OR($E$83>='LIMITS Clean Air'!$O$9,$E$86>='LIMITS Clean Air'!$O$9),0,I86-(E86/'LIMITS Clean Air'!$O$9)*I86)))","v":0.25},{"$f":"'LIMITS Clean Air'!D19","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$9,IF(Diesel,'LIMITS Clean Air'!I$9,0))","v":660},{"$f":"0.5/2","v":0.25}]
[null,{"$f":"IF(E87=0,0,LOG10(E87))","v":0},"PN",null,{"$f":"RESULTS!$K$14","v":0},{"$f":"IF(OR(Hydrogen,Electric),I87,IF(OR($E$84>=$H$84,$E$87>=$H$87),0,I87-(E87/H87)*I87))","v":1.125},{"$f":"'LIMITS Clean Air'!$J$21","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H$11,IF(Diesel,'LIMITS Clean Air'!I$11,0))","v":792000000000},{"$f":"2.25/2","v":1.125}]
[null,"average tests 1 and 2:",null,null,null,{"$f":"SUM(F82:F87)","v":5}]
[null,"PEMS Congestion","max points",{"$f":"SUM(I90:I97)","v":2},null,null,"max","avg"]
[null,null,"NMHC","mg/s",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"=ALS(E82<=$E$36;($F$36/I45)*I82;ALS(EN((E82<H82);(E82/G82)<1);(I82-(E82/H82)*I82);0))"]
[null,null,"NOx  AVG","mg/s",{"$f":"RESULTS!$H$19","v":0},{"$f":"IF(E91<H91,I91,F95)","v":1},null,{"$f":"'LIMITS Clean Air'!S6","v":0.5},1]
[null,null,"NOx MAX","mg/s",{"$f":"RESULTS!$H$18","v":0},{"$f":"IF(AND(E91<H91,E92<H92),I92,0)","v":1},null,{"$f":"'LIMITS Clean Air'!R6","v":1},1]
[null,null,"NO2","mg/s",null,null,null,null,0]
[null,null,"NH3","mg/s",null,null,null,null,0]
[null,null,"CO","mg/s",null,null,null,null,0]
[null,null,"PM","mg/s",null,null,null,null,0]
[null,{"$f":"IF(E97=0,0,LOG10(E97))","v":0},"PN",null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F91:F97)","v":2}]
[]
[]
[]
[]
[]
[]
[null,"SUMMARY"]
[null,{"$f":"B5","v":"1.1"},{"$f":"C5","v":"Regulatory Tailpipe Emission Lab Tests"},{"$f":"SUM(D6,D15,D24,)","v":30},null,{"$f":"ROUNDDOWN(SUM(F14,F23,F32),1)","v":30}]
[null,{"$f":"B33","v":"1.2"},{"$f":"C33","v":"Regulatory performance PEMS+ "},{"$f":"SUM(D34,D43)","v":10},null,{"$f":"ROUNDDOWN(SUM(F42,F51),1)","v":10}]
[null,{"$f":"B53","v":"1.3"},{"$f":"C53","v":"Robustness "},{"$f":"SUM(D54,D63,D72,D81,D89,)","v":30},null,{"$f":"ROUNDDOWN(SUM(F62,F71,F80,F88,F98),1)","v":30}]
[null,"TOTAL",null,{"$f":"SUM(D106:D108)","v":70},null,{"$f":"SUM(F106:F108)","v":70}]
[null,null,null,null,null,null,null,"test distribution"]
[null,null,null,null,null,null,null,"LAB",{"$f":"SUM(D6,D15,D24,D54)","v":40}]
[null,null,null,null,null,null,null,"PEMS",{"$f":"SUM(D89,D81,D72,D63,D43,D34)","v":30}]
[null,"TOTAL SCORE POLLUTANTS",null,"(0-10pts)",null,{"$f":"ROUNDDOWN(10*F109/D109,1)","v":10}]

{"sheet":"Efficiency","index":2,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[44,2,44,4],[52,5,52,6],[31,1,31,2],[49,1,49,2],[43,1,43,2],[49,5,49,6],[3,1,3,2],[39,1,39,2],[1,8,3,8],[1,1,2,2],[1,4,2,5],[1,6,2,7],[18,1,18,2],[14,1,17,1],[12,1,13,1]]}
[]
[null,"2. Efficiency",null,null,"Test Results",null,"Limits",null,"Max score"]
[]
[null,null,null,null,"Value","Points","lower","upper"]
[]
[null,"2.1","Test cycle measurements"]
[]
[null,"2.1.2","Energy Consumption (total)",null,null,null,null,null,null,null,"2.1.2.1",null,null,"2.1.2.2",null,null,"2.1.2.3"]
[null,null,"max points",{"$f":"I19","v":40},null,null,null,null,null,null,"Fuel Consumption (ICE liq. fuel)",null,null,"Energy Consumption (Electr. mode)",null,null,"Fuel Consumption (ICE, CNG, Hydrogen fuel cell)"]
[null,"Lab tests","WLTC cold (14 degr C)","kWh/100km",{"$f":"IF(Petrol,Efficiency!M10*'LIMITS Efficiency'!$C$18,IF(Diesel,Efficiency!M10*'LIMITS Efficiency'!$C$19,IF(OR(CNG_Mono,CNG_Dual),S10*'LIMITS Efficiency'!$C$20,IF(Hydrogen,S10*'LIMITS Efficiency'!$C$22,0)))+P10)","v":0},{"$f":"MAX(0,Sliding_Scale(E10,G10,H10,I10,0,Slide_Type))","v":10},{"$f":"'LIMITS Efficiency'!E6","v":30},{"$f":"'LIMITS Efficiency'!F6","v":90},10,null,"WLTC cold (14 degr C)","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$4,RESULTS!$Q$26),0)","v":0},"WLTC cold (14 degr C)","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R4,RESULTS!R26),0)","v":0},"WLTC cold (14 degr C)","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U4,RESULTS!U26),0)","v":0}]
[null,null,"WLTC cold (-7 degr C)","kWh/100km",{"$f":"IF(Petrol,Efficiency!M11*'LIMITS Efficiency'!$C$18,IF(Diesel,Efficiency!M11*'LIMITS Efficiency'!$C$19,IF(OR(CNG_Mono,CNG_Dual),S11*'LIMITS Efficiency'!$C$20,IF(Hydrogen,S11*'LIMITS Efficiency'!$C$22,0)))+P11)","v":0},{"$f":"MAX(0,Sliding_Scale(E11,G11,H11,I11,0,Slide_Type))","v":10},{"$f":"'LIMITS Efficiency'!E7","v":30},{"$f":"'LIMITS Efficiency'!F7","v":90},10,null,"WLTC cold (-7 degr C)","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$7,RESULTS!$Q$29),0)","v":0},"WLTC cold (-7 degr C)","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R7,RESULTS!R29),0)","v":0},"WLTC cold (-7 degr C)","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U7,RESULTS!U29),0)","v":0}]
[null,null,"WLTC-warm","kWh/100km",{"$f":"IF(Petrol,Efficiency!M12*'LIMITS Efficiency'!$C$18,IF(Diesel,Efficiency!M12*'LIMITS Efficiency'!$C$19,IF(OR(CNG_Mono,CNG_Dual),S12*'LIMITS Efficiency'!$C$20,IF(Hydrogen,S12*'LIMITS Efficiency'!$C$22,0))))+P12","v":0},{"$f":"MAX(0,Sliding_Scale(E12,G12,H12,I12,0,Slide_Type))","v":10},{"$f":"'LIMITS Efficiency'!E8","v":30},{"$f":"'LIMITS Efficiency'!F8","v":90},10,null,"WLTC-warm","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$8,RESULTS!$Q$30),0)","v":0},"WLTC-warm","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R8,RESULTS!R30),0)","v":0},"WLTC-warm","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U8,RESULTS!U30),0)","v":0}]
[null,"PEMS","PEMS+ cold engine1","kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!E11","v":30},{"$f":"'LIMITS Efficiency'!F11","v":90},0,null,"PEMS+ cold engine1","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$11,RESULTS!$Q$33),0)","v":0},"PEMS+ cold engine1","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R11,RESULTS!R33),0)","v":0},"PEMS+ cold engine1","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U11,RESULTS!U33),0)","v":0}]
[null,null,"PEMS+ cold engine2","kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!E10","v":30},{"$f":"'LIMITS Efficiency'!F10","v":90},0,null,"PEMS+ cold engine2","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$12,RESULTS!$Q$34),0)","v":0},"PEMS+ cold engine2","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R12,RESULTS!R34),0)","v":0},"PEMS+ cold engine2","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U12,RESULTS!U34),0)","v":0}]
[null,"robustness","Bab130","kWh/100km",{"$f":"IF(Petrol,Efficiency!M15*'LIMITS Efficiency'!$C$18,IF(Diesel,Efficiency!M15*'LIMITS Efficiency'!$C$19,IF(OR(CNG_Mono,CNG_Dual),S15*'LIMITS Efficiency'!$C$20,IF(Hydrogen,S15*'LIMITS Efficiency'!$C$22,0))))+P15","v":0},{"$f":"MAX(0,Sliding_Scale(E15,G15,H15,I15,0,2))","v":10},{"$f":"'LIMITS Efficiency'!E12","v":30},{"$f":"'LIMITS Efficiency'!F12","v":90},10,null,"Bab130","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$10,RESULTS!$Q$32),0)","v":0},"Bab130","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R10,RESULTS!R32),0)","v":0},"Bab130","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U10,RESULTS!U32),0)","v":0}]
[null,null,"PEMS light test","kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!$E$13","v":30},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0,null,"PEMS light test","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$15,RESULTS!$Q$37),0)","v":0},"PEMS light test","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R15,RESULTS!R37),0)","v":0},"PEMS light test","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U15,RESULTS!U37),0)","v":0}]
[null,null,"PEMS heavy test","kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!$E$13","v":30},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0,null,"PEMS heavy test","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$16,RESULTS!$Q$38),0)","v":0},"PEMS heavy test","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R16,RESULTS!R38),0)","v":0},"PEMS heavy test","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U16,RESULTS!U38),0)","v":0}]
[null,null,"PEMS 8 minutes","kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!$E$13","v":30},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0,null,"PEMS 8 km","l/100km",{"$f":"IF(OR(Petrol,Diesel),MAX(RESULTS!$Q$13,RESULTS!$Q$35),0)","v":0},"PEMS 8 km","kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R13,RESULTS!R35),0)","v":0},"PEMS 8 km","kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U13,RESULTS!U35),0)","v":0}]
[null,"total",null,null,null,{"$f":"(SUM(F10:F16))","v":40},null,null,{"$f":"SUM(I10:I16)","v":40},null,"Lab test Average","l/100km",{"$f":"AVERAGE(M$10,M$12,M$15)","v":0},"Lab test Average","kWh/100km",{"$f":"AVERAGE(P$10,P$12,P$15)","v":0},"Lab test Average","kg/100km",{"$f":"AVERAGE(S$10,S$12,S$15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lab test Worst Case","l/100km",{"$f":"MAX(M$10:M$12,M$15)","v":0},"Lab test Worst Case","kWh/100km",{"$f":"MAX(P$10:P$12,P$15)","v":0},"Lab test Worst Case","kg/100km",{"$f":"MAX(S$10:S$12,S$15)","v":0}]
[null,"2.2","Driving Range (lab test average)",null,null,null,null,null,null,null,"2.2.1",null,null,"2.2.2",null,null,"2.2.3"]
[null,null,"max points",{"$f":"I23","v":0},null,null,null,null,null,null,"Driving Range (ICE liq. fuel)",null,null,"Driving Range (Electr. mode)",null,null,"Driving Range (ICE, CNG, Hydrogen fuel cell)"]
[null,null,"PHEV","km",{"$f":"IF(AND(P34>0,M34>0),P34+M34,0)","v":0},{"$f":"IF(E23>=H23,I23,IF(E23<=G23,0,(E23-G23)/(H23-G23)*I23))","v":0},50,{"$f":"'LIMITS Efficiency'!D32","v":100},0,null,"WLTC+ cold (14 degr C)","km",{"$f":"IF(OR(Petrol,Diesel),IF(M10>0,100*SPECS!$B$10/M10,0),0)","v":0},"WLTC+ cold (14 degr C)","km",{"$f":"IF(Electric,IF(P10>0,100*SPECS!$B$12/P10,0),0)","v":0},"WLTC cold (14 degr C)","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S10>0,100*SPECS!$B$11/S10,0),0)","v":0}]
[null,null,"BEV","km",{"$f":"IF(AND(M34=0,P34>0),P34,0)","v":0},{"$f":"IF(E24>=H24,I24,IF(E24<=G24,0,(E24-G24)/(H24-G24)*I24))","v":0},275,550,{"$f":"$I$23","v":0},null,"WLTC+ cold (-7 degr C)","km",{"$f":"IF(OR(Petrol,Diesel),IF(M11>0,100*SPECS!$B$10/M11,0),0)","v":0},"WLTC+ cold (-7 degr C)","km",{"$f":"IF(Electric,IF(P11>0,100*SPECS!$B$12/P11,0),0)","v":0},"WLTC cold (-7 degr C)","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S11>0,100*SPECS!$B$11/S11,0),0)","v":0}]
[null,null,"CNG","km",{"$f":"IF(P34>0,0,S34)","v":0},{"$f":"IF(E25>=H25,$I$23,IF(E25<=G25,0,(E25-G25)/(H25-G25)*I25))","v":0},500,1000,{"$f":"$I$23","v":0},null,"WLTC+ warm engine","km",{"$f":"IF(OR(Petrol,Diesel),IF(M12>0,100*SPECS!$B$10/M12,0),0)","v":0},"WLTC+ warm engine","km",{"$f":"IF(Electric,IF(P12>0,100*SPECS!$B$12/P12,0),0)","v":0},"WLTC-warm","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S12>0,100*SPECS!$B$11/S12,0),0)","v":0}]
[null,null,"ICE","km",{"$f":"IF(P34>0,0,M34)","v":0},0,500,1000,0,null,"BAB130 Motorway","km",{"$f":"IF(OR(Petrol,Diesel),IF(M13>0,100*SPECS!$B$10/M13,0),0)","v":0},"BAB130 Motorway","km",{"$f":"IF(Electric,IF(P15>0,100*SPECS!$B$12/P15,0),0)","v":0},"BAB130 Motorway","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S15>0,100*SPECS!$B$11/S15,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PEMS+ cold engine1","km",{"$f":"IF(OR(Petrol,Diesel),IF(M14>0,100*SPECS!$B$10/M14,0),0)","v":0},"PEMS+ cold engine1","km",{"$f":"IF(Electric,IF(P13>0,100*SPECS!$B$12/P13,0),0)","v":0},"PEMS+ cold engine1","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S13>0,100*SPECS!$B$11/S13,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PEMS+ cold engine2","km",{"$f":"IF(OR(Petrol,Diesel),IF(M15>0,100*SPECS!$B$10/M15,0),0)","v":0},"PEMS+ cold engine2","km",{"$f":"IF(Electric,IF(P14>0,100*SPECS!$B$12/P14,0),0)","v":0},"PEMS+ cold engine2","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S14>0,100*SPECS!$B$11/S14,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PEMS light test","km",{"$f":"IF(OR(Petrol,Diesel),IF(M16>0,100*SPECS!$B$10/M16,0),0)","v":0},"PEMS light test","km",{"$f":"IF(Electric,IF(P16>0,100*SPECS!$B$12/P16,0),0)","v":0},"PEMS light test","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S16>0,100*SPECS!$B$11/S16,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PEMS heavy test","km",{"$f":"IF(OR(Petrol,Diesel),IF(M17>0,100*SPECS!$B$10/M17,0),0)","v":0},"PEMS heavy test","km",{"$f":"IF(Electric,IF(P17>0,100*SPECS!$B$12/P17,0),0)","v":0},"PEMS heavy test","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S17>0,100*SPECS!$B$11/S17,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PEMS 8 km","km",{"$f":"IF(OR(Petrol,Diesel),IF(M18>0,100*SPECS!$B$10/M18,0),0)","v":0},"PEMS 8 km","km",{"$f":"IF(Electric,IF(P18>0,100*SPECS!$B$12/P18,0),0)","v":0},"PEMS 8 km","km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S18>0,100*SPECS!$B$11/S18,0),0)","v":0}]
[null,"total",null,null,null,{"$f":"SUM(F23:F24)","v":0},null,null,null,null,"PEMS Average","km",{"$f":"AVERAGE(M27:M31)","v":0},"PEMS Average","km",{"$f":"AVERAGE(P27:P31)","v":0},"PEMS Average","km",{"$f":"AVERAGE(S27:S31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PEMS Worst Case","km",{"$f":"MIN(M27:M31)","v":0},"PEMS Worst Case","km",{"$f":"MIN(P27:P31)","v":0},"PEMS Worst Case","km",{"$f":"MIN(S27:S31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Lab test Average","km",{"$f":"AVERAGE(M23,M25,M26)","v":0},"Lab test Average","km",{"$f":"AVERAGE(P23,P25,P26)","v":0},"Lab test Average","km",{"$f":"AVERAGE(S23,S25,S26)","v":0}]
[null,"2.3","Driving Resistance",null,null,null,null,null,null,null,"Lab test Worst Case","km",{"$f":"MIN(M23:M26)","v":0},"Lab test Worst Case","km",{"$f":"MIN(P23:P26)","v":0},"Lab test Worst Case","km",{"$f":"MIN(S23:S26)","v":0}]
[null,null,"max points",{"$f":"I40","v":0},null,null,null,null,0]
[null,null,"tbd",null,null,null,null,null,0]
[null,null,"tbd",null,null,null,null,null,0]
[null,null,"tbe",null,null,null,null,null,0]
[null,"total",null,null,null,{"$f":"SUM(F39:F39)","v":0},null,null,{"$f":"SUM(I36:I39)","v":0}]
[]
[]
[]
[null,"SUMMARY",null,"max points","scored points"]
[null,"2.1","Test cycle measuments"]
[null,{"$f":"B8","v":"2.1.2"},{"$f":"C8","v":"Energy Consumption (total)"},{"$f":"D9","v":40},{"$f":"F19","v":40}]
[null,{"$f":"B21","v":"2.2"},{"$f":"C21","v":"Driving Range (lab test average)"},{"$f":"D22","v":0},{"$f":"F32","v":0}]
[null,{"$f":"B35","v":"2.3"},{"$f":"C35","v":"Driving Resistance"},{"$f":"D36","v":0},{"$f":"F40","v":0}]
[]
[null,"TOTAL",null,{"$f":"SUM(D46:D48)","v":40},{"$f":"ROUNDDOWN(SUM(E46:E48),1)","v":40}]
[]
[]
[null,"TOTAL SCORE EFFICIENCY",null,null,{"$f":"ROUNDDOWN(10*E50/D50,1)","v":10},"(0-10pts)"]

{"sheet":"Greenhouse","index":3,"n_rows":86,"n_cols":26,"rows_kept":86,"cut":false,"hidden":false,"merged":[[4,17,4,25],[77,1,77,2],[81,1,81,2],[81,6,81,7],[16,17,16,25],[6,17,6,18],[6,23,6,24],[70,1,70,2],[6,20,6,21],[85,1,85,2],[85,3,85,4],[85,6,85,7],[1,10,2,10],[3,1,3,2],[56,1,56,2],[1,1,2,2],[1,4,2,5],[1,6,2,7],[1,8,3,8],[11,1,11,2],[25,1,25,2],[33,1,33,2],[18,1,18,2],[40,1,40,2],[63,1,63,2]]}
[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,"Limits",null,"Max score",null,"Fall Back Fuel"]
[]
[null,null,null,null,"Value","Points","lower","upper",null,null,"Value"]
[null,"3.1","Regulatory Tailpipe Emission Lab Tests",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 equivalent upstream"]
[null,"WLTC","max points",{"$f":"SUM(I7:I9)","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,"ICE Liquid Fuel",null,"Factor","Electricity",null,"Factor","ICE Gaseous Fuel",null,"Factor"]
[null,"(14 degr C)","N2O","mg/km",{"$f":"RESULTS!M4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I7,IF(E7=0,Sliding_Scale(E7,G7,H7,I7,0,Slide_Type),IF(K7/E7>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E7,G7,H7,I7,0,Slide_Type),Sliding_Scale(E7,G7,H7,I7,0,Slide_Type))))","v":1},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$6,IF(Diesel,'LIMITS Greenhouse'!$E$6,0))","v":6.2},1,null,{"$f":"RESULTS!$M$26","v":0},null,null,null,null,null,null,{"$f":"IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",\"-\"))","v":"Petrol"},null,{"$f":"IF(Petrol,'LIMITS Greenhouse'!$D$28,IF(Diesel,'LIMITS Greenhouse'!$D$29,0))","v":0.188},{"$f":"IF(Electric,\"Electric\",\"-\")","v":"-"},null,{"$f":"'LIMITS Greenhouse'!D30","v":217.5},{"$f":"IF(CNG_Mono,\"CNG Monovalent\",IF(CNG_Dual,\"CNG Dual Fuel\",\"-\"))","v":"-"},null,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$31,IF(Diesel,'LIMITS Greenhouse'!$E$32,0))","v":0.23100000000000001}]
[null,null,"CH4","mg/km",{"$f":"RESULTS!P4","v":0},{"$f":"IF(OR(Hydrogen,Electric),I8,IF(E8=0,Sliding_Scale(E8,G8,H8,I8,0,Slide_Type),IF(K8/E8>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E8,G8,H8,I8,0,Slide_Type),Sliding_Scale(E8,G8,H8,I8,0,Slide_Type))))","v":2},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$7,IF(Diesel,'LIMITS Greenhouse'!$E$7,0))","v":32},2,null,{"$f":"RESULTS!$P$26","v":0},null,null,null,null,null,null,"WLTC cold (14 degr C)","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E4,RESULTS!$E26,0),0)*T$7)","v":0},"WLTC cold (14 degr C)","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R4,RESULTS!R26),0)/100)*$W$7","v":0},"WLTC cold (14 degr C)","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E4,RESULTS!E26),0)*$Z$7)","v":0}]
[null,null,"Total CO2","g/km",{"$f":"E10+E11","v":0},{"$f":"IF(OR(Hydrogen,Electric),I9,IF(E9=0,Sliding_Scale(E9,G9,H9,I9,0,Slide_Type),IF(K9/E9>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E9,G9,H9,I9,0,Slide_Type),Sliding_Scale(E9,G9,H9,I9,0,Slide_Type))))","v":4},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$8,IF(Diesel,'LIMITS Greenhouse'!$E$8,0))","v":175},4,null,0,null,null,null,null,null,null,"WLTC cold (-7 degr C)","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E7,RESULTS!$E29,0))*T$7)","v":0},"WLTC cold (-7 degr C)","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R7,RESULTS!R29),0)/100)*$W$7","v":0},"WLTC cold (-7 degr C)","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E7,RESULTS!E29),0)*$Z$7)","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!F4,RESULTS!F26,0),0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"WLTC-warm","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E8,RESULTS!$E30,0))*T$7)","v":0},"WLTC-warm","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R8,RESULTS!R30),0)/100)*$W$7","v":0},"WLTC-warm","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E8,RESULTS!E30),0)*$Z$7)","v":0}]
[null,null,"CO2-eq upstream","g/km",null,null,null,null,null,null,null,null,null,null,null,null,null,"PEMS+ cold engine1","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E11,RESULTS!$E33,0))*T$7)","v":0},"PEMS+ cold engine1","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R11,RESULTS!R33),0)/100)*$W$7","v":0},"PEMS+ cold engine1","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E11,RESULTS!E33),0)*$Z$7)","v":0}]
[null,"total",null,null,null,{"$f":"MAX(SUM(F7:F9),0)","v":7},null,null,null,null,null,null,null,null,null,null,null,"PEMS+ cold engine2","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E12,RESULTS!$E34,0))*T$7)","v":0},"PEMS+ cold engine2","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R12,RESULTS!R34),0)/100)*$W$7","v":0},"PEMS+ cold engine2","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E12,RESULTS!E34),0)*$Z$7)","v":0}]
[null,"WLTC-CAT","max points",{"$f":"SUM(I14:I16)","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,"Bab130","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E10,RESULTS!$E34,0))*T$7)","v":0},"Bab130","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R10,RESULTS!R34),0)/100)*$W$7","v":0},"Bab130","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E10,RESULTS!E32),0)*$Z$7)","v":0}]
[null,"(-7 degr C)","N2O","mg/km",{"$f":"RESULTS!$M$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I14,IF(E14=0,Sliding_Scale(E14,G14,H14,I14,0,Slide_Type),IF(K14/E14>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E14,G14,H14,I14,0,Slide_Type),Sliding_Scale(E14,G14,H14,I14,0,Slide_Type))))","v":1},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$N$6,IF(Diesel,'LIMITS Greenhouse'!$O$6,0))","v":9.9200000000000017},1,null,null,null,null,null,null,null,null,"PEMS light test","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E11,RESULTS!$E37,0))*T$7)","v":0},"PEMS light test","g/km",{"$f":"(IF(Electric,MAX(RESULTS!R15,RESULTS!R37),0)/100)*$W$7","v":0},"PEMS light test","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E11,RESULTS!E37),0)*$Z$7)","v":0}]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I15,IF(E15=0,Sliding_Scale(E15,G15,H15,I15,0,Slide_Type),IF(K15/E15>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E15,G15,H15,I15,0,Slide_Type),Sliding_Scale(E15,G15,H15,I15,0,Slide_Type))))","v":2},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$N$7,IF(Diesel,'LIMITS Greenhouse'!$O$7,0))","v":51.2},2,null,null,null,null,null,null,null,null,"PEMS heavy test","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E16,RESULTS!$E38,0))*T$7)","v":0},"PEMS heavy test","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!M16,RESULTS!M38)/100,0)*$Z$7)","v":0},"PEMS heavy test","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E16,RESULTS!E38),0)*$Z$7)","v":0}]
[null,null,"Total CO2","g/km",{"$f":"E17+E18","v":0},{"$f":"IF(OR(Hydrogen,Electric),I16,IF(E17=0,Sliding_Scale(E17,G16,H16,I16,0,Slide_Type),IF(K16/E17>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E17,G16,H16,I16,0,Slide_Type),Sliding_Scale(E17,G16,H16,I16,0,Slide_Type))))","v":4},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$N$8,IF(Diesel,'LIMITS Greenhouse'!$O$8,0))","v":175},4,null,null,null,null,null,null,null,null,"PEMS 8 minutes","g/km",{"$f":"(IF(OR(Petrol,Diesel),MAX(RESULTS!$E13,RESULTS!$E35,0))*T$7)","v":0},"PEMS 8 minutes","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!M13,RESULTS!M35)/100,0)*$Z$7)","v":0},"PEMS 8 minutes","g/km",{"$f":"(IF(OR(CNG_Mono,CNG_Dual),MAX(RESULTS!E13,RESULTS!E35),0)*$Z$7)","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F7,RESULTS!$F29,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,"total",null,null,null,{"$f":"MAX(SUM(F14:F16),0)","v":7}]
[null,"WLTC-warm","max points",{"$f":"SUM(I21:I23)","v":7}]
[null,"(warm)","N2O","mg/km",{"$f":"RESULTS!$M$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I21,IF(E21=0,Sliding_Scale(E21,G21,H21,I21,0,Slide_Type),IF(K21/E21>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E21,G21,H21,I21,0,Slide_Type),Sliding_Scale(E21,G21,H21,I21,0,Slide_Type))))","v":1},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$6,IF(Diesel,'LIMITS Greenhouse'!$E$6,0))","v":6.2},1]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I22,IF(E22=0,Sliding_Scale(E22,G22,H22,I22,0,Slide_Type),IF(K22/E22>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E22,G22,H22,I22,0,Slide_Type),Sliding_Scale(E22,G22,H22,I22,0,Slide_Type))))","v":2},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$7,IF(Diesel,'LIMITS Greenhouse'!$E$7,0))","v":32},2]
[null,null,"Total CO2","g/km",{"$f":"E24+E25","v":0},{"$f":"IF(OR(Hydrogen,Electric),I23,IF(E23=0,Sliding_Scale(E23,G23,H23,I23,0,Slide_Type),IF(K23/E23>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E23,G23,H23,I23,0,Slide_Type),Sliding_Scale(E23,G23,H23,I23,0,Slide_Type))))","v":4},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$8,IF(Diesel,'LIMITS Greenhouse'!$E$8,0))","v":175},4]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F8,RESULTS!$F30,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,"total",null,null,null,{"$f":"MAX(SUM(F21:F23),0)","v":7}]
[null,"3.2","Regulatory performance PEMS+ "]
[null,"PEMS+ cold engine 1","max points",{"$f":"SUM(I29:I31)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$11","v":0},{"$f":"IF(OR(Hydrogen,Electric),I29,IF(E29=0,Sliding_Scale(E29,G29,H29,I29,0,Slide_Type),IF(K29/E29>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E29,G29,H29,I29,0,Slide_Type),Sliding_Scale(E29,G29,H29,I29,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":9.3000000000000007},0,null,{"$f":"RESULTS!$M$33","v":0}]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P11","v":0},{"$f":"IF(OR(Hydrogen,Electric),I30,IF(E30=0,Sliding_Scale(E30,G30,H30,I30,0,Slide_Type),IF(K30/E30>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E30,G30,H30,I30,0,Slide_Type),Sliding_Scale(E30,G30,H30,I30,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$7,IF(Diesel,'LIMITS Greenhouse'!$J$7,0))","v":48},0,null,{"$f":"RESULTS!$P$33","v":0}]
[null,null,"Total CO2","g/km",{"$f":"E32+E33","v":0},{"$f":"IF(OR(Hydrogen,Electric),I31,IF(E31=0,Sliding_Scale(E31,G31,H31,I31,0,Slide_Type),IF(K31/E31>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E31,G31,H31,I31,0,Slide_Type),Sliding_Scale(E31,G31,H31,I31,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":262.5},0,null,{"$f":"RESULTS!$E$33+$S$30","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F11,RESULTS!$F33,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E29:E31>'LIMITS Greenhouse'!$K$6:$K$8,K29:K31>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F29:F31),0))","v":0}]
[null,"PEMS+ cold engine 2","max points",{"$f":"SUM(I36:I38)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$12","v":0},{"$f":"IF(OR(Hydrogen,Electric),I36,IF(E36=0,Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),IF(K36/E36>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),Sliding_Scale(E36,G36,H36,I36,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":9.3000000000000007},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P12","v":0},{"$f":"IF(OR(Hydrogen,Electric),I37,IF(E37=0,Sliding_Scale(E37,G37,H37,I37,0,Slide_Type),IF(K37/E37>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E37,G37,H37,I37,0,Slide_Type),Sliding_Scale(E37,G37,H37,I37,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$7,IF(Diesel,'LIMITS Greenhouse'!$J$7,0))","v":48},0]
[null,null,"Total CO2","g/km",{"$f":"E39+E40","v":0},{"$f":"IF(OR(Hydrogen,Electric),I38,IF(E38=0,Sliding_Scale(E38,G38,H38,I38,0,Slide_Type),IF(K38/E38>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E38,G38,H38,I38,0,Slide_Type),Sliding_Scale(E38,G38,H38,I38,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":262.5},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F12,RESULTS!$F34,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,"Regulatory performance PEMS+ ",null,null,null,{"$f":"IF(OR(E36:E38>'LIMITS Greenhouse'!$K$6:$K$8,K36:K38>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F36:F38),0))","v":0}]
[]
[null,"3.3","Robustness "]
[null,"BAB130","max points",{"$f":"SUM(I45:I47)","v":7}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I45,IF(E45=0,Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),IF(K45/E45>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),Sliding_Scale(E45,G45,H45,I45,0,Slide_Type))))","v":1},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$6,IF(Diesel,'LIMITS Greenhouse'!$E$6,0))","v":6.2},1,null,{"$f":"RESULTS!$M$32","v":0}]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$10","v":0},{"$f":"IF(OR(Hydrogen,Electric),I46,IF(E46=0,Sliding_Scale(E46,G46,H46,I46,0,Slide_Type),IF(K46/E46>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E46,G46,H46,I46,0,Slide_Type),Sliding_Scale(E46,G46,H46,I46,0,Slide_Type))))","v":2},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$7,IF(Diesel,'LIMITS Greenhouse'!$E$7,0))","v":32},2,null,{"$f":"RESULTS!$P$32","v":0}]
[null,null,"Total CO2","g/km",{"$f":"E48+E49","v":0},{"$f":"IF(OR(Hydrogen,Electric),I47,IF(E47=0,Sliding_Scale(E47,G47,H47,I47,0,Slide_Type),IF(K47/E47>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E47,G47,H47,I47,0,Slide_Type),Sliding_Scale(E47,G47,H47,I47,0,Slide_Type))))","v":4},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$8,IF(Diesel,'LIMITS Greenhouse'!$E$8,0))","v":175},4,null,{"$f":"RESULTS!$E$32+$S$29","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F10,RESULTS!$F32,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"MAX(SUM(F45:F47),0)","v":7}]
[null,"PEMS light test","max points",{"$f":"SUM(I52:I54)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$15","v":0},{"$f":"IF(OR(Hydrogen,Electric),I52,IF(E52=0,Sliding_Scale(E52,G52,H52,I52,0,Slide_Type),IF(K52/E52>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E52,G52,H52,I52,0,Slide_Type),Sliding_Scale(E52,G52,H52,I52,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":9.3000000000000007},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$15","v":0},{"$f":"IF(OR(Hydrogen,Electric),I53,IF(E53=0,Sliding_Scale(E53,G53,H53,I53,0,Slide_Type),IF(K53/E53>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E53,G53,H53,I53,0,Slide_Type),Sliding_Scale(E53,G53,H53,I53,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$7,IF(Diesel,'LIMITS Greenhouse'!$J$7,0))","v":48},0]
[null,null,"Total CO2","g/km",{"$f":"E55+E56","v":0},{"$f":"IF(OR(Hydrogen,Electric),I54,IF(E54=0,Sliding_Scale(E54,G54,H54,I54,0,Slide_Type),IF(K54/E54>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E54,G54,H54,I54,0,Slide_Type),Sliding_Scale(E54,G54,H54,I54,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":262.5},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F15,RESULTS!$F37,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E52:E54>'LIMITS Greenhouse'!$K$6:$K$8,K52:K54>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F52:F54),0))","v":0}]
[null,"PEMS heavy test","max points",{"$f":"SUM(I59:I63)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$16","v":0},{"$f":"IF(OR(Hydrogen,Electric),I59,IF(E59=0,Sliding_Scale(E59,G59,H59,I59,0,Slide_Type),IF(K59/E59>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E59,G59,H59,I59,0,Slide_Type),Sliding_Scale(E59,G59,H59,I59,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":9.3000000000000007},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$16","v":0},{"$f":"IF(OR(Hydrogen,Electric),I60,IF(E60=0,Sliding_Scale(E60,G60,H60,I60,0,Slide_Type),IF(K60/E60>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E60,G60,H60,I60,0,Slide_Type),Sliding_Scale(E60,G60,H60,I60,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$7,IF(Diesel,'LIMITS Greenhouse'!$J$7,0))","v":48},0]
[null,null,"CO2","g/km",{"$f":"E62+E63","v":0},{"$f":"IF(OR(Hydrogen,Electric),I63,IF(E63=0,Sliding_Scale(E63,G61,H61,I63,0,Slide_Type),IF(K63/E63>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E63,G61,H61,I63,0,Slide_Type),Sliding_Scale(E63,G61,H61,I63,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":262.5},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F16,RESULTS!$F38,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E59:E61>'LIMITS Greenhouse'!$K$6:$K$8,K59:K61>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F59:F61),0))","v":0}]
[null,"PEMS 8 minutes","max points",{"$f":"SUM(I66:I70)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I66,IF(E66=0,Sliding_Scale(E66,G66,H66,I66,0,Slide_Type),IF(K66/E66>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E66,G66,H66,I66,0,Slide_Type),Sliding_Scale(E66,G66,H66,I66,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$16","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":9.3000000000000007},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I67,IF(E67=0,Sliding_Scale(E67,G67,H67,I67,0,Slide_Type),IF(K67/E67>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E67,G67,H67,I67,0,Slide_Type),Sliding_Scale(E67,G67,H67,I67,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$17","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$7,IF(Diesel,'LIMITS Greenhouse'!$J$7,0))","v":48},0]
[null,null,"CO2","g/km",{"$f":"E69+E70","v":0},{"$f":"IF(OR(Hydrogen,Electric),I70,IF(E70=0,Sliding_Scale(E70,G68,H68,I70,0,Slide_Type),IF(K70/E70>='LIMITS Efficiency'!$E$25,(1-'LIMITS Efficiency'!$E$26)*Sliding_Scale(E70,G68,H68,I70,0,Slide_Type),Sliding_Scale(E70,G68,H68,I70,0,Slide_Type))))","v":0},{"$f":"'LIMITS Greenhouse'!$E$18","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":262.5},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual),MAX(RESULTS!$F13,RESULTS!$F35,0),0))","v":0}]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E66:E68>'LIMITS Greenhouse'!$K$6:$K$8,K66:K68>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F66:F68),0))","v":0}]
[]
[]
[]
[]
[]
[]
[null,"SUMMARY",null,"MAX",null,"SCORE"]
[null,{"$f":"B5","v":"3.1"},{"$f":"C5","v":"Regulatory Tailpipe Emission Lab Tests"},{"$f":"SUM(D6,D13,D20)","v":21},null,{"$f":"ROUNDDOWN(SUM(F12,F19,F26,),1)","v":21}]
[null,{"$f":"B27","v":"3.2"},{"$f":"C27","v":"Regulatory performance PEMS+ "},{"$f":"SUM(D28,D35)","v":0},null,{"$f":"ROUNDDOWN(SUM(F34,F41),1)","v":0}]
[null,{"$f":"B43","v":"3.3"},{"$f":"C43","v":"Robustness "},{"$f":"SUM(D44,D51,D58)","v":7},null,{"$f":"ROUNDDOWN(SUM(F50,F57,F64),1)","v":7}]
[null,"TOTAL",null,{"$f":"SUM(D79:D81)","v":28},null,{"$f":"SUM(F79:F81)","v":28}]
[]
[]
[]
[null,"TOTAL SCORE POLLUTANTS",null,"(0-10pts)",null,{"$f":"ROUNDDOWN(10*F82/D82,1)","v":10}]

{"sheet":"RESULTS","index":4,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[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],[42,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]]}
[]
["DOMINANT FUEL","MAIN RESULTS 1",null,null,"CO2\ntailpipe","CO2                RCB corr.","CO","NOx","NO","NO2","PN","PM","N2O","NH3","THC","CH4","Fuel Consumption","Energy Consumption","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)"]
[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"]
[null,"Laboratory Tests","WLTC+ appr.","WLTC+ cold engine (14 degr C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","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,"n.a.","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,"n.a.","n.a."]
[null,null,null,"WLTC+ cold engine (-7 degr C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","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,"WLTC+ reg. warm engn. rep. (not rated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","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,"Real-World tests","Approval","PEMS+ Cold Engine 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,null,"PEMS+ Cold Engine 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,"Short urban trip","Short trip / cold start 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,"n.a.","n.a.","n.a."]
[null,null,null,"Short trip / cold start 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,"n.a.","n.a.","n.a."]
[null,null,"Robustness","Eco / light",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,null,"Heavy Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,null,null,"g/s ↓","g/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","#/s ↓",null,"mg/s ↓",null,"mg/s ↓"]
[null,null,null,"Congestion MAX value"]
[null,null,null,"Congestion AVG value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 ↓"]
[null,null,"Insert name of test with particle filter regeneration occurance"]
[null,null,"Impact of regen. compared to the non-regenerating test [%]"]
[]
["FALL BACK FUEL ","MAIN RESULTS 2",null,null,"CO2\ntailpipe","CO2                RCB corr.","CO","NOx","NO","NO2","PN","PM","N2O","NH3","THC","CH4","Fuel Consumption","Energy Consumption","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)"]
[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"]
[null,"Laboratory Tests","WLTC+ appr.","WLTC+ cold engine (14 degr C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","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,"n.a.","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,"n.a.","n.a."]
[null,null,null,"WLTC+ cold engine (-7 degr C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","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,"WLTC+ reg. warm engn. rep. (not rated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","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,"Real-World tests","Approval","PEMS+ Cold Engine 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,null,"PEMS+ Cold Engine 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,"Short urban trip","Short trip / cold start 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,"n.a.","n.a.","n.a."]
[null,null,null,"Short trip / cold start 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.",null,"n.a.","n.a.","n.a."]
[null,null,"Robustness","Eco / light",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,null,"Heavy Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a."]
[null,null,null,null,"g/s ↓","g/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","#/s ↓","n.a.","mg/s ↓","n.a.","mg/s ↓","n.a."]
[null,null,null,"Congestion MAX value"]
[null,null,null,"Congestion AVG value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a."]
[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 ↓"]
[null,"Regene-ration","Insert name of test with particle filter regeneration occurance"]
[null,null,"Impact of regen. compared to the non-regenerating test [%]"]

{"sheet":"SPECS","index":5,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Brand",null,"e.g. Mercedes-Benz",null,null,null,null,null,null,null,null,"Petrol (inc hybrids)",{"$f":"IF(ICE_Type=1,TRUE,FALSE)","v":true},1,"Version","Euro 6b"]
["Model:",null,"e.g. V-Class",null,null,null,null,null,null,null,null,"Diesel (inc. hybrids)",{"$f":"IF(ICE_Type=2,TRUE,FALSE)","v":false},true,"2020.2.0.1","Euro 6c"]
["Variant Name:",null,"e.g. V250d 9gtronic",null,null,null,null,null,null,null,null,"Petrol PHEV",{"$f":"IF(ICE_Type=3,TRUE,FALSE)","v":false},null,null,"Euro 6d-Temp"]
["Test Reference Number:",null,"e.g. 20-FOR-0023",null,null,null,null,null,null,null,null,"Diesel PHEV",{"$f":"IF(ICE_Type=4,TRUE,FALSE)","v":false},null,null,"Euro 6d"]
["Drivetrain:",null,"e.g. 4x2",null,null,null,null,null,null,null,null,"ICE - CNG - Mono",{"$f":"IF(ICE_Type=5,TRUE,FALSE)","v":false}]
["Drive axle (FWD/AWD/RWD):",null,"e.g. RWD",null,null,null,null,null,null,null,null,"ICE - CNG - Dual",{"$f":"IF(ICE_Type=6,TRUE,FALSE)","v":false}]
["Fuel Type:",null,"e.g. diesel",null,null,null,null,null,null,null,null,"Hydrogen",{"$f":"IF(ICE_Type=7,TRUE,FALSE)","v":false}]
["Primary fuel source (if applicable):",null,"e.g. diesel",null,null,null,null,null,null,null,null,"Battery Electric",{"$f":"IF(ICE_Type=8,TRUE,FALSE)","v":false}]
["Secondary fuel source (if applicable):",null,"e.g. electric",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(EngineType,\"False\")","v":4}]
["Fuel tank size liquid fuel (l)",null,"e.g. 70"]
["Fuel tank size gaseous fuel (kg)"]
["Battery Size (kWh):"]
["Published CO2 (WLTP), combined (g/km):",null,"e.g. 132"]
["Published Driving Range (km):"]
["Gearbox type:",null,"e.g. automatic"]
["Chassis Version:",null,"e.g. hatchback"]
["Number of doors:",null,"e.g. 5 doors"]
["VIN tested vehicle: ",null,"e.g. WDF44781313651756"]
["Emission class and character:",null,"e.g. Euro 6d-Temp"]
["Country of registration:",null,"e.g. Germany"]
["Engine code:",null,"e.g. 654"]
["Engine volume (cm3):",null,"e.g. 1950"]
["Engine power (kW):",null,"e.g. 140"]
["Torque (Nm):",null,"e.g. 250"]
["Tyre size (front and rear if different): ",null,"e.g. 245/45 R19 Y XL"]
["Actual Vehicle Mass (kg) = CoC 13.2 - 75 kg",null,"e.g. 3100"]

{"sheet":"LIMITS Clean Air","index":6,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,14],[12,12,12,14],[13,12,13,14],[14,12,14,13],[15,12,15,13],[14,7,14,8],[15,7,15,8],[2,1,2,3],[12,1,12,3],[13,1,13,3],[12,7,12,9],[13,7,13,9],[14,1,14,2],[15,1,15,2],[2,6,2,8],[2,11,2,13],[2,16,2,18],[21,12,21,14],[20,1,20,2],[16,1,16,2],[17,1,17,2],[17,12,17,13],[18,12,18,13],[16,12,16,13],[18,1,18,2],[19,1,19,2],[19,7,19,8],[20,7,20,8],[18,7,18,8],[16,7,16,8],[17,7,17,8],[22,12,22,14],[23,12,23,14],[24,12,24,14],[19,12,19,13],[20,12,20,13]]}
[null,"Clean Air (Pollutants)"]
[]
[null,"u p p e r   l i m i t s (labtests)",null,null,"gross excess",null,"u p p e r   l i m i t s (PEMS tests)",null,null,"gross excess",null,"u p p e r   l i m i t s (extended bouderies)",null,null,"gross excess",null,"PEMS Congestion"]
[null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"},null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"},null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"},null,null,"max ","avg"]
[null,"HC",58,{"$f":"90-32","v":58},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.2*C5,IF(Diesel,1.5*D5,\"n.a.\"))","v":69.599999999999994},null,"HC",{"$f":"C5*$J$12","v":76.56},76.56,{"$f":"IF(OR(Petrol,CNG_Dual,CNG_Mono),1.5*H5,IF(Diesel,1.5*I5,\"n.a.\"))","v":114.84},null,"HC",{"$f":"C5*$O$12","v":76.56},76.56,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.5*M5,IF(Diesel,1.5*N5,\"n.a.\"))","v":114.84},null,null,"mg/s","mg/s"]
[null,"NOx",60,60,72,null,"NOx",79.2,79.2,118.80000000000001,null,"NOx",79.2,79.2,118.80000000000001,null,"NOx",1,0.5]
[null,"NO2",20,20,24,null,"NO2",26.400000000000002,26.400000000000002,39.6,null,"NO2",26.400000000000002,26.400000000000002,39.6]
[null,"NH3",10,10,12,null,"NH3",13.200000000000001,13.200000000000001,19.8,null,"NH3",13.200000000000001,13.200000000000001,19.8]
[null,"CO",500,500,600,null,"CO",660,660,990,null,"CO",660,660,990]
[null,"PM",4.5,4.5,5.3999999999999995,null,"PM",5.94,5.94,8.91,null,"PM",5.94,5.94,8.91]
[null,"PN",600000000000,600000000000,6000000000000,null,"PN",792000000000,792000000000,1188000000000,null,"PN",792000000000,792000000000,1188000000000]
[null,null,null,null,null,null,null,null,"CF:",1.32,null,null,null,"CF:",1.32]
[null,"l o w e r     l i m i t s (labtests)",null,null,null,null,null,"l o w e r     l i m i t s (PEMS tests)",null,null,null,null,"l o w e r     l i m i t s (WLTC  CAT test, -7 C)"]
[null,"petrol AND diesel",null,null,null,null,null,"petrol AND diesel",null,null,null,null,"petrol AND diesel"]
[null,"HC",null,0,null,null,null,"HC",null,{"$f":"D15","v":0},null,null,"HC",null,{"$f":"J15","v":0}]
[null,"NOx",null,0,null,null,null,"NOx",null,0,null,null,"NOx",null,{"$f":"J16","v":0}]
[null,"NO2","NO2",0,null,null,null,"NO2","NO2",0,null,null,"NO2","NO2",0]
[null,"NH3","NH3",0,null,null,null,"NH3","NH3",0,null,null,"NH3","NH3",0]
[null,"CO",null,0,null,null,null,"CO",null,0,null,null,"CO",null,0]
[null,"PM",null,0,null,null,null,"PM",null,0,null,null,"PM",null,0]
[null,"PN",null,0,null,null,null,"PN",null,0,null,null,"PN",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"extended bouderies applicable to:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WLTC  CAT test, -7 C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PEMS heavy test"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PEMS 8 km"]

{"sheet":"LIMITS Efficiency","index":7,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,7],[23,1,23,4],[29,1,29,3],[28,1,28,3],[25,1,25,3],[24,1,24,3],[5,1,9,1],[11,1,12,1],[15,1,15,7],[3,1,3,5]]}
[]
[null,"Efficiency"]
[]
[null,"Energy Consumption (total)"]
[null,"limits:",null,null,"lower","upper","mid"]
[null,"Lab tests","WLTC cold (14 degr C)","kWh/100km",30,90,30]
[null,null,"WLTC cold (-7 degr C)","kWh/100km",{"$f":"E6","v":30},{"$f":"F6","v":90},{"$f":"G6","v":30}]
[null,null,"WLTC-warm","kWh/100km",{"$f":"E7","v":30},{"$f":"F7","v":90},{"$f":"G7","v":30}]
[null,null,"WLTC -eco","kWh/100km",30,90,30]
[null,null,"WLTC-sport","kWh/100km",30,90,30]
[null,"PEMS","PEMS+","kWh/100km",30,90,30]
[null,"robustness","Bab130","kWh/100km",30,90,30]
[null,null,"suppl. PEMS","kWh/100km",30,90,30]
[]
[]
[null,"Energy / fuel consumption"]
[null,"multiplication liquid fuel (l/100km) or gaseous fuel  (kg/100km)  -> energy (kWh/100km)"]
[null,"Petrol",{"$f":"IF(H18>0,H18,E18)","v":8.64},"default",8.64,"override value:"]
[null,"Diesel",{"$f":"IF(H19>0,H19,E19)","v":9.7899999999999991},"default",9.7899999999999991,"override value:"]
[null,"CNG",{"$f":"IF(H20>0,H20,E20)","v":13.8925},"default",13.8925,"override value:"]
[null,"Electric",1]
[null,"Hydrogene",33.61,"default",33.61,"override value:"]
[]
[null,"modifyer for multifuel ICE vehicles"]
[null,"dominant/fall back ratio",null,null,1.5]
[null,"score modifier (%)",null,null,{"$f":"IF(CNG_Mono,0.1,IF(CNG_Dual,0.5,0))","v":0}]
[]
[]
[null,"Driving Range "]
[null,"(urban zero tailpipe emissions)"]
[null,"limits:","lower","upper"]
[null,"BEV",1000,100]
[null,"PHEV",1000,100]
[null,"ICE",1000,100]

{"sheet":"LIMITS Greenhouse","index":8,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,15],[20,8,20,9],[21,8,21,9],[14,8,14,10],[15,8,15,9],[16,8,16,9],[20,2,20,3],[20,13,20,14],[21,2,21,3],[21,13,21,14],[14,13,14,15],[14,2,14,4],[15,2,15,3],[15,13,15,14],[17,8,17,9],[19,8,19,9],[16,2,16,3],[16,13,16,14],[17,2,17,3],[18,2,18,3],[19,2,19,3],[19,13,19,14],[17,13,17,14],[32,1,32,2],[33,1,33,2],[25,1,25,3],[27,1,27,2],[28,1,28,2],[29,1,29,2],[31,1,31,2]]}
[]
[null,"Greenhouse gases"]
[]
[null,"GWP","u p p e r   l i m i t s (labtests)",null,null,"gross excess",null,"u p p e r   l i m i t s (PEMS tests)",null,null,"gross excess",null,"u p p e r   l i m i t s (WLTC  CAT test, -7 C)",null,null,"gross excess"]
[null,null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"},null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"},null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"}]
[null,298,"N2O",6.2,6.2,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.5*D6,IF(Diesel,1.5*E6,\"n.a.\"))","v":9.3000000000000007},null,"NO2",{"$f":"D6*$K$13","v":9.3000000000000007},9.3000000000000007,{"$f":"IF(Petrol,1.5*I6,IF(Diesel,1.5*J6,\"n.a.\"))","v":13.950000000000001},null,"NO2",{"$f":"D6*$P$13","v":9.9200000000000017},{"$f":"E6*$P$13","v":9.9200000000000017},{"$f":"IF(Petrol,1.5*N6,IF(Diesel,1.5*O6,\"n.a.\"))","v":14.880000000000003}]
[null,25,"CH4",32,32,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.5*D7,IF(Diesel,1.5*E7,\"n.a.\"))","v":48},null,"CH4",48,48,{"$f":"IF(Petrol,1.5*I7,IF(Diesel,1.5*J7,\"n.a.\"))","v":72},null,"CH4",{"$f":"D7*$P$13","v":51.2},{"$f":"E7*$P$13","v":51.2},{"$f":"IF(Petrol,1.5*N7,IF(Diesel,1.5*O7,\"n.a.\"))","v":76.800000000000011}]
[null,1,"CO2",175,175,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.5*D8,IF(Diesel,1.5*E8,\"n.a.\"))","v":262.5},null,"CO2",262.5,262.5,{"$f":"IF(Petrol,1.5*I8,IF(Diesel,1.5*J8,\"n.a.\"))","v":393.75},null,"CO2",{"$f":"D8","v":175},{"$f":"E8","v":175},{"$f":"IF(Petrol,1.5*N8,IF(Diesel,1.5*O8,\"n.a.\"))","v":262.5}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"CF:",1.5,null,null,null,"CF:",1.6]
[null,"GWP","l o w e r     l i m i t s (labtests)",null,null,null,null,null,"l o w e r     l i m i t s (WLTC  CAT test, -7 C)",null,null,null,null,"l o w e r     l i m i t s (PEMS tests)"]
[null,null,"petrol AND diesel",null,null,null,null,null,"petrol AND diesel",null,null,null,null,"petrol AND diesel"]
[null,298,"N2O","NO2",0,null,null,null,"N2O",null,{"$f":"E16","v":0},null,null,"N2O",null,{"$f":"K16","v":0}]
[null,25,"CH4","CH4",0,null,null,null,"CH4",null,{"$f":"E17","v":0},null,null,"CH4",null,{"$f":"K17","v":0}]
[null,1,"CO2","CO2",0,null,null,null,"CO2","NO2",{"$f":"E18","v":0},null,null,"CO2","NO2",{"$f":"K18","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"CO2-eq upstream factor"]
[]
[null,"Petrol",null,0.188]
[null,"Diesel",null,0.21]
[null,"Electricity","NO2",217.5]
[null,null,"CNG",0.23100000000000001]
[null,"(Hydrogene)"]

{"sheet":"WEBSITE SUMMARY","index":9,"n_rows":159,"n_cols":4,"rows_kept":159,"cut":false,"hidden":true,"merged":[]}
["Car Model",{"$f":"CONCATENATE(SPECS!B1,\" \",SPECS!B2)","v":" "},"Comment SV","Type"]
["Type",{"$f":"CONCATENATE(SPECS!B3,\" \",SPECS!B5,\" \",SPECS!B7,\" \",SPECS!B15)","v":"   "}]
["Release Date","2020-11-26"]
["Year of Test",2020]
["Engine",{"$f":"SPECS!B21","v":0}]
["Gearbox",{"$f":"SPECS!B15","v":0}]
["Emissions Class",{"$f":"SPECS!B19","v":0}]
["Stars",{"$f":"Stars","v":5}]
["Test #",{"$f":"SPECS!B4","v":0}]
["Engine Size 2",{"$f":"SPECS!B22","v":0}]
["Mass",{"$f":"SPECS!B26","v":0}]
["Clean Air Index",{"$f":"'Clean Air'!F113","v":10}]
["Clean Air Lab Tests - Overall Performance",{"$f":"Colour_Local('Clean Air'!F106,'Clean Air'!D106)","v":"Green"},"Need to check logic (sum of scores/sum of totals or average of percentages?)"]
["CA Cold Test - Score",{"$f":"ROUND('Clean Air'!F14,1)","v":10}]
["CA Cold Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F7,'Clean Air'!I7)","v":"Green"},"previously HC > to be renamed in dashboard"]
["CA Cold Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F8,'Clean Air'!I8)","v":"Green"}]
["CA Cold Test - NO2 Colour","Not Used","new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F10,'Clean Air'!I10)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F11,'Clean Air'!I11)","v":"Green"}]
["CA Cold Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F13,'Clean Air'!I13)","v":"Green"}]
["CA Warm Test - Score",{"$f":"ROUND('Clean Air'!F32,1)","v":10}]
["CA Warm Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F25,'Clean Air'!I25)","v":"Green"},"previously HC > to be renamed in dashboard"]
["CA Warm Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F26,'Clean Air'!I26)","v":"Green"}]
["CA Warm Test - NO2 Colour","Not Used","new","Brown - Green - Orange - Red - Yellow"]
["CA Warm Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F28,'Clean Air'!I28)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Warm Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F29,'Clean Air'!I29)","v":"Green"}]
["CA Warm Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F31,'Clean Air'!I31)","v":"Green"}]
["CA Eco Test - Score","-","only 2019"]
["CA Eco Test - HC Colour","-","only 2019"]
["CA Eco Test - NOx Colour","-","only 2019"]
["CA Eco Test - CO Colour","-","only 2019"]
["CA Eco Test - PN Colour","-","only 2019"]
["CA Sport Test - Score","-","only 2019"]
["CA Sport Test - HC Colour","-","only 2019"]
["CA Sport Test - NOx Colour","-","only 2019"]
["CA Sport Test - CO Colour","-","only 2019"]
["CA Sport Test - PN Colour","-","only 2019"]
["CA Cold Ambient Test - Score",{"$f":"ROUND('Clean Air'!F23,1)","v":10},"new","Number - 1 decimal place"]
["CA Cold Ambient Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F16,'Clean Air'!I16)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F17,'Clean Air'!I17)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NO2 Colour","Not Used","new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F19,'Clean Air'!I19)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F20,'Clean Air'!I20)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F22,'Clean Air'!I22)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - Score",{"$f":"ROUND('Clean Air'!F62,1)","v":10}]
["CA Highway Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F55,'Clean Air'!I55)","v":"Green"},"previously HC > to be renamed in dashboard"]
["CA Highway Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F56,'Clean Air'!I56)","v":"Green"}]
["CA Highway Test - NO2 Colour","Not Used","new","Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F58,'Clean Air'!I58)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F59,'Clean Air'!I59)","v":"Green"}]
["CA Highway Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F61,'Clean Air'!I61)","v":"Green"}]
["CA Road Test - Overall Performance Colour",{"$f":"Colour_Local('Clean Air'!F107,'Clean Air'!D107)","v":"Green"}]
["CA On Road Drive - Score",{"$f":"ROUND(AVERAGE('Clean Air'!F42,'Clean Air'!F51),1)","v":5}]
["CA On Road Drive - NMHC Colour","Grey","previously HC > to be renamed in dashboard"]
["CA On Road Drive - NOx Colour",{"$f":"Colour_Local(AVERAGE('Clean Air'!F36,'Clean Air'!F45),'Clean Air'!I36)","v":"Green"}]
["CA On Road Drive - NO2 Colour","Grey","new","Brown - Green - Orange - Red - Yellow"]
["CA On Road Drive - NH3 Colour","Grey","new","Brown - Green - Orange - Red - Yellow"]
["CA On Road Drive - CO Colour",{"$f":"Colour_Local(AVERAGE('Clean Air'!F39,'Clean Air'!F48),'Clean Air'!I48)","v":"Green"}]
["CA On Road Drive - PN Colour",{"$f":"Colour_Local(AVERAGE('Clean Air'!F41,'Clean Air'!F50),'Clean Air'!I50)","v":"Green"}]
["CA Robustness - Overall Performance Colour",{"$f":"Colour_Local('Clean Air'!F108,'Clean Air'!D108)","v":"Green"}]
["CA Light Load - Score",{"$f":"ROUND('Clean Air'!F71,1)","v":5}]
["CA Light Load - NMHC Colour","Grey"]
["CA Light Load - NOx Colour",{"$f":"Colour_Local('Clean Air'!F65,'Clean Air'!I65)","v":"Green"}]
["CA Light Load - NO2 Colour","Grey"]
["CA Light Load - NH3 Colour","Grey"]
["CA Light Load - CO Colour",{"$f":"Colour_Local('Clean Air'!F68,'Clean Air'!I68)","v":"Green"}]
["CA Light Load - PN Colour",{"$f":"Colour_Local('Clean Air'!F70,'Clean Air'!I70)","v":"Green"}]
["CA Heavy Load - Score",{"$f":"ROUND('Clean Air'!F80,1)","v":8}]
["CA Heavy Load - NMHC Colour","Grey"]
["CA Heavy Load - NOx Colour",{"$f":"Colour_Local('Clean Air'!F74,'Clean Air'!I74)","v":"Green"}]
["CA Heavy Load - NO2 Colour","Grey"]
["CA Heavy Load - NH3 Colour","Grey"]
["CA Heavy Load - CO Colour",{"$f":"Colour_Local('Clean Air'!F77,'Clean Air'!I77)","v":"Green"}]
["CA Heavy Load - PN Colour",{"$f":"Colour_Local('Clean Air'!F79,'Clean Air'!I79)","v":"Green"}]
["CA Short Trip - Score",{"$f":"ROUND('Clean Air'!F88,1)","v":5}]
["CA Short Trip - NMHC Colour","Grey"]
["CA Short Trip - NOx Colour",{"$f":"Colour_Local(AVERAGE('Clean Air'!F82,'Clean Air'!F85),'Clean Air'!I85)","v":"Green"}]
["CA Short Trip - NO2 Colour","Grey"]
["CA Short Trip - NH3 Colour","Grey"]
["CA Short Trip - CO Colour",{"$f":"Colour_Local(AVERAGE('Clean Air'!F83,'Clean Air'!F86),'Clean Air'!I86)","v":"Green"}]
["CA Short Trip - PN Colour",{"$f":"Colour_Local(AVERAGE('Clean Air'!F84,'Clean Air'!F87),'Clean Air'!I87)","v":"Green"}]
["CA Congestion - Score",{"$f":"ROUND('Clean Air'!F98,1)","v":2}]
["CA Congestion - NMHC Colour","Grey"]
["CA Congestion - NOx Colour",{"$f":"Colour_Local('Clean Air'!F91,'Clean Air'!I91)","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","Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."]
["Energy Efficiency Index",{"$f":"Efficiency!E53","v":10}]
["Energy Efficiency Lab Tests - Overall performance",{"$f":"Colour_Local(Efficiency!E53,10)","v":"Green"}]
["EE Cold Test - Score",{"$f":"ROUND(Efficiency!F10,1)","v":10}]
["EE Cold Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F10,Efficiency!I10)","v":"Green"}]
["EE Cold Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P10,1)","v":0}]
["EE Warm Test - Score",{"$f":"ROUND(Efficiency!F12,1)","v":10}]
["EE Warm Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F12,Efficiency!I12)","v":"Green"}]
["EE Warm Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P12,1)","v":0}]
["EE Eco Test - Score","-","only 2019"]
["EE Eco Test - Energy Eff Colour","-","only 2019"]
["EE Eco Test - Electric Efficiency Value","-","only 2019"]
["EE Sport Test - Score","-","only 2019"]
["EE Sport Test - Energy Eff Colour","-","only 2019"]
["EE Sport Test - Electric Efficiency Value","-","only 2019"]
["EE Cold Ambient Test - Score",{"$f":"ROUND(Efficiency!F11,1)","v":10},"new","Number - 1 decimal place"]
["EE Cold Ambient Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F11,Efficiency!I11)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["EE Cold Ambient Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P11,1)","v":0},"new","Number"]
["EE Highway Test - Score",{"$f":"ROUND(Efficiency!F15,1)","v":10}]
["EE Highway Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F15,Efficiency!I15)","v":"Green"}]
["EE Highway Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P15,1)","v":0}]
["Average Consumption (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel),Efficiency!M19,IF(Electric,Efficiency!P19,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S19,\"???\"))),1)","v":0}]
["Worst-Case Consumption (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel),Efficiency!M20,IF(Electric,Efficiency!P20,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S20,\"???\"))),1)","v":0}]
["Average Consumption (2nd fuel source)",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),Efficiency!P19,IF(CNG_Dual,Efficiency!M19,\"\"))","v":""}]
["Worst-Case Consumption (2nd fuel source)",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),Efficiency!P20,IF(CNG_Dual,Efficiency!M20,\"\"))","v":""}]
["Driving Range - Average (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel),Efficiency!M34,IF(Electric,Efficiency!P34,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S34,\"???\"))),0)","v":0}]
["Driving Range - Worst-Case (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel),Efficiency!M35,IF(Electric,Efficiency!P35,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S35,\"???\"))),0)","v":0}]
["Driving Range - Average (2nd fuel source)",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),Efficiency!P34,IF(CNG_Dual,Efficiency!M34,\"\"))","v":""}]
["Driving Range - Worst-Case (2nd fuel source)",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),Efficiency!P35,IF(CNG_Dual,Efficiency!M35,\"\"))","v":""}]
["Energy Efficiency Comment","Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."]
["Greenhouse Gases Index",{"$f":"ROUND(Greenhouse!F86,1)","v":10},"new","Number - 1 decimal place"]
["Greenhouse Gases - Overall Performance",{"$f":"Colour_Local(SUM(Greenhouse!F50,Greenhouse!F26,Greenhouse!F19,Greenhouse!F12),SUM(Greenhouse!D6,Greenhouse!D13,Greenhouse!D20,Greenhouse!D44))","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Cold Test - Score",{"$f":"ROUND(Greenhouse!F12,1)","v":7},"new","Number - 1 decimal place"]
["GG Cold Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F9,Greenhouse!I9)","v":"Green"},"added GG > to be renamed in the dashboard"]
["GG Cold Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F7,Greenhouse!I7)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Cold Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F8,Greenhouse!I8)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Warm Test - Score",{"$f":"ROUND(Greenhouse!F26,1)","v":7},"new","Number - 1 decimal place"]
["GG Warm Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F23,Greenhouse!I23)","v":"Green"},"added GG > to be renamed in the dashboard"]
["GG Warm Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F21,Greenhouse!I21)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Warm Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F22,Greenhouse!I22)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["Eco Test - CO2 Colour","-","only 2019"]
["Sport Test - CO2 Colour","-","only 2019"]
["GG Cold Ambient Test - Score",{"$f":"ROUND(Greenhouse!F19,1)","v":7},"new","Number - 1 decimal place"]
["GG Cold Ambient Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F16,Greenhouse!I16)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Cold Ambient Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F14,Greenhouse!I14)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Cold Ambient Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F15,Greenhouse!I15)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Highway Test - Score",{"$f":"ROUND(Greenhouse!F50,1)","v":7},"new","Number - 1 decimal place"]
["GG Highway Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F47,Greenhouse!I47)","v":"Green"},"added GG > to be renamed in the dashboard"]
["GG Highway Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F45,Greenhouse!I45)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["GG Highway Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F46,Greenhouse!I46)","v":"Green"},"new","Brown - Green - Orange - Red - Yellow"]
["Greenhouse Gases Comment","Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.","new","Long text!!"]
["Verdict","Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."]
["VIN of Tested Car",{"$f":"SPECS!B18","v":0}]
["Mass",{"$f":"SPECS!B26","v":0}]
["Engine Size",{"$f":"SPECS!B22","v":0}]
["Engine Power",{"$f":"SPECS!B23","v":0}]
["Torque",{"$f":"SPECS!B24","v":0}]
["Tyres",{"$f":"SPECS!B25","v":0}]
["Published CO2",{"$f":"SPECS!B13","v":0}]
["Rating Validity",{"$f":"SPECS!B18","v":0}]
["Consumption type (l - kg - kW)",{"$f":"IF(OR(Petrol,Diesel),\"l\",IF(OR(Hydrogen,CNG_Mono),\"kg\",IF(Electric,\"kW\",\"???\")))","v":"l"}]
["Consumption per","100km"]
["Primary fuel source",{"$f":"IF(OR(Petrol,Petrol_PHEV),\"Petrol\",IF(OR(Diesel,Diesel_PHEV),\"Diesel\",IF(Hydrogen,\"Hydrogen Fuel Cell\",IF(CNG_Mono,\"CNG\",IF(Electric,\"Electric\",IF(CNG_Dual,\"CNG\",\"???\"))))))","v":"Petrol"}]
["Secondary fuel source",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"Electric\",IF(CNG_Dual,\"Petrol\",\"\"))","v":""}]
["Published Range",{"$f":"SPECS!B14","v":0}]
["Primary fuel consumption units",{"$f":"IF(OR(Petrol,Diesel,Petrol_PHEV,Diesel_PHEV),\"l/100km\",IF(OR(CNG_Dual,CNG_Mono,Hydrogen),\"kg/100km\",IF(Electric,\"kWh/100km\")))","v":"l/100km"}]
["Secondary fuel consumption units",{"$f":"IF(OR(Petrol_PHEV,Diesel_PHEV),\"kWh/100km\",IF(CNG_Dual,\"l/100km\",\"\"))","v":""}]
["Single/Dual Fuel source",{"$f":"IF(OR(Petrol,Diesel,CNG_Mono,Hydrogen,Electric),\"Single\",IF(OR(Petrol_PHEV,Diesel_PHEV,CNG_Dual),\"Dual\",\"?????\"))","v":"Single"}]
["Battery capacity",{"$f":"SPECS!B12","v":0}]
["Drivetrain",{"$f":"SPECS!B5","v":0}]
["Short_Variant"]