{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["kalendar","rozpis_podla_deti"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":2,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"kalendar","index":0,"n_rows":114,"n_cols":16,"rows_kept":114,"cut":false,"hidden":false,"merged":[[3,1,43,1],[10,16,10,20],[48,1,75,1],[80,1,107,1]]}
["ZARIADENIE","TEN HALA"]
[null,null,null,1,2,3,4,5]
["K",null,"čas","Pondelok","Utorok","Streda","Štvrtok","Piatok","Piatok","nákady","Pondelok","Utorok","Streda","Štvrtok","Piatok"]
[1,"TENISOVÁ HALA","13:00:00","","Crkoňová Tereza","","Crkoňová Tereza","Kurcinová Viktoria",null,null,27,27,27,27,27]
[{"$f":"IF(C5=C4,A4+1,1)","v":2},null,{"$f":"C4","v":"13:00:00"},"","Dvorščíková Vanessa","","Dvorščíková Vanessa","Luhová Nela",null,null,null,null,null,null,null,"Iva Dovičinová"]
[{"$f":"IF(C6=C5,A5+1,1)","v":3},null,{"$f":"C5","v":"13:00:00"},"","Kurcinová Viktoria","","Tomáš Daniel","Miková Lucia",null,null,null,null,null,null,null,"Róbert Janiga"]
[4,null,"13:00:00","","Luhová Nela","","Virgová Vivien","Vetešková Laura",null,null,null,null,null,null,null,"Lenka Janigová"]
[1,null,{"$f":"C4+1/24","v":"14:00:00"},"Faktor Max","Hudcovská Alžbeta Ella","Dorociaková Daniela","","Dvorščík Damián",null,null,27,27,27,27,27,"dorast/muži"]
[2,null,{"$f":"C5+1/24","v":"14:00:00"},"Hlavačková Katarína","Rosinová Nina","Dvorščík Damián","","Hudcovská Alžbeta Ella",null,null,null,null,null,null,null,"neobsadené hodiny"]
[3,null,"14:00:00","Ondričková Olivia","Žiačiková Nela","Tomáš Timotej","","Kurcinová Mária"]
[4,null,"14:00:00","Vetešková Laura","","","","Rosinová Nina"]
[5,null,{"$f":"C11","v":"14:00:00"},"","","","",""]
[{"$f":"IF(C13=C11,A11+1,1)","v":1},null,{"$f":"C8+1/24","v":"15:00:00"},"","Hlavačková Katarína","","","Faktor Max",null,null,null,29,null,null,29]
[2,null,{"$f":"C9+1/24","v":"15:00:00"},"","Janíková Nicole","","","Ondričková Olivia"]
[3,null,{"$f":"C10+1/24","v":"15:00:00"},"","Kurcinová Mária","","","Pechová Michaela"]
[4,null,{"$f":"C11+1/24","v":"15:00:00"},"","Paliesek Samuel","","","Vrábel Martin"]
[1,null,"16:00:00","Chovancová Katka","","","","Janíková Nicole",null,null,29,null,null,null,29]
[2,null,"16:00:00","Pechová Michaela","","","","Jurgová Lucia"]
[3,null,"16:00:00","Varjassy Filip","","","","Virga Max"]
[4,null,"16:00:00","Vrábel Martin","","","","Žiačiková Nela"]
[1,null,"17:00:00","","","","",""]
[2,null,"17:00:00","","","","",""]
[3,null,"17:00:00","","","","",""]
[4,null,"17:00:00","","","","",""]
[1,null,"18:00:00","","","","",""]
[2,null,"18:00:00","","","","",""]
[3,null,"18:00:00","","","","",""]
[4,null,"18:00:00","","","","",""]
[1,null,"19:00:00","","","","Belavá Eliška","",null,null,null,null,null,29]
[2,null,"19:00:00","","","","Belavá Nikoleta",""]
[3,null,"19:00:00","","","","Chovancová Katka",""]
[4,null,"19:00:00","","","","",""]
[1,null,{"$f":"C29+1/48","v":"19:30:00"},"","","","","Schulcz Jakub",null,null,null,null,null,null,48]
[2,null,{"$f":"C30+1/48","v":"19:30:00"},"","","","","Hráč1, 2, 3","kurt č. 3"]
[3,null,"19:30:00","","","","","člen1, 2"]
[4,null,"19:30:00","","","","","člen3, 4"]
[1,null,"20:00:00","","","Kučiak Dominik","Dospelí-1","",null,null,null,null,29,16]
[2,null,"20:00:00","","","Schulcz Jakub","Dospelí-2",""]
[3,null,"20:00:00","","","Virga Max","Dospelí-3",""]
[4,null,"20:00:00","","","","Dospelí-4",""]
[1,null,"20:30:00","","","","",""]
[2,null,"20:30:00","","","","",""]
[3,null,"20:30:00","","","","",""]
[4,null,"20:30:00","","","","",""]
[]
["ZARIADENIE","BEDMINTON"]
[null,null,null,1,2,3,4,5]
["B",null,"čas","Pondelok","Utorok","Streda","Štvrtok","Piatok"]
[1,"BEDMINTON","13:00:00","","","","",""]
[{"$f":"IF(C50=C49,A49+1,1)","v":2},null,{"$f":"C49","v":"13:00:00"},"","","","",""]
[3,null,{"$f":"C50","v":"13:00:00"},"","","","",""]
[4,null,{"$f":"C51","v":"13:00:00"},"","","","",""]
[1,null,{"$f":"C49+1/24","v":"14:00:00"},"","","","",""]
[2,null,"14:00:00","","","","",""]
[3,null,"14:00:00","","","","",""]
[4,null,"14:00:00","","","","",""]
[1,null,"15:00:00","Kravčík Patrik","","","","",null,null,20]
[2,null,"15:00:00","Pechová Natália","","","",""]
[3,null,"15:00:00","Rosinová Adriana","","","",""]
[4,null,"15:00:00","Špilák Filip","","","",""]
[1,null,"16:00:00","","","","",""]
[2,null,"16:00:00","","","","",""]
[3,null,"16:00:00","","","","",""]
[4,null,"16:00:00","","","","",""]
[1,null,"17:00:00","","Lukáč Filip","","Lukáč Filip","",null,null,null,22,null,22]
[2,null,"17:00:00","","Rosinová Adriana","","Pontes Kristýna",""]
[3,null,"17:00:00","","Tomáš Daniel","","Velits Adam",""]
[4,null,"17:00:00","","Virgová Vivien","","",""]
[1,null,"18:00:00","","","","",""]
[2,null,"18:00:00","","","","",""]
[3,null,"18:00:00","","","","",""]
[4,null,"18:00:00","","","","",""]
[1,null,"19:00:00","","","","",""]
[2,null,"19:00:00","","","","",""]
[3,null,"19:00:00","","","","",""]
[4,null,"19:00:00","","","","",""]
[]
["ZARIADENIE"]
[]
["A","STC ARéNA","čas","Pondelok","Utorok","Streda","Štvrtok","Piatok","Piatok"]
[1,"STC ARéNA","14:00:00","","","","",""]
[{"$f":"IF(C82=C81,A81+1,1)","v":2},null,{"$f":"C81","v":"14:00:00"},"","","","",""]
[3,null,{"$f":"C82","v":"14:00:00"},"","","","",""]
[4,null,{"$f":"C83","v":"14:00:00"},"","","","",""]
[1,null,{"$f":"C81+1/24","v":"15:00:00"},"","","","",""]
[2,null,"15:00:00","","","","",""]
[3,null,"15:00:00","","","","",""]
[4,null,"15:00:00","","","","",""]
[1,null,{"$f":"C85+1/48","v":"15:30:00"},"","","Pontes Kristýna","","",null,null,null,null,17]
[2,null,{"$f":"C86+1/48","v":"15:30:00"},"","","Šišková Tamara","",""]
[3,null,"15:30:00","","","Špilák Filip","",""]
[4,null,"15:30:00","","","Velits Adam","",""]
[1,null,{"$f":"C89+1/48","v":"16:00:00"},"","","","","Kukosová Alžbet",null,null,null,null,null,null,14]
[2,null,{"$f":"C90+1/48","v":"16:00:00"},"","","","","Novosadová Diana"]
[3,null,{"$f":"C91+1/48","v":"16:00:00"},"","","","","Pastorek Adam"]
[4,null,{"$f":"C92+1/48","v":"16:00:00"},"","","","","Šišková Tamara"]
[1,null,{"$f":"C93+1/48","v":"16:30:00"},"","","Jurgová Lucia","","",null,null,null,null,17]
[2,null,{"$f":"C94+1/48","v":"16:30:00"},"","","Kravčík Patrik","",""]
[3,null,"16:30:00","","","Miková Lucia","",""]
[4,null,"16:30:00","","","Pechová Natália","",""]
[1,null,{"$f":"C97+1/24","v":"17:30:00"},"","","Kukosová Alžbet","","",null,null,null,null,17]
[2,null,"17:30:00","","","Novosadová Diana","",""]
[3,null,"17:30:00","","","Pastorek Adam","",""]
[4,null,"17:30:00","","","","",""]
[1,null,{"$f":"C101+1/48","v":"18:00:00"},"","","","",""]
[2,null,"18:00:00","","","","",""]
[3,null,"18:00:00","","","","",""]
[4,null,"18:00:00","","","","",""]
[]
[]
[]
[]
[]
[null,null,null,1,2,3,4,5]

{"sheet":"rozpis_podla_deti","index":1,"n_rows":159,"n_cols":16,"rows_kept":159,"cut":false,"hidden":false,"merged":[[48,0,88,0],[55,10,55,14],[93,0,120,0],[125,0,152,0],[20,3,20,6]]}
[null,null,"Predmet",{"$f":"CONCATENATE(\"Informácia o tréningoch - \",D38)","v":"Informácia o tréningoch - Paliesek Samuel"}]
[]
[null,null,"mail",{"$f":"VLOOKUP(D38,[1]deti_a_sutazni!$B$2:$F$100,5,0)","v":"hpmroman@hpm.sk"}]
[null,null,"copy to:","tkpuchov@centrum.sk"]
[null,null,"bcc:"]
[]
["Vážení rodičia,"]
[]
["posielame vám informácie ohľadom tréningov počas halovej sezóny a mesačný paušál, ktorý je splatný vopred do"]
["10teho dňa príslušného mesiaca, tzn. platba za November je splatná 10.11.2018 na účet TK Púchov číslo:"]
["SK86 1100 0000 0026 2170 2055"]
["ako účel platby prosíme uviesť \"príspevky na halovú sezónu\"."]
[{"$f":"CONCATENATE(\"Mesačný paušál: \",TEXT(G38,\"# ##0,00€\"))","v":"Mesačný paušál: 22,65€"}]
[{"$f":"CONCATENATE(\"Variabilný symbol: \",VLOOKUP($D$38,[1]hala2018!$C$2:$I$100,7,0))","v":"Variabilný symbol: 36"}]
["Prosím, pozrite si dole priložený rozpis tréningov a v prípade požiadavky na zmenu ma čo najskôr kontaktujte emailom alebo telefonicky."]
[]
["Prajem pekný deň."]
[]
["Vladimír Kuchař,  predseda klubu, mobil 0948860260"]
["Kontakty: www.tkpuchov.sk/kontakt.html"]
[null,null,null,"Počet detí na tréningu"]
[null,null,"Ceny na hodinu a hráča",4,3,2,1]
[null,null,"Tenisová hala - do 15:00",4.75,6.333333333333333,9.5,24.34]
[null,null,"Tenisová hala - po 15:00",5.25,7,10.5,26.34]
[null,null,"Bedminton Aqua šport - do 16:00",4.25,5.666666666666667,8.5,17.34]
[null,null,"Bedminton Aqua šport - po 16:00",4.75,6.333333333333333,9.5,19.34]
[null,null,"STC Aréna",3.75,5,7.5,14.34]
[]
[null,null,"Mesačné paušály - 2hodiny/týždeň ",4,3,2,1]
[null,null,"Tenisová hala - do 15:00",40.98571428571428,54.647619047619045,81.971428571428561,210.01942857142856]
[null,null,"Tenisová hala - po 15:00",45.3,60.4,90.6,227.2765714285714]
[null,null,"Bedminton Aqua šport - do 16:00",36.671428571428571,48.895238095238092,73.342857142857142,149.61942857142856]
[null,null,"Bedminton Aqua šport - po 16:00",40.98571428571428,54.647619047619045,81.971428571428561,166.87657142857142]
[null,null,"STC Aréna",32.357142857142854,43.142857142857139,64.714285714285708,123.73371428571427]
[]
[]
[null,null,"TRÉNINGY:"]
[null,null,"Meno","Paliesek Samuel",null,"Mesačný paušál:",{"$f":"(30+31+31+28+31)/5/7*H39","v":22.65}]
[null,null,null,null,null,null,null,{"$f":"SUM(H41:H93)","v":5.25}]
[null,null,"deň","ZARIADENIE","dvorec a čas","tréner","Počet tréningov/týždeň","Cena"]
[null,null,"Utorok","Tenis. Hala","K3 15:00","Dovičinová",1,5.25,null,null,null,null,null,null,null,{"$f":"D3","v":"hpmroman@hpm.sk"}]
[]
[]
[]
[]
[]
[]
[null,"čas","Pondelok","Utorok","Streda","Štvrtok","Piatok"]
["TENISOVÁ HALA","13:00:00","Vetešková Laura","Crkoňová Tereza","","Crkoňová Tereza","Kurcinová Viktoria"]
[null,{"$f":"B49","v":"13:00:00"},"","Dvorščíková Vanessa","","Dvorščíková Vanessa","Luhová Nela",null,null,"Iva Dovičinová"]
[null,{"$f":"B50","v":"13:00:00"},"","Kurcinová Viktoria","","Tomáš Daniel","Miková Lucia",null,null,"Róbert Janiga"]
[null,"13:00:00","","Luhová Nela","","Virgová Vivien","Vetešková Laura",null,null,"Lenka Janigová"]
[null,{"$f":"B49+1/24","v":"14:00:00"},"Ondričková Olivia","Hudcovská Alžbeta Ella","Dvorščík Damián","Dorociaková Daniela","Dvorščík Damián",null,null,"dorast/muži"]
[null,{"$f":"B50+1/24","v":"14:00:00"},"","Rosinová Nina","Faktor Max","","Hudcovská Alžbeta Ella",null,null,"individuálne tréningy, znížená dotácia klubu"]
[null,"14:00:00","","Žiačiková Nela","Hlavačková Katarína","","Kurcinová Mária"]
[null,"14:00:00","","","","","Rosinová Nina"]
[null,{"$f":"B56","v":"14:00:00"},"","","","",""]
[null,{"$f":"B53+1/24","v":"15:00:00"},"","Hlavačková Katarína","","","Faktor Max"]
[null,{"$f":"B54+1/24","v":"15:00:00"},"","Janíková Nicole","","","Ondričková Olivia"]
[null,{"$f":"B55+1/24","v":"15:00:00"},"","Kurcinová Mária","","","Pechová Michaela"]
[null,{"$f":"B56+1/24","v":"15:00:00"},"","Paliesek Samuel","","","Vrábel Martin"]
[null,"16:00:00","Chovancová Katka","","","","Janíková Nicole"]
[null,"16:00:00","Pechová Michaela","","","","Jurgová Lucia"]
[null,"16:00:00","Varjassy Filip","","","","Virga Max"]
[null,"16:00:00","Vrábel Martin","","","","Žiačiková Nela"]
[null,"17:00:00","","","","",""]
[null,"17:00:00","","","","",""]
[null,"17:00:00","","","","",""]
[null,"17:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"19:00:00","","","","Belavá Eliška",""]
[null,"19:00:00","","","","Belavá Nikoleta",""]
[null,"19:00:00","","","","Chovancová Katka",""]
[null,"19:00:00","","","","",""]
[null,{"$f":"B74+1/48","v":"19:30:00"},"","","","","Schulcz Jakub"]
[null,{"$f":"B75+1/48","v":"19:30:00"},"","","","","Hráč1, 2, 3"]
[null,"19:30:00","","","","","člen1, 2"]
[null,"19:30:00","","","","","člen3, 4"]
[null,"20:00:00","","","Kučiak Dominik","Dospelí-1",""]
[null,"20:00:00","","","Schulcz Jakub","Dospelí-2",""]
[null,"20:00:00","","","Virga Max","Dospelí-3",""]
[null,"20:00:00","","","","Dospelí-4",""]
[null,"20:30:00","","","","",""]
[null,"20:30:00","","","","",""]
[null,"20:30:00","","","","",""]
[null,"20:30:00","","","","",""]
[]
["BEDMINTON"]
[null,null,1,2,3,4,5]
[null,"čas","Pondelok","Utorok","Streda","Štvrtok","Piatok"]
["BEDMINTON","13:00:00","","","","",""]
[null,{"$f":"B94","v":"13:00:00"},"","","","",""]
[null,{"$f":"B95","v":"13:00:00"},"","","","",""]
[null,{"$f":"B96","v":"13:00:00"},"","","","",""]
[null,{"$f":"B94+1/24","v":"14:00:00"},"","","","",""]
[null,"14:00:00","","","","",""]
[null,"14:00:00","","","","",""]
[null,"14:00:00","","","","",""]
[null,"15:00:00","Kravčík Patrik","","","",""]
[null,"15:00:00","Pechová Natália","","","",""]
[null,"15:00:00","Rosinová Adriana","","","",""]
[null,"15:00:00","Špilák Filip","","","",""]
[null,"16:00:00","","","","",""]
[null,"16:00:00","","","","",""]
[null,"16:00:00","","","","",""]
[null,"16:00:00","","","","",""]
[null,"17:00:00","","Lukáč Filip","","Lukáč Filip",""]
[null,"17:00:00","","Rosinová Adriana","","Pontes Kristýna",""]
[null,"17:00:00","","Tomáš Daniel","","Velits Adam",""]
[null,"17:00:00","","Virgová Vivien","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"19:00:00","","","","",""]
[null,"19:00:00","","","","",""]
[null,"19:00:00","","","","",""]
[null,"19:00:00","","","","",""]
[]
[]
[]
["STC ARéNA","čas","Pondelok","Utorok","Streda","Štvrtok","Piatok"]
["STC ARéNA","14:00:00","","","","",""]
[null,{"$f":"B126","v":"14:00:00"},"","","","",""]
[null,{"$f":"B127","v":"14:00:00"},"","","","",""]
[null,{"$f":"B128","v":"14:00:00"},"","","","",""]
[null,{"$f":"B126+1/24","v":"15:00:00"},"","","","",""]
[null,"15:00:00","","","","",""]
[null,"15:00:00","","","","",""]
[null,"15:00:00","","","","",""]
[null,{"$f":"B130+1/48","v":"15:30:00"},"","","Pontes Kristýna","",""]
[null,{"$f":"B131+1/48","v":"15:30:00"},"","","Šišková Tamara","",""]
[null,"15:30:00","","","Špilák Filip","",""]
[null,"15:30:00","","","Velits Adam","",""]
[null,{"$f":"B134+1/48","v":"16:00:00"},"","","","","Kukosová Alžbet"]
[null,{"$f":"B135+1/48","v":"16:00:00"},"","","","","Novosadová Diana"]
[null,{"$f":"B136+1/48","v":"16:00:00"},"","","","","Pastorek Adam"]
[null,{"$f":"B137+1/48","v":"16:00:00"},"","","","","Šišková Tamara"]
[null,{"$f":"B138+1/48","v":"16:30:00"},"","","Jurgová Lucia","",""]
[null,{"$f":"B139+1/48","v":"16:30:00"},"","","Kravčík Patrik","",""]
[null,"16:30:00","","","Miková Lucia","",""]
[null,"16:30:00","","","Pechová Natália","",""]
[null,{"$f":"B142+1/24","v":"17:30:00"},"","","Kukosová Alžbet","",""]
[null,"17:30:00","","","Novosadová Diana","",""]
[null,"17:30:00","","","Pastorek Adam","",""]
[null,"17:30:00","","","","",""]
[null,{"$f":"B146+1/48","v":"18:00:00"},"","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[null,"18:00:00","","","","",""]
[]
[]
[]
[]
[]
[null,null,1,2,3,4,5]