Free course library11 lessons · 4 topics

Using the Team Dashboard Spreadsheet

Use the free Team Dashboard spreadsheet to visualize flow, balance performance measures, and support better coaching conversations.

Team Dashboard Spreadsheet course cover

By Troy Magennis

Lesson 7 of 11 · Using the Spreadsheet

Work in Progress and Age Chart

Read daily work in progress by age band and configure warnings for sudden changes.

Lesson notes

The chart shows work that has started but is not complete, day by day, color-coded by age.

  • Lowest, Middle, and Largest set the age-band thresholds. For example, 1, 7, and 14 days create light gray, dark gray, yellow, and orange bands.
  • WIP Warning % marks a large day-over-day change with a red square above the WIP column.
  • Age Warning % marks a large increase in older yellow and orange items with a red circle.
Work in Progress and Age chart from the Team Dashboard spreadsheet
Settings for WIP age bands and warning percentages