{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Uitleg","Totaaloverzicht","Geldchecker","Budget berekenen","Budget verdelen","Uitgaven","Inkomsten"],"not_rendered":{"charts":1,"images":24,"macros":1,"external_links":0,"defined_names":0,"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":"Uitleg","index":0,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[[22,0,22,9],[31,0,31,9],[28,0,28,9],[25,0,25,9],[0,0,2,9],[34,0,34,9],[15,0,15,9],[12,0,12,9],[9,0,9,9],[6,0,6,9],[19,0,19,9]]}
["S V M V"]
[]
[]
[]
["Hi,"]
[]
["Leuk dat je mijn excel document waarin ik mijn financiële administratie bijhoud, hebt gedownload! Dit document bestaat uit een aantal onderdelen, die elk los van elkaar behandeld worden in de uitleg. Verder zijn alle items met elkaar gelinkt. Let dus op dat er alleen gegevens ingevuld worden waar nodig."]
[]
["Het idee"]
["Het idee achter deze administratie,is dat er gewerkt wordt met 'potjes'. Zoals al eerder op mijn blog uitgelegd, maak ik gebruik van verschillende potjes. Elk met een eigen doel en prioriteit. In het voorbeelddocument heb ik een aantal potjes benoemd. Dit is op zich een goede basis, maar voel je vooral vrij zelf aan te passen. Let op dat je bij het gebruik van deze administratie, alleen gegevens invuld bij de groengekleurde velden. Uitzondering hierop zijn de tabs budget berekenen, inkomsten en uitgaven. "]
[]
["Totaaloverzicht"]
["In het tab 'totaaloverzicht' is het overzicht opgenomen van al jouw uitgaven, inkomsten en hoeveel er in jouw potjes zit. In deze tab pas je eigenlijk maar 1 ding aan: de titels van de potjes. Op het moment dat de naam wijzigd, zal dit doorvloeien door heel het document."]
[]
["Geldchecker"]
["Het is belangrijk om te zien of je wel alle uitgaven genoteerd hebt. Daarom is er de geldchecker. Hierin vul je alle saldo's in van je rekeningen en de inhoud van je portomenee. Deze worden vergeleken met wat er in zou moeten zitten. Is er een verschil, dan wordt aangegeven hoe groot dat verschil is en wat voor verschil er is. Mijn advies is om je inkomsten en uitgaven zo snel mogelijk erin te zetten, zodat je ze vervolgens weer kan vergeten. Een extra kolom is aangemaakt voor wat gelden 'buiten de boeken'. Die gebruik ik zelf als ik bijvoorbeeld een fysieke spaarpot met een bijbehorend doel open heb gemaakt. Ik wil niet dat dit geld op de grote hoop komt. Hiermee wordt het mogelijk deze gelden wel op te nemen, zodat je daar geen verschil mee krijgt."]
[]
["Budget berekenen"]
[]
["Het klinkt heel vanzelfsprekend. Hier vul je de verschillende kostenposten in en het bijbehorende bedrag. De totalen per pot worden automatisch uitgerekend. Verder is er een maximum bedrag aangemaakt wat er in de pot mag zitten. Niks invullen betekend geen limiet (handig voor de spaarpot), maar bijvoorbeeld voor kleding is het onnodig om meer dan 1000 euro daarin te hebben zitten per persoon. Verder hou ik zelf aan dat mijn zorgverzekering 10% duurder wordt en mijn vaste lasten jaarlijks met 2% stijgen. Dit wordt al meegenomen bij deze berekening. "]
[]
["Budget verdelen"]
["Een klein tabje die wordt gebruikt aan het einde van de maand om alle potjes weer bij te vullen. Hier wordt ook aangegeven of je wel genoeg inkomsten hebt gehad om alle gebudgeteerde kosten op te kunnen vangen. Daaronder is een regel aangebracht voor een handmatige + / -. Bijvoorbeeld handig als je geld terug hebt gekregen van de energiemaatschappij en je dit graag terug wilt stoppen in die pot. Bij deze verdeling wordt rekening gehouden met de maximum inhoud van een pot. Als deze is bereikt, zal hij niet extra bijgevuld worden. Verder wordt het 'restbedrag' wat je meer aan inkomen hebt dan aan budgetering, toegevoegd aan de eerste pot. In het voorbeeld heet hij Fun, maar dit kan ook je spaarpot zijn."]
[]
["Inkomsten"]
["Heel eenvoudig. Noteer hier al je inkomsten met een datum en omschrijving. "]
[]
["uitgaven"]
["De uitgaven werken hetzelfde als de inkomsten, alleen moet je hier ook het bedrag nogmaals invullen bij de pot waar het bedrag uitgehaald moet worden. "]
[]
["maandafsluiting"]
["Aan het einde van elke maand is het goed om de maand af te sluiten en daarmee statistieken op te kunnen bouwen. Er zijn in de tabs totaaloverzicht en budget verdelen knoppen aangemaakt. Zodra je op de knop januari klikt, zullen de gegevens worden gekopieerd naar het juiste veld om deze te laten zien in de tabel. Het was niet mogelijk om alles naar 1 knop te doen, dus per maand zal je 2x een knop aan moeten klikken."]
[]
["Tip"]
["Bewaar een extra kopie van de lege sheet. Deze kan je volgend jaar weer gebruiken. Hier hoef je dan enkel de bedragen in te vullen die je op 1 januari hebt."]

{"sheet":"Totaaloverzicht","index":1,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
["inkomsten","Pot 1","Pot 2","Pot 3","Pot 4","Pot 5","Pot 6","Pot 7","Pot 8","Pot 9","Pot 10","Pot 11","Pot 12","Pot 13","Pot 14","Pot 15","Totaal"]
[{"$f":"SUM(Inkomsten!C:C)+SUM('Budget verdelen'!E3:E14)","v":0},{"$f":"SUM(Uitgaven!E:E)+SUM('Budget verdelen'!F2:F14)","v":0},{"$f":"SUM(Uitgaven!F:F)+SUM('Budget verdelen'!G2:G14)","v":0},{"$f":"SUM(Uitgaven!G:G)+SUM('Budget verdelen'!H2:H14)","v":0},{"$f":"SUM(Uitgaven!H:H)+SUM('Budget verdelen'!I2:I14)","v":0},{"$f":"SUM(Uitgaven!I:I)+SUM('Budget verdelen'!J2:J14)","v":0},{"$f":"SUM(Uitgaven!J:J)+SUM('Budget verdelen'!K2:K14)","v":0},{"$f":"SUM(Uitgaven!K:K)+SUM('Budget verdelen'!L2:L14)","v":0},{"$f":"SUM(Uitgaven!L:L)+SUM('Budget verdelen'!M2:M14)","v":0},{"$f":"SUM(Uitgaven!M:M)+SUM('Budget verdelen'!N2:N14)","v":0},{"$f":"SUM(Uitgaven!N:N)+SUM('Budget verdelen'!O2:O14)","v":0},{"$f":"SUM(Uitgaven!O:O)+SUM('Budget verdelen'!P2:P14)","v":0},{"$f":"SUM(Uitgaven!P:P)+SUM('Budget verdelen'!Q2:Q14)","v":0},{"$f":"SUM(Uitgaven!Q:Q)+SUM('Budget verdelen'!R2:R14)","v":0},{"$f":"SUM(Uitgaven!R:R)+SUM('Budget verdelen'!S2:S14)","v":0},{"$f":"SUM(Uitgaven!S:S)+SUM('Budget verdelen'!T2:T14)","v":0},{"$f":"SUM(A3:P3)","v":0}]
[]
[]
[]
["uitgaven overzicht",{"$f":"B2","v":"Pot 1"},{"$f":"C2","v":"Pot 2"},"Pot 3","Pot 4","Pot 5","Pot 6","Pot 7","Pot 8","Pot 9","Pot 10","Pot 11","Pot 12","Pot 13","Pot 14","Pot 15","Totaal","inkomsten","spaarratio:"]
["januari",{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,1,Uitgaven!S:S)","v":0},{"$f":"SUM(B8:P8)","v":0},{"$f":"SUMIF(Inkomsten!A:A,1,Inkomsten!C:C)","v":0},{"$f":"(Q8+R8)/R8","v":{"$error":"#DIV/0!"}}]
["februari",{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,2,Uitgaven!S:S)","v":0},{"$f":"SUM(B9:P9)","v":0},{"$f":"SUMIF(Inkomsten!A:A,2,Inkomsten!C:C)","v":0},{"$f":"(Q9+R9)/R9","v":{"$error":"#DIV/0!"}}]
["maart",{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,3,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,3,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["april",{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,4,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,4,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["mei",{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,5,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,5,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["juni",{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,6,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,6,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["juli",{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,7,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,7,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["augustus",{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,8,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,8,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["september",{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,9,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,9,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["oktober",{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,10,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,10,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["november",{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,11,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,11,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["december",{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!E:E)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!F:F)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!G:G)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!H:H)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!I:I)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!J:J)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!K:K)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!L:L)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!M:M)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!N:N)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!O:O)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!P:P)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!Q:Q)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!R:R)","v":0},{"$f":"SUMIF(Uitgaven!$A:$A,12,Uitgaven!S:S)","v":0},0,{"$f":"SUMIF(Inkomsten!A:A,12,Inkomsten!C:C)","v":0},{"$error":"#DIV/0!"}]
["Totaal",{"$f":"SUM(B8:B19)","v":0},{"$f":"SUM(C8:C19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R8:R19)","v":0},{"$error":"#DIV/0!"}]
["Gemiddeld per maand",{"$f":"B20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"C20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"D20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"E20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"F20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"G20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"H20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"I20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"J20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"K20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"L20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"M20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"N20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"O20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"P20/(MAX(Uitgaven!$A:$A))","v":0},{"$f":"Q20/(MAX(Uitgaven!$A:$A))","v":0}]
["Resultaat +/-",{"$f":"B3-B27","v":0},{"$f":"C3-C27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Overzicht",{"$f":"B2","v":"Pot 1"},"Pot 2","Pot 3","Pot 4","Pot 5","Pot 6","Pot 7","Pot 8","Pot 9","Pot 10","Pot 11","Pot 12","Pot 13","Pot 14","Pot 15","Totaal","maand afsluiten"]
["2017-01-01",{"$f":"'Budget verdelen'!F2","v":0},{"$f":"'Budget verdelen'!G2","v":0},{"$f":"'Budget verdelen'!H2","v":0},{"$f":"'Budget verdelen'!I2","v":0},{"$f":"'Budget verdelen'!J2","v":0},{"$f":"'Budget verdelen'!K2","v":0},{"$f":"'Budget verdelen'!L2","v":0},{"$f":"'Budget verdelen'!M2","v":0},{"$f":"'Budget verdelen'!N2","v":0},{"$f":"'Budget verdelen'!O2","v":0},{"$f":"'Budget verdelen'!P2","v":0},{"$f":"'Budget verdelen'!Q2","v":0},{"$f":"'Budget verdelen'!R2","v":0},{"$f":"'Budget verdelen'!S2","v":0},{"$f":"'Budget verdelen'!T2","v":0},{"$f":"SUM(B26:P26)","v":0}]
["2017-02-01"]
["2017-03-01"]
["2017-04-01"]
["2017-05-01"]
["2017-06-01"]
["2017-07-01"]
["2017-08-01"]
["2017-09-01"]
["2017-10-01"]
["2017-11-01"]
["2017-12-01"]
["2018-01-01"]

{"sheet":"Geldchecker","index":2,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Bankrekeningen",null,null,null,"contanten",null,null,null,null,null,"administratie balans",null,null,null,null,"Verborgen potjes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Rekening 1",null,0,null,0,"x0,01",{"$f":"E3*0.01","v":0},null,null,null,null,null,null,null,null,null,null,0]
["Rekening 2",null,0,null,0,"x0,02",{"$f":"E4*0.02","v":0},null,null,null,null,null,null,null,null,null,null,0]
["Rekening 3",null,0,null,0,"x0,05",{"$f":"E5*0.05","v":0},null,null,null,null,null,null,null,null,null,null,0]
["Rekening 4",null,0,null,0,"x0,10",{"$f":"E6*0.1","v":0},null,null,null,null,null,null,null,null,null,null,0]
["Rekening 5",null,0,null,0,"x0,20",{"$f":"E7*0.2","v":0}]
["Rekening 6",null,0,null,0,"x0,50",{"$f":"E8*0.5","v":0}]
["Rekening 7",null,0,null,0,"x1,00",{"$f":"E9*1","v":0}]
["Rekening 8",null,0,null,0,"x2,00",{"$f":"E10*2","v":0}]
["Rekening 9",null,0,null,0,"x5",{"$f":"E11*5","v":0}]
["Rekening 10",null,0,null,0,"x10",{"$f":"E12*10","v":0}]
[null,null,null,null,0,"x20",{"$f":"E13*20","v":0}]
[null,null,null,null,0,"x50",{"$f":"E14*50","v":0}]
[null,null,null,null,0,"x100",{"$f":"E15*100","v":0}]
[]
[null,null,{"$f":"SUM(C3:C12)","v":0},null,null,null,{"$f":"SUM(G3:G15)","v":0},null,null,null,null,{"$f":"Totaaloverzicht!Q3","v":0},null,null,null,null,null,{"$f":"SUM(R2:R6)","v":0}]
[]
[]
[]
["Verschil"]
[]
[null,{"$f":"ROUND(SUM(L17,R17)-SUM(B17:I17),2)","v":0},null,{"$f":"IF(B23 = 0, \"geen\",\" \")","v":"geen"},{"$f":"IF(B23=0,\" \",(IF(B23<0,\"Er staat meer geld op je rekeningen dan volgens je administratie\", \"Er staat minder geld op je rekeningen dan volgens je administratie\")))","v":" "}]

{"sheet":"Budget berekenen","index":3,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["uitgavepost",{"$f":"Totaaloverzicht!B2","v":"Pot 1"},{"$f":"Totaaloverzicht!C2","v":"Pot 2"},{"$f":"Totaaloverzicht!D2","v":"Pot 3"},{"$f":"Totaaloverzicht!E2","v":"Pot 4"},{"$f":"Totaaloverzicht!F2","v":"Pot 5"},{"$f":"Totaaloverzicht!G2","v":"Pot 6"},{"$f":"Totaaloverzicht!H2","v":"Pot 7"},{"$f":"Totaaloverzicht!I2","v":"Pot 8"},{"$f":"Totaaloverzicht!J2","v":"Pot 9"},{"$f":"Totaaloverzicht!K2","v":"Pot 10"},{"$f":"Totaaloverzicht!L2","v":"Pot 11"},{"$f":"Totaaloverzicht!M2","v":"Pot 12"},{"$f":"Totaaloverzicht!N2","v":"Pot 13"},{"$f":"Totaaloverzicht!O2","v":"Pot 14"},{"$f":"Totaaloverzicht!P2","v":"Pot 15"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totaal: ",{"$f":"SUM(B3:B49)","v":0},{"$f":"SUM(C3:C49)","v":0},{"$f":"SUM(D3:D49)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(L3:L49)*1.03","v":0},0,0,0,0]
[]
["Maximaal spaarbedrag",null,500,10000,{"$f":"E50*4","v":0},5000,{"$f":"G50*12*1.1","v":0},1500,2500,{"$f":"J50*10","v":0},{"$f":"K50*12*1.1","v":0},{"$f":"L50*4","v":0},10000,10000,10000,40000]

{"sheet":"Budget verdelen","index":4,"n_rows":20,"n_cols":23,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["datum","Bedrag",null,null,"IN",{"$f":"Totaaloverzicht!B2","v":"Pot 1"},{"$f":"Totaaloverzicht!C2","v":"Pot 2"},{"$f":"Totaaloverzicht!D2","v":"Pot 3"},{"$f":"Totaaloverzicht!E2","v":"Pot 4"},{"$f":"Totaaloverzicht!F2","v":"Pot 5"},{"$f":"Totaaloverzicht!G2","v":"Pot 6"},{"$f":"Totaaloverzicht!H2","v":"Pot 7"},{"$f":"Totaaloverzicht!I2","v":"Pot 8"},{"$f":"Totaaloverzicht!J2","v":"Pot 9"},{"$f":"Totaaloverzicht!K2","v":"Pot 10"},{"$f":"Totaaloverzicht!L2","v":"Pot 11"},{"$f":"Totaaloverzicht!M2","v":"Pot 12"},{"$f":"Totaaloverzicht!N2","v":"Pot 13"},{"$f":"Totaaloverzicht!O2","v":"Pot 14"},{"$f":"Totaaloverzicht!P2","v":"Pot 15"}]
["2013-01-01",0,null,"bedrag wat jij op 1-1-2016 hebt",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["2013-02-01",null,null,"februari",{"$f":"-SUM(F3:T3)","v":0}]
["2013-03-01",null,null,"maart",{"$f":"-SUM(F4:T4)","v":0}]
["2013-03-01",null,null,"april",0]
["2013-05-01",null,null,"mei",0]
["2013-06-01",null,null,"juni",0]
["2013-07-01",null,null,"juli",0]
["2013-08-01",null,null,"augustus",0]
["2013-09-01",null,null,"september",0]
["2013-10-01",null,null,"oktober",0]
["2013-11-01",null,null,"november",0]
["2013-12-01",null,null,"december",0]
["2013-12-31",null,null,"eind december",0]
["totaal te verdelen",{"$f":"Totaaloverzicht!A3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal","Tekort"]
[null,null,null,"geplande verdeling",null,{"$f":"IF(B15-SUM(G17:T17)<0,0,B15-SUM(G17:T17))","v":0},{"$f":"IF(Totaaloverzicht!C3>'Budget berekenen'!C52,0,IF('Budget berekenen'!C52-Totaaloverzicht!C3<'Budget berekenen'!C50,'Budget berekenen'!C52-Totaaloverzicht!C3,'Budget berekenen'!C50+G18))","v":0},{"$f":"IF(Totaaloverzicht!D3>'Budget berekenen'!D52,0,IF('Budget berekenen'!D52-Totaaloverzicht!D3<'Budget berekenen'!D50,'Budget berekenen'!D52-Totaaloverzicht!D3,'Budget berekenen'!D50+H18))","v":0},{"$f":"IF(Totaaloverzicht!E3>'Budget berekenen'!E52,0,IF('Budget berekenen'!E52-Totaaloverzicht!E3<'Budget berekenen'!E50,'Budget berekenen'!E52-Totaaloverzicht!E3,'Budget berekenen'!E50+I18))","v":0},{"$f":"IF(Totaaloverzicht!F3>'Budget berekenen'!F52,0,IF('Budget berekenen'!F52-Totaaloverzicht!F3<'Budget berekenen'!F50,'Budget berekenen'!F52-Totaaloverzicht!F3,'Budget berekenen'!F50+J18))","v":0},{"$f":"IF(Totaaloverzicht!G3>'Budget berekenen'!G52,0,IF('Budget berekenen'!G52-Totaaloverzicht!G3<'Budget berekenen'!G50,'Budget berekenen'!G52-Totaaloverzicht!G3,'Budget berekenen'!G50+K18))","v":0},{"$f":"IF(Totaaloverzicht!H3>'Budget berekenen'!H52,0,IF('Budget berekenen'!H52-Totaaloverzicht!H3<'Budget berekenen'!H50,'Budget berekenen'!H52-Totaaloverzicht!H3,'Budget berekenen'!H50+L18))","v":0},{"$f":"IF(Totaaloverzicht!I3>'Budget berekenen'!I52,0,IF('Budget berekenen'!I52-Totaaloverzicht!I3<'Budget berekenen'!I50,'Budget berekenen'!I52-Totaaloverzicht!I3,'Budget berekenen'!I50+M18))","v":0},{"$f":"IF(Totaaloverzicht!J3>'Budget berekenen'!J52,0,IF('Budget berekenen'!J52-Totaaloverzicht!J3<'Budget berekenen'!J50,'Budget berekenen'!J52-Totaaloverzicht!J3,'Budget berekenen'!J50+N18))","v":0},{"$f":"IF(Totaaloverzicht!K3>'Budget berekenen'!K52,0,IF('Budget berekenen'!K52-Totaaloverzicht!K3<'Budget berekenen'!K50,'Budget berekenen'!K52-Totaaloverzicht!K3,'Budget berekenen'!K50+O18))","v":0},{"$f":"IF(Totaaloverzicht!L3>'Budget berekenen'!L52,0,IF('Budget berekenen'!L52-Totaaloverzicht!L3<'Budget berekenen'!L50,'Budget berekenen'!L52-Totaaloverzicht!L3,'Budget berekenen'!L50+P18))","v":0},{"$f":"IF(Totaaloverzicht!M3>'Budget berekenen'!M52,0,IF('Budget berekenen'!M52-Totaaloverzicht!M3<'Budget berekenen'!M50,'Budget berekenen'!M52-Totaaloverzicht!M3,'Budget berekenen'!M50+Q18))","v":0},{"$f":"IF(Totaaloverzicht!N3>'Budget berekenen'!N52,0,IF('Budget berekenen'!N52-Totaaloverzicht!N3<'Budget berekenen'!N50,'Budget berekenen'!N52-Totaaloverzicht!N3,'Budget berekenen'!N50+R18))","v":0},{"$f":"IF(Totaaloverzicht!O3>'Budget berekenen'!O52,0,IF('Budget berekenen'!O52-Totaaloverzicht!O3<'Budget berekenen'!O50,'Budget berekenen'!O52-Totaaloverzicht!O3,'Budget berekenen'!O50+S18))","v":0},{"$f":"IF(Totaaloverzicht!P3>'Budget berekenen'!P52,0,IF('Budget berekenen'!P52-Totaaloverzicht!P3<'Budget berekenen'!P50,'Budget berekenen'!P52-Totaaloverzicht!P3,'Budget berekenen'!P50+T18))","v":0},null,{"$f":"SUM(F17:T17)","v":0},{"$f":"IF(SUM(B15-V17)<0,SUM(B15-V17),\"Gefeliciteerd! Er is geen tekort!\")","v":"Gefeliciteerd! Er is geen tekort!"}]
[null,null,null,"extra toevoeging",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maand afsluiten"]

{"sheet":"Uitgaven","index":5,"n_rows":1000,"n_cols":19,"rows_kept":1000,"cut":false,"hidden":false,"merged":[]}
["Maand","Datum","Bedrag","Omschrijving",{"$f":"Totaaloverzicht!B2","v":"Pot 1"},{"$f":"Totaaloverzicht!C2","v":"Pot 2"},{"$f":"Totaaloverzicht!D2","v":"Pot 3"},{"$f":"Totaaloverzicht!E2","v":"Pot 4"},{"$f":"Totaaloverzicht!F2","v":"Pot 5"},{"$f":"Totaaloverzicht!G2","v":"Pot 6"},{"$f":"Totaaloverzicht!H2","v":"Pot 7"},{"$f":"Totaaloverzicht!I2","v":"Pot 8"},{"$f":"Totaaloverzicht!J2","v":"Pot 9"},{"$f":"Totaaloverzicht!K2","v":"Pot 10"},{"$f":"Totaaloverzicht!L2","v":"Pot 11"},{"$f":"Totaaloverzicht!M2","v":"Pot 12"},{"$f":"Totaaloverzicht!N2","v":"Pot 13"},{"$f":"Totaaloverzicht!O2","v":"Pot 14"},{"$f":"Totaaloverzicht!P2","v":"Pot 15"}]
[{"$f":"MONTH(B2)","v":1}]
[{"$f":"MONTH(B3)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B67)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B131)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B195)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B259)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B323)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B387)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B451)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B515)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B579)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B643)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B707)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B771)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B835)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B899)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B963)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]

{"sheet":"Inkomsten","index":6,"n_rows":1000,"n_cols":4,"rows_kept":1000,"cut":false,"hidden":false,"merged":[]}
["Maand","Datum","bedrag","omschrijving"]
[]
[{"$f":"MONTH(B3)","v":1}]
[{"$f":"MONTH(B4)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B68)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B132)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B196)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B260)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B324)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B388)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B452)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B516)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B580)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B644)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B708)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B772)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B836)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B900)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[{"$f":"MONTH(B964)","v":1}]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]