LICSS - a chemical spreadsheet in microsoft excel.

BACKGROUND: Representations of chemical datasets in spreadsheet format are important for ready data assimilation and manipulation. In addition to the normal spreadsheet facilities, chemical spreadsheets need to have visualisable chemical structures and data searchable by chemical as well as textual queries. Many such chemical spreadsheet tools are available, some operating in the familiar Microsoft Excel environment. However, within this group, the performance of Excel is often compromised, particularly in terms of the number of compounds which can usefully be stored on a sheet. SUMMARY: LICSS is a lightweight chemical spreadsheet within Microsoft Excel for Windows. LICSS stores structures solely as Smiles strings. Chemical operations are carried out by calling Java code modules which use the CDK, JChemPaint and OPSIN libraries to provide cheminformatics functionality. Compounds in sheets or charts may be visualised (individually or en masse), and sheets may be searched by substructure or similarity. All the molecular descriptors available in CDK may be calculated for compounds (in batch or on-the-fly), and various cheminformatic operations such as fingerprint calculation, Sammon mapping, clustering and R group table creation may be carried out.We detail here the features of LICSS and how they are implemented. We also explain the design criteria, particularly in terms of potential corporate use, which led to this particular implementation. CONCLUSIONS: LICSS is an Excel-based chemical spreadsheet with a difference:• It can usefully be used on sheets containing hundreds of thousands of compounds; it doesn't compromise the normal performance of Microsoft Excel• It is designed to be installed and run in environments in which users do not have admin privileges; installation involves merely file copying, and sharing of LICSS sheets invokes automatic installation• It is free and extensibleLICSS is open source software and we hope sufficient detail is provided here to enable developers to add their own features and share with the community.

Substituent effects on aromatic stacking interactions.

Synthetic supramolecular zipper complexes have been used to quantify substituent effects on the free energies of aromatic stacking interactions. The conformational properties of the complexes have been characterised using NMR spectroscopy in CDCl(3), and by comparison with the solid state structures of model compounds. The structural similarity of the complexes makes it possible to apply the double mutant cycle method to evaluate the magnitudes of 24 different aromatic stacking interactions. The major trends in the interaction energy can be rationalised using a simple model based on electrostatic interactions between the pi-faces of the two aromatic rings. However, electrostatic interactions between the substituents of one ring and the pi-face of the other make an additional contribution, due to the slight offset in the stacking geometry. This property makes aromatic stacking interactions particularly sensitive to changes in orientation as well as the nature and location of substituents.

Electrostatic control of aromatic stacking interactions.

A supramolecular approach has been used to investigate the free energies of intermolecular aromatic stacking interactions. Chemical double mutant cycles have been used to measure the effect of a range of substituents on face-to-face stacking interactions with phenyl and pentafluorophenyl rings. Electrostatic effects dominate the trends in interaction energy.

Experimental measurement of noncovalent interactions between halogens and aromatic rings.

Chemical double mutant cycles have been used to quantify the interactions of halogens with the faces of aromatic rings in chloroform. The halogens are forced over the face of an aromatic ring by an array of hydrogen-bonding interactions that lock the complexes in a single, well-defined conformation. These interactions can also be engineered into the crystal structures of simpler model compounds, but experiments in solution show that the halogen-aromatic interactions observed in the solid state are all unfavourable, regardless of whether the aromatic rings contain electron-withdrawing or electron-donating substituents. The halogen-aromatic interactions are repulsive by 1-3 kJ mol(-1). The interactions with fluorine are slightly less favourable than with chlorine and bromine.