{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIONS","Customer_Upload","Validation","ErrorCodes","Errors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":26,"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":"INSTRUCTIONS","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,2],[41,1,41,7]]}
[null,"INSTRUCTIONS FOR VARIOUS SPONSOR CUSTOMER UPLOAD TEMPLATE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"COLUMN","DESCRIPTION"]
[null,"A","   For SSC use only (We will generate and provided your N99 customer number to you by email) "]
[null,"B","   Enter the Customer Billing Information. Validate will fail if name exceeds 40 characters"]
[null,"C","   Enter the Country Name"]
[null,"D","   Auto populates if column C is the United States"]
[null,"E-G","   Enter Customer Billing Address"]
[null,"H","   Enter City name"]
[null,"I","Enter State or Canadian Province if you choose"]
[null,"J","Enter State"]
[null,"K","   Enter Postal Code"]
[null,"L","Enter customer email address (invoices and statements will be emailed if this field is completed) Up to 3 email adresses may be entered seperated by ; and no spaces"]
[null,"M","Enter customer billing contact name"]
[null,"N","   Enter customer billing phone number. Please omit dashes between numbers"]
[null,"U","For SSC use only"]
[null,"AB","   For SSC use only"]

{"sheet":"Customer_Upload","index":1,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,"Default to USA","This one will automatically fill in.","Last Modified: 10/26/2018",null,"No Address 4 (There is none for SPALL)",null,"State Cd populated via State or Province name if USA/Canada","code else",null,null,"Must be entered Last, First if that is how you want it to be loaded.",null,null,null,"Fill in this field","and this field","this will populate","do not edit these two.",null,"Default to S06","Default to CT04","Default to B07",null,null,null,"DO NOT EDIT.  Deter- mined by \"Billed By\""]
["Customer ID (SSC use only)","Business/Customer Name (Max Length 40 Chars)","Country Name","Country Code (based on Country Name)","Billing Address 1 (Prepend \"Attn: \" if required)\n(55 characters)","Billing Address 2 \n(55 characters)","Billing Address 3 \n(55 characters)","City","State or province name if USA/Canada ONLY (optional)","State","Postal Code","Customer email address for email submission","Customer Contact name (Last, First)","Customer Phone #","Customer Type Description","Customer Type","Billed By","Print Invoice Detail Report (If GLINT)?","Bill Plan Identifier","Print Invoice Detail Report?","Corporate Cust ID (SSC use only)","Credit Analyst","Collector","Billing Specialist","Reporting Requirements TYPE.","Invoice Form ID","Customer PO #","Statement Group (internal use only)"]

{"sheet":"Validation","index":2,"n_rows":265,"n_cols":8,"rows_kept":265,"cut":false,"hidden":true,"merged":[]}
[null,"CR-GL   CR-Other   One-Time   Milestone   Recurring   Scheduled"]
[null,"vals:","Customer Types",null,null,"Invoice Form IDs"]
[null,"Scheduled",0,"Scheduled",null,"SPSTANDARD"]
[null,"CR-GL",5,"Cost Reimbursable GL",null,"SF270"]
[null,"CR-Other",6,"Cost Reimbursable Other",null,"SF1034"]
[null,"Recurring",7,"Recurring"]
[null,"One-Time",8,"One-Time","Note -- this is being retained as an Excel 97 document -- so"]
[null,"Milestone",9,"Milestone"," things on other sheets may not be referred to if use is running"]
[null,null,"CustTypes, CustTypeVals, CustTypeLkp, CustToCode, CustCurrVals",null,"an old version -- so I filled in the values and am not using the"]
[null,1,"User 1","nope -- on list in error?","named ranges."]
[]
[null,null,"Not using now","Based on the \"Billed by\" field on the PAN"]
[null,"ST_GROUP"]
[null,"A","Group A","GLINT"]
[null,"B","Group B","GLINT Fast track"]
[null,"C","Group C","AR Manual"]
[null,"D","Group D","Fixed Price, Milestone, Pay Schedule, or One time -- or if none selected"]
[null,"E","Group E"]
[]
[null,null,"Leave these in her despite the fact that they're really not being used at all"]
[null,null,"Not using now except in validation macro",null,null,null,"Not using now except in validation macro"]
["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,"Not using now exept in validation macro"]
[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"]

{"sheet":"ErrorCodes","index":3,"n_rows":46,"n_cols":4,"rows_kept":46,"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 there are more rows."]
[115,"Data below end of obvious data","Critical","Data follows a row with blank customer.  It will not be processed."]
[120,"Invalid Customer ID","Critical","The Customer ID may only have up to 15 characters."]
[124,"Customer Name is required","Critical","The Customer Name may not be blank"]
[125,"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."]
[200,"State field is required","Critical","The State field is required and may not be blank."]
[205,"Invalid State","Critical","Invalid State:  To get a new State added to the USA or Canada, please contact 4-Help."]
[210,"Incorrect Field Length","Critical","The State field may not be longer than 6 characters."]
[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."]
[315,"Excess Field Length","Critical","Address 1 is limited to 49 characters because it will be prepended with \"Attn: \"."]
[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."]
[400,"Prior Address Field blank","Critical","The Email field may not be longer than 30 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."]
[460,"Excess Field Length","Critical","Customer Phone Number may not be longer than 24 characters."]
[470,"Phone number will be modified","Warning","The Phone Number will be modified to remove spaces, dashes, parentheses, slashes and quotes."]
[500,"Special character removed from cell","Warning","This cell contains a carriage return, line feed, or tab.  I changed the source to remove it."]
[515,"Customer Type is required","Critical","The Customer Type field is required and may not be blank."]
[520,"Customer Type value incorrect","Critical","The Customer Type field is not one of the designated values."]
[521,"Invalid Bill Plan Identifier","Critical","If the Customer Type is CR-GL, the Bill Plan Identifier must be GLINT (001) or GLINT Fast Track (002)."]
[523,"Excess Field Length","Critical","The Bill Plan Identifier may not be longer than 3 characters."]
[526,"Invalid Print flag","Critical","The Print Invoice Detail Report must be Y or N if it is not blank."]
[530,"Corporate Customer ID is too long","Critical","The optional Corporate Customer ID may not be longer than 15 characters."]
[533,"Excess Field Length","Critical","The Credit Analyst may not be longer than 8 characters."]
[535,"Excess Field Length","Critical","The Collector may not be longer than 8 characters."]
[537,"Excess Field Length","Critical","The Billing Specialist may not be longer than 8 characters."]
[540,"Invoice Form ID is required","Critical","The Invoice Form ID field is required and may not be blank.  Please fill in Reporting Requirements Type to set."]
[550,"Invoice Form ID invalid","Critical","The Invoice Form ID must be GNSTANDARD."]
[560,"Customer Blanket PO is too long","Critical","The optional Customer Blanket PO may not be longer than 25 characters."]
[570,"Invoice Form ID invalid","Critical","The Statement Group must be \"Group \" followed by A, B, C, D, or E."]
[580,"Invalid Statement Group","Critical","The Statement Group must be Group A, B, C, D, or E."]

{"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-01T11:13:56.320"}]
[null,"Error Code","Error Description","Error Type","Cell Value","Cell Address"]