Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 1 of 1
Full-Text Articles in Medicine and Health Sciences
Using Macros In Microsoft Excel To Facilitate Cleaning Of Research Data, Justin Bauzon, Caleb Murphy, Sandhya Wahi-Gururaj
Using Macros In Microsoft Excel To Facilitate Cleaning Of Research Data, Justin Bauzon, Caleb Murphy, Sandhya Wahi-Gururaj
School of Medicine Faculty Publications
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 …