Home > Excel Program > XLGantt > XLGantt How to > XLGantt(Excel Gantt) How to #5 – Analysis Report

XLGantt(Excel Gantt) How to #5 – Analysis Report

  • by

XLGantt(Excel Gantt) provides you with analysis reports to help you keep track of your project.

When you click the buttons in the ribbon menu> XLGantt > Analysis Group, reports are created and several features are provided as follows.

XLGantt(Excel Gantt) How to – Analysis Report

 

1. Progresses by Resources

It shows you the total workloads, planned workloads, progresses(%Work complete), etc.

  • When "by Resource Allocation Ratio" is selected in the "Workload Calculation" option – If you enter resources in the form of "John[50%],Elsa" in the resource field of the Schedule sheet, XLGantt calculates the workloads according to the percentage of the allocated resources.
  • When "by Weight" is selected in the "Workload Calculation" option – If you allocate multiple resources to one task, XLGantt calculates the workload assigned to one person by dividing the workloads by the number of people. For example, if you assign 3 people with a workload of 9 Man/Day, XLGantt calculates that each person has 3 man/day allocated.

If there is a task that has not been assigned to the person in charge, it is displayed as "(Resources unspecified)".

1) Progresses by Resources

XLGantt(Excel Gantt) How to – Analysis Report

 

2) Subtotals

Click on the number of the subtotal level in the upper left corner to see subtotals.

XLGantt(Excel Gantt) How to – Analysis Report

 

 

2. Workloads (by weeks, months, Resources)

When you click "Workloads by Weeks", "Workloads by Months", "Workloads by Resources" in the ribbon menu, XLGantt displays the Workloads by charts.

Man-Month is one person's working time for a month

The working days are usually 21, but it can be changed to 20 days, 22 days, etc., and Man-Month is calculated and displayed based on the changed working days.

1) Workloads by Weeks

XLGantt(Excel Gantt) How to – Analysis Report

 

2) Workloads by Months

XLGantt(Excel Gantt) How to – Analysis Report

 

3) Workloads by Resources

XLGantt(Excel Gantt) How to – Analysis Report

 

 

3. Project Progresses

Click "Progress by Weeks", "Progress by Months" on the ribbon to display the project progresses.

1) When not managing schedule changes

Only the "Planned workload progress" and "Earned value progress" are displayed.

XLGantt(Excel Gantt) How to – Analysis Report

 

2) When managing schedule changes

"Planned workload progress", "Earned value progress" and "Actual workload progress" are displayed.

XLGantt(Excel Gantt) How to – Analysis Report

 

 

4. Export Workload data to “Workload” sheet

If you click "Create Workload Data by Weeks","Create Workload Data by Months" in the menu, Workload data is exported to the "Workload" sheet.
Using the "Workload" sheet data, you can perform analysis as desired by features such as Excel pivot.

XLGantt(Excel Gantt) How to – Analysis Report

 

[ XLGantt(Excel Gantt) How to ]

Leave a Reply

Your email address will not be published.