PS. Gantt Report
- iarmstrong
The Gantt Report is found in the Reporting tab of ATS and APS. With a Gantt Report, it is possible for end users to create fully customisable Gantt reports without scripting expertise.
Create a Gantt Report just like any other report on the Reporting tab. There are two tabs on the report - a Setup tab and a Result tab. You do all of the configuration of the report on the Setup tab, and then switch to the result tab to see the result.
- 1 Setup
- 1.1 Configuration tab
- 1.2 Labels tab
- 1.3 Shadings tab
- 1.4 Filters tab
- 1.5 Groupings tab
- 1.6 Columns tab
- 1.7 Extra Guides tab
- 1.8 Printing tab
- 2 Result
- 2.1 Row Order
Setup
Configuration tab
How to populate main data field, see in the table below:
Gantt Bar Method | Either Scheduled or FullPeriod. Scheduled will use the date/times as they are actually scheduled in the software. FullPeriod will assume actions are taken over the duration of the period rather than at the instant they are actually done. Depending on the model setup, FullPeriod may give a better representation of the scheduler’s intent in ATS. |
Compress Blanks | When a value does not apply to a grouping at a level, a blank will be used instead. This can lead to a chain of nodes which just say “blank” before you get to the userful node at the end of the chain. If compress blanks is enabled, this will remove the intermediate blank nodes for a cleaner look. Let’s say you’re looking at stockpiles and reserves:
|
Split Noncontiguous Chronologically Sorted Leaf Tasks | This option will split and duplicate leaf tasks (tasks with no child tasks) if all of the following are true:
This option generally only makes sense if the leaf tasks are dig or blast blocks being operated on by a single agent. If this option is enabled and an agent finishes half block A, then does block B, and then returns to finish block A, there will be two rows for task A, rather than just one. |
Group Header | Settings of groups display in the results tab: |
Period Set | You can choose which period set is used in APS. There’s only one period set in ATS though. This will determine the periods shown in the timeline at the top. |
Timeline Buffers | The blank space on the left and right of the timeline to leave room for labels. |
Schedule Start/End Guides | The red dashed line at the start/end of the schedule: |
Axis Display | The major is the first row in the timeline, the minor is the second, and the periods are the third. |
Even/Odd Back Color | Allows you to alternate background colors of the Gantt each period. This may be useful for night/day shift. |
Color Badges |
Labels tab
You can create a number of “Single Labels”. These can be used as labels next to a gantt bar and in additional columns. These are tied to a single data source (there are potentially many) and you can report out a field from the data source. If you click on one of these labels, you can change its display number format, and include a prefix or suffix (leave blank to ignore). You can also apply filters. These filters will enable you to only include values which pass ALL of the filters. In the case above label “a” will show the dryTonnes done only by agent EX001. Note the filters allow the user of wildcards, | symbols, etc - they can be set up with the same syntax as the Chrono report filters.
Note the format for text (rather than numeric) fields is different:
Because text is being shown, it’s possible there are more than one value. The format will let you choose how you want the label to appear in this case. Mode will chose the most common occurrence. Blank will show nothing. Start will show a *.
A multi-Activity label can be only be used next to a Gantt bar - it cannot be used in a column. Because each bar in a Gantt may be associated with one (or more) activities, a multi-label allows you to choose the label that will be shown based on the activity done.
Shadings tab
You can add shading options to your Gantt. There are a couple different types of shadings - some of them depend on the activity (like Parcels). You can then choose colors based on the mutex selected. There’s always an <All Items> option which will just show you every unique value. If a mutex is available (which are not available for all types, and are configured in the setup tab of ATS or APS), it will only show the options of the mutex.
Filters tab
You can add filters to your Gantt. Any item that does not pass ALL filters configured here will not be considered on the Gantt.
Groupings tab
This is really the heart of how things are displayed on the Gantt.
The first thing to do is create “Group Options” which are string of text. If “Include in Name” is on - this text will appear in a node on the tree. You also need to choose a level number. This level number is referenced again below.
You can put more than one group option at the same level. If you do this, the text provided by the group option will be concatenated together with the others, using the “Name Separator” in the group set panel below.
You may disable “Include in Name” if you want to break apart two things, but not have that text appear in the tree.
For Source and Destination Group Options, you can choose the level that you want to for the name. You can do something like Dig_Pit - just choose dig first, and pit second, and use _ as the name separator. You can also leave the name blank for certain types of sources/destinations - in this case a blank will be used instead. If you are using a multi-part name (multiple group options at the same level), and one of those is blank - it will be ignored when constructing the full name. This allows you to have a name for pit blocks like Mine/Pit/Bench/Blast but for stockpiles Stockpiles/SP1 - and have them appear next to each other in the Gantt.
Location - You can choose for the first grouping to be allocated to a page instead of the Gantt. This will create a panel on the left of the Gantt, and you can switch between the items there.
Collapsed - Whether this node in the tree is expanded or not.
Shading - You can choose from one of the options in the Shading tab. Alternatively you can choose <Solid> and then choose a color for the bar. You can also choose none, in which case no bar will appear on the row. There are certain types of shadings that can only be shown if at the level the shading is applied has been filtered down to a single activity either through the selections at a level above or through the Filters tab.
Left/Right Label - You can choose a label that will appear on the left and/or right of the Gantt bar. This can be a multi-label or a single label.
Columns tab
You can create extra columns - these will be shown to the right of the group names. These can only be single labels.
Extra Guides tab
You can create extra guides (vertical lines on the Gantt at a specified date) to indicate certain important events.
Printing tab
You can create one or more print configurations. These will be used when using the print function. The print function will save the document as specified to a PDF file. For printing on a plotter, use size A0 and get a PDF, then print the PDF from Acrobat.
Fit to Horizontal Pages - This will resize the Gantt such that it fits to the specified pages wide. If set to 0, it will use the required number of pages.
Fit to Vertical Pages - This will resize the Gantt such that it fits to the specified number of pages or less as it may not be possible to fit it to an exact number of pages vertically.
Result
Row Order
On the Result tab, you can click the Reorder Rows button to show this dialog. This will allow you to change the order that items are sorted in the Gantt. You can choose either ascending, descending, or customized - which will allow you to specify the order explicitly.