I am, as a tester, totally with tools like JIRA. Those tools makes life much easier to maintain test cases. I have worked on projects where in one project we used to manage our test cases on Excel and on another we used Version1. We could easily differentiate in terms of speed of work. We had close to 2000 test cases for each product where we had automated 1700 test cases. We had to test close to 300 test cases manually. Below is my experience.
Experience with Excel:
- Maintenance is very cumbersome. (If you have copied same test case to different test suite, you will have to search same test cases on different test suite file in case of modification.)
- Tagging is difficult.(You literally have to copy test case if the same test case is used in different test suite.)
- Maintaining change of history is difficult. (With excel, it was difficult to track change in history. Mainly when tester missed to update the change history sheet.)
- Assigning test case is little difficult. (We have to modify name in each tester column in case of the tester is changed.)
- Measuring the matrix is difficult. (We had to go through each file to come up with numbers. Also, we had to have an intern to match numbers with master file.)
- Searching of test case was difficult.(If story changes and if test case happen to be changed or if we happen to search test case, it was really difficult. We had to first go through master file with list of test cases and then work on test case file.)
In case of tools like version one, what ever difficulties we had with Excel could easily be resolved. Also, V1 was accessible via various devices. So, it allowed us to mobilize. I was on a vacation and we had a new tester. He called me up as he had some doubt with test case and the regression was going on. I just logged into V1 through my tablet and explained him test case on the go. It was that easy.
I understand that its little complex system to learn. But, once we adapt it, it was breeze.
Let me know your views.