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 work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011



  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!

One book about dashboards estimates the cost of a typical dashboard as follows:

Dashboard Software $50,000
Other required software

$40,000

Annual maintenance $18,000
Implementation costs $110,000
Total Cost $218,000
   
Expected Annual Benefit from Dashboard (18 month payback) $140,000

Obviously, dashboards can be very expensive, but they don't need to be. Our 10-20-30 measure dashboards are very affordable and we can even help you get them going for a small fee.

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

 

 

 

Try QI Macros
FREE
For 30-Days


Or Buy It Now!

Unconditional
90-Day
Money-Back
Guarantee


 

 
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