Step-by-Step Demonstration: Run Chart Tools (Excel Templates) - PowerPoint PPT Presentation

Loading...

PPT – Step-by-Step Demonstration: Run Chart Tools (Excel Templates) PowerPoint presentation | free to download - id: 6e12f2-ZjBiN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Step-by-Step Demonstration: Run Chart Tools (Excel Templates)

Description:

Step-by-Step Demonstration: Run Chart Tools (Excel Templates) * How to set up Excel to optimally work with run chart files that have built-in macros. – PowerPoint PPT presentation

Number of Views:14
Avg rating:3.0/5.0
Slides: 19
Provided by: NAPHS
Learn more at: http://2c4xez132caw2w3cpr1il98fssf.wpengine.netdna-cdn.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Step-by-Step Demonstration: Run Chart Tools (Excel Templates)


1
Step-by-Step Demonstration Run Chart Tools
(Excel Templates)
1
2
How to set up Excel to optimally work with run
chart files that have built-in macros.
  1. You may see this when you open the file. Because
    it has macros, you get this security warning,
    please enable the content.
  2. Click yes to proceed in using the tool.
  1. If the excel file, still does not open up
    appropriately, it may be due to a macro security
    level setting. See next slide for ways to set up
    your Excel program to address this. If this does
    not fix the issue, please contact your hospitals
    IS department for assistance.

2
3
How to set up Excel to optimally work with run
chart files that have built-in macros.
  1. Find the place on your version of Excel where you
    can adjust the macro security level (Excel 2010
    shown here).
  2. Be sure macro settings look like this.
  3. When you open the file, enable macros.
  4. If you have an older version of Excel, you may
    need to lower the macro security by one level to
    allow the file to open successfully. Check your
    help button to find out how to do this on various
    Excel versions. If this does not work, please
    contact your hospitals local IS department for
    assistance.

3
4
Orientation to Run Chart Tools Three Tabs
4
5
Step 1 Clear data entries in sample template.
Save with new name on your own computer.
Automatically clears here
ORbe careful if want to save month/year labels.
You need to manually clear all other white fields.
and
and
5
6
Step 2 Edit the titles and legends fields as
suggested in sample template.
Type in your edits to best reflect the metric
specifics for your improvement project (note
ratio multiplier in cell E8).
6
7
Step 3 Select whether you are entering
numerators (preferred) or final rate values. This
will automatically alter other fields.
7
8
Step 4 Edit ratio multiplier (10, 100, 1000) as
applicable to metric.
8
9
Step 5 Enter in timeframes (dates, months,
years) and reformat as applicable.
9
10
Step 6 Enter numerators and denominators (or
just rates if using final values in column C).
10
11
Step 7 Select if you want denominators on
X-axis (a preferred display).
11
12
Step 8 Select if you want a goal line on graph
(preferred display) and value(s) for the goal.
For this example one may want to set the goal
to half of current rate, so enter in 3.3
3.3
Performance has been improving below goal the
last 4 mos, so decide to reset the goal to half
of current rate, so enter in 1.8
1.8
12
13
Step 9 Click on the Run Chart tab to see if
the display makes sense. Edit font sizes as
needed -OR- return to 1st line tab to edit
title / axis / legend fields.
13
14
Step 10 Edit / add annotations to run chart.
14
15
Step 11 Return to 1st Line tab to mark which
dates / data represent your baseline timeframe.
15
16
Step 12 Return to Run Chart tab. Use run
chart rules to identify special cause variation.
Readjust median line as applicable.
16
17
Step 13 Return to 1st Line tab to mark what
dates / data represent the start of your 2nd
median line.
17
18
Step 14 Return to Run Chart tab and use run
chart rules to identify special cause variation.
Readjust the median line as applicable.
18
About PowerShow.com