{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Příkaz","Vyúčtování test","Vyúčtování","Kurzy CNB","List1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":3,"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":"Příkaz","index":0,"n_rows":78,"n_cols":26,"rows_kept":78,"cut":false,"hidden":false,"merged":[[33,23,33,24],[45,1,45,4],[45,5,45,8],[31,10,31,15],[37,1,38,17],[31,6,31,8],[41,1,41,2],[36,1,36,17],[34,14,34,17],[33,14,33,17],[31,1,31,5],[34,3,34,5],[53,2,53,17],[54,1,54,17],[77,1,77,7],[69,1,69,7],[69,10,69,17],[73,10,73,17],[77,10,77,17],[73,1,73,7],[59,1,66,17],[57,1,57,3],[49,1,49,6],[49,7,49,8],[57,9,57,17],[56,1,56,3],[39,5,39,17],[39,1,39,2],[41,5,41,17],[43,1,43,2],[43,5,43,7],[43,9,43,10],[43,11,43,17],[47,1,47,3],[47,5,47,17],[45,13,45,17],[45,9,45,12],[51,2,52,17],[11,4,11,17],[33,9,33,10],[33,6,33,8],[33,1,33,2],[33,3,33,5],[17,8,17,12],[17,13,17,15],[23,1,23,2],[25,1,25,2],[21,1,21,9],[21,10,21,17],[29,1,29,3],[29,5,29,17],[27,3,27,15],[27,1,27,2],[23,3,23,15],[13,9,13,17],[15,3,15,17],[15,1,15,2],[17,1,17,5],[19,1,19,15],[25,3,25,15],[0,10,0,13],[3,1,3,2],[3,3,3,9],[3,11,3,17],[5,5,5,6],[5,7,5,8],[5,9,5,17],[13,1,13,2],[13,5,13,6],[13,7,13,8],[1,1,1,17],[7,1,7,2],[7,3,7,17],[9,3,9,17],[11,1,11,3]]}
[null,null,null,null,null,null,null,null,null,null,"Evidenční číslo:"]
[null,"CESTOVNÍ  PŘÍKAZ K USKUTEČNĚNÍ ZAHRANIČNÍ PRACOVNÍ CESTY"]
[]
[null,"Jméno a příjmení:",null,null,null,null,null,null,null,null,"Útvar:"]
[]
[null,"Zahájení cesty",null,"Datum:",null,null,null,"Místo:"]
[]
[null,"Místo konání:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stát, místo, pořadatel"]
[]
[null,"Účel:"]
[]
[null,"Očekávaný přínos/výstup:"]
[]
[null,"Ukončení cesty",null,"Datum:",null,null,null,"Místo:"]
[]
[null,"Jízdné hradí:"]
[]
[null,"Návrh na určení dopravního prostředku:",null,null,null,null,"A",null,{"$f":"IF(G18<>\"\",(VLOOKUP(G18,List1!B3:C11,2,FALSE)),\"\")","v":"Autobus"},null,null,null,null,{"$f":"IF(G18=\"V\",\"Jízdenku zařizuje:\",IF(G18=\"A\",\"Jízdenku zařizuje:\",IF(G18=\"L\",\"Letenku zařizuje:\",\"\")))","v":"Jízdenku zařizuje:"},null,null,null,"ZO PF UK"]
[]
[null,"Předpokládaná výše jízdních výdajů  za jehož použití mají být poskytnuty náhrady jízdních výdajů:"]
[]
[null,"Úhrada ostatních výdajů (PF UK, grant nebo projekt)",null,null,null,null,null,null,null,null,"Předpokládáná výše ostatních výdajů v Kč"]
[]
[null,"Ubytování hradí:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(PF UK, grant nebo projekt)",null,"částka v Kč"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"částka v Kč"]
[null,"Stravné hradí:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(PF UK, grant nebo projekt)",null,"částka v Kč"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"částka v Kč"]
[null,"Nutné vedl. výd. hradí:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(PF UK, grant nebo projekt)",null,"částka v Kč"]
[]
[null,"Nutné vedlejší výdaje specifikace:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specifikace"]
[]
[null,{"$f":"\"Cestovní pojištění (\"&List1!R2&\"), zajištuje a hradí:\"","v":"Cestovní pojištění (1 den), zajištuje a hradí:"},null,null,null,null,"ZO PF UK",null,null,null,"Předpokládáné výdaje celkem",null,null,null,null,null,null,{"$f":"IF(OR(G18=\"SV\",G18=\"SJ\"),R24+R26+R28,R20+R24+R26+R28)","v":0}]
[]
[null,"Žádám o zálohu:",null,"Ne",null,null,"Výše zálohy:",null,null,null,null,null,"CZK",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D34<>\"\",IF(J34<>\"\",(IF(M34=\"CZK\",1,VLOOKUP(TODAY(),'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(M34,List1!$S$4:$T$36,2,FALSE),TRUE)))*J34,\"\"),\"\")","v":""},null,"Výše v Kč podle naposledy aktualizovaného kurzu"]
[null,null,null,{"$f":"IF(AND(D34=\"Ano, na bank. Účet\",M34<>\"CZK\"),\"Na účet lze pouze CZK\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Číslo bankovního účtu"]
[]
[null,"POUŽITÍ  SOUKROMÉHO  VOZIDLA NA PRACOVNÍ CESTU"]
[null,"Vyplní řidič vozidla (zaměstnanec) před cestou."]
[]
[null,"Vlastník  vozidla:"]
[]
[null,"Řidič vozidla:",null,null,null,{"$f":"IF(D4=\"\",\"\",D4)","v":""}]
[]
[null,"RZ vozidla:",null,null,null,null,null,null,null,"Typ vozu:"]
[]
[null,"Datum povinn. proškolení  řidiče:",null,null,null,null,null,null,null,"Číslo havarijní pojistky:"]
[]
[null,"Spolucestující:"]
[]
[null,"Prohlašuji, že vozidlo použité na této služební cestě",null,null,null,null,null,"NENÍ",null," v evidenci plátců silniční daně pro rok 2020."]
[null,"Prohlašuji, že mám platný řidičský průkaz."]
[null,"Přílohy: "," - kopie velkého technického průkazu (datum aktuální technické kontroly)\n - kopie dokladu o zaplacení havarijního pojištění (pokud jste už neodevzdali  na ekonomickém oddělení.)"]
[]
[null,null,{"$f":"IF(OR(G18=\"V\",G18=\"A - VV\",G18=\"V - VV\",G18=\"L - VV\",G18=\"A - VV\",G18=\"A\",G18=\"L\",),\" - doklad o předpokládané výši jízdních výdajů za dopravní prostředek, za jehož použití mají být poskytnuty náhrady jízdních výdajů\",\"\")","v":" - doklad o předpokládané výši jízdních výdajů za dopravní prostředek, za jehož použití mají být poskytnuty náhrady jízdních výdajů"}]
[null,{"$f":"\"Žádám o náhradu jízdních výdajů  \"&IF(G18=\"VV\",\"za každý kilometr jízdy sazbou základní náhrady a náhradou za spotřebované pohonné hmoty podle zákonných sazeb platných v době konání pracovní cesty.\",IF(OR(G18=\"V - VV\",G18=\"V\"),\"ve výši odpovídající ceně jízdenky za vlak do výše \" & R20 &\" Kč.\",IF(OR(G18=\"A - VV\",G18=\"A\"),\"ve výši odpovídající ceně jízdenky za autobus do výše \" &R20&\" Kč.\",IF(OR(G18=\"L - VV\",G18=\"L\"),\"ve výši odpovídající ceně letenky do výše \" &R20&\" Kč.\",\"- NE.\"))))","v":"Žádám o náhradu jízdních výdajů  ve výši odpovídající ceně jízdenky za autobus do výše  Kč."}]
[]
[]
[null,"V Praze dne",null,null,null,null,null,null,null,"Podpis zaměstnance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Podpis  řešitele grantu nebo projektu",null,null,null,null,null,null,null,null,"Podpis přímého nadřízeného"]
[]
[]
[]
[null,"Podpis vedoucího zahraničního oddělení",null,null,null,null,null,null,null,null,"Podpis tajemníka (správce rozpočtu)"]
[]
[]
[]
[null,"Podpis vedoucího ekonomického oddělení",null,null,null,null,null,null,null,null,"Podpis děkana"]

{"sheet":"Vyúčtování test","index":1,"n_rows":56,"n_cols":33,"rows_kept":56,"cut":false,"hidden":true,"merged":[[18,20,19,20],[16,13,17,13],[16,17,17,17],[17,3,17,4],[18,1,19,1],[18,3,18,4],[18,6,19,6],[18,7,19,7],[18,9,19,9],[16,6,17,6],[16,7,17,7],[16,9,17,9],[16,10,17,10],[16,11,17,11],[18,19,19,19],[18,12,19,12],[19,3,19,4],[16,8,17,8],[18,8,19,8],[16,1,17,1],[16,3,16,4],[14,20,15,20],[16,20,17,20],[1,1,1,17],[2,1,3,1],[2,3,3,4],[2,6,3,6],[2,7,3,7],[2,8,3,8],[12,12,13,12],[16,12,17,12],[12,13,13,13],[12,17,13,17],[13,3,13,4],[14,1,15,1],[14,3,14,4],[14,6,15,6],[14,7,15,7],[14,9,15,9],[14,10,15,10],[12,3,12,4],[12,6,13,6],[12,7,13,7],[12,9,13,9],[12,10,13,10],[4,20,5,20],[6,20,7,20],[8,20,9,20],[10,20,11,20],[12,20,13,20],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,17,5,17],[4,19,5,19],[10,10,11,10],[10,11,11,11],[10,12,11,12],[10,13,11,13],[14,8,15,8],[10,17,11,17],[18,13,19,13],[18,17,19,17],[5,3,5,4],[6,13,7,13],[6,17,7,17],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,17,9,17],[9,3,9,4],[6,12,7,12],[7,3,7,4],[4,8,5,8],[6,10,7,10],[6,11,7,11],[11,3,11,4],[10,3,10,4],[10,6,11,6],[10,7,11,7],[10,9,11,9],[10,8,11,8],[55,9,56,17],[44,1,44,8],[48,9,48,17],[46,1,47,8],[49,9,49,17],[23,7,23,10],[34,1,34,4],[41,1,41,4],[51,1,51,5],[55,1,55,5],[30,1,31,4],[29,5,30,8],[31,7,31,8],[24,10,24,13],[4,1,5,1],[4,3,4,4],[4,6,5,6],[4,7,5,7],[4,9,5,9],[6,1,7,1],[6,3,6,4],[6,6,7,6],[6,7,7,7],[6,9,7,9],[6,8,7,8],[24,24,24,26],[16,19,17,19],[14,19,15,19],[12,19,13,19],[10,19,11,19],[8,19,9,19],[6,19,7,19],[8,1,9,1],[8,3,8,4],[8,6,9,6],[8,7,9,7],[8,9,9,9],[8,8,9,8],[18,10,19,10],[18,11,19,11],[14,13,15,13],[12,1,13,1],[12,11,13,11],[14,11,15,11],[14,12,15,12],[14,17,15,17],[15,3,15,4],[12,8,13,8],[10,1,11,1]]}
[]
[null,"VYÚČTOVÁNÍ PRACOVNÍ CESTY"]
[null,"Datum",null,"Odjezd - příjezd",null,null,"Použitý dopr. prostředek2)","Vzdálenost\nv km 1)","Jízdné v případě AUV","Jízdné a místní přeprava","Stravné","Noc-\nležné","Nutné\nvedlejší výdaje","Celkem",null,null,null,"Upraveno"]
[null,null,null,null,null,"v hod.",null,null,null,"Kč","Kč","Kč","Kč","Kč",null,null,null,"Kč",null,null,null,null,null,null,"Vozidlo"]
[null,"2020-01-02","Odjezd",null,null,"10:00:00",null,null,{"$f":"IF(G5=\"VV\",ROUND(H5*$Z$14+H5*$Z$18,2),\"\")","v":""},null,{"$f":"R26","v":691},null,null,{"$f":"(N(I5)+J5+L5+M5)","v":0},null,null,{"$f":"VLOOKUP(P27,$AC$12:$AG$16,Q27+1,FALSE)","v":91},null,null,{"$f":"IF(B5=\"\",\"\",IF(B7=\"\",\"konec\",\"průběh\"))","v":"průběh"},{"$f":"VLOOKUP(IF(B5=\"\",0,(IF(B5=B3,1000,100)+IF(B5=B7,10,1))),List1!$B$22:$D$26,3,FALSE)","v":4},{"$f":"B5","v":"2020-01-02"},{"$f":"IF(V5<>0,B5+F5,\"\")","v":"2020-01-02T10:00:00"},null,"SPZ"]
[null,null,"Příjezd",null,null,"12:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B5","v":"2020-01-02"},{"$f":"IF(V5<>0,B5+F6,\"\")","v":"2020-01-02T12:00:00"},null,"Palivo","nafta",null,null,null,{"$f":"AD8","v":43832}]
[null,"2020-01-05","Odjezd",null,null,"15:00:00",null,null,{"$f":"IF(G7=\"VV\",ROUND(H7*$Z$14+H7*$Z$18,2),\"\")","v":""},null,null,null,null,{"$f":"(N(I7)+J7+L7+M7)","v":0},null,null,{"$f":"VLOOKUP(P28,$AC$12:$AG$16,Q28+1,FALSE)","v":200},null,null,{"$f":"IF(B7=\"\",\"\",IF(B9=\"\",\"konec\",\"průběh\"))","v":"konec"},{"$f":"VLOOKUP(IF(B7=\"\",0,(IF(B7=B5,1000,100)+IF(B7=B9,10,1))),List1!$B$22:$D$26,3,FALSE)","v":4},{"$f":"B7","v":"2020-01-05"},{"$f":"IF(V7<>0,B7+F7,\"\")","v":"2020-01-05T15:00:00"},null,"spotřeba 1",3.1]
[null,null,"Příjezd",null,null,"20:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"2020-01-05"},{"$f":"IF(V7<>0,B7+F8,\"\")","v":"2020-01-05T20:00:00"},null,"spotřeba 2",null,null,null,null,{"$f":"MIN(B5:B20)","v":"2020-01-02"},{"$f":"MIN(W5:W20)","v":"2020-01-02T10:00:00"}]
[null,null,"Odjezd",null,null,null,null,null,{"$f":"IF(G9=\"VV\",ROUND(H9*$Z$14+H9*$Z$18,2),\"\")","v":""},null,null,null,null,{"$f":"(N(I9)+J9+L9+M9)","v":0},null,null,null,null,null,{"$f":"IF(B9=\"\",\"\",IF(B11=\"\",\"konec\",\"průběh\"))","v":""},{"$f":"VLOOKUP(IF(B9=\"\",0,(IF(B9=B7,1000,100)+IF(B9=B11,10,1))),List1!$B$22:$D$26,3,FALSE)","v":5},{"$f":"B9","v":"00:00:00"},{"$f":"IF(V9<>0,B9+F9,\"\")","v":""},null,"spotřeba 3",null,null,null,null,{"$f":"MAX(B5:B20)","v":"2020-01-05"},{"$f":"MAX(W5:W20)","v":"2020-01-05T20:00:00"}]
[null,null,"Příjezd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B9","v":"00:00:00"},{"$f":"IF(V9<>0,B9+F10,\"\")","v":""},null,"spotřeba 4"]
[null,null,"Odjezd",null,null,null,null,null,{"$f":"IF(G11=\"VV\",ROUND(H11*$Z$14+H11*$Z$18,2),\"\")","v":""},null,null,null,null,{"$f":"(N(I11)+J11+L11+M11)","v":0},null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",IF(B13=\"\",\"konec\",\"průběh\"))","v":""},{"$f":"VLOOKUP(IF(B11=\"\",0,(IF(B11=B9,1000,100)+IF(B11=B13,10,1))),List1!$B$22:$D$26,3,FALSE)","v":5},{"$f":"B11","v":"00:00:00"},{"$f":"IF(V11<>0,B11+F11,\"\")","v":""},null,"Průměr - použitá spotřeba",{"$f":"ROUND(AVERAGE(Z7:Z10),2)","v":3.1},null,null,null,"0 - 5 hod","5 až 12 hod.","12 až 18 hod.","více než 18 hod."]
[null,null,"Příjezd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B11","v":"00:00:00"},{"$f":"IF(V11<>0,B11+F12,\"\")","v":""},null,"Cena paliva z dokladu",null,"Pokud nezadáte cenu paliva z dokladu, bude použita cena z vyhlášky",null,"počet jídel",0,"I","II","III"]
[null,null,"Odjezd",null,null,null,null,null,{"$f":"IF(G13=\"VV\",ROUND(H13*$Z$14+H13*$Z$18,2),\"\")","v":""},null,null,null,null,{"$f":"(N(I13)+J13+L13+M13)","v":0},null,null,null,null,null,{"$f":"IF(B13=\"\",\"\",IF(B15=\"\",\"konec\",\"průběh\"))","v":""},{"$f":"VLOOKUP(IF(B13=\"\",0,(IF(B13=B11,1000,100)+IF(B13=B15,10,1))),List1!$B$22:$D$26,3,FALSE)","v":5},{"$f":"B13","v":"00:00:00"},{"$f":"IF(V13<>0,B13+F13,\"\")","v":""},null,"Náhrady",null,null,null,0,0,90,140,200]
[null,null,"Příjezd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":"00:00:00"},{"$f":"IF(V13<>0,B13+F14,\"\")","v":""},null,"amortizace za km",4.0999999999999996,null,null,1,0,{"$f":"AE13*0.3","v":27},{"$f":"0.65*AF13","v":91},{"$f":"0.75*AG13","v":150}]
[null,null,"Odjezd",null,null,null,null,null,{"$f":"IF(G15=\"VV\",ROUND(H15*$Z$14+H15*$Z$18,2),\"\")","v":""},null,null,null,null,{"$f":"(N(I15)+J15+L15+M15)","v":0},null,null,null,null,null,{"$f":"IF(B15=\"\",\"\",IF(B17=\"\",\"konec\",\"průběh\"))","v":""},{"$f":"VLOOKUP(IF(B15=\"\",0,(IF(B15=B13,1000,100)+IF(B15=B17,10,1))),List1!$B$22:$D$26,3,FALSE)","v":5},{"$f":"B15","v":"00:00:00"},{"$f":"IF(V15<>0,B15+F15,\"\")","v":""},null,"benzin 95 oktanů",33.1,null,null,2,0,0,{"$f":"0.3*AF13","v":42},{"$f":"0.5*AG13","v":100}]
[null,null,"Příjezd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B15","v":"00:00:00"},{"$f":"IF(V15<>0,B15+F16,\"\")","v":""},null,"benzin 98 oktanů",37.1,null,null,3,0,0,0,{"$f":"0.25*AG13","v":50}]
[null,null,"Odjezd",null,null,null,null,null,{"$f":"IF(G17=\"VV\",ROUND(H17*$Z$14+H17*$Z$18,2),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IF(B17=\"\",\"\",IF(B19=\"\",\"konec\",\"průběh\"))","v":""},{"$f":"VLOOKUP(IF(B17=\"\",0,(IF(B17=B15,1000,100)+IF(B17=B19,10,1))),List1!$B$22:$D$26,3,FALSE)","v":5},{"$f":"B17","v":"00:00:00"},{"$f":"IF(V17<>0,B17+F17,\"\")","v":""},null,"nafta",33.6]
[null,null,"Příjezd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B17","v":"00:00:00"},{"$f":"IF(V17<>0,B17+F18,\"\")","v":""},null,"náhrada za km paliva",{"$f":"ROUND(IF(Z12=0,(VLOOKUP(Z6,Y15:Z17,2,FALSE)),Z12)*Z11/100,4)","v":1.0416000000000001},{"$f":"IF(Z12<>\"\",\"použita cena z dokladu\",\"použita cena z vyhlášky\")","v":"použita cena z vyhlášky"}]
[null,null,"Odjezd",null,null,null,null,null,{"$f":"IF(G19=\"VV\",ROUND(H19*$Z$14+H19*$Z$18,2),\"\")","v":""},null,null,null,null,0,null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",IF(B21=\"\",\"konec\",\"průběh\"))","v":""},{"$f":"VLOOKUP(IF(B19=\"\",0,(IF(B19=B17,1000,100)+IF(B19=B21,10,1))),List1!$B$22:$D$26,3,FALSE)","v":5},{"$f":"B19","v":"00:00:00"},{"$f":"IF(V19<>0,B19+F19,\"\")","v":""}]
[null,null,"Příjezd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B19","v":"00:00:00"},{"$f":"IF(V19<>0,B19+F20,\"\")","v":""}]
[null,null,null,null,null,null,null,"Celkem",{"$f":"SUM(I5:I20)","v":0},{"$f":"SUM(J5:J20)","v":0},{"$f":"SUM(K5:K20)","v":691},{"$f":"IF(E23=\"ano\",0,SUM(L5:L20))","v":0},{"$f":"SUM(M5:M20)","v":0},{"$f":"SUM(I21:M21)","v":691}]
[null,"Strava poskytnuta bezplatně",null,null,"ano",null,null,"Záloha"]
[null,"Ubytování  poskytnuto bezplatně:*",null,null,"ano",null,null,{"$f":"IF((N21-N22)<0,\"Přeplatek (účtovatel vrátí)\", \"Doplatek (účtovateli bude doplaceno)\")","v":"Doplatek (účtovateli bude doplaceno)"},null,null,null,null,null,{"$f":"ABS(CEILING(N21-N22,1))","v":691}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O28=\"\",1,IF((O27+O28)<=5/24,1,IF((O27+O28)<=12/24,2,IF((O27+O28)<=18/24,3,4))))","v":4},{"$f":"VLOOKUP((IF((P28+P27)>3,3,(P28+P27))),$AC$12:$AG$16,P24+1,FALSE)","v":150}]
[null,"V - Vlak","SV - služební vozidlo",null,"V - VV  - vlastní vozidlo s náhradou výdajů za vlak",null,null,null,null,null,"Bezplatně poskytnutá strava",null,null,null,null,"počet jídel","skupina","Celkem",null,null,null,null,null,null,"Přehled EU norem používaných v TP"]
[null,"A - autobus","CV -  spolujízda",null,"A - VV - vlastní vozidlo s náhradou výdajů za autobus",null,null,null,null,null,"Datum","snídaně","oběd","večeře","doba",null,null,{"$f":"SUM(R27:R43)","v":691},null,null,null,null,null,null,"80/1268/EHS","arit.průměr","3 údaje v TP"]
[null,"L - letadlo","VV - vlastní vozidlo",null,"L - VV - vlastní vozidlo s náhradou výdajů za letadlo",null,null,null,null,null,{"$f":"IF(AD8<>0,AD8,\"\")","v":"2020-01-02"},"ano",null,null,{"$f":"IF(K27<>\"\",IF(K28<>0,K27+1-AE8,AE9-AE8),\"\")","v":0.58333333333575865},{"$f":"IF($E$22=\"ne\",0,IF(LEFT(L27,1)=\"A\",1,0)+IF(LEFT(M27,1)=\"A\",1,0)+IF(LEFT(N27,1)=\"A\",1,0))","v":1},{"$f":"IF(OR(O27<=5/24+1/24/60/60/100,O27=\"\"),1,IF(O27<=12/24,2,IF(O27<=18/24,3,4)))","v":3},{"$f":"IF(AND(K29=\"\",(Q7+Q5)<Q24),0,Q5)","v":91},null,null,null,null,null,null,"93/116/ES","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A2)<=$AD$9,$AD$8+List1!A2,\"\")","v":"2020-01-03"},null,null,null,{"$f":"IF(K28<>\"\",IF(K29<>\"\",1,$AE$9-K28),\"\")","v":1},0,{"$f":"IF(OR(O28<=5/24+1/24/60/60/100,O28=\"\"),1,IF(O28<=12/24,2,IF(O28<=18/24,3,4)))","v":4},{"$f":"IF(AND(K29=\"\",(Q7+Q5)<Q24),Q24,Q7)","v":200},null,null,null,null,null,null,"1999/100/ES","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A3)<=$AD$9,$AD$8+List1!A3,\"\")","v":"2020-01-04"},null,null,null,1,0,4,{"$f":"VLOOKUP(P29,$AC$12:$AG$16,Q29+1,FALSE)","v":200},null,null,null,null,null,null,"2004/3/ES","třetí údaj"]
[null,"Zdroj financování (PF UK, grant, jiný zdroj):",null,null,null,"Zpráva o výsledku pracovní cesty byla podána dne: ",null,null,null,null,{"$f":"IF(($AD$8+List1!A4)<=$AD$9,$AD$8+List1!A4,\"\")","v":"2020-01-05"},null,null,null,0.83333333333575865,0,4,200,null,null,null,null,null,null,"EU 692/2008","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A5)<=$AD$9,$AD$8+List1!A5,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU 692/2008A,…F","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A6)<=$AD$9,$AD$8+List1!A6,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU/566/2011","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A7)<=$AD$9,$AD$8+List1!A7,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"2007/46/ES","třetí údaj"]
[null,"Číslo bankovního účtu pro zasílání náhrad účtovateli:",null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A8)<=$AD$9,$AD$8+List1!A8,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EHK 101,R101.00","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A9)<=$AD$9,$AD$8+List1!A9,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"459/2012/EU","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A10)<=$AD$9,$AD$8+List1!A10,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"630/2012/EU ","třetí údaj"]
[null,"Prohlašuji, že jsem všechny údaje uvedl úplně a správně.",null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A11)<=$AD$9,$AD$8+List1!A11,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU195/2013","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A12)<=$AD$9,$AD$8+List1!A12,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"715/2007/ES","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A13)<=$AD$9,$AD$8+List1!A13,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU136/2014","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A14)<=$AD$9,$AD$8+List1!A14,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU2016/646","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A15)<=$AD$9,$AD$8+List1!A15,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU2017/1347","třetí údaj"]
[null,"Datum a podpis účtovatele",null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A16)<=$AD$9,$AD$8+List1!A16,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"EU2015/45","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($AD$8+List1!A17)<=$AD$9,$AD$8+List1!A17,\"\")","v":""},null,null,null,"",0,1,0,null,null,null,null,null,null,"jiná norma","arit.průměr"]
[]
[]
[]
[null,"Se způsobem provedení vyučtování souhlasí:"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Podpis přímého nadřízeného nebo řešitele grantu, projektu…"]
[]
[null,"Datum a podpis správce rozpočtu (tajemníka)"]
[]
[]
[]
[null,"Podpis vedoucího ekonom. odd. ",null,null,null,null,null,null,null,"Podpis zaměstnance, který kontroloval \na upravil vyúčtování (pokladní)"]

{"sheet":"Vyúčtování","index":2,"n_rows":60,"n_cols":44,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,5,61,9],[59,1,61,3],[55,1,56,3],[7,37,9,49],[25,3,25,4],[37,1,37,6],[38,1,39,4],[41,1,43,8],[46,1,47,8],[20,1,23,2],[20,3,20,4],[24,1,25,2],[15,5,15,6],[16,1,16,2],[28,1,28,6],[29,1,29,6],[0,35,0,36],[55,5,56,8],[33,1,35,8],[19,10,19,13],[50,1,51,3],[50,5,50,8],[28,35,28,37],[7,6,7,10],[6,30,7,30],[9,1,9,3],[6,31,7,31],[9,6,9,10],[9,17,9,18],[4,31,5,31],[4,30,5,30],[8,17,8,18],[13,1,13,3],[15,9,15,11],[16,9,16,11],[8,1,8,3],[11,7,11,8],[16,5,16,6],[15,1,15,2],[3,4,3,10],[26,1,27,2],[19,1,19,2],[21,9,22,9],[26,3,26,4],[27,3,27,4],[23,3,23,4],[19,3,19,4],[21,3,21,4],[22,3,22,4],[8,6,8,11],[24,3,24,4],[18,1,18,13],[24,10,24,13],[6,1,6,3],[5,6,5,10],[30,1,30,6],[1,1,1,13],[3,12,3,13],[11,1,11,3],[7,1,7,3],[10,1,10,3],[4,12,4,13],[4,1,4,3],[4,4,4,10],[6,6,6,10],[5,12,6,13],[9,12,9,13],[8,12,8,13],[2,1,2,3],[2,4,2,10],[3,1,3,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"60*60*24","v":86400}]
[null,"VYÚČTOVÁNÍ ZAHRANIČNÍ PRACOVNÍ CESTY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Kurzy ČNB jsou aktualizovány k \"&TEXT(MAX('Kurzy CNB'!A2:A389),\"dd.mm.rrrr\")","v":"Kurzy ČNB jsou aktualizovány k 03.02.2020"}]
[null,"Jméno a příjmení"]
[null,"Název akce",null,null,null,null,null,null,null,null,null,null,"stát",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vozidlo"]
[null,"Místo akce",null,null,null,null,null,null,null,null,null,null,"Německo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPZ"]
[null,null,null,null,"datum","čas","místo",null,null,null,null,null,"základní sazba zahraničního stravného",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palivo","benzin 95 oktanů",null,null,null,{"$f":"AO8","v":0}]
[null,"Zahájení cesty",null,null,"2020-01-02","08:00:00",null,null,null,null,null,null,null,null,null,null,null,{"$f":"E7+F7","v":"2020-01-02T08:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spotřeba 1",10,"Doplňte kombinovanou spotřebu dle norem EU z TP a ostatní pole ponechte prázdné"]
[null,"Překročení státní hranice/odlet",null,null,"2020-01-02","08:00:00",{"$f":"IF(R8<R7,\"překročení hranice nemůže být před začátkem cesty\",\"\")","v":""},null,null,null,null,null,{"$f":"VLOOKUP(M5,List1!V3:Y180,4,FALSE)","v":45},{"$f":"VLOOKUP(M5,List1!V3:Y180,2,FALSE)","v":"EUR"},null,null,null,{"$f":"E8+F8","v":"2020-01-02T08:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spotřeba 2",null,"Pokud údaj o kombinované spotřebě v technickém průkazu není, vypočte se spotřeba PHM vozidla aritmetickým průměrem ze všech údajů o spotřebě uvedených v technickém průkazu."]
[null,"Překročení státní hranice/přílet",null,null,null,null,{"$f":"IF(OR(E7>MAX('Kurzy CNB'!A2:A389),E16>MAX('Kurzy CNB'!A2:A389)),\"Začátek cesty nebo datum zálohy je v období mimo načtené kurzy ČNB\",\"\")","v":""},null,null,null,null,null,"použit kurz ze dne",null,null,null,null,{"$f":"E9+F9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spotřeba 3"]
[null,"Ukončení cesty",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(E16<>\"\",E14<>\"NE\",OR(F16<>\"\",F17<>\"\")),E16,E7)","v":"2020-01-02"},null,null,null,null,{"$f":"E10+F10","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spotřeba 4"]
[null,"Strava poskytnuta bezplatně",null,null,"ano",null,"Celková vzdálenost v km  při použití VV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Průměr - použitá spotřeba",{"$f":"ROUND(AVERAGE(AK7:AK10),2)","v":10},null,null,null,"0 - 5 hod","5 až 12 hod.","12 až 18 hod.","více než 18 hod."]
[null,"Použitý dopr. prostředek",null,null,"V",null,null,{"$f":"IF(E12=\"VV\",CEILING(G12*$AK$16+G12*$AK$21,0.01),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cena paliva z dokladu",null,"EUR",null,"počet jídel",0,"I","II","III"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cena paliva z dokladu CZK",{"$f":"CEILING(IF(AK12<>\"\",IF(AL12<>\"\",(IF(AL12=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(AL12,List1!$S$4:$T$36,2,FALSE),TRUE)))*AK12/VLOOKUP(AL12,List1!$S$3:$U$36,3,FALSE),0),0),0.0001)","v":0},null,null,0,0,100,150,220]
[null,"Poskytnuta záloha",null,null,"ne",null,"částka","měna","kurz ČNB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Náhrady",null,null,null,1,0,{"$f":"AP13*0.3","v":30},{"$f":"0.65*AQ13","v":97.5},{"$f":"0.75*AR13","v":165}]
[]
[null,"Záloha 1 ",null," vydaná dne","2020-01-10",null,null,"EUR",{"$f":"IF(OR(E16=\"\",H16=\"CZK\"),1,VLOOKUP(E16,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(H16,List1!$S$4:$T$36,2,FALSE),TRUE))","v":25.265000000000001},{"$f":"CEILING(I16*F16,0.001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"amortizace za km",4.2,null,null,2,0,0,{"$f":"0.3*AQ13","v":45},{"$f":"0.5*AR13","v":110}]
[null,"Záloha 2",null," vydaná dne",{"$f":"E16","v":"2020-01-10"},null,null,"CZK",{"$f":"IF(OR(E17=\"\",H17=\"CZK\",H17=\"\"),1,VLOOKUP(E17,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(H17,List1!$S$4:$T$36,2,FALSE),TRUE))","v":1},{"$f":"CEILING(I17*F17,0.001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"benzin 95 oktanů",32,null,null,3,0,0,0,{"$f":"0.25*AR13","v":55}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"benzin 98 oktanů",36]
[null,"VYÚČTOVÁNÍ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nafta",31.8]
[null,null,null,"Popis",null,"měna","částka","měna","částka",null,"Stravné",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elektřina",4.8]
[null,"Jízdní výdaje",null,"Vlastní vozidlo - VV",null,"CZK",{"$f":"H12","v":""},"CZK",{"$f":"G21","v":""},null,"měna","částka","měna","částka",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"náhrada za km paliva",{"$f":"ROUND(IF(AK13=0,(VLOOKUP(AK6,AJ17:AK20,2,FALSE)),AK13)*AK11/100,4)","v":3.2},{"$f":"IF(AK13<>\"\",\"použita cena z dokladu\",\"použita cena z vyhlášky\")","v":"použita cena z dokladu"}]
[null,null,null,null,null,"CZK",null,"CZK",{"$f":"IF(G22<>\"\",IF(F22<>\"\",(IF(F22=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F22,List1!$S$4:$T$36,2,FALSE),TRUE)))*G22/VLOOKUP(F22,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""},null,"CZK",{"$f":"CEILING(SUM(Z27:Z55),0.01)","v":0},"CZK",{"$f":"L22","v":0}]
[null,null,null,null,null,"EUR",null,"CZK",{"$f":"IF(G23<>\"\",IF(F23<>\"\",(IF(F23=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F23,List1!$S$4:$T$36,2,FALSE),TRUE)))*G23/VLOOKUP(F23,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""},null,{"$f":"N8","v":"EUR"},{"$f":"CEILING(SUM(AA27:AA55),0.01)","v":0},"CZK",{"$f":"IF(L23<>\"\",VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(K23,List1!$S$4:$T$36,2,FALSE),TRUE))*L23/VLOOKUP(K23,List1!$S$3:$U$36,3,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zahra"]
[null,null,null,null,null,null,null,"CZK",{"$f":"IF(G24<>\"\",IF(F24<>\"\",(IF(F24=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F24,List1!$S$4:$T$36,2,FALSE),TRUE)))*G24/VLOOKUP(F24,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""}]
[null,"Výdaje za ubytování",null,null,null,null,null,"CZK",{"$f":"IF(G25<>\"\",IF(F25<>\"\",(IF(F25=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F25,List1!$S$4:$T$36,2,FALSE),TRUE)))*G25/VLOOKUP(F25,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""},null,"Bezplatně poskytnutá strava",null,null,null,null,null,null,null,null,null,null,"počet jídel",null,null,null,"CZK",{"$f":"N8","v":"EUR"},null,"Celkem",null,null,null,null,null,null,null,null,null,null,null,"0 - 1 hod","1 až 12 hod.","12 až 18 hod.","více než 18 hod."]
[null,null,null,null,null,null,null,"CZK",{"$f":"IF(G26<>\"\",IF(F26<>\"\",(IF(F26=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F26,List1!$S$4:$T$36,2,FALSE),TRUE)))*G26/VLOOKUP(F26,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""},null,"Datum","snídaně","oběd","večeře","doba","začátek zahr","konec zahr","doba zahr","doba CR","přep zahr","přep CR",null,"kod zahr","kod tuz",null,"stravne CR","stravne zahr",null,null,null,null,null,null,null,null,null,null,null,null,"počet jídel",0,"I","II","III"]
[null,"Ostatní výdaje",null,null,null,null,null,"CZK",{"$f":"IF(G27<>\"\",IF(F27<>\"\",(IF(F27=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F27,List1!$S$4:$T$36,2,FALSE),TRUE)))*G27/VLOOKUP(F27,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""},null,{"$f":"IF(E7<>0,E7,\"\")","v":"2020-01-02"},null,null,null,{"$f":"IF(K27<>\"\",IF(K28<>\"\",K27+1-R7,R10-R7),\"\")","v":-43832.333333333336},{"$f":"IF(OR($E$8>K27,$E$9<K27),\"\",IF(K27=$E$8,$R$8,K27))","v":""},{"$f":"IF(OR($E$8>K27,$E$9<K27),\"\",IF(K27=$E$9,$R$9,K27+1))","v":""},{"$f":" IF(P27=\"\",\"\",Q27-P27)","v":""},{"$f":"IF(O27<>\"\",IF(R27<>\"\",O27-R27,O27),\"\")","v":-43832.333333333336},{"$f":"IF(S27<5/24,R27,IF(R27<=(5/24+0.0000001),\"\",R27))","v":""},{"$f":"IF(S27>=5/24,IF(R27<=(5/24+0.0000001),S27+R27,S27),S27)","v":-43832.333333333336},{"$f":"IF($E$11=\"ne\",0,IF(LEFT(L27,1)=\"A\",1,0)+IF(LEFT(M27,1)=\"A\",1,0)+IF(LEFT(N27,1)=\"A\",1,0))","v":0},{"$f":"IF(T27<>\"\",(IF(T27<(1/24-0.0000001),1,(IF(T27<=12/24,2,IF(T27<=18/24,3,4))))),\"\")","v":""},{"$f":"IF(U27<>\"\",(IF(U27<5/24,1,(IF(U27<=12/24,2,IF(U27<=18/24,3,4))))),\"\")","v":1},null,{"$f":"IF(X27<>\"\",IF(W27=\"\",VLOOKUP(V27,$AN$12:$AR$17,X27+1,FALSE),VLOOKUP(0,$AN$12:$AR$17,X27+1)),\"\")","v":0},{"$f":"IF(W27=\"\",\"\",IF(X27=1,VLOOKUP(V27,$AN$26:$AR$30,W27+1,FALSE),VLOOKUP(V27,$AN$26:$AR$30,3,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AR27/3","v":15},{"$f":"AR27*2/3","v":30},{"$f":"M8","v":45}]
[null,null,null,null,null,null,null,"CZK",{"$f":"IF(G28<>\"\",IF(F28<>\"\",(IF(F28=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(F28,List1!$S$4:$T$36,2,FALSE),TRUE)))*G28/VLOOKUP(F28,List1!$S$3:$U$36,3,FALSE),\"\"),\"\")","v":""},null,{"$f":"IF(($E$7+List1!A2)<=$E$10,$E$7+List1!A2,\"\")","v":""},null,null,null,{"$f":"IF(K28<>\"\",IF(K29<>\"\",1,$R$10-K28),\"\")","v":""},{"$f":"IF(OR($E$8>K28,$E$9<K28),\"\",IF(K28=$E$8,$R$8,K28))","v":""},{"$f":"IF(OR($E$8>K28,$E$9<K28),\"\",IF(K28=$E$9,$R$9,K28+1))","v":"00:00:00"},{"$f":" IF(P28=\"\",\"\",Q28-P28)","v":""},"",{"$f":"IF(S28<5/24,R28,IF(R28<=(5/24+0.0000001),\"\",R28))","v":""},{"$f":"IF(S28>=5/24,IF(R28<=(5/24+0.0000001),S28+R28,S28),S28)","v":""},0,{"$f":"IF(T28<>\"\",(IF(T28<(1/24-0.0000001),1,(IF(T28<=12/24,2,IF(T28<=18/24,3,4))))),\"\")","v":""},{"$f":"IF(U28<>\"\",(IF(U28<5/24,1,(IF(U28<=12/24,2,IF(U28<=18/24,3,4))))),\"\")","v":""},null,"",{"$f":"IF(W28=\"\",\"\",IF(X28=1,VLOOKUP(V28,$AN$26:$AR$30,W28+1,FALSE),VLOOKUP(V28,$AN$26:$AR$30,3,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1,0,{"$f":"AP27*0.3","v":4.5},{"$f":"0.65*AQ27","v":19.5},{"$f":"0.75*AR27","v":33.75}]
[null,"Celkem (včetně stravného)",null,null,null,null,null,"CZK",{"$f":"SUM(I21:I28,N22:N23)","v":0},null,{"$f":"IF(($E$7+List1!A3)<=$E$10,$E$7+List1!A3,\"\")","v":""},null,null,null,"","",{"$f":"IF(OR($E$8>K29,$E$9<K29),\"\",IF(K29=$E$9,$R$9,K29+1))","v":"00:00:00"},"","",{"$f":"IF(S29<5/24,R29,IF(R29<=(5/24+0.0000001),\"\",R29))","v":""},"",0,"","",null,"","",null,null,null,null,null,null,null,null,"Přehled EU norem používaných v TP",null,null,null,2,0,0,{"$f":"0.3*AQ27","v":9},{"$f":"0.5*AR27","v":22.5}]
[null,"Záloha",null,null,null,null,null,"CZK",{"$f":"IF(E14=\"ne\",0,CEILING(J16+J17,0.01))","v":0},null,{"$f":"IF(($E$7+List1!A4)<=$E$10,$E$7+List1!A4,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"80/1268/EHS","arit.průměr","3 údaje v TP",null,3,0,0,0,{"$f":"0.25*AR27","v":11.25}]
[null,{"$f":"IF(I31<0,\"Přeplatek (zaměstnanec vrátí)\", \"Doplatek (zaměstnanci bude doplaceno)\")","v":"Doplatek (zaměstnanci bude doplaceno)"},null,null,null,null,null,"CZK",{"$f":"(I29-I30)/(IF(H31=\"CZK\",1,VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$85,VLOOKUP(H31,List1!$S$4:$T$36,2,FALSE),TRUE))/VLOOKUP(H31,List1!$S$3:$U$36,3,FALSE))","v":0},null,{"$f":"IF(($E$7+List1!A5)<=$E$10,$E$7+List1!A5,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"93/116/ES","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A6)<=$E$10,$E$7+List1!A6,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"1999/100/ES","třetí údaj"]
[null,"Zdroj financování (PF UK, grant nebo projekt):",null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A7)<=$E$10,$E$7+List1!A7,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"2004/3/ES","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A8)<=$E$10,$E$7+List1!A8,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU 692/2008","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A9)<=$E$10,$E$7+List1!A9,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU 692/2008A,…F","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A10)<=$E$10,$E$7+List1!A10,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU/566/2011","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A11)<=$E$10,$E$7+List1!A11,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"2007/46/ES","třetí údaj"]
[null,"Číslo bankovního účtu pro zasílání náhrad zaměstnanci:",null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A12)<=$E$10,$E$7+List1!A12,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"EHK 101,R101.00","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A13)<=$E$10,$E$7+List1!A13,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"459/2012/EU","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A14)<=$E$10,$E$7+List1!A14,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"630/2012/EU ","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A15)<=$E$10,$E$7+List1!A15,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU195/2013","třetí údaj"]
[null,"Prohlašuji, že jsem všechny údaje uvedl úplně, a že je  zpráva ze zahraniční  pracovní cesty přiložena.",null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A16)<=$E$10,$E$7+List1!A16,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"715/2007/ES","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A17)<=$E$10,$E$7+List1!A17,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU136/2014","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A18)<=$E$10,$E$7+List1!A18,\"\")","v":""},null,null,null,"","","00:00:00","","",{"$f":"IF(S44<5/24,R44,IF(R44<=(5/24+0.0000001),\"\",R44))","v":""},"",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU2016/646","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A19)<=$E$10,$E$7+List1!A19,\"\")","v":""},null,null,null,"","","00:00:00","","",{"$f":"IF(S45<5/24,R45,IF(R45<=(5/24+0.0000001),\"\",R45))","v":""},"",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU2017/1347","třetí údaj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A20)<=$E$10,$E$7+List1!A20,\"\")","v":""},null,null,null,"","","00:00:00","","",{"$f":"IF(S46<5/24,R46,IF(R46<=(5/24+0.0000001),\"\",R46))","v":""},"",0,"","",null,"","",null,null,null,null,null,null,null,null,"EU2015/45","třetí údaj"]
[null,"Datum a podpis zaměstance",null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A21)<=$E$10,$E$7+List1!A21,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"","",null,null,null,null,null,null,null,null,"jiná norma","arit.průměr"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A22)<=$E$10,$E$7+List1!A22,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A23)<=$E$10,$E$7+List1!A23,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A24)<=$E$10,$E$7+List1!A24,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,"Podpis řešitele grantu nebo projektu",null,null,null,"Podpis vedoucího zahraničního oddělení",null,null,null,null,{"$f":"IF(($E$7+List1!A25)<=$E$10,$E$7+List1!A25,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A26)<=$E$10,$E$7+List1!A26,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A27)<=$E$10,$E$7+List1!A27,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A28)<=$E$10,$E$7+List1!A28,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A29)<=$E$10,$E$7+List1!A29,\"\")","v":""},null,null,null,"","","00:00:00","","","","",0,"","",null,"",""]
[null,"Podpis přímého nadřízeného",null,null,null,"Podpis vedoucího ekonomického oddělení"]
[]
[]
[]
[null,"Podpis správce rozpočtu (tajemníka)",null,null,null,"Podpis pracovníka ekonomického oddělení, \nkterý kontroloval a upravil vyúčtování"]

{"sheet":"Kurzy CNB","index":3,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Datum","1 AUD","1 BGN","1 BRL","1 CAD","1 CHF","1 CNY","1 DKK","1 EUR","1 GBP","1 HKD","1 HRK","100 HUF","1000 IDR","1 ILS","100 INR","100 ISK","100 JPY","100 KRW","1 MXN","1 MYR","1 NOK","1 NZD","100 PHP","1 PLN","1 RON","100 RUB","1 SEK","1 SGD","100 THB","1 TRY","1 USD","1 XDR","1 ZAR"]
["2020-01-02",15.872999999999999,12.991,5.6639999999999997,17.460999999999999,23.388000000000002,3.26,3.4009999999999998,25.41,29.954999999999998,2.9140000000000001,3.4129999999999998,7.7009999999999996,1.635,6.5670000000000002,31.795000000000002,18.561,20.87,1.9570000000000001,1.202,5.5540000000000003,2.5819999999999999,15.198,44.697000000000003,5.9720000000000004,5.3140000000000001,36.716000000000001,2.4260000000000002,16.844999999999999,75.296000000000006,3.81,22.702000000000002,31.393000000000001,1.613]
["2020-01-03",15.821,12.968,5.5990000000000002,17.53,23.396000000000001,3.2639999999999998,3.3929999999999998,25.36,29.797000000000001,2.9249999999999998,3.4060000000000001,7.673,1.6339999999999999,6.5419999999999998,31.699000000000002,18.524000000000001,21.039000000000001,1.95,1.1990000000000001,5.5469999999999997,2.5790000000000002,15.169,44.508000000000003,5.968,5.306,36.69,2.4180000000000001,16.856999999999999,75.451999999999998,3.8090000000000002,22.753,31.49,1.593]
["2020-01-06",15.696,12.935,5.5659999999999998,17.413,23.317,3.2429999999999999,3.3849999999999998,25.3,29.687000000000001,2.9089999999999998,3.387,7.6749999999999998,1.621,6.5010000000000003,31.425999999999998,18.427,20.91,1.9330000000000001,1.1970000000000001,5.5069999999999997,2.569,15.071,44.194000000000003,5.9649999999999999,5.2990000000000004,36.451999999999998,2.4020000000000001,16.744,74.962999999999994,3.782,22.600999999999999,31.219000000000001,1.5860000000000001]
["2020-01-07",15.553000000000001,12.920999999999999,5.5410000000000004,17.408000000000001,23.298999999999999,3.2589999999999999,3.3820000000000001,25.274999999999999,29.675000000000001,2.911,3.3929999999999998,7.63,1.631,6.5270000000000001,31.489000000000001,18.408999999999999,20.864000000000001,1.9410000000000001,1.1990000000000001,5.5279999999999996,2.5640000000000001,15.012,44.476999999999997,5.9539999999999997,5.2889999999999997,36.506999999999998,2.3969999999999998,16.760999999999999,74.725999999999999,3.786,22.626000000000001,31.335999999999999,1.583]
["2020-01-08",15.603,12.923,5.6040000000000001,17.463999999999999,23.405999999999999,3.2749999999999999,3.3809999999999998,25.265000000000001,29.777999999999999,2.9239999999999999,3.3919999999999999,7.633,1.637,6.5579999999999998,31.788,18.428000000000001,20.905999999999999,1.948,1.2090000000000001,5.5439999999999996,2.5649999999999999,15.092000000000001,44.796999999999997,5.9550000000000001,5.2880000000000003,36.820999999999998,2.403,16.834,74.891999999999996,3.82,22.739000000000001,31.478000000000002,1.5980000000000001]
["2020-01-09",15.598000000000001,12.913,5.5890000000000004,17.411999999999999,23.364999999999998,3.28,3.379,25.254999999999999,29.613,2.9260000000000002,3.3919999999999999,7.5949999999999998,1.641,6.55,31.902999999999999,18.341000000000001,20.78,1.96,1.21,5.5570000000000004,2.56,15.037000000000001,44.9,5.9530000000000003,5.2850000000000001,37.097999999999999,2.3969999999999998,16.817,75.075000000000003,3.8660000000000001,22.733000000000001,31.405999999999999,1.6]
["2020-01-10",15.662000000000001,12.917999999999999,5.5919999999999996,17.428000000000001,23.346,3.2909999999999999,3.3809999999999998,25.265000000000001,29.79,2.9329999999999998,3.3940000000000001,7.5670000000000002,1.655,6.5670000000000002,32.107999999999997,18.495999999999999,20.777999999999999,1.964,1.2110000000000001,5.5880000000000001,2.5579999999999998,15.065,45.116999999999997,5.95,5.2859999999999996,37.128,2.395,16.879000000000001,75.334999999999994,3.875,22.78,31.422000000000001,1.5980000000000001]
["2020-01-13",15.654999999999999,12.898999999999999,5.5060000000000002,17.382999999999999,23.337,3.29,3.3759999999999999,25.23,29.42,2.9169999999999998,3.3889999999999998,7.5469999999999997,1.659,6.5359999999999996,32.009,18.388999999999999,20.638999999999999,1.9590000000000001,1.2070000000000001,5.5819999999999999,2.5499999999999998,15.045,44.935000000000002,5.9580000000000002,5.2789999999999999,37.057000000000002,2.3889999999999998,16.832000000000001,75.051000000000002,3.8690000000000002,22.677,31.28,1.577]
["2020-01-14",15.615,12.863,5.4630000000000001,17.315999999999999,23.364999999999998,3.2879999999999998,3.3660000000000001,25.155000000000001,29.382999999999999,2.91,3.379,7.56,1.6559999999999999,6.5270000000000001,31.954000000000001,18.335000000000001,20.565999999999999,1.956,1.202,5.5549999999999997,2.5430000000000001,14.972,44.73,5.9580000000000002,5.2629999999999999,36.860999999999997,2.39,16.792000000000002,74.822000000000003,3.8439999999999999,22.634,31.234999999999999,1.569]
["2020-01-15",15.534000000000001,12.856,5.4240000000000004,17.263000000000002,23.388999999999999,3.2770000000000001,3.3650000000000002,25.145,29.347000000000001,2.9039999999999999,3.3780000000000001,7.5529999999999999,1.651,6.5220000000000002,31.875,18.408000000000001,20.539000000000001,1.95,1.2,5.5369999999999999,2.544,14.874000000000001,44.485999999999997,5.95,5.2590000000000003,36.741,2.3809999999999998,16.751000000000001,74.587999999999994,3.8340000000000001,22.567,31.155999999999999,1.569]
["2020-01-16",15.622,12.87,5.4109999999999996,17.294,23.44,3.2759999999999998,3.3679999999999999,25.17,29.448,2.9,3.38,7.54,1.6539999999999999,6.5259999999999998,31.779,18.372,20.497,1.9450000000000001,1.1990000000000001,5.5460000000000003,2.5409999999999999,15.012,44.33,5.9470000000000001,5.266,36.587000000000003,2.3820000000000001,16.753,74.221999999999994,3.8559999999999999,22.538,31.135000000000002,1.5620000000000001]
["2020-01-17",15.599,12.856,5.4180000000000001,17.344999999999999,23.423999999999999,3.3010000000000002,3.3650000000000002,25.145,29.545999999999999,2.9140000000000001,3.3809999999999998,7.4930000000000003,1.66,6.5529999999999999,31.856000000000002,18.300999999999998,20.558,1.952,1.2070000000000001,5.5839999999999996,2.5430000000000001,14.987,44.466000000000001,5.9349999999999996,5.2590000000000003,36.837000000000003,2.3849999999999998,16.808,74.564999999999998,3.8530000000000002,22.638000000000002,31.292999999999999,1.5660000000000001]
["2020-01-20",15.555,12.847,5.42,17.344999999999999,23.4,3.3010000000000002,3.3620000000000001,25.125,29.466000000000001,2.9180000000000001,3.379,7.4690000000000003,1.663,6.5549999999999997,31.89,18.259,20.571000000000002,1.954,1.214,5.5810000000000004,2.5430000000000001,14.958,44.48,5.9210000000000003,5.2569999999999997,36.832999999999998,2.38,16.815999999999999,74.671999999999997,3.83,22.667000000000002,31.294,1.56]
["2020-01-21",15.5,12.816000000000001,5.3730000000000002,17.268999999999998,23.332000000000001,3.2679999999999998,3.3540000000000001,25.065000000000001,29.477,2.9020000000000001,3.37,7.4749999999999996,1.651,6.5259999999999998,31.675000000000001,18.189,20.492999999999999,1.931,1.204,5.5389999999999997,2.5230000000000001,14.916,44.201999999999998,5.9059999999999997,5.2450000000000001,36.472000000000001,2.375,16.716999999999999,74.183000000000007,3.8010000000000002,22.552,31.135000000000002,1.5580000000000001]
["2020-01-22",15.535,12.851000000000001,5.4089999999999998,17.379000000000001,23.364999999999998,3.2850000000000001,3.363,25.135000000000002,29.763000000000002,2.9169999999999998,3.379,7.4889999999999999,1.661,6.5659999999999998,31.866,18.239999999999998,20.613,1.9470000000000001,1.2110000000000001,5.577,2.524,14.978999999999999,44.485999999999997,5.931,5.2590000000000003,36.591000000000001,2.3820000000000001,16.808,74.620999999999995,3.827,22.667999999999999,31.274999999999999,1.5740000000000001]
["2020-01-23",15.582000000000001,12.864000000000001,5.4409999999999998,17.236999999999998,23.440999999999999,3.2719999999999998,3.367,25.16,29.777999999999999,2.919,3.38,7.4619999999999997,1.6639999999999999,6.5629999999999997,31.812000000000001,18.257999999999999,20.707000000000001,1.9430000000000001,1.212,5.5739999999999998,2.524,14.98,44.530999999999999,5.9290000000000003,5.2649999999999997,36.662999999999997,2.3849999999999998,16.806000000000001,74.308000000000007,3.8260000000000001,22.686,31.286000000000001,1.577]
["2020-01-24",15.601000000000001,12.864000000000001,5.46,17.361000000000001,23.49,3.2869999999999999,3.367,25.16,29.835999999999999,2.9329999999999998,3.3820000000000001,7.4880000000000004,1.68,6.6029999999999998,31.984999999999999,18.311,20.800999999999998,1.952,1.214,5.6079999999999997,2.532,15.081,44.850999999999999,5.9109999999999996,5.2640000000000002,36.909999999999997,2.3879999999999999,16.875,74.619,3.839,22.797999999999998,31.452000000000002,1.5860000000000001]
["2020-01-27",15.487,12.898999999999999,5.43,17.350999999999999,23.602,3.2989999999999999,3.3759999999999999,25.23,29.902999999999999,2.9420000000000002,3.39,7.4749999999999996,1.6819999999999999,6.6130000000000004,32.037999999999997,18.361999999999998,21.004000000000001,1.9430000000000001,1.2090000000000001,5.6289999999999996,2.5139999999999998,15.002000000000001,44.984000000000002,5.907,5.2770000000000001,36.542999999999999,2.3849999999999998,16.858000000000001,74.489999999999995,3.8479999999999999,22.882999999999999,31.510999999999999,1.573]
["2020-01-28",15.481999999999999,12.895,5.4589999999999996,17.372,23.564,3.3039999999999998,3.375,25.22,29.81,2.9470000000000001,3.39,7.48,1.68,6.6310000000000002,32.146000000000001,18.382000000000001,21.013000000000002,1.944,1.216,5.6079999999999997,2.5030000000000001,14.973000000000001,45.131999999999998,5.9020000000000001,5.2779999999999996,36.600999999999999,2.379,16.87,74.353999999999999,3.8519999999999999,22.916,31.538,1.5640000000000001]
["2020-01-29",15.465,12.887,5.47,17.388999999999999,23.492000000000001,3.3029999999999999,3.3730000000000002,25.204999999999998,29.800999999999998,2.948,3.387,7.4710000000000001,1.681,6.6260000000000003,32.143999999999998,18.547000000000001,20.995000000000001,1.944,1.2230000000000001,5.6159999999999997,2.5059999999999998,14.942,45.070999999999998,5.8840000000000003,5.2759999999999998,36.542000000000002,2.383,16.837,73.983000000000004,3.8450000000000002,22.913,31.509,1.5680000000000001]
["2020-01-30",15.385,12.909000000000001,5.3920000000000003,17.327999999999999,23.619,3.3010000000000002,3.379,25.25,29.992999999999999,2.9470000000000001,3.3929999999999998,7.4630000000000001,1.6779999999999999,6.6310000000000002,31.954000000000001,18.579999999999998,21.036000000000001,1.92,1.22,5.6,2.4820000000000002,14.878,44.892000000000003,5.89,5.2859999999999996,36.243000000000002,2.3730000000000002,16.8,73.391000000000005,3.83,22.893999999999998,31.48,1.552]
["2020-01-31",15.285,12.888999999999999,5.3460000000000001,17.234000000000002,23.577000000000002,3.2879999999999998,3.3730000000000002,25.21,29.95,2.9369999999999998,3.3860000000000001,7.48,1.67,6.6180000000000003,31.949000000000002,18.495999999999999,20.946999999999999,1.9079999999999999,1.212,5.5659999999999998,2.4740000000000002,14.756,44.713000000000001,5.8620000000000001,5.274,35.844000000000001,2.3610000000000002,16.704000000000001,73.180000000000007,3.8130000000000002,22.81,31.385000000000002,1.528]
["2020-02-03",15.239000000000001,12.872,5.3380000000000001,17.187000000000001,23.59,3.2429999999999999,3.3690000000000002,25.175000000000001,29.696999999999999,2.93,3.383,7.4560000000000004,1.655,6.6020000000000003,31.866,18.335999999999999,20.960999999999999,1.9079999999999999,1.21,5.53,2.4540000000000002,14.717000000000001,44.722000000000001,5.859,5.2679999999999998,35.658999999999999,2.3570000000000002,16.63,73.284999999999997,3.802,22.75,31.324999999999999,1.5269999999999999]

{"sheet":"List1","index":4,"n_rows":180,"n_cols":25,"rows_kept":180,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"2020-01-01",null,null,null,null,null,null,null,"počet dní"]
[1,null,null,null,null,null,null,"2020-12-31",null,null,"ano","JE",null,"ZO PF UK",null,{"$f":"Příkaz!F14-Příkaz!F6+1","v":1},{"$f":"VALUE(RIGHT(P2,1))","v":1},{"$f":"P2&\" \"&VLOOKUP(Q2,P6:Q15,2,FALSE)","v":"1 den"},null,null,null,"Země","Měnový kód","Měna","Základní sazby zahraničního stravného"]
[2,"V","Vlak",null,null,null,null,null,null,null,"ne","NENÍ",null,"jinak",null,null,null,"CZK","CZK",0,1,"Afghánistán","EUR","euro",40]
[3,"A","Autobus",null,null,null,null,null,"CZK",null,null,null,null,null,null,null,null,"EUR","AUD",2,1,"Albánie","EUR","euro",35]
[4,"L","Letadlo",null,null,null,null,null,"EUR",null,"Ne",null,null,null,null,null,null,"GBP","BGN",3,1,"Alžírsko","EUR","euro",45]
[5,"SV","Služební silniční vozidlo",null,null,null,null,null,"USD",null,"Ano, v hotovosti",null,null,"ZO PF UK",null,0,"dní","PLN","BRL",4,1,"Andorra","EUR","euro",45]
[6,"SJ","Spolujízda",null,null,null,null,null,"GBP",null,"Ano, na bank. účet",null,null,"vyjíždějící",null,1,"den","USD","CAD",5,1,"Angola","USD","americký dolar",60]
[7,"VV","Vlastní silniční vozidlo - náhrada za každý km jízdy",null,null,null,null,null,"AUD",null,null,null,null,null,null,2,"dny",null,"CHF",6,1,"Argentina","USD","americký dolar",50]
[8,"V - VV","Vlastní vozidlo s náhradou výdajů za vlak",null,null,null,null,null,"BRL",null,null,null,null,null,null,3,"dny",null,"CNY",7,1,"Arménie","EUR","euro",35]
[9,"A - VV","Vlastní vozidlo s náhradou výdajů za autobus",null,null,null,null,null,"BGN",null,null,null,null,null,null,4,"dny",null,"DKK",8,1,"Austrálie a Oceánie – ostrovní státy1) ","USD","americký dolar",60]
[10,"L - VV","Vlastní vozidlo s náhradou výdajů za letadlo",null,null,null,null,null,"CNY",null,null,null,null,null,null,5,"dní",null,"EUR",9,1,"Ázerbájdžán","EUR","euro",40]
[11,null,null,null,null,null,null,null,"DKK",null,null,null,null,null,null,6,"dní",null,"GBP",10,1,"Bahamy","USD","americký dolar",55]
[12,"S",null,null,null,null,null,null,"PHP",null,null,null,null,null,null,7,"dní",null,"HKD",11,1,"Bahrajn","EUR","euro",45]
[13,"O",null,null,null,null,null,null,"HKD",null,null,null,null,null,null,8,"dní",null,"HRK",12,1,"Bangladéš","USD","americký dolar",50]
[14,"V",null,null,null,null,null,null,"HRK",null,null,null,null,null,null,9,"dní",null,"HUF",13,100,"Belgie","EUR","euro",50]
[15,"SO",null,null,null,null,null,null,"INR",null,null,null,null,null,null,null,null,null,"IDR",14,1000,"Belize","USD","americký dolar",50]
[16,"SV",null,null,null,null,null,null,"IDR",null,null,null,null,null,null,null,null,null,"ILS",15,1,"Benin","EUR","euro",45]
[17,"OV",null,null,null,null,null,null,"ISK",null,null,null,null,null,null,null,null,null,"INR",16,100,"Bermudy","USD","americký dolar",50]
[18,"SOV",null,null,null,null,null,null,"ILS",null,null,null,null,null,null,null,null,null,"ISK",17,100,"Bělorusko","EUR","euro",45]
[19,null,null,null,null,null,null,null,"JPY",null,null,null,null,null,null,null,null,null,"JPY",18,100,"Bhútán","USD","americký dolar",50]
[20,null,null,null,null,null,null,null,"ZAR",null,null,null,null,null,null,null,null,null,"KRW",19,100,"Bolívie","USD","americký dolar",50]
[21,110,"Z",1,null,null,null,null,"CAD",null,null,null,null,null,null,null,null,null,"MXN",20,1,"Bosna a Hercegovina","EUR","euro",40]
[22,1010,"P",2,null,null,null,null,"KRW",null,null,null,null,null,null,null,null,null,"MYR",21,1,"Botswana","USD","americký dolar",55]
[23,1001,"K",3,null,null,null,null,"HUF",null,null,null,null,null,null,null,null,null,"NOK",22,1,"Brazílie","USD","americký dolar",55]
[24,101,"S",4,null,null,null,null,"MYR",null,null,null,null,null,null,null,null,null,"NZD",23,1,"Brunej","USD","americký dolar",40]
[25,0,0,5,null,null,null,null,"MXN",null,null,null,null,null,null,null,null,null,"PHP",24,100,"Bulharsko","EUR","euro",35]
[26,null,null,null,null,null,null,null,"XDR",null,null,null,null,null,null,null,null,null,"PLN",25,1,"Burkina Faso ","EUR","euro",40]
[27,null,null,null,null,null,null,null,"NOK",null,null,null,null,null,null,null,null,null,"RON",26,1,"Burundi","USD","americký dolar",55]
[28,null,null,null,null,null,null,null,"NZD",null,null,null,null,null,null,null,null,null,"RUB",27,100,"Čad","EUR","euro",45]
[29,null,null,null,null,null,null,null,"PLN",null,null,null,null,null,null,null,null,null,"SEK",28,1,"Černá Hora","EUR","euro",35]
[30,null,null,null,null,null,null,null,"RON",null,null,null,null,null,null,null,null,null,"SGD",29,1,"Čína","EUR","euro",45]
[31,null,null,null,null,null,null,null,"RUB",null,null,null,null,null,null,null,null,null,"THB",30,100,"Dánsko","EUR","euro",55]
[32,null,null,null,null,null,null,null,"SGD",null,null,null,null,null,null,null,null,null,"TRY",31,1,"Džibuti","EUR","euro",50]
[33,null,null,null,null,null,null,null,"SEK",null,null,null,null,null,null,null,null,null,"USD",32,1,"Egypt","EUR","euro",35]
[34,null,null,null,null,null,null,null,"CHF",null,null,null,null,null,null,null,null,null,"XDR",33,1,"Ekvádor","USD","americký dolar",50]
[35,null,null,null,null,null,null,null,"THB",null,null,null,null,null,null,null,null,null,"ZAR",34,1,"Eritrea","USD","americký dolar",50]
[36,null,null,null,null,null,null,null,"TRY",null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(S37,3)","v":""},null,"Estonsko","EUR","euro",40]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Etiopie","EUR","euro",45]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Filipíny","EUR","euro",35]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Finsko","EUR","euro",50]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Francie","EUR","euro",45]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Francouzská Guayana","EUR","euro",45]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Gabon","EUR","euro",50]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Gambie","EUR","euro",45]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Ghana","EUR","euro",50]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Gibraltar","EUR","euro",40]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Gruzie","EUR","euro",35]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Guatemala","USD","americký dolar",45]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Guinea","EUR","euro",45]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Guinea-Bissau","EUR","euro",45]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Guyana","USD","americký dolar",50]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Honduras","USD","americký dolar",45]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Hongkong ","EUR","euro",45]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Chile","USD","americký dolar",55]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Chorvatsko","EUR","euro",35]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Indie","EUR","euro",45]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Indonésie","EUR","euro",35]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Irák","EUR","euro",40]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Írán","EUR","euro",40]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Irsko","EUR","euro",50]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Island","EUR","euro",60]
[61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Itálie, Vatikán a San Marino","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Izrael","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Japonsko","USD","americký dolar",65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Jemen","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Jihoafrická republika","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Jižní Súdán","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Jordánsko","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(S69,3)","v":""},null,"Kambodža","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kamerun","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kanada","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kapverdy","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Karibik – ostrovní státy2) ","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Katar","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kazachstán","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Keňa","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kolumbie","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Komory","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Konžská republika  (Brazzaville)","USD","americký dolar",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Konžská demokratická republika (Kinshasa)","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Korejská lidově demokratická republika","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Korejská republika","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kosovo","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kostarika","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kuba","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kuvajt","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kypr","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kyrgyzstán","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Laos","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Lesotho","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Libanon","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Libérie","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Libye","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Lichtenštejnsko","CHF","švýcarský frank",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Litva","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Lotyšsko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Lucembursko","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Macao ","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Madagaskar","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Maďarsko","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Malajsie","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Malawi","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Maledivy","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Mali","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Malta","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Maroko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Mauretánie","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Mauricius","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Mexiko","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Moldavsko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Monako","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Mongolsko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Mozambik","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Myanmar (Barma)","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Namibie","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Německo","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Nepál","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Niger ","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Nigérie","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Nikaragua","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Nizozemsko","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Norsko","EUR","euro",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Nový Zéland","USD","americký dolar",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Omán","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Pákistán","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Panama","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Paraguay","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Peru","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Pobřeží Slonoviny","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Polsko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Portugalsko a Azory","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Rakousko","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(S133,3)","v":""},null,"Rovníková Guinea","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Rumunsko","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Rusko","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Rwanda","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Řecko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Salvador","USD","americký dolar",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"San Marino","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Saúdská Arábie","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Senegal","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Severní Makedonie","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Seychely","USD","americký dolar",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Sierra Leone","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Singapur","USD","americký dolar",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Spojené arabské emiráty","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Slovensko","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Slovinsko","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Somálsko","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Spojené státy americké","USD","americký dolar",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Srbsko ","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Srí Lanka","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Středoafrická republika","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Súdán","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Surinam","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Svatý Tomáš a Princův ostrov","EUR","euro",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Svazijsko ","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Sýrie","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Španělsko","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Švédsko","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Švýcarsko","CHF","švýcarský frank",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Tádžikistán","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Tanzanie","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Thajsko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Tchaj-wan","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Togo ","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Tunisko","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Turecko","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Turkmenistán","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Uganda","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Ukrajina","EUR","euro",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Uruguay","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Uzbekistán","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Vatikán","EUR","euro",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Velká Británie","GBP","anglická libra",45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Venezuela","USD","americký dolar",65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Vietnam","EUR","euro",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Zambie","USD","americký dolar",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Zimbabwe","USD","americký dolar",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"ostatní země neuvedené v příloze","EUR","euro",35]