Sensory Evaluation  HOME CONTACT ABOUT US SUPPORT SENSORYTEST.COM
 
Sensory Evaluation  SIMS SOFTWARE QUESTION CHOICES CLIENT COMMENTS
 MARKETS VIEW REPORTS FREE EVALUATION
 TEST CHOICES GET DEMO SUPPORT



    SIMS <--> LIMS Batch Testing Examples,   automated SIMS LIMS communications back-n-forth.


   Introduction

SIMS Test Result Master Batches are usually associated with LIMS Systems and the importing/creating
of multiple SIMS Tests in batches, saving you time from having to manually having to create each test individually.
Your LIMS database or Excel worksheets can be used a source of the Batch information.

Most commonly used for batches of quality DOD Tests, Degree of Difference Test, where each test in the batch is
a one sample SIMS Test, Experiment vs Contol. Measure the degree of difference. See examples of DOD ballots.
In addition to DODs all other questions types are supported for your batch usage including comments.

This functionality creates new SIMS Tests for each record/row of the loaded Batch, SIMS Tests Result Code Masters,
then automatically Starts these Tests in sequential SIMS affective test rooms! Ready-to-test immediately!




   New Batch Options
      Sensory Evaluation



   New Batch Creation, this example shows 20 Tests in a batch.
      Sensory Evaluation



   Existing Batches Control
      Sensory Evaluation



   Batches Data Pull Example
      Sensory Evaluation




  =====  Notes for LIMS Batch Testing - SIMS Sensory Quality Panel Software  =====
  ========================================================================


  Batch Introduction
  ------------------

    SIMS Test Result Master Batches are usually associated with LIMS Systems and the importing/creating 
      of multiple SIMS Tests in batches, saving you time from having to manually having to create each test individually.
      Your LIMS database or Excel worksheets can be used a source of the Batch information.

    Most commonly used for batches of quality DOD Tests, Degree of Difference Test, where each test in the batch is 
      a one sample SIMS Test, Experiment vs Contol. Measure the degree of difference. See examples of DOD ballots.
      In addition to DODs all other questions types are supported for your batch usage including comments.   

    This functionality creates new SIMS Tests for each record/row of the loaded Batch, SIMS Tests Result Code Masters,
      then automatically Starts these Tests in sequential SIMS affective test rooms!  Ready-to-test immediately.


  New Batch Options
  -----------------

    Every Test in a given new Batch must share a common SIMS Test Definition, and other SIMS Test Result Execution options.
      You can also start the execution of every Test, each Test will be automatically assigned
      to starting rooms ordered sequentially, and each Test will be automatically Test Linked sequentially.

    SIMS Test Definition Code:   Select a preexisting SIMS Test Definition Code.   Be sure to select the right one
      since this will be the Test Definition used for every Result Code in the New Batch Creation.
      Helpful information about the current SIMS Test Definition is shown in few places on screen.


  New Batch Creation
  ------------------

    Button 1 - Batch Load from LIMS
                 You'll need to enter in a valid LIMS Batch_Number.  See your LIMS Administrators.
                 Batch_Number can be up to 20 alphanumeric characters in length and usually not case sensitive.

                 Or use [Excel Import] to populate the new batch. 4 columns.
                 Or use [Examples] button to populate batch with 20 example tests in an example batch.

    Button 2 - Batch Verify
                 Verifies all of fields, rows, and columns of the loaded Batch.

    Button 3 - Batch Accept
                 Repeats above verify, then performs additional verifications for Test Definitions and Testing Rooms.
                 Creates new SIMS Tests for each record/row of the loaded Batch, Result Code Masters.

    Examples:
       Batch 1 | 01 | 12001001 | Product 1 Description
       Batch 1 | 02 | 12001002 | Product 2 Description
       Batch 1 | 03 | 12001003 | Product 3 Description

    50 Rows Max.  4 Columns:   Batch_Number | Sequence_Number | Result_Code | Test_Description

      Batch_Number      VARCHAR(20) 
      Sequence_Number   INTEGER 1-50            (Max Sequence is 50)
      Result_Code       INTEGER or VARCHAR(10)  (same as LIMS 'Test_Number', this will be SIMS Result Code Name)
      Test_Description  VARCHAR(80)             (same as LIMS 'Product_Description', this will be SIMS Result Description)


  Existing Batches Control
  ------------------------

    Button 1 - START Tests Selected Batch Result Master Codes.
                 Automatically starts all the batch Tests in sequential SIMS Testing Rooms.
                 Optional: Test Link all of the Testing Rooms sequentially
                 You'll need to enter in a valid Starting Room.
                 Unused and Continuous Testing Rooms must be available in the SIMS System.
                 If you have problems, some helpful Hints:  Select a different Starting Room,
                    or End some Tests, or Add New Rooms to the SIMS System.

    Button 2 - END Tests Selected Batch Result Master Codes.
                 Ends every test that exists in the Batch.

    Button 3 - Show Result Master Codes.
                 Nice quick-n-easy look at any existing Batches in the SIMS System.
                 Displays: Batch_Number, Sequence_Number, Result_Master_Code, Result Code Description,
                           # Data Records, Active Status, and Hidden Status.

    Button 4 - Hide  Result Master Codes.
                 To toggle the status for visual inclusion on the Result Masters screen main grid.

    Button 5 - UnHide Result Master Codes.
                 To toggle the status for visual inclusion on the Result Masters screen main grid.

    Button 6 - DELETE Result Master Codes.
                 Danger, please preceed with caution, multiple tests & data loss.
                 If the Batch's all Result Codes combined, contains 10 or fewer real
                 data record, then standard warning screens will be shown to the user.
                 10 Data records is low enough to assume that the Batch was never used.
                 Greater Data Record counts will require a special Access Restrictd Passwords.
                 IF IN DOUBT, DO NOT DELETE YOUR TEST DATA.


  SQL DATABASE VIEW Technical Notes LIMS Batches
  ----------------------------------------------

      Usage:
          SELECT * FROM LIMS_BATCH WHERE BATCH_NUMBER = [user entry] ORDER BY SEQUENCE_NUMBER

          LIMS_BATCH ( -- View Name)
             BATCH_NUMBER         VARCHAR(20)
             SEQUENCE_NUMBER      INTEGER
             TEST_NUMBER          INTEGER (or VARCHAR if needed)
             PRODUCT_DESCRIPTION  VARCHAR(80)

        BATCH_NUMBER   SEQUENCE_NUMBER   TEST_NUMBER    PRODUCT_DESCRIPTION
        Batch 1        1                 12345001       Product 1 Description
        Batch 1        2                 12345002       Another Product Description
        Batch 1        3                 12345003       And another Product Description
        ...            ...               ...            ...
        Batch 1        25                12345025       More product


        The following is an example of how to create a 'simulated' LIMS_BATCH View result set.
          CREATE VIEW LIMS_BATCH AS
            SELECT 'Batch 1' AS BATCH_NUMBER, 1 AS SEQUENCE_NUMBER, '12345001' AS TEST_NUMBER, 'Product 1 Description' AS PRODUCT_DESCRIPTION UNION
            SELECT 'Batch 1' AS BATCH_NUMBER, 2 AS SEQUENCE_NUMBER, '12345002' AS TEST_NUMBER, 'Product 2 Description' AS PRODUCT_DESCRIPTION UNION
            SELECT 'Batch 1' AS BATCH_NUMBER, 3 AS SEQUENCE_NUMBER, '12345003' AS TEST_NUMBER, 'Product 3 Description' AS PRODUCT_DESCRIPTION UNION
            SELECT 'Batch 1' AS BATCH_NUMBER, 4 AS SEQUENCE_NUMBER, '12345004' AS TEST_NUMBER, 'Product 4 Description' AS PRODUCT_DESCRIPTION UNION
            SELECT 'Batch 1' AS BATCH_NUMBER, 5 AS SEQUENCE_NUMBER, '12345005' AS TEST_NUMBER, 'Product 5 Description' AS PRODUCT_DESCRIPTION

      Normally your View would be written to access your LIMS System Database.
        The View named LIMS_BATCH exists is the SIMS database, points to your LIMS System, and is authored/created by your LIMS DBA Administrator.


  SQL DATABASE PULL Technical Notes LIMS Batches
  ----------------------------------------------

     Examples that your LIMS DBA Administrator may want to use:
       *Single* SIMS Test Result Code   and   *Entire Batch* SIMS Test Result Codes

     Note: Please contact Sensory Computer Systems for these Examples


 ** End of Notes **




   
   DOD Questionnaire Example Line Scale             More examples here.
      Sensory Evaluation



   Batches Excel Example of Import / Export
      Sensory Evaluation





Sensory Evaluation
SIMS Sensory Quality Panel Software Systems - Evaluation Testing Software Systems

Sensory Evaluation



      Tweet
 
 



Copyright © 2017 by Sensory Computer Systems. All rights reserved.