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

{"sheet":"ONKOSTENDECLARATIE","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[2,2,2,3],[2,5,2,6],[4,2,4,3],[4,6,4,7],[4,10,4,11],[5,2,5,3],[5,6,5,7],[5,10,5,11],[21,2,21,4],[21,6,21,8],[22,2,22,4],[22,6,22,8]]}
[]
[]
[null,"Doel:",null,null,"Afschriftnummer:",null,null,"Betalingsperiode","van:",{"$f":"IF(COUNTA(ExpenseData[Datum])=0,\"\",MIN(ExpenseData[Datum]))","v":""},"aan:",{"$f":"IF(COUNTA(ExpenseData[Datum])=0,\"\",MAX(ExpenseData[Datum]))","v":""}]
[null,"Gegevens van werknemers:"]
[null,"Naam",{"$nulls":3},"Positie",{"$nulls":3},"BSN"]
[null,"Afdeling",{"$nulls":3},"Manager",{"$nulls":3},"Werknemer-ID"]
[]
[null,"Datum","Account","Omschrijving","Hotel","Vervoer","Brandstof","Maaltijden","Telefoon","Entertainment","Div.","Totaal"]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[Hotel]:[Div.]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Totaal",null,null,{"$f":"SUBTOTAL(109,ExpenseData[Hotel])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Vervoer])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Brandstof])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Maaltijden])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Telefoon])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Entertainment])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Div.])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[Totaal])","v":{"v":0,"d":"€ 0.00"}}]
[{"$nulls":10},"SUBTOTAAL",{"$f":"ExpenseData[[#Totals],[Totaal]]","v":{"v":0,"d":"€ 0.00"}}]
[null,"Goedgekeurd:",{"$nulls":3},"Notities: ",{"$nulls":4},"VOORSCHOTTEN",{"v":0,"d":"€ 0.00"}]
[{"$nulls":10},"TOTAAL",{"$f":"Subtotaal-Voorschotten","v":{"v":0,"d":"€ 0.00"}}]