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