EUVIMEDEUVIMED entdecken
VergleichsstudieOpen Access · CC BY 4.0

Comparative Analysis of the Accuracy of Microsoft Excel Macros in Retrospective Chart Review Studies

Justin Bauzon, Gustavo Romero-Velez, Ludovico Sehnem, Joyce Shin, Allan Siperstein, Judy Jin

Journal of Surgical Research · 2025

DOI: 10.1016/j.jss.2025.04.021 ↗

Kurz gefasst

Vergleichsstudie in der Zeitschrift Journal of Surgical Research, 2025. Verfasst von Justin Bauzon und 5 weiteren Autor:innen. Beteiligte Einrichtung: Department of Endocrine Surgery, Cleveland Clinic Foundation, Cleveland, Ohio. Hauptthemen laut MEDLINE: Thyroid Neoplasms, Electronic Health Records, Software. Die Arbeit nennt 17 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

INTRODUCTION: While retrospective chart review is a useful methodology for clinical research, challenges still exist when abstracting data from the electronic health record. When collected manually, unstructured "free text" data are particularly tedious and can be susceptible to errors and biases. We aimed to evaluate the accuracy of Microsoft Excel macros to facilitate the data abstraction process. METHODS: One hundred pathology reports following surgery for thyroid cancer were retrospectively evaluated. Twenty variables of interest (tumor characteristics, invasive features, and lymph node counts) were manually abstracted by a physician reviewer. A macro ("ThyMAC") was developed to extract the same variables. Abstraction error rates and speed were measured between manual and macro-assisted methods using a paired t-test. Accuracy, classification rates, and interrater reliability of ThyMAC were then analyzed. After identifying correctable errors, an ad hoc analysis of the optimized macro was then performed. RESULTS: Abstraction errors by physician reviewer were slightly lower relative to ThyMAC (3.8 versus 5.3% error rate, P = 0.03). By contrast, data collection time was 270 times faster via macro-assistance (65 versus 0.24 s per pathology report, P < 0.001). Overall, ThyMAC performed with high rates of accuracy (87-100%) for all abstracted variables, with moderate-to-perfect agreement for 14 of 20 variables. Addressing correctable errors significantly decreased macro error rates compared to the physician abstractor (3.6 versus 0.5%, P < 0.001). CONCLUSIONS: Compared to a trained physician abstractor, macros can extract unstructured data in retrospective chart review studies with high accuracy at speeds superior to a manual approach. Macro errors are typically preventable, and the program can be modified to improve data extraction accuracy. Macros can serve as an efficient and versatile tool to assist researchers with chart review data collection, especially when large datasets are involved.

Schlagwörter

MeSH-Schlagwörter (MEDLINE)

Thyroid NeoplasmsElectronic Health RecordsSoftwareHumansRetrospective StudiesReproducibility of Results

Stichwörter der Autor:innen

Chart reviewData abstractionData cleaningData miningElectronic health recordObservational studyRetrospective chart review

Autor:innen und Institutionen

  • Department of Endocrine Surgery, Cleveland Clinic Foundation, Cleveland, Ohio.
  • Department of Endocrine Surgery, Cleveland Clinic Foundation, Cleveland, Ohio. Electronic address: jinj@ccf.org.

Zitieren

APA

Bauzon, J., Romero-Velez, G., Sehnem, L., Shin, J., Siperstein, A., & Jin, J. (2025). Comparative Analysis of the Accuracy of Microsoft Excel Macros in Retrospective Chart Review Studies. Journal of Surgical Research. https://doi.org/10.1016/j.jss.2025.04.021

Vancouver

Bauzon J, Romero-Velez G, Sehnem L, Shin J, Siperstein A, Jin J. Comparative Analysis of the Accuracy of Microsoft Excel Macros in Retrospective Chart Review Studies. Journal of Surgical Research. 2025. doi:10.1016/j.jss.2025.04.021

BibTeX
@article{Bauzon2025,
  author = {Bauzon, Justin and Romero-Velez, Gustavo and Sehnem, Ludovico and Shin, Joyce and Siperstein, Allan and Jin, Judy},
  title = {Comparative Analysis of the Accuracy of Microsoft Excel Macros in Retrospective Chart Review Studies},
  journal = {Journal of Surgical Research},
  year = {2025},
  doi = {10.1016/j.jss.2025.04.021}
}
Kostenlos starten →