Use Case Points - Excel Template and Tutorial for Project Estimation > Business Analyst Community & Resources | Modern Analyst > Business Analysis Templates for the Business Analyst

Recent Templates | | Search | Subscribe (RSS)

» Use Case Points - Excel Template and Tutorial for Project Estimation

Statistics:

(19617 Views) (15 Comments)
Posted by: 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

By monopoly @ Saturday, January 17, 2009 4:34 PM

Thanks for ur sharing,very good resource!!

By djl @ 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.

By BColpitts @ Wednesday, July 15, 2009 2:47 PM

Yes, kuddos for this template. I also wish to thank you for sharing this.

By shakti123 @ Wednesday, May 05, 2010 7:11 AM

Thanks for the stunning post. I like that. www.designingtips.com for new business templates.

By MAK @ 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.

By Anonymous @ 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

By swanrou @ Thursday, October 28, 2010 7:56 PM

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

By Theozgursahin @ Saturday, December 18, 2010 5:49 AM

Thanks for your efford

By tonyslam @ Monday, January 24, 2011 12:45 PM

Thanks too for the effort. Am new to the working environments of ba and this sure helped.

By vikas.rao @ Tuesday, February 01, 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

By rakeshtomar @ Monday, March 07, 2011 2:34 AM

Thanks a lot for this excellent resource

By rajesh_dr @ Saturday, May 07, 2011 12:39 AM

i am unable to download the estimation template...

By tony_arraj @ Tuesday, May 17, 2011 8:52 AM

Thank you

By parthiban1975@gmail.com @ Tuesday, October 04, 2011 12:55 AM

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

By EtienneVenter @ Wednesday, November 02, 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%

Only registered users may post comments.

Join the Premier Community for
Business Analysts, Business Process Professionals,
Systems Analysts, Data Analysts, and more…

Business Analysis Templates & Aides for the Business Analyst

Join the Premier Community for Business Analysts, Business Process Professionals, Systems Analysts, Data Analysts, and more…

Business Analysis Templates & Aides for the Business Analyst

Join the Premier Community for
Business Analysts, Business Process Professionals,
Systems Analysts, Data Analysts, and more…