Business Analyst Community & Resources | Modern Analyst

Business Analysis Templates & Aides

Recent Templates | Categories | Search | Subscribe (RSS)

Use Case Points - Excel Template and Tutorial for Project Estimation

Statistics: 48034 Views // 20 Comments //

Posted by: Scott Sehlhorst on Monday, August 25, 2008

Categories: Business Analysis Planning (BABOK KA), Requirements Analysis (BABOK KA), xxx> MS Excel, Estimation

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:

Technical Factors of the Implementation. Primarily non-functional requirements of the system.
Environmental Factors. Mostly characterizing the implementation team, but touching on process as well.
Use Case Quantity and Complexity. The number of use cases and the number of steps within the use cases.
Actor Quantity and Complexity. The number and type of actors and interface.
Effort Estimation. The previously collected data is converted into man-hours.
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!!

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.

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.

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

AL posted on Thursday, October 28, 2010 7:56 PM

Hi All,
Thanks very much, great things to share around.
Cheers,
Al

Ozgur Sahin posted on Saturday, December 18, 2010 5:49 AM

Thanks for your efford

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.

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 Devaraj posted on Saturday, May 7, 2011 12:39 AM

i am unable to download the estimation template...

Antoine AA posted on Tuesday, May 17, 2011 8:52 AM

Thank you

parthiban posted on Tuesday, October 4, 2011 12:55 AM

Very very good Thanks for providing as handy and quick tool to calculate efforts

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%

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!

Hrair posted on Wednesday, July 9, 2014 10:05 AM

I am unable to find the link to download this template. Thanks

Sudhakar posted on Monday, July 14, 2014 1:46 AM

Not able to download..

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