Menu bar - Chart

Load Ratio Graph


If you select a load graph, the [Chart] menu for a load graph is displayed in the menu bar.

The [Chart] menu provides the following items:


Sort

Displays the Sort Expression Dialog.


Filter

Displays the Filter Expression Editor.


Display Area

Whole Area

Displays the whole area on a screen by reducing the scale of the current chart window. If the whole area can not be displayed, the chart is displayed by minimizing the size of the cells.

Enlarges active cells

Enlarges selected cell area.


Display mode

Display operations

Displays use instruction bars in resource Gantt rows.
Valid when resource Gantt rows are displayed.

Display work patterns

Displays working patterns on resource Gantt rows.


Fix

Full fix

Fixes the operation to which the selected bar belongs to its current assigned time and resource.
Valid when resource Gantt rows and order Gantt rows are displayed.

Unfix

Unfixes the operation to which the selected bar belongs.
Valid when resource Gantt rows and order Gantt rows are displayed.

Time fix

Fixes the operation to which the selected bar belongs to its current assigned time.
Valid when resource Gantt rows and order Gantt rows are displayed.

Resource fix

Fixes the operation to which the selected bar belongs to its current assigned resource.
Valid when resource Gantt rows and order Gantt rows are displayed.

Use Instruction Fix

Fixes the selected use instruction to that resource. Valid when resource Gantt rows and order Gantt rows are displayed.


Status

Freeze

Makes the status of the operation to which the selected bar belongs frozen.
Valid when resource Gantt rows and order Gantt rows are displayed.

Unfreeze

Makes the status of the operation to which the selected bar belongs unfrozen.
Valid when resource Gantt rows and order Gantt rows are displayed.

Release

Makes the status of the operation to which the selected bar belongs released.
Valid when resource Gantt rows and order Gantt rows are displayed.


Select all

Selects all the assigned bars on the Gantt chart.
Valid when resource Gantt rows and order Gantt rows are displayed.


Load Ratio Graph

Exports numeric values in the load graph.

Export: Spreadsheet Format

Exports values in the load graph by a spreadsheet-format (table-format) text file.

In spreadsheet format, values are output in a matrix with vertical axis representing items and the horizontal axis representing time.

2003/06/04 00:00:00,86400
Mixer 1,0.000000,0.911111,0.922222,0.000000,0.000000,0.758889,...
Packer 1,0.000000,0.360000,0.360000,0.000000,0.000000,0.000000,...
...

The first row represents the start time and summary period (the number of seconds). The second row and after represent data, and the first field represents resource code and the second field and after represent data for each summary period.

When the summary period is set to "Demarcation times", the first row will be a list of the start time and demarcation times.

2003/6/40:00,{00:00:00;04:00:00;08:00:00;16:00:00}
Mixer 1,0,0,0,0,0,0,0.94375,0.87380952,0,0,1,0.83333333,...
Packer 1,0,0,0,0,0,0,0,0.7547619,0,0,0.01458333,0,...
..

Export: RDB Format

Exports values in the load graph by a RDB-format (record-format) text file.

The style RDB outputs the information in the unit of row.
The outputted data contents will defer, depending on the setup for the property "RDB output format" for load graph (which is located in the load graph tab for chart display setting). There are 2 kinds of options: "load ratio" and "load time and operational time."

Load ratio

Outputs the load ratio. This is the default specified value.
For each row, the 1st field indicates resource code, the 2nd time and the 3rd load ratio.
1 refers to 100% in case of load ratio.

(Output example)

Mixer1,2007/06/04 00:00:00,0
Mixer1,2007/06/05 00:00:00,0
Mixer1,2007/06/06 00:00:00,0
Mixer1,2007/06/07 00:00:00,0.91111111
Mixer1,2007/06/08 00:00:00,0.92222222
Mixer1,2007/06/09 00:00:00,0
......
Packer1,2007/06/04 00:00:00,0
Packer1,2007/06/05 00:00:00,0
Packer1,2007/06/06 00:00:00,0
Packer1,2007/06/07 00:00:00,0.35222222
Packer1,2007/06/08 00:00:00,0.00777778
Packer1,2007/06/09 00:00:00,0
......

Load time and operational time

Outputs load time and operational time.
For each row, the 1st field indicates resource code, 2nd time, 3rd load time and 4th operational time. 1 refers to 24 hours in case of time.

(Output example)

Mixer1,2007/06/04 00:00:00,0,0.625
Mixer1,2007/06/05 00:00:00,0,0.625
Mixer1,2007/06/06 00:00:00,0,0.625
Mixer1,2007/06/07 00:00:00,0.56944444,0.625
Mixer1,2007/06/08 00:00:00,0.57638889,0.625
Mixer1,2007/06/09 00:00:00,0,0
......
Packer1,2007/06/04 00:00:00,0,0.625
Packer1,2007/06/05 00:00:00,0,0.625
Packer1,2007/06/06 00:00:00,0,0.625
Packer1,2007/06/07 00:00:00,0.22013889,0.625
Packer1,2007/06/08 00:00:00,0.00486111,0.625
Packer1,2007/06/09 00:00:00,0,0
......

To use this feature, you will need to set "Load graph summary method" ([Display Settings] - [Load graph]) to other than "None".


Export: Spreadsheet Format

Exports values in the inventory graph by a spreadsheet-format (table-format) text file.

Valid when Period (purchase plan) is set to 'Expression'.

(Output example)

,2018/06/06,2018/06/07,2018/06/08,2018/06/09,2018/06/10,2018/06/11
Mixer 1,Day Shift,Day Shift,Day Shift,,,Day Shift
Packer 1,Day Shift,Day Shift,Day Shift,,,Day Shift
Packer 2,Day Shift,Day Shift,Day Shift,,,Day Shift
......

Export:RDB Format

Exports values in the inventory graph by a spreadsheet-format (table-format) text file.

Valid when Period (purchase plan) is set to 'Expression'.

(Output example)

Mixer 1,2018/06/06,Day Shift
Mixer 1,2018/06/07,Day Shift
Mixer 1,2018/06/08,Day Shift
Mixer 1,2018/06/09,
......
Packer 1,2018/06/06,Day Shift
Packer 1,2018/06/07,Day Shift
Packer 1,2018/06/08,Day Shift
Packer 1,2018/06/09,
......

The following message will be displayed if the destination of export is not writable (e.g., read-only file):

"File <xxxxx> is read-only."

Execute export again after making the file writable (by releasing the read-only status).
* xxxxx refers to the file to which data is exported.


Inventory graph

Exports numeric values in the inventory graph.
Valid when inventory graph rows are displayed.


Resource gantt chart

Exports data.
Valid when resource Gantt rows are displayed.


[Ext] Move Selected Operation

To the Right

Moves the selected operation to the right.
Valid when resource Gantt rows and order Gantt rows are displayed.

To the Left

Moves the selected operation to the left.
Valid when resource Gantt rows and order Gantt rows are displayed.


*Top level menu items that have "[Ext]" at the beginning indicate the features that are implemented in Asprova Extension Plug-in Collection.


HelpNo.:698000
© Since 1994 Asprova Corporation, All rights reserved.