Transcript SanDisk PowerPoint Template
CMDDS Template Input Guidelines
SanDisk EMS 19 June 2013
Achieve More.
SanDisk Confidential 1
Agenda
CMDDS Sheet Input Lab Test Data Sheet Input Note for Lab Test Report and Incorrect Examples BOM and Material Weight Sheet Input Macros Usage
SanDisk Confidential 2
CMDDS Sheet Input
Area highlighted in yellow-General information is mandatory for CM to disclose
Our P/N: SanDisk part number. Part Name: Must same as SanDisk part number Mass: Product total weight. (
note: no need to fill manually, check input macro will calculate
) Contact information: CM contact information including CM name, CM code (received from SanDisk procurement/leave it as blank), contact name, address, email and phone number etc..
Request ID: Must input as “SanDisk”.
SanDisk Confidential 3
CMDDS Sheet Input
Example for general information SanDisk Confidential 4
CMDDS Sheet Input
Detail homogenous material information are mandatory for CM to disclose Used Region:
Location where homogenous subcomponent used in product. Material Name: Material type used.
Homogenous Component/Subcomponent:
Subcomponents used in homogenous material. Element Name/Chemical Substance: The chemical elements included in homogenous subcomponent.
Purpose of Containment: For what purpose substance is used.
SanDisk Confidential 5
CMDDS Sheet Input
Weight:
Total Homogeneous subcomponent weight and substances total weight need match and input manually.
CAS#: Chemical Abstracts Service Registry Number, which is a unique identifier for the chemical substance. CAS# should match with respective substance. Make sure substances CAS# is not included in Controlled and Reportable substances CAS# list (ref to GP).
Note:
Homogenous PPM level is not required to input manually. Total homogenous PPM level of each homogeneous subcomponent should be 1 million.
Substance PPM=(substance weight/homogeneous subcomponent weight)*1000000 SanDisk Confidential 6
CMDDS Sheet Input
Example for homogenous material declaration SanDisk Confidential 7
CMDDS Sheet Input
Example for homogenous material declaration SanDisk Confidential 8
Lab Test Data Sheet Input
General Information: General information will be captured from MDDS Form sheet by macro process
The 3 rd Lab Test Result
Test result: On the whole, input data per test result in lab test report; If test result is non detected, input “ND”; if CM could not provide any test report, input test result as “N/A”. Test date: Disclose the report publish date as test date. If there is no publish date, disclose latest date in testing period. RoHS Exemption: Select RoHS exemption based on dropdown menu. If there is no exemption, leave it as blank.
SanDisk Confidential 9
Lab Test Data Sheet Input
Screen shot for general information: Screen shot for test result: SanDisk Confidential 10
Note for Lab Test Report
SanDisk only accepts the lab test reports from ISO17025 certified 3rd party laboratories.
Content disclosed in completed lab test report from a 3 rd party laboratory: 1.
General information: serial number of test report, supplier name, sample name, sample description, sample type, test period and so on.
2.
Testing process and test result: test requirement, test method, sample preparation, test substance, MDL and test result.
3.
Sample picture.
MSDS can’t be accepted as a test report to SanDisk. 4/29/2020 SanDisk Confidential 11
Incorrect Lab Test Report Example
Incorrect lab test report example: Example 1: The description for ink in lab test reports are mismatched. All the lab test reports description for ink should be consistent. Example 2: The color description in MDDS mismatch with description in lab test report. Especially ink, power, solder paste etc.
4/29/2020 SanDisk Confidential 12
Incorrect Lab Test Report Example
Example 3: Lab test report with sample mixed tested won’t be accepted. Homogenous level lab test report is required.
Example 4: Description of material type in CMDDS sheet mismatch with that in lab test report.
4/29/2020 SanDisk Confidential 13
Incorrect Lab Test Report Example
Example 5: Validity date expired. SanDisk shall request CM to provide latest lab test report.
Example 6: Soluble substance lab test report can’t be accepted by SanDisk.
4/29/2020 SanDisk Confidential 14
BOM and Material Weight Sheet Input
Completely disclose the BOM materials used in the BOM spread sheet.
Memory wafer, Controller wafer, Die attach film and Gold wire material calculations are to be disclosed at the material weight spread sheet.
Example for Data disclosed in BOM and Material Weight Sheet SanDisk Confidential 15
Macros Usage Sequence
Macros are used to check data calculation, data integrity and CMDDS format accuracy automatically after CM input data.
Clear Format
( Do not forget to delete attachment in CMDDS )
Data Input in CMDDS Sheet Check Input in CMDDS Sheet Data Input in Lab Test Data Sheet Attach CoC and Lab Test Report in Lab Test Data Sheet Check Input in Lab Test Data sheet Export Data in CMDDS
SanDisk Confidential 16
Macros Usage
Clear Format: Before data input to MDDS, click “Clear Format” to delete unnecessary data or record.
Note
: CM shall delete attachments lab test report manually, as “Clear Format” function could only clean words; attachments are not included.
SanDisk Confidential 17
Macros Usage
Check Input in MDDS Form Sheet:
Data Input Manually
Disclose homogeneous material information from column A13-H13, J, M is mandatory.
Data Calculation Automatically
1. Data Calculation: No need to input any data in Column I, K, L . Macros will remind before calculate automatically if any data filled.
SanDisk Confidential 18
Macros Usage
After input data from column A to H, J and M, click “check input” in CMDDS sheet, mass(B9), unit element mass, homogenous component/subcomponent rate and content rate will be calculated and shown automatically. SanDisk Confidential 19
Macros Usage
2. Data Integrity Verification: 1) PPM level for homogenous subcomponent should be 1 million, macros will remind to modify if PPM level is incorrect.
2) If total homogenous subcomponents weight is equal to total unit element mass, numbers will show green color, else show red color. 3) If total content rate is 100%, number will show green color, else show red color.
CM should modify based on verification result. Screen shot for ppm level reminding: Screen shot for correct/incorrect weights: 3. Data Capture from CMDDS Sheet to Lab Test Data Sheet: C5, C6, and C7 are equal to CMDDS of B7, B8 and J5 respectively.
B13 is equal to CMDDS B7.
C13, D13 are equal to CMDDS A13, D13 and below.
SanDisk Confidential 20
Macros Usage
Check Input in Lab Test Data Sheet: After input data and attach lab test reports, click “check input”, macros will align the format.
Note
: Make sure all the attachments size are small and do not exceed excel cell, otherwise macros will show errors during “check input”. SanDisk Confidential 21
Macros Usage
Export Data: Click “Export” to transfer all the data into MDDS which will be sent to SanDisk.
Note
: Attachment size may change after export data process, CM need to check and do some adjustment to make it looks normal. Save MDDS in Excel 2003 version. SanDisk Confidential 22
Thank You!
SanDisk Confidential 23