{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Vendor Data","POC Data","Vendor Form","hiddenSheet","hiddenSheet POC"],"not_rendered":{"images":4,"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Vendor Data","index":0,"n_rows":2,"n_cols":20,"rows_kept":2,"hidden":true}
["(Do Not Modify) Account","(Do Not Modify) Row Checksum","(Do Not Modify) Modified On","Name","DUNS Number","Vendor Type","Cage Code","Vendor Website URL","Vendor Phone","Extension","Vendor Profile","Current or Former DHS Contractor","Current or Former DHS Contract Numbers","Street","City","State/Province","ZIP Code","Corporate Parent","Strategic Sourcing","Owner"]
[{"$nulls":3},121,"fadsf","Corporate Parent",null,"ewqewfqwr"]

{"sheet":"POC Data","index":1,"n_rows":2,"n_cols":13,"rows_kept":2,"hidden":true}
["(Do Not Modify) Contact","(Do Not Modify) Row Checksum","(Do Not Modify) Modified On","First Name","Last Name","Phone Number","Extension","Email","Job Title","Additional Information","Vendor","Primary/Alternate?","Owner"]
[{"$nulls":3},"fasdadf","sdaffaf",null,null,"asfda",null,null,121]

{"sheet":"Vendor Form","index":2,"n_rows":133,"n_cols":10,"rows_kept":133,"merged":[[2,2,2,10],[7,2,7,5],[7,8,7,10],[10,2,10,5],[10,8,10,10],[15,2,15,5],[18,2,18,10],[21,2,21,5],[21,8,21,10],[25,3,25,5],[27,3,27,5],[29,18,29,20],[31,2,31,5],[32,2,32,4],[34,2,34,5],[34,8,34,10],[36,2,36,5],[36,8,36,10],[38,2,38,5],[38,8,38,10],[40,2,40,5],[40,8,40,10],[42,2,42,5],[42,8,42,10],[44,1,44,11],[47,2,47,5],[47,8,47,10],[50,2,50,5],[53,2,53,5],[53,8,53,10],[56,2,57,5],[61,2,61,10],[62,2,62,10],[64,2,64,3],[64,4,64,7],[68,2,75,10]]}
[]
[null," "]
[null,null,"EngageDHS Form"]
[]
[null,null,"Please complete the following form with information pertinent from your company"]
[]
[null,null,"Vendor Name: *",{"$nulls":5},"DUNS Number: (N/A if none) *"]
[]
[]
[null,null,"Vendor Type (Corporate Parent or Satellite Office): * ",{"$nulls":5},"CAGE Code:"]
[]
[null,null,"Corporate Parent"]
[null,null,"Satellite Office"]
[]
[null,null,"Vendor Website: *",{"$nulls":5},"Phone Number:"]
[{"$nulls":9},"Ext:"]
[]
[null,null,"Vendor Profile: *"]
[]
[]
[null,null,"Current/Former DHS Contractor? (Yes or No):",{"$nulls":5},"Contract Number(s) if Current/Former Contractor:"]
[]
[null,null,"Yes"]
[null,null,"No"]
[]
[null,null,"Street:",{"$nulls":4},"City:"]
[]
[null,null,"State:",{"$nulls":4},"Zip:"]
[]
[]
[null,null,"Corporate Parent (if Satellite Office selected):",{"$nulls":5},"Strategic Sourcing Vehicle? (Yes or No):"]
[]
[]
[null,null,"NAICS Code(s):",{"$nulls":5},"Socioeconomic Status (SES):"]
{"$rows_empty":10}
[null,"POC Information"]
[]
[null,null,"First Name: *",{"$nulls":5},"Last Name: *"]
[]
[]
[null,null,"Email: *",{"$nulls":5},"Phone Number:"]
[{"$nulls":9},"Ext:"]
[]
[null,null,"Job Title:",{"$nulls":5},"Vendor or DUNS # "]
[{"$nulls":8},{"$f":"IF(C8=\"\",\"\",C8)","v":""}]
[]
[null,null,"Additional Information:",{"$nulls":5},"Primary or Alternate POC?:"]
[]
[]
[]
[]
[]
[null,null,"FOR DHS USE ONLY"]
[null,null,"Industry Liaison Submission Panel"]
[]
[null,null,"Login ID:"]
[]
[]
[]
[null,null,"1. After logging in click Create Import Sheets to Create Vendor Data Import Sheet and POC Import Sheet\n2. Go to https://crmaas2016.dhs.gov/EngageDHS and click the hamburger icon\n3. Click 'Industry Liaison' and then click 'Vendors'\n4. Click 'Import Data' and choose the Data Import Sheet to Import (The file name will appear as:  VendorData_(Vendor Name)\n5. After Import, Click 'Import Data' again to Import the Vendor POC Import Sheet  (The file name will appear as:  POCData_(Vendor POC Name)\n6. After completion, ensure Vendor and POC have been Imported correctly\n7. Navigate to the Vendor and scroll down to Commodities\n8. In the Commodities section enter in the NAICS Codes and SES that were provided from the Vendor"]
{"$rows_empty":9}
["Alabama"]
["Alaska"]
["Arizona"]
["Arkansas"]
["California"]
["Colorado"]
["Connecticut"]
["Delaware"]
["District of Columbia"]
["Florida"]
["Georgia"]
["Hawaii"]
["Idaho"]
["Illinois"]
["Indiana"]
["Iowa"]
["Kansas"]
["Kentucky"]
["Louisiana"]
["Maine"]
["Maryland"]
["Massachusetts"]
["Michigan"]
["Minnesota"]
["Mississippi"]
["Missouri"]
["Montana"]
["Nebraska"]
["Nevada"]
["New Hampshire"]
["New Jersey"]
["New Mexico"]
["New York"]
["North Carolina"]
["North Dakota"]
["Ohio"]
["Oklahoma"]
["Oregon"]
["Pennsylvania"]
["Rhode Island"]
["South Carolina"]
["South Dakota"]
["Tennessee"]
["Texas"]
["Utah"]
["Vermont"]
["Virginia"]
["Washington"]
["West Virginia"]
["Wisconsin"]
["Wyoming"]
[]
[]
["Primary"]
["Alternate"]

{"sheet":"hiddenSheet","index":3,"n_rows":22,"n_cols":33,"rows_kept":22,"hidden":true}
["account:z4PhNX7vuL3xVChQ1m2AB9Yg5AULVxXcg/SpIdNs6c5H0NE8XYXysP+DGNKHfuwvY7kxvUdBeoGlODJ6+SfaPg==:accountid=%28Do%20Not%20Modify%29%20Account&checksumLogicalName=%28Do%20Not%20Modify%29%20Row%20Checksum&modifiedon=%28Do%20Not%20Modify%29%20Modified%20On&name=Name&primarycontactid=Main%20POC&accountnumber=Account%20Number&parentaccountid=Corporate%20Parent&emailaddress1=Email&telephone1=Vendor%20Phone&telephone2=Other%20Phone&fax=Fax&websiteurl=Website&address1_addresstypecode=Address%201%3a%20Address%20Type&address1_name=Address%201%3a%20Name&address1_line1=Street&address1_line2=Address%201%3a%20Street%202&address1_line3=Address%201%3a%20Street%203&address1_city=City&address1_stateorprovince=State&address1_postalcode=ZIP%20Code&address1_country=Address%201%3a%20Country%2fRegion&address1_telephone1=Address%20Phone&address1_shippingmethodcode=Address%201%3a%20Shipping%20Method&address1_freighttermscode=Address%201%3a%20Freight%20Terms&description=Vendor%20Profile&industrycode=Industry&revenue=Annual%20Revenue&numberofemployees=No.%20of%20Employees&sic=SIC%20Code&ownershipcode=Ownership&tickersymbol=Ticker%20Symbol&territoryid=Territory&customertypecode=Relationship%20Type&accountcategorycode=Category&transactioncurrencyid=Currency&creditlimit=Credit%20Limit&creditonhold=Credit%20Hold&paymenttermscode=Payment%20Terms&defaultpricelevelid=Price%20List&ownerid=Owner&preferredcontactmethodcode=Preferred%20Method%20of%20Contact&donotemail=Do%20not%20allow%20Emails&donotphone=Do%20not%20allow%20Phone%20Calls&donotpostalmail=Do%20not%20allow%20Mails&donotbulkemail=Do%20not%20allow%20Bulk%20Emails&donotfax=Do%20not%20allow%20Faxes&originatingleadid=Originating%20Lead&donotsendmm=Send%20Marketing%20Materials&preferredappointmentdaycode=Preferred%20Day&preferredappointmenttimecode=Preferred%20Time&preferredserviceid=Preferred%20Service&preferredequipmentid=Preferred%20Facility%2fEquipment&preferredsystemuserid=Preferred%20User&ilt_dunsnumber=DUNS%20Number&ilt_vendortype=Vendor%20Type&ilt_cagecode=Cage%20Code&ilt_vendorwebsiteurl=Vendor%20Website%20URL&ilt_vendorphoneext=Extension&ilt_currentorformerdhscontractor=Current%20or%20Former%20DHS%20Contractor&ilt_currentorformerdhscontractnumbers=Current%20or%20Former%20DHS%20Contract%20Numbers&ilt_strategicsourcing=Strategic%20Sourcing&ilt_stateprovinceid=State%2fProvince"]
["Bill To","Ship To","Primary","Other"]
["Airborne","DHL","FedEx","UPS","Postal Mail","Full Load","Will Call"]
["FOB","No Charge"]
["Accounting","Agriculture and Non-petrol Natural Resource Extraction","Broadcasting Printing and Publishing","Brokers","Building Supply Retail","Business Services","Consulting","Consumer Services","Design, Direction and Creative Management","Distributors, Dispatchers and Processors","Doctor's Offices and Clinics","Durable Manufacturing","Eating and Drinking Places","Entertainment Retail","Equipment Rental and Leasing","Financial","Food and Tobacco Processing","Inbound Capital Intensive Processing","Inbound Repair and Services","Insurance","Legal Services","Non-Durable Merchandise Retail","Outbound Consumer Service","Petrochemical Extraction and Distribution","Service Retail","SIG Affiliations","Social Services","Special Outbound Trade Contractors","Specialty Realty","Transportation","Utility Creation and Distribution","Vehicle Retail","Wholesale"]
["Public","Private","Subsidiary","Other"]
["Competitor","Consultant","Customer","Investor","Partner","Influencer","Press","Prospect","Reseller","Supplier","Vendor","Other"]
["Preferred Customer","Standard"]
["Yes","No"]
["Net 30","2% 10, Net 30","Net 45","Net 60"]
["Any","Email","Phone","Fax","Mail"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Send","Do Not Send"]
["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["Morning","Afternoon","Evening"]
["Corporate Parent","Satellite Office"]
["No","Yes"]
["No","Yes"]

{"sheet":"hiddenSheet POC","index":4,"n_rows":19,"n_cols":7,"rows_kept":19,"hidden":true}
["contact:z4PhNX7vuL3xVChQ1m2AB9Yg5AULVxXcg/SpIdNs6c5H0NE8XYXysP+DGNKHfuwvY7kxvUdBeoGlODJ6+SfaPg==:contactid=%28Do%20Not%20Modify%29%20Contact&checksumLogicalName=%28Do%20Not%20Modify%29%20Row%20Checksum&modifiedon=%28Do%20Not%20Modify%29%20Modified%20On&ilt_pocid=POC&salutation=Salutation&firstname=First%20Name&middlename=Middle%20Name&lastname=Last%20Name&jobtitle=Job%20Title&parentcustomerid=Parent%20POC%20%26%20Vendor&telephone1=Phone%20Number&telephone2=Home%20Phone&mobilephone=Mobile%20Phone&fax=Fax&emailaddress1=Email&address1_addresstypecode=Address%201%3a%20Address%20Type&address1_name=Address%201%3a%20Name&address1_line1=Address%201%3a%20Street%201&address1_line2=Address%201%3a%20Street%202&address1_line3=Address%201%3a%20Street%203&address1_city=Address%201%3a%20City&address1_stateorprovince=Address%201%3a%20State%2fProvince&address1_postalcode=Address%201%3a%20ZIP%2fPostal%20Code&address1_country=Address%201%3a%20Country%2fRegion&address1_telephone1=Address%201%3a%20Phone&address1_freighttermscode=Address%201%3a%20Freight%20Terms&address1_shippingmethodcode=Address%201%3a%20Shipping%20Method&description=Additional%20Information&department=Department&managername=Manager&managerphone=Manager%20Phone&accountrolecode=Role&assistantname=Assistant&assistantphone=Assistant%20Phone&gendercode=Gender&familystatuscode=Marital%20Status&spousesname=Spouse%2fPartner%20Name&birthdate=Birthday&anniversary=Anniversary&ownerid=Owner&transactioncurrencyid=Currency&creditlimit=Credit%20Limit&creditonhold=Credit%20Hold&paymenttermscode=Payment%20Terms&defaultpricelevelid=Price%20List&preferredcontactmethodcode=Preferred%20Method%20of%20Contact&donotemail=Do%20not%20allow%20Emails&donotphone=Do%20not%20allow%20Phone%20Calls&donotpostalmail=Do%20not%20allow%20Mails&donotbulkemail=Do%20not%20allow%20Bulk%20Emails&donotfax=Do%20not%20allow%20Faxes&originatingleadid=Originating%20Lead&donotsendmm=Send%20Marketing%20Materials&preferredappointmentdaycode=Preferred%20Day&preferredappointmenttimecode=Preferred%20Time&preferredserviceid=Preferred%20Service&preferredequipmentid=Preferred%20Facility%2fEquipment&preferredsystemuserid=Preferred%20User&ilt_poctype=Primary%2fAlternate%3f&ilt_phoneext=Extension&ilt_vendorid=Vendor"]
["Bill To","Ship To","Primary","Other"]
["FOB","No Charge"]
["Airborne","DHL","FedEx","UPS","Postal Mail","Full Load","Will Call"]
["Decision Maker","Employee","Influencer"]
["Male","Female"]
["Single","Married","Divorced","Widowed"]
["Yes","No"]
["Net 30","2% 10, Net 30","Net 45","Net 60"]
["Any","Email","Phone","Fax","Mail"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Allow","Do Not Allow"]
["Send","Do Not Send"]
["Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["Morning","Afternoon","Evening"]
["Primary","Alternate"]