{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Súhrn rozpočtu","Mesačné príjmy","Mesačné výdavky","Výdavky počas semestra"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Súhrn rozpočtu","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],[6,1,6,2]]}
[null,"rozpočet na štúdium"]
[null,"percentuálny podiel minutých príjmov",null,null,"V tejto bunke sa nachádza skupinový stĺpcový graf porovnávajúci mesačné príjmy a výdavky."]
[null,{"$f":"ČistéMesačnéVýdavky/ČistýMesačnýPríjem","v":{"v":0.6436363636363637,"d":"64%"}}]
[null,{"$f":"ČistéMesačnéVýdavky","v":1770}]
[null,"čistý mesačný príjem"]
[null,{"$f":"Celkové_MesačnéPríjmy","v":{"v":2750,"d":"2,750 EUR"}}]
[null,"čisté mesačné výdavky"]
[null,{"$f":"Celkové_MesačnéVýdavky+Celkové_VýdavkyPočasSemestra","v":{"v":1770,"d":"1,770 EUR"}}]
[null,"zostatok"]
[null,{"$f":"ČistýMesačnýPríjem-ČistéMesačnéVýdavky","v":{"v":980,"d":"980 EUR"}}]

{"sheet":"Mesačné príjmy","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,4]]}
[null,{"$f":"Názov_Zošita","v":"rozpočet na štúdium"}]
[null,"mesačný príjem"]
[null,"Položka","Suma"]
[null,"Fixný príjem",{"v":1500,"d":"1,500 EUR"}]
[null,"Finančná pomoc",{"v":500,"d":"500 EUR"}]
[null,"Pôžičky",{"v":500,"d":"500 EUR"}]
[null,"Iné príjmy",{"v":250,"d":"250 EUR"}]
[null,"Súčet",{"$f":"SUBTOTAL(109,MesačnéPríjmy[Suma])","v":{"v":2750,"d":"2,750 EUR"}}]

{"sheet":"Mesačné výdavky","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,{"$f":"Názov_Zošita","v":"rozpočet na štúdium"}]
[null,"mesačné výdavky"]
[null,"Položka","Suma"]
[null,"Nájomné",{"v":20,"d":"20 EUR"}]
[null,"Služby",{"v":50,"d":"50 EUR"}]
[null,"Mobilný telefón",{"v":75,"d":"75 EUR"}]
[null,"Potraviny",{"v":250,"d":"250 EUR"}]
[null,"Výdavky na auto",{"v":50,"d":"50 EUR"}]
[null,"Študentské pôžičky",{"v":500,"d":"500 EUR"}]
[null,"Kreditné karty",{"v":275,"d":"275 EUR"}]
[null,"Poistenie",{"v":125,"d":"125 EUR"}]
[null,"Kaderník",{"v":50,"d":"50 EUR"}]
[null,"Zábava",{"v":0,"d":"0 EUR"}]
[null,"Rôzne",{"v":0,"d":"0 EUR"}]
[null,"Súčet",{"$f":"SUBTOTAL(109,MesačnéVýdavky[Suma])","v":{"v":1395,"d":"1,395 EUR"}}]

{"sheet":"Výdavky počas semestra","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,5],[10,1,10,2]]}
[null,{"$f":"Názov_Zošita","v":"rozpočet na štúdium"}]
[null,"výdavky počas semestra*"]
[null,"Položka","Suma","Mesačne"]
[null,"Školné",{"v":750,"d":"750 EUR"},{"$f":"IFERROR(VýdavkyZaSemester[[#This Row],[Suma]]/4, \"\")","v":{"v":187.5,"d":"188 EUR"}}]
[null,"Poplatky za laboratóriá",{"v":250,"d":"250 EUR"},{"$f":"IFERROR(VýdavkyZaSemester[[#This Row],[Suma]]/4, \"\")","v":{"v":62.5,"d":"63 EUR"}}]
[null,"Knihy",{"v":500,"d":"500 EUR"},{"$f":"IFERROR(VýdavkyZaSemester[[#This Row],[Suma]]/4, \"\")","v":{"v":125,"d":"125 EUR"}}]
[null,"Vklady",{"v":0,"d":"0 EUR"},{"$f":"IFERROR(VýdavkyZaSemester[[#This Row],[Suma]]/4, \"\")","v":{"v":0,"d":"0 EUR"}}]
[null,"Doprava",{"v":0,"d":"0 EUR"},{"$f":"IFERROR(VýdavkyZaSemester[[#This Row],[Suma]]/4, \"\")","v":{"v":0,"d":"0 EUR"}}]
[null,"Ostatné poplatky",{"v":0,"d":"0 EUR"},{"$f":"IFERROR(VýdavkyZaSemester[[#This Row],[Suma]]/4, \"\")","v":{"v":0,"d":"0 EUR"}}]
[null,"Súčet",{"$f":"SUBTOTAL(109,VýdavkyZaSemester[Suma])","v":{"v":1500,"d":"1,500 EUR"}},{"$f":"SUBTOTAL(109,VýdavkyZaSemester[Mesačne])","v":{"v":375,"d":"375 EUR"}}]
[null,"* pri dĺžke semestra 4 mesiace"]