{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CRF","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":33,"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":"CRF","index":0,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[49,0,49,4],[60,0,60,4],[70,0,70,4],[0,0,0,4],[1,0,4,4],[6,0,6,4],[15,0,15,4],[31,0,31,4],[43,0,43,4]]}
["PROPEL CUSTOMER MASTER DATA REQUEST FORM"]
["PLEASE COMPLETE ALL THE REQUIRED FIELDS \n(MANDATORY FIELDS ARE MARKED WITH A * IF INFORMATION IS NOT COMPLETED THE REQUEST WILL BE REJECTED)"]
[]
[]
[]
[null,null,null,null,null,null,null,"Mandatory Field"]
["GENERAL DETAILS",null,null,null,null,null,"*","Mandatory Field"]
[]
["REQUESTOR NAME*",null,null,"DATE*"]
["BUSINESS UNIT (SALES ENTITY)*","N60 - NA Fire Detection",null,"TITLE*"]
["ACTION TYPE*",null,null,"EMAIL ADDRESS*"]
["CHANGE REQUEST TYPE*"]
["COMPANY CODE*"]
[]
[]
["CUSTOMER DETAILS"]
[]
["CUSTOMER NAME 1*",null,null,"TEL . PHONE (BILL TO TEL.PHONE)"]
["CUSTOMER NAME 2",null,null,"FAX"]
["ADDRESS*",null,null,"E-MAIL (BILL TO EMAIL ID)"]
["COUNTRY*",null,null,"VAT NUMBER /TAX ID*"]
["POST CODE *",null,null,"COMPANY REGISTRATION NO (OPTIONAL)"]
["CITY*",null,null,"LANGUAGE*"]
["REGION/ STATE/PROVIDENCE*"]
["TRANSPORTATION ZONE*","US00KY-US Kentucky"]
["IF PO BOX ADDRESS"]
["1. PO BOX"]
["2. POSTAL CODE"]
["3. COMPANY POSTAL CODE"]
[]
[]
["BUSINESS / SALES & CREDIT DETAILS"]
[]
["CURRENCY INTO ERP SYSTEM*"]
["INCO TERMS*","FOB Free on Board"]
["INCO TERMS LOCATION"]
[" Freight Terms (INCO TERMS LOCATION 2)*","Prepaid"]
["CREDIT LIMIT WITH CURRENCY*"]
["PAYMENT TERMS*"]
["SEARCH TERM SAP*",{"$f":"_xlfn.CONCAT(B18,\" \",B19)","v":" "}]
[]
[]
[]
["COMPANY CODE DATA"]
[]
["RECONCILIATION ACCOUNT*","12100001  Accounts Receivable - Trade"]
["PAYMENT METHOD"]
[]
[]
["SALES AREA DATA"]
[]
["CUSTOMER GROUP (CHANNEL) - GLOBAL FIELDS*",null,null,"PRICE LIST*","F1- SIN Simplx India Dlr"]
["ADDITIONAL DATA - CUSTOMER GROUP 2*","100- Strat./Glob.Account",null,"DELIVERY PRIORITY*","01- High"]
["ADDITIONAL DATA - CUSTOMER GROUP 5 (SUB CHANNEL)",null,null,"CUSTOMER TAX CLASSIFICATION*"]
["SALES DISTRICT*","ZZ0001- Europe",null,"ACCOUNT ASSISGNMENT GROUP","Z1 Local Sales"]
["SALES OFFICE*","CH10 - Fire Detection Office",null,"COMPLETE DELIVERY","Blank - For Partial Delivery"]
["SALES GROUP*","CH1 - JCI Fire Detection",null,"SHIPPING CONDITION"]
["PRICE GROUP*","10- Level10",null,"ORDER BLOCK (SALES VIEW)"]
[]
[]
["PARTNER FUNCTIONS"]
[]
["SOLD TO"]
["SHIP TO"]
["BILL TO"]
["PAYER"]
["Intl Freight Forwarder (CR) Optional"]
["Default Carrier (TF)  Optional"]
[]
[]
["CONTACT PERSON NAME"]
[]
["FIRST NAME*"]
["LAST NAME*"]
["E-MAIL*"]
["TELEPHONE"]
["FAX"]

{"sheet":"Sheet1","index":1,"n_rows":60,"n_cols":36,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["TAX_EXEMPT","VAT_GROUP","VAT_REDUCED","Change Request Types","Identification Type","Inco Terms","Freight Terms (Incoterm Location 2) ","Reconciliation Account","Sort Keys","Planning Group","Customer Groups","Customer Group 2","Customer Group 5","Sales District","Price Group","Price List","Shipping Conditions","Delivery Priority","Customer Tax Classification","Account Assignment Group","Complete Delivery","Max Partial Deliveries","Order Block","Business Unit (Sales Entity)","Country","US","Other","5. Create Inter Company Customers Sold To/Ship To (INCP)","6 .Create Inter Company Bill To/Payer (ZICC)","29110001 AR - InterCompany","Transportation Zone","Description","TZ Description","US States","US TZ","Non US TZ"]
["EXEMPT","VAT_GROUP","VAT_RED","1. Create Third Party (Sold To)","BAAN","CFR Costs and Freight","Prepaid","12100001  Accounts Receivable - Trade","Sort  Description","A1 Domestic Domestic payments (A/P)","02- Intercompany","100- Strat./Glob.Account","101- Contracting","ZZ0001- Europe","10- Level10","F1- SIN Simplx India Dlr","11- Ocean","01- High","0 Tax Exempt","Z1 Foreign Sales","X- For Complete Delivery",1,"01- Overall Block","N10 - NA Applied","US","Z2 Local Sales","Z1 Foreign Sales","29110001 AR - InterCompany","29110001 AR - InterCompany",null,"INT00EU","Europe",{"$f":"_xlfn.CONCAT(AE2,\"-\",AF2)","v":"INT00EU-Europe"},"Alaska","US00AK-US Alaska","INT00EU-Europe"]
[null,null,"VAT_SRED","2. Create Third Party (Payer)","NAVGTR","CIF Costs, Insurance & Freight","Prepaid+Add","29110001 AR - InterCompany","000 - Allocation number","A2 Foreign Foreign payments (A/P)","03- Manufacturing Reps","101- National Account","102- Service","ZZ0002- North America","11- Level11","FA- ACC Autocall Can Dlr","12- Ground","02- Normal item","1 Liable for Taxes","Z2 Local Sales","Blank - For Partial Delivery",2,"02- Partner Blocked","N11 - NA Air Distribution","Other",null,null,null,null,null,"INT00ME","Middle East",{"$f":"_xlfn.CONCAT(AE3,\"-\",AF3)","v":"INT00ME-Middle East"},"Alabama","US00AL-US Alabama","INT00ME-Middle East"]
[null,null,null,"3. Create Third Party (Ship To)","GPCRM1","CIP Carriage and Insurance Paid to","Customer Collect",null,"001- Posting date","A3 V-affil Vendor-affiliated companies","04- Original Equip Mfg","102- Corporate Customer","103- Aftermarket Parts","ZZ0003- Latin America","12- Level12","FB- ACD Dom.AutoCall.dlr","13- 1 Day Air (10:30 AM)","03- Low",null,"Z3 Inter Company Sales",null,3,"03- Only Cash Allowed","N20 - NA Ind Ref",null,null,null,null,null,null,"INT00AS","Asia","INT00AS-Asia","Arkansas","US00AR-US Arkansas","INT00AS-Asia"]
["Customer Type",null,null,"4. Create Third Party (Bill To)","AOMS","CPT Carriage Paid to","Third Party Billing",null,"002- Doc. No, fiscal year","A4 Major ven Major vendors","05- Retailers","103- Intercompany","104- Product Distribution","ZZ0004- Asia Pacific","13- Level13","FC- CAD Dom.AC.Dlr. CWSI","14- 1 Day Air (3:00 PM)","24- Fast Track",null,null,null,4,"04- E-Invoicing","N30 - NA Ducted Systems",null,null,null,null,null,null,"INT00AF","Africa","INT00AF-Africa","Arizone","US00AZ-US Arizone","INT00AF-Africa"]
["Local Customer",null,null,"5. Create Inter Company Customers Sold To/Ship To (INCP)","LAWSON","DAP Delivered at Place",null,null,"003 - Document date","A5 HR Personnel costs","06- Contr/Dlr/Instlr/Int","104- Affiliate/Joint Vent","105- HVAC","ZZ0005- Middle East & Africa","14- Level14","FD- ACL Autcall APAC Dlr","15- 2 Day Air","25- Emergency",null,null,null,5,null,"N40 - NA Marine",null,null,null,null,null,null,"INT00SA","South America","INT00SA-South America","California","US00CA-US California","INT00SA-South America"]
["Enterprise",null,null,"6 .Create Inter Company Bill To/Payer (ZICC)",null,"DDP Delivered Duty Paid",null,null,"004- Branch account","A6 Taxes Taxes","07- eCommerce","105- Others","106- Marine / Navy",null,"15- Level15","FE- ANG AnsulGrtYarmouth","19- International Air",null,null,null,null,6,null,"N50 - NA Controls",null,null,null,null,null,null,"INT00CA","Canada","INT00CA-Canada","Colorado","US00CO-US Colorado"]
["Government",null,null,"7. Change Customer General Data",null,"DPU Delivered at Place",null,null,"005- Loc.currency amount","E1 Receipts Customer receipts (A/R)","08- Distrbtr(Wholesaler)","106- Branch","107- Wholesaler",null,"16- Level16","FF- ANS Ansul TransferPr","20- IntrnationlAirPriori",null,null,null,null,7,null,"N60 - NA Fire Detection",null,null,null,null,null,null,"INT00MEX","Mexico","INT00MEX-Mexico","Connecticut","US00CT-US Connecticut"]
["National",null,null,"8. Change Customer Sales Area Data",null,"EXW Ex Works",null,null,"006 - Doc.currency amount","E2 Domestic Domestic customers","09- Commission Agent","107- Intra-Company","108- AuthorisedDistributo",null,"17- Level17","FG- AUZ New Zealand","21- 3 Day Air",null,null,null,null,8,null,"N61 - NA FS-Intrusion",null,null,null,null,null,null,"US00AK","US Alaska","US00AK-US Alaska","Washington DC","US00DC-US Washington DC"]
["Residential Customer",null,null,"9. Change InterCompany Customers",null,"FAS Free Alongside Ship",null,null,"007-   Bill/exch.due date","E3 Foreign Foreign customers","10- GP Direct-Owner",null,"109- BSNA USA",null,"18- Level18","FH- CWU CWSI Dealer","22- 1 Day Air (8:00 AM)",null,null,null,null,9,null,"N62 - NA Security-ACVS",null,null,null,null,null,null,"US00AL","US Alabama","US00AL-US Alabama","Delaware","US00DE-US Delaware"]
[null,null,null,"10. Block/Unblock Third Party (Sold To)",null,"FCA Free Carrier",null,null,"008-  Cost center","E4 C-affil Customer-affiliated companies","11- GP Direct-GP Branch",null,"110- BSNA Canada",null,"19- Level19","FI- SCP BSNA US Br TrPr",null,null,null,null,null,null,null,"N63 - NA CORPORATE",null,null,null,null,null,null,"US00AR","US Arkansas","US00AR-US Arkansas","Florida","US00FL-US Florida"]
[null,null,null,"11. Block/Unblock Customer - Custom",null,"FOB Free on Board",null,null,"009 External doc.number   ","E5 High risk High risk customer","15- Branch Field Org NA",null,"500- Atocal N America Dlr",null,"20- Level20","FJ- DI01 BSNA US Cr TrPr",null,null,null,null,null,null,null,"N70 - NA Fire Suppression",null,null,null,null,null,null,"US00AZ","US Arizone","US00AZ-US Arizone","Georgia","US00GA-US Georgia"]
[null,null,null,null,null,"Z01 Freight Applied",null,null,"0010- Purchase order no.","E6 Major Major customers","16- Branch Field EMEALA",null,"501- Autocal/CWSI Dom Dlr",null,"GS- GSA Pricing","FK- SDE BSNA US LstPr",null,null,null,null,null,null,null,"N80 - NA JCH",null,null,null,null,null,null,"US00CA","US California","US00CA-US California","Hawaii","US00HI-US Hawaii"]
[null,null,null,null,null,"Z02 Freight Exempt",null,null,"011 Plant number","E7 Rent (A/R) Rent received","17- Branch Field OrgAPAC",null,"502- CWSI Dlr",null,null,"FL- SGI BAAN 112 to S4",null,null,null,null,null,null,null,"E10 - EMEA Applied",null,null,null,null,null,null,"US00CO","US Colorado","US00CO-US Colorado","Iowa","US00IA-US Iowa"]
[null,null,null,null,null,"Z03 Freight EXEMPT 50%",null,null,"012 Vendor number","E8 Redemption Loan redemption (A/R)","20- Others",null,"503- Ansul Dealers",null,null,"FM- GLP Simplx APAC Dlr",null,null,null,null,null,null,null,"E11 - EMEA Air Distr.",null,null,null,null,null,null,"US00CT","US Connecticut","US00CT-US Connecticut","Idaho","US00ID-US Idaho"]
[null,null,null,null,null,"Z04 Freight Third Party Billed",null,null,"014 Purchase order",null,null,null,"504- Midl east Simplx Dlr",null,null,"FN- SXC BSNA Ca Br TrPr",null,null,null,null,null,null,null,"E20 - EMEA Ind Ref",null,null,null,null,null,null,"US00DC","US Washington DC","US00DC-US Washington DC","Illinois","US00IL-US Illinois"]
[null,null,null,null,null,"Z05 Freight Collect",null,null," 015 Personnel number",null,null,null,"505- Midl east Atocal Dlr",null,null,"FO- SCT BSNA Ca Cr TrPr",null,null,null,null,null,null,null,"E30 - EMEA Ducted Systems",null,null,null,null,null,null,"US00DE","US Delaware","US00DE-US Delaware","Indiana","US00IN-US Indiana"]
[null,null,null,null,null,"Z06 Freight Exempt m",null,null,"016 Settlement period",null,null,null,"506- APAC Simplex Dealers",null,null,"FP- SDC BSNA Can LPr",null,null,null,null,null,null,null,"E40 - EMEA Marine",null,null,null,null,null,null,"US00FL","US Florida","US00FL-US Florida","Kansas","US00KS-US Kansas"]
[null,null,null,null,null,"ZNA Not Applicable",null,null,"017 Settl.per., pers.no. ",null,null,null,"507- APAC Autocall Dealer",null,null,"FQ- IND Ind Mfg Company",null,null,null,null,null,null,null,"E50 - EMEA Controls",null,null,null,null,null,null,"US00GA","US Georgia","US00GA-US Georgia","Kentucky","US00KY-US Kentucky"]
[null,null,null,null,null,null,null,null," 018 Asset number",null,null,null,"508- LATAM Dealers",null,null,"FR- JCI JCI/TIS SmplxC/S",null,null,null,null,null,null,null,"E60 - EMEA Fire Detection",null,null,null,null,null,null,"US00HI","US Hawaii","US00HI-US Hawaii","Louisiana","US00LA-US  Louisiana"]
[null,null,null,null,null,null,null,null,"021 Segment text",null,null,null,"509- NAmerica Simplex Dlr",null,null,"FS- LAT Smplx LATAM Dlr",null,null,null,null,null,null,null,"E61 - EMEA FS-Intrusion",null,null,null,null,null,null,"US00IA","US Iowa","US00IA-US Iowa","Massachusetts","US00MA-US Massachusetts"]
[null,null,null,null,null,null,null,null,"022 One-time name / city ",null,null,null,"510- New Zealand",null,null,"FT- MEA Aut ME Dlr",null,null,null,null,null,null,null,"E62 - EMEA Security-ACVS",null,null,null,null,null,null,"US00ID","US Idaho","US00ID-US Idaho","Maryland","US00MD-US Maryland"]
[null,null,null,null,null,null,null,null,"022 One-time name / city ",null,null,null,"511- Space Age",null,null,"FU- MES Smp ME Dlr",null,null,null,null,null,null,null,"E70 - EMEA Fire Suppression",null,null,null,null,null,null,"US00IL","US Illinois","US00IL-US Illinois","Maine","US00ME-US Maine"]
[null,null,null,null,null,null,null,null,"023 One-time city / name",null,null,null,null,null,null,"FV- SAE Spc Age Elctron",null,null,null,null,null,null,null,"E80 - EMEA JCH",null,null,null,null,null,null,"US00IN","US Indiana","US00IN-US Indiana","Michigan","US00MI-US Michigan"]
[null,null,null,null,null,null,null,null,"024 Document header text ",null,null,null,null,null,null,"FW- USL Ext US Dlr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00KS","US Kansas","US00KS-US Kansas","Minnesota","US00MN-US Minnesota"]
[null,null,null,null,null,null,null,null,"025 CPU date",null,null,null,null,null,null,"FX- RAJ Rajecko Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00KY","US Kentucky","US00KY-US Kentucky","Missouri","US00MO-US Missouri"]
[null,null,null,null,null,null,null,null,"026 Pmnt per.bslne date",null,null,null,null,null,null,"FY- RYN Reynosa Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00LA","US  Louisiana","US00LA-US  Louisiana","Mississsipi","US00MS-US Mississsipi"]
[null,null,null,null,null,null,null,null,"027 Value date",null,null,null,null,null,null,"FZ- TMC Total Manufactur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MA","US Massachusetts","US00MA-US Massachusetts","Montana","US00MT-US Montana"]
[null,null,null,null,null,null,null,null,"028 Asset number",null,null,null,null,null,null,"GS- GSA Customer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MD","US Maryland","US00MD-US Maryland","Noth Carolina","US00NC-US Noth Carolina"]
[null,null,null,null,null,null,null,null,"029 Pstng month,vendor ",null,null,null,null,null,null,"R1- Adv Exc Pricing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00ME","US Maine","US00ME-US Maine","Noth Dakota","US00ND-US Noth Dakota"]
[null,null,null,null,null,null,null,null,"031 Customer number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MI","US Michigan","US00MI-US Michigan","Nebraska","US00NE-US Nebraska"]
[null,null,null,null,null,null,null,null,"032 Pstng yr,month,curr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MN","US Minnesota","US00MN-US Minnesota","New Hampshire","US00NH-US New Hampshire"]
[null,null,null,null,null,null,null,null,"033 Cost center",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MO","US Missouri","US00MO-US Missouri","New Jersey","US00NJ-US New Jersey"]
[null,null,null,null,null,null,null,null,"034 Month, cost center",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MS","US Mississsipi","US00MS-US Mississsipi","New Mexico","US00NM-US New Mexico"]
[null,null,null,null,null,null,null,null,"035 Contract number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00MT","US Montana","US00MT-US Montana","Nevada","US00NV-US Nevada"]
[null,null,null,null,null,null,null,null,"036 Order ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NC","US Noth Carolina","US00NC-US Noth Carolina","New York","US00NY-US New York"]
[null,null,null,null,null,null,null,null,"037 Currency key",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00ND","US Noth Dakota","US00ND-US Noth Dakota","Ohio","US00OH-US Ohio"]
[null,null,null,null,null,null,null,null,"061 Test1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NE","US Nebraska","US00NE-US Nebraska","Oklahoma","US00OK-US Oklahoma"]
[null,null,null,null,null,null,null,null,"065 Test5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NH","US New Hampshire","US00NH-US New Hampshire","Oregon","US00OR-US Oregon"]
[null,null,null,null,null,null,null,null,"101 Cash discnt clearing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NJ","US New Jersey","US00NJ-US New Jersey","Pennsylvania","US00PA-US Pennsylvania"]
[null,null,null,null,null,null,null,null,"105 Test",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NM","US New Mexico","US00NM-US New Mexico","Puerto Rico","US00PR-US Puerto Rico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NV","US Nevada","US00NV-US Nevada","Rhode Island","US00RI-US Rhode Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00NY","US New York","US00NY-US New York","South Carolina","US00SC-US South Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00OH","US Ohio","US00OH-US Ohio","South Dakota","US00SD-US South Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00OK","US Oklahoma","US00OK-US Oklahoma","Tennesse","US00TN-US Tennesse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00OR","US Oregon","US00OR-US Oregon","Texas","US00TX-US Texas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00PA","US Pennsylvania","US00PA-US Pennsylvania","Utah","US00UT-US Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00PR","US Puerto Rico","US00PR-US Puerto Rico","Virginia","US00VA-US Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00RI","US Rhode Island","US00RI-US Rhode Island","Vermont","US00VT-US Vermont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00SC","US South Carolina","US00SC-US South Carolina","Washington","US00WA-US Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00SD","US South Dakota","US00SD-US South Dakota","Wisconsin","US00WI-US Wisconsin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00TN","US Tennesse","US00TN-US Tennesse","West Virginia","US00WV-US West Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00TX","US Texas","US00TX-US Texas","Wyoming","US00WY-US Wyoming"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00UT","US Utah","US00UT-US Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00VA","US Virginia","US00VA-US Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00VT","US Vermont","US00VT-US Vermont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00WA","US Washington","US00WA-US Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00WI","US Wisconsin","US00WI-US Wisconsin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00WV","US West Virginia","US00WV-US West Virginia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"US00WY","US Wyoming","US00WY-US Wyoming"]