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

{"sheet":"Onkostendeclaratie","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["BEDRIJFSNAAM"]
["ONKOSTENDECLARATIE"]
[]
[null,"WERKNEMER:","Pascaline Overeem",{"$nulls":3},"GEAUTORISEERD DOOR:"]
[null,"AFDELING:","Verkoop"]
[null,"WEEKEINDE:","2013-03-07",{"$nulls":3},"DATUM:"]
[null,"KILOMETERTARIEF:",{"v":0.67,"d":"€ 0.67"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"VRIJDAG"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"ZATERDAG"},"ZONDAG","MAANDAG","DINSDAG","WOENSDAG","DONDERDAG"]
[null,"VERVOER",{"$f":"WeekEindigendOp-6","v":"2013-03-01"},{"$f":"WeekEindigendOp-5","v":"2013-03-02"},{"$f":"WeekEindigendOp-4","v":"2013-03-03"},{"$f":"WeekEindigendOp-3","v":"2013-03-04"},{"$f":"WeekEindigendOp-2","v":"2013-03-05"},{"$f":"WeekEindigendOp-1","v":"2013-03-06"},{"$f":"WeekEindigendOp","v":"2013-03-07"},"TOTAAL"]
[null,"Afgelegde kilometers",{"v":145,"d":"145 "},{"$nulls":6},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":145,"d":"145 "}}]
[null,"Kilometervergoeding",{"$f":"C11*Kilometervergoeding","v":{"v":97.15,"d":"€ 97.15"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":97.15,"d":"€ 97.15"}}]
[null,"Parkeergeld en tol",{"$nulls":3},{"v":17,"d":"€ 17.00"},{"$nulls":3},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":17,"d":"€ 17.00"}}]
[null,"Autohuur",{"v":79,"d":"€ 79.00"},null,null,{"v":79,"d":"€ 79.00"},{"$nulls":3},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":158,"d":"€ 158.00"}}]
[null,"Taxi/limo",{"$nulls":7},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Overige (trein of bus)",{"$nulls":7},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Vliegtickets",{"$nulls":3},{"v":235,"d":"€ 235.00"},{"$nulls":3},{"$f":"SUM(vervoer[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":235,"d":"€ 235.00"}}]
[null,"TOTAAL",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"€ 176.15"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"€ 0.00"}},null,{"v":331,"d":"€ 331.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":507.15,"d":"€ 507.15"}]
[]
[null,"ACCOMMODATIE EN MAALTIJDEN"]
[null,"Accommodatie",{"v":145,"d":"€ 145.00"},{"$nulls":6},{"$f":"SUM(OvernachtingenMaaltijden[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":145,"d":"€ 145.00"}}]
[null,"Ontbijt",{"v":11.49,"d":"€ 11.49"},{"$nulls":6},{"$f":"SUM(OvernachtingenMaaltijden[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":11.49,"d":"€ 11.49"}}]
[null,"Lunch",{"v":12,"d":"€ 12.00"},{"$nulls":6},{"$f":"SUM(OvernachtingenMaaltijden[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":12,"d":"€ 12.00"}}]
[null,"Diner",{"v":17,"d":"€ 17.00"},{"$nulls":6},{"$f":"SUM(OvernachtingenMaaltijden[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":17,"d":"€ 17.00"}}]
[null,"Snack",{"$f":"C24*Kilometervergoeding","v":{"v":11.39,"d":"€ 11.39"}},{"$nulls":6},{"$f":"SUM(OvernachtingenMaaltijden[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":11.39,"d":"€ 11.39"}}]
[null,"Subtotaal maaltijden",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"€ 40.49"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"$f":"SUM(OvernachtingenMaaltijden[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":40.49,"d":"€ 40.49"}}]
[null,"TOTAAL",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"€ 185.49"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":185.49,"d":"€ 185.49"}]
[]
[null,"DIVERSEN"]
[null,"Benodigdheden",{"$nulls":7},{"$f":"SUM(Diversen[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Apparatuur",{"$nulls":7},{"$f":"SUM(Diversen[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Telefoon, fax, internet",{"$nulls":7},{"$f":"SUM(Diversen[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Overige",{"$nulls":7},{"$f":"SUM(Diversen[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":0,"d":"€ 0.00"}}]
[null,"Entertainment*",{"$nulls":3},{"v":199,"d":"€ 199.00"},{"$nulls":3},{"$f":"SUM(Diversen[[#This Row],[Dag 1]:[Dag 7]])","v":{"v":199,"d":"€ 199.00"}}]
[null,"TOTAAL",{"$f":"SUBTOTAL(109,Diversen[Dag 1])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Diversen[Dag 2])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Diversen[Dag 3])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Diversen[Dag 4])","v":{"v":199,"d":"€ 199.00"}},{"$f":"SUBTOTAL(109,Diversen[Dag 5])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Diversen[Dag 6])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Diversen[Dag 7])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUBTOTAL(109,Diversen[Totaal])","v":{"v":199,"d":"€ 199.00"}}]
[]
[null,"EINDTOTAAL",{"$f":"SUM(Diversen[[#Totals],[Dag 1]],OvernachtingenMaaltijden[[#Totals],[Dag 1]],vervoer[[#Totals],[Dag 1]])","v":{"v":361.64,"d":"€ 361.64"}},{"$f":"SUM(Diversen[[#Totals],[Dag 2]],OvernachtingenMaaltijden[[#Totals],[Dag 2]],vervoer[[#Totals],[Dag 2]])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(Diversen[[#Totals],[Dag 3]],OvernachtingenMaaltijden[[#Totals],[Dag 3]],vervoer[[#Totals],[Dag 3]])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(Diversen[[#Totals],[Dag 4]],OvernachtingenMaaltijden[[#Totals],[Dag 4]],vervoer[[#Totals],[Dag 4]])","v":{"v":530,"d":"€ 530.00"}},{"$f":"SUM(Diversen[[#Totals],[Dag 5]],OvernachtingenMaaltijden[[#Totals],[Dag 5]],vervoer[[#Totals],[Dag 5]])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(Diversen[[#Totals],[Dag 6]],OvernachtingenMaaltijden[[#Totals],[Dag 6]],vervoer[[#Totals],[Dag 6]])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(Diversen[[#Totals],[Dag 7]],OvernachtingenMaaltijden[[#Totals],[Dag 7]],vervoer[[#Totals],[Dag 7]])","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(Diversen[[#Totals],[Totaal]],OvernachtingenMaaltijden[[#Totals],[Totaal]],vervoer[[#Totals],[Totaal]])","v":{"v":891.64,"d":"€ 891.64"}}]
[]
[{"$nulls":9},"TOTALE KOSTEN"]
[null,"*Zakelijk doeleinde van items van het type Entertainment en Overige:",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"€ 891.64"}}]
[{"$nulls":9},"VOORSCHOTTEN"]
[]
[{"$nulls":9},"TOTALE VERGOEDING"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"€ 891.64"}}]
[{"$nulls":9},"Voeg alle ontvangstbewijzen toe."]