Advanced Tools Shewhart Control Charts for Excel + Power Query

The analytical tools of our software (software), which has no analogues in Russia, can confidently compete with the world's best software for statistical process control (Statistical Process Control, SPC), having the functionality that is in demand in the field of quality and improving operational efficiency, which competitors do not have, in particular: - analysis of data on 18 reference books of factors (types of sources of variation) used for point labels and separation of the control chart graph by vertical lines of the zones of factors on the XmR-map of individual values ​​and the XbarR-map of averages and ranges of subgroups; - automated grouping of data into rational subgroups according to 18 factor directories used as types of variation sources for the XbarR-map of averages and ranges of subgroups allows analyzing data for eighteen regroupings; - automated construction of a control chart of a map with a histogram and a scatter plot according to a user-selected query and connection to remote data sources through the unique Power Query tool included in Microsoft Excel 2016+, which provides connection to all known types of data sources without the need for knowledge of query languages; - presentation of histogram data in the form of an additional scatter plot , which demonstrates what the histogram hides from the analyst; - reflection on the histogram of production narrowed tolerances for sorting products "in tolerance" and "out of tolerance" taking into account the error and bias of the measuring system; - evaluation of the displacement of the measuring system detected by the control card ; - determination of the minimum increment (effective increment) for the measuring system; - control XbarR-chart for average and ranges of subgroups, with a choice of subgroup size from 2 to 100, while in [11] GOST R ISO 7870-2-2015 there are coefficients for constructing control XbarR-chart only up to 25 subgroups; - Shewhart control charts can be built by an analyst using a simulator with historical data added sequentially to the control chart in the order they were generated. Instead of filling our software with various abstruse tools of theoretical statistics, we focus on the full practical use of the most effective statistical process control methodologies and constantly increase their analytical functionality. User support is provided by professionals of our Center in Russian. The basic principle of our software: Install and use. It is the best solution for operational management of Shewhart control charts at the shop floor and subsequent analytical work with control charts, as well as for monitoring key process indicators in dispatch centers and on television panels in meeting rooms and executive offices. Screenshot of the program with the control panel for graphs of the XbarR control chart of averages. A special advantage is the program interface for easy use of the available functions by your staff, you do not need to remember anything - all buttons have an intuitive meaning of the functions they control, have clear labels and contextual help information . We are constantly working on improving our software, both in terms of new features and in terms of reducing the cognitive load on users. The rapidly outdated demo videos presenting our software on the site testify to the constant introduction of new features, but we try to update the screenshots of the software promptly. Buttons (icons) in the ribbon toolbar of the Excel add-in and large buttons in the scrolling software control panel display the meanings of the function, remind the user of the software's capabilities, and report the on/off status for the respective functions. Buttons (icons) in the toolbar ribbon of the Excel add-in have short pop-up text tips, and large semantic control panel buttons are provided with links to the description of the corresponding function on our site. Navigating through function icons in the Excel Add-in toolbar ribbon opens the corresponding file sheet while focusing the control panel on the buttons of the function group selected in the ribbon, moving that group to the top of the control panel. The Excel Control Chart toolbar ribbon (add-in) becomes visible only when you activate an Excel workbook with our software. If you're just working with other files in Excel, the Control Charts tab won't take up space in the toolbar. You can share checklists prepared with our software with anyone. Such files can be opened on any computer as normal Excel files, but without the possibility of using the functions of our program. The analyst can combine any of the functions of our software at his own discretion for comprehensive qualitative data analysis and obtaining the information about the processes that is not possible to obtain by other methods. By purchasing our software product, you gain competitive advantages through the automation of statistical process control (Statistical Process Control, SPC) and access to the unique, by world standards, competencies of professionals in our Center in the field of applying Shewhart control charts to improve business as a whole, which you can be sure of with our support.