{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,28]],"date-time":"2026-04-28T12:48:48Z","timestamp":1777380528182,"version":"3.51.4"},"reference-count":17,"publisher":"Elsevier BV","license":[{"start":{"date-parts":[[2025,7,1]],"date-time":"2025-07-01T00:00:00Z","timestamp":1751328000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"},{"start":{"date-parts":[[2025,7,1]],"date-time":"2025-07-01T00:00:00Z","timestamp":1751328000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/legal\/tdmrep-license"},{"start":{"date-parts":[[2025,5,7]],"date-time":"2025-05-07T00:00:00Z","timestamp":1746576000000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["clinicalkey.com","clinicalkey.com.au","clinicalkey.es","clinicalkey.fr","clinicalkey.jp","journalofsurgicalresearch.com","elsevier.com","sciencedirect.com"],"crossmark-restriction":true},"short-container-title":["Journal of Surgical Research"],"published-print":{"date-parts":[[2025,7]]},"DOI":"10.1016\/j.jss.2025.04.021","type":"journal-article","created":{"date-parts":[[2025,5,23]],"date-time":"2025-05-23T09:51:56Z","timestamp":1747993916000},"page":"92-97","update-policy":"https:\/\/doi.org\/10.1016\/elsevier_cm_policy","source":"Crossref","is-referenced-by-count":1,"special_numbering":"C","title":["Comparative Analysis of the Accuracy of Microsoft Excel Macros in Retrospective Chart Review Studies"],"prefix":"10.1016","volume":"311","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-0958-4343","authenticated-orcid":false,"given":"Justin","family":"Bauzon","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Gustavo","family":"Romero-Velez","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ludovico","family":"Sehnem","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Joyce","family":"Shin","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Allan","family":"Siperstein","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Judy","family":"Jin","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/j.jss.2025.04.021_bib1","first-page":"1187","article-title":"Stapled versus hand-sewn anastomoses in emergency general surgery: a retrospective review of outcomes in a unique patient population","volume":"74","author":"Farrah","year":"2013","journal-title":"J Trauma Acute Care Surg"},{"key":"10.1016\/j.jss.2025.04.021_bib2","doi-asserted-by":"crossref","first-page":"93","DOI":"10.1007\/s11701-024-01824-x","article-title":"Feasibility of robotic cholecystectomy at an academic center with a young robotic surgery program: a retrospective cohort study with umbrella review","volume":"18","author":"Corzo","year":"2024","journal-title":"J Robot Surg"},{"key":"10.1016\/j.jss.2025.04.021_bib3","doi-asserted-by":"crossref","first-page":"398","DOI":"10.4997\/jrcpe.2020.409","article-title":"Retrospective studies - utility and caveats","volume":"50","author":"Talari","year":"2020","journal-title":"J R Coll Physicians Edinb"},{"key":"10.1016\/j.jss.2025.04.021_bib4","doi-asserted-by":"crossref","first-page":"e65","DOI":"10.1097\/MLR.0000000000000108","article-title":"Overcoming the challenges of unstructured data in multisite, electronic medical record-based abstraction","volume":"54","author":"Polnaszek","year":"2016","journal-title":"Med Care"},{"key":"10.1016\/j.jss.2025.04.021_bib5","doi-asserted-by":"crossref","first-page":"1","DOI":"10.4258\/hir.2019.25.1.1","article-title":"Managing unstructured big data in healthcare system","volume":"25","author":"Kong","year":"2019","journal-title":"Healthc Inform Res"},{"key":"10.1016\/j.jss.2025.04.021_bib6","first-page":"1g","article-title":"Electronic health record (EHR) abstraction","volume":"18","author":"Alzu'bi","year":"2021","journal-title":"Perspect Health Inf Manag"},{"key":"10.1016\/j.jss.2025.04.021_bib7","first-page":"JG01","article-title":"Conducting record review studies in clinical practice","volume":"8","author":"Sarkar","year":"2014","journal-title":"J Clin Diagn Res"},{"key":"10.1016\/j.jss.2025.04.021_bib8","doi-asserted-by":"crossref","first-page":"430","DOI":"10.1164\/rccm.201610-2006OC","article-title":"Application of a natural language processing algorithm to asthma ascertainment. An automated chart review","volume":"196","author":"Wi","year":"2017","journal-title":"Am J Respir Crit Care Med"},{"key":"10.1016\/j.jss.2025.04.021_bib9","doi-asserted-by":"crossref","first-page":"653","DOI":"10.1080\/20009666.2021.1954282","article-title":"Using macros in microsoft excel to facilitate cleaning of research data","volume":"11","author":"Bauzon","year":"2021","journal-title":"J Community Hosp Intern Med Perspect"},{"key":"10.1016\/j.jss.2025.04.021_bib10","doi-asserted-by":"crossref","first-page":"448","DOI":"10.1177\/10815589231151437","article-title":"The Data Error Criteria (DEC) for retrospective studies: development and preliminary application","volume":"71","author":"Buczek","year":"2023","journal-title":"J Investig Med"},{"key":"10.1016\/j.jss.2025.04.021_bib11","doi-asserted-by":"crossref","first-page":"546","DOI":"10.1093\/aje\/kwg016","article-title":"Training, quality assurance, and assessment of medical record abstraction in a multisite study","volume":"157","author":"Reisch","year":"2003","journal-title":"Am J Epidemiol"},{"key":"10.1016\/j.jss.2025.04.021_bib12","doi-asserted-by":"crossref","first-page":"1485","DOI":"10.1093\/aje\/kwac035","article-title":"Misconceptions about the direction of bias from nondifferential misclassification","volume":"191","author":"Yland","year":"2022","journal-title":"Am J Epidemiol"},{"key":"10.1016\/j.jss.2025.04.021_bib13","doi-asserted-by":"crossref","first-page":"12","DOI":"10.3352\/jeehp.2013.10.12","article-title":"The retrospective chart review: important methodological considerations","volume":"10","author":"Vassar","year":"2013","journal-title":"J Educ Eval Health Prof"},{"key":"10.1016\/j.jss.2025.04.021_bib14","doi-asserted-by":"crossref","first-page":"180","DOI":"10.1097\/SLA.0000000000004354","article-title":"Accelerating surgical site infection abstraction with a semi-automated machine-learning approach","volume":"276","author":"Skube","year":"2022","journal-title":"Ann Surg"},{"key":"10.1016\/j.jss.2025.04.021_bib15","doi-asserted-by":"crossref","first-page":"292","DOI":"10.1016\/j.annemergmed.2014.03.025","article-title":"Looking through the retrospectoscope: reducing bias in emergency medicine chart review studies","volume":"64","author":"Kaji","year":"2014","journal-title":"Ann Emerg Med"},{"key":"10.1016\/j.jss.2025.04.021_bib16","doi-asserted-by":"crossref","DOI":"10.1097\/GOX.0000000000003633","article-title":"ChartSweep: a HIPAA-compliant tool to automate chart review for plastic surgery research","volume":"9","author":"Chartier","year":"2021","journal-title":"Plast Reconstr Surg Glob Open"},{"key":"10.1016\/j.jss.2025.04.021_bib17","doi-asserted-by":"crossref","first-page":"188","DOI":"10.1093\/jamia\/ocad182","article-title":"Selective prediction for extracting unstructured clinical data","volume":"31","author":"Swaminathan","year":"2023","journal-title":"J Am Med Inform Assoc"}],"container-title":["Journal of Surgical Research"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0022480425002355?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0022480425002355?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2026,3,26]],"date-time":"2026-03-26T09:15:20Z","timestamp":1774516520000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0022480425002355"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,7]]},"references-count":17,"alternative-id":["S0022480425002355"],"URL":"https:\/\/doi.org\/10.1016\/j.jss.2025.04.021","relation":{},"ISSN":["0022-4804"],"issn-type":[{"value":"0022-4804","type":"print"}],"subject":[],"published":{"date-parts":[[2025,7]]},"assertion":[{"value":"Elsevier","name":"publisher","label":"This article is maintained by"},{"value":"Comparative Analysis of the Accuracy of Microsoft Excel Macros in Retrospective Chart Review Studies","name":"articletitle","label":"Article Title"},{"value":"Journal of Surgical Research","name":"journaltitle","label":"Journal Title"},{"value":"https:\/\/doi.org\/10.1016\/j.jss.2025.04.021","name":"articlelink","label":"CrossRef DOI link to publisher maintained version"},{"value":"article","name":"content_type","label":"Content Type"},{"value":"\u00a9 2025 The Authors. Published by Elsevier Inc.","name":"copyright","label":"Copyright"}]}}