<< Click to Display Table of Contents >> Navigation:  Chapter 4 Projects > Exporting Data > Exporting Tables > Creating a Lab QA/QC Table

Lab QA/QC tables can be used to list the required, analysed, and missed parameter analyses for each sample as shown in the spreadsheet below. To create a new lab QA/QC table for a project select File > Export > Excel Tables > Lab QA/QC. The Lab QA/QC Report form will be displayed.

 

At the top of the form there are buttons for opening and saving script files. Script files are used to save the settings in a form and can be used to generate tables with similar settings.

 

Tables can be either dynamic or non-dynamic. Dynamic tables are created with the latest data every time they are opened. Non-dynamic tables are static and stored in the Datastore, these tables will show the data at the time they were created.

 

 

This form has four tabs for Data, Filter, Options, and Page Layout. The editing of these tabs is described in the sections below.

 

The Data, Filter and Options tabs are described below. The Page Layout tab is the same as described in the Lab Analysis Table are is described in that section. After the information on the tabs has been entered, the Export button at the bottom of the form will export the data to an Excel spreadsheet. When the spreadsheet has been generated it will be opened in Excel.