{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mijn studiebudget","Inkomsten en uitgaven","Berekening"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Mijn studiebudget","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[1,2,1,9]]}
["Maak op dit werkblad een studiebudget. \nDe volgende tip staat in cel A4."]
[null,null,"Mijn studiebudget"]
[]
["Voer uw gegevens in op het werkblad Inkomsten en uitgaven.\nAlle berekeningen op dit werkblad worden automatisch uitgevoerd.\nDe volgende tip staat in cel A8","Resterende inkomsten",{"$f":"Net_Monthly_Income-Net_Monthly_Expenses","v":{"v":637.5,"d":"€ 638"}}]
[null,"percentage bestede inkomsten",{"$f":"Net_Monthly_Expenses/Net_Monthly_Income","v":{"v":0.7681818181818182,"d":"77%"}}]
[]
[null,"Nettomaandinkomen",{"$f":"Maandelijkse_inkomsten[[#Totals],[Bedrag]]","v":{"v":2750,"d":"€ 2,750"}}]
["Onder de netto maandelijkse uitgaven vallen de semesteruitgaven gedeeld door de semesterduur (in maanden)","Netto maandelijkse uitgaven",{"$f":"Maandelijkse_uitgaven[[#Totals],[Bedrag]]+Semesteruitgaven[[#Totals],[Per maand]]","v":{"v":2112.5,"d":"€ 2,113"}}]

{"sheet":"Inkomsten en uitgaven","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"merged":[[1,1,1,2],[1,4,1,5],[1,7,1,9],[3,7,3,8]]}
["Voer uw inkomsten en uitgaven in in de tabellen op dit werkblad.\nTyp in cel J4 hoelang (maanden) uw semester duurt."]
[null,"Maandelijkse inkomsten",null,null,"Maandelijkse uitgaven",null,null,"Semesteruitgaven"]
[]
[null,"Artikel","Bedrag",null,"Artikel","Bedrag",null,"Type duur semester (maanden):",null,4]
[null,"Vast inkomen",{"v":1500,"d":"€ 1,500"},null,"Huur",{"v":350,"d":"€ 350"}]
[null,"Financiële hulp",{"v":500,"d":"€ 500"},null,"Water, gas, elektriciteit",{"v":50,"d":"€ 50"},null,"Artikel","Bedrag","Per maand"]
[null,"Leningen",{"v":500,"d":"€ 500"},null,"Mobiele telefoon",{"v":75,"d":"€ 75"},null,"Collegegeld",{"v":750,"d":"€ 750"},{"$f":"Semesteruitgaven[[#This Row],[Bedrag]]/Months_in_semester","v":{"v":187.5,"d":"€ 188"}}]
[null,"Overige inkomsten",{"v":250,"d":"€ 250"},null,"Boodschappen",{"v":250,"d":"€ 250"},null,"Laboratoriumkosten",{"v":300,"d":"€ 300"},{"$f":"Semesteruitgaven[[#This Row],[Bedrag]]/Months_in_semester","v":{"v":75,"d":"€ 75"}}]
[null,"Totaal",{"$f":"SUBTOTAL(109,Maandelijkse_inkomsten[Bedrag])","v":{"v":2750,"d":"€ 2,750"}},null,"Uitgaven auto",{"v":50,"d":"€ 50"},null,"Boeken",{"v":500,"d":"€ 500"},{"$f":"Semesteruitgaven[[#This Row],[Bedrag]]/Months_in_semester","v":{"v":125,"d":"€ 125"}}]
[{"$nulls":4},"Studieleningen",{"v":500,"d":"€ 500"},null,"Waarborgsommen",{"v":0,"d":"€ 0"},{"$f":"Semesteruitgaven[[#This Row],[Bedrag]]/Months_in_semester","v":{"v":0,"d":"€ 0"}}]
[{"$nulls":4},"Creditcards",{"v":275,"d":"€ 275"},null,"Vervoer",{"v":0,"d":"€ 0"},{"$f":"Semesteruitgaven[[#This Row],[Bedrag]]/Months_in_semester","v":{"v":0,"d":"€ 0"}}]
[{"$nulls":4},"Verzekering",{"v":125,"d":"€ 125"},null,"Andere kosten",{"v":0,"d":"€ 0"},{"$f":"Semesteruitgaven[[#This Row],[Bedrag]]/Months_in_semester","v":{"v":0,"d":"€ 0"}}]
[{"$nulls":4},"Kapper",{"v":50,"d":"€ 50"},null,"Totaal",{"$f":"SUBTOTAL(109,Semesteruitgaven[Bedrag])","v":{"v":1550,"d":"€ 1,550"}},{"$f":"SUBTOTAL(109,Semesteruitgaven[Per maand])","v":{"v":387.5,"d":"€ 388"}}]
[{"$nulls":4},"Amusement",{"v":0,"d":"€ 0"}]
[{"$nulls":4},"Diversen",{"v":0,"d":"€ 0"}]
[{"$nulls":4},"Totaal",{"$f":"SUBTOTAL(109,Maandelijkse_uitgaven[Bedrag])","v":{"v":1725,"d":"€ 1,725"}}]

{"sheet":"Berekening","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["Inkomsten",{"$f":"'Mijn studiebudget'!C7","v":{"v":2750,"d":"€ 2,750"}}]
["Uitgaven",{"$f":"'Mijn studiebudget'!C8","v":{"v":2112.5,"d":"€ 2,113"}}]