UPDATED: Simple Excel Dashboard to Monitor Test Progress
October 3, 2012 40 Comments
A while ago I posted an Excel-sheet that I have been using to manage the test case execution. I have recently done some updates that I like to share:
- Tab ‘EXECUTION’: It is now possible to also enter Defects: BugId/TestRef; Status; Priority; Open Date; Close Date; Description/Comments
- Tab ‘STATISTICS: The Stats on Defects are displayed in 5 graphs: Recent Defects; Defect/Status; Defects/Priority; Time to Close Defects; Invalid/Rejected
- Tab ‘STATISTICS’: You can define Thresholds for the Test Progress trend. Based on the thresholds a Green, Amber or Red symbol is displayed to indicate “Overall Test Progress”
- Tab ‘RESOURCES’: I’ve added a tab where you can enter some parameters to make a basic test resource estimation
Refer to the old sheet for a more detailed description. You may download a copy here: TestProgressManager In return, please drop me comment and tell me how you like it it and if there are anything that could be improved.
The Excel sheet has been created in MS Office 2010. Earlier versions may not support all formulas and graphs.