Agilent Technologies Compliance Connect Spreadsheet User Guide
Contents
1. materials with the same Material Name Trade name use this field to differentiate them RSRC Material Select N A from the drop down list Required Sesgraton enc gata s rotregurea artiste IMDS Material This is the IMDS material symbol Consult Optional Symbol applicable standards for naming guidelines e g ISO 1043 1 for plastics Material Select the applicable material Required Classification classification from the drop down list See Table 6 for available options Applicable OEM Enter N A not required by Agilent Required or Requestor Technologies Specifications Applicable Enter N A not required by Agilent Required Industry Technologies Specifications Pre Consumer Report the of the material weight that Required Recyclate originated from scrap from some manufacturing process Do not include regrind An example of pre consumer recyclate is metal shavings generated during manufacturing that are then melted and used to produce other parts Page 21 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 5 Materials Tab Fields and Definitions continued Required Optional Post Consumer Report the of Post Consumer Recyclate Required Recyclate contained in the material Post consumer recycled material come from products that have served their intended uses by consumers and have been diverted from the waste stream e g plastic soda bo2. such as paint adhesives or change Unit lubricants where the Measured Part Weight Amount is a function of length area or volume and then set this appropriately per length area or volume unit Computed Part Computed based on the sum of the Derived Weight Amount weights of the saleable part s Informational Only components Compare to the Measured Part Weight Amount value for accuracy NOTE value is computed in kg when Measured Part Weight Amount Measured Part Weight Unit Measured Part Weight per Length Area Volume Unit information is not provided Table 4a Part Tree Tab Sub Part level 2 through level 30 Fields continued Not required for rolled up BOM Required Optional Your Part Number n Your unique part number for the sub Required where n sub part part level 2 or greater Your Part Revision Your revision level for the sub part Required Level n where n Enter N A if you do not use separate sub part level 2 or Revision Levels to track parts greater Your Part Revision The effective date of your revision level Required Date n where n for the sub part The date format is dd sub part level 2 or mmm yyy e g 06 Jan 2007 Enter greater N A if you do not use Revision Dates to track parts Page 15 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 Your Part Name n where n sub part level 2 or greater RSRC Recyclability Catego
3. what directory are they in A11 agmcc export files will be located in the default directory C Program Files Agilent_RoHS or in the directory location you chose during the install of Agilent_RoHS Agilent Compliance Connect Spreadsheet Q12 What is the difference between the bold headings and the non bold headings in the Agilent TM Compliance Connect spreadsheet A12 The bold headings are columns that require data input in order to pass the data validation checks Many of the required columns will allow input of N A if the required data does not apply to the product you supply Agilent Technologies Input of data in the non bold headings is not required to pass the data validation checks or by Agilent Technologies Q13 Why are there grayed out rows on the Part Tree and Part Detail tabs A13 Information input into Part Tree and Part Detail tabs is to be staggered Data for subparts should begin one row below its parent assembly Likewise substance information begins one row below the material it comprises The gray fields indicate cells that should remain blank in order to maintain proper data structure
4. your submittal being considered incomplete and thereby rejected The sum of the substance concentrations reported for each material must equal 100 or 1 million parts per million Page 19 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Alloy composition substance content post industrial and post consumer recycled content should be verified with the material supplier Click the Overall Help button on the Materials tab for detailed instructions Use the Check Materials Data button to verify that all required information has been entered correctly Page 20 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 5 Materials Tab Fields and Definitions Column Name Required Optional Material Name The common industry name for the Required material Consult applicable standards for naming guidelines e g ISO 1043 1 for plastics Trade Name The material trade name usually based Optional Required if on who supplied the material Also known Raw Material as commercial name If you have multiple Submission materials with the same Material Name Manufacturer use this field to differentiate them Material The name of the manufacturer of the Optional Required if Manufacturer material Select the manufacturer s name Raw Material Name from the supplied list or enter it manually Submission if not in the list If you have multiple
5. Revision Date the part with format dd mmm yyyy Enter N A if you do not use Revision Dates to track parts Your Enter a comma separated list of the names Optional Fabrication of your plants where this part is fabricated Plant You must enclose each plant in quotes e g plant 1 plant 2 Measured The measured weight of the saleable part Required Part Weight This is the finished net weight without Amount packaging Measured Select which unit of measure is to be Required This Field is Part Weight applied to the measured weight in the Locked to prevent Unit previous column g kg or Ib change Page 17 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 4b Partial Declaration Tab Fields and Definitions Required Optional Measured Part If this is a saleable discrete part then Required This Field Weight per set this to each If this is a saleable is Locked to prevent length area volume bulk item such as paint adhesives change Unit or lubricants where the Measured Part Weight Amount is a function of length area or volume and then set this appropriately per length area or volume unit RoHS Declaration Select the EU RoHS Status for each Required part being reported per the EU RoHS Definition see annotation above this column for further information on the EU RoHS Definition Page 18 of 28 Agilent Technologies Compliance
6. one row for each material Select from available materials previously entered in the Materials tab Page 25 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 7 Part Detail Tab Fields and Definitions continued Required Optional Trade Name The material trade name usually Derived based on who supplies the material Also known as commercial name Auto populated Material Manufacturer Name The name of the material Derived manufacturer Auto populated Material Weight Amount Weight of the material in comprising Required the part for bulk materials e g sealers and adhesives estimate the average mass of the material applied per part Select from pull down menu Material Weight Unit The weight units used to specify the Required material weight in the previous column Select from pull down menu Material Weight per This column is a reminder of the Derived Length Area Volume Unit weight per attribute for the material Informational Only It is the same as the Part Weight per Length Area Volume Unit for the part when Material Weight Unit is not Step 7 Add Any Substances of Concern Add any substances of concern detail required Step 8 Certify and Export Click the Certify and Export button on the Substance of Concern Detail tab to 1 perform final validation checks 2 certify the contents of the spreadsheet and 3 expo
7. served their intended end uses and have been recovered from or otherwise diverted from the consumer waste stream for the purpose of recycling An example is recycled beverage containers that are sources of material for auto parts RSRC The Regulated Substance and Recyclability Certification System An Internet accessible program developed and used by DaimlerChrysler Corporation for collection of supplier part material and substance of concern data Saleable part The final as shipped part supplied to Agilent Technologies Specific Gravity The ratio of the density of a material g cm to the density of water 1 0 g mL Page 27 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Frequently Asked Questions Q1 A1 Q2 A2 Q3 A3 Q4 A4 Q5 A5 Q6 AG Q7 A7 Reporting Requirements Who do contact for technical support Refer to the Agilent Technologies Email for contact information Do need to include packaging materials in my report Do not include the packaging materials used for transporting your parts to Agilent Technologies or its designated manufacturing location Agilent Technologies does require materials Declaration for all packaging sourced for use in transporting Agilent Technologies products to its customers Is it possible to copy parts from one location to another Yes Data contained in part or material records can be copied withi
8. unalloyed or low alloyed Elastomers elastomeric compounds 2 Steels igh aloyed pra pry 2 1 Cast iron with lamellar graphite 5 4 2 Unsaturated polyester 1 2 2 Cast iron with nodular graphite vermicular cast iron Highly alloyed cast ron A Aluminum and aluminum alloys 7 Cast aluminum alloys k k MI N gt 2 3 D N gt pra aard po N Po Pp pl Magnesium and magnesium alloys 2 1 Cast magnesium alloys 7 1 Modified organic natural materials e g leather wood cardboard c inings i Wrought aluminum alloys Adhesives sealants M M M M 2 2 Wrought magnesium alloys Ceramics glass Titanium and titanium alloys Other compounds e g friction linings 3 1 Copper e g copper amounts in 8 1 Electronics e g pc boards displays cable harnesses Erecrics Refrigerant Tnemoplasics o6 Washing water battery acids a Filled Thermoplastics Preservative b Unfilled Thermoplastics 9 8 Other fuels and auxiliary means M oo wj oo Ph wj oo oy gt A ALA ho uo oy o oe a oa au Page 23 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Step 6 Complete the Part Detail tab Full Declarations The Part Detail tab requires suppliers to correlate the material type with each bottom level part or saleable part if reporting rolled up data The Compliance Connect spreadsheet iden
9. Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Step 5 Complete the Materials tab Full Declarations The Materials tab requires suppliers to create and define material records of fabrication used in each bottom level part as defined on the Part Tree tab or for each saleable part if reporting data in a rolled up format Material records identified or created during Step 5 will be matched up with the corresponding bottom level part during Step 6 Part Detail tab To create a new material type enter the attributes described in Table 5 for each material including the name and concentration of substances present Substances are selected from an extensive list Enter each substance contained within the material on a separate line beneath the grayed out cells for that material Use Misc to report proprietary information or in place of specific substances which may not be included in the available list The specific substance must be reported in all cases when it is classified as Banned Controlled or Reportable and exceed the reporting thresholds When reporting Misc as greater than 10 of the material content include a comment in the Remarks field that the actual substance is either proprietary or that it is not available in the pull down menu If the later include the CAS for the substance missing from the list in your comment Failure to follow this requirement will result in
10. Page 1 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Material Declaration TM Agilent Compliance Connect User Guide Agilent Technologies Controlled and Reportable Materials Declaration TM Compliance Connect User Guide Table of Contents OVETVIEW Joere aeee ieee eee a aA e EE a E aE a aE EA EAOa EREA 2 Software Requirements i 35 2ivandedecccezszeanccedecseceys sed ncaeecedaegavecdesatectedequsszdecaeeaenaegacsadec seanecngncdte ecayecabdegeesecoueste 3 Software License Terns resisite aae E ENRE 3 Technical SUD DOME vr ecsctesedneocs tecaeceshcatehnsteceeee deee Eee EE E aeee EEEa EEEE Ea aee EEEE EAEE aeaee TOE EAEE EE AEE 4 Reporting Part Material and Substance INfOrmatiOn ccccccccsssssssecececessesesseaeceeccesseseneseeeeecessessaeaeeseeens 4 Table 1 Data Reporting Structure Complete BOM cc cccccccscsssessssececeeecessesseaececeesseeseneaeeeeeeeseesees 5 Table 2 Data Reporting Structure Rolled Up BOM cc sccccccscsssssecseceeeeecessesseaececeesceeseseaeeeeeeseeesees 6 Proc ss Flow Dia Bi atu izes ies ccecc ces 5ese5 a EE evenness tees eau es tanec toss recs aan hoes tenes dass eee sae 7 Step 1 Download the Agilent Compliance nee a Spreads hetare eevee aeacdess eaten 8 Step 2 Import the Pr e Populate til es peeecacceveesnreectecatdc cau sesteectcacecussesseantadakec lt aessibensaedceectees Meaetadaneeevoe Rak 9 Step 3 Complete the General Info
11. alidation temporarily to facilitate the paste step of the process click this red button once to turn off again to turn on If reporting rolled up data as explained in the Reporting Part material and substance section on page 4 complete the Saleable Part fields for each end item part check data then proceed to Step 5 Click the Overall Help button on the Part Tree tab for detailed instructions Use the Check Part Tree Data button to verify that all required information has been entered and in the proper format Correct and check data input until it passes the data check Page 13 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 4a Part Tree Tab Fields and Definitions Saleable Part Fields Required Optional Requestor Part The Agilent Technologies part number Required Do Not Number Change Requestor Part This column designates the revision level Required Do Not Revision Level or revision number of the part Enter the Change revision indicator that Agilent Technologies uses Enter N A if Agilent Technologies does not use Revision Level to track parts Requestor Part This is the effective date of the part Required Do Not Revision Date revision for Agilent Technologies e g Change drawing ECN The date format is dd mmm yyyy e g 06 Jan 2007 Enter N A if Agilent Technologies does not use Revision Date to track
12. ce to turn off again to turn on Click the Overall Help button on the Partial Declaration tab for detailed instructions Use the Check Partial Declaration Data button to verify that all required information has been entered and in the proper format Correct and check data input until it passes the data check Page 16 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 4b Partial Declaration Tab Fields and Definitions Column Description Required Optional a Requestor The Agilent Technologies part number Required Do Not Requestor This column designates the revision level or Required Do Not Part Revision revision number of the part Enter the Change Level revision indicator that Agilent Technologies uses Enter N A if Agilent Technologies does not use Revision Level to track parts Requestor This is the effective date of the part revision Required Do Not Part Revision for Agilent Technologies e g drawing Change Date ECN The date format is dd mmm yyyy e g 06 Jan 2007 Enter N A if Agilent Technologies does not use Revision Date to track parts This is the descriptive name for the part You Your Your unique part number Required Bia Your Part Your revision level for the part Enter N A Required Revision if you do not use Revision Levels to track Level parts Your Part The effective date of your revision level for Required
13. ct only in connection with collecting and reporting Agilent data Any other use or modification requires a separate license Page 4 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Technical Support For questions and assistance in completing the Compliance Connect spreadsheet please contact Agilent Technologies via the appropriate email address listed on the Agilent Technologies request form In addition to technical support questions please notify your Agilent Technologies contact to update contact information address questions regarding part status or inform that you may not meet the established deadline Communication is crucial to the data collection process Reporting Part Material and Substance Information There are five data entry tabs General Information Part Tree or Partial Declaration Material Part Detail Substance of Concern in the Agilent Compliance Connect spreadsheet Partial Material Declarations only utilize three of these tabs General Information Partial Declaration and Substance of Concern rather than the full five tabs for full declarations An overview of the fields requested on each of the five tabs along with a definition and indication whether data input is optional or required is provided in Tables 3 4 5 and 7 Data must be provided in the proper format for each of the required fields at a minimum identified as bold column headings throughout th
14. e contact Optional Page 11 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Supplier Contact The address of the contact Optional Mit Supplier Contact The address line 2 of the contact Optional City Supplier Contact The state province of the contact Optional Supplier Contact The zip postal code of the contact Optional Supplier Contact The country of the contact Optional eauny ns omnrwenes Page 12 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Step 4a Complete the Part Tree tab Full Material Declarations only This tab requires suppliers to define the part structure for the saleable part s supplied to Agilent Technologies showing the parts at each assembly level within the BOM Begin by entering your top level part assembly level 01 information in the Saleable Part fields If the part is not an assembly proceed to Step 5 If the part is an assembly provide the complete BOM in the Sub Part fields to the right on the spreadsheet Assembly information should be staggered on the Part Tree tab as shown on the Part Tree Example tab Parts for each descending assembly level should begin one row beneath its parent assembly Do not input data in grayed cells within the spreadsheet If you are using a standard technique to copy and paste data from another source you may wish to turn off the Auto V
15. e spreadsheet Proper reporting using the Agilent Compliance Connect spreadsheet will require detailed knowledge of your bill of material BOM and how your parts are assembled An example of an exploded BOM and an indented BOM for a simple assembly follows Exploded BOM Washer Knob 123 2 Front123 3 Assembly Level Part Part Description 01 1234 Knob Assembly 02 123 1 Bolt 02 123 2 Washer 02 123 3 Knob Front Bolt 123 1 Washer 123 2 Knob Front 123 3 Knob 1234 Indented BOM Page 5 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 In this example the Knob Assembly is the saleable part The Knob Assembly is comprised of three subcomponents also known as leaf level parts or children Data regarding the saleable part and each of its components are reported on the Part Tree tab The Bolt Washer and Knob Front are bottom level parts as they are not comprised of additional parts The materials of composition are reported for bottom level parts on the Part Detail tab once each unique material type is defined on the Material tab Defining a material type on the Material tab includes Declaration of presence and concentration of each substance present in the material Table 1 summarizes how parts are broken down to subcomponents subcomponents to materials and materials to substances for the Knob Assembly example Note how material weights are equal to the part weights and substances eq
16. equirements TM Compliance Connect is supported for use on the following Microsoft operating systems and Excel versions as long as the latest Excel VB system files and patches are installed e Windows 2000 Excel 2000 or higher recommended e Windows 2000 Excel 97 e Windows NT Excel 97 or higher e Windows 98 Excel 97 or higher Comment on Language issues users may have to switch local settings to U S English when completing this form In Windows XP go through Start Settings Control Panel Regional and Language options and then select English United States Software License Terms TM A sublicense for use copy and distribution of Agilent Compliance Connect is granted by the AIAG under a primary license granted to AIAG by Enovia Software Corporation TM You may use copy and distribute Agilent Compliance Connect with the following restrictions 1 If you distribute this software all copies you distribute must contain all files that are in the original distribution unmodified including all copyright notices 2 You may not receive any payment or other consideration of any kind for TM distributing Agilent Compliance Connect except your actual cost of any media bearing the Software and your actual cost of shipment 3 You may not reverse engineer decompile or modify Agilent Compliance TM Connect code or any other aspect of the spreadsheet TM 4 You may use Agilent Compliance Conne
17. ltiple parts Bottom level parts are also referred to as lowest level or leaf level parts Chlorofluorocarbons CFCs Chemicals sometimes used as propellants in aerosol cans or as refrigerants Chemical Abstracts Service CAS Numbers CAS numbers are a unique identifier assigned to substances to eliminate the confusion and ambiguity of having more than one scientific or common name for a substance A known unique organic and inorganic substances have CAS Numbers Component The parts that comprise an assembly Components may be single piece parts or they may be sub assemblies IMDS The International Material Data System An automotive industry part content data collection system used by many OEMs Macros An action or set of actions you can use to automate tasks Pre Consumer Recyclate The portion of a material s weight that has been recovered from or otherwise diverted from the industrial waste stream for the purpose of recycling Pre consumer recyclate does not include home scrap Pre consumer recyclate is also referred to as rework post industrial materials and post process materials Pre consumer recyclate is material recovered from the waste stream of a manufacturing process for use in a different manufacturing process or has been recycled recovered by a third party and returned to the manufacturing process Post Consumer Recyclate The portion of a material s weight that comes from products or materials that have
18. n the same spreadsheet or to another spreadsheet Select entire rows when copying and pasting What if no longer supply the requested part to Agilent Technologies Notify the Email address on the request you received and be sure to include all part numbers in question and their circumstances TM Where do find the information required by the Compliance Connect spreadsheet Part structure quantity and other information are generally available on a bill of material Much of the required material and substance content information can be gathered from your suppliers Material Safety Data Sheets MSDS may be a source for some information however be careful to include only the constituents of the material as supplied to Agilent Technologies e g an MSDS for paint will include solvent which will evaporate from the paint during the drying curing process TM How do report a substance that is not in the look up table in Compliance Connect If a specific substance present in your part is not listed in the look up table it may be reported as Misc as long as that substance is not a Agilent Technologies Banned Controlled or Reportable substance Indicate the CAS Number for this substance in the Remarks column as instructed in Step 5 How do report proprietary material information If the identity of a specific substance present in your part is considered proprietary it may be reported as Misc as l
19. o reset your macro security options in Excel 97 select Tools then Options then the General Tab from the Excel tool bar Remove the check from the box next to Macro Virus Protection You are now ready to begin reporting Page 9 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Step 2 Import the Pre Populate file Do Not Fill the template yet This is very important Go to the Utilities tab to Import the Pre Populate file sent to you by an Agilent requestor Import the Pre Populate file by clicking the Import Tab Delimited Text File button Step 3 Complete the General Information tab Input general company and contact information for identification purposes but do not change or alter the Supplier ID and your Company Name as provided by Agilent in the Pre populate file that is imported to initialize the spreadsheet Once the fields are completed click the Check General Information Data button to verify that all required information has been entered and in the proper format Correct any identified errors then check supplier information data again before proceeding to Step 4 Page 10 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 3 General Information Tab Fields and Definitions Required Optional Requestor The name of the company requesting you Required to complete this workbook the company to whom you sell the part
20. on is available at Agilent Technologies Materials Declaration Process website referenced above Other versions of this form will not be accepted On an exception basis only Agilent Technologies may permit the use of the IPC1752 form for Declaration of material content information Please contact Agilent before using an IPC1752 form Agilent Technologies policy prescribes the use of the Compliance Connect software for collecting the material content of the parts used in its products to determine product compliance ensure appropriate end of life management and to drive a reduction in environmental impact Agilent Technologies advocates homogenous level reporting of 100 of the material content to ensure compatibility with future requirements and supports the development of industry standard reporting forms to ease supplier burden Both as a requirement for the qualification of new parts and to ascertain compliance status of legacy parts it is imperative that our suppliers respond in a timely manner and provide complete and accurate data to Materials Declaration requests from Agilent Technologies When materials are changed on a previously qualified part the suppliers must notify Agilent Technologies in advance of any changes in material content in accordance with Agilent Technologies Part Change Notification PCN process Page 3 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Software R
21. ong as that substance is not a Agilent Technologies Banned Controlled or Reportable substance Indicate that this substance is considered proprietary by your company in the Remarks column as instructed in Step 5 Page 28 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Error Messages Q8 Why aren t all of the bottom level parts in my Part Tree showing up on the Part Detail tab A8 Be certain the component structure is defined properly on the Part Tree tab Only bottom level parts those without subcomponents will appear on the Part Detail tab In addition if a bottom level part is used in multiple assemblies it must only be reported on the Part Detail tab once Q9 What do do when get an error that says that my weights do not add up to 100 A9 The sum of the weight of materials reported for each part must equal the part weight provided in the Part Weight Amount column or 100 In addition the sum of substance weights must equal 100 or be equal to the material weight Q10 I cannot generate an acmcc file What is wrong A10 There are a series of data checks that must be completed before the Compliance Connect spreadsheet will generate an agmcc file Users of the spreadsheet must utilize the Check Data button on each tab to ensure the data is correct before proceeding to the next tab Q11 I can t find the agmcc export files to send back to Agilent
22. parts This is the descriptive name for the part RSRC Select N A from the drop down list Required Recyclability RSRC data is not required at this time Category RSRC Select N A from the drop down list Required Disassembly RSRC data is not required at this time Category Your Part Your unique part number Required ime en ee Your Part Your revision level for the part Enter N A Required Revision Level if you do not use Revision Levels to track parts Your Part The effective date of your revision level for Required Revision Date the part with format dd mmm yyyy Enter N A if you do not use Revision Dates to track parts Your Enter a comma separated list of the Optional Fabrication names of your plants where this part is Plant fabricated You must enclose each plant in quotes e g plant 1 plant 2 Measured Part The measured weight of the saleable part Required This is the finished net weight without packaging Measured Part Select which unit of measure is to be Required This Field is Page 14 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 i Table 4a Part Tree Tab Fields and Definitions Saleable Part Fields continued Required Optional Measured Part If this is a saleable discrete part then Required This Field Weight per set this to each If this is a saleable is Locked to prevent length area volume bulk item
23. rived Part Weight Unit Select which unit of measure is to be applied to Required ea Part Weight per This column is a reminder of the Part Quantity Derived Length Area Volume Unit Part Weight Unit attribute for this leaf level Unit part in the Part Tree tab If this is a saleable discrete part then it will be each If this is a saleable bulk item such as paint adhesives or lubricants where the Part Weight Amount is a function of length area or volume then it will be the per length area or volume unit If the actual Part Weight was specified on the Part Tree tab then it will be weight Colored Select Y for colored parts N for parts with no Required added pigments dyes or colors ae CFCs Select Y if Chlorofluorocarbons are used in the Required manufacturing of this part otherwise select N oo Recycling Code Select all recycling code standards that apply to Required Standards this part from the list provided SAE J1344 ISO 1043 1 ISO 1043 2 ISO 1629 ISO 11469 VDS 260 Chemical Symbol Select Not Applicable if one or more of the following apply part is not recyclable too small weighs less than 50g not feasible to mark exempt from marking Select Not Marked if the part is not marked according to any of the above standards Material Name The common industry name for each material Required comprising the part The part may consist of several materials Create
24. rmation tab ccccccccccsscccesssececeessecececeseeececaeeeceessseeceeaeeeceeseeeeeees 9 Table 3 General Information Tab Fields and Definitions cccccesssccecsssneeeeseeeeeeesaeeeessaeeeeseaaes 10 Step 4a Complete the Part Tree tab Full Material Declarations only cccccccecssseceessseeeessseeees 12 Table 4a Part Tree Tab Fields and Definitions Saleable Part Fields ccssccssssecssscesstecssseeesseees 13 Table 4a Part Tree Tab Fields and Definitions Saleable Part Fields continued ccccceseeeee 14 Step 4b Complete the Partial Declaration tab Partial Material Declarations only cccceceees 15 Table 4b Partial Declaration Tab Fields and Definitions cc cccssccesssesssecessecseseecseeeseseessseeesseees 16 Step 5 Complete the Materials tab Full Declarations ccccccccccssssscecsscececsssceceeseseeeeeseseeesesssaeees 18 Table 5 Materials Tab Fields and Definitions cc cccsscccsscesssecseeecsseeecsaeesssaesseeeecsereessaeessaeesenees 20 Table 6 Material Classifications cccccccssssseceessneceeseeeceeseaaececseaaeeeceeaaecesseaaeeeeseaaeeeeseaaeeeeseaaeeeeneaaes 22 Step 6 Complete the Part Detail tab Full Declarations cccccccccssssceessssececsscceceesssceceeseseeeeessaaeees 23 Table 7 Part Detail Tab Fields and Definitions ccccccccsscesseneececseneeceeeeaeeeseeaueeee
25. rt the report file into an agmcc format and save it on your computer hard drive or network If data validation errors occur make any necessary corrections click on the Check Part Detail Data button and then click the Certify and Export button again The agmcc file is read only and cannot be edited Step 9 Submit Data to Agilent Technologies E mail the agmcc file generated during Step 6 per the instructions that came with the request from Agilent Technologies DO NOT E MAIL THE SOURCE XLS FILE Do not modify the AGMCC file name Your Agilent Technologies Compliance Connect reporting requirement is now complete Page 26 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Glossary Assembly Level Assembly levels are used to identify the location of detail components within the parts structure in a bill of materials Saleable parts are assembly level 1 The components including subassemblies comprising the saleable part are assembly level 2 and so forth Bill of material BOM A bill of material is an engineering part list that indicates the subcomponents and sometimes materials used in an assembly A bill of material will typically include the assembly level for each part indicating how the part is assembled as well as the part quantity for each subcomponent Bottom level part A part that is not an assembly that is a single piece item that is not comprised of mu
26. ry n where n sub part level 2 or greater 22 April 2009 Your descriptive name for the sub part Select N A from the drop down list RSRC data is not required at this time Table 4a Part Tree tab Sub Part level 2 through level 30 Fields continued RSRC Disassembly Category n where n sub part level 2 or greater Part Quantity Amount n where n sub part level 2 or greater Part Quantity Unit n where n sub part level 2 or greater Not required for rolled up BOM Select N A from the drop down list RSRC data is not required at this time Required Optional The amount of the sub part used in the saleable part For discrete parts enter the integer number of sub parts used For bulk items such as paint or wire this will likely not be an integer The unit of the sub part quantity For discrete parts enter each For bulk items such as paint or wire enter one of the other values Step 4b Complete the Partial Declaration tab Partial Material Declarations only This tab is automatically activated by Agilent Compliance Central if the Full Material Declaration on the General Tab is set to No Complete each of the required fields on the tab If you are using a standard technique to copy and paste data from another source you may wish to turn off the Auto Validation temporarily to facilitate the paste step of the process click this red button on
27. s detailed in this workbook Agilent Technologies Raw Material Select Y if this submission is for the Required Submission purpose of specifying raw material composition information only as opposed to an actual part Full Material Select Y for Full Chemical Composition Required Declaration Y N reporting or N for partial declaration Partial Declaration is for ROHS reporting ata homogeneous material level in yes no format based on IPC1752 Class 1 Declaration State whether the homogeneous materials meet RoHS thresholds and exemptions Supplier Code Your supplier code as recognized by Required Do Not mere Liglontecmonges ated Supplier Name Your company name as recognized by Required Do Not Supplier Type Select Internal if you are an Agilent Required Technologies plant or External if you are an Agilent Technologies supplier Supplier Contact The name of the contact at your company Required for this data submission Supplier Contact The email address of the contact Enter Required N A if you have no e mail address ise Supplier Contact The phone number of the contact Required e A Supplier Contact The fax number of the contact Required E i Supplier Contact The title of the contact Optional iw meee Supplier Contact The department of the contact Optional ee ae Supplier Contact The mail code of the contact if applicable Optional Supplier Contact The cell phone number of th
28. seaaeeeesenaeesenenaes 24 Step 7 Add Any Substances Of Concern cccccesssssssececececsesenaeaeeeeeesssesnsaeeeeeeeceseeaeseseceessssseaaeeesessseeeags 25 Step 8 Certify And Export ccccccccccsssssssececececsssesseaecececsssesesaeaeeeeeceseeseuaeeeeeesceseeeeaeeeeeessseseauaeseesesseeeaes 25 GIOSSAINY cccececectes cart sceneccetetacsetanencectectagsescece cee E E E O sett uae E E ER 26 Frequently Asked QUESTIONS cscssccccccecessesssseseceeecesseeuaesececscessesaaaeseceesseseeaeaeseseceeseuaeaeeeeseesseseasaeeeesens 27 Error MO SSAB ES ien es venenmneacsehesvacteos denceeande rete E a EE E eE E EErEE 28 Page 2 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Throughout this document reference will be made to Agilent Technologies Material Declaration Process website Rather than repeating the reference throughout the document it is provided below Please bookmark this link and explore the information on this site carefully as part of your preparation to completing the Declaration paperwork http www agilent com supplier Agilent_Materials shtml Overview TM This User Guide describes the proper completion of the Agilent Compliance Connect reporting form Material Declaration Reporters must use only the Agilent Compliance M Connect reporting form that is a data collection tool licensed from Enovia Software Corporation The Agilent Technologies specific versi
29. tab by clicking on the green button on the upper left hand corner of the sheet and correct any errors before proceeding to the next tab Before you get started review the reference tabs provided in the spreadsheet Overview Quick Reference Example Part Tree Example Material Example and Part Detail Example In addition a help box is displayed for each field within the Agilent M T Compliance Connect spreadsheet to provide further clarification Page 7 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Process Flow Diagram The part content reporting process using the Compliance Connect spreadsheet is summarized in the following diagram TM Download Agilent s Compliance Connect software and save on hard drive or network p s 7 way V Download reference materials N Y V l TM Open a blank copy of Agilent Compliance Connect enable the macros Import the Pre Populate File W Complete the General information Tab g Complete Part Tree tab for each Saleable Part supplied to Agilent Technologies or the Partial Declaration Tab and Define materials used in bottom level parts on the Material tab Complete the Part Detail tab by indicating the materials of fabrication for part s E mail agmcc file to Agilent Technologies per instructions that came with the request from Agilent Technologies Page 8 of 28 Agilent Technologies Compliance Connect Spreadsheet User G
30. tifies bottom level parts based on the BOM structure input on the Part Tree tab during Step 4a and identifies them in a pop up box when the Part Number field is selected Begin by clicking on the first cell under Part Number and selecting a bottom level part from the list Enter the part attributes columns headings have red text on the first line On subsequent lines enter information regarding the material s comprising that part green headings For each material in a part click the cell under Material Name and select a material from the list The Material Name list is generated by material record entries created on the Material tab during Step 5 Click the Overall Help button on the Part Tree tab for detailed instructions Use the Check Part Detail Data button to verify that all required information has been entered and is in the proper format After the data has been verified in the Part Detail tab the Certify and Export button will become enabled Page 24 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 7 Part Detail Tab Fields and Definitions Required Optional Your Part Number Your unique part number auto populated Your Part Revision Your revision level for the part auto populated Derived ce eee oe Your Part Revision The ane date of your revision level for the Derived Part Name The sei name for the part auto De
31. ttles that have been recycled then used to produce plastic clips Contained The sum of the Pre Consumer Recyclate Derived Recyclate As percentage of the material and Post Released Consumer Recyclate percentage of the material Contained The percent of recyclate contained in the Required Recyclate As material as measured Typically the same as Measured the Contained Recyclate As Released Specific Gravity Density entered as specific gravity of the Required material Enter N A not required by Agilent Technologies Remarks General comments regarding this material Optional pees iiomatonsuomsson Substance The chemical substance name from the list of Required fame inidawaenosn CAS Number The Chemical Abstracts Service number for Required the chemical substance name in the previous Substance Amount of the reported substance in the Required Concentration affected part material typically in percent by Amount weight of the material containing the substance Substance The units used to report the concentration in Required Concentration the previous column typically Unit Page 22 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 Table 6 lists the available Material Classifications for use when creating a new material type on the Materials tab Table 6 Material Classifications Steels cast steel sintered steel Thermoplastic elastomers 1 Steels
32. ual 100 of the material composition Table 1 Data Reporting Structure Complete BOM Part Material Composition Material Substance Substance Weight Amount composition Amount Ibs 1234 0 08 123 1 0 05 Steel 0 04 lron 5 3 23 100 123 2 0 02 Steel 0 015 Iron 90 5 3 2 TO0 X 100 Agilent Technologies suppliers have the option of reporting data for each saleable part in a summarized or rolled up format as long as the materials are reported at the homogenous level Rolled up data requires that the material content be summarized for the top level or saleable part rather than breaking down the assembly to its subcomponents This can be useful if the saleable part is an assembly containing Page 6 of 28 Agilent Technologies Compliance Connect Spreadsheet User Guide Rev 1 6 22 April 2009 several parts composed of the same homogenous materials Table 2 displays how rolled up data would be reported for the Knob Assembly example Table 2 Data Reporting Structure Rolled Up BOM Part Weight Material Material Substance Substance Ibs Composition Amount composition Amount 1234 0 08 Steel 0 055 Iron 90 Part number Sum of detail for saleable component part weights Notice that the sum of material weights is equal to the assembly part weight and that substances equal 100 of the material composition Data checks are built into the spreadsheet Suppliers must check the data for each completed
33. uide Rev 1 6 22 April 2009 Step 1 Download the Agilent Compliance Connect Spreadsheet The Agilent Compliance Connect spreadsheet is available to download from the Agilent Technologies website The spreadsheet is posted as a compressed file zip format due to its large file size e Download the zip file and save it on your computer hard drive or network Open TM the downloaded zip file use WinZip or other compatible software on operating systems prior to Windows XP Once the zip file is open double click on the TM executable exe or the Microsoft Excel file and load Compliance Connect on your computer hard drive or network e The Compliance Connect spreadsheet should prompt the user to enable or disable macros each time the file is opened Macros must be enabled or required spreadsheet functionality will be lost If the prompt does not appear check the Macro Security Level next e To set your Macro Security options o Excel 2003 select Tools then Options then Security tab then Macro Security button Select Medium on the Security Level tab and then click the OK button o Excel 2000 select Tools then Macro then Security from the Excel Tool Bar Select Medium on the Security Level tab and then click the OK button o To reset your macro security options in Excel 2000 select Tools then Macro then Security from the Excel tool bar Select Medium on the Security Level tab and then click the OK button T
Download Pdf Manuals
Related Search