{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1.strana tiskopisu","2.strana tiskopisu","List1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"1.strana tiskopisu","index":0,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,17,12,21],[27,14,27,21],[26,13,26,15],[26,11,26,12],[36,12,36,13],[35,14,35,15],[36,14,36,15],[34,18,34,19],[34,20,34,21],[19,12,19,16],[20,12,20,16],[26,16,26,21],[22,7,22,11],[25,7,25,21],[34,1,34,8],[34,9,34,11],[32,1,32,11],[25,1,25,6],[22,12,22,16],[28,12,28,21],[33,12,33,21],[22,17,22,21],[27,12,27,13],[27,10,27,11],[41,17,41,21],[37,14,37,15],[37,16,37,17],[38,16,38,21],[37,20,37,21],[37,18,37,19],[38,12,38,15],[37,12,37,13],[41,1,41,6],[41,11,41,16],[41,7,41,10],[37,8,37,10],[38,2,38,11],[37,1,37,6],[40,1,40,6],[40,7,40,11],[40,12,40,16],[40,17,40,21],[1,1,1,21],[2,1,2,3],[6,16,6,21],[10,17,10,21],[2,4,2,14],[3,4,3,14],[10,12,10,16],[9,17,9,21],[2,19,2,21],[9,1,9,6],[10,7,10,11],[4,4,4,14],[6,5,6,14],[6,1,6,4],[9,12,9,16],[2,16,2,18],[3,16,3,18],[4,16,4,18],[3,19,3,21],[7,17,7,18],[4,19,4,21],[7,5,7,14],[7,1,7,4],[7,20,7,21],[11,7,11,11],[12,12,12,16],[10,1,10,6],[21,7,21,11],[16,7,16,11],[15,1,15,6],[17,12,17,16],[19,7,19,11],[12,7,12,11],[17,1,17,6],[11,12,11,16],[12,1,12,6],[13,1,13,6],[14,1,14,6],[18,1,18,6],[13,7,13,11],[14,7,14,11],[19,1,19,6],[16,1,16,6],[18,7,18,11],[9,7,9,11],[17,7,17,11],[11,1,11,6],[20,1,20,6],[20,7,20,11],[22,1,22,6],[11,17,11,21],[18,12,18,16],[18,17,18,21],[16,17,16,21],[21,1,21,6],[13,17,13,21],[15,7,15,11],[15,12,15,16],[19,17,19,21],[21,12,21,16],[21,17,21,21],[20,17,20,21],[16,12,16,16],[17,17,17,21],[13,12,13,16],[14,12,14,16],[15,17,15,21],[14,17,14,21],[33,1,33,7],[33,8,33,11],[35,8,35,10],[36,1,36,6],[36,8,36,10],[35,16,35,17],[36,18,36,19],[35,1,35,7],[36,20,36,21],[36,16,36,17],[34,14,34,15],[34,16,34,17],[35,12,35,13],[35,20,35,21],[34,12,34,13],[35,18,35,19],[24,12,24,15],[23,1,23,3],[23,4,23,21],[24,7,24,10],[24,1,24,6],[24,17,24,21],[31,7,31,10],[31,12,31,21],[32,12,32,21],[29,1,29,21],[28,1,28,9],[26,1,26,4],[27,1,27,9],[31,1,31,6],[30,1,30,9],[30,10,30,21],[26,5,26,7],[26,8,26,10]]}
[]
[]
[null,"ORGANIZACE:",null,null,"Házená Legata Hustopeče, z.s.",null,null,null,null,null,null,null,null,null,null,null,"Datum narození:"]
[null,null,null,null,"Herbenova 983 / 2B",null,null,null,null,null,null,null,null,null,null,null,"Útvar:"]
[null,null,null,null,"693 01 Hustopeče",null,null,null,null,null,null,null,null,null,null,null,"Telefon, linka:"]
[]
[null,"Příjmení, jméno, titul:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normální pracovní doba"]
[":","Bydliště:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"od",null,null,"do"]
[]
[null," Počátek cesty (místo, datum)",null,null,null,null,null,"Místo jednání",null,null,null,null,"Účel a průběh cesty",null,null,null,null,"Konec cesty (místo, datum)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," 3. Spolucestující:"]
[null," 4. Určený dopravní prostředek:",null,null,null,null,null,null,null,null,null,"Druh:",null,null,null,null,"SPZ:"]
[null," 5. Předpokládaná částka výdajů Kč:"]
[null," 6. Povolená záloha Kč:",null,null,null,null,null,null,"vyplacená dne:",null,null,null,null,"pokl.doklad číslo:"]
[]
[null,"Podpis pokladníka",null,null,null,null,null,null,null,null,null,null,"Razítko, datum a podpis pracovníka oprávněného k povolení cesty"]
[null," VYÚČTOVÁNÍ PRACOVNÍ CESTY"]
[null," 7. Zpráva o výsledku pracovní cesty byla podána dne:"]
[null," Se způsobem provedení souhlasí:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Datum a podpis odpovědného pracovníka"]
[null," 8. VÝDAJOVÝ A PŘÍJMOVÝ DOKLAD číslo:",null,null,null,null,null,null,null,null,null,null,"Účtovací předpis"]
[null," Účtovaná náhrada byla přezkoušena a upravena na:",null,null,null,null,null,null,null,null,null,null,"Má dáti",null,"Dal",null,"Částka",null,"Středisko",null,"Zakázka"]
[null,"Kč"]
[null," Vyplacená záloha",null,null,null,null,null,"Kč"]
[null," Doplatek - Přeplatek",null,null,null,null,null,"Kč"]
[null," Slovy:",null,null,null,null,null,null,null,null,null,null,"Poznámka o zaúčtování"]
[]
[]
[null," Datum a podpis pracovníka, který upravil vyúčtování",null,null,null,null,null,"Datum a podpis pokladníka",null,null,null,"Datum a podpis příjemce (průkaz totožnosti)",null,null,null,null,null,"Schválil (datum a podpis)"]

{"sheet":"2.strana tiskopisu","index":1,"n_rows":51,"n_cols":22,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,12,50,14],[49,12,49,14],[46,1,46,11],[50,1,50,11],[38,18,38,20],[25,15,25,16],[26,15,26,16],[24,15,24,16],[29,15,29,16],[31,15,31,16],[36,15,36,16],[32,15,32,16],[30,15,30,16],[35,15,35,16],[37,15,37,16],[38,15,38,16],[23,1,24,1],[23,3,23,4],[23,6,24,6],[23,7,24,7],[24,3,24,4],[25,1,26,1],[25,3,25,4],[26,3,26,4],[7,12,8,12],[7,3,7,4],[7,6,8,6],[8,3,8,4],[7,10,8,10],[7,11,8,11],[11,15,11,16],[20,15,20,16],[17,11,18,11],[15,11,16,11],[19,11,20,11],[19,12,20,12],[19,15,19,16],[19,14,20,14],[17,15,17,16],[18,15,18,16],[17,13,18,13],[15,14,16,14],[15,15,15,16],[9,7,10,7],[9,6,10,6],[9,8,10,8],[9,10,10,10],[11,10,12,10],[9,12,10,12],[11,11,12,11],[11,7,12,7],[13,6,14,6],[19,6,20,6],[19,7,20,7],[17,6,18,6],[17,8,18,8],[17,10,18,10],[19,8,20,8],[19,10,20,10],[13,7,14,7],[11,8,12,8],[15,12,16,12],[17,12,18,12],[21,1,22,1],[21,3,21,4],[15,8,16,8],[15,6,16,6],[15,7,16,7],[23,8,24,8],[21,7,22,7],[17,7,18,7],[21,8,22,8],[19,1,20,1],[7,15,7,16],[6,15,6,16],[8,15,8,16],[9,14,10,14],[9,15,9,16],[10,15,10,16],[31,14,32,14],[29,14,30,14],[14,15,14,16],[12,15,12,16],[13,15,13,16],[11,14,12,14],[23,15,23,16],[27,15,27,16],[22,15,22,16],[28,15,28,16],[23,14,24,14],[21,15,21,16],[21,14,22,14],[16,15,16,16],[1,13,4,13],[27,13,28,13],[17,14,18,14],[7,13,8,13],[9,13,10,13],[13,13,14,13],[19,13,20,13],[25,13,26,13],[25,14,26,14],[21,13,22,13],[13,14,14,14],[7,14,8,14],[11,13,12,13],[23,13,24,13],[15,13,16,13],[1,14,4,14],[27,3,27,4],[28,3,28,4],[31,8,32,8],[27,10,28,10],[32,3,32,4],[31,3,31,4],[29,3,29,4],[30,3,30,4],[33,3,33,4],[33,7,34,7],[33,6,34,6],[27,7,28,7],[29,6,30,6],[0,1,0,16],[1,1,4,1],[1,6,5,6],[1,7,5,7],[1,8,5,8],[1,9,5,9],[1,15,4,16],[22,3,22,4],[9,3,9,4],[13,1,14,1],[15,1,16,1],[10,3,10,4],[11,1,12,1],[13,3,13,4],[16,3,16,4],[14,3,14,4],[5,15,5,16],[1,10,4,10],[1,12,4,12],[9,1,10,1],[1,2,1,5],[2,2,2,5],[7,1,8,1],[17,1,18,1],[1,11,4,11],[7,7,8,7],[7,8,8,8],[20,3,20,4],[13,11,14,11],[21,10,22,10],[15,10,16,10],[11,6,12,6],[12,3,12,4],[3,2,4,5],[15,3,15,4],[13,8,14,8],[13,10,14,10],[9,11,10,11],[19,3,19,4],[11,3,11,4],[17,3,17,4],[18,3,18,4],[21,6,22,6],[51,11,51,15],[41,5,41,8],[39,15,39,16],[39,9,39,13],[43,5,43,8],[45,11,45,15],[25,7,26,7],[27,6,28,6],[25,6,26,6],[38,9,38,13],[31,6,32,6],[35,13,36,13],[29,13,30,13],[35,12,36,12],[27,12,28,12],[38,6,38,7],[33,14,34,14],[33,15,33,16],[34,15,34,16],[29,10,30,10],[29,8,30,8],[35,14,36,14],[33,11,34,11],[27,14,28,14],[58,1,58,10],[47,1,47,10],[29,1,30,1],[35,1,36,1],[31,1,32,1],[33,1,34,1],[38,1,38,5],[43,1,43,3],[42,5,42,8],[42,1,42,3],[39,1,39,5],[41,1,41,3],[29,7,30,7],[35,8,36,8],[33,8,34,8],[33,10,34,10],[31,10,32,10],[35,3,35,4],[34,3,34,4],[35,10,36,10],[31,7,32,7],[36,3,36,4],[35,6,36,6],[35,7,36,7],[44,1,44,3],[44,11,44,15],[43,10,43,15],[39,6,39,7],[44,5,44,9],[48,1,48,11],[21,12,22,12],[21,11,22,11],[31,12,32,12],[27,11,28,11],[29,11,30,11],[23,11,24,11],[23,10,24,10],[25,12,26,12],[25,8,26,8],[27,8,28,8],[35,11,36,11],[33,13,34,13],[25,10,26,10],[31,11,32,11],[25,11,26,11],[31,13,32,13],[29,12,30,12],[27,1,28,1]]}
[null,"VYÚČTOVÁNÍ PRACOVNÍ CESTY"]
[null,"Datum",null,null,null,null,"Použitý dopravní prostředek 2)","Počet hodin \nztráty času","Vzdálenost v km 3)","Počátek a konec\nprac. výkonu (hodina)","Jízdné a\nmístní\npřeprava","Stravné","Nocležné","Nutné\nvedlejší\nvýdaje","Celkem","Upraveno"]
[null,null,"Odjezd - příjezd 1)"]
[null,null,"Místo jednání podtrhněte"]
[]
[null,null,null,null,null,"v hod.",null,null,null,null,"Kč","Kč","Kč","Kč","Kč","Kč"]
[null,1,2,null,null,null,3,4,5,6,7,8,9,10,11,12,null,null,"Den","Ve dni","ujeto km","silniční daň"]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I8*3","v":0},0,null,null,{"$f":"SUM(K8:N9)","v":0},null,null,null,1,1,{"$f":"SUMIF(S$8:S$36,T8,I$8:I$37)","v":0},{"$f":"IF(U8=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,0,0,null,null,{"$f":"SUM(K10:N11)","v":0},null,null,null,{"$f":"IF(#REF!=B8,S8,S8+1)","v":{"$error":"#REF!"}},2,{"$f":"SUMIF(S$8:S$36,T10,I$8:I$37)","v":0},{"$f":"IF(U10=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I12*3","v":0},null,null,null,{"$f":"SUM(K12:N13)","v":0},null,null,null,{"$f":"IF(B10=#REF!,S10,S10+1)","v":{"$error":"#REF!"}},3,{"$f":"SUMIF(S$8:S$36,T12,I$8:I$37)","v":0},{"$f":"IF(U12=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I14*3","v":0},null,null,null,{"$f":"SUM(K14:N15)","v":0},null,null,null,{"$f":"IF(B14=B10,S12,S12+1)","v":{"$error":"#REF!"}},4,{"$f":"SUMIF(S$8:S$36,T14,I$8:I$37)","v":0},{"$f":"IF(U14=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I16*3","v":0},null,null,null,{"$f":"SUM(K16:N17)","v":0},null,null,null,{"$f":"IF(B16=B14,S14,S14+1)","v":{"$error":"#REF!"}},5,{"$f":"SUMIF(S$8:S$36,T16,I$8:I$37)","v":0},{"$f":"IF(U16=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I18*3","v":0},null,null,null,{"$f":"SUM(K18:N19)","v":0},null,null,null,{"$f":"IF(B18=B16,S16,S16+1)","v":{"$error":"#REF!"}},6,{"$f":"SUMIF(S$8:S$36,T18,I$8:I$37)","v":0},{"$f":"IF(U18=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I20*3","v":0},null,null,null,{"$f":"SUM(K20:N21)","v":0},null,null,null,{"$f":"IF(B20=B18,S18,S18+1)","v":{"$error":"#REF!"}},7,{"$f":"SUMIF(S$8:S$36,T20,I$8:I$37)","v":0},{"$f":"IF(U20=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I22*3","v":0},null,null,null,{"$f":"SUM(K22:N23)","v":0},null,null,null,{"$f":"IF(B22=B20,S20,S20+1)","v":{"$error":"#REF!"}},8,{"$f":"SUMIF(S$8:S$36,T22,I$8:I$37)","v":0},{"$f":"IF(U22=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I24*3","v":0},null,null,null,{"$f":"SUM(K24:N25)","v":0},null,null,null,{"$f":"IF(B24=B22,S22,S22+1)","v":{"$error":"#REF!"}},9,{"$f":"SUMIF(S$8:S$36,T24,I$8:I$37)","v":0},{"$f":"IF(U24=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I26*3","v":0},null,null,null,{"$f":"SUM(K26:N27)","v":0},null,null,null,{"$f":"IF(B26=B24,S24,S24+1)","v":{"$error":"#REF!"}},10,{"$f":"SUMIF(S$8:S$36,T26,I$8:I$37)","v":0},{"$f":"IF(U26=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I28*3","v":0},null,null,null,{"$f":"SUM(K28:N29)","v":0},null,null,null,{"$f":"IF(B28=B26,S26,S26+1)","v":{"$error":"#REF!"}},11,{"$f":"SUMIF(S$8:S$36,T28,I$8:I$37)","v":0},{"$f":"IF(U28=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I30*3","v":0},null,null,null,{"$f":"SUM(K30:N31)","v":0},null,null,null,{"$f":"IF(B30=B28,S28,S28+1)","v":{"$error":"#REF!"}},12,{"$f":"SUMIF(S$8:S$36,T30,I$8:I$37)","v":0},{"$f":"IF(U30=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I32*3","v":0},null,null,null,{"$f":"SUM(K32:N33)","v":0},null,null,null,{"$f":"IF(B32=B30,S30,S30+1)","v":{"$error":"#REF!"}},13,{"$f":"SUMIF(S$8:S$36,T32,I$8:I$37)","v":0},{"$f":"IF(U32=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I34*3","v":0},null,null,null,{"$f":"SUM(K34:N35)","v":0},null,null,null,{"$f":"IF(B34=B32,S32,S32+1)","v":{"$error":"#REF!"}},14,{"$f":"SUMIF(S$8:S$36,T34,I$8:I$37)","v":0},{"$f":"IF(U34=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,"Odj.",null,null,null,null,null,null,null,{"$f":"I36*3","v":0},null,null,null,{"$f":"SUM(K36:N37)","v":0},null,null,null,{"$f":"IF(B36=B34,S34,S34+1)","v":{"$error":"#REF!"}},15,{"$f":"SUMIF(S$8:S$36,T36,I$8:I$37)","v":0},{"$f":"IF(U36=0,0,25)","v":0}]
[null,null,"Příj."]
[null,null,null,null,null,null,null,null,null,"Celkem:",{"$f":"SUM(K8:K37)","v":0},{"$f":"SUM(L8:L37)","v":0},{"$f":"SUM(M8:M37)","v":0},{"$f":"SUM(N8:N37)","v":0},{"$f":"SUM(O8:O37)","v":0}]
[null," Stravování bylo poskytnuto bezplatně:",null,null,null,null,"ANO-NE",null,null,"Z á l o h a",null,null,null,null,0,null,null,null,"Daň celkem",null,null,{"$f":"SUM(V8:V37)","v":0}]
[null," Ubytování bylo poskytnuto bezplatně:",null,null,null,null,"ANO-NE",null,null,{"$f":"IF(O38-O39<0,\"P ř e p l a t e k\",\"D o p l a t e k\")","v":"D o p l a t e k"},null,null,null,null,{"$f":"ABS(O38-O39)","v":0}]
[]
[null," O - osobní vlak",null,null,null,"AUS - auto služební"]
[null," R - rychlík",null,null,null,"AUV - auto vlastní"]
[null," A - autobus",null,null,null,"AUP - auto z půjčovny",null,null,null,null,"Prohlašuji, že jsem všechny údaje uvedl plně a správně"]
[null," L - letadlo",null,null,null,"MOS - motocykl služební"]
[]
[null," 1) Dobu odjezdu a příjezdu u veřejného dopravního prostředku vyplňte podle jízdního řádu"]
[null," 2) Uvádějte ve zkratce"]
[null," 3) Počet km uvádějte jen při použití jiného než veřejného hromadného dopravního prostředku"]
[]
[null," Sazby náhrad cestovních výdajů jsou uveřejněny ve Sb. zákonů podle systému § 8. zák. 119/92 Sb.",null,null,null,null,null,null,null,null,null,null,"Datum a podpis účtovatele"]

{"sheet":"List1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}