{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["mena","Výstup","Popis atribútov"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"mena","index":0,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":true,"merged":[]}
[null,"Úrad","Vedúci zamestnanec","Funkcia","Poverený zamestnanec PFK","Funkcia","číslo súhlasu","pokl. č. 1","mena 1","pokl. č. 2","mena 2","pokl. č. 3","mena 3"]
[401,"GK Békešská Čaba",null,"generálny konzul","ELIÁŠOVÁ Nina","hospodár","076959/2018-OŠRO-0157108",1500,"EUR",null,"USD",500000,"HUF"]
[402,"GK Istanbul","BUDAYOVÁ Soňa","generálny konzul","PÔBIŠ Rudolf","hospodár","809.512/2009-FINO ",10000,"EUR",null,"USD",8000,"TRY"]
[403,"GK Krakov","ŠIPOŠOVÁ Zlata","vedúci generálneho konzulátu","BENKOVIČOVÁ Mária","hospodár","033360/2021-OŠRO-29",1000,"EUR",null,"USD",20000,"PLN"]
[405,"GK Mníchov","KORČEK Jozef","generálny konzul","KOVÁČ Miroslav","hospodár","033360/2021-OŠRO-39",5000,"EUR",null,"USD"]
[406,"GK New York","VRBOVSKÝ Milan","generálny konzul","KEBÍSKOVÁ Lenka","zamestnanec poverený FHA",null,null,"EUR",null,"USD"]
[407,"GK St. Peterburg","SIVÁČEK Juraj  ","generálny konzul","IŽO Juraj","hospodár","032705/2022-OŠRO-13",60000,"EUR",null,"USD",500000,"RUB"]
[408,"GK Šanghai","VALA MAGÁTOVÁ Ivana","generálny konzul","KUKA Matej","hospodár","033360/2021-OŠRO-71",1000,"EUR",null,"USD",50000,"CNY"]
[409,"GK Užhorod","PÁNIS Pavol","generálny konzul","IŽOVÁ Zuzana","hospodár","037699/2020-OŠRO-37",60000,"EUR",null,"USD",50000,"UAH"]
[410,"GK Sydney","KABÁČ Martin","generálny konzul","GALLOVÁ Katarína","hospodár","032705/2022-OŠRO-30",20000,"EUR",null,null,30000,"AUD"]
[411,"GK Brusel","MICHALEC Andrej","generálny konzul","JURÍKOVÁ Mária","hospodár","032705/2022-OŠRO-21",5000,"EUR"]
[218,"PZÚ Bejrút","SURKOŠ Ivan","veľvyslanec","KRATOCHVÍLOVÁ Katarína","hospodár","033360/2021-OŠRO-19",5500,"EUR",70000,"USD",300000,"SYP"]
[301,"SD NATO Brusel","VAŇO Ivan","ZVSD","DAUČÍKOVÁ Soňa","hospodár","720.240/2011-FINO",4000,"EUR",null,"USD"]
[265,"SEKÚ Taipei","HROMÝ Bruno","veľvyslanec","RAKONCZAY Tomáš","diplomat - ZVZÚ, konzul, hospodár","033360/2021-OŠRO-44",1500,"EUR",null,"USD",150000,"TWD"]
[302,"SM OECD Paríž","RUŽIČKA František","veľvyslanec","HORVÁT Zuzana","hospodár","664.547/2014-FINO",2000,"EUR",null,"USD"]
[303,"SM OSN New York","CHATRNÚCH Róbert","ZVZÚ","KEBÍSKOVÁ Lenka","zamestnanec poverený FHA"]
[304,"SM OSN Ženeva","MATULAY Dušan","veľvyslanec, stály predstaviteľ","KOPECKÝ Vladimír","hospodár","033360/2021-OŠRO-21",2000,"EUR",null,"USD",10000,"CHF"]
[305,"SM RE Štrasburg","TOMOVÁ Oksana","veľvyslanec","TONHAUSEROVÁ Janka","hospodár","720.809/2011-FINO",3000,"EUR",null,"USD"]
[306,"SM Viedeň","BURIAN Peter","veľvyslanec","DIVINCOVÁ Alexandra","hospodár","724.462/2012-FINO",3000,"EUR",null,"USD"]
[266,"SÚ Priština","KOSTILNÍK Rastislav","VSÚ","PLŠKOVÁ Katarína","hospodár","037699/2020-OŠRO-17",3500,"EUR",null,"USD",60000,"RSD"]
[307,"SZ EÚ Brusel","VARGOVÁ Petra","veľvyslanec, stály predstaviteľ SZ","HRADSKÁ Blanka","hospodár - účtovník",null,8000,"EUR",null,"USD"]
[201,"ZÚ Abu Dhabi","KOVÁČ Michal","veľvyslanec","MULIKOVÁ Patrícia","hospodár","039291/2020-OŠRO-12",9000,"EUR",null,"USD",70000,"AED"]
[202,"ZÚ Abuja","FELIX Tomáš","veľvyslanec","FELIXOVÁ Miriam","referent hospodárskeho úseku, pokladník","026121/2023-OŠRO-16",60000,"EUR",null,"USD",4000000,"NGN"]
[203,"ZÚ Addis Abeba","ŠTOS Drahomír","veľvyslanec","PETRLA Ján","hospodár","033360/2021-OŠRO-67",null,"EUR",null,"USD",200000,"ETB"]
[204,"ZÚ Ankara","PŠENICA Ján","veľvyslanec","SERDAREVIĆ Ivan","hospodár","026121/2023-OŠRO-10",35000,"EUR",null,"USD",60000,"TRY"]
[205,"ZÚ Nur-Sultan","KIRNÁG Róbert","veľvyslanec","HRADSKÁ Blanka","hospodár","046797/2019-OŠRO-0039218",9000,"EUR",null,"USD",1000000,"KZT"]
[206,"ZÚ Atény","HANUSOVÁ Marcela","veľvyslanec","JUCHA Rastislav","hospodár, komunikačný zamestnanec","662.691/2017-FINO",60000,"EUR",null,"USD"]
[208,"ZÚ Bangkok","AUXT Jaroslav","veľvyslanec","MATÚŠEK Jozef","hospodár","033360/2021-OŠRO-41",4000,"EUR",1500,"USD",400000,"THB"]
[209,"ZÚ Belehrad","ROSOCHA Fedor","veľvyslanec","RAKÚS Richard","hospodár","012143/2017-OŠRO-0106046",10000,"EUR",null,"USD",500000,"RSD"]
[211,"ZÚ Bern","MICOVČIN Alexander","veľvyslanec","TOMČOVÁ Dana","hospodár","720.809/2011-FINO",2500,"EUR",null,"USD",10000,"CHF"]
[212,"ZÚ Brazília","ROSENBERG Viliam","veľvyslanec","UJLAKY HANÁKOVÁ Denisa","hospodár","033360/2021-OŠRO-80",14000,"EUR",null,"USD",30000,"BRL"]
[213,"ZÚ Brusel",null,"veľvyslanec",null,"hospodár","033360/2021-OŠRO-23",5000,"EUR",null,"USD"]
[215,"ZÚ Buenos Aires","HINDICKÝ Rastislav","veľvyslanec","GALOCIOVÁ Eleonóra","hospodár","026121/2023-OŠRO-7",35000,"EUR",null,"USD",1000000,"ARS"]
[216,"ZÚ Bukurešť","HATIAR Peter","veľvyslanec","FILIPKOVÁ Iveta","hospodár","033360/2021-OŠRO-35",8000,"EUR",null,"USD",23000,"RON"]
[217,"ZÚ Canberra","KABÁČ Martin","veľvyslanec","GALLOVÁ Katarína","hospodár","032705/2022-OŠRO-26",null,"EUR",null,"USD",33000,"AUD"]
[219,"ZÚ Dillí","MAXIÁN Róbert","veľvyslanec","BARTIŠEK Patrik","hospodár","033360/2021-OŠRO-13",20000,"EUR",500,"USD",2000000,"INR"]
[220,"ZÚ Dublin","DROBA Andrej","veľvyslanec","TYRALOVÁ Petra","hospodár","026121/2023-OŠRO-20",5000,"EUR",null,"USD"]
[221,"ZÚ Haag","MACHÁČ Juraj","veľvyslanec","KUZMICKÁ Zuzana","hospodár, komunikačný zamestnanec","062840/2019-OŠRO-0110604",5000,"EUR",null,"USD"]
[222,"ZÚ Hanoj","SVETÍK Pavol","VZÚ","JUDIAK Maroš","hospodár","012143/2017-OŠRO-0054198",15000,"EUR",null,"USD",700000000,"VND"]
[223,"ZÚ Havana","ZACHAR Milan","veľvyslanec","ĎUREČKOVÁ Martina","hospodár","026121/2023-OŠRO-39",50000,"EUR",5000,"USD",300000,"CUP"]
[224,"ZÚ Helsinki","KRIŠTOFÍK Dušan","veľvyslanec","IVAN Miroslav","hospodár","033360/2021-OŠRO-45",2000,"EUR",null,"USD"]
[225,"ZÚ Jakarta","FERKO Tomáš ","veľvyslanec","REHÁČEK Róbert","hospodár, regionálny administrátor","720.809/2011-FINO",25000,"EUR",6000,"USD",150000000,"IDR"]
[226,"ZÚ Káhira","MIHÁLIKOVÁ Lenka","veľvyslanec","DOSTÁL Matej ml.","hospodár","012143/2017-OŠRO-0082009",30000,"EUR",1000,"USD",100000,"EGP"]
[267,"ZÚ Kišiňov","IVAN Pavol","veľvyslanec","IVANOVÁ Larisa","hospodár,referent pre konzulárnu činnosť","032705/2022-OŠRO-18",5000,"EUR",null,"USD",60000,"MDL"]
[227,"ZÚ Kodaň","SLOBODNÍK Igor","veľvyslanec","PROCHÁZKA Peter","hospodár, vodič, domovník","033360/2021-OŠRO-65",1000,"EUR",null,"USD",30000,"DKK"]
[229,"ZÚ Kuvajt","HAJDUŠEK Igor","veľvyslanec","MULIKOVÁ Patrícia","ZVZÚ, konzul, hospodár","660.788/2014-FINO",1500,"EUR",null,"USD",5000,"KWD"]
[230,"ZÚ Kyjev","ŠAFIN Marek","veľvyslanec","ORAVCOVÁ Zuzana","hospodár","012143/2017-OŠRO-0077891",150000,"EUR",null,"USD",300000,"UAH"]
[231,"ZÚ Lisabon","KRÁLIK Tibor","veľvyslanec","TÖRÖK Richard","hospodár","710.561/2013-FINO",5000,"EUR",null,"USD"]
[232,"ZÚ Londýn","ONDREJCSÁK Róbert ","veľvyslanec","RAKOVÁ Miroslava","zamestnanec poverený FHA","033360/2021-OŠRO-12",1000,"EUR",null,"USD",25000,"GBP"]
[233,"ZÚ Ľubľana","ZELEŇÁK Peter","veľvyslanec","HERINGHOVÁ Ľubomíra","hospodár","033360/2021-OŠRO-51",5000,"EUR",null,"USD"]
[234,"ZÚ Madrid","TOMAGA Juraj","veľvyslanec","TÖRÖKOVÁ Alena","hospodár","033360/2021-OŠRO-69",4000,"EUR",null,"USD"]
[235,"ZÚ Mexiko","ŠAJGALÍKOVÁ Terézia","veľvyslanec","BUDOŠOVÁ Katarína","hospodár","012143/2017-OŠRO-0095225",null,"EUR",5000,"USD",100000,"MXN"]
[236,"ZÚ Minsk","ŽÁKOVÁ Katarína","VZÚ","ČELLÁR Miroslav","hospodár","032705/2022-OŠRO-16",50000,"EUR",null,"USD",50000,"BYN"]
[238,"ZÚ Nairobi","ŽUFFA LELIGDONOVÁ Katarína","veľvyslanec","ŽUFFA Michal","hospodár","033360/2021-OŠRO-37",3500,"EUR",1500,"USD",500000,"KES"]
[239,"ZÚ Nikózia","BEZÁK Martin","veľvyslanec","KURDIAN Lucia","hospodár","033360/2021-OŠRO-57",16000,"EUR",null,"USD"]
[240,"ZÚ Oslo","BUŽEK Roman","veľvyslanec","FRANCÚZ Stanislav","hospodár","033360/2021-OŠRO-31",null,"EUR",null,"USD",40000,"NOK"]
[241,"ZÚ Ottawa","GRIGOVÁ Viera","veľvyslanec","PILNÝ Juraj","hospodár","033360/2021-OŠRO-47",null,"EUR",null,"USD",18000,"CAD"]
[243,"ZÚ Peking","LIZÁK Peter","veľvyslanec","SLOVÍK Igor","hospodár","033360/2021-OŠRO-78",15000,"EUR",null,"USD",300000,"CNY"]
[244,"ZÚ Podgorica","GANDEL Boris","veľvyslanec","BALCO Hana","diplomat, konzul, hospodár","032705/2022-OŠRO-35",11000,"EUR",null,"USD"]
[246,"ZÚ Pretória","GRÁCZ Vladimír","veľvyslanec","PLŠKOVÁ Ľubica","hospodár","033360/2021-OŠRO-82",15000,"EUR",null,"USD",150000,"ZAR"]
[247,"ZÚ Riga","PAVLOVIČ Branislav","veľvyslanec","BÓRYOVÁ Jarmila","diplomat, hospodár","660.478/2014-FINO",2000,"EUR",null,"USD"]
[249,"ZÚ Sarajevo","HLOBEŇ Roman","veľvyslanec","PALDANOVÁ Zuzana","hospodár","030333/2018-OŠRO-0037753",4000,"EUR",null,"USD",6000,"BAM"]
[250,"ZÚ Skopje","MARKUŠ Henrik","veľvyslanec","CHLUPÍK Tibor","ZVZÚ,diplomat,konzul,hospodár","660.459/2014-FINO",6000,"EUR",null,"USD",200000,"MKD"]
[251,"ZÚ Sofia","GRIVNA Vasil","veľvyslanec","ČERNÍK Róbert","hospodár, komunikačný zamestnanec","012143/2017-OŠRO-0083047",8000,"EUR",null,"USD",8000,"BGN"]
[252,"ZÚ Soul","KUDERJAVÝ Ján","veľvyslanec","MESZÁROŠOVÁ Viera","hospodár","012143/2017-OŠRO-0135531",3000,"EUR",4000,"USD",5000000,"KRW"]
[253,"ZÚ Štokholm","ČAŇO Ľubomír","veľvyslanec","VOZÁKOVÁ Henrieta","hospodár","026121/2023-OŠRO-25",1000,"EUR",null,"USD",30000,"SEK"]
[254,"ZÚ Taškent","BORECKÝ Viktor","veľvyslanec","JANČOŠEK Matej","diplomat - ZVZÚ, konzul, hospodár","026121/2023-OŠRO-27",12000,"EUR",6000,"USD",30000000,"UZS"]
[269,"ZÚ Tbilisi","VÍZDAL Pavel","veľvyslanec","VRANKO Róbert","hospodár, referent konzulárneho úradu","012143/2017-OŠRO-0096674",10000,"EUR",null,"USD",6000,"GEL"]
[255,"ZÚ Teherán","BALLEK Ladislav","veľvyslanec","KOMLOŠ Róbert","hospodár","033360/2021-OŠRO-86",150000,"EUR",150000,"USD",400000000,"IRR"]
[256,"ZÚ Tel Aviv","MAUKŠ Igor","veľvyslanec","KOVÁČ Ján","hospodár, informačné systémy","033360/2021-OŠRO-84",2000,"EUR",1000,"USD",25000,"ILS"]
[257,"ZÚ Tirana","OTRUBA Albín","veľvyslanec","BARTÁK Maroš","hospodár","661.556/2016-FINO",10000,"EUR",null,"USD",300000,"ALL"]
[258,"ZÚ Tokio","TOMÁŠIK Marián","veľvyslanec","HAUSEROVÁ Kristína","diplomatka, konzulka, hospodárka","033360/2021-OŠRO-27",null,"EUR",null,"USD",2500000,"JPY"]
[259,"ZÚ Tripolis",null,"veľvyslanec",null,"diplomat - ZVZÚ, konzul, hospodár",null,null,"EUR",null,"USD"]
[263,"ZÚ Washington","JAVORČÍK Radovan","veľvyslanec","CAKOVÁ Monika","hospodár",null,null,"EUR",0,"USD"]
[264,"ZÚ Záhreb","KOVÁČOVÁ Hana","veľvyslanec","ŠVEDOVÁ Světluše","hospodár","033360/2021-OŠRO-55",2000,"EUR",null,"USD",25000,"HRK"]
[270,"ZÚ Bejrút","VARGA Marek","veľvyslanec","BAIROVÁ Daniela","hospodár",null,5500,"EUR",70000,"USD",40000000,"LBP"]
[271,"ZÚ Baku","LAJČIAK Milan","vedúci zastupiteľského úradu","LIPTÁKOVÁ Anastasia","hospodár","031793/2023-AZVV-11",12000,"EUR",null,"USD",30000,"AZN"]
[272,"ZÚ Jerevan","HACEK Miroslav","veľvyslanec","OLÁHOVÁ Eva","hospodár","033360/2021-OŠRO-17",2500,"EUR",null,"USD",4000000,"AMD"]
[273,"ZÚ Rijád","MICHALKA Rudolf","veľvyslanec","PETRLA Ján","hospodár","034790/2022-OŠRO-60",25000,"EUR",null,"USD",30000,"SAR"]

{"sheet":"Výstup","index":1,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,3,1,6],[0,0,0,9],[20,0,20,2],[20,3,20,9],[21,1,21,9],[4,4,4,6],[3,3,3,5],[3,7,3,8],[2,3,2,6]]}
["Pokladničná kniha"]
[null,null,"úrad:"]
[null,null,"pokladňa:",null,null,null,null,null,"mena:"]
[null,null,"obdobie:",null,null,null,"Súhlas FINO:"]
[null,null,null,null,"Limit zostatku pokladničnej hotovosti:"]
["Dátum","Číslo dokladu","Text","Obchodný prípad","Suma príjem","Suma výdaj","Zostatok","Var.Symbol","Pohľad./Záväz.","Suma EUR"]
[]
["Počiatočný stav:"]
[]
["DD.MM.RRRR"]
["DD.MM.RRRR"]
["DD.MM.RRRR"]
["DD.MM.RRRR"]
[]
[]
[]
["Súčet",null,null,null,{"$f":"SUM(E10:E14)","v":0},{"$f":"SUM(F10:F14)","v":0},null,null,null,{"$f":"SUM(J10:J14)","v":0}]
[]
["Konečný zostatok:"]
[]
["Zdôvodnenie prekročenia limitu zostatku pokladničnej hotovosti:"]
[]
["Dňa:","DD.MM.RRRR"]
["Vyhotovil:",null,null,null,null,null,"Schválil:"]
[null,null,null,null,null,null,null,"Vedúci ZÚ"]

{"sheet":"Popis atribútov","index":2,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Atribút","Popis"]
["Úrad","Názov organizácie - účtového okruhu"]
["Pokladňa","Názov pokladne z číselníka pokladní"]
["Obdobie","Výberové kritériá zadané užívateľom v zadávacej obrazovke reportu"]
["Mena","Mena pokladne z číselníka pokladní"]
["Súhlas FINO","Číslo písomnosti, ktorou je usmernený limit zostatku pokladne odborom FINO – z nastavení pokladne"]
["Limit zostatku","Výška limitu zostatku pokladne – z nastavení pokladne"]
["Počiatočný stav","Počiatočný stav pokladne podľa výberových kritérií zadaných za zadávacej obrazovke"]
["Pohyby","Pohyby pokladne podľa výberových kritérií zadaných za zadávacej obrazovke"]
["▪ Dátum","Dátum pohybu v pokadni - z dátumu dokladu"]
["▪ Číslo dokladu","Číslo dokladu, ktorým je pohyb v pokladni zaevidovaný"]
["▪ Text","Text z dokladu, ktorým je pohyb v pokladni zaevidovaný"]
["▪ Obchodný prípad","Názov použitého obchodného prípadu z číselníka obchodných prípadov"]
["▪ Suma príjem","Suma príjmu do pokladne - len v prípade, že ide o príjmový obchodný prípad"]
["▪ Suma výdaj","Suma výdavku z pokladne - len v prípade, že ide o výdavkový obchodný prípad"]
["▪ Zostatok","Priebežný zostatok pokladne po danom pohybe"]
["▪ Var.symbol","Variabilný symbol z dokladu, ktorým je pohyb v pokladni zaevidovaný"]
["▪ Pohľad./Záväzok","Číslo dokladu pohľadávky/záväzku - len v prípade, že ide o obchodný prípad, ktorý generuje pohľadávku/záväzok (z nastavení obchodných prípadov)"]
["▪ Suma EUR","Prepočet na EUR - len v pokladniach v cudzej mene"]
["▪ Súčet","Súčet hodnôt v stĺpcoch: Suma príjem, Suma výdaj, Suma EUR"]
["Konečný zostatok","Konečný stav pokladne podľa výberových kritérií zadaných za zadávacej obrazovke"]
["Dňa","Systémový dátum"]
["Vyhotovil","Meno prihláseného užívateľa"]
["Schválil","Meno vedúceho ZÚ – z nastavení systému"]