This will export the resource workload to an Excel sheet or a CSV text file, per day/week/month in a specified period.
Only the resources (or groups) where a resource type has been specified will be included in the workload calculaton. If a resource type is set on a resource group the workload for all sub resources (and sub groups and their sub resources etc.) within that group will be summed.
Notice that by default the resource type which is set on the resource to include must have it’s “bit flag” no. 15 set (see parameter ‘resourceTypeBitFlagNo’ below).
Example parameter configuration
Example output (Excel)
Month by month in three months.
| Resource | Resource type | Month | Avail |
| Cleaning | Type 1 | Nov-10 | 0 |
| Construction group | Type 1 | Nov-10 | 0 |
| Construction2 | Type 1 | Nov-10 | 0 |
| Cooling | Type 1 | Nov-10 | 0 |
| Heating | Type 1 | Nov-10 | 800 |
| Laboratory | Type 1 | Nov-10 | 0 |
| Painting | Type 1 | Nov-10 | 0 |
| Painting2 | Type 1 | Nov-10 | 0 |
| Painting3 | Type 1 | Nov-10 | 4560,5 |
| Painting4 | Type 1 | Nov-10 | 0 |
| Tech-Secr | Type 1 | Nov-10 | 133 |
| Welding group1 | Type 1 | Nov-10 | 1862 |
| Prod-DK | Type 2 | Nov-10 | 10660 |
| Prod-Ext | Type 2 | Nov-10 | 6560 |
| Supervisor | Type 2 | Nov-10 | 0 |
| Welding group2 | Type 2 | Nov-10 | 1640 |
| Welding2 | Type 2 | Nov-10 | 0 |
| Cleaning | Type 1 | Dec-10 | 0 |
| Construction group | Type 1 | Dec-10 | 0 |
| Construction2 | Type 1 | Dec-10 | 0 |
| Cooling | Type 1 | Dec-10 | 0 |
| Heating | Type 1 | Dec-10 | 820 |
| Laboratory | Type 1 | Dec-10 | 0 |
| Painting | Type 1 | Dec-10 | 0 |
| Painting2 | Type 1 | Dec-10 | 0 |
| Painting3 | Type 1 | Dec-10 | 4703 |
| Painting4 | Type 1 | Dec-10 | 0 |
| Tech-Secr | Type 1 | Dec-10 | 137 |
| Welding group1 | Type 1 | Dec-10 | 1918 |
| Prod-DK | Type 2 | Dec-10 | 10985 |
| Prod-Ext | Type 2 | Dec-10 | 6760 |
| Supervisor | Type 2 | Dec-10 | 0 |
| Welding group2 | Type 2 | Dec-10 | 1690 |
| Welding2 | Type 2 | Dec-10 | 0 |
| Cleaning | Type 1 | Jan-11 | 0 |
| Construction group | Type 1 | Jan-11 | 0 |
| Construction2 | Type 1 | Jan-11 | 0 |
| Cooling | Type 1 | Jan-11 | 0 |
| Heating | Type 1 | Jan-11 | 760 |
| Laboratory | Type 1 | Jan-11 | 0 |
| Painting | Type 1 | Jan-11 | 0 |
| Painting2 | Type 1 | Jan-11 | 0 |
| Painting3 | Type 1 | Jan-11 | 4343,5 |
| Painting4 | Type 1 | Jan-11 | 0 |
| Tech-Secr | Type 1 | Jan-11 | 126,5 |
| Welding group1 | Type 1 | Jan-11 | 1741 |
| Prod-DK | Type 2 | Jan-11 | 10140 |
| Prod-Ext | Type 2 | Jan-11 | 6240 |
| Supervisor | Type 2 | Jan-11 | 0 |
| Welding group2 | Type 2 | Jan-11 | 1560 |
| Welding2 | Type 2 | Jan-11 | 0 |
Week by week in three weeks.
| Resource | Resource type | Week | Avail |
| Cleaning | Type 1 | 2010-46 | 0 |
| Construction group | Type 1 | 2010-46 | 0 |
| Construction2 | Type 1 | 2010-46 | 0 |
| Cooling | Type 1 | 2010-46 | 0 |
| Heating | Type 1 | 2010-46 | 180 |
| Laboratory | Type 1 | 2010-46 | 0 |
| Painting | Type 1 | 2010-46 | 0 |
| Painting2 | Type 1 | 2010-46 | 0 |
| Painting3 | Type 1 | 2010-46 | 1023,5 |
| Painting4 | Type 1 | 2010-46 | 0 |
| Tech-Secr | Type 1 | 2010-46 | 30 |
| Welding group1 | Type 1 | 2010-46 | 420 |
| Prod-DK | Type 2 | 2010-46 | 2405 |
| Prod-Ext | Type 2 | 2010-46 | 1480 |
| Supervisor | Type 2 | 2010-46 | 0 |
| Welding group2 | Type 2 | 2010-46 | 370 |
| Welding2 | Type 2 | 2010-46 | 0 |
| Cleaning | Type 1 | 2010-47 | 0 |
| Construction group | Type 1 | 2010-47 | 0 |
| Construction2 | Type 1 | 2010-47 | 0 |
| Cooling | Type 1 | 2010-47 | 0 |
| Heating | Type 1 | 2010-47 | 180 |
| Laboratory | Type 1 | 2010-47 | 0 |
| Painting | Type 1 | 2010-47 | 0 |
| Painting2 | Type 1 | 2010-47 | 0 |
| Painting3 | Type 1 | 2010-47 | 1030 |
| Painting4 | Type 1 | 2010-47 | 0 |
| Tech-Secr | Type 1 | 2010-47 | 30 |
| Welding group1 | Type 1 | 2010-47 | 420 |
| Prod-DK | Type 2 | 2010-47 | 2405 |
| Prod-Ext | Type 2 | 2010-47 | 1480 |
| Supervisor | Type 2 | 2010-47 | 0 |
| Welding group2 | Type 2 | 2010-47 | 370 |
| Welding2 | Type 2 | 2010-47 | 0 |
| Cleaning | Type 1 | 2010-48 | 0 |
| Construction group | Type 1 | 2010-48 | 0 |
| Construction2 | Type 1 | 2010-48 | 0 |
| Cooling | Type 1 | 2010-48 | 0 |
| Heating | Type 1 | 2010-48 | 180 |
| Laboratory | Type 1 | 2010-48 | 0 |
| Painting | Type 1 | 2010-48 | 0 |
| Painting2 | Type 1 | 2010-48 | 0 |
| Painting3 | Type 1 | 2010-48 | 1030 |
| Painting4 | Type 1 | 2010-48 | 0 |
| Tech-Secr | Type 1 | 2010-48 | 30 |
| Welding group1 | Type 1 | 2010-48 | 420 |
| Prod-DK | Type 2 | 2010-48 | 2405 |
| Prod-Ext | Type 2 | 2010-48 | 1480 |
| Supervisor | Type 2 | 2010-48 | 0 |
| Welding group2 | Type 2 | 2010-48 | 370 |
| Welding2 | Type 2 | 2010-48 | 0 |
Day by day in three days.
| Resource | Resource type | Day | Avail |
| Cleaning | Type 1 | 15 Nov | 0 |
| Construction group | Type 1 | 15 Nov | 0 |
| Construction2 | Type 1 | 15 Nov | 0 |
| Cooling | Type 1 | 15 Nov | 0 |
| Heating | Type 1 | 15 Nov | 40 |
| Laboratory | Type 1 | 15 Nov | 0 |
| Painting | Type 1 | 15 Nov | 0 |
| Painting2 | Type 1 | 15 Nov | 0 |
| Painting3 | Type 1 | 15 Nov | 217 |
| Painting4 | Type 1 | 15 Nov | 0 |
| Tech-Secr | Type 1 | 15 Nov | 6,5 |
| Welding group1 | Type 1 | 15 Nov | 91 |
| Prod-DK | Type 2 | 15 Nov | 520 |
| Prod-Ext | Type 2 | 15 Nov | 320 |
| Supervisor | Type 2 | 15 Nov | 0 |
| Welding group2 | Type 2 | 15 Nov | 80 |
| Welding2 | Type 2 | 15 Nov | 0 |
| Cleaning | Type 1 | 16 Nov | 0 |
| Construction group | Type 1 | 16 Nov | 0 |
| Construction2 | Type 1 | 16 Nov | 0 |
| Cooling | Type 1 | 16 Nov | 0 |
| Heating | Type 1 | 16 Nov | 40 |
| Laboratory | Type 1 | 16 Nov | 0 |
| Painting | Type 1 | 16 Nov | 0 |
| Painting2 | Type 1 | 16 Nov | 0 |
| Painting3 | Type 1 | 16 Nov | 223,5 |
| Painting4 | Type 1 | 16 Nov | 0 |
| Tech-Secr | Type 1 | 16 Nov | 6,5 |
| Welding group1 | Type 1 | 16 Nov | 91 |
| Prod-DK | Type 2 | 16 Nov | 520 |
| Prod-Ext | Type 2 | 16 Nov | 320 |
| Supervisor | Type 2 | 16 Nov | 0 |
| Welding group2 | Type 2 | 16 Nov | 80 |
| Welding2 | Type 2 | 16 Nov | 0 |
| Cleaning | Type 1 | 17 Nov | 0 |
| Construction group | Type 1 | 17 Nov | 0 |
| Construction2 | Type 1 | 17 Nov | 0 |
| Cooling | Type 1 | 17 Nov | 0 |
| Heating | Type 1 | 17 Nov | 40 |
| Laboratory | Type 1 | 17 Nov | 0 |
| Painting | Type 1 | 17 Nov | 0 |
| Painting2 | Type 1 | 17 Nov | 0 |
| Painting3 | Type 1 | 17 Nov | 223,5 |
| Painting4 | Type 1 | 17 Nov | 0 |
| Tech-Secr | Type 1 | 17 Nov | 6,5 |
| Welding group1 | Type 1 | 17 Nov | 91 |
| Prod-DK | Type 2 | 17 Nov | 520 |
| Prod-Ext | Type 2 | 17 Nov | 320 |
| Supervisor | Type 2 | 17 Nov | 0 |
| Welding group2 | Type 2 | 17 Nov | 80 |
| Welding2 | Type 2 | 17 Nov | 0 |
Parameter descriptions
(* = configuration required)
applyFiltering
If true the exported workload will reflect the workload graph settings and the filter settings in the Gantt chart.
Default false
availableHoursText
Specify the text to be printed in the header cell for the available hours column.
The default is ‘(avail)’.
dayDateFormat
Specify the date format to use if ‘D’ is specified in ‘periodType’.
Default is ‘d MMM’, i.e. 3 Aug.
For additional examples se Formatting dates
dayText
Specify the text to be printed in the header cell for the period column, when ‘periodType’ is specified to ‘D’.
The default is ‘Day’.
decimalSeparator
The decimal separator used when exporting numbers, i.e. ‘,’ or ‘.’ (comma or period).
If left blank the default decimal separator corresponding to language preferences are automatically selected.
excludeFinishedWorkload
Specify true to ignore workload already finished on operations in progress.
Default false.
fileNameCSV *
Directory path including filename to the export file can be specified.
This must be specified if “outputAsCSV” is true.
Example: c:\workloadOverview.csv
fileNameExcel *
Directory path including filename to the export file can be specified.
Example: c:\workloadOverview.xls
includeOperationStates
Only relevant if ‘includeOperations’ is enabled.
Define the operation states to include on the report. Default is 20, 30, 40. See also ‘usedHours1StatusList’.
includeOperations
If this is enabled operations are added to the report. One row per operation, after each resource. At least 2 columns are always shown when this is enabled – ‘Operation’ and ‘Operation hours’. More columns can be added, see parameter ‘insertOperationColumns’.
This is only supported if ‘outputAsCSV’ is false.
insertOperationColumns
Here a list of layout items (fields/columns) can be defined. The same fields as in the field chooser in ROB-EX tables can be used.
For a list of the possible fields see the variable list. In the field chooser the id of a field is also shown.
Default is:
order_name, order_customer_name, opr_state, opr_start_time_readable, opr_end_time_readable
monthDateFormat
Specify the date format to use if ‘M’ is specified in ‘periodType’.
Default is ‘MMM-yy’, i.e. Aug-10.
For additional examples se Formatting dates
monthText
Specify the text to be printed in the header cell for the period column, when ‘periodType’ is specified to ‘M’.
The default is ‘Month’
numberFormat
The format of the numbers. #.## means for instance 10,57 (rounded from 10,56739). A hash symbol (#) indicates the max number of decimals, in this case it’s two. The format ‘0.00’ indicates exactly two decimals – i.e. 10,50.
The default is ‘#.##’. This is only relevant if ‘outputAsCSV’ is true.
onlyFinishedHours
If ‘true’ is specified only the finished hours will be reported for operations in progress. In this case parameter “excludeFinishedWorkload” has no effect.
Default is ‘false’.
outputAsCSV
If ‘true’ is specified the output format will be in CSV instead of XLS.
Default is ‘false’.
period
The quantity of days, weeks or months – dependent of what is specified in ‘periodType’.
periodType
‘D’, ‘W’ or ‘M’ can be specified. For instance if ‘W’ is specified and ‘4’ is specified in ‘period’ the workload will be calculated week by week in four weeks.
resourceText
Specify the text to be displayed in the resource header column.
The default is ‘Resource’.
resourceTypeBitFlagNo
If this is specified the resource types which is set on the resources to include must have the specified bit no. set.
This is done in “Edit->Resource” dialog. Select the “Resource types” tab and check the “Optional sub category” shown below.
Possible values are 8, 9, 10, 11, 12, 13, 14, 15. The default is 15.
resourceTypeText
Specify the text to be displayed in the resource type header column.
The default is ‘Resource type’.
separator
Specify the character used to delimit the columns of the generated CSV file.
The default is ‘;’ (semicolon).
sheetName
Specify the name of the Excel sheet to put the data in.
Default is ‘Workload Overview’
start
The start date from where the workload calculation should be performed.
The keyword “this week” corresponds to Monday morning at 00:00 in the current week. It is possible to add and subtract by specifying for instance ‘this w-3w+2d’ (or ‘this week – 3weeks + 2days’) (also see period parameter). Please notice that ‘m’ corresponds to month and NOT minute.
Supported notation: “now” or “this week” (not “this month”), y/year(s), m/mon/month(s), w/week(s), d/day(s), h/hour(s), min/minute(s) and s/sec/second(s).
The default is ‘this week’.
If ‘M’ is specified in ‘periodType’ the calculation will be performed from the first day in the month specified in this field. For instance if ‘this week + 2 days ‘ are specified – resulting in for instance the 18th of Nov, the calculation will be performed from the 1st of Nov at 00:00 in the morning.
If ‘W’ had been specified in ‘periodType’ the calculation would be performed from Monday the 15th of Nov at 00:00 in the morning.
At last if ‘D’ is specified in ‘periodType’ the calculation will be performed from the 18th of Nov from 00:00 in the morning.
Thus specifying hours, minutes or seconds will not give any effect.
usedHours1StatusList
Specify a comma separated operation state list to include in the workload calculation. This is used in the ‘Used1’ column.
Example: If ’20, 40’ is specified only operations with state planned or startet is included in the workload calculation.
Possible states:
15 Reserved/Forecast
20 Planned
30 Start possible
40 Started
50 Paused
60 Cancelled
70 CompletedIf nothing is specified all states except ‘70’ are included.
usedHours2StatusList
Specify a comma separated operation state list to include in the workload calculation. This is used in the ‘Used2’ column. If nothing is specified all states except ‘70’ are included.
usedHours3StatusList
Specify a comma separated operation state list to include in the workload calculation. This is used in the ‘Used3’ column. Leave blank if no calculations is whished in this column.
usedHours4StatusList
Specify a comma separated operation state list to include in the workload calculation. This is used in the ‘Used4’ column. Leave blank if no calculations is whished in this column.
usedHoursText1
Specify the text to be printed in the ‘Used 1’ column
The default is ‘(used1)’.
usedHoursText2
Specify the text to be printed in the ‘Used 2’ column
The default is ‘(used2)’.
usedHoursText3
Specify the text to be printed in the ‘Used 3’ column
The default is ‘(used3)’.
usedHoursText4
Specify the text to be printed in the ‘Used 4’ column
The default is ‘(used4)’.
weekDateFormat
Specify the date format to use if ‘W’ is specified in ‘periodType’.
‘yyyy-ww’ will result in ’2010-28’.
The default is ‘yyyy-ww’.
For additional examples se Formatting dates
weekText
Specify the text to be printed in the header cell for the period column, when ‘periodType’ is specified to ‘W’.
The default is ‘Week’.
Post your comment on this topic.