What are the best excel templates available online for effort estimation for web applications, rather i can say the best tools used for the said purpose.
Some Excel spreadsheets that support the estimation technique development effort estimation of Web applications are:
- UCPA - Project Datails http://liemur.com/Articles/UseCasePointEstimation.html
- Project Estimation using Use Case Metrics http://www.sparxsystems.com.au/resources/ucmetrics.html
- UseCasePoints.xls http://tynerblain.com/blog/2007/02/20/software-cost-estimation-ucp-7/
I hope you are useful.
Dear Ariel Adolfo Rodriguez Hernandez,
I am very much thankful for your prompt response.. i hope that the support will continue in future as well..
What development model are you going to use for the development? Agile vs Waterfall or Custom?
Dear Anubhav Agarwal
this will be customized rather hybrid one. but the spice of Waterfall will be there... i am cosidering use cases in the development framwork......
In that case, I would suggest you to use an iterative process for estimation. I do not have any such template but I could add my 2-cents here:
Create each use-case in three categories:
1. The presentation layer
2. The controller layer
3. The database layer
also, called the MVC layers.
Try to create each use-case as atomic as possible. Eg: User should be redirected to Registration Page after clicking on the 'Register Now' link.
If you are able to make/think each use-case as atomic as possible you should be able to provide better estimates. The best part in following an iterative process is that you would know that your estimates are wrong at a very early stage.
Try to follow this to break you use-case: https://en.wikipedia.org/wiki/INVEST_(mnemonic)
For the template have the following columns:
Sr. No, Use Case, Description, Complexity, Hours, Remarks
Use Case column should be contain one liner only and it should be easily say what you want to achieve, without going into too much details. Eg: As a website user, I should be able to see my profile page
Description column should contain more detailed analysis, add whatever is necessary to finish this task/use-case. Add all technical aspects in this column.
Complexity column should say how complex this use-case is in terms of development (Low, Medium, High).
Hours column should say man-hours required to implement this use-case
If you analyze your use-case properly and add details in Description column with correct intent then your estimates would be more realistic.
However, the link shared above by Ariel Adolfo Rodriguez Hernandez are a good starting point.
Dear Anubhav Agarwal,
i hope you will be fine.
it again my pleasure to put my kind words before you, i am really and extramly for the support and concern you expressed... i respect you seat and honor.. i request you if you have access to the data set somewr and have no restriction in foarwarding.. it would be my pleasure... like my development statistics to corelate my data..
thanks a lot
with regards
syed moshin
Hi Syed,
Unfortunately, I cannot share any data as the IP is not mine.
However, as I mentioned before, break your use-cases into smaller chunks and then estimates.
Here is an example:
http://www.scrum-institute.org/The_Scrum_Product_Backlog.php
- Badges
- Science topic