{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Starting menu","Fuelling motorway or locally","Preferred fuel station or else","Join queue or detour","Shortest vs. quickest route","Home or (overnight) parking","Costs due to road closures","Data","Info list box"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Starting menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Fuelling motorway or locally","index":1,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select your starting-points below"]
[null,"Area"]
[null,"Market segment"]
[null,"Vehicle type"]
[null,null,{"$f":"CONCATENATE(C10,C11)","v":""}]
[null,null,"Starting-points","Fill in other values below (required)"]
[null,"Fuelling volume required (litres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Length of detour (kilometres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Motorway fuel price (euro per litre)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D18=\"\",HLOOKUP(C12,Data!B4:AQ11,2,0),D18))","v":""}]
[null,"Local fuel price (euro per litre)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D19=\"\",C18-0.1,D19))","v":""}]
[null,"Difference in fuel price (euro per litre)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",C18-C19,D20))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Average speed (km/h)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D23=\"\",HLOOKUP(C12,Data!B4:AQ11,7,),D23))","v":""}]
[null,"Extra time required (in minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C23=\"\"),\"\",IF(D24=\"\",C15/C23*60,D24))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Costs per hour",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D27=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D27))","v":""}]
[]
[null,null,"Your results"]
[null,"Costs of detour and fuelling locally",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\"),\"\",C24/60*C27)","v":""}]
[null,"Advantage of detour and fuelling locally",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\"),\"\",C20*C14)","v":""}]
[null,"Total",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C14=\"\"),\"\",C31-C30)","v":""}]
[null,"Conclusion",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C14=\"\"),\"\",IF(C32=0,\"NO DIFFERENCE\",IF(C32>5%*C30,\"DETOUR SIGNIFICANTLY CHEAPER\",IF(AND(C32>0,C32<=5%*C30),\"DETOUR SOMETHING CHEAPER\",IF(AND(C32>=-5%*C30,C32<0),\"DETOUR SOMETHING MORE EXPENSIVE\",\"DETOUR MORE EXPENSIVE\")))))","v":""}]

{"sheet":"Preferred fuel station or else","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select your starting-points below"]
[null,"Area"]
[null,"Market segment"]
[null,"Vehicle type"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Starting-points","Fill in values below (required)"]
[null,"Fuelling volume required (in litres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Length of detour (kilometres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Extra waiting time involved (in minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Fuel price elsewhere (euro per litre)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D19=\"\",C20+0.2,D19))","v":""}]
[null,"Fuel price at preferred fuel station (euro per litre)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",HLOOKUP(C12,Data!B4:AQ11,3,0),D20))","v":""}]
[null,"Difference in fuel price (euro per litre)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D21=\"\",C19-C20,D21))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Average speed (km/h)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D24=\"\",HLOOKUP(C12,Data!B4:AQ11,7,),D24))","v":""}]
[null,"Extra time required for detour (in minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C24=\"\"),\"\",IF(D25=\"\",C15/C24*60,D25))","v":""}]
[null,"Total extra time required (in minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C16=\"\",C24=\"\"),\"\",C16+C25)","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Costs per hour",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D29=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D29))","v":""}]
[null,"Fixed costs per hour*",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D30=\"\",HLOOKUP(C12,Data!B4:AQ11,8,0),D30))","v":""},null,"* Fixed costs cover the total costs minus the variable costs (depreciation, fuel, tyres and maintenance & repair)"]
[]
[null,null,"Your results"]
[null,"Costs of detour, waiting times at preferred fuel station",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C16=\"\"),\"\",C25/60*C29+C16/60*C30)","v":""}]
[null,"Advantage implied by fuelling at preferred fuel station",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\"),\"\",C21*C14)","v":""}]
[null,"Total",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",C34-C33)","v":""}]
[null,"Conclusion",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",IF(C35=0,\"NO DIFFERENCE\",IF(C35>5%*C33,\"DETOUR SIGNIFICANTLY CHEAPER\",IF(AND(C35>0,C35<=5%*C33),\"DETOUR SOMETHING CHEAPER\",IF(AND(C35>=-5%*C33,C35<0),\"DETOUR SOMETHING MORE EXPENSIVE\",\"DETOUR MORE EXPENSIVE\")))))","v":""}]

{"sheet":"Join queue or detour","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select your starting-points below"]
[null,"Area"]
[null,"Market segment"]
[null,"Vehicle type"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Starting-points","Fill in values below (required)"]
[null,"Length of detour (kilometres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Toll charges for detour (in euro)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Time involved in queueing up (in minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Costs per kilometre",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D19=\"\",HLOOKUP(C12,Data!B4:AQ11,5,0),D19))","v":""}]
[null,"Costs per hour",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D20))","v":""}]
[]
[null,null,"Your results"]
[null,"Costs involved in joining the queue",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C16=\"\"),\"\",C16/60*C20)","v":""}]
[null,"Costs of detour",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",C14*C19+C15)","v":""}]
[null,"Total",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",C23-C24)","v":""}]
[null,"Conclusion",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",IF(C25=0,\"NO DIFFERENCE\",IF(C25>5%*C23,\"DETOUR SIGNIFICANTLY CHEAPER\",IF(AND(C25>0,C25<=5%*C23),\"DETOUR SOMETHING CHEAPER\",IF(AND(C25>=-5%*C23,C25<0),\"DETOUR SOMEHTING MORE EXPENSIVE\",\"DETOUR MORE EXPENSIVE\")))))","v":""}]

{"sheet":"Shortest vs. quickest route","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select your starting-points below"]
[null,"Area"]
[null,"Market segment"]
[null,"Vehicle type"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Starting-points","Fill in values below (required)"]
[null,"Length of shortest route (kilometres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Length of quickest route (kilometres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Time involved in taking shortest route (minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[null,"Time involved in taking quickest route (minutes)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D17=\"\",\"\",D17))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Costs per kilometre",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",HLOOKUP(C12,Data!B4:AQ11,5,0),D20))","v":""}]
[null,"Costs per hour",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D21=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D21))","v":""}]
[]
[null,null,"Your results"]
[null,"Cost benefit shortest route",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\"),\"\",IF(C14>C15,\"KORTSTE ROUTE IS NOOIT LANGER DAN DE SNELSTE ROUTE\",(C15-C14)*C20))","v":""}]
[null,"Cost benefit quickest route",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C16=\"\",C17=\"\"),\"\",IF(C17>C16,\"SNELSTE ROUTE DUURT NOOIT LANGER DAN KORTSTE ROUTE\",(C16-C17)/60*C21))","v":""}]
[null,"Total",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C17=\"\",C14=\"\"),\"\",C24-C25)","v":""}]
[null,"Conclusion",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C17=\"\"),\"\",IF(C26=0,\"NO DIFFERENCE\",IF(C26>5%*C24,\"SHORTEST ROUTE SIGNIFICANTLY CHEAPER\",IF(AND(C26>0,C26<=5%*C24),\"SHORTEST ROUTE SOMETHING CHEAPER\",IF(AND(C26>=-5%*C24,C26<0),\"QUICKEST ROUTE SOMETHING CHEAPER\",\"QUICKEST ROUTE SIGNIFICANTLY CHEAPER\")))))","v":""}]

{"sheet":"Home or (overnight) parking","index":5,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select your starting-points below"]
[null,"Area"]
[null,"Market segment"]
[null,"Vehicle type"]
[null,null,{"$f":"C11&C12","v":""}]
[null,null,"Starting-points","Fill in values below (required)"]
[null,"Kilometre distance to truck park (A)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Kilometre distance from truck park to next address (B)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[null,"Kilometre distance to work location (C)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D17=\"\",\"\",D17))","v":""}]
[null,"Kilometre distance from work location to next address (D)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D18=\"\",\"\",D18))","v":""}]
[null,"Driver's travelling costs back home and return to truck park (in euro)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D19=\"\",\"\",D19))","v":""}]
[null,"Truck parking charges (in euro)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D20=\"\",\"\",D20))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Costs per kilometre",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D23=\"\",HLOOKUP(C13,Data!B4:AQ11,5,0),D23))","v":""}]
[null,"Costs per hour",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D24=\"\",HLOOKUP(C13,Data!B4:AQ11,6,0),D24))","v":""}]
[]
[null,null,"Your results"]
[null,"Costs for return home/return to work location",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C17=\"\",C18=\"\"),\"\",(C17+C18)*C23)","v":""}]
[null,"Truck parking charges",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C15=\"\",C16=\"\",C19=\"\",C20=\"\"),\"\",(C15+C16)*C23+C19+C20)","v":""}]
[null,"Total",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C27=\"\",C28=\"\"),\"\",C27-C28)","v":""}]
[null,"Conclusion",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C27=\"\",C28=\"\"),\"\",IF(C29=0,\"NO DIFFERENCE\",IF(C29>5%*C27,\"PARKING SIGNIFICANTLY CHEAPER\",IF(AND(C29>0,C29<=5%*C27),\"PARKING SOMETHING CHEAPER\",IF(AND(C29>=-5%*C27,C29<0),\"BACK HOME SOMETHING CHEAPER\",\"BACK HOME SIGNIFICANTLY CHEAPER\")))))","v":""}]

{"sheet":"Costs due to road closures","index":6,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Select your starting-points below"]
[null,"Area"]
[null,"Market segment"]
[null,"Vehicle type"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Starting-points","Fill in values below (required)"]
[null,"Average number of daily trips passing road closure ",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Duration of road being closed (in days)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Length of detour  (kms) per individual trip due to closure",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Total length of detour (kilometres)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",IF(D19=\"\",C14*C15*C16,D19))","v":""}]
[]
[null,null,"Starting-points","If desired, fill in other values below"]
[null,"Costs per kilometre",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D22=\"\",HLOOKUP(C12,Data!B4:AQ11,5,0),D22))","v":""}]
[]
[null,null,"Your results"]
[null,"Total costs of road closure",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C19=\"\"),\"\",C19*C22)","v":""}]

{"sheet":"Data","index":7,"n_rows":11,"n_cols":43,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,40,42,44,46]
["Market segment","General distribution traffic","General distribution traffic","General distribution traffic","General distribution traffic","General distribution traffic","Truck load transport","Truck load transport","Refrigerated transport","Refrigerated transport","Refrigerated transport","Refrigerated transport","Refrigerated transport","Refrigerated transport","Sea container transport","Tipper transport","Tipper transport","Tank transport","Bulk transport","super lorries (LHVs)","super lorries (LHVs)","Transport to Germany","Transport to Germany","Transport to France","Transport to France","Transport to Italy","Transport to Italy","Transport to Spain","Transport to Spain","Transport to Poland","Transport to Poland","Transport to England","Transport to England","Refrigerated transport Germany","Refrigerated transport France","Refrigerated transport Italy","Refrigerated transport Spain","Refrigerated transport Poland","Tank transport Germany","Tank transport France","Tank transport Italy","Tank transport Spain","Tank transport Poland"]
["Vehicle type","Light truck <12 tons","Truck 12-16 tons","Truck, 16 tons and over","Truck + trailer","Tractor + semi-trailer","Truck + trailer","Tractor + semi-trailer","Solo, including refrigerator aggregate","Solo, isotherm","Truck + trailer, incl. refrigerator aggregate","Truck + trailer, isotherm","Tractor + semi-trailer, incl. refrigerator aggregate","Tractor + semi-trailer, isotherm","Tractor + semi-trailer chassis","Solo truck","truck + trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer + central axle trailer","Truck + dolly + semi-trailer","Truck + trailer","Tractor + semi-trailer","Truck + trailer","Tractor + semi-trailer","Truck + trailer","Tractor + semi-trailer","Truck + trailer","Tractor + semi-trailer","Truck + trailer","Tractor + semi-trailer","Tractor + semi-trailer; via Eurotunnel","Tractor + semi-trailer; via ferry","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer","Tractor + semi-trailer"]
["A2 & A3",{"$f":"B2&B3","v":"General distribution trafficLight truck <12 tons"},"General distribution trafficTruck 12-16 tons","General distribution trafficTruck, 16 tons and over",{"$f":"E2&E3","v":"General distribution trafficTruck + trailer"},{"$f":"F2&F3","v":"General distribution trafficTractor + semi-trailer"},{"$f":"G2&G3","v":"Truck load transportTruck + trailer"},"Truck load transportTractor + semi-trailer","Refrigerated transportSolo, including refrigerator aggregate","Refrigerated transportSolo, isotherm","Refrigerated transportTruck + trailer, incl. refrigerator aggregate","Refrigerated transportTruck + trailer, isotherm","Refrigerated transportTractor + semi-trailer, incl. refrigerator aggregate","Refrigerated transportTractor + semi-trailer, isotherm","Sea container transportTractor + semi-trailer chassis","Tipper transportSolo truck","Tipper transporttruck + trailer","Tank transportTractor + semi-trailer","Bulk transportTractor + semi-trailer","super lorries (LHVs)Tractor + semi-trailer + central axle trailer","super lorries (LHVs)Truck + dolly + semi-trailer","Transport to GermanyTruck + trailer","Transport to GermanyTractor + semi-trailer","Transport to FranceTruck + trailer","Transport to FranceTractor + semi-trailer","Transport to ItalyTruck + trailer","Transport to ItalyTractor + semi-trailer","Transport to SpainTruck + trailer","Transport to SpainTractor + semi-trailer","Transport to PolandTruck + trailer","Transport to PolandTractor + semi-trailer","Transport to EnglandTractor + semi-trailer; via Eurotunnel","Transport to EnglandTractor + semi-trailer; via ferry","Refrigerated transport GermanyTractor + semi-trailer","Refrigerated transport FranceTractor + semi-trailer","Refrigerated transport ItalyTractor + semi-trailer","Refrigerated transport SpainTractor + semi-trailer","Refrigerated transport PolandTractor + semi-trailer","Tank transport GermanyTractor + semi-trailer","Tank transport FranceTractor + semi-trailer","Tank transport ItalyTractor + semi-trailer","Tank transport SpainTractor + semi-trailer","Tank transport PolandTractor + semi-trailer"]
["Motorway fuel price (euro per litre)",1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2,1.2]
["Luxemburg fuel price (euro per litre)",1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01,1.01]
[]
["Costs per kilometre",1.41,1.53,1.6,1.87,1.84,1.69,1.67,1.83,1.74,1.97,1.8,1.84,1.73,1.38,2.36,1.94,1.62,1.59,1.63,1.68,1.45,1.41,1.5,1.45,1.45,1.4,1.27,1.23,1.64,1.59,2.21,3.21,1.53,1.57,1.52,1.33,1.72,1.59,1.64,1.59,1.4,1.77]
["Costs per hour",43.36,47.09,49.28,57.29,56.68,59.96,59.35,49.52,46.96,68.239999999999995,62.57,63.75,60.15,57.2,50.13,64.430000000000007,68.569999999999993,67.52,61.89,63.59,72.66,70.33,71.510000000000005,69.22,72.3,69.97,76.14,73.75,68.84,66.7,88.6,116.63,76.28,75.12,76,79.680000000000007,72.150000000000006,76.569999999999993,75.41,76.290000000000006,79.989999999999995,72.540000000000006]
["Average speed (km/h)",{"$f":"B9/B8","v":30.75177304964539},30.777777777777779,30.8,{"$f":"E9/E8","v":30.636363636363633},{"$f":"F9/F8","v":30.804347826086953},{"$f":"G9/G8","v":35.479289940828401},{"$f":"H9/H8","v":35.538922155688624},27.060109289617486,26.988505747126439,34.639593908629436,34.761111111111113,34.646739130434781,34.76878612716763,41.449275362318843,21.241525423728817,33.211340206185568,42.327160493827151,42.465408805031444,37.969325153374236,37.851190476190482,50.110344827586204,49.879432624113477,47.673333333333339,47.737931034482756,49.862068965517238,49.978571428571428,59.952755905511808,59.959349593495936,41.975609756097569,41.949685534591197,40.090497737556561,36.333333333333336,49.856209150326798,47.847133757961785,50,59.909774436090224,41.947674418604656,48.15723270440251,45.981707317073173,47.981132075471699,57.135714285714286,40.983050847457633]
["Fixed costs per hour",{"$f":"(110051-25360)/2538","v":33.369188337273442},{"$f":"(119504-31940)/2538","v":34.501182033096924},{"$f":"(125066-36282)/2538","v":34.981875492513794},{"$f":"(146169-47323)/2538","v":38.946414499605986},{"$f":"(143845-44670)/2538","v":39.076044129235619},{"$f":"(152173-52502)/2538","v":39.271473601260837},{"$f":"(150635-50405)/2538","v":39.491725768321515},{"$f":"(128362-36017)/2592","v":35.626929012345677},{"$f":"(121711-32596)/2592","v":34.380787037037038},{"$f":"(176868-64382)/2592","v":43.397376543209873},{"$f":"(162174-56912)/2592","v":40.610339506172842},{"$f":"(165233-53675)/2592","v":43.039351851851855},{"$f":"(155908-50277)/2592","v":40.752700617283949},{"$f":"(145178-54683)/2538","v":35.656028368794324},{"$f":"(117913-37405)/2352","v":34.229591836734691},{"$f":"(151528-53994)/2352","v":41.468537414965986},{"$f":"(177737-65832)/2592","v":43.173225308641975},{"$f":"(175006-66186)/2592","v":41.983024691358025},{"$f":"(163387-61281)/2640","v":38.676515151515154},{"$f":"(167871-65014)/2640","v":38.960984848484848},{"$f":"(188928-71469)/2600","v":45.176538461538463},{"$f":"(182865-66882)/2600","v":44.608846153846152},{"$f":"(186990-69325)/2615","v":44.996175908221794},{"$f":"(181003-64804)/2615","v":44.435564053537284},{"$f":"(209663-78931)/2900","v":45.08},{"$f":"(202908-73780)/2900","v":44.526896551724136},{"$f":"(228427-93514)/3000","v":44.970999999999997},{"$f":"(221261-87970)/3000","v":44.43033333333333},{"$f":"(205131-72827)/2980","v":44.397315436241612},{"$f":"(198760-67911)/2980","v":43.909060402684567},{"$f":"(231699-54442)/2615","v":67.784703632887187},{"$f":"(304982-49257)/2615","v":97.791586998087951},{"$f":"(198331-72746)/2600","v":48.301923076923075},{"$f":"(196437-70636)/2615","v":48.107456978967498},{"$f":"(220398-80413)/2900","v":48.270689655172411},{"$f":"(239054-94829)/3000","v":48.075000000000003},{"$f":"(215009-74584)/2980","v":47.122483221476507},{"$f":"(199089-72318)/2600","v":48.758076923076921},{"$f":"(197184-70045)/2615","v":48.619120458891011},{"$f":"(222385-80327)/2915","v":48.733447684391081},{"$f":"(238375-93451)/2980","v":48.63221476510067},{"$f":"(216164-74521)/2980","v":47.531208053691273}]

{"sheet":"Info list box","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Area","Market segment","Vehicle type"]
["Inland","General distribution traffic","Light truck <12 tons",null,null,"Inland","Market_segmentB"]
["Cross-border","Truck load transport","Truck 12-16 tons",null,null,"Cross-border","Market_segmentG"]
[null,"Refrigerated transport","Truck, 16 tons and over"]
[null,"Sea container transport","Truck + trailer",null,null,"General distribution traffic","Vehicle_type1"]
[null,"Tipper transport","Tractor + semi-trailer",null,null,"Truck load transport","Vehicle_type2"]
[null,"Tank transport",null,null,null,"Refrigerated transport","Vehicle_type3"]
[null,"Bulk transport","Truck + trailer",null,null,"Sea container transport","Vehicle_type4"]
[null,"Super lorries (LHVs)","Tractor + semi-trailer",null,null,"Tipper transport","Vehicle_type5"]
[null,null,null,null,null,"Tank transport","Vehicle_type6"]
[null,"Transport to Germany","Solo, including refrigerator aggregate",null,null,"Bulk transport","Vehicle_type6"]
[null,"Transport to France","Solo, isotherm",null,null,"Super lorries (LHVs)","Vehicle_type7"]
[null,"Transport to Italy","Truck + trailer, incl. refrigerator aggregate",null,null,"Transport to Germany","Vehicle_type2"]
[null,"Transport to Spain","Truck + trailer, isotherm",null,null,"Transport to France","Vehicle_type2"]
[null,"Transport to Poland","Tractor + semi-trailer, incl. refrigerator aggregate",null,null,"Transport to Italy","Vehicle_type2"]
[null,"Transport to England","Tractor + semi-trailer, isotherm",null,null,"Transport to Spain","Vehicle_type2"]
[null,"Refrigerated transport Germany",null,null,null,"Transport to Poland","Vehicle_type2"]
[null,"Refrigerated transport France","Tractor + semi-trailer chassis",null,null,"Transport to England","Vehicle_type8"]
[null,"Refrigerated transport Italy",null,null,null,"Refrigerated transport Germany","Vehicle_type6"]
[null,"Refrigerated transport Spain","Solo truck",null,null,"Refrigerated transport France","Vehicle_type6"]
[null,"Refrigerated transport Poland","Truck + trailer",null,null,"Refrigerated transport Italy","Vehicle_type6"]
[null,"Tank transport Germany",null,null,null,"Refrigerated transport Spain","Vehicle_type6"]
[null,"Tank transport France","Tractor + semi-trailer",null,null,"Refrigerated transport Poland","Vehicle_type6"]
[null,"Tank transport Italy",null,null,null,"Tank transport Germany","Vehicle_type6"]
[null,"Tank transport Spain","Tractor + semi-trailer + central axle trailer",null,null,"Tank transport France","Vehicle_type6"]
[null,"Tank transport Poland","Truck + dolly + semi-trailer",null,null,"Tank transport Italy","Vehicle_type6"]
[null,null,null,null,null,"Tank transport Spain","Vehicle_type6"]
[null,null,"Tractor + semi-trailer; via Eurotunnel",null,null,"Tank transport Poland","Vehicle_type6"]
[null,null,"Tractor + semi-trailer; via ferry"]
[]
[]
[]
[]
[]
[]
["Area","Market segment","Vehicle type"]
["Cross-border","Refrigerated transport Italy"]