{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Eelarve kokkuvõte","Kuu sissetulekud","Kuu väljaminekud","Semestrikulud"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Eelarve kokkuvõte","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,4,9,4],[3,1,3,2]]}
[null,"minu õppurieelarve"]
[null,"kulutatud sissetuleku protsent",null,null,"Selles lahtris asub kuu sissetulekuid ja väljaminekuid kõrvutav kobartulpdiagramm."]
[null,{"$f":"KuuNetoväljaminekud/KuuNetosissetulek","v":{"v":0.6436363636363637,"d":"64%"}}]
[null,{"$f":"KuuNetoväljaminekud","v":1770}]
[null,"kuu netosissetulek"]
[null,{"$f":"Kogusumma_Kuusissetulekud","v":{"v":2750,"d":"2,750 €"}}]
[null,"kuu netoväljaminekud"]
[null,{"$f":"Kogusumma_Kuuväljaminekud+Kogusumma_Semestrikulud","v":{"v":1770,"d":"1,770 €"}}]
[null,"saldo"]
[null,{"$f":"KuuNetosissetulek-KuuNetoväljaminekud","v":{"v":980,"d":"980 €"}}]

{"sheet":"Kuu sissetulekud","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,4]]}
[null,{"$f":"Töövihiku_pealkiri","v":"minu õppurieelarve"}]
[null,"kuu sissetulekud"]
[null,"Üksus","Summa"]
[null,"Püsisissetulek",{"v":1500,"d":"1,500 €"}]
[null,"Finantstoetus",{"v":500,"d":"500 €"}]
[null,"Laenud",{"v":500,"d":"500 €"}]
[null,"Muu sissetulek",{"v":250,"d":"250 €"}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Kuusissetulek[Summa])","v":{"v":2750,"d":"2,750 €"}}]

{"sheet":"Kuu väljaminekud","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,{"$f":"Töövihiku_pealkiri","v":"minu õppurieelarve"}]
[null,"kuu väljaminekud"]
[null,"Üksus","Summa"]
[null,"Üür",{"v":20,"d":"20 €"}]
[null,"Kommunaalid",{"v":50,"d":"50 €"}]
[null,"Mobiiltelefon",{"v":75,"d":"75 €"}]
[null,"Toit",{"v":250,"d":"250 €"}]
[null,"Auto",{"v":50,"d":"50 €"}]
[null,"Õppelaenud",{"v":500,"d":"500 €"}]
[null,"Krediitkaardid",{"v":275,"d":"275 €"}]
[null,"Kindlustus",{"v":125,"d":"125 €"}]
[null,"Juuksur",{"v":50,"d":"50 €"}]
[null,"Meelelahutus",{"v":0,"d":"0 €"}]
[null,"Muud",{"v":0,"d":"0 €"}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Kuuväljaminekud[Summa])","v":{"v":1395,"d":"1,395 €"}}]

{"sheet":"Semestrikulud","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,5],[10,1,10,2]]}
[null,{"$f":"Töövihiku_pealkiri","v":"minu õppurieelarve"}]
[null,"semestri väljaminekud *"]
[null,"Üksus","Summa","Kuu kohta"]
[null,"Õppetasud",{"v":750,"d":"750 €"},{"$f":"IFERROR(Semestrikulud[[#This Row],[Summa]]/4, \"\")","v":{"v":187.5,"d":"188 €"}}]
[null,"Laboritasud",{"v":250,"d":"250 €"},{"$f":"IFERROR(Semestrikulud[[#This Row],[Summa]]/4, \"\")","v":{"v":62.5,"d":"63 €"}}]
[null,"Raamatud",{"v":500,"d":"500 €"},{"$f":"IFERROR(Semestrikulud[[#This Row],[Summa]]/4, \"\")","v":{"v":125,"d":"125 €"}}]
[null,"Tagatised",{"v":0,"d":"0 €"},{"$f":"IFERROR(Semestrikulud[[#This Row],[Summa]]/4, \"\")","v":{"v":0,"d":"0 €"}}]
[null,"Transport",{"v":0,"d":"0 €"},{"$f":"IFERROR(Semestrikulud[[#This Row],[Summa]]/4, \"\")","v":{"v":0,"d":"0 €"}}]
[null,"Muud tasud",{"v":0,"d":"0 €"},{"$f":"IFERROR(Semestrikulud[[#This Row],[Summa]]/4, \"\")","v":{"v":0,"d":"0 €"}}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Semestrikulud[Summa])","v":{"v":1500,"d":"1,500 €"}},{"$f":"SUBTOTAL(109,Semestrikulud[Kuu kohta])","v":{"v":375,"d":"375 €"}}]
[null,"* arvutus põhineb 4-kuusel semestril"]