This happens all the time. Internally, your organization has a set of standard processes and policies that help you create quality products consistently and repeatably. Some of the data you observe and collect is just for your internal controls and some of it is needed to meet your customers' requirements. The Data Management module has tools to help you filter the right subset of data from your larger data set accurately every time. We call this function a COA Template record.

Request a Sample package of our Certificates of Analysis (PDF).

All the data you collect from your Quality Control tasks can be entered into the forms provided by our Data Management module. There is no longer a need to search different spreadsheets or Word documents for all the results needed for a Certificate of Analysis. The data you enter has a several reference fields linked to it, most notably the lot or serial number. When you create the Certificate of Analysis, you can reference the lot number of the material being certified and all its relevant data is readily available.

We provide several fields in the Certificate of Analysis Generator to identify the fill material that is being certified and to find the correct lot records. We also display the packaged item ID.

Quality Essentials Suite is a concurrent multi-user software solution that is licensed for unlimited user access. It should eliminate those bottlenecks and make retrieving data and archived reports much simpler. Check out our pricing page for more information.

In our Data Management module, we provide a report designer that supports unlimited creation of new reports. You can simply:

• Create the customer-specific layout
• Include the necessary images for the customer's logo
• Give the report a name
• Select the report layout when you need to create a new COA

There are Preview features that will allow you to confirm you selected the right report. No more waiting until after you entered data to find out you were using the wrong spreadsheet and then having to create the documents all over again.

With the Data Management module, you don’t need to do these kind of calculations manually or offline. We designed the software to include a large variety of functions for calculating results on a Certificate of Analysis. All the data you collected is available in the software, so we can run processes that will summarize the data, locate highest and lowest values, and even calculate average or standard deviations. And you can include these calculations on the Certificate. You don’t need to do those calculations manually.

The data collection functions in the Data Management module can support more than 11 different datatypes. These include:

• Pass/Fail Quantities
• Numbers with up to 5 places of decimal precision
• Boolean
• Alphanumeric text
• User-defined system lists for events like Country of Origin
• Dates
• Times
• Date and Time combinations
• Document attachment paths
• Standard functions on range data: Average, Minimum, Maximum, Std. Deviation, Sum
• Spreadsheet formulas

We know not every operation is identical and that information needs vary by industry and regulatory body. This is why we have included user-defined fields as a feature of the product. They are easy to setup and allow you to define the data type, which means you are less likely to have data entry errors. User-defined fields are a great way to include extra or unusual data easily and consistently.