Simple Excel Dashboard to Monitor Test Progress
January 12, 2012 153 Comments
Not all projects have a big fancy test management system. More often than not a big dinosaur like QC would do more harm than anything else in a small project. Nevertheless, it’s important to be able to get a quick heads up how the test effort progresses.
The following Excel sheet, that I’ve put together, gives a graphical overview of the test progress and can be used as a temporary solution or in a small project.
Updated: I have added some features to the TestProgressManager.xlsm. You can read about it here
The dashboard presents stats about:
- Total number of test cases
- Planned/Executed test cases today and yesterday
- Tests/Execution status
- Execution status/Test type
- Execution status/Tester
- Test Status/priority
- Test progress over time – Planned, Actual and Trend
The information (that the dashboard is based on) is entered in the ‘Execution’ tab:
- Type of test (Functional, Integration, Regression, Automation, Perfomance),
- Tester – who is testing
- Priority – Low, Medium, High
- PLN. Comp Date – When you plan the test will be completed
- ACT. Start Date – The date you start executing the test
- ACT. Comp Date – When the test is completed
- Status – Not Executed, In Progress, Failed, Completed
The ‘Start Date’/’End Date’ of the test period and the name of the testers that will participate, can be easily defined with a macro.
If you want a copy, drop me a comment with your email address (not published).
(This sheet was created in MS Office 2010, so you will probably need the same to support all macros, graphs, etc…)