{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["OVERALL RATING (avg)","SPECS","RESULTS","Clean Air","Efficiency","Greenhouse","LIMITS Clean Air","LIMITS Efficiency","LIMITS Greenhouse","WEBSITE SUMMARY","Track Changes"],"not_rendered":{"charts":1,"images":23,"macros":1,"external_links":0,"defined_names":17,"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 (avg)","index":0,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":false,"merged":[[64,2,64,4],[64,5,64,7],[65,5,65,6],[66,5,66,6],[67,5,67,6],[63,5,63,6],[58,5,58,6],[59,5,59,6],[60,2,60,4],[60,5,60,7],[61,5,61,6],[62,5,62,6],[57,5,57,6],[57,12,57,15],[50,2,50,7],[51,3,51,4],[51,5,51,7],[52,6,52,7],[53,3,53,4],[53,5,53,7],[55,3,55,4],[55,5,55,7],[56,2,56,4],[56,5,56,7],[56,12,56,15],[45,2,45,3],[45,4,45,5],[45,6,45,7],[46,2,46,3],[46,4,46,5],[46,6,46,7],[43,2,43,3],[43,4,43,5],[43,6,43,7],[44,2,44,3],[44,4,44,5],[44,6,44,7],[24,2,24,3],[24,4,24,5],[24,6,24,7],[25,2,25,7],[42,2,42,3],[42,4,42,5],[42,6,42,7],[22,2,22,3],[22,4,22,5],[22,6,22,7],[23,2,23,3],[23,4,23,5],[23,6,23,7],[8,1,12,1],[10,18,10,23],[14,1,17,1],[21,2,21,3],[21,4,21,5],[21,6,21,7],[7,2,7,3],[7,4,7,5],[7,6,7,7],[2,1,3,1],[2,2,3,2],[6,2,6,3],[6,4,6,5],[6,6,6,7],[68,2,68,4],[68,5,68,7],[69,5,69,6],[70,5,70,6],[71,5,71,6]]}
[]
[]
[null,{"$f":"CONCATENATE(D52,\" \",F52)","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,"Standard Testing",{"$f":"'Clean Air'!B6","v":"WLTC+ warm engine"},{"$f":"'Clean Air'!F14","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C12","v":"WLTC+ warm engine"},{"$f":"SUM(Efficiency!F12:F14)","v":{"$error":"#NAME?"}},{"$f":"Greenhouse!B24","v":"WLTC+ warm engine"},{"$f":"Greenhouse!F32","v":{"$error":"#NAME?"}}]
[null,null,{"$f":"'Clean Air'!B15","v":"WLTC+ cold engine (23°C)"},{"$f":"'Clean Air'!F23","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C10","v":"WLTC+ cold engine (23°C)"},{"$f":"Efficiency!F10","v":{"$error":"#NAME?"}},{"$f":"Greenhouse!B6","v":"WLTC+ cold engine (23°C)"},{"$f":"Greenhouse!F14","v":{"$error":"#NAME?"}}]
[null,null,{"$f":"'Clean Air'!B24","v":"BAB130 Motorway"},{"$f":"'Clean Air'!F32","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C15","v":"BAB130 Motorway"},{"$f":"Efficiency!F15","v":{"$error":"#NAME?"}},{"$f":"Greenhouse!B54","v":"BAB130 Motorway"},{"$f":"Greenhouse!F62","v":{"$error":"#NAME?"}}]
[null,null,{"$f":"'Clean Air'!B34","v":"PEMS+ cold engine 1"},{"$f":"'Clean Air'!F42","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C13","v":"PEMS+ cold engine 1"},{"$f":"IF(Efficiency!F13=0,\"-\",Efficiency!F13)","v":"-"},{"$f":"Greenhouse!B34","v":"PEMS+ cold engine 1"},{"$f":"IF(Greenhouse!D34=0,\"-\",Greenhouse!F42)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$52","v":"Short trip / cold start 1"},{"$f":"'Clean Air'!F59","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C18","v":"Short trip / cold start 1"},{"$f":"IF(Efficiency!F14=0,\"-\",Efficiency!F14)","v":"-"},{"$f":"Greenhouse!B81","v":"Short trip / cold start 1"},{"$f":"IF(Greenhouse!D81=0,\"-\",Greenhouse!F89)","v":"-"}]
[null,"Eligible for \nadditional robustness testing?",null,null,{"$f":"IF(AND(AVERAGE('Clean Air'!E102,Efficiency!F29,Greenhouse!F93)>='LIMITS Clean Air'!P20,MIN(Greenhouse!F93,Efficiency!F29,'Clean Air'!E102)>='LIMITS Clean Air'!P24),\"YES\",\"NO\")","v":{"$error":"#NAME?"}}]
[null,"Additional Robustness Testing",{"$f":"'Clean Air'!B62","v":"WLTC+ CAT (-7°C)"},{"$f":"IF(E14=\"YES\",'Clean Air'!F70,0)","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C11","v":"WLTC+ CAT (-7°C)"},{"$f":"IF(E14=\"YES\",Efficiency!F11,0)","v":{"$error":"#NAME?"}},{"$f":"Greenhouse!B15","v":"WLTC+ CAT (-7°C)"},{"$f":"IF(E14=\"YES\",Greenhouse!F23,0)","v":{"$error":"#NAME?"}}]
[null,null,{"$f":"'Clean Air'!$B$71","v":"PEMS+ Eco / light"},{"$f":"IF(E14=\"YES\",'Clean Air'!F79,0)","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C16","v":"PEMS+ Eco / light"},{"$f":"IF(Efficiency!F16=0,\"-\",Efficiency!F16)","v":"-"},{"$f":"Greenhouse!B63","v":"PEMS+ Eco / light"},{"$f":"IF(Greenhouse!D63=0,\"-\",Greenhouse!F71)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$80","v":"PEMS+ Heavy load"},{"$f":"IF(E14=\"YES\",'Clean Air'!F88,0)","v":{"$error":"#NAME?"}},{"$f":"Efficiency!C17","v":"PEMS+ Heavy load"},{"$f":"IF(Efficiency!F17=0,\"-\",Efficiency!F17)","v":"-"},{"$f":"Greenhouse!B72","v":"PEMS+ Heavy load"},{"$f":"IF(Greenhouse!D72=0,\"-\",Greenhouse!F80)","v":"-"}]
[null,null,{"$f":"'Clean Air'!$B$89","v":"PEMS Congestion"},{"$f":"IF(E14=\"YES\",'Clean Air'!F98,0)","v":{"$error":"#NAME?"}}]
[null,"not used",{"$f":"'Clean Air'!B43","v":"PEMS+ cold engine 2"},{"$f":"'Clean Air'!F51","v":0},{"$f":"Efficiency!C14","v":"PEMS+ cold engine 2"},{"$f":"IF(Efficiency!F14=0,\"-\",Efficiency!F14)","v":"-"},{"$f":"Greenhouse!$B$43","v":"PEMS+ cold engine 2"},{"$f":"IF(Greenhouse!D43=0,\"-\",Greenhouse!F51)","v":"-"}]
[null,null,null,null,"Driving Range ","-"]
[null,null,null,null,"Driving Resistance ",{"$f":"IF(Efficiency!E60=0,\"-\",Efficiency!F63)","v":"-"}]
[null,"Total Score",{"$f":"'Clean Air'!E101+'Clean Air'!E105","v":{"$error":"#NAME?"}},null,{"$f":"Efficiency!E32","v":{"$error":"#NAME?"}},null,{"$f":"Greenhouse!E95","v":{"$error":"#NAME?"}}]
[null,"Max Points Available",{"$f":"IF(E14=\"YES\",'Clean Air'!D105+'Clean Air'!D101,'Clean Air'!D101)","v":{"$error":"#NAME?"}},null,{"$f":"IF(E14=\"YES\",Efficiency!D32,Efficiency!D29)","v":{"$error":"#NAME?"}},null,{"$f":"IF(E14=\"YES\",Greenhouse!D95,Greenhouse!D93)","v":{"$error":"#NAME?"}},null,null,"CA",{"$f":"IF(AND(E14=\"YES\",ROUNDDOWN((C24*C25+E25*E24+G25*G24)/100,1)<5),'Clean Air'!E102,$C$24)","v":{"$error":"#NAME?"}}]
[null,"Index",{"$f":"ROUNDDOWN(10*C22/C23,1)","v":{"$error":"#NAME?"}},null,{"$f":"ROUNDDOWN(10*E22/E23,1)","v":{"$error":"#NAME?"}},null,{"$f":"ROUNDDOWN(10*G22/G23,1)","v":{"$error":"#NAME?"}},null,null,"EE",{"$f":"IF(AND(E14=\"YES\",ROUNDDOWN((C24*C25+E25*E24+G25*G24)/100,1)<5),Efficiency!F29,$E$24)","v":{"$error":"#NAME?"}}]
[null,"Weighting Factors",{"$f":"100/3","v":33.333333333333336},null,{"$f":"100/3","v":33.333333333333336},null,{"$f":"100/3","v":33.333333333333336},null,null,"GHG",{"$f":"IF(AND(E14=\"YES\",ROUNDDOWN((C24*C25+E25*E24+G25*G24)/100,1)<5),Greenhouse!F93,$G$24)","v":{"$error":"#NAME?"}}]
[null,"Weighted Overall Index",{"$f":"IF(AND(E14=\"YES\",ROUNDDOWN((C24*C25+E25*E24+G25*G24)/100,1)<5),5,ROUNDDOWN((C24*C25+E25*E24+G25*G24)/100,1))","v":{"$error":"#NAME?"}},null,null,null,null,null,{"$f":"ROUNDDOWN((C24*C25+E25*E24+G25*G24)/100,1)","v":{"$error":"#NAME?"}},{"$f":"ROUND(MAX(IF(C26>=F29:F38,E29:E38)),1)","v":{"$error":"#NAME?"}}]
[]
[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$24:$H$24>=C43:H43),1,0)","v":{"$error":"#NAME?"}}]
[null,null,7,null,6,null,{"$f":"G43-1","v":3},null,null,null,null,{"$f":"IF(AND($C$24:$H$24>=C44:H44),1,0)","v":{"$error":"#NAME?"}}]
[null,null,5,null,4.5,null,{"$f":"G44-1","v":2},null,null,null,null,{"$f":"IF(AND($C$24:$H$24>=C45:H45),1,0)","v":{"$error":"#NAME?"}}]
[null,null,3,null,3,null,1,null,null,null,null,{"$f":"IF(AND($C$24:$H$24>=C46:H46),1,0)","v":{"$error":"#NAME?"}}]
[null,null,1,null,1.5,null,0,null,null,null,null,{"$f":"IF(AND($C$24:$H$24>=C47:H47),1,0)","v":{"$error":"#NAME?"}}]
[]
[null,"1): test not operational yet",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L43:L47)","v":{"$error":"#NAME?"}}]
[]
[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!B29=0,\"-\",SPECS!B29)","v":"-"}," cc",{"$f":"IF(SPECS!B30=0,\"-\",SPECS!B30)","v":"-"}," kW"]
[null,null,"Applies to VIN:",{"$f":"IF(SPECS!B26=0,\"-\",SPECS!B26)","v":"-"}]
[null,null,"Powerunit(s)",{"$f":"IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",IF(CNG_Dual,\"CNG-Bivalent\",IF(CNG_Mono,\"CNG\",IF(Hydrogen,\"FCEV\",IF(Electric,\"Battery Electric\"))))))","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!B33","v":0}]
[null,null,"Average Energy Use (Warm Test, Cold Test, Highway)",null,null,"Average Driving Range (Warm Test, Cold Test, Highway)"]
[null,null,"liquid fuel ",{"$f":"IF(Efficiency!M$32>0,Efficiency!M$32,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(Efficiency!M$52>0,Efficiency!M$52,\"n.a.\")","v":"n.a."},null,"km"]
[null,null," gaseous fuel ",{"$f":"IF(Efficiency!S$32>0,Efficiency!S$32,\"n.a.\")","v":"n.a."},"kg/100km",{"$f":"IF(Efficiency!S$52>0,Efficiency!S$52,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"electric energy",{"$f":"IF(Efficiency!P$32>0,Efficiency!P$32,\"n.a.\")","v":"n.a."},"kWh/100km",{"$f":"IF(Efficiency!P$52>0,Efficiency!P$52,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"Warm Test (Lab) Energy Use ",null,null,"Warm Test (Lab) Driving range"]
[null,null,"liquid fuel ",{"$f":"IF(Efficiency!M$33>0,Efficiency!M$33,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(Efficiency!M$53>0,Efficiency!M$53,\"n.a.\")","v":"n.a."},null,"km"]
[null,null," gaseous fuel ",{"$f":"IF(Efficiency!S$33>0,Efficiency!S$33,\"n.a.\")","v":"n.a."},"kg/100km",{"$f":"IF(Efficiency!S$53>0,Efficiency!S$53,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"electric energy",{"$f":"IF(Efficiency!P$33>0,Efficiency!P$33,\"n.a.\")","v":"n.a."},"kWh/100km",{"$f":"IF(Efficiency!P$53>0,Efficiency!P$53,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"Highway Energy Use",null,null,"Highway Energy Use Driving Range"]
[null,null,"liquid fuel ",{"$f":"IF(Efficiency!M$34>0,Efficiency!M$34,\"n.a.\")","v":"n.a."},"l/100km",{"$f":"IF(Efficiency!M$54>0,Efficiency!M$54,\"n.a.\")","v":"n.a."},null,"km"]
[null,null," gaseous fuel ",{"$f":"IF(Efficiency!S$34>0,Efficiency!S$34,\"n.a.\")","v":"n.a."},"kg/100km",{"$f":"IF(Efficiency!S$54>0,Efficiency!S$54,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"electric energy",{"$f":"IF(Efficiency!P$34>0,Efficiency!P$34,\"n.a.\")","v":"n.a."},"kWh/100km",{"$f":"IF(Efficiency!P$54>0,Efficiency!P$54,\"n.a.\")","v":"n.a."},null,"km"]
[null,null,"Cold Ambient Test (-7°C) Energy Use",null,null,"Cold Ambient Test (-7°C) Driving Range"]
[null,null,"liquid fuel ",{"$f":"IF(AND($E$14=\"YES\",Efficiency!M$35>0),Efficiency!M$35,\"n.a.\")","v":{"$error":"#NAME?"}},"l/100km",{"$f":"IF(AND($E$14=\"YES\",Efficiency!M$55>0),Efficiency!M$55,\"n.a.\")","v":{"$error":"#NAME?"}},null,"km"]
[null,null," gaseous fuel ",{"$f":"IF(AND($E$14=\"YES\",Efficiency!S$35>0),Efficiency!S$35,\"n.a.\")","v":{"$error":"#NAME?"}},"kg/100km",{"$f":"IF(AND($E$14=\"YES\",Efficiency!S$55>0),Efficiency!S$55,\"n.a.\")","v":{"$error":"#NAME?"}},null,"km"]
[null,null,"electric energy",{"$f":"IF(AND($E$14=\"YES\",Efficiency!P$35>0),Efficiency!P$35,\"n.a.\")","v":{"$error":"#NAME?"}},"kWh/100km",{"$f":"IF(AND($E$14=\"YES\",Efficiency!P$55>0),Efficiency!P$55,\"n.a.\")","v":{"$error":"#NAME?"}},null,"km"]

{"sheet":"SPECS","index":1,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Brand",null,"CoC p.0.1. (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,"Rating Sheet Version","Euro 6b",1]
["Model",null,"CoC p.0.2.1. (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,"2023.2.0.8.7","Euro 6c"]
["Variant Name",null,"Model data (e.g. V250d, 9G-Tronic, Avantgarde)",null,null,null,null,null,null,null,null,"ICE - CNG - Mono",{"$f":"IF(ICE_Type=3,TRUE,FALSE)","v":false},null,"Protocols","Euro 6d-Temp"]
["Green NCAP Test Reference Number",null,"(e.g. 20-FOR-0023)",null,null,null,null,"SELECT",null,null,null,"ICE - CNG - Dual",{"$f":"IF(ICE_Type=4,TRUE,FALSE)","v":false},null,2022,"Euro 6d"]
["Drivetrain",null,"CoC p.3. (e.g. RWD)",null,null,null,null,null,null,null,null,"Hydrogen",{"$f":"IF(ICE_Type=6,TRUE,FALSE)","v":false},null,null,"Euro AX"]
["Fuel Type",{"$f":"IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",IF(E_85,\"Ethanol E85\",IF(CNG_Dual,\"CNG\",IF(CNG_Mono,\"CNG\",IF(Hydrogen,\"Hydrogen\",IF(Electric,\"Electric\")))))))","v":"Petrol"},"CoC p.26. (e.g. diesel, bi-fuel)",null,null,null,null,null,null,"Respect Green NCAP's definition of \"Hybrid\".",null,"Battery Electric",{"$f":"IF(ICE_Type=5,TRUE,FALSE)","v":false}]
["Primary fuel source",{"$f":"IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",IF(E_85,\"Ethanol E85\",IF(CNG_Dual,\"CNG\",IF(CNG_Mono,\"CNG\",IF(Hydrogen,\"Hydrogen\",IF(Electric,\"Electric\")))))))","v":"Petrol"},null,null,null,null,null,null,null,null,null,"Ethanol E85",{"$f":"IF(ICE_Type=7,TRUE,FALSE)","v":false},null,null,"Manual"]
["Secondary fuel source (if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Automatic"]
["Fuel tank size liquid fuel [l]",null,"Tech data (e.g. 70 l)",null,null,null,null,null,null,null,null,"Hybrid",false,null,null,"CVT"]
["Fuel tank size gaseous fuel [kg]",null,"Tech data (e.g. 15 kg)"]
["Declared Battery Capacity (usable) [kWh]",null,"Tech data (e.g. 52 kWh)",null,null,null,null,null,null,null,null,null,null,null,null,"RWD"]
["Declared Battery Capacity (installed) [kWh]",null,"Tech data (e.g. 56 kWh)",null,null,null,null,null,null,null,null,null,null,null,null,"FWD"]
["Declared CO2 emissions (WLTP) [g/km]",null,"CoC p.49.4. (e.g. 132 g/km)",null,null,null,null,null,null,null,null,null,null,null,null,"AWD"]
["Declared Fuel Consumption (WLTP) [l(kg)/100km]",null,"CoC p.49.4. (e.g. 6.2 l/100km)",null,null,null,null,null,null,null,null,null,null,null,null,"4x4"]
["Declared Fuel Consumption 2nd fuel source (WLTP) [l(kg)/100km]",null,"CoC p.49.4. (e.g. 6.2 l/100km)"]
["Declared Electric Energy Consumption (for BEV) [kWh/100km]",null,"CoC p.49.5.1 (e.g. 19.5 kWh/100km)"]
["Declared Electric Range (for BEV) [km]",null,"CoC p.49.5.1 (e.g. 400 km)"]
["Declared Electric Range City (for BEV) [km]",null,"CoC p.49.5.1 (e.g. 480 km)",null,null,null,null,null,null,null,null,null,null,null,null,"Waste heat"]
["Declared Electric Energy Consumption (for PHEV) [kWh/100km]",null,"CoC p.49.5.2 (e.g. 13.9 kWh/100km)",null,null,null,null,null,null,null,null,null,null,null,null,"PTC"]
["Declared Electric Range (EAER, for PHEV) [km]",null,"CoC p.49.5.2 (e.g. 50 km)",null,null,null,null,null,null,null,null,null,null,null,null,"Heat pump"]
["Declared Electric Range City (for PHEV) [km]",null,"CoC p.49.5.2 (e.g. 61 km)",null,null,null,null,null,null,null,null,null,null,null,null,"Waste heat & PTC"]
["Heating concept",null,"Tech data",null,null,null,null,null,null,null,null,null,null,null,null,"Waste heat & Heat pump"]
["Gearbox type",null,"CoC p.48. (e.g. automatic)",null,null,null,null,null,null,null,null,null,null,null,null,"Waste heat & PTC & Heat pump"]
["Chassis Version","AE","CoC p.38. (check list H24:H30) check https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX:32011R0678)",null,null,null,null,null,null,null,null,null,null,null,null,"PTC & Heat pump"]
["Number of doors",null,"CoC p.41. (e.g. 5 doors)",null,null,null,null,"AA","Saloon"]
["VIN tested vehicle",null,"CoC p.0.10. (e.g. WDF44781313651756)",null,null,null,null,"AB","Hatchback"]
["Emissions class",null,"CoC p.47. (e.g. Euro 6d AP)",null,null,null,null,"AC","Station wagon",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AJ"]
["Engine code",null,"CoC p.21. (e.g. BS654T)",null,null,null,null,"AD","Coupe",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AK"]
["Engine capacity [cm3]",null,"CoC p.25. (e.g. 1950 cm3)",null,null,null,null,"AE","Convertible",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AL"]
["Engine/System Power [kW]",null,"CoC p.27. (e.g. 140 kW, for HEV/PHEV see tech data)",null,null,null,null,"AF","Multi-purpose vehicle",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AM"]
["Engine/System Torque [Nm]",null,"See tech data (e.g. 250 Nm)",null,null,null,null,"AG","Truck station wagon",null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AN"]
["Tyre size (front and rear if different)",null,"For the actual vehicle (e.g. 245/45 255/30 R19)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AO"]
["Actual Vehicle Mass [kg] = CoC 13.2 - 75 kg",null,"Calculate: CoC p.13.2 - 75 kg (e.g. 1550 kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AP"]
["Start of Production",null,"if available, DD/MM/YYYY, should be before \"End of Production\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d AQ"]
["End of Production",null,"if available, DD/MM/YYYY, should be after \"Start of Production\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6 AX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6 AY"]
["Measured Recharged Electric Energy (BEV and PHEV, from grid) [kWh]",{"$f":"RESULTS!AA4","v":0},"Don't enter here. Will be taken from Results AA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6 AZ"]
["Measured Netto Battery Capacity (BEV and PHEV) [kWh]",{"$f":"RESULTS!AB4","v":0},"Don't enter here. Will be taken from Results AB4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp AG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp AH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp AI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp BG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp BH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp BI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp CG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp CH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp CI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro 6d-Temp DG"]

{"sheet":"RESULTS","index":2,"n_rows":44,"n_cols":30,"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 from Grid","Fuel consumpt.","Energy consumpt.","Gas Consumption","Board Comp.\n fuel consumpt.","Board Comp.\n energy consumpt.","Board Comp.\ngas consumpt.","Driving Range\n(ICE mode)","Driving Range\n(electr. mode)","Measured Recharged Electric Energy (BEV and PHEV, from grid) ","Measured Netto Battery Capacity","Efiiciency grid to battery output","Electr. energy consumpt. from battery"]
[null,null,null,null,"g/km","g/km","mg/km","mg/km","mg/km","mg/km","#/km","mg/km","mg/km","mg/km","mg/km","mg/km","l/100km","kWh/100km","g/s","Wh/s","kg/100km","l/100km","kWh/100km","kg/100km","km","km","kWh","kWh","%","kWh/100km"]
[null,"Laboratory Tests","WLTC+ appr.","WLTC+ cold engine (23°C)"]
[null,null,null,"WLTC+ cold engine 2 (not rated)"]
[null,null,null,"WLTC+ cold engine average (not rated)"]
[null,null,null,"WLTC+ CAT (-7°C)"]
[null,null,"Robustness","WLTC+ warm engine"]
[null,null,null,"WLTC+ reg. warm engn. rep. (not rated)"]
[null,null,null,"BAB130 Motorway"]
[null,"Real-World tests","Approval","PEMS+ cold engine 1",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,null,"PEMS+ cold engine 2",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,"Short urban trip","Short trip / cold start 1",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,null,"Short trip / cold start 2",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,"Robustness","PEMS+ Eco / light",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,null,"PEMS+ Heavy load",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a."]
[null,null,null,null,"g/s ↓","g/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","mg/s ↓","#/s ↓",null,"mg/s ↓",null,"mg/s ↓",null,null,"Wh/s ↓",null,null,null,null,null,null,null,null,null,null,null,"Wh/s ↓"]
[null,null,null,"Congestion MAX value",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a.",null,null,null,null,null,null,null,"n.a."]
[null,null,null,"Congestion AVG value",null,"n.a.",null,null,null,null,null,"n.a.","n.a.","n.a.","n.a.","n.a.","n.a.",null,null,null,null,null,null,null,"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 from Grid","Fuel consumpt.","Energy consumpt.","Gas Consumption","Board Comp.\n fuel consumpt.","Board Comp.\n energy consumpt.","Board Comp.\ngas consumpt.","Driving Range\n(ICE mode)","Driving Range\n(electr. mode)",null,null,null,"Electr. energy consumpt. from battery"]
[null,null,null,null,"g/km","g/km","mg/km","mg/km","mg/km","mg/km","#/km","mg/km","mg/km","mg/km","mg/km","mg/km","l/100km","kWh/100km","g/s","Wh/s","kg/100km","l/100km","kWh/100km","kg/100km","km","km",null,null,null,"kWh/100km"]
[null,"Laboratory Tests","WLTC+ appr.",{"$f":"D4","v":"WLTC+ cold engine (23°C)"}]
[null,null,null,{"$f":"D5","v":"WLTC+ cold engine 2 (not rated)"}]
[null,null,null,"WLTC+ cold engine average (not rated)"]
[null,null,null,"WLTC+ CAT (-7°C)"]
[null,null,"Robustness","WLTC+ warm engine"]
[null,null,null,"WLTC+ reg. warm engn. rep. (not rated)"]
[null,null,null,"BAB130 Motorway"]
[null,"Real-World tests","Approval","PEMS+ cold engine 1"]
[null,null,null,"PEMS+ cold engine 2"]
[null,null,"Short urban trip","Short trip / cold start 1"]
[null,null,null,"Short trip / cold start 2"]
[null,null,"Robustness","PEMS+ Eco / light"]
[null,null,null,"PEMS+ Heavy load"]
[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,"Wh/s ↓",null,null,null,null,null,null,null,null,null,null,null,"Wh/s ↓"]
[null,null,null,{"$f":"D18","v":"Congestion MAX value"}]
[null,null,null,{"$f":"D19","v":"Congestion AVG value"}]
[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":"Clean Air","index":3,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":false,"merged":[[104,7,104,9],[4,1,4,3],[60,1,60,3],[102,0,109,0],[111,0,114,0],[115,0,117,0],[119,0,127,0],[103,1,103,2],[32,0,40,0],[53,0,78,0],[42,0,51,0],[78,1,78,2],[99,1,99,2],[90,0,97,0],[101,1,101,2],[105,1,105,2],[79,11,86,11],[70,11,77,11],[87,1,87,2],[97,1,97,2],[1,10,2,10],[1,8,3,8],[22,1,22,2],[1,6,2,7],[1,4,2,5],[1,1,2,2],[3,1,3,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"1. Clean Air Index",null,null,"Test Results",null,"Thresholds",null,"Max score",null,"Fall Back Fuel"]
[]
[null,null,null,null,"Value","Points","Lower","Upper",null,null,"Value"]
[null,"Standard"]
[null,{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"max points",10]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$8-RESULTS!$P$8","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E7,G7,H7,I7,0,Slide_Type),Sliding_Scale(E7,G7,H7,I7,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$20","v":0.5},{"$f":"'LIMITS Clean Air'!$D$6","v":58},2]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I8,IF(E8=0,Sliding_Scale(E8,G8,H8,I8,0,Slide_Type),IF(K8/E8>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E8,G8,H8,I8,0,Slide_Type),Sliding_Scale(E8,G8,H8,I8,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$21","v":0.5},{"$f":"'LIMITS Clean Air'!$D$7","v":60},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I9,IF(E9=0,Sliding_Scale(E9,G9,H9,I9,0,Slide_Type),IF(K9/E9>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E9,G9,H9,I9,0,Slide_Type),Sliding_Scale(E9,G9,H9,I9,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$D$8","v":20},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I10,IF(E10=0,Sliding_Scale(E10,G10,H10,I10,0,Slide_Type),IF(K10/E10>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E10,G10,H10,I10,0,Slide_Type),Sliding_Scale(E10,G10,H10,I10,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$D$9","v":10},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!G8","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E11,G11,H11,I11,0,Slide_Type),Sliding_Scale(E11,G11,H11,I11,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$24","v":5},{"$f":"'LIMITS Clean Air'!$D$10","v":500},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$8","v":0},{"$f":"IF(OR(Hydrogen,Electric),I12,IF(E12=0,Sliding_Scale(E12,G12,H12,I12,0,Slide_Type),IF(K12/E12>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E12,G12,H12,I12,0,Slide_Type),Sliding_Scale(E12,G12,H12,I12,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$25","v":0},{"$f":"'LIMITS Clean Air'!$D$11","v":4.5},0]
[null,{"$f":"IF(E13=0,0,LOG10(E13))","v":0},"PN23","#/km",{"$f":"RESULTS!K8","v":0},{"$f":"Sliding_Scale(B13,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!I13,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$26","v":100000000},{"$f":"'LIMITS Clean Air'!$D$12","v":600000000000},3]
[null,"total",null,null,null,{"$f":"IF(OR(E7:E9>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!E11:E13>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!F7:F13),0))","v":{"$error":"#NAME?"}}]
[null,{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"max points",{"$f":"SUM(I16:I22)","v":10},null,null,null,null,null,null,null,null,1,{"$f":"LOG10(M15)","v":0},{"$f":"Sliding_Scale(N15,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O4-RESULTS!$P4","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E16,G16,H16,I16,0,Slide_Type),Sliding_Scale(E16,G16,H16,I16,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$20","v":0.5},{"$f":"'LIMITS Clean Air'!$D$6","v":58},2,null,{"$f":"RESULTS!$O$26","v":0},null,10,{"$f":"LOG10(M16)","v":1},{"$f":"Sliding_Scale(N16,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NOx ","mg/km",{"$f":"RESULTS!$H$4","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E17,G17,H17,I17,0,Slide_Type),Sliding_Scale(E17,G17,H17,I17,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$21","v":0.5},{"$f":"'LIMITS Clean Air'!$D$7","v":60},3,null,{"$f":"RESULTS!$H$26","v":0},null,{"$f":"M16*10","v":100},2,{"$f":"Sliding_Scale(N17,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$4","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E18,G18,H18,I18,0,Slide_Type),Sliding_Scale(E18,G18,H18,I18,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$D$8","v":20},0,null,{"$f":"RESULTS!$M$26","v":0},null,{"$f":"M17*10","v":1000},3,{"$f":"Sliding_Scale(N18,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$4","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E19,G19,H19,I19,0,Slide_Type),Sliding_Scale(E19,G19,H19,I19,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$D$9","v":10},1,null,{"$f":"RESULTS!$N$26","v":0},null,10000,4,{"$f":"Sliding_Scale(N19,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$4","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E20,G20,H20,I20,0,Slide_Type),Sliding_Scale(E20,G20,H20,I20,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$24","v":5},{"$f":"'LIMITS Clean Air'!$D$10","v":500},1,null,{"$f":"RESULTS!$G$26","v":0},null,100000,5,{"$f":"Sliding_Scale(N20,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$4","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E21,G21,H21,I21,0,Slide_Type),Sliding_Scale(E21,G21,H21,I21,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$25","v":0},{"$f":"'LIMITS Clean Air'!$D$11","v":4.5},0,null,{"$f":"RESULTS!$L$26","v":0},null,1000000,6,{"$f":"Sliding_Scale(N21,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,{"$f":"IF(E22=0,0,LOG10(E22))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$4","v":0},{"$f":"Sliding_Scale(B22,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!I22,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$26","v":100000000},{"$f":"'LIMITS Clean Air'!$D$12","v":600000000000},3,null,{"$f":"RESULTS!$K$26","v":0},null,10000000,7,{"$f":"Sliding_Scale(N22,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,"total",null,null,null,{"$f":"IF(OR(E16:E18>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!E20:E22>'LIMITS Clean Air'!$E$10:$E$12,K16:K18>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!K20:K22>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!F16:F22),0))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,100000000,8,{"$f":"Sliding_Scale(N23,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"max points",{"$f":"SUM(I25:I31)","v":10},null,null,null,null,null,null,null,null,1000000000,9,{"$f":"Sliding_Scale(N24,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$10-RESULTS!$P$10","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E25,G25,H25,I25,0,Slide_Type),Sliding_Scale(E25,G25,H25,I25,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$20","v":0.5},{"$f":"'LIMITS Clean Air'!$D$6","v":58},2,null,{"$f":"RESULTS!$O$32","v":0},null,10000000000,10,{"$f":"Sliding_Scale(N25,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$10","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E26,G26,H26,I26,0,Slide_Type),Sliding_Scale(E26,G26,H26,I26,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$21","v":0.5},{"$f":"'LIMITS Clean Air'!$D$7","v":60},3,null,{"$f":"RESULTS!$H$32","v":0},null,100000000000,11,{"$f":"Sliding_Scale(N26,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$10","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E27,G27,H27,I27,0,Slide_Type),Sliding_Scale(E27,G27,H27,I27,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$D$8","v":20},0,null,{"$f":"RESULTS!$M$32","v":0},null,600000000000,11.778151250383644,{"$f":"Sliding_Scale(N27,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$10","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E28,G28,H28,I28,0,Slide_Type),Sliding_Scale(E28,G28,H28,I28,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$D$9","v":10},1,null,{"$f":"RESULTS!$N$32","v":0},null,{"$f":"M26*10","v":1000000000000},12,{"$f":"Sliding_Scale(N28,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,10,0,Slide_Type)","v":{"$error":"#NAME?"}}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$10","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E29,G29,H29,I29,0,Slide_Type),Sliding_Scale(E29,G29,H29,I29,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$24","v":5},{"$f":"'LIMITS Clean Air'!$D$10","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),I30,IF(E30=0,Sliding_Scale(E30,G30,H30,I30,0,Slide_Type),IF(K30/E30>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E30,G30,H30,I30,0,Slide_Type),Sliding_Scale(E30,G30,H30,I30,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$25","v":0},{"$f":"'LIMITS Clean Air'!$D$11","v":4.5},0,null,{"$f":"RESULTS!$L$32","v":0}]
[null,{"$f":"IF(E31=0,0,LOG10(E31))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$10","v":0},{"$f":"Sliding_Scale(B31,'LIMITS Clean Air'!$D$27,'LIMITS Clean Air'!$D$13,'Clean Air'!I31,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$D$26","v":100000000},{"$f":"'LIMITS Clean Air'!$D$12","v":600000000000},3,null,{"$f":"RESULTS!$K$32","v":0}]
[null,"total",null,null,null,{"$f":"IF(OR(E25:E27>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!E29:E31>'LIMITS Clean Air'!$E$10:$E$12,K25:K27>'LIMITS Clean Air'!$E$6:$E$8,'Clean Air'!K29:K31>'LIMITS Clean Air'!$E$10:$E$12),0,MAX(SUM('Clean Air'!F25:F31),0))","v":{"$error":"#NAME?"}}]
[]
[null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"max points",{"$f":"SUM(I36:I41)","v":10}]
[null,null,"NMHC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56}]
[null,null,"NOx","mg/km",{"$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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),Sliding_Scale(E36,G36,H36,I36,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},4,null,{"$f":"RESULTS!H33","v":0}]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0,null,{"$f":"RESULTS!$M$33","v":0}]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E39,G39,H39,I39,0,Slide_Type),Sliding_Scale(E39,G39,H39,I39,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},2,null,{"$f":"RESULTS!$G$33","v":0}]
[null,null,"PM","mg/km"]
[null,{"$f":"IF(E41=0,0,LOG10(E41))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$11","v":0},{"$f":"Sliding_Scale(B41,'LIMITS Clean Air'!$H$27,'LIMITS Clean Air'!$H$13,'Clean Air'!I41,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},4,null,{"$f":"RESULTS!$K$33","v":0}]
[null,"total",null,null,null,{"$f":"IF(OR(E35:E41>'LIMITS Clean Air'!$I$6:$I$12),0,MAX(SUM('Clean Air'!F35:F41),0))","v":{"$error":"#NAME?"}}]
[null,"PEMS+ cold engine 2","max points",{"$f":"SUM(I45:I50)","v":0}]
[null,null,"NMHC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H6,IF(Diesel,'LIMITS Clean Air'!H$6,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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),Sliding_Scale(E45,G45,H45,I45,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H7,IF(Diesel,'LIMITS Clean Air'!H$7,0))","v":79.2},0]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H8,IF(Diesel,'LIMITS Clean Air'!H$8,0))","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H9,IF(Diesel,'LIMITS Clean Air'!H$9,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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E48,G48,H48,I48,0,Slide_Type),Sliding_Scale(E48,G48,H48,I48,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H10,IF(Diesel,'LIMITS Clean Air'!H$10,0))","v":660},0]
[null,null,"PM","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$H$25","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H11,IF(Diesel,'LIMITS Clean Air'!H$11,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":0},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Clean Air'!H12,IF(Diesel,'LIMITS Clean Air'!H$12,0))","v":792000000000},0]
[null,"total"]
[null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"max points",{"$f":"SUM(I53:I58)","v":5}]
[null,null,"NOx","mg/km",{"$f":"RESULTS!H13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I53,IF(F36=0,0,IF(OR($E$53>='LIMITS Clean Air'!$I$7,$E$56>='LIMITS Clean Air'!I7),0,I53-(E53/'LIMITS Clean Air'!$I$7)*I53)))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!D21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},{"$f":"2.25","v":2.25}]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$13","v":0},{"$f":"IF(OR(Hydrogen,Electric),I54,IF(F39=0,0,IF(OR($E$54>'LIMITS Clean Air'!$I$10,$E$57>='LIMITS Clean Air'!$I$10),0,I54-(E54/'LIMITS Clean Air'!$I$10)*I54)))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!D24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},{"$f":"0.5","v":0.5}]
[null,{"$f":"IF(E55=0,0,LOG10(E55))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$13","v":0},{"$f":"Sliding_Scale(B55,'LIMITS Clean Air'!$H$27,'LIMITS Clean Air'!$H$13,'Clean Air'!I55,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},{"$f":"2.25","v":2.25}]
[null,"PEMS 8km (2)","NOx","mg/km",{"$f":"RESULTS!H14","v":0},{"$f":"IF(OR(Hydrogen,Electric),I56,IF(F36=0,0,IF(OR($E$53>='LIMITS Clean Air'!$M$7,$E$56>='LIMITS Clean Air'!$M$7),0,I56-(E56/'LIMITS Clean Air'!$M$7)*I56)))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!D21","v":0.5},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),H53,IF(Diesel,'LIMITS Clean Air'!H$7,0))","v":79.2},0]
[null,"(cold start / short trip)","CO","mg/km",{"$f":"RESULTS!$G$14","v":0},{"$f":"IF(OR(Hydrogen,Electric),I57,IF(F39=0,0,IF(OR($E$54>='LIMITS Clean Air'!$M$10,$E$57>='LIMITS Clean Air'!$M$10),0,I57-(E57/'LIMITS Clean Air'!$M$10)*I57)))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!D24","v":5},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),H54,IF(Diesel,'LIMITS Clean Air'!H$10,0))","v":660},0]
[null,{"$f":"IF(E58=0,0,LOG10(E58))","v":0},"PN",null,{"$f":"RESULTS!$K$14","v":0},{"$f":"IF(OR(Hydrogen,Electric),I58,IF(OR($E$55>=$H$55,$E$58>=$H$58),0,I58-(E58/H58)*I58))","v":0},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),H55,IF(Diesel,'LIMITS Clean Air'!H$12,0))","v":792000000000},0]
[null,"total",null,null,null,{"$f":"SUM(F53:F55)","v":{"$error":"#NAME?"}}]
[]
[null,"Additional Robustness"]
[null,{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"max points",{"$f":"SUM(I63:I69)","v":10}]
[null,null,"NMHC","mg/km",{"$f":"RESULTS!$O$7-RESULTS!$P$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I63,IF(E63=0,Sliding_Scale(E63,G63,H63,I63,0,Slide_Type),IF(K63/E63>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E63,G63,H63,I63,0,Slide_Type),Sliding_Scale(E63,G63,H63,I63,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},2]
[null,null,"NOx ","mg/km",{"$f":"RESULTS!$H$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I64,IF(E64=0,Sliding_Scale(E64,G64,H64,I64,0,Slide_Type),IF(K64/E64>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E64,G64,H64,I64,0,Slide_Type),Sliding_Scale(E64,G64,H64,I64,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},3]
[null,null,"NO2","mg/km",{"$f":"RESULTS!$J$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I65,IF(E65=0,Sliding_Scale(E65,G65,H65,I65,0,Slide_Type),IF(K65/E65>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E65,G65,H65,I65,0,Slide_Type),Sliding_Scale(E65,G65,H65,I65,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0]
[null,null,"NH3","mg/km",{"$f":"RESULTS!$N$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I66,IF(E66=0,Sliding_Scale(E66,G66,H66,I66,0,Slide_Type),IF(K66/E66>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E66,G66,H66,I66,0,Slide_Type),Sliding_Scale(E66,G66,H66,I66,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},1]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I67,IF(E67=0,Sliding_Scale(E67,G67,H67,I67,0,Slide_Type),IF(K67/E67>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E67,G67,H67,I67,0,Slide_Type),Sliding_Scale(E67,G67,H67,I67,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},1]
[null,null,"PM","mg/km",{"$f":"RESULTS!$L$7","v":0},{"$f":"IF(OR(Hydrogen,Electric),I68,IF(E68=0,Sliding_Scale(E68,G68,H68,I68,0,Slide_Type),IF(K68/E68>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E68,G68,H68,I68,0,Slide_Type),Sliding_Scale(E68,G68,H68,I68,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L$25","v":0},{"$f":"'LIMITS Clean Air'!$H$11","v":5.94},0]
[null,{"$f":"IF(E69=0,0,LOG10(E69))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$7","v":0},{"$f":"Sliding_Scale(B69,'LIMITS Clean Air'!$L$27,'LIMITS Clean Air'!$L$13,'Clean Air'!I69,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$L$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},3]
[null,"total",null,null,null,{"$f":"IF(F101=\"yes\",IF(OR(E63:E65>'LIMITS Clean Air'!$M$6:$M$8,E67:E69>'LIMITS Clean Air'!$M$10:$M$12),0,MAX(SUM('Clean Air'!F63:F69),0)),0)","v":{"$error":"#NAME?"}}]
[null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"max points",{"$f":"SUM(I72:I78)","v":5}]
[null,null,"NMHC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},0]
[null,null,"NOx","mg/km",{"$f":"RESULTS!$H$15","v":0},{"$f":"IF(E73<=E36,I73,IF(E73<'Clean Air'!H36,(0.5*I73),0))","v":2.25},{"$f":"'LIMITS Clean Air'!$H$21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},2.25]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},0]
[null,null,"CO","mg/km",{"$f":"RESULTS!$G$15","v":0},{"$f":"IF(E76<=E39,I76,IF(E76<'Clean Air'!H39,(0.5*I76),0))","v":0.5},{"$f":"'LIMITS Clean Air'!$H$24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},0.5]
[null,null,"PM","mg/km"]
[null,{"$f":"IF(E78=0,0,LOG10(E78))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$15","v":0},{"$f":"Sliding_Scale(B78,'LIMITS Clean Air'!$H$27,'LIMITS Clean Air'!$H$13,'Clean Air'!I78,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},2.25]
[null,null,null,null,null,{"$f":"IF(F101=\"yes\",IF(OR(E72:E78>'LIMITS Clean Air'!$I$6:$I$12),0,MAX(SUM('Clean Air'!F72:F78),0)),0)","v":{"$error":"#NAME?"}}]
[null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"max points",{"$f":"SUM(I81:I87)","v":8}]
[null,null,"NMHC","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$H$20","v":0.5},{"$f":"'LIMITS Clean Air'!$H$6","v":76.56},0]
[null,{"$f":"Sliding_Scale(E82,H36,'LIMITS Clean Air'!M7,I82,0,Slide_Type)","v":{"$error":"#NAME?"}},"NOx","mg/km",{"$f":"RESULTS!$H$16","v":0},{"$f":"IF(OR(Hydrogen,Electric),I82,IF(E82=0,Sliding_Scale(E82,G82,H82,I82,0,Slide_Type),IF(K82/E82>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E82,G82,H82,I82,0,Slide_Type),Sliding_Scale(E82,G82,H82,I82,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!D21","v":0.5},{"$f":"'LIMITS Clean Air'!$H$7","v":79.2},3.6]
[null,null,"NO2","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$22","v":0},{"$f":"'LIMITS Clean Air'!$H$8","v":26.400000000000002},0]
[null,null,"NH3","mg/km",null,null,{"$f":"'LIMITS Clean Air'!$D$23","v":0.1},{"$f":"'LIMITS Clean Air'!$H$9","v":13.200000000000001},0]
[null,{"$f":"Sliding_Scale(E85,H39,'LIMITS Clean Air'!M10,I85,0,Slide_Type)","v":{"$error":"#NAME?"}},"CO","mg/km",{"$f":"RESULTS!$G$16","v":0},{"$f":"IF(OR(Hydrogen,Electric),I85,IF(E85=0,Sliding_Scale(E85,G85,H85,I85,0,Slide_Type),IF(K85/E85>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E85,G85,H85,I85,0,Slide_Type),Sliding_Scale(E85,G85,H85,I85,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!D24","v":5},{"$f":"'LIMITS Clean Air'!$H$10","v":660},0.8]
[null,null,"PM","mg/km"]
[null,{"$f":"IF(E87=0,0,LOG10(E87))","v":0},"PN23","#/km",{"$f":"RESULTS!$K$16","v":0},{"$f":"Sliding_Scale(B87,'LIMITS Clean Air'!$H$27,'LIMITS Clean Air'!$H$13,'Clean Air'!I87,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Clean Air'!$H$26","v":100000000},{"$f":"'LIMITS Clean Air'!$H$12","v":792000000000},3.6]
[null,null,null,null,null,{"$f":"IF(F101=\"yes\",IF(OR(E81:E87>'LIMITS Clean Air'!$I$6:$I$12),0,MAX(SUM('Clean Air'!F81:F87),0)),0)","v":{"$error":"#NAME?"}}]
[null,"PEMS Congestion","max points",{"$f":"SUM(I90:I97)","v":2}]
[null,null,"NMHC","mg/s",null,null,null,null,0]
[null,null,"NOx  AVG","mg/s",{"$f":"RESULTS!$H$19","v":0},{"$f":"IF(E91<H91,I91,0)","v":1},null,{"$f":"'LIMITS Clean Air'!Q7","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'!P7","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,{"$f":"IF(E97=0,0,LOG10(E97))","v":0},"PN23","#/km",null,null,null,null,0]
[null,null,null,null,null,{"$f":"IF(F101=\"yes\",SUM(F91:F97),0)","v":{"$error":"#NAME?"}}]
[]
[null,"Standard Testing Summary",null,"max","score","Stage 2?"]
[null,"Points",null,{"$f":"D52+D43+D24+D15+D6+D34","v":45},{"$f":"F59+F51+F32+F42+F14+F23","v":{"$error":"#NAME?"}},{"$f":"IF(AND(AVERAGE(E102,Efficiency!F29,Greenhouse!F93)>='LIMITS Clean Air'!P20,(MIN(Greenhouse!F93,Efficiency!F29,'Clean Air'!E102)>='LIMITS Clean Air'!P24)),\"YES\",\"NO\")","v":{"$error":"#NAME?"}}]
[null,"Subscore",null,null,{"$f":"ROUNDDOWN(10*(E101/D101),1)","v":{"$error":"#NAME?"}}]
[]
[null,"Additional Robustness Testing Summary",null,"max","score "]
[null,"Points",null,{"$f":"D89+D80+D71+D62","v":25},{"$f":"IF(F101=\"no\",0,F98+F88+F79+F70)","v":{"$error":"#NAME?"}},null,null,"test distribution"]
[null,"Subscore",null,null,{"$f":"ROUNDDOWN(10*(E105/D105),1)","v":{"$error":"#NAME?"}},null,null,"LAB",{"$f":"SUM(D6,D15,D62,D24)","v":40},{"$f":"(I106)/(I107+I106)","v":0.5714285714285714}]
[null,null,null,null,null,null,null,"PEMS",{"$f":"SUM(D89,D80,D71,D43,D34,D52)","v":30},{"$f":"I107/(I106+I107)","v":0.42857142857142855}]
[null,"Total",null,{"$f":"D105+D101","v":70},{"$f":"E105+E101","v":{"$error":"#NAME?"}},null,null,"Phase 1",{"$f":"D101","v":45},{"$f":"(I108)/(I109+I108)","v":0.6428571428571429}]
[null,"TOTAL SCORE CLEAN AIR",null,"(0-10pts)",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",ROUNDDOWN((10*(E105+E101)/(D101+D105)),1),ROUNDDOWN((10*E101/D101),1))","v":{"$error":"#NAME?"}},null,null,"Phase 2",{"$f":"D105","v":25},{"$f":"I109/(I108+I109)","v":0.35714285714285715}]

{"sheet":"Efficiency","index":4,"n_rows":63,"n_cols":29,"rows_kept":63,"cut":false,"hidden":false,"merged":[[32,5,32,6],[24,1,24,2],[3,1,3,2],[1,8,3,8],[1,4,2,5],[1,6,2,7],[18,1,18,2],[20,6,20,7],[21,6,21,7],[23,6,23,7],[28,1,28,2],[29,1,29,2],[1,1,2,3]]}
[]
[null,"2. Energy Efficiency Index",null,null,"Test Results",null,"Thresholds",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,"max points",{"$f":"I19","v":40},"Value","Points","Lower","Upper","Max score"]
[null,"Standard",{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"IF(Petrol,Efficiency!M23*'LIMITS Efficiency'!$C$19,IF(Diesel,Efficiency!M23*'LIMITS Efficiency'!$C$20,IF(E_85,Efficiency!M23*'LIMITS Efficiency'!$C$24,IF(CNG_Mono,S23*'LIMITS Efficiency'!$C$21,IF(Hydrogen,S23*'LIMITS Efficiency'!$C$23,IF(CNG_Dual,S23*'LIMITS Efficiency'!$C$21+Efficiency!M23*'LIMITS Efficiency'!$C$19,0)))))+P23)","v":0},{"$f":"MAX(0,Sliding_Scale(E10,G10,H10,I10,0,Slide_Type))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Efficiency'!E6","v":20},{"$f":"'LIMITS Efficiency'!F6","v":90},10]
[null,"Additional",{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"IF(Petrol,Efficiency!M24*'LIMITS Efficiency'!$C$19,IF(Diesel,Efficiency!M24*'LIMITS Efficiency'!$C$20,IF(E_85,Efficiency!M24*'LIMITS Efficiency'!$C$24,IF(CNG_Mono,S24*'LIMITS Efficiency'!$C$21,IF(Hydrogen,S24*'LIMITS Efficiency'!$C$23,IF(CNG_Dual,S24*'LIMITS Efficiency'!$C$21+Efficiency!M24*'LIMITS Efficiency'!$C$19,0)))))+P24)","v":0},{"$f":"IF(G29=\"yes\",MAX(0,Sliding_Scale(E11,G11,H11,I11,0,Slide_Type)),0)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Efficiency'!E7","v":20},{"$f":"'LIMITS Efficiency'!F7","v":90},10]
[null,"Standard",{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"kWh/100km",{"$f":"IF(Petrol,Efficiency!M25*'LIMITS Efficiency'!$C$19,IF(Diesel,Efficiency!M25*'LIMITS Efficiency'!$C$20,IF(E_85,Efficiency!M25*'LIMITS Efficiency'!$C$24,IF(CNG_Mono,S25*'LIMITS Efficiency'!$C$21,IF(Hydrogen,S25*'LIMITS Efficiency'!$C$23,IF(CNG_Dual,S25*'LIMITS Efficiency'!$C$21+Efficiency!M25*'LIMITS Efficiency'!$C$19,0)))))+P25)","v":0},{"$f":"MAX(0,Sliding_Scale(E12,G12,H12,I12,0,Slide_Type))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Efficiency'!E8","v":20},{"$f":"'LIMITS Efficiency'!F8","v":90},10]
[null,null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!E11","v":20},{"$f":"'LIMITS Efficiency'!F11","v":90},0]
[null,null,{"$f":"RESULTS!D12","v":"PEMS+ cold engine 2"},"kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!E10","v":20},{"$f":"'LIMITS Efficiency'!F10","v":90},0]
[null,"Standard",{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"kWh/100km",{"$f":"IF(Petrol,Efficiency!M28*'LIMITS Efficiency'!$C$19,IF(Diesel,Efficiency!M28*'LIMITS Efficiency'!$C$20,IF(E_85,Efficiency!M28*'LIMITS Efficiency'!$C$24,IF(CNG_Mono,S28*'LIMITS Efficiency'!$C$21,IF(Hydrogen,S28*'LIMITS Efficiency'!$C$23,IF(CNG_Dual,S28*'LIMITS Efficiency'!$C$21+Efficiency!M28*'LIMITS Efficiency'!$C$19,0)))))+P28)","v":0},{"$f":"MAX(0,Sliding_Scale(E15,G15,H15,I15,0,2))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Efficiency'!E12","v":20},{"$f":"'LIMITS Efficiency'!F12","v":90},10]
[null,null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!$E$13","v":20},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0]
[null,null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!$E$13","v":20},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0]
[null,null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"kWh/100km",null,null,{"$f":"'LIMITS Efficiency'!$E$13","v":20},{"$f":"'LIMITS Efficiency'!$F$13","v":90},0]
[null,"total",null,null,null,{"$f":"(SUM(F10:F16))","v":{"$error":"#NAME?"}},null,null,{"$f":"SUM(I10:I16)","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conversion from l/100km or kg/100km to kWh/100km for different energy carriers"]
[null,"2.2","Driving Range (lab test average)",null,"Deviation",null,"Declared Range ",null,null,null,"2.1.2.1",null,null,"2.1.2.2",null,null,"2.1.2.3",null,null,null,"2.1.2.4",null,null,"2.1.2.5",null,null,"2.1.2.6"]
[null,null,null,null,"%",null,"km",null,null,null,"Fuel Consumption (liquid fuel)",null,null,"Energy Consumption (electric energy)",null,null,"Gas Consumption (CNG, Hydrogen)",null,null,null,"Fuel Consumption (liquid fuel)",null,null,"Energy Consumption (electric energy)",null,null,"Gas Consumption (CNG, Hydrogen)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$4,RESULTS!$Q$26),0)","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R4,RESULTS!R26),0)","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U4,RESULTS!U26),0)","v":0},null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"kWh/100km",{"$f":"M23*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"WLTC cold+ (23 degr C)","kWh/100km",{"$f":"P23","v":0},"WLTC cold+ (23 degr C)","kWh/100km",{"$f":"S23*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,null,"BEV","only",{"$f":"IF(AND(M54=0,P54>0),-(G24-P54)/G24,0)","v":0},{"$f":"-(IF(E24>-'LIMITS Efficiency'!E37,0,IF(E24<-'LIMITS Efficiency'!E38,I24,(ABS(E24)-'LIMITS Efficiency'!E37)*I24/('LIMITS Efficiency'!E38-'LIMITS Efficiency'!E37))))","v":0},{"$f":"SPECS!B16","v":0},null,{"$f":"'LIMITS Efficiency'!D38","v":5},null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$7,RESULTS!$Q$29),0)","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R7,RESULTS!R29),0)","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U7,RESULTS!U29),0)","v":0},null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"kWh/100km",{"$f":"M24*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"WLTC cold+ (-7 degr C)","kWh/100km",{"$f":"P24","v":0},"WLTC cold+ (-7 degr C)","kWh/100km",{"$f":"S24*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,"total",null,null,null,{"$f":"SUM(F24:F24)","v":0},null,null,null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$8,RESULTS!$Q$30),0)","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R8,RESULTS!R30),0)","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U8,RESULTS!U30),0)","v":0},null,{"$f":"$C$12","v":"WLTC+ warm engine"},"kWh/100km",{"$f":"M25*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"WLTC+ warm engine","kWh/100km",0,"WLTC+ warm engine","kWh/100km",{"$f":"S25*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$11,RESULTS!$Q$33),0)","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R11,RESULTS!R33),0)","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U11,RESULTS!U33),0)","v":0},null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"kWh/100km",{"$f":"M26*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"PEMS+ cold engine","kWh/100km",0,"PEMS+ cold engine","kWh/100km",{"$f":"S26*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,"SUMMARY",null,"max points","score","sub score","Stage 2?",null,null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$12,RESULTS!$Q$34),0)","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R12,RESULTS!R34),0)","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U12,RESULTS!U34),0)","v":0},null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"kWh/100km",{"$f":"M27*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"PEMS+ cold engine2","kWh/100km",0,"PEMS+ cold engine2","kWh/100km",{"$f":"S27*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$10,RESULTS!$Q$32),0)","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R10,RESULTS!R32),0)","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U10,RESULTS!U32),0)","v":0},null,{"$f":"$C$15","v":"BAB130 Motorway"},"kWh/100km",{"$f":"M28*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"BAB130","kWh/100km",0,"BAB130","kWh/100km",{"$f":"S28*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,"Standard Testing ",null,{"$f":"I10+I15+I12","v":30},{"$f":"F10+F15+F12","v":{"$error":"#NAME?"}},{"$f":"ROUNDDOWN(10*(E29/D29),1)","v":{"$error":"#NAME?"}},{"$f":"IF(AND(AVERAGE(F29,Greenhouse!F93,'Clean Air'!E102)>='LIMITS Clean Air'!P20,MIN('Clean Air'!E102,Efficiency!F29,Greenhouse!F93)>='LIMITS Clean Air'!P24),\"YES\",\"NO\")","v":{"$error":"#NAME?"}},null,null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$15,RESULTS!$Q$37),0)","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R15,RESULTS!R37),0)","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U15,RESULTS!U37),0)","v":0},null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"kWh/100km",{"$f":"M29*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"PEMS light test","kWh/100km",0,"PEMS light test","kWh/100km",{"$f":"S29*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,"Additional Robustness Testing ",null,{"$f":"I11","v":10},{"$f":"IF(G29=\"yes\",F11,0)","v":{"$error":"#NAME?"}},{"$f":"ROUNDDOWN(10*(E30/D30),1)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$16,RESULTS!$Q$38),0)","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R16,RESULTS!R38),0)","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U16,RESULTS!U38),0)","v":0},null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"kWh/100km",{"$f":"M30*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"PEMS heavy test","kWh/100km",0,"PEMS heavy test","kWh/100km",{"$f":"S30*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"l/100km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),MAX(RESULTS!$Q$13,RESULTS!$Q$35),0)","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",{"$f":"IF(Electric,MAX(RESULTS!R13,RESULTS!R35),0)","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"kg/100km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),MAX(RESULTS!U13,RESULTS!U35),0)","v":0},null,{"$f":"$C$18","v":"Short trip / cold start 1"},"kWh/100km",{"$f":"M31*IF(Petrol,'LIMITS Efficiency'!$C$19,IF(Diesel,'LIMITS Efficiency'!$C$20,IF(E_85,'LIMITS Efficiency'!$C$24,IF(CNG_Dual,'LIMITS Efficiency'!$C$19))))","v":0},"PEMS 8 km","kWh/100km",0,"PEMS 8 km","kWh/100km",{"$f":"S31*IF(OR(CNG_Mono,CNG_Dual),'LIMITS Efficiency'!$C$21,IF(Hydrogen,'LIMITS Efficiency'!$C$23,0))","v":0}]
[null,"TOTAL ",null,{"$f":"D29+D30","v":40},{"$f":"E29+E30","v":{"$error":"#NAME?"}},null,null,null,null,null,"Average","l/100km",{"$f":"AVERAGE(M$23,M$25,M$28)","v":0},"Average","kWh/100km",{"$f":"AVERAGE(P$23,P$25,P$28)","v":0},"Average","kg/100km",{"$f":"AVERAGE(S$23,S$25,S$28)","v":0},null,"Average","kWh/100km",{"$f":"AVERAGE(W$23,W$25,W$28)","v":0},"Average","kWh/100km",{"$f":"AVERAGE(Z$23,Z$25,Z$28)","v":0},"Average","kWh/100km",{"$f":"AVERAGE(AC$23,AC$25,AC$28)","v":0}]
[null,"TOTAL SCORE ENERGY EFFICIENCY",null,null,"(0-10pts)",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",ROUNDDOWN((10*(E32/D32)),1),ROUNDDOWN((10*(E29/D29)),1))","v":{"$error":"#NAME?"}},null,null,null,null,"Warm Test (Lab)","l/100km",{"$f":"M25","v":0},"Warm Test (Lab)","kWh/100km",{"$f":"P25","v":0},"Warm Test (Lab)","kg/100km",{"$f":"S25","v":0},null,"Warm Test (Lab)","kWh/100km",{"$f":"W25","v":0},"Warm Test (Lab)","kWh/100km",{"$f":"Z25","v":0},"Warm Test (Lab)","kWh/100km",{"$f":"AC25","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Highway","l/100km",{"$f":"M28","v":0},"Highway","kWh/100km",{"$f":"P28","v":0},"Highway","kg/100km",{"$f":"S28","v":0},null,"Highway","kWh/100km",{"$f":"W28","v":0},"Highway","kWh/100km",{"$f":"Z28","v":0},"Highway","kWh/100km",{"$f":"AC28","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Cold Ambient Test","l/100km",{"$f":"IF(G29=\"yes\",M24,\"-\")","v":{"$error":"#NAME?"}},"Cold Ambient Test","kWh/100km",{"$f":"IF(G29=\"yes\",P24,\"-\")","v":{"$error":"#NAME?"}},"Cold Ambient Test","kg/100km",{"$f":"IF(G29=\"yes\",S24,\"-\")","v":{"$error":"#NAME?"}},null,"Cold Ambient Test","kWh/100km",{"$f":"IF(G29=\"yes\",W24,\"-\")","v":{"$error":"#NAME?"}},"Cold Ambient Test","kWh/100km",{"$f":"IF(G29=\"yes\",Z24,\"-\")","v":{"$error":"#NAME?"}},"Cold Ambient Test","kWh/100km",{"$f":"IF(G29=\"yes\",AC24,\"-\")","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,"Best Case for LCA","l/100km",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",MIN(Efficiency!M23:M26,Efficiency!M28:M30),MIN(Efficiency!M23,Efficiency!M25,Efficiency!M26,Efficiency!M28))","v":{"$error":"#NAME?"}},"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",IF(Electric,MIN(Efficiency!P23:P26,Efficiency!P28),MIN(Efficiency!P23:P26,Efficiency!P28:P30)),MIN(Efficiency!P23,Efficiency!P25,Efficiency!P26,Efficiency!P28))","v":{"$error":"#NAME?"}},"Best Case for LCA","kg/100km",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",MIN(Efficiency!S23:S26,Efficiency!S28:S30),MIN(Efficiency!S23,Efficiency!S25,Efficiency!S26,Efficiency!S28))","v":{"$error":"#NAME?"}},null,"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!O14=\"YES\",MIN(Efficiency!W23:W26,Efficiency!W28:W30),MIN(Efficiency!W23,Efficiency!W25,Efficiency!W26,Efficiency!W28))","v":0},"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!R14=\"YES\",MIN(Efficiency!Z23:Z26,Efficiency!Z28:Z30),MIN(Efficiency!Z23,Efficiency!Z25,Efficiency!Z26,Efficiency!Z28))","v":0},"Best Case for LCA","kWh/100km",{"$f":"IF('OVERALL RATING (avg)'!U14=\"YES\",MIN(Efficiency!AC23:AC26,Efficiency!AC28:AC30),MIN(Efficiency!AC23,Efficiency!AC25,Efficiency!AC26,Efficiency!AC28))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Worst Case for LCA","l/100km",{"$f":"MAX(M23:M26,M28:M30)","v":0},"Worst Case for LCA","kWh/100km",{"$f":"IF(Electric,MAX(P23:P26,P28),MAX(P23:P26,P28:P30))","v":0},"Worst Case for LCA","kg/100km",{"$f":"MAX(S23:S26,S28:S30)","v":0},null,"Worst Case for LCA","kWh/100km",{"$f":"MAX(W23:W26,W28:W30)","v":0},"Worst Case for LCA","kWh/100km",{"$f":"MAX(Z23:Z26,Z28:Z30)","v":0},"Worst Case for LCA","kWh/100km",{"$f":"MAX(AC23:AC26,AC28:AC30)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"2.2.1",null,null,"2.2.2",null,null,"2.2.3"]
[]
[null,null,null,null,null,null,null,null,null,null,"Driving Range (liquid fuel)",null,null,"Driving Range (electric energy)",null,null,"Driving Range (CNG, Hydrogen)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M23>0,100*SPECS!$B$9/M23,0),0)","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",{"$f":"IF(Electric,IF(P23>0,100*SPECS!$B$37/P23,0),0)","v":0},{"$f":"$C$10","v":"WLTC+ cold engine (23°C)"},"km",{"$f":"IF(OR(CNG_Mono,Hydrogen),IF(S23>0,100*SPECS!$B$10/S23,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M24>0,100*SPECS!$B$9/M24,0),0)","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",{"$f":"IF(Electric,IF(P24>0,100*SPECS!$B$37/P24,0),0)","v":0},{"$f":"$C$11","v":"WLTC+ CAT (-7°C)"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S24>0,100*SPECS!$B$10/S24,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$12","v":"WLTC+ warm engine"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M25>0,100*SPECS!$B$9/M25,0),0)","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"km",{"$f":"IF(Electric,IF(P25>0,100*SPECS!$B$37/P25,0),0)","v":0},{"$f":"$C$12","v":"WLTC+ warm engine"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S25>0,100*SPECS!$B$10/S25,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M26>0,100*SPECS!$B$9/M26,0),0)","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",{"$f":"IF(Electric,IF(P26>0,100*SPECS!$B$37/P26,0),0)","v":0},{"$f":"$C$13","v":"PEMS+ cold engine 1"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S26>0,100*SPECS!$B$10/S26,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M27>0,100*SPECS!$B$9/M27,0),0)","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",{"$f":"IF(Electric,IF(P27>0,100*SPECS!$B$37/P27,0),0)","v":0},{"$f":"$C$14","v":"PEMS+ cold engine 2"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S27>0,100*SPECS!$B$10/S27,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$15","v":"BAB130 Motorway"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M28>0,100*SPECS!$B$9/M28,0),0)","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"km",{"$f":"IF(Electric,IF(P28>0,100*SPECS!$B$37/P28,0),0)","v":0},{"$f":"$C$15","v":"BAB130 Motorway"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S28>0,100*SPECS!$B$10/S28,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M29>0,100*SPECS!$B$9/M29,0),0)","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",{"$f":"IF(Electric,IF(P29>0,100*SPECS!$B$37/P29,0),0)","v":0},{"$f":"$C$16","v":"PEMS+ Eco / light"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S29>0,100*SPECS!$B$10/S29,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M30>0,100*SPECS!$B$9/M30,0),0)","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",{"$f":"IF(Electric,IF(P30>0,100*SPECS!$B$37/P30,0),0)","v":0},{"$f":"$C$17","v":"PEMS+ Heavy load"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S30>0,100*SPECS!$B$10/S30,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$C$18","v":"Short trip / cold start 1"},"km",{"$f":"IF(OR(Petrol,Diesel,CNG_Dual,E_85),IF(M31>0,100*SPECS!$B$9/M31,0),0)","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"km",{"$f":"IF(Electric,IF(P31>0,100*SPECS!$B$37/P31,0),0)","v":0},{"$f":"$C$18","v":"Short trip / cold start 1"},"km",{"$f":"IF(OR(CNG_Mono,CNG_Dual,Hydrogen),IF(S31>0,100*SPECS!$B$10/S31,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Average","km",{"$f":"AVERAGE(M43,M45,M48)","v":0},"Average","km",{"$f":"AVERAGE(P43,P45,P48)","v":0},"Average","km",{"$f":"AVERAGE(S43,S45,S48)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Warm Test (Lab)","km",{"$f":"M45","v":0},"Warm Test (Lab)","km",{"$f":"P45","v":0},"Warm Test (Lab)","km",{"$f":"S45","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Highway","km",{"$f":"M48","v":0},"Highway","km",{"$f":"P48","v":0},"Highway","km",{"$f":"S48","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Cold Ambient Test","km",{"$f":"IF(G29=\"yes\",M44,\"-\")","v":{"$error":"#NAME?"}},"Cold Ambient Test","km",{"$f":"IF(G29=\"yes\",P44,\"-\")","v":{"$error":"#NAME?"}},"Cold Ambient Test","km",{"$f":"IF(G29=\"yes\",S44,\"-\")","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,"Best Case for LCA","km",{"$f":"MAX(M43:M46,M48:M50)","v":0},"Best Case for LCA","km",{"$f":"MAX(P43:P46,P48:P50)","v":0},"Best Case for LCA","km",{"$f":"MAX(S43:S46,S48:S50)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Worst Case for LCA","km",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",MIN(Efficiency!M43:M46,Efficiency!M48:M50),MIN(Efficiency!M43,Efficiency!M45,Efficiency!M46,Efficiency!M48))","v":{"$error":"#NAME?"}},"Worst Case for LCA","km",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",IF(Electric,MIN(Efficiency!P43:P46,Efficiency!P48),MIN(Efficiency!P43:P46,Efficiency!P48:P50)),MIN(Efficiency!P43,Efficiency!P45,Efficiency!P46,Efficiency!P48))","v":{"$error":"#NAME?"}},"Worst Case for LCA","km",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",MIN(Efficiency!S43:S46,Efficiency!S48:S50),MIN(Efficiency!S43,Efficiency!S45,Efficiency!S46,Efficiency!S48))","v":{"$error":"#NAME?"}}]
[null,"2.3","Driving Resistance"]
[null,null,"max points",{"$f":"I63","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(F62:F62)","v":0},null,null,{"$f":"SUM(I59:I62)","v":0}]

{"sheet":"Greenhouse","index":5,"n_rows":97,"n_cols":26,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,5,96,6],[94,1,94,2],[93,1,93,2],[4,17,4,25],[16,17,16,25],[6,17,6,18],[6,23,6,24],[88,1,88,2],[6,20,6,21],[90,1,90,2],[90,6,91,6],[91,1,91,2],[92,1,92,2],[92,6,93,6],[96,1,96,2],[96,3,96,4],[79,1,79,2],[1,10,2,10],[3,1,3,2],[70,1,70,2],[1,1,2,2],[1,4,2,5],[1,6,2,7],[1,8,3,8],[13,1,13,2],[31,1,31,2],[41,1,41,2],[22,1,22,2],[50,1,50,2]]}
[]
[null,"3.Greenhouse Gas Index",null,null,"Test Results",null,"Thresholds",null,"Max score",null,"Fall Back Fuel"]
[]
[null,null,null,null,"Value","Points","Lower","Upper",null,null,"Value",null,null,null,null,null,null,"Conversion from local consumption kWh/100km to upstream GHG emissions in g/km for different energy carriers"]
[null,"3.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 equivalent upstream (Well-to-Tank+)"]
[null,{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"max points",{"$f":"I9","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,"Liquid Fuel",null,"Factor","Electricity",null,"Factor","Gaseous Fuel",null,"Factor"]
[null,"Standard","N2O tailpipe","mg/km",{"$f":"RESULTS!M4","v":0},{"$f":"IF(E7<=H7,I7,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$D$6,IF(Diesel,'LIMITS Greenhouse'!$E$6,0))","v":10},0.5,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(OR(Petrol,CNG_Dual),'LIMITS Greenhouse'!$D$21,IF(Diesel,'LIMITS Greenhouse'!$D$22,IF(E_85,'LIMITS Greenhouse'!$D$26,0)))","v":0.85607812995876598},{"$f":"IF(Electric,\"Electricity\",\"-\")","v":"-"},null,{"$f":"IF(Electric,'LIMITS Greenhouse'!D23,0)","v":0},{"$f":"IF(CNG_Mono,\"CNG\",IF(CNG_Dual,\"CNG\",IF(Hydrogen,\"Hydrogen\",\"-\")))","v":"-"},null,{"$f":"IF(OR(CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$D$24,IF(Hydrogen,'LIMITS Greenhouse'!$D$25,0))","v":0}]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!P4","v":0},{"$f":"IF(E8<=H8,I8,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$D$7,IF(Diesel,'LIMITS Greenhouse'!$E$7,0))","v":32},0.5,null,{"$f":"RESULTS!$P$26","v":0},null,null,null,null,null,null,{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!W23*T$7","v":0},{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!Z23*$W$7","v":0},{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"g/km",{"$f":"Efficiency!AC23*Greenhouse!$Z$7","v":0}]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E10:E13)","v":0},{"$f":"Sliding_Scale(E9,G9,H9,I9,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!D8","v":225},10,null,0,null,null,null,null,null,null,{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!W24*T$7","v":0},{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!Z24*$W$7","v":0},{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"g/km",{"$f":"Efficiency!AC24*Greenhouse!$Z$7","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!F4,RESULTS!F26,0),0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!W25*T$7","v":0},{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!Z25*$W$7","v":0},{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"g/km",{"$f":"Efficiency!AC25*Greenhouse!$Z$7","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M4*'LIMITS Greenhouse'!$B$14/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!W26*T$7","v":0},{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!Z26*$W$7","v":0},{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"g/km",{"$f":"Efficiency!AC26*Greenhouse!$Z$7","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P4*'LIMITS Greenhouse'!$B$15/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D12","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!W27*T$7","v":0},{"$f":"RESULTS!D12","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!Z27*$W$7","v":0},{"$f":"RESULTS!D12","v":"PEMS+ cold engine 2"},"g/km",{"$f":"Efficiency!AC27*Greenhouse!$Z$7","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T8+W8+Z8-(1-(IF(Petrol,'LIMITS Greenhouse'!D31,IF(Diesel,'LIMITS Greenhouse'!D32,IF(E_85,'LIMITS Greenhouse'!D33,1)))))*E10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!W28*T$7","v":0},{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!Z28*$W$7","v":0},{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"g/km",{"$f":"Efficiency!AC28*Greenhouse!$Z$7","v":0}]
[null,"total",null,null,null,{"$f":"MIN(MAX(SUM(F7:F9),0),10)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!W29*T$7","v":0},{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!Z29*$W$7","v":0},{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"g/km",{"$f":"Efficiency!AC29*Greenhouse!$Z$7","v":0}]
[null,{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"max points",{"$f":"I18","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!W30*T$7","v":0},{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!Z30*$W$7","v":0},{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"g/km",{"$f":"Efficiency!AC30*Greenhouse!$Z$7","v":0}]
[null,"Additional","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$7","v":0},{"$f":"IF(E16<=H16,I16,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$N$6,IF(Diesel,'LIMITS Greenhouse'!$O$6,0))","v":16},0.5,null,null,null,null,null,null,null,null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!W31*T$7","v":0},{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!Z31*$W$7","v":0},{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"g/km",{"$f":"Efficiency!AC31*Greenhouse!$Z$7","v":0}]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$7","v":0},{"$f":"IF(E17<=H17,I17,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$N$7,IF(Diesel,'LIMITS Greenhouse'!$O$7,0))","v":51.2},0.5]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E19:E22)","v":0},{"$f":"Sliding_Scale(E18,G18,H18,I18,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!N8","v":225},10]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$F7,RESULTS!$F29,0),0))","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M7*'LIMITS Greenhouse'!$B$14/1000","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P7*'LIMITS Greenhouse'!$B$15/1000","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T9+W9+Z9-(1-(IF(Petrol,'LIMITS Greenhouse'!D31,IF(Diesel,'LIMITS Greenhouse'!D32,IF(E_85,'LIMITS Greenhouse'!D33,1)))))*E19","v":0}]
[null,"total",null,null,null,{"$f":"IF(G93=\"yes\",MIN(MAX(SUM(F16:F18),0),10),0)","v":{"$error":"#NAME?"}}]
[null,{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"max points",{"$f":"I27","v":10}]
[null,"Standard","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$8","v":0},{"$f":"IF(E25<=H25,I25,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$D$6,IF(Diesel,'LIMITS Greenhouse'!$E$6,0))","v":10},0.5]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$8","v":0},{"$f":"IF(E26<=H26,I26,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$D$7,IF(Diesel,'LIMITS Greenhouse'!$E$7,0))","v":32},0.5]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E28:E31)","v":0},{"$f":"Sliding_Scale(E27,G27,H27,I27,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!D8","v":225},10]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$F8,RESULTS!$F30,0),0))","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M8*'LIMITS Greenhouse'!$B$14/1000","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P8*'LIMITS Greenhouse'!$B$15/1000","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T10+W10+Z10-(1-(IF(Petrol,'LIMITS Greenhouse'!D31,IF(Diesel,'LIMITS Greenhouse'!D32,IF(E_85,'LIMITS Greenhouse'!D33,1)))))*E28","v":0}]
[null,"total",null,null,null,{"$f":"MIN(MAX(SUM(F25:F27),0),10)","v":{"$error":"#NAME?"}}]
[null,"3.2"]
[null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"max points",{"$f":"SUM(I35:I37)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$11","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I35,IF(E35=0,Sliding_Scale(E35,G35,H35,I35,0,Slide_Type),IF(K35/E35>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E35,G35,H35,I35,0,Slide_Type),Sliding_Scale(E35,G35,H35,I35,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":15},0,null,{"$f":"RESULTS!$M$33","v":0}]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P11","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I36,IF(E36=0,Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),IF(K36/E36>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E36,G36,H36,I36,0,Slide_Type),Sliding_Scale(E36,G36,H36,I36,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$15","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":"E38+E41","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E37,G37,H37,I37,0,Slide_Type),Sliding_Scale(E37,G37,H37,I37,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":225},0,null,{"$f":"RESULTS!$E$33+$S$36","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$E11,RESULTS!$E33,0),0))","v":0}]
[null,null,"CO2 eq N2O","g/km"]
[null,null,"CO2 eq CH4","g/km"]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E35:E37>'LIMITS Greenhouse'!$K$6:$K$8,K35:K37>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F35:F37),0))","v":0}]
[null,{"$f":"RESULTS!D12","v":"PEMS+ cold engine 2"},"max points",{"$f":"SUM(I44:I46)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$12","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I44,IF(E44=0,Sliding_Scale(E44,G44,H44,I44,0,Slide_Type),IF(K44/E44>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E44,G44,H44,I44,0,Slide_Type),Sliding_Scale(E44,G44,H44,I44,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":15},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P12","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I45,IF(E45=0,Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),IF(K45/E45>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E45,G45,H45,I45,0,Slide_Type),Sliding_Scale(E45,G45,H45,I45,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$15","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":"E47+E50","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E46,G46,H46,I46,0,Slide_Type),Sliding_Scale(E46,G46,H46,I46,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":225},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$E12,RESULTS!$E34,0),0))","v":0}]
[null,null,"CO2 eq N2O","g/km"]
[null,null,"CO2 eq CH4","g/km"]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E44:E46>'LIMITS Greenhouse'!$K$6:$K$8,K44:K46>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F44:F46),0))","v":0}]
[]
[null,"3.3"]
[null,{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"max points",{"$f":"I57","v":10}]
[null,"Standard","N2O tailpipe","mg/km",{"$f":"RESULTS!$M$10","v":0},{"$f":"IF(E55<=H55,I55,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$D$6,IF(Diesel,'LIMITS Greenhouse'!$E$6,0))","v":10},0.5,null,{"$f":"RESULTS!$M$32","v":0}]
[null,null,"CH4 tailpipe","mg/km",{"$f":"RESULTS!$P$10","v":0},{"$f":"IF(E56<=H56,I56,0)","v":0.5},{"$f":"'LIMITS Greenhouse'!$E$15","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual,E_85),'LIMITS Greenhouse'!$D$7,IF(Diesel,'LIMITS Greenhouse'!$E$7,0))","v":32},0.5,null,{"$f":"RESULTS!$P$32","v":0}]
[null,null,"Total CO2 equivalent","g/km",{"$f":"SUM(E58:E61)","v":0},{"$f":"Sliding_Scale(E57,G57,H57,I57,0,Slide_Type)","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"'LIMITS Greenhouse'!D8","v":225},10,null,{"$f":"RESULTS!$E$32+$S$35","v":0}]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$F10,RESULTS!$F32,0),0))","v":0}]
[null,null,"N2O CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!M10*'LIMITS Greenhouse'!$B$14/1000","v":0}]
[null,null,"CH4 CO2-eq (from tailpipe)","g/km",{"$f":"RESULTS!P10*'LIMITS Greenhouse'!$B$15/1000","v":0}]
[null,null,"CO2-eq upstream (Well-to-Tank+)","g/km",{"$f":"T13+W13+Z13-(1-(IF(Petrol,'LIMITS Greenhouse'!D31,IF(Diesel,'LIMITS Greenhouse'!D32,IF(E_85,'LIMITS Greenhouse'!D33,1)))))*E58","v":0}]
[null,null,null,null,null,{"$f":"MIN(MAX(SUM(F55:F57),0),10)","v":{"$error":"#NAME?"}}]
[null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"max points",{"$f":"SUM(I64:I66)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$15","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I64,IF(E64=0,Sliding_Scale(E64,G64,H64,I64,0,Slide_Type),IF(K64/E64>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E64,G64,H64,I64,0,Slide_Type),Sliding_Scale(E64,G64,H64,I64,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":15},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$15","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I65,IF(E65=0,Sliding_Scale(E65,G65,H65,I65,0,Slide_Type),IF(K65/E65>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E65,G65,H65,I65,0,Slide_Type),Sliding_Scale(E65,G65,H65,I65,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$15","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":"E67+E70","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$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E66,G66,H66,I66,0,Slide_Type),Sliding_Scale(E66,G66,H66,I66,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":225},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$E15,RESULTS!$E37,0),0))","v":0}]
[null,null,"CO2 eq N2O","g/km"]
[null,null,"CO2 eq CH4","g/km"]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E64:E66>'LIMITS Greenhouse'!$K$6:$K$8,K64:K66>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F64:F66),0))","v":0}]
[null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"max points",{"$f":"SUM(I73:I79)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$16","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I73,IF(E73=0,Sliding_Scale(E73,G73,H73,I73,0,Slide_Type),IF(K73/E73>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E73,G73,H73,I73,0,Slide_Type),Sliding_Scale(E73,G73,H73,I73,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":15},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$16","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I74,IF(E74=0,Sliding_Scale(E74,G74,H74,I74,0,Slide_Type),IF(K74/E74>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E74,G74,H74,I74,0,Slide_Type),Sliding_Scale(E74,G74,H74,I74,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$15","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":"E76+E79","v":0},{"$f":"IF(OR(Hydrogen,Electric),I79,IF(E79=0,Sliding_Scale(E79,G75,H75,I79,0,Slide_Type),IF(K79/E79>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E79,G75,H75,I79,0,Slide_Type),Sliding_Scale(E79,G75,H75,I79,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":225},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!$E16,RESULTS!$E38,0),0))","v":0}]
[null,null,"CO2 eq N2O","g/km"]
[null,null,"CO2 eq CH4","g/km"]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E73:E75>'LIMITS Greenhouse'!$K$6:$K$8,K73:K75>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F73:F75),0))","v":0}]
[null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"max points",{"$f":"SUM(I82:I88)","v":0}]
[null,null,"N2O","mg/km",{"$f":"RESULTS!$M$13","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I82,IF(E82=0,Sliding_Scale(E82,G82,H82,I82,0,Slide_Type),IF(K82/E82>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E82,G82,H82,I82,0,Slide_Type),Sliding_Scale(E82,G82,H82,I82,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$14","v":0},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$6,IF(Diesel,'LIMITS Greenhouse'!$J$6,0))","v":15},0]
[null,null,"CH4","mg/km",{"$f":"RESULTS!$P$13","v":"n.a."},{"$f":"IF(OR(Hydrogen,Electric),I83,IF(E83=0,Sliding_Scale(E83,G83,H83,I83,0,Slide_Type),IF(K83/E83>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E83,G83,H83,I83,0,Slide_Type),Sliding_Scale(E83,G83,H83,I83,0,Slide_Type))))","v":{"$error":"#VALUE!"}},{"$f":"'LIMITS Greenhouse'!$E$15","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":"E85+E88","v":0},{"$f":"IF(OR(Hydrogen,Electric),I88,IF(E88=0,Sliding_Scale(E88,G84,H84,I88,0,Slide_Type),IF(K88/E88>='LIMITS Efficiency'!$E$27,(1-'LIMITS Efficiency'!$E$28)*Sliding_Scale(E88,G84,H84,I88,0,Slide_Type),Sliding_Scale(E88,G84,H84,I88,0,Slide_Type))))","v":{"$error":"#NAME?"}},{"$f":"'LIMITS Greenhouse'!$E$16","v":50},{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),'LIMITS Greenhouse'!$I$8,IF(Diesel,'LIMITS Greenhouse'!$J$8,0))","v":225},0]
[null,null,"CO2 tailpipe","g/km",{"$f":"(IF(OR(Petrol,Diesel,CNG_Mono,CNG_Dual,E_85),MAX(RESULTS!E13,RESULTS!$E35,0),0))","v":0}]
[null,null,"CO2 eq N2O","g/km"]
[null,null,"CO2 eq CH4","g/km"]
[null,null,"CO2-eq upstream","g/km"]
[null,null,null,null,null,{"$f":"IF(OR(E82:E84>'LIMITS Greenhouse'!$K$6:$K$8,K82:K84>'LIMITS Greenhouse'!$K$6:$K$8),0,MAX(SUM(F82:F84),0))","v":0}]
[]
[null,"SUMMARY",null,"max points","scored points","sub score","Stage 2?"]
[]
[null,"Standard Testing",null,{"$f":"D6+D54+D24","v":30},{"$f":"F62+F14+F32","v":{"$error":"#NAME?"}},{"$f":"ROUNDDOWN(10*(E93/D93),1)","v":{"$error":"#NAME?"}},{"$f":"IF(AND(AVERAGE(F93,Efficiency!F29,'Clean Air'!E102)>='LIMITS Clean Air'!$P$20,MIN(F93,Efficiency!F29,'Clean Air'!E102)>='LIMITS Clean Air'!$P$24),\"YES\",\"NO\")","v":{"$error":"#NAME?"}}]
[null,"Additional Robustness Testing",null,{"$f":"D15","v":10},{"$f":"IF(G93=\"YES\",F23,0)","v":{"$error":"#NAME?"}},{"$f":"ROUNDDOWN(10*(E94/D94),1)","v":{"$error":"#NAME?"}}]
[null,"TOTAL",null,{"$f":"SUM(D93,D94)","v":40},{"$f":"SUM(E93,E94)","v":{"$error":"#NAME?"}}]
[]
[null,"TOTAL SCORE GREENHOUSE GAS",null,"(0-10pts)",null,{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",ROUNDDOWN(10*E95/D95,1),ROUNDDOWN(10*E93/D93,1))","v":{"$error":"#NAME?"}}]

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

{"sheet":"LIMITS Efficiency","index":7,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,1,3,5],[15,1,15,5],[16,1,16,5],[1,1,1,5],[34,2,34,4],[30,2,30,4],[25,1,25,4],[27,1,27,3],[26,1,26,3]]}
[]
[null,"Energy Efficiency"]
[]
[null,"Energy Consumption Thresholds"]
[null,"Thresholds:",null,null,"Lower","Upper"]
[null,null,{"$f":"RESULTS!D4","v":"WLTC+ cold engine (23°C)"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D7","v":"WLTC+ CAT (-7°C)"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D8","v":"WLTC+ warm engine"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D10","v":"BAB130 Motorway"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D11","v":"PEMS+ cold engine 1"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D13","v":"Short trip / cold start 1"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D15","v":"PEMS+ Eco / light"},"kWh/100km",20,90]
[null,null,{"$f":"RESULTS!D16","v":"PEMS+ Heavy load"},"kWh/100km",20,90]
[]
[]
[null,"Fuel / Energy Consumption"]
[null,"Multiplication liquid fuel (l/100km) or gaseous fuel (kg/100km) --> energy (kWh/100km)"]
[null,"Energy Carrier","Factor (default)",null,"Override"]
[null,"Petrol E10",{"$f":"IF(H19>0,H19,E19)","v":8.64},null,8.64]
[null,"Diesel B7",{"$f":"IF(H20>0,H20,E20)","v":9.7899999999999991},null,9.7899999999999991]
[null,"CNG",{"$f":"IF(H21>0,H21,E21)","v":13.8925},null,13.8925]
[null,"Electric",1,null,1]
[null,"Hydrogene",33.61,null,33.61]
[null,"Etahnol E85",6.41,null,6.41]
[]
[null,"Modifer 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,null,"Eligible for Stage 2 "]
[null,null,"score",{"$f":"Efficiency!F29","v":{"$error":"#NAME?"}},{"$f":"IF(D32/D33>=1,\"YES\",\"NO\")","v":{"$error":"#NAME?"}}]
[null,null,"threshold",{"$f":"'LIMITS Clean Air'!P22","v":5},{"$f":"D32/D33","v":{"$error":"#NAME?"}}]
[]
[null,null,"Range deviation BEVs"]
[null,null,null,"pen.points","%"]
[null,null,"tolerance",0,1]
[null,null,"max @ ...%",5,0.5]

{"sheet":"LIMITS Greenhouse","index":8,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,15],[16,8,16,9],[12,8,12,10],[13,8,13,9],[14,8,14,9],[16,13,16,14],[12,13,12,15],[12,2,12,4],[13,2,13,3],[13,13,13,14],[15,8,15,9],[14,2,14,3],[14,13,14,14],[15,2,15,3],[16,2,16,3],[15,13,15,14],[25,1,25,2],[18,1,18,3],[20,1,20,2],[21,1,21,2],[22,1,22,2],[24,1,24,2],[19,1,19,3],[23,1,23,2],[11,13,11,15],[18,6,18,8],[3,7,3,9],[3,2,3,4],[11,8,11,10],[11,2,11,4],[32,1,32,2],[27,1,28,3],[29,1,29,3],[30,1,30,2],[31,1,31,2]]}
[]
[null,"Greenhouse gases"]
[]
[null,"GWP","Upper Thresholds (labtests w/o WLTC+ CAT (-7°C))",null,null,"gross excess",null,"Upper Thresholds (PEMS+ tests)",null,null,"gross excess",null,"Upper Thresholds (WLTC+ CAT (-7°C))",null,null,"gross excess"]
[]
[null,298,"N2O",10,10,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.5*D6,IF(Diesel,1.5*E6,\"n.a.\"))","v":15},null,"N2O",{"$f":"D6*$K$10","v":15},{"$f":"E6*$K$10","v":15},{"$f":"IF(Petrol,1.5*I6,IF(Diesel,1.5*J6,\"n.a.\"))","v":22.5},null,"N2O",{"$f":"D6*$P$10","v":16},{"$f":"E6*$P$10","v":16},{"$f":"IF(Petrol,1.5*N6,IF(Diesel,1.5*O6,\"n.a.\"))","v":24}]
[null,34,"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,{"$f":"E7*$K$10","v":48},{"$f":"IF(Petrol,1.5*I7,IF(Diesel,1.5*J7,\"n.a.\"))","v":72},null,"CH4",{"$f":"D7*$P$10","v":51.2},{"$f":"E7*$P$10","v":51.2},{"$f":"IF(Petrol,1.5*N7,IF(Diesel,1.5*O7,\"n.a.\"))","v":76.800000000000011}]
[null,1,"CO2",225,225,{"$f":"IF(OR(Petrol,CNG_Mono,CNG_Dual),1.5*D8,IF(Diesel,1.5*E8,\"n.a.\"))","v":337.5},null,"CO2",{"$f":"D8","v":225},{"$f":"E8","v":225},{"$f":"IF(Petrol,1.5*I8,IF(Diesel,1.5*J8,\"n.a.\"))","v":337.5},null,"CO2",{"$f":"D8","v":225},{"$f":"E8","v":225},{"$f":"IF(Petrol,1.5*N8,IF(Diesel,1.5*O8,\"n.a.\"))","v":337.5}]
[]
[null,null,null,null,null,null,null,null,null,"CF:",1.5,null,null,null,"CF:",1.6]
[]
[null,"GWP","Lower Thresholds",null,null,null,null,null,"Lower Thresholds",null,null,null,null,"Lower Thresholds"]
[]
[null,298,"N2O",null,0,null,null,null,"N2O",null,{"$f":"E14","v":0},null,null,"N2O",null,{"$f":"K14","v":0}]
[null,34,"CH4",null,0,null,null,null,"CH4",null,{"$f":"E15","v":0},null,null,"CH4",null,{"$f":"K15","v":0}]
[null,1,"CO2",null,50,null,null,null,"CO2","NO2",{"$f":"E16","v":50},null,null,"CO2","NO2",{"$f":"K16","v":50}]
[]
[]
[null,"CO2-eq upstream factor",null,null,null,null,"Eligible for Stage 2 "]
[null,"kWh/100km > gCO2-eq./km ",null,null,null,null,"score",{"$f":"Greenhouse!F93","v":{"$error":"#NAME?"}},{"$f":"IF(H20/H21>=1,\"YES\",\"NO\")","v":{"$error":"#NAME?"}}]
[null,"Petrol E10",null,0.85607812995876598,null,null,"threshold",{"$f":"'LIMITS Clean Air'!P23","v":5},{"$f":"H20/H21","v":{"$error":"#NAME?"}}]
[null,"Diesel B7",null,0.66842444188992434]
[null,"Electricity EU27+UK","NO2",2.8202228762269628]
[null,"CNG",null,0.42340500949537657]
[null,"Hydrogen (nat. gas)",null,3.6351490393498231]
[null,"Ethanol E85",null,1.7529999999999999]
[]
[null,"Upstream CO2 reduction factor due to neutral bio-fuel share combustion carbon balance"]
[]
[null,"-"]
[null,"Petrol E10",null,0.93100000000000005]
[null,"Diesel B7",null,0.93500000000000005]
[null,"Ethanol E85",null,0.214]

{"sheet":"WEBSITE SUMMARY","index":9,"n_rows":183,"n_cols":5,"rows_kept":183,"cut":false,"hidden":true,"merged":[[91,3,91,5],[124,3,124,5],[150,3,150,5],[151,3,151,5]]}
["Car Model",{"$f":"CONCATENATE(SPECS!B1,\" \",SPECS!B2)","v":" "},null,"Type"]
["Type",{"$f":"SPECS!B3","v":0}]
["Release Date"]
["Year of Test"]
["Start of Production",{"$f":"IF(SPECS!B34=\"\",\"\",SPECS!B34)","v":""},"New 2301","empty or date: DD/MM/YYYY","currently not in use"]
["End of Production",{"$f":"IF(SPECS!B35<=SPECS!B34,\"\",IF(SPECS!B35=\"\",\"\",SPECS!B35))","v":""},"New 2301","empty or date: DD/MM/YYYY","currently not in use"]
["Engine",{"$f":"SPECS!B6","v":"Petrol"}]
["Gearbox",{"$f":"SPECS!B23","v":0}]
["Number of Doors",{"$f":"SPECS!B25","v":0},"New 2301","Number - no decimals"]
["Emissions Class",{"$f":"SPECS!B27","v":0}]
["Stars",{"$f":"Stars","v":{"$error":"#NAME?"}}]
["Test #",{"$f":"SPECS!B5","v":0}]
["Engine Size 2",{"$f":"SPECS!B29","v":0}]
["Mass",{"$f":"SPECS!B33","v":0}]
["Clean Air Index",{"$f":"'OVERALL RATING (avg)'!K23","v":{"$error":"#NAME?"}}]
["Clean Air Lab Tests - Overall Performance",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",(Colour_Local(SUM('Clean Air'!F14,'Clean Air'!F23,'Clean Air'!F32,'Clean Air'!F70),SUM('Clean Air'!D6,'Clean Air'!D15,'Clean Air'!D24,'Clean Air'!D62))),(Colour_Local(SUM('Clean Air'!F14,'Clean Air'!F23,'Clean Air'!F32),SUM('Clean Air'!D6,'Clean Air'!D15,'Clean Air'!D24))))","v":{"$error":"#NAME?"}}]
["CA Cold Test - Score",{"$f":"ROUND('Clean Air'!F23,1)","v":{"$error":"#NAME?"}}]
["CA Cold Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F16,'Clean Air'!I16)","v":{"$error":"#NAME?"}},"previously HC > to be renamed in dashboard"]
["CA Cold Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F17,'Clean Air'!I17)","v":{"$error":"#NAME?"}}]
["CA Cold Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F19,'Clean Air'!I19)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F20,'Clean Air'!I20)","v":{"$error":"#NAME?"}}]
["CA Cold Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F22,'Clean Air'!I22)","v":{"$error":"#NAME?"}}]
["CA Warm Test - Score",{"$f":"ROUND('Clean Air'!F14,1)","v":{"$error":"#NAME?"}}]
["CA Warm Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F7,'Clean Air'!I7)","v":{"$error":"#NAME?"}},"previously HC > to be renamed in dashboard"]
["CA Warm Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F8,'Clean Air'!I8)","v":{"$error":"#NAME?"}}]
["CA Warm Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Warm Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F10,'Clean Air'!I10)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Warm Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F11,'Clean Air'!I11)","v":{"$error":"#NAME?"}}]
["CA Warm Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F13,'Clean Air'!I13)","v":{"$error":"#NAME?"}}]
["CA Eco Test - Score",null,"only 2019"]
["CA Eco Test - HC Colour",null,"only 2019"]
["CA Eco Test - NOx Colour",null,"only 2019"]
["CA Eco Test - CO Colour",null,"only 2019"]
["CA Eco Test - PN Colour",null,"only 2019"]
["CA Sport Test - Score",null,"only 2019"]
["CA Sport Test - HC Colour",null,"only 2019"]
["CA Sport Test - NOx Colour",null,"only 2019"]
["CA Sport Test - CO Colour",null,"only 2019"]
["CA Sport Test - PN Colour",null,"only 2019"]
["CA Cold Ambient Test - Score",{"$f":"ROUND('Clean Air'!F70,1)","v":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["CA Cold Ambient Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F63,'Clean Air'!I63)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F64,'Clean Air'!I64)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F66,'Clean Air'!I66)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F67,'Clean Air'!I67)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Cold Ambient Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F69,'Clean Air'!I69)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - Score",{"$f":"ROUND('Clean Air'!F32,1)","v":{"$error":"#NAME?"}}]
["CA Highway Test - NMHC Colour",{"$f":"Colour_Local('Clean Air'!F25,'Clean Air'!I25)","v":{"$error":"#NAME?"}},"previously HC > to be renamed in dashboard"]
["CA Highway Test - NOx Colour",{"$f":"Colour_Local('Clean Air'!F26,'Clean Air'!I26)","v":{"$error":"#NAME?"}}]
["CA Highway Test - NO2 Colour","Not Used",null,"Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - NH3 Colour",{"$f":"Colour_Local('Clean Air'!F28,'Clean Air'!I28)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CA Highway Test - CO Colour",{"$f":"Colour_Local('Clean Air'!F29,'Clean Air'!I29)","v":{"$error":"#NAME?"}}]
["CA Highway Test - PN Colour",{"$f":"Colour_Local('Clean Air'!F31,'Clean Air'!I31)","v":{"$error":"#NAME?"}}]
["CA Road Test - Overall Performance Colour",{"$f":"IF('OVERALL RATING (avg)'!E14=\"YES\",(Colour_Local(SUM('Clean Air'!F42,'Clean Air'!F79,'Clean Air'!F88,'Clean Air'!F59,'Clean Air'!F98),SUM('Clean Air'!D34,'Clean Air'!D71,'Clean Air'!D80,'Clean Air'!D52,'Clean Air'!D89))),(Colour_Local(SUM('Clean Air'!F42,'Clean Air'!F59),SUM('Clean Air'!D34,'Clean Air'!D52))))","v":{"$error":"#NAME?"}}]
["CA On Road Drive - Score",{"$f":"ROUND('Clean Air'!F42,1)","v":{"$error":"#NAME?"}}]
["CA On Road Drive - NMHC Colour","Grey","previously HC > to be renamed in dashboard"]
["CA On Road Drive - NOx Colour",{"$f":"Colour_Local('Clean Air'!F36,'Clean Air'!I36)","v":{"$error":"#NAME?"}}]
["CA On Road Drive - NO2 Colour","Grey",null,"Brown - Green - Orange - Red - Yellow"]
["CA On Road Drive - NH3 Colour","Grey",null,"Brown - Green - Orange - Red - Yellow"]
["CA On Road Drive - CO Colour",{"$f":"Colour_Local('Clean Air'!F39,'Clean Air'!I39)","v":{"$error":"#NAME?"}}]
["CA On Road Drive - PN Colour",{"$f":"Colour_Local('Clean Air'!F41,'Clean Air'!I41)","v":{"$error":"#NAME?"}}]
["CA Robustness - Overall Performance Colour"]
["CA Light Load - Score",{"$f":"ROUND('Clean Air'!F79,1)","v":{"$error":"#NAME?"}}]
["CA Light Load - NMHC Colour","Grey"]
["CA Light Load - NOx Colour",{"$f":"Colour_Local('Clean Air'!F73,'Clean Air'!I73)","v":{"$error":"#NAME?"}}]
["CA Light Load - NO2 Colour","Grey"]
["CA Light Load - NH3 Colour","Grey"]
["CA Light Load - CO Colour",{"$f":"Colour_Local('Clean Air'!F76,'Clean Air'!I76)","v":{"$error":"#NAME?"}}]
["CA Light Load - PN Colour",{"$f":"Colour_Local('Clean Air'!F78,'Clean Air'!I78)","v":{"$error":"#NAME?"}}]
["CA Heavy Load - Score",{"$f":"ROUND('Clean Air'!F88,1)","v":{"$error":"#NAME?"}}]
["CA Heavy Load - NMHC Colour","Grey"]
["CA Heavy Load - NOx Colour",{"$f":"Colour_Local('Clean Air'!F82,'Clean Air'!I82)","v":{"$error":"#NAME?"}}]
["CA Heavy Load - NO2 Colour","Grey"]
["CA Heavy Load - NH3 Colour","Grey"]
["CA Heavy Load - CO Colour",{"$f":"Colour_Local('Clean Air'!F85,'Clean Air'!I85)","v":{"$error":"#NAME?"}}]
["CA Heavy Load - PN Colour",{"$f":"Colour_Local('Clean Air'!F87,'Clean Air'!I87)","v":{"$error":"#NAME?"}}]
["CA Short Trip - Score",{"$f":"ROUND('Clean Air'!F59,1)","v":{"$error":"#NAME?"}}]
["CA Short Trip - NMHC Colour","Grey"]
["CA Short Trip - NOx Colour",{"$f":"Colour_Local('Clean Air'!F53,'Clean Air'!I53)","v":{"$error":"#NAME?"}}]
["CA Short Trip - NO2 Colour","Grey"]
["CA Short Trip - NH3 Colour","Grey"]
["CA Short Trip - CO Colour",{"$f":"Colour_Local('Clean Air'!F54,'Clean Air'!I54)","v":{"$error":"#NAME?"}}]
["CA Short Trip - PN Colour",{"$f":"Colour_Local('Clean Air'!F55,'Clean Air'!I55)","v":{"$error":"#NAME?"}}]
["CA Congestion - Score",{"$f":"ROUND('Clean Air'!F98,1)","v":{"$error":"#NAME?"}}]
["CA Congestion - NMHC Colour","Grey"]
["CA Congestion - NOx Colour",{"$f":"Colour_Local(SUM('Clean Air'!F91,'Clean Air'!F92),SUM('Clean Air'!I91,'Clean Air'!I92))","v":{"$error":"#NAME?"}}]
["CA Congestion - NO2 Colour","Grey"]
["CA Congestion - NH3 Colour","Grey"]
["CA Congestion - CO Colour","Grey"]
["CA Congestion - PN Colour","Grey"]
["Clean Air Comments",null,null,"use [CAi] to show the Clean Air index value, e.g. Model X scores [CAi] out of 10 points.\n\nuse [AvS] to show the Average Score (don't include '%')"]
["Energy Efficiency Index",{"$f":"'OVERALL RATING (avg)'!K24","v":{"$error":"#NAME?"}}]
["Energy Efficiency Lab Tests - Overall performance",{"$f":"Colour_Local('OVERALL RATING (avg)'!K24,10)","v":{"$error":"#NAME?"}}]
["EE Cold Test - Score",{"$f":"ROUND(Efficiency!F10,1)","v":{"$error":"#NAME?"}}]
["EE Cold Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F10,Efficiency!I10)","v":{"$error":"#NAME?"}}]
["EE Cold Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P23,1)","v":0}]
["EE Warm Test - Score",{"$f":"ROUND(Efficiency!F12,1)","v":{"$error":"#NAME?"}}]
["EE Warm Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F12,Efficiency!I12)","v":{"$error":"#NAME?"}}]
["EE Warm Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P25,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":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["EE Cold Ambient Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F11,Efficiency!I11)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["EE Cold Ambient Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P24,1)","v":0},null,"Number"]
["EE Highway Test - Score",{"$f":"ROUND(Efficiency!F15,1)","v":{"$error":"#NAME?"}}]
["EE Highway Test - Energy Eff Colour",{"$f":"Colour_Local(Efficiency!F15,Efficiency!I15)","v":{"$error":"#NAME?"}}]
["EE Highway Test - Electric Efficiency Value",{"$f":"ROUND(Efficiency!P28,1)","v":0}]
["Average Consumption (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel,E85),Efficiency!M32,IF(Electric,Efficiency!P32,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S32,\"???\"))),2)","v":0},"Update 2202","Number - 2 decimal places (cfr Joanneum calculation)"]
["Best-Case Consumption (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel,E85),Efficiency!M36,IF(Electric,Efficiency!P36,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S36,\"???\"))),2)","v":{"$error":"#NAME?"}},"New 2301","Number - 2 decimal places (cfr Joanneum calculation)"]
["Worst-Case Consumption (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel,E85),Efficiency!M37,IF(Electric,Efficiency!P37,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S37,\"???\"))),2)","v":0},"Update 2202","Number - 2 decimal places (cfr Joanneum calculation)"]
["Average Consumption (2nd fuel source)",{"$f":"ROUND(IF(CNG_Dual,Efficiency!M32,\"0\"),2)","v":0},"Update 2202","Number - 2 decimal places (cfr Joanneum calculation)"]
["Best-Case Consumption (2nd fuel source)",{"$f":"ROUND(IF(CNG_Dual,Efficiency!M36,\"0\"),2)","v":0},"New 2301","Number - 2 decimal places (cfr Joanneum calculation)"]
["Worst-Case Consumption (2nd fuel source)",{"$f":"ROUND(IF(CNG_Dual,Efficiency!M37,\"0\"),2)","v":0},"Update 2202","Number - 2 decimal places (cfr Joanneum calculation)"]
["Driving Range - Average (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel,E85),Efficiency!M52,IF(Electric,Efficiency!P52,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S52,\"???\"))),0)","v":0},null,"Number - no decimal places"]
["Driving Range - Best-Case (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel,E85),Efficiency!M56,IF(Electric,Efficiency!P56,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S56,\"???\"))),0)","v":0},"New 2301","Number - no decimal places"]
["Driving Range - Worst-Case (1st fuel source)",{"$f":"ROUND(IF(OR(Petrol,Diesel,E85),Efficiency!M57,IF(Electric,Efficiency!P57,IF(OR(CNG_Dual,CNG_Mono,Hydrogen),Efficiency!S57,\"???\"))),0)","v":{"$error":"#NAME?"}},null,"Number - no decimal places"]
["Driving Range - Average (2nd fuel source)",{"$f":"ROUND(IF(CNG_Dual,Efficiency!M52,\"0\"),0)","v":0},null,"Number - no decimal places"]
["Driving Range - Best-Case (2nd fuel source)",{"$f":"ROUND(IF(CNG_Dual,Efficiency!M56,\"0\"),0)","v":0},"New 2301","Number - no decimal places"]
["Driving Range - Worst-Case (2nd fuel source)",{"$f":"ROUND(IF(CNG_Dual,Efficiency!M57,\"0\"),0)","v":0},null,"Number - no decimal places"]
["Energy Efficiency Comment",null,null,"use [EEi] to show the Energy Efficiency index value, e.g. Model X scores [EEi] out of 10 points.\n\nuse [AvS] to show the Average Score (don't include '%')"]
["Greenhouse Gas Index",{"$f":"'OVERALL RATING (avg)'!K25","v":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["Greenhouse Gas - Overall Performance",{"$f":"Colour_Local('OVERALL RATING (avg)'!K25,10)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Test - Score",{"$f":"ROUND(Greenhouse!F14,1)","v":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["GG Cold Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F9,Greenhouse!I9)","v":{"$error":"#NAME?"}},"added GG > to be renamed in the dashboard"]
["GG Cold Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F7,Greenhouse!I7)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F8,Greenhouse!I8)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Warm Test - Score",{"$f":"ROUND(Greenhouse!F32,1)","v":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["GG Warm Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F27,Greenhouse!I27)","v":{"$error":"#NAME?"}},"added GG > to be renamed in the dashboard"]
["GG Warm Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F25,Greenhouse!I25)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Warm Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F26,Greenhouse!I26)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["Eco Test - CO2 Colour","-"]
["Sport Test - CO2 Colour","-"]
["GG Cold Ambient Test - Score",{"$f":"ROUND(Greenhouse!F23,1)","v":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["GG Cold Ambient Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F18,Greenhouse!I18)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Ambient Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F16,Greenhouse!I16)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Cold Ambient Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F17,Greenhouse!I17)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Highway Test - Score",{"$f":"ROUND(Greenhouse!F62,1)","v":{"$error":"#NAME?"}},null,"Number - 1 decimal place"]
["GG Highway Test - CO2 Colour",{"$f":"Colour_Local(Greenhouse!F57,Greenhouse!I57)","v":{"$error":"#NAME?"}},"added GG > to be renamed in the dashboard"]
["GG Highway Test - N2O Colour",{"$f":"Colour_Local(Greenhouse!F55,Greenhouse!I55)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["GG Highway Test - CH4 Colour",{"$f":"Colour_Local(Greenhouse!F56,Greenhouse!I56)","v":{"$error":"#NAME?"}},null,"Brown - Green - Orange - Red - Yellow"]
["CO2 Tailpipe - Average",{"$f":"ROUND(AVERAGE(Greenhouse!E10,Greenhouse!E28,Greenhouse!E58),2)","v":0},"New 2301","Number - 2 decimal places (cfr Joanneum calculation)"]
["CO2 Tailpipe - Best",{"$f":"ROUND(IF('OVERALL RATING (avg)'!E14=\"NO\",MIN(Greenhouse!E10,Greenhouse!E28,Greenhouse!E38,Greenhouse!E58),IF('OVERALL RATING (avg)'!E14=\"YES\",MIN(Greenhouse!E10,Greenhouse!E19,Greenhouse!E28,Greenhouse!E38,Greenhouse!E58,Greenhouse!E67,Greenhouse!E76),\"\")),2)","v":{"$error":"#NAME?"}},"New 2301","Number - 2 decimal places (cfr Joanneum calculation)"]
["CO2 Tailpipe - Worst",{"$f":"ROUND(IF('OVERALL RATING (avg)'!E14=\"NO\",MAX(Greenhouse!E10,Greenhouse!E28,Greenhouse!E38,Greenhouse!E58),IF('OVERALL RATING (avg)'!E14=\"YES\",MAX(Greenhouse!E10,Greenhouse!E19,Greenhouse!E28,Greenhouse!E38,Greenhouse!E58,Greenhouse!E67,Greenhouse!E76),\"\")),2)","v":{"$error":"#NAME?"}},"New 2301","Number - 2 decimal places (cfr Joanneum calculation)"]
["N2O",{"$f":"ROUND(Greenhouse!E7,1)","v":0},"New 2301","Number - 1 decimal place","for LCA, from WLTC+ cold, mg/km"]
["CH4",{"$f":"ROUND(Greenhouse!E8,1)","v":0},"New 2301","Number - 1 decimal place","for LCA, from WLTC+ cold, mg/km"]
["Greenhouse Gas Comment",null,null,"use [GGi] to show the Greenhouse Gas index value, e.g. Model X scores [GGi] out of 10 points.\n\nuse [AvS] to show the Average Score (don't include '%')"]
["Verdict",null,null,"use [stars] to show the stars value of the spreadsheet\n\nuse [AvS] to show the Average Score (don't include '%')"]
["VIN of Tested Car",{"$f":"SPECS!B26","v":0}]
["Mass",{"$f":"SPECS!B33","v":0}]
["Engine Size",{"$f":"SPECS!B29","v":0}]
["Engine Power",{"$f":"SPECS!B30","v":0}]
["Torque",{"$f":"SPECS!B31","v":0}]
["Tyres",{"$f":"SPECS!B32","v":0}]
["Published CO2",{"$f":"IF(Electric,\"\",SPECS!B13)","v":0}]
["Rating Validity"]
["Consumption type (l - kg - kW)",{"$f":"IF(OR(Petrol,Diesel,E85),\"l\",IF(OR(Hydrogen,CNG_Mono,CNG_Dual),\"kg\",IF(Electric,\"kW\",\"???\")))","v":"l"}]
["Consumption per","100km"]
["Primary fuel source",{"$f":"IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",IF(E85,\"E85 Ethanol\",IF(Hydrogen,\"Hydrogen\",IF(CNG_Mono,\"CNG\",IF(Electric,\"Electric\",IF(CNG_Dual,\"CNG\",\"???\")))))))","v":"Petrol"}]
["Secondary fuel source",{"$f":"IF(CNG_Dual,\"Petrol\",\"\")","v":""}]
["Published Driving Range",{"$f":"SPECS!B17","v":0},"= declared driving range","Number - no decimal place"]
["Declared Driving Range City",{"$f":"SPECS!B18","v":0},"New 2203","Number - no decimal place"]
["Declared Consumption (1st Energy Source)",{"$f":"IF(SPECS!B14>0,ROUND(SPECS!B14,1),ROUND(SPECS!B16,1))","v":0},"New 2203","Number - 1 decimal place"]
["Declared Consumption (2nd Energy Source)",{"$f":"SPECS!B15","v":0},"New 2203","Number - 1 decimal place"]
["Primary fuel consumption units",{"$f":"IF(OR(Petrol,Diesel,E85),\"l/100km\",IF(OR(CNG_Dual,CNG_Mono,Hydrogen),\"kg/100km\",IF(Electric,\"kWh/100km\")))","v":"l/100km"}]
["Secondary fuel consumption units",{"$f":"IF(CNG_Dual,\"l/100km\",\"\")","v":""}]
["Single/Dual Fuel source",{"$f":"IF(OR(Petrol,Diesel,E85,CNG_Mono,Hydrogen,Electric),\"Single\",IF(OR(Petrol_PHEV,Diesel_PHEV,CNG_Dual),\"Dual\",\"?????\"))","v":"Single"}]
["Battery capacity",{"$f":"ROUND(SPECS!B11,IF(SPECS!B11<10,2,1))","v":0},"Declared Battery Capacity (usable)","Number - 1 decimal place > 10 - else 2 decimals"]
["Declared Battery Capacity (installed)",{"$f":"ROUND(SPECS!B12,IF(SPECS!B12<10,2,1))","v":0},"New 2301","Number - 1 decimal place > 10 - else 2 decimals"]
["Heating concept",{"$f":"SPECS!B22","v":0},"New 2302","text"]
["Drivetrain",{"$f":"SPECS!B5","v":0}]
["Short_Variant"]
["Chassis",{"$f":"VLOOKUP(SPECS!B24,SPECS!H25:I31,2,FALSE)","v":"Convertible"},"New 2203","Saloon - Hatchback - Station wagon - Coupe - Convertible - Multi-purpose vehicle - Truck station wagon"]
["Test stage",{"$f":"\"Stage \"&IF('OVERALL RATING (avg)'!E14=\"yes\",2,1)","v":{"$error":"#NAME?"}}]
["Internal Combustion Engine",{"$f":"IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",IF(E85,\"E85\",IF(CNG_Mono,\"CNG\",IF(CNG_Dual,\"CNG\",\"\")))))","v":"Petrol"},"New 2206, if tested on E85, it will show E85 as engine on purpose"]
["Electric Engine",{"$f":"IF(Hydrogen,\"Hydrogen\",IF(Electric,\"BEV\",IF(SPECS!M9=TRUE,\"Hybrid\",\"\")))","v":""},"New 2206"]
["Weighted Overall Index",{"$f":"'OVERALL RATING (avg)'!C26","v":{"$error":"#NAME?"}},"New 2209","Number - 1 decimal place"]
["Average Score",{"$f":"B181/10","v":{"$error":"#NAME?"}},"New 2305","%"]
["LCA Award","No","New 2305","Yes/No"]

{"sheet":"Track Changes","index":10,"n_rows":106,"n_cols":4,"rows_kept":106,"cut":false,"hidden":true,"merged":[]}
["Version 2.0.8.2 received the following changes to adopt E85 fuel:","Damyanov",null,"29.09.2022"]
[]
["LIMITS Greenhouse"]
["·       B33 E85 fuel Upstream CO2 reduction factor due to neutral bio-fuel share combustion carbon balance = 0,214"]
["·       Row 26, added “Ethanol E85”, 1,753"]
[]
["LIMITS Efficiency"]
["·       B19 added “E10”"]
["·       B20 added “B7”"]
["·       Row added after table at line 24"]
["·       On line 24 added “Ethanol E85, Factor 6,41, Override 6,41"]
[]
["SPECS"]
["·       Ethanol E85 option inserted"]
["·       Formula in B6 and B7 expanded with E85 option"]
[]
["Efficiency"]
["·       Formulas in E10:E15 expanded with addition of E85 option"]
["·       Formulas in M23:E31 expanded with addition of E85 option"]
["·       Formulas in W23:W31 expanded with addition of E85 option"]
["·       Formulas in M43:M51 expanded with addition of E85 option"]
[]
["Greenhouse"]
["·       Formulas in Column E and H expanded with addition of E85 option"]
["·       T7 formula expanded with E85 option"]
[]
["Website Summary"]
["·       D89, D118, D139, D140 now include instruction about using automatic indexing"]
["·       Row 167 now defines the Weighted Overall Index"]
[]
["Version saved as 2.0.8.2_E85"]
[]
["Version 2.0.8.2_E85 received the following chnages to ease data transfer to assessment, LCA Static and LCA Tool","Damyanov",null,"26.01.2023"]
[]
["Website Summary"]
["Row 5: Start of Production"]
["Row 6: End of Production"]
["Row 9: Number of Doors"]
["Row 114: Best-Case Consumption (1st fuel source)"]
["Row 117: Best-Case Consumption (1st fuel source)"]
["Cells D119-D124: format explanation"]
["Row 120: Driving Range - Best-Case (1st fuel source)"]
["Row 123: Driving Range - Best - Case (2nd fuel source)"]
["Row 144: CO2 Tailpipe - Average"]
["Row 145: CO2 Tailpipe - Best"]
["Row 146: CO2 Tailpipe - Worst"]
["Row 147: N2O"]
["Row 148: CH4"]
["Cell D165: format explanation"]
["Cell C170, explanation: Declared Battery Capacity (usable)"]
["Row 171: Declared Battery Capacity (installed)"]
["A15, A93, A126: formated in bold"]
[]
["SPECS"]
["Cells O1, O2: Rating sheet Version displayed"]
["Cell J6: Info added \"Respect Green NCAP's definition of \"Hybrid\".\""]
["Cell A5, label changed from \"Drivetrain (FWD/AWD/RWD/4WD)\" to Drivetrain\""]
["Cell B5: Dropdown list inserted for Drivetrain"]
["Chnaged A11 from \"Declared Battery Capacity [kWh]\" to \"Declared Battery Capacity (usable) [kWh]\""]
["Added Row 12: Declared Battery Capacity (installed) [kWh]"]
["Cell B22: Dropdown list inserted for Gearbox type"]
["Cell C23: info changed"]
["Added Row 33 \"Start of Production\""]
["Added Row 34 \"End of Production\" with conditional formatting"]
["Tabs SPECS and RESULTS moved to 2nd and 3rd position"]
["RESULTS"]
["Table Structure Protected by the same password as for the other tabs"]
["TABS LIMITS Clean Air, LIMITS Efficiency, LIMITS Greenhouse"]
["Font changed to Calibri 11 for all."]
["Version saved as 2.0.8.3"]
[]
["Version 2.0.8.3 received the following chnages as it was spotted that the PEMS tests are not included in the selection range for best/worst CO2 consumption for LCA. They should be, because there are included in the selection for best/worst fuel/energy consumption.","Damyanov",null,"02.02.2023"]
[]
["Greenhouse"]
["Hidden PEMS blocks opened: "]
["PEMS+ cold engine 1"]
["PEMS+ Eco / light"]
["PEMS+ Heavy load"]
["Cells C33 und B51 \"Regulatory performance PEMS+ \" deleted "]
["All PEMS test blocks put in gray font colour"]
["In all PEMS blocks, the formula for the tailpipe CO2 emissions received a changed reference to column \"E\" in sheet \"Results\", instead to column \"F\""]
["In all PEMS blocks, the formula for the tailpipe CO2 emissions received a additional variable \"E_85\""]
["WEBSITE SUMMARY"]
["B147 Addition of all PEMS test as range for the selection in the fromula"]
["B148 Addition of all PEMS test as range for the selection in the fromula"]
[]
["OVERALL RATING (avg)","Verheyen",null,"03.02.2023"]
["Stars label changed to year 2023"]
["WEBSITE SUMMARY"]
["Internal Combustion Engine (line 178) should say =IF(Petrol,\"Petrol\",IF(Diesel,\"Diesel\",IF(E_85,\"E85\",IF(CNG_Mono,\"CNG\",IF(CNG_Dual,\"CNG\",\"\"))))) to have E85 reflect in the datasheet. It is understood that E85 is not an eingine type, stillwe accept that."]
["SPECS","Damyanov",null,"03.02.2023"]
["Cell O2, Year chnaged to 2023"]
["Cells O3, O4: \"Protocols 2022\" added"]
[]
["Version saved as GNT_Rating_Sheet_Master_2023v2.0.8.4"]
[]
[]
["Version GNT_Rating_Sheet_Master_2023v2.0.8.4 received the following update:","Damyanov",null,"22.02.2023"]
["SPECS"]
["New entry in row 22: Heating concept with a drop down selection list in P18:P24"]
["O2: version changed to 2.0.8.5"]
["A13:A15 deleted \", combined PHEV\" from label"]
["WEBSITE SUMMARY"]
["Addition of new field \"Heating Concept\" in row 174 and reference to the source cell in SPECS"]
[]
["Version saved as GNT_Rating_Sheet_Master_2023v2.0.8.5"]