Are You Struggling to Create Scorecards and Dashboards for Your Core Measures?

home · products · services · search · view cart · contact  
 
  NAVIGATION        
 
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar

2253 S. Oneida
Ste 3D
Denver, CO 80224

We help people think!

Copyright © 2009



  color coded excel scorecard

In September 2006, the Aberdeen Group published their Lean Six Sigma Benchmark Report. One of their five recommendations for action was to "integrate data collection with analysis." That's what scorecards and dashboards do! Just enter your data and the color-coded scorecards and graphical dashboards are created automagically!

It's easy to create dashboards and scorecards using our Fill-in-the-Blanks Scorecard and Dashboard System. These system consist of four parts:

  • A place to describe your measures. You can choose from 10, 20 and 30 measure systems.
  • A place to enter your results
  • A color-coded (green, yellow, red -- good, poor, bad) scorecard that shows how well you're performing
  • A control chart for each measurement that shows actual performance as a graph.

Best of all, they are less than $50 per measure.
Download the User Guide! Click Here!
Download a 2-Metric Demo! Click Here!

Add 10 Measure Dashboard download (#W941) $397

Add 20 Measure Dashboard download (#W942) $697

Add 30 Measure Dashboard download (#W943) $997

 

Measurement Dashboards

It's easy to use Microsoft Excel to create measurement dashboards and scorecards customized to your needs using our fill-in-the-blanks systems.

Describe Your Measures
The first step is to describe your measurements. Most measurements consist of two things:

  • A Numerator (the number on top)
  • A Denominator (the divisor)

Simply describe each measure and the numerator and denominator (denominators are optional), and the rest of the system will automatically populate these values to the data entry, scorecard and dashboard sheets.

Here's what the entry form looks like:

excel dashboard scorecard input sheet

Data Entry Sheet
You can then start entering data into the data entry sheet. It has space for up to 24 months, 24 weeks, 24 days, or whatever time period you desire.

excel dashboard scorecard data entry sheet

These values are automatically converted in to measures and shown on the scorecards and dashboard charts.

Color Coded Scorecards visually report the status of your metrics.

Again in the "Describe Your Measures" sheet, enter the target or goal for each measure and indicate the thresholds for yellow, red or even purple (good).

color coded excel scorecard

These thresholds are used to display the good, bad and the ugly on your scorecards (example of a hospital dashboard is shown below). The yellow and red (bad and ugly) enables immediate action by the leadership team.

color coded excel scorecard

Control Charts
For better analysis of process performance, the system creates Xbar (i.e., average) control charts of your data automatically from the scorecard.

Add 10 Measure Dashboard download (#W941) $397

Add 20 Measure Dashboard download (#W942) $697

Add 30 Measure Dashboard download (#W943) $997

 

 

 

Download
FREE
30-Day Trial



QI Macros SPC Software for Excel

Or Buy It Now
for only $139!
Unconditional
90-Day
Money-Back
Guarantee

Add QI Macros Starter Kit - SPC Software plus training CD and tools book (#275) $197 plus S&H
Add SPC Simplified System - SPC Simplified Book and DVD, Plus SPC Software, Training Cd and Tools Example Book (#285) $297 plus S&H


 

 
home | products | services | search | sitemap | Shopping cart view cart | contact
QI Macros | Excel SPC Software | SPC Software Free Trial
Control Charts | c Chart | np Chart | p Chart | u Chart
ImR Chart | XmR Chart | XMedianR Chart | XbarR Chart | XbarS Chart | EWMA Chart
Anom Chart | Cusum Chart | Levey Jennings Chart | Moving Average Chart
Histograms | Pareto Chart | Scatter Plot | Run Chart
Box Whisker Plot | Dot Plot | Multivari Chart

Lean Six Sigma Training | Lean Six Sigma Training Denver
Lean Six Sigma Consulting | Lean Six Sigma Consulting Denver
Lean Six Sigma Training Systems | Do-It-Yourself Lean Six Sigma Training