Create Certified Results

Certified Results define the certified values and allowable tolerances such as Standard Deviation or Minimum/Maximum values for analytes included in Certified Reference Materials.

Certified Results can be created manually or can be imported from a CSV file.  

To Create a Certified Result

1. Open the configuration menu
2. Under Sampling, click Sample lists
3. Click Certified Results
4. Navigate to the bottom of the table and click on the empty row.  The following fields are available to describe the Certified Result.  Fields denoted with * are mandatory
1. CRM Code *
2. Sample Decomposition *
3. Analytical Method *
4. Element *
5. Unit *
6. Certified Values
7. Standard Deviation
8. 95% Confidence
9. Minimum Value
10. Maximum Value

To Import Analytical Methods: 

1. Open the configuration menu
2. Under Sampling, click Sample lists
3. Click Analytical Methods
4. Click the Import button on the top right-hand corner of the window
5. Click the Browse link and select your CSV file
6. Click the Import button
   

TIP: to quickly produce the file format needed by the Import, first Export the Analytical Methods data using the Export button, and then work within that file.  Note that entries that already exist cannot be re-imported or updated and should be removed from the file before importing any new Analytical Methods.

NOTES:

• In order for the Certificate Import to properly validate Reference Material and Certified Results, the following fields in Certified Results need to exactly match what is in Lab Services and Method Details:
• Sample Decomposition
• Analytical Method
• Element
• Unit

If these fields do not match exactly then the validation will not be performed.