you're reading...
Test Methodology

Test Estimation Template

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

Discussion

24 thoughts on “Test Estimation Template

  1. Hi Rajeev….Could you please send me the latest test estimation spreadsheet.

    my mail id is prabu_sofwin@yahoo.com

    Ur spreadsheet looks good

    Posted by Prabhu | July 27, 2009, 7:23 pm
  2. Hi Rajeev – It seems geocities is no more in existnace. Can you please forwared the updated test estimation model

    Posted by Kartik | November 3, 2009, 6:01 pm
  3. hi,

    please send test estimation templete.
    i required once i have get the requirements

    Posted by krishna | December 8, 2009, 11:58 am
  4. 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

    Posted by Nilesh | December 16, 2009, 9:58 pm
  5. All,

    I had not looked at the blog for a long time, I will update this section at the earliest.

    Thanks,
    Rajeev

    Posted by jrajeev | January 16, 2010, 2:44 pm
  6. Hi Rajeev,
    It seems geocities is no more in existnace. Can you please forward the updated test estimation model

    Posted by NareN | January 28, 2010, 12:51 pm
  7. Please send me the Test Estimation Template to jaykisan@gmail.com

    Posted by SatyaKiran Watts | February 10, 2010, 10:36 am
  8. Thanks for sharing!!!

    Ayreej
    Qualitylabs.blogspot.com

    Posted by Ayreej Rahman | February 18, 2010, 12:27 pm
  9. 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

    Posted by yemmie | March 26, 2010, 3:44 pm
  10. Can you please forwared the updated test estimation model? Pls

    Posted by arifa | March 29, 2010, 7:40 pm
  11. Can you please share the xls template for Test case estimations?

    arifa30august@gmail.com

    Posted by arifa | March 29, 2010, 7:40 pm
  12. Could you please share the knowledge with me regarding estimates and tracking against actuals.
    karthikguna@gmail.com

    Posted by Karthik | May 3, 2010, 4:48 pm
  13. 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.

    Posted by tanim | June 10, 2010, 2:17 pm
  14. Can you please mail me the estimation sheet it looks very nice,It will be great help for me.

    Posted by Rahul | July 14, 2010, 6:55 pm
  15. Please mail me th current estimation sheet it will be great help for me.

    Posted by Rahul | July 14, 2010, 6:56 pm
  16. Could you please send the estimation template to my id – sandy.dgp@gmail.com

    Thanks

    Posted by sandip | August 4, 2010, 7:00 pm
  17. Please send me the updated test case estimation template.

    Posted by Shreya | October 12, 2010, 3:04 pm
  18. Could you please send me the ‘Test estimate template’. Link is broken
    gandhe123@gmail.com

    Thanks
    swetha

    Posted by swetha | December 19, 2010, 10:16 am
  19. Can you please share the xls template for Test case estimations?

    Posted by jayant naikwade | April 6, 2011, 7:36 pm
  20. Hi Rajeev….Could you please send me the latest test estimation spreadsheet.

    Posted by nike | April 13, 2011, 4:38 pm
  21. Hi Rajeev….Could you please send me the latest test estimation spreadsheet.
    nikepauls@yahoo.in

    Posted by nike | April 13, 2011, 4:45 pm
  22. 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

    Posted by sandhya nadella | May 26, 2011, 12:46 am
  23. Hi Rajeev

    Can you please send me this Test estimation template on amitchugh20005@gmail.com?

    Posted by Amit | June 1, 2011, 12:16 am
  24. 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

    Posted by jrajeev | June 22, 2011, 12:12 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog Stats

  • 15,928 hits
January 2009
M T W T F S S
    Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  
%d bloggers like this: