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. |