Enter Initial Sample Weight

After a batch is logged, the initial weight for each sample can be recorded in the Sample Batches page. You can enter the weights manually using a configured balance or import the weights from an Excel file. With the Excel file you can also import the sample location and sample storage.

The total weight is automatically calculated and displays at the bottom of the screen.

Activity Steps

1. Locate and select the sample batch in the Sample Batches page.

2. Click Data in the menu.

   The Capture Data screen displays.

3. To enter the weights manually, enter the weight for each sample as required.

4. To enter the weights using a balance:

   Note: To calibrate the balance prior entering the weights, see Calibrate a Balance.

   1. Note: If a balance is configured, an OPEN message displays in green. Otherwise, a CLOSE message displays in red in the Instrument category group.

   2. Select the cell and press Enter or press the dedicated button on the balance instrument to send the weight to the cell.

5. If the port status appears as CLOSED, the balance may not be selected correctly.

   1. Select the balance instrument.

      1. Click Read.

         The Serial Communication screen displays.

      2. Select the Instrument.

      3. Select the Template.

      4. Click OK.

   2. Set the Mode to Auto.

6. To import the data from an Excel file:
   1. Click Import.

   2. Browse and select the Excel file.

      The Import Analytical Data screen displays.

   3. Select Overwrite existing data to replace any weight, location or storage data.

   4. Select whether the Samples in the Excel file are identified by Lab Code or Client ID.

   5. Click the icon next to the Column Headings field.

      The selected Excel file opens and the Obtain Range Object screen displays.

   6. Select the required column headings from the spreadsheet.

   7. Click OK.

   8. Click the icon next to the Row Headings field.

      The selected Excel file opens and the Obtain Range Object screen displays.

   9. Select the required row heading from the spreadsheet.

   10. Click OK.

   11. Click Next.

   12. Click Match to match the headings.

       AssayNet LIMS matches any headings that are identical in both the Data Capture and the Spreadsheet tables.

       Note: No data is imported for unmatched headings. You must manually match the columns.

   13. To manually match any unmatched column headings, select the heading from the Data Capture and the Spreadsheet tables.

   14. Click the Add Data Option icon.

   15. Click Next.

   16. Click Match to match the data.

       AssayNet LIMS matches any identical Lab Code or Client in both the Submittal and the Spreadsheet tables.

   17. To manually match any unmatched Lab Code or Client, select this data from the Submittal and the Spreadsheet tables.

   18. Click Next.

   19. Click the Add Data Option icon.

   20. Click Finish.

   21. Click Close.

7. To change and filter the data display:

   1. Select the Sample ID from Lab Code or Client ID.

   2. Set Display to Product to display a Product column.

8. Edit sample batch options:

   1. Click Edit.

      The Edit Sample Batch Options screen displays.

   2. Select the following options as required:

      • Create Products—Not in use.

      • Use Templates—Use a prep template. For more information see, Add a Preparation Template.

      • QC Samples in Separate Client Jobs—Separate QC for the batch in a different client job.

      • Require Sample Scan—Require the sample to be scanned when creating the laboratory job.

      • Auto Print on Data Entry

      • Measure QC Samples—Calculate QC samples.

      • Show Measurement Totals—Displays the Total weight at the bottom of the screen.

      • Allow Manual Data Entry—Disable manual entry of weight data in the Data Capture screen.
      • Allow Calibration Bypass—Bypass balance calibration.

   3. If Use Template is checked, select the Prep Template.

      Note: If a prep template is selected, you might need to close and reopen the Data Capture screen to display the template.

   4. Update the following fields as required:

      1. Units—The units for the sample weight to be entered in the Data Capture screen.

      2. Batch Size

      3. Decimals—The number of decimal places for the sample weight.

   5. Click OK.

9. To print:
   1. Click Print.

      The Print Preparation Products screen displays.

   2. Select from the Print Options.
   3. Click OK.

10. To export the data to an Excel file, click Export.