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

{"sheet":"Onkostendeclaratie","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[0,1,0,8],[0,9,0,11],[2,2,2,3],[2,4,2,5],[2,6,2,7],[5,2,5,3],[5,6,5,7],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[17,1,17,10],[18,1,18,10],[19,1,19,10],[20,2,20,4],[20,6,20,9]]}
[null,"Bedrijfsnaam",{"$nulls":7},"Alleen voor kantoorgebruik"]
[null,"Onkostendeclaratie"]
[null,"DOEL:",null,null,"NUMMER VAN AFSCHRIFT:",{"$nulls":4},"BETAALPERIODE:","Van",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MIN(Onkosten[Datum])), \"\")","v":""}]
[{"$nulls":10},"Naar",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MAX(Onkosten[Datum])), \"\")","v":""}]
[null,"GEGEVENS VAN WERKNEMER:"]
[null,"Naam",{"$nulls":3},"Positie",{"$nulls":3},"BSN/Werkgever-ID"]
[null,"Afdeling",{"$nulls":3},"Manager",{"$nulls":3},"Werknemer-ID"]
[]
[null,"Datum","Account","Beschrijving","Hotel","Vervoer","Brandstof","Maaltijden","Telefoon","Amusement","Divers","Totaal"]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(Onkosten[[#This Row],[Hotel]:[Divers]]), \"\")","v":0}]
[null,"Totaal",null,null,{"$f":"SUBTOTAL(109,Onkosten[Hotel])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Vervoer])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Brandstof])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Maaltijden])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Telefoon])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Amusement])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Divers])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Totaal])","v":0}]
[null,"Subtotaal",{"$nulls":9},{"$f":"IFERROR(SUM(Onkosten[[#Totals],[Totaal]]), \"\")","v":0}]
[null,"Voorschotten"]
[null,"Totaal",{"$nulls":9},{"$f":"IFERROR((L18-L19), \"\")","v":0}]
[null,"GOEDGEKEURD:",{"$nulls":3},"NOTITIES: "]