Concept: Microsoft Office
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.
The choice of an efficient document preparation system is an important decision for any academic researcher. To assist the research community, we report a software usability study in which 40 researchers across different disciplines prepared scholarly texts with either Microsoft Word or LaTeX. The probe texts included simple continuous text, text with tables and subheadings, and complex text with several mathematical equations. We show that LaTeX users were slower than Word users, wrote less text in the same amount of time, and produced more typesetting, orthographical, grammatical, and formatting errors. On most measures, expert LaTeX users performed even worse than novice Word users. LaTeX users, however, more often report enjoying using their respective software. We conclude that even experienced LaTeX users may suffer a loss in productivity when LaTeX is used, relative to other document preparation systems. Individuals, institutions, and journals should carefully consider the ramifications of this finding when choosing document preparation strategies, or requiring them of authors.
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).
Enzyme kinetic parameters are usually determined from initial rates nevertheless, laboratory instruments only measure substrate or product concentration versus reaction time (progress curves). To overcome this problem we present a methodology which uses integrated models based on Michaelis-Menten equation. The most severe practical limitation of progress curve analysis occurs when the enzyme shows a loss of activity under the chosen assay conditions. To avoid this problem it is possible to work with the same experimental points utilized for initial rates determination. This methodology is illustrated by the use of integrated kinetic equations with the well-known reaction catalyzed by alkaline phosphatase enzyme. In this work nonlinear regression was performed with the Solver supplement (Microsoft Office Excel). It is easy to work with and track graphically the convergence of SSE (sum of square errors). The diagnosis of enzyme inhibition was performed according to Akaike information criterion.
Excel2Genie, a simple and user-friendly Microsoft Excel interface, has been developed to the Genie-2000 Spectroscopic Software of Canberra Industries. This Excel application can directly control Canberra Multichannel Analyzer (MCA), process the acquired data and visualize them. Combination of Genie-2000 with Excel2Genie results in remarkably increased flexibility and a possibility to carry out repetitive data acquisitions even with changing parameters and more sophisticated analysis. The developed software package comprises three worksheets: display parameters and results of data acquisition, data analysis and mathematical operations carried out on the measured gamma spectra. At the same time it also allows control of these processes. Excel2Genie is freely available to assist gamma spectrum measurements and data evaluation by the interested Canberra users. With access to the Visual Basic Application (VBA) source code of this application users are enabled to modify the developed interface according to their intentions.
Contaminated site remediation is generally difficult, time consuming, and expensive. As a result ranking may aid in efficient allocation of resources. In order to rank the priorities of contaminated sites, input parameters relevant to contaminant fate and transport, and exposure assessment should be as accurate as possible. Yet, in most cases these parameters are vague or not precise. Most of the current remediation priority ranking methodologies overlook the vagueness in parameter values or do not go beyond assigning a contaminated site to a risk class. The main objective of this study is to develop an alternative remedial priority ranking system (RPRS) for contaminated sites in which vagueness in parameter values is considered. RPRS aims to evaluate potential human health risks due to contamination using sufficiently comprehensive and readily available parameters in describing the fate and transport of contaminants in air, soil, and groundwater. Vagueness in parameter values is considered by means of fuzzy set theory. A fuzzy expert system is proposed for the evaluation of contaminated sites and a software (ConSiteRPRS) is developed in Microsoft Office Excel 2007 platform. Rankings are employed for hypothetical and real sites. Results show that RPRS is successful in distinguishing between the higher and lower risk cases.
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.
Electronic laboratory notebooks (ELNs) will probably replace paper laboratory notebooks (PLNs) in academic research due to their advantages in data recording, sharing and security. Despite several reports describing technical characteristics of ELNs and their advantages over PLNs, no study has directly tested ELN performance among researchers. In addition, the usage of tablet-based devices or wearable technology as ELN complements has never been explored in the field. To implement an ELN in our biomedical research institute, here we first present a technical comparison of six ELNs using 42 parameters. Based on this, we chose two ELNs, which were tested by 28 scientists for a 3-month period and by 80 students via hands-on practical exercises. Second, we provide two survey-based studies aimed to compare these two ELNs (PerkinElmer Elements and Microsoft OneNote) and to analyze the use of tablet-based devices. We finally explore the advantages of using wearable technology as ELNs tools. Among the ELNs tested, we found that OneNote presents almost all parameters evaluated (39/42) and both surveyed groups preferred OneNote as an ELN solution. In addition, 80% of the surveyed scientists reported that tablet-based devices improved the use of ELNs in different respects. We also describe the advantages of using OneNote application for Apple Watch as an ELN wearable complement. This work defines essential features of ELNs that could be used to improve ELN implementation and software development.
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.
Advances in mobile telecommunication, improved mobile internet and affordability have led to a significant increase in smartphone use within medicine. The capability of instant messaging, photography, videography, word processing, drawing and internet access allow significant potential in this small portable device. Smartphone use within medicine has grown tremendously worldwide given its affordability, improved internet and capabilities.