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

Lab Analysis tables can be used to list analyses for selected samples as shown in the spreadsheet below. To create a new lab analysis report table select File > Export > Excel Tables > Lab Analyses. The Lab Analysis Table form will be displayed.

 

At the top of the form there are buttons for opening and saving scripts. Scripts are used to save the settings in a form and can be used to generate tables and crosstabs. Crosstabs are used to generate Excel spreadsheets that contain more then one table using previously stored scripts.  

 

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.

 

 

If the Crosstabs is not checked, this form has nine tabs for Data, Results, Filter, Regulations, Limits, Statistics, Options, Format, and Page Layout.  If the crosstabs is checked this form will have one tab for Crosstabs described below.

 

There are two options for selecting regulation limits. The first is the same limit is used for all samples as shown on the Regulations tab. And the second is a different limit is used for each sample or well (as shown on the Limits tab), this can be appropriate when site specific limits are required for each well location. The editing of these tabs is described in the sections below.

 

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.