Automatic update function for Shewhart control charts and histograms with all saved user settings (43 parameters)

This feature provides the unique ability to configure automatic chart updates with a selected timeout, or to use a list of customized charts (with all user-applied settings, from selecting a data file before rational grouping of data ) to quickly open them with updated data. The number of chart groups and the length of the list of charts in the groups have no limitation on the number of positions stored in them. All working chart settings (parameters), and today there are already 43 of them, which are made by the user, are saved in the properties of each chart from the list.

If you need to make changes to the settings of a chart previously added to the list, you need to select its name from the drop-down list in the auto-update control panel, then select new chart parameters, and then, if you want to save it under the same name, click the [Add chart] button. , the graph data will be overwritten. If you want to add a new name for a setting, change its name before clicking the [Add schedule] button.

All auto-update list settings are saved in the program's SQLite database and are loaded automatically when the program is restarted. For multiple changes, for example, the path to data files, the folder for saving pictures and their format, you can edit records directly in SQLite using the program DBeaver Community (Open-source version)

Settings are not saved intentionally scaling control card and demo removal points (subgroups).

Attention!
Each time you open a chart from the list, the data is reloaded from the selected source and all parameters and settings saved by the user are applied to it. When adding a data source file, new data will be reflected on the chart when it is selected from the drop-down list or in auto-update mode with a set timeout.

If you delete rows in the data source with the original data that were taken into account when the graph was saved in the list, you will have to re-configure the affected graphs and resave them in the list, for example, for functions fixation of control limits or constructing control limits for individual series .

Adding new data at the bottom of the source data table (normal option) does not require any adjustments.

Figure 1. Main menu. A hint is displayed when you hover the mouse over the button to go to the control panel for automatic chart updates.

Figure 2. Control panel for automatically updating Shewhart control chart graphs. A timeout value (15 seconds) has been entered, a group of graphs and a graph in the auto-update list have been selected. A contextual tooltip is displayed when the mouse cursor hovers over an activated chart editing toggle button.

Figure 3. A contextual tooltip is displayed when you hover the mouse over the activated toggle button for editing chart groups. The buttons for sorting the list of graphs in a group, deleting graphs, and starting automatic updating of graphs with a set timeout are deactivated.

Figure 4. The name of the graph with the Shewhart control chart in the auto-update list has been changed. A drop-down tooltip appears when you hover the mouse over the button for changing the chart name.

Figure 5. New settings have been made for the chart with the Shewhart control chart and a new name for the chart has been entered in the auto-update list. A drop-down tooltip appears when you hover the mouse over the [Add or overwrite chart] button.

Figure 6. The [Add or overwrite schedule] button is clicked. After successful saving, a confirmation information window opens.

Figure 7. A drop-down list is displayed with the names of previously saved graphs with Shewhart control charts.

Figure 8. A drop-down tooltip appears when you hover the mouse over the [Sort graphs] button for graphs with Shewhart control charts in the selected group of graphs.

For the convenience of managing large lists, a window for sorting, searching and filtering according to the auto-update list is provided. The auto-update list has no restrictions and can contain control chart graphs for all key characteristics of all aircraft parts and components.

Figure 9. A window for manually sorting the list of graphs with Shewhart control charts in the group of auto-update graphs is opened. The vertical scroll bar of the list is activated when the length of the list exceeds the size of the sorting window.

Moving or renaming a file, renaming a sheet in a file with source data, renaming columns in the data source with Types of factors that were used when constructing graphs in the auto-update list (the program will display a message about this), for example, in labels of points or in the selection of vertical separators of series of subgroups , or in rational grouping of data by type of factors, will require adjustment of the corresponding fields by selecting new values, after which it will be necessary to save the configured chart type in the auto-update list under the same name or delete an unclaimed chart from the list.

Figure 10. The name of the graph is selected in the auto-update list to be removed from the graph group. A tooltip appears when you hover the mouse over the [Delete chart] button.

Figure 11. A tooltip appears when you hover the mouse over the [Start auto-update] button.

Figure 12. Control panel for automatic updating of graphs with Shewhart control charts. Auto-updating of charts for the selected group of charts has started. A tooltip appears when you hover the mouse over the [Stop!] button. The indicator to the right of the [Stop!] button counts the total operating time of auto-update in the format [hh:mm:ss].

Checking the [Save in graphic format] checkbox allows you to automatically save graphs when walking through the auto-update list in user-selected ones. folder and file type, for example, in vector (PDF, SVG) or high-resolution raster format (PNG, 300 dpi).

This function allows, for example:

• provide graphic copy files with control charts to involved employees by selecting appropriate folders for saving, and the folders themselves can have restricted access;
• connect automatically updated graphic files-copies of control charts to corporate applications: CAD (CAD)- , PLM- , ERP , MES- , LIMS systems , through links.

Figure 13. A hint is displayed when you hover the mouse cursor over the [Save in graphic format] checkbox.

Figure 13. Model in KOMPAS-3D with links to PDF files with graphs of Shewhart control charts of key characteristics of the part.