Using macros in microsoft excel to facilitate cleaning of research data

Autor:	Justin Bauzon, Caleb Murphy, Sandhya Wahi-Gururaj
Jazyk:	angličtina
Rok vydání:	2021
Předmět:	Database Intrinsic function business.industry Brief Report Vital signs Sorting microsoft excel Information repository computer.software_genre RC31-1245 vba macro Informatics sort Medicine retrospective chart review Transcription (software) Macro business computer Internal medicine
Zdroj:	Journal of Community Hospital Internal Medicine Perspectives, Vol 11, Iss 5, Pp 653-657 (2021) Journal of Community Hospital Internal Medicine Perspectives article-version (VoR) Version of Record
ISSN:	2000-9666
Popis:	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
Databáze:	OpenAIRE
Externí odkaz:	https://explore.openaire.eu/search/publication?articleId=doi_dedup___::b0c1aaa6f572b208d3983cbbc30ae9c5 https://doaj.org/article/f454e50e351545f89c6d35115a553ea6 Zobrazit plný text záznamu Plný text ve formátu PDF