Excel-based Kanban board, issue tracking, and analytics
Rather than spread across several workbooks, the goal is to have as much as possible for a project available within one workbook.
You can download this and earlier versions on the releases page or you can clone this repo to your machine.
The green, red, and blue tabs are the ones where you can do data entry.
The purple tabs are intended to be read-only.
The orange tabs are charts.
Get started by adding your WIP limits and project code in the settings sheet (hidden by default)
Some of the contents of this repository is from FocusObjective's excellent spreadsheets. Those components are work licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Otherwise, the rest are a US Government work, with a Creative Commons 0 license
- 2017-03-31 : Added cycle time calculations to the dashboard and assorted bug fixes in the Weekly Summary and Forecasting sheets.
- 2017-03-27 : Fixed the erroneous throughput calculations on the dashboard and fixed backlog, forecasting, and incomplete calculations that were hard-coded project code-dependent.
- 2017-03-21 : Fixed the erroneous WIP count when tasks are aborted.
- 2017-03-20 : Fixed the "external linking" error.
- 2017-03-17 : Added support for aborting tasks. Renamed "Board" to "Tracking Data." Thanks to @spoonstein for the feedback.
- 2017-03-17 : Added version and version label. Created 1.0 release.
- 2017-03-16 : First commit