Patient Throughput LOS Time Tracking System


© 2007 KnowWare International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224

Jay Arthur
888-468-1537
303-756-9144
Email Us

We help people think!

Accelerate Patient Throughput and Reduce Length of Stay using our LOS Time Tracking System

According to the JCAHO, two thirds of hospitals experience ED diversion.

  • 20% are on divert more than 2.4 hours/day and 10% are on divert more than 5 hours per day.
  • Every hour on divert means the loss of two ambulances valued at an average of $6,000 each.
  • That's $12,000 per hour on divert.

While divert can be caused by lack of ED nursing staff or ED doctors, lack of beds is a significant cause. Hospitals also transfer patients to other hospitals because of bed shortages.

To reduce bed shortages, you have to accelerate patient throughput. And, according to the new JCAHO standard, LD.3.15, every hospital will need a plan to improve patient throughput starting in 2006.

To accelerate patient throughput, you have to be able to measure and improve the key steps in length of stay (LOS). More advanced paperless medical records systems will track much of this for you. If your system doesn't do this, you can't wait for the next big IT conversion.

To simplify and automate much of this data collection and analysis, I've created a series of time tracking tools in Microsoft Excel. And I've integrated them with the QI Macros control chart and pareto chart templates to give you automatic graphs of LOS performance. The ED log, for instance looks like this:


To simplify data entry we've built shortcut keys to help you input date and time data.

Watch demo now!

Download a 10-patient demo. Click Here!

If the date/time is earlier than a previous step, the cell will turn reddish-orange indicating that you have a data entry error (see Triage-before-Sign-in example above. The cell will also turn reddish-orange if you have an empty cell to complete before your data is ready for analysis.

These individual records are then summarized and presented as charts of key times:

  • sign-in to exam (door-to-doctor goal: 30 minutes)
  • bed ordered-to-floor (goal: 30 minutes)
  • pareto charts by doctor or floor to analyze differences.

There's also an ED Whiteboard to track times on all patients and their lab/xray results (Ordered/Complete).

Watch a demo of the ED Whiteboard now.

There are templates for:

  • ED Length of Stay
  • ED Whiteboard
  • Floor LOS (ICU/Tele/Med/Surg)
  • Bed Cleaning Times
  • Meal Delivery Times
  • Registration Wait Times

And, if you don't see what you want, we can build it for you. Because these templates are in Excel, you can tailor them to suit your needs or we can do it for you for a reasonable fee.

System Requirements: Microsoft Windows 2000-XP. Microsoft Excel 2000, XP and 2003

Watch demo now

The Complete Patient Throughput Length of Stay Time Tracking System is only $497 + $10 S&H (U.S.) It includes all of the templates and a user guide.

Download a 10-patient demo. Click Here!

Buy JCAHO Dashboard or LOS Time Tracking Templates Now JCAHO and NDNQI Dashboard


© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home | Lean Six Sigma | QI Macros | KnowWare | Site Map

Watch demo now

Download a 10-patient demo.

Download our FREE Health Care Length of Stay (LOS) Report!

Hospital Bed Management System

Time Tracking Templates for any Industry

Six Sigma Articles

FREE Lean Six Sigma Course
& QI Macros 30-day Trial
Name:
E-mail