{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["supplier_approval","document status","dropdown","instructions"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":23,"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":"supplier_approval","index":0,"n_rows":110,"n_cols":7,"rows_kept":110,"cut":false,"hidden":false,"merged":[[106,3,106,4],[55,0,55,4],[60,0,60,4],[99,0,101,1],[107,0,109,1],[103,0,103,4],[87,0,89,1],[90,0,92,1],[93,0,95,1],[96,0,98,1],[105,0,106,1],[80,0,80,4],[82,2,83,4],[82,0,83,1],[67,0,69,1],[68,2,68,3],[44,0,44,4],[46,0,46,4],[33,0,34,1],[1,0,1,4],[9,2,10,4],[11,2,12,4],[5,0,6,1],[7,0,8,1],[9,0,10,1],[11,0,12,1],[3,0,3,4],[5,2,6,4],[7,2,8,4],[42,2,43,4],[40,0,40,1],[13,0,14,1],[13,2,14,4],[26,2,27,4],[28,2,29,4],[22,0,23,1],[22,2,23,4],[24,0,25,1],[28,0,29,1],[26,0,27,1],[15,0,16,1],[17,0,18,1],[20,0,21,1],[31,2,32,4],[35,0,36,1],[42,0,43,1],[58,0,58,4],[49,0,49,1],[49,2,49,3],[48,0,48,1],[48,2,48,3],[48,4,48,5],[54,0,54,1],[52,0,52,4],[57,2,57,3],[57,4,57,5],[50,0,50,4],[37,0,38,1],[31,0,32,1],[69,3,69,4],[75,2,75,3],[77,2,77,3],[72,3,72,4],[73,0,77,1],[70,0,72,1],[71,2,71,3],[66,3,66,4],[63,3,63,4],[61,0,63,1],[64,0,66,1],[62,2,62,3],[65,2,65,3],[105,2,105,3],[74,3,74,4],[76,3,76,4],[0,3,0,4],[37,2,38,4],[35,2,36,4],[33,2,34,4],[17,2,18,4],[15,2,16,4],[20,2,21,4],[24,2,25,4],[84,2,85,4],[78,0,78,4],[84,0,85,1],[56,0,56,2],[57,0,57,1]]}
[null,null,null,"\nSupplier Approval \nLieferantenfreigabe"]
[]
[]
["Supplier Information",null,null,null,"0"]
[]
["Company Name\nUnternehmensbezeichnung"]
[]
["Address\nAdresse"]
[]
["Country\nLand"]
[]
["Contact Person\nKontaktperson"]
[]
["Email\nE-Mail"]
[]
["Phone\nTelefon"]
[]
["Mobile\nMobil"]
[]
[]
["Supplier Classification\nLieferantenklassifizierung",null," "]
[]
["Planned Supplier Status\nGeplanter Lieferantenstatus",null,""]
[]
["Commodity\nHauptwarengruppe",null,""]
[]
["Sub Commodity\nUnterwarengruppe"]
[]
["Spend per year (Plan)\nUmsatz pro Jahr (Plan)"]
[]
[]
["Payment terms\nZahlungsbedingungen"]
[]
["Delivery terms\nLieferbedingungen",null,null,null,null,null,5]
[]
["Financials (Rating)*\nFinanzen (Rating)",null,"Green"]
[]
["Q Rating of deliveries\nQ Rating der Lieferungen",null,""]
[]
[]
["*Please enter your own assessment\n  Bitte eigene Einschätzung eintragen"]
[]
["Reason for acceptance in  supplier pool\nGrund für die Aufnahme in den Lieferantenpool"]
[]
[]
[]
["Supplier Information",null,null,null,"0"]
[]
["\n          Geheimhaltungsvereinbarung",null,"\n           Lieferanten-Selbstauskunft",null,"\n         Verhaltenskodex"]
["\n          Lieferanten-Unterlagen",null,"\nFinanzielles Rating"]
["Please enclose all requested documents\nBitte alle erforderlichen Unterlagen beifügen"]
[]
["Details of Quality "]
[]
["Certificates**\nZertifikate"]
[]
["Quality risk release (to be filled by Q)\nQualitäts-Risikofreigabe (von Q zu befüllen)"]
["\n         Freigegeben",null,"      \n        Bedingt freigegeben (Handlung s. unten)",null,"\n         Nicht freigegeben"]
["**Please enclose all requested documents\nBitte alle erforderlichen Unterlagen beifügen"]
[]
["Planned / realized steps on quality:\nGeplante / umgesetzte Schritte zum Thema Qualität (Planungsdaten):\n"]
["Audit\nAudit"]
[null,null,"if yes, target / implementation date \nwenn ja, geplanter / umgesetzter Termin"]
[null,null,"if no, reason\nwenn nein, Grund"]
["Qualification Plan\nQualifizierungsplan"]
[null,null,"if yes, target / implementation date \nwenn ja, geplanter / umgesetzter Termin"]
[null,null,"if no, reason\nwenn nein, Grund"]
["Quality Assurance Agreement\nQualitätssicherungsvereinbarung"]
[null,null,"if yes, target / implementation date \nwenn ja, geplanter / umgesetzter Termin"]
[null,null,"if no, reason\nwenn nein, Grund"]
["Framework Agreement\nRahmenvertrag"]
[null,null,"if yes, target / implementation date \nwenn ja, geplanter / umgesetzter Termin"]
[null,null,"if no, reason\nwenn nein, Grund"]
["Additional Agreements\nZusätzliche Vereinbarungen"]
[null,null,"1.)"]
[null,null,"if yes, target / implementation date \nwenn ja, geplanter / umgesetzter Termin"]
[null,null,"2.)"]
[null,null,"if yes, target / implementation date \nwenn ja, geplanter / umgesetzter Termin"]
[]
[]
["Applicants"]
[]
["Applicant\nAntragsteller",null,""]
[]
["Address\nAdresse",null,{"$f":"IF(C83=\"\",\"\",\"  \"&VLOOKUP(C83,dropdown!F:H,2,FALSE))","v":""}]
[]
[]
["Lead Buyer\nStrategischer Einkäufer",null,"_____________","__________________","________________"]
[null,null,"Date","Name","Signature"]
[null,null,"Datum","Name","Unterschrift"]
["Supplier Quality\nLieferantenqualität",null,"_____________","__________________","________________"]
[null,null,"Date","Name","Signature"]
[null,null,"Datum","Name","Unterschrift"]
["Head of Procurement\nEinkaufsleiter Group Company",null,"_____________","__________________","________________"]
[null,null,"Date","Name","Signature"]
[null,null,"Datum","Name","Unterschrift"]
[null,null,"_____________","__________________","________________"]
[null,null,"Date","Name","Signature"]
[null,null,"Datum","Name","Unterschrift"]
[null,null,"_____________","__________________","________________"]
[null,null,"Date","Name","Signature"]
[null,null,"Datum","Name","Unterschrift"]
[]
["Uhlmann Corporate Procurement "]
[]
["Approval",null,"if yes, Supplier Approval no.\nwenn ja, Lieferantenfreigabe-Nr."]
[null,null,"if no, reason for refusal\nwenn nein, Ablehnungsgrund"]
["Global Category Manager\nGlobaler Warengruppenmanager",null,"_____________","__________________","________________"]
[null,null,"Date","Name","Signature"]
[null,null,"Datum","Name","Unterschrift"]

{"sheet":"document status","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"\nSupplier Approval \nLieferantenfreigabe"]
[]
["Date","Comment","Doc status","Autor"]
["2020-07-01","create Supplier Approval sheet","A","Ms. Pracht"]
["2020-07-14","update Supplier Approval sheet","B","Ms. Pracht"]
["2020-07-22","Implement Documentstatus für Supplier Approval","C","Mr. Oelmaier"]
["2020-09-08","update Supplier Approval sheet","D","Ms. Pracht"]
["2020-09-22","update Supplier Approval sheet","E","Ms. Pracht"]
["2021-01-21","update Supplier Approval sheet (payment and delivery terms)","F","Ms. Pracht"]
["2021-06-21","update Supplier Approval sheet (supplier classification)","G","Ms. Pracht"]
["2022-02-09","update Supplier Approval sheet (formatting adjusted)","H","Ms. Pracht"]
["2022-04-28","update Supplier Approval sheet (integration non production commodity codes)","I","Ms. Pracht"]

{"sheet":"dropdown","index":2,"n_rows":87,"n_cols":9,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
["Commodity:"]
[]
[null,"Dropdown Auswahl"]
["commodity 1","commodity 2","supplier for","supplier status","commodity 1","Companies","Company adress",null,"Financials"]
["Electrics","Electrics"," ","Global for Local Supplier","Electric Components","Uhlmann Pac-Systeme GmbH & Co. KG","Uhlmannstraße 14-18, 88471 Laupheim, Germany",1,"Red"]
["Machines_and_Systems","Electrical components","  1 - Machines and Accessory Equipment","Regional for Local Supplier","Machines and Systems","Koch Pac-Systeme GmbH & Co. KG","Dieselstraße 13, 72285 Pfalzgrafenweiler, Germany",2,"Yellow"]
["Mechanical_parts","Motors and Motor components","  2 - OEM (Original Equipment Manufacturer) ","Local for Local Supplier","Mechanical Parts","Cremer Speciaalmachines B.V.","Heereweg 5A, 2161 AB Lisse, Netherlands",3,"Green"]
["Engineered_components",null,"  3 - Electrical Parts / Components",null,"Enginereed Components","Jinzhou Wonder Packing Machinery Co., Ltd.","No.44 Zhongxin Rd, Taihe District, 121011 Jinzhou, China"]
["Fasteners","Machines and Systems","  4 - Drawing Parts",null,"Fasteners","Axito sp. z o.o.","Logistyczna 8, 55-040 Bielany Wroclawskie, Poland"]
["Software_Production_material","Machines","  5 - Standard Parts / Catalogue Parts",null,"Software","Axito GmbH","Uhlmannstraße 14-18, 88471 Laupheim, Germany"]
["Consulting","Systems","  6 - Others"]
["Facility_Management",null,"  7 - Surface Coating Product Touching Parts"]
["Freights_Logistics","Mechanical parts","  8 - Other Surface Coatings (Hardening, Eloxal, Chemical Nickel Plating)"]
["HR_Social_Services","Assemblies","  9 - Simple Services (Deburring, Drilling, etc.)"]
["IT","Drawing parts","10 - Indirect Supplier"]
["Marketing","Raw material"]
["Operations_Management","Surface"]
["Travel_Fleet_Management"]
[null,"Engineered components"]
[null,"Chains"]
[null,"Gears"]
[null,"Linear technology"]
[null,"Pneumatics"]
[null,"Tooth belt, Flat belts, Tapes, Belts"]
[null,"Vibrators, Vibratory conveyor technology"]
[null,"Hydraulics"]
["Q Rating","Fasteners"]
["Critical to Quality","Bearings, Shafts"]
["Non Critical to Quality","Brushes"]
["Direct product touching","Cable duct"]
["Indirect product touching","Couplings"]
[null,"Fittings, Locks, Hinges"]
["Delivery terms","Operating elements, Standard parts, Machine feet, Rolls"]
["To be defined","Screw, Nut, Washer, Bolt"]
["DAP = Delivery At Place (preferred Uhlmann Group)","Sealing technology"]
["DDP = Delivered Duty Paid","Signs"]
["CPT = Carriage Paid to","Springs"]
["CIP = Carriage, Insurance Paid to","Suction cups, Magnets"]
["FCA = Free Carrier","Transmission elements, Brakes"]
[null,"Tubes, Filters, Compensators"]
["Payment terms","Software_Production_material"]
["To be defined","License"]
["90 days net (preferred Uhlmann Group)","Software Services"]
["75 days net (preferred Uhlmann Group)","Consulting"]
["60 days net (preferred Uhlmann Group)","Accounting and Tax Audit"]
["45 days net","Insurance Services"]
["30 days net","IT Consulting"]
[null,"Law Consulting"]
["Certifications:","Marketing Consulting"]
[null,"Organisation Consulting"]
["ISO 9001","Patent and Fees"]
["ISO 14001","Personnel Consulting"]
["ISO 45001","Facility Management"]
["ISO 50001","Buildings"]
["ISO 27001","Energy"]
["ISO 13485","Office Equipment"]
["IATF 16949","Freights & Logistics"]
["ISO 15378","Transport Inbound"]
[null,"Transport Outbound"]
[null,"HR & Social Services"]
[null,"Social Services"]
[null,"Temporary Employment"]
[null,"Training"]
[null,"IT"]
[null,"IT Requirements"]
[null,"Communication"]
[null,"Marketing"]
[null,"Fair"]
[null,"Gifts"]
[null,"Printed Media"]
[null,"Advertisement"]
[null,"Marketing Services"]
[null,"Operations Management"]
[null,"Distribution and Packaging Materials"]
[null,"Investments"]
[null,"Maintenance and Service"]
[null,"Measuring Equipment"]
[null,"Operating Supplies"]
[null,"Sale of Surplus Goods"]
[null,"Services"]
[null,"Services Construction"]
[null,"Test Run Material"]
[null,"Tools"]
[null,"Validation and Documentation"]
[null,"Travel & Fleet Management"]
[null,"Travel Management"]
[null,"Vehicle Fleet"]

{"sheet":"instructions","index":3,"n_rows":144,"n_cols":6,"rows_kept":144,"cut":false,"hidden":true,"merged":[]}
["Erläuterung Dropdown"]
[]
["Separates Tabellenblatt erzeugen und Abhängigkeiten darstellen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Mit Hilfe des Namensmanagers die Felder in Spalte B jeweils benennen wie die Zeilen unter Commodity 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["WICHTIG:"]
["Die Überschriften unter \"commodity 1\" müssen genau so lauten, wie der Name im Namensmanager hinterlegt ist (z.B. mit \"_\" anstatt Leerzeichen)!!!"]
["(nur so können die Abhängigkeiten nachher zwischen Commodity und Subcommodity funktionieren)"]
[]
["Erstellung Dropdown Feld über Entwicklertools:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Anforderung zur Abhängigkeit:"]
["Wenn im Feld Commodity X steht soll im Feld Sub Commodity X1, X2, X… ausgewählt werden können und wenn im Fehld Commodity Y steht soll im Feld Sub Commodity Y1, Y2, Y…ausgewählt werden können usw."]
[]
[]
[]
[]
[]
["Formel im Namensmanager:"]
["=INDIREKT(INDEX(commodity1;supplier_approval!$G$24;1))"]
[]
["Hinweis: G24 bezieht sich auf eine Stelle in der Supplier Approval"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["WICHTIG:"]
["Nur wenn die Bezeichnung der Commodity 1 Überschriften mit denen der Überschriften von Commodity 2 und im Namensmanager übereinstimmen funktioniert die Abhängigkeit im Dropdown!!!"]
[]
["Beispiel:"]
[]
[]
[]
[]
[]
[]
["Entwicklertools – Entwurfsmodus – Eigenschaften:"]
[]
["ComboBox Commodity 1:",null,null,null,null,"ComboBox Commodity 2:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zusätzliche Infos:"]
["VBA-Programmierung:"]