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

{"sheet":"Onkostendeclaratie","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,5,3,6],[3,9,3,10],[4,2,4,3],[4,5,4,6],[4,9,4,10],[5,2,5,3],[5,5,5,6],[5,9,5,10],[6,2,6,3],[6,5,6,6],[6,9,6,10],[7,9,7,10]]}
[null,"ONKOSTENDECLARATIE"]
[null,"CONTOSO, LTD"]
[null,"123 South Main Street, North Buffalo, NY 12345"]
[null,"TELEFOON",4255550121,null,"NAAM","Ariette de Crom",null,null,"DOEL","Jaarlijks verkoopcongres",null,"KILOMETERVERGOEDING",{"v":0.5,"d":"€ 0.50/kilometer"}]
[null,"FAX",4255550122,null,"AFDELING","Verkoop",null,null,"BEGIN",{"$f":"IFERROR(MIN(Onkosten[DATUM]),\"\")","v":"2018-06-04"},null,"MAALTIJDVERGOEDING",{"v":30,"d":"€ 30.00/dag"}]
[null,"E-MAIL","info@contoso.com",null,"POSITIE","Algemeen directeur",null,null,"EINDE",{"$f":"IFERROR(MAX(Onkosten[DATUM]),\"\")","v":"2018-07-04"},null,"HOTELVERGOEDING",{"v":200,"d":"€ 200.00/nacht"}]
[null,"WEB","www.contoso.com",null,"MANAGER","Michael Tucker",null,null,"VOORBEREID DOOR","Ariette de Crom",null,"TELEFOONVERGOEDING",{"v":10,"d":"€ 10.00/dag"}]
[{"$nulls":8},"GOEDGEKEURD DOOR","Michael Tucker",null,"VERGOEDING DIVERSEN",{"v":50,"d":"€ 50.00/dag"}]
[]
[null,"DATUM","ACCOUNT","OMSCHRIJVING","HOTEL","VERVOER","MAALTIJDEN","TELEFOON","DIVERSEN","KILOMETERTELLER \nBEGINSTAND","KILOMETERTELLER \nEINDSTAND","TOTALE \nKILOMETERKOSTEN","TOTAAL "]
[null,{"$f":"TODAY()","v":"2018-06-04"},"Verkoop","Kilometers",{"$nulls":4},{"v":50,"d":"€ 50.00"},{"v":11378.5,"d":"11,378.5 kilometer"},{"v":11456.2,"d":"11,456.2 kilometer"},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":{"v":38.850000000000364,"d":"€ 38.85"}},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":{"v":88.85000000000036,"d":"€ 88.85"}}]
[null,{"$f":"TODAY()+30","v":"2018-07-04"},"Verkoop","Congres",{"v":445,"d":"€ 445.00"},{"v":225,"d":"€ 225.00"},{"v":20,"d":"€ 20.00"},null,{"v":5,"d":"€ 5.00"},{"v":11500,"d":"11,500.0 kilometer"},{"v":11560,"d":"11,560.0 kilometer"},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":{"v":30,"d":"€ 30.00"}},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":{"v":725,"d":"€ 725.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]:[KILOMETERTELLER \nEINDSTAND]])=2,(Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*MileageRate,\"\")","v":""},{"$f":"IF(COUNTA(Onkosten[[#This Row],[DATUM]:[KILOMETERTELLER \nEINDSTAND]])=0,\"\",SUM(Onkosten[[#This Row],[HOTEL]:[VERVOER]],Onkosten[[#This Row],[MAALTIJDEN]:[DIVERSEN]],((Onkosten[[#This Row],[KILOMETERTELLER \nEINDSTAND]]-Onkosten[[#This Row],[KILOMETERTELLER \nBEGINSTAND]])*(MileageRate))))","v":""}]
[null,"TOTALEN",null,null,{"$f":"SUBTOTAL(109,Onkosten[HOTEL])","v":{"v":445,"d":"€ 445.00"}},{"$f":"SUBTOTAL(109,Onkosten[VERVOER])","v":{"v":225,"d":"€ 225.00"}},{"$f":"SUBTOTAL(109,Onkosten[MAALTIJDEN])","v":{"v":20,"d":"€ 20.00"}},{"$f":"SUBTOTAL(109,Onkosten[TELEFOON])","v":0},{"$f":"SUBTOTAL(109,Onkosten[DIVERSEN])","v":{"v":55,"d":"€ 55.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,Onkosten[[TOTAAL ]])","v":{"v":813.8500000000004,"d":"€ 813.85"}}]
[{"$nulls":11},"VOORSCHOTTEN",{"v":0,"d":"€ 0.00"}]
[{"$nulls":11},"TOTAAL",{"$f":"Onkosten[[#Totals],[TOTAAL ]]-Voorschotten","v":{"v":813.8500000000004,"d":"€ 813.85"}}]