Hacky python script to generate metrics for Kanban board using physical cards. Expects an .xlsx spreadsheet with the started and finished dates for the your cards.
Spits out average cycle time data and a couple of useful charts (in .pdf format).
-
Must be names carddata.xlsx and must be placed alongside kanbancardmetrics.py script
-
Data must be on first sheet and must have the following columns:
- ID - a unique card ID
- Started - Date that work on card was started
- Finished - Date that work on card as finished
- Type - Type of card "Story", "Technical" etc etc
All other columns are ignored
Requires Python 3.5 or greater
pip install -r requirements.txt
python kanbancardmetrics.py
Stats will be dumped to console and two .pdfs charts will be generated