Home > Excel Program > XLGantt > XLGantt How to > XLGantt(Excel Gantt) How to #6 – Managing Schedule Change

XLGantt(Excel Gantt) How to #6 – Managing Schedule Change

  • by

In Excel Gantt, you can use actual start and finish dates. So You can identify the schedule is delayed or aheaded by entering actual start and finish dates.

1. Schedule change management setting

Click the “Options” button on the ribbon menu > XLGantt tab to choose schedule option.

XLGantt(Excel Gantt) How to – Schedule Change Management

 

If you choose “Managing Schedule Changes”,  the following fields are displayed: Actual Start Date, Actual Finish Date, and Actual Total Work.

XLGantt(Excel Gantt) How to – Schedule Change Management

 

2. How to enter the changed schedule

There are three ways to enter the changed schedule.

1) When the task is finished and you enter the actual start date and actual finish date.

  • If you enter the actual start date and the actual finish date directly, the %Work Complete is automatically entered as 100%.
  • If the planned schedule differs from the actual schedule, the background color of the date is displayed in yellow and the Gantt chart displays the actual schedule in blue lines.

XLGantt(Excel Gantt) How to – Schedule Change Management

 

2) If a task is finished as planned

If a task is finished on the same schedule as the planned schedule, you can enter 100% of the %Work Complete only. If you do not enter the actual start date and actual finish date, they will be filled with the same date as the planned start date and finish date.

 

3) If a task is not finished yet

If a task is not finished, enter only the actual start date and the %Work complete. If you enter the actual finish date, the task is considered finished, so you only need to enter the actual start date.

 

 

[ XLGantt(Excel Gantt) How to ]

Leave a Reply

Your email address will not be published.