{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","Current Data Sheet","Historic Data Sheet","Dropdown fields"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Calculator","index":0,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[17,7,17,12],[18,7,18,12],[19,7,19,12],[20,7,20,12],[21,7,21,12],[22,7,22,12],[23,7,23,12],[26,7,26,12],[27,7,27,12],[28,7,28,12],[29,7,29,12],[30,7,30,12],[31,7,31,12],[34,7,34,12],[35,7,35,12],[36,7,36,12],[37,7,37,12],[38,7,38,12],[39,7,39,12],[42,7,42,12],[43,7,43,12],[44,7,44,12],[45,7,45,12],[46,7,46,12],[47,7,47,12],[50,7,50,12],[51,7,51,12],[52,7,52,12],[53,7,53,12],[54,7,54,12],[55,7,55,12],[58,7,58,12],[59,7,59,12],[60,7,60,12],[61,7,61,12],[78,7,78,12],[79,7,79,12],[62,7,62,12],[63,7,63,12],[66,7,66,12],[67,7,67,12],[68,7,68,12],[69,7,69,12],[70,7,70,12],[71,7,71,12],[74,7,74,12],[75,7,75,12],[76,7,76,12],[77,7,77,12]]}
[null,"UoY Travel Carbon Calculator ",null,null,null,"Version: 3.0. - Apr24"]
[null,null,null,null,null,"Originally created by Chris West (SEI York), data update by Mark Clough (DTEF - UoY) "]
[null,null,null,null,null,"Defra Conversion Factors used: 2023 (updated 28th June 2023)"]
[null,"INSTRUCTIONS"]
[null,"Use the rows below to select the number of people, travel mode, and distance"]
[null,"Details can also be added for overnight accommodation by location"]
[null,"Emissions associated with these entries will be calculated and a total provided"]
[null,"A 'notes' column allows additional details associated with the activity to be recorded (e.g. for helping with alignment between project activities etc). Notes are discretionary (i.e. use if helpful)"]
[null,"Five rows are provided under each entry. To add more rows select a cell within a row in a section you wish to duplicate and double-click the button above (Click to Duplicate Selected Row)"]
[null,"At the bottom of the sheet the user can adjust the offsetting price per tonne (default = £77.88 for approximate EAUC Carbon Coalition offsetting)."]
[null,"For help with estimating flight distances, try: ",null,"http://www.webflyer.com/travel/mileage_calculator/ "]
[null,"For help with estimating road and rail distances, try:",null,"https://www.joaoleitao.com/distance-calculator/ "]
[]
[null,"EMISSIONS TOTAL (kg CO2e)",{"$f":"SUM(G17:G80)","v":0}]
[null,"Offsetting cost",{"$f":"$C$14/1000*$C$82","v":0}]
[null,null,null,null,null,"Do not edit this column data","Do not edit this \ncolumn data"]
[null,"FLIGHTS"]
[null,"No. of Persons Travelling","Type","Class","Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX('Current Data Sheet'!$B$4:$F$7,MATCH(Calculator!$C19,'Current Data Sheet'!$A$4:$A$7,0),MATCH(Calculator!$D19,'Current Data Sheet'!$B$3:$F$3,0)),0)","v":0},{"$f":"B19*F19*E19","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX('Current Data Sheet'!$B$4:$F$7,MATCH(Calculator!$C20,'Current Data Sheet'!$A$4:$A$7,0),MATCH(Calculator!$D20,'Current Data Sheet'!$B$3:$F$3,0)),0)","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX('Current Data Sheet'!$B$4:$F$7,MATCH(Calculator!$C21,'Current Data Sheet'!$A$4:$A$7,0),MATCH(Calculator!$D21,'Current Data Sheet'!$B$3:$F$3,0)),0)","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX('Current Data Sheet'!$B$4:$F$7,MATCH(Calculator!$C22,'Current Data Sheet'!$A$4:$A$7,0),MATCH(Calculator!$D22,'Current Data Sheet'!$B$3:$F$3,0)),0)","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX('Current Data Sheet'!$B$4:$F$7,MATCH(Calculator!$C23,'Current Data Sheet'!$A$4:$A$7,0),MATCH(Calculator!$D23,'Current Data Sheet'!$B$3:$F$3,0)),0)","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX('Current Data Sheet'!$B$4:$F$7,MATCH(Calculator!$C24,'Current Data Sheet'!$A$4:$A$7,0),MATCH(Calculator!$D24,'Current Data Sheet'!$B$3:$F$3,0)),0)","v":0},0]
[]
[null,"RAIL"]
[null,"No. of Persons Travelling","Type",null,"Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C28,'Current Data Sheet'!$A$24:$B$27,2,0),0))","v":0},{"$f":"B28*F28*E28","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C29,'Current Data Sheet'!$A$24:$B$27,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C30,'Current Data Sheet'!$A$24:$B$27,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C31,'Current Data Sheet'!$A$24:$B$27,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C32,'Current Data Sheet'!$A$24:$B$27,2,0),0))","v":0},0]
[]
[null,"BUS"]
[null,"No. of Persons Travelling","Type",null,"Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C36,'Current Data Sheet'!$A$30:$B$33,2,0),0)","v":0},{"$f":"B36*F36*E36","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP(C37,'Current Data Sheet'!$A$30:$B$33,2,0),0)","v":0},{"$f":"B37*F37*E37","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C38,'Current Data Sheet'!$A$30:$B$33,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C39,'Current Data Sheet'!$A$30:$B$33,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C40,'Current Data Sheet'!$A$30:$B$33,2,0),0))","v":0},0]
[]
[null,"CAR"]
[null,"No. of Persons Travelling","Type","Passengers per car","Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA((VLOOKUP(C44,'Current Data Sheet'!$A$14:$B$21,2,0)/D44),0))","v":0},{"$f":"B44*F44*E44","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA((VLOOKUP(C45,'Current Data Sheet'!$A$14:$B$21,2,0)/D45),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA((VLOOKUP(C46,'Current Data Sheet'!$A$14:$B$21,2,0)/D46),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA((VLOOKUP(C47,'Current Data Sheet'!$A$14:$B$21,2,0)/D47),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA((VLOOKUP(C48,'Current Data Sheet'!$A$14:$B$21,2,0)/D48),0))","v":0},0]
[]
[null,"TAXI"]
[null,"No. of Persons Travelling","Type",null,"Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C52,'Current Data Sheet'!$A$36:$B$37,2,0),0))","v":0},{"$f":"B52*F52*E52","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C53,'Current Data Sheet'!$A$36:$B$37,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C54,'Current Data Sheet'!$A$36:$B$37,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C55,'Current Data Sheet'!$A$36:$B$37,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C56,'Current Data Sheet'!$A$36:$B$37,2,0),0))","v":0},0]
[]
[null,"FERRY"]
[null,"No. of Persons Travelling","Type",null,"Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C60,'Current Data Sheet'!$A$10:$B$11,2,0),0))","v":0},{"$f":"B60*F60*E60","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C61,'Current Data Sheet'!$A$10:$B$11,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C62,'Current Data Sheet'!$A$10:$B$11,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C63,'Current Data Sheet'!$A$10:$B$11,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(C64,'Current Data Sheet'!$A$10:$B$11,2,0),0))","v":0},0]
[]
[null,"MOTORBIKE"]
[null,"No. of Persons Travelling",null,"Passengers per bike","Estimated Distance (km)","Emissions (kg CO2e) per passenger km","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"IFERROR('Current Data Sheet'!$B$40/D68,0)","v":0},{"$f":"B68*F68*E68","v":0}]
[null,null,null,null,null,{"$f":"IFERROR('Current Data Sheet'!$B$40/D69,0)","v":0},0]
[null,null,null,null,null,{"$f":"IFERROR('Current Data Sheet'!$B$40/D70,0)","v":0},0]
[null,null,null,null,null,{"$f":"IFERROR('Current Data Sheet'!$B$40/D71,0)","v":0},0]
[null,null,null,null,null,{"$f":"IFERROR('Current Data Sheet'!$B$40/D72,0)","v":0},0]
[]
[null,"ACCOMODATION"]
[null,"No. of Rooms",null,"Location","Number of nights","Emissions (kg CO2e) per room","Emissions (kg CO2e) Subtotal","Notes (e.g. add destinations for travel for record-keeping)"]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(Calculator!D76,'Current Data Sheet'!$A$43:$B$97,2,0),0))","v":0},{"$f":"B76*F76*E76","v":0}]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(Calculator!D77,'Current Data Sheet'!$A$43:$B$97,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(Calculator!D78,'Current Data Sheet'!$A$43:$B$97,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(Calculator!D79,'Current Data Sheet'!$A$43:$B$97,2,0),0))","v":0},0]
[null,null,null,null,null,{"$f":"_xlfn.SINGLE(_xlfn.IFNA(VLOOKUP(Calculator!D80,'Current Data Sheet'!$A$43:$B$97,2,0),0))","v":0},0]
[]
[null,"CARBON PRICE PER TONNE:",77.88]

{"sheet":"Current Data Sheet","index":1,"n_rows":99,"n_cols":20,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["Defra Conversion Factors 2023: https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2023"]
[null,"Total:",null,null,null,null,null,"Direct:",null,null,null,null,null,null,"WTT:"]
["Flights","Average passenger","Economy class","Premium economy class","Business class","First class",null,"Flights","Average passenger","Economy class","Premium economy class","Business class","First class",null,"Flights - WTT","Average passenger","Economy class","Premium economy class","Business class","First class"]
["Domestic, to/from UK",{"$f":"I4+P4","v":0.30607678523489934},0.30607678523489934,0.30607678523489934,0.30607678523489934,0.30607678523489934,null,"Domestic, to/from UK",0.27257678523489931,{"$f":"I4","v":0.27257678523489931},{"$f":"I4","v":0.27257678523489931},{"$f":"I4","v":0.27257678523489931},{"$f":"I4","v":0.27257678523489931},null,"Domestic, to/from UK",3.3500000000000002E-2,{"$f":"P4","v":3.3500000000000002E-2},{"$f":"P4","v":3.3500000000000002E-2},{"$f":"P4","v":3.3500000000000002E-2},{"$f":"P4","v":3.3500000000000002E-2}]
["Short-haul, to/from UK",{"$f":"I5+P5","v":0.20877713959731539},0.20535935436241612,0.30803287785234901,0.30803287785234901,0.30803287785234901,null,"Short-haul, to/from UK",0.1859171395973154,0.18286935436241611,{"$f":"L5","v":0.27430287785234903},0.27430287785234903,{"$f":"L5","v":0.27430287785234903},null,"Short-haul, to/from UK",2.2859999999999998E-2,2.249E-2,{"$f":"S5","v":3.3730000000000003E-2},3.3730000000000003E-2,{"$f":"S5","v":3.3730000000000003E-2}]
["Long-haul, to/from UK",{"$f":"I6+P6","v":0.29341062953020131},0.22471828053691276,0.35952519328859062,0.6516569302013423,0.89884302953020123,null,"Long-haul, to/from UK",0.26128062953020131,0.20010828053691276,0.3201551932885906,0.58028693020134225,0.80040302953020126,null,"Long-haul, to/from UK",3.2129999999999999E-2,2.461E-2,3.9370000000000002E-2,7.1370000000000003E-2,9.844E-2]
["International, to/from non-UK",{"$f":"I7+P7","v":0.19742378389261744},0.15120333030872482,0.24190942147651007,0.43846320536912753,0.60477239999999999,null,"International, to/from non-UK",0.17580378389261744,0.13464333030872483,0.21541942147651008,0.39044320536912752,0.53854239999999998,null,"International, to/from non-UK",2.162E-2,1.6559999999999998E-2,2.649E-2,4.802E-2,6.6229999999999997E-2]
[]
["Ferry ",null,null,null,null,null,null,"Ferry ",null,null,null,null,null,null,"Ferry - WTT"]
["Foot passenger",{"$f":"I10+P10","v":2.2953142878090575E-2},null,null,null,null,null,"Foot passenger",1.8710813959731544E-2,null,null,null,null,null,"Foot passenger",4.2423289183590313E-3]
["Car passenger",{"$f":"I11+P11","v":0.15865316755798808},null,null,null,null,null,"Car passenger",0.12932887543624161,null,null,null,null,null,"Car passenger",2.9324292121746469E-2]
[]
["Cars (average car)",null,null,null,null,null,null,"Cars (average car)",null,null,null,null,null,null,"Cars (average car) - WTT"]
["Diesel",{"$f":"I14+P14","v":0.21127644888053693},null,null,null,null,null,"Diesel",0.16982644888053691,null,null,null,null,null,"Diesel",4.1450000000000001E-2]
["Petrol",{"$f":"I15+P15","v":0.2094185342281879},null,null,null,null,null,"Petrol",0.16390853422818791,null,null,null,null,null,"Petrol",4.5510000000000002E-2]
["Hybrid",0.15006858791946306,null,null,null,null,null,"Hybrid",0.11897858791946307,null,null,null,null,null,"Hybrid",3.109E-2]
["CNG",0.21093419731543628,null,null,null,null,null,"CNG",0.17504419731543627,null,null,null,null,null,"CNG",3.5889999999999998E-2]
["LPG",0.22043059731543624,null,null,null,null,null,"LPG",0.19704059731543624,null,null,null,null,null,"LPG",2.3390000000000001E-2]
["Plug-in Hybrid EV",9.0282130201342292E-2,null,null,null,null,null,"PHEV",6.5882130201342287E-2,null,null,null,null,null,"PHEV",2.4400000000000002E-2]
["Battery EV",1.2149999999999999E-2,null,null,null,null,null,"BEV",0,null,null,null,null,null,"BEV",1.2149999999999999E-2]
["Unknown",0.2102985879194631,null,null,null,null,null,"Unknown",0.16663858791946309,null,null,null,null,null,"Unknown",4.3659999999999997E-2]
[]
["Rail",null,null,null,null,null,null,"Rail",null,null,null,null,null,null,"Rail - WTT"]
["National rail",{"$f":"I24+P24","v":4.4382963758389266E-2},null,null,null,null,null,"National rail",3.5462963758389261E-2,null,null,null,null,null,"National rail",8.9200000000000008E-3]
["International rail",5.6190778523489936E-3,null,null,null,null,null,"International rail",4.4590778523489931E-3,null,null,null,null,null,"International rail",1.16E-3]
["Light rail and tram",3.6053267114093963E-2,null,null,null,null,null,"Light rail and tram",2.8603267114093962E-2,null,null,null,null,null,"Light rail and tram",7.45E-3]
["London Underground",3.504206711409396E-2,null,null,null,null,null,"London Underground",2.780206711409396E-2,null,null,null,null,null,"London Underground",7.2399999999999999E-3]
[]
["Bus",null,null,null,null,null,null,"Bus",null,null,null,null,null,null,"Bus - WTT"]
["Local bus (not London)",{"$f":"I30+P30","v":0.14723276912751679},null,null,null,null,null,"Local bus (not London)",0.11836276912751678,null,null,null,null,null,"Local bus (not London)",2.887E-2]
["Local London bus",9.7482508724832218E-2,null,null,null,null,null,"Local London bus",7.8322508724832221E-2,null,null,null,null,null,"Local London bus",1.916E-2]
["Average local bus",0.12708039463087248,null,null,null,null,null,"Average local bus",0.10215039463087248,null,null,null,null,null,"Average local bus",2.4930000000000001E-2]
["Coach",3.3741401342281874E-2,null,null,null,null,null,"Coach",2.7181401342281877E-2,null,null,null,null,null,"Coach",6.5599999999999999E-3]
[]
["Taxis",null,null,null,null,null,null,"Taxis",null,null,null,null,null,null,"Taxis - WTT"]
["Regular taxi",{"$f":"I36+P36","v":0.18558579717095777},null,null,null,null,null,"Regular taxi",0.14861492593825501,null,null,null,null,null,"Regular taxi",3.6970871232702762E-2]
["Black cab",0.25492069155398167,null,null,null,null,null,"Black cab",0.20402466838120806,null,null,null,null,null,"Black cab",5.0896023172773634E-2]
[]
["Motorbike (average)",null,null,null,null,null,null,"Motorbike (average)",null,null,null,null,null,null,"Motorbike (average) - WTT"]
["Motorbike (average)",{"$f":"I40+P40","v":0.14323500528719005},null,null,null,null,null,"Motorbike (average)",0.1136742644295302,null,null,null,null,null,"Motorbike (average)",2.9560740857659844E-2]
[]
["Hotel",null," = No 2023 figures so used 2021 figures"]
["UK",10.4]
["Unknown/Other",10.4]
["Argentina",56]
["Australia",35]
["Austria",13.9]
["Belgium",12.2]
["Brazil",8.6999999999999993]
["Canada",7.4]
["Chile",27.6]
["China",53.5]
["Colombia",14.7]
["Costa Rica",4.7]
["Czech Republic",36.200000000000003]
["Egypt",44.2]
["Fiji",47.8]
["Finland"]
["France",6.7]
["Germany",13.2]
["Greece",43]
["Hong Kong, China",51.5]
["India",58.9]
["Indonesia",62.7]
["Ireland",25]
["Israel",54]
["Italy",14.3]
["Japan",39]
["Jordan",68.900000000000006]
["Korea",55.8]
["Macau, China",75.599999999999994]
["Malaysia",61.5]
["Maldives",152.19999999999999]
["Mexico",19.3]
["Netherlands",14.8]
["New Zealand",14.8]
["Oman",90.3]
["Panama",90.3]
["Peru",22.5]
["Philippines",54.3]
["Poland",33.200000000000003]
["Portugal",19]
["Qatar",86.2]
["Romania",86.2]
["Russian Federation",24.2]
["Saudi Arabia",106.4]
["Singapore",24.5]
["Slovak Republic",24.5]
["South Africa",51.4]
["Spain",7]
["Switzerland",6.6]
["Taiwan, China",77.3]
["Thailand",43.4]
["Turkey",32.1]
["United Arab Emirates",63.8]
["United States",16.100000000000001]
["Vietnam",38.5]
[]
[null,null," = No 2023 figures so used 2021 figures"]

{"sheet":"Historic Data Sheet","index":2,"n_rows":196,"n_cols":20,"rows_kept":196,"cut":false,"hidden":false,"merged":[]}
["Defra Conversion Factors 2022: https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2022"]
[null,"Total:",null,null,null,null,null,"Direct:",null,null,null,null,null,null,"WTT:"]
["Flights","Average passenger","Economy class","Premium economy class","Business class","First class",null,"Flights","Average passenger","Economy class","Premium economy class","Business class","First class",null,"Flights - WTT","Average passenger","Economy class","Premium economy class","Business class","First class"]
["Domestic, to/from UK",{"$f":"I4+P4","v":0.27278000000000002},0.27278000000000002,0.27278000000000002,0.27278000000000002,0.27278000000000002,null,"Domestic, to/from UK",0.24587000000000001,{"$f":"I4","v":0.24587000000000001},{"$f":"I4","v":0.24587000000000001},{"$f":"I4","v":0.24587000000000001},{"$f":"I4","v":0.24587000000000001},null,"Domestic, to/from UK",2.691E-2,{"$f":"P4","v":2.691E-2},{"$f":"P4","v":2.691E-2},{"$f":"P4","v":2.691E-2},{"$f":"P4","v":2.691E-2}]
["Short-haul, to/from UK",0.17033999999999999,0.16755999999999999,0.25131999999999999,0.25131999999999999,0.25131999999999999,null,"Short-haul, to/from UK",0.15353,0.15101999999999999,{"$f":"L5","v":0.22652},0.22652,{"$f":"L5","v":0.22652},null,"Short-haul, to/from UK",1.6809999999999999E-2,1.6539999999999999E-2,{"$f":"S5","v":2.4799999999999999E-2},2.4799999999999999E-2,{"$f":"S5","v":2.4799999999999999E-2}]
["Long-haul, to/from UK",0.21423,0.16406000000000004,0.26250000000000001,0.47578000000000004,0.65624000000000005,null,"Long-haul, to/from UK",0.19309000000000001,0.14787000000000003,0.23659000000000002,0.42882000000000003,0.59147000000000005,null,"Long-haul, to/from UK",2.1139999999999999E-2,1.619E-2,2.5909999999999999E-2,4.6960000000000002E-2,6.4769999999999994E-2]
["International, to/from non-UK",0.20372999999999999,0.156025,0.24964,0.45246999999999998,0.62409999999999999,null,"International, to/from non-UK",0.18362000000000001,0.140625,0.22500000000000001,0.40781000000000001,0.56250999999999995,null,"International, to/from non-UK",2.0109999999999999E-2,1.54E-2,2.4639999999999999E-2,4.4659999999999998E-2,6.1589999999999999E-2]
[]
["Ferry ",null,null,null,null,null,null,"Ferry ",null,null,null,null,null,null,"Ferry - WTT"]
["Foot passenger",{"$f":"I10+P10","v":2.2949999999999998E-2},null,null,null,null,null,"Foot passenger",1.874E-2,null,null,null,null,null,"Foot passenger",4.2100000000000002E-3]
["Car passenger",0.15861,null,null,null,null,null,"Car passenger",0.12952,null,null,null,null,null,"Car passenger",2.9090000000000001E-2]
[]
["Cars (average car)",null,null,null,null,null,null,"Cars (average car)",null,null,null,null,null,null,"Cars (average car) - WTT"]
["Diesel",{"$f":"I14+P14","v":0.211864},null,null,null,null,null,"Diesel",0.170824,null,null,null,null,null,"Diesel",4.104E-2]
["Petrol",0.21933,null,null,null,null,null,"Petrol",0.17047999999999999,null,null,null,null,null,"Petrol",4.8849999999999998E-2]
["Hybrid",0.15135999999999999,null,null,null,null,null,"Hybrid",0.12003999999999999,null,null,null,null,null,"Hybrid",3.1320000000000001E-2]
["CNG",0.21234999999999998,null,null,null,null,null,"CNG",0.17516999999999999,null,null,null,null,null,"CNG",3.7179999999999998E-2]
["LPG",0.22114,null,null,null,null,null,"LPG",0.19775000000000001,null,null,null,null,null,"LPG",2.3390000000000001E-2]
["Plug-in Hybrid EV",0.12006,null,null,null,null,null,"PHEV",9.3490000000000004E-2,null,null,null,null,null,"PHEV",2.657E-2]
["Battery EV",6.5659999999999996E-2,null,null,null,null,null,"BEV",5.1400000000000001E-2,null,null,null,null,null,"BEV",1.426E-2]
["Unknown",0.21575,null,null,null,null,null,"Unknown",0.17066999999999999,null,null,null,null,null,"Unknown",4.5080000000000002E-2]
[]
["Rail",null,null,null,null,null,null,"Rail",null,null,null,null,null,null,"Rail - WTT"]
["National rail",{"$f":"I24+P24","v":4.4410000000000005E-2},null,null,null,null,null,"National rail",3.5490000000000001E-2,null,null,null,null,null,"National rail",8.9200000000000008E-3]
["International rail",5.62E-3,null,null,null,null,null,"International rail",4.4599999999999996E-3,null,null,null,null,null,"International rail",1.16E-3]
["Light rail and tram",3.6060000000000002E-2,null,null,null,null,null,"Light rail and tram",2.861E-2,null,null,null,null,null,"Light rail and tram",7.45E-3]
["London Underground",3.5049999999999998E-2,null,null,null,null,null,"London Underground",2.7809999999999998E-2,null,null,null,null,null,"London Underground",7.2399999999999999E-3]
[]
["Bus",null,null,null,null,null,null,"Bus",null,null,null,null,null,null,"Bus - WTT"]
["Local bus (not London)",{"$f":"I30+P30","v":0.13646},null,null,null,null,null,"Local bus (not London)",0.10778,null,null,null,null,null,"Local bus (not London)",2.8680000000000001E-2]
["Local London bus",9.8209999999999992E-2,null,null,null,null,null,"Local London bus",7.936E-2,null,null,null,null,null,"Local London bus",1.8849999999999999E-2]
["Average local bus",0.12144000000000001,null,null,null,null,null,"Average local bus",9.6500000000000002E-2,null,null,null,null,null,"Average local bus",2.494E-2]
["Coach",3.3790000000000001E-2,null,null,null,null,null,"Coach",2.733E-2,null,null,null,null,null,"Coach",6.4599999999999996E-3]
[]
["Taxis",null,null,null,null,null,null,"Taxis",null,null,null,null,null,null,"Taxis - WTT"]
["Regular taxi",{"$f":"I36+P36","v":0.18507999999999999},null,null,null,null,null,"Regular taxi",0.14876,null,null,null,null,null,"Regular taxi",3.6319999999999998E-2]
["Black cab",0.25416,null,null,null,null,null,"Black cab",0.20416000000000001,null,null,null,null,null,"Black cab",0.05]
[]
["Motorbike (average)",null,null,null,null,null,null,"Motorbike (average)",null,null,null,null,null,null,"Motorbike (average) - WTT"]
["Motorbike (average)",{"$f":"I40+P40","v":0.14488999999999999},null,null,null,null,null,"Motorbike (average)",0.11355,null,null,null,null,null,"Motorbike (average)",3.134E-2]
[]
["Hotel",null," = No 2023 figures so used 2022 figures"]
["UK",10.4]
["Unknown/Other",10.4]
["Argentina",56]
["Australia",35]
["Austria",13.9]
["Belgium",12.2]
["Brazil",8.6999999999999993]
["Canada",7.4]
["Chile",27.6]
["China",53.5]
["Colombia",14.7]
["Costa Rica",4.7]
["Czech Republic",36.200000000000003]
["Egypt",44.2]
["Fiji",47.8]
["France",6.7]
["Germany",13.2]
["Greece",43]
["Hong Kong, China",51.5]
["India",58.9]
["Indonesia",62.7]
["Ireland",25]
["Israel",54]
["Italy",14.3]
["Japan",39]
["Jordan",68.900000000000006]
["Korea",55.8]
["Macau, China",75.599999999999994]
["Malaysia",61.5]
["Maldives",152.19999999999999]
["Mexico",19.3]
["Netherlands",14.8]
["New Zealand",10.4]
["Oman",90.3]
["Panama",22.1]
["Peru",22.5]
["Philippines",54.3]
["Poland",33.200000000000003]
["Portugal",19]
["Qatar",86.2]
["Romania",25.5]
["Russian Federation",24.2]
["Saudi Arabia",106.4]
["Singapore",24.5]
["Slovak Republic",19.100000000000001]
["South Africa",51.4]
["Spain",7]
["Switzerland",6.6]
["Taiwan, China",77.3]
["Thailand",43.4]
["Turkey",32.1]
["United Arab Emirates",63.8]
["United States",16.100000000000001]
["Vietnam",38.5]
[]
[null,null," = No 2023 figures so used 2022 figures"]
[]
[]
[]
[2021,"Defra Conversion Factors 2021: https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2021 "]
[null,"Total:",null,null,null,null,null,"Direct:",null,null,null,null,null,null,"WTT:"]
["Flights","Average passenger","Economy class","Premium economy class","Business class","First class",null,"Flights","Average passenger","Economy class","Premium economy class","Business class","First class",null,"Flights - WTT","Average passenger","Economy class","Premium economy class","Business class","First class"]
["Domestic, to/from UK",{"$f":"I105+P105","v":0.27277999999999997},0.27277999999999997,0.27277999999999997,0.27277999999999997,0.27277999999999997,null,"Domestic, to/from UK",0.24586999999999998,0.24586999999999998,0.24586999999999998,0.24586999999999998,0.24586999999999998,null,"Domestic, to/from UK",2.691E-2,2.691E-2,2.691E-2,2.691E-2,2.691E-2]
["Short-haul, to/from UK",{"$f":"I106+P106","v":0.17034000000000002},0.16756000000000001,0.25132000000000004,0.25132000000000004,0.25132000000000004,null,"Short-haul, to/from UK",0.15353000000000003,0.15102000000000002,0.22652000000000003,0.22652000000000003,0.22652000000000003,null,"Short-haul, to/from UK",1.6809999999999999E-2,1.6539999999999999E-2,2.4799999999999999E-2,2.4799999999999999E-2,2.4799999999999999E-2]
["Long-haul, to/from UK",{"$f":"I107+P107","v":0.21423},0.16406000000000004,0.26250000000000001,0.47578000000000004,0.65624000000000005,null,"Long-haul, to/from UK",0.19309000000000001,0.14787000000000003,0.23659000000000002,0.42882000000000003,0.59147000000000005,null,"Long-haul, to/from UK",2.1139999999999999E-2,1.619E-2,2.5909999999999999E-2,4.6960000000000002E-2,6.4769999999999994E-2]
["International, to/from non-UK",{"$f":"I108+P108","v":0.20372999999999999},0.156025,0.24964,0.45246999999999998,0.62409999999999999,null,"International, to/from non-UK",0.18362000000000001,0.140625,0.22500000000000001,0.40781000000000001,0.56250999999999995,null,"International, to/from non-UK",2.0109999999999999E-2,1.54E-2,2.4639999999999999E-2,4.4659999999999998E-2,6.1589999999999999E-2]
[]
["Ferry ",null,null,null,null,null,null,"Ferry ",null,null,null,null,null,null,"Ferry - WTT"]
["Foot passenger",{"$f":"I111+P111","v":2.2945999999999998E-2},null,null,null,null,null,"Foot passenger",1.8737999999999998E-2,null,null,null,null,null,"Foot passenger",4.2079999999999999E-3]
["Car passenger",0.15860399999999999,null,null,null,null,null,"Car passenger",0.12951699999999999,null,null,null,null,null,"Car passenger",2.9086999999999998E-2]
[]
["Cars (average car)",null,null,null,null,null,null,"Cars (average car)",null,null,null,null,null,null,"Cars (average car) - WTT"]
["Diesel",{"$f":"I115+P115","v":0.20946999999999999},null,null,null,null,null,"Diesel",0.16843,null,null,null,null,null,"Diesel",4.104E-2]
["Petrol",0.32938000000000006,null,null,null,null,null,"Petrol",0.28053000000000006,null,null,null,null,null,"Petrol",4.8849999999999998E-2]
["Hybrid",0.22366000000000003,null,null,null,null,null,"Hybrid",0.19234000000000001,null,null,null,null,null,"Hybrid",3.1320000000000001E-2]
["CNG",0.32089999999999996,null,null,null,null,null,"CNG",0.28361999999999998,null,null,null,null,null,"CNG",3.7280000000000001E-2]
["LPG",0.34248000000000001,null,null,null,null,null,"LPG",0.31908999999999998,null,null,null,null,null,"LPG",2.3390000000000001E-2]
["Plug-in Hybrid EV",0.18257999999999999,null,null,null,null,null,"PHEV",0.15600999999999998,null,null,null,null,null,"PHEV",2.657E-2]
["Battery EV",0.10239999999999999,null,null,null,null,null,"BEV",8.8139999999999996E-2,null,null,null,null,null,"BEV",1.426E-2]
["Unknown",0.32103999999999999,null,null,null,null,null,"Unknown",0.27595999999999998,null,null,null,null,null,"Unknown",4.5080000000000002E-2]
[]
["Rail",null,null,null,null,null,null,"Rail",null,null,null,null,null,null,"Rail - WTT"]
["National rail",{"$f":"I125+P125","v":4.2819999999999997E-2},null,null,null,null,null,"National rail",3.5490000000000001E-2,null,null,null,null,null,"National rail",7.3299999999999997E-3]
["International rail",5.1999999999999998E-3,null,null,null,null,null,"International rail",4.4599999999999996E-3,null,null,null,null,null,"International rail",7.3999999999999999E-4]
["Light rail and tram",3.279E-2,null,null,null,null,null,"Light rail and tram",2.8129999999999999E-2,null,null,null,null,null,"Light rail and tram",4.6600000000000001E-3]
["London Underground",3.2419999999999997E-2,null,null,null,null,null,"London Underground",2.7809999999999998E-2,null,null,null,null,null,"London Underground",4.6100000000000004E-3]
[]
["Bus",null,null,null,null,null,null,"Bus",null,null,null,null,null,null,"Bus - WTT"]
["Local bus (not London)",{"$f":"I131+P131","v":0.14642000000000002},null,null,null,null,null,"Local bus (not London)",0.11774000000000001,null,null,null,null,null,"Local bus (not London)",2.8680000000000001E-2]
["Local London bus",9.6030000000000004E-2,null,null,null,null,null,"Local London bus",7.7179999999999999E-2,null,null,null,null,null,"Local London bus",1.8849999999999999E-2]
["Average local bus",0.12720999999999999,null,null,null,null,null,"Average local bus",0.10227,null,null,null,null,null,"Average local bus",2.494E-2]
["Coach",3.3299999999999996E-2,null,null,null,null,null,"Coach",2.6839999999999999E-2,null,null,null,null,null,"Coach",6.4599999999999996E-3]
[]
["Taxis",null,null,null,null,null,null,"Taxis",null,null,null,null,null,null,"Taxis - WTT"]
["Regular taxi",{"$f":"I137+P137","v":0.18507999999999999},null,null,null,null,null,"Regular taxi",0.14876,null,null,null,null,null,"Regular taxi",3.6319999999999998E-2]
["Black cab",0.25416,null,null,null,null,null,"Black cab",0.20416000000000001,null,null,null,null,null,"Black cab",0.05]
[]
["Motorbike (average)",null,null,null,null,null,null,"Motorbike (average)",null,null,null,null,null,null,"Motorbike (average) - WTT"]
["Motorbike (average)",{"$f":"I141+P141","v":0.14488999999999999},null,null,null,null,null,"Motorbike (average)",0.11355,null,null,null,null,null,"Motorbike (average)",3.134E-2]
[]
["Hotel"]
["UK",13.9]
["Unknown/Other",13.9]
["Argentina",56]
["Australia",42.6]
["Austria",13.9]
["Belgium",10.9]
["Brazil",12.3]
["Canada",16.100000000000001]
["Chile",30.5]
["China",62.9]
["Colombia",13.5]
["Costa Rica",7.5]
["Czech Republic",36.200000000000003]
["Egypt",56.5]
["Fiji",47.8]
["France",6.5]
["Germany",17]
["Greece",43]
["Hong Kong, China",65.900000000000006]
["India",75.5]
["Indonesia",89.1]
["Ireland",25]
["Israel",54]
["Italy",20.2]
["Japan",60.6]
["Jordan",62.4]
["Korea",61.2]
["Macau, China",75.599999999999994]
["Malaysia",83]
["Maldives",183.3]
["Mexico",25.9]
["Netherlands",20.9]
["New Zealand",10.4]
["Panama",22.1]
["Peru",22.5]
["Philippines",44.2]
["Poland",33.200000000000003]
["Portugal",26]
["Qatar",126.8]
["Romania",25.5]
["Russian Federation",31.8]
["Saudi Arabia",114.5]
["Singapore",37.799999999999997]
["Slovak Republic",19.100000000000001]
["South Africa",61]
["Spain",18.7]
["Switzerland",7.4]
["Taiwan, China",77.3]
["Thailand",51]
["Turkey",33.6]
["United Arab Emirates",114.4]
["United States",19.7]
["Vietnam",51.8]

{"sheet":"Dropdown fields","index":3,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Flight Type","Flight Class","Ferry Type","Car Type","Rail Type","Bus Type","Taxis","Hotel Location","Persons"]
["Domestic, to/from UK","Average passenger","Foot passenger","Diesel","National rail","Local bus (not London)","Regular taxi","UK",1]
["Short-haul, to/from UK","Economy class","Car passenger","Petrol","International rail","Local London bus","Black cab","Unknown/Other",2]
["Long-haul, to/from UK","Premium economy class",null,"Hybrid","Light rail and tram","Average local bus",null,"Argentina",3]
["International, to/from non-UK","Business class",null,"Compressed Natural Gas (CNG)","London Underground","Coach",null,"Australia",4]
[null,"First class",null,"Liquid Petroleum Gas (LPG)",null,null,null,"Austria",5]
[null,null,null,"Plug-in Hybrid EV",null,null,null,"Belgium",6]
[null,null,null,"Battery EV",null,null,null,"Brazil",7]
[null,null,null,"Unknown",null,null,null,"Canada",8]
[null,null,null,null,null,null,null,"Chile",9]
[null,null,null,null,null,null,null,"China",10]
[null,null,null,null,null,null,null,"Colombia",11]
[null,null,null,null,null,null,null,"Costa Rica",12]
[null,null,null,null,null,null,null,"Czech Republic",13]
[null,null,null,null,null,null,null,"Egypt",14]
[null,null,null,null,null,null,null,"Fiji",15]
[null,null,null,null,null,null,null,"France",16]
[null,null,null,null,null,null,null,"Germany",17]
[null,null,null,null,null,null,null,"Greece",18]
[null,null,null,null,null,null,null,"Hong Kong, China",19]
[null,null,null,null,null,null,null,"India",20]
[null,null,null,null,null,null,null,"Indonesia",21]
[null,null,null,null,null,null,null,"Ireland",22]
[null,null,null,null,null,null,null,"Israel",23]
[null,null,null,null,null,null,null,"Italy",24]
[null,null,null,null,null,null,null,"Japan",25]
[null,null,null,null,null,null,null,"Jordan",26]
[null,null,null,null,null,null,null,"Korea",27]
[null,null,null,null,null,null,null,"Macau, China",28]
[null,null,null,null,null,null,null,"Malaysia",29]
[null,null,null,null,null,null,null,"Maldives",30]
[null,null,null,null,null,null,null,"Mexico",31]
[null,null,null,null,null,null,null,"Netherlands",32]
[null,null,null,null,null,null,null,"New Zealand",33]
[null,null,null,null,null,null,null,"Oman",34]
[null,null,null,null,null,null,null,"Panama",35]
[null,null,null,null,null,null,null,"Peru",36]
[null,null,null,null,null,null,null,"Philippines",37]
[null,null,null,null,null,null,null,"Poland",38]
[null,null,null,null,null,null,null,"Portugal",39]
[null,null,null,null,null,null,null,"Qatar",40]
[null,null,null,null,null,null,null,"Romania",41]
[null,null,null,null,null,null,null,"Russian Federation",42]
[null,null,null,null,null,null,null,"Saudi Arabia",43]
[null,null,null,null,null,null,null,"Singapore",44]
[null,null,null,null,null,null,null,"Slovak Republic",45]
[null,null,null,null,null,null,null,"South Africa",46]
[null,null,null,null,null,null,null,"Spain",47]
[null,null,null,null,null,null,null,"Switzerland",48]
[null,null,null,null,null,null,null,"Taiwan, China",49]
[null,null,null,null,null,null,null,"Thailand",50]
[null,null,null,null,null,null,null,"Turkey"]
[null,null,null,null,null,null,null,"United Arab Emirates"]
[null,null,null,null,null,null,null,"United States"]
[null,null,null,null,null,null,null,"Vietnam"]