SCEW: A Microsoft Excel add-in for easy creation of survival curves

Khan, Haseeb A.

doi:10.1016/j.cmpb.2006.05.001

Cited by 11 publications

(7 citation statements)

References 32 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Continuous variables are presented as medians with interquartile ranges (25th and 75th percentiles) and those for dichotomous variables as frequencies. Data were analyzed, and Kaplan–Meier (KM) graph was constructed, after data reformatting, for event‐free survival in both groups, with the time to the first event of the composite endpoint used as the outcome variable . Log‐rank test was used to compare KM curve of two arms.…”

Section: Methodsmentioning

confidence: 99%

Eptifibatide in Post‐infarction Angina Patients who refused Intervention: Ajmer Postmyocardial Infarction Angina Eptifibatide Research (AJMER) Study: A Pilot Study

Gokhroo

Kishor

Ranwa

et al. 2015

Cardiovascular Therapeutics

View full text Add to dashboard Cite

SUMMARYBackground: Early intervention is certainly a preferred strategy over conservative management in patients with post-infarction angina (PIA). But at times, it may not be feasible to intervene, especially if patient refuses for intervention. In a pilot study, we analyzed whether the addition of eptifibatide to intensified antianginal therapy would be of added benefit, in patients with PIA not willing to undergo intervention. Methods: A total of 461 patients with PIA who refused intervention were randomized in a 1:1 manner to receive either eptifibatide along with intensification of antianginal therapy (group A; n = 229) or intensified antianginal therapy alone (group B; n = 232). The primary endpoints were composite of all-cause death and nonfatal myocardial infarction at 30 days. Results: Primary composite endpoint did not differ between the two groups (16.2% vs. 18.9% in group A and group B, odds ratio [OR], 0.82; 95% CI, 0.5-1.30; P-value = 0.43). Significant earlier relief of angina (complete relief of angina within 12 h: 76% of patients in group A vs. 40.5% in group B; P-value <0.0001) was achieved in group A compared to group B. Although on Bleeding Academic Research Consortium (BARC) scale, type 1 and 2 bleeding was higher in group A (OR, 3.18; 95% CI, 1.76-5.74; P-value = 0.0001), the more serious (composite of type 3 and 5) bleeds did not show any difference (OR, 1.73; 95% CI, 0.7-4.08; P-value = 0.21). Conclusion: In patients with PIA who refused intervention, eptifibatide infusion resulted in earlier relief of angina albeit at the cost of increased non-lifethreatening bleeding. Further, this effect was achieved in significantly higher number of patients receiving eptifibatide infusion when compared to patients not receiving it. Primary composite endpoints, however, did not differ in two groups, but being a pilot study, this needs to be confirmed by larger study of adequate sample size.

show abstract

Section: Methodsmentioning

confidence: 99%

Eptifibatide in Post‐infarction Angina Patients who refused Intervention: Ajmer Postmyocardial Infarction Angina Eptifibatide Research (AJMER) Study: A Pilot Study

Gokhroo

Kishor

Ranwa

et al. 2015

Cardiovascular Therapeutics

View full text Add to dashboard Cite

show abstract

“…Macros, short for 'macroinstruction,' are customizable software applications that transform inputs based on a pre-specified procedure or algorithm. They are a versatile tool in research and administrative settings for handling repetitive, tedious tasks in spreadsheet management and statistical analysis [2][3][4][5]. We were unable to identify any publications that explore the utility of macros for sorting and formatting raw research data.…”

Section: Introductionmentioning

confidence: 99%

Using macros in microsoft excel to facilitate cleaning of research data

Bauzon

Murphy

Wahi‐Gururaj

2021

Journal of Community Hospital Internal Medicine Perspectives

View full text Add to dashboard Cite

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 preprogrammed 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 macroassisted 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.

show abstract

“…5 Experiences in practice show that for the management of data collections, in particular in the clinical context, spreadsheet applications such as Microsoft Excel are popular choices. 6,7 Excel is not only used for instance data management but also for the management of schema-level and administrative data. For example, the widely used open source clinical trial software OpenClinica for electronic data capture offers an Excel template for creating electronic case report forms.…”

Section: Introductionmentioning

confidence: 99%

One Step Away from Technology but One Step Towards Domain Experts—MDRBridge: A Template-Based ISO 11179-Compliant Metadata Processing Pipeline

et al. 2019

View full text Add to dashboard Cite

Summary Background Secondary use of routine medical data relies on a shared understanding of given information. This understanding is achieved through metadata and their interconnections, which can be stored in metadata repositories (MDRs). The necessity of an MDR is well understood, but the local work on metadata is a time-consuming and challenging process for domain experts. Objective To support the identification, collection, and provision of metadata in a predefined structured manner to foster consolidation. A particular focus is placed on user acceptance. Methods We propose a software pipeline MDRBridge as a practical intermediary for metadata capture and processing, based on MDRSheet, an ISO 11179–3 compliant template using popular spreadsheet software. It serves as a practical mediator for metadata acquisition and processing in a broader pipeline. Due to the different origins of the metadata, both manual entry and automatic extractions from application systems are supported. To enable the export of collected metadata into external MDRs, a mapping of ISO 11179 to Clinical Data Interchange Standards Consortium (CDISC) Operational Data Model (ODM) was developed. Results MDRSheet is embedded in the processing pipeline MDRBridge and delivers metadata in the CDISC ODM format for further use in MDRs. This approach is used to interactively unify core datasets, import existing standard datasets, and automatically extract all defined data elements from source systems. The involvement of clinical domain experts improved significantly due to minimal changes within their usual work routine. Conclusion A high degree of acceptance was achieved by adapting the working methods of clinical domain experts. The designed process is capable of transforming all relevant data elements according to the ISO 11179-3 format. MDRSheet is used as an intermediate format to present the information at a glance and to allow editing or supplementing by domain experts.

show abstract

SCEW: A Microsoft Excel add-in for easy creation of survival curves

Cited by 11 publications

References 32 publications

Eptifibatide in Post‐infarction Angina Patients who refused Intervention: Ajmer Postmyocardial Infarction Angina Eptifibatide Research (AJMER) Study: A Pilot Study

Eptifibatide in Post‐infarction Angina Patients who refused Intervention: Ajmer Postmyocardial Infarction Angina Eptifibatide Research (AJMER) Study: A Pilot Study

Using macros in microsoft excel to facilitate cleaning of research data

One Step Away from Technology but One Step Towards Domain Experts—MDRBridge: A Template-Based ISO 11179-Compliant Metadata Processing Pipeline

Contact Info

Product

Resources

About