ELECTRONIC SUBMISSIONS

(Updated 04/16/13)

为中国翻译这里点击

       We currently have a system in place for electronic submissions if you are a windows database management user.  You can submit your formulas 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-556-1044 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  Click here for the EXCEL TEMPLATE  There are 3 tabs, one for formula, one for brands and the third tab has instructions for use.

 *****INSTRUCTIONS FOR PASSWORD PROTECTING YOUR EXCEL FILE.*****

IT IS IMPORTANT FOR SECURITY AND TO PROTECT YOUR PROPRIETARY FORMULA INFORMATION THAT YOU PASSWORD PROTECT THE EXCEL FILE PRIOR TO SENDING IT TO DUKE.  To assign an optional password to your file, locate the TOOLS dropdown button which is just to the left of the SAVE button, then choose General Options.... and enter the company  password provided by Duke in the "password to open" field (it is in the form XXXX*XXXX).

IF YOU HAVE NOT RECEIVED A COMPANY SPECIFIC PASSWORD FROM DUKE, PLEASE CONTACT:  Caroline Davis Rourk at rourk003@mc.duke.edu and she can provide that to you.

      ACMI 3RD PARTY SUPPLIER/VENDOR LETTER:  click here for vendor letter. 

GENERAL INSTRUCTIONS FOR DATA ENTRY:

1. Data may be entered in mixed case but will be converted to uppercase when imported into the Duke system.

2. Defined columns on the product formulation worksheet is fixed and cannot be moved.  The heading line cannot be changed.

3. Data entered beyond the defined columns or inserted above the heading row will be ignored.

4. Data entered in each cell will be validated as you leave the cell.  Data pasted form other source will not be validated.

PRODUCT FORMULATION ENTRY:

1. Enter the MANUFACTURER/trade name, chemical name, Chemical Abstract Number (CAS#) and the high 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 alternate code to each alternate for the ingredient:

Example:

SUBMISSION TO DUKE:

1. Save your file using the Save As dialog

a. To assign an optional password to your file, locate the TOOLS dropdown button which is just to the left of the SAVE button, then choose General Options.... and enter the company  password provided by Duke in the "password to open" field (it is in the form XXXX*XXXX).

b. Change the file name to include your manufacturer's number and your product number.  The template file name of ACMIProductPPPPPP.xls could be SAVED AS (Example: 0123WATERCOLORS.xls)

c. Include in your cover letter/email whether the product is marketed to children, product sizes, for whom the product is being evaluated(ACMI member), the brand names and who will be paying for the evaluation. 

d. 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.

THESE INSTRUCTIONS CAN ALSO BE FOUND ON THE INSTRUCTIONS TAB OF THE EXCEL TEMPLATE

                                                                           DUKE OEM TOXICOLOGY HOME PAGE

         DUKE STAFF   DUKE MED CTR.    ACMI    WIMA    POISINDEX    WINDOWS SYSTEM