![]() If you haven’t already, please go and download it using the button below: Any tasks or subtasks which are now planned to start or finish late will be coloured red.Any tasks or subtasks which are planned to start or finish early will be coloured green.The GANTT is coloured blue to show where we are on track according to the baseline plan.Today is coloured yellow to remind you where we are currently on the plan.The final step is to admire the beautiful GANTT chart which is created for you.You can add these dates manually if you prefer, or even leave out dates for tasks with subtasks. This is therefore the start date of the task, likewise I used the =MAX( ) formula to find the maximum date between cells D26 and D33 for the task end date. In the screenshot below I have used the =MIN( ) formula to find the minimum date between cells C26 and C33. For tasks with subtasks you may prefer to create formulas to calculate the correct dates based on the subtasks.Delayed – for tasks which are not on track to complete on the baseline end date or before.On hold – for tasks which you have decided to postpone until a later time.On track – for tasks that you have started and are still on track to complete by the baseline end date.Not started – for any tasks which you have not yet started work on.Finally set the status of each task or subtask.You may not have comments on day 1, but as you progress the project this will be useful to add additional information for each task or subtask. If there are multiple people responsible for this task then create individual line items for each responsible person. You should put just one name in each row. In column G add who is responsible for each task.Whenever you baseline the dates of your plan, make sure you reference this date for clarity in cell C3. As you review and revise the plan on a daily basis the dates in columns E and F may change, but the baseline dates should remain static unless you have agreed to re-baseline the plan with project sponsors. If you are creating your plan for the first time then you can put the same dates into columns E and F respectively. ![]() These are the dates that your initial plan stated you would complete each task.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |