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: 45778 Views // 20 Comments // Article Rating
Posted by: Scott 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

ElleSong posted on Saturday, January 17, 2009 4:34 PM
Thanks for ur sharing,very good resource!!
monopoly
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.
djl
BColpitts posted on Wednesday, July 15, 2009 2:47 PM
Yes, kuddos for this template. I also wish to thank you for sharing this.
BColpitts
Mohammad A.Khadeer 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.
MAK
Anonymous User 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
Anonymous
AL posted on Thursday, October 28, 2010 7:56 PM
Hi All,
Thanks very much, great things to share around.
Cheers,
Al
swanrou
Ozgur Sahin posted on Saturday, December 18, 2010 5:49 AM
Thanks for your efford
Theozgursahin
tony 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.
tonyslam
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
vikas.rao
rakeshtomar posted on Monday, March 7, 2011 2:34 AM
Thanks a lot for this excellent resource
rakeshtomar
Rajesh Devaraj posted on Saturday, May 7, 2011 12:39 AM
i am unable to download the estimation template...
rajesh_dr
Antoine AA posted on Tuesday, May 17, 2011 8:52 AM
Thank you
tony_arraj
parthiban posted on Tuesday, October 4, 2011 12:55 AM
Very very good Thanks for providing as handy and quick tool to calculate efforts
parthiban1975@gmail.com
Etienne 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%
EtienneVenter
Vara posted on Wednesday, May 15, 2013 7:56 AM
Excellent one!
Vara
Sateesh posted on Tuesday, March 18, 2014 3:13 PM
Thanks a lot!
Sateesh
Hrair posted on Wednesday, July 9, 2014 10:05 AM
I am unable to find the link to download this template. Thanks
hrair742
Sudhakar posted on Monday, July 14, 2014 1:46 AM
Not able to download..
sjadhav72
PortfolioManagerPro posted on Saturday, March 12, 2022 3:51 PM
Does anyone have a copy of this template that they can either post here, or send to me? The link to the tynerblaine.com site where the template was apparently hosted no longer exists.

Please help/share.

Thanks a million in advance!
Scott
PortfolioManagerPro
Adrian M. posted on Saturday, March 12, 2022 9:40 PM
Try downloading now.
adrian
Only registered users may post comments.

 



 




Copyright 2006-2022 by Modern Analyst Media LLC