Discover the most talked about and latest scientific content & concepts.

Concept: Lotus 1-2-3


The spreadsheet software Microsoft Excel, when used with default settings, is known to convert gene names to dates and floating-point numbers. A programmatic scan of leading genomics journals reveals that approximately one-fifth of papers with supplementary Excel gene lists contain erroneous gene name conversions.

Concepts: Microsoft Excel, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3, Spreadsheet software, Pivot table, VisiCalc


Interactive modules for Data Exploration and Visualization (imDEV) is a Microsoft Excel spreadsheet embedded application providing an integrated environment for the analysis of omics data through a user-friendly interface. Individual modules enables interactive and dynamic analyses of large data by interfacing R’s multivariate statistics and highly customizable visualizations with the spreadsheet environment, aiding robust inferences and generating information-rich data visualizations. This tool provides access to multiple comparisons with false discovery correction, hierarchical clustering, principal and independent component analyses, partial least squares regression and discriminant analysis, through an intuitive interface for creating high-quality two- and a three-dimensional visualizations including scatter plot matrices, distribution plots, dendrograms, heat maps, biplots, trellis biplots and correlation networks. Availability and implementation: Freely available for download at Implemented in R and VBA and supported by Microsoft Excel (2003, 2007 and 2010).

Concepts: Regression analysis, Microsoft Excel, Microsoft, Graphical user interface, Spreadsheet, Visual Basic for Applications, Microsoft Office, Lotus 1-2-3


Graphing is socially significant for behavior analysts; however, graphing can be difficult to learn. Video modeling (VM) may be a useful instructional method but lacks evidence for effective teaching of computer skills. A between-groups design compared the effects of VM, text-based instruction, and no instruction on graphing performance. Participants who used VM constructed graphs significantly faster and with fewer errors than those who used text-based instruction or no instruction. Implications for instruction are discussed.

Concepts: Psychology, Microsoft Excel, Learning, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3, Microsoft Office 2007


Genomic datasets accompanying scientific publications show a surprisingly high rate of gene name corruption. This error is generated when files and tables are imported into Microsoft Excel and certain gene symbols are automatically converted into dates.

Concepts: Microsoft Excel, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3, CP/M, Microsoft Office 2007, Microsoft Office 2008 for Mac


Calculation of the concentration-time profile in four consecutive, well-mixed compartments that are connected by diffusional transport is a frequently occurring problem for chemists and engineers. Mathematically this is equivalent to many other problems such as the concentration profiles of a parent compound and its three consecutive reaction products resulting from reversible first-order kinetics. Here we present an analytical solution to this problem implemented in a Microsoft Excel spreadsheet (available for download) and we discuss various examples of how this simple-to-use tool can be applied to very different scenarios from various fields of science.

Concepts: Microsoft Excel, Mathematics, Science, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3, Pivot table


All available data on asbestos consumption in Australia were collated in order to determine the most common asbestos-containing materials remaining in the built environment. The proportion of asbestos contained within each material and the types of products these materials are most commonly found in was also determined. The lifetime of these asbestos containing products was estimated in order to develop a model that projects stocks and flows of asbestos products in Australia through to the year 2100. The model is based on a Weibull distribution and was built in an excel spreadsheet to make it user-friendly and accessible. The nature of the products under consideration means both their asbestos content and lifetime parameters are highly variable, and so for each of these a high and low estimate is presented along with the estimate used in the model. The user is able to vary the parameters in the model as better data become available.

Concepts: Microsoft Excel, Statistics, Mathematics, Natural environment, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3


Electronic medical records and electronic data capture (EDC) have changed data collection in clinical and translational research. However, spreadsheet programs, such as Microsoft Excel, are still used as data repository to record and organize patient data for research.

Concepts: Microsoft Excel, Crossover study, Clinical research, Computer program, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3


The study was aimed to compare two different monitor unit (MU) or dose verification software in volumetric modulated arc therapy (VMAT) using modified Clarkson’s integration technique for 6 MV photons beams. In-house Excel Spreadsheet based monitor unit verification calculation (MUVC) program and PTW’s DIAMOND secondary check software (SCS), version-6 were used as a secondary check to verify the monitor unit (MU) or dose calculated by treatment planning system (TPS). In this study 180 patients were grouped into 61 head and neck, 39 thorax and 80 pelvic sites. Verification plans are created using PTW OCTAVIUS-4D phantom and also measured using 729 detector chamber and array with isocentre as the suitable point of measurement for each field. In the analysis of 154 clinically approved VMAT plans with isocentre at a region above -350 HU, using heterogeneity corrections, In-house Spreadsheet based MUVC program and Diamond SCS showed good agreement TPS. The overall percentage average deviations for all sites were (-0.93% + 1.59%) and (1.37% + 2.72%) for In-house Excel Spreadsheet based MUVC program and Diamond SCS respectively. For 26 clinically approved VMAT plans with isocentre at a region below -350 HU showed higher variations for both In-house Spreadsheet based MUVC program and Diamond SCS. It can be concluded that for patient specific quality assurance (QA), the In-house Excel Spreadsheet based MUVC program and Diamond SCS can be used as a simple and fast accompanying to measurement based verification for plans with isocentre at a region above -350 HU.

Concepts: Microsoft Excel, Measurement, Systems of measurement, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3, Pivot table


Human flora are the most common cause of bacteremia in immunocompromised patients. Activities of daily living (ADL), including oral care and daily chlorhexidine gluconate bathing, can lower the risk of infection.

Concepts: Immune system, Antiseptic, Chlorhexidine, Lotus 1-2-3


Documentation of prescriptions and clinical outcomes in routine homeopathic practice is a prerequisite for conducting targeted research in homeopathy. Six homeopathic physicians participated in methodical data collection over a 3-month period in 6 outpatient departments of Mahesh Bhattacharyya Homeopathic Medical College and Hospital, West Bengal, India. A specifically designed Microsoft Excel spreadsheet enabled recording of consecutive appointments-date, patient identity, medical condition/complaint, whether chronic/acute, new/follow-up case, patient-assessed outcome (7-point Likert-type scale: -3 to +3), prescribed homeopathic medication, and whether other medication/s being taken for the condition. Spreadsheets were submitted monthly for data synthesis and analysis. A total of 1972 patients' follow-up generated data of 2905 appointments, of which 2272 (78.2%) were positive, 183 (6.3%) negative, and 450 (15.5%) showed no change. Strongly positive outcomes (scores of +2/+3) were recorded in osteoarthritis, piles, cough, dysfunctional uterine bleeding, chronic suppurative otitis media, and conjunctivitis. This systematic recording short-listed promising areas of future homeopathic research.

Concepts: Medicine, Microsoft Excel, Physician, Otitis media, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3