UPDATED: Simple Excel Dashboard to Monitor Test Progress
October 3, 2012 39 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.
Would love a copy please!
Thanks for sharing!
Pingback: Simple Excel Dashboard to Monitor Test Progress « QA STUFF
Can send to me acopy please
Thanks
Please send a copy
Would love a copy as well!
Hi Carl,
Thanks for sharing that tool; could you please send me a copy? I’d like to see if I can use it for my tests follow-up…
Looks fantastic – can I have a copy please
I’d love a copy too please
Please forward a copy
I would love a copy
It is nice one. Please send me a copy : thanongchair@gmail.com
Nice article, can you send me the dashboard please.
Thanks
Great, would love a copy! Many thanks!
Very nice, Please send me a copy
Looks cool! Can you please forward me a copy too? crores40y2k@gmail.com
This looks awesome! If you are willing to share, please send a copy also for me. Thanks!
Please send me a copy
Hi Carl-Johann,
Would you send me on this excel spreadsheet please?
It looks fantastic and I really think it would be extremely beneficial to my project.. and save me a big headache too!
I really like this. can you pls send the copy
Thanks for sharing! I’d love a copy.
Can you please send me a copy top
Can I please get a copy? Many Many thanks! Zeo01@hotmail.com
Would like a copy please, thanks.
Nice, would love a copy please!
my email id is aamer.247@gmail.com
Thanks in advance!
It looks great!
Please send me a copy as well.
thank you for the nice work!
Please send me a copy.
Thanks in advance.
Hi Carl,
Can you share me a copy.. Thanks in advance.. rajapages@hotmail.com
Very nice… can u please send me a copy tooo….
Hi Carl, this will be a very useful dashboard for my project. Will greatly appreciate if you could share a copy of the excel. Thanks in advance
Its very nice. Could you please send me a copy too?
It is very nice. can you please send me a copy
It looks very useful. Could I please have a copy? Many thanks.
Hi this looks perfect as a low-tech alternative and would suit my needs perfectly – could you send me a copy please.
Great dashboord, Could you please send me a copy? ro.mrs07@yahoo.co.id
hey looks cool.. pls share me a copy krishykool@gmail.com
Hi Carl,
Very good job!
It will be vey kind of you to share a copy of the excel.
Thanks in advance
Jean Luc.
jbiljbil@hotmail.com
Thank you for sharing. May I receive a copy at businessintegrator@cox.net? Thanks in advance. Neo
Execellent job!!!! could you send me a copy.
Very useful dashboard, can you please send me a copy at wbistest@yahoo.ca , thanks in advance