{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Prehľad večierkov","Zoznam hostí","Jedlo a nápoje","Ďalšie základné veci","Mriežka zasadacieho poriadku"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Prehľad večierkov","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[6,3,6,4],[6,5,6,6],[9,1,9,2],[12,1,12,2],[15,1,15,2]]}
[]
[]
[null,"Prehľad oslavy"]
[]
[]
[null,"UDALOSŤ",null,"PREHĽAD HOSTÍ",{"$nulls":3},{"$f":"\"ZOSTÁVAJÚCE POTVRDENIA ÚČASTI: \"&ZostávajúcePotvrdeniaÚčasti","v":"ZOSTÁVAJÚCE POTVRDENIA ÚČASTI: 2"}]
[null,"Oslava babičkiných 75. narodenín",null,"PREHĽAD ÚČASTI",null,"NÁKLADY NA HOSŤA",null,"SUMA ROZPOČTU"]
[{"$nulls":3},"Účasť potvrdili","Počet","Potraviny","Iní","Celkom"]
[null,"DÁTUM",null,"Dospelí",{"$f":"SUMIF(TabuľkaHostí[PRÍDE?],\"=Áno\",TabuľkaHostí[DOSPELÍ])","v":26},{"$f":"TabuľkaJedla[[#Totals],[CENA ZA DOSPELÉHO]]","v":{"v":12.690089084110037,"d":"12.69 €"}},{"$f":"ZákladnéNákladyNaHosťa","v":{"v":18.695652173913043,"d":"18.70 €"}},{"$f":"(SúhrnZaÚčastníkov[[#This Row],[Potraviny]]+SúhrnZaÚčastníkov[[#This Row],[Iní]])*PočetDetí","v":{"v":627.7148251604616,"d":"627.71 €"}}]
[null,"2011-06-14",null,"Deti",{"$f":"SUMIF(TabuľkaHostí[PRÍDE?],\"=Áno\",TabuľkaHostí[DETI])","v":20},{"$f":"TabuľkaJedla[[#Totals],[CENA ZA DIEŤA]]","v":{"v":7.252884190656953,"d":"7.25 €"}},{"$f":"ZákladnéNákladyNaHosťa","v":{"v":18.695652173913043,"d":"18.70 €"}},{"$f":"(SúhrnZaÚčastníkov[[#This Row],[Potraviny]]+SúhrnZaÚčastníkov[[#This Row],[Iní]])*PočetDetí","v":{"v":518.9707272914,"d":"518.97 €"}}]
[{"$nulls":3},"Celkom",{"$f":"SUBTOTAL(109,SúhrnZaÚčastníkov[Počet])","v":46},{"$f":"\"Priem.     \"&TEXT(SUBTOTAL(101,SúhrnZaÚčastníkov[Potraviny]),\"# ##0,00 €\")","v":"Priem.     9,97 €"},{"$f":"\"Priem.     \"&TEXT(SUBTOTAL(101,SúhrnZaÚčastníkov[Iní]),\"# ##0,00 €\")","v":"Priem.     18,70 €"},{"$f":"SUBTOTAL(109,SúhrnZaÚčastníkov[Celkom])","v":{"v":1146.6855524518614,"d":"1,146.69 €"}}]
[null,"ČAS"]
[null,"od 14:00 do 16:00"]
[]
[null,"MIESTO",null,"PREHĽAD ROZPOČTU"]
[null,"Dom tety Jany",null,"POLOŽKA","MNOŽSTVO","SUMA ROZPOČTU","CELKOVÉ NÁKLADY","ROZDIEL"]
[{"$nulls":3},"Jedlo a nápoje",{"$f":"COUNTA(TabuľkaJedla[JEDLO ALEBO NÁPOJ])","v":18},{"v":500,"d":"500.00 €"},{"$f":"TabuľkaJedla[[#Totals],[CELKOVÉ NÁKLADY]]","v":{"v":475,"d":"475.00 €"}},{"$f":"PrehľadRozpočtu[[#This Row],[SUMA ROZPOČTU]]-PrehľadRozpočtu[[#This Row],[CELKOVÉ NÁKLADY]]","v":{"v":25,"d":"25.00 €"}}]
[{"$nulls":3},{"$f":"Tabuľka1Hlavička","v":"Zariadenie & potreby"},{"$f":"COUNTA(Tabuľka1Rozpočet[Zariadenie & potreby])","v":7},{"v":400,"d":"400.00 €"},{"$f":"Tabuľka1Rozpočet[[#Totals],[Náklady]]","v":{"v":400,"d":"400.00 €"}},{"$f":"PrehľadRozpočtu[[#This Row],[SUMA ROZPOČTU]]-PrehľadRozpočtu[[#This Row],[CELKOVÉ NÁKLADY]]","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},{"$f":"Tabuľka2Hlavička","v":"Výzdoba"},{"$f":"COUNTA(Tabuľka2Rozpočet[Výzdoba])","v":4},{"v":150,"d":"150.00 €"},{"$f":"Tabuľka2Rozpočet[[#Totals],[Náklady]]","v":{"v":175,"d":"175.00 €"}},{"$f":"PrehľadRozpočtu[[#This Row],[SUMA ROZPOČTU]]-PrehľadRozpočtu[[#This Row],[CELKOVÉ NÁKLADY]]","v":{"v":-25,"d":"-25.00 €"}}]
[{"$nulls":3},{"$f":"Tabuľka3Hlavička","v":"Iní"},{"$f":"COUNTA(Tabuľka3Rozpočet[Iní])","v":4},{"v":300,"d":"300.00 €"},{"$f":"Tabuľka3Rozpočet[[#Totals],[Náklady]]","v":{"v":285,"d":"285.00 €"}},{"$f":"PrehľadRozpočtu[[#This Row],[SUMA ROZPOČTU]]-PrehľadRozpočtu[[#This Row],[CELKOVÉ NÁKLADY]]","v":{"v":15,"d":"15.00 €"}}]
[{"$nulls":3},"Celkom",{"$f":"SUBTOTAL(109,PrehľadRozpočtu[MNOŽSTVO])","v":33},{"$f":"SUBTOTAL(109,PrehľadRozpočtu[SUMA ROZPOČTU])","v":{"v":1350,"d":"1,350.00 €"}},{"$f":"SUBTOTAL(109,PrehľadRozpočtu[CELKOVÉ NÁKLADY])","v":{"v":1335,"d":"1,335.00 €"}},{"$f":"PrehľadRozpočtu[[#Totals],[SUMA ROZPOČTU]]-PrehľadRozpočtu[[#Totals],[CELKOVÉ NÁKLADY]]","v":{"v":15,"d":"15.00 €"}}]

{"sheet":"Zoznam hostí","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Zoznam hostí"]
[]
[]
[]
[null,"MENO","ADRESA","MESTO","ŠTÁT","PSČ","TELEFÓN","E-MAIL","PRÍDE?","DETI","DOSPELÍ","CELKOM"]
[null,"Rodina 1","Adresa 1","Mesto 1","Štát 1","PSČ 1","Telefón 1","E-mail 1","Nie",2,2,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":4}]
[null,"Rodina 2","Adresa 2","Mesto 2","Štát 2","PSČ 2","Telefón 2","E-mail 2","Áno",1,1,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":2}]
[null,"Rodina 3","Adresa 3","Mesto 3","Štát 3","PSČ 3","Telefón 3","E-mail 3","Áno",3,3,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":6}]
[null,"Rodina 4","Adresa 4","Mesto 4","Štát 4","PSČ 4","Telefón 4","E-mail 4",null,null,2,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":2}]
[null,"Rodina 5","Adresa 5","Mesto 5","Štát 5","PSČ 5","Telefón 5","E-mail 5","Áno",4,3,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":7}]
[null,"Rodina 6","Adresa 6","Mesto 6","Štát 6","PSČ 6","Telefón 6","E-mail 6","Áno",2,2,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":4}]
[null,"Rodina 7","Adresa 7","Mesto 7","Štát 7","PSČ 7","Telefón 7","E-mail 7","Áno",1,4,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":5}]
[null,"Rodina 8","Adresa 8","Mesto 8","Štát 8","PSČ 8","Telefón 8","E-mail 8","Nie",5,3,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":8}]
[null,"Rodina 9","Adresa 9","Mesto 9","Štát 9","PSČ 9","Telefón 9","E-mail 9","Áno",3,2,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":5}]
[null,"Rodina 10","Adresa 10","Mesto 10","Štát 10","PSČ 10","Telefón 10","E-mail 10","Áno",null,4,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":4}]
[null,"Rodina 11","Adresa 11","Mesto 11","Štát 11","PSČ 11","Telefón 11","E-mail 11","Áno",3,5,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":8}]
[null,"Rodina 12","Adresa 12","Mesto 12","Štát 12","PSČ 12","Telefón 12","E-mail 12","Nie",2,3,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":5}]
[null,"Rodina 13","Adresa 13","Mesto 13","Štát 13","PSČ 13","Telefón 13","E-mail 13","Áno",3,2,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":5}]
[null,"Rodina 14","Adresa 14","Mesto 14","Štát 14","PSČ 14","Telefón 14","E-mail 14","Nie",null,1,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":1}]
[null,"Rodina 15","Adresa 15","Mesto 15","Štát 15","PSČ 15","Telefón 15","E-mail 15",null,null,2,{"$f":"SUM(TabuľkaHostí[[#This Row],[DETI]:[DOSPELÍ]])","v":2}]

{"sheet":"Jedlo a nápoje","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Jedlo a nápoje"]
[]
[null,"Zadajte cenu a odhadované porcie na automatické vypočítanie celkového počtu porcií a ceny za porciu podľa celkovej účasti"]
[null,"JEDLO ALEBO NÁPOJ","CELKOVÉ NÁKLADY","PORCIA NA DIEŤA","PORCIA NA DOSPELÉHO","SPOLU PORCIÍ","CENA ZA PORCIU","CENA ZA DIEŤA","CENA ZA DOSPELÉHO","POZNÁMKY"]
[null,"Sóda",{"v":15,"d":"15.00 €"},0.5,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":62},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.24193548387096775,"d":"0.24 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.12096774193548387,"d":"0.12 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.4838709677419355,"d":"0.48 €"}},"2-litrové fľaše"]
[null,"Krabicové džúsy",{"v":15,"d":"15.00 €"},2,0,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":40},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.375,"d":"0.38 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.75,"d":"0.75 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0,"d":"0.00 €"}},"Jablká a biele hrozno"]
[null,"Víno",{"v":50,"d":"50.00 €"},0,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":52},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.9615384615384616,"d":"0.96 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":1.9230769230769231,"d":"1.92 €"}}]
[null,"Torta",{"v":75,"d":"75.00 €"},1,1,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":46},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":1.6304347826086956,"d":"1.63 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":1.6304347826086956,"d":"1.63 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":1.6304347826086956,"d":"1.63 €"}},"Objednať v cukrárni"]
[null,"Zmrzlina",{"v":20,"d":"20.00 €"},1,1.5,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":59},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.3389830508474576,"d":"0.34 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.3389830508474576,"d":"0.34 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.5084745762711864,"d":"0.51 €"}}]
[null,"Pudingy",{"v":15,"d":"15.00 €"},1,0,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":20},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.75,"d":"0.75 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.75,"d":"0.75 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0,"d":"0.00 €"}},"Kúpiť balené: vanilkové a čokoládové"]
[null,"Plnené hríby",{"v":32,"d":"32.00 €"},1,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":72},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.4444444444444444,"d":"0.44 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.4444444444444444,"d":"0.44 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.8888888888888888,"d":"0.89 €"}},"Šampiňóny plnené smotanovým syrom a údeninou"]
[null,"Bruschetta",{"v":22,"d":"22.00 €"},0,3,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":78},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.28205128205128205,"d":"0.28 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.8461538461538461,"d":"0.85 €"}},"Paradajky a bazalka "]
[null,"Údený losos",{"v":50,"d":"50.00 €"},1,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":72},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.6944444444444444,"d":"0.69 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.6944444444444444,"d":"0.69 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":1.3888888888888888,"d":"1.39 €"}}]
[null,"Malé žemle",{"v":20,"d":"20.00 €"},1,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":72},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.2777777777777778,"d":"0.28 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.2777777777777778,"d":"0.28 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.5555555555555556,"d":"0.56 €"}},"4 tašky – rôzne"]
[null,"Smotanový syr",{"v":10,"d":"10.00 €"},1,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":72},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.1388888888888889,"d":"0.14 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.1388888888888889,"d":"0.14 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.2777777777777778,"d":"0.28 €"}},"2 veľké tégliky"]
[null,"Kapary",{"v":12,"d":"12.00 €"},1,2,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":72},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.16666666666666666,"d":"0.17 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.16666666666666666,"d":"0.17 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.3333333333333333,"d":"0.33 €"}},"3 poháre"]
[null,"Kuracie krídelká",{"v":45,"d":"45.00 €"},2,4,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":144},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.3125,"d":"0.31 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.625,"d":"0.63 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":1.25,"d":"1.25 €"}},"Kúpiť v mäsiarstve na rohu"]
[null,"Hummus",{"v":10,"d":"10.00 €"},4,6,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":236},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.0423728813559322,"d":"0.04 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.1694915254237288,"d":"0.17 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.2542372881355932,"d":"0.25 €"}},"Urobiť deň predtým"]
[null,"Parmezánové pita lupienky",{"v":14,"d":"14.00 €"},4,6,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":236},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.059322033898305086,"d":"0.06 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.23728813559322035,"d":"0.24 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.3559322033898305,"d":"0.36 €"}},"Urobiť deň predtým"]
[null,"Zeleninová príloha",{"v":30,"d":"30.00 €"},4,10,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":340},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.08823529411764706,"d":"0.09 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.35294117647058826,"d":"0.35 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.8823529411764707,"d":"0.88 €"}},"Mrkva, zeler, brokolica, karfiol, červená a zelená paprika"]
[null,"Syrová nátierka",{"v":15,"d":"15.00 €"},5,10,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":360},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.041666666666666664,"d":"0.04 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.20833333333333331,"d":"0.21 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.41666666666666663,"d":"0.42 €"}},"Rôzne: smotanový syr, zrejúci syr, orechy"]
[null,"Keksy",{"v":25,"d":"25.00 €"},5,10,{"$f":"(TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]]*PočetDetí)+(TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]]*PočetDospelých)","v":360},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CELKOVÉ NÁKLADY]]/TabuľkaJedla[[#This Row],[SPOLU PORCIÍ]],\"\")","v":{"v":0.06944444444444445,"d":"0.07 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DIEŤA]],\"\")","v":{"v":0.3472222222222222,"d":"0.35 €"}},{"$f":"IFERROR(TabuľkaJedla[[#This Row],[CENA ZA PORCIU]]*TabuľkaJedla[[#This Row],[PORCIA NA DOSPELÉHO]],\"\")","v":{"v":0.6944444444444444,"d":"0.69 €"}},"Rôzne"]
[null,"Celkom",{"$f":"SUBTOTAL(109,TabuľkaJedla[CELKOVÉ NÁKLADY])","v":{"v":475,"d":"475.00 €"}},{"$f":"SUBTOTAL(109,TabuľkaJedla[PORCIA NA DIEŤA])","v":34.5},{"$f":"SUBTOTAL(109,TabuľkaJedla[PORCIA NA DOSPELÉHO])","v":65.5},{"$f":"SUBTOTAL(109,TabuľkaJedla[SPOLU PORCIÍ])","v":2393},{"$f":"SUBTOTAL(109,TabuľkaJedla[CENA ZA PORCIU])","v":{"v":6.915706603622084,"d":"6.92 €"}},{"$f":"SUBTOTAL(109,TabuľkaJedla[CENA ZA DIEŤA])","v":{"v":7.252884190656953,"d":"7.25 €"}},{"$f":"SUBTOTAL(109,TabuľkaJedla[CENA ZA DOSPELÉHO])","v":{"v":12.690089084110037,"d":"12.69 €"}}]

{"sheet":"Ďalšie základné veci","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Ďalšie základné veci"]
[]
[]
[null,"Zariadenie & potreby","Náklady","Kúpené","Poznámky"]
[null,"Prenájom miestnosti/sály",{"v":250,"d":"250.00 €"},"Áno"]
[null,"Obrusy",{"v":30,"d":"30.00 €"},"Áno","Nájomné"]
[null,"Stoly a stoličky",{"v":0,"d":"0.00 €"},null,"Zahrnuté v prenájme sály"]
[null,"Obrúsky k nápojom",{"v":25,"d":"25.00 €"}]
[null,"Obrúsky k jedlu",{"v":20,"d":"20.00 €"},null,"Nájomné"]
[null,"Obsluha",{"v":50,"d":"50.00 €"},null,"Nájomné"]
[null,"Riad",{"v":25,"d":"25.00 €"},null,"Nájomné"]
[null,"Celkom",{"$f":"SUBTOTAL(109,Tabuľka1Rozpočet[Náklady])","v":{"v":400,"d":"400.00 €"}}]
[]
[]
[null,"Výzdoba","Náklady","Kúpené","Poznámky"]
[null,"Balóny",{"v":25,"d":"25.00 €"}]
[null,"Nádoba s héliom",{"v":50,"d":"50.00 €"},null,"Nájomné"]
[null,"Ozdoby na stôl",{"v":100,"d":"100.00 €"},"Áno","Spolu 10"]
[null,"Sklenené vázy",{"v":0,"d":"0.00 €"},null,"Požičia Lenka"]
[null,"Celkom",{"$f":"SUBTOTAL(109,Tabuľka2Rozpočet[Náklady])","v":{"v":175,"d":"175.00 €"}}]
[]
[]
[null,"Iní","Náklady","Kúpené","Poznámky"]
[null,"Pozvánky",{"v":50,"d":"50.00 €"},"Áno"]
[null,"Poštovné",{"v":60,"d":"60.00 €"},"Áno"]
[null,"Fotograf",{"v":125,"d":"125.00 €"},null,"2 hodiny (od 14:00 do 16:00)"]
[null,"Darčekové predmety",{"v":50,"d":"50.00 €"}]
[null,"Celkom",{"$f":"SUBTOTAL(109,Tabuľka3Rozpočet[Náklady])","v":{"v":285,"d":"285.00 €"}}]

{"sheet":"Mriežka zasadacieho poriadku","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Zasadací poriadok"]
{"$rows_empty":33}
[{"$nulls":33},"*1 štvorček = približne 0,1 m2"]
["Poznámky",{"$nulls":18},{"$f":"\" Celkový počet hostí s potvrdenou účasťou: \"&PotvrdeníHostia","v":" Celkový počet hostí s potvrdenou účasťou: 46"}]
[{"$nulls":19},"Môžete použiť ktorékoľvek z nasledujúcich usporiadaní stolov:"]
[{"$nulls":20},{"$f":"ROUNDUP(PotvrdeníHostia/6,0)&\"okrúhle 1,4-metrové stoly (6 sedadiel)\"","v":"8okrúhle 1,4-metrové stoly (6 sedadiel)"}]
[{"$nulls":20},{"$f":"ROUNDUP(PotvrdeníHostia/8,0) &\" okrúhle 1,5-metrové stoly (8 sedadiel)\"","v":"6 okrúhle 1,5-metrové stoly (8 sedadiel)"}]
[{"$nulls":20},{"$f":"ROUNDUP(PotvrdeníHostia/10,0)&\"okrúhle 1,8-metrové stoly (10 sedadiel)\"","v":"5okrúhle 1,8-metrové stoly (10 sedadiel)"}]
[{"$nulls":20},{"$f":"ROUNDUP(PotvrdeníHostia/6,0)& \" obdĺžnikové stoly 0,75 x 1,8 m (6 sedadiel)\"","v":"8 obdĺžnikové stoly 0,75 x 1,8 m (6 sedadiel)"}]
[{"$nulls":20},{"$f":"ROUNDUP(PotvrdeníHostia/8,0)&\" obdĺžnikové stoly 0,75 x 2,4 m (8 sedadiel)\"","v":"6 obdĺžnikové stoly 0,75 x 2,4 m (8 sedadiel)"}]
[{"$nulls":19},"(Ideálne rozstupy medzi stolmi: 107 cm)"]