{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Voorblad","Home","Eigen declaraties","Reiskostendeclaraties","Rapportage","Instellingen"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Voorblad","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,1,6,5]]}
[]
[]
[]
[null,"Werkt de bovenstaande knop niet, dan moet je eerst de onderstaande stappen doorlopen om de macro's te deblokkeren."]
[]
[null,"Dit bestand bevat macro's"]
[null,"In nieuwere versies van Excel is door Microsoft een extra beveiliging geplaatst op het openen van bestanden met macro’s. \nNaast dat macro's erg nuttig kunnen zijn worden ze ook misbruikt voor malware en ransomware. Door de macro's standaard te blokkeren wil Microsoft de strijd aan gaan tegen cybercriminaliteit."]
[null,"Dit Exceldocument bevat macro's om een goede werking van het bestand te garanderen. Deblokkeren van het bestand doet u als volgt:"]
[]
[null,"Stap 1. Blokkade opheffen",null,null,"Stap 2. Macro's inschakelen"]
[null,"a.","U moet het bestand opslaan op een lokale harde schijf (of OneDrive). ",null,"Nadat je de blokkering van het Excelbestand hebt opgeheven, is het (vaak) ook nog nodig om de macro’s in te schakelen."]
[null,"b.","Open Windows Verkenner en zoek het bestand op. "]
[null,"c.","Klik vervolgens met de rechtermuisknop op het bestand en kies Eigenschappen in het contextmenu. \nOnderaan het tabblad Algemeen ziet u een sectie Beveiliging. Schakel het selectievakje Blokkering opheffen in. \n",null,"a.","Dit zie je doordat je een pop-up krijgt met de melding: ‘Microsoft Office heeft een mogelijk beveiligingsprobleem geïdentificeerd.’ of door een gele balk bovenin je Excelbestand met daarin de tekst: ‘BEVEILIGINGSWAARSCHUWING \nMacro’s zijn uitgeschakeld.’ Zie ook afbeeldingen 2 en 3."]
[null,null,"En klik op OK. Zie ook afbeelding 1",null,"b.","In deze gevallen kun je de macro’s inschakelen door op de knop ‘Macro’s inschakelen’ te klikken in het pop-up scherm, of \nop de knop ‘Inhoud inschakelen’ in de gele balk"]
[null,null,"Wanneer u nu het bestand (opnieuw) opent zullen de macro's in het bestand werkzaam zijn."]
[null,null,"Afbeelding 1",null,null,"Afbeelding 2                                                                                                    Afbeelding 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Deze handleiding is ook terug te lezen via deze link."]

{"sheet":"Home","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Het wachtwoord voor de beheerder is \"beheer\" (deze tekst graag verwijderen vóór in gebruikname van het document!)."]

{"sheet":"Eigen declaraties","index":2,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Declaratienr.","Naam","Email","Bedrijfsonderdeel","Reisdoel","Locatie","Datum","Kostentype","Afstand (km)","Kosten (euro)","Bon","Status","Goedgekeurd bedrag","Goedgekeurd door"]

{"sheet":"Reiskostendeclaraties","index":3,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Declaratienr.","Naam","Email","Bedrijfsonderdeel","Reisdoel","Locatie","Datum","Kostentype","Afstand (km)","Kosten (euro)","Bon","Status","Goedgekeurd bedrag","Goedgekeurd door"]

{"sheet":"Rapportage","index":4,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"Gedeclareerde reiskosten per bedrijfsonderdeel en status"]
[null,null,null,"Status"]
[null,null,"Bedrijfsonderdeel",{"$f":"Instellingen!AA7","v":"Ingevoerd"},{"$f":"Instellingen!AA8","v":"Gewijzigd"},{"$f":"Instellingen!AA9","v":"In behandeling"},{"$f":"Instellingen!AA10","v":"Goedgekeurd"},{"$f":"Instellingen!AA11","v":"Afgewezen"},"Verwijderd","Totaal"]
[null,null,{"$f":"IF(Instellingen!$K7=\"\",\"\",Instellingen!$K7)","v":""},{"$f":"IF($C9=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C9,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C9=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C9,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C9=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C9,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C9=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C9,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C9=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C9,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C9=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C9,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},{"$f":"IF(C9=\"\",\"\",SUM(D9:I9))","v":""}]
[null,null,{"$f":"IF(Instellingen!$K8=\"\",\"\",Instellingen!$K8)","v":""},{"$f":"IF($C10=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C10,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C10=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C10,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C10=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C10,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C10=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C10,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C10=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C10,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C10=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C10,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},{"$f":"IF(C10=\"\",\"\",SUM(D10:I10))","v":""}]
[null,null,{"$f":"IF(Instellingen!$K9=\"\",\"\",Instellingen!$K9)","v":""},{"$f":"IF($C11=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C11,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C11=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C11,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C11=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C11,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C11=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C11,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C11=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C11,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C11=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C11,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},{"$f":"IF(C11=\"\",\"\",SUM(D11:I11))","v":""}]
[null,null,{"$f":"IF(Instellingen!$K10=\"\",\"\",Instellingen!$K10)","v":""},{"$f":"IF($C12=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C12,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C12=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C12,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C12=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C12,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C12=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C12,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C12=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C12,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C12=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C12,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},{"$f":"IF(C12=\"\",\"\",SUM(D12:I12))","v":""}]
[null,null,{"$f":"IF(Instellingen!$K11=\"\",\"\",Instellingen!$K11)","v":""},{"$f":"IF($C13=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C13,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C13=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C13,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C13=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C13,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C13=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C13,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C13=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C13,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C13=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C13,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},{"$f":"IF(C13=\"\",\"\",SUM(D13:I13))","v":""}]
[null,null,{"$f":"IF(Instellingen!$K12=\"\",\"\",Instellingen!$K12)","v":""},{"$f":"IF($C14=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C14,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C14=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C14,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C14=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C14,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C14=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C14,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C14=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C14,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C14=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C14,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K13=\"\",\"\",Instellingen!$K13)","v":""},{"$f":"IF($C15=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C15,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C15=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C15,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C15=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C15,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C15=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C15,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C15=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C15,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C15=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C15,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K14=\"\",\"\",Instellingen!$K14)","v":""},{"$f":"IF($C16=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C16,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C16=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C16,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C16=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C16,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C16=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C16,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C16=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C16,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C16=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C16,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K15=\"\",\"\",Instellingen!$K15)","v":""},{"$f":"IF($C17=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C17,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C17=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C17,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C17=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C17,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C17=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C17,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C17=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C17,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C17=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C17,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K16=\"\",\"\",Instellingen!$K16)","v":""},{"$f":"IF($C18=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C18,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C18=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C18,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C18=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C18,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C18=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C18,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C18=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C18,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C18=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C18,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K17=\"\",\"\",Instellingen!$K17)","v":""},{"$f":"IF($C19=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C19,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C19=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C19,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C19=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C19,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C19=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C19,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C19=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C19,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C19=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C19,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K18=\"\",\"\",Instellingen!$K18)","v":""},{"$f":"IF($C20=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C20,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C20=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C20,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C20=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C20,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C20=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C20,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C20=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C20,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C20=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C20,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K19=\"\",\"\",Instellingen!$K19)","v":""},{"$f":"IF($C21=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C21,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C21=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C21,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C21=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C21,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C21=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C21,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C21=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C21,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C21=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C21,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K20=\"\",\"\",Instellingen!$K20)","v":""},{"$f":"IF($C22=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C22,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C22=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C22,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C22=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C22,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C22=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C22,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C22=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C22,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C22=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C22,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K21=\"\",\"\",Instellingen!$K21)","v":""},{"$f":"IF($C23=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C23,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C23=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C23,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C23=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C23,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C23=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C23,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C23=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C23,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C23=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C23,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K22=\"\",\"\",Instellingen!$K22)","v":""},{"$f":"IF($C24=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C24,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C24=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C24,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C24=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C24,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C24=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C24,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C24=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C24,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C24=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C24,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K23=\"\",\"\",Instellingen!$K23)","v":""},{"$f":"IF($C25=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C25,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C25=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C25,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C25=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C25,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C25=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C25,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C25=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C25,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C25=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C25,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K24=\"\",\"\",Instellingen!$K24)","v":""},{"$f":"IF($C26=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C26,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C26=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C26,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C26=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C26,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C26=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C26,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C26=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C26,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C26=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C26,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K25=\"\",\"\",Instellingen!$K25)","v":""},{"$f":"IF($C27=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C27,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C27=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C27,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C27=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C27,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C27=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C27,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C27=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C27,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C27=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C27,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K26=\"\",\"\",Instellingen!$K26)","v":""},{"$f":"IF($C28=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C28,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C28=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C28,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C28=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C28,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C28=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C28,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C28=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C28,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C28=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C28,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K27=\"\",\"\",Instellingen!$K27)","v":""},{"$f":"IF($C29=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C29,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C29=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C29,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C29=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C29,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C29=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C29,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C29=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C29,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C29=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C29,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K28=\"\",\"\",Instellingen!$K28)","v":""},{"$f":"IF($C30=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C30,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C30=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C30,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C30=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C30,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C30=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C30,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C30=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C30,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C30=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C30,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K29=\"\",\"\",Instellingen!$K29)","v":""},{"$f":"IF($C31=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C31,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C31=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C31,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C31=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C31,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C31=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C31,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C31=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C31,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C31=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C31,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},""]
[null,null,{"$f":"IF(Instellingen!$K30=\"\",\"\",Instellingen!$K30)","v":""},{"$f":"IF($C32=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C32,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!D$8))","v":""},{"$f":"IF($C32=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C32,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!E$8))","v":""},{"$f":"IF($C32=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C32,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!F$8))","v":""},{"$f":"IF($C32=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C32,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!G$8))","v":""},{"$f":"IF($C32=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C32,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!H$8))","v":""},{"$f":"IF($C32=\"\",\"\",SUMIFS(Reiskostendeclaraties!$J$7:$J$5000,Reiskostendeclaraties!$D$7:$D$5000,Rapportage!$C32,Reiskostendeclaraties!$L$7:$L$5000,Rapportage!I$8))","v":""},{"$f":"IF(C32=\"\",\"\",SUM(D32:I32))","v":""}]
[null,null,"Totaal",{"$f":"SUM(D9:D32)","v":0},0,0,0,0,0,0]

{"sheet":"Instellingen","index":5,"n_rows":14,"n_cols":31,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Naam",null,null,null,"E-mail",null,null,null,"Bedrijfsonderdeel",null,null,null,"Kostentype",null,null,null,"Vergoeding per km (euro)",null,null,null,"Bon",null,null,null,"Status",null,null,null,"Naam beheerder"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eigen vervoer",null,null,null,null,null,null,null,"Aanwezig",null,null,null,"Ingevoerd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Openbaar vervoer ",null,null,null,null,null,null,null,"Afwezig",null,null,null,"Gewijzigd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overig vervoer",null,null,null,null,null,null,null,null,null,null,null,"In behandeling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accommodatie",null,null,null,null,null,null,null,null,null,null,null,"Goedgekeurd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maaltijden",null,null,null,null,null,null,null,null,null,null,null,"Afgewezen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Representatie",null,null,null,null,null,null,null,null,null,null,null,"Verwijderd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Registratie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overig"]