Spectral Analysis Chart – How to create one in Excel 2010

The lead time Spectral Analysis Chart, or lead time Histogram Chart is a very useful tool for visualizing and analyzing you process lead times. In this post I show you how you can create one in Microsoft Excel 2010.

Spectral Analysis Chart example

I’m using the same process data in this example as in the Control Chart example. There should be no problem to have both the Control Chart and the Spectral Analysis Chart in the same document. Step 1 through step 23 are therefore the same in both examples.

Let’s get started.

Continue reading

How to create a Cumulative Flow Diagram in Excel and TFS 2010

Cumulative Flow Diagrams (CFDs) are valuable tools for tracking and forecasting the performance of your processes. In this post I will show you how you can create a Cumulative Flow Diagram in Excel that fetches the data from Team Foundation Server 2010 (TFS 2010).

Update
As been pointed out on the KanbanDev mailing list by Daniel Vacanti the approach of counting items per process stage is a simplified way to construct CFDs. Daniel points in his book Actionable Agile Metrics for Predictability out that this approach only works when the following two conditions are satisfied:

  1. Work items are not moved backward in your workflow.
  2. Work items are never completely removed before they are completed.

Keep this in mind if you use this approach.

Result

In this example I ‘m using a modified MSF for Agile Software Development v5.0 template. I have added the following states to the User Story work item workflow:

  • Analysis
  • Analysis Done
  • Development
  • Development Done
  • Test
  • Deployed

Let’s get started.

Continue reading

Control Chart – How to create one in Excel 2010

Control Charts are an important tool for analyzing your process. In this post I show you how you can create a lead time Control Chart in Microsoft Excel 2010.

Important note
In this example the control limits are based on the standard deviation function in Excel. This may or may not be the correct way to calculate your control limits of your data

FormatedFeatureControlChart

Let’s get started.

Continue reading

Cumulative Flow Diagram – How to create one in Excel 2010

Cumulative Flow Diagrams (CFDs) are valuable tools for tracking and forecasting the performance of your processes. In this post I show you how you can create a simple Cumulative Flow Diagram in Microsoft Excel 2010.

Update
As been pointed out on the KanbanDev mailing list by Daniel Vacanti the approach of counting items per process stage is a simplified way to construct CFDs. Daniel points in his book Actionable Agile Metrics for Predictability out that this approach only works when the following two conditions are satisfied:

  1. Work items are not moved backward in your workflow.
  2. Work items are never completely removed before they are completed.

Keep this in mind if you use this approach.

CFDDone

Let’s get started.

Continue reading