{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Plánovač dovolenkového rozpočtu"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Plánovač dovolenkového rozpočtu","index":0,"n_rows":37,"n_cols":12,"rows_kept":37,"merged":[[1,1,7,4],[9,1,9,4],[9,8,9,11],[19,1,19,4],[19,8,19,11],[30,1,30,4],[30,8,30,11]]}
[]
[null,"Plánovač \ndovolenkového rozpočtu"]
[]
[{"$nulls":8},"DOVOLENKOVÝ ROZPOČET",null,{"$f":"SUM(Dary[Rozpočet],Balenie[Rozpočet],(Cestovanie[Rozpočet],(Strava[Rozpočet],(Zábava[Rozpočet],Rôzne[Rozpočet]))))","v":{"v":750,"d":"750.00 EUR"}}]
[{"$nulls":8},"SKUTOČNÉ VÝDAVKY",null,{"$f":"SUM((Dary[Skutočné],(Balenie[Skutočné],(Cestovanie[Skutočné],(Strava[Skutočné],(Zábava[Skutočné],(Rôzne[Skutočné])))))))","v":{"v":820,"d":"820.00 EUR"}}]
[]
[{"$nulls":8},"ROZDIEL (nad alebo pod úrovňou rozpočtu)",null,{"$f":"SUM(K4-K5)","v":{"v":-70,"d":"-70.00 EUR"}}]
[]
[]
[null,"Darčeky",{"$nulls":6},"Sviatočné jedlo"]
[null,"Položka","Rozpočet","Skutočné","Rozdiel",{"$nulls":3},"Položka","Rozpočet","Skutočné","Rozdiel"]
[null,"Rodina",{"v":500,"d":"500.00 EUR"},{"v":495,"d":"495.00 EUR"},{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":5,"d":"5.00 EUR"}},{"$nulls":3},"Potraviny",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Priatelia",{"v":250,"d":"250.00 EUR"},{"v":325,"d":"325.00 EUR"},{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":-75,"d":"-75.00 EUR"}},{"$nulls":3},"Pitie",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Kolegovia",null,null,{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Výzdoba",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Učitelia, pestúnky, opatrovateľky atď.",null,null,{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Charitatívne príspevky",null,null,{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Celková hodnota",{"$f":"SUBTOTAL(109,Strava[Rozpočet])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Strava[Skutočné])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Strava[Rozdiel])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Celková hodnota",{"$f":"SUBTOTAL(109,Dary[Rozpočet])","v":{"v":750,"d":"750.00 EUR"}},{"$f":"SUBTOTAL(109,Dary[Skutočné])","v":{"v":820,"d":"820.00 EUR"}},{"$f":"SUBTOTAL(109,Dary[Rozdiel])","v":{"v":-70,"d":"-70.00 EUR"}}]
[]
[null,"Balenie",{"$nulls":6},"Zábava"]
[null,"Položka","Rozpočet","Skutočné","Rozdiel",{"$nulls":3},"Položka","Rozpočet","Skutočné","Rozdiel"]
[null,"Darčekové balenie",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Pomoc s oslavou (barman, catering, upratovacia služba atď.)",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Menovky",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Výzdoba",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Pomôcky (stuha, páska atď.)",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Jedlá a nápoje",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Škatule",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Oblečenie",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Poštovné",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Vstupenky",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Večere v reštaurácii",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Celková hodnota",{"$f":"SUBTOTAL(109,Balenie[Rozpočet])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Balenie[Skutočné])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Balenie[Rozdiel])","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[{"$nulls":8},"Celková hodnota",{"$f":"SUBTOTAL(109,Zábava[Rozpočet])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Zábava[Skutočné])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Zábava[Rozdiel])","v":{"v":0,"d":"0.00 EUR"}}]
[]
[null,"Cestovanie",{"$nulls":6},"Rôzne"]
[null,"Položka","Rozpočet","Skutočné","Rozdiel",{"$nulls":3},"Položka","Rozpočet","Skutočné","Rozdiel"]
[null,"Letenky",null,null,{"$f":"Cestovanie[[#This Row],[Rozpočet]]-Cestovanie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Fotografie z dovolenky",null,null,{"$f":"Rôzne[[#This Row],[Rozpočet]]-Rôzne[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ubytovanie",null,null,{"$f":"Cestovanie[[#This Row],[Rozpočet]]-Cestovanie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Pohonné hmoty ",null,null,{"$f":"Rôzne[[#This Row],[Rozpočet]]-Rôzne[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Doprava",null,null,{"$f":"Cestovanie[[#This Row],[Rozpočet]]-Cestovanie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Rôzne[[#This Row],[Rozpočet]]-Rôzne[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Cestovanie[[#This Row],[Rozpočet]]-Cestovanie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":3},"Celková hodnota",{"$f":"SUBTOTAL(109,Rôzne[Rozpočet])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Rôzne[Skutočné])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Rôzne[Rozdiel])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Celková hodnota",{"$f":"SUBTOTAL(109,Cestovanie[Rozpočet])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Cestovanie[Skutočné])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Cestovanie[Rozdiel])","v":{"v":0,"d":"0.00 EUR"}}]