I need to be able to create customized labels for R-Groups for analysis in Excel.

I need to be able to create customized labels for R-Groups for analysis in Excel.

There is a way for you to add more structures that can be recognized by the Excel Add-in during an R-Group Analysis. Basically, you need to create the corresponding structures in the Nicknames folder.

In Windows XP, this folder is located by default under:

C:\Documents and Settings\All Users\Application Data\CambridgeSoft\ChemOffice2010\ChemDraw\ChemDraw Items\Nicknames

If you have Windows Vista or 7, the ChemDraw nicknames structures folder is under:

C:\ProgramData\CambridgeSoft\ChemOffice2010\ChemDraw\ChemDraw Items\Nicknames

You can use existing .cdxml files on that folder as a starting point (i.e.: Phenyl.cdxml) to add more structures that can be recognized by the Excel Add-in during an R-Group Analysis.