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

{"sheet":"Začíname","index":0,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Ako používať túto šablónu"]
[null,"Pomocou tohto plánovača dovolenkového rozpočtu môžete sledovať svoje výdavky."]
[null,"Ak chcete začať, zadajte v každej tabuľke kategórií rozpočet a skutočné výdavky."]
[null,"Rozpočet na dovolenku, celková skutočná minutá suma a rozdiel sa vypočítajú automaticky."]

{"sheet":"Plánovač dovolenkového rozpočtu","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[0,2,5,7],[2,10,2,11],[8,2,8,5],[8,10,8,13],[18,2,18,5],[18,10,18,13],[29,2,29,5],[29,10,29,13]]}
[null,null,"Plánovač \ndovolenkového rozpočtu"]
[]
[{"$nulls":10},"DOVOLENKOVÝ ROZPOČET",null,null,{"$f":"SUM(Dary[Rozpočet],Balenie[Rozpočet],(Cestovné[Rozpočet],(Strava[Rozpočet],(Zábava[Rozpočet],Rôzne[Rozpočet]))))","v":{"v":750,"d":"750.00 EUR"}}]
[{"$nulls":10},"SKUTOČNÉ VÝDAVKY",null,null,{"$f":"SUM((Dary[Skutočné],(Balenie[Skutočné],(Cestovné[Skutočné],(Strava[Skutočné],(Zábava[Skutočné],(Rôzne[Skutočné])))))))","v":{"v":820,"d":"820.00 EUR"}}]
[]
[{"$nulls":10},"ROZDIEL (nad alebo pod úrovňou rozpočtu)",null,null,{"$f":"SUM(N3-N4)","v":{"v":-70,"d":"-70.00 EUR"}}]
[]
[]
[null,null,"DARY",{"$nulls":7},"SVIATOČNÉ JEDLO"]
[null,null,"Položka","Rozpočet","Skutočné","Rozdiel",{"$nulls":4},"Položka","Rozpočet","Skutočné","Rozdiel"]
[null,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":4},"Potraviny",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,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":4},"Pitie",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,null,"Kolegovia",null,null,{"$f":"Dary[[#This Row],[Rozpočet]]-Dary[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"Výzdoba",null,null,{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,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":4},"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,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":7},{"$f":"Strava[[#This Row],[Rozpočet]]-Strava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,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,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"}},{"$nulls":4},"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,null,"BALENIE",{"$nulls":7},"ZÁBAVA"]
[null,null,"Položka","Rozpočet","Skutočné","Rozdiel",{"$nulls":4},"Položka","Rozpočet","Skutočné","Rozdiel"]
[null,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":4},"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,null,"Menovky",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"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,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":4},"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,null,"Škatule",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"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,null,"Poštovné",null,null,{"$f":"Balenie[[#This Row],[Rozpočet]]-Balenie[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"Vstupenky",null,null,{"$f":"Zábava[[#This Row],[Rozpočet]]-Zábava[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,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":4},"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"}}]
[{"$nulls":10},"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"}}]
[null,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":4},"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,null,"CESTOVANIE",{"$nulls":7},"RÔZNE"]
[null,null,"Položka","Rozpočet","Skutočné","Rozdiel",{"$nulls":4},"Položka","Rozpočet","Skutočné","Rozdiel"]
[null,null,"Letenky",null,null,{"$f":"Cestovné[[#This Row],[Rozpočet]]-Cestovné[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"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,null,"Ubytovanie",null,null,{"$f":"Cestovné[[#This Row],[Rozpočet]]-Cestovné[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"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,null,"Doprava",null,null,{"$f":"Cestovné[[#This Row],[Rozpočet]]-Cestovné[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"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,null,"Iné (stlačením klávesu Tab v poslednom stĺpci tohto riadka pridáte riadok)",null,null,{"$f":"Cestovné[[#This Row],[Rozpočet]]-Cestovné[[#This Row],[Skutočné]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,null,"Celková hodnota",{"$f":"SUBTOTAL(109,Cestovné[Rozpočet])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Cestovné[Skutočné])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUBTOTAL(109,Cestovné[Rozdiel])","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":4},"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"}}]