{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input","Lookup","Lists","Notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":"Input","index":0,"n_rows":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":false,"merged":[[23,1,23,2],[22,1,22,2],[0,0,2,4],[18,0,18,3],[18,4,18,8],[19,0,19,3],[19,4,19,8],[20,0,20,8],[26,22,27,23],[26,16,27,17],[26,19,27,20],[26,1,27,2],[25,10,25,11],[25,13,25,14],[25,16,25,17],[25,19,25,20],[26,4,27,5],[26,7,27,8],[26,10,27,11],[26,13,27,14],[25,1,25,2],[25,4,25,5],[25,7,25,8],[25,22,25,23],[20,9,20,13],[0,5,2,24],[3,0,3,24],[18,16,20,24],[4,0,17,24],[18,9,18,13],[18,14,20,15],[19,9,19,13]]}
[null,null,null,null,null,"Heathrow CVP Euro Standard Checking Tool"]
[]
[]
["Tool Information"]
["Vehicles comply with a specific regulatory emission standard when manufactured or first registered. In Europe these standards are called Euro Standards and apply to the pollutants nitrogen oxides (NOx), particulate matter (PM), carbon monoxide (CO) and hydrocarbons but not to CO2 or fuel consumption. The dates from which a Euro standard applies are defined in terms of type approval at year of manufacturer.  However, there is a grace period in the legisation between year of manufacturer and date of first registration to allow for stock holding.  This means that is it not always clear what standard a vehicle meets just from the year of registration as it may meet the latest standard or be an older version sold under the period of grace.  \n\nThe Heathrow Euro Standard Checking Tool allows identifying the emission standard of passenger cars, vans, heavy-goods vehicles and specialist GSE based on their date of manufacture or registration. This can be used when calculating the emisions performance of a vehicle or assessing whether it will meet a given emission standard in relation to local policy, regulation or incentive. To run the tool, the user is required to select the type of vehicle, fuel, engine size/type and provide either the date of manufacture or the date of registration. The tool will then automatically assign a Euro Standard and will provide an indication of the level of confidence of the estimate, based on the grace period between type approval and registration dates. Confidence levels can be either \"green\" or \"amber\". If the confidence level is \"amber\" then the registration date falls in the grace period, in this case the lower emission standard is assumed but the tool also indicates the alternative higher emission standard that it may comply with.  To be certain of the emission standard of a vehicle the actual date of manufactur is required.\n\nCaution! Date should be provided as DD/MM/YYYY. No future beyond 2050 are allowed. Do not overwrite the contents of the Euro Standard, Confidence and Alternative boxes. \nVersion: 2.1. Stable. QA/QC. \nReference: https://www.dieselnet.com\n                  http://emleg.com/  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Developed by:",null,null,null,"Michel Vedrenne",null,null,null,null,"michel.vedrenne@ricardo.com",null,null,null,null,"Comments:"]
["Managed by:",null,null,null,"Guy Hitchcock",null,null,null,null,"guy.hitchcock@ricardo.com"]
["Last Update:",null,null,null,null,null,null,null,null,"2016-11-30"]
[]
[null,"Date"]
[null,{"$f":"TODAY()","v":"2019-11-07"}]
[]
[null,"Vehicle Type",null,null,"Fuel Type",null,null,"Engine Size/Type",null,null,"Date",null,null,"Date Type",null,null,"Euro Standard",null,null,"Confidence",null,null,"Alternative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($AA$27&\"_1\",Lookup!$A$1:$N$175,COLUMN(Lookup!$M$1),FALSE),\"\")","v":""},null,null,"u",null,null,{"$f":"IFERROR(VLOOKUP($AA$27&\"_1\",Lookup!$A$1:$O$175,COLUMN(Lookup!$O$1),FALSE),\"\")","v":""},null,null,null,{"$f":"VehicleInput&\"_\"&FuelInput&\"_\"&EngineInput","v":"__"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($AA$27&\"_1\",Lookup!$A$1:$N$175,COLUMN(Lookup!$N$1),FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Lookup","index":1,"n_rows":176,"n_cols":15,"rows_kept":176,"cut":false,"hidden":true,"merged":[]}
["Code_Result","Pivot_Code","Vehicle Type","Fuel Type","Size","Activated","Type Approval Start","Type Approval End","Registration Start","Registration End","Manufacture","Registration","Euro Standard","Flag","Alternative"]
[{"$f":"B2&\"_\"&SUM(K2:L2)","v":"Car_Diesel_<1.4 l_0"},{"$f":"C2&\"_\"&D2&\"_\"&E2","v":"Car_Diesel_<1.4 l"},"Car","Diesel","<1.4 l",{"$f":"IF(B2=Input!$AA$27,1,0)","v":0},"1900-01-01",{"$f":"G3","v":"1992-07-01"},{"$f":"DATE(YEAR(G2)+1,MONTH(G2),DAY(G2))","v":"1901-01-01"},{"$f":"I3","v":"1993-07-01"},{"$f":"IF(AND(F2=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G2,DateInput<=H2),1,0),0)","v":0},{"$f":"IF(AND(F2=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I2,DateInput<=J2),1,0),0)","v":0},"Pre Euro 1",{"$f":"IF(AND(F2=1,K2=1),\"Green\",IF(AND(F2=1,L2=1),IF(AND(DateInput>H2,DateInput<=J2),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N2=\"Amber\",INDIRECT(ADDRESS(ROW(M2)+1,COLUMN(M2))),\"-\"))","v":"-"}]
[{"$f":"B3&\"_\"&SUM(K3:L3)","v":"Car_Diesel_<1.4 l_0"},{"$f":"C3&\"_\"&D3&\"_\"&E3","v":"Car_Diesel_<1.4 l"},{"$f":"C2","v":"Car"},{"$f":"D2","v":"Diesel"},{"$f":"E2","v":"<1.4 l"},{"$f":"IF(B3=Input!$AA$27,1,0)","v":0},"1992-07-01",{"$f":"G4","v":"1996-01-01"},"1993-07-01",{"$f":"I4","v":"1997-01-01"},0,0,"Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N3=\"Amber\",INDIRECT(ADDRESS(ROW(M3)+1,COLUMN(M3))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l",{"$f":"C3","v":"Car"},{"$f":"D3","v":"Diesel"},{"$f":"E3","v":"<1.4 l"},{"$f":"IF(B4=Input!$AA$27,1,0)","v":0},"1996-01-01",{"$f":"G6","v":"2000-01-01"},"1997-01-01",{"$f":"I6","v":"2001-01-01"},0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N4=\"Amber\",INDIRECT(ADDRESS(ROW(M4)+2,COLUMN(M4))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l","Car","Diesel","<1.4 l",{"$f":"IF(B5=Input!$AA$27,1,0)","v":0},"1996-01-01",{"$f":"H4","v":"2000-01-01"},{"$f":"I4","v":"1997-01-01"},{"$f":"J4","v":"2001-01-01"},0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N5=\"Amber\",INDIRECT(ADDRESS(ROW(M5)+1,COLUMN(M5))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l",{"$f":"C5","v":"Car"},{"$f":"D5","v":"Diesel"},{"$f":"E5","v":"<1.4 l"},{"$f":"IF(B6=Input!$AA$27,1,0)","v":0},"2000-01-01",{"$f":"G7","v":"2005-01-01"},"2001-01-01",{"$f":"I7","v":"2006-01-01"},0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N6=\"Amber\",INDIRECT(ADDRESS(ROW(M6)+1,COLUMN(M6))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l","Car","Diesel","<1.4 l",{"$f":"IF(B7=Input!$AA$27,1,0)","v":0},"2005-01-01",{"$f":"G8","v":"2009-09-01"},"2006-01-01",{"$f":"I8","v":"2011-01-01"},0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N7=\"Amber\",INDIRECT(ADDRESS(ROW(M7)+1,COLUMN(M7))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l","Car","Diesel","<1.4 l",{"$f":"IF(B8=Input!$AA$27,1,0)","v":0},"2009-09-01",{"$f":"G9","v":"2011-09-01"},"2011-01-01",{"$f":"I9","v":"2013-01-01"},0,0,"Euro 5a",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N8=\"Amber\",INDIRECT(ADDRESS(ROW(M8)+1,COLUMN(M8))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l","Car","Diesel","<1.4 l",{"$f":"IF(B9=Input!$AA$27,1,0)","v":0},"2011-09-01",{"$f":"G10","v":"2014-09-01"},"2013-01-01",{"$f":"I10","v":"2015-09-01"},0,0,"Euro 5b",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N9=\"Amber\",INDIRECT(ADDRESS(ROW(M9)+1,COLUMN(M9))),\"-\"))","v":"-"}]
["Car_Diesel_<1.4 l_0","Car_Diesel_<1.4 l","Car","Diesel","<1.4 l",{"$f":"IF(B10=Input!$AA$27,1,0)","v":0},"2014-09-01","2050-01-01",{"$f":"DATE(YEAR(G10)+1,MONTH(G10),DAY(G10))","v":"2015-09-01"},"2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N10=\"Amber\",INDIRECT(ADDRESS(ROW(M10)+1,COLUMN(M10))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car","Petrol","<1.4 l",{"$f":"IF(B11=Input!$AA$27,1,0)","v":0},"1900-01-01",{"$f":"G12","v":"1992-07-01"},"1901-01-01",{"$f":"I12","v":"1993-07-01"},0,0,"Pre Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N11=\"Amber\",INDIRECT(ADDRESS(ROW(M11)+1,COLUMN(M11))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car",{"$f":"D11","v":"Petrol"},"<1.4 l",{"$f":"IF(B12=Input!$AA$27,1,0)","v":0},"1992-07-01","1996-01-01","1993-07-01","1997-01-01",0,0,"Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N12=\"Amber\",INDIRECT(ADDRESS(ROW(M12)+1,COLUMN(M12))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car","Petrol","<1.4 l",{"$f":"IF(B13=Input!$AA$27,1,0)","v":0},"1996-01-01","2000-01-01","1997-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N13=\"Amber\",INDIRECT(ADDRESS(ROW(M13)+1,COLUMN(M13))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car","Petrol","<1.4 l",{"$f":"IF(B14=Input!$AA$27,1,0)","v":0},"2000-01-01","2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N14=\"Amber\",INDIRECT(ADDRESS(ROW(M14)+1,COLUMN(M14))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car","Petrol","<1.4 l",{"$f":"IF(B15=Input!$AA$27,1,0)","v":0},"2005-01-01","2009-09-01","2006-01-01","2011-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N15=\"Amber\",INDIRECT(ADDRESS(ROW(M15)+1,COLUMN(M15))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car","Petrol","<1.4 l",{"$f":"IF(B16=Input!$AA$27,1,0)","v":0},"2009-09-01","2014-09-01","2011-01-01","2015-09-01",0,0,"Euro 5",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N16=\"Amber\",INDIRECT(ADDRESS(ROW(M16)+1,COLUMN(M16))),\"-\"))","v":"-"}]
["Car_Petrol_<1.4 l_0","Car_Petrol_<1.4 l","Car","Petrol","<1.4 l",{"$f":"IF(B17=Input!$AA$27,1,0)","v":0},"2014-09-01","2050-01-01",{"$f":"DATE(YEAR(G17)+1,MONTH(G17),DAY(G17))","v":"2015-09-01"},{"$f":"J10","v":"2050-01-01"},0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N17=\"Amber\",INDIRECT(ADDRESS(ROW(M17)+1,COLUMN(M17))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car",{"$f":"D2","v":"Diesel"},"1.4-2.0 l",{"$f":"IF(B18=Input!$AA$27,1,0)","v":0},{"$f":"G2","v":"1900-01-01"},"1992-07-01","1901-01-01","1993-07-01",0,0,{"$f":"M2","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N18=\"Amber\",INDIRECT(ADDRESS(ROW(M18)+1,COLUMN(M18))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car",{"$f":"D3","v":"Diesel"},{"$f":"E18","v":"1.4-2.0 l"},{"$f":"IF(B19=Input!$AA$27,1,0)","v":0},"1992-07-01","1996-01-01","1993-07-01","1997-01-01",0,0,{"$f":"M3","v":"Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N19=\"Amber\",INDIRECT(ADDRESS(ROW(M19)+1,COLUMN(M19))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car",{"$f":"D4","v":"Diesel"},{"$f":"E19","v":"1.4-2.0 l"},{"$f":"IF(B20=Input!$AA$27,1,0)","v":0},"1996-01-01","2000-01-01","1997-01-01","2001-01-01",0,0,{"$f":"M4","v":"Euro 2"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N20=\"Amber\",INDIRECT(ADDRESS(ROW(M20)+2,COLUMN(M20))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car",{"$f":"D5","v":"Diesel"},"1.4-2.0 l",{"$f":"IF(B21=Input!$AA$27,1,0)","v":0},"1996-01-01","2000-01-01","1997-01-01","2001-01-01",0,0,{"$f":"M5","v":"Euro 2"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N21=\"Amber\",INDIRECT(ADDRESS(ROW(M21)+1,COLUMN(M21))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car",{"$f":"D6","v":"Diesel"},"1.4-2.0 l",{"$f":"IF(B22=Input!$AA$27,1,0)","v":0},{"$f":"G6","v":"2000-01-01"},"2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N22=\"Amber\",INDIRECT(ADDRESS(ROW(M22)+1,COLUMN(M22))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car","Diesel","1.4-2.0 l",{"$f":"IF(B23=Input!$AA$27,1,0)","v":0},{"$f":"G7","v":"2005-01-01"},"2009-09-01","2006-01-01","2011-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N23=\"Amber\",INDIRECT(ADDRESS(ROW(M23)+1,COLUMN(M23))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car","Diesel","1.4-2.0 l",{"$f":"IF(B24=Input!$AA$27,1,0)","v":0},{"$f":"G8","v":"2009-09-01"},"2011-09-01","2011-01-01","2013-01-01",0,0,"Euro 5a",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N24=\"Amber\",INDIRECT(ADDRESS(ROW(M24)+1,COLUMN(M24))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car","Diesel","1.4-2.0 l",{"$f":"IF(B25=Input!$AA$27,1,0)","v":0},{"$f":"G9","v":"2011-09-01"},"2014-09-01","2013-01-01","2015-09-01",0,0,"Euro 5b",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N25=\"Amber\",INDIRECT(ADDRESS(ROW(M25)+1,COLUMN(M25))),\"-\"))","v":"-"}]
["Car_Diesel_1.4-2.0 l_0","Car_Diesel_1.4-2.0 l","Car","Diesel","1.4-2.0 l",{"$f":"IF(B26=Input!$AA$27,1,0)","v":0},{"$f":"G10","v":"2014-09-01"},"2050-01-01","2015-09-01","2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N26=\"Amber\",INDIRECT(ADDRESS(ROW(M26)+1,COLUMN(M26))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B27=Input!$AA$27,1,0)","v":0},{"$f":"G11","v":"1900-01-01"},"1992-07-01","1901-01-01","1993-07-01",0,0,"Pre Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N27=\"Amber\",INDIRECT(ADDRESS(ROW(M27)+1,COLUMN(M27))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B28=Input!$AA$27,1,0)","v":0},{"$f":"G12","v":"1992-07-01"},"1996-01-01","1993-07-01","1997-01-01",0,0,"Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N28=\"Amber\",INDIRECT(ADDRESS(ROW(M28)+1,COLUMN(M28))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B29=Input!$AA$27,1,0)","v":0},{"$f":"G13","v":"1996-01-01"},"2000-01-01","1997-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N29=\"Amber\",INDIRECT(ADDRESS(ROW(M29)+1,COLUMN(M29))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B30=Input!$AA$27,1,0)","v":0},{"$f":"G14","v":"2000-01-01"},"2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N30=\"Amber\",INDIRECT(ADDRESS(ROW(M30)+1,COLUMN(M30))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B31=Input!$AA$27,1,0)","v":0},{"$f":"G15","v":"2005-01-01"},"2009-09-01","2006-01-01","2011-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N31=\"Amber\",INDIRECT(ADDRESS(ROW(M31)+1,COLUMN(M31))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B32=Input!$AA$27,1,0)","v":0},{"$f":"G16","v":"2009-09-01"},"2014-09-01","2011-01-01","2015-09-01",0,0,"Euro 5",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N32=\"Amber\",INDIRECT(ADDRESS(ROW(M32)+1,COLUMN(M32))),\"-\"))","v":"-"}]
["Car_Petrol_1.4-2.0 l_0","Car_Petrol_1.4-2.0 l","Car","Petrol","1.4-2.0 l",{"$f":"IF(B33=Input!$AA$27,1,0)","v":0},{"$f":"G17","v":"2014-09-01"},"2050-01-01","2015-09-01","2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N33=\"Amber\",INDIRECT(ADDRESS(ROW(M33)+1,COLUMN(M33))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B34=Input!$AA$27,1,0)","v":0},{"$f":"G18","v":"1900-01-01"},"1992-07-01","1901-01-01","1993-07-01",{"$f":"IF(AND(F34=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G34,DateInput<=H34),1,0),0)","v":0},{"$f":"IF(AND(F34=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I34,DateInput<=J34),1,0),0)","v":0},"Pre Euro 1",{"$f":"IF(AND(F34=1,K34=1),\"Green\",IF(AND(F34=1,L34=1),IF(AND(DateInput>H34,DateInput<=J34),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N34=\"Amber\",INDIRECT(ADDRESS(ROW(M34)+1,COLUMN(M34))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",{"$f":"E34","v":">2.0 l"},{"$f":"IF(B35=Input!$AA$27,1,0)","v":0},{"$f":"G19","v":"1992-07-01"},"1996-01-01","1993-07-01","1997-01-01",0,0,"Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N35=\"Amber\",INDIRECT(ADDRESS(ROW(M35)+1,COLUMN(M35))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",{"$f":"E35","v":">2.0 l"},{"$f":"IF(B36=Input!$AA$27,1,0)","v":0},{"$f":"G20","v":"1996-01-01"},"2000-01-01","1997-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N36=\"Amber\",INDIRECT(ADDRESS(ROW(M36)+2,COLUMN(M36))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B37=Input!$AA$27,1,0)","v":0},{"$f":"G21","v":"1996-01-01"},"2000-01-01","1997-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N37=\"Amber\",INDIRECT(ADDRESS(ROW(M37)+1,COLUMN(M37))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B38=Input!$AA$27,1,0)","v":0},{"$f":"G22","v":"2000-01-01"},"2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N38=\"Amber\",INDIRECT(ADDRESS(ROW(M38)+1,COLUMN(M38))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B39=Input!$AA$27,1,0)","v":0},{"$f":"G23","v":"2005-01-01"},"2009-09-01","2006-01-01","2011-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N39=\"Amber\",INDIRECT(ADDRESS(ROW(M39)+1,COLUMN(M39))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B40=Input!$AA$27,1,0)","v":0},{"$f":"G24","v":"2009-09-01"},"2011-09-01","2011-01-01","2013-01-01",0,0,"Euro 5a",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N40=\"Amber\",INDIRECT(ADDRESS(ROW(M40)+1,COLUMN(M40))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B41=Input!$AA$27,1,0)","v":0},{"$f":"G25","v":"2011-09-01"},"2014-09-01","2013-01-01","2015-09-01",0,0,"Euro 5b",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N41=\"Amber\",INDIRECT(ADDRESS(ROW(M41)+1,COLUMN(M41))),\"-\"))","v":"-"}]
["Car_Diesel_>2.0 l_0","Car_Diesel_>2.0 l","Car","Diesel",">2.0 l",{"$f":"IF(B42=Input!$AA$27,1,0)","v":0},{"$f":"G26","v":"2014-09-01"},"2050-01-01","2015-09-01","2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N42=\"Amber\",INDIRECT(ADDRESS(ROW(M42)+1,COLUMN(M42))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B43=Input!$AA$27,1,0)","v":0},{"$f":"G27","v":"1900-01-01"},"1992-07-01","1901-01-01","1993-07-01",0,0,"Pre Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N43=\"Amber\",INDIRECT(ADDRESS(ROW(M43)+1,COLUMN(M43))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B44=Input!$AA$27,1,0)","v":0},{"$f":"G28","v":"1992-07-01"},"1996-01-01","1993-07-01","1997-01-01",0,0,"Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N44=\"Amber\",INDIRECT(ADDRESS(ROW(M44)+1,COLUMN(M44))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B45=Input!$AA$27,1,0)","v":0},{"$f":"G29","v":"1996-01-01"},"2000-01-01","1997-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N45=\"Amber\",INDIRECT(ADDRESS(ROW(M45)+1,COLUMN(M45))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B46=Input!$AA$27,1,0)","v":0},{"$f":"G30","v":"2000-01-01"},"2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N46=\"Amber\",INDIRECT(ADDRESS(ROW(M46)+1,COLUMN(M46))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B47=Input!$AA$27,1,0)","v":0},{"$f":"G31","v":"2005-01-01"},"2009-09-01","2006-01-01","2011-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N47=\"Amber\",INDIRECT(ADDRESS(ROW(M47)+1,COLUMN(M47))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B48=Input!$AA$27,1,0)","v":0},{"$f":"G32","v":"2009-09-01"},"2014-09-01","2011-01-01","2015-09-01",0,0,"Euro 5",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N48=\"Amber\",INDIRECT(ADDRESS(ROW(M48)+1,COLUMN(M48))),\"-\"))","v":"-"}]
["Car_Petrol_>2.0 l_0","Car_Petrol_>2.0 l","Car","Petrol",">2.0 l",{"$f":"IF(B49=Input!$AA$27,1,0)","v":0},{"$f":"G33","v":"2014-09-01"},"2050-01-01","2015-09-01","2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N49=\"Amber\",INDIRECT(ADDRESS(ROW(M49)+1,COLUMN(M49))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B50=Input!$AA$27,1,0)","v":0},{"$f":"G34","v":"1900-01-01"},{"$f":"G51","v":"1994-10-01"},{"$f":"DATE(YEAR(G50)+1,MONTH(G50),DAY(G50))","v":"1901-01-01"},{"$f":"I51","v":"1995-10-01"},0,0,{"$f":"M34","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N50=\"Amber\",INDIRECT(ADDRESS(ROW(M50)+1,COLUMN(M50))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg",{"$f":"C50","v":"Van"},{"$f":"D50","v":"Diesel"},"N1 (I) - ≤1305 kg",{"$f":"IF(B51=Input!$AA$27,1,0)","v":0},"1994-10-01",{"$f":"G52","v":"1998-01-01"},"1995-10-01",{"$f":"I52","v":"1999-01-01"},0,0,{"$f":"M35","v":"Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N51=\"Amber\",INDIRECT(ADDRESS(ROW(M51)+1,COLUMN(M51))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg",{"$f":"C51","v":"Van"},"Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B52=Input!$AA$27,1,0)","v":0},"1998-01-01",{"$f":"G54","v":"2000-01-01"},"1999-01-01",{"$f":"I54","v":"2001-01-01"},0,0,"Euro 2",{"$f":"IF(AND(F52=1,K52=1),\"Green\",IF(AND(F52=1,L52=1),IF(AND(DateInput>H52,DateInput<=J52),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N52=\"Amber\",INDIRECT(ADDRESS(ROW(M52)+2,COLUMN(M52))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B53=Input!$AA$27,1,0)","v":0},"1998-01-01",{"$f":"H5","v":"2000-01-01"},"1999-01-01",{"$f":"J37","v":"2001-01-01"},0,{"$f":"IF(AND(F53=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I53,DateInput<=J53),1,0),0)","v":0},"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N53=\"Amber\",INDIRECT(ADDRESS(ROW(M53)+1,COLUMN(M53))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B54=Input!$AA$27,1,0)","v":0},"2000-01-01",{"$f":"G55","v":"2005-01-01"},"2001-01-01",{"$f":"I55","v":"2006-01-01"},0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N54=\"Amber\",INDIRECT(ADDRESS(ROW(M54)+1,COLUMN(M54))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B55=Input!$AA$27,1,0)","v":0},"2005-01-01",{"$f":"G56","v":"2009-09-01"},"2006-01-01",{"$f":"I56","v":"2010-09-01"},0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N55=\"Amber\",INDIRECT(ADDRESS(ROW(M55)+1,COLUMN(M55))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B56=Input!$AA$27,1,0)","v":0},"2009-09-01",{"$f":"G57","v":"2011-09-01"},"2010-09-01",{"$f":"I57","v":"2012-09-01"},0,0,"Euro 5a",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N56=\"Amber\",INDIRECT(ADDRESS(ROW(M56)+1,COLUMN(M56))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B57=Input!$AA$27,1,0)","v":0},"2011-09-01",{"$f":"G58","v":"2014-09-01"},"2012-09-01",{"$f":"I58","v":"2015-09-01"},0,0,"Euro 5b",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N57=\"Amber\",INDIRECT(ADDRESS(ROW(M57)+1,COLUMN(M57))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (I) - ≤1305 kg_0","Van_Diesel_N1 (I) - ≤1305 kg","Van","Diesel","N1 (I) - ≤1305 kg",{"$f":"IF(B58=Input!$AA$27,1,0)","v":0},"2014-09-01",{"$f":"H49","v":"2050-01-01"},"2015-09-01",{"$f":"J49","v":"2050-01-01"},0,0,{"$f":"M42","v":"Euro 6"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N58=\"Amber\",INDIRECT(ADDRESS(ROW(M58)+1,COLUMN(M58))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg",{"$f":"C58","v":"Van"},{"$f":"D58","v":"Diesel"},"N1 (II) - 1305-1760 kg",{"$f":"IF(B59=Input!$AA$27,1,0)","v":0},{"$f":"G50","v":"1900-01-01"},{"$f":"G60","v":"1994-10-01"},"1901-01-01",{"$f":"I60","v":"1995-10-01"},0,0,{"$f":"M50","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N59=\"Amber\",INDIRECT(ADDRESS(ROW(M59)+1,COLUMN(M59))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel",{"$f":"E59","v":"N1 (II) - 1305-1760 kg"},{"$f":"IF(B60=Input!$AA$27,1,0)","v":0},{"$f":"G51","v":"1994-10-01"},{"$f":"G61","v":"1998-01-01"},"1995-10-01",{"$f":"I61","v":"1999-01-01"},0,0,{"$f":"M51","v":"Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N60=\"Amber\",INDIRECT(ADDRESS(ROW(M60)+1,COLUMN(M60))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel",{"$f":"E60","v":"N1 (II) - 1305-1760 kg"},{"$f":"IF(B61=Input!$AA$27,1,0)","v":0},"1998-01-01",{"$f":"G63","v":"2000-01-01"},"1999-01-01",{"$f":"I63","v":"2001-01-01"},0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N61=\"Amber\",INDIRECT(ADDRESS(ROW(M61)+2,COLUMN(M61))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel","N1 (II) - 1305-1760 kg",{"$f":"IF(B62=Input!$AA$27,1,0)","v":0},"1998-01-01",{"$f":"H5","v":"2000-01-01"},"1999-01-01",{"$f":"I63","v":"2001-01-01"},0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N62=\"Amber\",INDIRECT(ADDRESS(ROW(M62)+1,COLUMN(M62))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel","N1 (II) - 1305-1760 kg",{"$f":"IF(B63=Input!$AA$27,1,0)","v":0},"2000-01-01",{"$f":"G64","v":"2005-01-01"},"2001-01-01",{"$f":"I64","v":"2006-01-01"},0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N63=\"Amber\",INDIRECT(ADDRESS(ROW(M63)+1,COLUMN(M63))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel","N1 (II) - 1305-1760 kg",{"$f":"IF(B64=Input!$AA$27,1,0)","v":0},"2005-01-01",{"$f":"G65","v":"2009-09-01"},"2006-01-01",{"$f":"I65","v":"2010-09-01"},0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N64=\"Amber\",INDIRECT(ADDRESS(ROW(M64)+1,COLUMN(M64))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel","N1 (II) - 1305-1760 kg",{"$f":"IF(B65=Input!$AA$27,1,0)","v":0},"2009-09-01",{"$f":"G66","v":"2011-09-01"},"2010-09-01",{"$f":"I66","v":"2012-09-01"},0,0,"Euro 5a",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N65=\"Amber\",INDIRECT(ADDRESS(ROW(M65)+1,COLUMN(M65))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (II) - 1305-1760 kg_0","Van_Diesel_N1 (II) - 1305-1760 kg","Van","Diesel","N1 (II) - 1305-1760 kg",{"$f":"IF(B66=Input!$AA$27,1,0)","v":0},"2011-09-01",{"$f":"G67","v":"2015-09-01"},"2012-09-01",{"$f":"I67","v":"2016-09-01"},{"$f":"IF(AND(F66=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G66,DateInput<=H66),1,0),0)","v":0},{"$f":"IF(AND(F66=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I66,DateInput<=J66),1,0),0)","v":0},"Euro 5b",{"$f":"IF(AND(F66=1,K66=1),\"Green\",IF(AND(F66=1,L66=1),IF(AND(DateInput>H66,DateInput<=J66),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N66=\"Amber\",INDIRECT(ADDRESS(ROW(M66)+1,COLUMN(M66))),\"-\"))","v":"-"}]
[{"$f":"B67&\"_\"&SUM(K67:L67)","v":"Van_Diesel_N1 (II) - 1305-1760 kg_0"},{"$f":"C67&\"_\"&D67&\"_\"&E67","v":"Van_Diesel_N1 (II) - 1305-1760 kg"},"Van","Diesel","N1 (II) - 1305-1760 kg",{"$f":"IF(B67=Input!$AA$27,1,0)","v":0},"2015-09-01",{"$f":"H58","v":"2050-01-01"},"2016-09-01",{"$f":"J58","v":"2050-01-01"},0,0,{"$f":"M58","v":"Euro 6"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N67=\"Amber\",INDIRECT(ADDRESS(ROW(M67)+1,COLUMN(M67))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B68=Input!$AA$27,1,0)","v":0},{"$f":"G59","v":"1900-01-01"},"1994-10-01","1901-01-01","1995-10-01",0,0,{"$f":"M59","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N68=\"Amber\",INDIRECT(ADDRESS(ROW(M68)+1,COLUMN(M68))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel",{"$f":"E68","v":"N1 (III) - >1760 kg"},{"$f":"IF(B69=Input!$AA$27,1,0)","v":0},"1994-10-01","1998-01-01","1995-10-01","1999-01-01",0,0,{"$f":"M60","v":"Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N69=\"Amber\",INDIRECT(ADDRESS(ROW(M69)+1,COLUMN(M69))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel",{"$f":"E69","v":"N1 (III) - >1760 kg"},{"$f":"IF(B70=Input!$AA$27,1,0)","v":0},"1998-01-01","2000-01-01","1999-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N70=\"Amber\",INDIRECT(ADDRESS(ROW(M70)+2,COLUMN(M70))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B71=Input!$AA$27,1,0)","v":0},"1998-01-01","2000-01-01","1999-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N71=\"Amber\",INDIRECT(ADDRESS(ROW(M71)+1,COLUMN(M71))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B72=Input!$AA$27,1,0)","v":0},"2000-01-01","2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N72=\"Amber\",INDIRECT(ADDRESS(ROW(M72)+1,COLUMN(M72))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B73=Input!$AA$27,1,0)","v":0},"2005-01-01","2009-09-01","2006-01-01","2010-09-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N73=\"Amber\",INDIRECT(ADDRESS(ROW(M73)+1,COLUMN(M73))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B74=Input!$AA$27,1,0)","v":0},"2009-09-01","2011-09-01","2010-09-01","2012-09-01",0,0,"Euro 5a",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N74=\"Amber\",INDIRECT(ADDRESS(ROW(M74)+1,COLUMN(M74))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B75=Input!$AA$27,1,0)","v":0},"2011-09-01","2015-09-01","2012-09-01","2016-09-01",0,0,"Euro 5b",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N75=\"Amber\",INDIRECT(ADDRESS(ROW(M75)+1,COLUMN(M75))),\"-\"))","v":"-"}]
["Van_Diesel_N1 (III) - >1760 kg_0","Van_Diesel_N1 (III) - >1760 kg","Van","Diesel","N1 (III) - >1760 kg",{"$f":"IF(B76=Input!$AA$27,1,0)","v":0},"2015-09-01","2050-01-01","2016-09-01","2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N76=\"Amber\",INDIRECT(ADDRESS(ROW(M76)+1,COLUMN(M76))),\"-\"))","v":"-"}]
["Van_Diesel_N2 - >3.5 t_0","Van_Diesel_N2 - >3.5 t",{"$f":"C76","v":"Van"},{"$f":"D76","v":"Diesel"},"N2 - >3.5 t",{"$f":"IF(B77=Input!$AA$27,1,0)","v":0},{"$f":"G74","v":"2009-09-01"},"2011-09-01","2010-09-01",{"$f":"J74","v":"2012-09-01"},0,0,{"$f":"M74","v":"Euro 5a"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N77=\"Amber\",INDIRECT(ADDRESS(ROW(M77)+1,COLUMN(M77))),\"-\"))","v":"-"}]
["Van_Diesel_N2 - >3.5 t_0","Van_Diesel_N2 - >3.5 t","Van",{"$f":"D77","v":"Diesel"},{"$f":"E77","v":"N2 - >3.5 t"},{"$f":"IF(B78=Input!$AA$27,1,0)","v":0},"2011-09-01","2015-09-01","2012-09-01",{"$f":"J75","v":"2016-09-01"},0,0,{"$f":"M75","v":"Euro 5b"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N78=\"Amber\",INDIRECT(ADDRESS(ROW(M78)+1,COLUMN(M78))),\"-\"))","v":"-"}]
["Van_Diesel_N2 - >3.5 t_0","Van_Diesel_N2 - >3.5 t","Van",{"$f":"D78","v":"Diesel"},{"$f":"E78","v":"N2 - >3.5 t"},{"$f":"IF(B79=Input!$AA$27,1,0)","v":0},"2015-09-01","2050-01-01","2016-09-01",{"$f":"J76","v":"2050-01-01"},0,0,{"$f":"M76","v":"Euro 6"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N79=\"Amber\",INDIRECT(ADDRESS(ROW(M79)+1,COLUMN(M79))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van","Petrol",{"$f":"E50","v":"N1 (I) - ≤1305 kg"},{"$f":"IF(B80=Input!$AA$27,1,0)","v":0},{"$f":"G68","v":"1900-01-01"},{"$f":"G81","v":"1994-10-01"},"1901-01-01",{"$f":"I81","v":"1995-10-01"},0,0,{"$f":"M11","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N80=\"Amber\",INDIRECT(ADDRESS(ROW(M80)+1,COLUMN(M80))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van",{"$f":"D80","v":"Petrol"},"N1 (I) - ≤1305 kg",{"$f":"IF(B81=Input!$AA$27,1,0)","v":0},"1994-10-01","1998-01-01","1995-10-01","1999-01-01",0,0,"Euro 1",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N81=\"Amber\",INDIRECT(ADDRESS(ROW(M81)+1,COLUMN(M81))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van","Petrol","N1 (I) - ≤1305 kg",{"$f":"IF(B82=Input!$AA$27,1,0)","v":0},"1998-01-01","2000-01-01","1999-01-01","2001-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N82=\"Amber\",INDIRECT(ADDRESS(ROW(M82)+1,COLUMN(M82))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van","Petrol","N1 (I) - ≤1305 kg",{"$f":"IF(B83=Input!$AA$27,1,0)","v":0},"2000-01-01","2005-01-01","2001-01-01","2006-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N83=\"Amber\",INDIRECT(ADDRESS(ROW(M83)+1,COLUMN(M83))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van","Petrol","N1 (I) - ≤1305 kg",{"$f":"IF(B84=Input!$AA$27,1,0)","v":0},"2005-01-01","2009-09-01","2006-01-01","2011-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N84=\"Amber\",INDIRECT(ADDRESS(ROW(M84)+1,COLUMN(M84))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van","Petrol","N1 (I) - ≤1305 kg",{"$f":"IF(B85=Input!$AA$27,1,0)","v":0},"2009-09-01","2014-09-01",{"$f":"I8","v":"2011-01-01"},"2015-09-01",0,0,"Euro 5",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N85=\"Amber\",INDIRECT(ADDRESS(ROW(M85)+1,COLUMN(M85))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (I) - ≤1305 kg_0","Van_Petrol_N1 (I) - ≤1305 kg","Van","Petrol","N1 (I) - ≤1305 kg",{"$f":"IF(B86=Input!$AA$27,1,0)","v":0},"2014-09-01",{"$f":"H79","v":"2050-01-01"},"2015-09-01",{"$f":"J79","v":"2050-01-01"},0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N86=\"Amber\",INDIRECT(ADDRESS(ROW(M86)+1,COLUMN(M86))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg",{"$f":"C86","v":"Van"},{"$f":"D86","v":"Petrol"},{"$f":"E59","v":"N1 (II) - 1305-1760 kg"},{"$f":"IF(B87=Input!$AA$27,1,0)","v":0},{"$f":"G80","v":"1900-01-01"},{"$f":"G88","v":"1994-10-01"},"1901-01-01",{"$f":"I88","v":"1995-10-01"},0,0,{"$f":"M80","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N87=\"Amber\",INDIRECT(ADDRESS(ROW(M87)+1,COLUMN(M87))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg","Van","Petrol",{"$f":"E60","v":"N1 (II) - 1305-1760 kg"},{"$f":"IF(B88=Input!$AA$27,1,0)","v":0},{"$f":"G81","v":"1994-10-01"},"1998-01-01","1995-10-01","1999-01-01",0,0,{"$f":"M81","v":"Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N88=\"Amber\",INDIRECT(ADDRESS(ROW(M88)+1,COLUMN(M88))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg","Van","Petrol","N1 (II) - 1305-1760 kg",{"$f":"IF(B89=Input!$AA$27,1,0)","v":0},{"$f":"G82","v":"1998-01-01"},"2001-01-01","1999-01-01","2002-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N89=\"Amber\",INDIRECT(ADDRESS(ROW(M89)+1,COLUMN(M89))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg","Van","Petrol","N1 (II) - 1305-1760 kg",{"$f":"IF(B90=Input!$AA$27,1,0)","v":0},"2001-01-01","2006-01-01","2002-01-01","2007-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N90=\"Amber\",INDIRECT(ADDRESS(ROW(M90)+1,COLUMN(M90))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg","Van","Petrol","N1 (II) - 1305-1760 kg",{"$f":"IF(B91=Input!$AA$27,1,0)","v":0},"2006-01-01","2010-09-01","2007-01-01","2012-01-01",0,0,"Euro 4",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N91=\"Amber\",INDIRECT(ADDRESS(ROW(M91)+1,COLUMN(M91))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg","Van","Petrol","N1 (II) - 1305-1760 kg",{"$f":"IF(B92=Input!$AA$27,1,0)","v":0},"2010-09-01","2015-09-01","2012-01-01","2016-09-01",0,0,"Euro 5",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N92=\"Amber\",INDIRECT(ADDRESS(ROW(M92)+1,COLUMN(M92))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (II) - 1305-1760 kg_0","Van_Petrol_N1 (II) - 1305-1760 kg","Van","Petrol","N1 (II) - 1305-1760 kg",{"$f":"IF(B93=Input!$AA$27,1,0)","v":0},"2015-09-01",{"$f":"H86","v":"2050-01-01"},"2016-09-01",{"$f":"J86","v":"2050-01-01"},0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N93=\"Amber\",INDIRECT(ADDRESS(ROW(M93)+1,COLUMN(M93))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg",{"$f":"C93","v":"Van"},{"$f":"D93","v":"Petrol"},{"$f":"E68","v":"N1 (III) - >1760 kg"},{"$f":"IF(B94=Input!$AA$27,1,0)","v":0},{"$f":"G87","v":"1900-01-01"},{"$f":"H87","v":"1994-10-01"},{"$f":"I87","v":"1901-01-01"},{"$f":"J87","v":"1995-10-01"},0,0,{"$f":"M87","v":"Pre Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N94=\"Amber\",INDIRECT(ADDRESS(ROW(M94)+1,COLUMN(M94))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg","Van","Petrol",{"$f":"E69","v":"N1 (III) - >1760 kg"},{"$f":"IF(B95=Input!$AA$27,1,0)","v":0},{"$f":"G88","v":"1994-10-01"},"1998-01-01","1995-10-01","1999-01-01",0,0,{"$f":"M88","v":"Euro 1"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N95=\"Amber\",INDIRECT(ADDRESS(ROW(M95)+1,COLUMN(M95))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg","Van","Petrol","N1 (III) - >1760 kg",{"$f":"IF(B96=Input!$AA$27,1,0)","v":0},"1998-01-01","2001-01-01","1999-01-01","2002-01-01",0,0,"Euro 2",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N96=\"Amber\",INDIRECT(ADDRESS(ROW(M96)+1,COLUMN(M96))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg","Van","Petrol","N1 (III) - >1760 kg",{"$f":"IF(B97=Input!$AA$27,1,0)","v":0},"2001-01-01","2006-01-01","2002-01-01","2007-01-01",0,0,"Euro 3",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N97=\"Amber\",INDIRECT(ADDRESS(ROW(M97)+1,COLUMN(M97))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg","Van","Petrol","N1 (III) - >1760 kg",{"$f":"IF(B98=Input!$AA$27,1,0)","v":0},"2006-01-01","2010-09-01","2007-01-01","2012-01-01",{"$f":"IF(AND(F98=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G98,DateInput<=H98),1,0),0)","v":0},{"$f":"IF(AND(F98=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I98,DateInput<=J98),1,0),0)","v":0},"Euro 4",{"$f":"IF(AND(F98=1,K98=1),\"Green\",IF(AND(F98=1,L98=1),IF(AND(DateInput>H98,DateInput<=J98),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N98=\"Amber\",INDIRECT(ADDRESS(ROW(M98)+1,COLUMN(M98))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg","Van","Petrol","N1 (III) - >1760 kg",{"$f":"IF(B99=Input!$AA$27,1,0)","v":0},"2010-09-01","2015-09-01","2012-01-01","2016-09-01",0,0,"Euro 5",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N99=\"Amber\",INDIRECT(ADDRESS(ROW(M99)+1,COLUMN(M99))),\"-\"))","v":"-"}]
["Van_Petrol_N1 (III) - >1760 kg_0","Van_Petrol_N1 (III) - >1760 kg","Van","Petrol","N1 (III) - >1760 kg",{"$f":"IF(B100=Input!$AA$27,1,0)","v":0},"2015-09-01","2050-01-01","2016-09-01","2050-01-01",0,0,"Euro 6",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N100=\"Amber\",INDIRECT(ADDRESS(ROW(M100)+1,COLUMN(M100))),\"-\"))","v":"-"}]
["Van_Petrol_N2 - >3.5 t_0","Van_Petrol_N2 - >3.5 t",{"$f":"C100","v":"Van"},{"$f":"D100","v":"Petrol"},{"$f":"E77","v":"N2 - >3.5 t"},{"$f":"IF(B101=Input!$AA$27,1,0)","v":0},{"$f":"G99","v":"2010-09-01"},{"$f":"H99","v":"2015-09-01"},"2012-01-01","2016-09-01",0,0,{"$f":"M99","v":"Euro 5"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N101=\"Amber\",INDIRECT(ADDRESS(ROW(M101)+1,COLUMN(M101))),\"-\"))","v":"-"}]
["Van_Petrol_N2 - >3.5 t_0","Van_Petrol_N2 - >3.5 t",{"$f":"C101","v":"Van"},{"$f":"D101","v":"Petrol"},{"$f":"E78","v":"N2 - >3.5 t"},{"$f":"IF(B102=Input!$AA$27,1,0)","v":0},{"$f":"G100","v":"2015-09-01"},"2050-01-01","2016-09-01","2050-01-01",0,0,{"$f":"M100","v":"Euro 6"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N102=\"Amber\",INDIRECT(ADDRESS(ROW(M102)+1,COLUMN(M102))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW","HGV","Diesel","≤85 kW",{"$f":"IF(B103=Input!$AA$27,1,0)","v":0},{"$f":"G94","v":"1900-01-01"},{"$f":"G104","v":"1992-01-01"},{"$f":"DATE(YEAR(G103)+1,MONTH(G103),DAY(G103))","v":"1901-01-01"},{"$f":"I104","v":"1993-01-01"},0,0,"Pre Euro I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N103=\"Amber\",INDIRECT(ADDRESS(ROW(M103)+1,COLUMN(M103))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW",{"$f":"C103","v":"HGV"},"Diesel","≤85 kW",{"$f":"IF(B104=Input!$AA$27,1,0)","v":0},"1992-01-01","1996-10-01","1993-01-01","1997-10-01",0,0,"Euro I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N104=\"Amber\",INDIRECT(ADDRESS(ROW(M104)+1,COLUMN(M104))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW","HGV","Diesel","≤85 kW",{"$f":"IF(B105=Input!$AA$27,1,0)","v":0},"1996-10-01","2000-10-01","1997-10-01","2001-10-01",0,0,"Euro II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N105=\"Amber\",INDIRECT(ADDRESS(ROW(M105)+1,COLUMN(M105))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW","HGV","Diesel","≤85 kW",{"$f":"IF(B106=Input!$AA$27,1,0)","v":0},"2000-10-01","2005-10-01","2001-10-01","2006-10-01",0,0,"Euro III",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N106=\"Amber\",INDIRECT(ADDRESS(ROW(M106)+1,COLUMN(M106))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW","HGV","Diesel","≤85 kW",{"$f":"IF(B107=Input!$AA$27,1,0)","v":0},"2005-10-01","2008-10-01","2006-10-01","2009-10-01",0,0,"Euro IV",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N107=\"Amber\",INDIRECT(ADDRESS(ROW(M107)+1,COLUMN(M107))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW","HGV","Diesel","≤85 kW",{"$f":"IF(B108=Input!$AA$27,1,0)","v":0},"2008-10-01","2013-01-01","2009-10-01","2014-01-01",0,0,"Euro V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N108=\"Amber\",INDIRECT(ADDRESS(ROW(M108)+1,COLUMN(M108))),\"-\"))","v":"-"}]
["HGV_Diesel_≤85 kW_0","HGV_Diesel_≤85 kW","HGV","Diesel","≤85 kW",{"$f":"IF(B109=Input!$AA$27,1,0)","v":0},"2013-01-01",{"$f":"H102","v":"2050-01-01"},"2014-01-01",{"$f":"J102","v":"2050-01-01"},0,0,"Euro VI",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N109=\"Amber\",INDIRECT(ADDRESS(ROW(M109)+1,COLUMN(M109))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW",{"$f":"C103","v":"HGV"},{"$f":"D103","v":"Diesel"},">85 kW",{"$f":"IF(B110=Input!$AA$27,1,0)","v":0},{"$f":"G103","v":"1900-01-01"},{"$f":"G111","v":"1992-01-01"},"1901-01-01",{"$f":"J103","v":"1993-01-01"},0,0,{"$f":"M103","v":"Pre Euro I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N110=\"Amber\",INDIRECT(ADDRESS(ROW(M110)+1,COLUMN(M110))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW",{"$f":"C104","v":"HGV"},"Diesel",{"$f":"E110","v":">85 kW"},{"$f":"IF(B111=Input!$AA$27,1,0)","v":0},{"$f":"G104","v":"1992-01-01"},"1998-10-01","1993-01-01",{"$f":"I112","v":"1999-10-01"},0,0,{"$f":"M104","v":"Euro I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N111=\"Amber\",INDIRECT(ADDRESS(ROW(M111)+1,COLUMN(M111))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW","HGV","Diesel",">85 kW",{"$f":"IF(B112=Input!$AA$27,1,0)","v":0},"1998-10-01","2000-10-01","1999-10-01",{"$f":"I113","v":"2001-10-01"},0,0,"Euro II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N112=\"Amber\",INDIRECT(ADDRESS(ROW(M112)+1,COLUMN(M112))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW","HGV","Diesel",">85 kW",{"$f":"IF(B113=Input!$AA$27,1,0)","v":0},{"$f":"G106","v":"2000-10-01"},"2005-10-01","2001-10-01",{"$f":"I114","v":"2006-10-01"},0,0,"Euro III",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N113=\"Amber\",INDIRECT(ADDRESS(ROW(M113)+1,COLUMN(M113))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW","HGV","Diesel",">85 kW",{"$f":"IF(B114=Input!$AA$27,1,0)","v":0},{"$f":"G107","v":"2005-10-01"},"2008-10-01","2006-10-01",{"$f":"I115","v":"2009-10-01"},0,0,"Euro IV",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N114=\"Amber\",INDIRECT(ADDRESS(ROW(M114)+1,COLUMN(M114))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW","HGV","Diesel",">85 kW",{"$f":"IF(B115=Input!$AA$27,1,0)","v":0},{"$f":"G108","v":"2008-10-01"},"2013-01-01","2009-10-01",{"$f":"I116","v":"2014-01-01"},0,0,"Euro V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N115=\"Amber\",INDIRECT(ADDRESS(ROW(M115)+1,COLUMN(M115))),\"-\"))","v":"-"}]
["HGV_Diesel_>85 kW_0","HGV_Diesel_>85 kW","HGV","Diesel",">85 kW",{"$f":"IF(B116=Input!$AA$27,1,0)","v":0},{"$f":"G109","v":"2013-01-01"},{"$f":"H109","v":"2050-01-01"},"2014-01-01",{"$f":"J109","v":"2050-01-01"},0,0,"Euro VI",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N116=\"Amber\",INDIRECT(ADDRESS(ROW(M116)+1,COLUMN(M116))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW","Specialist_GSE","Diesel","130-560 kW",{"$f":"IF(B117=Input!$AA$27,1,0)","v":0},{"$f":"G110","v":"1900-01-01"},{"$f":"G118","v":"1998-01-01"},{"$f":"DATE(YEAR(G117)+2,MONTH(G117),DAY(G117))","v":"1902-01-01"},{"$f":"I118","v":"2000-01-01"},0,0,"Pre Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N117=\"Amber\",INDIRECT(ADDRESS(ROW(M117)+1,COLUMN(M117))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW",{"$f":"C117","v":"Specialist_GSE"},"Diesel","130-560 kW",{"$f":"IF(B118=Input!$AA$27,1,0)","v":0},"1998-01-01","2001-01-01",{"$f":"DATE(YEAR(G118)+2,MONTH(G118),DAY(G118))","v":"2000-01-01"},"2003-01-01",0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N118=\"Amber\",INDIRECT(ADDRESS(ROW(M118)+1,COLUMN(M118))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW","Specialist_GSE","Diesel","130-560 kW",{"$f":"IF(B119=Input!$AA$27,1,0)","v":0},"2001-01-01","2005-01-01","2003-01-01","2007-01-01",0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N119=\"Amber\",INDIRECT(ADDRESS(ROW(M119)+1,COLUMN(M119))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW",{"$f":"C119","v":"Specialist_GSE"},"Diesel","130-560 kW",{"$f":"IF(B120=Input!$AA$27,1,0)","v":0},"2005-01-01","2010-01-01","2007-01-01","2012-01-01",0,0,"Stage III A",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N120=\"Amber\",INDIRECT(ADDRESS(ROW(M120)+1,COLUMN(M120))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW","Specialist_GSE","Diesel","130-560 kW",{"$f":"IF(B121=Input!$AA$27,1,0)","v":0},"2010-01-01","2013-01-01","2012-01-01","2015-01-01",0,0,"Stage III B",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N121=\"Amber\",INDIRECT(ADDRESS(ROW(M121)+1,COLUMN(M121))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW","Specialist_GSE","Diesel","130-560 kW",{"$f":"IF(B122=Input!$AA$27,1,0)","v":0},"2013-01-01","2018-01-01","2015-01-01","2020-01-01",0,0,"Stage IV",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N122=\"Amber\",INDIRECT(ADDRESS(ROW(M122)+1,COLUMN(M122))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_130-560 kW_0","Specialist_GSE_Diesel_130-560 kW",{"$f":"C122","v":"Specialist_GSE"},"Diesel","130-560 kW",{"$f":"IF(B123=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H116","v":"2050-01-01"},"2020-01-01",{"$f":"J116","v":"2050-01-01"},{"$f":"IF(AND(F123=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G123,DateInput<=H123),1,0),0)","v":0},{"$f":"IF(AND(F123=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I123,DateInput<=J123),1,0),0)","v":0},"Stage V",{"$f":"IF(AND(F123=1,K123=1),\"Green\",IF(AND(F123=1,L123=1),IF(AND(DateInput>H123,DateInput<=J123),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N123=\"Amber\",INDIRECT(ADDRESS(ROW(M123)+1,COLUMN(M123))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW",{"$f":"C123","v":"Specialist_GSE"},"Diesel","75-130 kW",{"$f":"IF(B124=Input!$AA$27,1,0)","v":0},{"$f":"G117","v":"1900-01-01"},{"$f":"G125","v":"1998-01-01"},"1902-01-01",{"$f":"I125","v":"2000-01-01"},0,0,{"$f":"M117","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N124=\"Amber\",INDIRECT(ADDRESS(ROW(M124)+1,COLUMN(M124))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW","Specialist_GSE","Diesel",{"$f":"E124","v":"75-130 kW"},{"$f":"IF(B125=Input!$AA$27,1,0)","v":0},"1998-01-01",{"$f":"G126","v":"2002-01-01"},"2000-01-01","2004-01-01",0,0,{"$f":"M118","v":"Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N125=\"Amber\",INDIRECT(ADDRESS(ROW(M125)+1,COLUMN(M125))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW","Specialist_GSE","Diesel","75-130 kW",{"$f":"IF(B126=Input!$AA$27,1,0)","v":0},"2002-01-01",{"$f":"G127","v":"2006-01-01"},"2004-01-01","2008-01-01",0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N126=\"Amber\",INDIRECT(ADDRESS(ROW(M126)+1,COLUMN(M126))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW","Specialist_GSE","Diesel","75-130 kW",{"$f":"IF(B127=Input!$AA$27,1,0)","v":0},"2006-01-01",{"$f":"G128","v":"2011-01-01"},"2008-01-01","2013-01-01",0,0,"Stage III A",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N127=\"Amber\",INDIRECT(ADDRESS(ROW(M127)+1,COLUMN(M127))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW","Specialist_GSE","Diesel","75-130 kW",{"$f":"IF(B128=Input!$AA$27,1,0)","v":0},"2011-01-01",{"$f":"G129","v":"2013-10-01"},"2013-01-01","2015-10-01",0,0,"Stage III B",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N128=\"Amber\",INDIRECT(ADDRESS(ROW(M128)+1,COLUMN(M128))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW","Specialist_GSE","Diesel","75-130 kW",{"$f":"IF(B129=Input!$AA$27,1,0)","v":0},"2013-10-01",{"$f":"H122","v":"2018-01-01"},"2015-10-01","2020-01-01",0,0,"Stage IV",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N129=\"Amber\",INDIRECT(ADDRESS(ROW(M129)+1,COLUMN(M129))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_75-130 kW_0","Specialist_GSE_Diesel_75-130 kW","Specialist_GSE","Diesel","75-130 kW",{"$f":"IF(B130=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H123","v":"2050-01-01"},"2020-01-01",{"$f":"J123","v":"2050-01-01"},0,0,"Stage V",{"$f":"IF(AND(F130=1,K130=1),\"Green\",IF(AND(F130=1,L130=1),IF(AND(DateInput>H130,DateInput<=J130),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N130=\"Amber\",INDIRECT(ADDRESS(ROW(M130)+1,COLUMN(M130))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_37-56 kW_0","Specialist_GSE_Diesel_37-56 kW","Specialist_GSE","Diesel","37-56 kW",{"$f":"IF(B131=Input!$AA$27,1,0)","v":0},{"$f":"G124","v":"1900-01-01"},{"$f":"G132","v":"1998-04-01"},"1902-01-01",{"$f":"I132","v":"2000-04-01"},0,0,{"$f":"M124","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N131=\"Amber\",INDIRECT(ADDRESS(ROW(M131)+1,COLUMN(M131))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_37-56 kW_0","Specialist_GSE_Diesel_37-56 kW","Specialist_GSE","Diesel",{"$f":"E131","v":"37-56 kW"},{"$f":"IF(B132=Input!$AA$27,1,0)","v":0},"1998-04-01",{"$f":"G133","v":"2003-01-01"},"2000-04-01",{"$f":"I133","v":"2005-01-01"},0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N132=\"Amber\",INDIRECT(ADDRESS(ROW(M132)+1,COLUMN(M132))),\"-\"))","v":"-"}]
[{"$f":"B133&\"_\"&SUM(K133:L133)","v":"Specialist_GSE_Diesel_37-56 kW_0"},{"$f":"C133&\"_\"&D133&\"_\"&E133","v":"Specialist_GSE_Diesel_37-56 kW"},"Specialist_GSE","Diesel",{"$f":"E132","v":"37-56 kW"},{"$f":"IF(B133=Input!$AA$27,1,0)","v":0},"2003-01-01",{"$f":"G134","v":"2007-01-01"},"2005-01-01",{"$f":"I134","v":"2009-01-01"},0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N133=\"Amber\",INDIRECT(ADDRESS(ROW(M133)+1,COLUMN(M133))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_37-56 kW_0","Specialist_GSE_Diesel_37-56 kW","Specialist_GSE","Diesel",{"$f":"E133","v":"37-56 kW"},{"$f":"IF(B134=Input!$AA$27,1,0)","v":0},"2007-01-01",{"$f":"G135","v":"2012-01-01"},"2009-01-01",{"$f":"I135","v":"2014-01-01"},0,0,"Stage III A",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N134=\"Amber\",INDIRECT(ADDRESS(ROW(M134)+1,COLUMN(M134))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_37-56 kW_0","Specialist_GSE_Diesel_37-56 kW","Specialist_GSE","Diesel",{"$f":"E134","v":"37-56 kW"},{"$f":"IF(B135=Input!$AA$27,1,0)","v":0},"2012-01-01",{"$f":"G136","v":"2018-01-01"},"2014-01-01",{"$f":"I136","v":"2020-01-01"},0,0,"Stage III B",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N135=\"Amber\",INDIRECT(ADDRESS(ROW(M135)+1,COLUMN(M135))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_37-56 kW_0","Specialist_GSE_Diesel_37-56 kW",{"$f":"C134","v":"Specialist_GSE"},{"$f":"D135","v":"Diesel"},{"$f":"E135","v":"37-56 kW"},{"$f":"IF(B136=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H130","v":"2050-01-01"},"2020-01-01",{"$f":"J130","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N136=\"Amber\",INDIRECT(ADDRESS(ROW(M136)+1,COLUMN(M136))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_56-75 kW_0","Specialist_GSE_Diesel_56-75 kW",{"$f":"C135","v":"Specialist_GSE"},"Diesel","56-75 kW",{"$f":"IF(B137=Input!$AA$27,1,0)","v":0},{"$f":"G131","v":"1900-01-01"},{"$f":"H131","v":"1998-04-01"},{"$f":"I131","v":"1902-01-01"},{"$f":"J131","v":"2000-04-01"},{"$f":"IF(AND(F137=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G137,DateInput<=H137),1,0),0)","v":0},{"$f":"IF(AND(F137=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I137,DateInput<=J137),1,0),0)","v":0},"Pre Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N137=\"Amber\",INDIRECT(ADDRESS(ROW(M137)+1,COLUMN(M137))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_56-75 kW_0","Specialist_GSE_Diesel_56-75 kW",{"$f":"C136","v":"Specialist_GSE"},"Diesel",{"$f":"E137","v":"56-75 kW"},{"$f":"IF(B138=Input!$AA$27,1,0)","v":0},{"$f":"G132","v":"1998-04-01"},{"$f":"H132","v":"2003-01-01"},{"$f":"I132","v":"2000-04-01"},{"$f":"J132","v":"2005-01-01"},{"$f":"IF(AND(F138=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G138,DateInput<=H138),1,0),0)","v":0},{"$f":"IF(AND(F138=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I138,DateInput<=J138),1,0),0)","v":0},"Stage I",{"$f":"IF(AND(F138=1,K138=1),\"Green\",IF(AND(F138=1,L138=1),IF(AND(DateInput>H138,DateInput<=J138),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N138=\"Amber\",INDIRECT(ADDRESS(ROW(M138)+1,COLUMN(M138))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_56-75 kW_0","Specialist_GSE_Diesel_56-75 kW",{"$f":"C136","v":"Specialist_GSE"},"Diesel",{"$f":"E138","v":"56-75 kW"},{"$f":"IF(B139=Input!$AA$27,1,0)","v":0},{"$f":"G133","v":"2003-01-01"},{"$f":"H133","v":"2007-01-01"},{"$f":"I133","v":"2005-01-01"},{"$f":"J133","v":"2009-01-01"},{"$f":"IF(AND(F139=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G139,DateInput<=H139),1,0),0)","v":0},{"$f":"IF(AND(F139=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I139,DateInput<=J139),1,0),0)","v":0},"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N139=\"Amber\",INDIRECT(ADDRESS(ROW(M139)+1,COLUMN(M139))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_56-75 kW_0","Specialist_GSE_Diesel_56-75 kW",{"$f":"C137","v":"Specialist_GSE"},"Diesel",{"$f":"E139","v":"56-75 kW"},{"$f":"IF(B140=Input!$AA$27,1,0)","v":0},{"$f":"G134","v":"2007-01-01"},{"$f":"H134","v":"2012-01-01"},{"$f":"I134","v":"2009-01-01"},{"$f":"J134","v":"2014-01-01"},{"$f":"IF(AND(F140=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G140,DateInput<=H140),1,0),0)","v":0},{"$f":"IF(AND(F140=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I140,DateInput<=J140),1,0),0)","v":0},"Stage III A",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N140=\"Amber\",INDIRECT(ADDRESS(ROW(M140)+1,COLUMN(M140))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_56-75 kW_0","Specialist_GSE_Diesel_56-75 kW",{"$f":"C136","v":"Specialist_GSE"},"Diesel",{"$f":"E140","v":"56-75 kW"},{"$f":"IF(B141=Input!$AA$27,1,0)","v":0},"2011-01-01",{"$f":"H129","v":"2018-01-01"},"2013-01-01",{"$f":"I142","v":"2020-01-01"},0,0,"Stage III B",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N141=\"Amber\",INDIRECT(ADDRESS(ROW(M141)+1,COLUMN(M141))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_56-75 kW_0","Specialist_GSE_Diesel_56-75 kW",{"$f":"C141","v":"Specialist_GSE"},"Diesel","56-75 kW",{"$f":"IF(B142=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H136","v":"2050-01-01"},"2020-01-01",{"$f":"J136","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N142=\"Amber\",INDIRECT(ADDRESS(ROW(M142)+1,COLUMN(M142))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_NA_0","Specialist_GSE_Diesel_NA","Specialist_GSE","Diesel","NA",{"$f":"IF(B143=Input!$AA$27,1,0)","v":0},"2012-01-01",{"$f":"H129","v":"2018-01-01"},"2014-01-01",{"$f":"I144","v":"2020-01-01"},0,0,"Stage III B",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N143=\"Amber\",INDIRECT(ADDRESS(ROW(M143)+1,COLUMN(M143))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_NA_0","Specialist_GSE_Diesel_NA","Specialist_GSE","Diesel","NA",{"$f":"IF(B144=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H142","v":"2050-01-01"},"2020-01-01",{"$f":"J142","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N144=\"Amber\",INDIRECT(ADDRESS(ROW(M144)+1,COLUMN(M144))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_19-37 kW_0","Specialist_GSE_Diesel_19-37 kW",{"$f":"C144","v":"Specialist_GSE"},{"$f":"D144","v":"Diesel"},"19-37 kW",{"$f":"IF(B145=Input!$AA$27,1,0)","v":0},{"$f":"G131","v":"1900-01-01"},{"$f":"G146","v":"2000-01-01"},"1902-01-01",{"$f":"I146","v":"2002-01-01"},0,0,{"$f":"M131","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N145=\"Amber\",INDIRECT(ADDRESS(ROW(M145)+1,COLUMN(M145))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_19-37 kW_0","Specialist_GSE_Diesel_19-37 kW","Specialist_GSE","Diesel",{"$f":"E145","v":"19-37 kW"},{"$f":"IF(B146=Input!$AA$27,1,0)","v":0},"2000-01-01",{"$f":"G147","v":"2006-01-01"},"2002-01-01",{"$f":"I147","v":"2008-01-01"},0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N146=\"Amber\",INDIRECT(ADDRESS(ROW(M146)+1,COLUMN(M146))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_19-37 kW_0","Specialist_GSE_Diesel_19-37 kW","Specialist_GSE","Diesel",{"$f":"E146","v":"19-37 kW"},{"$f":"IF(B147=Input!$AA$27,1,0)","v":0},"2006-01-01",{"$f":"H141","v":"2018-01-01"},"2008-01-01",{"$f":"I148","v":"2020-01-01"},0,0,"Stage III A",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N147=\"Amber\",INDIRECT(ADDRESS(ROW(M147)+1,COLUMN(M147))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_19-37 kW_0","Specialist_GSE_Diesel_19-37 kW","Specialist_GSE","Diesel",{"$f":"E147","v":"19-37 kW"},{"$f":"IF(B148=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H144","v":"2050-01-01"},"2020-01-01",{"$f":"J144","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N148=\"Amber\",INDIRECT(ADDRESS(ROW(M148)+1,COLUMN(M148))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_>560 kW_0","Specialist_GSE_Diesel_>560 kW","Specialist_GSE","Diesel",">560 kW",{"$f":"IF(B149=Input!$AA$27,1,0)","v":0},"1900-01-01",{"$f":"G150","v":"2018-01-01"},"1902-01-01",{"$f":"I150","v":"2020-01-01"},0,0,"Pre Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N149=\"Amber\",INDIRECT(ADDRESS(ROW(M149)+1,COLUMN(M149))),\"-\"))","v":"-"}]
["Specialist_GSE_Diesel_>560 kW_0","Specialist_GSE_Diesel_>560 kW","Specialist_GSE","Diesel",{"$f":"E149","v":">560 kW"},{"$f":"IF(B150=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H148","v":"2050-01-01"},"2020-01-01",{"$f":"J148","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N150=\"Amber\",INDIRECT(ADDRESS(ROW(M150)+1,COLUMN(M150))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW",{"$f":"C150","v":"Specialist_GSE"},"SparkIgnited","Hand-held, < 20 cm3, <19 kW",{"$f":"IF(B151=Input!$AA$27,1,0)","v":0},{"$f":"G145","v":"1900-01-01"},{"$f":"G152","v":"2004-08-11"},"1902-01-01",{"$f":"I152","v":"2006-08-11"},0,0,{"$f":"M145","v":"Pre Stage I"},{"$f":"IF(AND(F151=1,K151=1),\"Green\",IF(AND(F151=1,L151=1),IF(AND(DateInput>H151,DateInput<=J151),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N151=\"Amber\",INDIRECT(ADDRESS(ROW(M151)+1,COLUMN(M151))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW",{"$f":"C151","v":"Specialist_GSE"},{"$f":"D151","v":"SparkIgnited"},{"$f":"E151","v":"Hand-held, < 20 cm3, <19 kW"},{"$f":"IF(B152=Input!$AA$27,1,0)","v":0},"2004-08-11",{"$f":"G153","v":"2007-08-01"},"2006-08-11",{"$f":"I153","v":"2009-08-01"},0,0,"Stage I",{"$f":"IF(AND(F152=1,K152=1),\"Green\",IF(AND(F152=1,L152=1),IF(AND(DateInput>H152,DateInput<=J152),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N152=\"Amber\",INDIRECT(ADDRESS(ROW(M152)+1,COLUMN(M152))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW","Specialist_GSE",{"$f":"D152","v":"SparkIgnited"},{"$f":"E152","v":"Hand-held, < 20 cm3, <19 kW"},{"$f":"IF(B153=Input!$AA$27,1,0)","v":0},"2007-08-01",{"$f":"H147","v":"2018-01-01"},"2009-08-01",{"$f":"J147","v":"2020-01-01"},0,0,"Stage II",{"$f":"IF(AND(F153=1,K153=1),\"Green\",IF(AND(F153=1,L153=1),IF(AND(DateInput>H153,DateInput<=J153),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N153=\"Amber\",INDIRECT(ADDRESS(ROW(M153)+1,COLUMN(M153))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, < 20 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E153","v":"Hand-held, < 20 cm3, <19 kW"},{"$f":"IF(B154=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H150","v":"2050-01-01"},"2020-01-01",{"$f":"J150","v":"2050-01-01"},0,0,"Stage V",{"$f":"IF(AND(F154=1,K154=1),\"Green\",IF(AND(F154=1,L154=1),IF(AND(DateInput>H154,DateInput<=J154),\"Amber\",\"Green\"),0))","v":0},{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N154=\"Amber\",INDIRECT(ADDRESS(ROW(M154)+1,COLUMN(M154))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW","Specialist_GSE","SparkIgnited","Hand-held, 20-50 cm3, <19 kW",{"$f":"IF(B155=Input!$AA$27,1,0)","v":0},{"$f":"G151","v":"1900-01-01"},{"$f":"H151","v":"2004-08-11"},"1902-01-01",{"$f":"J151","v":"2006-08-11"},0,0,{"$f":"M151","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N155=\"Amber\",INDIRECT(ADDRESS(ROW(M155)+1,COLUMN(M155))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E155","v":"Hand-held, 20-50 cm3, <19 kW"},{"$f":"IF(B156=Input!$AA$27,1,0)","v":0},"2004-08-11",{"$f":"H152","v":"2007-08-01"},"2006-08-11",{"$f":"J152","v":"2009-08-01"},0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N156=\"Amber\",INDIRECT(ADDRESS(ROW(M156)+1,COLUMN(M156))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E156","v":"Hand-held, 20-50 cm3, <19 kW"},{"$f":"IF(B157=Input!$AA$27,1,0)","v":0},"2007-08-01",{"$f":"H153","v":"2018-01-01"},"2009-08-01",{"$f":"J153","v":"2020-01-01"},0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N157=\"Amber\",INDIRECT(ADDRESS(ROW(M157)+1,COLUMN(M157))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, 20-50 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E157","v":"Hand-held, 20-50 cm3, <19 kW"},{"$f":"IF(B158=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H154","v":"2050-01-01"},"2020-01-01",{"$f":"J154","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N158=\"Amber\",INDIRECT(ADDRESS(ROW(M158)+1,COLUMN(M158))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW","Specialist_GSE","SparkIgnited","Hand-held, >50 cm3, <19 kW",{"$f":"IF(B159=Input!$AA$27,1,0)","v":0},"1900-01-01",{"$f":"G160","v":"2004-08-11"},"1902-01-01",{"$f":"I160","v":"2006-08-11"},0,0,{"$f":"M155","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N159=\"Amber\",INDIRECT(ADDRESS(ROW(M159)+1,COLUMN(M159))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E159","v":"Hand-held, >50 cm3, <19 kW"},{"$f":"IF(B160=Input!$AA$27,1,0)","v":0},"2004-08-11",{"$f":"G161","v":"2008-08-01"},"2006-08-11",{"$f":"I161","v":"2010-08-01"},0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N160=\"Amber\",INDIRECT(ADDRESS(ROW(M160)+1,COLUMN(M160))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E160","v":"Hand-held, >50 cm3, <19 kW"},{"$f":"IF(B161=Input!$AA$27,1,0)","v":0},"2008-08-01",{"$f":"H157","v":"2018-01-01"},"2010-08-01",{"$f":"J157","v":"2020-01-01"},0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N161=\"Amber\",INDIRECT(ADDRESS(ROW(M161)+1,COLUMN(M161))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Hand-held, >50 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E161","v":"Hand-held, >50 cm3, <19 kW"},{"$f":"IF(B162=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H158","v":"2050-01-01"},"2020-01-01",{"$f":"J158","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N162=\"Amber\",INDIRECT(ADDRESS(ROW(M162)+1,COLUMN(M162))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, < 66 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, < 66 cm3, <19 kW","Specialist_GSE","SparkIgnited","Non-hand-held, < 66 cm3, <19 kW",{"$f":"IF(B163=Input!$AA$27,1,0)","v":0},{"$f":"G159","v":"1900-01-01"},{"$f":"G164","v":"2004-08-11"},"1902-01-01",{"$f":"I164","v":"2006-08-11"},0,0,{"$f":"M159","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N163=\"Amber\",INDIRECT(ADDRESS(ROW(M163)+1,COLUMN(M163))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, < 66 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, < 66 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E163","v":"Non-hand-held, < 66 cm3, <19 kW"},{"$f":"IF(B164=Input!$AA$27,1,0)","v":0},{"$f":"G156","v":"2004-08-11"},{"$f":"H161","v":"2018-01-01"},"2006-08-11",{"$f":"J161","v":"2020-01-01"},0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N164=\"Amber\",INDIRECT(ADDRESS(ROW(M164)+1,COLUMN(M164))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, < 66 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, < 66 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E164","v":"Non-hand-held, < 66 cm3, <19 kW"},{"$f":"IF(B165=Input!$AA$27,1,0)","v":0},{"$f":"G158","v":"2018-01-01"},{"$f":"H162","v":"2050-01-01"},"2020-01-01",{"$f":"J162","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N165=\"Amber\",INDIRECT(ADDRESS(ROW(M165)+1,COLUMN(M165))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 66-100 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 66-100 cm3, <19 kW","Specialist_GSE","SparkIgnited","Non-hand-held, 66-100 cm3, <19 kW",{"$f":"IF(B166=Input!$AA$27,1,0)","v":0},{"$f":"G163","v":"1900-01-01"},{"$f":"G167","v":"2004-08-11"},"1902-01-01",{"$f":"I167","v":"2006-08-11"},0,0,{"$f":"M163","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N166=\"Amber\",INDIRECT(ADDRESS(ROW(M166)+1,COLUMN(M166))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 66-100 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 66-100 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E166","v":"Non-hand-held, 66-100 cm3, <19 kW"},{"$f":"IF(B167=Input!$AA$27,1,0)","v":0},{"$f":"G164","v":"2004-08-11"},{"$f":"H164","v":"2018-01-01"},"2006-08-11",{"$f":"J164","v":"2020-01-01"},{"$f":"IF(AND(F167=1,DateType=\"Date of Manufacture\"),IF(AND(DateInput>G167,DateInput<=H167),1,0),0)","v":0},{"$f":"IF(AND(F167=1,DateType=\"Date of Registration\"),IF(AND(DateInput>I167,DateInput<=J167),1,0),0)","v":0},"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N167=\"Amber\",INDIRECT(ADDRESS(ROW(M167)+1,COLUMN(M167))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 66-100 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 66-100 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E167","v":"Non-hand-held, 66-100 cm3, <19 kW"},{"$f":"IF(B168=Input!$AA$27,1,0)","v":0},{"$f":"G165","v":"2018-01-01"},{"$f":"H165","v":"2050-01-01"},"2020-01-01",{"$f":"J165","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N168=\"Amber\",INDIRECT(ADDRESS(ROW(M168)+1,COLUMN(M168))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW","Specialist_GSE","SparkIgnited","Non-hand-held, 11-225 cm3, <19 kW",{"$f":"IF(B169=Input!$AA$27,1,0)","v":0},{"$f":"G166","v":"1900-01-01"},{"$f":"G170","v":"2004-08-11"},"1902-01-01",{"$f":"I170","v":"2006-08-11"},0,0,{"$f":"M166","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N169=\"Amber\",INDIRECT(ADDRESS(ROW(M169)+1,COLUMN(M169))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E169","v":"Non-hand-held, 11-225 cm3, <19 kW"},{"$f":"IF(B170=Input!$AA$27,1,0)","v":0},{"$f":"G167","v":"2004-08-11"},{"$f":"G171","v":"2007-08-01"},"2006-08-11",{"$f":"I171","v":"2009-08-01"},0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N170=\"Amber\",INDIRECT(ADDRESS(ROW(M170)+1,COLUMN(M170))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E170","v":"Non-hand-held, 11-225 cm3, <19 kW"},{"$f":"IF(B171=Input!$AA$27,1,0)","v":0},"2007-08-01",{"$f":"H167","v":"2018-01-01"},"2009-08-01",{"$f":"J167","v":"2020-01-01"},0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N171=\"Amber\",INDIRECT(ADDRESS(ROW(M171)+1,COLUMN(M171))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, 11-225 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E171","v":"Non-hand-held, 11-225 cm3, <19 kW"},{"$f":"IF(B172=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H168","v":"2050-01-01"},"2020-01-01",{"$f":"J168","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N172=\"Amber\",INDIRECT(ADDRESS(ROW(M172)+1,COLUMN(M172))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW","Specialist_GSE","SparkIgnited","Non-hand-held, >225 cm3, <19 kW",{"$f":"IF(B173=Input!$AA$27,1,0)","v":0},{"$f":"G169","v":"1900-01-01"},{"$f":"G174","v":"2004-08-11"},"1902-01-01",{"$f":"I174","v":"2006-08-11"},0,0,{"$f":"M169","v":"Pre Stage I"},0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N173=\"Amber\",INDIRECT(ADDRESS(ROW(M173)+1,COLUMN(M173))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E173","v":"Non-hand-held, >225 cm3, <19 kW"},{"$f":"IF(B174=Input!$AA$27,1,0)","v":0},{"$f":"G170","v":"2004-08-11"},{"$f":"G175","v":"2006-08-01"},"2006-08-11",{"$f":"I175","v":"2008-08-01"},0,0,"Stage I",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N174=\"Amber\",INDIRECT(ADDRESS(ROW(M174)+1,COLUMN(M174))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E174","v":"Non-hand-held, >225 cm3, <19 kW"},{"$f":"IF(B175=Input!$AA$27,1,0)","v":0},"2006-08-01",{"$f":"H171","v":"2018-01-01"},"2008-08-01",{"$f":"J171","v":"2020-01-01"},0,0,"Stage II",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N175=\"Amber\",INDIRECT(ADDRESS(ROW(M175)+1,COLUMN(M175))),\"-\"))","v":"-"}]
["Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW_0","Specialist_GSE_SparkIgnited_Non-hand-held, >225 cm3, <19 kW","Specialist_GSE","SparkIgnited",{"$f":"E175","v":"Non-hand-held, >225 cm3, <19 kW"},{"$f":"IF(B176=Input!$AA$27,1,0)","v":0},"2018-01-01",{"$f":"H172","v":"2050-01-01"},"2020-01-01",{"$f":"J172","v":"2050-01-01"},0,0,"Stage V",0,{"$f":"IF(DateInput>Input!$B$24,\"-\",IF(N176=\"Amber\",INDIRECT(ADDRESS(ROW(M176)+1,COLUMN(M176))),\"-\"))","v":"-"}]

{"sheet":"Lists","index":2,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Vehicle","Car","Van","HGV","Specialist_GSE","CarDiesel","CarPetrol","VanDiesel","VanPetrol","HGVDiesel","Specialist_GSEDiesel","Specialist_GSEIgnited",null,"Dates"]
["Car","Diesel","Diesel","Diesel","Diesel","<1.4 l","<1.4 l","N1 (I) - ≤1305 kg","N1 (I) - ≤1305 kg","≤85 kW",">560 kW","Hand-held, < 20 cm3, <19 kW",null,"Date of Manufacture"]
["Van","Petrol","Petrol",null,"SparkIgnited","1.4-2.0 l","1.4-2.0 l","N1 (II) - 1305-1760 kg","N1 (II) - 1305-1760 kg",">85 kW","130-560 kW","Hand-held, 20-50 cm3, <19 kw",null,"Date of Registration"]
["HGV",null,null,null,null,">2.0 l",">2.0 l","N1 (III) - >1760 kg","N1 (III) - >1760 kg",null,"75-130 kW","Hand-held, >50 cm3, <19 kW"]
["Specialist_GSE",null,null,null,null,null,null,"N2 - >3.5 t","N2 - >3.5 t",null,"56-75 kW","Non-hand-held, < 66 cm3, <19 kW"]
[null,null,null,null,null,null,null,null,null,null,"37-56 kW","Non-hand-held, 66-100 cm3, <19 kW"]
[null,null,null,null,null,null,null,null,null,null,"19-37 kW","Non-hand-held, 11-225 cm3, <19 kW"]
[null,null,null,null,null,null,null,null,null,null,null,"Non-hand-held, >225 cm3, <19 kW"]

{"sheet":"Notes","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}