ELECTRONIC SUBMISSIONS

(Updated 08/03/09)

为中国翻译这里点击

       We currently have a system in place for electronic submissions if you are a windows database management user.  You can submit your formulas on diskette or as Email attachments.  This program encrypts your submissions so that they can be safely mailed or attached to an Email.  Do not send unencrypted formulations as Email attachments.  The latter should be mailed or sent overnight delivery to us.  

      If you are interested in purchasing the ACMI windows database management system, please contact Debbie Gustafson at ACMI at781-293-4100 for purchase information.

      If you would like to hear more about the ACMI windows database management system, please contact Caroline Rourk at Duke at 919-681-6535 or at email address: rourk003@mc.duke.edu.    

       ELECTRONIC SUBMISSION OF AN EXCEL SPREADSHEET

    We have recently developed the capability for submitting a product electronically using an EXCEL FILE.     为中国翻译这里点击

Use this file to enter your formula as follows:

1.  Enter the MANUFACTURER/trade name, chemical name, Chemical Abstracts Services registration number(CAS#) and the high and low loading range, in percent by weight for each ingredient.  Make sure to enter a manufacturer/trade name for each ingredient.

2.  For colors, enter each color name and the loading for those formula ingredients (usually pigments or dyes) that are unique to that color.  The pigment/dye information does not have to be repeated for each new color line.

Example:

3. If you have alternates for an ingredient, assign the same company code to each ingredient:

Example:

4. Change the file name to include your manufacturer's number and your product number.  The template file is named 0000productPPPPPP.xls. Your product may be named (four digit man#)productwatercolors.xls.

In order to send this excel file to Duke electronically we recommend that you password protect the file since it contains your proprietary formula information.  In order to do so, Duke will need to assign you a company specific password.  Contact Caroline Davis Rourk at Duke for this information prior to sending the file. Tel-919-681-6535, fax- 919-286-5647  email: rourk003@mc.duke.edu.

We also have an excel template for submitting brands with SKU numbers for import into the ACMI database system at Duke.  EXCEL BRANDS

Companies should rename the PPPPPPPP portion of the filename to the product getting the import data and they must just add rows to these files. The program expects columns exactly as defined in these templates and additional data will not be recognized

TO PASSWORD PROTECT YOUR EXCEL FILE GO TO TOOLS/OPTIONS/SECURITY.

5. Once you have received your password and instructions from Duke, attach an email note or memo telling us the following information about the file:

Product number;product category; whether the product is marketed to children; product sizes; for whom this product is being evaluated (ACMI, WIMA, etc), the brand names and who is paying for the evaluation.  If you are a new customer, we will need a prepayment of the estimated amount of the evaluation prior to beginning the actual evaluation.

6. Files can be submitted to us by email attachment or CD.  Send to email address: rourk003@mc.duke.edu or mailed to 2200 West Main Street, Suite 400, Durham, N.C. 27705.

                                                                           DUKE OEM TOXICOLOGY HOME PAGE

         DUKE STAFF   DUKE MED CTR.    ACMI    WIMA    POISINDEX    WINDOWS SYSTEM