Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Выполните приведенные ниже настройки для получения готового проекта.

При выполнение приведенных инструкций и правильном заполнении всех шагов настройки Вы получите экспортированные отчеты, аналогичные показанным на изображении ниже.

Настройка проекта

Выполните настройку проекта, как показано ниже. По завершении каждого шага, нажимайте синюю кнопку воспроизведения для перехода к следующей задаче настройки.

1. Шаг Configuration Options (Параметры конфигурации)

В данном демонстрационном проекте установите флажки для опций No Extensions, No Drills, No Known Parcels, Do Not Embed Rapid Reserver, No Reserves Hacking и Optimise Product.

  • При установке флажка для опции Optimise Product оборудование останавливается по достижении планового задания. Нет ограничения на часы работы оборудования. Возможен перегруз оборудования для достижения установленной цели.

2. Шаг Create Tables (Создание таблиц)

Таблицы должны быть созданы для каждой группы блоков: карьеры, отвалы и (опционально) внутренние отсыпы. Количество уровней в каждой таблице должно соответствовать иерархии уровней файлов запасов, чтобы их можно было по отдельности сопоставить друг с другом в ходе выполнения шага Map Fields (Сопоставление полей).

 Общее представление шага Create Tables

В таблицах, отмеченных флажком Holds Dumps (Содержит отвалы) нет информации по запасам, их блоки нельзя разработать. Если определенная площадь подлежит отработке (выгрузке и забору материала), то блоки требуется импортировать дважды (один раз как отвалы, а другой раз как запасы).

Более подробно про настройку таблиц см. здесь.

3. Шаг Misc Fields (Поля разных параметров)

В шаге Misc Fields устанавливаются такие свойства блока, как тип, объем, его выработка и местоположение.

Заполните таблицу полей разных параметров, как показано.

 Таблица полей разных параметров

Indent

Name

Description

Units

Field Type

Summary Type

Weighting

Formatting

0

blockType

Block Type

Text

None

0

blastType

Blast type

Text

None

0

blastStatus

Blast Status

Text

None

0

dataSource

Data Source

Text

None

0

remaining

Remaining Ratio after Preschedule

m³/m³

Double

WeightedAverage

solidVolume

#,##0.00

0

solidVolume

Solid Volume

Double

Sum

#,##0

0

surfaceArea

Surface Area

Double

Sum

#,##0

0

wallLenght

Wall Length

m

Double

Sum

#,##0

0

presplitPerimeter

Presplit Wall length

m

Double

Sum

#,##0

0

hardness

Hardness

Text

None

0

digRateFactor

Dig Rate Factor

Double

WeightedAverage

solidVolume

#,##0

0

Flitch

Flitch

Text

None

0

flitchIndex

Flitch Index

Double

WeightedAverage

solidVolume

#,##0

0

benchName

Maps Bench Level

Text

None

0

centroid

Centroid

Title

None

1

x

X

m

Double

WeightedAverage

solidVolume

#,##0.00

1

y

Y

m

Double

WeightedAverage

solidVolume

#,##0.00

1

z

Z

m

Double

WeightedAverage

solidVolume

#,##0.00

0

blastDelay

Blast Delay

Double

WeightedAverage

solidVolume

#,##0.00

0

blastFloor

Blast Floor

Double

WeightedAverage

solidVolume

#,##0.00

0

drillSource

Drill Source

Text

None

0

drilling

Drilling

Title

None

1

status

Status

Text

None

1

drillPrep

Prep Days

Double

Sum

#,##0.00

1

loadingDays

Load Days

Double

Sum

#,##0.00

1

length

Total Drill Metres

m

Double

Sum

#,##0

1

drilledPct

Drilled Metres Percentage

%

Double

Sum

0.0%

1

stemming

Stemming

t

Double

Sum

#,##0

1

dets

Dets

no.

Double

Sum

#,##0

1

bore

Does a bore exist

Text

None

1

gc

grade control drilling required

Title

None

2

required

is GC drilling required

Text

None

2

metres

grade control metres

Double

Sum

#,##0

0

explosives

Explosives reporting

Title

None

1

anfo

ANFO

Title

None

2

tonnes

Tonnes of ANFO

t

Double

Sum

#,##0

2

an

AN

t

Double

Sum

#,##0

2

fo

Fuel Oil

t

Double

Sum

#,##0

4. Шаг Mining Fields (Поля параметров добычи)

По умолчанию в шаге Mining Fields (Поля параметров добычи) установлены поля для объема, тонн в сухом состоянии, тонн влажного материала и уровня содержания влаги. В дополнении к этим стандартным полям, требуется добавить любые другие поля блочной модели, которые присутствуют в файлах запасов и имеют отношение к планированию. Например, содержания продукта, пустые породы, класс ресурса, геологический класс и класс горизонта грунтовых вод. Любое поле, влияющее на коммерческую ценность материала, должно быть отмечено флажком в поле Product Field (например, тонны и сорта).

Заполните таблицу полей параметров добычи, как показано.

 Таблица полей параметров добычи

Indent

Product Field

Name

Description

Units

Field Type

Summary Type

Weighting

Formatting

0

False

volume

Volume

bcm

Double

Sum

#,##0

0

True

dryTonnes

Dry Tonnes

dt

Double

Sum

#,##0

0

True

wetTonnes

Wet Tonnes

wt

Double

Sum

#,##0

0

True

moisture

Moisture [ (wt - dt) / wt ]

t/t

Double

WeightedAverage

wetTonnes

0.#####

0

True

grades

Grades

Title

None

1

True

fe

Fe

%

Double

WeightedAverage

dryTonnes

#,##0.000

1

True

al

Al

%

Double

WeightedAverage

dryTonnes

#,##0.000

1

True

si

Si

%

Double

WeightedAverage

dryTonnes

#,##0.000

1

True

p

Phos

%

Double

WeightedAverage

dryTonnes

#,##0.000

1

True

mn

Mn

%

Double

WeightedAverage

dryTonnes

#,##0.000

1

True

loi

LOI

%

Double

WeightedAverage

dryTonnes

#,##0.000

0

False

ctadj

Truck Cycle Time Factor

Double

Sum

#,##0.00

0

False

class

Class

Title

None

1

False

res

Resource Class

Title

None

2

False

indicated

Indicated

t

Double

Sum

#,##0

2

False

inferred

Inferred

t

Double

Sum

#,##0

2

False

measured

Measured

t

Double

Sum

#,##0

2

False

unclassified

Uncalssified

t

Double

Sum

#,##0

0

False

drilling

Drilling Fields

Title

None

0

False

contourPct

Contour Percentage

Double

WeightedAverage

dryTonnes

#,##0.00

0

False

path

Imported Input Path

Title

None

1

False

weight

Weight

Double

Sum

#,##0

1

False

priority

Priority Sequence

Double

WeightedAverage

path_weight

#,##0

5. Шаг Choose Data Sources (Выбор источников данных)

В шаге Choose Data Sources импортируйте соответствующие 3D-солиды из Rapid Reserver в формате «‎.invModel».

 Общее представление шага Choose Data Sources

6. Шаг Map Fields (Сопоставление полей)

В панели Block Mappings (Сопоставление блоков) заполните уровни структуры и поля Misc, перетащив элементы из списка заголовков запасов.

Неправильно или не заполненные поля отображаются красным. Перетащите в них подходящие заголовки.

Чтобы оставить сопоставление расчетных компонентов пустым, установите флажок Ignore Missing Fields in Parcels (Игнорировать отсутствующие поля).

7. Шаг Waste Dumps (Отвалы вскрышных пород)

Имена и объемы отвалов вскрышных пород (Waste Dumps) определяются автоматически из базы данных по запасам (показаны синим шрифтом). В таблицах, отмеченных флажком «Holds Dumps» (С отвалами) в шаге Create Tables (Создание таблиц), автоматически перечисляется их содержимое.

Для добавления точки отвала:

  1. Перейдите в приложение Haul Infinity и откройте вкладку Designer.

    1. Перейдите File > Open и импортируйте файл «Sample.hinf».

    2. Найдите или создайте въезд на ярус отвала (LiftEntry) с названием «Dumps/DP1».

  2. Перейдите во вкладку Setup и выберите шаг Waste Dumps (Отвалы вскрышных пород).

    1. Нажмите иконку зеленого плюса.

    2. Измените имя отвала на «DP1».

    3. Назначьте ему вместимость 100 000 000 кубометров.

Эти узлы Haul Infinity теперь будут обрабатываться планировщиком как точки отвалов.

Точки отвалов должны быть представлены в Haul Infinity в виде узла. Имя узла должно соответствовать назначению Dumps/myDumpName.

8. Шаг Phase Adjacencies (Примыкание фаз)

Для разработки фазы 101 и фазы 102 одновременно, без подрезания фазы 102 под фазой 101:

  • Выберите «OpenPit/M1/P1/P102» в столбце Name.

  • Выберите «OpenPit/M1/P1/P1011» из раскрывающегося списка в столбце Adjacent Stages.

Блоки уровня фазы 102 будут проверять на вертикальные зависимости c уровнем фазы 101.

9. On Bench step

Set dependencies between blocks on a bench/lift. There are options to use automatic dependencies, manually created dependencies, or a combination of the two.

 On Bench step overview

Set "OR" dependency type in Auto Rule Type for Dumps lifts (Blasts - Or [0]).

Note, that “OR” dependency is not automatically displayed in the Auto Rule Type dropdown.

  1. Using Auto Rule Type column dropdown select dependency for Dump1 to “Blast”.

  2. Extend Dump1 to its Lifts levels.

  3. For each Lift select “AND” dependency from the dropdown.

  4. In the Viewport Display area you’ll see selected Lift with pink arrows, showing “AND” auto rule type dependencies.

  1. Toggle upwards red

Dependency Type arrow (last icon) to switch from “AND” to “OR” dependencies type.

  1. This icon will become pointing downwards and dependencies arrows on a Lift will be shown in blue.

  2. Now you can choose “Blasts - Or” dependency from this Lift dropdown.

  1. Repeat for other Dump Lifts

  • Dependencies will be created blasting out from the start point(s) created by the user,

  • More than one block will be available at once.

  • Dependencies for trim shots are automatically created.

10. Between Benches step

Step Between Benches allows user to plan multiple bench mining in a single phase.

  • A zero expand distance allows vertical walls.

  • A positive expand distance forces a minimum running track between crests and toes.

  • In the Max Active Benches column limit a bench from being mined until the Nth bench above it is completely mined out.

  • In the Max Agents on Bench column limit how many Agents can be active on a given bench.

  • In the Max Agents on Block limit individual blasts from having more than the specified number of Agents on them at a time.

11. Custom step

  1. Press the clipboard icon to add a New Dependency Set.

  2. Rename the Dependency Set to “Backfills”.

  3. Using the tree hierarchy on the right, select the successor record and double click on the predecessor.

    1. Successor > Backfills > Pit2 > click, then Predecessor > OpenPit > M1 > P2 > double click.

    2. Successor > Backfills > Pit1 > click, then Predecessor > OpenPit > M1 > P1 > P101 > double click.

12. Swell Factors step

The Swell factors step is used to calculate loose volume from bank volume, for the purposes of dump capacity calculations. Swell factors for haulage calculations can be configured in Haul Infinity under the Materials setup task. 

 To configure Swell factors in Haul Infinity
  1. Go to Haul Infinity > Setup tab > Materials step.

  2. Add two new materials: “Ore” and “Waste”.

  3. Set Density for Ore to 3 t/m³ and for Waste to 2.5 t/m³.

  4. Set Moisture percentage for both Ore and for Waste to 5%.

  5. Set Swell to Bucket percentage for both Ore and for Waste to 120%.

  6. Set Swell to Tray percentage for both Ore and for Waste to 125%.

By default, swell factors are applied to the <All Parcels> group. To create new material groups follow the steps below:

 Configure Mutex Parcel Group
  1. Go to Reserves tab > Data panel.

  2. Press the gear icon to open Configure Parcel Subsets window.

  3. In the Parcel Subsets section add new Parcel Subsets: “Ore” and “Waste”.

  4. Tick relevant parcels for each subset:

    1. Tick “bg”, “hg”, “hgha“, “hghs”, “lg” parcels for Ore subset.

    2. Tick “minw” and “w” parcels for Waste subset.

  5. In the Mutex Parcel Groups section add new Mutex Groups and rename it to “Haulage”.

  6. Assign relevant Subset Names to each Parcel:

    1. For parcels “bg”, “hg”, “hgha“, “hghs”, “lg” set subset name to “Ore”.

    2. For parcels “minw” and “w” set subset name to “Waste”.

7. Press OK.

8. Return to the Swell Factors step.

9. In the Mutex Parcel Group field select “Haulage” group.

13. Periods step

  1. Click on the wizard icon to open the Generate Periods Wizard

  2. Use the blue plus icon to add new periods.

  3. Use the dropdowns to set repeating time intervals and overall duration.

  4. Inspect the results in the Preview Results table on the right.

  5. Toggle the options and naming conventions as required. 

  6. Press OK to finish.

14. Stockpiles

  1. Press the green plus button to add the stockpiles:

    1. “ROM1_1”,

    2. “ROM1_2”,

    3. “LT_1”,

    4. “LT_2”.

  2. In the Capacity Field column for all of them select “Mining_wetTonnes”.

 Stockpiles step overview

15. Crushers step

  1. Press the green plus button to add the crushers:

    1. “CR1_DRY”, and

    2. “CR1_WET”.

  2. Select relevant Processing Streams.

  3. Set “Planned Availability (PA)” type.

  4. Set capacity to “Mining_wetTonnes”.

 Crushers step overview

Column Availability Types to Specify is used to convert calendar time to productive time and engine hours. Availability types explained here.

16. Truck Types step

Every project must have at least one truck type, which is used to calculate fleet numbers, engine hours and fuel burn. 

  1. Press the green plus button to add a new Truck Type.

  2. Rename it to match the Haul Infinity name.

Truck definitions must be present in Haul Infinity in order for the scheduler to reference them. Instructions on how to add Trucks Types in Haul Infinity see here.

  1. Select from

Availability Types to Specify column dropdown “Planned Availability” and “Use of Availability” types for each truck (Availability types explained here).

  1. Flag in 

Adjust Cycle Time Factor by Time introduces a new row in the calendar, so cycle times can be factored faster or slower in different periods (ie. wet weather period). 

17. Loader Types step

Same as for the previous step, loaders types must be present in Haul Infinity.

  1. Press the green plus button to add loaders R9400, R9250, EX2500, EX3600, and CAT994.

  2. Select for each of them ““Planned Availability” and “Use of Availability” types.

  3. In column Loadable Trucks specify which trucks to be loaded by the selected loader type.

  4. Flag in Use as Agent column creates a 1:1 mapping between an Agent and a Loader. Refer to TS. Haul Infinity Inputs for more information.

18. Fleets step

Fleet Assignments provide means to switch between different truck-and-loader groups for given times, locations, materials and destinations.

Fleets can be added by clicking the clipboard icon and configuring the “Loader-Truck” pairing.

Click on the ”Loader-Truck Pairing” field to open the Configure window, where you can add loaders and pair them with relevant trucks.

19. Agents step

In the agents step assign Images and Quantity Fields to each agent.

 Agents step overview

20. Incentives step

Each new incentive adds rows to the Calendar to weight the ranking of blocks by the Agent. 

  • Attractiveness incentives cause certain locations to be ranked higher by the Agent. 

  • Seek Parcels incentives cause certain material types to be ranked higher by the Agent. 

  • Seek Grades incentives cause certain material qualities to be ranked higher by the Agent.

  • Priority incentives are used to directly paint a preferred mining sequence over the available blocks.

Detailed explanation of incentives and priorities see here.

21. Destination Logic step

Destination Logic describes the resting place of material at the end of the period.

Each rule lists the destinations for transactions that match its filter criteria:

  • Code Filters: may differentiate destinations by some custom logic.

  • Period Filters: may differentiate pre- and post- plant commissioning.

  • Agent Filters: may differentiate autonomous and crewed tipheads.

  • Source/Destination Filters: may differentiate ore and waste sources/destinations by pit.

Set Dependency Logic for High Grade Expit:

  1. Click the folder icon to add a new rules folder.

    1. Rename it to “Expit”.

  2. Click the clipboard icon to add a new node.

    1. Rename it to “hg”.

 Create hg expit destination rule

3. Click in the Sources field to open the Configure window.

  • Untick Stockpiles checkbox to show only Open Pit as a source.

  • For parcels, tick “hg”, “hgha”, “hghs” to include in the rule.

  • Press OK.

4. Click on the Destinations field to open the Configure window.

5. Set a destination to the Crusher Feed.

6. Press the blue plus icon to add a crusher feed and select from its dropdown “ROM1_1” stockpile and “CR1_DRY” crusher. Press OK.

New Destination Rule for High Grade Expit has been added.

7. Use blue arrows icons from the toolbar to move “hg” rule to the top in the Expit list.

  • You can also drag and drop it in the location desired, pointed by the blue arrow.

Set destination logics for mg, lg1, as well as for waste, contamination and reclaim as shown below.

22. Steps Logic

Each rule lists the Steps for transactions that match its filter criteria:

  • Period Filters: may differentiate changes in movement pathways.

  • Agent Filters: may differentiate autonomous and crewed fleets.

  • Source Filters: may differentiate ex-pit from rehandle fleets.

  • Destination Filters: may differentiate trucks that can use the overpass, or fit in the crusher bin. 

 Steps logic step overview

Set the Steps Rule for Crewed Rules:

  1. Click the folder icon to add a new rules folder.

    1. rename it to “crewed”.

  2. Click the clipboard icon to add two new nodes.

    1. Rename them to “direct expit” and “indirect feed”.

  3. Assign Agent Filters R9400, R9250, EX2500 and EX3600.

4. Assign all parcels as Sources.

5. Set destinations: Dumps, Backfills and Stockpiles for the direct expit rule, and Crushers for indirect fleet.

6. Configure steps using Source, Destination and Fleet Assignment dropdowns. Direct Expit rule should follow steps from <current source> to <current destination> by <current agent>, while Indirect feed should go from <current source> to <Stockpiles/ROM1_1> as a destination by <current agent>, and from <Stockpiles/ROM1_1> as a source to <current destination> by the rehandle fleet.

Detailed explanation of the Steps Logic see here.

Logic errors

Any errors or warnings that may occur while configuring logics will be listed in the Errors panel at a bottom of a screen.

Example of resolving missing record subset error:

“The specified record subset (CREWED) does not exist in rule (direct expit)”.

This type of error arrears when selected Record cannot be mapped properly or wasn’t created.

To fix:

  1. Go to the Reserves tab.

  2. Locate the Records panel and press the gear icon to open Configure Record Subsets window.

  3. Review the CREWED record subset configuration, if any.

  4. If CREWED record subset doesn’t exist, then press the green plus icon to add it and tick relevant pit levels in the tree on the right.

  5. Press OK, return to the Setup tab and run to the next step. This type of error should be removed from a list.

23. Constraints step

An Agent action may be limited by the following constraints (selected from Add Constraint button dropdown):

  • Standard Constraint: limits the material sent to destinations from specified areas. (The Agent may still mine and send the material to alternative destinations.)

  • Source Constraint: limits the material mined at the source, in the form of a Calendar table by pit, stage or bench. 

  • Bench Advance Constraint: limits the vertical advance between the lowest elevation in the last period and the lowest elevation in the current period. 

  • Drill Standard Constraint: limits drilling in one area. 

  • Drill Source Constraint: limits drilling in multiple areas, in the form of a Calendar table by pit, stage or bench. 

  • Agent Assignments: creates a table of loader assignment limits for each pit, stage or bench. (This option requires Use as Agent option ticked for required loaders).

 Constraints step overview

To create Agent Assignment constraint for the Stage Loaders:

  1. In the Constraints step press the Add Constraint button and select “Agent Assignment” option from the dropdown.

2. Change new assignment name to “StageLoaders”.

3. Checkbox in the Use Constraint column should stay ticked.

4. Click anywhere in the Configuration field area to open Configure window.

5. In the Agents/Drills section tick R9400, R9250, EX2500, EX3600 loaders to apply constraints to.

6. Select “Stage” from the Level dropdown to limit work area to a stage selected.

7. Tick Limit Number of Active Agents in Area to limit number of loaders performing work on that stage.

8. In Inline Reporting section press the blue plus button to add new report field.

9. Rename it to “Mined”.

10. Press the gear icon on the right to configure report fields.

11. Make sure all the parcels, destinations and agents are ticked.

12. Press OK to confirm.

Exercise:

Add Standard and Sources constraints the same way.

24. Product Specifications step

The Product Specifications step allows the user to define the rules of the optimization. Each rule becomes a new row in the Calendar.

 Product Specifications step overview

To add crusher grade target specification:

  1. In the Product Specifications step press the Add Product Specifications button and select “Agent Assignment” option from the dropdown.

2. Rename it to “Rail_fines_fe”.

3. Checkbox in the Use Spec column should stay ticked.

4. Click anywhere in the Configuration field area to open Configure window.

5. Open the Grade Field dropdown, scroll down and select “Output>rail_SubProducts_fines_grades_fe” option.

6. Flag Specify Min, Specify Target and Specify Max checkboxes.

7. Select CR1_DRY and CR1_WET crushers as destinations.

8. Press OK to confirm.

Detailed description of each of the Product Specification types see here.

Exercise:

Add Crusher Grade Targets type Product Specifications for Rail_fines_si, Rail_fines_al and Rail_fines_p, and Crusher Cash Flow type Product Specifications for IncentiviseDry, IncentiviseWet, HGtoDry and LGtoWet.

25. Haulage Configuration

  1. Flag Export Key Column from Chrono Reports option if you want to export key column from Chrono reports.

  2. Flag Export Units Column from Chrono Reports option if you want to export units column from Chrono reports.

  3. Select a truck type to use as a default truck (it must be a valid truck that exists in Haul Infinity).

  4. Select a loader type to use as a default loader (it must be a valid loader that exists in Haul Infinity).

  5. Select haulage materials mutex parcel group.

  6. Select a valid haulage quantity type.

  7. Select a haulage metric for fill sequencing. Note that “Distance” is faster, “Travel Time” is more accurate).

  8. Enable Process Optimised Stockpiles Last option, if required/ Unticked by default.

  9. Set up blasting so it can only run on one blast at a time by ticking Use Serial Blasting Delays option. This approximates a bomb crew that cannot be on more than one shot at once.

  10. Choose from the dropdown the hatching style which will represent drilling areas in the Animation tab.

 Haulage Configuration step overview

26. Dynamic Haulage step

  • Flags are imported from Haul Infinity.

  • In Configuration column set for Start Off initial flag state:

    • AllMined - The trigger is fired when ALL blocks specified have finished mining.

Reserves

In the Reserves tab you can review reserves and dumps solids as well as set their parcel subsets.

  • Mutex Record Subsets allow categories (such as “Ore” or “Waste”) to be created and managed in a single place, so that any changes here propagate to all other references in the Setup.

  • Parcel Subsets are listed and configured in the Data panel, right of the viewport in the Reserves tab.

  • Click on the Parcel Subset field dropdown to open a list of preconfigured subsets.

Parcel Subset Configuration exercise

  1. In the Reserves tab > Data panel press the gear icon, right to Parcel Subset filed dropdown.

  2. The Configure Parcel Subset window will open, where you can add/delete/move up and down and assign parcels subsets and mutex groups.

3. Press the green plus button five times to add five parcel subsets.

4. Name them as “Ore”, “Waste”, “None”, “Other”, and “Low Grade”.

5. Flag relevant parcels for each of them, using common sense:

  • For “Ore” subset, select “bg”, “hg“, “hgha“ and “hghs“.

  • For “Waste” subset, select “minw” and “w”.

  • For “None”, all checkboxes should be unticked.

  • For “Other”, set any other settings.

  • For “LowGrade”, select “lg”.

6. Using blue arrows move parcel subset “None” to the end of a list and place “LowGrade” between “Ore” and “Waste”.

7. Configure Mutex Parcel Groups, that will divide parcels into mutually exclusive sets.

  • Press the green plus button two times to add two mutex groups.

  • Name them as “Haulage” and “OreWaste”.

  • Assign relevant Subset Names to each Parcel:

    1. For parcels “bg”, “hg”, “hgha“, “hghs”, “lg” set subset name to “Ore”.

    2. For parcels “minw” and “w” set subset name to “Waste”.

8. Press OK to confirm.

9. Click on the Parcel Subset field dropdown and you should see these subsets in the list of preconfigured subsets.

Schedule tab

The Schedule tab is the main section for scheduling, reviewing and reporting.

Before starting any scheduling and in order to view animation and populate any reports you should run period/scenarios/full schedule.

Calendar and Animation

Populate your project parameters in the Calendar and Run the scenario.

In the Animation tab, move the slider in the bottom Animation panel to see work progress across the periods.

Open the hidden Current Stage tab to see detailed data about each agent movements at the current stage.

Chrono Report

Creating Chrono reports is a useful feature of Alastri Tactical Scheduler. These reports are used to create static report tables to match business standard templates.

  • Add a new report in the Reporting tab by clicking Add Report button on the left and selecting “Chrono Report” option from its dropdown.

  • Click in the name field and rename to "Summary".

  1. Open the Table Setup tab and fill it in to match your data set, as shown below.

 Table Setup

Type

Name

Caption

Indent

Format

Data Source

Item

Filter 1 Field

Filter 1 Value

Title - act like folders. Their only function is to contain child rows.

Row - look up a value from some data source.

Iter(ative) - can be used to loop over a list of items, and return the value for each item.

Alphanumeric identifier used to create a unique lookup for the row, which can later be referenced in graph series and calculated fields. It is also used as a lookup code for formulas and charts.

Display name of the row in the output table.

Creates nested table fields.

Excel-style number formatting

Choose values from the "Database", "Calendar", "OpeningInventory", "ClosingInventory", "Period", "Custom List" or create a calculated field. 

Choose a field from the data source or enter a calculation.

Filter the data by these fields. 

Filter the data where the filter field equals these values. 

Title

tr

Trucks

0

Row

tr.CAT793_CREW

CAT793_CREW

1

#,##0.0

Database

NumTrucks

Truck

CAT793_CREW

Row

tr.CAT793_AHS

CAT793_AHS

1

#,##0.0

Database

NumTrucks

Truck

CAT793_AHS

Row

tr.KOM830E_CREW

KOM830E_CREW

1

#,##0.0

Database

NumTrucks

Truck

KOM830E_CREW

Row

tr.KOM830E_AHS

KOM830E_AHS

1

#,##0.0

Database

NumTrucks

Truck

KOM830E_AHS

Row

tr.CAT785D

CAT785D

1

#,##0.0

Database

NumTrucks

Truck

CAT785D

2. Go to the Table tab to review Trucks performance across different periods.

 Trucks Table

3. Open the Chart Setup tab to set a chart based on previously added fields.

  • In the Charts panel press the blue plus button to add a new chart. Name it “Trucks”.

  • In the Primary Axis section add a caption “Trucks”.

  • In the Series panel add five truck types and name them accordingly: “CAT793_AHS”, “CAT793_CREW”, “KOM830E_AHS”, “KOM830E_CREW” and “CAT785D”.

  • From the Fields dropdown select a relevant field for each truck.

  • Set a series type to be shown in the main Charts tab. In this exercise we use “StackedBar” type, but you can use the one you like better, and change it at any time.

  • Select a desired color for each series using the Color dropdown.

 Truck Chart Setup

4. When completed, and no errors left in the Error List, you can open the Charts tab and review graphical representation of the data populated, based on trucks performance by given periods.

 Review results in the Charts Tab

Exercise 1.

Create a Chart to display Plant Feed tonnes, based on wet and dry tonnes feed and target limit.

  1. Fill in the Plant Feed data in the Table Setup tab as shown below.

2. Preview results in the Table tab.

 Table tab results

3. Create “Plant Feed” chart with a capture “Tonnes”, “#,##0” format and add “Target”, “Wet” and “Dry” series. Set relevant fields, types and colors for each series.

 Feed Plant Chart Setup

For the Target series type, it is recommended to use a different series type, such as “DashedLines”, to visually show the actual feed against the target one.

4. Go to the Charts tab and review the result. If all data was populated correctly, your Plant Feed chart should look like in the example below.

Exercise 2.

Create a Chart to display Fe and Si percentage, based on Plant Production Rail.

  1. Fill in the Plant Production data in the Table Setup tab as shown below.

2. Preview results in the Table tab.

 Table tab results

3. Create “Rail Fe” and “Rail Si” charts with captures “Fe, %” and “Si, %” accordingly. Choose “#,##0.000” format and add “Rail Fe” and “Rail Si” series. Select relevant fields, types and colors for each series.

 Rail Fe Chart Setup

4. Go to the Charts tab and review the results. If all data was populated correctly, your Rail Fe and Rail Si charts should look like in the example below.

Exercise 3.

Repeat the same steps to create a chart, showing Excavators Utilization, based on Loaders types and their state (active or idle).

 Fill in all the relevant data as required.

You can move blocks of charts in the Charts tab as desired, by dragging and dropping them. For example, you can place Excavators and Trucks Utilization, or Si and Fe percentage charts next to each other to visually compare them.

If you complete all the exercises correctly, your final Charts tab will look as shown below:

Exporting Report

Alastri Tactical Scheduler provides user with different export options.

  1. You can export capture of Table and Charts tabs data, by pressing the Copy Image button.

 Copy Image button location

Note that in the Charts tab you can copy the entire image or selected charts.

The Copy Image button will save the capture to the clipboard, ready for pasting in users reports, presentations or any other documents.

2. Use the Export Manager button to export selected reports in “.xlsx” format.

3. Select a report required and press

Export Selected button to export one report in “.xlsx” format.

  • Specify the saving path and a file name.

  • Open saved report in Microsoft Excel - you should see Table and Charts data tabs views.

  • No labels