{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cashflow","Maandelijkse inkomsten","Maandelijkse uitgaven","GRAFIEKGEGEVENS"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Cashflow","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Naam"]
[null,"Gezinsbudget"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"januari"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Opmerking: De tabel Cashflow wordt automatisch berekend op basis van gegevens op de werkbladen Maandelijkse inkomsten en Maandelijkse uitgaven"]
[null,"Cashflow","Geraamd","Werkelijk","Variantie"]
[null,"Totale inkomsten",{"$f":"Inkomsten[[#Totals],[Geraamd]]","v":{"v":5700,"d":"5,700"}},{"$f":"Inkomsten[[#Totals],[Werkelijk]]","v":{"v":5500,"d":"5,500"}},{"$f":"Inkomsten[[#Totals],[Variantie]]","v":-200}]
[null,"Totale uitgaven",{"$f":"Uitgaven[[#Totals],[Geraamd]]","v":{"v":3603,"d":"3,603"}},{"$f":"Uitgaven[[#Totals],[Werkelijk]]","v":{"v":3655,"d":"3,655"}},{"$f":"Uitgaven[[#Totals],[Variantie]]","v":-52}]
[null,"Totaal cash",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,Cashflow[Variantie])","v":-252}]

{"sheet":"Maandelijkse inkomsten","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Naam","v":"Naam"}]
[null,{"$f":"Budgettitel","v":"Gezinsbudget"}]
[null,{"$f":"Maand","v":"januari"}]
[null,{"$f":"Jaar","v":2017}]
[null,"Maandelijkse inkomsten","Geraamd","Werkelijk","Variantie"]
[null,"Inkomsten 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"Inkomsten[[#This Row],[Werkelijk]]-Inkomsten[[#This Row],[Geraamd]]","v":0}]
[null,"Inkomsten 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"Inkomsten[[#This Row],[Werkelijk]]-Inkomsten[[#This Row],[Geraamd]]","v":100}]
[null,"Andere inkomsten",300,0,{"$f":"Inkomsten[[#This Row],[Werkelijk]]-Inkomsten[[#This Row],[Geraamd]]","v":-300}]
[null,"Totale inkomsten",{"$f":"SUBTOTAL(109,Inkomsten[Geraamd])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,Inkomsten[Werkelijk])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,Inkomsten[Variantie])","v":-200}]

{"sheet":"Maandelijkse uitgaven","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Naam","v":"Naam"}]
[null,{"$f":"Budgettitel","v":"Gezinsbudget"}]
[null,{"$f":"Maand","v":"januari"}]
[null,{"$f":"Jaar","v":2017}]
[null,"Maandelijkse uitgaven","Geraamd","Werkelijk","Variantie"]
[null,"Huisvesting",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Boodschappen",250,280,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":-30}]
[null,"Telefoon",38,38,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Elektriciteit/gas",65,78,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":-13}]
[null,"Water/riolering/afval",25,21,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":4}]
[null,"Kabel-tv",75,83,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":-8}]
[null,"Internet",60,60,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Onderhoud/reparaties",0,60,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":-60}]
[null,"Kinderopvang",180,150,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":30}]
[null,"Collegegeld",250,250,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Huisdieren",75,80,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":-5}]
[null,"Vervoer",280,260,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":20}]
[null,"Persoonlijke verzorging",75,65,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":10}]
[null,"Verzekering",255,255,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Creditcards",100,100,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Leningen",0,0,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Belastingen",0,0,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Cadeaus/goede doelen",150,150,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Spaargeld",225,225,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Overig",0,0,{"$f":"Uitgaven[[#This Row],[Geraamd]]-Uitgaven[[#This Row],[Werkelijk]]","v":0}]
[null,"Totaal",{"$f":"SUBTOTAL(109,Uitgaven[Geraamd])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,Uitgaven[Werkelijk])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,Uitgaven[Variantie])","v":-52}]

{"sheet":"GRAFIEKGEGEVENS","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"GRAFIEKGEGEVENS"]
[]
[null,null,"Geraamd","Werkelijk"]
[null,"Cashflow",{"$f":"Cashflow[[#Totals],[Geraamd]]","v":2097},{"$f":"Cashflow[[#Totals],[Werkelijk]]","v":1845}]
[null,"Maandelijkse inkomsten",{"$f":"Inkomsten[[#Totals],[Geraamd]]","v":5700},{"$f":"Inkomsten[[#Totals],[Werkelijk]]","v":5500}]
[null,"Maandelijkse uitgaven",{"$f":"Uitgaven[[#Totals],[Geraamd]]","v":3603},{"$f":"Uitgaven[[#Totals],[Werkelijk]]","v":3655}]