Home > Excel Program > XLGantt > XLGantt How to > XLGantt(Excel Gantt) How to #12 – Integration with Excel Features

XLGantt(Excel Gantt) How to #12 – Integration with Excel Features

You can include the formulas and functions of the Excel in XLGantt.

1. Display project information using functions provided by XLGantt

You can add rows above the title and use the functions provided by XLGantt to display the project start date, etc. at the range you want.

XLGantt(Excel Gantt) How to - Integration with Excel Features

 

Functions provided by XLGantt

  • xlgantt.ProjectName(): Get project name
  • xlgantt.ProjectStartDate(): Get project start date
  • xlgantt.ProjectFinishDate(): Get project finish date
  • xlgantt.ProjectPlanProgress(): Get planned progress of project(Planned %Work Complete)
  • xlgantt.ProejctActualProgress(): Get actual progress of project(%Work Complete)
  • xlgantt.ProjectProgressString(): Get project progress summary information
  • xlgantt.CommentOnHeadArea(): Get comment to display at the top of the Schedule sheet

 

2. Add columns and enter Excel formulas

You can add columns and enter formulas.

For example, you can easily track the progress of the project by adding the SPI column as follows.

XLGantt(Excel Gantt) How to - Integration with Excel Features

*SPI(Schedule Performance Index) : The Schedule Performance Index indicates how efficiently you are actually progressing compared to the planned project schedule.

 

 

[ XLGantt(Excel Gantt) How to ]

Leave a Reply

Your email address will not be published.