Stratis Health EDTC Excel Data Collection Tool User Manual

About this manual

This manual explains how to use Stratis Health's Excel-based data collection tool for the Emergency Department Transfer Communication (EDTC) measure. It covers downloading, macro setup, data entry, record management, and report generation. The tool is designed for healthcare providers to collect and report on patient transfer communication data.

The manual includes step-by-step instructions for adding new records, editing existing ones, running monthly and discharge disposition reports, and exporting data for MBQIP submission. It also provides guidance on enabling macros and navigating the tool’s interface.

What's inside

• Background
• Downloading the tool
• Getting started
• Macro setup
• Color coding
• Navigation
• Specifications Manual
• Initial Page
• Adding a new record
• Patient List page

Frequently asked questions

What is the EDTC measure?

The EDTC measure is a hospital quality measure used to evaluate communication for transitions of care during emergency department (ED) transfers.

What versions of Excel are supported?

The tool is available in two versions: XLSM (for Excel 2007 and beyond) and XLS (for older Excel versions).

What should I do if I accidentally enter data for an existing record?

You will receive a message asking if you want to save the record as a new one. Click "Yes" to save it as a new record, or "No" to cancel.