Estimation is a big task and also tricky. In this template I have tried to break this task into steps. By following the steps the estimation process would be simple and also predictable.
At this moment the template is only for manual testing and the same will be update with automation also.
Please download the template from http://geocities.com/withrajeev/TestEstimateTemplate.xls
Snippet of the template found below
Sl.No | Parameters | Best Case | Worst Case | Possible |
1 | No. Of Test Modules | |||
2 | No.of Test Requirements | |||
3 | No. of test cases/requirement | |||
5 | Total number of test cases | 10 | ||
6 | % of complex1 test cases * | 50 | ||
6a | No.of complex1 test cases | 10 | #VALUE! | 0 |
7 | % of complex2 test cases * | 30 | ||
7a | No. of complex 2 test cases | 7.5 | 0 | 0 |
8 | No. of complex3 test cases * | 2 | 0 | 0 |
9 | No. of Test analyst | 3 | ||
10 | Test Analyst knowledge | |||
11 | No. of test cycles | |||
12 | Incident reporting and closing | |||
13 | % incident getting fixed | |||
14 | Test case overhead time | |||
15 | Test Case rework time/ cycle | |||
16 | Contigency factor | |||
Test Case development time | ||||
Test Case Execution time | ||||
*Complex 1 Weightage | 2 | Note: Test cases that need to be executed for n number of data can be clasified as Complex 1 |
||
*Complex 2 Weightage | 1.5 | |||
*Complex 3 weightage | 1 |
Advertisements
Hi Rajeev….Could you please send me the latest test estimation spreadsheet.
my mail id is prabu_sofwin@yahoo.com
Ur spreadsheet looks good
Hi Rajeev – It seems geocities is no more in existnace. Can you please forwared the updated test estimation model
hi,
please send test estimation templete.
i required once i have get the requirements
Hello Rajeev,
This is Nilesh from mumbai, would like to know more about test esteemation. The above link is down. Pls upload it again or could u plz send on my mail id:nileshw12@rediffmail.com
Thanks and Regards,
Nilesh
All,
I had not looked at the blog for a long time, I will update this section at the earliest.
Thanks,
Rajeev
Hi Rajeev,
It seems geocities is no more in existnace. Can you please forward the updated test estimation model
Please send me the Test Estimation Template to jaykisan@gmail.com
Thanks for sharing!!!
Ayreej
Qualitylabs.blogspot.com
Hi Ayreej,
Can you please forward the tempalte to me as well?
My id is praveenpmt@gmail.com.
Thanks in advance.
Hi,
Im trying download the test estimate template but the site is down. kindly send it to my email address: yemmie03@hotmail.com.
Thnaks
yemmie
Can you please forwared the updated test estimation model? Pls
Can you please share the xls template for Test case estimations?
arifa30august@gmail.com
Could you please share the knowledge with me regarding estimates and tracking against actuals.
karthikguna@gmail.com
hi rajiv,
your estimation template looks awesome but i wasn’t able to download as the site is down. can you please send me spreadsheet to anam34@lycos.com
i will appreciate if anyone else do me a favour by sending it as well.
thanks.
Can you please mail me the estimation sheet it looks very nice,It will be great help for me.
Please mail me th current estimation sheet it will be great help for me.
Could you please send the estimation template to my id – sandy.dgp@gmail.com
Thanks
Please send me the updated test case estimation template.
Could you please send me the ‘Test estimate template’. Link is broken
gandhe123@gmail.com
Thanks
swetha
Can you please share the xls template for Test case estimations?
Hi Rajeev….Could you please send me the latest test estimation spreadsheet.
Hi Rajeev….Could you please send me the latest test estimation spreadsheet.
nikepauls@yahoo.in
Hi Rajeev – this is Sandhya Kandru from Tampa,FL. I really liked the estimation tool that you have posted here as a snippet from the template.Can you please email me the spreadsheet in the xls format for me??
Thanks and regards – Sandhya
Hi Rajeev
Can you please send me this Test estimation template on amitchugh20005@gmail.com?
Hi All,
A copy of this template is uploaded in this location: http://www.box.net/shared/okpa9mbxg5tzi349uml8. Please download the same. I have recently working on Model based estimation and you can find this template also in this blog: https://jrajeev.wordpress.com/2011/06/22/model-based-estimation/. I request you all to check this and also leave your comments/suggestions on how we can improve and make estimation process simple.
Thanks,
Rajeev
Hi Rajeev,
Can You send me Test Estimation Sheet to grrajeish@yahoo.co.in, since geocities site is not available anymore.
Hello Rajeev, It looks like geo cities are no more hosting your data. Could you please send the latest estimation template to my email id kareemulla.shaik@gmail.com
Hello Rajeev,
your template is good, can you please share me the latest automation effort estimation template to sreekanth.peetla@gmail.com. thanks in advance.
Hi Rajeev do you have any Template for estimating the automation effort.