HTTPS SSH

AAMfP: a simple (Personal) Kanban metrics spreadsheet

Copyright © 2017, 2018, 2019 Marco Bresciani.

Creative Commons 
License AAMfP: a simple (Personal) Kanban metrics spreadsheet by Marco Bresciani is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Free Cultural
Works This is a freely licensed work, as explained in the Definition of Free Cultural Works.

Feel free to open an issue for bugs, enhancements, proposals or tasks following the Contributor Covenant Code of Conduct. For further questions or requests, let's keep in touch:

Kanban One is an online tool with the features of this spreadsheet.


Download

Current version is v.13.0.0 'GSB84'. See Downloads.

For versions history see the Changelog file.


Intro

Improve your daily workflow with this LibreOffice Calc spreadsheet using the concepts of Personal Kanban and applying some flow metrics as described in the book Actionable Agile Metrics for Predictability (and compatible with Actionable Agile™ Analytics tool).

Visualize your work

The project also contains contains PDF and ODG (LibreOffice Draw) versions of an A3 format printable Personal Kanban board with Backlog, Next, In-progress and Done columns. Feel free to use it to visualize your work items!

This Kanban board uses Unifont by Unifoundry for text purposes. Copyright (C) 1998-2018 Roman Czyborra, Paul Hardy, Qianqian Fang, Andrew Miller, Johnnie Weaver, David Corbett, et al. License GPLv2+: GNU GPL version 2 or later <http://gnu.org/licenses/gpl.html> with the GNU Font Embedding Exception.

Limit your work-in-progress

Remember to add your WIP limit to each of the columns in the board above, to be sure to properly apply Kanban concepts and obtain real improvements.


Usage

Complete, detailed usage instructions and data explanations can be found in the Usage file.

Briefly: the only sheet you need to work on is the WorkItems sheet where you need to add, for each work item, the dates when such work items have changed state. CoS (Class of Service) and WIT (Work Item Type) column values are not mandatory.

Please note that WorkItems sheet already contains some data. Those are example data to show you how to use and write them. Feel free to remove them.

While bug #6 is open, when a work item has to be dropped/cancelled/abandoned/… for any reason, you have to write such cancellation date in all remaining columns cells and also write the same date in the Deleted column. With this, the work item will be properly identified as deleted.

In order to have correct metrics, chart, and data you have to keep the Workitems sheet rows in the correct order. Specifically, select the table and apply the following sorting criteria (all crescent order): Done, In-progress, Next, Deadline, Backlog, ID. Once the columns are ordered in this way, you can scroll all other sheets where you can find the metrics and charts properly computed and rendered.

Deadline column value is optional and the content is automatically and conditionally formatted. Deadline is: * today, red cell; * this week, orange cell; * this month, yellow cell; * next month, green cell. * expired completed activity, red text.

The whole WorkItems sheet is compatible with Actionable Agile™ Analytics tool (see Format for Data File): simply export WorkItems sheet as CSV (select comma (,) as cell separator and quotes (") for fields) and then import it in the tool.


References

For Kanban method starts from here: What is Kanban | Lean Kanban and the Essential Kanban Condensed Guide.

For Personal Kanban starts from here: Map your work, control your life: Personal Kanban and Personal Kanban: The Book | Personal Kanban.

For more details and explanations on metrics please see the book Actionable Agile Metrics for Predictability by Vacanti, Daniel S..

Kanban One is an online tool with the features of this spreadsheet.

Thanks

Thanks to (in appearing order):


Copyright © 2017, 2018, 2019 Marco Bresciani.

Creative Commons 
License AAMfP: a simple (Personal) Kanban metrics spreadsheet by Marco Bresciani is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Free Cultural
Works This is a freely licensed work, as explained in the Definition of Free Cultural Works.