{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Start","Maandelijkse budgetrapport","Maandelijkse kosten","Aanvullende gegevens"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"OVER DEZE SJABLOON"]
[null,"Gebruik deze werkmap voor het bijhouden van uw kosten en het maken van een familiebudget."]
[null,"Verwachte en werkelijke inkomsten uit verschillende bronnen in het werkblad maandelijkse budgetrapport en de verwachte en werkelijke hoeveelheden die zijn besteed aan verschillende categorieën in het werkblad maandelijkse kosten, invoeren."]
[null,"Het geschatte en het werkelijk saldo en het verschil worden automatisch bijgewerkt, en budgetoverzicht en de grafiek budgetoverzicht worden bijgewerkt in het werkblad maandelijks budgerrapport."]
[null,"U een nieuwe categorie in de tabel in het werkblad Aanvullende gegevens wijzigen of invoeren."]
[null,"Opmerking: "]
[null,"Aanvullende instructies worden verstrekt in kolom A in het werkblad Maandelijkse budgetrapport en in cel A1 in de werkbladen Maandelijkse kosten en Aanvullende gegevens. Deze tekst is opzettelijk verborgen. Als u de tekst wilt verwijderen, selecteert u kolom A of cel A1 en drukt u op Delete. Als u de tekst zichtbaar wilt maken, selecteert u kolom A of cel A1 en wijzigt u de tekenkleur."]
[null,"Als u meer wilt weten over tabellen, drukt u in een tabel op Shift en F10 en selecteert u de optie Tabel en vervolgens Alternatieve tekst. Als u meer wilt weten over draaitabellen, drukt u in een draaitabel op Shift en F10 en selecteert u de optie Opties voor draaitabel en vervolgens Alternatieve tekst."]

{"sheet":"Maandelijkse budgetrapport","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[0,1,0,4],[0,5,0,7],[0,12,0,13],[1,9,5,13],[2,2,2,5],[3,2,3,5],[4,2,4,5],[7,1,10,1],[7,5,10,5],[7,6,10,6],[8,9,31,9],[12,1,16,1],[12,5,16,5],[12,6,16,6],[19,1,34,6]]}
["Maak in dit werkblad een maandelijkse budgetrapport. De titel van dit werkblad staat in de cel rechts en de subtitel staat in cel J1. Selecteer cel F1 om naar het werkblad Maandelijkse kosten te gaan. Andere handige instructies over het gebruik van dit werkblad staan in cellen in deze kolom.","Budgetoverzicht",{"$nulls":3},"Maandelijkse uitgaven",{"$nulls":3},"Budgetoverzicht",null,null,"Deze cel bevat één groene tarwestengel."]
["Het label Saldo staat in de cel rechts. Draaitabelslicers om gegevens te filteren staan in de cellen J2 tot en met N6. Als u meerdere categorieën wilt selecteren, houdt u de Control-toets ingedrukt.","Saldo",{"$nulls":7},"De categorieslicer voor het filteren van onderstaande draaitabellen op de geselecteerde categorie staat in de cel."]
["Het label Geraamd saldo staat in de cel rechts. Geraamd saldo wordt automatisch berekend in cel G3.","Geraamd saldo","(Geraamde inkomsten minus uitgaven)",{"$nulls":3},{"$f":"D17-SUM(BudgetDetails[Geraamde kosten])","v":{"v":1585,"d":"€ 1,585"}}]
["Het label Werkelijk saldo staat in de cel rechts. Het werkelijk saldo wordt automatisch berekend in cel G4.","Werkelijk saldo ","(Werkelijk minus uitgaven)",{"$nulls":3},{"$f":"D11-SUM(BudgetDetails[Werkelijke kosten])","v":{"v":1740,"d":"€ 1,740"}}]
["Het label Verschil staat in de cel rechts. Het verschil wordt automatisch berekend in cel G5. De volgende aanwijzing staat in cel A7.","Verschil","(Werkelijk minus geraamd)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"€ 155"}}]
[]
["Het label Inkomsten staat in de cel rechts, Uitgaven in cel F7 en Tip voor budgetoverzicht in cel J7.","Inkomsten",{"$nulls":3},"Uitgaven",{"$nulls":3},"Selecteer onderstaande draaitabel en selecteer vervolgens Vernieuwen in het tabblad analyseren om bij te werken."]
["Het label Werkelijke inkomsten staat in de cel rechts en het label Werkelijke uitgaven in cel F8. Voer Inkomsten 1 in in cel D8. Werkelijke uitgaven worden automatisch berekend in cel G8.","WERKELIJK","Inkomsten 1",{"v":5800,"d":"€ 5,800"},null,"WERKELIJK",{"$f":"SUM(BudgetDetails[Werkelijke kosten])","v":{"v":7860,"d":"€ 7,860"}}]
["Voer Inkomsten 2 in in cel D9. De afbeelding staat in cel J9. De draaitabel begint in cel K9. Selecteer voor het bijwerken van de draaitabel Vernieuwen in het tabblad Analyseren.",null,"Inkomsten 2",{"v":2300,"d":"€ 2,300"},{"$nulls":5},"Deze cel bevat de afbeelding.","Categorie","Geraamde kosten ","Werkelijke kosten ","Verschil "]
["Voer Extra inkomsten in in cel D10.",null,"Extra inkomsten",{"v":1500,"d":"€ 1,500"},{"$nulls":6},"Belastingen",{"v":300,"d":"€ 300"},{"v":300,"d":"€ 300"},{"v":0,"d":"€ 0"}]
["Het label Totale inkomsten staat in cel C11 en de Totale inkomsten worden automatisch berekend in cel D11. De volgende aanwijzing staat in cel A13.",null,"Totale inkomsten",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"€ 9,600"}}]
[{"$nulls":10},"Cadeaus en liefdadigheidsinstelling",{"v":100,"d":"€ 100"},{"v":125,"d":"€ 125"},{"v":-25,"d":"€ -25"}]
["Het label Geraamde inkomsten staat in de cel rechts en het label Werkelijke uitgaven in cel F13. Geraamde uitgaven worden automatisch berekend in cel G13.","GERAAMD",{"$nulls":3},"GERAAMD",{"$f":"SUM(BudgetDetails[Geraamde kosten])","v":{"v":7915,"d":"€ 7,915"}}]
["Voer geraamde inkomsten 1 in in cel D14.",null,"Inkomsten 1",{"v":6000,"d":"€ 6,000"},{"$nulls":6},"Entertainment",{"v":400,"d":"€ 400"},{"v":358,"d":"€ 358"},{"v":42,"d":"€ 42"}]
["Voer geraamde inkomsten 2 in in cel D15.",null,"Inkomsten 2",{"v":1000,"d":"€ 1,000"}]
["Voer Extra inkomsten in in cel D16.",null,"Extra inkomsten",{"v":2500,"d":"€ 2,500"},{"$nulls":6},"Eten en drinken",{"v":1100,"d":"€ 1,100"},{"v":1320,"d":"€ 1,320"},{"v":-220,"d":"€ -220"}]
["Het label Totale inkomsten staat in cel C17 en de Totale inkomsten worden automatisch berekend in cel D17. De volgende aanwijzing staat in cel A20.",null,"Totale inkomsten",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"€ 9,500"}}]
[{"$nulls":10},"Huisdieren",{"v":170,"d":"€ 170"},{"v":100,"d":"€ 100"},{"v":70,"d":"€ 70"}]
[]
["Cirkeldiagram met het percentage van de uitgaven per categorie staat in de cel rechts.","Cirkeldiagram met het percentage van de uitgaven per categorie staat in deze cel.",{"$nulls":8},"Huisvesting",{"v":2830,"d":"€ 2,830"},{"v":2702,"d":"€ 2,702"},{"v":128,"d":"€ 128"}]
[]
[{"$nulls":10},"Kinderen",{"v":140,"d":"€ 140"},{"v":140,"d":"€ 140"},{"v":0,"d":"€ 0"}]
[]
[{"$nulls":10},"Leningen",{"v":200,"d":"€ 200"},{"v":200,"d":"€ 200"},{"v":0,"d":"€ 0"}]
[]
[{"$nulls":10},"Persoonlijke verzorging",{"v":150,"d":"€ 150"},{"v":140,"d":"€ 140"},{"v":10,"d":"€ 10"}]
[]
[{"$nulls":10},"Spaargeld of investeringen",{"v":200,"d":"€ 200"},{"v":200,"d":"€ 200"},{"v":0,"d":"€ 0"}]
[]
[{"$nulls":10},"Vervoer",{"v":1425,"d":"€ 1,425"},{"v":1375,"d":"€ 1,375"},{"v":50,"d":"€ 50"}]
[]
[{"$nulls":10},"Verzekering",{"v":900,"d":"€ 900"},{"v":900,"d":"€ 900"},{"v":0,"d":"€ 0"}]
[]
[{"$nulls":10},"Eindtotaal",{"v":7915,"d":"€ 7,915"},{"v":7860,"d":"€ 7,860"},{"v":55,"d":"€ 55"}]

{"sheet":"Maandelijkse kosten","index":2,"n_rows":62,"n_cols":7,"rows_kept":62,"merged":[[0,1,0,4],[0,5,0,6]]}
["Bereken uw maandelijkse kosten in dit werkblad. De titel van dit werkblad staat in de cel rechts. Selecteer cel F1 om naar het werkblad Maandelijks budgetrapport te gaan.","Maandelijkse kosten",{"$nulls":3},"Maandelijkse budgetrapport"]
[" Voer de gegevens in in de tabel Budgetinformatie die in de cel rechts begint.","Omschrijving","Categorie","Geraamde kosten","Werkelijke kosten","Verschil","Overzicht werkelijke kosten"]
[null,"Buitenschoolse activiteiten","Kinderen",{"v":40,"d":"€ 40"},{"v":40,"d":"€ 40"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":40,"d":"€ 40"}}]
[null,"Medisch","Kinderen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Studiebenodigdheden","Kinderen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Studiekosten","Kinderen",{"v":100,"d":"€ 100"},{"v":100,"d":"€ 100"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":100,"d":"€ 100"}}]
[null,"Concerten","Entertainment",{"v":50,"d":"€ 50"},{"v":40,"d":"€ 40"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":10,"d":"€ 10"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":40,"d":"€ 40"}}]
[null,"Theater","Entertainment",{"v":200,"d":"€ 200"},{"v":150,"d":"€ 150"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":150,"d":"€ 150"}}]
[null,"Films","Entertainment",{"v":50,"d":"€ 50"},{"v":28,"d":"€ 28"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":22,"d":"€ 22"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":28,"d":"€ 28"}}]
[null,"Muziek (cd's, downloads, enzovoort.)","Entertainment",{"v":50,"d":"€ 50"},{"v":30,"d":"€ 30"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":20,"d":"€ 20"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":30,"d":"€ 30"}}]
[null,"Sportevenementen","Entertainment",{"v":0,"d":"€ 0"},{"v":40,"d":"€ 40"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-40,"d":"€ -40"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":40,"d":"€ 40"}}]
[null,"Video/dvd (kopen)","Entertainment",{"v":20,"d":"€ 20"},{"v":50,"d":"€ 50"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-30,"d":"€ -30"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}}]
[null,"Video/dvd (huren)","Entertainment",{"v":30,"d":"€ 30"},{"v":20,"d":"€ 20"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":10,"d":"€ 10"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":20,"d":"€ 20"}}]
[null,"Uit eten","Eten en drinken",{"v":1000,"d":"€ 1,000"},{"v":1200,"d":"€ 1,200"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-200,"d":"€ -200"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":1200,"d":"€ 1,200"}}]
[null,"Boodschappen","Eten en drinken",{"v":100,"d":"€ 100"},{"v":120,"d":"€ 120"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-20,"d":"€ -20"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":120,"d":"€ 120"}}]
[null,"Liefdadigheid 1","Cadeaus en liefdadigheidsinstelling",{"v":75,"d":"€ 75"},{"v":100,"d":"€ 100"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-25,"d":"€ -25"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":100,"d":"€ 100"}}]
[null,"Liefdadigheid 2","Cadeaus en liefdadigheidsinstelling",{"v":25,"d":"€ 25"},{"v":25,"d":"€ 25"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":25,"d":"€ 25"}}]
[null,"Cadeau 1","Cadeaus en liefdadigheidsinstelling",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Cadeau 2","Cadeaus en liefdadigheidsinstelling",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Kabel/satelliet","Huisvesting",{"v":100,"d":"€ 100"},{"v":100,"d":"€ 100"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":100,"d":"€ 100"}}]
[null,"Elektriciteit","Huisvesting",{"v":45,"d":"€ 45"},{"v":50,"d":"€ 50"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-5,"d":"€ -5"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}}]
[null,"Gas","Huisvesting",{"v":300,"d":"€ 300"},{"v":400,"d":"€ 400"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-100,"d":"€ -100"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":400,"d":"€ 400"}}]
[null,"Schoonmaakdiensten","Huisvesting",{"v":200,"d":"€ 200"},null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":200,"d":"€ 200"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Onderhoud","Huisvesting",{"v":200,"d":"€ 200"},{"v":150,"d":"€ 150"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":150,"d":"€ 150"}}]
[null,"Hypotheek of huur","Huisvesting",{"v":1700,"d":"€ 1,700"},{"v":1700,"d":"€ 1,700"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":1700,"d":"€ 1,700"}}]
[null,"Aardgas/olie","Huisvesting",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Internetservice","Huisvesting",{"v":100,"d":"€ 100"},{"v":100,"d":"€ 100"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":100,"d":"€ 100"}}]
[null,"(Mobiele) telefoon","Huisvesting",{"v":60,"d":"€ 60"},{"v":60,"d":"€ 60"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":60,"d":"€ 60"}}]
[null,"Telefoon (thuis)","Huisvesting",{"v":35,"d":"€ 35"},{"v":39,"d":"€ 39"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-4,"d":"€ -4"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":39,"d":"€ 39"}}]
[null,"Benodigdheden","Huisvesting",{"v":40,"d":"€ 40"},{"v":55,"d":"€ 55"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-15,"d":"€ -15"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":55,"d":"€ 55"}}]
[null,"Afvalverwijdering en recyclen","Huisvesting",{"v":25,"d":"€ 25"},{"v":22,"d":"€ 22"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":3,"d":"€ 3"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":22,"d":"€ 22"}}]
[null,"Water en riolering","Huisvesting",{"v":25,"d":"€ 25"},{"v":26,"d":"€ 26"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-1,"d":"€ -1"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":26,"d":"€ 26"}}]
[null,"Gezondheid","Verzekering",{"v":400,"d":"€ 400"},{"v":400,"d":"€ 400"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":400,"d":"€ 400"}}]
[null,"Woning","Verzekering",{"v":400,"d":"€ 400"},{"v":400,"d":"€ 400"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":400,"d":"€ 400"}}]
[null,"Leven","Verzekering",{"v":100,"d":"€ 100"},{"v":100,"d":"€ 100"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":100,"d":"€ 100"}}]
[null,"Creditcard 1","Leningen",{"v":200,"d":"€ 200"},{"v":200,"d":"€ 200"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":200,"d":"€ 200"}}]
[null,"Creditcard 2","Leningen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Creditcard 3","Leningen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Persoonlijk","Leningen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Student/leerling","Leningen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Kleding","Persoonlijke verzorging",{"v":150,"d":"€ 150"},{"v":140,"d":"€ 140"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":10,"d":"€ 10"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":140,"d":"€ 140"}}]
[null,"Stomerij","Persoonlijke verzorging",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Haar/nagels","Persoonlijke verzorging",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Sportclub","Persoonlijke verzorging",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Medisch","Persoonlijke verzorging",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Eten en drinken","Huisdieren",{"v":150,"d":"€ 150"},{"v":75,"d":"€ 75"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":75,"d":"€ 75"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":75,"d":"€ 75"}}]
[null,"Verzorging","Huisdieren",{"v":20,"d":"€ 20"},{"v":25,"d":"€ 25"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-5,"d":"€ -5"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":25,"d":"€ 25"}}]
[null,"Medisch","Huisdieren",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Speelgoed","Huisdieren",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Investeringsgeld","Spaargeld of investeringen",{"v":200,"d":"€ 200"},{"v":200,"d":"€ 200"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":200,"d":"€ 200"}}]
[null,"Pensioengeld","Spaargeld of investeringen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Overheid","Belastingen",{"v":300,"d":"€ 300"},{"v":300,"d":"€ 300"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":300,"d":"€ 300"}}]
[null,"Lokaal","Belastingen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Provincie","Belastingen",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Openbaar vervoer","Vervoer",{"v":100,"d":"€ 100"},{"v":150,"d":"€ 150"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":-50,"d":"€ -50"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":150,"d":"€ 150"}}]
[null,"Brandstof","Vervoer",{"v":450,"d":"€ 450"},{"v":400,"d":"€ 400"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":400,"d":"€ 400"}}]
[null,"Verzekering","Vervoer",{"v":300,"d":"€ 300"},{"v":300,"d":"€ 300"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":300,"d":"€ 300"}}]
[null,"Kentekenbewijs/rijbewijs ","Vervoer",{"v":25,"d":"€ 25"},{"v":25,"d":"€ 25"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":25,"d":"€ 25"}}]
[null,"Onderhoud","Vervoer",{"v":100,"d":"€ 100"},{"v":50,"d":"€ 50"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":50,"d":"€ 50"}}]
[null,"Parkeerkosten","Vervoer",null,null,{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}}]
[null,"Autobetaling","Vervoer",{"v":450,"d":"€ 450"},{"v":450,"d":"€ 450"},{"$f":"BudgetDetails[[#This Row],[Geraamde kosten]]-BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":0,"d":"€ 0"}},{"$f":"BudgetDetails[[#This Row],[Werkelijke kosten]]","v":{"v":450,"d":"€ 450"}}]
[null,"Totaal",null,{"$f":"SUBTOTAL(109,BudgetDetails[Geraamde kosten])","v":{"v":7915,"d":"€ 7,915"}},{"$f":"SUBTOTAL(109,BudgetDetails[Werkelijke kosten])","v":{"v":7860,"d":"€ 7,860"}},{"$f":"SUBTOTAL(109,BudgetDetails[Verschil])","v":{"v":55,"d":"€ 55"}}]

{"sheet":"Aanvullende gegevens","index":3,"n_rows":15,"n_cols":5,"rows_kept":15}
["Gebruik dit werkblad om de vervolgkeuzelijst kolomcategorie in de tabel Budgetgegevens in het werkblad maandelijkse kosten te wijzigen. Hiervoor wijzigt of voert u een nieuwe categorie in in de opzoeken budgetcategorie vanaf cel E2. Draaitabellen die zijn gekoppeld aan de grafiek budgetoverzicht in het werkblad maandelijkse budgetrapport in cel B2.","Draaitabel voor grafiek Budgetoverzicht",null,null,"Opzoeklijst voor categorie budgetinformatie"]
[null,"Categorie","Kosten",null,"Opzoeken Budgetcategorie"]
[null,"Kinderen",{"v":140,"d":"€ 140"},null,"Kinderen"]
[null,"Entertainment",{"v":358,"d":"€ 358"},null,"Entertainment"]
[null,"Eten en drinken",{"v":1320,"d":"€ 1,320"},null,"Eten en drinken"]
[null,"Cadeaus en liefdadigheidsinstelling",{"v":125,"d":"€ 125"},null,"Cadeaus en liefdadigheidsinstelling"]
[null,"Huisvesting",{"v":2702,"d":"€ 2,702"},null,"Huisvesting"]
[null,"Verzekering",{"v":900,"d":"€ 900"},null,"Verzekering"]
[null,"Leningen",{"v":200,"d":"€ 200"},null,"Leningen"]
[null,"Persoonlijke verzorging",{"v":140,"d":"€ 140"},null,"Persoonlijke verzorging"]
[null,"Huisdieren",{"v":100,"d":"€ 100"},null,"Huisdieren"]
[null,"Spaargeld of investeringen",{"v":200,"d":"€ 200"},null,"Spaargeld of investeringen"]
[null,"Belastingen",{"v":300,"d":"€ 300"},null,"Belastingen"]
[null,"Vervoer",{"v":1375,"d":"€ 1,375"},null,"Vervoer"]
[null,"Eindtotaal",{"v":7860,"d":"€ 7,860"}]