What I did
- Writing and executing of tests
- Reporting problems in Jira
- Creating an automated spreadsheet to keep track of problems over time
I made an Excel workbook that scanned a spreadsheet exported from Jira and automatically generated metrics from it.
The spreadsheet has 3 builtin worksheets, and to use the spreadsheet exported from Jira it has to be imported as a worksheet first.
The overview worksheet looks as follows..
"Totals" here means the performance of the entire team, not any individual team member. In hindsight I think replacing "Total Bugs" here with "Open Bugs" and replacing "Open Bugs" with "Bugs Opened This Week" would make sense. This way ideally the "Open Bugs" would be decreasing even if the "Bugs Opened This Week" is increasing.
In the last week of the the project I finished an idea I had, namely the leaderboard. I shared an image in Slack, and it was well received by the team. Some people said that if was posted every week it would motivate them. However, due to this being completed in the last week it was too late to actually use it.
The other worksheets contain data used by the overview worksheet.
The individual effort worksheet looks as follows..
This worksheet contains the number of bugs closed and opened per week on the right and a summary on the left as well as the number of total bugs assigned, which isn't measured per week.
The overall effort worksheet looks as follows..
The fix rate here is the per week fix rate summarized on the overview worksheet.