{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Startmenu","Tanken Rijksweg of lokaal","Favoriete tankstation of elders","Door file of omrijden","Kortste vs snelste route","Naar thuis of parkeren","Kosten wegafsluiting","Data","Info listbox"],"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":"Startmenu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tanken Rijksweg of lokaal","index":1,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selecteer hieronder uw uitgangspunten"]
[null,"Gebied"]
[null,"Deelmarkt"]
[null,"Type voertuig"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in (verplicht)"]
[null,"Te tanken hoeveelheid (in liters)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Omrijdkilometers",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Brandstofprijs langs Rijksweg (in euro per liter)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D18=\"\",HLOOKUP(C12,Data!B4:AQ11,2,0),D18))","v":""}]
[null,"Brandstofprijs lokaal (in euro per liter)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D19=\"\",C18-0.1,D19))","v":""}]
[null,"Verschil in brandstofprijs (in euro per liter)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",C18-C19,D20))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Gemiddelde snelheid (in km/uur)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D23=\"\",HLOOKUP(C12,Data!B4:AQ11,7,),D23))","v":""}]
[null,"Extra benodigde tijd (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C23=\"\"),\"\",IF(D24=\"\",C15/C23*60,D24))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Kosten per uur",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D27=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D27))","v":""}]
[]
[null,null,"Uw resultaten"]
[null,"Kosten omrijden en daar tanken",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\"),\"\",C24/60*C27)","v":""}]
[null,"Voordeel omrijden en daar tanken",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\"),\"\",C20*C14)","v":""}]
[null,"Totaal",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C14=\"\"),\"\",C31-C30)","v":""}]
[null,"Conclusie",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C14=\"\"),\"\",IF(C32=0,\"GEEN VERSCHIL\",IF(C32>5%*C30,\"OMRIJDEN FLINK VOORDELIGER\",IF(AND(C32>0,C32<=5%*C30),\"OMRIJDEN IETS VOORDELIGER\",IF(AND(C32>=-5%*C30,C32<0),\"OMRIJDEN IETS ONVOORDELIGER\",\"OMRIJDEN FLINK ONVOORDELIGER\")))))","v":""}]

{"sheet":"Favoriete tankstation of elders","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selecteer hieronder uw uitgangspunten"]
[null,"Gebied"]
[null,"Deelmarkt"]
[null,"Type voertuig"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Uitgangspunten","Vul hieronder waardes in (verplicht)"]
[null,"Te tanken hoeveelheid (in liters)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Omrijdkilometers",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Extra wachttijd (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Brandstofprijs elders (in euro per liter)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D19=\"\",C20+0.2,D19))","v":""}]
[null,"Brandstofprijs favoriete tankstation (in euro per liter)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",HLOOKUP(C12,Data!B4:AQ11,3,0),D20))","v":""}]
[null,"Verschil in brandstofprijs (in euro per liter)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D21=\"\",C19-C20,D21))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Gemiddelde snelheid (in km/uur)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D24=\"\",HLOOKUP(C12,Data!B4:AQ11,7,),D24))","v":""}]
[null,"Extra benodigde tijd voor rijden (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C24=\"\"),\"\",IF(D25=\"\",C15/C24*60,D25))","v":""}]
[null,"Totaal extra benodigde tijd (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C16=\"\",C24=\"\"),\"\",C16+C25)","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Kosten per uur",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D29=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D29))","v":""}]
[null,"Vaste kosten per uur*",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D30=\"\",HLOOKUP(C12,Data!B4:AQ11,8,0),D30))","v":""},null,"* Vaste kosten betreffen de totale kosten minus de variabele kosten (afschrijving, brandstof, banden en R&O)"]
[]
[null,null,"Uw resultaten"]
[null,"Kosten omrijden, wachttijd tanken favoriete tankstation",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C15=\"\",C16=\"\"),\"\",C25/60*C29+C16/60*C30)","v":""}]
[null,"Voordeel tanken favoriete tankstation",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\"),\"\",C21*C14)","v":""}]
[null,"Totaal",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",C34-C33)","v":""}]
[null,"Conclusie",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",IF(C35=0,\"GEEN VERSCHIL\",IF(C35>5%*C33,\"OMRIJDEN FLINK VOORDELIGER\",IF(AND(C35>0,C35<=5%*C33),\"OMRIJDEN IETS VOORDELIGER\",IF(AND(C35>=-5%*C33,C35<0),\"OMRIJDEN IETS ONVOORDELIGER\",\"OMRIJDEN FLINK ONVOORDELIGER\")))))","v":""}]

{"sheet":"Door file of omrijden","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selecteer hieronder uw uitgangspunten"]
[null,"Gebied"]
[null,"Deelmarkt"]
[null,"Type voertuig"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Uitgangspunten","Vul hieronder waardes in (verplicht)"]
[null,"Omrijdkilometers",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Tolkosten bij omrijden (in euro)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Tijdsduur file (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Kosten per kilometer",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D19=\"\",HLOOKUP(C12,Data!B4:AQ11,5,0),D19))","v":""}]
[null,"Kosten per uur",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D20))","v":""}]
[]
[null,null,"Uw resultaten"]
[null,"Kosten in file blijven staan",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C16=\"\"),\"\",C16/60*C20)","v":""}]
[null,"Kosten omrijden",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",C14*C19+C15)","v":""}]
[null,"Totaal",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",C23-C24)","v":""}]
[null,"Conclusie",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",IF(C25=0,\"GEEN VERSCHIL\",IF(C25>5%*C23,\"OMRIJDEN FLINK VOORDELIGER\",IF(AND(C25>0,C25<=5%*C23),\"OMRIJDEN IETS VOORDELIGER\",IF(AND(C25>=-5%*C23,C25<0),\"OMRIJDEN IETS ONVOORDELIGER\",\"OMRIJDEN FLINK ONVOORDELIGER\")))))","v":""}]

{"sheet":"Kortste vs snelste route","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selecteer hieronder uw uitgangspunten"]
[null,"Gebied"]
[null,"Deelmarkt"]
[null,"Type voertuig"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Uitgangspunten","Vul hieronder waardes in (verplicht)"]
[null,"Aantal kilometers kortste route",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Aantal kilometers snelste route",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Tijdsduur kortste route (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[null,"Tijdsduur snelste route (in minuten)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D17=\"\",\"\",D17))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Kosten per kilometer",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D20=\"\",HLOOKUP(C12,Data!B4:AQ11,5,0),D20))","v":""}]
[null,"Kosten per uur",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D21=\"\",HLOOKUP(C12,Data!B4:AQ11,6,0),D21))","v":""}]
[]
[null,null,"Uw resultaten"]
[null,"Kostenvoordeel kortste 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,"Kostenvoordeel snelste 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,"Totaal",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C17=\"\",C14=\"\"),\"\",C24-C25)","v":""}]
[null,"Conclusie",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C17=\"\"),\"\",IF(C26=0,\"GEEN VERSCHIL\",IF(C26>5%*C24,\"KORTSTE ROUTE FLINK VOORDELIGER\",IF(AND(C26>0,C26<=5%*C24),\"KORTSTE ROUTE IETS VOORDELIGER\",IF(AND(C26>=-5%*C24,C26<0),\"SNELSTE ROUTE IETS VOORDELIGER\",\"SNELSTE ROUTE FLINK VOORDELIGER\")))))","v":""}]

{"sheet":"Naar thuis of parkeren","index":5,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selecteer hieronder uw uitgangspunten"]
[null,"Gebied"]
[null,"Deelmarkt"]
[null,"Type voertuig"]
[null,null,{"$f":"C11&C12","v":""}]
[null,null,"Uitgangspunten","Vul hieronder waardes in (verplicht)"]
[null,"Aantal kilometers naar parkeerplaats (A)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Aantal kilometers van parkeerplaats naar volgend adres (B)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[null,"Aantal kilometers naar standplaats (C)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D17=\"\",\"\",D17))","v":""}]
[null,"Aantal kilometers van standplaats naar volgend adres (D)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D18=\"\",\"\",D18))","v":""}]
[null,"Reiskosten chauffeur naar huis en van huis terug naar parkeerplaats (in euro's)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D19=\"\",\"\",D19))","v":""}]
[null,"Kosten parkeren (in euro's)",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D20=\"\",\"\",D20))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Kosten per kilometer",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D23=\"\",HLOOKUP(C13,Data!B4:AQ11,5,0),D23))","v":""}]
[null,"Kosten per uur",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\"),\"\",IF(D24=\"\",HLOOKUP(C13,Data!B4:AQ11,6,0),D24))","v":""}]
[]
[null,null,"Uw resultaten"]
[null,"Kosten naar thuis/standplaats",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C17=\"\",C18=\"\"),\"\",(C17+C18)*C23)","v":""}]
[null,"Kosten bij parkeren",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C15=\"\",C16=\"\",C19=\"\",C20=\"\"),\"\",(C15+C16)*C23+C19+C20)","v":""}]
[null,"Totaal",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C27=\"\",C28=\"\"),\"\",C27-C28)","v":""}]
[null,"Conclusie",{"$f":"IF(OR(C10=\"\",C11=\"\",C12=\"\",C27=\"\",C28=\"\"),\"\",IF(C29=0,\"GEEN VERSCHIL\",IF(C29>5%*C27,\"PARKEREN FLINK VOORDELIGER\",IF(AND(C29>0,C29<=5%*C27),\"PARKEREN IETS VOORDELIGER\",IF(AND(C29>=-5%*C27,C29<0),\"NAAR THUIS/STANDPLAATS IETS VOORDELIGER\",\"NAAR THUIS/STANDPLAATS FLINK VOORDELIGER\")))))","v":""}]

{"sheet":"Kosten wegafsluiting","index":6,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Selecteer hieronder uw uitgangspunten"]
[null,"Gebied"]
[null,"Deelmarkt"]
[null,"Type voertuig"]
[null,null,{"$f":"C10&C11","v":""}]
[null,null,"Uitgangspunten","Vul hieronder waardes in (verplicht)"]
[null,"Gemiddeld aantal ritten per dag langs de wegafsluiting ",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D14=\"\",\"\",D14))","v":""}]
[null,"Tijdsperiode van de wegafsluiting (in dagen)",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D15=\"\",\"\",D15))","v":""}]
[null,"Omrijdkilometers vanwege de wegafsluiting per rit",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D16=\"\",\"\",D16))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Totaal aantal omrijdkilometers",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\",C14=\"\",C15=\"\",C16=\"\"),\"\",IF(D19=\"\",C14*C15*C16,D19))","v":""}]
[]
[null,null,"Uitgangspunten","Vul hieronder andere waardes in indien gewenst"]
[null,"Kosten per kilometer",{"$f":"IF(OR(C9=\"\",C10=\"\",C11=\"\"),\"\",IF(D22=\"\",HLOOKUP(C12,Data!B4:AQ11,5,0),D22))","v":""}]
[]
[null,null,"Uw resultaten"]
[null,"Totale kosten wegafsluiting",{"$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]
["Deelmarkt","Algemeen distributievervoer","Algemeen distributievervoer","Algemeen distributievervoer","Algemeen distributievervoer","Algemeen distributievervoer","Wagenladingvervoer","Wagenladingvervoer","Koel-vries vervoer","Koel-vries vervoer","Koel-vries vervoer","Koel-vries vervoer","Koel-vries vervoer","Koel-vries vervoer","Zeecontainervervoer","Vervoer met kiepers","Vervoer met kiepers","Tankvervoer","Bulkvervoer","LZV's","LZV's","Vervoer op Duitsland","Vervoer op Duitsland","Vervoer op Frankrijk","Vervoer op Frankrijk","Vervoer op Italië","Vervoer op Italië","Vervoer op Spanje","Vervoer op Spanje","Vervoer op Polen","Vervoer op Polen","Vervoer op Engeland","Vervoer op Engeland","Koel-vries vervoer Duitsland","Koel-vries vervoer Frankrijk","Koel-vries vervoer Italië","Koel-vries vervoer Spanje","Koel-vries vervoer Polen","Tankvervoer Duitsland","Tankvervoer Frankrijk","Tankvervoer Italië","Tankvervoer Spanje","Tankvervoer Polen"]
["Type voertuig","Lichte vrachtwagen <12 ton","Vrachtwagen 12-16 ton","Vrachtwagen, 16 ton en meer","Vrachtwagen + aanhanger","Trekker + oplegger","Vrachtwagen + aanhanger","Trekker + oplegger","Solo, inclusief koelmotor","Solo, isotherm","Vrachtwagen + aanhanger, incl. koelmotor","Vrachtwagen + aanhanger, isotherm","Trekker + oplegger, incl. koelmotor","Trekker + oplegger, isotherm","Trekker + opleggerchassis","Solo vrachtwagen","Vrachtwagen + aanhanger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger + middenasaanhangwagen","Vrachtauto + dolly + oplegger","Vrachtwagen + aanhanger","Trekker + oplegger","Vrachtwagen + aanhanger","Trekker + oplegger","Vrachtwagen + aanhanger","Trekker + oplegger","Vrachtwagen + aanhanger","Trekker + oplegger","Vrachtwagen + aanhanger","Trekker + oplegger","Trekker + oplegger; via Eurotunnel","Trekker + oplegger; via ferrydienst","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger","Trekker + oplegger"]
["A2 & A3",{"$f":"B2&B3","v":"Algemeen distributievervoerLichte vrachtwagen <12 ton"},"Algemeen distributievervoerVrachtwagen 12-16 ton","Algemeen distributievervoerVrachtwagen, 16 ton en meer",{"$f":"E2&E3","v":"Algemeen distributievervoerVrachtwagen + aanhanger"},{"$f":"F2&F3","v":"Algemeen distributievervoerTrekker + oplegger"},{"$f":"G2&G3","v":"WagenladingvervoerVrachtwagen + aanhanger"},"WagenladingvervoerTrekker + oplegger","Koel-vries vervoerSolo, inclusief koelmotor","Koel-vries vervoerSolo, isotherm","Koel-vries vervoerVrachtwagen + aanhanger, incl. koelmotor","Koel-vries vervoerVrachtwagen + aanhanger, isotherm","Koel-vries vervoerTrekker + oplegger, incl. koelmotor","Koel-vries vervoerTrekker + oplegger, isotherm","ZeecontainervervoerTrekker + opleggerchassis","Vervoer met kiepersSolo vrachtwagen","Vervoer met kiepersVrachtwagen + aanhanger","TankvervoerTrekker + oplegger","BulkvervoerTrekker + oplegger","LZV'sTrekker + oplegger + middenasaanhangwagen","LZV'sVrachtauto + dolly + oplegger","Vervoer op DuitslandVrachtwagen + aanhanger","Vervoer op DuitslandTrekker + oplegger","Vervoer op FrankrijkVrachtwagen + aanhanger","Vervoer op FrankrijkTrekker + oplegger","Vervoer op ItaliëVrachtwagen + aanhanger","Vervoer op ItaliëTrekker + oplegger","Vervoer op SpanjeVrachtwagen + aanhanger","Vervoer op SpanjeTrekker + oplegger","Vervoer op PolenVrachtwagen + aanhanger","Vervoer op PolenTrekker + oplegger","Vervoer op EngelandTrekker + oplegger; via Eurotunnel","Vervoer op EngelandTrekker + oplegger; via ferrydienst","Koel-vries vervoer DuitslandTrekker + oplegger","Koel-vries vervoer FrankrijkTrekker + oplegger","Koel-vries vervoer ItaliëTrekker + oplegger","Koel-vries vervoer SpanjeTrekker + oplegger","Koel-vries vervoer PolenTrekker + oplegger","Tankvervoer DuitslandTrekker + oplegger","Tankvervoer FrankrijkTrekker + oplegger","Tankvervoer ItaliëTrekker + oplegger","Tankvervoer SpanjeTrekker + oplegger","Tankvervoer PolenTrekker + oplegger"]
["Brandstofprijs langs Rijksweg (in euro per liter)",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]
["Brandstofprijs Luxemburg (in euro per liter)",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]
[]
["Kosten per kilometer",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]
["Kosten per uur",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]
["Gemiddelde snelheid (in km/uur)",{"$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]
["Vaste kosten per uur",{"$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 listbox","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Gebied","Deelmarkt","Voertuigtype"]
["Binnenlands","Algemeen distributievervoer","Lichte vrachtwagen <12 ton",null,null,"Binnenlands","DeelmarktB"]
["Grensoverschrijdend","Wagenladingvervoer","Vrachtwagen 12-16 ton",null,null,"Grensoverschrijdend","DeelmarktG"]
[null,"Koel-vries vervoer","Vrachtwagen, 16 ton en meer"]
[null,"Zeecontainervervoer","Vrachtwagen + aanhanger",null,null,"Algemeen distributievervoer","Voertuigtype1"]
[null,"Vervoer met kiepers","Trekker + oplegger",null,null,"Wagenladingvervoer","Voertuigtype2"]
[null,"Tankvervoer",null,null,null,"Koel-vries vervoer","Voertuigtype3"]
[null,"Bulkvervoer","Vrachtwagen + aanhanger",null,null,"Zeecontainervervoer","Voertuigtype4"]
[null,"LZV's","Trekker + oplegger",null,null,"Vervoer met kiepers","Voertuigtype5"]
[null,null,null,null,null,"Tankvervoer","Voertuigtype6"]
[null,"Vervoer op Duitsland","Solo, inclusief koelmotor",null,null,"Bulkvervoer","Voertuigtype6"]
[null,"Vervoer op Frankrijk","Solo, isotherm",null,null,"LZV's","Voertuigtype7"]
[null,"Vervoer op Italië","Vrachtwagen + aanhanger, incl. koelmotor",null,null,"Vervoer op Duitsland","Voertuigtype2"]
[null,"Vervoer op Spanje","Vrachtwagen + aanhanger, isotherm",null,null,"Vervoer op Frankrijk","Voertuigtype2"]
[null,"Vervoer op Polen","Trekker + oplegger, incl. koelmotor",null,null,"Vervoer op Italië","Voertuigtype2"]
[null,"Vervoer op Engeland","Trekker + oplegger, isotherm",null,null,"Vervoer op Spanje","Voertuigtype2"]
[null,"Koel-vries vervoer Duitsland",null,null,null,"Vervoer op Polen","Voertuigtype2"]
[null,"Koel-vries vervoer Frankrijk","Trekker + opleggerchassis",null,null,"Vervoer op Engeland","Voertuigtype8"]
[null,"Koel-vries vervoer Italië",null,null,null,"Koel-vries vervoer Duitsland","Voertuigtype6"]
[null,"Koel-vries vervoer Spanje","Solo vrachtwagen",null,null,"Koel-vries vervoer Frankrijk","Voertuigtype6"]
[null,"Koel-vries vervoer Polen","Vrachtwagen + aanhanger",null,null,"Koel-vries vervoer Italië","Voertuigtype6"]
[null,"Tankvervoer Duitsland",null,null,null,"Koel-vries vervoer Spanje","Voertuigtype6"]
[null,"Tankvervoer Frankrijk","Trekker + oplegger",null,null,"Koel-vries vervoer Polen","Voertuigtype6"]
[null,"Tankvervoer Italië",null,null,null,"Tankvervoer Duitsland","Voertuigtype6"]
[null,"Tankvervoer Spanje","Trekker + oplegger + middenasaanhangwagen",null,null,"Tankvervoer Frankrijk","Voertuigtype6"]
[null,"Tankvervoer Polen","Vrachtauto + dolly + oplegger",null,null,"Tankvervoer Italië","Voertuigtype6"]
[null,null,null,null,null,"Tankvervoer Spanje","Voertuigtype6"]
[null,null,"Trekker + oplegger; via Eurotunnel",null,null,"Tankvervoer Polen","Voertuigtype6"]
[null,null,"Trekker + oplegger; via ferrydienst"]
[]
[]
[]
[]
[]
[]
["Gebied","Deelmarkt","Voertuigtype"]
["Grensoverschrijdend","Koel-vries vervoer Duitsland","Trekker + oplegger"]