{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kilometerlijst","2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Kilometerlijst","index":0,"n_rows":40,"n_cols":19,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,8,12,9],[35,7,35,8],[1,4,4,9],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"Naam:",null,null,"Voor een juiste werking eerst \"macro's inschakelen\". Gelieve deze kilometerlijst volledig ingevuld (zie voorbeeld onderaan) per email te verzenden naar Daxxa.      Verzenden via \"Bestand\" dan \"Opslaan en verzenden\" tot slot \"Als bijlage verzenden\". Een eventuele omleiding dient apart via de mail te worden doorgegeven.",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Weeknummer:",41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Datum van:",{"$f":"DATE(2019,1,1)-WEEKDAY(DATE(2019,1,1))-IF(WEEKDAY(DATE(2019,1,1))<6,5,-2)+$C$3*7","v":"2019-10-07"}]
[null,"Datum tot:",{"$f":"DATE(2019,1,1)-WEEKDAY(DATE(2019,1,1))-IF(WEEKDAY(DATE(2019,1,1))<6,5,-2)+$C$3*7+6","v":"2019-10-13"}]
[]
[null,null,"Indien bedrijfsauto Daxxa:",null,null,null,null,"Uw brandstofdeclaratie:"]
[null,"Kenteken:",null,null,null,null,null,"Verbruik 1 op",{"$f":"IF('2'!B23<>TRUE,17,15)","v":17}]
[null,"Literprijs bon:",null,null,null,null,null,"Brandstof",{"$f":"ROUND($H$36/I8*$C$9/121*100,2)","v":0},"EUR"]
[null,"KM beginstand:",null,null,null,null,null,"BTW",{"$f":"ROUND($H$36/I8*$C$9/121*21,2)","v":0},"EUR"]
[null,"KM eindstand",null,null,null,null,null,"Totaal",{"$f":"ROUND(SUM(I9:I10),2)","v":0},"EUR"]
[]
[null,"Naam meerijders","Straat en huisnummer (start)","Postcode","Straat en huisnummer (werk)","Postcode","Enkel/retour","reistijd","km totaal"]
[null,"Maandag",null,null,null,null,null,{"$f":"IF(G14=\"enkel\",G_reistijd(D14,C14,F14,E14),G_reistijd(D14,C14,F14,E14)*2)","v":"00:00:00"},{"$f":"IF($G14=\"enkel\",G_afstand(D14,C14,F14,E14,0,1)/1000,G_afstand(D14,C14,F14,E14,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G15=\"enkel\",G_reistijd(D15,C15,F15,E15),G_reistijd(D15,C15,F15,E15)*2)","v":"00:00:00"},{"$f":"IF($G15=\"enkel\",G_afstand(D15,C15,F15,E15,0,1)/1000,G_afstand(D15,C15,F15,E15,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G16=\"enkel\",G_reistijd(D16,C16,F16,E16),G_reistijd(D16,C16,F16,E16)*2)","v":"00:00:00"},{"$f":"IF($G16=\"enkel\",G_afstand(D16,C16,F16,E16,0,1)/1000,G_afstand(D16,C16,F16,E16,0,1)*2/1000)","v":0},"km"]
[null,"Dinsdag",null,null,null,null,null,{"$f":"IF(G17=\"enkel\",G_reistijd(D17,C17,F17,E17),G_reistijd(D17,C17,F17,E17)*2)","v":"00:00:00"},{"$f":"IF($G17=\"enkel\",G_afstand(D17,C17,F17,E17,0,1)/1000,G_afstand(D17,C17,F17,E17,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G18=\"enkel\",G_reistijd(D18,C18,F18,E18),G_reistijd(D18,C18,F18,E18)*2)","v":"00:00:00"},{"$f":"IF($G18=\"enkel\",G_afstand(D18,C18,F18,E18,0,1)/1000,G_afstand(D18,C18,F18,E18,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G19=\"enkel\",G_reistijd(D19,C19,F19,E19),G_reistijd(D19,C19,F19,E19)*2)","v":"00:00:00"},{"$f":"IF($G19=\"enkel\",G_afstand(D19,C19,F19,E19,0,1)/1000,G_afstand(D19,C19,F19,E19,0,1)*2/1000)","v":0},"km"]
[null,"Woensdag",null,null,null,null,null,{"$f":"IF(G20=\"enkel\",G_reistijd(D20,C20,F20,E20),G_reistijd(D20,C20,F20,E20)*2)","v":"00:00:00"},{"$f":"IF($G20=\"enkel\",G_afstand(D20,C20,F20,E20,0,1)/1000,G_afstand(D20,C20,F20,E20,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G21=\"enkel\",G_reistijd(D21,C21,F21,E21),G_reistijd(D21,C21,F21,E21)*2)","v":"00:00:00"},{"$f":"IF($G21=\"enkel\",G_afstand(D21,C21,F21,E21,0,1)/1000,G_afstand(D21,C21,F21,E21,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G22=\"enkel\",G_reistijd(D22,C22,F22,E22),G_reistijd(D22,C22,F22,E22)*2)","v":"00:00:00"},{"$f":"IF($G22=\"enkel\",G_afstand(D22,C22,F22,E22,0,1)/1000,G_afstand(D22,C22,F22,E22,0,1)*2/1000)","v":0},"km"]
[null,"Donderdag",null,null,null,null,null,{"$f":"IF(G23=\"enkel\",G_reistijd(D23,C23,F23,E23),G_reistijd(D23,C23,F23,E23)*2)","v":"00:00:00"},{"$f":"IF($G23=\"enkel\",G_afstand(D23,C23,F23,E23,0,1)/1000,G_afstand(D23,C23,F23,E23,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G24=\"enkel\",G_reistijd(D24,C24,F24,E24),G_reistijd(D24,C24,F24,E24)*2)","v":"00:00:00"},{"$f":"IF($G24=\"enkel\",G_afstand(D24,C24,F24,E24,0,1)/1000,G_afstand(D24,C24,F24,E24,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G25=\"enkel\",G_reistijd(D25,C25,F25,E25),G_reistijd(D25,C25,F25,E25)*2)","v":"00:00:00"},{"$f":"IF($G25=\"enkel\",G_afstand(D25,C25,F25,E25,0,1)/1000,G_afstand(D25,C25,F25,E25,0,1)*2/1000)","v":0},"km"]
[null,"Vrijdag",null,null,null,null,null,{"$f":"IF(G26=\"enkel\",G_reistijd(D26,C26,F26,E26),G_reistijd(D26,C26,F26,E26)*2)","v":"00:00:00"},{"$f":"IF($G26=\"enkel\",G_afstand(D26,C26,F26,E26,0,1)/1000,G_afstand(D26,C26,F26,E26,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G27=\"enkel\",G_reistijd(D27,C27,F27,E27),G_reistijd(D27,C27,F27,E27)*2)","v":"00:00:00"},{"$f":"IF($G27=\"enkel\",G_afstand(D27,C27,F27,E27,0,1)/1000,G_afstand(D27,C27,F27,E27,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G28=\"enkel\",G_reistijd(D28,C28,F28,E28),G_reistijd(D28,C28,F28,E28)*2)","v":"00:00:00"},{"$f":"IF($G28=\"enkel\",G_afstand(D28,C28,F28,E28,0,1)/1000,G_afstand(D28,C28,F28,E28,0,1)*2/1000)","v":0},"km"]
[null,"Zaterdag",null,null,null,null,null,{"$f":"IF(G29=\"enkel\",G_reistijd(D29,C29,F29,E29),G_reistijd(D29,C29,F29,E29)*2)","v":"00:00:00"},{"$f":"IF($G29=\"enkel\",G_afstand(D29,C29,F29,E29,0,1)/1000,G_afstand(D29,C29,F29,E29,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G30=\"enkel\",G_reistijd(D30,C30,F30,E30),G_reistijd(D30,C30,F30,E30)*2)","v":"00:00:00"},{"$f":"IF($G30=\"enkel\",G_afstand(D30,C30,F30,E30,0,1)/1000,G_afstand(D30,C30,F30,E30,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G31=\"enkel\",G_reistijd(D31,C31,F31,E31),G_reistijd(D31,C31,F31,E31)*2)","v":"00:00:00"},{"$f":"IF($G31=\"enkel\",G_afstand(D31,C31,F31,E31,0,1)/1000,G_afstand(D31,C31,F31,E31,0,1)*2/1000)","v":0},"km"]
[null,"Zondag",null,null,null,null,null,{"$f":"IF(G32=\"enkel\",G_reistijd(D32,C32,F32,E32),G_reistijd(D32,C32,F32,E32)*2)","v":"00:00:00"},{"$f":"IF($G32=\"enkel\",G_afstand(D32,C32,F32,E32,0,1)/1000,G_afstand(D32,C32,F32,E32,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 1)",null,null,null,null,null,{"$f":"IF(G33=\"enkel\",G_reistijd(D33,C33,F33,E33),G_reistijd(D33,C33,F33,E33)*2)","v":"00:00:00"},{"$f":"IF($G33=\"enkel\",G_afstand(D33,C33,F33,E33,0,1)/1000,G_afstand(D33,C33,F33,E33,0,1)*2/1000)","v":0},"km"]
[null,"(naam meerijder 2)",null,null,null,null,null,{"$f":"IF(G34=\"enkel\",G_reistijd(D34,C34,F34,E34),G_reistijd(D34,C34,F34,E34)*2)","v":"00:00:00"},{"$f":"IF($G34=\"enkel\",G_afstand(D34,C34,F34,E34,0,1)/1000,G_afstand(D34,C34,F34,E34,0,1)*2/1000)","v":0},"km"]
[]
[null,null,null,null,"Totaal kilometers",null,null,{"$f":"ROUND(SUM(I14:I34),1)","v":0},null,"km"]
[null,"Voorbeeld:"]
[null,"Maandag","Klein Frankrijk 1","4461 ZN","Hoofdstraat 1","4416 AA","Retour",{"$f":"IF(G38=\"enkel\",G_reistijd(D38,C38,F38,E38),G_reistijd(D38,C38,F38,E38)*2)","v":"00:30:00"},{"$f":"IF($G38=\"enkel\",G_afstand(D38,C38,F38,E38,0,0),G_afstand(D38,C38,F38,E38,0,0)*2)","v":33.799999999999997},"km"]
[null,"Meerijder 1","Hoofdstraat 1","4416 AA","Rooseveltlaan 1","4624 DJ","Retour",{"$f":"IF(G39=\"enkel\",G_reistijd(D39,C39,F39,E39),G_reistijd(D39,C39,F39,E39)*2)","v":"00:36:00"},{"$f":"IF($G39=\"enkel\",G_afstand(D39,C39,F39,E39,0,0),G_afstand(D39,C39,F39,E39,0,0)*2)","v":59.4},"km"]
[null,"Meerijder 2","Rooseveltlaan 1","4624 DJ","Argon 21","4751 XC","Retour",{"$f":"IF(G40=\"enkel\",G_reistijd(D40,C40,F40,E40),G_reistijd(D40,C40,F40,E40)*2)","v":"00:26:00"},{"$f":"IF($G40=\"enkel\",G_afstand(D40,C40,F40,E40,0,0),G_afstand(D40,C40,F40,E40,0,0)*2)","v":36},"km"]

{"sheet":"2","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["VP-039-L",17,null,"Enkel"]
["VP-040-L",17,null,"Retour"]
["VP-348-B",17]
["VP-349-B",17]
["VP-350-B",17]
["VP-783-J",17]
["VP-784-J",17]
["VP-785-J",17]
["VP-926-N",17]
["VP-927-N",17]
["VP-928-N",17]
["VP-929-N",17]
["VP-930-N",17]
["VP-984-G",17]
["VP-985-G",17]
["VP-986-G",17]
["VP-987-G",17]
["VR-456-D",17]
["VR-457-D",17]
["VR-458-D",17]
[]
[null,{"$f":"Kilometerlijst!C8","v":0}]
[null,{"$f":"OR(B22=A1,B22=A2,B22=A3,B22=A4,B22=A5,B22=A6,B22=A7,B22=A8,B22=A9,B22=A10,B22=A11,B22=A12,B22=A13,B22=A14,B22=A15,B22=A16,B22=A17,B22=A18,B22=A19,B22=A20)","v":false}]