Sensitivity analysis for unmeasured confounders using an electronic spreadsheet

In studies assessing the effects of a given exposure variable and a specific outcome of interest, confusion may arise from the mistaken impression that the exposure variable is producing the outcome of interest, when in fact the observed effect is due to an existing confounder. However, quantitative techniques are rarely used to determine the potential influence of unmeasured confounders. Sensitivity analysis is a statistical technique that allows to quantitatively measuring the impact of an unmeasured confounding variable on the association of interest that is being assessed. The purpose of this study was to make it feasible to apply two sensitivity analysis methods available in the literature, developed by Rosenbaum and Greenland, using an electronic spreadsheet. Thus, it can be easier for researchers to include this quantitative tool in the set of procedures that have been commonly used in the stage of result validation.

Metagenomics, paratransgenesis and the Anopheles microbiome: a portrait of the geographical distribution of the anopheline microbiota based on a meta-analysis of reported taxa

Anophelines harbour a diverse microbial consortium that may represent an extended gene pool for the host. The proposed effects of the insect microbiota span physiological, metabolic and immune processes. Here we synthesise how current metagenomic tools combined with classical culture-dependent techniques provide new insights in the elucidation of the role of the Anopheles-associated microbiota. Many proposed malaria control strategies have been based upon the immunomodulating effects that the bacterial components of the microbiota appear to exert and their ability to express anti-Plasmodium peptides. The number of identified bacterial taxa has increased in the current “omics” era and the available data are mostly scattered or in “tables” that are difficult to exploit. Published microbiota reports for multiple anopheline species were compiled in an Excel® spreadsheet. We then filtered the microbiota data using a continent-oriented criterion and generated a visual correlation showing the exclusive and shared bacterial genera among four continents. The data suggested the existence of a core group of bacteria associated in a stable manner with their anopheline hosts. However, the lack of data from Neotropical vectors may reduce the possibility of defining the core microbiota and understanding the mosquito-bacteria interactive consortium.

TitGer: uma planilha eletrônica para simulação de titulação de mistura de compostos polipróticos

The aim of this paper is to present a simple way of treating the general equation for acid-base titrations based on the concept of degree of dissociation, and to propose a new spreadsheet approach for simulating the titration of mixtures of polyprotic compounds. The general expression, without any approximation, is calculated a simple iteration method, making number manipulation easy and painless. The user-friendly spreadsheet was developed by using MS-Excel and Visual-Basic-for-Excel. Several graphs are drawn for helping visualizing the titration behavior. A Monte Carlo function for error simulation was also implemented. Two examples for titration of alkalinity and McIlvaine buffer are presented.

Planilha de validação: uma nova ferramenta para estimar figuras de mérito na validação de métodos analíticos univariados

This work presents the VALIDATION SPREADSHEET, a public domain tool that can be used to evaluate the figures of merit for univariate analytical methods. A real example of BTEX determination in environmental samples is included to illustrate its use. The spreadsheet has been developed for Excel® and Open Office®, and is available on the internet at http//lqta.iqm.unicamp.br.

Determinação de ácido acéttico em amostra de vinagre adulterada com ácido clorídrico - um experimento integrado de titulação potenciométrica e condutométrica

The determination of acetic acid in vinegar adulterated sample using simultaneous potentiometric and condutometric titrations was used as an example of integrated experiment in instrumental analysis. An Excel® spreadsheet, which allows the entry of simultaneous data and the construction of the superimposed experimental curves (condutometric, potentiometric, first and second derivative potentiometric curve and, distribution diagrama of the acetic species as function of pH), was used as powerful tool to discuss the fundamental concepts involved in each technique and choose the best of them to quantify, without mutual interference, H3CCOOH and HCl in vinegar adulterated sample.

AVALIAÇÃO DO USO DE PLANILHAS COMPUTACIONAIS COMO UMA FERRAMENTA DIDÁTICA EM QUÍMICA ANALÍTICA QUALITATIVA

The use of spreadsheet softwares is not widespread in Chemical Education in Brazil as a computational education tool. By its turn the Qualitative Analytical Chemistry is considered a discipline with classical and non-flexible content. Thus in this work the spreadsheet software Excel® was evaluated as a teaching tool in a Qualitative Analytical Chemistry course for calculations of concentrations of the species in equilibrium in solutions of acids. After presenting the theory involved in such calculations the students were invited to elaborate the representation of the distribution of these species in a graphical form, using the spreadsheet software. Then the teaching team evaluated the resulting graphics regarding form and contents. The graphics with conceptual and/or formal errors were returned for correction, revealing significant improvement in the second presentation in all cases. The software showed to be motivating for the content of the discipline, improving the learning interest, while it was possible to prove that even in classical disciplines it is possible to introduce new technologies to help the teaching process.

Weather based warning systems for bean angular-leaf-spot and anthracnose

Data available in the literature were used to develop a warning system for bean angular leaf spot and anthracnose, caused by Phaeoisariopsis griseola and Colletotrichum lindemuthianum, respectively. The model is based on favorable environmental conditions for the infectious process such as continuous leaf wetness duration and mean air temperature during this subphase of the pathogen-host relationship cycle. Equations published by DALLA PRIA (1977) showing the interactions of those two factors on the disease severity were used. Excell spreadsheet was used to calculate the leaf wetness period needed to cause different infection probabilities at different temperature ranges. These data were employed to elaborate critical period tables used to program a computerized electronic device that records leaf wetness duration and mean temperature and automatically shows the daily disease severity value (DDSV) for each disease. The model should be validated in field experiments under natural infection for which the daily disease severity sum (DDSS) should be identified as a criterion to indicate the beginning and the interval of fungicide applications to control both diseases.

Economic analysis for sizing of sugarcane (Saccharum spp.) mechanized harvesting

Sugarcane has a significant role on Brazilian agribusiness economy. The harvesting cane is considered as one of the most important operations of the process for it has to attend the raw material demanded by the sugar mill in quality and a competitive cost. The objective of this work it is it of analyzing, of systemic way, the variables influence on economical and operational performance in sugarcane mechanized harvesting process for sizing of machines. For this purpose a model called "ColheCana", was developed in a spreadsheet and in a programming language. The results showed that the field efficiency and harvester´s initial value are variables of great impact in the cost and that there is a maximum area that one equipment can attend and for this area the cost is minimum.

Calculating germination measurements and organizing spreadsheets

With the objective to minimize difficulties for beginners we are proposing the use of a conventional spreadsheet for the calculations of the main germination (or emergence) measurements, the organization of the final data for the statistical analysis and some electronic commands involved in these steps.