Simple Excel Dashboard to Monitor Test Progress

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

Dashboard

 

 

 

 

 

 

 

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

Test Cases

 

 

 

 

 

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.

Setup

 

 

 

 

 

 

You may download a copy of the new version here: TestProgressManager

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…)

About these ads