Calculation with Gantt Variables |
  
|
Calculation with Gantt Variables |
|
Use Case
The Gantt variables are useful when the quantities are task-driven.
On a worksite, you may need to calculate for each Minute that involves workforce the count of water bottles required according to the count of working days.
Just multiply a variable of type duration by a daily/hourly rate.
For an Overhead Task, $Duration is the most appropriate variable.
List of Variables
In addition to Qwbs, five variables are offered in the dictionary-editor of variables provided that a planning is defined and you created and inserted the 'Formula for quantity' column.
They show according to the types of task (Static or not) and of duration:.
Types ↓ |
$Type (text) |
$Duration |
$WkDays |
$WkHours |
Static |
|
End-Date – Start-Date |
= $Duration |
|
Full Working Days |
Full Working Days |
Count of days |
|
|
Working Hours |
Working Hours |
|
Count of hours |
$NrTasks is the count of tasks attached to the Minute and can be useful in the next case.
Composite Minutes
When you select <Multiple> in the Gantt task column, the involved tasks must share common types, otherwise $Type equals TypesMismatch and an error is signaled:
Common Types ↓ |
$Type (text) |
$Duration |
$WkDays |
$WkHours |
Static |
Full Working Days |
Overall End Date – Overall Start Date |
Sum of counts of days |
|
Full Working Days |
Full Working Days |
|
||
Working Hours |
Working Hours |
|
Sum of counts of hours |