SciCombinator

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

Concept: Lotus 1-2-3

600

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

29

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 http://sourceforge.net/projects/imdev/. 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

25

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

5

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

0

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

0

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

0

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

0

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

0

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

0

Terminal restriction fragment length polymorphism (T-RFLP) analysis is a DNA-fingerprinting method that can be used for comparisons of the microbial community composition in a large number of samples. There is no consensus on how T-RFLP data should be treated and analyzed before comparisons between samples are made, and several different approaches have been proposed in the literature. The analysis of T-RFLP data can be cumbersome and time-consuming, and for large datasets manual data analysis is not feasible. The currently available tools for automated T-RFLP analysis, although valuable, offer little flexibility, and few, if any, options regarding what methods to use. To enable comparisons and combinations of different data treatment methods an analysis template and an extensive collection of macros for T-RFLP data analysis using Microsoft Excel were developed.

Concepts: Microsoft Excel, Object-oriented programming, Restriction fragment length polymorphism, Microsoft, Spreadsheet, Microsoft Office, Lotus 1-2-3, Microsoft Office 2007