{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["OVERALL RATING","Clean Air","Efficiency","limits","SPECS","Lab results","PEMS results"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OVERALL RATING","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,3,2],[17,2,17,3],[17,4,17,5],[32,3,32,4],[6,2,6,3],[6,4,6,5],[16,4,16,5],[7,2,7,3],[16,2,16,3],[15,2,15,3],[7,4,7,5],[15,4,15,5],[33,2,33,4],[36,2,36,4],[30,3,30,4],[19,2,19,3],[20,2,20,3],[21,4,21,5],[19,4,19,5],[23,4,23,5],[20,4,20,5],[23,2,23,3],[22,4,22,5],[22,2,22,3],[21,2,21,3]]}
[]
[]
[null,{"$f":"D29","v":0},{"$f":"E29","v":0}]
[]
[]
[]
[null,null,"Clean Air Index\n",null,"Energy Efficiency Index\n"]
[null,null,32.6,null,40.5]
[null,null,{"$f":"'Clean Air'!B6","v":"WLTC-cold"},{"$f":"'Clean Air'!F12","v":9},"Energy Consumption \n(WLTC-cold)",{"$f":"Efficiency!F18","v":10}]
[null,null,{"$f":"'Clean Air'!B13","v":"WLTC-warm"},{"$f":"'Clean Air'!F19","v":3},"Energy Consumption \n(WLTC-warm/eco/sport)",{"$f":"SUM(Efficiency!F19:F21)","v":9}]
[null,null,{"$f":"'Clean Air'!B20","v":"WLTC -eco"},{"$f":"'Clean Air'!F26","v":3},"Energy Consumption 1)\n(PEMS+)",{"$f":"IF(Efficiency!F22=0,\"-\",Efficiency!F22)","v":"-"}]
[null,null,{"$f":"'Clean Air'!B27","v":"WLTC -sport"},{"$f":"'Clean Air'!F33","v":3},"Energy Consumption \n(BAB130)",{"$f":"Efficiency!F23","v":10}]
[null,null,{"$f":"'Clean Air'!B36","v":"PEMS+"},{"$f":"'Clean Air'!F42","v":7},"Energy Consumption 1)\n(suppl PEMS)",{"$f":"IF(Efficiency!F24=0,\"-\",Efficiency!F24)","v":"-"}]
[null,null,{"$f":"'Clean Air'!B45","v":"BAB130"},{"$f":"'Clean Air'!F51","v":9},"Driving Range 1)",{"$f":"IF(Efficiency!F46=0,\"-\",Efficiency!F46)","v":"-"}]
[null,null,"suppl. PEMS 1)",null,"Driving Resistance 1)",{"$f":"IF(Efficiency!F47=0,\"-\",Efficiency!F47)","v":"-"}]
[null,"Total Score",{"$f":"'Clean Air'!F65","v":34},null,{"$f":"Efficiency!E49","v":29}]
[null,"Max Points available",{"$f":"'Clean Air'!D65","v":34},null,{"$f":"Efficiency!D49","v":34}]
[null,"Index",{"$f":"10*C16/C17","v":10},null,{"$f":"10*E16/E17","v":8.5294117647058822}]
[null,"RATING REQUIREMENTS 2018"]
[null,null,8,null,7.5,null,{"$f":"IF(AND($C$18:$F$18>=C20:F20),1,0)","v":1}]
[null,null,7,null,6,null,{"$f":"IF(AND($C$18:$F$18>=C21:F21),1,0)","v":1}]
[null,null,6,null,4.5,null,{"$f":"IF(AND($C$18:$F$18>=C22:F22),1,0)","v":1}]
[null,null,5,null,3,null,{"$f":"IF(AND($C$18:$F$18>=C23:F23),1,0)","v":1}]
[null,null,4,null,1.5,null,{"$f":"IF(AND($C$18:$F$18>=C24:F24),1,0)","v":1}]
[]
[null,"1): test not operational yet",null,null,null,null,{"$f":"SUM(G20:G24)","v":5}]
[]
[null,null,"TEST DETAILS"]
[null,null,"Vehicle",{"$f":"SPECS!B1","v":0},{"$f":"SPECS!B2","v":0}]
[null,null," Specs (cc/kW)",{"$f":"SPECS!B9","v":0},{"$f":"SPECS!B10","v":0}]
[null,null,"Applies to VIN:",{"$f":"SPECS!B3","v":0}]
[null,null,"Powerunit(s)",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\", \" \"))","v":"petrol"},{"$f":"IF(Electric,\"electric\",\" \")","v":" "}]
[null,null,"Actual mass (kg)",{"$f":"SPECS!B14","v":0}]
[null,null,"Average consumption (in WLTC tests)"]
[null,null,"fuel ",{"$f":"IF(AVERAGE(Efficiency!M18:M21)>0,AVERAGE(Efficiency!M18:M21),\"n.a.\")","v":"n.a."},"l/100km"]
[null,null,"electric energy",{"$f":"IF(AVERAGE(Efficiency!P18:P21)>0,AVERAGE(Efficiency!P18:P21),\"n.a.\")","v":"n.a."},"kWh/100km"]
[null,null,"Worst case consumption (suppl PEMS test) 1)"]
[null,null,"fuel","n.a.","l/100km"]
[null,null,"electric energy","n.a.","kWh/100km"]

{"sheet":"Clean Air","index":1,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[57,1,57,2],[68,3,68,4],[64,6,64,7],[68,6,68,7],[60,1,60,2],[68,1,68,2],[64,1,64,2],[1,8,3,8],[11,1,11,2],[32,1,32,2],[41,1,41,2],[1,6,2,7],[1,4,2,5],[1,1,2,2],[3,1,3,2],[18,1,18,2],[25,1,25,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"1. Pollutants",null,null,"Test Results",null,"Limits",null,"Max score"]
[]
[null,null,null,null,"Value","Points","lower","upper"]
[null,"1.1","Regulatory Tailpipe Emission Lab Tests"]
[null,"WLTC-cold","max points",{"$f":"SUM(I7:I11)","v":9}]
[null,"(cold1)","HC","mg/km",{"$f":"'Lab results'!$C$10","v":0},{"$f":"Sliding_Scale(E7,G7,H7,I7,0,Slide_Type)","v":2},{"$f":"limits!$D$13","v":45},{"$f":"IF(Petrol,limits!C$5,IF(Diesel,limits!D$5,0))","v":100},2]
[null,null,"NOx ","mg/km",{"$f":"'Lab results'!$F$10","v":0},{"$f":"Sliding_Scale(E8,G8,H8,I8,0,Slide_Type)","v":3},{"$f":"limits!$D$14","v":30},{"$f":"IF(Petrol,limits!C$6,IF(Diesel,limits!D$6,0))","v":60},3]
[null,null,"CO","mg/km",{"$f":"'Lab results'!$B$10","v":0},{"$f":"Sliding_Scale(E9,G9,H9,I9,0,Slide_Type)","v":1},{"$f":"limits!$D$15","v":250},{"$f":"IF(Petrol,limits!C$7,IF(Diesel,limits!D$7,0))","v":1000},1]
[null,null,"PM","mg/km",{"$f":"'Lab results'!$G$10","v":0},{"$f":"Sliding_Scale(E10,G10,H10,I10,0,Slide_Type)","v":0},{"$f":"limits!$D$16","v":2.25},{"$f":"IF(Petrol,limits!C$8,IF(Diesel,limits!D$8,0))","v":4.5},0]
[null,null,"PN",null,{"$f":"'Lab results'!$H$10","v":0},{"$f":"Sliding_Scale(E11,G11,H11,I11,0,Slide_Type)","v":3},{"$f":"limits!$D$17","v":60000000000},{"$f":"IF(Petrol,limits!C$9,IF(Diesel,limits!D$9,0))","v":600000000000},3]
[null,"total",null,null,null,{"$f":"IF(OR(E7:E11>limits!$E$5:$E$9),0,MAX(SUM('Clean Air'!F7:F11),0))","v":9}]
[null,"WLTC-warm","max points",{"$f":"SUM(I14:I18)","v":3}]
[null,"(warm)","HC","mg/km",{"$f":"'Lab results'!$C$20","v":0},{"$f":"Sliding_Scale(E14,G14,H14,I14,0,Slide_Type)","v":0.66666666666666663},{"$f":"limits!$D$13","v":45},{"$f":"IF(Petrol,limits!C$5,IF(Diesel,limits!D$5,0))","v":100},{"$f":"2/3","v":0.66666666666666663}]
[null,null,"NOx","mg/km",{"$f":"'Lab results'!$F$20","v":0},{"$f":"Sliding_Scale(E15,G15,H15,I15,0,Slide_Type)","v":1},{"$f":"limits!$D$14","v":30},{"$f":"IF(Petrol,limits!C$6,IF(Diesel,limits!D$6,0))","v":60},{"$f":"3/3","v":1}]
[null,null,"CO","mg/km",{"$f":"'Lab results'!$B$20","v":0},{"$f":"Sliding_Scale(E16,G16,H16,I16,0,Slide_Type)","v":0.33333333333333331},{"$f":"limits!$D$15","v":250},{"$f":"IF(Petrol,limits!C$7,IF(Diesel,limits!D$7,0))","v":1000},{"$f":"1/3","v":0.33333333333333331}]
[null,null,"PM","mg/km",{"$f":"'Lab results'!$G$20","v":0},{"$f":"Sliding_Scale(E17,G17,H17,I17,0,Slide_Type)","v":0},{"$f":"limits!$D$16","v":2.25},{"$f":"IF(Petrol,limits!C$8,IF(Diesel,limits!D$8,0))","v":4.5},0]
[null,null,"PN",null,{"$f":"'Lab results'!$H$20","v":0},{"$f":"Sliding_Scale(E18,G18,H18,I18,0,Slide_Type)","v":1},{"$f":"limits!$D$17","v":60000000000},{"$f":"IF(Petrol,limits!C$9,IF(Diesel,limits!D$9,0))","v":600000000000},{"$f":"3/3","v":1}]
[null,"total",null,null,null,{"$f":"IF(OR(E14:E18>limits!$E$5:$E$9),0,MAX(SUM('Clean Air'!F14:F18),0))","v":3}]
[null,"WLTC -eco","max points",{"$f":"SUM(I21:I25)","v":3}]
[null,"(warm)","HC","mg/km",{"$f":"'Lab results'!$C$30","v":0},{"$f":"Sliding_Scale(E21,G21,H21,I21,0,Slide_Type)","v":0.66666666666666663},{"$f":"limits!$D$13","v":45},{"$f":"IF(Petrol,limits!C$5,IF(Diesel,limits!D$5,0))","v":100},{"$f":"2/3","v":0.66666666666666663}]
[null,null,"NOx","mg/km",{"$f":"'Lab results'!$F$30","v":0},{"$f":"Sliding_Scale(E22,G22,H22,I22,0,Slide_Type)","v":1},{"$f":"limits!$D$14","v":30},{"$f":"IF(Petrol,limits!C$6,IF(Diesel,limits!D$6,0))","v":60},{"$f":"3/3","v":1}]
[null,null,"CO","mg/km",{"$f":"'Lab results'!$B$30","v":0},{"$f":"Sliding_Scale(E23,G23,H23,I23,0,Slide_Type)","v":0.33333333333333331},{"$f":"limits!$D$15","v":250},{"$f":"IF(Petrol,limits!C$7,IF(Diesel,limits!D$7,0))","v":1000},{"$f":"1/3","v":0.33333333333333331}]
[null,null,"PM","mg/km",{"$f":"'Lab results'!$G$30","v":0},{"$f":"Sliding_Scale(E24,G24,H24,I24,0,Slide_Type)","v":0},{"$f":"limits!$D$16","v":2.25},{"$f":"IF(Petrol,limits!C$8,IF(Diesel,limits!D$8,0))","v":4.5},0]
[null,null,"PN",null,{"$f":"'Lab results'!$H$30","v":0},{"$f":"Sliding_Scale(E25,G25,H25,I25,0,Slide_Type)","v":1},{"$f":"limits!$D$17","v":60000000000},{"$f":"IF(Petrol,limits!C$9,IF(Diesel,limits!D$9,0))","v":600000000000},{"$f":"3/3","v":1}]
[null,"total",null,null,null,{"$f":"IF(OR(E21:E25>limits!$E$5:$E$9),0,MAX(SUM('Clean Air'!F21:F25),0))","v":3}]
[null,"WLTC -sport","max points",{"$f":"SUM(I28:I32)","v":3}]
[null,null,"HC","mg/km",{"$f":"'Lab results'!$C$40","v":0},{"$f":"Sliding_Scale(E28,G28,H28,I28,0,Slide_Type)","v":0.66666666666666663},{"$f":"limits!$D$13","v":45},{"$f":"IF(Petrol,limits!C$5,IF(Diesel,limits!D$5,0))","v":100},{"$f":"2/3","v":0.66666666666666663}]
[null,null,"NOx","mg/km",{"$f":"'Lab results'!$F$40","v":0},{"$f":"Sliding_Scale(E29,G29,H29,I29,0,Slide_Type)","v":1},{"$f":"limits!$D$14","v":30},{"$f":"IF(Petrol,limits!C$6,IF(Diesel,limits!D$6,0))","v":60},{"$f":"3/3","v":1}]
[null,null,"CO","mg/km",{"$f":"'Lab results'!$B$40","v":0},{"$f":"Sliding_Scale(E30,G30,H30,I30,0,Slide_Type)","v":0.33333333333333331},{"$f":"limits!$D$15","v":250},{"$f":"IF(Petrol,limits!C$7,IF(Diesel,limits!D$7,0))","v":1000},{"$f":"1/3","v":0.33333333333333331}]
[null,null,"PM","mg/km",{"$f":"'Lab results'!$G$40","v":0},{"$f":"Sliding_Scale(E31,G31,H31,I31,0,Slide_Type)","v":0},{"$f":"limits!$D$16","v":2.25},{"$f":"IF(Petrol,limits!C$8,IF(Diesel,limits!D$8,0))","v":4.5},0]
[null,null,"PN",null,{"$f":"'Lab results'!$H$40","v":0},{"$f":"Sliding_Scale(E32,G32,H32,I32,0,Slide_Type)","v":1},{"$f":"limits!$D$17","v":60000000000},{"$f":"IF(Petrol,limits!C$9,IF(Diesel,limits!D$9,0))","v":600000000000},{"$f":"3/3","v":1}]
[null,"total",null,null,null,{"$f":"IF(OR(E28:E32>limits!E5:E9),0,MAX(SUM('Clean Air'!F28:F32),0))","v":3}]
[]
[null,"1.2","Regulatory performance PEMS+ "]
[null,"PEMS+","max points",{"$f":"SUM(I37:I41)","v":7}]
[null,null,"HC","mg/km",{"$f":"'PEMS results'!F27","v":0},{"$f":"Sliding_Scale(E37,G37,H37,I37,0,Slide_Type)","v":0},{"$f":"limits!$J$13","v":45},{"$f":"IF(Petrol,limits!H$5,IF(Diesel,limits!I$5,0))","v":150},0]
[null,null,"NOx","mg/km",{"$f":"'PEMS results'!$D$27","v":0},{"$f":"Sliding_Scale(E38,G38,H38,I38,0,Slide_Type)","v":3},{"$f":"limits!$J$14","v":30},{"$f":"IF(Petrol,limits!H$6,IF(Diesel,limits!I$6,0))","v":90},3]
[null,null,"CO","mg/km",{"$f":"'PEMS results'!$C$27","v":0},{"$f":"Sliding_Scale(E39,G39,H39,I39,0,Slide_Type)","v":1},{"$f":"limits!$J$15","v":250},{"$f":"IF(Petrol,limits!H$7,IF(Diesel,limits!I$7,0))","v":1500},1]
[null,null,"PM","mg/km",null,{"$f":"Sliding_Scale(E40,G40,H40,I40,0,Slide_Type)","v":0},{"$f":"limits!$J$16","v":2.25},{"$f":"IF(Petrol,limits!H$8,IF(Diesel,limits!I$8,0))","v":6.75},0]
[null,null,"PN",null,{"$f":"'PEMS results'!$E$27","v":0},{"$f":"Sliding_Scale(E41,G41,H41,I41,0,Slide_Type)","v":3},{"$f":"limits!$J$17","v":60000000000},{"$f":"IF(Petrol,limits!H$9,IF(Diesel,limits!I$9,0))","v":900000000000},3]
[null,"Regulatory performance PEMS+ ",null,null,null,{"$f":"IF(OR(E37:E41>limits!$J$5:$J$9),0,MAX(SUM('Clean Air'!F37:F41),0))","v":7}]
[]
[null,"1.3","Robustness "]
[null,"BAB130","max points",{"$f":"SUM(I46:I50)","v":9}]
[null,null,"HC","mg/km",{"$f":"'Lab results'!$C$48","v":0},{"$f":"Sliding_Scale(E46,G46,H46,I46,0,Slide_Type)","v":2},{"$f":"limits!$D$13","v":45},{"$f":"IF(Petrol,limits!C$5,IF(Diesel,limits!D$5,0))","v":100},2]
[null,null,"NOx","mg/km",{"$f":"'Lab results'!$F$48","v":0},{"$f":"Sliding_Scale(E47,G47,H47,I47,0,Slide_Type)","v":3},{"$f":"limits!$D$14","v":30},{"$f":"IF(Petrol,limits!C$6,IF(Diesel,limits!D$6,0))","v":60},3]
[null,null,"CO","mg/km",{"$f":"'Lab results'!$B$48","v":0},{"$f":"Sliding_Scale(E48,G48,H48,I48,0,Slide_Type)","v":1},{"$f":"limits!$D$15","v":250},{"$f":"IF(Petrol,limits!C$7,IF(Diesel,limits!D$7,0))","v":1000},1]
[null,null,"PM","mg/km",{"$f":"'Lab results'!$G$48","v":0},{"$f":"Sliding_Scale(E49,G49,H49,I49,0,Slide_Type)","v":0},{"$f":"limits!$D$16","v":2.25},{"$f":"IF(Petrol,limits!C$7,IF(Diesel,limits!D$7,0))","v":1000},0]
[null,null,"PN",null,{"$f":"'Lab results'!$H$48","v":0},{"$f":"Sliding_Scale(E50,G50,H50,I50,0,Slide_Type)","v":3},{"$f":"limits!$D$17","v":60000000000},{"$f":"IF(Petrol,limits!C$9,IF(Diesel,limits!D$9,0))","v":600000000000},3]
[null,null,null,null,null,{"$f":"IF(OR(E46:E50>limits!$E$5:$E$9,ISERROR(F46:F50)),0,MAX(SUM('Clean Air'!F46:F50),0))","v":9}]
[null,"suppl. PEMS 1)","max points",{"$f":"SUM(I53:I57)","v":0}]
[null,null,"HC","mg/km",{"$f":"'PEMS results'!$F$13","v":0},{"$f":"Sliding_Scale(E53,G53,H53,I53,0,Slide_Type)","v":0},{"$f":"limits!$J$13","v":45},{"$f":"IF(Petrol,limits!H$5,IF(Diesel,limits!I$5,0))","v":150},0]
[null,null,"NOx","mg/km",{"$f":"'PEMS results'!$D$13","v":0},{"$f":"Sliding_Scale(E54,G54,H54,I54,0,Slide_Type)","v":0},{"$f":"limits!$J$14","v":30},{"$f":"IF(Petrol,limits!H$6,IF(Diesel,limits!I$6,0))","v":90},0]
[null,null,"CO","mg/km",{"$f":"'PEMS results'!$C$13","v":0},{"$f":"Sliding_Scale(E55,G55,H55,I55,0,Slide_Type)","v":0},{"$f":"limits!$J$15","v":250},{"$f":"IF(Petrol,limits!H$7,IF(Diesel,limits!I$7,0))","v":1500},0]
[null,null,"PM","mg/km",null,{"$f":"Sliding_Scale(E56,G56,H56,I56,0,Slide_Type)","v":0},{"$f":"limits!$J$16","v":2.25},{"$f":"IF(Petrol,limits!H$8,IF(Diesel,limits!I$8,0))","v":6.75},0]
[null,null,"PN",null,{"$f":"'PEMS results'!$E$13","v":0},{"$f":"Sliding_Scale(E57,G57,H57,I57,0,Slide_Type)","v":0},{"$f":"limits!$J$17","v":60000000000},{"$f":"IF(Petrol,limits!H$9,IF(Diesel,limits!I$9,0))","v":900000000000},0]
[null,null,null,null,null,0]
[null,"1): test not operational yet"]
[]
[null,"SUMMARY"]
[null,{"$f":"B5","v":"1.1"},{"$f":"C5","v":"Regulatory Tailpipe Emission Lab Tests"},{"$f":"SUM(D6,D13,D20,D27)","v":18},null,{"$f":"SUM(F12,F19,F26,F33)","v":18}]
[null,{"$f":"B35","v":"1.2"},{"$f":"C35","v":"Regulatory performance PEMS+ "},{"$f":"SUM(D36)","v":7},null,{"$f":"SUM(F42)","v":7}]
[null,{"$f":"B44","v":"1.3"},{"$f":"C44","v":"Robustness "},{"$f":"SUM(D45,D52)","v":9},null,{"$f":"SUM(F51,F58)","v":9}]
[null,"TOTAL",null,{"$f":"SUM(D62:D64)","v":34},null,{"$f":"SUM(F62:F64)","v":34}]
[]
[]
[]
[null,"TOTAL SCORE POLLUTANTS",null,"(0-10pts)",null,{"$f":"10*F65/D65","v":10}]

{"sheet":"Efficiency","index":2,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[24,10,24,15],[42,2,42,4],[51,5,51,6],[29,1,29,2],[48,1,48,2],[41,1,41,2],[48,5,48,6],[3,1,3,2],[37,1,37,2],[1,8,3,8],[1,1,2,2],[1,4,2,5],[1,6,2,7],[8,1,9,1],[11,1,12,1],[13,1,13,2],[17,1,20,1],[22,1,23,1],[24,1,24,2]]}
[]
[null,"2. Efficiency",null,null,"Test Results",null,"Limits",null,"Max score"]
[]
[null,null,null,null,"Value","Points","lower","upper"]
[]
[null,"2.1","Test cycle measurements"]
[null,"2.1.1","CO2 emissions"]
[null,null,"max points",{"$f":"IF(SPECS!H4=1,SUM(I9:I13),IF(SPECS!H6=1,SUM(I9:I13),0))","v":0}]
[null,"Lab tests","WLTC","mg/km",{"$f":"'Lab results'!$I$10","v":0},{"$f":"IF(E9>=H9,0,IF(E9<=G9, I9,I9-(E9-G9)/(H9-G9)*I9))","v":0},60,150,0]
[null,null,"WLTC warm","mg/km",{"$f":"'Lab results'!$I$20","v":0},{"$f":"IF(E10>=H10,0,IF(E10<=G10, I10,I10-(E10-G10)/(H10-G10)*I10))","v":0},60,150,0]
[null,"PEMS","PEMS+","mg/km",{"$f":"'PEMS results'!B27","v":0},{"$f":"IF(E11>=H11,0,IF(E11<=G11, I11,I11-(E11-G11)/(H11-G11)*I11))","v":0},60,150,0]
[null,"robustness","Bab130","mg/km",{"$f":"'Lab results'!$I$48","v":0},0,60,150,0]
[null,null,"suppl. PEMS","mg/km",{"$f":"'PEMS results'!B13","v":0},0,60,150,0]
[null,"total",null,null,null,{"$f":"IF(D8>0,SUM(F9:F13), \"n/a\")","v":"n/a"}]
[]
[null,"2.1.2","Energy Consumption (total)",null,null,null,null,null,null,null,"2.1.2.1",null,null,"2.1.2.2"]
[null,null,"max points",{"$f":"I25","v":29},null,null,null,null,null,null,"Fuel Consumption (ICE)",null,null,"Energy Consumption (EV)"]
[null,"Lab tests","WLTC","kWh/100km",{"$f":"IF(Petrol,Efficiency!M18*limits!$C$22,IF(Diesel,Efficiency!M18*limits!$C$23,0))+P18","v":0},{"$f":"IF(E18>=H18,0,IF(E18<=G18, I18,I18-(E18-G18)/(H18-G18)*I18))","v":10},40,90,10,null,"WLTC-cold1","l/100km",{"$f":"IF(OR(Petrol,Diesel),'Lab results'!J10,0)","v":0},"WLTC-cold1","kWh/100km",{"$f":"IF(Electric,'Lab results'!W10,0)","v":0}]
[null,null,"WLTC-warm","kWh/100km",{"$f":"IF(Petrol,Efficiency!M19*limits!$C$22,IF(Diesel,Efficiency!M19*limits!$C$23,0))+P19","v":0},{"$f":"IF(E19>=H19,0,IF(E19<=G19, I19,I19-(E19-G19)/(H19-G19)*I19))","v":3},40,90,3,null,"WLTC-warm","l/100km",{"$f":"IF(OR(Petrol,Diesel),'Lab results'!J20,\"\")","v":0},"WLTC-warm","kWh/100km",{"$f":"IF(Electric,'Lab results'!W20,0)","v":0}]
[null,null,"WLTC -eco","kWh/100km",{"$f":"IF(Petrol,Efficiency!M20*limits!$C$22,IF(Diesel,Efficiency!M20*limits!$C$23,0))+P20","v":0},3,40,90,3,null,"WLTC -eco","l/100km",{"$f":"IF(OR(Petrol,Diesel),'Lab results'!J30,\"\")","v":0},"WLTC -eco","kWh/100km",{"$f":"IF(Electric,'Lab results'!W30,0)","v":0}]
[null,null,"WLTC-sport","kWh/100km",{"$f":"IF(Petrol,Efficiency!M21*limits!$C$22,IF(Diesel,Efficiency!M21*limits!$C$23,0))+P21","v":0},{"$f":"IF(E21>=H21,0,IF(E21<=G21, I21,I21-(E21-G21)/(H21-G21)*I21))","v":3},40,90,3,null,"WLTC-sport","l/100km",{"$f":"IF(OR(Petrol,Diesel),'Lab results'!$J$40,\"\")","v":0},"WLTC-sport","kWh/100km",{"$f":"IF(Electric,'Lab results'!W40,0)","v":0}]
[null,"PEMS","PEMS+","kWh/100km",{"$f":"IF(Petrol,Efficiency!M22*limits!$C$22,IF(Diesel,Efficiency!M22*limits!$C$23,0))+P22","v":0},null,40,90,0,null,"PEMS+","l/100km",null,"PEMS+","kWh/100km"]
[null,"robustness","Bab130","kWh/100km",{"$f":"IF(Petrol,Efficiency!M23*limits!$C$22,IF(Diesel,Efficiency!M23*limits!$C$23,0))+P23","v":0},10,40,90,10,null,"Bab130","l/100km",{"$f":"IF(OR(Petrol,Diesel),'Lab results'!$J$48,\"\")","v":0},"Bab130","kWh/100km",{"$f":"IF(Electric,'Lab results'!W48,0)","v":0}]
[null,null,"suppl. PEMS","kWh/100km",{"$f":"IF(Petrol,Efficiency!M24*limits!$C$22,IF(Diesel,Efficiency!M24*limits!$C$23,0))+P24","v":0},0,40,90,0,null,"suppl. PEMS","l/100km",null,"suppl. PEMS","kWh/100km"]
[null,"total",null,null,null,{"$f":"SUM(F18:F24)","v":29},null,null,{"$f":"SUM(I18:I24)","v":29}]
[]
[null,"2.2","Driving Range 1)"]
[null,null,"max points",{"$f":"SUM(I29:I29)","v":0}]
[null,null,null,"km",null,{"$f":"IF(E29>=H29,$I$29,IF(E29<=G29,0,(E29-G29)/(H29-G29)*I29))","v":0},800,1500,0]
[null,"total",null,null,null,{"$f":"SUM(F29:F29)","v":0}]
[]
[]
[null,"2.3","Driving Resistance 1)"]
[null,null,"max points",{"$f":"I38","v":5},null,null,null,null,5]
[null,null,"vehicle mass","kg",null,null,null,null,0]
[null,null,"rolling resistance","N",null,null,null,null,0]
[null,null,"Aerodynamic Drag","N/km",null,null,null,null,0]
[null,"total",null,null,null,{"$f":"SUM(F37:F37)","v":0},null,null,{"$f":"SUM(I34:I37)","v":5}]
[]
[null,"1): test not operational yet"]
[]
[null,"SUMMARY",null,"max points","scored points"]
[null,"2.1","Test cycle measuments"]
[null,{"$f":"B7","v":"2.1.1"},{"$f":"C7","v":"CO2 emissions"},{"$f":"D8","v":0},{"$f":"F14","v":"n/a"}]
[null,{"$f":"B16","v":"2.1.2"},{"$f":"C16","v":"Energy Consumption (total)"},{"$f":"D17","v":29},{"$f":"F25","v":29}]
[null,{"$f":"B27","v":"2.2"},{"$f":"C27","v":"Driving Range 1)"},{"$f":"D28","v":0},{"$f":"F30","v":0}]
[null,{"$f":"B33","v":"2.3"},{"$f":"C33","v":"Driving Resistance 1)"},{"$f":"D34","v":5},{"$f":"F38","v":0}]
[]
[null,"TOTAL",null,{"$f":"SUM(D44:D47)","v":34},{"$f":"SUM(E44:E47)","v":29}]
[]
[]
[null,"TOTAL SCORE EFFICIENCY",null,null,{"$f":"10*E49/D49","v":8.5294117647058822},"(0-10pts)"]

{"sheet":"limits","index":3,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,1,20,9],[2,1,2,3],[10,1,10,3],[11,1,11,3],[0,1,0,9],[19,1,19,9],[10,7,10,9],[11,7,11,9],[12,7,12,8],[13,7,13,8],[15,7,15,8],[16,7,16,8],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[14,7,14,8]]}
[null,"Pollutants"]
[]
[null,"u p p e r   l i m i t s (labtests)",null,null,"gross excess",null,"u p p e r   l i m i t s (PEMS tests)",null,null,"gross excess"]
[null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"},null,null,"petrol","diesel",{"$f":"IF(Petrol,\"petrol\",IF(Diesel,\"diesel\",\"n.a\"))","v":"petrol"}]
[null,"HC",100,90,{"$f":"IF(Petrol,1.5*C5,IF(Diesel,1.5*D5,\"n.a.\"))","v":150},null,"HC",{"$f":"C5*$J$10","v":150},135,{"$f":"IF(Petrol,1.5*H5,IF(Diesel,1.5*I5,\"n.a.\"))","v":225}]
[null,"NOx",60,80,{"$f":"IF(Petrol,1.5*C6,IF(Diesel,1.5*D6,\"n.a.\"))","v":90},null,"NOx",90,120,{"$f":"IF(Petrol,1.5*H6,IF(Diesel,1.5*I6,\"n.a.\"))","v":135}]
[null,"CO",1000,500,{"$f":"IF(Petrol,1.5*C7,IF(Diesel,1.5*D7,\"n.a.\"))","v":1500},null,"CO",1500,750,{"$f":"IF(Petrol,1.5*H7,IF(Diesel,1.5*I7,\"n.a.\"))","v":2250}]
[null,"PM",4.5,4.5,{"$f":"IF(Petrol,1.5*C8,IF(Diesel,1.5*D8,\"n.a.\"))","v":6.75},null,"PM",6.75,6.75,{"$f":"IF(Petrol,1.5*H8,IF(Diesel,1.5*I8,\"n.a.\"))","v":10.125}]
[null,"PN",600000000000,600000000000,6000000000000,null,"PN",900000000000,900000000000,6000000000000]
[null,null,null,null,null,null,null,null,"CF:",1.5]
[null,"l o w e r     l i m i t s (labtests)",null,null,null,null,null,"l o w e r     l i m i t s (PEMS tests)"]
[null,"petrol AND diesel",null,null,null,null,null,"petrol AND diesel"]
[null,"HC",null,{"$f":"MIN(C5:D5)/2","v":45},null,null,null,"HC",null,{"$f":"D13","v":45}]
[null,"NOx",null,{"$f":"MIN(C6:D6)/2","v":30},null,null,null,"NOx",null,{"$f":"D14","v":30}]
[null,"CO",null,250,null,null,null,"CO",null,{"$f":"D15","v":250}]
[null,"PM",null,2.25,null,null,null,"PM",null,{"$f":"D16","v":2.25}]
[null,"PN",null,{"$f":"MIN(C9:D9)/10","v":60000000000},null,null,null,"PN",null,{"$f":"D17","v":60000000000}]
[]
[]
[null,"Energy / fuel consumption"]
[null,"multiplication fuel (l/100km) -> energy (kWh/100km)"]
[null,"Petrol",8.67090909090909]
[null,"Diesel",9.8609756097560979]
[null,"Electric",1]

{"sheet":"SPECS","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Brand",null,null,null,null,null,null,null,null,null,null,"Petrol",{"$f":"IF(ICE_Type=1,TRUE,FALSE)","v":true},1]
["Model:",null,null,null,null,null,null,null,null,null,null,"Diesel",{"$f":"IF(ICE_Type=2,TRUE,FALSE)","v":false},false]
["Applies to VIN:",null,null,null,null,null,null,null,null,null,null,"Petrol Hybrid",false]
["VIN tested vehicle: ",null,null,null,null,null,null,null,null,null,null,"Diesel Hybrid",false]
["Emission class and character:",null,null,null,null,null,null,null,null,null,null,"Electric",{"$f":"IF(N2,TRUE,FALSE)","v":false}]
["Country of registration:"]
["Model:"]
["Engine code:"]
["Engine volume (cm3):"]
["Engine power (kW):"]
["Gearbox type (auto/manual):"]
["Drive axle (FWD/AWD/RWD):"]
["Tyre size (front and rear if different): "]
["Vehicle mass (kg):"]

{"sheet":"Lab results","index":5,"n_rows":48,"n_cols":23,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,0,1,22],[11,0,11,22],[41,0,41,22],[21,0,21,22],[31,0,31,22]]}
[]
["WLTC-cold1"]
["Mass Emissions (Bag results)"]
["Phase","CO","THC","CH4","NMHC","NOx","PM","PN","CO2","Fuel consumption","ΔERESS\n(cf A6 Ap2 3.6)","ΔCO2\n(cf A6 Ap2 4.4)","RCB Corrected CO2","CO2","RCB Corrected CO2","CO","THC","CH4","NMHC","NOx","PM","PN","Energy\nConsum."]
["Unit","mg/km","mg/km","mg/km","mg/km","mg/km","mg/km","#/km","g/km","L/100km","-","g","g/km","g/kWh","g/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","#/kWh","kWh"]
[1]
[2]
[3]
[4]
["Global",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[]
["WLTC-warm"]
["Mass Emissions (Bag results)"]
["Phase","CO","THC","CH4","NMHC","NOx","PM","PN","CO2","Fuel consumption","ΔERESS\n(cf A6 Ap2 3.6)","ΔCO2\n(cf A6 Ap2 4.4)","RCB Corrected CO2","CO2","RCB Corrected CO2","CO","THC","CH4","NMHC","NOx","PM","PN","Energy\nConsum."]
["Unit","mg/km","mg/km","mg/km","mg/km","mg/km","mg/km","#/km","g/km","L/100km","-","g","g/km","g/kWh","g/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","#/kWh","kWh"]
[1]
[2]
[3]
[4]
["Global",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[]
["WLTC-warm - eco"]
["Mass Emissions (Bag results)"]
["Phase","CO","THC","CH4","NMHC","NOx","PM","PN","CO2","Fuel consumption","ΔERESS\n(cf A6 Ap2 3.6)","ΔCO2\n(cf A6 Ap2 4.4)","RCB Corrected CO2","CO2","RCB Corrected CO2","CO","THC","CH4","NMHC","NOx","PM","PN"]
["Unit","mg/km","mg/km","mg/km","mg/km","mg/km","mg/km","#/km","g/km","L/100km","-","g","g/km","g/kWh","g/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","#/kWh"]
[1]
[2]
[3]
[4]
["Global"]
[]
["WLTC-sport"]
["Mass Emissions (Bag results)"]
["Phase","CO","THC","CH4","NMHC","NOx","PM","PN","CO2","Fuel consumption","ΔERESS","ΔCO2","RCB Corrected CO2","CO2","RCB Corrected CO2","CO","THC","CH4","NMHC","NOx","PM","PN","Energy"]
["Unit","mg/km","mg/km","mg/km","mg/km","mg/km","mg/km","#/km","g/km","L/100km","-","g","g/km","g/kWh","g/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","#/kWh","kWh"]
[1]
[2]
[3]
[4]
["Global",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[]
["BAB130"]
["Mass Emissions (Bag results)"]
["Phase","CO","THC","CH4","NMHC","NOx","PM","PN","CO2","Fuel consumption","CO2","CO","THC","CH4","NMHC","NOx","PM","PN",null,null,null,null,"Energy\nConsum."]
["Unit","mg/km","mg/km","mg/km","mg/km","mg/km","mg/km","#/km","g/km","L/100km","g/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","mg/kWh","#/kWh",null,null,null,null,"kWh"]
[1]
[2]
["Global",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]

{"sheet":"PEMS results","index":6,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Robustness:"]
["Heavy Warm"]
["Emission Results Synthese"]
["Emission Results (Excluding Cold Start)","CO2 (g/km)","CO (mg/km)","NOx (mg/km)","PN (#/km)","THC (mg/km)","FC (l/100km)","EC (kWh/100km)","CO2 (g/kWh)","CO (mg/kWh)","NOx (mg/kWh)","PN (#/kWh)","THC (mg/kWh)"]
["URBAN"]
["RURAL"]
["MOTORWAY"]
["OVERAL"]
["Emission Results (Including Cold Start)","CO2 (g/km)","CO (mg/km)","NOx (mg/km)","PN (#/km)","THC (mg/km)","FC (l/100km)","EC (kWh/100km)","CO2 (g/kWh)","CO (mg/kWh)","NOx (mg/kWh)","PN (#/kWh)","THC (mg/kWh)"]
["URBAN"]
["RURAL"]
["MOTORWAY"]
["OVERALL"]
[]
["PEMS+"]
["Regular cold"]
["Emission Results Synthese"]
["Emission Results (Excluding Cold Start)","CO2 (g/km)","CO (mg/km)","NOx (mg/km)","PN (#/km)","THC (mg/km)","FC (l/100km)","EC (kWh/100km)","CO2 (g/kWh)","CO (mg/kWh)","NOx (mg/kWh)","PN (#/kWh)","THC (mg/kWh)"]
["URBAN"]
["RURAL"]
["MOTORWAY"]
["OVERAL"]
["Emission Results (Including Cold Start)","CO2 (g/km)","CO (mg/km)","NOx (mg/km)","PN (#/km)","THC (mg/km)","FC (l/100km)","EC (kWh/100km)","CO2 (g/kWh)","CO (mg/kWh)","NOx (mg/kWh)","PN (#/kWh)","THC (mg/kWh)"]
["URBAN"]
["RURAL"]
["MOTORWAY"]
["OVERALL"]