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