{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Začíname","Svadobný rozpočet","Oblečenie-hostina-hudba-fotky","Výzdoba-kvety-dary-cestovanie"],"not_rendered":{"charts":1,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Začíname","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"INFORMÁCIE O TEJTO ŠABLÓNE"]
[null,"Túto šablónu použite na sledovanie svadobných výdavkov."]
[null,"Do samostatných hárkov zadajte odhadované a skutočné náklady za rozličné kategórie."]
[null,"Súhrn svadobného rozpočtu a graf sa automaticky aktualizujú."]
[null,"Poznámka: "]
[null,"V každom hárku sú v stĺpci A uvedené ďalšie pokyny. Tento text je zámerne skrytý. Ak chcete text odstrániť, vyberte stĺpec A a potom stlačte kláves DELETE. Ak chcete text zobraziť, vyberte stĺpec A a potom zmeňte farbu písma."]
[null,"Ak chcete získať ďalšie informácie o tabuľkách, v tabuľke stlačte kláves SHIFT a potom kláves F10, vyberte možnosť TABUĽKA a potom vyberte položku ALTERNATÍVNY TEXT."]

{"sheet":"Svadobný rozpočet","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[2,2,4,5],[18,2,42,5]]}
["V tomto hárku môžete vytvoriť svadobný rozpočet. Zadaním podrobností do tabuliek hárka Oblečenie-hostina-hudba-fotografie a hárka Výzdoba-kvety-dary-cestovanie aktualizujte súhrn a graf v aktuálnom hárku. V bunkách v tomto stĺpci na nachádzajú užitočné pokyny na používanie tohto hárka. Označenie dátumu svadby je v bunke C1.",null,"Dátum svadby:"]
["Do bunky C2 zadajte dátum svadby. V bunke E2 sa automaticky spočítajú zostávajúce dni.",null,{"$f":"TODAY()+365","v":"2019-12-07"},"Zostávajúce dni:",{"$f":"C2-TODAY()","v":365}]
["V bunke C3 je uvedený nadpis tohto hárka. Ďalší pokyn je v bunke A6.",null,"Súhrn svadobného rozpočtu"]
[]
[]
["Tabuľka so súhrnom rozpočtu začínajúca v bunke C6 sa aktualizuje automaticky. Ďalší pokyn sa nachádza v bunke A19.",null,"KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,null,"Oblečenie",{"$f":"Oblečenie_celkom_odhad","v":{"v":9490,"d":"9,490.00"}},{"$f":"Oblečenie_celkom_skut","v":{"v":9770,"d":"9,770.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":-280,"d":"-280.00"}}]
[null,null,"Hostina",{"$f":"Hostina_celkom_odhad","v":{"v":1050,"d":"1,050.00"}},{"$f":"Hostina_celkom_skut","v":{"v":928,"d":"928.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":122,"d":"122.00"}}]
[null,null,"Hudba",{"$f":"Hudba_zábava_celkom_odhad","v":{"v":600,"d":"600.00"}},{"$f":"Hudba_zábava_celkom_skut","v":{"v":400,"d":"400.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":200,"d":"200.00"}}]
[null,null,"Tlačoviny",{"$f":"Tlačoviny_papiernicky_tovar_odhad","v":{"v":935,"d":"935.00"}},{"$f":"Tlačoviny_papiernicky_tovar_skut","v":{"v":870,"d":"870.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":65,"d":"65.00"}}]
[null,null,"Fotografovanie",{"$f":"Fotografovanie_celkom_odhad","v":{"v":1625,"d":"1,625.00"}},{"$f":"Fotografovanie_celkom_skut","v":{"v":1575,"d":"1,575.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":50,"d":"50.00"}}]
[null,null,"Výzdoba",{"$f":"Výzdoba_celkom_odhad","v":{"v":700,"d":"700.00"}},{"$f":"Výzdoba_celkom_skut","v":{"v":720,"d":"720.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":-20,"d":"-20.00"}}]
[null,null,"Kvety",{"$f":"Kvety_celkom_odhad","v":{"v":900,"d":"900.00"}},{"$f":"Kvety_celkom_skut","v":{"v":850,"d":"850.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":50,"d":"50.00"}}]
[null,null,"Dary",{"$f":"Dary_celkom_odhad","v":{"v":1345,"d":"1,345.00"}},{"$f":"Dary_celkom_skut","v":{"v":1075,"d":"1,075.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":270,"d":"270.00"}}]
[null,null,"Cestovanie",{"$f":"Cestovanie_preprava_celkom_odhad","v":{"v":100,"d":"100.00"}},{"$f":"Cestovanie_preprava_celkom_skut","v":{"v":165,"d":"165.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":-65,"d":"-65.00"}}]
[null,null,"Iné",{"$f":"Iné_výdavky_celkom_odhad","v":{"v":885,"d":"885.00"}},{"$f":"Iné_výdavky_celkom_skut","v":{"v":1021,"d":"1,021.00"}},{"$f":"SúhrnRozpočtu[[#This Row],[ODHADOVANÉ]]-SúhrnRozpočtu[[#This Row],[SKUTOČNÉ]]","v":{"v":-136,"d":"-136.00"}}]
[null,null,"Celkové výdavky",{"$f":"SUBTOTAL(109,SúhrnRozpočtu[ODHADOVANÉ])","v":{"v":17630,"d":"17,630.00"}},{"$f":"SUBTOTAL(109,SúhrnRozpočtu[SKUTOČNÉ])","v":{"v":17374,"d":"17,374.00"}},{"$f":"SUBTOTAL(109,SúhrnRozpočtu[NAD/POD])","v":{"v":256,"d":"256.00"}}]
[]
["Koláčový graf v bunke A19 sa aktualizuje automaticky.",null,"V tejto bunke sa nachádza koláčový graf zobrazujúci percento výdavkov jednotlivých kategórií."]

{"sheet":"Oblečenie-hostina-hudba-fotky","index":2,"n_rows":56,"n_cols":6,"rows_kept":56,"merged":[[16,1,16,4],[28,1,28,4],[29,1,29,4],[35,1,35,4],[48,1,48,4]]}
["Do príslušných tabuliek tohto hárka zadajte odhadované a skutočné náklady pre jednotlivé kategórie. Suma presiahnutia alebo nespotrebovania rozpočtu sa vypočíta automaticky. Označenie oblečenia je v bunke napravo. V bunkách v tomto stĺpci na nachádzajú užitočné pokyny na používanie tohto hárka. Začnite stlačením šípky nadol.","Oblečenie",{"$nulls":3}," "]
[" Do tabuľky Oblečenie začínajúcej v bunke napravo zadajte podrobnosti. Ďalší pokyn sa nachádza v bunke A18.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"," "]
[null,"Zásnubný prsteň/prstene",{"v":1500,"d":"1,500.00"},{"v":1500,"d":"1,500.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C3-'Oblečenie-hostina-hudba-fotky'!$D3","v":{"v":0,"d":"0.00"}}]
[null,"Nastávajúci partner 1 prsteň",{"v":2000,"d":"2,000.00"},{"v":2300,"d":"2,300.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C4-'Oblečenie-hostina-hudba-fotky'!$D4","v":{"v":-300,"d":"-300.00 "}}]
[null,"Nastávajúci partner 1 šaty/smoking",{"v":3000,"d":"3,000.00"},{"v":2750,"d":"2,750.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C5-'Oblečenie-hostina-hudba-fotky'!$D5","v":{"v":250,"d":"250.00"}}]
[null,"Nastávajúci partner 1 závoj/ozdoba hlavy",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C6-'Oblečenie-hostina-hudba-fotky'!$D6","v":{"v":0,"d":"0.00"}}]
[null,"Nastávajúci partner 1 topánky",{"v":350,"d":"350.00"},{"v":300,"d":"300.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C7-'Oblečenie-hostina-hudba-fotky'!$D7","v":{"v":50,"d":"50.00"}}]
[null,"Nastávajúci partner 1 šperky",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C8-'Oblečenie-hostina-hudba-fotky'!$D8","v":{"v":-150,"d":"-150.00 "}}]
[null,"Nastávajúci partner 1 pančuchy",{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C9-'Oblečenie-hostina-hudba-fotky'!$D9","v":{"v":0,"d":"0.00"}}]
[null,"Nastávajúci partner 2 prsteň",{"v":300,"d":"300.00"},{"v":250,"d":"250.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C10-'Oblečenie-hostina-hudba-fotky'!$D10","v":{"v":50,"d":"50.00"}}]
[null,"Nastávajúci partner 2 šaty/smoking",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C11-'Oblečenie-hostina-hudba-fotky'!$D11","v":{"v":-50,"d":"-50.00 "}}]
[null,"Nastávajúci partner 2 závoj/ozdoba hlavy",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C12-'Oblečenie-hostina-hudba-fotky'!$D12","v":{"v":0,"d":"0.00"}}]
[null,"Nastávajúci partner 2 topánky",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C13-'Oblečenie-hostina-hudba-fotky'!$D13","v":{"v":25,"d":"25.00"}}]
[null,"Nastávajúci partner 2 šperky",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C14-'Oblečenie-hostina-hudba-fotky'!$D14","v":{"v":-150,"d":"-150.00 "}}]
[null,"Nastávajúci partner 2 pančuchy",{"v":20,"d":"20.00"},{"v":25,"d":"25.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C15-'Oblečenie-hostina-hudba-fotky'!$D15","v":{"v":-5,"d":"-5.00 "}}]
[null,"Celkom za oblečenie",{"$f":"SUBTOTAL(109,Oblečenie[ODHADOVANÉ])","v":{"v":9490,"d":"9,490.00"}},{"$f":"SUBTOTAL(109,Oblečenie[SKUTOČNÉ])","v":{"v":9770,"d":"9,770.00"}},{"$f":"SUBTOTAL(109,Oblečenie[NAD/POD])","v":{"v":-280,"d":"-280.00 "}}]
[]
["Označenie hostiny je v bunke napravo.","Hostina*"]
["Do tabuľky začínajúcej v bunke napravo zadajte náklady na hostinu bez tých na zábavu a výzdobu. Ďalší pokyn sa nachádza v bunke A31.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Poplatok za miestnosť/sálu",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C20-'Oblečenie-hostina-hudba-fotky'!$D20","v":{"v":50,"d":"50.00"}}]
[null,"Stoly a stoličky",{"v":100,"d":"100.00"},{"v":50,"d":"50.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C21-'Oblečenie-hostina-hudba-fotky'!$D21","v":{"v":50,"d":"50.00"}}]
[null,"Strava",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C22-'Oblečenie-hostina-hudba-fotky'!$D22","v":{"v":0,"d":"0.00"}}]
[null,"Nápoje",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C23-'Oblečenie-hostina-hudba-fotky'!$D23","v":{"v":0,"d":"0.00"}}]
[null,"Obrusy",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C24-'Oblečenie-hostina-hudba-fotky'!$D24","v":{"v":0,"d":"0.00"}}]
[null,"Torta",{"v":700,"d":"700.00"},{"v":700,"d":"700.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C25-'Oblečenie-hostina-hudba-fotky'!$D25","v":{"v":0,"d":"0.00"}}]
[null,"Priania",{"v":50,"d":"50.00"},{"v":28,"d":"28.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C26-'Oblečenie-hostina-hudba-fotky'!$D26","v":{"v":22,"d":"22.00"}}]
[null,"Personál a výpomoc",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C27-'Oblečenie-hostina-hudba-fotky'!$D27","v":{"v":0,"d":"0.00"}}]
[null,"Celkom za hostinu",{"$f":"SUBTOTAL(109,Hostina[ODHADOVANÉ])","v":{"v":1050,"d":"1,050.00"}},{"$f":"SUBTOTAL(109,Hostina[SKUTOČNÉ])","v":{"v":928,"d":"928.00"}},{"$f":"SUBTOTAL(109,Hostina[NAD/POD])","v":{"v":122,"d":"122.00"}}]
[null,"* Bez zábavy a výzdoby"]
[]
["Označenie hudby a zábavy je v bunke napravo.","Hudba/zábava"]
["Do tabuľky Hudba začínajúcej v bunke napravo zadajte podrobnosti. Ďalší pokyn sa nachádza v bunke A37.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Hudobníci na obrad",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C33-'Oblečenie-hostina-hudba-fotky'!$D33","v":{"v":0,"d":"0.00"}}]
[null,"Kapela alebo dídžej na hostinu",{"v":200,"d":"200.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C34-'Oblečenie-hostina-hudba-fotky'!$D34","v":{"v":200,"d":"200.00"}}]
[null,"Celkom za hudbu/zábavu",{"$f":"SUBTOTAL(109,Hudba[ODHADOVANÉ])","v":{"v":600,"d":"600.00"}},{"$f":"SUBTOTAL(109,Hudba[SKUTOČNÉ])","v":{"v":400,"d":"400.00"}},{"$f":"SUBTOTAL(109,Hudba[NAD/POD])","v":{"v":200,"d":"200.00"}}]
[]
["Označenie tlačovín a papiernickeho tovaru je v bunke napravo.","Tlačoviny/papiernicky tovar"]
["Do tabuľky Tlačoviny začínajúcej v bunke napravo zadajte podrobnosti. Ďalší pokyn je v bunke A50.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Pozvánky",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C39-'Oblečenie-hostina-hudba-fotky'!$D39","v":{"v":50,"d":"50.00"}}]
[null,"Oznámenia",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C40-'Oblečenie-hostina-hudba-fotky'!$D40","v":{"v":25,"d":"25.00"}}]
[null,"Poďakovania",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C41-'Oblečenie-hostina-hudba-fotky'!$D41","v":{"v":0,"d":"0.00"}}]
[null,"Osobné písacie potreby",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C42-'Oblečenie-hostina-hudba-fotky'!$D42","v":{"v":0,"d":"0.00"}}]
[null,"Kniha návštev",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C43-'Oblečenie-hostina-hudba-fotky'!$D43","v":{"v":0,"d":"0.00"}}]
[null,"Programy",{"v":75,"d":"75.00"},{"v":80,"d":"80.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C44-'Oblečenie-hostina-hudba-fotky'!$D44","v":{"v":-5,"d":"-5.00 "}}]
[null,"Obrúsky na hostinu",{"v":35,"d":"35.00"},{"v":40,"d":"40.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C45-'Oblečenie-hostina-hudba-fotky'!$D45","v":{"v":-5,"d":"-5.00 "}}]
[null,"Zápalky",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C46-'Oblečenie-hostina-hudba-fotky'!$D46","v":{"v":0,"d":"0.00"}}]
[null,"Kaligrafia",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C47-'Oblečenie-hostina-hudba-fotky'!$D47","v":{"v":0,"d":"0.00"}}]
[null,"Celkom za tlačoviny/papiernicky tovar",{"$f":"SUBTOTAL(109,Tlač[ODHADOVANÉ])","v":{"v":935,"d":"935.00"}},{"$f":"SUBTOTAL(109,Tlač[SKUTOČNÉ])","v":{"v":870,"d":"870.00"}},{"$f":"SUBTOTAL(109,Tlač[NAD/POD])","v":{"v":65,"d":"65.00"}}]
[]
["Označenie fotografovania je v bunke napravo.","Fotografovanie"]
["Do tabuľky Fotografovanie začínajúcej v bunke napravo zadajte podrobnosti.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Oficiálne",{"v":1300,"d":"1,300.00"},{"v":1300,"d":"1,300.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C52-'Oblečenie-hostina-hudba-fotky'!$D52","v":{"v":0,"d":"0.00"}}]
[null,"Ďalšie výtlačky",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C53-'Oblečenie-hostina-hudba-fotky'!$D53","v":{"v":0,"d":"0.00"}}]
[null,"Fotoalbumy",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C54-'Oblečenie-hostina-hudba-fotky'!$D54","v":{"v":0,"d":"0.00"}}]
[null,"Videonahrávky",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"'Oblečenie-hostina-hudba-fotky'!$C55-'Oblečenie-hostina-hudba-fotky'!$D55","v":{"v":50,"d":"50.00"}}]
[null,"Celkom za fotografovanie",{"$f":"SUBTOTAL(109,Fotografovanie[ODHADOVANÉ])","v":{"v":1625,"d":"1,625.00"}},{"$f":"SUBTOTAL(109,Fotografovanie[SKUTOČNÉ])","v":{"v":1575,"d":"1,575.00"}},{"$f":"SUBTOTAL(109,Fotografovanie[NAD/POD])","v":{"v":50,"d":"50.00"}}]

{"sheet":"Výzdoba-kvety-dary-cestovanie","index":3,"n_rows":48,"n_cols":5,"rows_kept":48,"merged":[[8,1,8,4],[9,1,9,4],[18,1,18,4],[27,1,27,4],[34,1,34,4]]}
["Do príslušných tabuliek tohto hárka zadajte odhadované a skutočné náklady pre jednotlivé kategórie. Suma presiahnutia alebo nespotrebovania rozpočtu sa vypočíta automaticky. Označenie výzdoby je v bunke napravo. V bunkách v tomto stĺpci na nachádzajú užitočné pokyny na používanie tohto hárka. Začnite stlačením šípky nadol.","Výzdoba*"]
["Zadajte náklady na dekorácie bez nákladov na kvety v tabuľke začínajúcej v bunke napravo. Ďalší pokyn je v bunke A11.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Mašle pre sedenie",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C3-'Výzdoba-kvety-dary-cestovanie'!$D3","v":{"v":0,"d":"0.00"}}]
[null,"Stolná výzdoba",{"v":300,"d":"300.00"},{"v":320,"d":"320.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C4-'Výzdoba-kvety-dary-cestovanie'!$D4","v":{"v":-20,"d":"-20.00 "}}]
[null,"Sviečky",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C5-'Výzdoba-kvety-dary-cestovanie'!$D5","v":{"v":25,"d":"25.00"}}]
[null,"Osvetlenie",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C6-'Výzdoba-kvety-dary-cestovanie'!$D6","v":{"v":25,"d":"25.00"}}]
[null,"Balóny",{"v":200,"d":"200.00"},{"v":250,"d":"250.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C7-'Výzdoba-kvety-dary-cestovanie'!$D7","v":{"v":-50,"d":"-50.00 "}}]
[null,"Celkom za výzdobu",{"$f":"SUBTOTAL(109,Výzdoba[ODHADOVANÉ])","v":{"v":700,"d":"700.00"}},{"$f":"SUBTOTAL(109,Výzdoba[SKUTOČNÉ])","v":{"v":720,"d":"720.00"}},{"$f":"SUBTOTAL(109,Výzdoba[NAD/POD])","v":{"v":-20,"d":"-20.00 "}}]
[null,"*Bez kvetov"]
[]
["Označenie kvetov je v bunke napravo.","Kvety"]
["Do tabuľky Kvety začínajúcej v bunke napravo zadajte podrobnosti. Ďalší pokyn je v bunke A20.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Kytice",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C13-'Výzdoba-kvety-dary-cestovanie'!$D13","v":{"v":50,"d":"50.00"}}]
[null,"Pierka",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C14-'Výzdoba-kvety-dary-cestovanie'!$D14","v":{"v":0,"d":"0.00"}}]
[null,"Náramky na ruku",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C15-'Výzdoba-kvety-dary-cestovanie'!$D15","v":{"v":0,"d":"0.00"}}]
[null,"Obrad",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C16-'Výzdoba-kvety-dary-cestovanie'!$D16","v":{"v":0,"d":"0.00"}}]
[null,"Hostina",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C17-'Výzdoba-kvety-dary-cestovanie'!$D17","v":{"v":0,"d":"0.00"}}]
[null,"Celkom za kvety",{"$f":"SUBTOTAL(109,Kvety[ODHADOVANÉ])","v":{"v":900,"d":"900.00"}},{"$f":"SUBTOTAL(109,Kvety[SKUTOČNÉ])","v":{"v":850,"d":"850.00"}},{"$f":"SUBTOTAL(109,Kvety[NAD/POD])","v":{"v":50,"d":"50.00"}}]
[]
["Označenie darov je v bunke napravo","Dary"]
["Do tabuľky Dary začínajúcej v bunke napravo zadajte podrobnosti. Ďalší pokyn je v bunke A29.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Účastníci",{"v":1000,"d":"1,000.00"},{"v":400,"d":"400.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C22-'Výzdoba-kvety-dary-cestovanie'!$D22","v":{"v":600,"d":"600.00"}}]
[null,"Nastávajúci partner 1",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C23-'Výzdoba-kvety-dary-cestovanie'!$D23","v":{"v":-50,"d":"-50.00 "}}]
[null,"Nastávajúci partner 2",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C24-'Výzdoba-kvety-dary-cestovanie'!$D24","v":{"v":-50,"d":"-50.00 "}}]
[null,"Rodičia",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C25-'Výzdoba-kvety-dary-cestovanie'!$D25","v":{"v":0,"d":"0.00"}}]
[null,"Čítajúci/iní účastníci",{"v":20,"d":"20.00"},{"v":250,"d":"250.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C26-'Výzdoba-kvety-dary-cestovanie'!$D26","v":{"v":-230,"d":"-230.00 "}}]
[null,"Celkom za dary",{"$f":"SUBTOTAL(109,Dary[ODHADOVANÉ])","v":{"v":1345,"d":"1,345.00"}},{"$f":"SUBTOTAL(109,Dary[SKUTOČNÉ])","v":{"v":1075,"d":"1,075.00"}},{"$f":"SUBTOTAL(109,Dary[NAD/POD])","v":{"v":270,"d":"270.00"}}]
[]
["Označenie cestovania alebo prepravy je v bunke napravo.","Cestovanie/preprava"]
["Do tabuľky Cestovanie začínajúcej v bunke napravo zadajte podrobnosti. Ďalší pokyn je v bunke A36.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Limuzíny alebo autá",{"v":100,"d":"100.00"},{"v":125,"d":"125.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C31-'Výzdoba-kvety-dary-cestovanie'!$D31","v":{"v":-25,"d":"-25.00 "}}]
[null,"Parkovanie",{"v":0,"d":"0.00"},{"v":40,"d":"40.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C32-'Výzdoba-kvety-dary-cestovanie'!$D32","v":{"v":-40,"d":"-40.00 "}}]
[null,"Taxíky",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C33-'Výzdoba-kvety-dary-cestovanie'!$D33","v":{"v":0,"d":"0.00"}}]
[null,"Celkom za cestovanie/prepravu",{"$f":"SUBTOTAL(109,Cestovanie[ODHADOVANÉ])","v":{"v":100,"d":"100.00"}},{"$f":"SUBTOTAL(109,Cestovanie[SKUTOČNÉ])","v":{"v":165,"d":"165.00"}},{"$f":"SUBTOTAL(109,Cestovanie[NAD/POD])","v":{"v":-65,"d":"-65.00 "}}]
[]
["Označenie iných výdavkov je v bunke napravo.","Ďalšie výdavky"]
["Do tabuľky Ďalšie výdavky začínajúcej v bunke napravo zadajte podrobnosti.","KATEGÓRIA","ODHADOVANÉ","SKUTOČNÉ","NAD/POD"]
[null,"Sobášiaca osoba",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C38-'Výzdoba-kvety-dary-cestovanie'!$D38","v":{"v":0,"d":"0.00"}}]
[null,"Poplatok za kostol alebo obrad",{"v":40,"d":"40.00"},{"v":55,"d":"55.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C39-'Výzdoba-kvety-dary-cestovanie'!$D39","v":{"v":-15,"d":"-15.00 "}}]
[null,"Starejší",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C40-'Výzdoba-kvety-dary-cestovanie'!$D40","v":{"v":0,"d":"0.00"}}]
[null,"Skúšobná večera",{"v":450,"d":"450.00"},{"v":450,"d":"450.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C41-'Výzdoba-kvety-dary-cestovanie'!$D41","v":{"v":0,"d":"0.00"}}]
[null,"Oslava zásnub",{"v":20,"d":"20.00"},{"v":50,"d":"50.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C42-'Výzdoba-kvety-dary-cestovanie'!$D42","v":{"v":-30,"d":"-30.00 "}}]
[null,"Večierky",{"v":30,"d":"30.00"},{"v":20,"d":"20.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C43-'Výzdoba-kvety-dary-cestovanie'!$D43","v":{"v":10,"d":"10.00"}}]
[null,"Návštevy kaderníctiev",{"v":45,"d":"45.00"},{"v":46,"d":"46.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C44-'Výzdoba-kvety-dary-cestovanie'!$D44","v":{"v":-1,"d":"-1.00 "}}]
[null,"Rozlúčky so slobodou",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C45-'Výzdoba-kvety-dary-cestovanie'!$D45","v":{"v":0,"d":"0.00"}}]
[null,"Raňajky a obed",{"v":300,"d":"300.00"},{"v":400,"d":"400.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C46-'Výzdoba-kvety-dary-cestovanie'!$D46","v":{"v":-100,"d":"-100.00 "}}]
[null,"Hotelové izby",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"'Výzdoba-kvety-dary-cestovanie'!$C47-'Výzdoba-kvety-dary-cestovanie'!$D47","v":{"v":0,"d":"0.00"}}]
[null,"Celkom za iné výdavky",{"$f":"SUBTOTAL(109,ĎalšieVýdavky[ODHADOVANÉ])","v":{"v":885,"d":"885.00"}},{"$f":"SUBTOTAL(109,ĎalšieVýdavky[SKUTOČNÉ])","v":{"v":1021,"d":"1,021.00"}},{"$f":"SUBTOTAL(109,ĎalšieVýdavky[NAD/POD])","v":{"v":-136,"d":"-136.00 "}}]