{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Diverse Supplier Profile","Lists","Extract"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"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":"Diverse Supplier Profile","index":0,"n_rows":125,"n_cols":3,"rows_kept":125,"cut":false,"hidden":false,"merged":[[124,1,124,2],[8,1,8,2],[6,1,6,2],[102,4,102,7],[2,1,3,2]]}
[]
[]
[null,"                        Supplier Diversity"]
[]
[]
[]
[null,"                                               Supplier Profile Form"]
[]
[null,"Thank you for your interest in the thyssenkrupp Supplier Diversity program. Please complete the following form to be added to our database.\n                                                                                                                                                                                                                                                 To submit this form, it must be opened and completed in .XLSM format.  Required data is identified with *     we cannot accept forms without the required data.  Save the form to your desktop and email to Supplierdiversity@thyssenkrupp.com                                                                                                                                                                               Your information will be shared with our purchasing groups and other stakeholders involved in sourcing opportunities."]
[null,"Date",{"$f":"TODAY()","v":"2020-02-10"}]
[]
[null,"COMPANY INFORMATION"]
[null,"Company Name*"]
[null,"DUNS Number* "]
[null,"Address 1*"]
[null,"Address 2"]
[null,"City*"]
[null,"State (select)*"]
[null,"Zip*"]
[null,"Country*","USA"]
[null,"Phone*"]
[null," Website URL"]
[null,"Year Established*"]
[null,"Federal Tax ID/ VAT "]
[null,"NAICS Code*"]
[null,"Total Annual Sales (in USD)*"]
[null,"Number of Employees*"]
[null,"Have you supplied to thyssenkrupp in the past?*"]
[null,"If yes, provide thyssenkrupp supplier ID"]
[null,"Quality Certifications"]
[]
[]
[]
[null,"COMPANY STRUCTURE"]
[null,"If your company is a Division or subsidiary of a parent company --                                                                                                                                                                    provide the following information for the parent company"]
[null,"DUNS Number"]
[null,"Parent Company Name"]
[null,"City"]
[null,"State"]
[null,"Zip"]
[null,"Country"]
[]
[null,"LOCATIONS OUTSIDE OF THE US (Mark an \"x\" where applicable)"]
[null,"Operations outside of USA that can provide product/service to USA"]
[null,"Mexico"]
[null,"Canada"]
[null,"China"]
[null,"Europe"]
[null,"None"]
[]
[null,"OFFICERS AND CONTACT INFORMATION"]
[null,"Owner/ Executive’s Name "]
[null,"Job Title"]
[null,"First Name"]
[null,"Last Name"]
[null,"Email Address"]
[null,"Phone"]
[null," "]
[null,"Primary /Sales Contact"]
[null,"Job Title"]
[null,"First Name"]
[null,"Last Name"]
[null,"Email Address"]
[null,"Phone"]
[]
[null,"Diverse Classification (Mark an \"x\" where applicable)*  "]
[null,"Minority-Owned Business (MBE)"]
[null,"Women-Owned Business (WBE)"]
[null,"Veteran-Owned Business (VET)"]
[null,"Small Business Class (select from list)"]
[null,"Lesbian, Gay, Bi-Sexual, Transgender (LGBT)"]
[null,"Other Certification(s)"]
[]
[null,"Ethnicity (Mark an \"x\" where applicable)"]
[null,"·         African American"]
[null,"·         Asian-Indian American"]
[null,"·         Asian-Pacific American"]
[null,"·         Hispanic"]
[null,"·         Native American"]
[]
[null,"CERTIFIED BY: (Mark an \"x\" where applicable & attach each certificate with your submission)*"]
[null,"CAMSC"]
[null,"NMSDC or Regional affiliate"]
[null,"WEConnect International "]
[null,"WBENC"]
[null,"NVBDC "]
[null,"8(a) Business Enterprise"]
[null,"SBA"]
[null,"Other"]
[null," "]
[null,"Certificate ID number*"]
[null," Expiration Date*"]
[null,"Certificate ID number 2"]
[null," Expiration Date 2"]
[]
[]
[null,"PRODUCT AND SERVICES (Please make a selection from the dropdowns)"]
[]
[null,"NONPRODUCTION MATERIAL (Select from List)"]
[null,"Corporate Commodity"]
[null,"Subcommodity"]
[]
[null,"PRODUCTION MATERIAL (Select from List)"]
[null,"Corporate Commodity"]
[null,"Subcommodity"]
[]
[null,"KEY CUSTOMERS"]
[null,"List top (3) customers"]
[null,"Customer 1"]
[null,"Customer 2"]
[null,"Customer 3"]
[null,"Are any automotive? (Yes or No)*"]
[]
[null,"MISC INFORMATION"]
[null,"Significant awards / recognition your company received? "]
[null,"How did you hear about the thyssenkrupp Supplier Diversity Program?"]
[]
[null,"Brief Comments/ capabilities attachments: (Lines spaces/area for comments and attachments if desired)"]
[]
[null,"* = Required",{"$f":"IF(COUNTA(C13,C14,C15,C17,C18,C19,C20,C21,C23,C25,C26,C27,C28,C91,C92,C112)=16,\"Required Fields Complete\",\"Required Fields Incomplete\")","v":"Required Fields Incomplete"}]
[]
[null,"If you have questions, contact our Corporate Supplier Diversity Champion @ Supplierdiversity@thyssenkrupp.com"]
[]
[]
[null,"               PRINT FORM                        RESET FIELDS"]

{"sheet":"Lists","index":1,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Alabama","(AL)",{"$f":"(A1 & \" \" &B1)","v":"Alabama (AL)"},"(AL)","Sales Address",null,"Production Commodity Info","Castings Subcommodities","Chemicals Subcommodities","Electromechanics & Assemblies Subcommodities","Electronics Subcommodities","Forgings & Formings Subcommodities","Steel & Bearings Subcommodities","Miscellaneous Subcommodities","Nonprod Cluster","Machines\\Equipment Subcommodities","General_Supplies Subcommodities","Tools Subcommodities","Spare_Parts\\Maintenance_Services Subcommodities","Facility_Management Subcommodities","NPM_Services Subcommodities","Freight_Purchasing Subcommodities"]
["Alaska","(AK)",{"$f":"(A2 & \" \" &B2)","v":"Alaska (AK)"},"(AK)","Distribution Address",null,"CASTINGS","Iron Castings CV / Industry","Covers & Doors","Actuators","Camera Modules","Fasteners & Formings","Bearings","Copper & Brass","Facility_Management","Assembly - Air Bag Applications","Adhesive Tapes","Abrasives Tools","Commissioning/Decommissioning Services","Architecture & Building Planning","Air","Air Transport"]
["Arizona","(AZ)","Arizona (AZ)","(AZ)","Corporate Address",null,"CHEMICALS","Iron Castings Passenger Cars","Decoratives","Assemblies","Discretes & Power ICs","Forgings Aluminum","Friction - Transmissions","Fabric / Airbags","Freight_Purchasing","Assembly line - Electronic","Cleaning / Personal Hygienics / Skin Care Products","Broaching Tools","Drive Technology","Building Rent & Lease","Car","Area Freight forwarding"]
["Arkansas","(AR)","Arkansas (AR)","(AR)","Order Address",null,"ELECTROMECHANICS\\ASSEMBLIES","LM HPDC large > 2.000 to","Functional Plastics & Resins","Connection Systems","Displays","Forgings Steel","Raw Material (Flat & Bar)","Filtration","General_Supplies","Assembly line - General","Clothes","Cuttings tools associated services","Elektro Technology","Canteen (all Food Services)","Consulting Services","CEP"]
["California","(CA)","California (CA)","(CA)","Manufacturing Address",null,"ELECTRONICS","LM HPDC medium < 2.000 to","Lubricants","Horn Units","ECU's","Powder Metals","Stamped Parts","Friction - Braking","Machines\\Equipment","Balancing - Test & Measurement","Corrugated & Solid Board","Die Casting Tools","Fluid Technology","Cleaning Facilities","Embedded Software","Customs Brokerage"]
["Colorado","(CO)","Colorado (CO)","(CO)","Invoice Address",null,"FORGINGS\\FORMINGS","LM HPDC small","Other Decorative & Air Bag Covers","Hydraulic, Pneumatics & Solenoids ","Micros | Asics","Subcontracting - Forgings & Formings","Subcontracting - Steel & Bearings","Leather","NPM_Services","Blasting","First Fill Lubricants (Production Material)","Drilling Tools (e.g. Driling, Reaming,etc.)","Inspection & Maintenance  Services","Cleaning Machines","Evaluation Model","Emties Management"]
["Connecticut","(CT)","Connecticut (CT)","(CT)",null,null,"STEEL\\BEARINGS","LM Other Technologies","Resins","Magnets, Motor Components & Coils","Passive, Relays and Lenses","Tooling - Forgings & Formings","Tooling - Steel & Bearings","Leather Wrapping","Spare_Parts\\Maintenance_Services","Cranes","Food and Drink Products","Fixtures & Clamping Tools associated Services","Measurement Technology","Drinking Water","Financial/Insurance Services","Factory Transport & Short Distance Transport"]
["Delaware","(DE)","Delaware (DE)","(DE)",null,null,"Miscellaneous","Metal Management / Process Technology","Rubber, Rubber Metals & Gaskets","Motors","PCBs and Others","Turned Parts","Tubes","OPW/Protection Cover","Tools","Deburring","General Plant / Storage & Warehouse Equipment","Gages, Measuring Machines associated Services","Parts for Assembly & Test Equipment","Dry Construction, Wooden Construction, Flooring, Roofing, Facade","Fleet Management","Full Truck Loads"]
["Florida","(FL)","Florida (FL)","(FL)",null,null,null,"Subcontracting - Castings","Surface Treatment & others","Sensors - Electrom.& Assemblies","Power Modules",null,"Wire Formings/Springs/Stalks/Cassettes","Pyro & Inflator Chemicals",null,"Environmental Simulation","Glasses, Earplugs, other PPE","Gearing Tools (hobs)","Parts for Engineering Equipment","Effluent","Health Services","Other Logistic Services"]
["Georgia","(GA)","Georgia (GA)","(GA)",null,null,null,"Tooling - Castings","Tooling - Chemicals","Switches","Sensors - Semiconductors",null,null,"Pyrotechnics",null,"Filtration / Briquetting","Gloves","Hand Gauges & Hand Inspection Equipment","Parts for Machines","Electrical Installation, Receiver Technology","Hotel","Packaging Services"]
["Hawaii","(HI)","Hawaii (HI)","(HI)",null,null,null,null,null,"SWS Heating Systems","Subcontracting - Electronics",null,null,"Seal Foils",null,"Handling Technology","Handtools","Injection Mold Tools","Parts for Process Equipment","Electricity","HR Development","Postal"]
["Idaho","(ID)","Idaho (ID)","(ID)",null,null,null,null,null,"Tooling - Electrom.& Assemblies","Tooling - Electronics",null,null,"Thread",null,"Heat Treatment","Household Appliances / Kitchen Equipment /  Dishes, Cutlery, Glassware ","Inserts","Repair Services","Elevator System ","Legal Services","Premium Land Freight"]
["Illinois","(IL)","Illinois (IL)","(IL)",null,null,null,null,null,"Wireharnesses",null,null,null,"Webbing / Belts",null,"Marking","Internal Manual Transport & Manual Lifting Devices / Lifting Means","Load Pick-up Fixtures, Hoists","Standard & small Parts","Employee Transportation","Marketing","Rail Transport & Combined Transport"]
["Indiana","(IN)","Indiana (IN)","(IN)",null,null,null,null,null,null,null,null,null,"Wood",null,"Master Forming","Laboratory Equipment (Lab. Furniture, lab. Chemicals, Apparatures, etc.)","Machine & Equipment related Tools associated Services","Technical Facility Equipment (incl. forklifts, other equipment)","Excavation, Masonry, Concrete Work, Road/Track/Canal Work","Outsourced Labor","Relocation of Machines & Assembly Lines"]
["Iowa","(IA)","Iowa (IA)","(IA)",null,null,null,null,null,null,null,null,null,null,null,"Metal Forming","Medical Equipment & Medicine Articles","Measuring Devices",null,"Facility Maintenance Services","Personell Services","Sea Transport"]
["Kansas","(KS)","Kansas (KS)","(KS)",null,null,null,null,null,null,null,null,null,null,null,"Noise & Vibration Testing - NVH","Metal Pallets, Racks & Boxes","Measuring Fixtures",null,"Fire Protection","R&D Electronics","Sorting"]
["Kentucky","(KY)","Kentucky (KY)","(KY)",null,null,null,null,null,null,null,null,null,null,null,"Post Process Measuring","Office Furniture","Measuring Machines",null,"Forklifts","R&D Mechanical","Special / heavy Transport "]
["Louisiana","(LA)","Louisiana (LA)","(LA)",null,null,null,null,null,null,null,null,null,null,null,"Rapid Prototyping","Office Material","Measuring Tools (Meters; Switches)",null,"Hazardous Waste","R&D Planing & PM","Warehousing"]
["Maine","(ME)","Maine (ME)","(ME)",null,null,null,null,null,null,null,null,null,null,null,"Robots","Oils & Lubricants","Milling Tools",null,"Heating, Ventilation, Air-condition, Sanitation","R&D Testing/Inspection"]
["Maryland","(MD)","Maryland (MD)","(MD)",null,null,null,null,null,null,null,null,null,null,null,"Separation","Packaging Aids (Tapes, Dunnage, Labels)","Rotationally Symmetrical  Workpiece Clambing",null,"Infrastructure Installations (Compressed Air / Central Units)","Rail/Ship "]
["Massachusetts","(MA)","Massachusetts (MA)","(MA)",null,null,null,null,null,null,null,null,null,null,null,"Seperation Processes","Plastic Pallets & Boxes","Shopfloor Related Fixtures",null,"IT-Services","Recruiting "]
["Michigan","(MI)","Michigan (MI)","(MI)",null,null,null,null,null,null,null,null,null,null,null,"Shaking Units / Vibration Units","Plastic Trays & Deep-drawn Parts","Stamping & Forming Tools",null,"Land & Building Purchase","Relocation"]
["Minnesota","(MN)","Minnesota (MN)","(MN)",null,null,null,null,null,null,null,null,null,null,null,"Software - Special Test Application","Powertools (electr., aircompr.)","Steady State Workpiece Clambing",null,"Landscaping / Winter Services","Sorting Services"]
["Mississippi","(MS)","Mississippi (MS)","(MS)",null,null,null,null,null,null,null,null,null,null,null,"Surface Treatment Equipment","Semi finished Materials (Iron, Steel, non ferrous Metals, Plastics)","Thread Tools",null,"Long-distance Heating","Temp Workers"]
["Missouri","(MO)","Missouri (MO)","(MO)",null,null,null,null,null,null,null,null,null,null,null,"Test - None Destructive / Crack Detection ","Shoes","Tool Holders",null,"Media Technology & Production-related Hardware","Training"]
["Montana","(MT)","Montana (MT)","(MT)",null,null,null,null,null,null,null,null,null,null,null,"Test Machine, Test System - Components","Soldering-/Weldingtools & Accessories","Toolmanagement",null,"Moving offices","Translation"]
["Nebraska","(NE)","Nebraska (NE)","(NE)",null,null,null,null,null,null,null,null,null,null,null,"Test Machine, Test System","Spares for Buildings & Furniture (small parts)","Turning Tools",null,"Natural Gas","Travel Management"]
["Nevada","(NV)","Nevada (NV)","(NV)",null,null,null,null,null,null,null,null,null,null,null,"Test Rigs","Surface Treatment Chemicals","Wire Baskets & Heat Resistant Fixtures",null,"Non hazardous waste"]
["New Hampshire","(NH)","New Hampshire (NH)","(NH)",null,null,null,null,null,null,null,null,null,null,null,"Warehouse Systems","Technical Gases",null,null,"Other Building Services"]
["New Jersey","(NJ)","New Jersey (NJ)","(NJ)",null,null,null,null,null,null,null,null,null,null,null,"Washing","VCI, Plastic Bags & Foils",null,null,"Power Plant"]
["New Mexico","(NM)","New Mexico (NM)","(NM)",null,null,null,null,null,null,null,null,null,null,null,"Welding","Wooden Pallets, Boxes & Parts",null,null,"Real Estate Services"]
["New York","(NY)","New York (NY)","(NY)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scrap Revenues / Recyclables"]
["North Carolina","(NC)","North Carolina (NC)","(NC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Security"]
["North Dakota","(ND)","North Dakota (ND)","(ND)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Software"]
["Ohio","(OH)","Ohio (OH)","(OH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stream Water"]
["Oklahoma","(OK)","Oklahoma (OK)","(OK)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telecommunications & Network Components"]
["Oregon","(OR)","Oregon (OR)","(OR)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Turnkey Construction Work"]
["Pennsylvania","(PA)","Pennsylvania (PA)","(PA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waste Management Services (Inhouse)"]
["Rhode Island","(RI)","Rhode Island (RI)","(RI)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Windows, Doors, Gates, Staircases, Steel/Metal Construction, Fence Systems, Scaffolding"]
["South Carolina","(SC)","South Carolina (SC)","(SC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Workplace Equipment & Data Center Hardware"]
["South Dakota","(SD)","South Dakota (SD)","(SD)"]
["Tennessee","(TN)","Tennessee (TN)","(TN)"]
["Texas","(TX)","Texas (TX)","(TX)"]
["Utah","(UT)","Utah (UT)","(UT)"]
["Vermont","(VT)","Vermont (VT)","(VT)"]
["Virginia","(VA)","Virginia (VA)","(VA)"]
["Washington","(WA)","Washington (WA)","(WA)"]
["West Virginia","(WV)","West Virginia (WV)","(WV)"]
["Wisconsin","(WI)","Wisconsin (WI)","(WI)"]
["Wyoming","(WY)","Wyoming (WY)","(WY)"]

{"sheet":"Extract","index":2,"n_rows":2,"n_cols":110,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"TRANSPOSE('Diverse Supplier Profile'!B10:C118)","v":"Date"},0,"COMPANY INFORMATION","Company Name*","DUNS Number* ","Address 1*","Address 2","City*","State (select)*","Zip*","Country*","Phone*"," Website URL","Year Established*","Federal Tax ID/ VAT ","NAICS Code*","Total Annual Sales (in USD)*","Number of Employees*","Have you supplied to thyssenkrupp in the past?*","If yes, provide thyssenkrupp supplier ID","Quality Certifications",0,0,0,"COMPANY STRUCTURE","If your company is a Division or subsidiary of a parent company --                                                                                                                                                                    provide the following information for the parent company","DUNS Number","Parent Company Name","City","State","Zip","Country",0,"LOCATIONS OUTSIDE OF THE US (Mark an \"x\" where applicable)","Operations outside of USA that can provide product/service to USA","Mexico","Canada","China","Europe","None",0,"OFFICERS AND CONTACT INFORMATION","Owner/ Executive’s Name ","Job Title","First Name","Last Name","Email Address","Phone"," ","Primary /Sales Contact","Job Title","First Name","Last Name","Email Address","Phone",0,"Diverse Classification (Mark an \"x\" where applicable)*  ","Minority-Owned Business (MBE)","Women-Owned Business (WBE)","Veteran-Owned Business (VET)","Small Business Class (select from list)","Lesbian, Gay, Bi-Sexual, Transgender (LGBT)","Other Certification(s)",0,"Ethnicity (Mark an \"x\" where applicable)","·         African American","·         Asian-Indian American","·         Asian-Pacific American","·         Hispanic","·         Native American",0,"CERTIFIED BY: (Mark an \"x\" where applicable & attach each certificate with your submission)*","CAMSC","NMSDC or Regional affiliate","WEConnect International ","WBENC","NVBDC ","8(a) Business Enterprise","SBA","Other"," ","Certificate ID number*"," Expiration Date*","Certificate ID number 2"," Expiration Date 2",0,0,"PRODUCT AND SERVICES (Please make a selection from the dropdowns)",0,"NONPRODUCTION MATERIAL (Select from List)","Corporate Commodity","Subcommodity",0,"PRODUCTION MATERIAL (Select from List)","Corporate Commodity","Subcommodity",0,"KEY CUSTOMERS","List top (3) customers","Customer 1","Customer 2","Customer 3","Are any automotive? (Yes or No)*",0,"MISC INFORMATION","Significant awards / recognition your company received? ","How did you hear about the thyssenkrupp Supplier Diversity Program?",0,"Brief Comments/ capabilities attachments: (Lines spaces/area for comments and attachments if desired)",{"$error":"#N/A"}]
["2020-02-10",0,0,0,0,0,0,0,0,0,"USA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"00:00:00",0,"00:00:00",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"}]