If you are currently running a version of SQCpack prior to 7.0.18029.2, upgrading to version 7.0.19079.3 will require an update to your SQCpack database. Typically, your IT staff will perform this update at a time when no other users are using SQCpack. We recommend that you make a backup of your production multi-user SQCpack database before you update that database. After the update has been applied, you must run SQCpack 7.0.18029.2 or higher to open the upgraded database.
Expanded out-of-control testing for run charts – SQCpack now support runs of points above or below the centerline on all control and run charts.
Fractional Data Entry –Users can enter fractions and SQCpack will automatically convert them to the decimal equivalent.
Improvements to histogram when one or more specifications are missing. Now better use of space is available by not displaying statistics that can’t be computed due to missing specification(s).
Pareto chart – Bar colors can now be changed from the standard bar colors.
Reports – Improved group-by labels when grouping by a weekly timeframe.
Certificates of Analysis – Percent symbols (%) can now be displayed in the Units of Measure column.
Improved the ability for customers to create Control Chart templates for use when there is a need to create ‘blank’ control charts. This is useful when a user needs to enter results on paper for later entry into SQCpack.
Added a new Choice List option that allows specific selections to be available during data entry based on the login name. This feature is beneficial when one user should only be able to select items from a specific Choice List while another user should only be able to select items from a different Choice List.
StatBoard can now conduct out-of-control analysis for three-way charts.
Improvements to allow better control of the displayed number of decimal places for histograms.
Users can now control the number of decimal places used for statistics in a Certificate of Analysis.
Improvement to Data Group Importing prevents redundant Choice Lists from appearing.
Added an option to include a border around each cell of a histogram. This option makes it easy to see each bar of the histogram so that when a histogram is printed, the user can view the bars while not wasting toner.
Creating Reports has been improved by adding a filter option to select specific Data groups used in the Report.
The chart default style has been updated to make it more visually appealing.
Improvements were made to reduce the amount of computer memory that SQCpack uses.
Saving default Annotations has been improved to include all elements of Annotations.
Short-run charting including Mean ranges, Difference, Zed W, and Product Short Run Charts, which are useful when the target of the data is different from sample to sample.
Three-Way Charting used when the variation within a subgroup is small, causing control limits to be too narrow for a traditional X-bar chart to be useful.
Recent Activity which allows users to view dynamic reports and StatBoards™ that automatically update based on recent activity.
Multiple Y-Axis Scales for Multi-Line Charts which allows the y-axis scale can to be unique for each data line when comparing two or more data lines with very different data.
Certificate of Analysis improvements including: Separation of analysis information based on an identifier within the C. of A.; and the ability to print the supporting data used to create the C. of A. within the C. of A. selection screen.
Improved performance speed when using the Single Subgroup and Worksheet editors, when modifying a data group, and for reporting.
Improved system to display Work Instructions, Corrective Actions, and Images associated with characteristics and/or Data groups.
Added the ability to run multiple CMM Integration configurations simultaneously.
Added a notification of which out-of-control test triggered the condition when an out-of-control condition occurs during data entry.
Includes the ability to easily see the Division associated with charts and reports.
Corrected an error causing Certificates of Analysis to display incorrectly.
Added a setting to change the number of subgroups in memory making data entry faster
Corrected an issue when excluding subgroups in charts
Corrected an error for Reports that use grouping and a numeric identifier
Improved prompting for Causes, Notes, and Corrective Actions when using the Worksheet editor
Views were created for Data groups making it easier for apps, such as Power BI, to read from an SQCpack database
Improved Searching within a data group
Added the ability to select from a Choice List when filtering charts
Improved cloud-based concurrent-user license for easier deployment
Improved the look of control limits when multiple control limits are in use
Improved Importing data from Excel to allow the user to change the type of identifier
Made visual improvements to the edit panel in a chart
Audit trail improvements for Causes, Notes, and Corrective Actions
Improved the speed of the document display system during data entry
Added feature to display documents during data entry so documents automatically switch when the user moves to a different characteristic
Added the ability to show zero as a Pareto bar label
Added the ability to group data using bi-weekly as the method
Improved editing for Causes, Notes, and Corrective Actions during data entry
Improved data entry experience when working with Pareto data
Corrected an issue with StatBoard and rules for percent out-of-spec
Audit trail improvements when count data is used
Added capability to support FIPS-compliance
Added a single subgroup data entry option
Improved performance when creating Reports utilizing large amounts of data
Improved formatting decimals for Reports
Added the ability to use external data in Reports
Added the ability to create default annotation styles
Added the ability to list which Divisions are applied to data groups and charts
Added an additional chart label option for Pareto Cost charts
Improved Causes, Notes, and Corrective Actions dialog box when adding or editing for characteristics
Last modified date is updated for last new data entered
CMM Improvements to allow multiple Excel files to be read simultaneously
Improved Find and Search capability in the subgroup editor
Improvements to Certificate of Analysis:
- for using Row number in the filter condition
- support for filter prompting
Added the ability to view Causes, Notes, and Corrective Actions within the chart and in a legend below the chart
Added support for French language
Added an easy way to select and display capability statistics on control charts
Added an out-of-spec indicator for a control chart to easily determine if any observations in a subgroup have out-of-spec data
CMM Integration improvements:
- Improvements to auto-fill when creating configuration files
- Added a feature to keep CMM configuration files running continuously
Improved and consolidated Annotations and Extra lines while editing a chart
Additional date format options added to x-axis labels for control charts
Added Common Specifications allowing users to apply the same specifications to many characteristics
Added Multiple Specifications which allows the same characteristic to support more than a single set of specifications
Added Inactivity timeout, freeing up licenses that are not actively used
Improved StatBoard® performance
Added “SQCpack User” allowing for the user be automatically entered during data entry
Improved the ‘discoverability’ of chart title macros
Improved the User Interface for calculated characteristics
Improved the User Interface for view-only data
Improved the presentation of the data grid above control charts
Improved the User Interface when editing charts
Improved the presentation of the data grid above control charts
User Interface improvement for measurement and calculated characteristics
User Experience improvements when creating a Calculated characteristic
Improved Annotations by adding a user-controlled default setting
CMM Integration improvements:
- Increased the number of rules available
- Improved the way CMM integration can be closed
Charting improvements including the ability to show observation points on average charts
Added the ability to default to a Median line on Run charts
Added the ability to use CMM Integration with Excel files (Previously only ASCII files were supported)
Added the ability to duplicate characteristics in a data group
Added the ability to include Notes and Corrective Actions to alerting messages
Improved the data entry experience for data groups that have a large number of characteristics
Added the ability to hide default charts
Improved the User Interface for calculated characteristics
Added the ability to copy characteristics within a data group, making it easier to create data groups that have many similar characteristics
Improved the data entry user experience when calculated characteristics are used
Charts can now use specifications that are defined in: the characteristics of the data group, the original data source, or the chart itself
The PQ User Community can now be accessed from within the program
Improvements to CMM integration including better messaging and ability to add notes
Added thumbnail images for multi-charts
Improved tooltip information for Date and Time identifiers
Improved style of Capability Summary chart
Added the ability to include Six-Way Analysis™ charts in StatBoards
Improved annotations to allow text to wrap
Improved the way Six-Way Analysis utilizes filters
Added “Prompt the user” to create a backup before a Data Group is deleted
Added the ability to display charts from a Chart Group in a slideshow
Improved memory usage
Messaging and alerting added
Added feature for adding an image macro
Support for Cusum chart
Added the ability to edit a chart within a Multichart
Ability to export/import external single charts
User can now control x-axis labels of linear charts in Six-Way Analysis™ charts
Added Slideshow feature
Support for EWMA chart
Added share button in finder
Added optional automatic audit purging
Ability to label Histogram cells at the left, center or right
Added multi-level x-axis capabilities
Added ability to control spec line settings individually
Real-time chart updates immediately after default chart changes
Added support for Cloud license
Auditing includes the row number when a row is edited or deleted
Multiple improvements to Pareto charts
Ability to print specs in Print data
Added units of measure to measurement characteristics
Added a new Date/Time format option
Ability to create choice lists for any text identifier column
Added ability to auto populate choice lists from existing data
Added vertical layout option and 'show only selected columns' option on step 3 of wizard
Added ability to export, import, and print data from within data entry
Made Chart Titles more explanatory when editing the Font attributes
Improved annotations and user experience for removing an annotation
Improved view of chart when CHARTrunner charts are imported
Improved the default column widths for new data groups and the cell focus when adding data to an existing data group
Added ability for two or more groups to be opened simultaneously when the both use the same data device
Added helpful message for update queries that likely need to replace '*' wildcard with '%'
Added /IMPORT65 command that allows many databases to be imported at one time
Improved how limits and lines are labelled when the UCL and/or LCL is above 100 or below 0 for p- and p-prime control charts.
Added the ability to format decimal places when data is displayed above the chart
Multi-charts dynamically update when the scale slider is used.
Data entry for np-chart data was corrected
Removing a chart template and reapplying the default chart template sets the chart back to SQCpack defaults.
Corrected issue when the lower part of "New" in the split button was selected when creating a new data group
Corrected custom cell width for histograms when no variation exists in the data
Fixed issue where negative limits were not being hidden when checkbox was selected to hide them
Pareto category font labels are dynamically changed rather than requiring a manual refresh
Performance improvements were made to queries where a filter is applied.
Improved start/stop button behavior used in CMM integration.
Improved multi-selection deletion in several lists.
Enhanced Pareto so that single pane chart with appropriate column mappings can easily produce a totals chart.
Improved saving of y-axis and x-axis changes in chart editor.
Improved support for time-only identifiers in data entry and charting.
Improved memory management when doing data entry with real-time charts visible.
Improved Fixtures that use the prompt for identifiers feature.
Improve ability to delete ALL rows from a data group data entry table.
Added ability to suppress footnotes in reports.
Added the ability to remove an annotation with the delete key while viewing a chart.
Improved initial data entry column heading width and better text wrapping when needed.
Added the ability for double-click to zoom and un-zoom a chart in a multi-chart.
Improved filtering when more than one data groups us used in a report.
Improved handling of empty cells when creating Pareto charts.
Performance improvements in retrieving chart and data groups. This is most noticeable when there is a large numbers of items and/or when using a remote database deployment.
Improve handling of alerts when a calculated characteristic is used in an alert.
Allow displaying more than forty cells in a customized histogram.
Six-Way Analysis™ -- A combination of six charts that provides an at-a-glance overview of your process.
Capability summary chart – Allows at-a-glance capability and performance indices to be evaluated.
Normal Probability Plot – Allows process normality to be easily evaluated.
Global filter for multi-charts – Saves time by allowing easy editing of the charts in the multi-chart with one filter instead of editing each chart individually.
Implemented ability to group data in reports -- so that analysis can easily be performed (and grouped) by batch number, lot number, shift, or any other identifier
Quick Find feature – Easily find and add data so that less time will be spent searching for data groups.
Quick report feature – Allows a statistical summary report to be created and displayed in seconds.
Ability to create Chart List Filter from Finder
Added the ability to create new categories from ‘Classify’ dialog
Added the ability to easily change to recently used databases
Added save report as PDF to right click and command line interfaces
Added new and changed default markers for multi-line charts
Added ability to have titles be part of chart template
Calculated characteristics can now accept notes, causes, and/or corrective actions
Added option to suppress chart titles for individuals charts displayed in a multi-chart
Added the ability to save a report as pdf without first previewing the report
Option for long date/time format for date identifiers
Export data works for calculated characteristics
Added support for filtering to both Print data and Export data as well as improved these dialogs.
Support for calculated characteristics in reports
Added the ability to assign Division and/or Category for many groups and/or charts at one time
Speed – Performance improvements:
Improved performance when grouping is used in reports and charts
Improved speed when importing data into an existing data group
Improved speed for reports to preview or print large reports
Speed up thumbnail view of charts in Finder – Especially beneficial with a large number of charts in a database
Improved memory usage by updating chart thumbnails in the background
Audit trail Improvements
Track changes made to a choice lists, changes made to specification values, and renaming groups
Enhanced audit trail:
More details when group is updated
More details when specifications are changed
Added change chart and change report audit records
UI / UX
UI Improvements in Edit Filter View
Added new options for how to label lines edit panels
Improved how categories are applied with 3-state checkbox when selecting categories
Horizontal scroll improvements importing from csv with many columns
During data entry, added column highlighting color to better define data and column associated with the data
Made columns resizable in report editor
Data entry animation on chart with switching characteristics
Many improvements to CMM integration including better support for multiple data files
Charts imported from SQCpack 6.5 will automatically have a category name applied to them
Improved the chart sub-list from the data groups menu
Improved data entry experience for date and time identifiers
Improved “delete group” interface while editing groups
User can specify the number of samples to use for the Real Time Chart
Bulk add/edit for categories from Finder
Charts that use “@” command in their title where not printing the chart title if printed from the chart finder.
Charts that use “@FILTER” command in their title were not displaying the contents correctly.
SQCpack 6.5 data groups with documents and/or images are now mapped appropriately.
SQCpack 6.5 databases with passwords will be detected and guidance displayed before an import can continue.
Custom queries that use SQL Server were improved for editing.
Improved displayed date format to respect Windows date formats.
Multi-charts and Reports that once included a chart or characteristic that was removed by the user can now be edited appropriately.
User roles created using the default settings were not created properly.
Added Ctrl+Shift+Alt+D command to detach the current single-user database and fixed path error when creating single-user database.
Sample Report 1 was corrected to display properly.
Additional minor improvements were made such as: Added horizontal grid lines in data entry, better Pareto labelling for stacked bar charts, updated the help file, added additional scroll bars, updated the sample database, added an indication for number of items selected, added Median chart testing in the StatBoard, improved import dialog for .CSV files, and improved font size of titles when data is imported from a 6.5 database.
An update was made when saving SQCpack charts as CRF files.
An issue with the out-of-control classifications has been corrected.
In rare cases real-time charting locked up.
An update was made to reference charts and reporting.
An update has been applied for opening the data editor on a 64bit Vista PC.
A reporting issue has been corrected.
An issue in the reporting feature dealing with columns derived from calculated formulas has been corrected.