I have got a request to Identify the dates (duration) where there are no tasks planned in the schedule.
Scenario: In a duration of 1 year project, there could be few instances that no tasks planned in a span of couple of days.
I want to find the dates where are no tasks planned/scheduled.
There may be better ways, but a quick and dirty way is 1) save the file to a new name. 2) Open the Resource Name column and at the first task in your schedule assign a resource named “Resource”. 3) Fill down the entire schedule to the las task with this resource. 4) Now go to the Resource Usage view and set it to Days in the time scale. You can scroll through the complete timeframe of the schedule and see if there are any days when the resource named Resource is not assigned – those days have no tasks assigned.
Roy, great suggestion that made me think. I love to figure out cool ways to solve unique issues. Here’s another way that might be a bit easier. Select every task in your project (multiple easy way of doing this) and select the Task Information option (Shift+F2 is the shortcut). Under the General tab, select the checkbox for Rollup. This will roll all Gantt bars to the project summary task (make sure you are showing the project summary task). This will show you all gaps between tasks. Hope this helps…
I work in schedules of 1500 lines or so and perform this analysis regularly. I have found the easiest way to do this is to view the Gannt chart on the right and have the timescale set to an interval level of daily. Then, with Show All Tasks, you can easily do a visual. If you have sequenced your tasks correctly as a waterfall, you can readily identify days where no work has been determined. I once found a two week gap that was not identified by reviewing the schedule any other way. Good luck!
Gaps in the schedule are gaps in the Critical Path of the schedule. We have a tool, called Complete Critical Paths, that displays the most Critical Path in your schedule and its gaps and it also explains why those gaps are there allowing you to remove some gaps and optimize your schedule immediately. If you would like to find more about it, please visit http://www.projectprocorp.com
Hope this helps!
Roy and Larry
Both the sugestions have worked out for me. Thanks for your quick reply.