{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Onkostendeclaratie"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Onkostendeclaratie","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Onkostendeclaratie reiskosten"]
[]
[null,"Naam","Ariette de Crom","Geautoriseerd door",null,null,"Roelf Neumann",null,"Kilometervergoeding",null,null,{"v":0.32,"d":"€ 0.32"}]
[]
[null,"Afdeling","Verkoop","Datum ingediend",null,null,{"$f":"TODAY()","v":"2018-01-19"},null,"Totale vergoeding",null,null,{"$f":"Totalevergoeding","v":{"v":550.3846011865525,"d":"€ 550.38"}}]
[]
[null,"Periode",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"d-m-jj\"),\"Van \"&TEXT(MIN(B10:B13),\"d-m-jj\")&\" naar \"&TEXT(MAX(B10:B13),\"d-m-jj\"))","v":"Van 20-12-17 naar 25-12-17"}]
[]
[null,"Datum","Beschrijving van kosten","Vliegtickets","Overnachting","Weg- \nvervoer \n(benzine, huurauto, taxi)","Maaltijden en fooien","Vergaderingen en cursussen","Kilometers","Kilometervergoeding","Diversen","Wisselkoers","Onkostenvaluta","Totaal"]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Reis naar kantoor klant",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF(Onkostendeclaratie!I10<>\"\",Onkostendeclaratie!I10*MileageRate,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":1.517,"d":"1.52"},"CAD",{"$f":"IFERROR(IF(OR(Onkostendeclaratie!$L10=\"\",Onkostendeclaratie!$L10=1),SUM(Onkostendeclaratie!$J10:$K10,Onkostendeclaratie!$D10:$H10)*1,SUM(Onkostendeclaratie!$J10:$K10,Onkostendeclaratie!$D10:$H10)/Onkostendeclaratie!$L10),\"\")","v":{"v":407.5148319050759,"d":"€ 407.51"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-20"},"Lunch met klant",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF(Onkostendeclaratie!I11<>\"\",Onkostendeclaratie!I11*MileageRate,\"\")","v":3.84},null,{"v":1.517,"d":"1.52"},"CAD",{"$f":"IFERROR(IF(OR(Onkostendeclaratie!$L11=\"\",Onkostendeclaratie!$L11=1),SUM(Onkostendeclaratie!$J11:$K11,Onkostendeclaratie!$D11:$H11)*1,SUM(Onkostendeclaratie!$J11:$K11,Onkostendeclaratie!$D11:$H11)/Onkostendeclaratie!$L11),\"\")","v":{"v":18.5497692814766,"d":"€ 18.55"}}]
[null,"2017-12-20","Middagcursus",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF(Onkostendeclaratie!I12<>\"\",Onkostendeclaratie!I12*MileageRate,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR(Onkostendeclaratie!$L12=\"\",Onkostendeclaratie!$L12=1),SUM(Onkostendeclaratie!$J12:$K12,Onkostendeclaratie!$D12:$H12)*1,SUM(Onkostendeclaratie!$J12:$K12,Onkostendeclaratie!$D12:$H12)/Onkostendeclaratie!$L12),\"\")","v":{"v":101.92,"d":"€ 101.92"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-25"},"Reis naar vliegveld",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF(Onkostendeclaratie!I13<>\"\",Onkostendeclaratie!I13*MileageRate,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"EUR",{"$f":"IFERROR(IF(OR(Onkostendeclaratie!$L13=\"\",Onkostendeclaratie!$L13=1),SUM(Onkostendeclaratie!$J13:$K13,Onkostendeclaratie!$D13:$H13)*1,SUM(Onkostendeclaratie!$J13:$K13,Onkostendeclaratie!$D13:$H13)/Onkostendeclaratie!$L13),\"\")","v":{"v":22.400000000000002,"d":"€ 22.40"}}]
[null,"Totaal",null,{"$f":"SUBTOTAL(109,Onkosten[Vliegtickets])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Onkosten[Overnachting])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Onkosten[Weg- \nvervoer \n(benzine, huurauto, taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Onkosten[Maaltijden en fooien])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Onkosten[Vergaderingen en cursussen])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Onkosten[Kilometers])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Onkosten[Kilometervergoeding])","v":39.36},{"$f":"SUBTOTAL(109,Onkosten[Diversen])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Onkosten[Totaal])","v":{"v":550.3846011865525,"d":"€ 550.38"}}]