{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Impact Wanderers","Instructions & Basic Setup","Transport","Accommodation","Consumption and waste","Leisure","Volunteering","Dashboard - Results","backoffice","sources","ideas","Feuil1","Feuil2"],"not_rendered":{"charts":8,"images":110,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Impact Wanderers","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions & Basic Setup","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[35,1,35,2],[36,1,36,2],[37,1,37,2],[0,1,1,5],[0,7,1,8],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[20,1,20,2],[22,1,22,2],[21,1,21,2],[33,1,33,2],[34,1,34,2]]}
[null,"Let's get started: instructions",null,null,null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[]
[null,"This tool has been built to help you understand the negative and positive impact of your travels - both for a socio-economic and environmental perspective."]
[null,"We split the assessment in five parts: Transport, Accommodation, Consumption & waste, Leisure and volunteering."]
[null,"You can only enter one country at a time in this tool. If you wish to do the assessments for several countries, please save and complete several versions of this tool."]
[null,"We will soon publish an add-on that allows you to compare different countries. Stay tuned!"]
[]
[null,"This tool is meant to make you and us think about the impact of our choices while we travel - it is by no means meant to give a specific answer!"]
[null,"Indeed, impact assessment is a constantly evolving science."]
[null,"If you have ideas as to how to improve the visuals, frameworks, indicators, messages or datasets, do not hesitate to contact us. This tool is meant to evolve through time and integrate your feedback!"]
[]
[null,"Throughout the tool, we use the following visual code:"]
[]
[null,null,null,"Category name: do not touch"]
[null,null,null,"Data input: ONLY FILL IN THESE CELLS"]
[null,null,null,"Results: do not touch"]
[null,null,null,"Main results: do not touch"]
[null,null,null,"Navigation: click on the footprints to navigate between pages."]
[]
[]
[null,"THE DATA INPUT STARTS HERE: Please fill in the light orange cells below."]
[null,"# of days"]
[null,"# of travellers"]
[null,"Country in which you travel",null,"(Please select)"]
[null,"Where is home?",null,"(Please select)"]
[]
[null,"Please fill in the relevant light orange cells on each of the pages below and look at the results in the light blue cells."]
[null,"Transport"]
[null,"Accomodation"]
[null,"Consumption and waste"]
[null,"Leisure"]
[null,"Volunteering"]

{"sheet":"Transport","index":2,"n_rows":196,"n_cols":13,"rows_kept":196,"cut":false,"hidden":false,"merged":[[12,1,12,2],[185,1,185,7],[14,1,14,2],[89,1,89,2],[86,1,86,2],[75,1,75,2],[76,3,77,3],[43,1,43,2],[28,1,29,1],[67,1,67,5],[76,4,77,4],[79,1,82,4],[73,1,73,2],[170,6,170,12],[0,1,1,4],[18,1,22,6],[117,1,119,6],[166,1,168,7],[0,5,1,6],[13,1,13,2],[28,7,28,10],[76,1,77,2],[92,1,94,4],[69,1,70,8],[28,3,28,5],[121,3,121,5],[9,1,9,2],[8,1,8,2],[10,1,10,2],[11,1,11,2]]}
[null,"Transport: Carbon footprint and climate change",null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[]
[null,"Environmental impact",null,null,"Your travel:"]
[null,"Carbon footprint",null,null,"# of days",{"$f":"'Instructions & Basic Setup'!D28","v":0}]
[null,"Avoided emissions",null,null,"# of travellers",{"$f":"'Instructions & Basic Setup'!D29","v":0}]
[null,"What if analysis",null,null,"Country",{"$f":"'Instructions & Basic Setup'!D30","v":"(Please select)"}]
[null,"What if you had stayed home?",null,null,"Where is home?",{"$f":"'Instructions & Basic Setup'!D31","v":"(Please select)"}]
[null,"Socio-economic impact",null,null,"If you need to modify information on your travel, please do it on the instructions page."]
[null,"Results"]
[]
[null,"Environmental impact: How much greenhouse gas emissions did you emit?",null,null,null,null,null,"Back to top"]
[]
[null,"How to make the tool work? Specify below in the light orange cells the amount of kilometers and # of days travelled with each means of transportation. You can find the kilometers on websites such as google.maps. If you have the amount and type of fuel consumed (column D, E and F), it may help obtain more specific results, in particular for local transports such as tuk tuk ride or hybrid vehicles. If not, we will use an estimation (check the level of uncertainty in column H). Enter the number of people being transported in the car, tuk tuk (etc...) for private transport. In Cambodia, some of our shared cabs were taking 9 people!"]
[]
[]
[]
[]
[]
[null,"# of days",{"$f":"F10","v":0}]
[null,"# of travellers",{"$f":"F11","v":0}]
[null,"Country",{"$f":"F12","v":"(Please select)"}]
[]
[null,"Enter your data in the light orange cells (google.maps can help!)",null,"Optional",null,null,null,"Check out your results here and on the graphs below!"]
[null,null,"Total kilometers per person (over full time period)","Average # of people (total) in the vehicle","Total fuel consumption of the vehicle (litres)","Type of fuel",null,"Total kilometers per person per day","Greenhouse gases emissions (kg) per person per day","Level of certainty (3=best)","% repartition of greenhouse gases emissions"]
[null,"Plane",null,null,null,null,null,{"$f":"IFERROR(C31/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(VLOOKUP(B31,sources!$A$6:$B$17,2,FALSE)*C31/$C$25,\"NA\")","v":"NA"},{"$f":"IF(E31>0,3,3)","v":3},{"$f":"IFERROR(I31/$I$45,0)","v":0}]
[null,"Private car/ cab",null,null,null,"(Please select)",null,{"$f":"IFERROR(C32/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(IF(E32=\"\",C32*VLOOKUP(B32,sources!$A$6:$B$18,2,FALSE)/'Instructions & Basic Setup'!$D$28,VLOOKUP(Transport!F32,sources!$B$24:$D$35,3,FALSE)/'Instructions & Basic Setup'!$D$28/Transport!D32),\"NA\")","v":"NA"},{"$f":"IF(E32>0,3,2)","v":2},0]
[null,"Motorbike",null,null,null,"(Please select)",null,{"$f":"IFERROR(C33/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(IF(E33=\"\",C33*VLOOKUP(B33,sources!$A$6:$B$18,2,FALSE)/'Instructions & Basic Setup'!$D$28,VLOOKUP(Transport!F33,sources!$B$24:$D$35,3,FALSE)/'Instructions & Basic Setup'!$D$28/Transport!D33),\"NA\")","v":"NA"},{"$f":"IF(E33>0,3,2)","v":2},0]
[null,"Scooter",null,null,null,"(Please select)",null,"NA",{"$f":"IFERROR(IF(E34=\"\",C34*VLOOKUP(B34,sources!$A$6:$B$18,2,FALSE)/'Instructions & Basic Setup'!$D$28,VLOOKUP(Transport!F34,sources!$B$24:$D$35,3,FALSE)/'Instructions & Basic Setup'!$D$28/Transport!D34),\"NA\")","v":"NA"},{"$f":"IF(E34>0,3,2)","v":2},0]
[null,"Tuk tuk",null,null,null,"(Please select)",null,"NA",{"$f":"IFERROR(IF(E35=\"\",C35*VLOOKUP(B35,sources!$A$6:$B$18,2,FALSE)/'Instructions & Basic Setup'!$D$28,VLOOKUP(Transport!F35,sources!$B$24:$D$35,3,FALSE)/'Instructions & Basic Setup'!$D$28/Transport!D35),\"NA\")","v":"NA"},{"$f":"IF(E35>0,3,1)","v":1},0]
[null,"Boat",null,null,null,"(Please select)",null,"NA",{"$f":"IFERROR(IF(E36=\"\",C36*VLOOKUP(B36,sources!$A$6:$B$18,2,FALSE)/'Instructions & Basic Setup'!$D$28,VLOOKUP(Transport!F36,sources!$B$24:$D$35,3,FALSE)/'Instructions & Basic Setup'!$D$28/Transport!D36),\"NA\")","v":"NA"},{"$f":"IF(E36>0,3,1)","v":1},0]
[null,"Bus",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B37,sources!$A$6:$B$17,2,FALSE)*C37/$C$25,\"NA\")","v":"NA"},{"$f":"IF(E37>0,3,1)","v":1},0]
[null,"Train",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B38,sources!$A$6:$B$17,2,FALSE)*C38/$C$25,\"NA\")","v":"NA"},{"$f":"IF(E38>0,3,1)","v":1},0]
[null,"Metro/ tube",null,null,null,null,null,"NA",{"$f":"IFERROR(C39*sources!B21*VLOOKUP(Transport!C27,sources!A38:C183,3,FALSE)/C25,\"NA\")","v":"NA"},2,0]
[null,"Hitchhiking",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B40,sources!$A$6:$B$17,2,FALSE)*C40/$C$25,\"NA\")","v":"NA"},{"$f":"IF(E40>0,3,3)","v":3},0]
[null,"Bicycle",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B41,sources!$A$6:$B$17,2,FALSE)*C41/$C$25,\"NA\")","v":"NA"},{"$f":"IF(E41>0,3,3)","v":3},0]
[null,"Walking",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B42,sources!$A$6:$B$17,2,FALSE)*C42/$C$25,\"NA\")","v":"NA"},{"$f":"IF(E42>0,3,3)","v":3},0]
[]
[null,"Main results"]
[null,"Total km with air transport",{"$f":"SUM(C31:C42)","v":0},null,"Total emissions with air transport",null,null,{"$f":"SUM(H31:H42)","v":0},{"$f":"SUM(I31:I42)","v":0},{"$f":"SUMPRODUCT(J31:J42,K31:K42)","v":0}]
[null,"Total km witout air transport",{"$f":"SUM(C32:C42)","v":0},null,"Total emissions without air transport",null,null,{"$f":"SUM(H32:H42)","v":0},{"$f":"SUM(I32:I42)","v":0},{"$f":"IFERROR(SUMPRODUCT(I32:I42,J32:J42)/SUM(I32:I42),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Positive impact and \"What if ?\" analysis",null,null,null,null,null,"Back to top"]
[]
[null,"What quantity of carbon emissions did you avoid because you took some public and carbon-free transport locally? We help you calculate the carbon emissions you avoided by choosing these means of transportation."]
[]
[]
[]
[null,"You avoided this amount of carbon emissions…",null,"Kg of greenhouse gases per traveller","% of actual carbon footprint"]
[null,null,null,"1 traveller ",null,null,null,null,{"$f":"D75","v":"1 traveller "},0]
[null,"Because you took carbon-free transport (hitchkiking, cycling, walking), you saved:",null,{"$f":"IFERROR(SUM(I32:I42)/SUM(H32:H42)*(H40+H41+H42)*C25,\"NA\")","v":"NA"},{"$f":"IFERROR(D76/($I$45*$C$25),\"NA\")","v":"NA"},null,{"$f":"B76","v":"Because you took carbon-free transport (hitchkiking, cycling, walking), you saved:"},null,"NA","NA"]
[null,"Because you took public transport & carbon-free over private car, you saved:",null,{"$f":"IFERROR(SUM($C$32:$C$42)*VLOOKUP($B32,sources!$A$6:$B$17,2,FALSE)-D87,\"NA\")","v":0},{"$f":"IFERROR(D77/($I$45*$C$25),\"NA\")","v":"NA"},null,{"$f":"B77","v":"Because you took public transport & carbon-free over private car, you saved:"},null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"B87","v":"Your actual carbon footprint in kg per person over the full period of time"},null,{"$f":"D87","v":0},{"$f":"E87","v":0}]
[null,null,null,null,null,null,{"$f":"CONCATENATE($B$85,B88)","v":"What if you had…...Used only private transport (car)"},null,{"$f":"D88+D$87","v":0},{"$error":"#VALUE!"}]
[null,"What your carbon emissions would be if you had chosen another transportation means: what if you had taken only private transports locally, for example cars, cabs or motorcycles? On the other hand, what if you had taken only carbon-free transport (hitchiking, cycling, walking) all the time? We exclude air travels from these results.",null,null,null,null,{"$f":"CONCATENATE($B$85,B89)","v":"What if you had…...Used only private transport (motorcycle/ scooter) "},null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,{"$f":"CONCATENATE($B$85,B90)","v":"What if you had…...Used only buses"},null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,{"$f":"CONCATENATE($B$85,B91)","v":"What if you had…...Used only carbon-free transport (incl. Hitchhiking)"},null,0,{"$error":"#VALUE!"}]
[]
[]
[null,"What if you had…",null,"kg of greenhouse gases per traveller you would have saved (-) or emitted additional  (+)  if…","% of actual carbon footprint"]
[null,null,null,"1 traveller"]
[null,"Your actual carbon footprint in kg per person over the full period of time",null,{"$f":"I46*C25","v":0}]
[null,"...Used only private transport (car)",null,{"$f":"IFERROR((SUM($C$32:$C$42)*VLOOKUP(\"Private car/ cab\",sources!$A$6:$B$17,2,FALSE)-D$87),\"NA\")","v":0},{"$f":"IFERROR(D88/($I$45*$C$25),\"NA\")","v":"NA"}]
[null,"...Used only private transport (motorcycle/ scooter) ",null,{"$f":"IFERROR((SUM($C$32:$C$42)*VLOOKUP(\"Motorbike\",sources!$A$6:$B$17,2,FALSE)-D87),\"NA\")","v":0},{"$f":"IFERROR(D89/($I$45*$C$25),\"NA\")","v":"NA"}]
[null,"...Used only buses",null,{"$f":"IFERROR((SUM($C$32:$C$42)*VLOOKUP(\"Bus\",sources!$A$6:$B$17,2,FALSE)-D87),\"NA\")","v":0},{"$f":"IFERROR(D90/($I$45*$C$25),\"NA\")","v":"NA"}]
[null,"...Used only carbon-free transport (incl. Hitchhiking)",null,{"$f":"IFERROR(-D87,\"NA\")","v":0},{"$f":"IFERROR(D91/($I$45*$C$25),\"NA\")","v":"NA"}]
[]
[null,"Red means that you would have emitted more using this option. Green means you would have saved/ avoided the emission of greenhouse gases. Orange means that the difference is too small to say, as the calculations bear a level of uncertainty."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"What if you had stayed home?"]
[]
[null,"Enter below the average distance travelled per year using each of these transportation means in the light orange cells. If you know the exact fuel consumption, enter it in columns D, E and F for more precision in the results."]
[]
[]
[]
[null,null,null,"Optional"]
[null,"# of people",{"$f":"F11","v":0}]
[null,"Where is home?",{"$f":"F13","v":"(Please select)"}]
[]
[null,null,"Kilometers (total for all travellers) per year","Average # of people (total) in the vehicle","Fuel consumption (litres)","Type of fuel",null,"Kilometers per person per day","Greenhouse gases (kg) per person per day","Level of certainty (3=best)","% of total GHGs"]
[null,"Plane",null,null,null,null,null,{"$f":"IFERROR(C127/$C$123/365,\"NA\")","v":"NA"},{"$f":"IFERROR(VLOOKUP(B127,sources!$A$6:$B$17,2,FALSE)*C127/$C$123/365,\"NA\")","v":"NA"},{"$f":"IF(E127>0,3,3)","v":3},{"$f":"IFERROR(I127/$I$140,0)","v":0}]
[null,"Private car/ cab",null,null,null,null,null,{"$f":"IFERROR(C128/$C$123/365,\"NA\")","v":"NA"},{"$f":"IFERROR(IF(E128=\"\",C128*VLOOKUP(B128,sources!$A$6:$B$18,2,FALSE)/C123/365,VLOOKUP(Transport!F128,sources!$B$24:$D$35,3,FALSE)/D128/365),\"NA\")","v":"NA"},{"$f":"IF(E128>0,3,2)","v":2},0]
[null,"Motorbike",null,null,null,null,null,"NA",{"$f":"IFERROR(IF(E129=\"\",C129*VLOOKUP(B129,sources!$A$6:$B$18,2,FALSE)/$C$123/365,VLOOKUP(Transport!F129,sources!$B$24:$D$35,3,FALSE)/D129/365),\"NA\")","v":"NA"},{"$f":"IF(E129>0,3,2)","v":2},0]
[null,"Scooter",null,null,null,null,null,"NA",{"$f":"IFERROR(IF(E130=\"\",C130*VLOOKUP(B130,sources!$A$6:$B$18,2,FALSE)/$C$123/365,VLOOKUP(Transport!F130,sources!$B$24:$D$35,3,FALSE)/D130/365),\"NA\")","v":"NA"},{"$f":"IF(E130>0,3,2)","v":2},0]
[null,"Tuk tuk",null,null,null,null,null,"NA",{"$f":"IFERROR(IF(E131=\"\",C131*VLOOKUP(B131,sources!$A$6:$B$18,2,FALSE)/$C$123/365,VLOOKUP(Transport!F131,sources!$B$24:$D$35,3,FALSE)/D131/365),\"NA\")","v":"NA"},{"$f":"IF(E131>0,3,1)","v":1},0]
[null,"Boat",null,null,null,null,null,"NA",{"$f":"IFERROR(IF(E132=\"\",C132*VLOOKUP(B132,sources!$A$6:$B$18,2,FALSE)/$C$123/365,VLOOKUP(Transport!F132,sources!$B$24:$D$35,3,FALSE)/D132/365),\"NA\")","v":"NA"},{"$f":"IF(E132>0,3,1)","v":1},0]
[null,"Bus",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B133,sources!$A$6:$B$17,2,FALSE)*C133/$C$123/365,\"NA\")","v":"NA"},{"$f":"IF(E133>0,3,1)","v":1},0]
[null,"Train",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B134,sources!$A$6:$B$17,2,FALSE)*C134/$C$123/365,\"NA\")","v":"NA"},{"$f":"IF(E134>0,3,1)","v":1},0]
[null,"Metro/ tube",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B135,sources!$A$6:$B$18,2,FALSE)*C135/$C$123/365,\"NA\")","v":"NA"},2,0]
[null,"Hitchhiking",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B136,sources!$A$6:$B$17,2,FALSE)*C136/$C$123/365,\"NA\")","v":"NA"},{"$f":"IF(E136>0,3,3)","v":3},0]
[null,"Bicycle",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B137,sources!$A$6:$B$17,2,FALSE)*C137/$C$123/365,\"NA\")","v":"NA"},{"$f":"IF(E137>0,3,3)","v":3},0]
[null,"Walking",null,null,null,null,null,"NA",{"$f":"IFERROR(VLOOKUP(B138,sources!$A$6:$B$17,2,FALSE)*C138/$C$123/365,\"NA\")","v":"NA"},{"$f":"IF(E138>0,3,3)","v":3},0]
[]
[null,"Total",{"$f":"SUM(C127:C138)","v":0},null,null,null,"Total",{"$f":"SUM(H127:H138)","v":0},{"$f":"SUM(I127:I138)","v":0},{"$f":"SUMPRODUCT(J127:J138,K127:K138)","v":0}]
[null,null,null,null,null,null,"Versus…",{"$f":"H45","v":0},{"$f":"I45","v":0},{"$f":"J45","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Socio-economic impact: What is your spend profile?",null,null,null,null,null,"Back to top"]
[]
[null,"What is the socio-economic impact of your choices of transportation? As a proxy we suggest analysing your spend profile. Did you give more to small businesses or large ones? Was your money spent in the local economy or on international brands? Was your money spent in an organization that seeks to have a \"positive impact\"?"]
[]
[]
[]
[null,null,null,null,null,null,"Enter all what you spent on transport over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,null,"Total USD","USD per person per day","%",null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent ($)"]
[null,"Small ",{"$f":"SUMIF($E$188:$E$1048576,B173,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C173/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C173/SUM(M:M),\"NA\")","v":0},null,{"$f":"F12","v":"(Please select)"},"Taxi tour 1 day","Transport","Small ","Local","N",100]
[null,"Medium",{"$f":"SUMIF($E$188:$E$1048576,B174,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C174/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C174/SUM(M:M),\"NA\")","v":0},null,{"$f":"$C$27","v":"(Please select)"},"plane ticket","Transport","Large","International","N",1000]
[null,"Large",{"$f":"SUMIF($E$188:$E$1048576,B175,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C175/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C175/SUM(M:M),\"NA\")","v":0},null,"(Please select)","Train tickets","Transport","Public services","Local","N",100]
[null,"Public services",{"$f":"SUMIF($E$188:$E$1048576,B176,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C176/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C176/SUM(M:M),\"NA\")","v":0},null,"(Please select)","Taxi - regulars","Transport","Large","Local","N",300]
[null,"Religious institutions",{"$f":"SUMIF($E$188:$E$1048576,B177,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C177/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C177/SUM(M:M),\"NA\")","v":0},null,"(Please select)",null,"Transport","Large","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"Transport","Large","Local","N"]
[null,"Local",{"$f":"SUMIF($F$188:$F$1048576,B179,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C179/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C179/SUM(M:M),\"NA\")","v":0},null,"(Please select)",null,"Transport","Large","Local","N"]
[null,"International",{"$f":"SUMIF($F$188:$F$1048576,B180,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C180/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C180/SUM(M:M),\"NA\")","v":0},null,"(Please select)",null,"Transport","Large","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"Transport","Large","Local","N"]
[null,"Positive impact",{"$f":"SUMIF($G$188:$G$1048576,B182,$H$188:$H$1048576)","v":0},{"$f":"IFERROR(C182/$C$123/$C$25,\"NA\")","v":"NA"},{"$f":"IFERROR(C182/SUM(M:M),\"NA\")","v":0},null,"(Please select)",null,"Transport","Large","Local","N"]
[null,"Conventional",null,null,{"$f":"1-E182","v":1}]
[null,"Total",{"$f":"SUM(C173:C177)","v":0},{"$f":"IFERROR(C184/$C$17/$C$18, \"NA\")","v":"NA"}]
[]
[null,"Enter all what you spent on transport over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent ($)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"'Instructions & Basic Setup'!$D$30","v":"(Please select)"},null,"Transport","(Please select)","(Please select)","(Please select)"]

{"sheet":"Accommodation","index":3,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[28,4,29,5],[56,1,56,7],[25,1,25,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[41,6,41,12],[31,1,31,2],[22,4,22,5],[37,1,39,6],[0,5,1,6],[0,1,1,4],[18,1,20,6],[23,4,25,5],[26,4,27,5],[23,1,23,2],[26,1,26,2],[24,1,24,2],[27,1,27,2],[32,1,32,2],[31,4,31,8],[28,1,28,2],[29,1,29,2],[32,4,32,8]]}
[null,"Accomodation: your money does not sleep",null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"# of days",{"$f":"'Instructions & Basic Setup'!D28","v":0}]
[null,"Environmental impact",null,null,"# of travellers",{"$f":"'Instructions & Basic Setup'!D29","v":0}]
[null,"Socio-economic impact",null,null,"Country",{"$f":"'Instructions & Basic Setup'!D30","v":"(Please select)"}]
[null,"Results",null,null,"Where is home?",{"$f":"'Instructions & Basic Setup'!D31","v":"(Please select)"}]
[null,null,null,null,"If you need to modify information on your travel, please do it here:"]
[null,"Environmental impact: focus on \"special situations\"",null,null,null,null,null,"Back to top"]
[]
[null,"# of days",{"$f":"F8","v":0}]
[null,"# of travellers",{"$f":"F9","v":0}]
[null,"Country",{"$f":"F10","v":"(Please select)"}]
[]
[null,"We identify \"special situations\" (either in the positive or negative) and assess them by assigning them a high-level bonus/malus score. For example, we stayed in a few places where electricity was 100% renewable, thereby saving carbon emissions. We assign a bonus of 4 out of 5. In addition, we need to take into account the context: saving energy is far more important from an climate change perspective in a country where the energy mix is very carbon-intensive. We include an index to shed light on this, with 100 the worst situation and 0 the worst."]
[]
[]
[null,"Instructions: fill in the orange cells"]
[null,"# of nights spent…:",null,null,"Rationale",null,"Bonus/malus",null,null,"Bonus/malus"]
[null,"… camping/ no electricity",null,"NA","… thereby not emitting greenhouse gases linked to energy use.",null,0,null,null,1]
[null,"… couchsurfing",null,"NA",null,null,1,null,null,2]
[null,"… in places running on 80+% renewable energy",null,"NA",null,null,0,null,null,2]
[null,"… dorms",null,"NA","Dorms and homestays tend to use less energy than hotels, given that you share the common areas/ rooms with more people.",null,2,null,null,3]
[null,"… homestays ",null,"NA",null,null,3,null,null,3]
[null,"… mid-range hotels",null,"NA","These hotels tend to use more energy and water per client (more space, lights, swimming pool, towels…)",null,3,null,null,4]
[null,"… high-end hotels ",null,"NA",null,null,5,null,null,5]
[]
[null,"Bonus/malus (5=worst; 1=best)",null,{"$f":"IFERROR(SUMPRODUCT(J24:J30,D24:D30)/SUM(D24:D30),\"NA\")","v":"NA"},"Weighted average"]
[null,"Country GHGs index (0=best; 100=worst)",null,{"$f":"IFERROR(VLOOKUP(C17,sources!$A$38:$E$183,5,FALSE),\"NA\")","v":"NA"},"Saving energy is even more important in countries with a high GHG intensity of electricity."]
[]
[]
[null,"Socio-economic impact: What is your spend profile?",null,null,null,null,null,"Back to top"]
[]
[null,"What is the socio-economic impact of your choices of accomodation? As a proxy we suggest analysing your spend profile. Did you give more to small businesses or large ones? Was your money spent in the local economy or on international brands? Was your money spent in an organization that seeks to have a \"positive impact\"?"]
[]
[]
[]
[null,"Instructions: Check the results below after filling the light orange cells on the right. ",null,null,null,null,"Enter all what you spent on accomodation over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,null,"Total USD","USD per person per day","%",null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent (US $)"]
[null,"Small ",{"$f":"SUMIF($E$59:$E$497,B44,H$59:$H$497)","v":0},{"$f":"IFERROR(C44/$C$15/$C$16, \"NA\")","v":"NA"},{"$f":"IFERROR(D44/SUM($D$44:$D$48),\"NA\")","v":"NA"},null,{"$f":"$C$17","v":"(Please select)"},"camping","Accomodation","Medium","Local","N",20]
[null,"Medium",{"$f":"SUMIF($E$59:$E$497,B45,H$59:$H$497)","v":0},{"$f":"IFERROR(C45/$C$15/$C$16, \"NA\")","v":"NA"},{"$f":"IFERROR(D45/SUM($D$44:$D$48),\"NA\")","v":"NA"},null,"(Please select)","Eco tourism","Accomodation","Medium","Local","N",100]
[null,"Large",{"$f":"SUMIF($E$59:$E$497,B46,H$59:$H$497)","v":0},"NA","NA",null,"(Please select)","Homestay","Accomodation","Small ","Local","N",30]
[null,"Public services",{"$f":"SUMIF($E$59:$E$497,B47,H$59:$H$497)","v":0},"NA","NA",null,"(Please select)","3 mid-range H","Accomodation","Large","Local","N",150]
[null,"Religious institutions",{"$f":"SUMIF($E$59:$E$497,B48,H$59:$H$497)","v":0},"NA","NA",null,"(Please select)","4 High end","Accomodation","Large","Local","N",400]
[null,null,null,null,null,null,"(Please select)",null,"Accomodation","Large","Local","N"]
[null,"Local",{"$f":"SUMIF($F$59:$F$497,B50,H$59:$H$497)","v":0},"NA",{"$f":"IFERROR(D50/SUM($D$50:$D$51),\"NA\")","v":"NA"},null,"(Please select)",null,"Accomodation","Large","Local","N"]
[null,"International",{"$f":"SUMIF($F$59:$F$497,B51,H$59:$H$497)","v":0},"NA",{"$f":"IFERROR(D51/SUM($D$50:$D$51),\"NA\")","v":"NA"},null,"(Please select)",null,"Accomodation","Large","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"Accomodation","Large","Local","N"]
[null,"Positive impact",{"$f":"SUMIF($G$59:$G$497,\"Y\",H$59:$H$497)","v":0},"NA",{"$f":"IFERROR(D53/D55,\"NA\")","v":"NA"},null,"(Please select)",null,"Accomodation","Large","Local","N"]
[null,"Conventional",{"$f":"C55-C53","v":0},null,null,null,"(Please select)",null,"Accomodation","Large","Local","N"]
[null,"Total",{"$f":"SUM(C44:C48)","v":0},"NA",null,null,"(Please select)",null,"Accomodation","Large","Local","N"]
[]
[null,"Enter all what you spent on accomodation over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent (US $)"]
[null,{"$f":"$C$17","v":"(Please select)"},null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Accomodation","(Please select)","(Please select)","(Please select)"]

{"sheet":"Consumption and waste","index":4,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":false,"merged":[[97,1,97,7],[0,1,1,5],[8,1,8,2],[11,1,11,2],[37,1,37,2],[36,1,36,2],[35,1,35,2],[19,1,19,2],[9,1,9,2],[10,1,10,2],[23,2,23,3],[12,1,12,2],[75,6,76,12],[39,1,39,2],[81,6,81,12],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[50,1,51,5],[77,1,79,6],[0,6,1,7],[16,1,17,5],[21,1,21,5],[41,1,41,5],[44,4,44,5]]}
[null,"Consumption and waste: you are what you buy (and waste…)",null,null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Your travel:"]
[null,"Environmental impact",null,null,"# of days",{"$f":"'Instructions & Basic Setup'!D28","v":0}]
[null,"Focus on plastic waste",null,null,"# of travellers",{"$f":"'Instructions & Basic Setup'!D29","v":0}]
[null,"Focus on food",null,null,"Country",{"$f":"'Instructions & Basic Setup'!D30","v":"(Please select)"}]
[null,"Socio-economic impact",null,null,"Where is home?",{"$f":"'Instructions & Basic Setup'!D31","v":"(Please select)"}]
[null,"Results",null,null,"If you need to modify information on your travel, please do it here:"]
[]
[null,"Environmental impact: focus on plastic waste and food",null,null,null,"Back to top"]
[]
[null,"Consumption of food and souvenirs can have a wide range of environmental impact, through waste but also the resources needed and the pollution generated by their production. While it is possible to quantify the carbon, water, biodiversity and pollution footprint of consumption, it is time-consuming and necessitates a large amount of data. Therefore, we adopt here an intermediate approach, where we focus on the amount of plastic waste generated and the type of food consumed."]
[]
[]
[null,"Focus on plastic waste"]
[]
[null,"In certain countries, a traveller may generate much more plastic waste than at home, because of the straws, plastic bottles etc. Minimizing one's plastic footprint (and more broadly waste) is particularly important as many countries do not have a proper waste collection and management system in place."]
[]
[null,null,"Instructions: fill in the light orange cells",null,"Optional"]
[null,null,"# bought/ consumed while travelling (approximation) for all travellers","Estimated weight (kg)","# bought/ consumed while at home, over the same period of time (approximation)","Estimated weight (kg)"]
[null,"# of plastic cups",null,{"$f":"15/1000*C26","v":0},"NA",{"$f":"IFERROR(15/1000*E26,\"NA\")","v":"NA"}]
[null,"# of plastic bags",null,{"$f":"5/1000*C27","v":0},"NA",{"$f":"IFERROR(5/1000*E27,\"NA\")","v":"NA"}]
[null,"# straws",null,{"$f":"C28*10/1000","v":0},"NA",{"$f":"IFERROR(E28*10/1000,\"NA\")","v":"NA"}]
[null,"# of plastic bottles (33 cl)",null,{"$f":"10*33/50/1000*C29","v":0},"NA",{"$f":"IFERROR(10*33/50/1000*E29,\"NA\")","v":"NA"}]
[null,"# of plastic bottles (1L)",null,{"$f":"10*100/50/1000*C30","v":0},"NA",{"$f":"IFERROR(10*100/50/1000*E30,\"NA\")","v":"NA"}]
[null,"# of plastic bottles (1.5l)",null,{"$f":"10*150/50/1000*C31","v":0},"NA",{"$f":"IFERROR(10*150/50/1000*E31,\"NA\")","v":"NA"}]
[null,"# of plastic bottles (5l)",null,{"$f":"10*500/50/1000*C32","v":0},"NA",{"$f":"IFERROR(10*500/50/1000*E32,\"NA\")","v":"NA"}]
[null,"# of bottle refills (in litres)",null,{"$f":"-10*100/50/1000*C33","v":0},"NA",{"$f":"IFERROR(-10*100/50/1000*E33,\"NA\")","v":"NA"}]
[]
[null,null,null,"While travelling",null,"While at home"]
[null,"Total plastic use and waste (kg, over full period)",null,{"$f":"SUM(D26:D32)","v":0},null,{"$f":"SUM(F26:F32)","v":0}]
[null,"Plastic waste avoided (kg, total over full period)",null,{"$f":"D33","v":0},null,{"$f":"F33","v":"NA"}]
[null,"Country waste management index (0=best; 100=worst)"]
[]
[null,"Focus on food"]
[]
[null,"Your food choices may have a substantial environmental impact, whether it is on carbon emissions, water use or biodiversity losses. It is difficult to calculate precisely in kg of carbon or cubic meter of water the environmental impact of your food - therefore we focus on practices (did you eat mostly vegetarian meals?) as a proxy."]
[]
[null,null,null,"Optional"]
[null,null,"% of meals that are...; while travelling","% of meals that are...; while at home ","Rationale"]
[null,"% of meals vegetarian","Fill in","Fill in","Tend to have a lower environmental footprint."]
[null,"% of meals non-vegetarian","Fill in","Fill in"]
[null,"% of meals organic","Fill in","Fill in","Tend to have a lower environmental footprint."]
[null,"% of meals non-organic","Fill in","Fill in"]
[]
[null,"If you want to refine the analysis, feel in the light orange cells below. It will calculate the weighted average environmental score of the type of food you consume. Should you want to compare it with your diet at home, please feel in the second column too. Indeed, tourists tend to eat less sustainable products and more meat while travelling."]
[]
[]
[null,null,"Optional","Optional"]
[null,null,"# of meals that contain… ; while travelling","# of meals that contain… ; while at home (over the same period of time)","Environmental score (5=Worst)"]
[null,"Beef",null,null,5]
[null,"Cheese",null,null,4]
[null,"Fish",null,null,4]
[null,"Poultry",null,null,3]
[null,"Legumes (lentils, chickpeas…)",null,null,2]
[null,"Eggs",null,null,2]
[null,"Sweets",null,null,1]
[null,"Cereals",null,null,1]
[null,"Yogurt",null,null,1]
[null,"Pasta",null,null,1]
[null,"Rice",null,null,1]
[null,"Bread",null,null,1]
[null,"Milk and dairy",null,null,1]
[null,"Fruits and veggies",null,null,0]
[]
[null,"Environmental score; Weighted average (5=worst)",{"$f":"IFERROR(SUMPRODUCT(C56:C69,$E$56:$E$69)/SUM(C56:C69),\"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(D56:D69,$E$56:$E$69)/SUM(D56:D69),\"NA\")","v":"NA"}]
[]
[]
[null,"Socio-economic impact: What is your spend profile?",null,null,null,null,null,"Back to top"]
[]
[null,"# of days",{"$f":"F9","v":0},null,null,null,"Please enter in the below pagele what you spent on food, beverages, souvenirs, toilettries and other tangible items over the specified period of time. Add as many lines as necessary. "]
[null,"# of travellers",{"$f":"F10","v":0}]
[null,"What is the socio-economic impact of your choices of accomodation? As a proxy we suggest analysing your spend profile. Did you give more to small businesses or large ones? Was your money spent in the local economy or on international brands? Was your money spent in an organization that seeks to have a \"positive impact\"?"]
[]
[]
[]
[null,"Instructions: Check the results below after filling the light orange cells on the right. ",null,null,null,null,"Enter all what you spent on shopping, food & bev over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,null,"Total USD","USD per person per day","%",null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent ($)"]
[null,"Small ",{"$f":"SUMIF($E$100:$E$503,$B84,$H$100:$H$503)","v":0},{"$f":"IFERROR(C84/$C$76/$C$77,\"NA\")","v":"NA"},{"$f":"IFERROR(C84/SUM($C$84:$C$88),\"NA\")","v":"NA"},null,{"$f":"$F$11","v":"(Please select)"},"Resto","Food & Bev","Medium","Local","N",300]
[null,"Medium",{"$f":"SUMIF($E$100:$E$503,$B85,$H$100:$H$503)","v":0},{"$f":"IFERROR(C85/$C$76/$C$77,\"NA\")","v":"NA"},{"$f":"IFERROR(C85/SUM($C$84:$C$88),\"NA\")","v":"NA"},null,{"$f":"$F$11","v":"(Please select)"},"Restos Hilton","Food & Bev","Large","Local","N",500]
[null,"Large",{"$f":"SUMIF($E$100:$E$503,$B86,$H$100:$H$503)","v":0},"NA","NA",null,"(Please select)","Souvenirs","Shopping","Small ","Local","N",150]
[null,"Public services",{"$f":"SUMIF($E$100:$E$503,$B87,$H$100:$H$503)","v":0},"NA","NA",null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,"Religious institutions",{"$f":"SUMIF($E$100:$E$503,$B88,$H$100:$H$503)","v":0},"NA","NA",null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,"Local",{"$f":"SUMIF($F$100:$F$503,$B90,$H$100:$H$503)","v":0},{"$f":"IFERROR(C90/$C$76/$C$77,\"NA\")","v":"NA"},{"$f":"IFERROR(C90/SUM($C$90:$C$91),\"NA\")","v":"NA"},null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,"International",{"$f":"SUMIF($F$100:$F$503,$B91,$H$100:$H$503)","v":0},{"$f":"IFERROR(C91/$C$76/$C$77,\"NA\")","v":"NA"},{"$f":"IFERROR(C91/SUM($C$90:$C$91),\"NA\")","v":"NA"},null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,"Positive impact",{"$f":"SUMIF($G$100:$G$503,\"Y\",$H$100:$H$503)","v":0},{"$f":"IFERROR(C93/$C$76/$C$77,\"NA\")","v":"NA"},{"$f":"IFERROR(C93/SUM(M:M),\"NA\")","v":0},null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,"Conventional",{"$f":"C95-C93","v":0},null,null,null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[null,"Total",{"$f":"SUM(C84:C88)","v":0},{"$f":"IFERROR(C95/$C$76/$C$77,\"NA\")","v":"NA"},null,null,"(Please select)",null,"(Please select)","Small ","Local","N"]
[]
[]
[null,"Enter all what you spent on shopping, food & bev over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent ($)"]
[null,{"$f":"$F$11","v":"(Please select)"},null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"(Please select)","(Please select)","(Please select)","(Please select)"]

{"sheet":"Leisure","index":5,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,1,1,5],[0,7,1,9],[17,6,17,12],[9,1,11,8],[32,1,32,7]]}
[null,"Leisure: have fun with you money",null,null,null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[null,"Socio-economic impact: What is your spend profile?"]
[]
[null,"What is the socio-economic impact of your leisure? This is very hard to evaluate, but as a proxy we suggest analysing your spend profile. Did you give more to small businesses or large ones? Was your money spent in the local economy or on international brands? Was your money spent in an organization that seeks to have a \"positive impact\"?"]
[]
[]
[]
[null,"# of days",{"$f":"'Instructions & Basic Setup'!D28","v":0}]
[null,"# of travellers",{"$f":"'Instructions & Basic Setup'!D29","v":0}]
[null,"Country",{"$f":"'Instructions & Basic Setup'!D30","v":"(Please select)"}]
[]
[null,"Instructions: Check the results below after filling the light orange cells on the right. ",null,null,null,null,"Enter all what you spent on leisure over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,null,"Total USD","USD per person per day","%",null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent ($)"]
[null,"Small ",{"$f":"SUMIF($E$35:$E$500,$B20,$H$35:$H$500)","v":0},{"$f":"IFERROR(C20/$C$14/$C$15,\"NA\")","v":"NA"},{"$f":"IFERROR(D20/SUM($D$20:$D$24),\"NA\")","v":"NA"},null,{"$f":"$C$16","v":"(Please select)"},"prostitutes","Leisure","Medium","Local","N",500]
[null,"Medium",{"$f":"SUMIF($E$35:$E$500,$B21,$H$35:$H$500)","v":0},{"$f":"IFERROR(C21/$C$14/$C$15,\"NA\")","v":"NA"},{"$f":"IFERROR(D21/SUM($D$20:$D$24),\"NA\")","v":"NA"},null,{"$f":"$C$16","v":"(Please select)"},"surf","Leisure","Medium","Local","N",50]
[null,"Large",{"$f":"SUMIF($E$35:$E$500,$B22,$H$35:$H$500)","v":0},"NA","NA",null,"(Please select)","Safari","Leisure","Medium","Local","N",200]
[null,"Public services",{"$f":"SUMIF($E$35:$E$500,$B23,$H$35:$H$500)","v":0},"NA","NA",null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,"Religious institutions",{"$f":"SUMIF($E$35:$E$500,$B24,$H$35:$H$500)","v":0},"NA","NA",null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,"Local",{"$f":"SUMIF($F$35:$F$500,$B26,$H$35:$H$500)","v":0},{"$f":"IFERROR(C26/$C$14/$C$15,\"NA\")","v":"NA"},{"$f":"IFERROR(D26/SUM($D$26:$D$27),\"NA\")","v":"NA"},null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,"International",{"$f":"SUMIF($F$35:$F$500,$B27,$H$35:$H$500)","v":0},{"$f":"IFERROR(C27/$C$14/$C$15,\"NA\")","v":"NA"},{"$f":"IFERROR(D27/SUM($D$26:$D$27),\"NA\")","v":"NA"},null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,null,null,null,null,null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,"Positive impact",{"$f":"SUMIF($G$35:$G$500,\"Y\",$H$35:$H$500)","v":0},{"$f":"IFERROR(C29/$C$14/$C$15,\"NA\")","v":"NA"},{"$f":"IFERROR(D29/D31,\"NA\")","v":"NA"},null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,"Conventional",{"$f":"C31-C29","v":0},null,null,null,"(Please select)",null,"Leisure","Medium","Local","N"]
[null,"Total",{"$f":"SUM(C20:C24)","v":0},{"$f":"IFERROR(C31/$C$14/$C$15,\"NA\")","v":"NA"},null,null,"(Please select)",null,"Leisure","Medium","Local","N"]
[]
[null,"Enter all what you spent on leisure over the specified period of time, for all travellers. Add as many lines as necessary. "]
[null,"Country","Description","Classification","Business type","Local/ international","Positive impact?","Spent ($)"]
[null,{"$f":"$C$16","v":"(Please select)"},null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,{"$f":"$C$16","v":"(Please select)"},null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[null,"(Please select)",null,"Leisure","(Please select)","(Please select)","(Please select)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Environmental impact"]

{"sheet":"Volunteering","index":6,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,7,1,10],[0,1,1,5],[8,1,10,8],[18,1,18,8],[12,1,12,8],[13,1,13,5],[14,1,14,8],[16,1,16,8],[15,1,15,8]]}
[null,"Volunteering: how did you spend your time?",null,null,null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[]
[null,"In this section, we assess the positive impact of volunteering activities. We leave it to you to determine whether what you did can be classified as having a \"positive impact\". For exemple, in our case, we consider that a volunteering experience on an organic or permaculture farm could be classified as \"positive impact\". However, we do not include experiences such as helping in hostels with no environmental or social purpose."]
[]
[]
[]
[null,"It is hard to determine whether a particular volunteering experience really had a positive impact. We leave it to you to determine this, as you know better than anybody else! However, as a guidance, here are some of the criteria that we use to determine whether our own volunteering may have had a \"positive impact\":"]
[null,"The organisation has an environmental or social purpose."]
[null,"You performed tasks in which you were \"operational\" right away (e.g. distributing food) or stayed a longer time in the organisation (> one month)"]
[null,"If you worked directly with kids or people, you stayed at least 3 months."]
[null,"You did not perform a task that a local person could have done, for a salary."]
[]
[null,"In some organizations, volunteers are asked to pay. We consider this money to have \"positive impact\" but classify it under the categories \"Accomodation\" and \"Consumption & Waste\". For example, in Cambodia we paid 5 USD per day per person. We considered that 50% of the money was for food and the other for accomodation and therefore included them in the socio-economic impact on the relevant pages."]
[]
[null,"Your travel:"]
[null,"# of days",{"$f":"'Instructions & Basic Setup'!D28","v":0}]
[null,"# of travellers",{"$f":"'Instructions & Basic Setup'!D29","v":0}]
[null,"Country",{"$f":"'Instructions & Basic Setup'!D30","v":"(Please select)"}]
[null,"If you need to modify information on your travel, please do it here:"]
[]
[null,"Instructions: Fill in the light orange cells below."]
[null,"Name of the project","# of full-days volunteering per person"]
[]
[]
[]
[]
[null,"Total # of days",{"$f":"SUM(C29:C31)","v":0}]
[null,"% time volunteering",{"$f":"IFERROR(C33/C22,\"NA\")","v":"NA"}]

{"sheet":"Dashboard - Results","index":7,"n_rows":229,"n_cols":17,"rows_kept":229,"cut":false,"hidden":false,"merged":[[105,3,105,4],[105,5,105,6],[120,5,120,6],[174,3,174,4],[174,5,174,6],[122,5,122,6],[145,2,145,3],[147,2,147,3],[148,2,149,3],[148,4,149,4],[148,5,149,5],[142,1,143,7],[121,2,121,3],[121,5,121,6],[151,1,153,7],[163,1,165,7],[158,2,158,3],[169,5,170,7],[172,1,172,7],[157,2,157,3],[160,2,160,3],[184,2,184,3],[185,2,185,3],[186,2,186,3],[228,2,228,3],[187,2,187,3],[189,1,189,4],[218,2,218,3],[196,5,196,6],[200,5,200,6],[219,2,219,3],[220,2,220,3],[197,5,199,6],[202,5,202,6],[194,1,194,7],[191,5,192,7],[0,1,1,5],[98,1,98,6],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[14,1,14,4],[0,6,1,7],[226,2,226,3],[227,2,227,3],[224,2,224,3],[221,2,221,3],[222,2,222,3],[32,5,33,7],[86,1,86,5],[88,5,89,7],[103,1,103,7],[100,5,101,7],[64,1,69,1],[35,1,37,7],[49,6,59,7],[91,1,92,7],[40,1,45,1],[210,5,211,7],[213,1,215,7],[218,5,220,7],[221,5,222,7],[223,5,224,7],[223,2,223,3]]}
[null,"Summary results: Your dashboard",null,null,null,null,"Powered by Impact Wanderers"]
[]
[]
[]
[]
[]
[]
[]
[null,"On this page, you can see a summary of all the main results in each impact category. "]
[null,"Just follow the footprints to go to the relevant section to get the details."]
[null,"No need to fill anything on this page - just check out the results!"]
[]
[null,{"$f":"CONCATENATE(\"Overall results for your travel in\",\" \", 'Instructions & Basic Setup'!D30)","v":"Overall results for your travel in (Please select)"}]
[]
[null,"Your overall scores: 5 = worst, 0 = best",null,null,null,"Your performance while travelling","Compared with home (where available)",null,null,null,"While travelling","While at home"]
[null,"Socio-economic impact: Spend profile",null,null,null,{"$f":"IFERROR(IF(H16=0,5,IF(H16<0.2,4,IF(H16<0.4,3,IF(H16<0.6,2,IF(H16<0.8,1,0))))),\"NA\")","v":"NA"},"NA",{"$f":"0.33*D47+0.33*J46+0.33*K46","v":{"$error":"#VALUE!"}},null,"Spend",{"$f":"F16","v":"NA"},{"$f":"G16","v":"NA"},4.5,3.5,2.5,1.5,0.5]
[null,"Socio-economic impact: Volunteering",null,null,null,{"$f":"IF(D97=0,5,IF(D97<0.2,4,IF(D97<0.4,3,IF(D97<0.6,2,IF(D97<0.8,1,IF(D97<1,0,IF(D97=1,0,\"NA\")))))))","v":"NA"},"NA",null,null,"Volunteering",{"$f":"F17","v":"NA"},"NA",4.5,3.5,2.5,1.5,0.5]
[null,"Environmental impact: Greenhouse gases from transport",null,null,null,{"$f":"IFERROR(IF(H18>1,5,IF(AND(H18=0,D120=0),\"NA\",IF(H18=0,0,IF(H18<0.5,1,IF(H18<0.7,2,IF(H18<0.8,3,IF(H18<1,4))))))),\"NA\")","v":"NA"},{"$f":"IFERROR(IF(I18>1,5,IF(AND(I18=0,F120=0),\"NA\",IF(I18=0,0,IF(I18<0.5,1,IF(I18<0.7,2,IF(I18<0.8,3,IF(I18<1,4))))))),\"NA\")","v":"NA"},{"$f":"E120/(3000/365)","v":{"$error":"#VALUE!"}},{"$f":"G120/(3000/365)","v":{"$error":"#VALUE!"}},"Transport","NA","NA",4.5,3.5,2.5,1.5,0.5]
[null,"Environmental impact: Plastic waste",null,null,null,{"$f":"IF(E188=0,0,IF(E188<20,1,IF(E188<40,2,IF(E188<60,3,IF(E188<80,4,IF(E188=\"NA\",\"NA\",5))))))","v":"NA"},{"$f":"IF(G188=0,\"NA\",IF(G188<19,0,IF(G188<20,1,IF(G188<40,2,IF(G188<60,3,IF(G188<80,4,IF(G188=\"NA\",\"NA\",5)))))))","v":"NA"},{"$f":"IFERROR(IF($E$187>0.5,$E$185/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29*100/(1*10*100/50/1000),$E$185/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29*100/(1*10*100/50/1000)*($E$187*2)),\"NA\")","v":"NA"},{"$f":"IFERROR(IF($G$187>0.5,$G$185/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29*100/(2*10*100/50/1000),$G$185/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29*100/(2*10*100/50/1000)*($G$187*2)),\"NA\")","v":"NA"},"Plastic ","NA","NA",4.5,3.5,2.5,1.5,0.5]
[null,"Environmental impact: Food choices",null,null,null,{"$f":"IF(H20=0,5,IF(H20<0.2,4,IF(H20<0.4,3,IF(H20<0.6,2,IF(H20<0.8,1,IF(H20=\"Fill in\",\"NA\",0))))))","v":"NA"},{"$f":"IF(I20=0,5,IF(I20<0.2,4,IF(I20<0.4,3,IF(I20<0.6,2,IF(I20<0.8,1,IF(I20=\"Fill in\",\"NA\",0))))))","v":"NA"},{"$f":"IF(D203=\"NA\",IF($D$198>$D$200,$D$198,$D$200),D203)","v":"Fill in"},{"$f":"IF(E203=\"NA\",IF($E$198>$E$200,$E$198,$E$200),E203)","v":"Fill in"},"Food ","NA","NA",4.5,3.5,2.5,1.5,0.5]
[null,"Environmental impact: Accommodation choices",null,null,null,{"$f":"IFERROR(ROUND(E229,0),\"NA\")","v":"NA"},"NA",null,null,"Accommodation","NA","NA",4.5,3.5,2.5,1.5,0.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Socio-economic impact: Spend profile",null,null,null,null,null,"Back to top"]
[]
[null,{"$f":"F15","v":"Your performance while travelling"},null,{"$f":"F16","v":"NA"},null,{"$f":"IF(D33=5,\"A score of 5 means that you spent between 0% of your money in small, local or positive impact organisations.\", IF(D33=4,\"A score of 4 means that you spent less than 20% of your money in small, local or positive impact organisations.\",IF(D33=3,\"A score of 3 means that you spent between 20 and 40% of your money in small, local or positive impact organisations.\",IF(D33=2,\"A score of 2 means that you spent between 40 and 60% of your money in small, local or positive impact organisations.\",IF(D33=1,\"A score of 1 means that you spent between 60 and 80% of your money in small, local or positive impact organisations.\",\"A score of 0 means that you spent over 80% of your money in small, local or positive impact organisations.\")))))","v":"A score of 0 means that you spent over 80% of your money in small, local or positive impact organisations."}]
[null,"Compared with home",null,{"$f":"G16","v":"NA"}]
[]
[null,"What is the socio-economic impact of your money? As an (imperfect) proxy we suggest analysing your spend profile. Did you give more to small businesses or large ones? Was your money spent in the local economy or on international brands? Was your money spent in an organization that seeks to have a \"positive impact\" (social and/or environmental)?"]
[]
[]
[]
[null,null,null,"Small ","Medium","Large","Public services","Religious Institutions","Total","% positive impact","% local"]
[null,"USD per day per person","Accommodation",{"$f":"IFERROR(SUMIF(Accommodation!$E$59:$E$497,D$40,Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Accommodation!$E$59:$E$497,E$40,Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Accommodation!$E$59:$E$497,F$40,Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Accommodation!$E$59:$E$497,G$40,Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Accommodation!$E$59:$E$497,H$40,Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"SUM(D41:H41)","v":0},{"$f":"IFERROR(SUMIF(Accommodation!$G$59:$G$497,\"Y\",Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/$I41,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Accommodation!$F$59:$F$497,\"Local\",Accommodation!$H$59:$H$497)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/$I41,\"NA\")","v":"NA"}]
[null,null,"Food & Bev",{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,D$40,'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,E$40,'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,F$40,'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,G$40,'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,H$40,'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"SUM(D42:H42)","v":0},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$G$100:$G$1004,\"Y\",'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I42,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$F$100:$F$1004,\"Local\",'Consumption and waste'!$D$100:$D$1004,$C42)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I42,\"NA\")","v":"NA"}]
[null,null,"Shopping",{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,D$40,'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,E$40,'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,F$40,'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,G$40,'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$E$100:$E$1004,H$40,'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"SUM(D43:H43)","v":0},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$G$100:$G$1004,\"Y\",'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I43,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIFS('Consumption and waste'!$H$100:$H$1004,'Consumption and waste'!$F$100:$F$1004,\"Local\",'Consumption and waste'!$D$100:$D$1004,$C43)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I43,\"NA\")","v":"NA"}]
[null,null,"Leisure",{"$f":"IFERROR(SUMIF(Leisure!$E$35:$E$500,D$40,Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Leisure!$E$35:$E$500,E$40,Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Leisure!$E$35:$E$500,F$40,Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Leisure!$E$35:$E$500,G$40,Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Leisure!$E$35:$E$500,H$40,Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"SUM(D44:H44)","v":0},{"$f":"IFERROR(SUMIF(Leisure!$G$35:$G$500,\"Y\",Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I44,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Leisure!$F$35:$F$500,\"Local\",Leisure!$H$35:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I44,\"NA\")","v":"NA"}]
[null,null,"Transport",{"$f":"IFERROR(SUMIF(Transport!$E$188:$E$500,D$40,Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Transport!$E$188:$E$500,E$40,Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Transport!$E$188:$E$500,F$40,Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Transport!$E$188:$E$500,G$40,Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Transport!$E$188:$E$500,H$40,Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29,\"NA\")","v":"NA"},{"$f":"SUM(D45:H45)","v":0},{"$f":"IFERROR(SUMIF(Transport!$G$188:$G$500,\"Y\",Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I45,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMIF(Transport!$F$188:$F$500,\"Local\",Transport!$H$188:$H$500)/'Instructions & Basic Setup'!$D$28/'Instructions & Basic Setup'!$D$29/I45,\"NA\")","v":"NA"}]
[null,null,"Total",{"$f":"SUM(D41:D45)","v":0},0,0,0,0,{"$f":"SUM(I41:I45)","v":0},{"$f":"IFERROR(SUMPRODUCT(J41:J45,$I$41:$I$45)/$I$46,\"NA\")","v":"NA"},{"$f":"IFERROR(SUMPRODUCT(K41:K45,$I$41:$I$45)/$I$46,\"NA\")","v":"NA"}]
[null,null,"%",{"$f":"IFERROR(D46/$I$46,\"NA\")","v":"NA"},{"$f":"IFERROR(E46/$I$46,\"NA\")","v":"NA"},"NA","NA","NA","NA"]
[]
[]
[null,null,null,null,null,null,"We define \"small businesses\" organisations that tend to be family-run (guest houses, cheap eateries). Medium businesses are by definition larger, potentially franchised, and may employ external staff. Large businesses include chains and large brands."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"% positive impact","% local"]
[null,"Percentage spent","Accommodation",{"$f":"J41","v":"NA"},{"$f":"K41","v":"NA"}]
[null,null,"Food & Bev",{"$f":"J42","v":"NA"},"NA"]
[null,null,"Shopping",{"$f":"J43","v":"NA"},"NA"]
[null,null,"Leisure",{"$f":"J44","v":"NA"},"NA"]
[null,null,"Transport",{"$f":"J45","v":"NA"},"NA"]
[null,null,"Total",{"$f":"J46","v":"NA"},"NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Socio-economic impact: Volunteering activities",null,null,null,null,null,"Back to top"]
[]
[null,{"$f":"B33","v":"Your performance while travelling"},null,{"$f":"F17","v":"NA"},null,{"$f":"IF(D89=5,\"A score of 5 means that you spent none of your time volunteering in positive impact projects.\",IF(D89=4,\"A score of 4 means that you spent less than 20% of your time volunteering in positive impact projects.\",IF(D89=3,\"A score of 3 means that you spent between 20 and 40% of your time volunteering in positive impact projects.\",IF(D89=2,\"A score of 2 means that you spent between 40 and 60% of your time volunteering in positive impact projects.\",IF(D89=1,\"A score of 1 means that you spent between 60 and 80% of your time volunteering in positive impact projects.\",\"A score of 0 means that you spent more than 80% of your time volunteering in positive impact projects.\")))))","v":"A score of 0 means that you spent more than 80% of your time volunteering in positive impact projects."}]
[null,{"$f":"B34","v":"Compared with home"},null,{"$f":"G17","v":"NA"}]
[]
[null,"Travellers can benefit countries they visit by spending money in the right place and giving in-kind through volunteering e.g. (although it depends on what type of volunteering, see the volunteering page for more information as to how to determine whether your volunteering experience may have had a real positive impact on the host organisation and its beneficiaries). "]
[]
[]
[null,null,null,"Indicator"]
[null,null,"Total days spent",{"$f":"Volunteering!C33","v":0}]
[null,null,"% time",{"$f":"Volunteering!C34","v":"NA"}]
[]
[null,"3. Environmental impact: Greenhouse gases (GHG) from transport",null,null,null,null,null,"Back to top"]
[]
[null,{"$f":"B89","v":"Your performance while travelling"},null,{"$f":"F18","v":"NA"},null,{"$f":"IF(D101=5,\"A score of 5 means that you exceeded your daily carbon budget on transport.\", IF(D101=4,\"A score of 4 means that you used over 80% of your daily carbon budget on transport.\",IF(D101=3,\"A score of 3 means that you used between 70 and 80% of your daily carbon budget on transport.\",IF(D101=2,\"A score of 2 means that you used between 50 and 70% of your daily carbon budget on transport.\",IF(D101=1,\"A score of 1 means that you used less than 50% of your daily carbon budget on transport.\", \"A score of 0 means that you did not use any of your daily carbon budget on transport.\")))))","v":"A score of 0 means that you did not use any of your daily carbon budget on transport."}]
[null,{"$f":"B90","v":"Compared with home"},null,{"$f":"G18","v":"NA"}]
[]
[null,"Transport can contribute a substantial part of the total GHG emissions of travelling, especially taking the plane, leading to climate change."]
[]
[null,null,null,{"$f":"CONCATENATE(\"While travelling in\",\" \",'Instructions & Basic Setup'!$D$30)","v":"While travelling in (Please select)"},null,{"$f":"CONCATENATE(\"While at home in\",\" \",'Instructions & Basic Setup'!$D$31)","v":"While at home in (Please select)"}]
[null,null,null,"Km per day per person","GHG Emissions per day per person (kg)","Km per day per person","GHG Emissions per day per person (kg)"]
[null,null,"Plane",{"$f":"Transport!H31","v":"NA"},{"$f":"Transport!$I31","v":"NA"},{"$f":"Transport!H127","v":"NA"},{"$f":"Transport!I127","v":"NA"}]
[null,null,"Private car/ cab",{"$f":"Transport!H32","v":"NA"},{"$f":"Transport!$I32","v":"NA"},{"$f":"Transport!H128","v":"NA"},{"$f":"Transport!I128","v":"NA"}]
[null,null,"Motorbike",{"$f":"Transport!H33","v":"NA"},{"$f":"Transport!$I33","v":"NA"},{"$f":"Transport!H129","v":"NA"},{"$f":"Transport!I129","v":"NA"}]
[null,null,"Scooter",{"$f":"Transport!H34","v":"NA"},{"$f":"Transport!$I34","v":"NA"},{"$f":"Transport!H130","v":"NA"},{"$f":"Transport!I130","v":"NA"}]
[null,null,"Tuk tuk",{"$f":"Transport!H35","v":"NA"},{"$f":"Transport!$I35","v":"NA"},{"$f":"Transport!H131","v":"NA"},{"$f":"Transport!I131","v":"NA"}]
[null,null,"Boat",{"$f":"Transport!H36","v":"NA"},{"$f":"Transport!$I36","v":"NA"},{"$f":"Transport!H132","v":"NA"},{"$f":"Transport!I132","v":"NA"}]
[null,null,"Bus",{"$f":"Transport!H37","v":"NA"},{"$f":"Transport!$I37","v":"NA"},{"$f":"Transport!H133","v":"NA"},{"$f":"Transport!I133","v":"NA"}]
[null,null,"Train",{"$f":"Transport!H38","v":"NA"},{"$f":"Transport!$I38","v":"NA"},{"$f":"Transport!H134","v":"NA"},{"$f":"Transport!I134","v":"NA"}]
[null,null,"Metro/ tube",{"$f":"Transport!H39","v":"NA"},{"$f":"Transport!$I39","v":"NA"},{"$f":"Transport!H135","v":"NA"},{"$f":"Transport!I135","v":"NA"}]
[null,null,"Hitchhiking",{"$f":"Transport!H40","v":"NA"},{"$f":"Transport!$I40","v":"NA"},{"$f":"Transport!H136","v":"NA"},{"$f":"Transport!I136","v":"NA"}]
[null,null,"Bicycle",{"$f":"Transport!H41","v":"NA"},{"$f":"Transport!$I41","v":"NA"},{"$f":"Transport!H137","v":"NA"},{"$f":"Transport!I137","v":"NA"}]
[null,null,"Walking",{"$f":"Transport!H42","v":"NA"},{"$f":"Transport!$I42","v":"NA"},{"$f":"Transport!H138","v":"NA"},{"$f":"Transport!I138","v":"NA"}]
[null,null,"Total",{"$f":"SUM(D108:D119)","v":0},{"$f":"IF(AND(E108=\"NA\",E109=\"NA\",E110=\"NA\",E111=\"NA\",E112=\"NA\",E113=\"NA\",E114=\"NA\",E115=\"NA\",E116=\"NA\",E117=\"NA\",E118=\"NA\",E119=\"NA\"),\"NA\",SUM(E108:E119))","v":"NA"},{"$f":"IF(AND(F108=\"NA\",F109=\"NA\",F110=\"NA\",F111=\"NA\",F112=\"NA\",F113=\"NA\",F114=\"NA\",F115=\"NA\",F116=\"NA\",F117=\"NA\",F118=\"NA\",F119=\"NA\"),\"NA\",SUM(F108:F119))","v":"NA"},{"$f":"IF(AND(G108=\"NA\",G109=\"NA\",G110=\"NA\",G111=\"NA\",G112=\"NA\",G113=\"NA\",G114=\"NA\",G115=\"NA\",G116=\"NA\",G117=\"NA\",G118=\"NA\",G119=\"NA\"),\"NA\",SUM(G108:G119))","v":"NA"}]
[null,null,"% of your yearly \"carbon budget\" used",null,{"$f":"IFERROR(E120*'Instructions & Basic Setup'!$D$28/3000,\"NA\")","v":"NA"},{"$f":"IFERROR(G120*365/3000,\"NA\")","v":"NA"}]
[null,null,"% of your daily \"carbon budget\" used",null,{"$f":"IFERROR(E120/(3000/365),\"NA\")","v":"NA"},{"$f":"IFERROR(G120/(3000/365),\"NA\")","v":"NA"}]
[null,null,"Certainty index (3 = best)",null,{"$f":"Transport!J45","v":0},{"$f":"Transport!J140","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"What quantity of carbon emissions did you avoid because you took some public and carbon-free transport locally? We help you calculate the carbon emissions you avoided by choosing these means of transportation."]
[]
[]
[null,null,"You avoided this amount of carbon emissions…",null,"Kg of greenhouse gases per traveller","% of actual carbon footprint"]
[null,null,null,null,"1 traveller "]
[null,null,"Because you took carbon-free transport (hitchkiking, cycling, walking), you saved:",null,{"$f":"Transport!D76","v":"NA"},{"$f":"Transport!E76","v":"NA"}]
[null,null,"Because you took public transport & carbon-free over private car, you saved:",null,{"$f":"Transport!D77","v":0},{"$f":"Transport!E77","v":"NA"}]
[]
[]
[null,"What your carbon emissions would be if you had chosen another transportation means: what if you had taken only private transports locally, for example cars, cabs or motorcycles? On the other hand, what if you had taken only carbon-free transport (hitchiking, cycling, walking) all the time? We exclude air travels from these results."]
[]
[]
[]
[null,null,"What if you had used only…",null,"kg of greenhouse gases per traveller you would have saved (-) or emitted additional  (+)  if…","% of actual carbon footprint"]
[null,null,null,null,"1 traveller"]
[null,null,"Your actual carbon footprint in kg per person over the full period of time",null,{"$f":"J95*D46","v":0}]
[null,null,"…Private transport (car)",null,{"$f":"Transport!D88","v":0},{"$f":"Transport!E88","v":"NA"}]
[null,null,"…Private transport (motorcycle/ scooter) ",null,{"$f":"Transport!D89","v":0},{"$f":"Transport!E89","v":"NA"}]
[null,null,"…Buses",null,{"$f":"Transport!D90","v":0},{"$f":"Transport!E90","v":"NA"}]
[null,null,"…Carbon-free transport in the country itself",null,{"$f":"Transport!D91","v":0},{"$f":"Transport!E91","v":"NA"}]
[]
[null,"Red means that you would have emitted more using this option. Green means you would have saved/ avoided the emission of greenhouse gases. Orange means that the difference is too small to say, as the calculations bear a level of uncertainty."]
[]
[]
[]
[null,"4. Environmental impact: Plastic waste",null,null,null,null,null,"Back to top"]
[]
[null,{"$f":"B101","v":"Your performance while travelling"},null,{"$f":"F19","v":"NA"},null,"The higher the score, the more plastic you used in countries with poor waste management."]
[null,{"$f":"B102","v":"Compared with home"},null,{"$f":"G19","v":"NA"}]
[]
[null,"In certain countries (in Asia for example), a traveller may generate much more plastic waste than at home, because of the straws, plastic bottles etc. Minimizing one's plastic footprint (and more broadly waste) is particularly important as many countries do not have a proper waste collection and management system in place. We therefore include an index to evaluate this aspect."]
[]
[null,null,null,{"$f":"CONCATENATE(\"While travelling in\",\" \",'Instructions & Basic Setup'!$D$30)","v":"While travelling in (Please select)"},null,{"$f":"CONCATENATE(\"While at home in\",\" \",'Instructions & Basic Setup'!$D$31)","v":"While at home in (Please select)"}]
[null,null,null,"# bought/ consumed","Estimated weight (kg)","# bought/ consumed","Estimated weight (kg)"]
[null,null,"# of plastic cups",{"$f":"'Consumption and waste'!C26","v":0},{"$f":"'Consumption and waste'!D26","v":0},{"$f":"'Consumption and waste'!E26","v":"NA"},{"$f":"'Consumption and waste'!F26","v":"NA"}]
[null,null,"# of plastic bags",{"$f":"'Consumption and waste'!C27","v":0},{"$f":"'Consumption and waste'!D27","v":0},{"$f":"'Consumption and waste'!E27","v":"NA"},{"$f":"'Consumption and waste'!F27","v":"NA"}]
[null,null,"# of plastic bottles (33 cl)",{"$f":"'Consumption and waste'!C29","v":0},{"$f":"'Consumption and waste'!D29","v":0},{"$f":"'Consumption and waste'!E28","v":"NA"},{"$f":"'Consumption and waste'!F28","v":"NA"}]
[null,null,"# of plastic bottles (1L)",{"$f":"'Consumption and waste'!C30","v":0},{"$f":"'Consumption and waste'!D30","v":0},{"$f":"'Consumption and waste'!E29","v":"NA"},{"$f":"'Consumption and waste'!F29","v":"NA"}]
[null,null,"# of plastic bottles (1.5l)",{"$f":"'Consumption and waste'!C31","v":0},{"$f":"'Consumption and waste'!D31","v":0},{"$f":"'Consumption and waste'!E30","v":"NA"},{"$f":"'Consumption and waste'!F30","v":"NA"}]
[null,null,"# of plastic bottles (5l)",{"$f":"'Consumption and waste'!C32","v":0},{"$f":"'Consumption and waste'!D32","v":0},{"$f":"'Consumption and waste'!E31","v":"NA"},{"$f":"'Consumption and waste'!F31","v":"NA"}]
[null,null,"# of refills (in litres)",{"$f":"'Consumption and waste'!C33","v":0},{"$f":"'Consumption and waste'!D33","v":0},{"$f":"'Consumption and waste'!E32","v":"NA"},{"$f":"'Consumption and waste'!F32","v":"NA"}]
[]
[null,null,"Total plastic use and waste (kg, over full period)",null,{"$f":"'Consumption and waste'!D36","v":0},null,{"$f":"'Consumption and waste'!F36","v":0}]
[null,null,"Plastic waste avoided (kg, total over full period)",null,{"$f":"'Consumption and waste'!D37","v":0},null,{"$f":"'Consumption and waste'!F37","v":"NA"}]
[null,null,"Country waste mngt index (0=best; 100=worst)",null,{"$f":"IFERROR(1-VLOOKUP('Instructions & Basic Setup'!$D$30,sources!$A$203:$I$392,9,FALSE),\"NA\")","v":"NA"},null,{"$f":"IFERROR(1-VLOOKUP('Instructions & Basic Setup'!$D$31,sources!$A$203:$I$392,9,FALSE),\"NA\")","v":"NA"}]
[null,null,"Composite index of plastic use and country mngt ",null,{"$f":"IF(H19=\"NA\",\"NA\",IF(H19>100,100,H19))","v":"NA"},null,{"$f":"IF(I19=\"NA\",\"NA\",IF(H19>100,100,I19))","v":"NA"}]
[]
[null,"5. Environmental impact: Food choices",null,null,null,null,null,"Back to top"]
[]
[null,{"$f":"B170","v":"Your performance while travelling"},null,{"$f":"F20","v":"NA"},null,{"$f":"IF(D192=5,\"A score of 5 means that none of your meals were either vegetarian or organic.\",IF(D192=4,\"A score of 4 means that less than 20% of your meals were either vegetarian or organic.\",IF(D192=3,\"A score of 3 means that between 20 and 40% of your meals were either vegetarian or organic\",IF(D192=2,\"A score of 2 means that between 40 and 60% of your meals were either vegetarian or organic.\",IF(D192=1,\"A score of 1 means that between 60 and 80% of your meals were either vegetarian or organic.\",\"A score of 0 means that over 80% of your meals were either vegetarian or organic.\")))))","v":"A score of 0 means that over 80% of your meals were either vegetarian or organic."}]
[null,{"$f":"B171","v":"Compared with home"},null,{"$f":"G20","v":"NA"}]
[]
[null,"Your food choices may have a substantial environmental impact, whether it is on carbon emissions, water use or biodiversity losses. It is difficult to calculate precisely in kg of carbon or cubic meters of water the environmental impact of your food - therefore we focus on practices (did you eat mostly vegetarian meals?) as a proxy."]
[]
[null,null,null,"% of meals; while travelling","% of meals; while at home ","Rationale"]
[null,null,"% of meals vegetarian",{"$f":"'Consumption and waste'!C46","v":"Fill in"},{"$f":"'Consumption and waste'!D46","v":"Fill in"},"Vegetarian & organic meals tend to have a lower environmental footprint than meat-based and non-organic food."]
[null,null,"% of meals non-vegetarian",{"$f":"'Consumption and waste'!C47","v":"Fill in"},{"$f":"'Consumption and waste'!D47","v":"Fill in"}]
[null,null,"% of meals organic",{"$f":"'Consumption and waste'!C48","v":"Fill in"},{"$f":"'Consumption and waste'!D48","v":"Fill in"}]
[null,null,"% of meals non-organic",{"$f":"'Consumption and waste'!C49","v":"Fill in"},{"$f":"'Consumption and waste'!D49","v":"Fill in"}]
[]
[null,null,"Refined environmental score based on meal composition",{"$f":"'Consumption and waste'!C71","v":"NA"},{"$f":"'Consumption and waste'!D71","v":"NA"},"Optional calculations taking into account the exact meal composition (meat, grain, dairy, vegetables etc)"]
[]
[]
[]
[]
[]
[null,"6. Environmental impact: Accommodation choices",null,null,null,null,null,"Back to top"]
[]
[null,{"$f":"B192","v":"Your performance while travelling"},null,{"$f":"F21","v":"NA"},null,"The higher the score, the more nights in energy and water-intensive accomodations, in countries with high carbon intensity of energy."]
[null,{"$f":"B193","v":"Compared with home"},null,{"$f":"G21","v":"NA"}]
[]
[null,"We identify \"special situations\" (either in the positive or negative) and assess them by assigning them a high-level bonus/malus score. For example, we stayed in a few places where electricity was 100% renewable, thereby saving carbon emissions. We assign a bonus of 4 out of 5. In addition, we need to take into account the context: saving energy is far more important from an climate change perspective in a country where the energy mix is very carbon-intensive. We include an index to shed light on this, with 100 the worst situation and 0 the worst."]
[]
[]
[]
[null,null,"# of nights spent…:",null,null,"Rationale",null,null,"Bonus/malus"]
[null,null,"… camping/ no electricity",null,{"$f":"Accommodation!D24","v":"NA"},"… thereby not emitting greenhouse gases linked to energy use.",null,null,1]
[null,null,"… couchsurfing",null,{"$f":"Accommodation!D25","v":"NA"},null,null,null,2]
[null,null,"… in places running on 80+% renewable energy",null,{"$f":"Accommodation!D26","v":"NA"},null,null,null,2]
[null,null,"… dorms",null,{"$f":"Accommodation!D27","v":"NA"},"Dorms and homestays tend to use less energy than hotels, given that you share the common areas/ rooms with more people.",null,null,3]
[null,null,"… homestays ",null,{"$f":"Accommodation!D28","v":"NA"},null,null,null,3]
[null,null,"… mid-range hotels",null,{"$f":"Accommodation!D29","v":"NA"},"These hotels tend to use more energy and water per client (more space, lights, swimming pool, towels…)",null,null,4]
[null,null,"… high-end hotels ",null,{"$f":"Accommodation!D30","v":"NA"},null,null,null,5]
[]
[null,null,"Bonus/malus (5=worst; 1=best)",null,{"$f":"Accommodation!D32","v":"NA"},"Weighted average"]
[null,null,"Country GHGs index (0=best; 100=worst)",null,{"$f":"Accommodation!D33","v":"NA"},"Saving energy is even more important in countries with a high GHG intensity of electricity."]
[null,null,"Overall score (5=worst; 1=best)",null,{"$f":"IFERROR(E227*IF((E228*2)>100,100,E228*2)/100,\"NA\")","v":"NA"},"Takes into account both the bonus/malus average and the country GHGs index"]

{"sheet":"backoffice","index":8,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
["red",165,115,156,198,165]
["green",150,81,97,113,28]
["blue",181,115,132,148,74]
[]
["(Please select)",null,"(Please select)",null,"(Please select)",null,"(Please select)",null,null,"(Please select)","(Please select)"]
["Small ",null,"Food & Bev",null,"Leisure",null,"Diesel (average biofuel blend)",null,null,"Local","Y"]
["Medium",null,"Shopping",null,"Culture",null,"Diesel (100% mineral diesel)",null,null,"International","N"]
["Large",null,null,null,null,null,"Petrol (average biofuel blend)"]
["Public services",null,null,null,null,null,"Petrol (100% mineral petrol)"]
["Religious institutions",null,null,null,null,null,"CNG"]
[null,null,null,null,null,null,"LNG"]
[null,null,null,null,null,null,"LPG"]
[null,null,null,null,null,null,"Other petroleum gas"]
[null,null,null,null,null,null,"Fuel oil"]
[null,null,null,null,null,null,"Gas oil"]
[null,null,null,null,null,null,"Marine gas oil"]
[null,null,null,null,null,null,"Marine fuel oil"]

{"sheet":"sources","index":9,"n_rows":392,"n_cols":11,"rows_kept":392,"cut":false,"hidden":true,"merged":[[27,0,30,0]]}
[]
[]
["Emission factors"]
[]
[]
["Plane",0.19,"Defra, international, economy class (incl. Production and combustion of fuel)"]
["Private car/ cab",{"$f":"0.17+0.04","v":0.21000000000000002},"Defra, average car (incl. Production and combustion of fuel)"]
["Camping car",0.41,"14L au 100","a contresens"]
["Motorbike",{"$f":"0.11+0.03","v":0.14000000000000001},"Defra, average motorbike (incl. Production and combustion of fuel)"]
["Scooter",{"$f":"0.08+0.02","v":0.1},"Defra, small motorbike (incl. Production and combustion of fuel)"]
["Tuk tuk",{"$f":"(2.3+0.6)/25/2","v":5.7999999999999996E-2},"Defra + testimony"]
["Boat",0.05,null,"blue economy"]
["Bus",3.4000000000000002E-2,null,null,null,"bus lower than train?"]
["Train",0.06,"https://www.co2nnect.org/help_sheets/?op_id=602&opt_id=98"]
["Hitchhiking",0]
["Bicycle",0]
["Walking",0]
["Metro/ tube",{"$f":"B21*C135","v":4.9749296200563044E-3}]
[]
["Bottle 1.5L","43g","Hellopro"]
["Electricity tube per passenger.km",0.13,"Defra","kwh"]
[]
["Activity","Fuel","Unit","kg CO2e","kg CO2","kg CH4","kg N2O"]
[null,"Diesel (average biofuel blend)","litres",2.6001627112482195,2.5784260580568197,5.1681028354095204E-4,2.1219842907858805E-2]
[null,"Diesel (100% mineral diesel)","litres",2.6719320747436055,2.6501954215522057,5.1681028354095204E-4,2.1219842907858805E-2]
[null,"Petrol (average biofuel blend)","litres",2.1983536074047074,2.1875970494793395,7.0381261827501228E-3,3.7184317426179358E-3]
[null,"Petrol (100% mineral petrol)","litres",2.3007492533234681,2.2899926953981002,7.0381261827501228E-3,3.7184317426179358E-3]
[null,"CNG","litres",0.49245136401268447,0.4914996670080708,6.9351726788913865E-4,2.5817973672455651E-4]
[null,"LNG","litres",1.2733066942797273,1.2708459392581017,1.7931926771535584E-3,6.675623444720272E-4]
[null,"LPG","litres",1.508071357441644,1.5058341114013103,1.0882549760583874E-3,1.1489910642751722E-3]
[null,"Other petroleum gas","litres",0.96100504339705861,0.96008992316072583,4.174818596408864E-4,4.9763837669193655E-4]
[null,"Fuel oil","litres",3.1697636703769181,3.1586564749261679,3.9449155846091955E-3,7.1622798661408818E-3]
[null,"Gas oil","litres",2.9535052630192773,2.7148936170212767,3.0255744961331563E-3,0.23558607150186758]
[null,"Marine gas oil","litres",2.7362468085106384,2.7148936170212767,1.0638297872340426E-3,2.028936170212766E-2]
[null,"Marine fuel oil","litres",3.1906581532416509,3.166011787819254,1.2278978388998037E-3,2.3418467583497055E-2]
[]
["(Please select)",2015,"C02 per fuel consumption (t per tj to kg per kwh)","Rank"]
["Albania",41.706299999999999,{"$f":"B38*1000/277778","v":0.15014255988595207},{"$f":"RANK(C38,$C$38:$C$183,1)","v":51},{"$f":"C38*100/0.3","v":50.04751996198403}]
["Algeria",57.645600000000002,0.20752399398080482,101,69.174664660268277]
["Angola",32.617699999999999,0.11742362606109916,33,39.141208687033057]
["Argentina",53.18,0.19144784684172253,83,63.815948947240848]
["Armenia",36.574800000000003,0.13166917466466027,41,43.889724888220087]
["Australia",72.610299999999995,0.26139687088250324,140,87.132290294167746]
["Austria",45.259900000000002,0.16293550965159229,59,54.311836550530757]
["Azerbaijan",51.240200000000002,0.18446457242834208,76,61.48819080944736]
["Bahrain",50.319899999999997,0.1811514950788039,72,60.383831692934635]
["Bangladesh",44.4482,0.16001339198928641,58,53.337797329762139]
["Belarus",50.2851,0.18102621517902784,{"$f":"RANK(C38,C38:C183,0)","v":96},60.34207172634261]
["Belgium",41.456499999999998,0.14924328060537551,{"$f":"RANK(C39,C39:C184,0)","v":46},49.747760201791841]
["Benin",27.769100000000002,9.9968680025055989E-2,{"$f":"RANK(C40,C40:C185,0)","v":112},33.322893341685329]
["Bolivia",52.719299999999997,0.18978932816853744,{"$f":"RANK(C41,C41:C185,0)","v":63},63.263109389512479]
["Bosnia and Herzegovina",66.138800000000003,0.23809948952040838,{"$f":"RANK(C42,C42:C185,0)","v":103},79.36649650680279]
["Botswana",62.032200000000003,0.22331574134740695,{"$f":"RANK(C43,C43:C185,0)","v":7},74.438580449135657]
["Brazil",36.1327,0.13007761593790723,{"$f":"RANK(C44,C44:C185,0)","v":85},43.359205312635744]
["Brunei Darussalam",52.530700000000003,0.18911036871170506,{"$f":"RANK(C45,C45:C185,0)","v":68},63.036789570568352]
["Bulgaria",56.209000000000003,0.20235223811820952,{"$f":"RANK(C46,C46:C185,0)","v":71},67.450746039403171]
["Cambodia",27.183399999999999,9.7860161711870619E-2,{"$f":"RANK(C47,C47:C185,0)","v":83},32.620053903956872]
["Cameroon",18.432300000000001,6.6356226915018482E-2,{"$f":"RANK(C48,C48:C185,0)","v":71},22.118742305006162]
["Canada",48.551499999999997,0.17478526017179186,{"$f":"RANK(C49,C49:C185,0)","v":88},58.261753390597285]
["Chile",54.002600000000001,0.1944092044726364,{"$f":"RANK(C50,C50:C185,0)","v":111},64.803068157545468]
["Chinese Taipei",54.738599999999998,0.19705880235295811,{"$f":"RANK(C51,C51:C185,0)","v":62},65.686267450986037]
["Colombia",51.139200000000002,0.18410097271922185,{"$f":"RANK(C52,C52:C185,0)","v":19},61.366990906407288]
["Congo",24.301300000000001,8.7484610012312003E-2,{"$f":"RANK(C53,C53:C185,0)","v":28},29.161536670770669]
["Costa Rica",33.572699999999998,0.12086162331070134,{"$f":"RANK(C54,C54:C185,0)","v":94},40.287207770233785]
["Côte d'Ivoire",17.766200000000001,6.3958268833384929E-2,{"$f":"RANK(C55,C55:C185,0)","v":60},21.319422944461643]
["Croatia",44.110700000000001,0.15879839296128564,{"$f":"RANK(C56,C56:C185,0)","v":49},52.932797653761881]
["Cuba",59.1995,0.2131180295055764,{"$f":"RANK(C57,C57:C185,0)","v":105},71.039343168525477]
["Curaçao",56.498800000000003,0.20339551728358618,{"$f":"RANK(C58,C58:C185,0)","v":110},67.798505761195401]
["Cyprus",69.947400000000002,0.2518104385516492,{"$f":"RANK(C59,C59:C185,0)","v":70},83.936812850549728]
["Czech Republic",56.4148,{"$f":"B70*1000/277778","v":0.20309311752550599},{"$f":"RANK(C60,C60:C185,0)","v":56},{"$f":"C70*100/0.3","v":67.697705841835329}]
["Dem. Rep. of Congo",2.2606000000000002,8.1381534894772092E-3,{"$f":"RANK(C61,C61:C185,0)","v":53},2.7127178298257366]
["Denmark",47.449300000000001,0.17081734334612533,{"$f":"RANK(C62,C62:C185,0)","v":62},56.939114448708452]
["Dominican Republic",61.874400000000001,0.22274766180187056,103,74.249220600623516]
["DPR of Korea",68.694699999999997,0.24730072215942225,93,82.433574053140759]
["Ecuador",59.593899999999998,0.21453786836970531,107,71.512622789901783]
["Egypt",59.744100000000003,0.21507858793712967,76,71.692862645709894]
["El Salvador",35.746499999999997,0.12868729705016235,41,42.895765683387452]
["Eritrea",17.097799999999999,6.1552030758375391E-2,49,20.517343586125133]
["Estonia",68.400499999999994,0.2462416030067176,17,82.080534335572537]
["Ethiopia",4.8720999999999997,1.7539545968363223E-2,51,5.8465153227877416]
["Finland",30.933900000000001,0.11136195091043928,121,37.120650303479763]
["France",28.1462,0.10132623893900886,74,33.775412979669625]
["FYR of Macedonia",64.5595,0.23241401406878875,37,77.471338022929586]
["Gabon",15.276300000000001,5.4994636004291199E-2,23,18.331545334763735]
["Georgia",43.228499999999997,0.1556224755020196,44,51.874158500673204]
["Germany",56.629399999999997,0.20386567690745847,43,67.955225635819488]
["Ghana",34.603200000000001,0.12457142034286374,92,41.52380678095458]
["Gibraltar",66.164400000000001,0.23819164944668042,107,79.39721648222681]
["Greece",66.525800000000004,0.23949268840584928,25,79.830896135283098]
["Guatemala",28.481200000000001,0.10253223797420963,118,34.177412658069876]
["Haiti",17.936299999999999,6.4570628343497319E-2,96,21.523542781165773]
["Honduras",38.848799999999997,0.1398555681155455,101,46.618522705181839]
["Hong Kong, China",75.459100000000007,0.2716525426779659,35,90.55084755932198]
["Hungary",40.252200000000002,0.14490780407375675,108,48.302601357918917]
["Iceland",8.7858999999999998,3.1629214696628244E-2,{"$f":"RANK(C85,C85:C207,0)","v":80},10.543071565542748]
["India",57.9771,0.20871739302608558,52,69.572464342028525]
["Indonesia",46.834899999999998,0.16860550511559588,94,56.201835038531961]
["Iraq",65.9114,0.23728085017531983,33,79.093616725106614]
["Ireland",63.595999999999997,0.22894541684366654,32,76.315138947888855]
["Islamic Rep. of Iran",55.781500000000001,0.20081323934940851,97,66.937746449802844]
["Israel",64.748000000000005,0.23309261352590921,102,77.697537841969734]
["Italy",51.766199999999998,{"$f":"B102*1000/277778","v":0.18635817091346327},85,{"$f":"C102*100/0.3","v":62.119390304487752}]
["Jamaica",57.695,0.20770183383853294,23,69.233944612844311]
["Japan",63.441200000000002,0.22838813728949017,85,76.12937909649672]
["Jordan",65.853300000000004,0.23707169034264775,111,79.023896780882581]
["Kazakhstan",68.860699999999994,0.24789832168134265,52,82.632773893780879]
["Kenya",13.454499999999999,4.8436161251070996E-2,77,16.145387083690334]
["Korea",51.325800000000001,0.18477273218181425,36,61.590910727271428]
["Kosovo",81.824399999999997,0.2945676043459165,40,98.18920144863884]
["Kuwait",58.839799999999997,0.21182311054151154,59,70.60770351383718]
["Kyrgyzstan",59.290300000000002,0.21344490924407261,40,71.14830308135754]
["Latvia",38.347700000000003,0.13805160955871237,65,46.01720318623746]
["Lebanon",70.945700000000002,0.25540431567654742,54,85.134771892182485]
["Libya",62.739600000000003,0.22586237931009656,43,75.287459770032186]
["Lithuania",34.880299999999998,0.12556897954481636,42,41.856326514938786]
["Luxembourg",56.434899999999999,0.20316547746761804,39,67.721825822539344]
["Malaysia",61.313299999999998,0.22072770341783726,{"$f":"RANK(C107,C107:C228,0)","v":102},73.575901139279097]
["Malta",61.276400000000002,0.22059486352410917,67,73.531621174703062]
["Mauritius",65.289599999999993,0.23504237196610239,31,78.347457322034145]
["Mexico",56.383200000000002,0.20297935761651392,52,67.659785872171312]
["Mongolia",82.910899999999998,0.29847900121679899,52,99.493000405599673]
["Montenegro",55.817,0.20094103924716861,86,66.980346415722877]
["Morocco",67.652600000000007,0.24354916516066788,40,81.183055053555961]
["Mozambique",9.3094000000000001,3.351381318894945E-2,47,11.17127106298315]
["Myanmar",29.363700000000001,0.10570923543261165,90,35.23641181087055]
["Namibia",48.755699999999997,0.17552037958369632,56,58.506793194565439]
["Nepal",11.4358,4.1168847064922354E-2,49,13.722949021640785]
["Netherlands",50.465800000000002,0.18167673465861228,50,60.558911552870761]
["New Zealand",36.072699999999998,0.1298616161107071,48,43.287205370235704]
["Nicaragua",31.385200000000001,0.11298662961069632,56,37.662209870232104]
["Niger",16.0059,5.7621193903044876E-2,37,19.207064634348292]
["Nigeria",11.0428,3.9754048196761441E-2,57,13.25134939892048]
["Norway",29.614899999999999,0.10661355470915622,49,35.53785156971874]
["Oman",60.507300000000001,{"$f":"B134*1000/277778","v":0.21782610573911543},105,{"$f":"C134*100/0.3","v":72.608701913038487}]
["Other Africa",10.6302,3.8268689385048495E-2,92,12.756229795016166]
["Other Asia",43.302500000000002,0.15588887528889978,72,51.962958429633261]
["Other Non-OECD Americas",67.665899999999993,0.24359704512236388,101,81.199015040787955]
["Pakistan",37.141300000000001,0.1337085730331416,68,44.56952434438054]
["Panama",59.879899999999999,0.21556746754602596,86,71.855822515341984]
["Paraguay",25.055499999999999,9.0199727840217722E-2,88,30.066575946739245]
["People's Rep. of China",72.625600000000006,0.26145195083843936,96,87.150650279479791]
["Peru",47.6937,0.17169718264225386,98,57.232394214084628]
["Philippines",47.573099999999997,0.1712630229895816,90,57.087674329860533]
["Poland",71.052599999999998,0.25578915536867569,55,85.263051789558574]
["Portugal",51.1494,0.18413769268984587,100,61.379230896615297]
["Qatar",42.014299999999999,0.15125135899891279,80,50.417119666304259]
["Republic of Moldova",53.5105,0.19263764588988327,55,64.212548629961091]
["Romania",52.046999999999997,0.1873690501047599,87,62.456350034919971]
["Russian Federation",49.4358,0.17796873762500992,57,59.322912541669979]
["Saudi Arabia",57.257599999999996,0.20612719509824393,92,68.709065032747972]
["Senegal",38.836100000000002,0.13980984815212147,{"$f":"RANK(C141,C141:C261,0)","v":49},46.603282717373823]
["Serbia",72.055400000000006,0.25939923248061403,{"$f":"RANK(C142,C142:C262,0)","v":75},86.466410826871353]
["Singapore",41.437899999999999,0.14917632065894348,{"$f":"RANK(C143,C143:C263,0)","v":75},49.72544021964783]
["Slovak Republic",42.888500000000001,0.15439847648121882,{"$f":"RANK(C144,C144:C263,0)","v":51},51.466158827072938]
["Slovenia",46.652999999999999,0.16795066563946748,71,55.983555213155825]
["South Africa",71.904200000000003,0.25885491291606966,79,86.284970972023217]
["South Sudan",45.662700000000001,0.16438558849152923,70,54.79519616384308]
["Spain",49.6111,0.1785998171201463,70,59.533272373382104]
["Sri Lanka",40.709299999999999,0.14655336275730979,73,48.851120919103266]
["Sudan",23.464600000000001,8.4472492422006065E-2,{"$f":"RANK(C150,C150:C268,0)","v":63},28.157497474002025]
["Suriname",74.503399999999999,0.26821202543037964,{"$f":"RANK(C151,C151:C269,0)","v":80},89.404008476793209]
["Sweden",19.482600000000001,7.0137303890156891E-2,{"$f":"RANK(C152,C152:C270,0)","v":52},23.379101296718964]
["Switzerland",36.325299999999999,0.13077097538321969,{"$f":"RANK(C153,C153:C271,0)","v":78},43.590325127739895]
["Syrian Arab Republic ",62.810099999999998,0.2261161791070567,{"$f":"RANK(C154,C154:C271,0)","v":75},75.372059702352232]
["Tajikistan",38.225200000000001,0.13761060991151208,72,45.870203303837364]
["Thailand",43.722900000000003,{"$f":"B166*1000/277778","v":0.15740231407814875},54,{"$f":"C166*100/0.3","v":52.467438026049585}]
["Togo",13.0227,4.6881682494654006E-2,73,15.627227498218002]
["Trinidad and Tobago",28.0609,0.10101915918467266,72,33.67305306155756]
["Tunisia",55.968800000000002,0.20148751880998497,75,67.162506269994992]
["Turkey",58.819899999999997,0.21175147059882349,83,70.583823532941167]
["Turkmenistan",59.722499999999997,0.21500082799933759,56,71.666942666445863]
["Ukraine",50.224299999999999,0.18080733535413174,84,60.269111784710582]
["United Arab Emirates",58.730400000000003,0.21142927085658331,77,70.476423618861105]
["United Kingdom",51.502400000000002,0.18540849167320667,60,61.802830557735554]
["United Rep. of Tanzania",10.6839,3.8462009230392613E-2,76,12.820669743464206]
["United States",54.546700000000001,0.19636796290562969,74,65.455987635209908]
["Uruguay",30.307300000000001,0.10910619271504583,85,36.368730905015276]
["Uzbekistan",53.611800000000002,0.19300232559813954,82,64.334108532713174]
["Venezuela",55.044899999999998,0.19816148147081483,67,66.053827156938283]
["Viet Nam",54.460999999999999,0.19605944315244547,64,65.353147717481818]
["Yemen",76.493799999999993,0.27537745969803218,64,91.792486566010737]
["Zambia",7.6981000000000002,2.7713137829489736E-2,73,9.2377126098299129]
["Zimbabwe",24.980699999999999,8.9930448055641543E-2,65,29.976816018547179]
[]
[]
[]
[null,"Beef",5]
[null,"Cheese",4]
[null,"Fish",4]
[null,"Poultry",3]
[null,"Legumes (beans, lentils, chickpeas…)",2]
[null,"Eggs",2]
[null,"Sweets",1]
[null,"Cereals",1]
[null,"Yogurt",1]
[null,"Pasta",1]
[null,"Rice",1]
[null,"Bread",1]
[null,"Milk and dairy",1]
[null,"Fruits and veggies",0]
[]
[null,null,"% waste unmanaged","Municipal waste landfilled","Municipal waste incinerated","Municipal waste recycled","Municipal waste incinerated with energy recovery"]
["Afghanistan",{"$f":"VLOOKUP(A203,countries,1,FALSE)","v":{"$error":"#N/A"}},0.32750000476837149,0,0,0,0,{"$f":"SUM(C203:G203)","v":0.32750000476837149},{"$f":"0.5*(1-C203)+0.5*(F203)","v":0.33624999761581426}]
["Albania","Albania",0.15000000000000002,0,0,0,0,0.15000000000000002,0.42499999999999999,null,"Algeria"]
["Algeria","Algeria",0.39987058823529409,0.5996117647058824,0,5.1764705882352947E-4,0,1,0.30032352941176471,null,"Angola"]
["Andorra",{"$error":"#N/A"},0,0,1,0,0,1,0.5]
["Angola","Angola",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"Armenia"]
["Antigua and Barbuda",{"$error":"#N/A"},5.0000000000000044E-2,0.95,0,0,0,1,0.47499999999999998]
["Argentina","Argentina",0.33112747688293465,0.64238252220153802,0,2.6490000915527341E-2,0,1,0.34768126201629634,null,"Austria"]
["Armenia","Armenia",0.8197500038146972,0.18024999618530274,0,0,0,1,9.0124998092651398E-2,null,"Azerbaijan"]
["Aruba",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Australia","Australia",0,0.69661911715152203,0,0.30338088284847803,0,1,0.65169044142423904,null,"Bangladesh"]
["Austria","Austria",0,0,0,0.34786410854356581,0.65213589145643414,1,0.67393205427178293,null,"Belarus"]
["Azerbaijan","Azerbaijan",0,0,0,0,0,0,0.5,null,"Belgium"]
["Bahamas",{"$error":"#N/A"},0.44689999999999996,0,0,0,0,0.44689999999999996,0.27655000000000002]
["Bahrain","Bahrain",0.247,0,0,0,0,0.247,0.3765,null,"Bolivia"]
["Bangladesh","Bangladesh",0.58000000000000007,0,0,0,0,0.58000000000000007,0.20999999999999996,null,"Bosnia and Herzegovina"]
["Barbados",{"$error":"#N/A"},0.44689999999999996,0,0,0,0,0.44689999999999996,0.27655000000000002]
["Belarus","Belarus",0.25,0.75,0,0,0,1,0.375,null,"Brazil"]
["Belgium","Belgium",0,4.3865816024047891E-2,3.2744904919359698E-2,0.41375359617167939,0.50963568288491301,1,0.7068767980858397,null,"Brunei Darussalam"]
["Belize",{"$error":"#N/A"},0.61449998855590826,0.38550001144409174,0,0,0,1,0.19275000572204587]
["Benin","Benin",0.77,0,0,0,0,0.77,0.11499999999999999,null,"Cambodia"]
["Bermuda",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Bhutan",{"$error":"#N/A"},0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426]
["Bolivia","Bolivia",0.50958869934082007,0,0,0,0,0.50958869934082007,0.24520565032958996,null,"Chile"]
["Bosnia and Herzegovina","Bosnia and Herzegovina",0.38370313695485847,0.61629686304514153,0,0,0,1,0.30814843152257076,null,"Chinese Taipei"]
["Botswana","Botswana",0.71693034807840972,0,0,0,0,0.71693034807840972,0.14153482596079514,null,"Colombia"]
["Brazil","Brazil",0.34400501155853269,0.63001498889923091,0,2.5979999542236329E-2,0,0.99999999999999989,0.3409874939918518,null,"Congo"]
["Brunei Darussalam","Brunei Darussalam",0.19999999999999996,0,0,0,0,0.19999999999999996,0.4,null,"Costa Rica"]
["Bulgaria","Bulgaria",0.31185653886250431,0.36556961658751308,0,0.3172854690774301,5.2883754725524682E-3,0.99999999999999989,0.50271446510746287,null,"Côte d'Ivoire"]
["Burkina Faso",{"$error":"#N/A"},1,0,0,0,0,1,0]
["Burundi",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Cambodia","Cambodia",0.25,0,0,0,0,0.25,0.375,null,"Curaçao"]
["Cameroon","Cameroon",0.84431023026891938,0.15343673833671012,0,2.2530313943704837E-3,0,1,7.8971400562725558E-2,null,"Cyprus"]
["Canada","Canada",1.0000000000000009E-2,0.59483687595712087,0,0.26532,0.12984312404287901,{"$f":"SUM(C235:G235)","v":0.99999999999999989},{"$f":"0.5*(1-C235)+0.5*(F235)","v":0.62766},null,"Czech Republic"]
["Cape Verde",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Cayman Islands",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Central African Republic",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Chad",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Chile","Chile",0.11699999999999999,0.88300000000000001,0,0,0,1,0.4415,null,"Ecuador"]
["China","People's Rep. of China",0.44259793417944071,0.427793802538322,6.4804131641118604E-2,0,6.4804131641118604E-2,1,0.27870103291027964,null,"Egypt"]
["Colombia",{"$f":"VLOOKUP(A242,countries,1,FALSE)","v":"Colombia"},2.0000000000000018E-2,0,0,0,0,2.0000000000000018E-2,0.49,null,"El Salvador"]
["Comoros",{"$error":"#N/A"},0.8,0,0,0,0,0.8,9.9999999999999978E-2]
["Costa Rica","Costa Rica",0.27,0,0,0,0,0.27,0.36499999999999999,null,"Estonia"]
["Côte d'Ivoire","Côte d'Ivoire",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"Ethiopia"]
["Croatia","Croatia",7.999999999999996E-2,0.85010500308832615,0,6.9894996911673876E-2,0,1,0.49494749845583697,null,"Finland"]
["Cuba","Cuba",0.42404053766032246,0.53412165875733431,0,4.1837803582343319E-2,0,1,0.30889863296101044,null,"France"]
["Cyprus","Cyprus",0,0.61907270811380399,0,0.38020284510010538,7.2444678609062175E-4,1,0.69010142255005269,null,"FYR of Macedonia"]
["Czech Republic","Czech Republic",3.5735556879095132E-3,0.29169519082205858,4.0382352213482955E-4,0.56827812643289588,0.13604930353500114,0.99999999999999989,0.78235228537249313,null,"Gabon"]
["Democratic People's Republic of Korea",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Democratic Republic of the Congo","Dem. Rep. of Congo",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Denmark",{"$f":"VLOOKUP(A252,countries,1,FALSE)","v":"Denmark"},0,2.3313378766712134E-2,0,0.22286081556987375,0.75382580566341417,1,0.61143040778493685,null,"Ghana"]
["Djibouti",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Dominican Republic","Dominican Republic",0.40500000000000003,0,0,0,0,0.40500000000000003,0.29749999999999999,null,"Greece"]
["Ecuador","Ecuador",0.51,0,0,0,0,0.51,0.245,null,"Guatemala"]
["Egypt","Egypt",0.247,0,0,0,0,0.247,0.3765,null,"Haiti"]
["El Salvador","El Salvador",0.47,0,0,0,0,0.47,0.26500000000000001,null,"Honduras"]
["Equatorial Guinea",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Eritrea","Eritrea",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"Hungary"]
["Estonia","Estonia",0.20999999999999996,0.4149148175210553,0,0.31301657501057573,6.2068607468369036E-2,1,0.55150828750528791,null,"Iceland"]
["Ethiopia","Ethiopia",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"India"]
["Finland","Finland",0,0.53240100404692381,0,0.25415364650035011,0.21344534945272614,1,0.62707682325017511,null,"Indonesia"]
["France","France",0,0.37502177317825841,1.5170656512975033E-2,0.23319433090583552,0.37661323940293107,1,0.61659716545291776,null,"Iraq"]
["Gabon","Gabon",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"Ireland"]
["Gambia",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Georgia","Georgia",0.4,0,0,0,0,0.4,0.3,null,"Israel"]
["Germany","Germany",0,1.2541920458594797E-4,4.8522448922510278E-3,0.48515743209164924,0.50986490381151373,{"$f":"SUM(C267:G267)","v":1},{"$f":"0.5*(1-C267)+0.5*(F267)","v":0.74257871604582459},null,"Italy"]
["Ghana","Ghana",0.15000000000000002,0,0,0,0,0.15000000000000002,0.42499999999999999,null,"Jamaica"]
["Greece","Greece",0,0.67016412379073009,0,0.32983587620926991,0,1,0.66491793810463495,null,"Japan"]
["Greenland",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Grenada",{"$error":"#N/A"},0.44689999999999996,0,0,0,0,0.44689999999999996,0.27655000000000002]
["Guam",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Guatemala","Guatemala",0.77829999923706095,0,0,0,0,0.77829999923706095,0.11085000038146953,null,"Korea"]
["Guinea",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Guinea-Bissau",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Guyana",{"$error":"#N/A"},0.10999999999999999,0,0,0,0,0.10999999999999999,0.44500000000000001]
["Haiti","Haiti",0.89,0,0,0,0,0.89,5.4999999999999993E-2,null,"Latvia"]
["Honduras","Honduras",0.31999999999999995,0,0,0,0,0.31999999999999995,0.34,null,"Lebanon"]
["Hong Kong","Hong Kong, China",0,0,0,0,0,0,0.5]
["Hungary",{"$f":"VLOOKUP(A280,countries,1,FALSE)","v":"Hungary"},0.12735428587859793,0.38206285763579378,0,0.37534385753036009,0.1152389989552482,1,0.62399478582588108,null,"Lithuania"]
["Iceland","Iceland",0,0.74545454545454548,0,0.1393939393939394,0.11515151515151516,1,0.5696969696969697,null,"Luxembourg"]
["India","India",0.71,0.03,9.9999999999999992E-2,7.9999999999999918E-2,7.9999999999999918E-2,0.99999999999999989,0.18499999999999997,null,"Malaysia"]
["Indonesia","Indonesia",0.19999999999999996,0,0,0,0,0.19999999999999996,0.4,null,"Malta"]
["Iran",{"$error":"#N/A"},0.247,0,0,0,0,0.247,0.3765]
["Iraq","Iraq",0.44400001525878896,0,0.55599998474121104,0,0,1,0.27799999237060552,null,"Mexico"]
["Ireland","Ireland",9.9999999999999978E-2,0.47227508480639357,3.3733934629028109E-4,0.42738757584731618,0,1,0.66369378792365807,null,"Mongolia"]
["Isle of Man",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Israel","Israel",0.247,0,0,0,0,0.247,0.3765,null,"Morocco"]
["Italy","Italy",0,0.31939307988927823,2.1222131554104865E-4,0.36112385542168673,0.31927084337349398,1,0.68056192771084334,null,"Mozambique"]
["Jamaica","Jamaica",0.43,0.57000000000000006,0,0,0,1,0.28500000000000003,null,"Myanmar"]
["Japan","Japan",1.9999694824219816E-3,3.6273563744547044E-2,0.59149341664731681,0.17829147783618751,0.19194157228952666,1,0.58814575417688275,null,"Namibia"]
["Jordan","Jordan",5.0000000000000044E-2,0,0,0,0,5.0000000000000044E-2,0.47499999999999998,null,"Nepal"]
["Kazakhstan","Kazakhstan",0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426,null,"Netherlands"]
["Kenya","Kenya",0.6,0,0,0,0,0.6,0.2,null,"New Zealand"]
["Kiribati",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Korea, Republic of","Korea",6.999969482421986E-3,0.36128380006942618,7.1729060441430278E-2,0.48825810956529131,7.1729060441430278E-2,1,0.74062907004143463,null,"Niger"]
["Kuwait",{"$f":"VLOOKUP(A297,countries,1,FALSE)","v":"Kuwait"},0,1,0,0,0,1,0.5,null,"Nigeria"]
["Kyrgyzstan","Kyrgyzstan",1,0,0,0,0,1,0,null,"Norway"]
["Lao People's Democratic Republic",{"$error":"#N/A"},0.19999999999999996,0,0,0,0,{"$f":"SUM(C299:G299)","v":0.19999999999999996},{"$f":"0.5*(1-C299)+0.5*(F299)","v":0.4}]
["Latvia","Latvia",0.5,0.32480793677112696,0,0.17519206322887304,0,1,0.33759603161443652,null,"Other Africa"]
["Lebanon","Lebanon",0.41826407734056986,0.51379223202170965,0,6.7943690637720489E-2,0,1,0.32483980664857526,null,"Other Asia"]
["Lesotho",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Liberia",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Liechtenstein",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Lithuania","Lithuania",2.2404779686333032E-2,0.59618156036036174,1.1531558227473148E-3,0.38026050413055795,0,1,0.67892786222211243,null,"Paraguay"]
["Luxembourg","Luxembourg",0,0.12798319327731089,0,0.33239495798319324,0.53962184873949581,1,0.66619747899159665,null,"People's Rep. of China"]
["Madagascar",{"$error":"#N/A"},1,0,0,0,0,1,0]
["Malawi",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Malaysia","Malaysia",0.5,0,0,0,0,0.5,0.25,null,"Poland"]
["Maldives",{"$error":"#N/A"},0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426]
["Mali",{"$error":"#N/A"},0.6,0,0,0,0,0.6,0.2]
["Malta","Malta",4.5267489711934172E-2,0.6628738398399403,9.7005927781454674E-3,0.27571114236416749,6.4469353058126001E-3,1,0.61522182632611666,null,"Republic of Moldova"]
["Marshall Islands",{"$error":"#N/A"},0.4,0,0,0.6,0,1,0.6]
["Mauritania",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Mauritius","Mauritius",0.2577905834036156,0.71337175021084664,0,2.8837666385537749E-2,0,1,0.38552354149096107,null,"Saudi Arabia"]
["Mexico","Mexico",0.3176745220635816,0.65302196401789392,0,2.9303513918524537E-2,0,1,0.3558144959274715,null,"Senegal"]
["Micronesia (Federated States of)",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Monaco",{"$error":"#N/A"},0,0,0.94082954619752768,5.9170453802472385E-2,0,1,0.52958522690123622]
["Mongolia","Mongolia",0.19999999999999996,0,0,0,0,0.19999999999999996,0.4,null,"Slovak Republic"]
["Morocco","Morocco",0.80045500000000003,0.18448500000000001,0,1.506E-2,0,1,0.10730249999999998,null,"Slovenia"]
["Mozambique","Mozambique",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"South Africa"]
["Myanmar","Myanmar",0.19999999999999996,0,0,0,0,0.19999999999999996,0.4,null,"South Sudan"]
["Namibia","Namibia",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"Spain"]
["Nepal","Nepal",0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426,null,"Sri Lanka"]
["Netherlands","Netherlands",0,1.7747747747747789E-2,0,0.5067567567567568,0.47549549549549547,1,0.7533783783783784,null,"Sudan"]
["New Zealand","New Zealand",0,0.84697910550005184,0,0.15302089449994818,0,1,0.57651044724997413,null,"Suriname"]
["Nicaragua","Nicaragua",0.27,0,0,0,0,0.27,0.36499999999999999,null,"Sweden"]
["Niger","Niger",0.92732162355915615,0,5.4502024968396692E-2,1.8176351472447252E-2,0,1.0000000000000002,4.5427363956645553E-2,null,"Switzerland"]
["Nigeria","Nigeria",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997,null,"Syrian Arab Republic "]
["Northern Mariana Islands",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Norway","Norway",1.0000000000000009E-2,8.7095896353848304E-2,0,0.37237660468143008,0.53052749896472162,{"$f":"SUM(C331:G331)","v":1},{"$f":"0.5*(1-C331)+0.5*(F331)","v":0.68118830234071504},null,"Thailand"]
["Oman","Oman",0.247,0,0,0,0,0.247,0.3765,null,"Togo"]
["Pakistan","Pakistan",0.4,0,0,0,0,0.4,0.3,null,"Trinidad and Tobago"]
["Palau",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Panama","Panama",0.35800003051757801,0,0,0,0,0.35800003051757801,0.320999984741211,null,"Turkey"]
["Paraguay","Paraguay",0.62356189727783207,0,0,0,0,0.62356189727783207,0.18821905136108397,null,"Turkmenistan"]
["Peru","Peru",0.4375,0.5625,0,0,0,1,0.28125,null,"Ukraine"]
["Philippines","Philippines",0.30000000000000004,0,0,0,0,0.30000000000000004,0.35,null,"United Arab Emirates"]
["Poland","Poland",0.18971061093247588,0.59240524226563906,8.3329573334337062E-3,0.19594366084216738,1.3607528626284062E-2,1.0000000000000002,0.50311652495484571,null,"United Kingdom"]
["Portugal","Portugal",0,0.61940965885357535,0,0.2608428719208094,0.11974746922561527,1,0.63042143596040467,null,"United Rep. of Tanzania"]
["Puerto Rico",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Qatar","Qatar",0.247,0.753,0,0,0,1,0.3765,null,"Uruguay"]
["Republic of Moldova","Republic of Moldova",0,0,0,0,0,0,0.5,null,"Uzbekistan"]
["Romania","Romania",0.22786126752985902,0.38358380258957714,0,0.36302141243140496,2.5533517449158927E-2,1,0.56758007245077291,null,"Venezuela"]
["Russia","Russian Federation",0.25,0,0,0,0,0.25,0.375]
["Rwanda",{"$f":"VLOOKUP(A346,countries,1,FALSE)","v":{"$error":"#N/A"}},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Saint Kitts and Nevis",{"$error":"#N/A"},0.44689999999999996,0,0,0,0,0.44689999999999996,0.27655000000000002]
["Saint Lucia",{"$error":"#N/A"},0.44689999999999996,0,0,0,0,0.44689999999999996,0.27655000000000002]
["Saint Vincent and the Grenadines",{"$error":"#N/A"},0.44689999999999996,0,0,0,0,0.44689999999999996,0.27655000000000002]
["San Marino",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Saudi Arabia","Saudi Arabia",0.247,0,0,0,0,0.247,0.3765]
["Senegal","Senegal",0.78600000381469703,0,0,0,0,0.78600000381469703,0.10699999809265148]
["Serbia and Montenegro",{"$error":"#N/A"},0.25,0,0,0,0,0.25,0.375]
["Seychelles",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Sierra Leone",{"$error":"#N/A"},0.8473410320281981,0,0,0,0,0.8473410320281981,7.6329483985900948E-2]
["Singapore","Singapore",0,2.4353143969122016E-2,0.20281476565420553,0.57001732472246691,0.20281476565420553,1,0.78500866236123346]
["Slovakia (Slovak Republic)",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Slovenia","Slovenia",6.9999999999999951E-2,0.16828947662590263,0,0.70257841668716048,5.9132106686936886E-2,1,0.81628920834358021]
["Somalia",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["South Africa","South Africa",5.0000000000000044E-2,0,0,0,0,5.0000000000000044E-2,0.47499999999999998]
["Spain","Spain",0,0.44524353302758723,0,0.32393416251277529,0.23082230445963747,1,0.66196708125638759]
["Sri Lanka","Sri Lanka",0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426]
["Sudan","Sudan",0.63650000000000007,0,0,0,0,{"$f":"SUM(C363:G363)","v":0.63650000000000007},{"$f":"0.5*(1-C363)+0.5*(F363)","v":0.18174999999999997}]
["Suriname","Suriname",0.32999999999999996,0,0,0,0,0.32999999999999996,0.33500000000000002]
["Swaziland",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Sweden","Sweden",0,0.41763842549114916,0,0.34130560969509344,0.24105596481375735,1,0.67065280484754675]
["Switzerland","Switzerland",0,0,0,0.40955262589150637,0.59044737410849357,1,0.70477631294575316]
["Syria",{"$error":"#N/A"},0.26,0,0,0,0,0.26,0.37]
["Tajikistan","Tajikistan",0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426]
["Thailand","Thailand",0.55000000000000004,0,2.4870099196976851E-2,0.4251299008030231,0,1,0.43756495040151155]
["The former Yugoslav Republic of Macedonia",{"$error":"#N/A"},0.28000000000000003,0,0,0,0,0.28000000000000003,0.36]
["Timor-Leste",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Togo","Togo",0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["Trinidad and Tobago","Trinidad and Tobago",9.9999999999999978E-2,0,0,0,0,9.9999999999999978E-2,0.45]
["Tunisia","Tunisia",0.28750000000000003,0.71249999999999991,0,0,0,1,0.35624999999999996]
["Turkey","Turkey",0.42249999999999999,0.57750000000000001,0,0,0,1,0.28875000000000001]
["Turkmenistan","Turkmenistan",0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426]
["Turks and Caicos Islands",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Uganda",{"$error":"#N/A"},1,0,0,0,0,1,0]
["Ukraine","Ukraine",0.7,0,0,0,0,0.7,0.15000000000000002]
["United Arab Emirates","United Arab Emirates",0.247,0,0,0,0,0.247,0.3765]
["United Kingdom","United Kingdom",0,0.64831494477766605,2.4541890654044142E-4,0.24243096355883931,0.10900867275695413,0.99999999999999989,0.62121548177941965]
["United Republic of Tanzania",{"$error":"#N/A"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]
["United States","United States",0,0.70591117917304746,0,0.14000000000000001,0.15408882082695252,1,0.57000000000000006]
["United States Virgin Islands",{"$error":"#N/A"},0,0,0,0,0,0,0.5]
["Uruguay","Uruguay",0.14000000000000001,0,0,0,0,0.14000000000000001,0.43]
["Uzbekistan","Uzbekistan",0.32750000476837149,0,0,0,0,0.32750000476837149,0.33624999761581426]
["Venezuela (Bolivarian Republic of)","Venezuela",0.14000000000000001,0,0,0,0,0.14000000000000001,0.43]
["Vietnam","Vietnam",0.7,0,0,0,0,0.7,0.15000000000000002]
["Yemen",{"$f":"VLOOKUP(A390,countries,1,FALSE)","v":"Yemen"},0.95199999809265123,4.8000001907348738E-2,0,0,0,1,2.4000000953674383E-2]
["Zambia",{"$f":"VLOOKUP(A391,countries,1,FALSE)","v":"Zambia"},0.8,0,0,0,0,0.8,9.9999999999999978E-2]
["Zimbabwe",{"$f":"VLOOKUP(A392,countries,1,FALSE)","v":"Zimbabwe"},0.63650000000000007,0,0,0,0,0.63650000000000007,0.18174999999999997]

{"sheet":"ideas","index":10,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["ideas pour la v2"]
["rajouter helicopter dans transport"]
["rajouter d'autres modes de transport - sources hybrides"]
["add international transport in what if analysis"]
["transport dans benevolat"]
["electronics"]

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

{"sheet":"Feuil2","index":12,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"cab"]
[null,null,"km","person"]
[null,null,9,2]
[null,null,9,4]
[null,null,13,4]
[null,null,70,4]
[null,null,3.5,2]
[null,null,12,5]
[null,null,{"$f":"SUM(C4:C9)*2","v":233}]
[null,null,{"$f":"SUMPRODUCT(C4:C9,D4:D9)/SUM(C4:C9)","v":3.8884120171673819}]
[]
[]
[null,null,"Jeepney/trycicle",null,"consumtion"]
[null,"Jeepney",3,15,15,null,"Huts nuts",2,4]
[null,"Jeepney",32,25,15,null,"boat tour",50,20]
[null,"Jeepney",8,25,15,null,"Talibon",120,60]
[null,"Trycicle",3,2,7,null,"Sibulan",5]
[null,"Trycicle",1,2,7,null,"Siquijor",20]
[null,"jeepney",6,15,15,null,"Apo",15]
[null,"Trycicle",6,4,7,null,null,200]
[null,"jeepney",20,15,15,null,null,1000]
[null,"jeepney",6,20,15,null,null,{"$f":"SUM(H15:H22)*2","v":2824}]
[null,"Trycicle",3,1,7]
[null,"Trycicle",3,2,7]
[null,"jeepney",5,15,15]
[]
[null,null,{"$f":"SUM(C15:C26)*2-3","v":189},{"$f":"SUMPRODUCT(C15:C26,D15:D26)/SUM(C15:C26)","v":17.40625},{"$f":"SUM(E15:E26)","v":140}]