Dear Mihir,

An example how to display logP values for a list of compound in Excel:

The structures can be found in the column A of an Excel sheet and you would like to see the logP values in the column B next to the structures.

Please select the B1 cell and enter =JClogP(A1) into the B1 cell and press enter

>> the logP value (calculated for the structure in A1 cell) should be displayed in the B1 cell

Click on the bottom-right corner of the B1 cell, and copy the logP function from B1 cell to the B2, B3, B4, B5...... cells by dragging.

>> logP values - calculated for the structures in A2, A3, A4, A5 ... cells - should be displayed in B2, B3, B4, B5...... cells

Of course you can insert the JClogP function into the B1 cell by using the "Insert Function" function of the Excel.

In this case you have to select the JClogP function from the JChem_Protonation and Partitioning category on the Insert Function form.

Press OK and enter A1 as Molecule on the Function Arguments form and Press OK on the Function Arguments form

>> The calculated logP value should be displayed in B1 cell. You can copy the function into B2, B2, B3 cells by dragging.

Best regards,

Zsolt