PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: ChemDraw functions in Excel
Topic Summary: choices under "Insert Function" don't work
Created On: 6/18/2009 11:50 PM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
Answer This question was answered by CS RNA, on Friday, June 30, 2017 2:51 AM

Answer:

Please note ChemDraw Ultra or ChemBioDraw Ultra or ChemDraw Professional suite does not include CLOGP (also ChemProp Proand Molecular Topology) functions in ChemDraw for Excel. Hence when you tried to use functions like CLOGP_DRIVER_PARTITION_COEFFICIENT you got a #VALUE!

You can calculate all these properties within ChemDraw Ultra or ChemBioDraw Ultra as well as ChemDraw Professional application, but if you also want to use them in Excel, you need to upgrade to ChemOffice Ultra or ChemBioOffice Ultra suite or ChemOffice Professional suite.

 6/18/2009 11:50 PM
User is offline View Users Profile Print this message


Bruce

Posts: 1
Joined: 6/18/2009

I want to calculate chemical properties in excel. I select "Insert Function" and then "CHEMPROPPRO.LOGP" and type "A2" between the parentheses; I get "0". However, if I change the function to "CHEMPROP.LOGP(A2), that works. Yet I can't select "CHEMPROP.LOGP" using "Insert Function".

Also, using "Insert Function", when I select CHEMPROPPRO.WATER.SOLUBILITY and enter A2 between parentheses, I get "0". When I change the function to CHEMPROP.WATER.SOLUBILITY(A2), I get "#NAME?"

ISSTRUCTURE(A2) returns "TRUE"
 6/24/2009 4:29 AM
User is offline View Users Profile Print this message


CS RNA

Posts: 609
Joined: 2/25/2009

In ChemDraw for Excel you are able to insert only the available functions. I believe everything behaving properly; you have this issue because, you are trying to use a non available function (in the list) manually by editing the function name within Excel.

I think you are trying to find the value for a complex structure; it would be nice if you can contact support@cambridgesoft.com with sample file with that structure.


-------------------------

- PKI Support

 8/4/2009 5:24 AM
User is offline View Users Profile Print this message


timmy

Posts: 18
Joined: 4/1/2009

I had this problem too - the response to me was that it is a defect, has been reported, and will be addressed in a future release........has it been addressed yet?


“CHEMPROPPRO.LOGP()” is the correct function to use, but it showing the error. I have entered this issue in our defect tracking system, so that we can hopefully address it in a future release. We have no information as to when it will be addressed at this time, but all new releases and patches are announced in the ChemBioNews weekly email.

 8/7/2009 2:14 AM
User is offline View Users Profile Print this message


CS RNA

Posts: 609
Joined: 2/25/2009

Actually it is limitation; you got issue because you are trying to find the value for a complex structure.

It would be helpful if you can send a sample files with the structures (.cdx) that are not behaving properly to support@cambridgesoft.com


-------------------------

- PKI Support

 4/14/2010 11:33 PM
User is offline View Users Profile Print this message


jimmyp

Posts: 1
Joined: 4/14/2010

I have a similar problem. Some of the functions in Chemdraw/Excel 12.0 work but things like =CLOGP_DRIVER_PARTITION_COEFFICIENT(cell number) return the message #VALUE. This is very annoying as one often wants to calculate ClogP and TPSA for a list of compounds. It has nothing to do with the complexity of the structure -- I drew the structure for phenol, observed in the Chemdraw "chemical properties" window that it yielded a TPSA value, but the moment one tries to insert this function into a spreadsheet with a reference to a cell containing a structure, the function yields the same #VALUE! error message.

This happens whether one starts from scratch or is working from an imported SD file. Major flaw with the program -- and the patch did not help. BTW this is on MS Office 2003.

Simple functions like the number of H Bond acceptors work -- rotatable bonds do not. Is there a list anywhere of which functions fail?
 9/6/2010 1:38 AM
User is offline View Users Profile Print this message


CS RNA

Posts: 609
Joined: 2/25/2009

Are you able to get the value for Benzene; if so please contact support@cambridgesoft.com with a sample file; with the structures (.cdx) that are not behaving properly.

Meanwhile, can you please retest the problem with the newly released ChemDraw for Excel patch (12.0.2.987)? You can obtain from the following link (by selecting the appropriate product say ChemBioDraw/ChemDraw)

http://www.cambridgesoft.com/s...ktopSupport/Downloads/



-------------------------

- PKI Support

 6/30/2017 2:51 AM
User is offline View Users Profile Print this message


CS RNA

Posts: 609
Joined: 2/25/2009

Answer Answer

Please note ChemDraw Ultra or ChemBioDraw Ultra or ChemDraw Professional suite does not include CLOGP (also ChemProp Proand Molecular Topology) functions in ChemDraw for Excel. Hence when you tried to use functions like CLOGP_DRIVER_PARTITION_COEFFICIENT you got a #VALUE!

You can calculate all these properties within ChemDraw Ultra or ChemBioDraw Ultra as well as ChemDraw Professional application, but if you also want to use them in Excel, you need to upgrade to ChemOffice Ultra or ChemBioOffice Ultra suite or ChemOffice Professional suite.



-------------------------

- PKI Support

FuseTalk Basic Edition v4.0 - © 1999-2018 FuseTalk Inc. All rights reserved.