Project Management

Please login or join to subscribe to this thread

Tool to auto-evaluate Start and End date from estimated hours

linkedin twitter facebook   Estimating  
Guys,

i frequently give you project plans done i excel with columns estimated hrs, start date, end date. After the developer estimate the task, and keep a kick off start date of the project in mind we spend 3-4 hrs just to evaluates manually the start and end date of each task considering weekend, public holidays in mind.

I have access to MS project also, but not i am new to it.

My questions is , is there any tool in which i can enter the task, estimate and project kick off start date and it evaluates the start and end date,time line of each task keeping in mind
a. weekends
b. public holidays
c. make sure that every week is fully utilizing 40 hrs adjusting 1 40 hr task or several tasks which sum up to 40 hrs.

thanks
Sort By:
avatar
Drew Craig Sr. Agile & Product Coach| Vanguard Philadelphia, Pa, United States
Sameer,

Yes, in MS Project, tasks are maintainted through dependencies. You can set predecessors and successors using logical relationships - SS, SF, FF, FS.

By doing so, tasks are automatically managed through tracking the dependent tasks start and finish in conjunction with the original estimated duration.

Additionally, MS Project has built in calendars to manage working times. It also has the ability to modify as needed. In short, MS Project, will automatically take into account working hours (9-5), weekends, and hoiday's when scheduling tasks.

Hope that helps.

References:
avatar
Drew Craig Sr. Agile & Product Coach| Vanguard Philadelphia, Pa, United States
^ Continued:
BrightHubPM
Izenbridge - Saket is an active member here

These are just quick examples I grabbed - there are many out there.
Thanks a lot Andrew!
avatar
Deepa Kalangi Manager, Program Management, Author, Trainer| CVS Health Charlotte, NC, United States
Sameer

This can be easily done in MS Project. Just go to tools and tell the options to exclude holidays and weekends. If you play with the tool just for a few minutes you will easily understand how it calculates the end times for a task. Also, dependencies, predecessors are the ones that will help the tool determine the start date of the subsequent task( FS is the most common one used). There are many youtube videos(I am sure) or articles out there to learn how we do it. Good luck!!
avatar
Sonali Malu Maharashtra, India
MS Project is perfect for your need. You can find good tutorials of MS Project online and start using it.

Please login or join to reply

Content ID:
ADVERTISEMENTS

"I only hope that we never lose sight of one thing - that it was all started by a mouse."

- Walt Disney

ADVERTISEMENT

Sponsors