Starting a new project (SQL Server Version)

Navigation:  Managing Projects (SQL Server Version) >

Starting a new project (SQL Server Version)

Previous pageReturn to chapter overviewNext page

General instructions for starting a new site/project are as follows, you may like to expand this with internal proceedures

 

1. Starting a new Site / Project

 

Start ESdat.  Click on the ‘New’ icon on the startup form, then

If this is to be a new Project at a new Site click 'New Site and New Project'

If this is a new Project at an existing Site select the Site, and click New Project

If this is an additional Site for an existing Project select the Project and click New Site.

Fill in the Site / Project details

 

2. Loading Location data (optional)

 

From the ESdat menus select Import – Templates - Data Tables,

In the white Listbox double click on the ‘Location’ table

A template will open in Excel.  Enter the data.

Select the Import button () on the Excel toolbar, click Import.

Fix any problems and reimport.

 

3. Loading Lab Data

 

From the ESdat menus select Import, Laboratory File.

Navigate to the laboratory file.  (The laboratory file must be in the ESdat format)

Select the ‘Sample’ file.  The file should then open up in Excel.

Specify the field duplicates and blanks and import as described in the tutorials

 

*When a field duplicate is imported, it is important that the sample type is changed from Normal to Field_D under the Sample Type column, similarly Interlab Duplicates must be changed to Interlab_D.  The parent sample will need to be assigned in the Parent Sample column.  Details on this can be obtained from the field person/sampler.

 

4. Loading Environmental Standards

 

From the ESdat menus select Import, Environmental Standards.

Navigate to the Environmental Standards file.  (The file must be in the ESdat format,

Select the file that relates to the standards you want.  The file should then open up in Excel.

The file may contain multiple sheets which need to be imported if the standard requires evaluation of a summation of compounds.

The file is ready to import; click import.

 

5. Checking and Outputs

Use the ‘Reports’ functions to check and report data

Check the data using the Chemistry QA Error Checker, and

Tabulate the data using the Chemistry Result Table Export.