WinSPC.comWinSPC.com
Global leaders in real-time SPC software solutions
  • Software
    • WinSPC
      • WinSPC
      • Capture Data
      • Monitoring & Alarming
      • Analysis & Reporting
      • Industries Using WinSPC
      • How to Buy WinSPC
      • Supply Chain Quality
      • Achieve Regulatory Compliance
      • WinSPC System Requirements
      • Gauge Interface Hardware
      • Download WinSPC Trial
    • WinSPC Hosted Solution
      • WinSPC Hosted Solution
      • Retain Local System Flexibility
      • Gain These Hosted Solution Benefits
      • Go Beyond Traditional SaaS
      • Data Protection & Security
    • WinSPC Envision
      • WinSPC Envision
      • Visibility
      • Mobility
      • Interactivity
      • How to Buy WinSPC Envision
      • Envision System Requirements
    • What is SPC?
      • What is SPC
      • SPC Training Materials
      • SPC Tools
      • SPC FAQ
      • SPC Glossary
  • Services
    • Implementation Assistance
    • System Integration
    • Customer-Specific Solutions
    • Software Validation
    • SPC & Software Training
      • SPC & WinSPC Courses
      • Course Delivery Options
      • Directions & Lodging
  • Resources
    • Contact Us & Support
    • Activate WinSPC Licenses
    • Customer Downloads (PRIV)
    • WinSPC Knowledgebase
    • Choosing WinSPC (BLOG)
    • DataNet News (News BLOG)
    • Ask The Expert (Tech BLOG)
    • DataNet Facebook Wall
    • DataNet Twitter Wall
Home » Ask The Expert » WinSPC Tips & Tricks: Easily Create a Report to Meet Regulatory Requirements | WinSPC Tips & Tricks

WinSPC Tips & Tricks: Easily Create a Report to Meet Regulatory Requirements | WinSPC Tips & Tricks

WinSPC real-time statistical process control software can help you to easily generate a COA report to clear regulatory requirements.

Creating a Certificate of Analysis Report With Tag Values

This report will produce a Certificate of Analysis (COA) style report (similar to existing COA reports in WinSPC), but will also contain a list of tag names and unique tag values at the top of the report. The report will combine the tag values for each of the variables into a comma separated list of unique tag values. This report can be useful if you are filtering your underlying dataset by one tag value (such as “Order Number”), but want to see a list of all the “Serial Numbers” that were entered as tag values for that particular “Order Number”.

An example of the report is shown here (in this example, the user filtered the underlying data to a specific “Customer Order Number”):

This report will produce 1 page per WinSPC part that is contained within the underlying dataset or object the report is executed on. If the part contains more than 40 variables, multiple pages will be produced for a single part, but a single report page will only show information regarding a single part. Please note that if multiple report pages are produced for a single part, the list of tag values at the top of the page will only represent the tag values associated with the variables shown on that page of the report.

There are also some available options to add some color to the report. The following options are available:

  • Add ‘gray banding’ to allow for easier reading of the rows. This will alternate gray/white graphical bands every group of 3 variables (the first three variables will have a gray background, the next 3 will have white, etc.).
  • Color the values in the ‘Cpk’ according to its value. Cpk values less than 1.00 will be red, values between 1.00 and 1.33 will be yellow, and values greater than (or equal to) 1.33 will be green.
  • Color the values in the ‘Cp’ column (according to the same rules for the Cpk coloring).
  • Color the values in the ‘Ppk’ column (according to the same rules for the Cpk coloring).
  • Color the values in the ‘Pp’ column (according to the same rules for the Cpk coloring).

These options can be turned on or off in the report template properties, as seen here:

To turn a color option on or off, open up the properties of the report template, click on the checkbox next to the ‘True’/’False’ text for the item and then click “OK” to save the report template.

A couple sample outputs of the report can be seen by downloading the PDF attachments below.

To use this report template, simply download the report template export (“COA (with tags).exp”) from the attachments below and import the template into your WinSPC system.

Attachments
  • COA (with tags) (with colors).pdf (102,687 bytes)
  • COA (with tags).pdf (100,487 bytes)
  • COA (with tags).exp (519,983 bytes) [Please contact support at 248.447.0140 or support@winspc.com]

Access the entire WinSPC Knowledgebase

About DataNet Quality Systems

DataNet Quality Systems empowers manufacturers to improve products, processes, and profitability through real-time statistical software solutions. The company’s vision is to deliver trusted and capable technology solutions that allow manufacturers to create the highest quality product for the lowest possible cost. DataNet’s flagship product, WinSPC, provides statistical decision-making at the point of production and delivers real-time, actionable information to where it is needed most. With over 2500 customers worldwide and distributors across the globe, DataNet is dedicated to delivering a high level of customer service and support, shop-floor expertise, and training in the areas of Continuous Improvement, Six Sigma, and Lean Manufacturing services.

May 6, 2020 Matthew Holden

Leave a Reply Cancel reply

You must be logged in to post a comment

Search WinSPC.com

Evaluate WinSPC

  • Quick Video Tour
  • Talk to an Expert
  • Download Trial
  • Request a Quote
  • Plan an Online Demo

Follow Us On

Follow Us On FacebookFollow Us On LinkedInFollow Us On TwitterFollow Us On YouTube

Find it on WinSPC.com

Follow Us on

Follow Us on FacebookFollow Us on LinkedInFollow Us on TwitterFollow Us on YouTube

Contact Us

866-4WINSPC

248-357-2200

248-357-4933

info*dqs.com

Southfield

Michigan USA

my_location Find Us - Map

Helpful Links

  • Knowledgebase Site
  • Ask The Expert – BLOG
  • What is SPC?
  • SPC Tools
  • SPC FAQ
  • SPC Glossary
  • Docs & Downloads

About Us

  • About DataNet
  • Find A Reseller
  • Contact Us & Support
  • Industries Using WinSPC
  • Customers Using WinSPC
  • DataNet News
  • DataNet Facebook Wall
  • DataNet Twitter Wall
  • Our Privacy Policy
DataNet Quality Systems - 29200 Northwestern Hwy - Southfield, MI 48034 -- Copyright © 1995-2022 -- All Rights Reserved