Hi all,

I'm trying to come up with a solution for a problem I have at work.

I work in a QA environment, and have a team of testers that I allocate projects to test and run.

These projects testing and run times vary case by case. Some might request substantial testing due to the complexity of the project, with shorter run times. Other projects might have simplistic testing but huge run times.

I want to be able to list a selection of current projects being worked on, giving me a total time of testing and a total run time. I want to be able to manually input the project test and run times in (as I mentioned previously, they vary).

From here I want to be able to have a pool of testers available, that I can add to a project, either the testing or the run through’s to shorten the overall duration.

For example: Project A has a testing time of 10 hours, and a run time of 15 hours. So assigning one tester to this project will take them 25 hours to complete. If however, I assign another tester to the run through, and have the first test work just on the testing, the test time is reduced with Tester A taking 10 hours to complete the testing and Tester B taking 15 hours to finish the run through.

Now if I add further testers to each of these test types, it'll reduce the duration even further.

In addition to this I'd like these results to be reflected in a chart, showing the project title, the test type (testing or run through), the number of testers assigned to each test type, and finally the ETA for completion.

I want to use excel for this as I feel it handles data well.

I've dabbled with Pivot tables, but can't really see it working the way i need (although I may just be using them incorrectly).

I also thought about using VBA, but wouldn't know where to start really or how flexible it can be. I've done a few bits using VBA in the past, but I'm far from proficient with it.

Any pointers, advice or kicks in the right direction would be fantastic!

Thanks all

Adam