General usage screens: Difference between revisions

From Blackbox stations
Jump to navigation Jump to search
 
(22 intermediate revisions by the same user not shown)
Line 3: Line 3:
The data in the open screen can be refreshed in the following ways:
The data in the open screen can be refreshed in the following ways:
* '''View''' → '''Refresh''';
* '''View''' → '''Refresh''';
* with the f5 hotkey.
* with the '''f5''' hotkey.


=== Select period ===
=== Select period ===
When opening various screens, a window may appear in which you can enter the period for which you want to see the relevant data:
When opening various screens, a window may appear in which you can enter the period for which you want to see the relevant data. De default datetimes are set on today 06:00 minus two weeks:


[[File:Period selection.jpg|350px]]
[[File:Periodselection 2 weeks.jpg|350px]]


The start and end date time can be adjusted in two ways:
The start and end date time can be adjusted in two ways:
Line 14: Line 14:
* by clicking the calendar icon and selecting a date.
* by clicking the calendar icon and selecting a date.


After clicking on '''OK''' the screen is opened and the data of the chosen period is shown.
After clicking on '''OK''' the screen is opened and the data of the chosen period is shown. The datetimes are retained for the period selection of that specific screen, as long as you keep the application open. After closing the application the datetimes will be the default values.  


After closing the screen with '''X''' or '''Cancel''' the screen will not open and you will return to the screen from where you started the action.
After closing the screen with '''X''' or '''Cancel''' the screen will not open and you will return to the screen from where you started the action.
Line 30: Line 30:
* click on the '''X''' at the top right.
* click on the '''X''' at the top right.


All running processes are terminated when the application is closed, with the exception of automatic data collection from black boxes.
All running processes are terminated when the application is closed, with the exception of automatic data collection from blackboxes.
 


== Use of lists ==
== Use of lists ==
Line 73: Line 72:
* by holding the '''Ctrl''' key and clicking multiple rows individually;
* by holding the '''Ctrl''' key and clicking multiple rows individually;
* by holding the '''Shift''' key and clicking on two rows. The intermediate rows are selected;
* by holding the '''Shift''' key and clicking on two rows. The intermediate rows are selected;
* clicking '''Ctrl''' → '''a''' selects all rows at once.
* pressing '''Ctrl''' → '''a''' selects all rows at once.


==== Sort data ====
==== Sort data ====
Line 163: Line 162:


=== Conditional formatting ===
=== Conditional formatting ===
In all the list views, except for the [[Ship overview]] screen, a number of conditional formatting rules can be set for each column. The possibilities depend on the value of the comlumn.  
In all the list views, except for the [[Ship overview]] screen, a number of conditional formatting rules and effects can be set for each column. The possibilities depend on the value of the comlumn.  


Conditional formatting can be opened by right clicking on a column heading → '''Conditional formatting''' and click on the specific formatting rule.
==== Apply conditional formatting rules ====
Conditional formatting can be set by right clicking on a column heading → '''Conditional formatting''' and click on one of the standard formatting rules.


After clicking on the desired option, the following screen opens (in this example 'Greater than' under the [[Highlight Cell Rules]] is chosen). Here you can enter the specific value(s) and how the cell should look if it containts that value:  
After clicking on the desired option, the following screen opens (in this example 'Greater than' under the [[General_usage_screens#Highlight_Cell_Rules| Highlight Cell Rules]] is chosen). Here you can enter the specific value(s) and how the cell should look if it containts that value:  


[[File:Highlight cells - standard options.jpg]]
[[File:Highlight cells - standard options.jpg]]
Line 173: Line 173:
By checking 'Apply formatting to an entire row', the whole row will appear the way that's set in the rule, not only the specific cell(s) in the column.
By checking 'Apply formatting to an entire row', the whole row will appear the way that's set in the rule, not only the specific cell(s) in the column.


==== Highlight Cell Rules ====
After closing with '''OK''' the rules are saved and used. After closing the screen with '''Cancel''', the rules are not saved and used. The rules are retained after closing the application.
 
Under [[General_usage_screens#Manage_conditional_formatting_rules| Manage Rules]] you can set formatting rules more specific (i.e. define colours, fonts etc.).
 
==== Delete conditional formatting rules ====
Conditional formatting rules can be removed per rule or all together, by right clicking on a column heading that contains a formatting rule → '''Conditional formatting''' and click on '''Clear rules'''. Clicking on a column header that doesn't have a rule, only allows you to remove all the rules at once.
 
Under [[General_usage_screens#Manage_conditional_formatting_rules| Manage Rules]] you also can delete one or more rules, by selecting the rule and click on 'Delete rule'.
 
==== Manage conditional formatting rules ====
In the conditional formatting rules manager all the applied rules are listed and can be created, edited and deleted. The manager can be opened by right clicking on a column heading → '''Conditional formatting''' and click on '''Manage rules'''. The following screen is opened:
 
[[File:Manage rules.jpg]]
 
To create a new rule click on '''New Rule''', select the desired rule type and fill in the rule description.
 
To edit an existing rule, select the rule by clicking on the appropriate cell and click on '''Edit rule'''. The rule type and description can be changed.
 
To delete an existing rule, select the rule by clicking on the appropriate cell and click on '''Delete rule'''. The rule dissapears in the list.
 
Clicking on '''Apply''' shows the changes in the background. After closing with '''OK''' the rules are saved and used.
After closing the screen with '''Cancel''', the rules are not saved and used.
 
===== Highlight Cell Rules =====
The following standard options are available for highlighting cells depending on specified values or dates:
The following standard options are available for highlighting cells depending on specified values or dates:
* Greater than;
* Greater than;
Line 185: Line 208:
[[File:Highlight cells - custom option.jpg]]
[[File:Highlight cells - custom option.jpg]]


==== Top/Bottom rules ====
===== Top/Bottom rules =====  
This option allows to highlight cells with the smallest or largest values and averages. The following top/bottom rules are standard available:
This option allows to highlight cells with the smallest or largest values and averages. The following top/bottom rules are standard available:
* Top and bottom 10 items;  
* Top and bottom 10 items;  
Line 193: Line 216:
The number 10 can be changed into a different number.  
The number 10 can be changed into a different number.  


==== Unique/Duplicate rules ====
===== Unique/Duplicate rules =====  
This option allows to highlight cells depending on if the it unique or duplicate values in that column.
This option allows to highlight cells depending on if the it unique or duplicate values in that column.


==== Data Update Rules ====
===== Data Update Rules =====
This option temporarily highlight cells when there value changes, increases or decreases.  
This option temporarily highlight cells when there value changes, increases or decreases.  


==== Other visual effects ====
===== Other visual effects =====
Other visual effects for cells are available:
Other visual effects for cells are available:
* Color scales: cells will be filled with solid colors which you can choose from a palette. Based on your selection, the palette gradually shifts through two or three threshold colors.
* Color scales: cells will be filled with solid colors which you can choose from a palette. Based on your selection, the palette gradually shifts through two or three threshold colors.
* Data bars: cells are partially filled with the selected color. The fill percentage depends on how small or large the cell value is compared to other values in this column. You can also draw a vertical axis at the zero value. In this instance, data bars for positive and negative values are displayed in opposite directions and are painted with different colours.
* Data bars: cells are partially filled with the selected color. The fill percentage depends on how small or large the cell value is compared to other values in this column. You can also draw a vertical axis at the zero value. In this instance, data bars for positive and negative values are displayed in opposite directions and are painted with different colours.
* Icons: icon sets allow you to label each value range with a corresponding icon. The system will pick automatically
* Icons: icon sets allow you to label each value range with a corresponding icon. The system will pick automatically values and corresponding colours, which can be changed under [[General_usage_screens#Manage_conditional_formatting_rules| Manage Rules]].


=== Search ===
=== Search ===
Line 258: Line 281:
To open a saved chart, click on the menu item '''Tools''' → '''Graph view''' → '''Custom''' in the relevant screen. Under 'Preset', the desired graph can be selected via the drop-down menu.
To open a saved chart, click on the menu item '''Tools''' → '''Graph view''' → '''Custom''' in the relevant screen. Under 'Preset', the desired graph can be selected via the drop-down menu.


===== Edit preset graph =====
===== Edit preset chart =====
A preset graph can be changed by selecting the appropriate preset in the graph selection window. Lines can be added or removed directly under the axes. After clicking on '''OK''' the changes are saved and the graph opens in a new screen.
A preset graph can be changed by selecting the appropriate preset in the graph selection window. Lines can be added or removed directly under the axes. After clicking on '''OK''' the changes are saved and the graph opens in a new screen.


===== Delete preset graph =====
===== Delete preset chart =====
A preset is permanently deleted by selecting the preset concerned and clicking on '''Delete'''.
A preset is permanently deleted by selecting the preset concerned and clicking on '''Delete'''.


=== Zoom graph in and out ===
=== Zoom chart in and out ===
You can zoom in on a chart in the following ways:
You can zoom in on a chart in the following ways:
# Press '''Shift''' → the mouse cursor changes to [[File:Inzoomen grafiek.png]]
# Press '''Shift''' → the mouse cursor changes to [[File:Inzoomen grafiek.png]]
Line 288: Line 311:
=== Change chart type ===
=== Change chart type ===
By default, a chart is set as a line chart. At the bottom left of the screen this can be converted to a point graph by clicking on '''Point''':
By default, a chart is set as a line chart. At the bottom left of the screen this can be converted to a point graph by clicking on '''Point''':
add picture
 
[[File:Chart - Line and point.jpg]]
 
The selected option will have a thicker black line around the button.
 
=== Set thresholds ===
For the following charts a maximum of four tresholds can be set:
* [[Registrations#Registration_data_chart| The registration data chart]];
* [[Turbo_pressure_and_RPM#Curve_chart| The curve chart]];
* [[General_usage_screens#Custom_chart| The custom chart]].
 
In all cases, threshold 1 and two are for the left y-axis, 3 and 4 for the right y-axis.
 
To set a treshold, enter the desired number in the approproate thershold field the bottom right of thethe screen:
 
[[File:Chart - Thresholds.jpg]]


=== Export chart ===
=== Export chart ===
See [[Export_files#Export chart|export chart]] for more information about exporting a chart.
See [[Export_files#Export chart|export chart]] for more information about exporting a chart.

Latest revision as of 12:55, 23 August 2023

General actions

Refresh screen

The data in the open screen can be refreshed in the following ways:

  • ViewRefresh;
  • with the f5 hotkey.

Select period

When opening various screens, a window may appear in which you can enter the period for which you want to see the relevant data. De default datetimes are set on today 06:00 minus two weeks:

The start and end date time can be adjusted in two ways:

  • by typing the desired date and time in the field. By clicking on the up or down arrow on the keyboard, the relevent cell will increase of decrease. Navigate within the period and selection boxes can be done by clicking on the right or left arrow.
  • by clicking the calendar icon and selecting a date.

After clicking on OK the screen is opened and the data of the chosen period is shown. The datetimes are retained for the period selection of that specific screen, as long as you keep the application open. After closing the application the datetimes will be the default values.

After closing the screen with X or Cancel the screen will not open and you will return to the screen from where you started the action.

Close screen

You can close an open screen in the following ways:

  • FileClose;
  • click on the X at the top right.

In general, any changes made when closing the screen will not be saved.

Quit application

You can close the application from the ship overview screen in the following ways:

  • FileExit;
  • click on the X at the top right.

All running processes are terminated when the application is closed, with the exception of automatic data collection from blackboxes.

Use of lists

Depending on the station type and/or the available licenses, the following screens are available in list view:

  • the ship overview screen in list view
  • the registration screen
  • the configurations screen
  • the deviations screen
  • the status times screens
  • the analysis screen
  • the areas screen
  • the calibration screen
  • the turbo pressure and speed screen
  • the turbo pressure status check screen
  • the TP check weekly overview screen
  • the sms screen
  • the sms history screen

Change the layout of the columns

The layout and display of columns can be adjusted to your preferences. The changes are retained after closing the screen and the application.

Text display column headers

Under View the options 'Horizontal view' and 'Vertical view' are available. The text in the column header will either be displayed horizontally or vertically.

Adjust column width

The column width of one column can be adjusted by hovering over the right edge of the column and dragging it. To set the appropriate column's width automatically, right-click on the column → Best Fit. Automatically setting the width of all column headers can be done by right-clicking on a column → Best Fit (all columns).

Move columns

Columns can be moved among themselves by clicking and dragging them to the desired position.

Hide columns

Columns can be hidden by right clicking on the column and choosing Hide this column in the pop-up menu. The hidden columns can be made visible again by right clicking on one of the column headings and choosing Column chooser. A window appears at the bottom right in which the desired column can be made visible by double clicking on it or dragging it to the desired position in the list.

Display list data

The data in a list can be calculated, filtered, grouped and sorted in various ways.

Select data

A single row can be selected by clicking on it. In some lists, multiple rows can be selected. This can be done in two ways:

  • by holding the Ctrl key and clicking multiple rows individually;
  • by holding the Shift key and clicking on two rows. The intermediate rows are selected;
  • pressing Ctrla selects all rows at once.

Sort data

Sorting a list can be done in the following ways:

  • By clicking on the column header of the field to be sorted, after which an arrow pointing upwards is visible in the column header and the column is automatically sorted in ascending order. Clicking the up arrow will sort in descending order.
  • Right click on the column header and select Sort ascending or Sort descending from the pop up menu.

If multiple sorts has to be applied, the Shift key must be held when clicking on the relevant column headings.

The sorting of one column can be removed by right clicking on the relevant column header and choose Clear sorting. The sorting of all columns can be removed by right clicking on any column heading and choose Clear all sorting.

Filtering data

Filtering list data can be done by applying:

  • a column filter: a simple or complex filter on a single column;
  • the autofilter row: a more complex filter on one or more columns;
  • the filter editor: a more complex filter on one or more columns;

If one or more filters are active, this is shown at the bottom of the relevant screen. By clicking on Edit filter right at the bottom of the screen, the Filter Editor is opened and the filtering can be adjusted.

A filtering of one column header can be removed in several ways:

  • by clicking on the filter icon of the relevant column and choosing Clear Filter in the window, or by slecting the checkbox All.
  • by right clicking on the filtered column header and choosing Clear Filter.
  • by removing the value from the autofilter row.

Filtering of multiple column headings can be disabled by unchecking the checkbox at the bottom left of the screen, or removed completely by clicking the cross next to it:

After closing the screen and the application, the filter settings are saved.

Column filter

Data in each column can be filtered by hovering the mouse cursor over the column header and clicking on the filter icon that becomes visible:. Depending on the contents of a column, a window appears in which you can filter by value, text and/or date. After clicking the checkbox of the desired value on which to filter, the window is closed and the filtered values ​​are visible in the list.

A more complex filter can be applied to columns containing text by clicking the filter icon → Text FiltersCustom Filter.

Auto Filter Row

The auto filter row is shown by right clicking on a column header and choosing Show auto filter row. A row will then appear above the column headings in which the values ​​can be entered directly on which to filter. Depending on the contents of a column, you can filter by value, text or date. An entered value is immediately applied in the list.

The auto filter row is hidden by right clicking on a column header and choosing Hide auto filter row.

Filter Editor

The filter editor can be opened by right clicking on a column heading → Filter Editor. The following screen will open:

To apply the set filtering directly and keep the Filter Editor open, click on Apply. If you want to close the Filter Editor, you can click on OK. The filtering is applied and you are returned to the original screen. After closing the screen with X or Cancel, the set filters are not applied and you return to the original screen.

Grouping data

Grouping data in a column can be done in two ways:

  • drag the relevant column header to the grouping box above it;
  • go to the column header, right click and select Group By This Column.

By doing this for multiple column headers, you can group data of multiple columns. To change the order of the grouping, the relevant column can be dragged to a different position.

The grouping can be removed by column by:

  • drag the column header back to the list view at the desired location;
  • hover over the column header in the grouping box, right click and select UnGroup.

All groupings can be removed at once by right clicking on the grouping box and selecting Clear Grouping.

Column Calculations

If under ViewColumn calculations is checked, there will be a light gray bar below the list. A calculation can be switched on and off by clicking the right mouse button under a column in the gray bar. If there is already a calculation, a new calculation can be added via the item 'Add new summary'.

Depending on the type of data in the column, the following calculations can be chosen:

Calculation Meaning
sum adds numbers
Min shows the minimum value of the data
Max shows the maximum value of the data
Count shows the number of lines
Average shows the average value of the data
None disables the selected column calculation
Clear summary items disables all calculations for that column at once

If there is a calculation, one of the following modes can be selected via Mode:

  • All rows: the calculation takes place over the entire column;
  • Selection: the calculation is done over a chosen selection (see select data);
  • Mixed: the calculation is done over a chosen selection if at least one row is selected, otherwise the calculation is done over the entire column.

Conditional formatting

In all the list views, except for the Ship overview screen, a number of conditional formatting rules and effects can be set for each column. The possibilities depend on the value of the comlumn.

Apply conditional formatting rules

Conditional formatting can be set by right clicking on a column heading → Conditional formatting and click on one of the standard formatting rules.

After clicking on the desired option, the following screen opens (in this example 'Greater than' under the Highlight Cell Rules is chosen). Here you can enter the specific value(s) and how the cell should look if it containts that value:

By checking 'Apply formatting to an entire row', the whole row will appear the way that's set in the rule, not only the specific cell(s) in the column.

After closing with OK the rules are saved and used. After closing the screen with Cancel, the rules are not saved and used. The rules are retained after closing the application.

Under Manage Rules you can set formatting rules more specific (i.e. define colours, fonts etc.).

Delete conditional formatting rules

Conditional formatting rules can be removed per rule or all together, by right clicking on a column heading that contains a formatting rule → Conditional formatting and click on Clear rules. Clicking on a column header that doesn't have a rule, only allows you to remove all the rules at once.

Under Manage Rules you also can delete one or more rules, by selecting the rule and click on 'Delete rule'.

Manage conditional formatting rules

In the conditional formatting rules manager all the applied rules are listed and can be created, edited and deleted. The manager can be opened by right clicking on a column heading → Conditional formatting and click on Manage rules. The following screen is opened:

To create a new rule click on New Rule, select the desired rule type and fill in the rule description.

To edit an existing rule, select the rule by clicking on the appropriate cell and click on Edit rule. The rule type and description can be changed.

To delete an existing rule, select the rule by clicking on the appropriate cell and click on Delete rule. The rule dissapears in the list.

Clicking on Apply shows the changes in the background. After closing with OK the rules are saved and used. After closing the screen with Cancel, the rules are not saved and used.

Highlight Cell Rules

The following standard options are available for highlighting cells depending on specified values or dates:

  • Greater than;
  • Less than;
  • Between;
  • Equal to;
  • Text that contains.

More rule options are available under 'Custom Condition':

Top/Bottom rules

This option allows to highlight cells with the smallest or largest values and averages. The following top/bottom rules are standard available:

  • Top and bottom 10 items;
  • Top and bottom 10%;
  • Above and below average.

The number 10 can be changed into a different number.

Unique/Duplicate rules

This option allows to highlight cells depending on if the it unique or duplicate values in that column.

Data Update Rules

This option temporarily highlight cells when there value changes, increases or decreases.

Other visual effects

Other visual effects for cells are available:

  • Color scales: cells will be filled with solid colors which you can choose from a palette. Based on your selection, the palette gradually shifts through two or three threshold colors.
  • Data bars: cells are partially filled with the selected color. The fill percentage depends on how small or large the cell value is compared to other values in this column. You can also draw a vertical axis at the zero value. In this instance, data bars for positive and negative values are displayed in opposite directions and are painted with different colours.
  • Icons: icon sets allow you to label each value range with a corresponding icon. The system will pick automatically values and corresponding colours, which can be changed under Manage Rules.

Search

The search function is activated by right clicking on a column header and selecting Show Find Panel. An input field for a search term appears at the top left.

Deactivating the search function is done by right clicking on a column header and choose Hide Find Panel.

Using the charts

Only available in: BSS and BMS

Depending on available licenses, different charts are available in the service station: standard charts and the possibility to compose your own chart from a list view.

Open standard chart

The following standard charts are available by default in the service station:

Custom chart

Depending on the type of station and/or the licenses available, a custom chart can be created from the following screens:

Create custom chart

To create a chart yourself, click on the menu item ToolsChart viewCustom in the relevant screen. The following screen opens:

The possible data that can be plotted on the graph are listed under 'Columns' and are based on the screen from which the graph is created. These can be placed individually under the X- or Y-axis by clicking on the line and dragging it to the white area below the X- or Y-axis. The lines can be placed back separately under 'Columns' to not show them in the graph.

Only the date-time can be plotted on the X-axis. The rest of the data can be plotted separately on the Y-axis.

After closing with OK the graph is generated and opened in a new screen.

After closing the window with X no graph is generated and you return to the previous screen.

Preset custom chart

If you wish to re-use a graph you created yourself, a preset can be made.

Create preset chart

To save a chart for reuse, click Add in the chart selection window. A small window opens in which a name for the chart can be entered. After clicking on OK the window is closed and the chosen name is under 'Preset'. After closing the window with X or Cancel the name is not added.

From here you can build the chart by placing columns under the X-axis and Y-axis.

After closing with OK the graph is saved under the chosen preset name and opened in a new screen. After closing the window with X, the graph is not generated and saved. You return to the previous screen.

Open preset chart

To open a saved chart, click on the menu item ToolsGraph viewCustom in the relevant screen. Under 'Preset', the desired graph can be selected via the drop-down menu.

Edit preset chart

A preset graph can be changed by selecting the appropriate preset in the graph selection window. Lines can be added or removed directly under the axes. After clicking on OK the changes are saved and the graph opens in a new screen.

Delete preset chart

A preset is permanently deleted by selecting the preset concerned and clicking on Delete.

Zoom chart in and out

You can zoom in on a chart in the following ways:

  1. Press Shift → the mouse cursor changes to
  2. click on the place graph that needs to be zoomed in and click the left mouse button. This causes the graph to zoom in three times or
  3. hold down the left mouse button and select a region in the graph to be zoomed in. After releasing the mouse button, the selected region is zoomed in:


You can zoom out a chart in the following ways:

  1. Press Alt → the mouse cursor changes to
  2. click on the place graph that needs to be zoomed out and click the left mouse button. This will zoom out the graph three times.

To go to the previous zoom level, you can type Ctrl + Z.

If it is not possible to zoom in or out any further, there is no + or – in the icon.

Scrolling in a chart

When the graph does not fit completely in the screen after zooming in, you can scroll through the graph in several ways:

  • click with the left mouse button on the graph. The mouse pointer changes from to . Hold down the left mouse button and move in the desired direction.
  • click on the scroll bar at the bottom of the graph to move left or right
  • use Ctrl + arrow key (up, down, left, right) to move in the desired direction.

Change chart type

By default, a chart is set as a line chart. At the bottom left of the screen this can be converted to a point graph by clicking on Point:

The selected option will have a thicker black line around the button.

Set thresholds

For the following charts a maximum of four tresholds can be set:

In all cases, threshold 1 and two are for the left y-axis, 3 and 4 for the right y-axis.

To set a treshold, enter the desired number in the approproate thershold field the bottom right of thethe screen:

Export chart

See export chart for more information about exporting a chart.