Assigning resources and prices to tasks and showing their summary usage

Source: 01-Resources.js - Resources chart shown in the same grid in fixed rows

In this example the resource usage chart in the first grid is not fully updated by changes done in the second grid, because in real application it is not expected to show two resource charts for one data

Source: 01-Resources_grid.js - Shows resource usage from the previous grid

Resource list

The list of available resources is defined in root Resources tag, the individual resources are defined inside by R tags.
The R tag can have these attributes:

Name as unique identification of the resource.
Text as optional resource name to be displayed instead of the Name in popup resources menu.
Price as price of the resource used in calculation of task or project price.
Availability as count of the available resources, when actual resource usage exceeds this count, the bars in Resource chart are displayed in red.
The Availability can also contain one or more date ranges to specify the resource counts depending on dates.
The Availability can be easily edited by users in dialog by Dates type Button.

Resource assign

The resources are assigned individually per main bar plan by

GanttResourcesX

attribute, where the X is the main bar plan number, empty for the first one.
The resources for run bar (when GanttTask contains "Run") are assigned by

GanttRunResources

.
The resources for run box (when GanttTask contains "Box") are assigned in the box attribute

Resources

in the GanttRun definition.
The format is: name1*amount1+extra1;name2*amount2+extra2;...
For run box resources definition is the ';' separator replaced by '#'.

Resources are separated by semicolon (defined by <Format ValueSeparator/>). The name and amount are separated by asterisk (defined by <Format CountSeparator/>). The extra is separated by plus (defined by <Format AddSeparator/>).
The name is resource Name.
The amount is amount of resource units per task data unit. The amount can be omitted if it is 1 and the extra is not used or is 0 and extra is used.
The extra are extra resource units independent on the task duration. The extra can be omitted if it is 0.
If the name and amount are omitted, the extra is extra price for the task independent on resources and task duration. There should be only one such extra price per task.

The resources can be assigned by users in Gantt popup menu, shown by action EditGanttResources attached by default to OnDblClickGantt event.
The resources can be also changed in right click Gantt popup menu, "Change resources" menu item.

Attribute
GanttResourcesAssign
specifies how the resources are chosen in the resources menu, possible options are:
0 - single resource, 1 - resources without count, only checkboxes shown, 2 - resources count can be selected in combo 1 - 10, 3 - resources count is editable integer, 4 - resources count is editable float, 5 - only extra resource units and task price.
Attribute
GanttResourcesExtra
controls if and how can be added the extra prices for the resources.
0 - none, 1 - one extra price per whole task, 2 - extra units per resources, 3 - both.
If permitted extra price per task, the resource names should not be numbers.
Or the resources menu can be defined by custom
GanttResourcesMenu
as standard TreeGrid JSON menu.

Resources filter

The tasks can be filtered according to assigned resources, to show only tasks for selected resources.
The predefined filter can be set by GanttResourcesFilter attribute.
Users can choose the resources to filter in Space cell of Type SelectGanttResources.

Resources calculation

There are three calculation functions to use in formulas for support of calculation resources.

ganttresourcepeak returns maximal count of the resource used in grid at one time.
ganttresourceunits returns count of all allocated units for given resource in the whole grid.
ganttresourceextra returns summary of extra prices assigned to tasks for given resource, or for all extra prices for whole task.

There are also three support API function for custom resources calculation.

GetGanttPrice returns price of the task according to its duration and assigned resources.
GetResourceErrors returns all errors or usage in grid for the resource name in two dimensional array.
GetResourceUsage returns Availability string as usage of given resource in chart.
GetGanttResourceCount returns information about given resource usage in given date range (peak, units or average usage).

Resources usage chart

It is special Gantt chart row showing usage of one resource in the whole project.
The cell shows the Resource usage chart when set

GanttAvailability

to special format specifying the chart type.
The GanttAvailability format is: resource_name#chart_type#def_name, where chart_type can be:

1 - resource usage by the tasks in chart. Uses Green class by default.
2 - resource usage, for Work is the same as 1, for Material shows constant usage, not incremental. Uses Green class by default.
3 - availability chart, shows chart for the resource Availability value. Uses Yellow Class by default.
4 - actual availability at given times, for Work it is the same as 3, for Material is similar to 5, but shifted by one GanttDataUnit. Uses Yellow Class by default.
5 - free resources chart (availability minus usage). Uses default (blue/red) class by default.
6 - resource errors (availability minus usage, only negative values). Uses Red class by default.
7 - resource errors, positive (availability minus usage, only negative values as positive values). Uses Red class by default.
8 - resource errors, full (availability minus usage, only negative values as full usage at given time). Uses Red class by default.

The def_name is optional name of Def row, to show resources from only rows with this attribute.
The number format is set by GanttAvailabilityFormat attribute.
The Resource usage chart shows bars (blue, red or yellow), one per one GanttUnit, with number as count of resources consumed in the GanttUnit.
The blue bars are for resource usage, red bars for resource errors and yellow bars for resource availability.
The bar colors can be redefined by GanttAvailabilityClass attribute.
The resource usage chart can be shown in the same grid as the source tasks, usually in fixed rows, or in another grid, see below.

Automatically generated Resources usage chart

It is possible to automatically create the Resource usage chart from source in another grid.
The resources list can be modified, the resources can be added, deleted, changed or renamed via the resource chart.

The source grid must contain tasks with resources and resource list. The source grid can be even hidden, to work only as data source for the Resource usage chart, set <bdo Hidden='1' ... >
The resource grid should have defined only layout xml, because body rows are automatically generated from the resource list in source grid.

The resource grid must define these <Cfg> attributes:

GanttResourceMaster

as id of the source grid and GanttResourceName, GanttResourcePrice and GanttResourceAvailability as columns in resource grid, where will be shown these attribute of source R tag.
For more information see documentation.

1. Resources