{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Local Variables","Instructions","Customer_Upload","ErrorCodes","Errors","Print View","Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":21,"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":"Local Variables","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["User Information:"]
["Uniqname:","=Env(\"USERNAME\")"]
["Phone Number:"]
[]
[]
["File Information:"]
["Import File Location:","E:\\Margaret\\PeopleSoft\\Problems\\2013-09-AST - GNALL_Template\\csvFiles\\LoadCustomersGNALL_After_Reorder.csv"]
[]
["Total Amounts",{"$f":"SUM(BillAmounts)","v":{"$error":"#NAME?"}}]
["Header Count",{"$f":"COUNTIF(#REF!,\"Y\")","v":{"$error":"#REF!"}}]
["Line Count",{"$f":"COUNT(#REF!)","v":0}]
["Accounting Entries",{"$f":"COUNT(BillAmounts)","v":0}]
[]
[null,"Nice idea, this, but I couldn't get it to work consistently, so I'm using Global Variables."]

{"sheet":"Instructions","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"INSTRUCTIONS FOR GENERAL CUSTOMER UPLOADTEMPLATE"]
[]
[null,"BASICS"]
[null,"1.  Please do NOT enter more than 100 General customers at a time."]
[null,"2.  Please do NOT place carriage returns or tabs in any of your free-form fields. When using copy and paste use paste special when possible. "]
[null,"3.  Columns in bold are required columns."]
[null,"4.  If a customer email address is provided, all invoices and past due customer statements will be sent to the customer via email."]
[null,"5.  Please note the Customer Upload information entered should be to whom /where the invoice are to be sent for processing."]
[null,"6.  For customer information changes please submit via the General Customer Request eForm. Include in the title field: General Customer Update and the GN customer number. List all changes in the description field.      "]
[]
[null,"The most up-to-date version of the General Customer Upload Template is located on the Shared Services website at:  http://www.ssc.umich.edu/forms"]
[]
[null,"STEP ONE: "]
[null,"Run M-Pathways query to determine if customer already exists or if a new customer is required. The query name is M_AR_10_CUSTOMER_LIST. For more information on where to run the query in M-Pathways, see the beginning of the MyLinc document titled Creating the General Customer Upload File. If the customer already exists and no information changes, proceed to completing the \"General Billing Upload template\". If the customer does not exist, continue to Step 2.  "]
[]
[null,"STEP TWO: "]
[null,"After opening the General Customer Upload Template, when prompted, select  Enable Macros. This will enable you to use the features of the template for validation and printing."]
[]
[null,"STEP THREE: "]
[null,"Complete the following columns as needed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"STEP FOUR: "]
[null,"Press the Validate button on the form to check for errors.  Assuming that there are no other issues found, save as a XLSM file and attach to the General Customer Request eForm. Once the customer is loaded, you will receive a confirmation with the newly created customer number. The customer number will start with GNxxxxx."]

{"sheet":"Customer_Upload","index":2,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Last Modified: 10/26/2018"]
["Business/Customer Name \n(max 40 Characters)","Country","Billing Address 1 (Prepend \"Attn:\" if Required\n(max 55 characters)","Billing Address 2 \n(max 55 characters)","Billing Address 3 \n(mas 55 characters)","Billing Address 4 \n(max 55 characters)","City\n (max 30 characters)","State/Province name (Optional)","State \n(max 6 char)","Postal Code\n(max 12 char)","Customer email address for invoice submission\n(max 130 characters)","Customer Contact name \n(max 40 characters)","Telephone Prefix \n(Country Code)\n(optional, 3 char)","Customer Phone # \n(max 24 characters)","Telephone Extension\n(opt, max 6 char)","UM Dept Contact Uniquname\n(max 30 char)"]
[null,null,null,null,null,null,null,"",""]

{"sheet":"ErrorCodes","index":3,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["Error Code","Error Description","ErrorType","Tip"]
[110,"No Customer Provided","Critical","There is no Customer provided for this line, but data exists on this line or on a lower line."]
[115,"Data below end of obvious data","Critical","Data follows a row with blank customer.  It will not be processed."]
[120,"Invalid Customer Name","Critical","The Customer Name may only have up to 40 characters."]
[130,"Country value is required","Critical","The Country field is required and may not be blank."]
[140,"Invalid Country","Critical","Please use the drop-down list to select a valid country from the lookup table.\nTo get a new Country added, please contact 4-Help."]
[150,"City value is required","Critical","The City field is required and may not be blank."]
[160,"Excess field length","Critical","The City field may not be longer than 30 characters."]
[180,"State name not permitted","Warning","The optional state name is only allowed if the country is the USA or Canada."]
[190,"State name not valid","Warning","If the optional state name is provided it must be a valid value for the country"]
[200,"State field is required","Critical","The State field is required for USA & Canada and may not be blank."]
[205,"Invalid State","Critical","Please use the drop-down list to select a valid state from the lookup table.\nTo get a new State added to the USA or Canada, please contact 4-Help."]
[210,"Excess Field Length","Critical","The State field may not be longer than 6 characters."]
[215,"State code doesn't match name","Critical","if the optional state name is provided the state code must match it."]
[240,"Zip Code is required","Critical","The Postal (Zip) code is required and may not be blank."]
[250,"Excess Field Length","Critical","The Postal (Zip) code may not be longer than 12 characters."]
[300,"Address 1 Field is required","Critical","The Address 1 field is required and may not be blank."]
[310,"Excess Field Length","Critical","Address Field length limited to 55 characters."]
[320,"Prior Address Field blank","Warning","Address 2 is filled in, but Address 1 is blank."]
[325,"Prior Address Field blank","Warning","Address 3 is filled in, but Address 1 is blank."]
[330,"Prior Address Field blank","Warning","Address 3 is filled in, but Address 1 and Address 2 are blank."]
[335,"Prior Address Field blank","Warning","Address 3 is filled in but Address 2 is blank."]
[340,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 1 is blank."]
[345,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 1 and Address 3 are blank."]
[350,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 1 and Address 2 are blank."]
[355,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 1, Address 2, and Address 3 are blank."]
[360,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 3 is blank."]
[365,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 2 is blank."]
[370,"Prior Address Field blank","Warning","Address 4 is filled in, but Address 2 and Address 3 are blank."]
[400,"Excess field length","Critical","The Email field may not be longer than 130 characters."]
[410,"Not a valid eMail address","Critical","This does not appear to be a valid e-mail address.  There is no \"@\"."]
[415,"Not a valid eMail address","Critical","This does not appear to be a valid e-mail address.  The \"@\" is at the very beginning."]
[420,"Not a valid eMail address","Critical","This does not appear to be a valid e-mail address.  The \"@\" is at the very end."]
[425,"Not a valid eMail address","Critical","This does not appear to be a valid e-mail address.  The domain (after the \"@\") is blank."]
[430,"Not a valid eMail address","Critical","This does not appear to be a valid e-mail address.  The characters before the \"@\" are only spaces."]
[450,"Excess Field Length","Critical","Customer Contact Name may not be longer than 40 characters."]
[455,"Excess Field Length","Critical","The Customer Phone Prefix may not be longer than 3 characters."]
[460,"Excess Field Length","Critical","Customer Phone Number may not be longer than 24 characters."]
[465,"Required field is blank","Critical","The Customer Phone Number is required and may not be blank."]
[470,"Phone number will be modified","Warning","The Phone Number will be modified to remove spaces, dashes, parentheses, slashes and quotes."]
[480,"Excess Field Length","Critical","Customer Phone Number Extension may not be longer than 6 characters."]
[490,"Special character removed from cell","Warning","This cell contained a carriage return, line feed, or tab.  It has been removed."]
[500,"Dept Contact email missing","Critical","Dept Contact email field is required but blank."]
[510,"Uniqname/email: incorrect length","Critical","The Department Contact email must be between 3 and 30 characters long."]
[520,"Email may not be sent externally","Critical","A domain may not be specified for the UM Department Contact email.  (It is for umich.edu only.)"]
[610,"File type of upload file - CSV","Information","The file you opened is a .csv file."]
[620,"File type of upload file - DAT","Information","The file you opened is a .dat file."]
[630,"File type of upload file - Other","Information","The file you opened is neither a .csv nor a .dat file."]
[640,"File name doesn't match contents","Information","Not an Error CSV file nor an Exported DAT file -OR- the contents don't match the name."]
[650,"Unexpected data in input file","Information","A row in the input file did not start with GNALLNEXT."]
[660,"Row has incorrect type, not loaded","Information","Row not loaded -- does not start with \"GNALLNEXT\"."]
[710,"Too many columns in CSV file","Information","There are too many column represented in the CSV file.  Extra columns ignored."]
[720,"Empty line found in CSV file","Information","Empty line found in CSV file.  No more lines loaded."]
[730,"Only 199 rows may be loaded","Critical","Too many rows found in input file.  Only 199 rows may be inserted to the Template."]
[810,"Import File Failed","Critical","An error occurred and your CSV or DAT file was not imported correctly."]

{"sheet":"Errors","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Validation Results",null,null,null,{"$f":"NOW()","v":"2024-04-01T10:43:24.340"}]
[null,"Error Code","Error Description","Error Type","Cell Value","Cell Address"]

{"sheet":"Print View","index":5,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Control Record:"]
[null,null,null,"Preparation Date:  ",null,"Total Customers to load:",null,null,null,"Customer load sheet filled out by:  ","jeffgree"]
[]
[null,"Customer Information:"]
[]
[null,null,"Customer Name",null,"Country","Address (up to 4 lines)","City","State Code","Postal Code","Customer Contact Name","Contact UniqName"]
[null,null,null,null,null,null,null,"Prefix","Cust Phone #","Suffix","Customer e-Mail"]

{"sheet":"Validation","index":6,"n_rows":269,"n_cols":8,"rows_kept":269,"cut":false,"hidden":true,"merged":[]}
[]
["Lookup for Unit of Measure"]
["len(disp)","Display","Pass"]
[{"$f":"LEN(B4)","v":5},"Books","BK"]
[3,"Box","BOX"]
[4,"Days","DAY"]
[4,"Each","EA"]
[4,"Hour","HR"]
[5,"Hours","HRS"]
[3,"Job","JA"]
[5,"Miles","MIL"]
[7,"Minutes","MIN"]
[5,"Month","MO"]
[7,"Seconds","SEC"]
[5,"Sheet","SH"]
[4,"Unit","UN"]
[9,"US Dollar","USD"]
[4,"Week","WK"]
[4,"Year","YR"]
[{"$f":"\"Max = \" & MAX(A4:A19)","v":"Max = 9"},"UOM_Lookup above","UOM_Lookup_Pass both cols."]
[]
["The next row is used for TextToColValidation."]
[]
[]
[]
["Lookup for Valid Countries.  9/13/2013 241 values.",null,null,null,null,"Lookup for valid states if country is USA",null,"SCd_Lookup"]
["ps_country_tbl",null,"Country_Lookup","Country_Codes, Country_Lookup_Pass Both Columns",null,"ps_state_tbl","State_Lookup","State_Lookup_Pass Both Columns"]
["The lookup value",null,"Descr","Country",null,"Note -- 58 rows.","Descr","State"]
["must be to the ",null,"Afghanistan","AFG",null,null,"Alabama","AL"]
["right of the ",null,"Albania","ALB",null,null,"Alaska","AK"]
["key.",null,"Algeria","DZA",null,null,"American Samoa","AS"]
["Here they key",null,"American Samoa","ASM",null,null,"APO/FPO Europe/Mid East Africa","AE"]
["is the acual",null,"Andorra","AND",null,null,"APO/FPO Pacific","AP"]
["country name ",null,"Angola","AGO",null,null,"APO/FPO the Americas","AA"]
["(which will go ",null,"Anguilla","AIA",null,null,"Arizona","AZ"]
["into the Customer",null,"Antarctica","ATA",null,null,"Arkansas","AR"]
["sheet) and the",null,"Antigua and Barbuda","ATG",null,null,"California","CA"]
["looup value is the ",null,"Argentina","ARG",null,null,"Colorado","CO"]
["3-letter code",null,"Armenia","ARM",null,null,"Connecticut","CT"]
["which I will need",null,"Aruba","ABW",null,null,"Delaware","DE"]
["for the .dat file.)",null,"Australia","AUS",null,null,"District of Columbia","DC"]
[null,null,"Austria","AUT",null,null,"Florida","FL"]
[null,null,"Azerbaijan","AZE",null,null,"Georgia","GA"]
[null,null,"Bahamas","BHS",null,null,"Guam","GU"]
[null,null,"Bahrain","BHR",null,null,"Hawaii","HI"]
[null,null,"Bangladesh","BGD",null,null,"Idaho","ID"]
[null,null,"Barbados","BRB",null,null,"Illinois","IL"]
[null,null,"Belarus","BLR",null,null,"Indiana","IN"]
[null,null,"Belgium","BEL",null,null,"Iowa","IA"]
[null,null,"Belize","BLZ",null,null,"Kansas","KS"]
[null,null,"Benin","BEN",null,null,"Kentucky","KY"]
[null,null,"Bermuda","BMU",null,null,"Louisiana","LA"]
[null,null,"Bhutan","BTN",null,null,"Maine","ME"]
[null,null,"Bolivia","BOL",null,null,"Maryland","MD"]
[null,null,"Bosnia and Herzegovina","BIH",null,null,"Massachusetts","MA"]
[null,null,"Botswana","BWA",null,null,"Michigan","MI"]
[null,null,"Bouvet Island","BVT",null,null,"Minnesota","MN"]
[null,null,"Brazil","BRA",null,null,"Mississippi","MS"]
[null,null,"British Indian Ocean Territory","IOT",null,null,"Missouri","MO"]
[null,null,"Brunei Darussalam","BRN",null,null,"Montana","MT"]
[null,null,"Bulgaria","BGR",null,null,"Nebraska","NE"]
[null,null,"Burkina Faso","BFA",null,null,"Nevada","NV"]
[null,null,"Burundi","BDI",null,null,"New Hampshire","NH"]
[null,null,"Cambodia","KHM",null,null,"New Jersey","NJ"]
[null,null,"Cameroon","CMR",null,null,"New Mexico","NM"]
[null,null,"Canada","CAN",null,null,"New York","NY"]
[null,null,"Cape Verde","CPV",null,null,"North Carolina","NC"]
[null,null,"Cayman Islands","CYM",null,null,"North Dakota","ND"]
[null,null,"Central African Republic","CAF",null,null,"Ohio","OH"]
[null,null,"Chad","TCD",null,null,"Oklahoma","OK"]
[null,null,"Chile","CHL",null,null,"Oregon","OR"]
[null,null,"China","CHN",null,null,"Pennsylvania","PA"]
[null,null,"Christmas Island","CXR",null,null,"Puerto Rico","PR"]
[null,null,"Cocos (Keeling) Islands","CCK",null,null,"Rhode Island","RI"]
[null,null,"Colombia","COL",null,null,"South Carolina","SC"]
[null,null,"Comoros","COM",null,null,"South Dakota","SD"]
[null,null,"Congo","COG",null,null,"Tennessee","TN"]
[null,null,"Congo, The Democratic Republic","COD",null,null,"Texas","TX"]
[null,null,"Cook Islands","COK",null,null,"Utah","UT"]
[null,null,"Costa Rica","CRI",null,null,"Vermont","VT"]
[null,null,"Cote D'Ivoire","CIV",null,null,"Virgin Islands","VI"]
[null,null,"Croatia","HRV",null,null,"Virginia","VA"]
[null,null,"Cuba","CUB",null,null,"Washington","WA"]
[null,null,"Cyprus","CYP",null,null,"West Virginia","WV"]
[null,null,"Czech Republic","CZE",null,null,"Wisconsin","WI"]
[null,null,"Denmark","DNK",null,null,"Wyoming","WY"]
[null,null,"Djibouti","DJI"]
[null,null,"Dominica","DMA"]
[null,null,"Dominican Republic","DOM"]
[null,null,"East Timor","TMP",null,"Lookup for valid provinces if country is Canada",null,"PCd_Lookup"]
[null,null,"Ecuador","ECU",null,"ps_state_tbl","Prov_Lookup","Prov_Lookup_Pass Both Columns"]
[null,null,"Egypt","EGY",null,"Note -- 16 rows.","Descr","State"]
[null,null,"El Salvador","SLV",null,null,"Alberta","AB"]
[null,null,"Equatorial Guinea","GNQ",null,null,"Beyond the limits of any Prov.","ZZ"]
[null,null,"Eritrea","ERI",null,null,"British Columbia","BC"]
[null,null,"Estonia","EST",null,null,"Manitoba","MB"]
[null,null,"Ethiopia","ETH",null,null,"New Brunswick","NB"]
[null,null,"Falkland Islands (Malvinas)","FLK",null,null,"Newfoundland","NF"]
[null,null,"Faroe Islands","FRO",null,null,"Northwest Territories","NT"]
[null,null,"Fiji","FJI",null,null,"Nova Scotia","NS"]
[null,null,"Finland","FIN",null,null,"Nunavut (NN)","NN"]
[null,null,"Fmr Yugoslav Rep of Macedonia","MKD",null,null,"Nunavut (NU)","NU"]
[null,null,"France","FRA",null,null,"Ontario","ON"]
[null,null,"French Guiana","GUF",null,null,"Prince Edward Island","PE"]
[null,null,"French Polynesia","PYF",null,null,"Quebec (PQ)","PQ"]
[null,null,"French Southern Territories","ATF",null,null,"Quebec (QC)","QC"]
[null,null,"Gabon","GAB",null,null,"Saskatchewan","SK"]
[null,null,"Gambia","GMB",null,null,"Yukon","YT"]
[null,null,"Georgia","GEO"]
[null,null,"Germany","DEU",null,null,"The 2 Quebec provinces were indistinguishable.  I added the"]
[null,null,"Ghana","GHA",null,null,"parenthetical comments as they had been for Nunavut."]
[null,null,"Gibraltar","GIB"]
[null,null,"Greece","GRC"]
[null,null,"Greenland","GRL"]
[null,null,"Grenada","GRD"]
[null,null,"Guadeloupe","GLP"]
[null,null,"Guam","GUM"]
[null,null,"Guatemala","GTM"]
[null,null,"Guinea","GIN"]
[null,null,"Guinea-Bissau","GNB"]
[null,null,"Guyana","GUY"]
[null,null,"Haiti","HTI"]
[null,null,"Heard and McDonald Islands","HMD"]
[null,null,"Holy See (Vatican City State)","VAT"]
[null,null,"Honduras","HND"]
[null,null,"Hong Kong","HKG"]
[null,null,"Hungary","HUN"]
[null,null,"Iceland","ISL"]
[null,null,"India","IND"]
[null,null,"Indonesia","IDN"]
[null,null,"Iran (Islamic Republic Of)","IRN"]
[null,null,"Iraq","IRQ"]
[null,null,"Ireland","IRL"]
[null,null,"Israel","ISR"]
[null,null,"Italy","ITA"]
[null,null,"Jamaica","JAM"]
[null,null,"Japan","JPN"]
[null,null,"Jordan","JOR"]
[null,null,"Kazakhstan","KAZ"]
[null,null,"Kenya","KEN"]
[null,null,"Kiribati","KIR"]
[null,null,"Korea, Democratic People's Rep","PRK"]
[null,null,"Korea, Republic of","KOR"]
[null,null,"Kosovo, Republic of","KOS"]
[null,null,"Kuwait","KWT"]
[null,null,"Kyrgyzstan","KGZ"]
[null,null,"Lao People's Democratic Rep","LAO"]
[null,null,"Latvia","LVA"]
[null,null,"Lebanon","LBN"]
[null,null,"Lesotho","LSO"]
[null,null,"Liberia","LBR"]
[null,null,"Libyan Arab Jamahiriya","LBY"]
[null,null,"Liechtenstein","LIE"]
[null,null,"Lithuania","LTU"]
[null,null,"Luxembourg","LUX"]
[null,null,"Macau","MAC"]
[null,null,"Madagascar","MDG"]
[null,null,"Malawi","MWI"]
[null,null,"Malaysia","MYS"]
[null,null,"Maldives","MDV"]
[null,null,"Mali","MLI"]
[null,null,"Malta","MLT"]
[null,null,"Marshall Islands","MHL"]
[null,null,"Martinique","MTQ"]
[null,null,"Mauritania","MRT"]
[null,null,"Mauritius","MUS"]
[null,null,"Mayotte","MYT"]
[null,null,"Mexico","MEX"]
[null,null,"Micronesia, Federated States","FSM"]
[null,null,"Moldova, Republic of","MDA"]
[null,null,"Monaco","MCO"]
[null,null,"Mongolia","MNG"]
[null,null,"Montenegro","MNE"]
[null,null,"Montserrat","MSR"]
[null,null,"Morocco","MAR"]
[null,null,"Mozambique","MOZ"]
[null,null,"Myanmar","MMR"]
[null,null,"Namibia","NAM"]
[null,null,"Nauru","NRU"]
[null,null,"Nepal","NPL"]
[null,null,"Netherlands","NLD"]
[null,null,"Netherlands Antilles","ANT"]
[null,null,"New Caledonia","NCL"]
[null,null,"New Zealand","NZL"]
[null,null,"Nicaragua","NIC"]
[null,null,"Niger","NER"]
[null,null,"Nigeria","NGA"]
[null,null,"Niue","NIU"]
[null,null,"Norfolk Island","NFK"]
[null,null,"Northern Mariana Islands","MNP"]
[null,null,"Norway","NOR"]
[null,null,"Oman","OMN"]
[null,null,"Pakistan","PAK"]
[null,null,"Palau","PLW"]
[null,null,"Panama","PAN"]
[null,null,"Papua New Guinea","PNG"]
[null,null,"Paraguay","PRY"]
[null,null,"Peru","PER"]
[null,null,"Philippines","PHL"]
[null,null,"Pitcairn","PCN"]
[null,null,"Poland","POL"]
[null,null,"Portugal","PRT"]
[null,null,"Puerto Rico","PRI"]
[null,null,"Qatar","QAT"]
[null,null,"Republic of Serbia","SRB"]
[null,null,"Reunion","REU"]
[null,null,"Romania","ROU"]
[null,null,"Russian Federation","RUS"]
[null,null,"Rwanda","RWA"]
[null,null,"Saint Helena","SHN"]
[null,null,"Saint Kitts and Nevis","KNA"]
[null,null,"Saint Lucia","LCA"]
[null,null,"Saint Pierre and Miquelon","SPM"]
[null,null,"Samoa","WSM"]
[null,null,"San Marino","SMR"]
[null,null,"Sao Tome and Principe","STP"]
[null,null,"Saudi Arabia","SAU"]
[null,null,"Senegal","SEN"]
[null,null,"Seychelles","SYC"]
[null,null,"Sierra Leone","SLE"]
[null,null,"Singapore","SGP"]
[null,null,"Slovakia","SVK"]
[null,null,"Slovenia","SVN"]
[null,null,"Solomon Islands","SLB"]
[null,null,"Somalia","SOM"]
[null,null,"South Africa","ZAF"]
[null,null,"Spain","ESP"]
[null,null,"Sri Lanka","LKA"]
[null,null,"St Vincent and the Grenadines","VCT"]
[null,null,"Sth Georgia & Sth Sandwich Is","SGS"]
[null,null,"Sudan","SDN"]
[null,null,"Suriname","SUR"]
[null,null,"Svalbard and Jan Mayen","SJM"]
[null,null,"Swaziland","SWZ"]
[null,null,"Sweden","SWE"]
[null,null,"Switzerland","CHE"]
[null,null,"Syrian Arab Republic","SYR"]
[null,null,"Taiwan, Province of China","TWN"]
[null,null,"Tajikistan","TJK"]
[null,null,"Tanzania, United Republic of","TZA"]
[null,null,"Thailand","THA"]
[null,null,"Togo","TGO"]
[null,null,"Tokelau","TKL"]
[null,null,"Tonga","TON"]
[null,null,"Trinidad and Tobago","TTO"]
[null,null,"Tunisia","TUN"]
[null,null,"Turkey","TUR"]
[null,null,"Turkmenistan","TKM"]
[null,null,"Turks and Caicos Islands","TCA"]
[null,null,"Tuvalu","TUV"]
[null,null,"US Minor Outlying Islands","UMI"]
[null,null,"Uganda","UGA"]
[null,null,"Ukraine","UKR"]
[null,null,"United Arab Emirates","ARE"]
[null,null,"United Kingdom","GBR"]
[null,null,"United States","USA"]
[null,null,"Uruguay","URY"]
[null,null,"Uzbekistan","UZB"]
[null,null,"Vanuatu","VUT"]
[null,null,"Venezuela","VEN"]
[null,null,"Viet Nam","VNM"]
[null,null,"Virgin Islands (British)","VGB"]
[null,null,"Virgin Islands (U.S.)","VIR"]
[null,null,"Wallis and Futuna Islands","WLF"]
[null,null,"Western Sahara","ESH"]
[null,null,"Yemen","YEM"]
[null,null,"Yugoslavia","YUG"]
[null,null,"Zambia","ZMB"]
[null,null,"Zimbabwe","ZWE"]