{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Declaratie SKBG","GroBo","Kostendrager","Logos","Macrodata"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":"Declaratie SKBG","index":0,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[61,0,61,8],[63,0,63,8],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[55,3,55,5],[59,3,59,5],[58,2,59,2],[57,0,57,2],[58,0,59,1],[44,1,44,5],[45,1,45,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[40,1,40,5],[52,1,52,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[31,1,31,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5],[13,1,13,4],[3,4,3,5],[1,0,1,2],[3,6,3,8],[5,5,5,8],[10,7,10,8],[12,7,12,8],[9,1,9,2],[0,0,0,8],[1,3,1,4],[10,1,10,4],[11,1,11,4],[12,1,12,4]]}
["Dit formulier svp alleen digitaal invullen en niet met de hand geschreven"]
["Selecteer je eigen school :",null,null,"SKBG",null,null,null,null,"Versie 1.101"]
[]
[null,null,null,null,"Declaratiemaand :",null,"Maand"]
[null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Schoolnaam:",{"$f":"D2","v":"SKBG"}]
[null,null,null,null,"Locatienr.:",{"$f":"VLOOKUP(F6,Logos!B2:D20,2,FALSE)","v":1}]
[null,null,null,null,"Vestiging:",{"$f":"VLOOKUP(F6,Logos!B2:E20,3,FALSE)","v":"Warnsveld"}]
[]
["Declarant: ","Maak keuze"]
["Naam:",null,null,null,null,"IBAN Rekeningnummer:"]
["Adres:",null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",IF(IBANcheck(H11)=1,\"\",\"Geen juiste IBAN nr.\"))","v":""}]
["Postcode",null,null,null,null,"Declaratiedatum:",null,{"$f":"NOW()","v":"2019-03-06T14:58:41.590"}]
["Woonplaats:",null,null,null,null,"Betalingskenmerk:",null,{"$f":"\"Declaratie \" &DAY(H13) & \"-\" & MONTH(H13) & \"-\"& YEAR(H13)","v":"Declaratie 6-3-2019"}]
[]
["Datum","Omschrijving van de kosten",null,null,null,null,"Bedrag","Grootboek","Kostendrager"]
[null,"VOG",null,null,null,null,null,416900]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totaal declaratie",null,{"$f":"CONCATENATE(F4,I5,B11)","v":" "},null,{"$f":"SUM(G17:G53)","v":0}]
[]
["Datum declaratie:",null,{"$f":"H13","v":"2019-03-06T14:58:41.590"},"Handtekening declarant",null,null,"Totaal:",null,{"$f":"G54","v":0}]
[]
[]
["Aantal bijlagen:",null,1]
[null,null,null,"Aldus naar waarheid ingevuld"]
[]
[{"$f":"IF(Inlevermaand=\"Maand\",\"\",\"De uiterlijke inlevertermijn van deze declaratie bedraagt 1 maand na afloop van de maand \" & Inlevermaand &\" \" & YEAR(H13)&\"!\")","v":""}]
["Declaraties zonder bon of betaalbewijs kunnen niet in behandeling worden genomen!"]
["Zorg bij aankopen via internet altijd voor een factuur of een schermafdruk van de overeengekomen prijs!"]

{"sheet":"GroBo","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Meest voorkomende grootboekrekeningen"]
["Rek.nr.","Omschrijving"]
[414000,"Nascholing"]
[416900,"Overige personele lasten"]
[416950,"Werkkostenregeling"]
[433000,"Dagelijks onderhoud"]
[437000,"Tuinonderhoud en binnenplanten"]
[442000,"Drukwerk / kopieerkosten"]
[442210,"Kleine aansch. invent/ict <€500"]
[442300,"Kantoorbenodigdheden"]
[446200,"Abonnementen/lectuur/contributies"]
[447000,"Representatiekosten"]
[447100,"Wervingskosten leerlingen"]
[447400,"Activiteiten"]
[447500,"Kosten school jubileum - feest school"]
[448000,"Medezeggenschap"]
[449700,"Huishoudelijke uitgaven"]
[449900,"Overige kosten"]
[455000,"Onderwijsleerpakket verbruik"]
[455200,"Culturele vorming/muziekimpuls"]

{"sheet":"Kostendrager","index":2,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Verb. code","Code verbijzondering"]
["04TU","De Hoge Voorde"]
["05CP","St. Joseph"]
["05EF","Martinus"]
["05EG","De Kopermolen"]
["05JW","St. Martinus"]
["06HV","St. Jozef A"]
["06KK","Daltonschool Willibrordus"]
["06PP","Oecumenische BS"]
["07SQ","De Kleine Wereld"]
["07SY","De Vlier"]
["08ZC","St. Jozef W"]
["10XB","John F. Kennedy"]
["11WI","Walter Gillijnsschool"]
["12FW","De Achtsprong"]
["12OX","De Scheperstee"]
["14ZA","Antonius"]
["AH13","Bestuursbureau"]
["CENTRAAL","Centraal Budget"]
["Fusie","Fusie uitg steunstichting"]
["MU","Muziekimpls"]
["NB","Nieuwbouw"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PO","Passend Onderwijs"]
["TSK","Taalschakelklas"]
["WKR","Werkostenregeling"]

{"sheet":"Logos","index":3,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["BRIN","School","BRIN","Plaats"]
[1,"SKBG",1,"Warnsveld"]
["04TU","De Hoge Voorde","04TU","Vorden"]
["05CP","St. Joseph","05CP","Lochem"]
["05EF","Martinus","05EF","Twello"]
["05EG","De Kopermolen","05EG","Klarenbeek"]
["05JW","St. Martinus","05JW","Bussloo"]
["06HV","St. Jozef A","06HV","Aalten"]
["06KK","Daltonschool Willibrordus","06KK","Ruurlo"]
["06PP","Oecumenische BS","06PP","Brummen"]
["07SQ","De Kleine Wereld","07SQ","Twello"]
["07SY","De Vlier","07SY","Winterswijk"]
["08ZC","St. Jozef W","08ZC","Winterswijk"]
["10XB","John F. Kennedy","10XB","Zutphen"]
["11WI","Walter Gillijnsschool","11WI","Zutphen"]
["12FW","De Achtsprong","12FW","Zutphen"]
["12OX","De Scheperstee","12OX","Warnsveld"]
["14ZA","Antonius","14ZA","De Vecht"]
["AH13","Bestuursbureau","AH13","Warnsveld"]
["CENTRAAL","Centraal Budget","CENTRAAL","Warnsveld"]
[]
[]
[]
[]
[]
[]
["Maand",null,"Maand","Maak keuze"]
["Januari",null,"Januari","Ouder"]
["Februari",null,"Februari","OP"]
["Maart",null,"Maart","OOP"]
["April",null,"April"]
["Mei",null,"Mei"]
["Juni",null,"Juni"]
["Juli",null,"Juli"]
["Augustus",null,"Augustus"]
["September",null,"September"]
["Oktober",null,"Oktober"]
["November",null,"November"]
["December",null,"December"]

{"sheet":"Macrodata","index":4,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Declaratie SKBG'!D2","v":"SKBG"}]
[{"$f":"IF(A1=\"SKBG\",1,2)","v":1}]
[null,null,null,null,null,"Dit is de beveiliging voor het werkblad en we proberen daar wat heel moois van te maken"]