{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cesta vyuctovanie","Doprava","Stravné + krajiny","Ubytovanie","Iné výdavky","Rolovacie nástroje","Hárok2","Hárok1","ZZ Pracovna cesta vyuctovanie "],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"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":"Cesta vyuctovanie","index":0,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[50,0,50,7],[51,0,51,4],[52,0,52,7],[53,0,53,4],[51,5,51,7],[53,5,53,7],[61,0,62,7],[3,1,3,7],[11,0,11,7],[37,2,37,3],[10,5,10,7],[27,5,27,6],[33,0,33,4],[18,0,18,7],[30,0,30,4],[10,0,10,4],[34,0,34,7],[29,5,29,6],[30,5,30,6],[28,1,28,4],[24,1,24,4],[25,1,25,4],[14,5,14,6],[16,5,16,7],[17,0,17,7],[24,5,24,6],[25,5,25,6],[23,5,23,6],[21,1,21,4],[22,1,22,4],[23,1,23,4],[45,5,45,7],[49,5,49,7],[47,5,47,7],[47,0,47,4],[39,0,39,1],[26,1,26,4],[26,5,26,6],[43,0,43,4],[44,0,44,7],[28,5,28,6],[40,0,40,4],[40,5,40,7],[27,1,27,4],[29,0,29,4],[31,0,31,4],[31,5,31,7],[36,1,36,4],[37,0,37,1],[38,2,38,3],[38,5,38,6],[33,5,33,7],[42,0,42,7],[43,5,43,7],[57,5,57,7],[58,5,58,7],[21,5,21,6],[22,5,22,6],[19,1,19,4],[20,1,20,4],[1,0,1,7],[2,1,2,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[16,0,16,4],[12,0,13,7],[14,1,14,2],[15,1,15,2],[14,3,14,4],[15,3,15,4],[15,5,15,7],[41,0,41,7],[46,0,46,7],[45,0,45,4],[32,0,32,7],[35,0,35,7],[0,0,0,7],[19,5,19,6],[20,5,20,6],[59,5,59,7],[60,5,60,7],[49,0,49,4],[48,0,48,7],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[39,2,39,3],[60,0,60,4],[54,0,54,7],[55,5,55,7],[56,5,56,7]]}
["Slovenský horolezecký spolok JAMES\nJunácka 6, 832 80  Bratislava \nRegistrovaný na MV SR pod č. VVS/1-909/90-96 z 29. 8. 1990 "]
[" VYÚČTOVANIE CESTY DO ZAHRANIČIA"]
["Podujatie"]
["Trasa cesty"]
["Vedúci (adresa)"]
["Mená účastníkov"]
["Počet ľudí"]
["Začiatok cesty"]
["Ukončenie cesty"]
["Počet dní"]
["Použitý dopravný prostriedok (vlak, autobus, lietadlo)",null,null,null,null,"Automobil"]
["CESTOVNÉ"]
["Povolenie na použitie vlastného motorového vozidla pri pracovnej ceste\nPo zvážení hodpodárnosti a účelovosti a po dohode s pracovníkom, predseda SHS dáva súhlas na použitie vlastného motorového vozisla počas uvedenej pracovnej cesty:"]
[]
["Typ vozidla:",null,null,"Spotreba (1/100km)",null,null,null,"Diesel"]
["ŠPZ:",null,null,"Č. technického preukazu"]
["Kópia technického preukazu uložená na sekretaiáte pod číslom:"]
["Povolené vyúčtovanie základnej náhrady za 1km jazdy je 0,213 EUR"]
[]
["A","Spotreba pohonných hmôt (1/100 km)",null,null,null,null,null,"l/100 km"]
["B","Počet najazdených km na PH v SR",null,null,null,null,null,"km"]
["C","Predajná cena použitých pohonných hmôt zo SR",null,null,null,null,null,"EUR"]
["D","Náhrada za spotrebované PHM v SR (A x B x C : 100)",null,null,null,{"$f":"F20*F21*F22/100","v":0},null,"EUR"]
["E","Počet najazdených km na PH zo zahraničia",null,null,null,null,null,"km"]
["F","Predajná cena PHM zo zahraničia (viac blokov priemer)",null,null,null,null,null,"EUR"]
["G","Náhrada za spotrebované PHM zahraničia (A x E x F : 100)",null,null,null,{"$f":"F20*F24*F25/100","v":0},null,"EUR"]
["H","Počet najazdených kilometrov počas cesty spolu",null,null,null,null,null,"km"]
["I","Výška povolenej základnej sadzby za 1 km jazdy",null,null,null,0.21299999999999999,null,"EUR"]
["J","Základná sadzba (H x I)",null,null,null,{"$f":" F27*F28","v":0},null,"EUR"]
["Náhrada spolu (D + G + J) ",null,null,null,null,{"$f":"F23+F26+F29","v":0},null,"EUR"]
["Výška náhrady schválená VV / komisiou",null,null,null,null,null,null,"EUR"]
["DOPRAVA - DOKLADY",null,null,null,null,"SPOLU SUMA V EUR"]
["Kliknite na modrú ikonu zoznamu v tomto riadku pre \nzobrazenie zoznamu na vpisovanie dokladov"]
["Automatický súčet dokladov",null,null,null,null,{"$f":"Doprava!F25","v":0}]
["STRAVNÉ"]
["I. VYPĹŇA SA PRI STRAVNOM - JEDNA KRAJINA"]
["DENNÝ NÁROK",null,null,null,null,"hodín","časť","SUMA EUR"]
["1 DEŇ - PRECHOD HRANÍC (ODLET)",null,"DÁTUM A ČAS",null,null,null,null,{"$f":"G38*E39*B37","v":0}]
["POČET DNÍ",null,"POČET ĽUDÍ",null,null,24,null,{"$f":"B39*E39*B37","v":0}]
["POSLEDNÝ DEŇ - PRECHOD HRANÍC",null,"DÁTUM A ČAS",null,null,null,null,{"$f":"G40*E39*B37","v":0}]
["Automatický súčet - stravné spolu",null,null,null,null,{"$f":"SUM(H38:H40)","v":0}]
[]
["II. VYPĹŇA SA PRI STRAVNOM -  DVA A VIAC KRAJÍN V ZAHRANIČÍ"]
["STRAVNÉ VIAC KRAJÍN ZOZNAM",null,null,null,null,"SPOLU SUMA V EUR"]
["Kliknite na modrú ikonu zoznamu v tomto riadku pre \nzobrazenie zoznamu na vpisovanie dokladov"]
["Automatický súčet dokladov",null,null,null,null,{"$f":"'Stravné + krajiny'!F23:I23","v":0}]
["UBYTOVANIE"]
["UBYTOVANIE - DOKLADY",null,null,null,null,"SPOLU SUMA V EUR"]
["Kliknite na modrú ikonu zoznamu v tomto riadku pre \nzobrazenie zoznamu na vpisovanie dokladov"]
["Automatický súčet dokladov",null,null,null,null,{"$f":"Ubytovanie!F29","v":0}]
["INÉ VÝDAVKY"]
["INÉ VÝDAVKY - DOKLADY",null,null,null,null,"SPOLU SUMA V EUR"]
["Kliknite na modrú ikonu zoznamu v tomto riadku pre \nzobrazenie zoznamu na vpisovanie dokladov"]
["Automatický súčet dokladov",null,null,null,null,{"$f":"'Iné výdavky'!F25:H25","v":0}]
["REKAPITULÁCIA"]
["CESTOVNÉ",null,null,{"$f":"SUM(F31,F34)","v":0}]
["STRAVNÉ ",null,null,{"$f":"SUM(F41,F46)","v":0}]
["UBYTOVANIE",null,null,{"$f":"SUM(F50)","v":0}]
["INÉ VÝDAVKY",null,null,{"$f":"SUM(F54)","v":0}]
["VÝDAVKY SPOLU",null,null,{"$f":"SUM(D56:E59)","v":0},null,{"$f":"SUM(F56:H59)","v":0}]
["ÚHRADA"]
["IČO: 00586455 l DIČ: 2020871974  IBAN: SK30 0200 0000 0000 0623 3112   \nclenske@james.sk l sekretar@james.sk l office@james.sk  0908 718 714\n  \nPrehlasujem, že všetky údaje sú správne a úplne. (dátum a podpis vedúceho): \n\nVyjadrenie vysielajúcej zložky k vecnej a časovej správnosti \n(dátum a podpis zodpov.prac.):\n\nKontroloval (dátum, podpis a meno likvidátora):\n"]

{"sheet":"Doprava","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,6],[6,1,6,4],[7,1,7,4],[9,1,9,4],[10,1,10,4],[1,0,1,6],[5,1,5,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[8,1,8,4],[25,0,26,6],[19,1,19,4],[20,1,20,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[21,1,21,4],[23,0,23,6],[11,1,11,4],[22,1,22,4],[24,0,24,4],[24,5,24,6],[13,1,13,4],[17,1,17,4],[18,1,18,4],[12,1,12,4]]}
["Slovenský horolezecký spolok JAMES\nJunácka 6, 832 80  Bratislava \nRegistrovaný na MV SR pod č. VVS/1-909/90-96 z 29. 8. 1990 "]
["DOPRAVA"]
["ČÍSLO DOKLADU","TEXT",null,null,null,"SUMA \nINÁ MENA","SUMA \nEUR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Po vpísaní údajov kliknite na modrú ikonu \nšipky v tomto riadku pre pokračovanie"]
["SPOLU",null,null,null,null,{"$f":"SUM(G4:G23)","v":0}]
["IČO: 00586455 l  DIČ: 2020871974  IBAN:  SK30 0200 0000 0000 0623 3112   \nclenske@james.sk  l  sekretar@james.sk l office@james.sk  0908 718 714  "]

{"sheet":"Stravné + krajiny","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,5,2,8],[19,5,19,8],[20,5,20,8],[23,0,24,8],[18,0,18,1],[18,2,18,3],[12,5,12,6],[12,7,12,8],[17,3,17,4],[13,3,13,4],[16,1,16,4],[16,5,16,6],[16,7,16,8],[19,0,19,4],[20,0,20,4],[21,0,21,8],[22,0,22,4],[22,5,22,8],[17,5,17,6],[17,7,17,8],[18,5,18,6],[18,7,18,8],[11,5,11,8],[15,0,15,4],[15,5,15,8],[12,1,12,4],[1,0,1,8],[13,5,13,6],[11,0,11,4],[14,0,14,8],[2,0,2,4],[9,3,9,4],[4,7,4,8],[9,5,9,6],[10,0,10,8],[9,7,9,8],[13,7,13,8],[5,7,5,8],[3,7,3,8],[7,5,7,8],[8,1,8,4],[8,5,8,6],[8,7,8,8],[5,5,5,6],[6,0,6,8],[7,0,7,4],[3,1,3,4],[3,5,3,6],[4,0,4,1],[4,2,4,3],[5,2,5,3],[4,5,4,6]]}
["Slovenský horolezecký spolok JAMES\nJunácka 6, 832 80  Bratislava \nRegistrovaný na MV SR pod č. VVS/1-909/90-96 z 29. 8. 1990 "]
["STRAVNÉ prvá krajina"]
["PRVÁ KRAJINA ZAHRANIČIE, NÁZOV:"]
["DENNÝ NÁROK",null,null,null,null,"INÁ MENA",null,"SUMA V EUR"]
["1 DEŇ - PRECHOD HRANÍC (ODLET)",null,"DÁTUM A ČAS"]
["POČET HODÍN",null,"POČET ĽUDÍ"]
["STRAVNÉ + krajina 2"]
["ĎALŚIA KRAJINA NÁZOV:"]
["DENNÝ NÁROK",null,null,null,null,"INÁ MENA",null,"SUMA V EUR"]
["POČET DNÍ",null,"POČET ĽUDÍ"]
["STRAVNÉ + krajina 3"]
["ĎALŚIA KRAJINA NÁZOV:"]
["DENNÝ NÁROK",null,null,null,null,"INÁ MENA",null,"SUMA V EUR"]
["POČET DNÍ",null,"POČET ĽUDÍ"]
["STRAVNÉ + krajina 4"]
["ĎALŚIA KRAJINA NÁZOV:"]
["DENNÝ NÁROK",null,null,null,null,"INÁ MENA",null,"SUMA V EUR"]
["POČET DNÍ",null,"POČET ĽUDÍ"]
["POSLEDNÝ DEŇ - PRECHOD HRANÍC",null,"DÁTUM A ČAS"]
["SPOLU STRAVNÉ V INEJ MENE",null,null,null,null,{"$f":"SUM(F6,F10,F14,F19)","v":0}]
["SPOLU STRAVNÉ",null,null,null,null,{"$f":"SUM(H6,H10,H14,H19)","v":0}]
["Po vpísaní údajov kliknite na modrú ikonu \nšipky v tomto riadku pre pokračovanie"]
["SPOLU V EUR",null,null,null,null,{"$f":"SUM(F21)","v":0}]
["IČO: 00586455  l  DIČ: 2020871974      IBAN:  SK30 0200 0000 0000 0623 3112   \nclenske@james.sk    l    sekretar@james.sk    l    office@james.sk  0908 718 714  "]

{"sheet":"Ubytovanie","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,3,7],[5,0,5,7],[4,0,4,7],[6,1,6,4],[6,5,6,6],[7,1,7,4],[7,5,7,6],[8,1,8,4],[8,5,8,6],[23,1,23,4],[9,1,9,4],[13,1,13,4],[14,1,14,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[15,1,15,4],[16,1,16,4],[18,1,18,4],[19,1,19,4],[29,0,30,7],[24,1,24,4],[25,1,25,4],[26,1,26,4],[26,5,26,6],[27,0,27,7],[28,0,28,4],[28,5,28,7],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[17,1,17,4],[23,5,23,6],[24,5,24,6],[25,5,25,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6]]}
[" Slovenský horolezecký spolok JAMES\n Junácka 6, 832 80  Bratislava \n Registrovaný na MV SR pod č. VVS/1-909/90-96 z 29. 8. 1990 \n"]
[]
[]
[]
["UBYTOVANIE"]
[]
["ČÍSLO DOKLADU","TEXT",null,null,null,"INÁ MENA",null,"SUMA EUR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Po vpísaní údajov kliknite na modrú ikonu \nšipky v tomto riadku pre dokončenie"]
["SPOLU",null,null,null,null,{"$f":"SUM(H8:H27)","v":0}]
["IČO: 00586455  l  DIČ: 2020871974      IBAN:  SK30 0200 0000 0000 0623 3112   \nclenske@james.sk    l    sekretar@james.sk    l    office@james.sk  0908 718 714  "]

{"sheet":"Iné výdavky","index":4,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,7],[24,0,24,4],[24,5,24,7],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,5,19,6],[22,5,22,6],[7,1,7,4],[7,5,7,6],[23,0,23,7],[22,1,22,4],[13,1,13,4],[10,5,10,6],[11,5,11,6],[12,5,12,6],[10,1,10,4],[11,1,11,4],[12,1,12,4],[1,0,1,7],[2,1,2,4],[2,5,2,6],[3,1,3,4],[3,5,3,6],[25,0,26,7],[19,1,19,4],[20,1,20,4],[21,1,21,4],[4,1,4,4],[20,5,20,6],[21,5,21,6],[4,5,4,6],[5,1,5,4],[5,5,5,6],[9,5,9,6],[8,1,8,4],[8,5,8,6],[9,1,9,4],[6,1,6,4],[6,5,6,6]]}
["Slovenský horolezecký spolok JAMES\nJunácka 6, 832 80  Bratislava \nRegistrovaný na MV SR pod č. VVS/1-909/90-96 z 29. 8. 1990 "]
["INÉ VÝDAVKY"]
["ČÍSLO DOKLADU","TEXT",null,null,null,"SUMA \nINÁ MENA",null,"SUMA \nEUR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Po vpísaní údajov kliknite na modrú ikonu \nšipky v tomto riadku pre pokračovanie"]
["SPOLU",null,null,null,null,{"$f":"SUM(H4:H23)","v":0}]
["IČO: 00586455 l  DIČ: 2020871974  IBAN:  SK30 0200 0000 0000 0623 3112   \nclenske@james.sk  l  sekretar@james.sk l office@james.sk  0908 718 714  "]

{"sheet":"Rolovacie nástroje","index":5,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Stĺpec1",null,"Stĺpec1"]
[null,"Vvyberte z možností"]
[null,"Automobil"]
[null,"Vlak"]
[null,"Autobus"]
[null,"Letecká doprava"]
[]
[null,"Stĺpec1"]
[null,"Automobil"]
[null,"Vlak"]
[null,"Autobus"]
[null,"Letecká doprava"]
[]
[]
[]
[null,"Diesel"]
[null,"Benzín"]
[null,"Elektrina"]
[null,"Vodík"]
[]
[]
[null,"Vyberte z možností"]
[null,"Automobil"]
[null,"Autobus"]
[null,"Vlak"]
[null,"Letecká doprava"]

{"sheet":"Hárok2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hárok1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ZZ Pracovna cesta vyuctovanie ","index":8,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,3,28],[0,0,3,0],[50,1,51,8],[4,1,5,8],[4,9,318,27],[21,1,22,8],[23,4,23,7],[24,4,24,7],[25,4,25,7],[26,4,26,7],[27,1,27,7],[28,1,29,8],[14,1,15,8],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[6,2,6,8],[7,2,7,8],[30,1,30,2],[30,3,30,4],[31,1,31,2],[31,3,31,4],[4,0,146,0],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[13,1,13,5],[13,6,13,8],[12,2,12,8],[30,7,30,8],[30,5,30,6],[31,6,31,7],[32,6,32,7],[33,6,33,7],[44,1,44,6],[41,1,42,8],[32,1,32,2],[32,3,32,4],[33,1,33,2],[33,3,33,4],[35,1,36,8],[37,2,37,7],[34,1,34,7],[38,2,38,7],[39,2,39,7],[40,1,40,7],[43,1,43,6],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,1,49,8],[52,1,222,8],[45,1,45,6],[46,1,46,6],[47,1,47,6],[48,1,48,6]]}
[null," Slovenský horolezecký spolok JAMES\n Junácka 6, 832 80  Bratislava \n Registrovaný na MV SR pod č. VVS/1-909/90-96 z 29. 8. 1990 \n"]
[]
[]
[]
[null," VYÚČTOVANIE PRACOVNEJ CESTY"]
[]
[null,"Trasa cesty"]
[null,"Vedúci (adresa)"]
[null,"Mená účastníkov"]
[null,"Počet ľudí"]
[null,"Začiatok cesty"]
[null,"Ukončenie cesty"]
[null,"Počet dní"]
[null,"Použitý dopravný prostriedok (vlak, autobus, lietadlo)"]
[null,"CESTOVNÉ"]
[]
[null,"Číslo dokladu","Text",null,null,null,null,null,"suma"]
[null,null,null,null,null,null,null,null,35.6]
[null,null,null,null,null,null,null,null,96.99]
[null,null,null,null,null,null,null,null,5.12]
[null,"SPOLU",null,null,null,null,null,null,{"$f":"SUM(I18:I20)","v":137.71}]
[null,"UBYTOVANIE"]
[]
[null,"Číslo dokladu","Počet nocí","počet ľudí",null,null,null,null,"suma"]
[null,null,null,null,null,null,null,null,31.94]
[null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,178.39]
[null,"SPOLU",null,null,null,null,null,null,{"$f":"SUM(I25:I27)","v":217.32999999999998}]
[null,"STRAVNÉ"]
[]
[null,"Stravné od 1.7.2019",null,"12h ---- 5,10 €",null,"12h-18h ------ 7,60 €",null,"18h------11,60 € "]
[null,null,null,null,null,null,null,null,573.15]
[null,null,null,null,null,null,null,null,2216]
[null,null,null,null,null,null,null,null,17.21]
[null,"SPOLU",null,null,null,null,null,null,{"$f":"SUM(I32:I34)","v":2806.36}]
[null,"INÉ VÝDAVKY"]
[]
[null,"Číslo dokladu",null,null,null,null,null,null,"Suma"]
[null,null,null,null,null,null,null,null,13.87]
[null,null,null,null,null,null,null,null,222.2]
[null,"SPOLU",null,null,null,null,null,null,{"$f":"SUM(I38:I40)","v":236.07}]
[null,"REKAPITULÁCIA"]
[]
[null,"Cestovné",null,null,null,null,null,{"$f":"I21","v":137.71}]
[null,"Ubytovanie",null,null,null,null,null,{"$f":"I28","v":217.32999999999998}]
[null,"Stravné",null,null,null,null,null,{"$f":"I35","v":2806.36}]
[null,"Iné výdavky",null,null,null,null,null,{"$f":"I41","v":236.07}]
[null,"VÝDAVKY SPOLU",null,null,null,null,null,{"$f":"SUM(H44:I47)","v":3397.4700000000003}]
[null,"ÚHRADA"]
[]
[null,"IČO: 00586455  l  DIČ: 2020871974      IBAN:  SK30 0200 0000 0000 0623 3112   \nclenske@james.sk    l    sekretar@james.sk    l    office@james.sk  0908 718 714  "]
[]
[null,"INÉ VÝDAVKY"]