EurekaMag
+ Translate
+ Most Popular
Investigations on the organic drift in North Swedish streams
Limitations of Using Microsoft Excel Version 2016 (MS Excel 2016) for Statistical Analysis for Medical Research
Phloem necrosis of coffee in Surinam
Anatomy of Mystus seenghala IV Nervous system
Integrated farming system for gardenland conditions of Coimbatore district - an over view
Tetrapleure (Tetrapleura tetraptera), an unknown African medicinal and spice plant
The origin and phylogenetic significance of the trochophoran larvae 2. evolutionary significance of the larvae of coelomate worms and mollusks
Comparison of rice bran and maize bran as feeds for growing and fattening pigs
Enterobacter amnigenus. An unusual human pathogen
Influence of Seriboost foliar application on leaf yield and leaf protein content in mulberry (Morus spp.), in relation to silkworm cocoon production
The identity of the lipstick mold of cultivated mushrooms agaricus bisporus
Advantages and disadvantages of bordeaux mixture and of lime-sulphur used on apples in the growing season
'Pan-sukh' disease of Rice in the Central Provinces
Geological age of the Ptilophyllum flora; a critical reassessment
Study of vitellogenesis in birds; physiological phases & role of folliculin in vitellogenesis
Evaluation of WCT coconut and Komadan coconut
Therapy for acne with saccharomyces boulardii
Evidence for Late Cretaceous N-S dextral shear in the west-central crystalline core, North Cascades, Washington
'Rajeshwari' - a high-yielding white seeded variety of sesame for Andhra Pradesh
Manufacture of Ricotta cheese from whey fortified with skim milk powder using different acidulants
Occurrence of Eutrichophilus mexicanus (Rudow, 1866) and Eutrichophilus lobatus (Ewing, 1936) (Phthiraptera: Trichodectidae) on Sphiggurus villosus (Cuvier, 1825) (Rodentia: Erethizontidae) in Rio de
Factors affecting fruitfulness in durian (Durio zibethinus Murr.). I. Flowering and pollination
Bronchial cuff pressure change caused by left-sided double-lumen endobronchial tube displacement
Some Biological Applications of Organometallic Compounds
The composition of pampas-grass (Cortaderia argentea.)

Using macros in microsoft excel to facilitate cleaning of research data


Using macros in microsoft excel to facilitate cleaning of research data



Journal of Community Hospital Internal Medicine Perspectives 11(5): 653-657



ISSN/ISBN: 2000-9666

PMID: 34567457

Background: Retrospective chart review studies may be delayed by inability to export clean clinical data from an electronic medical record (EMR) or data repository. Macros are pre-programmed procedures that can be used in Microsoft Excel to help streamline the process of cleaning clinical datasets. Objectives: To demonstrate how macros may be useful for researchers at community hospitals and smaller academic health centers that lack informatics support. Methods: Using an intrinsic function of our institution's EMR, vital signs and lab results from 20 individual hospitalizations were exported to a spreadsheet. Two macros were developed to sort through these datasets and output them into a specified format. The speed of macro-assisted data cleaning was compared to manual transcription. Results: Time spent on data cleaning was significantly reduced when using macro-assisted sorting compared to the manual approach for both vital signs (46.5 seconds versus 12.3 minutes per record, a 94% reduction; P < 0.001) and labs (13.7 seconds versus 2.6 minutes per record, a 91% reduction; P < 0.001). Conclusions:Macros offer a flexible and efficient tool for cleaning large sets of clinical data, particularly when an institution lacks informatics support or EMR functionality to export clinical data in an analysis-ready format.

Please choose payment method:






(PDF emailed within 1 workday: $29.90)

Accession: 072849240

Download citation: RISBibTeXText

Related references

Tutorial: simulating chromatography with Microsoft Excel Macros. Analytica Chimica Acta 773: 1-8, 2013

Generating variable and random schedules of reinforcement using Microsoft Excel macros. Journal of Applied Behavior Analysis 41(2): 227-235, 2008

PETRO.CALC.PLOT, Microsoft Excel macros to aid petrologic interpretation. Computers and Geosciences 20(6): 1041-1061, 1994

Add-in macros for rapid and versatile calculation of non-compartmental pharmacokinetic parameters on Microsoft Excel spreadsheets. Computer Methods and Programs in Biomedicine 50(1): 43-52, 1996

Microsoft excel macros for analysing plasmid instability and their application to recombinant strains of Saccharomyces cerevisiae. Binary Computing in Microbiology 6(6): 204-210, 1994

Retention prediction and separation optimization under multilinear gradient elution in liquid chromatography with Microsoft Excel macros. Journal of Chromatography. a 1395: 109-115, 2015

"Utstein style" spreadsheet and database programs based on Microsoft Excel and Microsoft Access software for CPR data management of in-hospital resuscitation. Resuscitation 61(1): 37-40, 2004

Limitations of Using Microsoft Excel Version 2016 (MS Excel 2016) for Statistical Analysis for Medical Research. Clinical Spine Surgery 29(5): 203-204, 2016

Preparing data for analysis using microsoft Excel. Journal of Investigative Medicine: the Official Publication of the American Federation for Clinical Research 54(6): 334-341, 2006

How to manage and display qualitative data using "Framework" and Microsoft Excel. Journal of Clinical Nursing 12(4): 610-612, 2003

Simple and Quick Visualization of Periodical Data Using Microsoft Excel. Methods and Protocols 2(4), 2019

Petro Plot: A plotting and data management tool set for Microsoft Excel. Geochemistry, Geophysics, Geosystems 4(3): N/A-N/A, 2003

PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel. Computer Methods and Programs in Biomedicine 99(3): 306-314, 2010

Inflexion Automated analysis of radioligand binding data with microsoft Excel. British Journal of Pharmacology 112(Proceedings Suppl MAY): 440P, 1994

Using Microsoft Excel® to Build a Customized Partial-Interval Data Collection System. Behavior Analysis in Practice 11(4): 504-516, 2018