{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kilometerlogboek en Onkosten..."],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Kilometerlogboek en Onkosten...","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[null,"Kilometerlogboek en Onkostendeclaratie"]
[]
[null,"Naam van werknemer",null,"Tarief per kilometer",{"v":0.27,"d":"€ 0.27"}]
[null,"Werknemer-ID",null,"Voor periode",{"$f":"\"Til \"&TEXT(MIN(B9:B19),\"d-m-jj\")&\" tot \"&TEXT(MAX(B9:B19),\"d-m-jj\")","v":"Til 4-8-17 tot 5-8-17"}]
[null,"Beschrijving van voertuig",null,"Totaalaantal kilometers",{"$f":"Mileage_Total","v":10}]
[null,"Geautoriseerd door",null,"Totale vergoeding",{"$f":"Reimbursement_Total","v":{"v":2.7,"d":"€ 2.70"}}]
[]
[null,"Datum","Beginlocatie","Bestemming","Beschrijving/Notities","Beginstand kilometerteller","Eindstand kilometerteller","Aantal kilometers","Vergoeding"]
[null,{"$f":"TODAY()","v":"2017-08-04"},"Thuiskantoor","Northwind Traders","Vergadering met klant",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"€ 1.35"}}]
[null,{"$f":"TODAY()+1","v":"2017-08-05"},"Northwind Traders","Thuiskantoor","Vergadering met klant",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"€ 1.35"}}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":7},0,{"v":0,"d":"€ 0.00"}]
[{"$nulls":6},"Totalen",{"$f":"SUBTOTAL(109,Uitgaven[Aantal kilometers])","v":10},{"$f":"SUBTOTAL(109,Uitgaven[Vergoeding])","v":{"v":2.7,"d":"€ 2.70"}}]