How do you specify options?

User 1efa2c4884

05-11-2010 22:29:09


I just started testing JChem for Excel and so far I have not been able to figure out how to specify options when using JChemExcel.Functions.  For example, I have a structure in a cell within Excel and I want to calculate the polar surface area of the structure.  I use JCPSA(), which allows me to specify the structure and the pH but not whether to exclude/include sulfur and phosphorus atoms from calculation.  It appears that by default, the function excludes sulfur and phosphorus but I would like to calculate the value including the two atoms.  Is there a way to do that within JChem for Excel?


Thank you!

ChemAxon def2724101

06-11-2010 09:01:20


I am afraid that this type of options is missing from the Polar Surface Area plugin. It is not possibe to decide if you want to include these atoms into the calculation or not. You can find more information about the calculator plugins by using this link:

I have pasted the available information about the Polar Surface Area plugin:

Polar surface area (PSA) is formed by polar atoms of a molecule.
It is a descriptor that shows good correlation with passive molecular
transport through membranes, and so allows estimation of transport
properties of drugs. Estimation of topoligical polar surface area (TPSA)
is based on the method given in this paper. The
method provides results which are practically identical with the 3D PSA,
while calculation time of TPSA is approximately 100-times faster. This
method is more suitable for fast bioavailability screening of large
virtual libraries. The TPSA value can be calculated both for the neutral form and
the major microspecies.

The calculation and the display options can be set in the Polar Surface Area (2D)


Best regards,


ChemAxon 0e37943a96

08-11-2010 07:29:45


initially we started off by putting the calculations in JChem for Excel with the default options. If there is need we will add the necessary options.

We also have a "universal function" called JCChemicalTerms, where it is possible to calculate any chemical terms expression on an input molecule. However I checked and as far as I can see, it is not even possible to specify it in Chemical Terms.

We will add these options to the 5.4 release of JChem for Excel.

Best regards,