Business Analysis Templates & Aides


Recent Templates | Categories | Search | Subscribe (RSS)

Use Case Points - Excel Template and Tutorial for Project Estimation

Use Case Points - Excel Template and Tutorial for Project Estimation
Statistics: 43355 Views // 18 Comments // Article Rating
Posted by: sehlhorst on Monday, August 25, 2008

Estimating the amount of work required to deliver software is hard. Estimating the amount of work in the very early stages of a project is even harder. A method was developed to estimate the amount of work required by analyzing what the system will allow its users to do. That method is called Estimating With Use Case Points.

Introduction

The cost estimation technique of use case points evaluates the following factors to determine an estimate of cost:

  1. Technical Factors of the Implementation. Primarily non-functional requirements of the system.
  2. Environmental Factors. Mostly characterizing the implementation team, but touching on process as well.
  3. Use Case Quantity and Complexity. The number of use cases and the number of steps within the use cases.
  4. Actor Quantity and Complexity. The number and type of actors and interface.
  5. Effort Estimation. The previously collected data is converted into man-hours.
  6. Free Excel Spreadsheet for Calculating UCP. Download it today. Its free.

Author: Scott Sehlhorst

DOWNLOAD: You must be logged-on in order to download templates.

COMMENTS

monopoly posted on Saturday, January 17, 2009 4:34 PM
Thanks for ur sharing,very good resource!!
djl posted on Tuesday, May 19, 2009 4:52 PM
This template was exactly what I needed. With it, I was able to reply to and meet a specific customer need. Thank you very much for developing this template and sharing it with the rest of us.
BColpitts posted on Wednesday, July 15, 2009 2:47 PM
Yes, kuddos for this template. I also wish to thank you for sharing this.
MAK posted on Tuesday, May 25, 2010 2:43 AM
Good stuff, Thanks for sharing the template. As we all understand, any simple, consistent and workable methodology would help practitioners. If possible, please share one fully worked out example.
Anonymous posted on Tuesday, May 25, 2010 6:41 PM
Hello All,
Great template, but I was wondering if anyone has any resource that can supplement my understanding of how to rank each variable.

Also, In what scenarios, have u guys used the above template.

Thanks
Chapman MBA Grad
swanrou posted on Thursday, October 28, 2010 7:56 PM
Hi All,
Thanks very much, great things to share around.
Cheers,
Al
Theozgursahin posted on Saturday, December 18, 2010 5:49 AM
Thanks for your efford
tonyslam posted on Monday, January 24, 2011 12:45 PM
Thanks too for the effort. Am new to the working environments of ba and this sure helped.
vikas.rao posted on Tuesday, February 1, 2011 12:02 AM
Thanks a lot for this excellent resource. It is of outstanding help in early estimation. The supported links was very informative as well. If possible, can you please some information on multiplier and the calculations, how they have been derived.

Thanks
Regards
rakeshtomar posted on Monday, March 7, 2011 2:34 AM
Thanks a lot for this excellent resource
rajesh_dr posted on Saturday, May 7, 2011 12:39 AM
i am unable to download the estimation template...
tony_arraj posted on Tuesday, May 17, 2011 8:52 AM
Thank you
[email protected] posted on Tuesday, October 4, 2011 12:55 AM
Very very good Thanks for providing as handy and quick tool to calculate efforts
EtienneVenter posted on Wednesday, November 2, 2011 8:28 AM
Very good and thanks a lot. How does one apply the model to estimate the effort per phase of a project i.e. Inception, Elaboration, Construction & Transition? In our organization each CoE (centre of excellence) have to give an estimate for their part in the project i.e. Business Analysts vs. System Analysts vs. Architects vs. Developers vs. Testers etc. Is it possible and accurate to allocate a percentage per phase i.e.
Inception = 10%
Elaboration = 25%
Construction = 55%
Transition = 10%
Vara posted on Wednesday, May 15, 2013 7:56 AM
Excellent one!
Sateesh posted on Tuesday, March 18, 2014 3:13 PM
Thanks a lot!
hrair742 posted on Wednesday, July 9, 2014 10:05 AM
I am unable to find the link to download this template. Thanks
sjadhav72 posted on Monday, July 14, 2014 1:46 AM
Not able to download..
Only registered users may post comments.






Copyright 2006-2020 by Modern Analyst Media LLC