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 Saving Changes...
Sort By:
Drew CraigSr. Agile & Product Coach| VanguardPhiladelphia, 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:
Saving Changes...
Drew CraigSr. Agile & Product Coach| VanguardPhiladelphia, Pa, United States
These are just quick examples I grabbed - there are many out there. Saving Changes...
Thanks a lot Andrew! Saving Changes...
Deepa KalangiManager, Program Management, Author, Trainer| CVS HealthCharlotte, 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!! Saving Changes...