Download - J Chem For Excel: US UGM 2008
![Page 1: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/1.jpg)
JChem for Excel
Tamas Peltz, Ferenc Csizmadia
Solutions for Cheminformatics
![Page 2: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/2.jpg)
Introduction
• Microsoft Excel integrated solution for Marvin and JChem
functionality
• Use Excel’s powerful features: Functions, Sorting, Filtering,
Charts…
• Implemented in C# .NET, and Visual Studio• Proof that ChemAxon APIs can be used in a Java-less .NET
environment
• Easy to install and deploy
• UNDER DEVELOPMENT
![Page 3: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/3.jpg)
Features
• Import from Databases using custom filters
• Import from, and export to files.
• Searching and R-Group Decomposition
• Adding, editing structures
• Chemical functions among Excel functions
![Page 4: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/4.jpg)
Import from Database – Manage Connections
• JChem Cartridge Databases– Structure search runs
on the server• JChem Base
Databases– Structure search runs
locally– Databases supported
• Oracle• Coming: MSSQL,
Access, MySQL, ...
• Connection settings are saved
![Page 5: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/5.jpg)
Import from Database - Query
• Common interface for client-side or server-side structure searching
• Easy to use control for specifying search options
• Chemical Terms filter expressions for queries
• Optional substructure hit coloring and alignment
• Additional SQL filters
![Page 6: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/6.jpg)
Structure file import and export
• Most file formats supported
by Marvin could be
exported and imported
– MRV,SDF,RDF,SMILES
, IUPAC name,…
• Wizards guide you through
the import and export
processes
![Page 7: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/7.jpg)
Import - Results
SDF import resultsDatabase import results with hit coloring
![Page 8: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/8.jpg)
R-group Decomposition
• Run Decomposition on– JChem Database– Files– Excel Worksheet
![Page 9: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/9.jpg)
Chemical Excel Functions
• Chemical Terms functions and Marvin calculations are implemented as Excel functions:
• Composition, Mass, MolFormula
• AtomCount, BondCount,
ChiralCenterCount,RingCount…
• logP,logD, pKa , PSA,
H-bond donor/acceptors
• Bioavailability, GhoseFilter,LeadLikeness,Lipinski rule of 5…
• SubstructureMatch, Dissimilarity
• IUPAC Name
• StructureImage(draws an image of a structure)
![Page 10: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/10.jpg)
Chemical Excel Functions
• Values are calculated from:• SMILES, SMARTS, IUPAC Name strings
• Structure cells – structures resulting from imports,
edit, or other functions
• Marvin OLE Object (future)
• Function results are automatically updated when structures edited or added
![Page 11: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/11.jpg)
Chemical Excel functions – Demo
Property calculations for Caffeine
![Page 12: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/12.jpg)
Chemical Excel functions – Demo 2
logD vs. pH calculated and displayed
in a chart from a SMILES input
MolFormula,
Composition, IUPAC
Name calculated from
CD_STRUCTURE
![Page 13: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/13.jpg)
Reactor Excel Functions• JCReactGetProductImage(<GenericReaction>, <Reagent1>,
<Reagent2>)• React the reagents based on the generic reaction, and put the image of the
product in the cell
• JCReactGetReactionImage(<GenericReaction>, <Reagent1>, <Reagent2>)
• React the reagents based on the generic reaction, and put the image of the concrete reaction in the cell
• JCReactGetProduct (<GenericReaction>, <Reagent1>, <Reagent2>, <Format>)
• React the reagents based on the generic reaction, and put the string representation of the product in the cell(SMILES, IUPAC name)
• JCReactGetReaction (<GenericReaction>, <Reagent1>, <Reagent2>, <Format>)
• React the reagents based on the generic reaction, and put the string representation of the product in the cell(SMILES , IUPAC name)
![Page 14: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/14.jpg)
Reactor Excel Functions - Demo
=JCReactGetProductImage(<GenericReaction in A1>, <Reagents in A column>, <Reagents in Row1>)
![Page 15: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/15.jpg)
Deployment
• MSI Installer
• No configuration needed
• ~10MB File with JChem and Marvin API included
• Automatic deployment and updates through
Active Directory
• ClickOnce (Planned Feature)
• Update from Excel at startup or when needed
![Page 16: J Chem For Excel: US UGM 2008](https://reader033.vdocuments.us/reader033/viewer/2022061120/546cee02b4af9f702c8b521c/html5/thumbnails/16.jpg)
Find out more
• Product descriptions & linkswww.chemaxon.com/products.html
• Forumwww.chemaxon.com/forum
• Presentations and posterswww.chemaxon.com/conf
• Downloadwww.chemaxon.com/download.html