{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["ONDERWIJSPERIODE","STUDIEPUNTEN","BUDGET","NETTO MAANDELIJKSE UITGAVEN","UITGAVEN ONDERWIJSPERIODE","BOEKEN"],"not_rendered":{"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"ONDERWIJSPERIODE","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[2,3,2,4]]}
[null,"MIJN LESROOSTER"]
[null,"HERFSTPERIODE"]
[null,null,"BEGINTIJD","TIJDSINTERVAL",null,"JAAR"]
[null,null,"09:00:00",60,"(in minuten)"]
[null,"TIJD ","MA","DI","WO","DO","VR","ZA","ZO"]
[null,{"$f":"Begintijd+TIME(0,(ROW(A1)-1)*Tijdsinterval,0)","v":"09:00:00"},"Ontbijt","Ontbijt","Ontbijt","Ontbijt","Ontbijt"]
[null,"10:00:00","Handel: College gebouw B, lokaal 256"]
[null,"11:00:00",{"$nulls":3},"Natuurkunde: Laboratorium \nGebouw J, lokaal 309"]
[null,"12:00:00"]
[null,"13:00:00"]
[null,"14:00:00"]
[null,"15:00:00"]
[null,"16:00:00"]
[null,"17:00:00"]
[null,"18:00:00"]
[null,"19:00:00"]
[null,"20:00:00"]
[null,"21:00:00"]
[null,"22:00:00"]
[null,"23:00:00"]
[null,1]
[null,1.0416666666666665]
[null,1.0833333333333335]
[null,1.125]
[null,1.1666666666666665]
[null,1.2083333333333335]
[null,1.25]
[null,1.2916666666666665]
[null,1.3333333333333335]

{"sheet":"STUDIEPUNTEN","index":1,"n_rows":17,"n_cols":8,"rows_kept":17}
[null,"UNIVERSITEIT"]
[null,"STUDIEPUNTENPLANNER"]
[null,"Graad",{"$f":"Jaar","v":"JAAR"}]
[null,"ALGEHELE VOORTGANG",null,"ALGEHELE VOORTGANG"]
[null,{"$f":"AVERAGE(Cursussen[CIJFER])","v":3.5},{"$f":"IFERROR(TEXT(AVERAGEIF(Cursussen[VOLTOOID],\"Ja\",Cursussen[CIJFER]),\"0,00\"),\"0,00\")&\" Huidig cijfergemiddelde\"","v":"3,50 Huidig cijfergemiddelde"},{"$f":"COUNTIF(Cursussen[VOLTOOID],\"Ja\")/COUNTA(Cursussen[CURSUSTITEL])","v":0.6666666666666666},{"$f":"TEXT(COUNTIF(Cursussen[VOLTOOID],\"Ja\")/COUNTA(Cursussen[CURSUSTITEL]),\"0%\")&\" Voltooid\"","v":"67% Voltooid"}]
[null,"Opmerking: Het volgende puntenoverzicht wordt automatisch gevuld met de waarden in de onderstaande tabel voor Academische cursussen"]
[null,"VEREISTE","TOTAAL AANTAL STUDIEPUNTEN","BEHAALD","NODIG"]
[null,"Hoofdvak",{"$f":"IF(SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B8,Cursussen[STUDIEPUNTEN])=0,\"0\",SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B8,Cursussen[STUDIEPUNTEN]))","v":4},{"$f":"SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B8,Cursussen[VOLTOOID],\"Ja\")","v":4},{"$f":"SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B8,Cursussen[STUDIEPUNTEN])-SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B8,Cursussen[VOLTOOID],\"Ja\")","v":0}]
[null,"Bijvak",{"$f":"IF(SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B9,Cursussen[STUDIEPUNTEN])=0,\"0\",SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B9,Cursussen[STUDIEPUNTEN]))","v":3},{"$f":"SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B9,Cursussen[VOLTOOID],\"Ja\")","v":0},{"$f":"SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B9,Cursussen[STUDIEPUNTEN])-SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B9,Cursussen[VOLTOOID],\"Ja\")","v":3}]
[null,"Optionele cursus",{"$f":"IF(SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B10,Cursussen[STUDIEPUNTEN])=0,\"0\",SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B10,Cursussen[STUDIEPUNTEN]))","v":2},{"$f":"SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B10,Cursussen[VOLTOOID],\"Ja\")","v":2},{"$f":"SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B10,Cursussen[STUDIEPUNTEN])-SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B10,Cursussen[VOLTOOID],\"Ja\")","v":0}]
[null,"Algemene studie",{"$f":"IF(SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B11,Cursussen[STUDIEPUNTEN])=0,\"0\",SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B11,Cursussen[STUDIEPUNTEN]))","v":"0"},{"$f":"SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B11,Cursussen[VOLTOOID],\"Ja\")","v":0},{"$f":"SUMIF(Cursussen[VEREISTE],STUDIEPUNTEN!$B11,Cursussen[STUDIEPUNTEN])-SUMIFS(Cursussen[STUDIEPUNTEN],Cursussen[VEREISTE],STUDIEPUNTEN!$B11,Cursussen[VOLTOOID],\"Ja\")","v":0}]
[null,"Totaal",{"$f":"SUBTOTAL(109,STUDIEPUNTEN!$C$8:$C$11)","v":9},{"$f":"SUBTOTAL(109,STUDIEPUNTEN!$D$8:$D$11)","v":6},{"$f":"SUBTOTAL(109,STUDIEPUNTEN!$E$8:$E$11)","v":3}]
[null,"Cursussen"]
[null,"CURSUSTITEL","CURSUSNUMMER","VEREISTE","STUDIEPUNTEN","VOLTOOID","CIJFER","ONDERWIJSPERIODE"]
[null,"Cursus 1","Nummer","Hoofdvak",4,"Ja",{"v":4,"d":"4.0"},"Periode 1"]
[null,"Cursus 2","Nummer","Bijvak",3,"Nee",null,"Periode 1"]
[null,"Cursus 3","Nummer","Optionele cursus",2,"Ja",{"v":3,"d":"3.0"},"Periode 1"]

{"sheet":"BUDGET","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[5,1,5,2]]}
[null,{"$f":"Universiteit","v":"UNIVERSITEIT"}]
[null,"BUDGETTRACKER"]
[null,"Mijn budget",{"$f":"Jaar","v":"JAAR"}]
[null,"PERCENTAGE VAN INKOMEN UITGEGEVEN"]
[null,{"$f":"NETTO_MAANDELIJKSE_UITGAVEN/NETTO_MAANDELIJKSE_INKOMSTEN","v":{"v":0.7454545454545455,"d":"€ 1"}}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"NETTOMAANDINKOMEN","NETTO MAANDELIJKSE UITGAVEN","SALDO"]
[null,{"$f":"C10","v":{"v":2750,"d":"€ 2,750"}},{"$f":"'NETTO MAANDELIJKSE UITGAVEN'!C4+'UITGAVEN ONDERWIJSPERIODE'!D4","v":{"v":2050,"d":"€ 2,050"}},{"$f":"NETTO_MAANDELIJKSE_INKOMSTEN-NETTO_MAANDELIJKSE_UITGAVEN","v":{"v":700,"d":"€ 700"}}]
[null,"Maanden in onderwijsperiode",4]
[null,"MAANDELIJKSE INKOMSTEN",{"$f":"SUM(MaandelijkseInkomsten[BEDRAG])","v":{"v":2750,"d":"€ 2,750"}}]
[null,"ITEM","BEDRAG"]
[null,"Vast inkomen",{"v":1500,"d":"€ 1,500"}]
[null,"Financiële hulp",{"v":500,"d":"€ 500"}]
[null,"Leningen",{"v":500,"d":"€ 500"}]
[null,"Overige inkomsten",{"v":250,"d":"€ 250"}]

{"sheet":"NETTO MAANDELIJKSE UITGAVEN","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"Universiteit","v":"UNIVERSITEIT"}]
[null,"BUDGETTRACKER"]
[null,"Maandelijkse uitgaven",{"$f":"Jaar","v":"JAAR"}]
[null,"MAANDELIJKSE UITGAVEN",{"$f":"SUM(MaandelijkseUitgaven[BEDRAG])","v":{"v":1675,"d":"€ 1,675"}}]
[null,"ITEM","BEDRAG"]
[null,"Huur",{"v":300,"d":"€ 300"}]
[null,"Water, gas, elektriciteit",{"v":50,"d":"€ 50"}]
[null,"Mobiele telefoon",{"v":75,"d":"€ 75"}]
[null,"Boodschappen",{"v":250,"d":"€ 250"}]
[null,"Uitgaven auto",{"v":50,"d":"€ 50"}]
[null,"Studieleningen",{"v":500,"d":"€ 500"}]
[null,"Creditcards",{"v":275,"d":"€ 275"}]
[null,"Verzekering",{"v":125,"d":"€ 125"}]
[null,"Amusement",{"v":50,"d":"€ 50"}]
[null,"Diversen",{"v":0,"d":"€ 0"}]

{"sheet":"UITGAVEN ONDERWIJSPERIODE","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"Universiteit","v":"UNIVERSITEIT"}]
[null,"BUDGETTRACKER"]
[null,"Uitgaven onderwijsperiode",{"$f":"Jaar","v":"JAAR"}]
[null,"UITGAVEN ONDERWIJSPERIODE (totaal/per maand)",{"$f":"SUM(UitgavenOnderwijsperiode[BEDRAG])","v":{"v":1500,"d":"€ 1,500"}},{"$f":"SUM(UitgavenOnderwijsperiode[PER MAAND])","v":{"v":375,"d":"€ 375"}}]
[null,"ITEM","BEDRAG","PER MAAND"]
[null,"Collegegeld",{"v":750,"d":"€ 750"},{"$f":"UitgavenOnderwijsperiode[[#This Row],[BEDRAG]]/Maanden_in_periode","v":{"v":187.5,"d":"€ 188"}}]
[null,"Laboratoriumkosten",{"v":250,"d":"€ 250"},{"$f":"UitgavenOnderwijsperiode[[#This Row],[BEDRAG]]/Maanden_in_periode","v":{"v":62.5,"d":"€ 63"}}]
[null,"Boeken",{"v":500,"d":"€ 500"},{"$f":"UitgavenOnderwijsperiode[[#This Row],[BEDRAG]]/Maanden_in_periode","v":{"v":125,"d":"€ 125"}}]
[null,"Waarborgsommen",{"v":0,"d":"€ 0"},{"$f":"UitgavenOnderwijsperiode[[#This Row],[BEDRAG]]/Maanden_in_periode","v":{"v":0,"d":"€ 0"}}]
[null,"Vervoer",{"v":0,"d":"€ 0"},{"$f":"UitgavenOnderwijsperiode[[#This Row],[BEDRAG]]/Maanden_in_periode","v":{"v":0,"d":"€ 0"}}]
[null,"Andere kosten",{"v":0,"d":"€ 0"},{"$f":"UitgavenOnderwijsperiode[[#This Row],[BEDRAG]]/Maanden_in_periode","v":{"v":0,"d":"€ 0"}}]

{"sheet":"BOEKEN","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"Universiteit","v":"UNIVERSITEIT"}]
[null,"BOEKENTRACKER"]
[null,"Boekenlijst"]
[null,"TITEL","AUTEUR","CURSUS","WAAR KOPEN?","ISBN","OPMERKINGEN"]
[null,"Boektitel","Auteur","Cursus","Locatie","Nummer"]
[null,"Boektitel","Auteur","Cursus","Locatie","Nummer"]
[null,"Boektitel","Auteur","Cursus","Locatie","Nummer"]