Dashboard Topic: Demo of an Excel Dashboard for Hospital Bed Management.

Strategic management of hospital beds has become a high-pressure requirement in today’s world of health care facilities needing to do more with less resources. Like it or not, hospitals make money by determining the “right” kind of patients, procedures and getting the occupany and turn-over rates right. Yes, it seems cold-hearted, but strategic management of resources such as beds is what drives the profitability of health-care facilities.

Now, in defense of hospitals, I recently had the experience of bringing someone with an arm injury to the emergency room. This person was concerned because of her lack of health insurance. While checking in, however, the nurse and the admissions clerk both, in separate conversations, reassured us that they do not turn away people who need care. In fact they pointed out a sign posted in a prominent location that they do not turn away people because of an inability to pay.

Now, back to excel dashboards. Today we have the opportunity not only to look at screenshots of an excel dashboard for the management of hospital bed metrics, but, thanks to qimacros.com, you can actually download a working Excel worksheet for use as a hospital bed management dashboard system. Here is a screengrab of the goals and objectives of their bed dashboard system. I screen captured this page from their bed management demo video:

The following excel dashboard screenshots and links are from the qimacros bed management page.

First off, let’s download (right-click and “save target as”) the hospital bed management excel dashboard itself. You’ll see that it has 3 tabs: Patient Census, Hospital, and Bed Management Statistics.

Here is a look at the bed status dashboard:

Bed statuses are color coded and can have values such as Occupied, Available, Assigned, Discharge Ordered, Likely, Pending or Transfer, Cleaning, No Staff or Not in Service.

The census screen looks like this:

The bed statistics page of this excel dashboard looks like the following:

Of course, since this is an excel spreadsheet, you can visualize the bed management metrics with graphs such as this:

Be sure to download the excel spreadsheet.

Finally, here is a picture of what we are looking to replace - a whiteboard used in a hospital hallway to manage bed statuses. Think of it this way, when the head nurse erases a status from that board, it goes away forever. Why struggle with trying to recreate it for analysis from your admission records. Capture it and use it right away with an enterprise dashboard.

Tags: Hospital Dashboard, Bed Management Dashboards, Excel Dashboard Example, Hospital KPI and Metrics, Enterprise Dashboards,

Excel Dashboard

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

One Response to “Excel Dashboard for Hospital Bed Management”

1. Dashboard Recap - Recent Screenshots Sept 13 2007 » Executive Dashboards Said on September 13th, 2007 at 12:23 pm quote

   [...] Hospital Bed Management Dashboard System with Excel Dashboard Download: [...]

Leave a Reply

Last Modified: Thursday, September 13th, 2007 @ 11:56

This business intelligence dashboard blog entry was posted on Thursday, September 13th, 2007 at 11:51 am and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

• Hospital Bed Occupancy Management Enterprise Dashboard circa 2001
...
• Hospital Bed Management Dashboard - Screenshots from bio-terrorism drill
...
• Hospital Performance Measures and Improvement Process Metrics
...
• A Good Primer on Hospital Workflows and Metrics
...
• Hospital Management Dashboard - Scorecard KPIs and patient profitability graphs
...
• Hospital Performance Scorecard - using enterprise dashboards to track health care KPIs
...
• Medical Practice Health KPI Enterprise Dashboard
...
• Business Intelligence Dashboard Search Terms
...

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?

Recently Posted

• Excel Infographics
• iDashboards Winter Olympics Dashboard
• Go Back to School for Excel
• 7 Ways to Remain Relevant for Business Intelligence in 2010
• Dashboard Data Table Navigation
• Dashboard Metrics Status Indicators
• Communicating Through Business Dashboards
• Building a Flex Dashboard
• Retail Store Scorecard
• Google Analytics Marketing Dashboard