{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["8537","Customer confirmation","Currency-codes","IBAN","Codes&Tables"],"not_rendered":{"images":2,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"8537","index":0,"n_rows":234,"n_cols":17,"rows_kept":234,"merged":[[0,13,3,15],[5,18,8,25],[6,1,6,2],[6,4,6,7],[6,9,23,16],[8,1,8,3],[9,1,9,7],[9,18,11,25],[11,1,11,7],[12,1,12,7],[12,19,13,25],[13,1,13,7],[14,1,14,7],[14,18,20,25],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[28,0,29,0],[28,1,28,7],[30,1,30,7],[32,1,32,7],[34,1,34,4],[34,6,34,7],[36,1,36,7],[37,1,37,7],[38,1,38,7],[39,0,40,0],[39,1,39,7],[43,9,43,11],[43,12,43,16],[45,14,45,16],[51,9,51,10],[51,12,51,16],[55,4,55,6],[55,9,55,16],[62,1,62,7],[63,1,63,7],[63,14,63,16],[64,1,64,7],[65,1,65,7],[65,9,65,16],[66,9,68,16],[68,0,71,0],[68,1,68,7],[69,1,69,7],[69,9,70,16],[70,1,70,7],[71,1,71,7]]}
[null,"International Transfer Order",{"$nulls":7},"To",{"$nulls":3},"*BC63+*",null,null,"BC63+"]
[]
[]
[null,"Please transfer as specified below"]
[]
[null,"Currency",{"$nulls":3},"Amount (in figures)"]
[{"$nulls":9},"This form is to be used for all international transfers\nin Euro and foreign currencies, which do not meet the criteria for a SEPA payment (see below).\nPlease indicate the required data concerning the beneficiary and\nthe beneficiary's bank account and bank in terms of IBAN (international\nbank account number) and BIC (Bank identifier code).\n\nIf it is required to purchase a currency, the order will be executed only after the currency transaction has been completed.\n\n\nFor all conditions in respect of international transfers please refer to\nthe price list displayed in our branches - available at  https://www.bankaustria.at/files/preise_auslandszahlungsverkehr_en_bis_09102023.pdf and https://www.bankaustria.at/files/preise_auslandszahlungsverkehr_en.pdf"]
["ACCOUNT",{"$f":"IF(ISNA(MATCH(B7,$A$79:$A$234,0)),\"currency invalid!!!\",\"account-number (without '-','/')\")","v":"currency invalid!!!"},{"$nulls":4},"Date (DD.MM.YYYY)"]
["NO.",{"$nulls":5},{"$f":"TODAY()","v":"2026-01-19"}]
["HOLDER"]
[null,"ordering customer max 4x35 spaces"]
["NAME"]
["NAME"]
["STREET"]
[]
[]
[]
[null,"Purpose of payment max. 4x35 spaces"]
[]
[]
[]
[]
[]
[]
[null,"Beneficiary max 4x35 spaces",{"$nulls":7},"Criteria for SEPA payments:"]
["NAME"]
["NAME",{"$nulls":8},"- Transfer currency: Euro"]
["STREET",{"$nulls":8},"- The beneficiary's bank account is stated in terms of a valid IBAN"]
[{"$nulls":9},"- Cross-border payment between the payer's and beneficiary's banks "]
[null,"Beneficiary's Bank ",{"$nulls":7},"  within the EU member states and the EEA member states"]
["IBAN **)",{"$nulls":8},"  Iceland, Norway and Liechtenstein or a SEPA contry outside EEA"]
["or",{"$f":"IF(B31=\"\",\"\",IBAN!C21)","v":""},{"$nulls":7},"  (e.g. United Kingdom or Switzerland), detailed list:"]
["ACC.NO.",{"$nulls":8},"  https://www.bankaustria.at/files/sepa-kundeninfo-en.pdf"]
[null,"BIC Code/SWIFT Addr.",{"$nulls":3},"Routing-Type / Routing-Code",{"$nulls":3},"- Shared fees: Bank charges in Austria debit to payer, "]
[{"$nulls":9},"  outside Austria debit to beneficiary"]
[null,"Bank max 4x35 spaces",{"$nulls":7},"- No special instructions under:"]
["NAME",{"$nulls":8},"   “Mode of transfer”"]
["NAME",{"$nulls":8},"   “Special statements by payer”"]
["STREET"]
[]
[null,"bank charges (for transfers outside EEA) *)"]
[null,"in Austria: debit to",null,null," payer",null,null," beneficiary",null,"For internal use by bank:"]
[]
[null,"outside Austria",null,null," payer",null,null," beneficiary",null,"FBAWI"]
[null,{"$f":"IF(AND(D42<>\"\",G42<>\"\"),\"charges option not allowed\",\"\")&IF(AND(D44<>\"\",G44<>\"\"),\"charges option not allowed\",\"\")&IF(AND(G42<>\"\",D44<>\"\"),\"charges option not allowed\",\"\")","v":""}]
[null,"*) transfers within EEA area or IF NOT SPECIFIED:",{"$nulls":7},"Country of Banking Connection"]
[null,"     charges in Austria debit to payer,"]
[null,"     charges outside Austria debit to beneficiary",{"$nulls":8},"Transfer-order issued by branch"]
[null,"MODE OF TRANSFER:",{"$nulls":7},"for cheque remittance only"]
[null,"x"," Standard ",null," Cheque ",null,null," URGENT",null,null," Registered",null,null," Express"]
[{"$nulls":7},"Currency acc.",null,"Currency for charges",null,null,"Account for charges (if different from standard)"]
[{"$nulls":4}," EUR-account"]
[]
[null,null,"T=FX/forward contract",{"$nulls":6},{"$f":"IF(J52<>\"\",IF(ISNA(MATCH(J52,$A$79:$A$234,0)),\"incorrect Currency!!!\",\"\"),\"\")","v":""},null,null,{"$f":"IF(AND(J52<>\"\",M52=\"\"),\"please insert a charges account no.\",\"\")","v":""}]
[]
[null,null,"K=FX/spot contract",{"$nulls":4}," Number",null,"geprüft / Stempel (bankinternal only)"]
[null,null,"V=Loan"]
[null,{"$f":"IF(AND($B$50<>\"\",$G$50<>\"\"),\"mode of transfer: only standard or urgent allowed\",\"\")","v":""}]
[null,{"$f":"IF(AND($B$50<>\"\",$D$50<>\"\"),\"mode of transfer: only standard or cheque allowed\",\"\")","v":""}]
[null,{"$f":"IF(AND(D50<>\"\",G50<>\"\"),\"mode of transfer cheque: additional only 'express' instead *urgent' is allowed \",\"\")","v":""}]
[null,{"$f":"IF(AND(OR(B50<>\"\",G50<>\"\"),J50<>\"\"),\"registered only possible for cheque\",\"\")","v":""}]
[]
[{"$nulls":14},"Phone-No. of payer"]
[]
[]
[{"$nulls":9},{"$f":"IF(J67=\"IBAN is incorrect\",\"Unable to execute this payment\",\"\")","v":""}]
[null,"Special statements by payer"]
[]
["V 01.26"]
[]
[]
[{"$nulls":9},"Account signature of payer"]
[]
[null,"**) \"IBAN\"field: Please indicate the International Bank Account Number of the beneficiary here (not in the \"Account number\" field)"]
[]
[]
[]
[]
["AED",{"$nulls":4},10000,null,"DEV","Verein.-Arabische-Emirate-Dirham"]
["AFA",{"$nulls":7},"Afghani"]
["ALL",{"$nulls":4},10000,null,null,"Albanischer Lek                 "]
["AMD",{"$nulls":7},"Armenien-Dram                   "]
["AOA",{"$nulls":7},"Kwanza                          "]
["AON",{"$nulls":7},"Angola-Kwanza neu               "]
["AOR",{"$nulls":7},"Angola-Kwanza Rejusted          "]
["ARS",{"$nulls":7},"Argentinischer Peso             "]
["AUD",{"$nulls":4},10000,null,"DEV","Australischer Dollar            "]
["AWG",{"$nulls":7},"Aruba-Gulden                    "]
["AZM",{"$nulls":7},"Aserbeidschan-Manat             "]
["BAM",{"$nulls":7},"Mark Convertible                "]
["BBD",{"$nulls":7},"Barbados-Dollar                 "]
["BDT",{"$nulls":7},"Bangladesch-Taka                "]
["BHD",{"$nulls":7},"Bahrain-Dinar                   "]
["BIF",{"$nulls":7},"Burundi-Franc                   "]
["BMD",{"$nulls":7},"Bermuda-Dollar                  "]
["BND",{"$nulls":7},"Brunei-Dollar                   "]
["BOB",{"$nulls":7},"Bolivien-Boliviano              "]
["BRL",{"$nulls":7},"Brasilien-Real                  "]
["BSD",{"$nulls":7},"Bahama-Dollar                   "]
["BTN",{"$nulls":7},"Bhutan-Ngultrum                 "]
["BWP",{"$nulls":7},"Botswana-Pula                   "]
["BYR",{"$nulls":7},"Belarussian Ruble               "]
["BZD",{"$nulls":7},"Belize-Dollar                   "]
["CAD",{"$nulls":4},10000,null,"DEV","Kanadischer Dollar              "]
["CDF",{"$nulls":7},"Franc congolais                 "]
["CHF",{"$nulls":4},50000,null,"DEV","Schweizer Franken               "]
["CLP",{"$nulls":7},"Chilenischer Peso               "]
["CNY",{"$nulls":4},10000,null,null,"China-Yuan Renminbi             "]
["COP",{"$nulls":7},"Kolumbianischer Peso            "]
["CRC",{"$nulls":7},"Costa-Rica-Colon                "]
["CUP",{"$nulls":7},"Kubanischer Peso                "]
["CVE",{"$nulls":7},"Kap-Verde-Escudo                "]
["CZK",{"$nulls":4},100000,null,"DEV","Tschechische Krone              "]
["DJF",{"$nulls":7},"Dschibuti-Franc                 "]
["DKK",{"$nulls":4},100000,null,"DEV","Dänische Krone                  "]
["DOP",{"$nulls":7},"Dominikanischer Peso            "]
["DZD",{"$nulls":6},"DEV","Algerischer Dinar               "]
["ECS",{"$nulls":7},"Ecuador-Sucre                   "]
["EGP",{"$nulls":7},"Ägyptisches Pfund               "]
["ERN",{"$nulls":7},"Eritrea-Nakfa                   "]
["ETB",{"$nulls":7},"Äthiopien-Birr                  "]
["EUR",null,1,null,null,999999999999999,null,"MUM","Euro                            "]
["FJD",{"$nulls":7},"Fidschi-Dollar                  "]
["FKP",{"$nulls":7},"Falkland-Pfund                  "]
["GBP",{"$nulls":4},10000,null,"DEV","Pfund Sterling                  "]
["GEL",{"$nulls":7},"Georgien-Lari                   "]
["GHS",{"$nulls":7},"Ghana-Cedi                      "]
["GIP",{"$nulls":7},"Gibraltar Pfund                 "]
["GMD",{"$nulls":7},"Gambia-Dalasi                   "]
["GNF",{"$nulls":7},"Guinea-Franc                    "]
["GTQ",{"$nulls":7},"Guatemala-Quetzal               "]
["GYD",{"$nulls":7},"Guyana-Dollar                   "]
["HKD",{"$nulls":4},50000,null,"DEV","Hongkong-Dollar                 "]
["HNL",{"$nulls":7},"Honduras-Lempira                "]
["HTG",{"$nulls":7},"Haiti-Gourde                    "]
["HUF",{"$nulls":6},"DEV","Ungarischer Forint              "]
["IDR",{"$nulls":6},"DEV","Indonesische Rupiah             "]
["ILS",{"$nulls":4},1000,null,"DEV","Israel-Neuer Shekel             "]
["INR",{"$nulls":4},100000,null,"DEV","Indische Rupie                  "]
["IQD",{"$nulls":7},"Irak Dinar                      "]
["IRR",{"$nulls":7},"Iran Rial                       "]
["ISK",{"$nulls":6},"DEV","Isländische Krone               "]
["JMD",{"$nulls":7},"Jamaika-Dollar                  "]
["JOD",{"$nulls":7},"Jordan-Dinar                    "]
["JPY",{"$nulls":4},1000000,null,"DEV","Yen                             "]
["KES",{"$nulls":4},100000,null,"DEV","Kenia-Schilling                 "]
["KGS",{"$nulls":7},"Kirgisistan-Som                 "]
["KHR",{"$nulls":7},"Kambodscha-Riel                 "]
["KMF",{"$nulls":7},"Komoren-Franc                   "]
["KPW",{"$nulls":7},"Nordkoreanischer Won            "]
["KRW",{"$nulls":7},"Südkoreanischer Won             "]
["KWD",{"$nulls":4},1000,null,"DEV","Kuwait-Dinar                    "]
["KYD",{"$nulls":7},"Kaiman-Dollar                   "]
["KZT",{"$nulls":7},"Kasachstan-Tenge                "]
["LAK",{"$nulls":7},"Laos-Kip                        "]
["LBP",{"$nulls":7},"Libanesisches Pfund             "]
["LKR",{"$nulls":7},"Sri-Lanka-Rupie                 "]
["LRD",{"$nulls":7},"Liberianischer Dollar           "]
["LSL",{"$nulls":7},"Lesotho-Loti                    "]
["LYD",{"$nulls":7},"Libyscher Dinar                 "]
["MAD",{"$nulls":4},10000,null,"DEV","Marokkanischer Dirham           "]
["MDL",{"$nulls":7},"Moldau-Leu                      "]
["MGF",{"$nulls":7},"Madagaskar-Franc                "]
["MKD",{"$nulls":7},"Mazedonien-Neuer Denar          "]
["MMK",{"$nulls":7},"Myanmar-Kyat                    "]
["MNT",{"$nulls":7},"Mongolei-TOGROG                 "]
["MOP",{"$nulls":7},"Macau-Pataca                    "]
["MRO",{"$nulls":7},"Mauretanien-Ouguiya             "]
["MUR",{"$nulls":7},"Mauritius-Rupie                 "]
["MVR",{"$nulls":7},"Malediven-Rufiyaa               "]
["MWK",{"$nulls":7},"Malawi-Kwacha                   "]
["MXN",{"$nulls":7},"Mexikanischer Peso              "]
["MXV",{"$nulls":7},"Mexican Unidad de Inversion     "]
["MYR",{"$nulls":4},10000,null,"DEV","Malaysischer Ringgit            "]
["MZM",{"$nulls":7},"Mosambik-Metical                "]
["NAD",{"$nulls":7},"Namibia-Dollar                  "]
["NGN",{"$nulls":7},"Nigeria-Naira                   "]
["NIO",{"$nulls":7},"Nicaragua-Gold-Cordoba          "]
["NOK",{"$nulls":4},100000,null,"DEV","Norwegische Krone               "]
["NPR",{"$nulls":7},"Nepalesische Rupie              "]
["NZD",{"$nulls":4},10000,null,"DEV","Neuseeland-Dollar               "]
["OMR",{"$nulls":7},"Omani-Rial                      "]
["PAB",{"$nulls":7},"Panama-Balboa                   "]
["PEN",{"$nulls":7},"Peru-Neuer Sol                  "]
["PGK",{"$nulls":7},"Papua-Neuguinea-Kina            "]
["PHP",{"$nulls":7},"Philippinischer Peso            "]
["PKR",{"$nulls":7},"Pakistanische Rupie             "]
["PLN",{"$nulls":4},10000,null,"DEV","Polnischer Zloty Neu            "]
["PYG",{"$nulls":7},"Paraguay-Guarani                "]
["QAR",{"$nulls":7},"Katar-Riyal                     "]
["RON",{"$nulls":4},10000,null,"DEV","Rumänische Leu (neu)                             "]
["RSD",{"$nulls":6},"DEV","Serbischer Dinar (Neu)"]
["RUB",{"$nulls":6},"DEV","Russische Föderation-Rubel (Neu)"]
["RWF",{"$nulls":7},"Ruanda-Franc                    "]
["SAR",{"$nulls":4},10000,null,"DEV","Saudi Riyal                     "]
["SBD",{"$nulls":7},"Salomonen-Dollar                "]
["SCR",{"$nulls":7},"Seychellen-Rupie                "]
["SDD",{"$nulls":7},"Sudanesischer Dinar             "]
["SEK",{"$nulls":4},100000,null,"DEV","Schwedische Krone               "]
["SGD",{"$nulls":4},10000,null,"DEV","Singapur-Dollar                 "]
["SHP",{"$nulls":7},"St. Helena-Pfund                "]
["SLL",{"$nulls":7},"Sierra Leone-Leone              "]
["SOS",{"$nulls":7},"Somalia-Schilling               "]
["SRG",{"$nulls":7},"Suriname-Gulden                 "]
["STD",{"$nulls":7},"Sao Tome und Principe Dobra     "]
["SVC",{"$nulls":7},"El-Salvador-Colon               "]
["SYP",{"$nulls":7},"Syrisches Pfund                 "]
["SZL",{"$nulls":7},"Swasiland-Lilangeni             "]
["THB",{"$nulls":4},100000,null,"DEV","Thailand-Baht                   "]
["TMM",{"$nulls":7},"Turkmenistan-Manat              "]
["TND",{"$nulls":4},1000,null,"DEV","Tunesischer Dinar               "]
["TOP",{"$nulls":7},"Tonga-Pa'anga                   "]
["TRY",{"$nulls":4},20000,null,"DEV","Türkische Lira                  "]
["TTD",{"$nulls":7},"Trinidad-und-Tobago-Dollar      "]
["TWD",{"$nulls":7},"Neuer Taiwan Dollar             "]
["TZS",{"$nulls":7},"Tansania-Schilling              "]
["UAH",{"$nulls":7},"Ukraine-Griwna                  "]
["UGX",{"$nulls":7},"Uganda-Schilling                "]
["USD",{"$nulls":4},10000,null,"DEV","US-Dollar                       "]
["UYU",{"$nulls":7},"Uruguayischer Peso              "]
["UZS",{"$nulls":7},"Usbekistan-Sum                  "]
["VEB",{"$nulls":7},"Venezuela-Bolivar               "]
["VND",{"$nulls":7},"Vietnam-Dong                    "]
["VUV",{"$nulls":7},"Vanuatu-Vatu                    "]
["WST",{"$nulls":7},"Samoa-Tala                      "]
["XAF",{"$nulls":7},"CFA-Franc-Äquatorial            "]
["XAU",{"$nulls":7},"Gold (Unzen)                    "]
["XCD",{"$nulls":7},"Ostkaribischer Dollar           "]
["XOF",{"$nulls":7},"CFA-Franc-West                  "]
["XPF",{"$nulls":7},"CFP-Franc-Neukaledonien         "]
["YER",{"$nulls":7},"Jemen-Rial                      "]
["ZAR",{"$nulls":4},10000,null,"DEV","Rand                            "]
["ZMK",{"$nulls":7},"Sambia-Kwacha                   "]
["ZWD",{"$nulls":7},"Simbabwe-Dollar                 "]

{"sheet":"Customer confirmation","index":1,"n_rows":74,"n_cols":15,"rows_kept":74,"merged":[[2,1,2,5],[3,14,5,16],[6,1,6,2],[6,4,6,7],[9,1,9,7],[12,11,13,15],[14,0,15,0],[18,9,28,16],[28,0,29,0],[34,1,34,4],[34,6,34,7],[39,0,40,0],[55,4,55,6],[59,13,59,15],[68,0,71,0],[69,9,70,16]]}
[null,"International Transfer Order",{"$nulls":7},"To"]
[]
[]
[null,"Please transfer as specified below",{"$nulls":12},"copy for ordering customer"]
[]
[null,"Currency",{"$nulls":3},"Amount (in figures)"]
[null,{"$f":"'8537'!B7:C7","v":0},null,null,{"$f":"'8537'!E7:H7","v":{"v":0,"d":"0.00"}}]
["ACCOUNT",{"$nulls":5},"Date (DD,MM,YYYY)"]
["NO.",{"$f":"'8537'!B9","v":0},{"$nulls":4},{"$f":"'8537'!G9","v":"2026-01-19"}]
["HOLDER",{"$f":"'8537'!B10","v":0}]
[null,"ordering customer max 4x35 spaces"]
["NAME",{"$f":"'8537'!B12","v":0}]
["NAME",{"$f":"'8537'!B13","v":0},{"$nulls":9},"assumption confirmation"]
["STREET",{"$f":"'8537'!B14","v":0}]
[null,{"$f":"'8537'!B15","v":0}]
[{"$nulls":11},"is not considered as"]
[{"$nulls":11},"advice of deal"]
[null,"Purpose of payment max. 4x35 spaces"]
[null,{"$f":"'8537'!B19","v":0},{"$nulls":7},"If it is required to purchase a currency, the order will be executed only  after the currency transaction has been completed.\n"]
[null,{"$f":"'8537'!B20","v":0}]
[null,{"$f":"'8537'!B21","v":0}]
[null,{"$f":"'8537'!B22","v":0}]
[]
[]
[null,"Beneficiary max 4x35 spaces"]
["NAME",{"$f":"'8537'!B26","v":0}]
["NAME",{"$f":"'8537'!B27","v":0}]
["STREET",{"$f":"'8537'!B28","v":0}]
[null,{"$f":"'8537'!B29","v":0}]
[null,"Beneficiary's Bank"]
["IBAN **)",{"$f":"'8537'!B31","v":0}]
["or"]
["ACC.NO.",{"$f":"'8537'!B33","v":0}]
[null,"BIC Code/SWIFT Addr.",{"$nulls":3},"Routing-Type / Routing Code"]
[null,{"$f":"'8537'!B35","v":0},{"$nulls":3},{"$f":"'8537'!F35","v":0},{"$f":"'8537'!G35","v":0}]
[null,"Bank max 4x35 spaces "]
["NAME",{"$f":"'8537'!B37","v":0}]
["NAME",{"$f":"'8537'!B38","v":0}]
["STREET",{"$f":"'8537'!B39","v":0}]
[null,{"$f":"'8537'!B40","v":0}]
[null,"bank charges (for transfers outside EEA) *)"]
[null,"in Austria: debit to",null,null," payer",null,null," beneficiary"]
[]
[null,"outside Austria",null,null," payer",null,null," beneficiary"]
[null,{"$f":"IF(AND(D42<>\"\",G42<>\"\"),\"charges option not allowed\",\"\")&IF(AND(D44<>\"\",G44<>\"\"),\"charges option not allowed\",\"\")&IF(AND(G42<>\"\",D44<>\"\"),\"charges option not allowed\",\"\")","v":""}]
[null,"*) transfers within EEA area or IF NOT SPECIFIED:",{"$nulls":7},"Country of Banking Connection",{"$nulls":4},{"$f":"'8537'!O46","v":0}]
[null,"charges in Austria debit to payer,"]
[null,"charges outside Austria debit to beneficiary",{"$nulls":7},{"$f":"'8537'!J48","v":0},"Transfer-order issued by branch"]
[null,"MODE OF TRANSFER:",{"$nulls":7},"for cheque remittance only"]
[null,{"$f":"'8537'!B50","v":"x"}," Standard ",{"$f":"'8537'!D50","v":0}," Cheque ",null,{"$f":"'8537'!G50","v":0}," URGENT",null,{"$f":"'8537'!J50","v":0}," Registered",null,{"$f":"'8537'!M50","v":0}," Express"]
[{"$nulls":7},"Currency acc.",null,"Currency for charges",null,null,"Account for charges (if different from standard)"]
[null,{"$f":"'8537'!B52","v":0},null,{"$f":"'8537'!D52","v":0}," EUR-account",null,null,{"$f":"'8537'!H52","v":0},null,{"$f":"'8537'!J52","v":0},null,null,{"$f":"'8537'!M52","v":0}]
[]
[null,null,"T= FX/forward contract"]
[]
[null,{"$f":"'8537'!B56","v":0},"K=FX/spot contract",null,{"$f":"'8537'!E56","v":0},null,null," Number"]
[null,null,"V=Loan"]
[]
[]
[]
[]
[]
[{"$nulls":14},"Phone-No. of payer"]
[{"$nulls":14},{"$f":"'8537'!O64","v":0}]
[null,{"$f":"'8537'!B65","v":0}]
[null,{"$f":"'8537'!B66","v":0}]
[null,"Special statements by payer"]
[]
[{"$f":"'8537'!A69:A72","v":"V 01.26"},{"$f":"'8537'!B69","v":0}]
[null,{"$f":"'8537'!B70","v":0},{"$nulls":7},{"$f":"'8537'!J70:Q71","v":0}]
[null,{"$f":"'8537'!B71","v":0}]
[null,{"$f":"'8537'!B72","v":0},{"$nulls":7},"Account signature of payer"]
[]
[null,"**) \"IBAN\"field: Please indicate the International Bank Account Number of the beneficiary here (not in the \"Account number\" field)"]

{"sheet":"Currency-codes","index":2,"n_rows":159,"n_cols":2,"rows_kept":159}
["ISO-Code","Currency"]
["AED","Verein.-Arabische-Emirate-Dirham"]
["AFA","Afghani"]
["ALL","Albanischer Lek                 "]
["AMD","Armenien-Dram                   "]
["ANG","Niederländischer Antillen Gulden"]
["AOA","Kwanza                          "]
["AON","Angola-Kwanza neu               "]
["AOR","Angola-Kwanza Rejusted          "]
["ARS","Argentinischer Peso             "]
["AUD","Australischer Dollar            "]
["AWG","Aruba-Gulden                    "]
["AZM","Aserbeidschan-Manat             "]
["BAM","Mark Convertible                "]
["BBD","Barbados-Dollar                 "]
["BDT","Bangladesch-Taka                "]
["BHD","Bahrain-Dinar                   "]
["BIF","Burundi-Franc                   "]
["BMD","Bermuda-Dollar                  "]
["BND","Brunei-Dollar                   "]
["BOB","Bolivien-Boliviano              "]
["BRL","Brasilien-Real                  "]
["BSD","Bahama-Dollar                   "]
["BTN","Bhutan-Ngultrum                 "]
["BWP","Botswana-Pula                   "]
["BYR","Belarussian Ruble               "]
["BZD","Belize-Dollar                   "]
["CAD","Kanadischer Dollar              "]
["CDF","Franc congolais                 "]
["CHF","Schweizer Franken               "]
["CLP","Chilenischer Peso               "]
["CNY","China-Yuan Renminbi             "]
["COP","Kolumbianischer Peso            "]
["CRC","Costa-Rica-Colon                "]
["CUP","Kubanischer Peso                "]
["CVE","Kap-Verde-Escudo                "]
["CZK","Tschechische Krone              "]
["DJF","Dschibuti-Franc                 "]
["DKK","Dänische Krone                  "]
["DOP","Dominikanischer Peso            "]
["DZD","Algerischer Dinar               "]
["ECS","Ecuador-Sucre                   "]
["EGP","Ägyptisches Pfund               "]
["ERN","Eritrea-Nakfa                   "]
["ETB","Äthiopien-Birr                  "]
["EUR","Euro                            "]
["FJD","Fidschi-Dollar                  "]
["FKP","Falkland-Pfund                  "]
["GBP","Pfund Sterling                  "]
["GEL","Georgien-Lari                   "]
["GHS","Ghana-Cedi                      "]
["GIP","Gibraltar Pfund                 "]
["GMD","Gambia-Dalasi                   "]
["GNF","Guinea-Franc                    "]
["GTQ","Guatemala-Quetzal               "]
["GYD","Guyana-Dollar                   "]
["HKD","Hongkong-Dollar                 "]
["HNL","Honduras-Lempira                "]
["HRK","Kroatien-Kuna                   "]
["HTG","Haiti-Gourde                    "]
["HUF","Ungarischer Forint              "]
["IDR","Indonesische Rupiah             "]
["ILS","Israel-Neuer Shekel             "]
["INR","Indische Rupie                  "]
["IQD","Irak Dinar                      "]
["IRR","Iran Rial                       "]
["ISK","Isländische Krone               "]
["JMD","Jamaika-Dollar                  "]
["JOD","Jordan-Dinar                    "]
["JPY","Yen                             "]
["KES","Kenia-Schilling                 "]
["KGS","Kirgisistan-Som                 "]
["KHR","Kambodscha-Riel                 "]
["KMF","Komoren-Franc                   "]
["KPW","Nordkoreanischer Won            "]
["KRW","Südkoreanischer Won             "]
["KWD","Kuwait-Dinar                    "]
["KYD","Kaiman-Dollar                   "]
["KZT","Kasachstan-Tenge                "]
["LAK","Laos-Kip                        "]
["LBP","Libanesisches Pfund             "]
["LKR","Sri-Lanka-Rupie                 "]
["LRD","Liberianischer Dollar           "]
["LSL","Lesotho-Loti                    "]
["LYD","Libyscher Dinar                 "]
["MAD","Marokkanischer Dirham           "]
["MDL","Moldau-Leu                      "]
["MGF","Madagaskar-Franc                "]
["MKD","Mazedonien-Neuer Denar          "]
["MMK","Myanmar-Kyat                    "]
["MNT","Mongolei-TOGROG                 "]
["MOP","Macau-Pataca                    "]
["MRO","Mauretanien-Ouguiya             "]
["MUR","Mauritius-Rupie                 "]
["MVR","Malediven-Rufiyaa               "]
["MWK","Malawi-Kwacha                   "]
["MXN","Mexikanischer Peso              "]
["MXV","Mexican Unidad de Inversion     "]
["MYR","Malaysischer Ringgit            "]
["MZM","Mosambik-Metical                "]
["NAD","Namibia-Dollar                  "]
["NGN","Nigeria-Naira                   "]
["NIO","Nicaragua-Gold-Cordoba          "]
["NOK","Norwegische Krone               "]
["NPR","Nepalesische Rupie              "]
["NZD","Neuseeland-Dollar               "]
["OMR","Omani-Rial                      "]
["PAB","Panama-Balboa                   "]
["PEN","Peru-Neuer Sol                  "]
["PGK","Papua-Neuguinea-Kina            "]
["PHP","Philippinischer Peso            "]
["PKR","Pakistanische Rupie             "]
["PLN","Polnischer Zloty Neu            "]
["PYG","Paraguay-Guarani                "]
["QAR","Katar-Riyal                     "]
["RON","Rumänische Leu (Neu)     "]
["RSD","Serbischer Dinar Neu"]
["RUB","Russische Föderation-Rubel (Neu)"]
["RWF","Ruanda-Franc                    "]
["SAR","Saudi Riyal                     "]
["SBD","Salomonen-Dollar                "]
["SCR","Seychellen-Rupie                "]
["SDD","Sudanesischer Dinar             "]
["SEK","Schwedische Krone               "]
["SGD","Singapur-Dollar                 "]
["SHP","St. Helena-Pfund                "]
["SLL","Sierra Leone-Leone              "]
["SOS","Somalia-Schilling               "]
["SRG","Suriname-Gulden                 "]
["STD","Sao Tome und Principe Dobra     "]
["SVC","El-Salvador-Colon               "]
["SYP","Syrisches Pfund                 "]
["SZL","Swasiland-Lilangeni             "]
["THB","Thailand-Baht                   "]
["TMM","Turkmenistan-Manat              "]
["TND","Tunesischer Dinar               "]
["TOP","Tonga-Pa'anga                   "]
["TRY","Türkische Lira                  "]
["TTD","Trinidad-und-Tobago-Dollar      "]
["TWD","Neuer Taiwan Dollar             "]
["TZS","Tansania-Schilling              "]
["UAH","Ukraine-Griwna                  "]
["UGX","Uganda-Schilling                "]
["USD","US-Dollar                       "]
["UYU","Uruguayischer Peso              "]
["UZS","Usbekistan-Sum                  "]
["VEB","Venezuela-Bolivar               "]
["VND","Vietnam-Dong                    "]
["VUV","Vanuatu-Vatu                    "]
["WST","Samoa-Tala                      "]
["XAF","CFA-Franc-Äquatorial            "]
["XAU","Gold (Unzen)                    "]
["XCD","Ostkaribischer Dollar           "]
["XOF","CFA-Franc-West                  "]
["XPF","CFP-Franc-Neukaledonien         "]
["YER","Jemen-Rial                      "]
["ZAR","Rand                            "]
["ZMK","Sambia-Kwacha                   "]
["ZWD","Simbabwe-Dollar                 "]

{"sheet":"IBAN","index":3,"n_rows":35,"n_cols":29,"rows_kept":35,"hidden":true,"merged":[[2,1,2,11],[4,2,4,3],[5,2,5,6],[12,2,12,10],[12,13,12,14],[14,2,14,10],[15,2,15,10],[16,2,16,10],[17,2,17,10],[23,1,23,17],[25,2,25,10],[26,2,26,5],[26,7,26,11],[27,2,27,10],[28,2,28,6],[28,7,28,11],[30,13,30,14]]}
[{"$nulls":18},"us9053940502757552705012"]
[]
[null,"Berechnung der IBAN für Österreich (5 Stellen BLZ, 11 Stellen Kontonummer)",{"$nulls":16},"DE89370400440532013000"]
[]
[null,"Bankleitzahl (5-stellig)",20151,{"$nulls":8},{"$f":"IF(FormalfehlerBLZ, \"Österreichische BLZ sind 5 Stellen lang\",\"\")","v":""},{"$nulls":3},{"$f":"IF(LEN(U15)>23,\"RICHTIG\",FALSE)","v":{"$error":"#VALUE!"}},{"$nulls":3},"IBAN - Ziffernfolge",{"$f":"CONCATENATE(TEXT('Codes&Tables'!C59,\"00000\"),TEXT('Codes&Tables'!D59,\"00000000000\"),\"102900\")","v":"2015110080090000102900"},{"$nulls":6},{"$f":"IF(LEN('Codes&Tables'!C59) <> 5, TRUE(), FALSE())","v":false}]
[null,"Kontonummer (max. 11-stellig)",10080090000,{"$nulls":8},{"$f":"IF(FormalfehlerKTONR, \"Österreichische Kontonummern sind maximal 11 Stellen lang\",\"\")","v":""},{"$nulls":15},{"$f":"IF(KTONR_AT = \"\",TRUE(),IF(LEN('Codes&Tables'!D59) > 11, TRUE(), FALSE()))","v":false}]
[{"$nulls":19},"Berechnung Teil1",{"$f":"MOD(VALUE(LEFT(U5,9)),97)","v":7}]
[{"$nulls":19},"Berechnung Teil2",{"$f":"MOD(U7*10000000+VALUE(MID(U5,10,7)),97)","v":31}]
[null,"IBAN",{"$f":"IF(OR(FormalfehlerBLZ,FormalfehlerKTONR),\"IBAN kann wegen fehlerhafter BLZ oder KTONR nicht errechnet werden\",CONCATENATE(\"AT\",TEXT(U10,\"00 \"),TEXT('Codes&Tables'!C59,\"0000 0\"),TEXT('Codes&Tables'!D59,\"000 0000 0000\")))","v":"AT54 2015 1100 8009 0000"},{"$nulls":16},"Berechnung Teil3",{"$f":"MOD(U8*1000000+VALUE(MID(U5,17,6)),97)","v":44}]
[{"$nulls":19},"Prüfziffer",{"$f":"98-U9","v":54}]
[]
[{"$nulls":19},"IBAN seems to be correct"]
[null,null,"Prüfung der IBAN ",{"$nulls":10},"IBAN-Stellenanzahl",{"$nulls":5},"IBAN is incorrect"]
[null,null,{"$f":"MID(C15,1,4)","v":"0"},{"$f":"MID(IBAN,5,4)","v":""},{"$f":"MID(IBAN,9,4)","v":""},{"$f":"MID(IBAN,13,4)","v":""},{"$f":"MID(IBAN,17,4)","v":""},{"$f":"MID(IBAN,21,4)","v":""},{"$f":"MID(IBAN,25,4)","v":""},{"$f":"MID(IBAN,29,4)","v":""},{"$f":"MID(IBAN,33,4)","v":""},null,null,"RICHTIG","lt. Eingabe",{"$nulls":13},"Stellen-Anzahl"]
[null,"IBAN:",{"$f":"'8537'!B31","v":0},{"$nulls":10},{"$f":"VLOOKUP((LEFT(C15,2)),'Codes&Tables'!IBAN_Länge,2,TRUE)","v":{"$error":"#N/A"}},{"$f":"LEN(IBAN)","v":1},{"$nulls":4},"Ziffernfolge IBAN",{"$f":"'Codes&Tables'!E59","v":{"$error":"#VALUE!"}},{"$nulls":6},{"$f":"IF(LEN(SUBSTITUTE('Codes&Tables'!E59,\" \",\"\"))>34,TRUE(),FALSE())","v":{"$error":"#VALUE!"}},{"$f":"LEN(U15)","v":{"$error":"#VALUE!"}}]
[null,"Ergebnis:",{"$f":"IF(Prüfziffer_b = 1, T12, T13)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF(N15<>O15,\"IBAN-Länge oder LAND ist FALSCH!\",\"IBAN-Länge = O.K. \")","v":{"$error":"#N/A"}},{"$nulls":16},"Berechnung Teil1",{"$f":"MOD(VALUE(LEFT(U15,9)),97)","v":{"$error":"#VALUE!"}},"Stelle 1-9",{"$f":"MOD(221021290,97)","v":0}]
[null,null,{"$f":"+O15-N15","v":{"$error":"#N/A"}},{"$nulls":16},"Berechnung Teil2",{"$f":"MOD(U17*10000000+VALUE(MID(U15,10,7)),97)","v":{"$error":"#VALUE!"}},"Stelle 10-16",{"$f":"MOD(1100001,97)","v":21}]
[{"$nulls":19},"Berechnung Teil3",{"$f":"IF(LEN($U$15)>=23,MOD(U18*10000000+VALUE(MID($U$15,17,7)),97),MOD(U18*10^(LEN($U$15)-16)+VALUE(MID($U$15,17,LEN($U$15)-16)),97))","v":{"$error":"#VALUE!"}},"Stelle 17-23",{"$f":"MOD(212345222,97)","v":0},"O.K.(AD,AT,BE,CH,DK,EE,FI,LT,LU,NO,SI)"]
[{"$nulls":19},"Berechnung Teil4",{"$f":"IF(LEN($U$15)<24,FALSE,IF(LEN($U$15)>=30,MOD(U19*10000000+VALUE(MID($U$15,24,7)),97),MOD(U19*10^(LEN($U$15)-23)+VALUE(MID($U$15,24,LEN($U$15)-23)),97)))","v":{"$error":"#VALUE!"}},"Stelle 24-30",{"$f":"MOD(9211210,97)","v":90},"O.K.(CY,CZ,DE,ES,FR,GB,GI,GR,HU,IE,IS,IT,LI,LV,NL,PL,PT,SE,SK,TR)"]
[null,null,{"$f":"IF(ISERROR(C16),T13,C16)","v":"IBAN is incorrect"},{"$nulls":16},"Berechnung Teil5",{"$f":"IF(LEN($U$15)<31,FALSE,IF(LEN($U$15)>=37,MOD(U20*10000000+VALUE(MID($U$15,31,7)),97),MOD(U20*10^(LEN($U$15)-30)+VALUE(MID($U$15,31,LEN($U$15)-30)),97)))","v":{"$error":"#VALUE!"}},"Stelle 31-37",{"$f":"MOD(902829001,97)","v":46},"O.K.(RO)"]
[{"$nulls":19},"Berechnung Teil6",{"$f":"IF(LEN($U$15)<38,FALSE,IF(LEN($U$15)>=44,MOD(U21*10000000+VALUE(MID($U$15,38,7)),97),MOD(U21*10^(LEN($U$15)-37)+VALUE(MID($U$15,38,LEN($U$15)-37)),97)))","v":{"$error":"#VALUE!"}},"Stelle 38-44",{"$f":"MOD(462822298,97)","v":87}]
[{"$nulls":19},"Berechnung Teil7",{"$f":"IF(LEN($U$15)>44,MOD(U22*10^(LEN($U$15)-44)+VALUE(MID($U$15,45,LEN($U$15)-44)),97))","v":{"$error":"#VALUE!"}},"Stelle 45-51",{"$f":"MOD(870000004,97)","v":20},"O.K.(MT)"]
[null,"Berechnung der IBAN international (die selbst errechnete IBAN darf nicht für Zahlungen verwendet werden! -> FEHLERQUELLE!)",{"$nulls":17},"Prüfziffer",{"$f":"IF(U20=FALSE,U19,0)+IF(U21=FALSE,U20,0)+IF(U22=FALSE,U21,0+IF(U23=FALSE,U22,0)+IF(U23<>FALSE,U23))","v":{"$error":"#VALUE!"}}]
[{"$nulls":12},"Differnz Stellenanzahl",{"$nulls":15},"Stellen-Anzahl"]
[null,"",{"$f":"VLOOKUP(IBAN_Länge,[0]!Länge_BLZ,4,TRUE)","v":{"v":5,"d":"(5 Stellen - Bankleitzahl (lt. Länder-Tabelle))"}},{"$nulls":9},"\"lt.Tabelle\" zu \"eingegeben\"",{"$nulls":6},"IBAN - Ziffernfolge",{"$f":"CONCATENATE(TEXT('Codes&Tables'!F59,REPT(\"0\",C26)),'Codes&Tables'!G59,'Codes&Tables'!H59,\"00\")","v":"0006100519786457841326292700"},{"$nulls":6},{"$f":"IF(LEN(SUBSTITUTE('Codes&Tables'!E69,\" \",\"\"))>34,TRUE(),FALSE())","v":false},{"$f":"LEN(U26)","v":28}]
[null,"Bankleitzahl (ohne Sonderzeichen): ","00061",{"$nulls":4},{"$f":"LEN(BLZ_INT)","v":{"v":5,"d":"5 Stellen Bankleitzahl eingegeben!"}},{"$nulls":4},{"$f":"+H27-C26","v":{"v":0,"d":"0 Stelle(n) Differenz"}}]
[null,"",{"$f":"VLOOKUP(IBAN_Länge,'Codes&Tables'!A101:H136,6,TRUE)","v":{"v":12,"d":"(12 Stellen - Bankleitzahl (lt. Länder-Tabelle))"}},{"$nulls":16},"Berechnung Teil1",{"$f":"MOD(VALUE(LEFT(U26,9)),97)","v":18},"Stelle 1-9"]
[null,"Kontonummer (ohne Sonderzeichen): ","00519786457841326",{"$nulls":4},{"$f":"LEN(KTONR_INT)","v":{"v":17,"d":"17 Stellen Kontonummer eingegeben!"}},{"$nulls":4},{"$f":"+H29-C28","v":{"v":5,"d":"5 Stelle(n) Differenz"}},{"$nulls":6},"Berechnung Teil2",{"$f":"MOD(U28*10000000+VALUE(MID(U26,10,7)),97)","v":40},"Stelle 10-16"]
[null," Landes-Code: ","TR",null,null,"zuerst eingeben!",{"$nulls":13},"Berechnung Teil3",{"$f":"IF(LEN(U26)>=23,MOD(U29*10000000+VALUE(MID(U26,17,7)),97),MOD(U29*10^(LEN(U26)-16)+VALUE(MID(U26,17,LEN(U26)-16)),97))","v":0},"Stelle 17-23",null,"O.K.(AD,AT,BE,CH,DK,EE,FI,LT,LU,NO,SI)"]
[{"$nulls":13},"IBAN-Stellenanzahl",{"$nulls":5},"Berechnung Teil4",{"$f":"IF(LEN($U$26)<24,FALSE,IF(LEN($U$26)>=30,MOD(U30*10000000+VALUE(MID($U$26,24,7)),97),MOD(U30*10^(LEN($U$26)-23)+VALUE(MID($U$26,24,LEN($U$26)-23)),97)))","v":65},"Stelle 24-30",null,"O.K.(CY,CZ,DE,ES,FR,GB,GI,GR,HU,IE,IS,IT,LI,LV,NL,PL,PT,SE,SK,TR)"]
[{"$nulls":13},"IBAN-Länge","lt. Eingabe",{"$nulls":4},"Berechnung Teil5",{"$f":"IF(LEN($U$26)<31,FALSE,IF(LEN($U$26)>=37,MOD(U31*10000000+VALUE(MID($U$26,31,7)),97),MOD(U31*10^(LEN($U$26)-30)+VALUE(MID($U$26,31,LEN($U$26)-30)),97)))","v":false},"Stelle 31-37",null,"O.K.(RO)"]
[null,"\"errechnete\" IBAN lautet:",{"$f":"CONCATENATE(UPPER(C30),TEXT(U35,\"00\"),TEXT(C27,CONCATENATE(REPT(\"0\",C26))),TEXT(C29,REPT(\"0\",C28)))","v":"TR3300061519786457841326"},{"$nulls":10},{"$f":"VLOOKUP((LEFT($C$33,2)),[0]!IBAN_Länge2,2,TRUE)","v":21},{"$f":"LEN(C33)","v":24},{"$nulls":4},"Berechnung Teil6",{"$f":"IF(LEN($U$26)<38,FALSE,IF(LEN($U$26)>=44,MOD(U32*10000000+VALUE(MID($U$26,38,7)),97),MOD(U32*10^(LEN($U$26)-37)+VALUE(MID($U$26,38,LEN($U$26)-37)),97)))","v":false},"Stelle 38-44"]
[{"$nulls":11},{"$f":"IF(N33<>O33,\"IBAN-Länge ist FALSCH!\",\"IBAN-Länge = O.K. \")","v":"IBAN-Länge ist FALSCH!"},{"$nulls":7},"Berechnung Teil7",{"$f":"IF(LEN($U$26)>44,MOD(U33*10^(LEN($U$26)-44)+VALUE(MID($U$26,45,LEN($U$26)-44)),97))","v":false},"Stelle 45-51",null,"O.K.(MT)"]
[{"$nulls":19},"Prüfziffer",{"$f":"IF(U31=FALSE,98-U30,0)+IF(U32=FALSE,IF(U31<>FALSE,98-U31,0),0)+IF(U34=FALSE,IF(U33<>FALSE,98-U33,0),0)+IF(U34<>FALSE,98-U34,0)","v":33}]

{"sheet":"Codes&Tables","index":4,"n_rows":156,"n_cols":10,"rows_kept":156,"hidden":true}
[null,null,"BLZ Österreich","KTONR Österreich","IBAN ","c) BLZ","c) KTONR","c) LAND"]
["A",10,{"$f":"SUBSTITUTE(BLZ_AT,$A2,$B2)","v":"20151"},{"$f":"SUBSTITUTE(KTONR_AT,$A2,$B2)","v":"10080090000"},{"$f":"SUBSTITUTE(CONCATENATE(RIGHT(IBAN,LEN(IBAN)-4),LEFT(IBAN,4)),$A2,$B2)","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(BLZ_INT,$A2,$B2)","v":"00061"},{"$f":"SUBSTITUTE(KTONR_INT,$A2,$B2)","v":"00519786457841326"},{"$f":"SUBSTITUTE(Länder_Code,$A2,$B2)","v":"TR"}]
["B",11,{"$f":"SUBSTITUTE(C2,$A3,$B3)","v":"20151"},"10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["C",12,{"$f":"SUBSTITUTE(C3,A4,B4)","v":"20151"},{"$f":"SUBSTITUTE(D3,$A4,$B4)","v":"10080090000"},{"$f":"SUBSTITUTE(E3,$A4,$B4)","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(F3,$A4,$B4)","v":"00061"},{"$f":"SUBSTITUTE(G3,$A4,$B4)","v":"00519786457841326"},{"$f":"SUBSTITUTE(H3,$A4,$B4)","v":"TR"}]
["D",13,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["E",14,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["F",15,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["G",16,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["H",17,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["I",18,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["J",19,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["K",20,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["L",21,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["M",22,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["N",23,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["O",24,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["P",25,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["Q",26,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","TR"]
["R",27,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","T27"]
["S",28,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","T27"]
["T",29,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["U",30,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["V",31,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["W",32,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["X",33,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["Y",34,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["Z",35,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["a",10,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["b",11,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["c",12,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["d",13,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["e",14,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["f",15,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["g",16,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["h",17,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["i",18,{"$f":"SUBSTITUTE(C35,A36,B36)","v":"20151"},{"$f":"SUBSTITUTE(D35,$A36,$B36)","v":"10080090000"},{"$f":"SUBSTITUTE(E35,$A36,$B36)","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(F35,$A36,$B36)","v":"00061"},{"$f":"SUBSTITUTE(G35,$A36,$B36)","v":"00519786457841326"},{"$f":"SUBSTITUTE(H35,$A36,$B36)","v":"2927"}]
["j",19,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["k",20,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["l",21,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["m",22,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["n",23,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["o",24,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["p",25,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["q",26,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["r",27,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["s",28,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["t",29,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["u",30,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["v",31,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["w",32,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["x",33,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["y",34,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["z",35,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["-",null,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["/",null,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
[".",null,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
[":",null,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
["_",null,"20151","10080090000",{"$error":"#VALUE!"},"00061","00519786457841326","2927"]
[" ",null,{"$f":"SUBSTITUTE(C57,A59,B59)","v":"20151"},{"$f":"SUBSTITUTE(D57,$A59,$B59)","v":"10080090000"},{"$f":"SUBSTITUTE(E58,$A59,$B59)","v":{"$error":"#VALUE!"}},{"$f":"SUBSTITUTE(F58,$A59,$B59)","v":"00061"},{"$f":"SUBSTITUTE(G58,$A59,$B59)","v":"00519786457841326"},{"$f":"SUBSTITUTE(H58,$A59,$B59)","v":"2927"}]
["b) Prüfung der IBAN "]
["Landes_KZ","IBAN_Länge",null,null,"Test-IBANs (erfunden)",null,"IBANs aus dem Tagesgeschäft"]
["AD",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B62,TRUE(),FALSE())","v":false},null,"AD1200012030200359100100"]
["AT",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B63,TRUE(),FALSE())","v":false},null,"AT611904300234573201"]
["BA",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B64,TRUE(),FALSE())","v":false},null,"BA391290079401028494"]
["BG",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B65,TRUE(),FALSE())","v":false},null,"BG80BNBG96611020345678"]
["BE",16,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B66,TRUE(),FALSE())","v":false},null,"BE68539007547034"]
["CH",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B67,TRUE(),FALSE())","v":false},null,"CH9300762011623852957"]
["CY",29,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B68,TRUE(),FALSE())","v":false},null,"CY17002001280000001200527600"]
["IL",23,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B69,TRUE(),FALSE())","v":false},null,"IL340110440000003707077",null,"IL340110440000003707077"]
["CZ",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B70,TRUE(),FALSE())","v":false},null,"CZ65 08000000192000145399"]
["DE",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B71,TRUE(),FALSE())","v":false},null,"DE89370400440532013000"]
["DK",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B72,TRUE(),FALSE())","v":false},null,"DK5000400440116243"]
["EE",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B73,TRUE(),FALSE())","v":false},null,"EE382200221020145685"]
["ES",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B74,TRUE(),FALSE())","v":false},null,"ES9121000418450200051332"]
["FI",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B75,TRUE(),FALSE())","v":false},null,"FI2112345600000785"]
["FO",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B76,TRUE(),FALSE())","v":false},null,"DK5000400440116243"]
["FR",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B77,TRUE(),FALSE())","v":false},null,"FR1420041010050500013M02606"]
["GB",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B78,TRUE(),FALSE())","v":false},null,"GB29NWBK60161331926819"]
["GI",23,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B79,TRUE(),FALSE())","v":false},null,"GI75NWBK000000007099453"]
["GL",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B80,TRUE(),FALSE())","v":false},null,"DK5000400440116243"]
["GR",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B81,TRUE(),FALSE())","v":false},null,"GR1601101250000000012300695"]
["HR",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B82,TRUE(),FALSE())","v":false},null,"HR3512345671234567890"]
["HU",28,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B83,TRUE(),FALSE())","v":false},null,"HU42117730161111101800000000"]
["IE",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B84,TRUE(),FALSE())","v":false},null,"IE29AIBK93115212345678"]
["IS",26,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B85,TRUE(),FALSE())","v":false},null,"IS140159260076545510730339"]
["IT",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B86,TRUE(),FALSE())","v":false},null,"IT60X0542811101000000123456"]
["LI",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B87,TRUE(),FALSE())","v":false},null,"LI21088100002324013AA"]
["LT",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B88,TRUE(),FALSE())","v":false},null,"LT121000011101001000"]
["LU",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B89,TRUE(),FALSE())","v":false},null,"LU280019400644750000"]
["LV",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B90,TRUE(),FALSE())","v":false},null,"LV80BANK0000435195001"]
["MC",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B91,TRUE(),FALSE())","v":false},null,"MC1420041010050500013M02606"]
["MK",19,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B92,TRUE(),FALSE())","v":false},null,"MK91123001234567890"]
["MU",30,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B93,TRUE(),FALSE())","v":false},null,"MU17BOMM0101101030300200000MUR"]
["MT",31,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B94,TRUE(),FALSE())","v":false},null,"MT84MALT011000012345MTLCAST001S"]
["NL",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B95,TRUE(),FALSE())","v":false},null,"NL91ABNA0417164300"]
["NO",15,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B96,TRUE(),FALSE())","v":false},null,"NO9386011117947"]
["PL",28,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B97,TRUE(),FALSE())","v":false},null,"PL27114020040000300201355387"]
["PT",25,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B98,TRUE(),FALSE())","v":false},null,"PT50000201231234567890154"]
["RO",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B99,TRUE(),FALSE())","v":false},null,"RO49AAAA1B31007593840000",null,"ro63bpos24302798558eur01"]
["SE",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B100,TRUE(),FALSE())","v":false},null,"SE3550000000054910000003"]
["SI",19,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B101,TRUE(),FALSE())","v":false},null,"SI56191000000123438"]
["SK",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B102,TRUE(),FALSE())","v":false},null,"SK3112000000198742637541"]
["SM",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B103,TRUE(),FALSE())","v":false},null,"SM21J0100516052120050012345"]
["TN",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B104,TRUE(),FALSE())","v":false},null,"TN5914207207100707129648"]
["TR",26,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B105,TRUE(),FALSE())","v":false},null,"TR330006100519786457841326"]
["RS",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B106,TRUE(),FALSE())","v":false},null,"RS35265100000005095461"]
["ME",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$15,\" \",\"\"))='Codes&Tables'!B107,TRUE(),FALSE())","v":false},null,"ME25530005020000221892"]
[]
["c) Berechnung der IBAN international"]
["Landes_KZ","IBAN_Länge2",null,"Länge BLZ","Test-IBANs (erfunden)","Länge Kto.Nr.","IBANs aus dem Tagesgeschäft"]
["AD",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B111,TRUE(),FALSE())","v":true},8,"AD1200012030200359100100",12,null,null,{"$f":"4+D111+F111","v":24},{"$f":"+I111-B111","v":0}]
["AT",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B112,TRUE(),FALSE())","v":false},5,"AT611904300234573201",11,null,null,20,0]
["BA",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B113,TRUE(),FALSE())","v":false},6,"BA391290079401028494",10,null,null,20,0]
["BE",16,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B114,TRUE(),FALSE())","v":false},3,"BE68539007547034",9,null,null,16,0]
["BG",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B115,TRUE(),FALSE())","v":false},4,"BG80BNBG96611020345678",14,null,null,22,0]
["CH",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B116,TRUE(),FALSE())","v":false},5,"CH9300762011623852957",12,null,null,21,0]
["IL",23,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B117,TRUE(),FALSE())","v":false},6,"IL340110440000003707077",13,null,null,{"$f":"4+D117+F117","v":23},0]
["CY",28,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B118,TRUE(),FALSE())","v":false},14,"CY17002001280000001200527600",10,null,null,28,0]
["CZ",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B119,TRUE(),FALSE())","v":true},4,"CZ6508000000192000145399",16,null,null,24,0]
["DE",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B120,TRUE(),FALSE())","v":false},8,"DE89370400440532013000",10,null,null,{"$f":"4+D120+F120","v":22},{"$f":"+I120-B120","v":0}]
["DK",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B121,TRUE(),FALSE())","v":false},4,"DK5000400440116243",10,null,null,18,0]
["EE",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B122,TRUE(),FALSE())","v":false},4,"EE382200221020145685",12,null,null,20,0]
["ES",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B123,TRUE(),FALSE())","v":true},8,"ES9121000418450200051332",12,null,null,24,0]
["FI",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B124,TRUE(),FALSE())","v":false},6,"FI2112345600000785",8,null,null,18,0]
["FO",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B125,TRUE(),FALSE())","v":false},4,"DK5000400440116243",10,null,null,18,0]
["FR",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B126,TRUE(),FALSE())","v":false},10,"FR1420041010050500013M02606",13,null,null,27,0]
["GB",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B127,TRUE(),FALSE())","v":false},10,"GB29NWBK60161331926819",8,null,null,22,0]
["GI",23,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B128,TRUE(),FALSE())","v":false},4,"GI75NWBK000000007099453",15,null,null,23,0]
["GL",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B129,TRUE(),FALSE())","v":false},4,"DK5000400440116243",10,null,null,18,0]
["GR",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B130,TRUE(),FALSE())","v":false},7,"GR1601101250000000012300695",16,null,null,27,0]
["HR",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B131,TRUE(),FALSE())","v":false},7,"HR3512345671234567890",10,null,null,21,0]
["HU",28,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B132,TRUE(),FALSE())","v":false},7,"HU42117730161111101800000000",17,null,null,28,0]
["IE",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B133,TRUE(),FALSE())","v":false},10,"IE29AIBK93115212345678",8,null,null,22,0]
["IS",26,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B134,TRUE(),FALSE())","v":false},4,"IS140159260076545510730339",18,null,null,26,0]
["IT",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B135,TRUE(),FALSE())","v":false},11,"IT60X0542811101000000123456",12,null,null,27,0]
["LI",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B136,TRUE(),FALSE())","v":false},5,"LI21088100002324013AA",12,null,null,21,0]
["LT",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B137,TRUE(),FALSE())","v":false},5,"LT121000011101001000",11,null,null,20,0]
["LU",20,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B138,TRUE(),FALSE())","v":false},3,"LU280019400644750000",13,null,null,20,0]
["LV",21,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B139,TRUE(),FALSE())","v":false},4,"LV80BANK0000435195001",13,null,null,21,0]
["MC",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B140,TRUE(),FALSE())","v":false},10,"MC1420041010050500013M02606",13,null,null,27,0]
["MK",19,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B141,TRUE(),FALSE())","v":false},3,"MK91123001234567890",12,null,null,19,0]
["MU",30,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B142,TRUE(),FALSE())","v":false},4,"MU17BOMM0101101030300200000MUR",22,null,null,30,0]
["MT",31,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B143,TRUE(),FALSE())","v":false},9,"MT84MALT011000012345MTLCAST001S",18,null,null,31,0]
["NL",18,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B144,TRUE(),FALSE())","v":false},4,"NL91ABNA0417164300",10,null,null,18,0]
["NO",15,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B145,TRUE(),FALSE())","v":false},4,"NO9386011117947",7,null,null,15,0]
["PL",28,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B146,TRUE(),FALSE())","v":false},8,"PL27114020040000300201355387",16,null,null,28,0]
["PT",25,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B147,TRUE(),FALSE())","v":false},8,"PT50000201231234567890154",13,null,null,25,0]
["RO",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B148,TRUE(),FALSE())","v":true},4,"RO49AAAA1B31007593840000",16,"ro63bpos24302798558eur01",null,24,0]
["SE",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B149,TRUE(),FALSE())","v":true},3,"SE3550000000054910000003",17,null,null,24,0]
["SI",19,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B150,TRUE(),FALSE())","v":false},5,"SI56191000000123438",10,null,null,19,0]
["SK",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B151,TRUE(),FALSE())","v":true},4,"SK3112000000198742637541",16,null,null,24,0]
["SM",27,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B152,TRUE(),FALSE())","v":false},10,"SM21J0100516052120050012345",13,null,null,27,0]
["TN",24,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B153,TRUE(),FALSE())","v":true},5,"TN5914207207100707129648",15,null,null,24,0]
["TR",26,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B154,TRUE(),FALSE())","v":false},5,"TR760006100519786457841326",17,null,null,26,0]
["RS",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B155,TRUE(),FALSE())","v":false},3,"RS35265100000005095461",15,null,null,22,0]
["ME",22,{"$f":"IF(LEN(SUBSTITUTE(IBAN!$C$33,\" \",\"\"))='Codes&Tables'!B156,TRUE(),FALSE())","v":false},3,"ME25530005020000221892",15,null,null,22,0]