{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Budgetwiel","Data"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"Over de sjabloon"]
[null,"Blijf op de hoogte van uw maandelijkse uitgaven en besparingen met behulp van deze sjabloon."]
[null,"Voer de details van de Onkosten en het Maandelijks Inkomen in de tabel om de Besparingen te berekenen."]
[null,"Ringdiagram met onkosten en besparingen wordt automatisch bijgewerkt."]
[null,"Opmerking:"]
[null,"Aanvullende instructies zijn opgenomen in kolom A van het BUDGETWIEL-werkblad. Deze tekst is opzettelijk verborgen. Om tekst te verwijderen selecteert u eerst kolom A en vervolgens VERWIJDEREN. Om de tekst niet langer te verbergen selecteert u eerst kolom A en wijzigt u vervolgens de kleur van het lettertype."]
[null,"Als u meer wilt weten over de tabel, drukt u op SHIFT en vervolgens op F10 binnen de tabel. Daarna selecteert u de optie TABEL en dan ALTERNATIEVE TEKST."]

{"sheet":"Budgetwiel","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,2],[0,3,0,6],[1,2,4,4]]}
["Maak een budgetwiel op dit werkblad. De titel van het werkblad staat in de cel rechts en de info in cel D1. Andere handige instructies voor het gebruik van dit werkblad staan ​​in cellen in deze kolom. Druk op de pijl die naar beneden wijst om aan de slag te gaan.","Budgetwiel",null,"Vul de tabel in deze sjabloon in. De grafiek geeft uw maandelijkse uitgaven weer in verhouding tot uw maandelijkse inkomen. Het berekent ook de percentages om u te laten zien hoeveel u bespaart/heeft bespaard."]
["Het label Maandelijks Inkomen staat in de cel rechts, het ringdiagram dat onkosten en besparingen toont staat in cel C2 en het label Hoeveelheid Besparingen staat in cel G2.","Maandelijks Inkomen","Ringdiagram dat het onkosten- en besparingspercentage toont bevindt zich in deze cel.",{"$nulls":3},"Hoeveelheid Besparingen"]
["Voer het Maandelijks Inkomen in de cel rechts in. De Hoeveelheid Besparingen wordt automatisch berekend in cel G3. De volgende instructie staat in cel A6.",{"v":5738,"d":"$5,738"},{"$nulls":4},{"$f":"Savings","v":{"v":2777,"d":"$2,777"}}]
[{"$nulls":6},"Waarde automatisch berekend"]
[]
["Voer details in de Onkostentabel die begint in de cel rechts.","Onkosten","Categorie","Hoeveelheid","Frequentie","Maandbedrag","% van Totaal"]
[null,"Verzekering","Transport",{"v":300,"d":"$300"},"Om de 6 maanden",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":50,"d":"$50"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.00871383757406762,"d":"1%"}}]
[null,"Gas","Transport",{"v":25,"d":"$25"},"Wekelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"$100"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Betaling voor Auto","Transport",{"v":200,"d":"$200"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"$200"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"Hypotheek","Start",{"v":1600,"d":"$1,600"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":1600,"d":"$1,600"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.27884280237016384,"d":"28%"}}]
[null,"Kabel","Start",{"v":60,"d":"$60"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"$60"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Filmavond","Entertainment",{"v":70,"d":"$70"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"$70"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Sportschoenen","Div.",{"v":300,"d":"$300"},"Jaarlijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":25,"d":"$25"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.00435691878703381,"d":"0%"}}]
[null,"Hondenvoer","Div.",{"v":60,"d":"$60"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"$60"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Huisdierenverzekering","Div.",{"v":70,"d":"$70"},"Jaarlijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":6,"d":"$6"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":1.0456605088881143E-3,"d":"0%"}}]
[null,"Boodschappen","Eten",{"v":100,"d":"$100"},"Wekelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":400,"d":"$400"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.06971070059254096,"d":"7%"}}]
[null,"Koffie","Eten",{"v":25,"d":"$25"},"Wekelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"$100"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Klimmaterialen","Entertainment",{"v":170,"d":"$170"},"Jaarlijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":14,"d":"$14"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":2.4398745207389336E-3,"d":"0%"}}]
[null,"Lidmaatschap sportschool","Div.",{"v":60,"d":"$60"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"$60"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Hoofdtelefoons","Entertainment",{"v":50,"d":"$50"},"Jaarlijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":4,"d":"$4"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":6.9710700592540956E-4,"d":"0%"}}]
[null,"Kappersbezoek","Div.",{"v":70,"d":"$70"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"$70"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Videogames","Entertainment",{"v":100,"d":"$100"},"Maandelijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"$100"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Kleding","Div.",{"v":500,"d":"$500"},"Jaarlijks",{"$f":"IF(Expenses[Amount]>0,IF(Expenses[Frequency]<>\"\",ROUND(IF(Expenses[Frequency]=\"Maandelijks\",Expenses[Amount],IF(Expenses[Frequency]=\"Wekelijks\",Expenses[Amount]*4,IF(Expenses[Frequency]=\"Per kwartaal\",Expenses[Amount]/3,IF(Expenses[Frequency]=\"Om de 6 maanden\",Expenses[Amount]/6,IF(Expenses[Frequency]=\"Jaarlijks\",Expenses[Amount]/12,IF(Expenses[Frequency]=\"Twee-wekelijks\",Expenses[Amount]*2,IF(Expenses[Frequency]=\"Twee-maandelijks\",Expenses[Amount]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":42,"d":"$42"}},{"$f":"IF(Expenses[Monthly Amount]<>\"\",Expenses[Monthly Amount]/Income,\"\")","v":{"v":7.3196235622168E-3,"d":"1%"}}]

{"sheet":"Data","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["Dit blad moet verborgen blijven"]
["Categorieën","Bedrag per categorie","Percentage van het totaal","Frequentie","Besparingen"]
["Start",{"$f":"IF(SUMIF(Expenses[Category],\"Start\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Start\",Expenses[Monthly Amount]),NA())","v":{"v":1660,"d":"$1,660"}},{"$f":"IF(B3>0,B3/Income,\"\")","v":{"v":0.289299407459045,"d":"29%"}},"Wekelijks",{"$f":"Income-SUM(Expenses[Monthly Amount])","v":{"v":2777,"d":"$2,777"}}]
["Entertainment",{"$f":"IF(SUMIF(Expenses[Category],\"Entertainment\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Entertainment\",Expenses[Monthly Amount]),NA())","v":{"v":188,"d":"$188"}},{"v":0.03276402927849425,"d":"3%"},"Maandelijks"]
["Transport",{"$f":"IF(SUMIF(Expenses[Category],\"Transport\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Transport\",Expenses[Monthly Amount]),NA())","v":{"v":350,"d":"$350"}},{"v":0.06099686301847333,"d":"6%"},"Per kwartaal"]
["Eten",{"$f":"IF(SUMIF(Expenses[Category],\"Eten\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Eten\",Expenses[Monthly Amount]),NA())","v":{"v":500,"d":"$500"}},{"v":0.08713837574067619,"d":"9%"},"Om de 6 maanden"]
["Div.",{"$f":"IF(SUMIF(Expenses[Category],\"Div.\",Expenses[Monthly Amount])>0,SUMIF(Expenses[Category],\"Div.\",Expenses[Monthly Amount]),NA())","v":{"v":263,"d":"$263"}},{"v":0.04583478563959568,"d":"5%"},"Jaarlijks"]
["Besparingen",{"$f":"IF(E3>0,E3,NA())","v":{"v":2777,"d":"$2,777"}},{"v":0.4839665388637156,"d":"48%"},"Twee-wekelijks"]
[{"$nulls":3},"Twee-maandelijks"]
[null,"TOTAAL:",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"100%"}}]