{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Abschlüsse","Hilfe zu den Listenfeldern","Allgemeine Informationen","Änderungshistorie","Data"],"not_rendered":{"macros":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Abschlüsse","index":0,"n_rows":11,"n_cols":38,"rows_kept":11,"merged":[[0,0,0,2],[0,3,0,17],[0,18,0,25],[0,26,0,33]]}
["Stornoangaben",null,null,"Angaben zum Versicherungsnehmer",{"$nulls":14},"Angaben zum ausländischen Versicherungsunternehmen (Nicht ausfüllen in Stornozeilen oder wenn die mitteilende Stelle ein Versicherungsunternehmen ist)",{"$nulls":7},"Angaben zur Versicherung (Nicht ausfüllen in Stornozeilen)"]
["Storno *","Antragsnummer (*)","Zeilennummer (*)","Rechtsform *","Identifikationsnummer","Name/Bezeichnung (*)","Titel","Namensvorsatz","Namenszusatz","Vorname (*)","Geburtsdatum (*)","Adresszusatz","Strasse (*)","Hausnr","Zusatz","Postleitzahl (*)","Ort (*)","Staat (*)","Firma (*)","Adresszusatz","Strasse","Hausnr","Zusatz","Postleitzahl","Ort (*)","Staat (*)","Vertragskennzeichen (*)","Art der Versicherungssummenangabe (*)","Betrag (*)","Waehrung (*)","Versicherungsbeginn (*)","Laufzeittyp (*)","Versicherungsende (*)","Vertragsqualifizierung (*)","Importmeldung","","",""]
[{"$nulls":8},""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":8},""]
[{"$nulls":6},"",null,""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","",""]
[{"$nulls":6},"","","",{"$nulls":20},"","","",""]

{"sheet":"Hilfe zu den Listenfeldern","index":1,"n_rows":699,"n_cols":2,"rows_kept":699,"merged":[[0,0,0,1],[2,0,2,1],[4,0,4,1],[5,0,5,1],[8,0,8,1],[10,0,10,1],[11,0,11,1],[15,0,15,1],[16,0,16,1],[273,0,273,1],[274,0,274,1],[529,0,529,1],[530,0,530,1]]}
["Hilfe zu den Listenfeldern"]
[]
["Auf dieser Seite finden Sie hilfreiche Erläuterungen zu den Listenfeldern der Abschlüsse der Mitteilung über kapitalbildende Lebensversicherungsverträge nach § 45 d Absatz 3 Einkommensteuergesetz (EStG)."]
[]
["Storno"]
["Zulässige Angaben: "]
["Ja","Kennzeichnet die Zeile als Stornozeile."]
["Nein","Kennzeichnet die Zeile als Normalzeile."]
["Bitte beachten Sie den Hinweis zu Stornozeilen im Arbeitsblatt \"Änderungshistorie\""]
[]
["Rechtsform"]
["Zulässige Angaben: "]
["01","Natürliche Person"]
["99","Juristische Person"]
[]
["Staat des Versicherungsnehmers"]
["Zulässige Angaben: "]
["Kürzel","Land"]
["AD","Andorra                                                  "]
["AE","Vereinigte Arabische Emirate                               "]
["AF","Afghanistan                                                "]
["AG","Antigua und Barbuda                                       "]
["AI","Anguilla                                                "]
["AL","Albanien                                                 "]
["AM","Armenien                                                 "]
["AN","Niederländische Antillen                                   "]
["AO","Angola                                                   "]
["AQ","Antarktis                                                 "]
["AR","Argentinien                                                "]
["AS","Amerikanisch Samoa                                      "]
["AT","Österreich                                              "]
["AU","Australien                                                 "]
["AW","Aruba                                                   "]
["AX","Aland Inseln"]
["AZ","Aserbaidschan                                            "]
["BA","Bosnien und Herzegowina                                 "]
["BB","Barbados                                                "]
["BD","Bangladesch                                                "]
["BE","Belgien                                                 "]
["BF","Burkina Faso                                               "]
["BG","Bulgarien                                                  "]
["BH","Bahrain                                                  "]
["BI","Burundi                                                  "]
["BJ","Benin                                                    "]
["BL","Saint Barthélemy"]
["BM","Bermuda                                                    "]
["BN","Brunei                                                   "]
["BO","Bolivien                                                   "]
["BQ","Bonaire, Saba und Sint Eustatius"]
["BR","Brasilien                                                  "]
["BS","Bahamas                                                 "]
["BT","Bhutan                                                     "]
["BV","Bouvet Insel                                              "]
["BW","Botsuana                                                   "]
["BY","Belarus (Weissrussland)                                  "]
["BZ","Belize                                                   "]
["CA","Kanada                                                     "]
["CC","Cocos (Keeling) Inseln                                  "]
["CD","Democratic Republic Congo                               "]
["CF","Zentralafrikanische Republik                               "]
["CG","Kongo                                                    "]
["CH","Schweiz                                                 "]
["CI","Cote d' Ivoire                                          "]
["CK","Cook Inseln                                             "]
["CL","Chile                                                      "]
["CM","Kamerun                                                 "]
["CN","VR China                                                   "]
["CO","Kolumbien                                                  "]
["CR","Costa Rica                                                 "]
["CU","Kuba                                                       "]
["CV","Kap Verde                                                "]
["CW","Curacao"]
["CX","Weihnachtsinsel"]
["CY","Zypern                                                   "]
["CZ","Tschechische Republik                                   "]
["DE","Deutschland                                             "]
["DJ","Djibouti                                                  "]
["DK","Dänemark                                                "]
["DM","Dominica                                                "]
["DO","Dominikanische Rep.                                        "]
["DZ","Algerien                                                   "]
["EC","Ecuador                                                    "]
["EE","Estland                                                  "]
["EG","Ägypten                                                    "]
["EH","Westsahara"]
["ER","Eritrea                                                  "]
["ES","Spanien                                                 "]
["ET","Äthiopien                                                  "]
["FI","Finnland                                                "]
["FJ","Fidschi                                                  "]
["FK","Falklandinseln                                            "]
["FM","Föderierte Staaten Mikronesien                          "]
["FO","Färöer                                                    "]
["FR","Frankreich                                              "]
["GA","Gabun                                                    "]
["GB","Vereinigtes Königreich                                  "]
["GD","Grenada                                                    "]
["GE","Georgien                                                 "]
["GF","Französisch Guyana                                      "]
["GG","Guernsey                                                 "]
["GH","Ghana                                                      "]
["GI","Gibraltar                                               "]
["GL","Grönland                                                  "]
["GM","Gambia                                                     "]
["GN","Guinea                                                  "]
["GP","Guadeloupe                                              "]
["GQ","Äquatorial-Guinea                                         "]
["GR","Griechenland                                            "]
["GS","South Georgia and the South Sandwich Islands            "]
["GT","Guatemala                                                  "]
["GU","Guam                                                      "]
["GW","Guinea-Bissau                                             "]
["GY","Guyana                                                  "]
["HK","Hongkong                                                   "]
["HM","Heard Island and Mcdonald Islands                       "]
["HN","Honduras                                                 "]
["HR","Kroatien                                                "]
["HT","Haiti                                                      "]
["HU","Ungarn                                                   "]
["IC","Kanarische Inseln"]
["ID","Indonesien                                                 "]
["IE","Irland                                                  "]
["IL","Israel                                                     "]
["IM","Isle of Man                                              "]
["IN","Indien                                                     "]
["IO","Brit. Gebiet Ind. Ozean                                   "]
["IQ","Irak                                                     "]
["IR","Islamische Republik Iran                                   "]
["IS","Island                                                   "]
["IT","Italien                                                 "]
["JE","Jersey                                                   "]
["JM","Jamaika                                                  "]
["JO","Jordanien                                                "]
["JP","Japan                                                      "]
["KE","Kenia                                                      "]
["KG","Kirgisistan                                             "]
["KH","Kambodscha                                               "]
["KI","Kiribati                                                  "]
["KM","Komoren                                                  "]
["KN","Saint Kitts and Nevis                                   "]
["KP","Korea Demokr. Volksrep.                                    "]
["KR","Korea, Republik                                            "]
["KW","Kuwait                                                     "]
["KY","Kaimaninseln                                               "]
["KZ","Kasachstan                                              "]
["LA","Demokratische Volksrepublik Laos                           "]
["LB","Libanon                                                    "]
["LC","Saint Lucia                                             "]
["LI","Liechtenstein                                           "]
["LK","Sri Lanka                                                "]
["LR","Liberia                                                    "]
["LS","Lesotho                                                    "]
["LT","Litauen                                                  "]
["LU","Luxemburg                                               "]
["LV","Lettland                                                 "]
["LY","Libyen                                                   "]
["MA","Marokko                                                    "]
["MC","Monaco                                                  "]
["MD","Moldau                                                   "]
["ME","Montenegro"]
["MF","Saint Martin"]
["MG","Madagaskar                                              "]
["MH","Marshall-Inseln                                           "]
["MK","Mazedonien                                              "]
["ML","Mali                                                       "]
["MM","Myanmar                                                  "]
["MN","Mongolei                                                   "]
["MO","Macau                                                    "]
["MP","Northern Mariana Islands                                "]
["MQ","Martinique                                              "]
["MR","Mauretanien                                                "]
["MS","Montserrat                                              "]
["MT","Malta                                                    "]
["MU","Mauritius                                                "]
["MV","Malediven                                                  "]
["MW","Malawi                                                   "]
["MX","Mexiko                                                     "]
["MY","Malaysia                                                   "]
["MZ","Mosambik                                                 "]
["NA","Namibia                                                    "]
["NC","Neukaledonien                                           "]
["NE","Niger                                                   "]
["NF","Norfolk Island                                          "]
["NG","Nigeria                                                    "]
["NI","Nicaragua                                                  "]
["NL","Niederlande                                             "]
["NM","Sint Maarten (Niederländisches Gebiet)"]
["NO","Norwegen                                                "]
["NP","Nepal                                                      "]
["NR","Nauru                                                     "]
["NU","Niue                                                    "]
["NZ","Neuseeland                                                 "]
["OM","Oman                                                       "]
["PA","Panama                                                     "]
["PE","Peru                                                       "]
["PF","Franz.-Polynesien                                         "]
["PG","Papua-Neuguinea                                         "]
["PH","Philippinen                                                "]
["PK","Pakistan                                                   "]
["PL","Polen                                                    "]
["PM","St. Pierre/Miquelon                                     "]
["PN","Pitcairninseln                                          "]
["PR","Puerto Rico                                              "]
["PS","Palestinian Territory, occupied                         "]
["PT","Portugal                                                "]
["PW","Palau                                                   "]
["PY","Paraguay                                                   "]
["QA","Katar                                                      "]
["RE","Reunion                                                 "]
["RO","Rumänien                                                 "]
["RS","Serbien"]
["RU","Russische Föderation                                     "]
["RW","Ruanda                                                   "]
["SA","Königreich Saudi-Arabien                                 "]
["SB","Salomonen                                               "]
["SC","Seychellen                                               "]
["SD","Sudan                                                    "]
["SE","Schweden                                                "]
["SG","Singapur                                                   "]
["SH","St. Helena                                              "]
["SI","Slowenien                                               "]
["SJ","Svalbard und Jan Mayen"]
["SK","Slowakische Republik                                    "]
["SL","Sierra Leone                                               "]
["SM","San Marino                                                 "]
["SN","Senegal                                                    "]
["SO","Somalia                                                    "]
["SR","Suriname                                                   "]
["SS","Südsudan"]
["ST","Sao Tome/Principe                                       "]
["SV","El Salvador                                                "]
["SY","Syrien                                                     "]
["SZ","Swasiland                                                "]
["TC","Turks- U. Caicosinseln                                  "]
["TD","Tschad                                                     "]
["TF","French Southern Territories                             "]
["TG","Togo                                                       "]
["TH","Thailand                                                   "]
["TJ","Tadschikistan                                           "]
["TK","Tokelau                                                 "]
["TL","Timor-Leste                                             "]
["TM","Turkmenistan                                            "]
["TN","Tunesien                                                   "]
["TO","Tonga                                                   "]
["TR","Türkei                                                     "]
["TT","Trinidad und Tobago                                     "]
["TV","Tuvalu                                                  "]
["TW","Taiwan                                                     "]
["TZ","Tansania                                                 "]
["UA","Ukraine                                                  "]
["UG","Uganda                                                   "]
["UM","United States minor outlying Islands                    "]
["US","Vereinigte Staaten von Amerika                             "]
["UY","Uruguay                                                 "]
["UZ","Usbekistan                                              "]
["VA","Vatikanstadt                                               "]
["VC","St Vincent and the Grenadines                           "]
["VE","Venezuela                                                  "]
["VG","Britische Jungferninseln                                  "]
["VI","Amerikanische Jungferninseln                              "]
["VN","Vietnam                                                    "]
["VU","Vanuatu                                                 "]
["WF","Wallis/Futuna                                           "]
["WS","Samoa                                                      "]
["XI","Ceuta"]
["XJ","Melilla"]
["YE","Jemen                                                      "]
["YT","Mayotte                                                 "]
["ZA","Südafrika                                                  "]
["ZM","Sambia                                                  "]
["ZW","Simbabwe                                                   "]
[]
[]
["Staat des Versicherungsunternehmens"]
["Zulässige Angaben: "]
["Kürzel","Land"]
["AD","Andorra                                                  "]
["AE","Vereinigte Arabische Emirate                               "]
["AF","Afghanistan                                                "]
["AG","Antigua und Barbuda                                       "]
["AI","Anguilla                                                "]
["AL","Albanien                                                 "]
["AM","Armenien                                                 "]
["AN","Niederländische Antillen                                   "]
["AO","Angola                                                   "]
["AQ","Antarktis                                                 "]
["AR","Argentinien                                                "]
["AS","Amerikanisch Samoa                                      "]
["AT","Österreich                                              "]
["AU","Australien                                                 "]
["AW","Aruba                                                   "]
["AX","Aland Inseln"]
["AZ","Aserbaidschan                                            "]
["BA","Bosnien und Herzegowina                                 "]
["BB","Barbados                                                "]
["BD","Bangladesch                                                "]
["BE","Belgien                                                 "]
["BF","Burkina Faso                                               "]
["BG","Bulgarien                                                  "]
["BH","Bahrain                                                  "]
["BI","Burundi                                                  "]
["BJ","Benin                                                    "]
["BL","Saint Barthélemy"]
["BM","Bermuda                                                    "]
["BN","Brunei                                                   "]
["BO","Bolivien                                                   "]
["BQ","Bonaire, Saba und Sint Eustatius"]
["BR","Brasilien                                                  "]
["BS","Bahamas                                                 "]
["BT","Bhutan                                                     "]
["BV","Bouvet Insel                                              "]
["BW","Botsuana                                                   "]
["BY","Belarus (Weissrussland)                                  "]
["BZ","Belize                                                   "]
["CA","Kanada                                                     "]
["CC","Cocos (Keeling) Inseln                                  "]
["CD","Democratic Republic Congo                               "]
["CF","Zentralafrikanische Republik                               "]
["CG","Kongo                                                    "]
["CH","Schweiz                                                 "]
["CI","Cote d' Ivoire                                          "]
["CK","Cook Inseln                                             "]
["CL","Chile                                                      "]
["CM","Kamerun                                                 "]
["CN","VR China                                                   "]
["CO","Kolumbien                                                  "]
["CR","Costa Rica                                                 "]
["CU","Kuba                                                       "]
["CV","Kap Verde                                                "]
["CW","Curacao"]
["CX","Weihnachtsinsel"]
["CY","Zypern                                                   "]
["CZ","Tschechische Republik                                   "]
["DJ","Djibouti                                                  "]
["DK","Dänemark                                                "]
["DM","Dominica                                                "]
["DO","Dominikanische Rep.                                        "]
["DZ","Algerien                                                   "]
["EC","Ecuador                                                    "]
["EE","Estland                                                  "]
["EG","Ägypten                                                    "]
["EH","Westsahara"]
["ER","Eritrea                                                  "]
["ES","Spanien                                                 "]
["ET","Äthiopien                                                  "]
["FI","Finnland                                                "]
["FJ","Fidschi                                                  "]
["FK","Falklandinseln                                            "]
["FM","Föderierte Staaten Mikronesien                          "]
["FO","Färöer                                                    "]
["FR","Frankreich                                              "]
["GA","Gabun                                                    "]
["GB","Vereinigtes Königreich                                  "]
["GD","Grenada                                                    "]
["GE","Georgien                                                 "]
["GF","Französisch Guyana                                      "]
["GG","Guernsey                                                 "]
["GH","Ghana                                                      "]
["GI","Gibraltar                                               "]
["GL","Grönland                                                  "]
["GM","Gambia                                                     "]
["GN","Guinea                                                  "]
["GP","Guadeloupe                                              "]
["GQ","Äquatorial-Guinea                                         "]
["GR","Griechenland                                            "]
["GS","South Georgia and the South Sandwich Islands            "]
["GT","Guatemala                                                  "]
["GU","Guam                                                      "]
["GW","Guinea-Bissau                                             "]
["GY","Guyana                                                  "]
["HK","Hongkong                                                   "]
["HM","Heard Island and Mcdonald Islands                       "]
["HN","Honduras                                                 "]
["HR","Kroatien                                                "]
["HT","Haiti                                                      "]
["HU","Ungarn                                                   "]
["IC","Kanarische Inseln"]
["ID","Indonesien                                                 "]
["IE","Irland                                                  "]
["IL","Israel                                                     "]
["IM","Isle of Man                                              "]
["IN","Indien                                                     "]
["IO","Brit. Gebiet Ind. Ozean                                   "]
["IQ","Irak                                                     "]
["IR","Islamische Republik Iran                                   "]
["IS","Island                                                   "]
["IT","Italien                                                 "]
["JE","Jersey                                                   "]
["JM","Jamaika                                                  "]
["JO","Jordanien                                                "]
["JP","Japan                                                      "]
["KE","Kenia                                                      "]
["KG","Kirgisistan                                             "]
["KH","Kambodscha                                               "]
["KI","Kiribati                                                  "]
["KM","Komoren                                                  "]
["KN","Saint Kitts and Nevis                                   "]
["KP","Korea Demokr. Volksrep.                                    "]
["KR","Korea, Republik                                            "]
["KW","Kuwait                                                     "]
["KY","Kaimaninseln                                               "]
["KZ","Kasachstan                                              "]
["LA","Demokratische Volksrepublik Laos                           "]
["LB","Libanon                                                    "]
["LC","Saint Lucia                                             "]
["LI","Liechtenstein                                           "]
["LK","Sri Lanka                                                "]
["LR","Liberia                                                    "]
["LS","Lesotho                                                    "]
["LT","Litauen                                                  "]
["LU","Luxemburg                                               "]
["LV","Lettland                                                 "]
["LY","Libyen                                                   "]
["MA","Marokko                                                    "]
["MC","Monaco                                                  "]
["MD","Moldau                                                   "]
["ME","Montenegro"]
["MF","Saint Martin"]
["MG","Madagaskar                                              "]
["MH","Marshall-Inseln                                           "]
["MK","Mazedonien                                              "]
["ML","Mali                                                       "]
["MM","Myanmar                                                  "]
["MN","Mongolei                                                   "]
["MO","Macau                                                    "]
["MP","Northern Mariana Islands                                "]
["MQ","Martinique                                              "]
["MR","Mauretanien                                                "]
["MS","Montserrat                                              "]
["MT","Malta                                                    "]
["MU","Mauritius                                                "]
["MV","Malediven                                                  "]
["MW","Malawi                                                   "]
["MX","Mexiko                                                     "]
["MY","Malaysia                                                   "]
["MZ","Mosambik                                                 "]
["NA","Namibia                                                    "]
["NC","Neukaledonien                                           "]
["NE","Niger                                                   "]
["NF","Norfolk Island                                          "]
["NG","Nigeria                                                    "]
["NI","Nicaragua                                                  "]
["NL","Niederlande                                             "]
["NM","Sint Maarten (Niederländisches Gebiet)"]
["NO","Norwegen                                                "]
["NP","Nepal                                                      "]
["NR","Nauru                                                     "]
["NU","Niue                                                    "]
["NZ","Neuseeland                                                 "]
["OM","Oman                                                       "]
["PA","Panama                                                     "]
["PE","Peru                                                       "]
["PF","Franz.-Polynesien                                         "]
["PG","Papua-Neuguinea                                         "]
["PH","Philippinen                                                "]
["PK","Pakistan                                                   "]
["PL","Polen                                                    "]
["PM","St. Pierre/Miquelon                                     "]
["PN","Pitcairninseln                                          "]
["PR","Puerto Rico                                              "]
["PS","Palestinian Territory, occupied                         "]
["PT","Portugal                                                "]
["PW","Palau                                                   "]
["PY","Paraguay                                                   "]
["QA","Katar                                                      "]
["RE","Reunion                                                 "]
["RO","Rumänien                                                 "]
["RS","Serbien"]
["RU","Russische Föderation                                     "]
["RW","Ruanda                                                   "]
["SA","Königreich Saudi-Arabien                                 "]
["SB","Salomonen                                               "]
["SC","Seychellen                                               "]
["SD","Sudan                                                    "]
["SE","Schweden                                                "]
["SG","Singapur                                                   "]
["SH","St. Helena                                              "]
["SI","Slowenien                                               "]
["SJ","Svalbard und Jan Mayen"]
["SK","Slowakische Republik                                    "]
["SL","Sierra Leone                                               "]
["SM","San Marino                                                 "]
["SN","Senegal                                                    "]
["SO","Somalia                                                    "]
["SR","Suriname                                                   "]
["SS","Südsudan                                   "]
["ST","Sao Tome/Principe                                       "]
["SV","El Salvador                                                "]
["SY","Syrien                                                     "]
["SZ","Swasiland                                                "]
["TC","Turks- U. Caicosinseln                                  "]
["TD","Tschad                                                     "]
["TF","French Southern Territories                             "]
["TG","Togo                                                       "]
["TH","Thailand                                                   "]
["TJ","Tadschikistan                                           "]
["TK","Tokelau                                                 "]
["TL","Timor-Leste                                             "]
["TM","Turkmenistan                                            "]
["TN","Tunesien                                                   "]
["TO","Tonga                                                   "]
["TR","Türkei                                                     "]
["TT","Trinidad und Tobago                                     "]
["TV","Tuvalu                                                  "]
["TW","Taiwan                                                     "]
["TZ","Tansania                                                 "]
["UA","Ukraine                                                  "]
["UG","Uganda                                                   "]
["UM","United States minor outlying Islands                    "]
["US","Vereinigte Staaten von Amerika                             "]
["UY","Uruguay                                                 "]
["UZ","Usbekistan                                              "]
["VA","Vatikanstadt                                               "]
["VC","St Vincent and the Grenadines                           "]
["VE","Venezuela                                                  "]
["VG","Britische Jungferninseln                                  "]
["VI","Amerikanische Jungferninseln                              "]
["VN","Vietnam                                                    "]
["VU","Vanuatu                                                 "]
["WF","Wallis/Futuna                                           "]
["WS","Samoa                                                      "]
["XI","Ceuta"]
["XJ","Melilla"]
["YE","Jemen                                                      "]
["YT","Mayotte                                                 "]
["ZA","Südafrika                                                  "]
["ZM","Sambia                                                  "]
["ZW","Simbabwe                                                   "]
[]
["Währung"]
["Zulässige Angaben: "]
["Kürzel","Land"]
["AED","United Arab Emirates, Dirhams"]
["AFN","Afghanistan, Afghanis"]
["ALL","Albania, Leke"]
["AMD","Armenia, Drams"]
["ANG","Netherlands Antilles, Guilders"]
["AOA","Angola, Kwanza"]
["ARS","Argentina, Pesos"]
["AUD","Australia, Dollars"]
["AWG","Aruba, Guilders"]
["AZN","Azerbaijan, Manats"]
["BAM","Bosnia and Herzegovina, Convertible Marka"]
["BBD","Barbados, Dollars"]
["BDT","Bangladesh, Taka"]
["BGN","Bulgaria, Leva"]
["BHD","Bahrain, Dinars"]
["BIF","Burundi, Francs"]
["BMD","Bermuda, Dollars"]
["BND","Brunei Darussalam, Dollars"]
["BOB","Bolivia, Bolivianos"]
["BOV","Bolivia, Mvdol"]
["BRL","Brazil, Brazil Real"]
["BSD","Bahamas, Dollars"]
["BTN","Bhutan, Ngultrum"]
["BWP","Botswana, Pulas"]
["BYR","Belarus, Rubles"]
["BZD","Belize, Dollars"]
["CAD","Canada, Dollars"]
["CDF","Congo/Kinshasa, Congolese Francs"]
["CHF","Switzerland, Francs"]
["CLF","Chile, Unidades de fomento"]
["CLP","Chile, Pesos"]
["CNY","China, Yuan Renminbi"]
["COP","Colombia, Pesos"]
["COU","Colombia, Unidad de Valor Real"]
["CRC","Costa Rica, Colones"]
["CUC","Cuba, Convertible Pesos"]
["CUP","Cuba, Pesos"]
["CVE","Cape Verde, Escudos"]
["CZK","Czech Republic, Koruny"]
["DJF","Djibouti, Francs"]
["DKK","Denmark, Kroner"]
["DOP","Dominican Republic, Pesos"]
["DZD","Algeria, Algeria Dinars"]
["EEK","Estonia, Krooni"]
["EGP","Egypt, Pounds"]
["ERN","Eritrea, Nakfa"]
["ETB","Ethiopia, Birr"]
["EUR","Euro Member Countries, Euro"]
["FJD","Fiji, Dollars"]
["FKP","Falkland Islands (Malvinas), Pounds"]
["GBP","United Kingdom, Pounds"]
["GEL","Georgia, Lari"]
["GHS","Ghana, Cedis"]
["GIP","Gibraltar, Pounds"]
["GMD","Gambia, Dalasi"]
["GNF","Guinea, Francs"]
["GTQ","Guatemala, Quetzales"]
["GWP","Guinea-Bissau Peso"]
["GYD","Guyana, Dollars"]
["HKD","Hong Kong, Dollars"]
["HNL","Honduras, Lempiras"]
["HRK","Croatia, Kuna"]
["HTG","Haiti, Gourdes"]
["HUF","Hungary, Forint"]
["IDR","Indonesia, Rupiahs"]
["ILS","Israel, New Shekels"]
["INR","India, Rupees"]
["IQD","Iraq, Dinars"]
["IRR","Iran, Rials"]
["ISK","Iceland, Kronur"]
["JMD","Jamaica, Dollars"]
["JOD","Jordan, Dinars"]
["JPY","Japan, Yen"]
["KES","Kenya, Shillings"]
["KGS","Kyrgyzstan, Soms"]
["KHR","Cambodia, Riels"]
["KMF","Comoros, Francs"]
["KPW","Korea (North), Won"]
["KRW","Korea (South), Won"]
["KWD","Kuwait, Dinars"]
["KYD","Cayman Islands, Dollars"]
["KZT","Kazakstan, Tenge"]
["LAK","Laos, Kips"]
["LBP","Lebanon, Pounds"]
["LKR","Sri Lanka, Rupees"]
["LRD","Liberia, Dollars"]
["LSL","Lesotho, Maloti"]
["LTL","Lithuania, Litai"]
["LVL","Latvia, Lati"]
["LYD","Libya, Dinars"]
["MAD","Morocco, Dirhams"]
["MDL","Moldova, Lei"]
["MGA","Madagascar, Malagasy Ariary"]
["MKD","Macedonia, Denars"]
["MMK","Myanmar (Burma), Kyats"]
["MNT","Mongolia, Tugriks"]
["MOP","Macau, Patacas"]
["MRO","Mauritania, Ouguiyas"]
["MUR","Mauritius, Rupees"]
["MVR","Maldives (Maldive Islands), Rufiyaa"]
["MWK","Malawi, Kwachas"]
["MXN","Mexico, Pesos"]
["MXV","Mexico, Mexican Unidad de Inversion"]
["MYR","Malaysia, Ringgits"]
["MZN","Mozambique, Meticais"]
["NAD","Namibia, Dollars"]
["NGN","Nigeria, Nairas"]
["NIO","Nicaragua, Gold Cordobas"]
["NOK","Norway, Krone"]
["NPR","Nepal, Nepal Rupees"]
["NZD","New Zealand, Dollars"]
["OMR","Oman, Rials"]
["PAB","Panama, Balboa"]
["PEN","Peru, Nuevos Soles"]
["PGK","Papua New Guinea, Kina"]
["PHP","Philippines, Pesos"]
["PKR","Pakistan, Rupees"]
["PLN","Poland, Zlotych"]
["PYG","Paraguay, Guarani"]
["QAR","Qatar, Rials"]
["RON","Romania, New Lei"]
["RSD","Serbian Dinar"]
["RUB","Russia, Rubles"]
["RWF","Rwanda, Rwanda Francs"]
["SAR","Saudi Arabia, Riyals"]
["SBD","Solomon Islands, Dollars"]
["SCR","Seychelles, Rupees"]
["SDG","Sudan, Dinars"]
["SEK","Sweden, Kronor"]
["SGD","Singapore, Dollars"]
["SHP","Saint Helena, Pounds"]
["SLL","Sierra Leone, Leones"]
["SOS","Somalia, Shillings"]
["SRD","Suriname, Dollar"]
["SSP","South Sudan, Pounds"]
["STD","São Tome and Principe, Dobras"]
["SVC","El Salvador, Colones"]
["SYP","Syria, Pounds"]
["SZL","Swaziland, Emalangeni"]
["THB","Thailand, Baht"]
["TJS","Tajikistan, Somoni"]
["TMT","Turkmenistan, Manats"]
["TND","Tunisia, Dinars"]
["TOP","Tonga, Pa'anga"]
["TRY","Turkey, Liras"]
["TTD","Trinidad and Tobago, Dollars"]
["TVD","Tuvalu, Dollars"]
["TWD","Taiwan, New Dollars"]
["TZS","Tanzania, Shillings"]
["UAH","Ukraine, Hryvnia"]
["UGX","Uganda, Shillings"]
["USD","United States of America, Dollars"]
["UYU","Uruguay, Pesos"]
["UZS","Uzbekistan, Sums"]
["VEF","Venezuela, Bolivares"]
["VND","Viet Nam, Dong"]
["VUV","Vanuatu, Vatu"]
["WST","Samoa, Tala"]
["XAF","Communauté Financière Africaine BEAC, Francs"]
["XCD","East Caribbean Dollars"]
["XOF","Communauté Financière Africaine BCEAO, Francs"]
["XPD","Palladium Ounces"]
["XPF","Comptoirs Français du Pacifique Francs"]
["YER","Yemen, Rials"]
["ZAR","South Africa, Rand"]
["ZMK","Zambia, Kwacha"]
["ZWL","Zimbabwe, Zimbabwe Dollars"]

{"sheet":"Allgemeine Informationen","index":2,"n_rows":80,"n_cols":1,"rows_kept":80}
["Allgemeine Informationen"]
[]
["Auf dieser Seite finden Sie allgemeine Informationen zur Handhabung des vorliegenden Excelsheets. Weitere Informationen finden Sie im Benutzerleitfaden."]
[]
["Spalten, die mit einem Stern \"*\" gekennzeichnet sind, müssen ausgefüllt werden."]
["Spalten, die mit einem Stern in Klammern \"(*)\" gekennzeichnet sind, müssen je nach Ihren sonstigen Angaben ebenfalls ausgefüllt werden."]
[]
["Wichtiger Hinweis"]
[]
["Im Zusammenhang mit der Nutzung der Importfunktionalität macht das Bundeszentralamt für Steuern (BZSt) auf Folgendes aufmerksam: "]
[]
["1) Die Benutzung der Importfunktionalität erfolgt auf eigenes Risiko. Das BZSt schließt jegliche Haftung für unmittelbare und mittelbare Schäden aus, die den Antragstellern aufgrund der Benutzung dieser Funktionalität oder der Unfähigkeit, diese Funktionalität zu verwenden, entstehen, insbesondere für Datenverluste, Mehraufwendungen oder fehlerhafte Ergebnisse, entgangenen Gewinn, Betriebsunterbrechung, Verlust von geschäftlichen Informationen und sonstige finanzielle Verluste. "]
[]
["2) Das zur Vereinfachung des Datenimports vom BZSt bereitgestellte EMAK-Excel-Sheet für das Programm Microsoft Excel ist eine Serviceleistung des BZSt. Es wurde vom BZSt sorgfältig erstellt, getestet und wird den Antragstellern im reinen Ist-Zustand zur Verfügung gestellt. Aufgrund der Vielzahl verfügbarer Versionen des Programms Microsoft Excel wird das EMAK-Excel-Sheet ausschließlich in Versionen ab Excel 2010 unter Windows unterstützt. "]
[]
["Tipp: Die Version Ihrer Microsoft Excel-Installation finden Sie heraus, indem Sie das Menü \"?\" öffnen und dort auf \"Info\" klicken. "]
[]
[]
["Probleme bei der Validierung von Datumsfeldern"]
[]
["Problembeschreibung"]
["Wenn Sie trotz korrekter Datumseingabe beim Aufruf von \"Daten prüfen\" oder \"CSV Export\" eine Fehlermeldung erhalten, dass das eingegebene Datum ungültig ist, ist möglicherweise das Datumsformat Ihrer regionalen Einstellungen nicht auf TT.MM.JJJJ gesetzt. Diese Einstellung ist für die ordnungsgemäße Ausführung der Makros notwendig. "]
[]
["Problembehebung"]
["Um das Datumformat Ihrer regionalen Einstellungen zu ändern, führen Sie bitte folgende Schritte aus: "]
["1) Gehen Sie zu Start -> Einstellungen -> Systemsteuerung -> Regions- und Sprachoptionen."]
["2) Klicken Sie in der Registerkarte \"Regionale Einstellungen\" auf \"Anpassen...\"."]
["3) Wählen Sie die Registerkarte \"Datum\" aus."]
["4) Wählen Sie als Datumstrennzeichen den Punkt \".\"."]
["5) Wählen Sie im Feld \"Format\" für \"Kurzes Datumsformat\" den Wert \"TT.MM.JJJJ\" aus."]
["6) Bestätigen Sie mit \"OK\"."]
[]
[]
["Probleme beim Einfügen großer Zahlen"]
[]
["Problembeschreibung"]
["Wenn große Zahlen aus anderen Anwendungen per Copy&Paste in dieses Excel-Sheet übertragen werden, kann es passieren, dass die Formatierung der Zelle nachhaltig überschrieben wird. Sie können dies leicht daran erkennen, dass die Zahl nach dem Einfügen in der wissenschaftlichen Darstellung angezeigt wird und auch durch manuelles Editieren der Zelle nicht wieder korrigiert werden kann."]
[]
["Beispiel "]
["Das Einfügen der Zahl 4567123456789679 führt dazu, dass in der Zelle 4,56172E+15 angezeigt wird."]
[]
["Problembehebung"]
["Wenn die Formatierung einer oder mehrerer Zellen in Ihrem Excel-Sheet wie erläutert überschrieben wurde, können Sie dies korrigieren, indem Sie folgende Schritte durchführen: \n"]
["1. Durchführung einer Datenprüfung\nFühren Sie eine Datenprüfung durch, indem Sie auf den Knopf \"Daten prüfen\" klicken. Die betroffenen Felder werden hierdurch rot umrandet. "]
[]
["2. Formatierung aus unbeschädigten Zellen übernehmen"]
["Stellen Sie die Formatierung einer rot umrandeten Zelle wieder her, indem Sie die Inhalte einer nicht rot umrandeten Zelle aus der gleichen Spalte mit Copy&Paste in die beschädigte Zelle übertragen."]
["Wiederholen Sie dieses Vorgehen für alle rot umrandeten Zellen."]
[]
["Korrektes Vorgehen zum Kopieren von Werten aus anderen Anwendungen"]
["Die Formatierung der Zelle bleibt erhalten, wenn Sie Zahlen wie gewohnt im Zwischenspeicher ablegen (üblicherweise unter Verwendung des Tastaturkürzels [Strg] [C]) und beim Einfügen eine der folgenden Varianten ausführen:\n\nVariante 1:\n1) Fügen Sie die Daten aus der Zwischenablage mit [Strg] [V] in die Zielzelle ein.\n2) Die Schaltfläche \"Einfügen-Optionen\" wird nun direkt unter Ihrer eingefügten Auswahl angezeigt. Wenn Sie auf die Schaltfläche klicken, wird eine Liste angezeigt. Wählen Sie \"Formatierung der Zielzellen übernehmen\" aus."]
[]
["Variante 2:"]
["1) Mit dem Mauszeiger in die Zelle klicken\n2) Auf die rechte Maustaste klicken. Es öffnet sich das Kontextmenü.\n3) Wählen Sie aus dem Kontextmenü den Menüpunkt \"Inhalte einfügen\" aus.\n4) Entscheiden Sie sich in dem Fenster, das sich nun öffnet, für die Variante \"Einfügen als Text\" und klicken Sie abschließend auf den OK-Knopf. Die ursprüngliche Formatierung der Zelle bleibt erhalten und die Zahl wird korrekt angezeigt."]
[]
[]
["Problem abgeschnittener Tooltips"]
[]
["Problembeschreibung"]
["Bei bestimmten Systemeinstellungen werden Tooltips (Quick-Infos, Eingabemeldungen) unter Umständen nicht mehr vollständig angezeigt. Dieses Problem scheint nur bei systemweit erhöhter Textgröße aufzutreten. Manche Versionen von Windows 7 haben eine auf 125% erhöhte Textgröße voreingestellt."]
[]
["Problembehebung"]
["Um den in Windows verwendeten Schriftgrad zu ändern, führen Sie bitte folgende Schritte durch:"]
["1) Gehen Sie zu Start -> Systemsteuerung -> Anzeige."]
["2) Wählen Sie \"Kleiner - 100%\"."]
["3) Melden Sie sich von Windows ab und anschließend wieder an."]
["Bei Problemen mit der Lesbarkeit können Sie die Bildschirmlupe verwenden."]
[]
[]
["Problem Markierung der Zellen mit einem farbigen Dreieck"]
[]
["Problembeschreibung"]
["In bestimmten Excel-Versionen werden Zellen mit einem farbigen Dreieck markiert. Wenn man die Zelle selektiert, erscheint ein Ausrufezeichen-Symbol. Beim Klicken auf das Ausrufezeichen-Symbol wird einer der Hinweise \"Als Text gespeicherte Zahlen\" oder \"Datumswert mit nur zweistelliger Jahreszahl\" angezeigt. Diese Hinweise können ignoriert werden, da sie für die Bearbeitung der Importdaten unerheblich sind. Sie können die Anzeige dieser Hinweise aber auch wie nachfolgend beschrieben ausschalten. "]
[]
["Problembehebung"]
["Um die Markierung der Zellen mit einem farbigen Dreieck auszuschalten, führen Sie die folgenden Schritte aus:"]
["1) Selektieren Sie eine markierte Zelle und klicken Sie auf das angezeigte Ausrufezeichen-Symbol."]
["2) Wählen Sie aus der angezeigten Auswahlliste \"Optionen zu Fehlerüberprüfung...\" aus."]
["3) Wählen Sie die Kästchen \"Zahlen, die als Text formatiert sind oder denen ein Apostroph vorangestellt ist\" und \"Zellen, die zweistellige Jahreszahlen enthalten\" ab."]
["4) Bestätigen Sie mit einem Klick auf den \"OK\"-Button."]

{"sheet":"Änderungshistorie","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"merged":[[0,0,0,1],[2,0,2,1],[7,0,7,1],[17,0,17,1],[18,0,18,2],[21,0,21,2]]}
["Änderungshistorie"]
[]
["Aktuelle Versionsangaben:"]
["Version des vorliegenden Import-Excelsheets:","2.1.5"]
["Folgende Hauptversion der CSV-Schnittstelle wird unterstützt:","2"]
["Generiert durch Portalversion:","40"]
[]
["Änderungshistorie:"]
["Version des Import-Excelsheets","Unterstützte Hauptversion der CSV-Schnittstelle","Änderungen"]
["2.1.5",2,"Geburtsdatum des Versicherungsnehmers darf nicht vor 1900 liegen"]
["2.1.3",2,"Ergänzung der Währung Südsudanesisches Pfund"]
["2.1.2","2","Ergänzung des Staates Südsudan, Fehlerkorrekturen"]
["2.1.1","2","Umstellung des CSV-Formats."]
["2.1.0","2","Neue Spalte \"Namenszusatz\", Storno verfügbar"]
["1.1.0","1","Initialversion"]
["Versionen, die nur geringfügige Anpassungen ohne fachlichen Hintergrund beinhalten, werden hier nicht aufgeführt."]
[]
["Hinweis zu Stornozeilen:"]
["Sie haben seit Version 2.1.0 die Möglichkeit, gezielt einzelne Vertragsabschlüsse aus bereits dem BZSt übermittelten Meldungen wieder zu stornieren. Dazu können Sie in der Spalte \"Storno\" \"Ja\" auswählen, wodurch die aktuelle Zeile als Stornozeile ausgewiesen wird. Geben Sie zur Spezifikation des zu stornierenden Vertragsabschlusses die Antragsnummer des betreffenden Antrags und die entsprechende Zeilennummer innerhalb dieses Antrags in den Spalten \"Antragsnummer\" beziehungsweise \"Zeilennummer\" an. Darüber hinaus ist noch die Rechtsform des Versicherungsnehmers des zu stornierenden Abschlusses anzugeben sowie \"Name/Bezeichnung\" (bei juristischen Personen) beziehungsweise das \"Geburtsdatum\" (bei natürlichen Personen) zu ergänzen. Weitere Angaben sind nicht zulässig."]
[]
["Hinweis zur Umstellung des CSV-Formats:"]
["Die Umstellung des CSV-Formats erfolgt für Sie als Benutzer des Import-Excelshshets automatisch. Bei dieser Umstellung wird die Behandlung der Trennzeichen Komma (,) und Strichpunkt (;), sowie der Textbegrenzungszeichen Apostroph (') und Anführungsstriche (\") verändert. Wenn Sie Dateien importieren, die vor dieser Umstellung erzeugt wurden und diese Zeichen in den Feldwerten enthalten, überprüfen Sie bitte, ob diese korrekt importiert wurden. Durch diese Umstellung können Sie die genannten Zeichen jetzt auch innerhalb Ihrer Feldwerte verwenden, wenn sie nicht durch feldspezifische Regeln ausgeschlossen sind."]

{"sheet":"Data","index":4,"n_rows":254,"n_cols":8,"rows_kept":254,"hidden":true}
["storno","rechtsform","vnstaat","vustaat","artsumme","waehrung","laufzeittyp","vertragquali"]
["Ja","01","AD","AD","Gesamtbeitragssumme","AED","befristet","fondsgebunden"]
["Nein","99","AE","AE","Versicherungssumme","AFN","unbefristet","konventionell"]
[null,null,"AF","AF",null,"ALL",null,"vermögensverwaltend"]
[null,null,"AG","AG",null,"AMD"]
[null,null,"AI","AI",null,"ANG"]
[null,null,"AL","AL",null,"AOA"]
[null,null,"AM","AM",null,"ARS"]
[null,null,"AN","AN",null,"AUD"]
[null,null,"AO","AO",null,"AWG"]
[null,null,"AQ","AQ",null,"AZN"]
[null,null,"AR","AR",null,"BAM"]
[null,null,"AS","AS",null,"BBD"]
[null,null,"AT","AT",null,"BDT"]
[null,null,"AU","AU",null,"BGN"]
[null,null,"AW","AW",null,"BHD"]
[null,null,"AX","AX",null,"BIF"]
[null,null,"AZ","AZ",null,"BMD"]
[null,null,"BA","BA",null,"BND"]
[null,null,"BB","BB",null,"BOB"]
[null,null,"BD","BD",null,"BOV"]
[null,null,"BE","BE",null,"BRL"]
[null,null,"BF","BF",null,"BSD"]
[null,null,"BG","BG",null,"BTN"]
[null,null,"BH","BH",null,"BWP"]
[null,null,"BI","BI",null,"BYR"]
[null,null,"BJ","BJ",null,"BZD"]
[null,null,"BL","BL",null,"CAD"]
[null,null,"BM","BM",null,"CDF"]
[null,null,"BN","BN",null,"CHF"]
[null,null,"BO","BO",null,"CLF"]
[null,null,"BQ","BQ",null,"CLP"]
[null,null,"BR","BR",null,"CNY"]
[null,null,"BS","BS",null,"COP"]
[null,null,"BT","BT",null,"COU"]
[null,null,"BV","BV",null,"CRC"]
[null,null,"BW","BW",null,"CUC"]
[null,null,"BY","BY",null,"CUP"]
[null,null,"BZ","BZ",null,"CVE"]
[null,null,"CA","CA",null,"CZK"]
[null,null,"CC","CC",null,"DJF"]
[null,null,"CD","CD",null,"DKK"]
[null,null,"CF","CF",null,"DOP"]
[null,null,"CG","CG",null,"DZD"]
[null,null,"CH","CH",null,"EEK"]
[null,null,"CI","CI",null,"EGP"]
[null,null,"CK","CK",null,"ERN"]
[null,null,"CL","CL",null,"ETB"]
[null,null,"CM","CM",null,"EUR"]
[null,null,"CN","CN",null,"FJD"]
[null,null,"CO","CO",null,"FKP"]
[null,null,"CR","CR",null,"GBP"]
[null,null,"CU","CU",null,"GEL"]
[null,null,"CV","CV",null,"GHS"]
[null,null,"CW","CW",null,"GIP"]
[null,null,"CX","CX",null,"GMD"]
[null,null,"CY","CY",null,"GNF"]
[null,null,"CZ","CZ",null,"GTQ"]
[null,null,"DE","DJ",null,"GWP"]
[null,null,"DJ","DK",null,"GYD"]
[null,null,"DK","DM",null,"HKD"]
[null,null,"DM","DO",null,"HNL"]
[null,null,"DO","DZ",null,"HRK"]
[null,null,"DZ","EC",null,"HTG"]
[null,null,"EC","EE",null,"HUF"]
[null,null,"EE","EG",null,"IDR"]
[null,null,"EG","EH",null,"ILS"]
[null,null,"EH","ER",null,"INR"]
[null,null,"ER","ES",null,"IQD"]
[null,null,"ES","ET",null,"IRR"]
[null,null,"ET","FI",null,"ISK"]
[null,null,"FI","FJ",null,"JMD"]
[null,null,"FJ","FK",null,"JOD"]
[null,null,"FK","FM",null,"JPY"]
[null,null,"FM","FO",null,"KES"]
[null,null,"FO","FR",null,"KGS"]
[null,null,"FR","GA",null,"KHR"]
[null,null,"GA","GB",null,"KMF"]
[null,null,"GB","GD",null,"KPW"]
[null,null,"GD","GE",null,"KRW"]
[null,null,"GE","GF",null,"KWD"]
[null,null,"GF","GG",null,"KYD"]
[null,null,"GG","GH",null,"KZT"]
[null,null,"GH","GI",null,"LAK"]
[null,null,"GI","GL",null,"LBP"]
[null,null,"GL","GM",null,"LKR"]
[null,null,"GM","GN",null,"LRD"]
[null,null,"GN","GP",null,"LSL"]
[null,null,"GP","GQ",null,"LTL"]
[null,null,"GQ","GR",null,"LVL"]
[null,null,"GR","GS",null,"LYD"]
[null,null,"GS","GT",null,"MAD"]
[null,null,"GT","GU",null,"MDL"]
[null,null,"GU","GW",null,"MGA"]
[null,null,"GW","GY",null,"MKD"]
[null,null,"GY","HK",null,"MMK"]
[null,null,"HK","HM",null,"MNT"]
[null,null,"HM","HN",null,"MOP"]
[null,null,"HN","HR",null,"MRO"]
[null,null,"HR","HT",null,"MUR"]
[null,null,"HT","HU",null,"MVR"]
[null,null,"HU","ID",null,"MWK"]
[null,null,"ID","IC",null,"MXN"]
[null,null,"IC","IE",null,"MXV"]
[null,null,"IE","IL",null,"MYR"]
[null,null,"IL","IM",null,"MZN"]
[null,null,"IM","IN",null,"NAD"]
[null,null,"IN","IO",null,"NGN"]
[null,null,"IO","IQ",null,"NIO"]
[null,null,"IQ","IR",null,"NOK"]
[null,null,"IR","IS",null,"NPR"]
[null,null,"IS","IT",null,"NZD"]
[null,null,"IT","JE",null,"OMR"]
[null,null,"JE","JM",null,"PAB"]
[null,null,"JM","JO",null,"PEN"]
[null,null,"JO","JP",null,"PGK"]
[null,null,"JP","KE",null,"PHP"]
[null,null,"KE","KG",null,"PKR"]
[null,null,"KG","KH",null,"PLN"]
[null,null,"KH","KI",null,"PYG"]
[null,null,"KI","KM",null,"QAR"]
[null,null,"KM","KN",null,"RON"]
[null,null,"KN","KP",null,"RSD"]
[null,null,"KP","KR",null,"RUB"]
[null,null,"KR","KW",null,"RWF"]
[null,null,"KW","KY",null,"SAR"]
[null,null,"KY","KZ",null,"SBD"]
[null,null,"KZ","LA",null,"SCR"]
[null,null,"LA","LB",null,"SDG"]
[null,null,"LB","LC",null,"SEK"]
[null,null,"LC","LI",null,"SGD"]
[null,null,"LI","LK",null,"SHP"]
[null,null,"LK","LR",null,"SLL"]
[null,null,"LR","LS",null,"SOS"]
[null,null,"LS","LT",null,"SRD"]
[null,null,"LT","LU",null,"SSP"]
[null,null,"LU","LV",null,"STD"]
[null,null,"LV","LY",null,"SVC"]
[null,null,"LY","MA",null,"SYP"]
[null,null,"MA","MC",null,"SZL"]
[null,null,"MC","MD",null,"THB"]
[null,null,"MD","ME",null,"TJS"]
[null,null,"ME","MF",null,"TMT"]
[null,null,"MF","MG",null,"TND"]
[null,null,"MG","MH",null,"TOP"]
[null,null,"MH","MK",null,"TRY"]
[null,null,"MK","ML",null,"TTD"]
[null,null,"ML","MM",null,"TVD"]
[null,null,"MM","MN",null,"TWD"]
[null,null,"MN","MO",null,"TZS"]
[null,null,"MO","MP",null,"UAH"]
[null,null,"MP","MQ",null,"UGX"]
[null,null,"MQ","MR",null,"USD"]
[null,null,"MR","MS",null,"UYU"]
[null,null,"MS","MT",null,"UZS"]
[null,null,"MT","MU",null,"VEF"]
[null,null,"MU","MV",null,"VND"]
[null,null,"MV","MW",null,"VUV"]
[null,null,"MW","MX",null,"WST"]
[null,null,"MX","MY",null,"XAF"]
[null,null,"MY","MZ",null,"XCD"]
[null,null,"MZ","NA",null,"XOF"]
[null,null,"NA","NC",null,"XPD"]
[null,null,"NC","NE",null,"XPF"]
[null,null,"NE","NF",null,"YER"]
[null,null,"NF","NG",null,"ZAR"]
[null,null,"NG","NI",null,"ZMK"]
[null,null,"NI","NL",null,"ZWL"]
[null,null,"NL","NM"]
[null,null,"NM","NO"]
[null,null,"NO","NP"]
[null,null,"NP","NR"]
[null,null,"NR","NU"]
[null,null,"NU","NZ"]
[null,null,"NZ","OM"]
[null,null,"OM","PA"]
[null,null,"PA","PE"]
[null,null,"PE","PF"]
[null,null,"PF","PG"]
[null,null,"PG","PH"]
[null,null,"PH","PK"]
[null,null,"PK","PL"]
[null,null,"PL","PM"]
[null,null,"PM","PN"]
[null,null,"PN","PR"]
[null,null,"PR","PS"]
[null,null,"PS","PT"]
[null,null,"PT","PW"]
[null,null,"PW","PY"]
[null,null,"PY","QA"]
[null,null,"QA","RE"]
[null,null,"RE","RO"]
[null,null,"RO","RS"]
[null,null,"RS","RU"]
[null,null,"RU","RW"]
[null,null,"RW","SA"]
[null,null,"SA","SB"]
[null,null,"SB","SC"]
[null,null,"SC","SD"]
[null,null,"SD","SE"]
[null,null,"SE","SG"]
[null,null,"SG","SH"]
[null,null,"SH","SI"]
[null,null,"SI","SJ"]
[null,null,"SJ","SK"]
[null,null,"SK","SL"]
[null,null,"SL","SM"]
[null,null,"SM","SN"]
[null,null,"SN","SO"]
[null,null,"SO","SR"]
[null,null,"SR","SS"]
[null,null,"SS","ST"]
[null,null,"ST","SV"]
[null,null,"SV","SY"]
[null,null,"SY","SZ"]
[null,null,"SZ","TC"]
[null,null,"TC","TD"]
[null,null,"TD","TF"]
[null,null,"TF","TG"]
[null,null,"TG","TH"]
[null,null,"TH","TJ"]
[null,null,"TJ","TK"]
[null,null,"TK","TL"]
[null,null,"TL","TM"]
[null,null,"TM","TN"]
[null,null,"TN","TO"]
[null,null,"TO","TR"]
[null,null,"TR","TT"]
[null,null,"TT","TV"]
[null,null,"TV","TW"]
[null,null,"TW","TZ"]
[null,null,"TZ","UA"]
[null,null,"UA","UG"]
[null,null,"UG","UM"]
[null,null,"UM","US"]
[null,null,"US","UY"]
[null,null,"UY","UZ"]
[null,null,"UZ","VA"]
[null,null,"VA","VC"]
[null,null,"VC","VE"]
[null,null,"VE","VG"]
[null,null,"VG","VI"]
[null,null,"VI","VN"]
[null,null,"VN","VU"]
[null,null,"VU","WF"]
[null,null,"WF","WS"]
[null,null,"WS","XI"]
[null,null,"XI","XJ"]
[null,null,"XJ","YE"]
[null,null,"YE","YT"]
[null,null,"YT","ZA"]
[null,null,"ZA","ZM"]
[null,null,"ZM","ZW"]
[null,null,"ZW"]