{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Algemene gegevens","Inkomsten","Uitgaven","Resultaat","\"Taart\""],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"Algemene gegevens","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,0,6,5],[7,0,7,5],[0,0,1,5],[3,1,3,2],[4,1,4,2],[4,4,4,5],[3,4,3,5],[2,0,2,5]]}
["1. Algemene gegevens",null,null,null,null,null,null,null,"Man"]
[null,null,null,null,null,null,null,null,"Vrouw"]
["Bestemd voor"]
["Naam:",null,null,"Adres:"]
["Postcode:",null,null,"Woonplaats:"]
[]
[]
["Huishoudsamenstelling"]
[" ","Naam","m/v","Leeftijd","  ","Beroep"]
["1.","Henk","Man",47,"jaar","accountant"]
["2.","Sandra","Vrouw",42,"jaar","Zorgverleenster"]
["3.",null,null,null,"jaar"]
["4.",null,null,null,"jaar"]
["5.",null,null,null,"jaar"]
["6.",null,null,null,"jaar"]

{"sheet":"Inkomsten","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["2. Inkomsten"]
[null,"Huidige situatie",null,"Nieuwe situatie"]
["Netto salaris/uitkering",2400,null,2600]
["Netto salaris/uitkering partner",2000,null,2000]
["Vakantiegeld",0,null,0]
["Vakantiegeld partner",0,null,0]
["Tegemoetkoming schoolkosten",0,null,0]
["Zorgtoeslag",0,null,0]
["Huurtoeslag",0,null,0]
["Kindgebonden budget",0,null,0]
["Kinderopvangtoeslag",0,null,0]
["Kinderbijslag",125,null,125]
["Voorlopige teruggaaf",0,null,0]
["Eenmalige belastingteruggaaf",1800,null,1800]
["Overige inkomsten",0,null,0]
[]
["Totaal inkomsten",{"$f":"SUM(B3:B15)","v":6325},null,{"$f":"SUM(D3:D15)","v":6525}]

{"sheet":"Uitgaven","index":2,"n_rows":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":false,"merged":[[83,0,83,1],[89,0,89,1],[98,0,98,1],[4,2,4,3],[4,4,4,5],[51,0,51,1],[57,0,57,1],[61,0,61,1],[66,0,66,1],[71,0,71,1],[77,0,77,1],[5,0,5,1],[10,0,10,1],[20,0,20,1],[28,0,28,1],[35,0,35,1],[0,0,1,5],[2,0,3,5],[58,0,59,5],[60,2,60,3],[60,4,60,5],[41,0,41,1]]}
["3. Uitgaven"]
[]
["3.1 Vaste lasten"]
[]
[null,null,"Huidige situatie",null,"Nieuwe situatie"]
["Woning"]
[null,"Huur/hypotheek",850,null,1350]
[null,"Servicekosten, erfpacht",0,null,0]
[null,null,null,{"$f":"SUM(C7:C8)","v":850},null,{"$f":"SUM(E7:E8)","v":1350}]
[]
["Energie & heffingen"]
[null,"Gas, elektra",null,null,150]
[null,"Water",25,null,25]
[null,"Reinigingsheffing",0,null,0]
[null,"Waterschapsheffing",0,null,0]
[null,"Rioolrecht",0,null,0]
[null,"Overige heffingen (bv. hondenbelasting)",0,null,0]
[null,"Onroerende zaakbelasting",0,null,0]
[null,null,null,{"$f":"SUM(C12:C18)","v":25},null,{"$f":"SUM(E12:E18)","v":175}]
[]
["Verzekeringen"]
[null,"Zorgverzekering",250,null,250]
[null,"Aansprakelijkheidsverzekering",0,null,0]
[null,"Inboedelverzekering",0,null,0]
[null,"Opstalverzekering",0,null,0]
[null,"Overige verzekeringen",0,null,0]
[null,null,null,{"$f":"SUM(C22:C26)","v":250},null,{"$f":"SUM(E22:E26)","v":250}]
[]
["Abonnementen & contributies"]
[null,"Vaste telefoon, tv, internet",0,null,0]
[null,"Mobiele telefoon",0,null,0]
[null,"Abonnementen ",0,null,0]
[null,"Contributies",0,null,0]
[null,null,null,{"$f":"SUM(C30:C33)","v":0},null,{"$f":"SUM(E30:E33)","v":0}]
[]
["School-/ studiekosten & kinderopvang"]
[null,"Schoolkosten",0,null,0]
[null,"Studiekosten",0,null,0]
[null,"Kinderopvang",0,null,0]
[null,null,null,{"$f":"SUM(C37:C39)","v":0},null,{"$f":"SUM(E37:E39)","v":0}]
[]
["Vervoer"]
[null,"Wegenbelasting",0,null,0]
[null,"Autoverzekering",0,null,0]
[null,"Onderhoud vervoersmiddel",0,null,0]
[null,"Afbetaling, afschrijving",0,null,0]
[null,"Brandstof",0,null,0]
[null,"OV-kosten",0,null,0]
[null,"Overige",0,null,0]
[null,null,null,{"$f":"SUM(C43:C49)","v":0},null,{"$f":"SUM(E43:E49)","v":0}]
[]
["Overige vaste lasten"]
[null,"Alimentatie",0,null,0]
[null,"Afbetalingen (lening, rente)",0,null,0]
[null,"Overig",0,null,0]
[null,null,null,{"$f":"SUM(C53:C55)","v":0},null,{"$f":"SUM(E53:E55)","v":0}]
[]
["Totaal vaste uitgaven",null,null,{"$f":"SUM(D56+D50+D40+D34+D27+D19+D9)","v":1125},null,{"$f":"SUM(F56+F50+F40+F34+F27+F19+F9)","v":1775}]
["3.2 Reserveringsuitgaven"]
[]
[null,null,"Huidige situatie",null,"Nieuwe situatie"]
["Kleding & schoenen"]
[null,"Kleding, schoenen",0,null,0]
[null,"Overig",0,null,0]
[null,null,null,{"$f":"SUM(C63:C64)","v":0},null,{"$f":"SUM(E63:E64)","v":0}]
[]
["Inventaris, huis & tuin"]
[null,"Inventaris",0,null,0]
[null,"Onderhoud aan huis en tuin",0,null,0]
[null,null,null,{"$f":"SUM(C68:C69)","v":0},null,{"$f":"SUM(E68:E69)","v":0}]
[]
["Vrije tijd en hobby's"]
[null,"Hobby's",0,null,0]
[null,"Uitgaan",0,null,0]
[null,"Vakantie",0,null,0]
[null,null,null,{"$f":"SUM(C73:C75)","v":0},null,{"$f":"SUM(E73:E75)","v":0}]
[]
["Sparen & onvoorziene uitgaven"]
[null,"Niet vergoede ziektekosten",0,null,0]
[null,"Sparen",0,null,0]
[null,"Overig",0,null,0]
[null,null,null,{"$f":"SUM(C79:C81)","v":0},null,{"$f":"SUM(E79:E81)","v":0}]
[]
["Dagelijkse boodschappen"]
[null,"Voeding",0,null,0]
[null,"Was- en schoonmaakartikelen",0,null,0]
[null,"Persoonlijke verzorging",0,null,0]
[null,null,null,{"$f":"SUM(C85:C87)","v":0},null,{"$f":"SUM(E85:E87)","v":0}]
[]
["Overige huishoudelijke uitgaven"]
[null,"Zakgeld kinderen",0,null,0]
[null,"Huisdieren",0,null,0]
[null,"Cadeaus",0,null,0]
[null,"Huishoudelijke hulp",0,null,0]
[null,"Roken",0,null,0]
[null,"Diversen ",0,null,0]
[null,null,null,{"$f":"SUM(C91:C96)","v":0},null,{"$f":"SUM(E91:E96)","v":0}]
[]
["Totaal reserveringsuitgaven",null,null,{"$f":"SUM(D97+D88+D82+D76+D70+D65)","v":0},null,{"$f":"SUM(F97+F88+F82+F76+F70+F65)","v":0}]

{"sheet":"Resultaat","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5],[0,0,1,5]]}
["4. Totaal inkomsten en uitgaven"]
[]
[null,"Huidige situatie",null,null,"Nieuwe situatie "]
["2. Totaal inkomsten",null,{"$f":"Inkomsten!B17","v":6325},null,null,{"$f":"Inkomsten!D17","v":6525}]
[]
["3.1 Totaal vaste lasten",{"$f":"Uitgaven!D58","v":1125},null,null,{"$f":"Uitgaven!F58","v":1775}]
["3.2 Totaal reserveringsuitgaven",{"$f":"Uitgaven!D99","v":0},null,null,{"$f":"Uitgaven!F99","v":0}]
["3. Totaal uitgaven",null,{"$f":"B6+B7","v":1125},null,null,{"$f":"E6+E7","v":1775}]
[]
["Saldo",null,{"$f":"C4-C8","v":5200},null,null,{"$f":"F4-F8","v":4750}]

{"sheet":"\"Taart\"","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Uitgaventaart "]
["Woning",{"$f":"Uitgaven!D9","v":850}]
["Energie & heffingen",{"$f":"Uitgaven!D19","v":25}]
["Verzekeringen",{"$f":"Uitgaven!D27","v":250}]
["Abonnementen & contributies",{"$f":"Uitgaven!D34","v":0}]
["School-/ studiekosten & kinderopvang",{"$f":"Uitgaven!D40","v":0}]
["Vervoer",{"$f":"Uitgaven!D50","v":0}]
["Overige vaste lasten",{"$f":"Uitgaven!D56","v":0}]
["Kleding & schoenen",{"$f":"Uitgaven!D65","v":0}]
["Inventaris, huis & tuin",{"$f":"Uitgaven!D70","v":0}]
["Vrije tijd en hobby's",{"$f":"Uitgaven!D76","v":0}]
["Sparen & onvoorziene uitgaven",{"$f":"Uitgaven!D82","v":0}]
["Dagelijkse boodschappen",{"$f":"Uitgaven!D88","v":0}]
["Overige huishoudelijke uitgaven",{"$f":"Uitgaven!D97","v":0}]