John Seddon - Vanguard Consulting Vanguard Logo
Home
Online Charts
Create Online Chart
CapChart
Want to create a chart?  
Importing Data from Paper  
Creating a Chart from Scratch
Asking Better Questions  
Splitting the Data  
Special Causes  
Saving Views  
CapChart Help
Getting Started  
Charts  
Views  
Excel Data  
Access Database  
Filters  
Options  
Remove Points  
Including Points  
Splitting Charts  
Annotation  
Chart Zoom  
Scaling  
Import Data  
Glossary  
Menus  
Groups  
Moving Views  
Download
Product Key
Register
Login
Purchase
 
Want to create a chart?

Existing data held in Excel or Access can be viewed, analysed, questioned and manipulated through CapChart while the original data remains unchanged. Excel templates are provided for occasions when you have no data or it is held on paper.

Data from access or excel into capchart
The capability chart below illustrates how long, from a tenant’s point of view, it took a housing association to make repairs.
Total Elapsed Time Chart -Vanguard CapChart

The data was taken from an Access database and imported into CapChart. To reflect the elapsed time from the customer’s point of view, an Access database was used to link together different works orders that the housing association counted as separate jobs that were, in fact, the same piece of work from the customer’s perspective. For example, if a tree has fallen down in a storm through your kitchen window, the clock does not stop until the damaged sink has been replaced and plumbed in, the tiles have been replaced, the walls painted, and the window re-glazed. This is one job, from the customer’s point of view, not five.

Once the jobs had been linked to reflect the customer’s view of the work, Access was used to calculate a daily average end-to-end time, over time. The data was imported into CapChart, and the capability chart was generated.

For more information about taking a systems view of a ‘break-fix’ system (such as housing repairs), see Chapter 5, The ‘break-fix’ archetype, in Freedom from Command and Control.