{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["P. Podaci o kontakt osobama","A. Ukupne usluge osiguranja","B. Transakcije s nerezidentima","D. Stanje mat. pričuve","E. Kreiranje datoteke","Padajuće liste"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":2,"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. Podaci o kontakt osobama","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["P. Podaci o kontakt osobama"]
[]
["Oznaka osobe","Ime i prezime","Broj telefona","E-adresa"]

{"sheet":"A. Ukupne usluge osiguranja","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["A. Ukupne usluge osiguranja"]
["-u eurima"]
["Naziv stavke","Godina","Mjesec","Iznos"]
["<NazivStavke>","<Godina>","<Mjesec>","<Iznos>"]

{"sheet":"B. Transakcije s nerezidentima","index":2,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["B. Transakcije s nerezidentima"]
["-u eurima"]
["Naziv stavke","Godina","Mjesec","Zemlja","Iznos"]
["<NazivStavke>","<Godina>","<Mjesec>","<Zemlja>","<Iznos>"]

{"sheet":"D. Stanje mat. pričuve","index":3,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["D. Stanje matematičke pričuve osiguranja života koja pripada nerezidentima"]
["-u eurima"]
["Naziv stavke","Godina","Mjesec","Zemlja","Stanje na kraju mjeseca"]
["<NazivStavke>","<Godina>","<Tromjesecje>","<Zemlja>","<StanjeKrajKvartala>"]

{"sheet":"E. Kreiranje datoteke","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,4,6,5],[8,4,8,5],[10,4,10,5],[12,4,12,5]]}
["UPUTA ZA DOSTAVU PODATAKA:"]
[]
["1. Omogućite izvođenje makro naredbi"]
[]
["2. Popunite tablice  podacima"]
[]
["3. U zeleno polje upišite matični broj:",null,null,null,"00000325",null,null,"potvrdite unos tipkom <ENTER>"]
[]
["4. U narančasto polje upišite OIB:",null,null,null,"01234567890"]
[]
["5. U žuto polje upišite godinu / odaberite razdoblje izvješća:",null,null,null,"2023",null,null,"Q1"]
[]
["6. U plavo polje unesite koji put podnosite izvještaj                                 ",null,null,null,"1"]
[]
["7. Pritisnite gumb 'Kreiraj XML datoteku' za kreiranje XML datoteke"]
[]
[]
[]
[]
[]
["7. Datoteka kreirana na lokaciji:"]
[]
["8. Locirajte datoteku na navedenoj lokaciji"]
[]
["9. Provjerite naziv datoteke"]
[]
["10. Dogovorenim načinom dostavite XML datoteku"]
[]
[]
[]
["NAPOMENA"]
["Kod nekih MS Excel verzija je nakon omogućavanja izvođenja makro naredbi datoteku potrebno zatvoriti (da se spreme postavke) te ponovo otvoriti."]
["Do opcija za postavljanje makro naredbi dolazi se putem padajućeg izbornika u MS Excel programu:"]
["Za starije verzije Ecela:"]
["hrv. verzija >> Alati > Odrednice... > Sigurnost > Sigurnost makro naredbe... > odaberite srednja ili niska"]
["eng. verzija >> Tools > Options... > Security > MacroSecurity... > odaberite Medium ili Low"]
["U novijim verzijama Excela: "]
["Datoteka>Mogućnosti>Centar za pouzdanost>Postavke centra za pouzdanost>Postavke makronaredbi> odabir \"Omogući sve makronaredbe\""]

{"sheet":"Padajuće liste","index":5,"n_rows":251,"n_cols":10,"rows_kept":251,"cut":false,"hidden":true,"merged":[]}
["OZNAKA OSOBE","A stavke","B_C stavke","Godina","Mjesec","Tromjesečje","Zemlja","D.stavke","Vrst.inst.","Godina"]
["OS1-Izvještaj popunio/la","A.1.1.- Zaračunate bruto premije za osiguranje robe u prijevozu","B.1.1.- Osiguranje robe u prijevozu-Zaračunate bruto premije",2023,"01","Q1","AF-AFGANISTAN","D.1.1.- Stanje matematičke pričuve osiguranja života koja pripada nerezidentima","1 - osiguravateljsko društvo",2015]
["OS2-Odgovorna osoba","A.1.2.- Likvidirane štete u bruto iznosu za osiguranje robe u prijevozu","B.1.2.1.- Osiguranje robe u prijevozu-Likvidirane štete u bruto iznosu-nerezidentu na temelju njegove police",2024,"02","Q2","AL-ALBANIJA",null,"2 - reosiguravateljsko društvo",2016]
[null,"A.2.1.- Zaračunate bruto premije za neživotno osiguranje","B.1.2.2.- Osiguranje robe u prijevozu-Likvidirane štete u bruto iznosu-nerezidentu na temelju police rezidenta",2025,"03","Q3","DZ-ALZIR",null,null,2017]
[null,"A.2.2.- Likvidirane štete u bruto iznosu za neživotno osiguranje","B.2.1.- Neživotno osiguranje-Zaračunate bruto premije",2026,"04","Q4","AS-AMERICKA SAMOA",null,null,2018]
[null,"A.3.1.- Zaračunate bruto premije za životno osiguranje","B.2.2.1.- Neživotno osiguranje-Likvidirane štete u bruto iznosu-nerezidentu na temelju njegove police",2027,"05",null,"VI-AMERICKI DJEVICANSKI OTOCI",null,null,2019]
[null,"A.3.2.- Likvidirane štete u bruto iznosu za životno osiguranje","B.2.2.2.- Neživotno osiguranje-Likvidirane štete u bruto iznosu-nerezidentu na temelju police rezidenta",2028,"06",null,"AD-ANDORA",null,null,2020]
[null,null,"B.3.1.- Životno osiguranje-Zaračunate bruto premije",2029,"07",null,"AO-ANGOLA",null,null,2021]
[null,null,"B.3.2.- Životno osiguranje-Likvidirane štete u bruto iznosu",2030,"08",null,"AI-ANGUILLA",null,null,2022]
[null,null,"B.3.3.- Dodatne osigurane svote",2031,"09",null,"AQ-ANTARKTIKA",null,null,2023]
[null,null,"B.4.1.- Pružene pomoćne usluge",2032,"10",null,"AG-ANTIGVA I BARBUDA",null,null,2024]
[null,null,"B.4.2.- Primljene pomoćne usluge",2033,"11",null,"AR-ARGENTINA",null,null,2025]
[null,null,"B.5.1.- Premije predane u reosiguranje",2034,"12",null,"AM-ARMENIJA"]
[null,null,"B.5.2.- Udio reosiguravatelja u likvidiranim štetama",2035,null,null,"AW-ARUBA"]
[null,null,"C.1.1.- Prijelazni račun-Odljev",2036,null,null,"AU-AUSTRALIJA"]
[null,null,"C.1.2.- Prijelazni račun-Priljev",2037,null,null,"AT-AUSTRIJA"]
[null,null,null,null,null,null,"AZ-AZERBAJDZAN"]
[null,null,null,null,null,null,"BS-BAHAMI"]
[null,null,null,null,null,null,"BH-BAHREIN"]
[null,null,null,null,null,null,"BD-BANGLADES"]
[null,null,null,null,null,null,"BB-BARBADOS"]
[null,null,null,null,null,null,"BE-BELGIJA"]
[null,null,null,null,null,null,"BZ-BELIZE"]
[null,null,null,null,null,null,"BJ-BENIN"]
[null,null,null,null,null,null,"BM-BERMUDI"]
[null,null,null,null,null,null,"CI-BJELOKOSNA OBALA"]
[null,null,null,null,null,null,"BY-BJELORUSIJA"]
[null,null,null,null,null,null,"BW-BOCVANA"]
[null,null,null,null,null,null,"BO-BOLIVIJA, PLURINACIONALNA DRZAVA"]
[null,null,null,null,null,null,"BQ-BONAIRE, SVETI EUSTAZIJE I SABA"]
[null,null,null,null,null,null,"BA-BOSNA I HERCEGOVINA"]
[null,null,null,null,null,null,"CX-BOZICNI OTOK"]
[null,null,null,null,null,null,"BR-BRAZIL"]
[null,null,null,null,null,null,"VG-BRITANSKI DJEVICANSKI OTOCI"]
[null,null,null,null,null,null,"IO-BRITANSKI INDIJSKOOCEANSKI TERITORIJ"]
[null,null,null,null,null,null,"BN-BRUNEJ"]
[null,null,null,null,null,null,"BG-BUGARSKA"]
[null,null,null,null,null,null,"BF-BURKINA FASO"]
[null,null,null,null,null,null,"BI-BURUNDI"]
[null,null,null,null,null,null,"BT-BUTAN"]
[null,null,null,null,null,null,"TD-CAD"]
[null,null,null,null,null,null,"CZ-CESKA"]
[null,null,null,null,null,null,"CL-CILE"]
[null,null,null,null,null,null,"CY-CIPAR"]
[null,null,null,null,null,null,"ME-CRNA GORA"]
[null,null,null,null,null,null,"CW-CURACAO"]
[null,null,null,null,null,null,"DK-DANSKA"]
[null,null,null,null,null,null,"DM-DOMINIKA"]
[null,null,null,null,null,null,"DO-DOMINIKANSKA REPUBLIKA"]
[null,null,null,null,null,null,"DJ-DZIBUTI"]
[null,null,null,null,null,null,"EG-EGIPAT"]
[null,null,null,null,null,null,"EC-EKVADOR"]
[null,null,null,null,null,null,"GQ-EKVATORSKA GVINEJA"]
[null,null,null,null,null,null,"ER-ERITREJA"]
[null,null,null,null,null,null,"EE-ESTONIJA"]
[null,null,null,null,null,null,"ET-ETIOPIJA"]
[null,null,null,null,null,null,"FK-FALKLANDI (MALVINI)"]
[null,null,null,null,null,null,"FO-FEROJSKI OTOCI (OVCJI)"]
[null,null,null,null,null,null,"FJ-FIDZI"]
[null,null,null,null,null,null,"PH-FILIPINI"]
[null,null,null,null,null,null,"FI-FINSKA"]
[null,null,null,null,null,null,"FR-FRANCUSKA"]
[null,null,null,null,null,null,"FX-FRANCUSKA (EUROPSKI DIO)"]
[null,null,null,null,null,null,"GF-FRANCUSKA GVAJANA"]
[null,null,null,null,null,null,"PF-FRANCUSKA POLINEZIJA"]
[null,null,null,null,null,null,"TF-FRANCUSKI JUZNI TERITORIJ"]
[null,null,null,null,null,null,"GA-GABON"]
[null,null,null,null,null,null,"GM-GAMBIJA"]
[null,null,null,null,null,null,"GH-GANA"]
[null,null,null,null,null,null,"GI-GIBRALTAR"]
[null,null,null,null,null,null,"GR-GRCKA"]
[null,null,null,null,null,null,"GD-GRENADA"]
[null,null,null,null,null,null,"GL-GRENLAND"]
[null,null,null,null,null,null,"GE-GRUZIJA"]
[null,null,null,null,null,null,"GP-GUADELOUPE"]
[null,null,null,null,null,null,"GU-GUAM"]
[null,null,null,null,null,null,"GG-GUERNSEY"]
[null,null,null,null,null,null,"GY-GVAJANA"]
[null,null,null,null,null,null,"GT-GVATEMALA"]
[null,null,null,null,null,null,"GN-GVINEJA"]
[null,null,null,null,null,null,"GW-GVINEJA BISAU"]
[null,null,null,null,null,null,"HT-HAITI"]
[null,null,null,null,null,null,"HN-HONDURAS"]
[null,null,null,null,null,null,"HK-HONG KONG"]
[null,null,null,null,null,null,"IN-INDIJA"]
[null,null,null,null,null,null,"ID-INDONEZIJA"]
[null,null,null,null,null,null,"IQ-IRAK"]
[null,null,null,null,null,null,"IR-IRAN, ISLAMSKA REPUBLIKA"]
[null,null,null,null,null,null,"IE-IRSKA"]
[null,null,null,null,null,null,"IS-ISLAND"]
[null,null,null,null,null,null,"IT-ITALIJA"]
[null,null,null,null,null,null,"IL-IZRAEL"]
[null,null,null,null,null,null,"JM-JAMAJKA"]
[null,null,null,null,null,null,"JP-JAPAN"]
[null,null,null,null,null,null,"YE-JEMEN"]
[null,null,null,null,null,null,"JE-JERSEY"]
[null,null,null,null,null,null,"JO-JORDAN"]
[null,null,null,null,null,null,"GS-JUZNA DZORDZIJA I OTOCI JUZNI SENDVIC"]
[null,null,null,null,null,null,"SS-JUZNI SUDAN"]
[null,null,null,null,null,null,"ZA-JUZNOAFRICKA REPUBLIKA"]
[null,null,null,null,null,null,"KY-KAJMANSKI OTOCI"]
[null,null,null,null,null,null,"KH-KAMBODZA"]
[null,null,null,null,null,null,"CM-KAMERUN"]
[null,null,null,null,null,null,"CA-KANADA"]
[null,null,null,null,null,null,"QA-KATAR"]
[null,null,null,null,null,null,"KZ-KAZAHSTAN"]
[null,null,null,null,null,null,"KE-KENIJA"]
[null,null,null,null,null,null,"CN-KINA"]
[null,null,null,null,null,null,"KG-KIRGISTAN"]
[null,null,null,null,null,null,"KI-KIRIBATI"]
[null,null,null,null,null,null,"CC-KOKOSOVI OTOCI (KEELING)"]
[null,null,null,null,null,null,"CO-KOLUMBIJA"]
[null,null,null,null,null,null,"KM-KOMORI"]
[null,null,null,null,null,null,"CG-KONGO"]
[null,null,null,null,null,null,"CD-KONGO, DEMOKRATSKA REPUBLIKA"]
[null,null,null,null,null,null,"KP-KOREJA, DNR"]
[null,null,null,null,null,null,"KR-KOREJA, REPUBLIKA"]
[null,null,null,null,null,null,"XK-KOSOVO"]
[null,null,null,null,null,null,"CR-KOSTARIKA"]
[null,null,null,null,null,null,"CU-KUBA"]
[null,null,null,null,null,null,"CK-KUKOVI OTOCI"]
[null,null,null,null,null,null,"KW-KUVAJT"]
[null,null,null,null,null,null,"LA-LAOS, NDR"]
[null,null,null,null,null,null,"LS-LESOTO"]
[null,null,null,null,null,null,"LV-LETONIJA"]
[null,null,null,null,null,null,"LB-LIBANON"]
[null,null,null,null,null,null,"LR-LIBERIJA"]
[null,null,null,null,null,null,"LY-LIBIJA"]
[null,null,null,null,null,null,"LI-LIHTENSTAJN"]
[null,null,null,null,null,null,"LT-LITVA"]
[null,null,null,null,null,null,"LU-LUKSEMBURG"]
[null,null,null,null,null,null,"MG-MADAGASKAR"]
[null,null,null,null,null,null,"HU-MADZARSKA"]
[null,null,null,null,null,null,"MO-MAKAO"]
[null,null,null,null,null,null,"MK-MAKEDONIJA"]
[null,null,null,null,null,null,"MW-MALAVI"]
[null,null,null,null,null,null,"MV-MALDIVI"]
[null,null,null,null,null,null,"MY-MALEZIJA"]
[null,null,null,null,null,null,"ML-MALI"]
[null,null,null,null,null,null,"MT-MALTA"]
[null,null,null,null,null,null,"MA-MAROKO"]
[null,null,null,null,null,null,"MH-MARSALOVI OTOCI"]
[null,null,null,null,null,null,"MQ-MARTINIQUE"]
[null,null,null,null,null,null,"MU-MAURICIJUS"]
[null,null,null,null,null,null,"MR-MAURITANIJA"]
[null,null,null,null,null,null,"YT-MAYOTTE"]
[null,null,null,null,null,null,"MX-MEKSIKO"]
[null,null,null,null,null,null,"MM-MIJANMAR"]
[null,null,null,null,null,null,"FM-MIKRONEZIJA, SAVEZNE DRZAVE"]
[null,null,null,null,null,null,"MD-MOLDAVIJA, REPUBLIKA"]
[null,null,null,null,null,null,"MC-MONAKO"]
[null,null,null,null,null,null,"MN-MONGOLIJA"]
[null,null,null,null,null,null,"MS-MONTSERRAT"]
[null,null,null,null,null,null,"MZ-MOZAMBIK"]
[null,null,null,null,null,null,"NA-NAMIBIJA"]
[null,null,null,null,null,null,"NR-NAURU"]
[null,null,null,null,null,null,"NP-NEPAL"]
[null,null,null,null,null,null,"NE-NIGER"]
[null,null,null,null,null,null,"NG-NIGERIJA"]
[null,null,null,null,null,null,"NI-NIKARAGVA"]
[null,null,null,null,null,null,"NU-NIUE"]
[null,null,null,null,null,null,"NL-NIZOZEMSKA"]
[null,null,null,null,null,null,"NO-NORVESKA"]
[null,null,null,null,null,null,"NC-NOVA KALEDONIJA"]
[null,null,null,null,null,null,"NZ-NOVI ZELAND"]
[null,null,null,null,null,null,"DE-NJEMACKA"]
[null,null,null,null,null,null,"OM-OMAN"]
[null,null,null,null,null,null,"AX-OTOCI ALAND"]
[null,null,null,null,null,null,"TC-OTOCI TURKS I CAICOS"]
[null,null,null,null,null,null,"BV-OTOK BOUVET"]
[null,null,null,null,null,null,"HM-OTOK HEARD I OTOCI MCDONALD"]
[null,null,null,null,null,null,"IM-OTOK MAN"]
[null,null,null,null,null,null,"NF-OTOK NORFOLK"]
[null,null,null,null,null,null,"PK-PAKISTAN"]
[null,null,null,null,null,null,"PW-PALAU"]
[null,null,null,null,null,null,"PS-PALESTINA, DRZAVA"]
[null,null,null,null,null,null,"PA-PANAMA"]
[null,null,null,null,null,null,"PG-PAPUA NOVA GVINEJA"]
[null,null,null,null,null,null,"PY-PARAGVAJ"]
[null,null,null,null,null,null,"PE-PERU"]
[null,null,null,null,null,null,"PN-PITCAIRN"]
[null,null,null,null,null,null,"PL-POLJSKA"]
[null,null,null,null,null,null,"PR-PORTORIKO"]
[null,null,null,null,null,null,"PT-PORTUGAL"]
[null,null,null,null,null,null,"RE-REUNION"]
[null,null,null,null,null,null,"RW-RUANDA"]
[null,null,null,null,null,null,"RO-RUMUNJSKA"]
[null,null,null,null,null,null,"RU-RUSIJA"]
[null,null,null,null,null,null,"US-SAD"]
[null,null,null,null,null,null,"SV-SALVADOR"]
[null,null,null,null,null,null,"WS-SAMOA"]
[null,null,null,null,null,null,"SM-SAN MARINO"]
[null,null,null,null,null,null,"SA-SAUDIJSKA ARABIJA"]
[null,null,null,null,null,null,"SC-SEJSELI"]
[null,null,null,null,null,null,"SN-SENEGAL"]
[null,null,null,null,null,null,"SL-SIJERA LEONE"]
[null,null,null,null,null,null,"SG-SINGAPUR"]
[null,null,null,null,null,null,"SY-SIRIJA"]
[null,null,null,null,null,null,"MP-SJEVERNI MARIJANSKI OTOCI"]
[null,null,null,null,null,null,"SK-SLOVACKA"]
[null,null,null,null,null,null,"SI-SLOVENIJA"]
[null,null,null,null,null,null,"SB-SOLOMONSKI OTOCI"]
[null,null,null,null,null,null,"SO-SOMALIJA"]
[null,null,null,null,null,null,"ES-SPANJOLSKA"]
[null,null,null,null,null,null,"RS-SRBIJA"]
[null,null,null,null,null,null,"CF-SREDNJOAFRICKA REPUBLIKA"]
[null,null,null,null,null,null,"LK-SRI LANKA"]
[null,null,null,null,null,null,"SD-SUDAN"]
[null,null,null,null,null,null,"SR-SURINAM"]
[null,null,null,null,null,null,"SJ-SVALBARD I JAN MAYEN"]
[null,null,null,null,null,null,"SZ-SVAZI"]
[null,null,null,null,null,null,"SE-SVEDSKA"]
[null,null,null,null,null,null,"SH-SVETA HELENA,ASCENSION I TRISTAN DA CUNH"]
[null,null,null,null,null,null,"LC-SVETA LUCIJA"]
[null,null,null,null,null,null,"VA-SVETA STOLICA, DRZAVA VATIKANSKOG GRADA"]
[null,null,null,null,null,null,"BL-SVETI BARTOLOMEJ"]
[null,null,null,null,null,null,"KN-SVETI KRISTOFOR I NEVIS"]
[null,null,null,null,null,null,"MF-SVETI MARTIN (FRANCUSKI DIO)"]
[null,null,null,null,null,null,"SX-SVETI MARTIN (NIZOZEMSKI DIO)"]
[null,null,null,null,null,null,"PM-SVETI PETAR I MIKELON"]
[null,null,null,null,null,null,"ST-SVETI TOMA I PRINSIPE"]
[null,null,null,null,null,null,"VC-SVETI VINCENT I GRENADINI"]
[null,null,null,null,null,null,"CH-SVICARSKA"]
[null,null,null,null,null,null,"TJ-TADZIKISTAN"]
[null,null,null,null,null,null,"TH-TAJLAND"]
[null,null,null,null,null,null,"TW-TAJVAN, KINESKA PROVINCIJA"]
[null,null,null,null,null,null,"TZ-TANZANIJA, UJEDINJENA REPUBLIKA"]
[null,null,null,null,null,null,"TL-TIMOR LESTE"]
[null,null,null,null,null,null,"TG-TOGO"]
[null,null,null,null,null,null,"TK-TOKELAU"]
[null,null,null,null,null,null,"TO-TONGA"]
[null,null,null,null,null,null,"TT-TRINIDAD I TOBAGO"]
[null,null,null,null,null,null,"TN-TUNIS"]
[null,null,null,null,null,null,"TM-TURKMENISTAN"]
[null,null,null,null,null,null,"TR-TURSKA"]
[null,null,null,null,null,null,"TV-TUVALU"]
[null,null,null,null,null,null,"UG-UGANDA"]
[null,null,null,null,null,null,"UM-UJEDINJENE DRZ. MANJIH PACIFICKIH OTOKA"]
[null,null,null,null,null,null,"AE-UJEDINJENI ARAPSKI EMIRATI"]
[null,null,null,null,null,null,"UA-UKRAJINA"]
[null,null,null,null,null,null,"UY-URUGVAJ"]
[null,null,null,null,null,null,"UZ-UZBEKISTAN"]
[null,null,null,null,null,null,"VU-VANUATU"]
[null,null,null,null,null,null,"GB-VELIKA BRITANIJA"]
[null,null,null,null,null,null,"VE-VENEZUELA, BOLIVARIJANSKA REPUBLIKA"]
[null,null,null,null,null,null,"VN-VIJETNAM"]
[null,null,null,null,null,null,"WF-WALLIS I FUTUNA"]
[null,null,null,null,null,null,"ZM-ZAMBIJA"]
[null,null,null,null,null,null,"EH-ZAPADNA SAHARA"]
[null,null,null,null,null,null,"CV-ZELENORTSKA REPUBLIKA"]
[null,null,null,null,null,null,"ZW-ZIMBABVE"]