openmolecules.org Forum: Functionality » LLE column doesn't update with new compound data

Home » DataWarrior » Functionality » LLE column doesn't update with new compound data

Show: Today's Messages :: Polls :: Message Navigator

LLE column doesn't update with new compound data [message #92]

Wed, 12 August 2015 02:46

mvamos
Messages: 24
Registered: January 2015
Location: US

Junior Member

The LLE calculation column didn't update for me when I added new data. I merged in new IC50 data on which the LLE calculation is based. The structures for the compounds were already present and I merged the .csv file containing the IC50 data.

If I go again through Chemistry>Add Compound Properties>LE & Tox>LLE to add a new column (now appended with a 2 at the end because it's a duplicate of the previous), the values for the new data populate correctly.

In the attached photo, you can see the original LLE column on the left, and the 2nd LLE on the right.

Perhaps this is a small bug?

Attachment: Untitled.png
(Size: 16.41KB, Downloaded 1030 times)

Report message to a moderator

Re: LLE column doesn't update with new compound data [message #95 is a reply to message #92]

Fri, 14 August 2015 07:41

thomas
Messages: 715
Registered: June 2014

Senior Member

this is the expected behaviour. The LLE calculation is a one time matter. There is no mechanism that would update LLE values when the original IC50 is updated or when new IC50 values are appended. After appending new rows you could remove the then incomplete LLE column and calculate a new one. If you do this often, you could create a macro for that. Regards, Thomas

Report message to a moderator

Re: LLE column doesn't update with new compound data [message #276 is a reply to message #95]

Tue, 30 May 2017 01:49

Christoph
Messages: 9
Registered: May 2017

Junior Member

Hi everyone,

I had similar issues. I added more molecules and was wondering why the SMILES-structure column doesn't automatically update and add the SMILES for my new molecule. It would be nice to have an "update" option for the columns which DataWarrior once filled in.

Only a suggestion... Smile

Best wishes,
Christoph

Report message to a moderator

Re: LLE column doesn't update with new compound data [message #282 is a reply to message #276]

Fri, 02 June 2017 22:41

thomas
Messages: 715
Registered: June 2014

Senior Member

Hi Christoph,

DataWarrior has no mechanism to automatically update cell content that was originally derived from other cell content. If I started that, this could get easily very complex and chaotic, because editing a structure might then change computed properties, which in turn could trigger changes on derived columns. SAR tables, chemical space plots, SOMs, custering results, ..., would all require an automatic update after adding or changing some rows. To be consistent I would need to update everything and not just SMILES columns. DataWarrior would then be another program. For some time I thought about giving individual columns an 'automatic update' status, but even that would have lots of consequences. Finally, I dropped the idea. Again I suggest to create a small macro deleting the SMILES column and re-creating it.

Hope you can live without it.

Best wishes, Thomas

Report message to a moderator

Re: LLE column doesn't update with new compound data [message #286 is a reply to message #282]

Mon, 05 June 2017 17:18

Christoph
Messages: 9
Registered: May 2017

Junior Member

Hi Thomas,

Thank you very much for letting us know more about the background.

Since there is a workaround on this issue I can live with the current version of course.

Because it would however be a very nice feature if all 'derived' columns could be updated automatically, maybe this idea would be something for the list of features for the next major version of the program at some time in the future.

Best wishes,
Christoph

Report message to a moderator

Previous Topic:	Rendering structures from SMILES
Next Topic:	Option to freeze columns and rows.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 00:10:05 CET 2024

Total time taken to generate the page: 0.03729 seconds