{"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],[0,10,0,17],[25,3,25,15],[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,"Příloha OD  č. 2/2020\n\nEvidenč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,500,null,null,"GBP",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$156,VLOOKUP(M34,List1!$S$4:$T$36,2,FALSE),TRUE)))*J34,\"\"),\"\")","v":14782.5},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,{"$f":"IF(D34=\"Ano, na bank. Účet\",\"Číslo bankovního účtu\",\"Datum vyplacení\")","v":"Datum vyplacení"}]
[]
[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,"Poznámka schvalujících"]
[]
[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],[5,6,5,10],[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,1,3,3],[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],[0,8,0,13],[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]]}
[null,null,null,null,null,null,null,null,"Příloha OD  č. 2/2020",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:A460),\"dd.mm.rrrr\")","v":"Kurzy ČNB jsou aktualizovány k 17.05.2021"}]
[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,"2021-01-05","08:00:00",null,null,null,null,null,null,null,null,null,null,null,{"$f":"E7+F7","v":"2021-01-05T08: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,"2021-01-05","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":"2021-01-05T08: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,"2021-01-10","08:00:00",{"$f":"IF(OR(E7>MAX('Kurzy CNB'!A2:A460),E16>MAX('Kurzy CNB'!A2:A460)),\"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":"2021-01-10T08: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,"2021-01-10","08:00:00",null,null,null,null,null,null,{"$f":"IF(AND(E16<>\"\",E14<>\"NE\",OR(F16<>\"\",F17<>\"\")),E16,E7)","v":"2021-01-05"},null,null,null,null,{"$f":"E10+F10","v":"2021-01-10T08: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$156,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$156,VLOOKUP(H16,List1!$S$4:$T$36,2,FALSE),TRUE))","v":{"$error":"#N/A"}},{"$f":"CEILING(I16*F16,0.001)","v":{"$error":"#N/A"}},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.4000000000000004,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$156,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ů",27.8,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ů",31.5]
[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",27.2]
[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",5]
[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":2.78},{"$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$156,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$156,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":225},"CZK",{"$f":"IF(L23<>\"\",VLOOKUP($M$10,'Kurzy CNB'!$A$1:$AH$156,VLOOKUP(K23,List1!$S$4:$T$36,2,FALSE),TRUE))*L23/VLOOKUP(K23,List1!$S$3:$U$36,3,FALSE)","v":5900.625},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$156,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$156,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$156,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$156,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":"2021-01-05"},null,null,null,{"$f":"IF(K27<>\"\",IF(K28<>\"\",K27+1-R7,R10-R7),\"\")","v":0.66666666666424135},{"$f":"IF(OR($E$8>K27,$E$9<K27),\"\",IF(K27=$E$8,$R$8,K27))","v":"2021-01-05T08:00:00"},{"$f":"IF(OR($E$8>K27,$E$9<K27),\"\",IF(K27=$E$9,$R$9,K27+1))","v":"2021-01-06"},{"$f":" IF(P27=\"\",\"\",Q27-P27)","v":0.66666666666424135},{"$f":"IF(O27<>\"\",IF(R27<>\"\",O27-R27,O27),\"\")","v":0},{"$f":"IF(S27<5/24,R27,IF(R27<=(5/24+0.0000001),\"\",R27))","v":0.66666666666424135},{"$f":"IF(S27>=5/24,IF(R27<=(5/24+0.0000001),S27+R27,S27),S27)","v":0},{"$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":3},{"$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":30},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$156,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":"2021-01-06"},null,null,null,{"$f":"IF(K28<>\"\",IF(K29<>\"\",1,$R$10-K28),\"\")","v":1},{"$f":"IF(OR($E$8>K28,$E$9<K28),\"\",IF(K28=$E$8,$R$8,K28))","v":"2021-01-06"},{"$f":"IF(OR($E$8>K28,$E$9<K28),\"\",IF(K28=$E$9,$R$9,K28+1))","v":"2021-01-07"},{"$f":" IF(P28=\"\",\"\",Q28-P28)","v":1},0,{"$f":"IF(S28<5/24,R28,IF(R28<=(5/24+0.0000001),\"\",R28))","v":1},{"$f":"IF(S28>=5/24,IF(R28<=(5/24+0.0000001),S28+R28,S28),S28)","v":0},0,{"$f":"IF(T28<>\"\",(IF(T28<(1/24-0.0000001),1,(IF(T28<=12/24,2,IF(T28<=18/24,3,4))))),\"\")","v":4},{"$f":"IF(U28<>\"\",(IF(U28<5/24,1,(IF(U28<=12/24,2,IF(U28<=18/24,3,4))))),\"\")","v":1},null,0,{"$f":"IF(W28=\"\",\"\",IF(X28=1,VLOOKUP(V28,$AN$26:$AR$30,W28+1,FALSE),VLOOKUP(V28,$AN$26:$AR$30,3,FALSE)))","v":45},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":5900.625},null,{"$f":"IF(($E$7+List1!A3)<=$E$10,$E$7+List1!A3,\"\")","v":"2021-01-07"},null,null,null,1,"2021-01-07",{"$f":"IF(OR($E$8>K29,$E$9<K29),\"\",IF(K29=$E$9,$R$9,K29+1))","v":"2021-01-08"},1,0,{"$f":"IF(S29<5/24,R29,IF(R29<=(5/24+0.0000001),\"\",R29))","v":1},0,0,4,1,null,0,45,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":"2021-01-08"},null,null,null,1,"2021-01-08","2021-01-09",1,0,1,0,0,4,1,null,0,45,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$156,VLOOKUP(H31,List1!$S$4:$T$36,2,FALSE),TRUE))/VLOOKUP(H31,List1!$S$3:$U$36,3,FALSE))","v":5900.625},null,{"$f":"IF(($E$7+List1!A5)<=$E$10,$E$7+List1!A5,\"\")","v":"2021-01-09"},null,null,null,1,"2021-01-09","2021-01-10",1,0,1,0,0,4,1,null,0,45,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":"2021-01-10"},null,null,null,0.33333333333575865,"2021-01-10","2021-01-10T08:00:00",0.33333333333575865,0,0.33333333333575865,0,0,2,1,null,0,15,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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","",{"$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,"","","","","",{"$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,"","","","","",{"$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ěstnance",null,null,null,null,null,null,null,null,{"$f":"IF(($E$7+List1!A21)<=$E$10,$E$7+List1!A21,\"\")","v":""},null,null,null,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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,"","","","","","","",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":95,"n_cols":34,"rows_kept":95,"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"]
["2021-01-04",16.411000000000001,13.365,4.1340000000000003,16.734999999999999,24.181000000000001,3.2890000000000001,3.5139999999999998,26.14,28.99,2.742,3.46,7.2359999999999998,1.53,6.63,29.111999999999998,16.724,20.646000000000001,1.962,1.0760000000000001,5.306,2.5030000000000001,15.319000000000001,44.262,5.7480000000000002,5.367,28.927,2.5910000000000002,16.138000000000002,71.162000000000006,2.8860000000000001,21.259,30.619,1.4590000000000001]
["2021-01-05",16.463000000000001,13.407999999999999,4.0019999999999998,16.759,24.273,3.306,3.5249999999999999,26.225000000000001,29.03,2.7559999999999998,3.4689999999999999,7.2789999999999999,1.536,6.6769999999999996,29.181000000000001,16.8,20.77,1.9630000000000001,1.0660000000000001,5.32,2.5049999999999999,15.391999999999999,44.429000000000002,5.7670000000000003,5.3819999999999997,28.611000000000001,2.6080000000000001,16.206,71.292000000000002,2.891,21.369,30.959,1.4239999999999999]
["2021-01-06",16.516999999999999,13.369,4.0149999999999997,16.710999999999999,24.164000000000001,3.2829999999999999,3.5139999999999998,26.145,28.849,2.7330000000000001,3.4590000000000001,7.3040000000000003,1.5249999999999999,6.6550000000000002,28.984000000000002,16.727,20.585999999999999,1.952,1.073,5.2839999999999998,2.5190000000000001,15.451000000000001,44.091999999999999,5.7889999999999997,5.3659999999999997,28.779,2.597,16.093,70.847999999999999,2.8879999999999999,21.190999999999999,30.683,1.4119999999999999]
["2021-01-07",16.509,13.367000000000001,4.0129999999999999,16.757999999999999,24.138000000000002,3.294,3.5150000000000001,26.145,28.992000000000001,2.7469999999999999,3.4550000000000001,7.3079999999999998,1.5309999999999999,6.6959999999999997,29.036000000000001,16.835000000000001,20.565999999999999,1.948,1.0780000000000001,5.2750000000000004,2.528,15.465,44.284999999999997,5.8049999999999997,5.367,28.67,2.5990000000000002,16.088000000000001,70.938999999999993,2.9060000000000001,21.298999999999999,30.899000000000001,1.391]
["2021-01-08",16.606999999999999,13.378,3.9809999999999999,16.835000000000001,24.167000000000002,3.3050000000000002,3.5179999999999998,26.164999999999999,29.039000000000001,2.7549999999999999,3.456,7.2759999999999998,1.5229999999999999,6.7119999999999997,29.135999999999999,16.826000000000001,20.559000000000001,1.956,1.069,5.2969999999999997,2.5430000000000001,15.505000000000001,44.378999999999998,5.8,5.3719999999999999,28.815999999999999,2.6030000000000002,16.126000000000001,71.016999999999996,2.907,21.359000000000002,30.87,1.3979999999999999]
["2021-01-11",16.622,13.417,3.9420000000000002,16.872,24.210999999999999,3.33,3.528,26.24,29.077000000000002,2.782,3.4620000000000002,7.274,1.5269999999999999,6.7839999999999998,29.364999999999998,16.702999999999999,20.7,1.964,1.07,5.3239999999999998,2.5299999999999998,15.507,44.866,5.7939999999999996,5.3879999999999999,28.895,2.6040000000000001,16.218,71.587999999999994,2.8980000000000001,21.574000000000002,31.178000000000001,1.395]
["2021-01-12",16.635999999999999,13.391,3.9329999999999998,16.89,24.222999999999999,3.3330000000000002,3.5209999999999999,26.19,29.285,2.7770000000000001,3.4540000000000002,7.282,1.524,6.8129999999999997,29.396999999999998,16.766999999999999,20.664000000000001,1.96,1.0780000000000001,5.3070000000000004,2.524,15.46,44.817999999999998,5.7880000000000003,5.3760000000000003,29.077999999999999,2.5960000000000001,16.221,71.477000000000004,2.8769999999999998,21.535,31.015999999999998,1.3979999999999999]
["2021-01-13",16.635999999999999,13.384,4.0350000000000001,16.898,24.207999999999998,3.3260000000000001,3.5179999999999998,26.175000000000001,29.414000000000001,2.7749999999999999,3.4529999999999998,7.266,1.53,6.851,29.407,16.779,20.702000000000002,1.96,1.0840000000000001,5.32,2.532,15.439,44.765000000000001,5.7830000000000004,5.3719999999999999,29.151,2.5819999999999999,16.218,71.620999999999995,2.891,21.515000000000001,31.001000000000001,1.405]
["2021-01-14",16.744,13.39,4.0999999999999996,17.032,24.24,3.3410000000000002,3.52,26.19,29.448,2.786,3.4609999999999999,7.2830000000000004,1.5369999999999999,6.875,29.54,16.724,20.754000000000001,1.9690000000000001,1.089,5.3529999999999998,2.54,15.541,44.978999999999999,5.7720000000000002,5.3739999999999997,29.398,2.5920000000000001,16.277999999999999,71.951999999999998,2.927,21.603999999999999,31.155999999999999,1.4219999999999999]
["2021-01-15",16.683,13.374000000000001,4.1059999999999999,16.968,24.289000000000001,3.3330000000000002,3.516,26.16,29.391999999999999,2.7829999999999999,3.4630000000000001,7.2670000000000003,1.5389999999999999,6.6139999999999999,29.510999999999999,16.725999999999999,20.802,1.962,1.089,5.3449999999999998,2.5369999999999999,15.481999999999999,44.924999999999997,5.7649999999999997,5.3680000000000003,29.38,2.5819999999999999,16.242000000000001,71.84,2.899,21.577000000000002,31.108000000000001,1.417]
["2021-01-18",16.657,13.387,4.0970000000000004,16.988,24.364000000000001,3.3420000000000001,3.52,26.184999999999999,29.396999999999998,2.8,3.468,7.2649999999999997,1.5429999999999999,6.7110000000000003,29.611000000000001,16.7,20.917999999999999,1.9610000000000001,1.0920000000000001,5.3570000000000002,2.5209999999999999,15.423999999999999,45.155999999999999,5.77,5.3719999999999999,29.224,2.5790000000000002,16.286999999999999,72.012,2.8919999999999999,21.706,31.265000000000001,1.4159999999999999]
["2021-01-19",16.638000000000002,13.375,4.0960000000000001,16.939,24.29,3.3290000000000002,3.516,26.16,29.36,2.7810000000000001,3.4580000000000002,7.2969999999999997,1.5329999999999999,6.6440000000000001,29.474,16.661999999999999,20.736000000000001,1.956,1.1000000000000001,5.3239999999999998,2.5299999999999998,15.371,44.908000000000001,5.7679999999999998,5.367,29.248999999999999,2.5910000000000002,16.233000000000001,71.813000000000002,2.8969999999999998,21.562000000000001,31.058,1.444]
["2021-01-20",16.678000000000001,13.359,4.0579999999999998,16.992999999999999,24.234000000000002,3.3380000000000001,3.512,26.125,29.507999999999999,2.786,3.4540000000000002,7.31,1.5389999999999999,6.6360000000000001,29.571000000000002,16.619,20.798999999999999,1.9590000000000001,1.099,5.3390000000000004,2.5310000000000001,15.398999999999999,44.959000000000003,5.7640000000000002,5.36,29.321999999999999,2.577,16.276,72.006,2.9,21.594000000000001,31.094000000000001,1.4430000000000001]
["2021-01-21",16.689,13.343,4.07,17.001999999999999,24.225000000000001,3.3220000000000001,3.508,26.094999999999999,29.446999999999999,2.7690000000000001,3.45,7.3010000000000002,1.5329999999999999,6.56,29.408000000000001,16.641999999999999,20.756,1.9510000000000001,1.0940000000000001,5.3250000000000002,2.5449999999999999,15.481999999999999,44.673000000000002,5.7619999999999996,5.3540000000000001,29.11,2.5880000000000001,16.228000000000002,71.703000000000003,2.9140000000000001,21.460999999999999,30.911000000000001,1.4510000000000001]
["2021-01-22",16.584,13.37,3.9769999999999999,16.922999999999998,24.273,3.319,3.5150000000000001,26.15,29.367000000000001,2.7749999999999999,3.4569999999999999,7.3129999999999997,1.5329999999999999,6.5549999999999997,29.457999999999998,16.655999999999999,20.722999999999999,1.9450000000000001,1.079,5.32,2.5310000000000001,15.433,44.746000000000002,5.76,5.3650000000000002,28.704999999999998,2.5939999999999999,16.193000000000001,71.676000000000002,2.899,21.509,31.027999999999999,1.423]
["2021-01-25",16.584,13.337,3.9260000000000002,16.87,24.213000000000001,3.3159999999999998,3.5049999999999999,26.08,29.373999999999999,2.7690000000000001,3.4470000000000001,7.2990000000000004,1.5309999999999999,6.5679999999999996,29.43,16.611000000000001,20.690999999999999,1.946,1.0740000000000001,5.3070000000000004,2.5209999999999999,15.475,44.640999999999998,5.7439999999999998,5.35,28.454000000000001,2.5920000000000001,16.178999999999998,71.591999999999999,2.9020000000000001,21.463000000000001,30.96,1.411]
["2021-01-26",16.599,13.334,3.9649999999999999,16.888999999999999,24.172000000000001,3.3210000000000002,3.5059999999999998,26.08,29.405000000000001,2.7709999999999999,3.448,7.2720000000000002,1.5269999999999999,6.57,29.452999999999999,16.611000000000001,20.71,1.9470000000000001,1.0720000000000001,5.3049999999999997,2.5099999999999998,15.529,44.677999999999997,5.7359999999999998,5.3490000000000002,28.574999999999999,2.589,16.199000000000002,71.652000000000001,2.9220000000000002,21.478999999999999,30.968,1.417]
["2021-01-27",16.527999999999999,13.308,4.0039999999999996,16.841000000000001,24.193000000000001,3.32,3.4990000000000001,26.024999999999999,29.442,2.7709999999999999,3.4430000000000001,7.2110000000000003,1.5289999999999999,6.58,29.428999999999998,16.576000000000001,20.677,1.9410000000000001,1.0640000000000001,5.3109999999999999,2.4889999999999999,15.449,44.664999999999999,5.7169999999999996,5.3380000000000001,28.373000000000001,2.573,16.177,71.605000000000004,2.907,21.484000000000002,30.962,1.411]
["2021-01-28",16.41,13.352,3.9649999999999999,16.783999999999999,24.22,3.3410000000000002,3.512,26.114999999999998,29.474,2.786,3.4510000000000001,7.2469999999999999,1.5349999999999999,6.5579999999999998,29.568000000000001,16.739999999999998,20.692,1.9339999999999999,1.056,5.3390000000000004,2.4820000000000002,15.355,44.93,5.7430000000000003,5.3559999999999999,28.268000000000001,2.577,16.204000000000001,71.915000000000006,2.9239999999999999,21.6,31.114000000000001,1.417]
["2021-01-29",16.449000000000002,13.305,3.9079999999999999,16.766999999999999,24.094999999999999,3.335,3.4990000000000001,26.02,29.44,2.766,3.4380000000000002,7.26,1.528,6.5359999999999996,29.427,16.669,20.481000000000002,1.921,1.06,5.3040000000000003,2.5150000000000001,15.430999999999999,44.61,5.7430000000000003,5.3369999999999997,28.341000000000001,2.5720000000000001,16.140999999999998,71.703000000000003,2.931,21.442,30.847999999999999,1.4219999999999999]
["2021-02-01",16.405999999999999,13.279,3.948,16.783000000000001,24.007999999999999,3.3239999999999998,3.492,25.97,29.442,2.7719999999999998,3.4279999999999999,7.2880000000000003,1.5329999999999999,6.5350000000000001,29.395,16.614999999999998,20.486000000000001,1.9219999999999999,1.0589999999999999,5.3159999999999998,2.5,15.417,44.707999999999998,5.7610000000000001,5.3289999999999997,28.347000000000001,2.5550000000000002,16.138000000000002,71.682000000000002,2.9889999999999999,21.489000000000001,30.962,1.43]
["2021-02-02",16.344999999999999,13.243,3.9889999999999999,16.792999999999999,23.962,3.3319999999999999,3.4820000000000002,25.9,29.401,2.774,3.4159999999999999,7.2830000000000004,1.5329999999999999,6.5190000000000001,29.465,16.591999999999999,20.481000000000002,1.927,1.0629999999999999,5.3170000000000002,2.5030000000000001,15.422000000000001,44.887,5.7619999999999996,5.3140000000000001,28.48,2.5489999999999999,16.146000000000001,71.709000000000003,2.9910000000000001,21.506,30.931999999999999,1.4379999999999999]
["2021-02-03",16.431000000000001,13.254,4.0359999999999996,16.866,24.001000000000001,3.3410000000000002,3.4849999999999999,25.925000000000001,29.41,2.7839999999999998,3.4239999999999999,7.2910000000000004,1.5409999999999999,6.532,29.597999999999999,16.608000000000001,20.541,1.9339999999999999,1.071,5.327,2.504,15.532999999999999,44.924999999999997,5.7720000000000002,5.32,28.436,2.5590000000000002,16.186,71.819999999999993,3.01,21.579000000000001,30.984999999999999,1.4450000000000001]
["2021-02-04",16.465,13.24,4.0279999999999996,16.86,23.934999999999999,3.34,3.4820000000000002,25.895,29.532,2.7839999999999998,3.42,7.282,1.54,6.548,29.617999999999999,16.588999999999999,20.513000000000002,1.931,1.0660000000000001,5.319,2.5049999999999999,15.536,44.905000000000001,5.7619999999999996,5.3109999999999999,28.571999999999999,2.5550000000000002,16.16,71.825999999999993,3.0289999999999999,21.587,30.977,1.4370000000000001]
["2021-02-05",16.372,13.194000000000001,3.956,16.817,23.835999999999999,3.3279999999999998,3.47,25.805,29.48,2.778,3.4129999999999998,7.2370000000000001,1.5349999999999999,6.54,29.533999999999999,16.658999999999999,20.361999999999998,1.9179999999999999,1.06,5.29,2.504,15.384,44.767000000000003,5.7320000000000002,5.2939999999999996,28.788,2.5499999999999998,16.096,71.531000000000006,3.0449999999999999,21.533999999999999,30.863,1.4379999999999999]
["2021-02-08",16.399999999999999,13.156000000000001,3.9630000000000001,16.751000000000001,23.736000000000001,3.3180000000000001,3.46,25.734999999999999,29.3,2.7610000000000001,3.4039999999999999,7.1829999999999998,1.5289999999999999,6.5179999999999998,29.335000000000001,16.635000000000002,20.27,1.909,1.0589999999999999,5.2640000000000002,2.5049999999999999,15.374000000000001,44.491,5.7409999999999997,5.2789999999999999,28.785,2.544,16.016999999999999,71.287999999999997,3.0169999999999999,21.401,30.672999999999998,1.4319999999999999]
["2021-02-09",16.413,13.159000000000001,3.9279999999999999,16.702000000000002,23.798999999999999,3.3039999999999998,3.4609999999999999,25.74,29.308,2.7429999999999999,3.4009999999999998,7.1719999999999997,1.5189999999999999,6.5330000000000004,29.158000000000001,16.702999999999999,20.335999999999999,1.91,1.0580000000000001,5.2530000000000001,2.5089999999999999,15.372999999999999,44.265999999999998,5.7510000000000003,5.28,28.725999999999999,2.5470000000000002,16.012,71.021000000000001,2.9980000000000002,21.263000000000002,30.527999999999999,1.4379999999999999]
["2021-02-10",16.471,13.208,3.9380000000000002,16.780999999999999,23.907,3.3039999999999998,3.4729999999999999,25.83,29.472999999999999,2.7480000000000002,3.415,7.2249999999999996,1.5229999999999999,6.5490000000000004,29.248999999999999,16.643000000000001,20.334,1.927,1.06,5.2670000000000003,2.5249999999999999,15.372,44.332999999999998,5.7629999999999999,5.2969999999999997,28.863,2.5630000000000002,16.062999999999999,71.23,3.0209999999999999,21.300999999999998,30.696999999999999,1.4490000000000001]
["2021-02-11",16.477,13.176,3.9710000000000001,16.756,23.856000000000002,3.2879999999999998,3.4649999999999999,25.77,29.367999999999999,2.7370000000000001,3.4049999999999998,7.2149999999999999,1.5189999999999999,6.5209999999999999,29.155000000000001,16.54,20.273,1.9239999999999999,1.0649999999999999,5.2489999999999997,2.512,15.367000000000001,44.177,5.7309999999999999,5.2859999999999996,28.847000000000001,2.5550000000000002,16.029,71.066999999999993,3.0230000000000001,21.219000000000001,30.600999999999999,1.452]
["2021-02-12",16.439,13.167999999999999,3.9430000000000001,16.704000000000001,23.841000000000001,3.2959999999999998,3.464,25.754999999999999,29.350999999999999,2.7440000000000002,3.4020000000000001,7.1769999999999996,1.522,6.54,29.308,16.530999999999999,20.254999999999999,1.925,1.0620000000000001,5.2619999999999996,2.504,15.292999999999999,44.267000000000003,5.7229999999999999,5.2839999999999998,28.678000000000001,2.5550000000000002,16.03,71.126000000000005,3.03,21.271000000000001,30.681000000000001,1.452]
["2021-02-15",16.456,13.13,3.9420000000000002,16.731000000000002,23.771999999999998,3.28,3.4529999999999998,25.68,29.442,2.73,3.391,7.17,1.5209999999999999,6.5259999999999998,29.152999999999999,16.504000000000001,20.100999999999999,1.92,1.0620000000000001,5.2469999999999999,2.5179999999999998,15.294,44.164000000000001,5.7249999999999996,5.2670000000000003,28.864000000000001,2.5569999999999999,16.001000000000001,70.825000000000003,3.0419999999999998,21.167999999999999,30.498000000000001,1.4670000000000001]
["2021-02-16",16.497,13.17,3.95,16.760999999999999,23.849,3.286,3.4630000000000001,25.754999999999999,29.492999999999999,2.7360000000000002,3.4009999999999998,7.1840000000000002,1.5229999999999999,6.5529999999999999,29.126999999999999,16.552,20.096,1.92,1.056,5.2629999999999999,2.5270000000000001,15.353999999999999,43.944000000000003,5.73,5.282,28.821999999999999,2.5649999999999999,16.012,70.882999999999996,3.0409999999999999,21.209,30.556999999999999,1.4590000000000001]
["2021-02-17",16.623999999999999,13.234999999999999,3.9980000000000002,16.91,23.952999999999999,3.3260000000000001,3.4809999999999999,25.885000000000002,29.768000000000001,2.7690000000000001,3.419,7.2089999999999996,1.5309999999999999,6.5910000000000002,29.484000000000002,16.614000000000001,20.231999999999999,1.9390000000000001,1.0580000000000001,5.3140000000000001,2.5350000000000001,15.423,44.302,5.7510000000000003,5.31,29.071000000000002,2.5779999999999998,16.149999999999999,71.575000000000003,3.07,21.465,31,1.452]
["2021-02-18",16.664999999999999,13.222,3.9630000000000001,16.896999999999998,23.879000000000001,3.3079999999999998,3.4780000000000002,25.86,29.882999999999999,2.76,3.4140000000000001,7.2089999999999996,1.526,6.5629999999999997,29.497,16.597999999999999,20.254999999999999,1.9339999999999999,1.06,5.2939999999999996,2.5310000000000001,15.452999999999999,44.118000000000002,5.7610000000000001,5.3049999999999997,29.065000000000001,2.5779999999999998,16.132999999999999,71.334000000000003,3.08,21.4,30.779,1.4730000000000001]
["2021-02-19",16.733000000000001,13.215,3.9369999999999998,16.885999999999999,23.818000000000001,3.3,3.4750000000000001,25.844999999999999,29.876999999999999,2.746,3.41,7.2089999999999996,1.514,6.51,29.363,16.61,20.22,1.93,1.046,5.2690000000000001,2.5310000000000001,15.532,43.92,5.7649999999999997,5.3010000000000002,28.844000000000001,2.5760000000000001,16.093,71.028999999999996,3.06,21.291,30.648,1.4570000000000001]
["2021-02-22",16.864000000000001,13.272,3.8860000000000001,16.939,23.841000000000001,3.31,3.49,25.954999999999998,29.997,2.7589999999999999,3.4279999999999999,7.2279999999999998,1.516,6.54,29.504000000000001,16.681000000000001,20.279,1.9219999999999999,1.0289999999999999,5.2919999999999998,2.5150000000000001,15.651999999999999,43.911999999999999,5.77,5.3230000000000004,28.532,2.5870000000000002,16.163,71.265000000000001,3.0289999999999999,21.393999999999998,30.87,1.4359999999999999]
["2021-02-23",16.844999999999999,13.244,3.9209999999999998,16.914000000000001,23.664999999999999,3.3010000000000002,3.484,25.905000000000001,30.015000000000001,2.7509999999999999,3.419,7.2130000000000001,1.514,6.5339999999999998,29.42,16.690999999999999,20.242000000000001,1.917,1.03,5.2759999999999998,2.5099999999999998,15.621,43.893000000000001,5.7480000000000002,5.3129999999999997,28.81,2.5710000000000002,16.143000000000001,71.057000000000002,3.0249999999999999,21.334,30.774000000000001,1.4510000000000001]
["2021-02-24",16.928999999999998,13.281000000000001,3.9590000000000001,17.015000000000001,23.552,3.3149999999999999,3.4929999999999999,25.975000000000001,30.190999999999999,2.758,3.427,7.2210000000000001,1.518,6.5449999999999999,29.559000000000001,16.800999999999998,20.184999999999999,1.93,1.0489999999999999,5.29,2.5350000000000001,15.79,43.973999999999997,5.75,5.3280000000000003,29.027000000000001,2.5739999999999998,16.184999999999999,71.241,2.9830000000000001,21.387,30.881,1.478]
["2021-02-25",17.041,13.347,3.919,17.109000000000002,23.564,3.3090000000000002,3.5110000000000001,26.11,30.21,2.754,3.44,7.2489999999999997,1.516,6.5110000000000001,29.398,17.032,20.120999999999999,1.921,1.03,5.2859999999999996,2.5529999999999999,15.907,43.875999999999998,5.7869999999999999,5.3559999999999999,28.9,2.5939999999999999,16.193000000000001,70.816000000000003,2.9550000000000001,21.352,30.847000000000001,1.4419999999999999]
["2021-02-26",16.783999999999999,13.391,3.9289999999999998,17.087,23.841000000000001,3.3450000000000002,3.5230000000000001,26.195,30.091000000000001,2.7869999999999999,3.456,7.2480000000000002,1.516,6.5369999999999999,29.244,17.132000000000001,20.331,1.9159999999999999,1.036,5.3360000000000003,2.5179999999999998,15.755000000000001,44.332000000000001,5.7969999999999997,5.3730000000000002,28.888999999999999,2.5830000000000002,16.265000000000001,71.183999999999997,2.9049999999999998,21.611999999999998,31.265000000000001,1.4470000000000001]
["2021-03-01",16.75,13.334,3.8759999999999999,17.074999999999999,23.678000000000001,3.3460000000000001,3.5070000000000001,26.08,30.132000000000001,2.79,3.4420000000000002,7.1879999999999997,1.518,6.5490000000000004,29.416,16.946000000000002,20.277000000000001,1.9279999999999999,1.042,5.335,2.5179999999999998,15.685,44.564999999999998,5.7619999999999996,5.35,29.2,2.5619999999999998,16.259,71.593000000000004,2.9910000000000001,21.64,31.146000000000001,1.4370000000000001]
["2021-03-02",16.95,13.364000000000001,3.8250000000000002,17.167999999999999,23.655999999999999,3.359,3.5150000000000001,26.14,30.239000000000001,2.802,3.4470000000000001,7.1870000000000003,1.5169999999999999,6.585,29.617000000000001,17.186,20.329000000000001,1.93,1.0509999999999999,5.3550000000000004,2.548,15.778,44.808,5.7690000000000001,5.3609999999999998,29.475000000000001,2.5779999999999998,16.32,71.802999999999997,2.9660000000000002,21.733000000000001,31.222999999999999,1.4419999999999999]
["2021-03-03",16.914999999999999,13.367000000000001,3.7970000000000002,17.158999999999999,23.63,3.3540000000000001,3.5150000000000001,26.14,30.263999999999999,2.7959999999999998,3.448,7.1870000000000003,1.522,6.5919999999999996,29.774000000000001,17.140999999999998,20.297000000000001,1.9390000000000001,1.046,5.3540000000000001,2.552,15.766999999999999,44.725999999999999,5.766,5.3579999999999997,29.411000000000001,2.581,16.29,71.504999999999995,2.9369999999999998,21.687999999999999,31.138999999999999,1.4510000000000001]
["2021-03-04",16.963999999999999,13.397,3.8839999999999999,17.225999999999999,23.576000000000001,3.3660000000000001,3.524,26.204999999999998,30.373999999999999,2.8069999999999999,3.4540000000000002,7.1879999999999997,1.526,6.58,29.928000000000001,17.094000000000001,20.277000000000001,1.9350000000000001,1.0449999999999999,5.3659999999999997,2.5550000000000002,15.789,44.869,5.7560000000000002,5.3689999999999998,29.567,2.58,16.352,71.769000000000005,2.9260000000000002,21.774000000000001,31.294,1.4490000000000001]
["2021-03-05",16.901,13.45,3.8719999999999999,17.349,23.774999999999999,3.395,3.5369999999999999,26.305,30.477,2.8380000000000001,3.4729999999999999,7.1820000000000004,1.5409999999999999,6.641,30.155999999999999,17.204000000000001,20.344000000000001,1.9530000000000001,1.038,5.4080000000000004,2.5760000000000001,15.718999999999999,45.313000000000002,5.75,5.3890000000000002,29.591000000000001,2.5819999999999999,16.433,72.23,2.9380000000000002,22.033999999999999,31.635999999999999,1.4410000000000001]
["2021-03-08",17.045999999999999,13.507,3.8730000000000002,17.574999999999999,23.829000000000001,3.4119999999999999,3.5529999999999999,26.42,30.817,2.8660000000000001,3.4860000000000002,7.1959999999999997,1.55,6.6689999999999996,30.349,17.302,20.495999999999999,1.9550000000000001,1.0329999999999999,5.42,2.5960000000000001,15.849,45.704999999999998,5.7430000000000003,5.4080000000000004,29.768999999999998,2.5950000000000002,16.515999999999998,72.356999999999999,2.9009999999999998,22.263999999999999,31.812999999999999,1.4390000000000001]
["2021-03-09",17.010000000000002,13.435,3.7690000000000001,17.515999999999998,23.731999999999999,3.3940000000000001,3.5350000000000001,26.285,30.667000000000002,2.8479999999999999,3.4620000000000002,7.157,1.5349999999999999,6.641,30.265999999999998,17.327000000000002,20.292000000000002,1.9419999999999999,1.0349999999999999,5.3689999999999998,2.605,15.815,45.555,5.73,5.3789999999999996,29.876999999999999,2.5920000000000001,16.416,71.861000000000004,2.8849999999999998,22.109000000000002,31.513999999999999,1.4330000000000001]
["2021-03-10",16.995000000000001,13.407,3.8119999999999998,17.440000000000001,23.690999999999999,3.387,3.5259999999999998,26.225000000000001,30.623000000000001,2.8410000000000002,3.456,7.1360000000000001,1.5309999999999999,6.6340000000000003,30.21,17.242000000000001,20.311,1.9319999999999999,1.04,5.3440000000000003,2.6019999999999999,15.805999999999999,45.384,5.7320000000000002,5.367,29.81,2.589,16.37,71.665999999999997,2.9049999999999998,22.050999999999998,31.478000000000002,1.4430000000000001]
["2021-03-11",17.018000000000001,13.38,3.907,17.396000000000001,23.658000000000001,3.3730000000000002,3.5190000000000001,26.17,30.559000000000001,2.819,3.45,7.1529999999999996,1.518,6.6219999999999999,30.132000000000001,17.071000000000002,20.167000000000002,1.9350000000000001,1.056,5.3250000000000002,2.5939999999999999,15.824999999999999,45.164000000000001,5.7190000000000003,5.3570000000000002,29.745999999999999,2.5840000000000001,16.331,71.602999999999994,2.94,21.873999999999999,31.212,1.47]
["2021-03-12",16.986999999999998,13.37,3.9390000000000001,17.459,23.567,3.3679999999999999,3.516,26.15,30.466999999999999,2.8220000000000001,3.4460000000000002,7.1420000000000003,1.5229999999999999,6.5970000000000004,30.15,16.992000000000001,20.093,1.93,1.0529999999999999,5.3209999999999997,2.593,15.722,45.26,5.7009999999999996,5.3529999999999998,29.818000000000001,2.5790000000000002,16.29,71.185000000000002,2.891,21.911999999999999,31.37,1.466]
["2021-03-15",16.986000000000001,13.393000000000001,3.915,17.608000000000001,23.634,3.3820000000000001,3.5230000000000001,26.195,30.571999999999999,2.83,3.456,7.1260000000000003,1.5249999999999999,6.6440000000000001,30.283000000000001,17.065000000000001,20.123000000000001,1.9370000000000001,1.0620000000000001,5.343,2.593,15.789,45.264000000000003,5.7050000000000001,5.3630000000000004,30.045000000000002,2.5720000000000001,16.329999999999998,71.497,2.9129999999999998,21.974,31.388999999999999,1.4770000000000001]
["2021-03-16",17.027000000000001,13.398,3.93,17.623000000000001,23.75,3.3809999999999998,3.5230000000000001,26.2,30.491,2.8290000000000002,3.4580000000000002,7.1319999999999997,1.5249999999999999,6.6689999999999996,30.303000000000001,17.282,20.177,1.9450000000000001,1.0649999999999999,5.3410000000000002,2.593,15.811999999999999,45.183999999999997,5.7039999999999997,5.3609999999999998,30.225999999999999,2.5830000000000002,16.332000000000001,71.492999999999995,2.9329999999999998,21.972999999999999,31.388999999999999,1.48]
["2021-03-17",16.956,13.372,3.89,17.613,23.673999999999999,3.3780000000000001,3.5179999999999998,26.16,30.529,2.8279999999999998,3.4529999999999998,7.1139999999999999,1.522,6.68,30.263000000000002,17.279,20.117999999999999,1.9430000000000001,1.0589999999999999,5.33,2.585,15.742000000000001,45.110999999999997,5.67,5.3529999999999998,29.795999999999999,2.581,16.309999999999999,71.361000000000004,2.9239999999999999,21.966000000000001,31.398,1.476]
["2021-03-18",17.061,13.38,3.9529999999999998,17.648,23.637,3.3759999999999999,3.5190000000000001,26.17,30.577000000000002,2.8290000000000002,3.4550000000000001,7.1050000000000004,1.5249999999999999,6.657,30.215,17.263000000000002,20.119,1.9470000000000001,1.0669999999999999,5.343,2.59,15.798,45.121000000000002,5.657,5.3559999999999999,29.696999999999999,2.577,16.343,71.17,2.9830000000000001,21.969000000000001,31.353000000000002,1.4850000000000001]
["2021-03-19",17.007999999999999,13.36,3.9780000000000002,17.571000000000002,23.613,3.3759999999999999,3.5139999999999998,26.13,30.466999999999999,2.8290000000000002,3.4489999999999998,7.1,1.5249999999999999,6.6639999999999997,30.306999999999999,17.259,20.172000000000001,1.944,1.0820000000000001,5.35,2.5609999999999999,15.743,45.212000000000003,5.6559999999999997,5.351,29.672999999999998,2.5680000000000001,16.364000000000001,71.265000000000001,3.0270000000000001,21.975000000000001,31.376000000000001,1.4930000000000001]
["2021-03-22",16.931999999999999,13.332000000000001,3.9569999999999999,17.495999999999999,23.657,3.3610000000000002,3.5070000000000001,26.074999999999999,30.238,2.8149999999999999,3.4420000000000002,7.1070000000000002,1.518,6.617,30.218,17.245000000000001,20.096,1.9390000000000001,1.0580000000000001,5.3140000000000001,2.5710000000000002,15.691000000000001,45.076999999999998,5.6660000000000004,5.3369999999999997,29.324999999999999,2.5670000000000002,16.303999999999998,70.816000000000003,2.77,21.863,31.216000000000001,1.4850000000000001]
["2021-03-23",16.91,13.394,3.9980000000000002,17.53,23.672999999999998,3.3860000000000001,3.5230000000000001,26.195,30.388999999999999,2.8380000000000001,3.4569999999999999,7.1470000000000002,1.5309999999999999,6.7,30.423999999999999,17.664000000000001,20.306000000000001,1.9510000000000001,1.0649999999999999,5.3470000000000004,2.573,15.484,45.338999999999999,5.6710000000000003,5.3579999999999997,29.015999999999998,2.573,16.419,71.159000000000006,2.7970000000000002,22.045000000000002,31.445,1.49]
["2021-03-24",16.870999999999999,13.387,4.0149999999999997,17.611000000000001,23.677,3.3980000000000001,3.524,26.204999999999998,30.381,2.8530000000000002,3.46,7.18,1.536,6.734,30.521000000000001,17.457999999999998,20.378,1.958,1.069,5.3650000000000002,2.58,15.449,45.600999999999999,5.6619999999999999,5.3609999999999998,29.048999999999999,2.5779999999999998,16.463000000000001,71.48,2.7879999999999998,22.161999999999999,31.611000000000001,1.4950000000000001]
["2021-03-25",16.867999999999999,13.414,3.919,17.658999999999999,23.754999999999999,3.3980000000000001,3.528,26.234999999999999,30.48,2.8610000000000002,3.464,7.1920000000000002,1.5409999999999999,6.71,30.588000000000001,17.513000000000002,20.373999999999999,1.956,1.0640000000000001,5.3609999999999998,2.581,15.477,45.753,5.6539999999999999,5.3689999999999998,29.145,2.5739999999999998,16.5,71.393000000000001,2.782,22.227,31.64,1.4830000000000001]
["2021-03-26",16.873000000000001,13.337999999999999,3.887,17.606999999999999,23.521000000000001,3.3849999999999998,3.508,26.085000000000001,30.509,2.8490000000000002,3.4430000000000001,7.1749999999999998,1.536,6.6440000000000001,30.513000000000002,17.413,20.169,1.958,1.0760000000000001,5.3390000000000004,2.5760000000000001,15.468,45.655999999999999,5.61,5.3369999999999997,29.146000000000001,2.56,16.442,71.171999999999997,2.76,22.138999999999999,31.439,1.4750000000000001]
["2021-03-29",16.939,13.334,3.8370000000000002,17.588999999999999,23.547999999999998,3.3730000000000002,3.5070000000000001,26.08,30.638999999999999,2.8460000000000001,3.444,7.1980000000000004,1.532,6.6440000000000001,30.454000000000001,17.271999999999998,20.181999999999999,1.954,1.0660000000000001,5.3440000000000003,2.589,15.518000000000001,45.661999999999999,5.6139999999999999,5.319,29.155000000000001,2.552,16.443000000000001,71.013999999999996,2.7109999999999999,22.131,31.428000000000001,1.474]
["2021-03-30",16.942,13.356,3.8620000000000001,17.632999999999999,23.628,3.3860000000000001,3.5129999999999999,26.125,30.594000000000001,2.8620000000000001,3.4510000000000001,7.19,1.5369999999999999,6.6760000000000002,30.286000000000001,17.593,20.173999999999999,1.962,1.0780000000000001,5.36,2.5960000000000001,15.554,45.817999999999998,5.609,5.3090000000000002,29.295999999999999,2.5489999999999999,16.518000000000001,71.197000000000003,2.6640000000000001,22.248999999999999,31.597000000000001,1.49]
["2021-03-31",16.963999999999999,13.367000000000001,3.875,17.683,23.614999999999998,3.4049999999999998,3.5150000000000001,26.145,30.675999999999998,2.8679999999999999,3.4529999999999998,7.1970000000000001,1.5349999999999999,6.6719999999999997,30.463000000000001,17.654,20.132999999999999,1.974,1.087,5.3769999999999998,2.6150000000000002,15.593,45.938000000000002,5.6219999999999999,5.3120000000000003,29.602,2.5539999999999998,16.577999999999999,71.314999999999998,2.6880000000000002,22.295000000000002,31.588999999999999,1.5069999999999999]
["2021-04-01",16.829999999999998,13.336,3.9409999999999998,17.643000000000001,23.501999999999999,3.379,3.5070000000000001,26.085000000000001,30.617999999999999,2.855,3.4460000000000002,7.21,1.5289999999999999,6.6619999999999999,30.248999999999999,17.542000000000002,20.059999999999999,1.964,1.0920000000000001,5.3570000000000002,2.5979999999999999,15.52,45.703000000000003,5.6589999999999998,5.3140000000000001,29.114000000000001,2.5379999999999998,16.507000000000001,71.02,2.72,22.206,31.47,1.516]
["2021-04-06",16.827999999999999,13.319000000000001,3.91,17.555,23.535,3.367,3.5019999999999998,26.05,30.521000000000001,2.8359999999999999,3.4409999999999998,7.23,1.52,6.6790000000000003,30.045999999999999,17.425000000000001,19.998999999999999,1.9690000000000001,1.0880000000000001,5.3380000000000001,2.585,15.493,45.366,5.673,5.2969999999999997,28.782,2.5390000000000001,16.445,70.305000000000007,2.706,22.053999999999998,31.282,1.52]
["2021-04-07",16.622,13.250999999999999,3.8969999999999998,17.295000000000002,23.469000000000001,3.335,3.4849999999999999,25.914999999999999,30.103999999999999,2.802,3.42,7.2060000000000004,1.5049999999999999,6.6040000000000001,29.335999999999999,17.231000000000002,19.850999999999999,1.952,1.08,5.28,2.577,15.323,44.685000000000002,5.6630000000000003,5.2690000000000001,28.068000000000001,2.5310000000000001,16.283000000000001,69.528000000000006,2.6659999999999999,21.812999999999999,30.992000000000001,1.4990000000000001]
["2021-04-08",16.657,13.231,3.89,17.317,23.486999999999998,3.3290000000000002,3.4790000000000001,25.88,29.988,2.802,3.4119999999999999,7.2130000000000001,1.5,6.6390000000000002,29.207999999999998,17.138999999999999,19.951000000000001,1.9530000000000001,1.08,5.2679999999999998,2.5670000000000002,15.355,44.838000000000001,5.6829999999999998,5.2610000000000001,28.286999999999999,2.5350000000000001,16.260000000000002,69.304000000000002,2.6749999999999998,21.795999999999999,31.058,1.4990000000000001]
["2021-04-09",16.649000000000001,13.262,3.891,17.352,23.561,3.3290000000000002,3.488,25.94,29.93,2.8050000000000002,3.423,7.2450000000000001,1.498,6.6360000000000001,29.207999999999998,17.077000000000002,19.893000000000001,1.948,1.0840000000000001,5.2770000000000001,2.5649999999999999,15.384,44.908999999999999,5.7140000000000004,5.2729999999999997,28.263999999999999,2.5499999999999998,16.271999999999998,69.375,2.677,21.821000000000002,31.056000000000001,1.4990000000000001]
["2021-04-12",16.670000000000002,13.305999999999999,3.8580000000000001,17.428000000000001,23.658999999999999,3.34,3.5,26.024999999999999,30.081,2.8109999999999999,3.4390000000000001,7.3010000000000002,1.498,6.641,29.138999999999999,17.132999999999999,19.989999999999998,1.944,1.0860000000000001,5.2889999999999997,2.5779999999999998,15.388999999999999,44.923000000000002,5.7519999999999998,5.2880000000000003,28.300999999999998,2.552,16.302,69.39,2.6819999999999999,21.86,31.116,1.4970000000000001]
["2021-04-13",16.619,13.301,3.8180000000000001,17.332999999999998,23.649000000000001,3.3420000000000001,3.4980000000000002,26.015000000000001,30.006,2.8130000000000002,3.4369999999999998,7.2370000000000001,1.4970000000000001,6.62,28.995999999999999,17.126000000000001,19.978999999999999,1.946,1.083,5.2889999999999997,2.5579999999999998,15.352,44.970999999999997,5.6950000000000003,5.2850000000000001,28.323,2.548,16.28,69.227999999999994,2.6859999999999999,21.870999999999999,31.177,1.4930000000000001]
["2021-04-14",16.669,13.257999999999999,3.8039999999999998,17.254999999999999,23.503,3.319,3.4870000000000001,25.934999999999999,29.834,2.7909999999999999,3.4260000000000002,7.2329999999999997,1.484,6.5960000000000001,28.867000000000001,17.096,19.898,1.944,1.0780000000000001,5.25,2.5739999999999998,15.417999999999999,44.689,5.6950000000000003,5.2670000000000003,28.640999999999998,2.5569999999999999,16.210999999999999,69.122,2.6789999999999998,21.677,30.879000000000001,1.4990000000000001]
["2021-04-15",16.791,13.262,3.8380000000000001,17.341999999999999,23.484000000000002,3.32,3.488,25.94,29.899000000000001,2.7890000000000001,3.43,7.2279999999999998,1.4830000000000001,6.6029999999999998,28.882000000000001,17.077000000000002,19.93,1.9419999999999999,1.083,5.2539999999999996,2.5830000000000002,15.519,44.710999999999999,5.6929999999999996,5.2670000000000003,28.126999999999999,2.5609999999999999,16.238,69.396000000000001,2.6709999999999998,21.669,30.942,1.522]
["2021-04-16",16.77,13.256,3.8460000000000001,17.302,23.547000000000001,3.32,3.4860000000000002,25.925000000000001,29.873000000000001,2.7839999999999998,3.4260000000000002,7.18,1.4850000000000001,6.601,29.053000000000001,17.067,19.887,1.9419999999999999,1.085,5.242,2.5870000000000002,15.500999999999999,44.704999999999998,5.6970000000000001,5.2629999999999999,28.521000000000001,2.5659999999999998,16.227,69.293999999999997,2.6819999999999999,21.632999999999999,30.905000000000001,1.516]
["2021-04-19",16.719000000000001,13.241,3.863,17.221,23.547000000000001,3.3069999999999999,3.4830000000000001,25.9,29.992000000000001,2.7709999999999999,3.42,7.1890000000000001,1.4790000000000001,6.5970000000000004,28.754999999999999,17.073,19.91,1.931,1.0840000000000001,5.2190000000000003,2.597,15.462,44.481999999999999,5.6950000000000003,5.258,28.225000000000001,2.5649999999999999,16.172000000000001,68.929000000000002,2.665,21.52,30.774000000000001,1.5109999999999999]
["2021-04-20",16.721,13.244,3.8639999999999999,17.167000000000002,23.492000000000001,3.3090000000000002,3.4830000000000001,25.905000000000001,30.015000000000001,2.77,3.4209999999999998,7.17,1.4830000000000001,6.6150000000000002,28.613,17.053999999999998,19.831,1.929,1.081,5.2240000000000002,2.59,15.481,44.517000000000003,5.6920000000000002,5.2569999999999997,28.055,2.5579999999999998,16.186,68.777000000000001,2.649,21.5,30.838000000000001,1.5029999999999999]
["2021-04-21",16.651,13.237,3.8719999999999999,17.103999999999999,23.481999999999999,3.319,3.4809999999999999,25.89,30.018999999999998,2.778,3.4180000000000001,7.1459999999999999,1.484,6.6219999999999999,28.579000000000001,17.190999999999999,19.946999999999999,1.9259999999999999,1.0840000000000001,5.2329999999999997,2.5790000000000002,15.48,44.527000000000001,5.6820000000000004,5.2549999999999999,28.123000000000001,2.5510000000000002,16.210999999999999,68.745000000000005,2.6379999999999999,21.562999999999999,30.942,1.5109999999999999]
["2021-04-22",16.600999999999999,13.222,3.887,17.161000000000001,23.437000000000001,3.3079999999999998,3.4769999999999999,25.86,29.777000000000001,2.7669999999999999,3.415,7.1139999999999999,1.4790000000000001,6.5810000000000004,28.609000000000002,17.126000000000001,19.847999999999999,1.921,1.077,5.22,2.5739999999999998,15.404999999999999,44.359000000000002,5.6760000000000002,5.2489999999999997,28.315999999999999,2.5539999999999998,16.161999999999999,68.462999999999994,2.5979999999999999,21.469000000000001,30.773,1.5]
["2021-04-23",16.579999999999998,13.215999999999999,3.9460000000000002,17.161999999999999,23.417000000000002,3.3010000000000002,3.476,25.844999999999999,29.744,2.76,3.4129999999999998,7.1109999999999998,1.4750000000000001,6.5810000000000004,28.568000000000001,17.093,19.885000000000002,1.919,1.08,5.2130000000000001,2.573,15.387,44.323,5.665,5.2480000000000002,28.609000000000002,2.548,16.141999999999999,68.275999999999996,2.5710000000000002,21.420999999999999,30.739000000000001,1.502]
["2021-04-26",16.632000000000001,13.193,3.915,17.177,23.315000000000001,3.2930000000000001,3.47,25.805,29.669,2.7519999999999998,3.411,7.1029999999999998,1.474,6.5880000000000001,28.550999999999998,17.088999999999999,19.766999999999999,1.92,1.077,5.2110000000000003,2.5720000000000001,15.43,44.167999999999999,5.6630000000000003,5.2409999999999997,28.488,2.5470000000000002,16.100999999999999,67.923000000000002,2.57,21.353000000000002,30.646999999999998,1.4970000000000001]
["2021-04-27",16.672999999999998,13.239000000000001,3.94,17.277999999999999,23.46,3.3050000000000002,3.4820000000000002,25.895,29.805,2.76,3.4260000000000002,7.1379999999999999,1.4790000000000001,6.6109999999999998,28.725000000000001,17.263000000000002,19.786000000000001,1.9279999999999999,1.075,5.2290000000000001,2.5880000000000001,15.486000000000001,44.258000000000003,5.673,5.258,28.614999999999998,2.5539999999999998,16.163,68.295000000000002,2.6110000000000002,21.425000000000001,30.789000000000001,1.494]
["2021-04-28",16.667000000000002,13.273999999999999,3.9540000000000002,17.36,23.507999999999999,3.3170000000000002,3.4910000000000001,25.96,29.847000000000001,2.7709999999999999,3.4340000000000002,7.1760000000000002,1.4830000000000001,6.6120000000000001,28.882000000000001,17.446000000000002,19.75,1.93,1.0740000000000001,5.2430000000000003,2.6019999999999999,15.537000000000001,44.341999999999999,5.6609999999999996,5.266,28.838000000000001,2.5670000000000002,16.215,68.58,2.6320000000000001,21.509,30.891999999999999,1.4990000000000001]
["2021-04-29",16.594999999999999,13.198,3.9729999999999999,17.323,23.420999999999999,3.29,3.472,25.815000000000001,29.702000000000002,2.7410000000000001,3.4169999999999998,7.1630000000000003,1.4730000000000001,6.556,28.73,17.396000000000001,19.524999999999999,1.921,1.0649999999999999,5.1870000000000003,2.6040000000000001,15.454000000000001,44.015999999999998,5.6529999999999996,5.2430000000000003,28.664999999999999,2.5529999999999999,16.056999999999999,68.201999999999998,2.589,21.280999999999999,30.53,1.494]
["2021-04-30",16.614000000000001,13.234999999999999,4.01,17.449000000000002,23.536000000000001,3.3140000000000001,3.4809999999999999,25.885000000000002,29.797999999999998,2.76,3.43,7.1929999999999996,1.4830000000000001,6.6050000000000004,28.928999999999998,17.303000000000001,19.669,1.923,1.0680000000000001,5.2320000000000002,2.601,15.465,44.43,5.6719999999999997,5.2519999999999998,28.538,2.5459999999999998,16.135000000000002,68.768000000000001,2.5950000000000002,21.428000000000001,30.808,1.4890000000000001]
["2021-05-03",16.559000000000001,13.157,3.9390000000000001,17.413,23.41,3.3079999999999998,3.4670000000000001,25.785,29.693000000000001,2.7559999999999998,3.4169999999999998,7.1639999999999997,1.482,6.6029999999999998,28.975000000000001,17.076000000000001,19.55,1.907,1.056,5.2169999999999996,2.5750000000000002,15.364000000000001,44.396999999999998,5.6660000000000004,5.234,28.417000000000002,2.5329999999999999,16.071999999999999,68.647999999999996,2.577,21.41,30.744,1.482]
["2021-05-04",16.559999999999999,13.211,3.9289999999999998,17.417000000000002,23.54,3.3210000000000002,3.476,25.844999999999999,29.783000000000001,2.7679999999999998,3.427,7.1740000000000004,1.49,6.61,29.091000000000001,17.369,19.693999999999999,1.909,1.0589999999999999,5.2140000000000004,2.581,15.308999999999999,44.720999999999997,5.67,5.2450000000000001,28.638000000000002,2.5419999999999998,16.077999999999999,68.959999999999994,2.5819999999999999,21.498999999999999,30.824000000000002,1.482]
["2021-05-05",16.634,13.192,3.9630000000000001,17.509,23.527999999999999,3.319,3.47,25.8,29.908999999999999,2.766,3.4260000000000002,7.1740000000000004,1.4890000000000001,6.5789999999999997,29.084,17.109000000000002,19.664999999999999,1.911,1.0629999999999999,5.218,2.5840000000000001,15.462,44.703000000000003,5.6369999999999996,5.2359999999999998,28.73,2.5310000000000001,16.091999999999999,69.066000000000003,2.5750000000000002,21.486999999999998,30.765999999999998,1.492]
["2021-05-06",16.623999999999999,13.215,3.996,17.503,23.599,3.3130000000000002,3.4750000000000001,25.844999999999999,29.818999999999999,2.7589999999999999,3.431,7.2160000000000002,1.4970000000000001,6.5739999999999998,29.06,17.126999999999999,19.625,1.911,1.0580000000000001,5.1989999999999998,2.57,15.462999999999999,44.682000000000002,5.6349999999999998,5.2460000000000004,28.757000000000001,2.5350000000000001,16.058,68.558000000000007,2.5760000000000001,21.431000000000001,30.702000000000002,1.502]
["2021-05-07",16.542999999999999,13.13,4.0270000000000001,17.481000000000002,23.422999999999998,3.3010000000000002,3.4540000000000002,25.68,29.585999999999999,2.742,3.4079999999999999,7.1740000000000004,1.4910000000000001,6.5110000000000001,28.972999999999999,17.062999999999999,19.489999999999998,1.901,1.0609999999999999,5.1790000000000003,2.5649999999999999,15.352,44.462000000000003,5.6139999999999999,5.2130000000000001,28.702999999999999,2.536,15.988,68.319999999999993,2.5670000000000002,21.295000000000002,30.53,1.494]
["2021-05-10",16.582000000000001,13.083,4.0110000000000001,17.358000000000001,23.396999999999998,3.2789999999999999,3.4409999999999998,25.59,29.686,2.7080000000000002,3.3929999999999998,7.1630000000000003,1.4810000000000001,6.4710000000000001,28.67,16.957999999999998,19.343,1.891,1.0549999999999999,5.1189999999999998,2.5590000000000002,15.349,43.924999999999997,5.6059999999999999,5.1959999999999997,28.431000000000001,2.528,15.882999999999999,67.685000000000002,2.5459999999999998,21.027000000000001,30.19,1.498]
["2021-05-11",16.492999999999999,13.074999999999999,4.0220000000000002,17.364000000000001,23.302,3.2719999999999998,3.44,25.574999999999999,29.733000000000001,2.706,3.3919999999999999,7.1369999999999996,1.48,6.4009999999999998,28.643000000000001,16.948,19.358000000000001,1.879,1.06,5.1029999999999998,2.5499999999999998,15.298999999999999,43.921999999999997,5.6180000000000003,5.1909999999999998,28.419,2.5289999999999999,15.861000000000001,67.582999999999998,2.5369999999999999,21.015000000000001,30.312000000000001,1.506]
["2021-05-12",16.440000000000001,13.048,4.0199999999999996,17.434999999999999,23.277000000000001,3.27,3.4319999999999999,25.52,29.745999999999999,2.7120000000000002,3.39,7.14,1.484,6.423,28.690999999999999,16.934000000000001,19.361999999999998,1.873,1.0549999999999999,5.1059999999999999,2.5449999999999999,15.233000000000001,44.064999999999998,5.6159999999999997,5.18,28.393000000000001,2.5249999999999999,15.85,67.466999999999999,2.524,21.062999999999999,30.373999999999999,1.506]
["2021-05-13",16.315999999999999,13.077999999999999,3.9940000000000002,17.440000000000001,23.337,3.2810000000000001,3.4390000000000001,25.574999999999999,29.715,2.726,3.3980000000000001,7.1669999999999998,1.4910000000000001,6.43,28.786000000000001,16.992999999999999,19.32,1.87,1.0509999999999999,5.1319999999999997,2.5249999999999999,15.148,44.235999999999997,5.6239999999999997,5.1909999999999998,28.5,2.5139999999999998,15.866,67.528999999999996,2.492,21.172000000000001,30.497,1.4950000000000001]
["2021-05-14",16.305,13.034000000000001,3.9860000000000002,17.34,23.274999999999999,3.2669999999999999,3.4279999999999999,25.49,29.613,2.7069999999999999,3.39,7.1719999999999997,1.4810000000000001,6.4119999999999999,28.702000000000002,16.891999999999999,19.241,1.861,1.0609999999999999,5.0960000000000001,2.5470000000000002,15.199,44.045999999999999,5.6369999999999996,5.1740000000000004,28.433,2.5169999999999999,15.772,67.066000000000003,2.4940000000000002,21.024000000000001,30.187999999999999,1.4930000000000001]
["2021-05-17",16.251000000000001,13.036,3.9590000000000001,17.312000000000001,23.283000000000001,3.26,3.4279999999999999,25.495000000000001,29.565000000000001,2.7029999999999998,3.3919999999999999,7.2240000000000002,1.47,6.3929999999999998,28.638999999999999,16.873000000000001,19.228000000000002,1.845,1.054,5.0830000000000002,2.532,15.101000000000001,43.808999999999997,5.6130000000000004,5.1760000000000002,28.344999999999999,2.5099999999999998,15.708,66.783000000000001,2.5099999999999998,20.995999999999999,30.207999999999998,1.4810000000000001]

{"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,"2021-01-01",null,null,null,null,null,null,null,"počet dní"]
[1,null,null,null,null,null,null,"2021-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",45]
[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",40]
[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",40]
[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",50]
[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žibutsko","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",40]
[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á Guyana","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",40]
[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",50]
[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",55]
[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,"Mosambik","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",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Nigérie","EUR","euro",50]
[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",50]
[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,"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",50]
[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",40]
[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",40]
[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",55]
[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",45]
[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",45]
[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,"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]
[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,null,null,null,""]