Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Video

Updated: May 25, 2026

Isolation of Lipoprotein Particles from Chicken Egg Yolk for the Study of Bacterial Pathogen Fatty Acid Incorporation into Membrane Phospholipids
11:59

Isolation of Lipoprotein Particles from Chicken Egg Yolk for the Study of Bacterial Pathogen Fatty Acid Incorporation into Membrane Phospholipids

Published on: May 15, 2019

LICSS - a chemical spreadsheet in microsoft excel.

Kevin R Lawson1, Jonty Lawson

  • 1Syngenta Ltd, Jealotts Hill Research Centre, Bracknell, Berkshire, RG42 6EY, UK. kevin.lawson@syngenta.com.

Journal of Cheminformatics
|February 4, 2012
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

Microsoft Excel is a cornerstone tool for data analysis and statistical operations, offering a wide array of functionalities to manage, analyze, and visualize data efficiently. Recognized for its versatility, Excel facilitates the performance of basic to complex statistical operations, serving as an indispensable asset for analysts, researchers, and students alike. Excel's significance in data analysis emanates from its spreadsheet environment, where data can be organized in rows and columns,...
Performing a Simple Data Analysis using MS-Excel Function01:17

Performing a Simple Data Analysis using MS-Excel Function

Microsoft Excel offers a suite of functions and tools ideal for statistical analysis, making it accessible to students and researchers. This article outlines fundamental Excel functions pivotal for data analysis.
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Microsoft Excel: Pearson's Correlation01:18

Microsoft Excel: Pearson's Correlation

Microsoft Excel is a powerful tool for statistical analysis, including calculating Pearson's correlation coefficient, which measures the strength and direction of a linear relationship between two continuous variables. Pearson's correlation coefficient, often denoted as "r," ranges from -1 to 1. A value close to 1 indicates a strong positive correlation, meaning as one variable increases, the other does too. A value close to -1 indicates a strong negative correlation, implying that as one...
Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

Regression analysis in Microsoft Excel is a powerful statistical method for examining the relationship between a dependent variable and one or more independent variables. It's used extensively in fields such as economics, biology, and business to predict outcomes, understand relationships, and make data-driven decisions. The most common type is linear regression, which attempts to fit a straight line through the data points to model the relationship between variables.
To perform regression...
Microsoft Excel: Student's t-Test01:25

Microsoft Excel: Student's t-Test

Student's t-test in Microsoft Excel is a statistical method used to compare the means of two groups to determine if they are significantly different from each other. It's commonly used to evaluate hypotheses, such as testing whether a treatment has an effect compared to a control group. Excel provides built-in functions to perform t-tests, making it accessible for users needing to conduct basic statistical analysis.
To conduct a t-test in Excel, use the T.TEST function or the "Data Analysis...
Statistical Package for the Social Sciences (SPSS)01:22

Statistical Package for the Social Sciences (SPSS)

The Statistical Package for the Social Sciences, or SPSS, is a data management and analysis software suite. Developed by SPSS Inc. in 1968 and acquired by IBM in 2009, this tool was initially designed for social science data analysis, evolving to serve a wider range of disciplines. It was later renamed to Statistical Product and Service Solutions.
SPSS streamlines the process from data preparation to analysis and reporting. It is characterized by its user-friendly interface, which conceals...

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Substituent effects on aromatic stacking interactions.

Organic & biomolecular chemistry·2007
Same author

Electrostatic control of aromatic stacking interactions.

Journal of the American Chemical Society·2005
Same author

Experimental measurement of noncovalent interactions between halogens and aromatic rings.

Chembiochem : a European journal of chemical biology·2004
Same journal

Multimodal feature fusion for molecular property classification.

Journal of cheminformatics·2026
Same journal

P2MAT: A machine learning (ML) driven software for Property Prediction of MATerial.

Journal of cheminformatics·2026
Same journal

Computational design of low-volatility lubricants for space using interpretable machine learning.

Journal of cheminformatics·2026
Same journal

OpenStats: how to combine statistics and research data management (RDM) to leverage efficient scientific data analysis by guided statistics.

Journal of cheminformatics·2026
Same journal

Unified heterogeneity-aware benchmark of drug synergy prediction: a cross-study analysis of traditional machine learning and graph deep learning models.

Journal of cheminformatics·2026
Same journal

Count your bits: fingerprint benchmarking to assess broad chemical space representation.

Journal of cheminformatics·2026
See all related articles

LICSS is a lightweight, open-source chemical spreadsheet for Microsoft Excel that handles large datasets efficiently. It offers advanced cheminformatics features and easy installation for corporate environments.

Area of Science:

  • Cheminformatics
  • Computational Chemistry
  • Data Management

Background:

  • Spreadsheet representations are crucial for chemical data assimilation and manipulation.
  • Existing chemical spreadsheet tools often compromise Microsoft Excel's performance with large datasets.
  • Need for searchable chemical data and visualizable structures within spreadsheets.

Purpose of the Study:

  • To introduce LICSS, a lightweight chemical spreadsheet integrated into Microsoft Excel.
  • To enable efficient handling of large chemical datasets without performance degradation.
  • To provide advanced cheminformatics functionalities within a familiar spreadsheet environment.

Main Methods:

  • LICSS stores chemical structures as SMILES strings.
  • Utilizes Java code modules with CDK, JChemPaint, and OPSIN libraries for cheminformatics.

More Related Videos

Identification of Protein Interaction Partners in Mammalian Cells Using SILAC-immunoprecipitation Quantitative Proteomics
12:53

Identification of Protein Interaction Partners in Mammalian Cells Using SILAC-immunoprecipitation Quantitative Proteomics

Published on: July 6, 2014

Related Experiment Videos

Last Updated: May 25, 2026

Isolation of Lipoprotein Particles from Chicken Egg Yolk for the Study of Bacterial Pathogen Fatty Acid Incorporation into Membrane Phospholipids
11:59

Isolation of Lipoprotein Particles from Chicken Egg Yolk for the Study of Bacterial Pathogen Fatty Acid Incorporation into Membrane Phospholipids

Published on: May 15, 2019

Identification of Protein Interaction Partners in Mammalian Cells Using SILAC-immunoprecipitation Quantitative Proteomics
12:53

Identification of Protein Interaction Partners in Mammalian Cells Using SILAC-immunoprecipitation Quantitative Proteomics

Published on: July 6, 2014

  • Enables visualization of chemical structures (individual or en masse) and substructure/similarity searching.

    • Main Results:

    • LICSS supports sheets with hundreds of thousands of compounds without compromising Excel performance.
    • Facilitates batch or on-the-fly calculation of molecular descriptors available in CDK.
    • Supports various cheminformatics operations including fingerprint calculation, Sammon mapping, clustering, and R group table creation.

    Conclusions:

    • LICSS is a free, extensible, and open-source chemical spreadsheet for Windows.
    • Designed for easy installation and use in environments without admin privileges.
    • Facilitates efficient chemical data management and analysis within Microsoft Excel.