{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Home","Ruleset","Examples","Postal Codes","Parameter"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":13,"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":"Home","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,8,24,10]]}
[]
[]
[]
[]
[]
[]
[]
["© 2010 by e-Consultance"]
["Norbert Eiglsperger"]
["Dr.-Böttcher-Straße 31",null,null,null,null,null,null,null,null,null,null,null,"Address-Format-Machine V1.0"]
["D-81245 München"]
["0049/175/2984383"]
["0043/68/110 622 322"]
["http://www.e-consultance.de"]
[]
[]
[]
[]
[]
[null,"Number or testcases included:",null,null,{"$f":"Examples!E1","v":40}]
[null,"Current Domestic Country",null,null,{"$f":"VLOOKUP(Parameter!B30,'Postal Codes'!A1:B257,2,FALSE)","v":"Austria"}]
[null,"Current max lines for labels",null,null,{"$f":"Parameter!B31","v":5}]
[null,"Maximim length per line",null,null,{"$f":"Parameter!B32","v":30},null,null,null,"By starting Tool you accept licence."]
[]
[]
[]
[]
[null,"Licence:"]
[null,"You may test this application as long as you want."]
[null,"You must not copy the basic approach of this software solution, nor copy the knowledge of addressformatting."]
[null,"For using this application within your private of business environment you need a proper licence, that can be"]
[null,"checked with an licence key. Without licence key, you can test the encluded examples, but cannot enter a"]
[null,"house number."]
[null,"Price and conditions of a licence is depending on the future use and additional implementation"]
[null,"support i.e. consulting contracts."]
[null,"Note: Housenumber cannot be changed without licence key."]

{"sheet":"Ruleset","index":1,"n_rows":589,"n_cols":14,"rows_kept":589,"cut":false,"hidden":true,"merged":[]}
["Default:"]
[0,null,null,null,null,null,null,null,null,null,null,null,"Reserved for Confidential"]
[1,"[Heading1]",null,null,null,null,null,null,null,null,null,null,1,"for addresse-Area (1-3"]
[2,"[Heading2]",null,null,null,null,null,null,null,null,null,null,2]
[3,"[Heading3]",null,null,null,null,null,null,null,null,null,null,3,"c/o line if available"]
[4,"[Street] ","\"o\"","[Number]","{","\"/\"","[Addr. Complement]","}",null,null,null,null,4,"Street"]
[5,"[City] ","\"o\"","[City Complement] ","\"o\"","[Zip code]",null,null,null,null,null,null,5,"City Complement Zip (as default international)"]
[6,"[Country]",null,null,null,null,null,null,null,null,null,null,6,"Country"]
[7,null,null,null,null,null,null,null,null,null,null,null,7,"sometimes used if we insert below street or City line (e.g. ZIP Code in GB)"]
[8,null,null,null,null,null,null,null,null,null,null,null,8,"not used yet"]
[9,null,null,null,null,null,null,null,null,null,null,null,9,"space to copy data"]
[]
[]
["//* GENERAL RULES HUMAN VS. COMPANY"]
[]
["// if human than insert human heading-part"]
["*"]
["0 check","[Human]",true]
[1,"[Salutary title]","\"o\"","[Profession title]"]
[2,"[Heading1]"]
[3,"[Profession name]"]
[]
["//* RULES FOR POST OFFICE BOX"]
[]
["// if po-box  is used replace line street (for human and companies), pobox has higher priority then street"]
["*"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"PO Box \"","[pobox]"]
["0 define","[Number]","\"\""]
[]
["// if po-box  is used and German speaking countries insert \"Postfach\" while replacing line 3"]
["Deutschland"]
["Österreich"]
["Schweiz"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"Postfach \"","[pobox]"]
[]
["// if po-box  is used and Iceland speaking Country insert \"Pósthólf \" while replacing line 3"]
["Island"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"Pósthólf \"","[pobox]"]
[]
["// if po-box  is used and Spain speaking Country insert \"Casilia \" while replacing line 3"]
["Chile"]
["Spanien"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"Casilia \"","[pobox]"]
[]
["// if po-box  is used and Portugeeze speaking Country insert \"Caixa Postal \" while replacing line 3"]
["Portugal"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"Caixa Postal \"","[pobox]"]
[]
["// if po-box  is used and french speaking Country insert \"….  \" while replacing line 3"]
["Frankreich"]
["Algerien"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"Boîte Postale \"","[pobox]"]
[]
["// if po-box  is used and Fidsche speaking Country insert \"GPO Box\" while replacing line 3"]
["Fidschi"]
["0 check","[pobox]","-\"\""]
["0 define","[street]","\"GPO Box \"","[pobox]"]
[]
["//* RULES REGARDING C/O LINE"]
[]
["// if co-line is used replace line 3 (for human and companies)"]
["*"]
["0 check","[c/o line]","-\"\""]
["3 replace","[c/o line]"]
[]
["//* RULES FOR HANDLING ZIP-CODE"]
[]
["// put ZIP Code left: Zip space  City space City Complement  (for Europe)"]
["Argentinien"]
["Belgien"]
["Brasilien"]
["Dänemark"]
["Chile"]
["China"]
["Deutschland"]
["Estland"]
["Färöer"]
["Finnland"]
["Frankreich"]
["Griechenland"]
["Grönland"]
["Island"]
["Isreal"]
["Italien"]
["Liechtenstein"]
["Litauen"]
["Luxemburg"]
["Malaysia"]
["Norwegen"]
["Österreich"]
["Portugal"]
["Rumänien"]
["Russische Föderation"]
["San Marino"]
["Schweden"]
["Schweiz"]
["Slowakei"]
["Spanien"]
["Tschechische Republik"]
["Türkei"]
["Ungarn"]
["Volksrepublik China"]
[5,"[Zip code]","\"o\"","[City] ","\"o\"","[City Complement] "]
[]
["// put ZIP Code left: Zip space  City comma space City Complement  (for Mexiko"]
["Mexiko"]
[5,"[Zip code]","\"o\"","[City] ","\", o\"","[City Complement] "]
[]
["// put ZIP Code after (right): : City space City Complement hyphen Zip"]
["Indien"]
["Pakistan"]
["Thailand"]
[5,"[City] ","\"o\"","[City Complement] ","\"-\"","[Zip code]"]
[]
["// put ZIP Code after (right): : City space City Complement space LV-hyphen Zip"]
["Lettland"]
[5,"[City] ","\"o\"","[City Complement] ","\"o\"","[Postal-Code]","\"-\"","[Zip code]"]
[]
[]
["// put ZIP Code after (right): : City comma space City Complement space Zip"]
["Cota Rica"]
["Vereinigte Staaten von Amerika"]
["Irland"]
["Taiwan"]
["5 replace","[City] ","{","\", o\"","[City Complement]","}","{","\"o\"","[Zip code]","}"]
[]
["// put ZIP Code after (right): : City space City Complement double space Zip"]
["Kanada"]
["Vereinigte Staaten von Amerika"]
["5 replace","[City] ","\", o\"","[City Complement]","\"n\"","[Zip code]"]
[]
["// put ZIP Code below (under) the City (and City Complement): To avoid another label line, the zip code will be moved behind the county name "]
["England"]
["Grossbritanien"]
["Ägypten"]
["Insel Alderney"]
["Insel Guernsey"]
["Insel Jersey"]
["Insel Man"]
["5 replace"," [City] ","\"o\"","[City Complement]"]
["6 replace","[Country]","\"o\"","[Zip code]"]
[]
["// put ZIP Code below (under) the City (and City Complement): To avoid another label line, the zip code will be moved before the county name "]
["Japan"]
["5 replace","[City Complement]","\", o\""," [City] "]
["6 replace","[Zip code]","\"o\"","[Country]"]
[]
["// put ZIP Code below (under) the City (and City Complement): To avoid another label line, the zip code will be moved behind the county name"]
["Brasilien"]
["5 replace"," [City] ","\" - \"","[City Complement]"]
["6 replace","[Country]","\"o\"","[Zip code]"]
[]
["// put ZIP Code below (under) the City (and City Complement): but before country (to avoid another line"]
["Südafrika"]
["5 replace"," [City] ","\"o\"","[City Complement]"]
["6 replace","[Zip code]","\"o\"","[Country]"]
[]
["// move City name out of ZIP line, to put it below. To avoid another line, behind the Country (for the moment)"]
["Ecuador"]
["5 replace","[Zip code]","\"o\"","[City Complement]"]
["6 replace","[Country]","\"o\""," [City] "]
[]
["//* RULES FOR ADRESS COMPLEMENT"]
[]
["// seperate Addr. Complement with comma"]
["Dänemark"]
["Philipinen"]
[4,"[Street] ","\"o\"","[Number]","{","\", o\"","[Addr. Complement]","}"]
[]
["// seperate Addr. Complement with space"]
["Italien"]
[4,"[Street] ","\"o\"","[Number]","{","\"o\"","[Addr. Complement]","}"]
[]
["//* RULES FOR NUMBER PLACING"]
["*"]
[]
["// Some Countries:  put house number in front of street"]
["Australien"]
["England"]
["Insel Alderney"]
["Insel Guernsey"]
["Insel Jersey"]
["Insel Man"]
["Frankreich"]
["Grossbritanien"]
["Irland"]
["Japan"]
["Kanada"]
["Luxenburg"]
["Malaysia"]
["Neuseeland"]
["Vereinigte Staaten von Amerika"]
["4 replace"," [Number]","\"o\"","[Street] ","{","\"/\"","[Addr. Complement]","}"]
[]
["//if no street exists put number after City line"]
["Österreich"]
["Deutschland"]
["0 check","[street]","\"\""]
["4 delete","[Number]"]
["5 add","\"o\""," [Number]"]
[]
["//* POSTAL CODES INSTEAD OF COUNTRY (out of date, but saves lines)"]
[]
["// Replace Country Name and insert Postal County Code before zip for D + A"]
["Österreich"]
["Deutschland"]
["0 check","[SenderCountry]","\"Österreich\"","\"Deutschland\""]
["6 delete","[Country]"]
["5 insert","[Postal-Code]","\"-\""]
[]
["// Replace Country Name and insert Postal County Code before zip for CH if confitential"]
["Schweiz"]
["0 check","[SenderCountry]","\"Österreich\"","\"Deutschland\"","\"Schweiz\""]
["0 check","[Confidential]",true]
["6 delete","[Country]"]
["5 insert","[Postal-Code]","\"-\""]
[]
["//* LOCAL FEATURES"]
[]
["//  if Hungary then move street line below Zip- and City line"]
["Ungarn"]
["99 copy","=4"]
["4 copy","=5"]
["5 copy","=9"]
["9 replace"]
[]
["// if WEST Bank or GAZA STREIFEN then add \"VIA ISRAEL\""]
["West Bank"]
["Gaza Streifen"]
["6 add","\"o\"","\"VIA ISRAEL\""]
[]
["// if some location in China then add \"VIA TAIWAN"]
["Pescadores Islands"]
["Quemoy"]
["Matsu"]
["Fischer-Inseln"]
["Penghu"]
["6 add","\"o\"","\"VIA TAIWAN\""]
[]
["//* GENERAL NUMBER OF LINE MANAGEMENT"]
[]
["// if number of lines > 5 and c/o line is empty, delete line 3, means heading 3 or profession name"]
["*"]
["0 check","numberoflines",">5"]
["0 check","[c/o line]","\"\""]
["3 replace"]
[]
["// if number of lines > 5 and c/o line is not empty, delete line 2 for non-human"]
["*"]
["0 check","number of lines",">5"]
["0 check","[human]",false]
["0 check","[c/o line]","-\"\""]
["2 replace"]
[]
["// if number of lines > 5 and c/o line is not empty, delete line 2 for human, but modify line 1"]
["*"]
["0 check","number of lines",">5"]
["0 check","[human]",true]
["0 check","[c/o line]","-\"\""]
["1 replace","[salutary title]","\"o\"","[heading 1]"]
["2 replace"]
[]
["//* CONFIDENTIAL"]
[]
["//: Deutschland, Österreich and Schweiz"]
[]
["// if \"confidential\"and lines full and human then \"confidential\" in line 1 and salutary titel  and heading in line 2"]
["Deutschland"]
["Österreich"]
["Schweiz"]
["0 check","[Confidential]",true]
["0 check","numberoflines","=5"]
["0 check","[Human]",{"$f":"1=1","v":true}]
["0 replace","[Confidential]"]
["1 replace","[Salutary title]","\"o\"","[Heading1]"]
["2 replace"]
[]
["// if \"confidential\" and lines are not full and human, then put \"Confitential\" in line 0 "]
["Deutschland"]
["Österreich"]
["Schweiz"]
["0 check","[Confidential]",true]
["0 check","numberoflines","<5"]
["0 check","[Human]",{"$f":"1=1","v":true}]
["0 replace","[Confidential]"]
[]
["// if \"confidential\" and used lines are full and company: move heading1 into line 2 and put \"Condifential\" in line 1 "]
["Deutschland"]
["Österreich"]
["Schweiz"]
["0 check","[Confidential]",true]
["0 check","numberoflines","=5"]
["0 check","[Human]",false]
["0 replace","[Confidential]"]
["1 replace","[Heading1]"]
["2 replace"]
[]
["// Replace Country Name and insert Postal County Code before zip for CH if confitential"]
["Schweiz"]
["0 check","[Confidential]",true]
["0 check","number of lines",{"$f":"\"=\"&Parameter!B31+1","v":"=6"}]
["6 delete","[Country]"]
["5 insert","[Postal-Code]","\"-\""]
[]
["//: other areas will work only with higher number of lines"]
[]
["// if \"confidential\" and used lines have space"]
["*"]
["0 check","[Country]","-\"Deutschland\""]
["0 check","[Country]","-\"Österreich\""]
["0 check","[Country]","-\"Schweiz\""]
["0 check","[Confidential]",true]
["0 check","numberoflines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 replace","[Confidential]"]
[]
["// if \"confidential\" and used lines have space (if we delete line 2)"]
["*"]
["0 check","[Country]","-\"Deutschland\""]
["0 check","[Country]","-\"Österreich\""]
["0 check","[Country]","-\"Schweiz\""]
["0 check","[Confidential]",true]
["0 check","[Line2]","-\"\""]
["0 check","numberoflines",{"$f":"\"=\"&Parameter!$B$31","v":"=5"}]
["0 replace","[Confidential]"]
["1 replace","[Salutary title]","\"o\"","[Heading1]"]
["2 replace"]
[]
["//* HANDLING OF ADDITIONAL LINES"]
[]
["//:if street is not unique, then move City in line above or delete it, and use City complement next to zip code"]
[]
["// Not unique street::replace City in Zip-Code line and let only [City complement] stay  (if you don´t have space to put the city into a seperate line)"]
["Österreich"]
["Deutschland"]
["0 check","[City Complement]","-\"\""]
["0 check","number of lines",{"$f":"\"=\"&Parameter!$B$31","v":"=5"}]
["5 delete","[City]"]
[]
["//  Not unique street: if street is empty (we have space)  then remove City in Zip-Code line and let only [City complement] stay  and insert City in line above "]
["Österreich"]
["Deutschland"]
["0 check","[City Complement]","-\"\""]
["0 check","[Street]","\"\""]
[4,"[City]"]
["5 delete","[City]"]
[]
["//  Not unique street: if less then 5 lines then to remove City in Zip-Code line and insert [City] in a separate line above  until so seperate if possible"]
["Österreich"]
["Deutschland"]
["0 check","[City Complement]","-\"\""]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Street] ","-\"\""]
["5 delete","[City]"]
["6 copy","=5"]
[5,"[City]"]
[]
["//: Different Countries"]
[]
["// if City Complement is text, then move \"village\" into line above ZIP-line and City, if is number, let it be behind City"]
["Tschechische Republik"]
["0 check","[City Complement]","-\"\""]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[City Complement]","-(isnumber)"]
["5 delete","[City Complement]"]
["7 copy","=6"]
["6 copy","=5"]
["5 replace","[City Complement]"]
["0 Ucase","[City]"]
[]
["// put ZIP Code below (under) the City (and City Complement): and above country"]
["Südafrika"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"},null,null,null,"// if possible move Zip code in a seperate line"]
["7 replace","[Country]"]
["6 replace","[Zip code]"]
[]
["// Move City Complement as Region into seperate line above (here Human and Company) if lines available"]
["Fidschi"]
["Philipienen"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"},null,null,null,"// if co line used, then 1,3,4,5,6,7 will be needed => may be more then 5, so don't do it"]
["1 replace","[Salutary title]","\"o\"","[Heading1]",null,null,"// Salutary Title is empty for Company so this line fits for Human and non Human"]
["2 replace"]
["5 delete","[City Complement]"]
["7 copy","=6"]
["6 copy","=5"]
["5 replace","[City Complement]"]
[]
["// Move Addr. Complement as add. Street Area (zone) into seperate line below street if lines available"]
["Fidschi"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Addr. Complement]","-\"\""]
["8 copy","=7"]
["7 copy","=6"]
["6 copy","=5"]
["4 delete","[Addr. Complement]","\"/\""]
["5 replace","[Addr. Complement]"]
[]
["// if there is at least one lines free, then move city complement in line above"]
["Neuseeland"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[City Complement]","-\"\""]
["7 copy","=6",null,null,null,null,null,null,null,null,null,null," Country line"]
["6 copy","=5",null,null,null,null,null,null,null,null,null,null," City line"]
["6 delete","[City Complement]",null,null,null,null,null,null,null,null,null,null," City line without City Complement"]
["5 replace","[City Complement]",null,null,null,null,null,null,null,null,null,null,"City Complement (Suburb) in line above"]
[]
["// Move Country Name in next line"]
["England"]
["Grossbritanien"]
["Insel Alderney"]
["Insel Guernsey"]
["Insel Jersey"]
["Insel Man"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["6 delete","[Country]"]
["7 add","[Country]"]
[]
["// Move City Complement in next line"]
["England"]
["Grossbritanien"]
["Insel Alderney"]
["Insel Guernsey"]
["Insel Jersey"]
["Insel Man"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[City Complement]","-\"\""]
["8 copy","=7"]
["7 copy","=6"]
["5 delete","[City Complement]"]
["6 replace","[City Complement]"]
[]
["// Move Addr Complement  (house name) into  line above street: number shall be empty"]
["England"]
["Grossbritanien"]
["Insel Alderney"]
["Insel Guernsey"]
["Insel Jersey"]
["Insel Man"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Addr. Complement]","-\"\""]
["9 copy","=8"]
["8 copy","=7"]
["7 copy","=6"]
["6 copy","=5"]
["5 copy","=4"]
["5 delete","[Addr. Complement]","\"/\""]
["4 replace","[Addr. Complement]"]
[]
["// Move Addr Complement  (zone) into  line below street"]
["Argentinien"]
["Kanada"]
["Japan"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Addr. Complement]","-\"\""]
["7 copy","=6"]
["6 copy","=5"]
["4 delete","[Addr. Complement]","\"/\""]
["5 replace","[Addr. Complement]"]
[]
["// Move Addr Complement  (zone) into  line below street"]
["*"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[line4]/len",{"$f":"\">\"&Parameter!$B$32","v":">30"}]
["0 check","[Country]","-\"Fidschi\""]
["9 copy","=8"]
["8 copy","=7"]
["7 copy","=6"]
["6 copy","=5"]
["4 delete","[Addr. Complement]","\"/\"","\", o\""]
["5 replace","[Addr. Complement]"]
[]
[]
["// use free line No 2 for humans to split salutary title with profession title from heading"]
["*"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Line2]","\"\""]
["0 check","[Human]","\"\""]
["1 replace","[Salutary title]","\"o\"","[Profession title]"]
["2 replace","[Heading 1]"]
[]
["// use free line No 2 for company to insert heading 2"]
["*"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Line2]","\"\""]
["0 check","[Human]","-\"\""]
["2 replace","[Heading 2]"]
[]
["// use free line No 3 for humans to re insert profession name"]
["*"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Line3]","\"\""]
["0 check","[Human]","-\"\""]
["3 replace","[profession name]"]
[]
["// use free line No 3 for company to insert heading 3"]
["*"]
["0 check","number of lines",{"$f":"\"<\"&Parameter!$B$31","v":"<5"}]
["0 check","[Line3]","\"\""]
["0 check","[Human]","\"\""]
["3 replace","[profession name]"]
[]
["//* LAYOUT FEATURES (NO MORE POSITIONING)"]
[]
["// make City uppercase"]
["Indien"]
["Pakistan"]
["Thailand"]
["Chile"]
["Japan"]
["0 Ucase ","[City] "]
[]
["//make Street, City and City Complement Uppercase"]
["Frankreich"]
["Luxenburg"]
["0 Ucase","[Country]"]
["0 Ucase","[City]"]
["0 Ucase","[City Complement]"]
["0 Ucase","[Street]"]
[]
["//make everything Ucase"]
["Australien"]
["Kanada"]
["0 Ucase","[Country]"]
["0 Ucase","[City]"]
["0 Ucase","[City Complement]"]
["0 Ucase","[Street]"]
["0 Ucase","[Addr. Complement]"]
["0 Ucase","[Number]"]
["0 Ucase","[Heading1]"]
["0 Ucase","[Heading2]"]
["0 Ucase","[Heading3]"]
["0 Ucase","[Salutary title]"]
["0 Ucase","[Profession title]"]
["0 Ucase","[profession name]"]
[]
[]
["// delete  add. optional attributes of human"]
["Australien"]
["1 delete","[Salutary title]"]
["1 delete","[Profession title]"]
["1 delete","[Profession name]"]
[]
["// remove Postal Code for domestic (independent where it is  (line 5 or 6 :-)"]
[{"$f":"Parameter!B30","v":"Österreich"}]
["5 delete","[Postal-Code]"]
["5 delete","\"-\""]
["6 delete","[Postal-Code]"]
["6 delete","\"-\""]
["7 delete","[Postal-Code]"]
["7 delete","\"-\""]
[]
["//make country always uppercase"]
["*"]
["0 Ucase","[Country]"]
[]
["// Fertig"]
["END"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"    "]

{"sheet":"Examples","index":2,"n_rows":656,"n_cols":8,"rows_kept":656,"cut":false,"hidden":false,"merged":[]}
["Data must be correct (for human non human), empty line to seperate Tcases",null,null,"#",{"$f":"MAX(D:D)","v":40},"Explanations and more informations"]
[null,"* Europa",null,0]
[null,null,null,{"$f":"IF(AND(A3<>\"\",A2=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":0}]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A5:B21,2,FALSE))),VLOOKUP(\"country=\",A5:B21,2,FALSE),VLOOKUP(\"[Country]=\",A5:B21,2,FALSE))","v":"Deutschland"},null,0]
["human=","ü",null,1]
["salutary title=","Herr",null,1]
["heading 1=","Max Mustermann",null,1]
["street=","Bayerwaldstraße",null,1]
["number=","13b",null,1]
["zip=",94360,null,1]
["city=","Mitterfels",null,1]
["country=","Deutschland",null,1]
[null,null,null,1]
["human=","ü",null,2]
["confidential=","ü",null,2]
["salutary title=","Herr",null,2]
["profession title=","Dipl.Ingenieur",null,2]
["heading 1=","Max Mann",null,2]
["c/oline=","wg. Maria Mann",null,2]
["number=",10,null,2]
["street=","Kirchenweg",null,2]
["city complement=","Scheibelsgrub ",null,2]
["zip=",94360,null,2]
["city=","Mitterfels",null,2]
["country=","Deutschland",null,2]
[null,null,null,2]
["human=","ü",null,3]
["confidential=","ü",null,3]
["salutary title=","Herr",null,3]
["heading 1=","Max Mustermann",null,3]
["number=",2,null,3]
["street=",null,null,3]
["city=","Mitterfels",null,3]
["city complement=","Dunk",null,3]
["zip=",94360,null,3]
["city=","Mitterfels",null,3]
["country=","Deutschland",null,3]
[null,null,null,3]
["human=","ü",null,4]
["salutary title=","Herr und Frau",null,4,null,null,"Dorfstraße in 24217 Bendfeld "]
["profession title=",null,null,4,null,null,"Dorfstraße in 24217 Fiefbergen "]
["heading 1=","Norbert und Maria Mustermeier",null,4,null,null,"Dorfstraße in 24217 Höhndorf "]
["heading 2=",null,null,4,null,null,"Dorfstraße in 24217 Krokau "]
["c/oline=","wg. Fricka Mustermann",null,4,null,null,"Dorfstraße in 24217 Stakendorf "]
["street=","Dorfstraße ",null,4,null,null,"Dorfstraße in 24217 Wisch "]
["addr.complement=","App. 446",null,4]
["number=",3,null,4]
["pobox=",null,null,4]
["city=","Schönberg (Holstein)",null,4]
["city complement=","Bendfeld",null,4]
["zip=","24217",null,4]
["country=","Deutschland",null,4]
[null,null,null,4]
["human=",null,null,5]
["salutary title=",null,null,5]
["profession title=",null,null,5]
["heading 1=","Malerbetrieb Dietrich Wulf",null,5]
["heading 2=",null,null,5]
["heading 3=",null,null,5]
["c/oline=","wg. Fricka Mustermann",null,5]
["street=",null,null,5]
["addr.complement=",null,null,5]
["number=",14,null,5]
["pobox=",null,null,5]
["city=","Rehlingen",null,5]
["city complement=","Diersbüttel",null,5]
["zip=",21385,null,{"$f":"IF(AND(A67<>\"\",A66=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":5}]
["country=","Deutschland",null,5]
[null,null,null,5]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A308:B342,2,FALSE))),VLOOKUP(\"country=\",A71:B97,2,FALSE),VLOOKUP(\"[Country]=\",A71:B97,2,FALSE))","v":"Österreich"},null,5]
["human=","ü",null,6]
["salutary title=","Frau",null,6]
["profession title=",null,null,6]
["heading 1=","Michaela Sommer",null,6]
["heading 2=",null,null,6]
["c/oline=",null,null,6]
["street=","Grünwaldweg",null,6]
["addr.complement=",null,null,6]
["number=",16,null,6]
["city=","Obersiebenbrunn",null,6]
["city complement=",null,null,6]
["zip=",2283,null,6]
["country=","Österreich",null,6]
[null,null,null,6]
["human=","ü",null,7]
["salutary title=","Frau",null,7]
["profession title=",null,null,7]
["heading 1=","Michaela Sommer",null,7]
["heading 2=",null,null,7]
["c/oline=",null,null,7]
["street=",null,null,7]
["addr.complement=",null,null,7]
["number=",null,null,7]
["pobox=",100,null,7]
["city=","Obersiebenbrunn",null,7]
["city complement=",null,null,7]
["zip=",2283,null,7]
["country=","Österreich",null,7]
[null,null,null,7]
["[confidential]=",null,null,8]
["[human]=","ü",null,8]
["[salutarytitle]=","Frau",null,8,null,1]
["[professiontitle]=",null,null,8,null,2]
["[professionname]=",null,null,8,null,3]
["[heading1]=","Mag. Maria Muster",null,8,null,4]
["[heading2]=",null,null,8,null,5]
["[heading3]=",null,null,8]
["[coline]=",null,null,8]
["[street]=","Gartenweg",null,8]
["[number]=",8,null,8]
["[addrcomplement]=",null,null,8]
["[pobox]=",null,null,8]
["[zip]=",3741,null,8]
["[city]=","Pulkau",null,8]
["[citycomplement]=","Rafing             ",null,8]
["[country]=","Österreich",null,8]
[null,null,null,8]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A119:B342,2,FALSE))),VLOOKUP(\"country=\",A119:B342,2,FALSE),VLOOKUP(\"[Country]=\",A119:B342,2,FALSE))","v":"Italien"},null,8]
["salutary title=",null,null,9]
["profession title=",null,null,9]
["heading 1=","UniCredit S.p.A.",null,9]
["heading 2=","Global Financial Institutions ",null,9]
["heading 3=","& Trade Finance",null,9]
["c/oline=","c/o Massimo Medici, Trade Fin.",null,9]
["street=","Via le Bodio",null,9]
["addr.complement=",null,null,9]
["number=","29 - B3",null,9]
["city=","Milano",null,9]
["city complement=",null,null,9]
["zip=","20123",null,9]
["country=","Italien",null,{"$f":"IF(AND(A131<>\"\",A130=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":9}]
[null,null,null,9]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A134:B150,2,FALSE))),VLOOKUP(\"country=\",A134:B150,2,FALSE),VLOOKUP(\"[Country]=\",A134:B150,2,FALSE))","v":"Frankreich"},null,9]
["heading 1=","Auberge Le d'Artagnan",null,10]
["c/oline=","A l'att. Mme Céline Guillaume",null,10]
["number=",80,null,10]
["street=","rue Vitruve",null,10]
["city=","Paris",null,10]
["zip=",75020,null,10]
["country=","Frankreich",null,10]
[null,null,null,10]
["heading 1=","Novotel Lyon Porte du Valvert",null,11]
["c/oline=","A l'att. Mme Céline Guillaume",null,11]
["number=","13D ",null,11]
["street=","avenue Victor Hugo",null,11]
["city=","Tassin la demi lune",null,11]
["zip=",69160,null,11]
["country=","Frankreich",null,11]
[null,null,null,11]
["heading 1=","LRV LY, au Four Seasons ",null,12]
["heading 2=","Hotel  G. V‎",null,12]
["c/oline=","A l'att. Mme Céline Guillaume",null,12]
["number=",31,null,12]
["street=","avenue George V",null,12]
["city=",75008,null,12]
["zip=","Paris",null,12]
["country=","Frankreich",null,12]
[null,null,null,12]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A160:B195,2,FALSE))),VLOOKUP(\"country=\",A160:B195,2,FALSE),VLOOKUP(\"[country]=\",A160:B195,2,FALSE))","v":"Grossbritanien"},null,12]
["human=","ü",null,13]
["salutary title=","Mr.",null,13]
["heading 1=","Charles Xample",null,13]
["c/oline=","at Xample Company",null,13]
["number=",16,null,13]
["street=","Xample Street",null,13]
["city=","London",null,13]
["zip=","SW1E 6LB",null,13]
["country=","Grossbritanien",null,13]
[null,null,null,13]
["confidential=","ü",null,14]
["heading 1=","Florence Nightingale Found-",null,14]
["heading 2=","ation of British Nurses",null,14]
["street=","The Inspire, Hornbeam Park",null,14]
["city=","Harrogate",null,14]
["zip="," HG2 8PA",null,14]
["country=","Grossbritanien",null,14]
[null,null,null,14]
["[confidential]=",null,null,15,null,"This is a test for more then 5 lines"]
["[human]=",null,null,15,null,0,"Confidential"]
["[salutarytitle]=",null,null,15,null,1,"heading 1"]
["[professiontitle]=",null,null,15,null,2,"heading 2"]
["[professionname]=",null,null,15,null,3,"c/o line or heading 3"]
["[heading1]=","Nildram Ltd",null,15,null,4,"Addr. Complement = house"]
["[heading2]=",null,null,15,null,5,"Street space number"]
["[heading3]=",null,null,15,null,6,"City"]
["[coline]=","Reservation c/o Mrs. Smith",null,15,null,7,"City Complement"]
["[street]=","Oxford Road",null,15,null,8,"ZIP-code"]
["[number]=","Ardenham Court",null,15,null,9,"Country"]
["[addrcomplement]=",null,null,15]
["[pobox]=",null,null,15]
["[city]=","Aylesbury",null,15]
["[citycomplement]=","Buckingshire",null,15,null,"County not needed, but available, put it in line below city (if possible)"]
["[zip]=","HP19 3EQ",null,15]
["[country]=","Grossbritanien",null,15]
[null,null,null,{"$f":"IF(AND(A195<>\"\",A194=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":15}]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A197:B232,2,FALSE))),VLOOKUP(\"country=\",A197:B232,2,FALSE),VLOOKUP(\"[country]=\",A197:B232,2,FALSE))","v":"Irland"},null,15]
["[confidential]=",null,null,16]
["[human]=",null,null,16]
["[salutarytitle]=",null,null,16]
["[professiontitle]=",null,null,16]
["[professionname]=",null,null,16]
["[heading1]=","The Avalon Hotel",null,16]
["[heading2]=",null,null,16]
["[heading3]=",null,null,16]
["[coline]=","Reservation c/o Mrs. Smith",null,16]
["[street]=","Burlingtoin Road",null,16]
["[number]=",223,null,16]
["[addrcomplement]=",null,null,16]
["[pobox]=",null,null,16]
["[city]=","Dublin",null,16]
["[citycomplement]=",null,null,16]
["[zip]=",2,null,16]
["[country]=","Irland",null,16]
[null,null,null,16]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A216:B251,2,FALSE))),VLOOKUP(\"country=\",A216:B251,2,FALSE),VLOOKUP(\"[country]=\",A216:B251,2,FALSE))","v":"Dänemark"},null,16]
["[confidential]=",null,null,17]
["[human]=","ü",null,17]
["[salutarytitle]=","Mr.",null,17]
["[professiontitle]=",null,null,17]
["[professionname]=",null,null,17]
["[heading1]=","Peter Mogensen",null,17]
["[heading2]=",null,null,17]
["[heading3]=",null,null,17]
["[coline]=","c/o Fictional Company ",null,17,null,"City optional will not be used"]
["[street]=","Niels Bohrs Alle",null,17]
["[number]=",23,null,17]
["[addrcomplement]=","1330 floor 13",null,17]
["[pobox]=",null,null,17]
["[city]=","Odense M",null,17]
["[citycomplement]=","Dalum                           ",null,17]
["[zip]=",5230,null,17]
["[country]=","Dänemark",null,17]
[null,null,null,17]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A235:B270,2,FALSE))),VLOOKUP(\"country=\",A235:B270,2,FALSE),VLOOKUP(\"[country]=\",A235:B270,2,FALSE))","v":"Tschechische Republik"},null,17]
["[confidential]=",null,null,18]
["[human]=",null,null,18]
["[salutarytitle]=",null,null,18]
["[professiontitle]=",null,null,18]
["[professionname]=",null,null,18]
["[heading1]=","Pan Martin Parma",null,18]
["[heading2]=",null,null,18]
["[heading3]=",null,null,18]
["[coline]=",null,null,18]
["[street]=","Prujezdna",null,18]
["[number]=","320/62",null,18]
["[pobox]=",null,null,18]
["[addrcomplement]=",null,null,18]
["[city]=","PRAHA",null,18]
["[citycomplement]=",10,null,18]
["[zip]=","100 00",null,18]
["[country]=","Tschechische Republik",null,18]
[null,null,null,18]
["[confidential]=",null,null,19]
["[human]=",null,null,19]
["[salutarytitle]=",null,null,19]
["[professiontitle]=",null,null,19]
["[professionname]=",null,null,19]
["[heading1]=","Pan Martin Parma",null,19]
["[heading2]=",null,null,{"$f":"IF(AND(A259<>\"\",A258=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":19}]
["[heading3]=",null,null,19]
["[coline]=",null,null,19]
["[street]=","Ladova",null,19]
["[number]=","3/64",null,19]
["[pobox]=",null,null,19]
["[addrcomplement]=",null,null,19]
["[city]=","SENOHRABY",null,19]
["[citycomplement]=","Hrusice",null,19]
["[zip]=","100 00",null,19]
["[country]=","Tschechische Republik",null,19]
[null,null,null,19]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A272:B288,2,FALSE))),VLOOKUP(\"country=\",A272:B288,2,FALSE),VLOOKUP(\"[Country]=\",A272:B288,2,FALSE))","v":"Ungarn"},null,19]
["[confidential]=",null,null,20]
["[human]=",null,null,20]
["[salutarytitle]=",null,null,20]
["[professiontitle]=",null,null,20]
["[professionname]=",null,null,20]
["[heading1]=","Univerzum-Expressz Kereskedelmi ",null,20]
["[heading2]=","és Fuvarozó Kft. Budapest ",null,20]
["[heading3]=",null,null,20]
["[coline]=",null,null,20]
["[number]=",24,null,20]
["[street]=","Szentmihályi út",null,20]
["[pobox]=",null,null,20]
["[addrcomplement]=","D",null,20]
["[city]=","Budapest",null,20]
["[citycomplement]=",null,null,20]
["[zip]=",1144,null,20]
["[country]=","Ungarn",null,20]
[null,null,null,20]
[null,"* Nordamerika",null,20]
[null,null,null,20]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A293:B309,2,FALSE))),VLOOKUP(\"country=\",A293:B309,2,FALSE),VLOOKUP(\"[Country]=\",A293:B309,2,FALSE))","v":"Vereinigte Staaten von Amerika"},null,20]
["heading 1=","Best Western Motel: Paradise",null,21]
["heading 2=","Inn and suites",null,21]
["c/oline=","Gold Card Service Dept.",null,21]
["number=","15691",null,21]
["street=","North Oracle Road",null,21]
["city=","Tucson",null,21]
["city complement=","AZ",null,21]
["zip=","85739-9111",null,21]
["country=","Vereinigte Staaten von Amerika",null,21]
[null,null,null,21]
["heading 1=","The Arizona Health Sc. Center",null,22]
["heading 2=","at the University of Arizona",null,22]
["c/oline="," c/o Mrs Johnson, Dept. Exhib.",null,22]
["number=","1120-1140",null,22]
["street=","Orwellcampus",null,22]
["addr.complement=","Building 712",null,22]
["city=","Tucson",null,22]
["city complement=","Pima, AZ",null,22]
["zip=","85721-0001",null,22]
["country=","Vereinigte Staaten von Amerika",null,22]
[null,null,null,22]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A315:B342,2,FALSE))),VLOOKUP(\"country=\",A315:B342,2,FALSE),VLOOKUP(\"[Country]=\",A315:B342,2,FALSE))","v":"Mexiko"},null,22]
["heading 1=","MAHÉKAL BEACH RESORT",null,23]
["heading 2=","Reservations",null,23]
["c/oline=","a Sra. Xochil Gordillo Morales",null,23]
["street=","Calle",null,23]
["addr.complement=","Norte con Zona Fed. Maritima",null,23]
["number=",38,null,23]
["city=","Playa del Carmen",null,23]
["city complement=","Quintana Roo",null,23]
["zip=","77710",null,{"$f":"IF(AND(A323<>\"\",A322=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":23}]
["country=","Mexiko",null,23]
["[confidential]=",null,null,23]
["[human]=","ü",null,23]
["[salutarytitle]=","Sra.",null,23]
["[professiontitle]=",null,null,23]
["[professionname]=",null,null,23]
["[heading1]=","Otilia Ramos Perez",null,23]
["[heading2]=",null,null,23]
["[heading3]=",null,null,23]
["[coline]=",null,null,23]
["[street]=","Urión ",null,23]
["[number]=",30,null,23]
["[addrcomplement]=","Col. Atlatilco",null,23]
["[pobox]=",null,null,23]
["[zip]=","02860",null,23]
["[city]=","Mexico",null,23]
["[citycomplement]=","D.F.",null,23]
["[country]=","Mexiko",null,23]
[null,null,null,23]
[null,"* Südamerika",null,23]
[null,null,null,23]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A346:B422,2,FALSE))),VLOOKUP(\"country=\",A346:B422,2,FALSE),VLOOKUP(\"[country]=\",A346:B422,2,FALSE))","v":"Argentinien"},null,23]
["[confidential]=","ü",null,24,null,"Result (Depending on number of lines)"]
["[human]=","ü",null,24,null,"0 Confidential",null,"Confidential"]
["[salutarytitle]=","Sn.",null,24,null,"1 salutary + pro title",null,"Sn. Ingeniero Diplomando"]
["[professiontitle]=","Ingeniero Diplomado",null,24,null,"2 heading 1"]
["[professionname]=",null,null,24,null,"3 c/o",null,"c/o Juana Aguirre"]
["[heading1]=","Prof. Carlo Francis Xavier",null,24,null,"4 Street number"]
["[heading2]=",null,null,24,null,"5 Addr Complement"]
["[heading3]=",null,null,24,null,"6 Zip City, City Complement"]
["[coline]=","c/o Juana Aguirre",null,24,null,"7 Country"]
["[street]=","Piedras No",null,24]
["[number]=",623,null,24]
["[addrcomplement]=","Piso2 Dpto. 4",null,24]
["[pobox]=",null,null,24]
["[zip]=","C1070AAM ",null,24]
["[city]=","Capital Federal",null,24]
["[citycomplement]=",null,null,24]
["[country]=","Argentinien",null,24]
[null,null,null,24]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A365:B443,2,FALSE))),VLOOKUP(\"country=\",A365:B443,2,FALSE),VLOOKUP(\"[country]=\",A365:B443,2,FALSE))","v":"Chile"},null,24]
["[confidential]=",null,null,25]
["[human]=","ü",null,25]
["[salutarytitle]=","Señor",null,25]
["[professiontitle]=",null,null,25]
["[professionname]=",null,null,25]
["[heading1]=","Juan Pérez",null,25]
["[heading2]=",null,null,25]
["[heading3]=",null,null,25]
["[coline]=",null,null,25]
["[street]=","El Juncal",null,25]
["[number]=","050",null,25]
["[addrcomplement]=",null,null,25]
["[pobox]=",null,null,25]
["[zip]=",null,null,25]
["[city]=","Qulicura",null,25]
["[citycomplement]=",null,null,25]
["[country]=","Chile",null,25]
[null,null,null,25]
["[confidential]=",null,null,26]
["[human]=",null,null,26]
["[salutarytitle]=",null,null,26]
["[professiontitle]=",null,null,26]
["[professionname]=",null,null,{"$f":"IF(AND(A387<>\"\",A386=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":26}]
["[heading1]=","Posada de Mike Rapu - ",null,26]
["[heading2]=","Explora en Rapa Nui",null,26]
["[heading3]=",null,null,26]
["[coline]=",null,null,26]
["[street]=","Sector Te Miro Oone",null,26]
["[number]=",null,null,26]
["[addrcomplement]=",null,null,26]
["[pobox]=",null,null,26]
["[zip]=",null,null,26]
["[city]=","Rapa Nui, Easter Island",null,26]
["[citycomplement]=",null,null,26]
["[country]=","Chile",null,26]
[null,null,null,26]
["[confidential]=",null,null,27]
["[human]=",null,null,27]
["[salutarytitle]=",null,null,27]
["[professiontitle]=",null,null,27]
["[professionname]=",null,null,27]
["[heading1]=","Puyuhuapi Lodge",null,27]
["[heading2]=",null,null,27]
["[heading3]=",null,null,27]
["[coline]=",null,null,27]
["[street]=","Bahía Dorita s/n",null,27]
["[number]=",null,null,27]
["[addrcomplement]=",null,null,27]
["[pobox]=",null,null,27]
["[zip]=",null,null,27]
["[city]=","Puyuhuapi ",null,27]
["[citycomplement]=",null,null,27]
["[country]=","Chile",null,27]
[null,null,null,27]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A420:B442,2,FALSE))),VLOOKUP(\"country=\",A420:B442,2,FALSE),VLOOKUP(\"[country]=\",A420:B442,2,FALSE))","v":"Brasilien"},null,{"$f":"IF(AND(A419<>\"\",A400=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":27}]
["[confidential]=",null,null,{"$f":"IF(AND(A420<>\"\",A419=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":28}]
["[human]=","ü",null,28]
["[salutarytitle]=","Sr.",null,28]
["[professiontitle]=",null,null,28]
["[professionname]=",null,null,28]
["[heading1]=","Luis Carvalho",null,28]
["[heading2]=",null,null,28]
["[heading3]=",null,null,28]
["[coline]=",null,null,28]
["[street]=","SBN - Quadra 13 - Bloca B - 8o andar",null,28]
["[number]=",null,null,28]
["[pobox]=",null,null,28]
["[addrcomplement]=",null,null,28]
["[city]=","Brasilia",null,28]
["[citycomplement]=","DF Brasil",null,28]
["[zip]=","70002-900 ",null,28]
["[country]=","Brasilien",null,28]
[null,null,null,28]
[null,"* Naher Osten",null,28]
[null,null,null,28]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A441:B489,2,FALSE))),VLOOKUP(\"country=\",A441:B489,2,FALSE),VLOOKUP(\"[Country]=\",A441:B489,2,FALSE))","v":"Gaza Streifen"},null,28]
["heading 1=","PNA Ministry of Health",null,29]
["heading 2=","Palestinian National Authority",null,29]
["c/oline=","c/o Mr. Nabil Shaath",null,29]
["street=","Abu-Khadra Center,",null,29]
["number=","P.O. Box 1035",null,29]
["city=","Gaza",null,29]
["zip=","00972",null,29]
["country=","Gaza Streifen",null,29]
[null,null,null,29]
[null,"* Australien und Ozeanien",null,29]
[null,null,null,29]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A453:B487,2,FALSE))),VLOOKUP(\"country=\",A453:B487,2,FALSE),VLOOKUP(\"[country]=\",A453:B487,2,FALSE))","v":"Australien"},null,29]
["[confidential]=",null,null,30]
["[human]=","ü",null,30]
["[salutarytitle]=","Mr.",null,30]
["[professiontitle]=",null,null,30]
["[professionname]=",null,null,30]
["[heading1]=","Max Mustermann",null,30]
["[heading2]=",null,null,30]
["[heading3]=",null,null,30]
["[coline]=",null,null,30]
["[number]=",31,null,30]
["[street]=","Thoroughfare Name ST",null,30]
["[pobox]=",null,null,30]
["[addrcomplement]=",null,null,30]
["[city]=","Placename",null,30]
["[citycomplement]=","QLD",null,30]
["[zip]=",4870,null,30]
["[country]=","Australien",null,30]
[null,null,null,30]
["[confidential]=",null,null,31]
["[human]=","ü",null,31]
["[salutarytitle]=","Mr.",null,31]
["[professiontitle]=",null,null,31]
["[professionname]=",null,null,31]
["[heading1]=","Norbert Eiglsperger",null,31]
["[heading2]=",null,null,31]
["[heading3]=",null,null,31]
["[coline]=",null,null,31]
["[number]=","Lot 31",null,31]
["[street]=","Thoroughfare Name AVE",null,31]
["[pobox]=",null,null,31]
["[addrcomplement]=",null,null,31]
["[city]=","Placename",null,{"$f":"IF(AND(A484<>\"\",A483=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":31}]
["[citycomplement]=","QLD",null,31]
["[zip]=",4870,null,31]
["[country]=","Australien",null,31]
[null,null,null,31]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A490:B513,2,FALSE))),VLOOKUP(\"country=\",A490:B513,2,FALSE),VLOOKUP(\"[country]=\",A490:B513,2,FALSE))","v":"Neuseeland"},null,31]
["[confidential]=",null,null,32]
["[human]=",null,null,32]
["[salutarytitle]=",null,null,32]
["[professiontitle]=",null,null,32]
["[professionname]=",null,null,32]
["[heading1]=","Lumino Support Centre",null,32]
["[heading2]=","Level 16 West Plaza Building",null,32]
["[heading3]=",null,null,32]
["[coline]=","c/o Andy Tapper, General Manager",null,32]
["[number]=","3-7",null,32]
["[street]=","Albert Street",null,32]
["[pobox]=",106514,null,32]
["[addrcomplement]=",null,null,32]
["[city]=","Auckland",null,32]
["[citycomplement]=",null,null,32]
["[zip]=",1143,null,32]
["[country]=","Neuseeland",null,32]
[null,null,null,32]
["[confidential]=",null,null,33]
["[human]=",null,null,33]
["[salutarytitle]=",null,null,33]
["[professiontitle]=",null,null,33]
["[professionname]=",null,null,33]
["[heading1]=","Albrights Ltd",null,33]
["[heading2]=",null,null,33]
["[heading3]=",null,null,33]
["[coline]=",null,null,33]
["[street]=","Victoria Street",null,33]
["[number]=",50,null,33]
["[pobox]=",null,null,33]
["[addrcomplement]=",null,null,33]
["[city]=","Timaru",null,33]
["[citycomplement]=","Parkside",null,33]
["[zip]=",7910,null,33]
["[country]=","Neuseeland",null,33]
[null,null,null,33]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A527:B561,2,FALSE))),VLOOKUP(\"country=\",A527:B561,2,FALSE),VLOOKUP(\"[country]=\",A527:B561,2,FALSE))","v":"Fidschi"},null,33]
["[confidential]=",null,null,34,null,"testcase with 5 lines"]
["[human]=","ü",null,34]
["[salutarytitle]=","Mr.",null,34]
["[professiontitle]=",null,null,34]
["[professionname]=",null,null,34]
["[heading1]=","John David",null,34]
["[heading2]=",null,null,34]
["[heading3]=",null,null,34]
["[coline]=",null,null,34]
["[street]=","Viria Street",null,34]
["[number]=",null,null,34]
["[addrcomplement]=",null,null,34]
["[pobox]=",null,null,34]
["[city]=","Suva",null,34]
["[citycomplement]=","Vatuwaqu",null,34]
["[zip]=",null,null,34]
["[country]=","Fidschi",null,34]
[null,null,null,34]
["[confidential]=",null,null,35,null,"Testcase for more lines then 5"]
["[human]=",null,null,35,null,"here CO line add."]
["[salutarytitle]=",null,null,35,null,"\"Confidential\""]
["[professiontitle]=",null,null,{"$f":"IF(AND(A548<>\"\",A547=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":35}]
["[professionname]=",null,null,35]
["[heading1]=","Fiji Daily Post",null,35]
["[heading2]=",null,null,35]
["[heading3]=",null,null,35]
["[coline]=",null,null,35]
["[street]=","Ackland St.",null,35]
["[number]=",19,null,35]
["[addrcomplement]=","Viria E Ind. SD",null,35]
["[pobox]=",null,null,35]
["[city]=","Suva",null,35]
["[citycomplement]=","Vatuwaqu",null,35]
["[zip]=",null,null,35]
["[country]=","Fidschi",null,35]
[null,null,null,35]
["[confidential]=",null,null,36]
["[human]=",null,null,36]
["[salutarytitle]=",null,null,36]
["[professiontitle]=",null,null,36]
["[professionname]=",null,null,36]
["[heading1]=","Fiji Daily Post",null,36]
["[heading2]=",null,null,36]
["[heading3]=",null,null,36]
["[coline]=","c/o Mr. John David",null,36]
["[street]=","Ackland St.",null,36]
["[number]=",19,null,36]
["[addrcomplement]=","Viria East Industrial Subdivision",null,36]
["[pobox]=",null,null,36]
["[city]=","Suva",null,36]
["[citycomplement]=","Vatuwaqu",null,36]
["[zip]=",null,null,36]
["[country]=","Fidschi",null,36]
[null,null,null,36]
[null,"* Asien",null,36]
[null,null,null,36]
[null,{"$f":"IF(NOT(ISERROR(VLOOKUP(\"country=\",A584:B618,2,FALSE))),VLOOKUP(\"country=\",A584:B618,2,FALSE),VLOOKUP(\"[country]=\",A584:B618,2,FALSE))","v":"Indien"},null,36]
["[confidential]=",null,null,37]
["[human]=",null,null,37]
["[salutarytitle]=",null,null,37]
["[professiontitle]=",null,null,37]
["[professionname]=",null,null,37]
["[heading1]=","Steel Authority of India Ltd.",null,37]
["[heading2]=",null,null,37]
["[heading3]=",null,null,37]
["[coline]=","c/o Ispat Bhavan",null,37]
["[street]=","Lodhi Road",null,37]
["[number]=",null,null,37]
["[addrcomplement]=",null,null,37]
["[pobox]=",null,null,37]
["[city]=","New Dheli",null,37]
["[citycomplement]=",null,null,37]
["[zip]=",110003,null,37]
["[country]=","Indien",null,37]
[null,null,null,37]
["[confidential]=",null,null,38]
["[human]=",null,null,38]
["[salutarytitle]=",null,null,38]
["[professiontitle]=",null,null,38]
["[professionname]=",null,null,38]
["[heading1]=","Department of Posts",null,38]
["[heading2]=","Business Development Directorate",null,38]
["[heading3]=",null,null,38]
["[coline]=","c/o Dak Bhavan",null,38]
["[street]=","Parliament Street",null,38]
["[number]=",null,null,{"$f":"IF(AND(A612<>\"\",A611=\"\"),INDEX($D:$D,ROW()-1,1)+1,INDEX($D:$D,ROW()-1,1))","v":38}]
["[addrcomplement]=",null,null,38]
["[pobox]=",null,null,38]
["[city]=","New Dheli",null,38]
["[citycomplement]=",null,null,38]
["[zip]=",110001,null,38]
["[country]=","Indien",null,38]
[null,null,null,38]
["[confidential]=",null,null,39]
["[human]=","ü",null,39]
["[salutarytitle]=","Mr.",null,39]
["[professiontitle]=",null,null,39]
["[professionname]=",null,null,39]
["[heading1]=","Taro Tanaka",null,39]
["[heading2]=",null,null,39]
["[heading3]=","(note: In rural areas)",null,39]
["[coline]=",null,null,39]
["[street]=","Shiokawa",null,39]
["[number]=","2338 ",null,39]
["[addrcomplement]=","Maruko-machi",null,39]
["[pobox]=",null,null,39]
["[city]=","Nagano",null,39]
["[citycomplement]=","Chisagata-gun",null,39]
["[zip]=","386–401",null,39]
["[country]=","Japan",null,39]
[null,null,null,39]
["[confidential]=",null,null,40]
["[human]=","ü",null,40]
["[salutarytitle]=","Mr.",null,40]
["[professiontitle]=",null,null,40]
["[professionname]=",null,null,40]
["[heading1]=","Taro M. Tanaka",null,40]
["[heading2]=",null,null,40]
["[heading3]=","(note: In towns)",null,40]
["[coline]=",null,null,40]
["[street]=",null,null,40]
["[number]=","10–23",null,40]
["[addrcomplement]=","Mitsugi 1–chome",null,40]
["[pobox]=",null,null,40]
["[city]=","Tokyo",null,40]
["[citycomplement]=","Musashi-Murayama-shi",null,40]
["[zip]=","208–0032 ",null,40]
["[country]=","Japan",null,40]
[null,null,null,40]
["END"]

{"sheet":"Postal Codes","index":3,"n_rows":257,"n_cols":28,"rows_kept":257,"cut":false,"hidden":true,"merged":[]}
["Chile","Country","Postal-Code","Country Hint?","Country Areas","Addr. Complement","Address Lines","City","City Complement","c/o Line","Company","Confidential","Country","Name 1","Name 2","Name 3","Human","Number","PO Box","Postal code","Profession name","Profession Title","Regular","Salutary Title","Sender Country","Street","Zip-Code"]
[{"$f":"IF(NOT(ISERROR(VLOOKUP($A$1,A7:A257,1,FALSE))),$A$1,\"\")","v":"Chile"},{"$f":"IF(A2=\"\",IF(NOT(ISERROR(VLOOKUP($A$1,B7:B257,1,FALSE))),$A$1,\"\"),\"\")","v":""},{"$f":"C3","v":"RCH"},{"$f":"D3","v":"WAHR"},{"$f":"SUBSTITUTE(IF(NOT(ISERROR(FIND(\" \",MID(E5,1,FIND(\":\",E5))))),\"\",IF(ISERROR(FIND(\":\",E5)),\"\",MID(E5,1,FIND(\":\",E5)-1))),\"_\",\" \")","v":""},{"$f":"SUBSTITUTE(IF(NOT(ISERROR(FIND(\" \",MID(F5,1,FIND(\":\",F5))))),\"\",IF(ISERROR(FIND(\":\",F5)),\"\",MID(F5,1,FIND(\":\",F5)-1))),\"_\",\" \")","v":""},"","","Provinces","","","","","","","","","","","","","","","","","",""]
[{"$f":"A5","v":"Chile"},{"$f":"B5","v":"Chile"},{"$f":"C5","v":"RCH"},{"$f":"D5","v":"WAHR"},{"$f":"TRIM(\" \"&MID(E5,LEN(E2)+IF(E2<>\"\",2,1),999))","v":""},"","","","Provinces are not used","","","","Almost standard address rules. (may be due to many German settlers?)\n\nEaster Island does not use Zip-Codes or house numbers, may be other areas like Patagonia or terra de la fuego (Feuerland) are similar.","","","","","","","","","","","","","",""]
["Working Area"]
[{"$f":"IF($A2<>\"\",VLOOKUP($A2,$A$7:$AA$257,COLUMN(),FALSE),\"\")&IF($B2<>\"\",VLOOKUP($B2,$B$7:$AB$257,COLUMN($AB$1)-1,FALSE),\"\")","v":"Chile"},{"$f":"IF($A2<>\"\",VLOOKUP($A2,$A$7:$AA$257,COLUMN(),FALSE),\"\")&IF($B2<>\"\",VLOOKUP($B2,$B$7:$AA$257,COLUMN()-1,FALSE),\"\")","v":"Chile"},"RCH","WAHR","","","","","Provinces: Provinces are not used","","","","Almost standard address rules. (may be due to many German settlers?)\n\nEaster Island does not use Zip-Codes or house numbers, may be other areas like Patagonia or terra de la fuego (Feuerland) are similar.","","","","","","","","","","","","","",""]
["Data Base Area"]
["Deutschland","Germany","D  ",{"$f":"M7<>\"\"","v":true},"","","","","Village: If a street name is not unique within an ZIP-Code, then add village or location name to make street name unique. If needed skip City name of zip-code and replace it by unique location name. ","","","","If a street name is not unique within an ZIP-Code, then add village or location name to make street name unique. If needed skip City name of zip-code and replace it by unique location name. Usually don´t use profession names","","","","","","","","Usually don´t use profession names","","","","","","",{"$f":"A7","v":"Deutschland"}]
["Italien","Italy","I  ",{"$f":"M8<>\"\"","v":true},"","","","","","","","","The abbreviation for the province should appear in the address, after the name of the locality, seperated with space","","","","","","","","","","","","","","",{"$f":"A8","v":"Italien"}]
["Österreich","Austria","A  ",{"$f":"M9<>\"\"","v":true},"","","","","Village: If a street name is not unique within an ZIP-Code, then add village or location name to make street name unique. If needed skip City name of zip-code and replace it by unique location name. ","","","","If a street name is not unique within an ZIP-Code, then add village or location name to make street name unique. If needed skip City name of zip-code and replace it by unique location name. Usually use profession names","","","","","","","","Usually use profession names","","","","","","",{"$f":"A9","v":"Österreich"}]
["Schweiz","Switzerland","CH ",false,"","","","","Village: If a street name is not unique within an ZIP-Code, then add village or location name to make street name unique. If needed skip City name of zip-code and replace it by unique location name. ","","","","","","","","","","","","","","","","","","","Schweiz"]
["Afghanistan","Afghanistan","AFG",true,"","","","","","","","","The address must be given in Latin letter.","","","","","","","","","","","","","","","Afghanistan"]
["Ägypten","Egypt","ET ",true,"","","","","","","","","The 5-figure zip code is to be stated under the city or provincial name. ","","","","","","","","","","","","","","","Ägypten"]
["Albanien","Albania","AL ",false,"","","","","","","","",null,"","","","","","","","","","","","","","","Albanien"]
["Algerien","Algeria","DZ ",false,"","","","","","","","","","","","","","","","","","","","","","","","Algerien"]
["Amerikanisch Samoa","American Samoa","AS ",false,"","","","","","","","","","","","","","","","","","","","","","","","Amerikanisch Samoa"]
["Samoa","Samoa","",false,"Use Amerikanische / American ….","","","","","","","","","","","","","","","","","","","","","","","Samoa"]
["Amerikanische Jungferninseln","American Virgin Island","AJ ",false,"","","","","","","","","","","","","","","","","","","","","","","","Amerikanische Jungferninseln"]
["Jungferninseln","Virgin Island","",false,"Use Amerikanische / American ….","","","","","","","","","","","","","","","","","","","","","","","Jungferninseln"]
["Andorra","Andorra","AND",false,"","","","","","","","","","","","","","","","","","","","","","","","Andorra"]
["Angola","Angola","ANG",false,"incl. Nordfolk Kokos- and Weihnachtsinseln Christmas Island","","","","","","","","","","","","","","","","","","","","","","","Angola"]
["Antarktis Territorium","Antarctica","AT ",false,"","","","","","","","","","","","","","","","","","","","","","","","Antarktis Territorium"]
["Äquatorialguinea","Equatorial Guinea","AQU",false,"","","","","","","","","","","","","","","","","","","","","","","","Äquatorialguinea"]
["Argentinien","Argentina","RA ",false,"","Piso,_Dept.: Use field Addr. Complement for \"Piso = level\" and \"Dept.=Door number\" informations","","","","","","","","","","","","","","","","","","","","","Argentina postal code (\"CPA\") has one letter + four digits + three letters","Argentinien"]
["Aserbaidschan","Azerbaijan","AZ ",false,"","","","","","","","","","","","","","","","","","","","","","","","Aserbaidschan"]
["Äthiopien","Ethiopia","ETH",true,"","","","","","","","","The address must be given in Latin letter.","","","","","","","","","","","","","","","Äthiopien"]
["Australien","Australia","AU",true,"","","","","State_/_Territory: Abbreviations (as of December 2005)\n        ACT Australian Capital Territory\n        NSW New South Wales\n        NT  Northern Territory\n        QLD Queensland\n        SA  South Australia\n        TAS Tasmania\n        VIC Victoria\n        WA  Western Australia\n       \n\n","","","","Enter State or Terretory into City Complement (without comma)\neach line should contain a maximum of 40 characters, including spaces; \nthe use of punctuation marks should be avoided; they are, however, acceptable in the line containing the addressee name, and are also accepted for separating specific address elements\nthe last two lines should be printed in upper case. ","","","","","","","","","","","","","Abbreviations for Types of Streets/Roads/etc. (as of December 2005)\n        ALLEY Alley\n        ARC   Arcade\n        AVE   Avenue\n        BVD   Boulevard\n        CL    Close\n        CRES  Crescent\n        DR    Drive\n        ESP   Esplanade\n        GR    Grove\n        HWY   Highway\n        LANE  Lane\n        PDE   Parade\n        PL    Place\n        RD    Road\n        SQ    Square\n        ST    Street\n        TCE   Terrace\n       ","","Australien"]
["Bahamas","Bahamas","BS ",false,"","","","","","","","","","","","","","","","","","","","","","","","Bahamas"]
["Bahrain","Bahrain","BRN",false,"","","","","","","","","","","","","","","","","","","","","","","","Bahrain"]
["Bangladesh","Bangladesh","BD ",false,"","","","","","","","","","","","","","","","","","","","","","","","Bangladesh"]
["Barbados","Barbados","BDS",false,"","","","","","","","","","","","","","","","","","","","","","","","Barbados"]
["Republik Belarus ","Republic of Belarus","BY ",false,"(Weißrußland)","","","","","","","","","","","","","","","","","","","","","","","Republik Belarus "]
["Belarus ","Belarus ","",false,"Use Republic of Belarus","","","","","","","","","","","","","","","","","","","","","","","Belarus "]
["Belgien","Belgium","B  ",true,"","","","","","","","","* each line of the address may contain at most 32 characters or spaces;\n* abbreviations should be used when the line contains more than 32 characters (see list below). ","","","","","","","","","","","","","","","Belgien"]
["Belize","Belize","BH ",false,"","","","","","","","","","","","","","","","","","","","","","","","Belize"]
["Benin","Benin","DY ",false,"","","","","","","","","","","","","","","","","","","","","","","","Benin"]
["Bermuda","Bermuda","BER",false,"","","","","","","","","","","","","","","","","","","","","","","","Bermuda"]
["Bolivien","Bolivia","BOL",false,"","","","","","","","","","","","","","","","","","","","","","","","Bolivien"]
["Bosnien-Herzegowina","Bosnia and Herzegovina","BIH",false,"","","","","","","","","","","","","","","","","","","","","","","","Bosnien-Herzegowina"]
["Botswana","Botswana","RB ",false,"","","","","","","","","","","","","","","","","","","","","","","","Botswana"]
["Brasilien","Brazil","BR ",true,"","","","","State_Abbr.: DF BRAZIL is District Federal Brazil, so enter Brazil may be twice:  BRASILIA - DF BRAZIL, Country= BRAZIL","","","","The state abbreviation (two characters) in City Complement must follow the town name, separated by a dash. The city of Brasilia is divided into sectors. The sectors appear as abbreviations in the address (three to four capital letters). A sector is divided into quadras, which are themselves divided into blocks.\n ","","","","","","","","","","","","","","","Brasilien"]
["Britische  Jungferninseln","British Virgin Islands","BJ ",false,"","","","","","","","","","","","","","","","","","","","","","","","Britische  Jungferninseln"]
["Brunei Darussalam","Brunei Darussalam","BRU",false,"","","","","","","","","","","","","","","","","","","","","","","","Brunei Darussalam"]
["Bulgarien","Bulgaria","BG ",false,"","","","","","","","","","","","","","","","","","","","","","","","Bulgarien"]
["Burkina Faso","Burkina Faso","BF ",false,"","","","","","","","","","","","","","","","","","","","","","","","Burkina Faso"]
["Burundi","Burundi","RU ",false,"","","","","","","","","","","","","","","","","","","","","","","","Burundi"]
["Canton und Enderbury Inseln","Canton and Enderbury Islands","CUE",false,"Use Republic of Kiribati, put Canton … into City Complement","","","","","","","","","","","","","","","","","","","","","","","Canton und Enderbury Inseln"]
["Chile","Chile","RCH",true,"","","","","Provinces: Provinces are not used","","","","Almost standard address rules. (may be due to many German settlers?)\n\nEaster Island does not use Zip-Codes or house numbers, may be other areas like Patagonia or terra de la fuego (Feuerland) are similar.","","","","","","","","","","","","","","","Chile"]
["China","China","??",true,"","","","","","","","","In Chinese characters written addresses should contain next to the name of the destination also the city name with the seat of the responsible postal office as well as the names of the province and the district in whose area the destination lies.\nMoreover, must be stated:\na)  with letters into the continental share of China: NATIONAL REPUBLIC CHINA (dt)., RÉPUBLIQUE POPULAIRE DE CHINE (franz). or CHINA PEOPLE'S REPUBLIC OF (English ones).\nb)  with letters to Formosa (Taiwan): TAIWAN (Formose)\nc)  with letters on the islands Quemoy and Matsu as well as the Pescadores-(Fischer) islands (Penghu): VIATAIWAN (Formose)","","","","","","","","","","","","","","","China"]
["Cook-Inseln","Cook Islands","COI",false,"","","","","","","","","","","","","","","","","","","","","","","","Cook-Inseln"]
["Costa Rica","Costa Rica","CR ",true,"","","","","","","","","Enter District in City Complement, Zip Code right of City and District","","","","","","Enter PO Box into street with text \"Apartado Postal \" followed by PO Box number","","","","","","","","","Costa Rica"]
["Côte d'Ivory","Côte d'Ivory","CI ",true,"","","","","","","","","This is the correct country name:  CÔTE D'IVOIRE, not Ivory Coast, but use only CÔTE D'IVOIRE or CÔTE D'IVOIRE (REP.) .","","","","","","","","","","","","","","","Côte d'Ivory"]
["Curacao","Curacao","CU ",false,"","","","","","","","","","","","","","","","","","","","","","","","Curacao"]
["Dänemark","Denmark","DK ",false,"","","","Postcal_District: Enter the postal district that is related to the zip code, not the destination city. If the postal ditrict has an extension \"COPENHAGEN V\" enter it here. The real City-name is optional and is not used\n","Village: Local area or village (if needed) will be shown in line above Zip-Code","","","","","","","","","","","","","","","","","","","Dänemark"]
["Demokratische Republik Laos","Laos Democratic Republic","LAO",false,"","","","","","","","","","","","","","","","","","","","","","","","Demokratische Republik Laos"]
["Dominika","Dominika","WD ",false,"","","","","","","","","","","","","","","","","","","","","","","","Dominika"]
["Dominikanische Republik","Dominican Republic","DOM",false,"","","","","","","","","","","","","","","","","","","","","","","","Dominikanische Republik"]
["Dschibuti","Dschibuti","DSC",false,"","","","","","","","","","","","","","","","","","","","","","","","Dschibuti"]
["Ecuador","Ecuador","EC ",true,"","","","","","","","","Use the land names ECUADOR or ÉQUATEUR (franz). The zip code is given about the location name(city).","","","","","","","","","","","","","","","Ecuador"]
["El Salvador","El Salvador","ES ",false,"","","","","","","","","","","","","","","","","","","","","","","","El Salvador"]
["Elfenbeinküste","Côte d'Ivoire","CI ",true,"","","","","","","","","The correct country name is CÔTE D'IVOIRE, not Ivory Coast, but use only CÔTE D'IVOIRE or CÔTE D'IVOIRE (REP.).","","","","","","","","","","","","","","","Elfenbeinküste"]
["England","England","GB",true,"Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","Select \"Great Britain\" Grossbritanien please","England"]
["Eritrea","Eritrea","ERI",false,"","","","","","","","","","","","","","","","","","","","","","","","Eritrea"]
["Estland","Estonia","EST",false,"","","","","","","","","","","","","","","","","","","","","","","","Estland"]
["Falklandinseln","Falkland Islands","FAL",false,"","","","","","","","","","","","","","","","","","","","","","","","Falklandinseln"]
["Färöer","Føroyar","FO ",false,"","","","","","","","","","","","","","","","","","","","","","","","Färöer"]
["Fidschi","Fiji","FJI",false,"","","","","","","","","","","","","","","Enter Post Office Box number here","","","","","","","","","Fidschi"]
["Finnland","Finland","FIN",false,"","","","","","","","","","","","","","","","","","","","","","","","Finnland"]
["Fischer-Inseln","Penghu islands","??",false,"","","","","","","","","","","","","","","","","","","","","","","","Fischer-Inseln"]
["Formosa ","n.a.","??",false,"","","","","","","","","","","","","","","","","","","","","","","","Formosa "]
["Frankreich","France","F  ",true,"","","","","","","","","Number is on front of street, but not seperated with comma. From the line for street and house number no “dots” will be used. Upper case letters of the last lines (from street) is  recommended. After the local name the word CEDEX (Courrier d'Enterprise à distribution  EXceptionnelle – commercial post with priority delivery) can follow. It should not be deleted.","","","","","","","","","","","","","","","Frankreich"]
["Französich Polynesien","French Polynesia","FP ",false,"","","","","","","","","","","","","","","","","","","","","","","","Französich Polynesien"]
["Französisch Guayana","French Guyana","FG ",false,"","","","","","","","","","","","","","","","","","","","","","","","Französisch Guayana"]
["Polynesien","Polynesia","",{"$f":"M73<>\"\"","v":true},"use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia","use Französisch Polynesien / French Polynesia",{"$f":"A73","v":"Polynesien"}]
["Guayana","Guyana","",true,"use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","use Französisch Guayana / French Guayana","Guayana"]
["Gambia","Gambia","WAG",false,"","","","","","","","","","","","","","","","","","","","","","","","Gambia"]
["Georgien","Georgia","GE ",false,"","","","","","","","","","","","","","","","","","","","","","","","Georgien"]
["Ghana","Ghana","GH ",false,"","","","","","","","","","","","","","","","","","","","","","","","Ghana"]
["Gibraltar","Gibraltar","GBZ",false,"","","","","","","","","","","","","","","","","","","","","","","","Gibraltar"]
["Grenada","Grenada","WG ",false,"","","","","","","","","","","","","","","","","","","","","","","","Grenada"]
["Griechenland","Greece","GR ",false,"","","","","","","","","","","","","","","","","","","","","","","","Griechenland"]
["Grönland","Greenland","GRO",false,"","","","","","","","","","","","","","","","","","","","","","","","Grönland"]
["Grossbritanien","Great Britain","GB ",true,"","Name_of_House: Fill in here house name if street has no number. ","","Post_Office_Location: Put in City of post office","County: Put in county (Grafschaft) if you wish: From postal rules it's optional","","","","For destinations in Great Britain or Northern Ireland the informatin of the county is no more necessary, if postal place (location) and zip code are given. The zip code is below the local name. Houses can have instead of numbers names (above street line)","","","","","There are houses without numbers, but names. Fill the name of house into Addr. Complement.","","","","","","","","Some streets don´t have number. Then use house name in Addr.Complement","","Grossbritanien"]
["Guadeloupe","Guadeloupe","GUA",false,"","","","","","","","","","","","","","","","","","","","","","","","Guadeloupe"]
["Guam","Guam","GUM",false,"","","","","","","","","","","","","","","","","","","","","","","","Guam"]
["Guatemala","Guatemala","GCA",false,"","","","","","","","","","","","","","","","","","","","","","","","Guatemala"]
["Guinea","Guinea","GNB",false,"","","","","","","","","","","","","","","","","","","","","","","","Guinea"]
["Guyana","Guyana","GUY",false,"","","","","","","","","","","","","","","","","","","","","","","","Guyana"]
["Haiti","Haiti","RH ",false,"","","","","","","","","","","","","","","","","","","","","","","","Haiti"]
["Honduras","Honduras","HN ",false,"","","","","","","","","","","","","","","","","","","","","","","","Honduras"]
["Hong Kong","Hong Kong","HOK",true,"address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","Hong Kong"]
["Hongkong","Hongkong","HK ",true,"address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","address to Nat. Rep. Of China Volksrepublik China","Hongkong"]
["Indien","India","IND",false,"","","","","","","","","","","","","","","","","","","","","","","","Indien"]
["Indonesien","Indonesia","RI ",false,"","","","","","","","","","","","","","","","","","","","","","","","Indonesien"]
["Insel Alderney","Alderney, Channel islands","GBA",false,"","","","","","","","","","","","","","","","","","","","","","","","Insel Alderney"]
["Insel Guernsey","Guernsey, Channel Islands","GBG",false,"","","","","","","","","","","","","","","","","","","","","","","","Insel Guernsey"]
["Insel Jersey","Jersey, Channel Islands","GBJ",false,"","","","","","","","","","","","","","","","","","","","","","","","Insel Jersey"]
["Insel Man","Isle of man","GBM",false,"","","","","","","","","","","","","","","","","","","","","","","","Insel Man"]
["Alderney","Alderney","",true,"Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Use Insel Alderney","Alderney"]
["Guernsey","Guernsey","",true,"Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Use Insel Guernsey","Guernsey"]
["Jersey","Jersey","",true,"Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Use Insel Jersey","Jersey"]
["Man","Man","",true,"Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Use Insel Man","Man"]
["Alderney","Alderney Channel island","IRQ",false,"","","","","","","","","","","","","","","","","","","","","","","","Alderney"]
["Guernsey","Guernsey Channel Island","IRQ",false,"","","","","","","","","","","","","","","","","","","","","","","","Guernsey"]
["Jersey","Jersey Channel Island","IR ",true,"","","","","","","","","The address is to be stated in Latin or Persian characters and in Arabian or Persian digits, as well as into French, English or Persian language. The land name is RÉP.ISLAMIQUE D'IRAN (franz.) or IRAN ISLAMIC REP.OF (English ones).","","","","","","","","","","","","","","","Jersey"]
["Irland","Isle of man","IRL",false,"","","","","","","","","","","","","","","","","","","","","","","In general, Postcodes are not required. The exception is Dublin and Cork city where a 1 or 2 digit zone number appears after the name of the city (eg Dublin 2).","Irland"]
["Irak","Iraq","IRQ",false,"","","","","","","","","","","","","","","","","","","","","","","","Irak"]
["Iran","Iran","IR ",true,"","","","","","","","","The address is to be stated in Latin or Persian characters and in Arabian or Persian digits, as well as into French, English or Persian language. The land name is RÉP.ISLAMIQUE D'IRAN (franz.) or IRAN ISLAMIC REP.OF (English ones).","","","","","","","","","","","","","","","Iran"]
["Irland","Ireland","IRL",false,"","","","","","","","","","","","","","","","","","","","","","","In general, Postcodes are not required. The exception is Dublin and Cork city where a 1 or 2 digit zone number appears after the name of the city (eg Dublin 2).","Irland"]
["Island","Iceland","IS ",false,"","","","","","","","","","","","","","","","","","","","","","","","Island"]
["Israel","Israel","IL ",false,"einschl. besetzte / annektierte Gebiete","","","","","","","","","","","","","","","","","","","","","","","Israel"]
["Jamaika","Jamaica","JA ",false,"","","","","","","","","","","","","","","","","","","","","","","","Jamaika"]
["Japan","Japan","J  ",true,"","","","","","","","","In Japan, the address is generally written on a single line, beginning with the largest geographical area and ending with the smallest one. In the Roman alphabet, this would transcripted as follows: JAPAN 112–0001 TOKYO Bunkyo–Ku Hakusan 4–Chome 3–2 However, according to the latest information, automatic sorting equipment used by the Japanese Post is only able to sort items on which the address is in kanji, hiragana or katakana characters. Items whose address is in Roman script are sorted manually. Addresses may therefore also be laid out as they are in the West, from the smallest geographical area at the top to the largest at the bottom.","","","","","","","","","","","","","","","Japan"]
["Jordanien","Jordan","JOR",false,"","","","","","","","","","","","","","","","","","","","","","","","Jordanien"]
["Jugoslawien ","Bailiwick of Jersey","YU ",false,"(Serbien/Montenegro)","","","","","","","","","","","","","","","","","","","","","","","Jugoslawien "]
["Kaimaninseln","Cayman Islands","KAI",false,"","","","","","","","","","","","","","","","","","","","","","","","Kaimaninseln"]
["Kambodscha","Cambodia","K  ",false,"","","","","","","","","","","","","","","","","","","","","","","","Kambodscha"]
["Kamerun","Cameroon","CAM",false,"","","","","","","","","","","","","","","","","","","","","","","","Kamerun"]
["Kanada","Canada","CDN",true,"incl. canadian managed Terretorries","Street_Direction_or_Rural_Route:  Street Direction uses the common one- or two-letter abbreviation (se below).\nMany rural areas now have civic addresses. Civic addresses (street and number) are enter in field street and number. RR followed by Route number and Station number is correct: RR 8 STN MAIN\n\nStreet Directions: \nEnglish:\nEast = E\nNorth = N\nNortheast = NE\nNorthwest = NW\nSouth = S\nSoutheast = SE\nSouthwest = SW\nWest = W\n\nor French:\nEst = E\nNord = N\nNord-Est = NE\nNord-Ouest = NO\nSud = S\nSud-Est = SE\nSud-Ouest = SO\nOuest = O\n","","Municipality_Name: The official municipality name (as provided to Canada Post by the municipality), the official abbreviation of the municipality name or an official alternate name should be used and should not be translated. (Ex.: TROIS-RIVIÈRES is not THREE RIVERS.)","Province: The province should always be presented using the official two-letter symbol. USse 2 char abbreviation or long name.\nAB=Alberta / Alberta\nBC=British Columbia / Colombie-Britannique\nMB=Manitoba / Manitoba\nNB=New Brunswick / Nouveau-Brunswick\nNL=Newfoundland and Labrador / Terre-Neuve-et-Labrador\nNT=Northwest Territories / Territoires du Nord-Ouest\nNS=Nova Scotia / Nouvelle-Écosse\nNU=Nunavut / Nunavut\nON=Ontario / Ontario\nPE=Prince Edward Island / Île-du-Prince-Édouard\nQC=Québec / Québec\nSK=Saskatchewan / Saskatchewan\nYT=Yukon / Yukon\n","","","","Input is required: Street directions  enter into field Addr. Complement and Province enter in field City Complement. \n\nThe building of the address is a mix of Great Britain and USA-Rules.","","","","","In this field: A unit number is placed before the civic number with a hyphen between, OR after the street type, using an acceptable unit identifier. PLUS The civic number is the official number assigned to an address by the municipality. PLUS When a civic number suffix is present, there is no space when it is alpha (123A), and there is one space when it is a fraction (123 1/2): \n\nCorrect Input:\n\"10-123 1/2\" or \"10-123A\"","The postal box number should always be placed on the line just above the municipality, province and Postal Code. The # symbol should not be used, nor the French equivalent no. Punctuation should not be used. Station information should be present to direct mail to the proper postal installation. This is especially important in larger areas where there is more than one installation within the same municipality.\nStation = STN\nRetail Postal Outlet=RPO\n\nFor \"PO Box 4001 STN A \" insert here \"4001 STN A\" in PO Box Field.","","","","","","","For street names several abbreviations are used: AVE for Avenue, PLAT for Plateau, PT for POINT.","The Postal Code should be in uppercase and placed two spaces to the right of the province with one space between the first three and last three characters. A hyphen should not be used (ex. T0L-1K0).","Kanada"]
["Kanalinseln","Channel Islands","KAN",false,"","","","","","","","","","","","","","","","","","","","","","","","Kanalinseln"]
["Kasachstan","Kazakstan","KZ ",false,"","","","","","","","","","","","","","","","","","","","","","","","Kasachstan"]
["Katar","Qatar","Q",false,"","","","","","","","","","","","","","","","","","","","","","","","Katar"]
["Kenia","Kenya","EAK",false,"","","","","","","","","","","","","","","","","","","","","","","","Kenia"]
["Kirgisistan","Kyrgyzstan","KS ",false,"","","","","","","","","","","","","","","","","","","","","","","","Kirgisistan"]
["Republik Kiribati","Republic of Kiribati","KIB",false,"","","","","","","","","","","","","","","","","","","","","","","","Republik Kiribati"]
["Kiribati","Kiribati","",true,"Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Use Republik / Republic of Kiribati","Kiribati"]
["Kolumbien","Colombia","CO ",false,"","","","","","","","","","","","","","","","","","","","","","","","Kolumbien"]
["Komoren","Comoros","KOM",false,"","","","","","","","","","","","","","","","","","","","","","","","Komoren"]
["Kongo","Congo","RCB",false,"","","","","","","","","","","","","","","","","","","","","","","","Kongo"]
["Königreich Saudi Arabien","Kingdom of Saudi Arabia","KSA",false,"","","","","","","","","","","","","","","","","","","","","","","","Königreich Saudi Arabien"]
["Kroatien","Croatia","HR ",false,"","","","","","","","","","","","","","","","","","","","","","","","Kroatien"]
["Kuba","Cuba","C  ",false,"","","","","","","","","","","","","","","","","","","","","","","","Kuba"]
["Kuwait","Kuwait","KWT",false,"","","","","","","","","","","","","","","","","","","","","","","","Kuwait"]
["Laos","Laos","",true,"Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Use  Demokratische Republik Laos","Laos"]
["Lesotho","Lesotho","LS ",false,"","","","","","","","","","","","","","","","","","","","","","","","Lesotho"]
["Lettland","Latvia","LV ",{"$f":"#REF!<>\"\"","v":{"$error":"#REF!"}},"","","","","","","","","ZIP Code after City and Postal Code before ZIP => City Complement LV-1123","","","","","","","","","","","","","","",{"$f":"A135","v":"Lettland"}]
["Libanon","Lebanon","RL ",{"$f":"M136<>\"\"","v":false},"","","","","","","","","","","","","","","","","","","","","","","","Libanon"]
["Liberia","Liberia","LB ",false,"","","","","","","","","","","","","","","","","","","","","","","","Liberia"]
["Libyen","Lybia","LAR",false,"","","","","","","","","","","","","","","","","","","","","","","","Libyen"]
["Liechtenstein","Liechtenstein","FL ",false,"","","","","","","","","","","","","","","","","","","","","","","","Liechtenstein"]
["Litauen","Lithuania","LV ",{"$f":"M135<>\"\"","v":true},"","","","","","","","",null,"","","","","","","","","","","","","","","Litauen"]
["Luxemburg","Luxembourg","L  ",true,"","","","","","","","","Luxembourg address format seems mostly similar to France's format, except that:\n\n    * The postal code is a four-digit number. ","","","","","","","","","","","","","","","Luxemburg"]
["Macau","Macau","MAC",true,"","","","","","","","","Destinations in MACAO (MACAU) should not carry the addition \"Hong Kong\".","","","","","","","","","","","","","","","Macau"]
["Madagaskar","Madagascar","RM ",false,"","","","","","","","","","","","","","","","","","","","","","","","Madagaskar"]
["Malawi","Malawi","MW ",false,"","","","","","","","","","","","","","","","","","","","","","","","Malawi"]
["Malaysia","Malaysia","MAL",false,"","","","","","","","","","","","","","","","","","","","","","","","Malaysia"]
["Mali","Mali","RMM",false,"","","","","","","","","","","","","","","","","","","","","","","","Mali"]
["Malta","Malta","M  ",false,"","","","","","","","","","","","","","","","","","","","","","","","Malta"]
["Marokko","Morocco","MA ",false,"","","","","","","","","","","","","","","","","","","","","","","","Marokko"]
["Marshallinseln","Marshal Island","MAR",false,"","","","","","","","","","","","","","","","","","","","","","","","Marshallinseln"]
["Martinique","Martinique","MAT",false,"","","","","","","","","","","","","","","","","","","","","","","","Martinique"]
["Matsu ","Matsu ","??",false,"","","","","","","","","","","","","","","","","","","","","","","","Matsu "]
["Mauretanien","Mauritania","RIM",true,"","","","","","","","","Correct country name: MAURITANIA (dt)., MAURITANIE (franz.) or MAURITANIA (engl.).","","","","","","","","","","","","","","","Mauretanien"]
["Mauritius","Mauritius","MS ",true,"","","","","","","","","Correct country name: MAURITIUS (dt./English), MAURICE (franz).","","","","","","","","","","","","","","","Mauritius"]
["Mayotte","Mayotte","MAY",false,"","","","","","","","","","","","","","","","","","","","","","","","Mayotte"]
["Mazedonien","Macedonia ","MK ",false,"","","","","","","","","","","","","","","","","","","","","","","","Mazedonien"]
["Mexiko","Mexico","MEX",true,"","","",null,"Provincial_Code: \nHere the list of all provincial codes:\nAguascalientes AGS\nBaja California BC\nBaja California Sur BCS\nCampeche CAM\nChiapas CHIS\nChihuahua CHIH\nCoahuila COAH\nColima COL\nDistrito Federal DF\nDurango DGO\nGuanajuato GTO\nGuerrero GRO\nHidalgo HGO\nJalisco JAL\nMexico MEX\nMichoacan MICH\nMorelos MOR\nNayarit NAY\nNuevo Leon NL\nOaxaca OAX\nPuebla PUE\nQueretaro QRO\nQuintana Roo Q.ROO\nSan Luis Potosi SLP\nSinaloa SIN\nSonora SON\nTabasco TAB\nTamaulipas TAMPS\nTlaxcala TLAX\nVeracruz VER\nYucatan YUC\nZacatecas ZAC","","","","Enter District in City Complement","","","","","","","","","","","","","","","Mexiko"]
["Mikronesien","Micronesia","MIK",false,"","","","","","","","","","","","","","","","","","","","","","","","Mikronesien"]
["Moldawien","Moldova","",false,"","","","","","","","","","","","","","","","","","","","","","","","Moldawien"]
["Monaco","Monaco","MC ",false,"","","","","","","","","","","","","","","","","","","","","","","","Monaco"]
["Mongolei","Mongolia","MGL, MON",false,"","","","","","","","","","","","","","","","","","","","","","","","Mongolei"]
["Montenegro","Montenegro","CG ",false,"","","","","","","","","","","","","","","","","","","","","","","","Montenegro"]
["Montserrat","Montserrat","MOT",false,"","","","","","","","","","","","","","","","","","","","","","","","Montserrat"]
["Mosambik","Mozambique","",false,"","","","","","","","","","","","","","","","","","","","","","","","Mosambik"]
["Myanmar","Myanmar","MYA",false,"","","","","","","","","","","","","","","","","","","","","","","","Myanmar"]
["Namibia","Namibia","NAM  , SWA",false,"","","","","","","","","","","","","","","","","","","","","","","","Namibia"]
["Neukaledonien","New Caledonia","NKA   ",false,"","","","","","","","","","","","","","","","","","","","","","","","Neukaledonien"]
["Neuseeland","New Zealand","NZ    ",true,"","","","","","","","","Special rules are used for \nSTREET:\nUrban and rural addresses must include the \"street name\". This line can also contain:\n• a street number and letter (alpha) before the street name\n• a unit and unit separator ‘/’ before the street number\n• the street type and/or street direction after the street name.\n\nPO BOX or STREET:\nDelivery Service addresses must contain one of ‘PO Box’, ‘Private Bag’, ‘Response Bag’, ‘CMB’ (Community Mail Box), ‘Counter Delivery’, or ‘Poste Restante’ (all exceot PO Box use in this tool the field street) . This is followed by the delivery service identifier (usually a number) if New Zealand Post has allocated one.\n\nSUBURB = CITY COMPLEMENT\nSuburb is needed only where commonly used – normally in metropolitan areas and written under the street line (if possible)","","","","","","","","","","","","","","","Neuseeland"]
["Nicaragua","Nicaragua","NIC   ",false,"","","","","","","","","","","","","","","","","","","","","","","","Nicaragua"]
["Niederlande","Netherlands","NL    ",false,"","","","","","","","","","","","","","","","","","","","","","","","Niederlande"]
["Niederländische Antillen","Netherlands Antilles","NA    ",false,"","","","","","","","","","","","","","","","","","","","","","","","Niederländische Antillen"]
["Niger","Niger","RN ",false,"","","","","","","","","","","","","","","","","","","","","","","","Niger"]
["Nigeria","Nigeria","WAN",false,"","","","","","","","","","","","","","","","","","","","","","","","Nigeria"]
["Niue","Niue","NIU",false,"","","","","","","","","","","","","","","","","","","","","","","","Niue"]
["Nordkorea","North Korea","KOR",false,"","","","","","","","","","","","","","","","","","","","","","","","Nordkorea"]
["Nördliche Marianen","Northern Mariana Islands","NMA   ",false,"","","","","","","","","","","","","","","","","","","","","","","","Nördliche Marianen"]
["Norwegen","Norway","N     ",false,"","","","","","","","","","","","","","","","","","","","","","","","Norwegen"]
["Oman","Oman","OM",false,"","","","","","","","","","","","","","","","","","","","","","","","Oman"]
["Pakistan","Pakistan","PK ",true,"","","","","","","","","Use only the name of country PAKISTAN without any addition. The zip code stands with hyphen behind the local name.","","","","","","","","","","","","","","","Pakistan"]
["Palau","Palau","PAL",false,"","","","","","","","","","","","","","","","","","","","","","","","Palau"]
["Panama","Panama","PA ",false,"","","","","","","","","","","","","","","","","","","","","","","","Panama"]
["Papua Neuguinea","Ind. State of Papua New Guinea","PNG",false,"","","","","","","","","","","","","","","","","","","","","","","","Papua Neuguinea"]
["Paraguay","Paraguay","PY ",false,"","","","","","","","","","","","","","","","","","","","","","","","Paraguay"]
["Pazifische Inseln","Trust Territory of the Pacific Islands","PIN",false,"","","","","","","","","","","","","","","","","","","","","","","","Pazifische Inseln"]
["Penghu","Penghu","??",true,"Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Use Fischer Islands","Penghu"]
["Peru","Peru","PE ",false,"","","","","","","","","","","","","","","","","","","","","","","","Peru"]
["Pescadores Islands","Nutze Fischer Islands","??",true,"","","","","","","","","In Chinese characters written addresses should contain beside the name of the destination also the city name with the seat of the responsible postal office as well as the names of the province and the district in whose area the destination lies.\nMoreover, must be stated:\na)  with letters into the continental share of China: NATIONAL REPUBLIC CHINA (dt)., RÉPUBLIQUE POPULAIRE DE CHINE (franz). or CHINA PEOPLE'S REPUBLIC OF (English ones).\nb)  with letters to Formosa (Taiwan): TAIWAN (Formose)\nc)  with letters on the islands Quemoy and Matsu as well as the Pescadores-(Fischer) islands (Penghu): VIATAIWAN (Formose)","","","","","","","","","","","","","","","Pescadores Islands"]
["Philippinen","Philippines","RP ",false,"","","","","","","","","","","","","","","","","","","","","","","","Philippinen"]
["Pitcairn Inseln","Pitcairn Islands","PIT",false,"","","","","","","","","","","","","","","","","","","","","","","","Pitcairn Inseln"]
["Polen","Poland","PL ",true,"","","","","","","","","The destination has to be written in the manner of writing corresponding to the international postal place directory.","","","","","","","","","","","","","","","Polen"]
["Portugal","Portugal","P  ",true,"","","","","","","","","postal code now has three added digits for a total of seven","","","","","","","","","","","","","","postal code now has three added digits for a total of seven","Portugal"]
["Puerto Rico","Puerto Rico","PRI, PR",false,"","","","","","","","","","","","","","","","","","","","","","","","Puerto Rico"]
["Quemoy ","Quemoy ","??",false,"","","","","","","","","","","","","","","","","","","","","","","","Quemoy "]
["Republik Korea ","Korean Republic","ROK",true,"(Südkorea)","","","","","","","","The zip code should be given on the right of the city / location name. Upper case of the whole address is recommended. Number is before street,´.\na) DEMOCRATIC NATIONAL REPUBLIC KOREA (dt.) or RÉPUBLIQUE POPULAIRE DÉMOCRATIQUE DE CORÉE (franz.) or KOREA DEMOCRATIC PEOPLE'S REPUBLIC OF (English ones).\nb) REPUBLIK KOREA (dt.) or RÉPUBLIQUE DE CORÉE (franz.) or REPUBLIC OF KOREA (engl.)","","","","","","","","","","","","","","The zip code should be given on the right of the city / location name. ","Republik Korea "]
["Reunion","Reunion","REU",false,"","","","","","","","","","","","","","","","","","","","","","","","Reunion"]
["Ruanda","Rwanda","RWA",false,"","","","","","","","","","","","","","","","","","","","","","","","Ruanda"]
["Rumänien","Romania","RO ",false,"","","","","","","","","","","","","","","","","","","","","","","","Rumänien"]
["Russische Föderation","Russian Federation","RUS",false,"","","","","","","","","","","","","","","","","","","","","","","","Russische Föderation"]
["Sabah und Labuan","Sabah and Labuan","CNB",true,"Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Use Malaysia","Sabah und Labuan"]
["Sambia","Zambia","Y , Z",{"$f":"M199<>\"\"","v":true},"","","","","","","","","The address has to be noted with Latin letter.","","","","","","","","","","","","","","",{"$f":"A199","v":"Sambia"}]
["San Marino","San Marino","RSM",false,"","","","","","","","","","","","","","","","","","","","","","","","San Marino"]
["Saudiarabien","Saudi Arabia","SA ",true,"Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Use Königreich Saudi Arabien / Kingdom of Saudi Arabia","Saudiarabien"]
["Schweden","Sweden","S  ",false,"","","","","","","","","","","","","","","","","","","","","","","","Schweden"]
["Senegal","Senegal","SN ",false,"","","","","","","","","","","","","","","","","","","","","","","","Senegal"]
["Serbien","Serbia","SRB",false,"","","","","","","","","","","","","","","","","","","","","","","","Serbien"]
["Seychellen","Seychelles","SY ",false,"","","","","","","","","","","","","","","","","","","","","","","","Seychellen"]
["Sierra Leone","Sierra Leone","WAL",false,"","","","","","","","","","","","","","","","","","","","","","","","Sierra Leone"]
["Simbabwe","Zimbabwe","ZW ",false,"","","","","","","","","","","","","","","","","","","","","","","","Simbabwe"]
["Singapur","Singapore","SGP",true,"","","","","","","","","Correct country name: REPUBLIC SINGAPORE (dt.) or RÉPUBLIQUE DE SINGAPOUR (franz.) or REPUBLIC OF SINGAPORE (English ones).\n","","","","","","","","","","","","","","","Singapur"]
["Slowakei","Slovakia","",false,"","","","","","","","","","","","","","","","","","","","","","","","Slowakei"]
["Slowenien","Slovenia","SLO",false,"","","","","","","","","","","","","","","","","","","","","","","","Slowenien"]
["Somalia","Somalia","SP ",false,"","","","","","","","","","","","","","","","","","","","","","","","Somalia"]
["Sowjetunion","Soviet Union","SU ",true," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)","In former times the address was sorted: Soviet Union, Region, Town , Street, addresse, but now both forms exists"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)"," former Republic, well it's former: Select correct State (out of several :-)","Sowjetunion"]
["Spanien","Spain","E  ",false,"","","","","","","","","","","","","","","","","","","","","","","","Spanien"]
["Sri Lanka","Sri Lanka","CL ",false,"","","","","","","","","","","","","","","","","","","","","","","","Sri Lanka"]
["St. Helena","St. Helena","HEL",false,"","","","","","","","","","","","","","","","","","","","","","","","St. Helena"]
["St. Lucia","St. Lucia","WL ",false,"","","","","","","","","","","","","","","","","","","","","","","","St. Lucia"]
["St. Pierre / Miquelon","St. Pierre / Miquelon","PIE",false,"","","","","","","","","","","","","","","","","","","","","","","","St. Pierre / Miquelon"]
["St. Vincent","St. Vincent","WV ",false,"","","","","","","","","","","","","","","","","","","","","","","","St. Vincent"]
["Sudan","Sudan","SUD",false,"","","","","","","","","","","","","","","","","","","","","","","","Sudan"]
["Südafrika","South Africa","ZA ",false,"","","","","","","","","","","","","","","","","","","","","","","","Südafrika"]
["Surinam","Suriname","SME",false,"","","","","","","","","","","","","","","","","","","","","","","","Surinam"]
["Swasiland","Swaziland","SD ",false,"","","","","","","","","","","","","","","","","","","","","","","","Swasiland"]
["Syrien","Syria","SYR",false,"","","","","","","","","","","","","","","","","","","","","","","","Syrien"]
["Tadschikistan","Tajikistan","TD, THA, TI",false,"","","","","","","","","","","","","","","","","","","","","","","","Tadschikistan"]
["Taiwan","Taiwan","RC ",true," (China)","","","","","","","","In Chinese characters written addresses should contain beside the name of the destination also the city name with the seat of the responsible postal office as well as the names of the province and the district in whose area the destination lies.\nMoreover, must be stated:\na)  with letters into the continental share of China: NATIONAL REPUBLIC CHINA (dt)., RÉPUBLIQUE POPULAIRE DE CHINE (franz). or CHINA PEOPLE'S REPUBLIC OF (English ones).\nb)  with letters to Formosa (Taiwan): TAIWAN (Formose)\nc)  with letters on the islands Quemoy and Matsu as well as the Pescadores-(Fischer) islands (Penghu): VIATAIWAN (Formose)","","","","","","","","","","","","","","","Taiwan"]
["Tansania","Tanzania","EAT",false,"","","","","","","","","","","","","","","","","","","","","","","","Tansania"]
["Thailand","Thailand","T  ",true,"","","","","","","","","Address in Latin letter. The zip code is to be attached on the right from or below the entry of the destination.\n\n","","","","","","","","","","","","","","","Thailand"]
["Togo","Togo","RT ",false,"","","","","","","","","","","","","","","","","","","","","","","","Togo"]
["Tokelau Inseln","Tokelau Islands","TOK",false,"","","","","","","","","","","","","","","","","","","","","","","","Tokelau Inseln"]
["Tonga","Tonga","TG ",false,"","","","","","","","","","","","","","","","","","","","","","","","Tonga"]
["Trinidad und Tobago","Trinidad and Tobago","TT ",false,null,"","","","","","","","","","","","","","","","","","","","","","","Trinidad und Tobago"]
["Tschechische Republik","Czech Republic","CZ ",true,"","","","","No_of_DeliveryPostOffice_or_Delivery_Village: The addresses of certain major cities, contain a one to three figures code after the city name (e.g. PRAHA 11) They are the delivery post office. Enter the Code (here 11) in this field.\n\nIf smaller villages have to be addressed, then enter them here, too. They will be shown in a separat line below the street, above the Zip-Code and City.","","","","The addresses of certain major cities, such as Prague or Brno, contain a one to three figures code after the locality name (e.g. PRAHA 11) which identifies (together with the locality name) the delivery post office. Locality given in the address beside the postcode has a delivery post office. Enter both data in City Complement.\n\nThe locality without a delivery post office will appear on the line above the postcode. ","","","","","The street number often consists of two numbers separated by a slash. The first number is a unique district-related building number which doesn’t depend on the street where the building is located, the second number is the street number. Enter both in Number.","","","","","","","","The street number often consists of two numbers separated by a slash. The first number is a unique district-related building number which doesn’t depend on the street where the building is located, the second number is the street number. Enter both in Number.","","Tschechische Republik"]
["Türkei","Turkey","TR ",false,"","","","","","","","","","","","","","","","","","","","","","","","Türkei"]
["Tunesien","Tunisia","TN ",false,"","","","","","","","","","","","","","","","","","","","","","","","Tunesien"]
["Turkmenistan","Turkmenistan","TM, TMN",false,"","","","","","","","","","","","","","","","","","","","","","","","Turkmenistan"]
["Turks- und Caicosinseln","Turks and Caicos Islands","TUC",false,"","","","","","","","","","","","","","","","","","","","","","","","Turks- und Caicosinseln"]
["Tuvalu","Tuvalu","TUV",false,"","","","","","","","","","","","","","","","","","","","","","","","Tuvalu"]
["Uganda","Uganda","EAU",false,"","","","","","","","","","","","","","","","","","","","","","","","Uganda"]
["Ukraine","Ukraine","UA ",false,"","","","","","","","","","","","","","","","","","","","","","","","Ukraine"]
["Ungarn","Hungary","H  ",true,"","","","Street is below City and Zip-Line (this is done by the tool)","","","","","Street is below City and Zip-Line (this is done by the tool)","","","","","","","","","","","","","Street is below City and Zip-Line (this is done by the tool)","Street is below City and Zip-Line (this is done by the tool)","Ungarn"]
["Uruguay","Uruguay","RDU, ROU",false,"","","","","","","","","","","","","","","","","","","","","","","","Uruguay"]
["Usbekistan","Uzbekistan","UZ ",false,"","","","","","","","","","","","","","","","","","","","","","","","Usbekistan"]
["Vanatua","Vanatua","VAN",false,"","","","","","","","","","","","","","","","","","","","","","","","Vanatua"]
["Vatikan","Vatican","SCV",false,"","","","","","","","","","","","","","","","","","","","","","","","Vatikan"]
["Vatikanstadt","City of Vatican","V  ",false,"","","","","","","","","","","","","","","","","","","","","","","","Vatikanstadt"]
["Venezuela","Venezuela","YV ",false,"","","","","","","","","","","","","","","","","","","","","","","","Venezuela"]
["Vereinigte Arabische Emirate","United Arab Emirates","UAE",false,"","","","","","","","","","","","","","","","","","","","","","","","Vereinigte Arabische Emirate"]
["Vereinigte Staaten von Amerika","United States of America","USA",true,"incl. Hawai, but not unincorporated territories of the United States located in the South Pacific Ocean.","Door_App.:Any add. Information like door, app. etc. shown after street name.","","","State: List of States in USA: \nAZ for Arizona\nNM New Mexico \nMIS is valid only for Mississippi\nMO is Missouri\nTX for Texas \netc.\ncheck internet for codes","","","","Enter destination location (city), abbreviation of the state and the 9-figure zip code (with a hyphen between the 5th and 6th digit). Two empty spaces between state and zip code. The abbreviation MIS is valid only for the state Mississippi, the abbreviation for the state Missouri is MO. Upper case of the whole address is recommended.","","","","","","","","","","","","","","Enter Zip Code with all nine digits including hyphen between 5th and 6th digit.","Vereinigte Staaten von Amerika"]
["Vietnam","Vietnam","VN ",false,"","","","","","","","","","","","","","","","","","","","","","","","Vietnam"]
["Volksrepublik China","People's Republic of China","CN ",true,"","","","","","","","","In Chinese characters written addresses should contain next to the name of the destination also the city name with the seat of the responsible postal office as well as the names of the province and the district in whose area the destination lies.\nMoreover, must be stated:\na)  with letters into the continental share of China: NATIONAL REPUBLIC CHINA (dt)., RÉPUBLIQUE POPULAIRE DE CHINE (franz). or CHINA PEOPLE'S REPUBLIC OF (English ones).\nb)  with letters to Formosa (Taiwan): TAIWAN (Formose)\nc)  with letters on the islands Quemoy and Matsu as well as the Pescadores-(Fischer) islands (Penghu): VIATAIWAN (Formose)","","","","","","","","","","","","","","","Volksrepublik China"]
["Volksrepublik Jemen","Republic of Yemen","ADN",false,"","","","","","","","","","","","","","","","","","","","","","","","Volksrepublik Jemen"]
["Samoa","Indep. State of Samoa","",false,"","","","","","","","","","","","","","","","","","","","","","","","Samoa"]
["West Samoa","West Samoa","",true,"Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","Use Samoa / Indep. State of Samoa","West Samoa"]
["Zaire","Zaire","ZRE",false,"","","","","","","","","","","","","","","","","","","","","","","","Zaire"]
["Sansibar","Zanzibar","",false,"","","","","","","","","","","","","","","","","","","","","","","","Sansibar"]
["Zentralafrikanische Republik","Central African Republic","RCA",false,"","","","","","","","","","","","","","","","","","","","","","","","Zentralafrikanische Republik"]
["Zypern","Cyprus","CY ",false,"","","","","","","","","","","","","","","","","","","","","","","","Zypern"]

{"sheet":"Parameter","index":4,"n_rows":300,"n_cols":5,"rows_kept":300,"cut":false,"hidden":true,"merged":[]}
["Priority of fields: If we have to shorten, then begin  to delte in this sorting order, not implemented yet",null,null,"Field","Fieldnotes"]
["professionname","delete first",null,"Addr. Complement","This is for appartmentnumbers, door numbers or similar extensions"]
["professiontitle",null,null,"Address lines","number of lines that shall be used for output (not complete implemented yet)"]
["salutarytitle",null,null,"City","Name of location referenced by ZIP-Code"]
["addrcomplement",null,null,"City Complement","If in D+A the street is not unique wihin an ZIP Code, then enter here the location or village that makes street name unique.\n\nFor Countries with usage of proincial codes, e.g. for USA you have to identify the state, then use this field to enter the area or region, state, province etc."]
["heading3",null,null,"Clear Field","Clears all fields to enter data manually."]
["heading2",null,null,"Close It","Closes UserForm."]
["citycomplement",null,null,"c/o Line","If within a company the mail shall be addressed to a special person:\n(To companyname)\nc/o Mrs. Smith\n\nif this letter was sent in behalf of another nat. person:\n(To Mr. Smith jun.)\nconcerning Mr. Smith sen.\n\nif this letter is sent using another person as transmitter:\n(To saving club)\nthough Mr. Smith"]
["postalcode",null,null,"Company","Opposite of Human"]
["city",null,null,"Confidential","Can only be assigned to D+A+CH addresses otherwise 5 lines cannot be granted."]
["zip",null,null,"Country","Country of addresse. Check if country is selected correctly. Some Countries in list have hints: Check them!"]
["country",null,null,"Name 1","In case of human: Include all academic titles, before, and after the name. Insert frist, second and surname. If line is too short: You can shorten second, then first name, skip \"after titles first\" then \"before titles\". Skip always lower titles first.\n\nFor companies this line is used always completely, other extension lines may not be  used, depending of  data."]
["number",null,null,"Name 2","For Companies an additional line for the name."]
["pobox",null,null,"Name 3","For Companies an additional line for the name."]
["street",null,null,"Human","Select type of addresse: Human for direct addresses as human, and other for all other kind of addresses"]
["coline",null,null,"Load Next Testcase",{"$f":"\"There are \"&Examples!E1&\" testcases. You can select the next testcase\"","v":"There are 40 testcases. You can select the next testcase"}]
["heading1",null,null,"Load Previous Testcase",{"$f":"\"There are \"&Examples!E4&\" testcases. You can select the last / previous  testcase\"","v":"There are  testcases. You can select the last / previous  testcase"}]
["confidential",null,null,"Number","Housenumber of addressee"]
["human","delete last",null,"PO Box","Post Office Box: If this field is used then street and number cannot be used, POBox and street are excluding logics."]
[null,null,null,"Postal Code","Internally generated code in front of zip-code. Shall not be used anymore, but to reduce to 5 lines this works still fine. So this code is officially not supported, but is so helpfull, that we cannot avoid to use it."]
[null,null,null,"Profession Name","This is the profession learned and usually executed, at least in former professional life. \ne.g. consultant"]
[null,null,null,"Profession Title","This are titles by professional or military education: \ne.g. Dipl.-Ing., General "]
[null,null,null,"Regular","non confidential"]
[null,null,null,"Salutary Title","To address natural poeple\ne.g. Mister, Mr., Mrs., Señora, Herr, Frau"]
[null,null,null,"Sender Country","Country of sender of mail. This is needed to identify domestic mailings."]
[null,null,null,"Street","If Street is used, POBox cannot be used. Street can be shortend by \"str.\" or similar abreviations according to the language of the country of the addresse."]
[null,null,null,"Zip-Code","Zip-Code in full length as it shall appear on address (e.g. for  USA with hypen inside)"]
[null,null,null,"Show Field Info","Opens this window to show this information."]
[null,null,null,"Show Country Hint","Shows information related to the country"]
["Domestic Country","Österreich"]
["Max. Number of Lines",5]
["Length of line",30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF($A48<>\"\",VLOOKUP($A48,$A$5:$AA$258,COLUMN(),FALSE),\"\")&IF($B48<>\"\",VLOOKUP($B48,$B$5:$AB$258,COLUMN($AB$1)-1,FALSE),\"\")","v":""}]
["List of Countries in Postal Codes",null,"Deutschland","Austria"]
[null,null,"Italien","Germany"]
[null,null,"Österreich","Italy"]
[null,null,"Schweiz","Switzerland"]
[null,null,"Afghanistan","Afghanistan"]
[null,null,"Ägypten","Albania"]
[null,null,"Albanien","Alderney"]
[null,null,"Alderney","Alderney Channel island"]
[null,null,"Algerien","Alderney, Channel islands"]
[null,null,"Amerikanisch Samoa","Algeria"]
[null,null,"Amerikanische Jungferninseln","American Samoa"]
[null,null,"Andorra","American Virgin Island"]
[null,null,"Angola","Andorra"]
[null,null,"Antarktis Territorium","Angola"]
[null,null,"Äquatorialguinea","Antarctica"]
[null,null,"Argentinien","Argentina"]
[null,null,"Aserbaidschan","Australia"]
[null,null,"Äthiopien","Azerbaijan"]
[null,null,"Australien","Bahamas"]
[null,null,"Bahamas","Bahrain"]
[null,null,"Bahrain","Bailiwick of Jersey"]
[null,null,"Bangladesh","Bangladesh"]
[null,null,"Barbados","Barbados"]
[null,null,"Belarus ","Belarus "]
[null,null,"Belgien","Belgium"]
[null,null,"Belize","Belize"]
[null,null,"Benin","Benin"]
[null,null,"Bermuda","Bermuda"]
[null,null,"Bolivien","Bolivia"]
[null,null,"Bosnien-Herzegowina","Bosnia and Herzegovina"]
[null,null,"Botswana","Botswana"]
[null,null,"Brasilien","Brazil"]
[null,null,"Britische  Jungferninseln","British Virgin Islands"]
[null,null,"Brunei Darussalam","Brunei Darussalam"]
[null,null,"Bulgarien","Bulgaria"]
[null,null,"Burkina Faso","Burkina Faso"]
[null,null,"Burundi","Burundi"]
[null,null,"Canton und Enderbury Inseln","Cambodia"]
[null,null,"Chile","Cameroon"]
[null,null,"China","Canada"]
[null,null,"Cook-Inseln","Canton and Enderbury Islands"]
[null,null,"Costa Rica","Cayman Islands"]
[null,null,"Côte d'Ivory","Central African Republic"]
[null,null,"Curacao","Channel Islands"]
[null,null,"Dänemark","Chile"]
[null,null,"Demokratische Republik Laos","China"]
[null,null,"Dominika","City of Vatican"]
[null,null,"Dominikanische Republik","Colombia"]
[null,null,"Dschibuti","Comoros"]
[null,null,"Ecuador","Congo"]
[null,null,"El Salvador","Cook Islands"]
[null,null,"Elfenbeinküste","Costa Rica"]
[null,null,"England","Côte d'Ivory"]
[null,null,"Eritrea","Côte d'Ivoire"]
[null,null,"Estland","Croatia"]
[null,null,"Falklandinseln","Cuba"]
[null,null,"Färöer","Curacao"]
[null,null,"Fidschi","Cyprus"]
[null,null,"Finnland","Czech Republic"]
[null,null,"Fischer-Inseln","Denmark"]
[null,null,"Formosa ","Dominican Republic"]
[null,null,"Frankreich","Dominika"]
[null,null,"Französich Polynesien","Dschibuti"]
[null,null,"Französisch Guayana","Ecuador"]
[null,null,"Gambia","Egypt"]
[null,null,"Georgien","El Salvador"]
[null,null,"Ghana","England"]
[null,null,"Gibraltar","Equatorial Guinea"]
[null,null,"Grenada","Eritrea"]
[null,null,"Griechenland","Estonia"]
[null,null,"Grönland","Ethiopia"]
[null,null,"Grossbritanien","Falkland Islands"]
[null,null,"Guadeloupe","Fiji"]
[null,null,"Guam","Finland"]
[null,null,"Guatemala","Føroyar"]
[null,null,"Guayana","France"]
[null,null,"Guernsey","French Guyana"]
[null,null,"Guinea","French Polynesia"]
[null,null,"Guyana","Gambia"]
[null,null,"Haiti","Georgia"]
[null,null,"Honduras","Ghana"]
[null,null,"Hong Kong","Gibraltar"]
[null,null,"Hongkong","Great Britain"]
[null,null,"Indien","Greece"]
[null,null,"Indonesien","Greenland"]
[null,null,"Insel Alderney","Grenada"]
[null,null,"Insel Guernsey","Guadeloupe"]
[null,null,"Insel Jersey","Guam"]
[null,null,"Insel Man","Guatemala"]
[null,null,"Irak","Guernsey"]
[null,null,"Irak","Guernsey Channel Island"]
[null,null,"Irak","Guernsey, Channel Islands"]
[null,null,"Iran","Guinea"]
[null,null,"Iran","Guyana"]
[null,null,"Irland","Guyana"]
[null,null,"Irland","Haiti"]
[null,null,"Island","Honduras"]
[null,null,"Israel","Hong Kong"]
[null,null,"Jamaika","Hongkong"]
[null,null,"Japan","Hungary"]
[null,null,"Jersey","Iceland"]
[null,null,"Jordanien","Ind. State of Papua New Guinea"]
[null,null,"Jugoslawien ","Indep. State of Samoa"]
[null,null,"Jungferninseln","India"]
[null,null,"Kaimaninseln","Indonesia"]
[null,null,"Kambodscha","Iran"]
[null,null,"Kamerun","Iraq"]
[null,null,"Kanada","Ireland"]
[null,null,"Kanalinseln","Isle of man"]
[null,null,"Kasachstan","Isle of man"]
[null,null,"Katar","Israel"]
[null,null,"Kenia","Jamaica"]
[null,null,"Kirgisistan","Japan"]
[null,null,"Kiribati","Jersey"]
[null,null,"Kolumbien","Jersey Channel Island"]
[null,null,"Komoren","Jersey, Channel Islands"]
[null,null,"Kongo","Jordan"]
[null,null,"Königreich Saudi Arabien","Kazakstan"]
[null,null,"Kroatien","Kenya"]
[null,null,"Kuba","Kingdom of Saudi Arabia"]
[null,null,"Kuwait","Kiribati"]
[null,null,"Laos","Korean Republic"]
[null,null,"Lesotho","Kuwait"]
[null,null,"Lettland","Kyrgyzstan"]
[null,null,"Libanon","Laos"]
[null,null,"Liberia","Laos Democratic Republic"]
[null,null,"Libyen","Latvia"]
[null,null,"Liechtenstein","Lebanon"]
[null,null,"Litauen","Lesotho"]
[null,null,"Luxemburg","Liberia"]
[null,null,"Macau","Liechtenstein"]
[null,null,"Madagaskar","Lithuania"]
[null,null,"Malawi","Luxembourg"]
[null,null,"Malaysia","Lybia"]
[null,null,"Mali","Macau"]
[null,null,"Malta","Macedonia "]
[null,null,"Man","Madagascar"]
[null,null,"Marokko","Malawi"]
[null,null,"Marshallinseln","Malaysia"]
[null,null,"Martinique","Mali"]
[null,null,"Matsu ","Malta"]
[null,null,"Mauretanien","Man"]
[null,null,"Mauritius","Marshal Island"]
[null,null,"Mayotte","Martinique"]
[null,null,"Mazedonien","Matsu "]
[null,null,"Mexiko","Mauritania"]
[null,null,"Mikronesien","Mauritius"]
[null,null,"Moldawien","Mayotte"]
[null,null,"Monaco","Mexico"]
[null,null,"Mongolei","Micronesia"]
[null,null,"Montenegro","Moldova"]
[null,null,"Montserrat","Monaco"]
[null,null,"Mosambik","Mongolia"]
[null,null,"Myanmar","Montenegro"]
[null,null,"Namibia","Montserrat"]
[null,null,"Neukaledonien","Morocco"]
[null,null,"Neuseeland","Mozambique"]
[null,null,"Nicaragua","Myanmar"]
[null,null,"Niederlande","n.a."]
[null,null,"Niederländische Antillen","Namibia"]
[null,null,"Niger","Netherlands"]
[null,null,"Nigeria","Netherlands Antilles"]
[null,null,"Niue","New Caledonia"]
[null,null,"Nordkorea","New Zealand"]
[null,null,"Nördliche Marianen","Nicaragua"]
[null,null,"Norwegen","Niger"]
[null,null,"Oman","Nigeria"]
[null,null,"Pakistan","Niue"]
[null,null,"Palau","North Korea"]
[null,null,"Panama","Northern Mariana Islands"]
[null,null,"Papua Neuguinea","Norway"]
[null,null,"Paraguay","Nutze Fischer Islands"]
[null,null,"Pazifische Inseln","Oman"]
[null,null,"Penghu","Pakistan"]
[null,null,"Peru","Palau"]
[null,null,"Pescadores Islands","Panama"]
[null,null,"Philippinen","Paraguay"]
[null,null,"Pitcairn Inseln","Penghu"]
[null,null,"Polen","Penghu islands"]
[null,null,"Polynesien","People's Republic of China"]
[null,null,"Portugal","Peru"]
[null,null,"Puerto Rico","Philippines"]
[null,null,"Quemoy ","Pitcairn Islands"]
[null,null,"Republik Belarus ","Poland"]
[null,null,"Republik Kiribati","Polynesia"]
[null,null,"Republik Korea ","Portugal"]
[null,null,"Reunion","Puerto Rico"]
[null,null,"Ruanda","Qatar"]
[null,null,"Rumänien","Quemoy "]
[null,null,"Russische Föderation","Republic of Belarus"]
[null,null,"Sabah und Labuan","Republic of Kiribati"]
[null,null,"Sambia","Republic of Yemen"]
[null,null,"Samoa","Reunion"]
[null,null,"Samoa","Romania"]
[null,null,"San Marino","Russian Federation"]
[null,null,"Sansibar","Rwanda"]
[null,null,"Saudiarabien","Sabah and Labuan"]
[null,null,"Schweden","Samoa"]
[null,null,"Senegal","San Marino"]
[null,null,"Serbien","Saudi Arabia"]
[null,null,"Seychellen","Senegal"]
[null,null,"Sierra Leone","Serbia"]
[null,null,"Simbabwe","Seychelles"]
[null,null,"Singapur","Sierra Leone"]
[null,null,"Slowakei","Singapore"]
[null,null,"Slowenien","Slovakia"]
[null,null,"Somalia","Slovenia"]
[null,null,"Sowjetunion","Somalia"]
[null,null,"Spanien","South Africa"]
[null,null,"Sri Lanka","Soviet Union"]
[null,null,"St. Helena","Spain"]
[null,null,"St. Lucia","Sri Lanka"]
[null,null,"St. Pierre / Miquelon","St. Helena"]
[null,null,"St. Vincent","St. Lucia"]
[null,null,"Sudan","St. Pierre / Miquelon"]
[null,null,"Südafrika","St. Vincent"]
[null,null,"Surinam","Sudan"]
[null,null,"Swasiland","Suriname"]
[null,null,"Syrien","Swaziland"]
[null,null,"Tadschikistan","Sweden"]
[null,null,"Taiwan","Syria"]
[null,null,"Tansania","Taiwan"]
[null,null,"Thailand","Tajikistan"]
[null,null,"Togo","Tanzania"]
[null,null,"Tokelau Inseln","Thailand"]
[null,null,"Tonga","Togo"]
[null,null,"Trinidad und Tobago","Tokelau Islands"]
[null,null,"Tschechische Republik","Tonga"]
[null,null,"Türkei","Trinidad and Tobago"]
[null,null,"Tunesien","Trust Territory of the Pacific Islands"]
[null,null,"Turkmenistan","Tunisia"]
[null,null,"Turks- und Caicosinseln","Turkey"]
[null,null,"Tuvalu","Turkmenistan"]
[null,null,"Uganda","Turks and Caicos Islands"]
[null,null,"Ukraine","Tuvalu"]
[null,null,"Ungarn","Uganda"]
[null,null,"Uruguay","Ukraine"]
[null,null,"Usbekistan","United Arab Emirates"]
[null,null,"Vanatua","United States of America"]
[null,null,"Vatikan","Uruguay"]
[null,null,"Vatikanstadt","Uzbekistan"]
[null,null,"Venezuela","Vanatua"]
[null,null,"Vereinigte Arabische Emirate","Vatican"]
[null,null,"Vereinigte Staaten von Amerika","Venezuela"]
[null,null,"Vietnam","Vietnam"]
[null,null,"Volksrepublik China","Virgin Island"]
[null,null,"Volksrepublik Jemen","West Samoa"]
[null,null,"West Samoa","Zaire"]
[null,null,"Zaire","Zambia"]
[null,null,"Zentralafrikanische Republik","Zanzibar"]
[null,null,"Zypern","Zimbabwe"]