Advanced Design Creating Workflow

Advanced Design Creating Workflow

Overview

In our basic workflow for creating and importing custom designs we covered a simple example on how to create a design with a warm-up sample always being seen in the first position while other samples are randomized.

By popular demand of our clients, we are including the steps for creating a more advanced design.

Scenario and Challenges

  1. You have 12 samples that need to be evaluated over three days (to avoid fatiguing).
  2. The samples are to be evaluated in groups of 4 samples on each day.
  3. Due to the effect open packages have on product freshness and consistency, you are not to open all 12 samples at the start of the evaluation (on the first day).
    For example, if you were to open all 12 samples on the first day, by the third day the samples will become _________ (fill in the blank: soggy, stale, hard, otherwise affected...). In other words, you do not want to randomize the samples across all 12. 
  4. There are 25 panelists.

Design Type and Presentation Solution

You need to create a custom design that will randomize samples in a balanced fashion (positionally and pairwise) as follows:
  1. Day 1: Samples 1 through 4
  2. Day 2: Samples 5 through 8
  3. Day 3: Samples 9 through 12
You will need to use the Partial Present feature to present the subset of 4 samples on each day.

How to make it all happen?

You could start from a blank Excel file and come up with the randomization, but that's the hard way. This workflow will teach you how you can reuse existing designs to help you create your new design.
For example, you know that on each day you will present 4 samples and that those samples need to be randomized while maintaining positional and pairwise balance. Compusense Cloud already has designs for 4 samples that are positionally and pairwise balanced. All you need to do is use them to create your design for 12 samples randomized as described above.

General Workflow

  1. Export a William's design for 4 samples.
  2. Use the exported design to create your own for 12 samples.
  3. Import the design into Cloud and add it to your test.
  4. Use Partial Present to properly present 4 samples on each day.

Exporting Existing Design

  1. From the "Dashboard", click on "Libraries > Designs ".

  2. In the "Search designs" search for the design called '6x Williams Design (6 Latin Squares)'. It has 4 samples, 4 presented and 24 in the base design. Please see the image below.


  3. Select the design and click "View > Export design" .

  4. Save the file to a location on your local or network drive . Open the file in Excel.

  5. Because the file is in the .csv format, you will not be able to save any formatting (such as colour) in it. Colour coding plays an important role in this exercise, so please follow the steps below to enable formatting:
    1. In Excel, go to "File > Save As ". Select a folder where you wish to save it.

    2. Update the name to reflect the fact that there are 12 samples in the new design and under the "Save as type" list select "Excel Workbook" .


    3. Click " Save".

  6. The exported design will have rows of sample sets (different orders) and columns of different sample positions. The sample numbers are highlighted yellow in the image below. We will use the highlighted area for creating randomizations for each day.


Creating the Custom Design

Day 1 Randomization
  1. Select the design from cells B2 through E25 (everything in yellow in the above image) and copy it.

  2. Click in the cell G2 and paste. Your day 1 design is done! :) Easy, isn't it?!

  3. Change its colour into orange and put a label above (Day 1).


Day 2  Randomization
  1. Select the yellow design from cells B3 through E25 and copy it.
    Please note that you should start from B3 , not B2 as you did for the day 1.

  2. Click in the cel l K2 and paste.

  3. Back to the yellow design, select the cells B2 through E2 and copy them.
    This was a necessary step to ensure that the order is not identical for panelists each day they return to evaluate samples.

  4. Click in the cell K25 and paste.  

  5. Change the colour for the day 2 design into blue and label it Day 2.


  6. Select the design in blue (cells K2 through N25) and on your keyboard press Ctrl H. This will bring up the "Find and Replace" feature in Excel.

  7. We will now find all sample #1 instances and replace them with the sample #5 (because this is the day 2 group of samples we should not be serving the samples from day 1):
    1. In the "Find what " box, type 1.

    2. In the "Replace with" box, type 5.

    3. Click "Options >>" and place a checkmark in the "Match entire cell contents" checkbox .


    4. Click "Replace All". There should be 24 replacements. Click "OK" to confirm.

  8. Keep the "Find and Replace" window open. Now find all the sample #2 instances and replace them with 6. Follow the same steps until you replace samples 1 through 4 with the samples 5 through 8 respectively.

  9. Close the "Find and Replace" window. The day 2 design is done!

Day 3   Randomization
  1. Select the yellow design from cells  B4 through  E25 and copy it.
    Please note that you should start from B4

  2. Click in the cell O2 and paste.

  3. Back to the yellow design, select the cells B2 through E3 (two rows of samples) and copy them. 

  4. Click in the cell O24 and paste.

  5. Change the colour for the day 3 design into green and label it Day 3.


  6. Select the design in green (cells O2 through R25) and on your keyboard press Ctrl H. This will bring up the "Find and Replace" feature in Excel.

  7. Click "Options >>" and place a checkmark in the "Match entire cell contents " checkbox.

  8. Follow the same until you replace samples 1 through 4 with the samples 9 through 12 respectively. The day 3 design is done! In fact, the entire design is done and should look similar to this:


Final File Preparations

Because the design is currently in the file format that is not compatible with Compusense, follow the steps below to prepare it for import into Compusense:

  1. Open a blank Excel file.

  2. Back in the Excel workbook where you created your new design, select the entire new design. This would include the cells G2 through R25 (all three colours). Copy the design.

  3. Back to the blank Excel file, click in the cell A1 and paste.

  4. Save the file as .csv.

Importing the Design Into the Designs Library

  1. From the "Dashboard", click "Libraries > Designs".

  2. In the top right-hand corner, click "Create new design".

  3. Specify the "Design name" . Be descriptive and specific when choosing the name so that it is easy for everyone to tell what the design consists of.

  4. Specify the "Design type".

  5. Click "Import design", browse to your .csv file and click it to import. You will be presented with a validation message either confirming that the import was successful, or informing you of any errors and their details.


    Notice that the "Samples", "Presented", and "Orders in base design" automatically populate.

  6. Add a "Description " about the design with any additional important details.

  7. Click "Next > Next > Next " .

  8. Specify who can have access to the design (the group) and click "Save design " to save the changes.

The design can now be added into tests when the  Advanced  option in "Samples & design" is toggled to "Yes".
    In addition to Excel, you can create designs in other 3rd party design creation software packages that provide .csv format, such as Design Express. 


    Import Design Directly Into Test

    You are also able to import designs directly into tests. Doing this will not save the design to be used again in future tests. 
    1. From the within your test, click the "Samples & design"   tab.

    2. Toggle the "Advanced" option to "Yes".

    3. Click "Import design ".

    4. Select your saved Excel file and click "Open".

    5. Click "Save".


    Generate the "Serve report" in the "Logistics" tab to assist you with the sample serving. Use the Partial Present feature to serve a subset of samples each day.

      • Related Articles

      • Samples & Design: Tetrad Test - Single

        Overview The number of samples and their blinding codes play an important role in your Tetrad test setup. The template test distributed with our software is set up as a single Tetrad test type. The double (back to back) Tetrad test type is available ...
      • Samples & Design: Add and Modify Reps

        Overview The reps provide the ability to present the samples more than once to the same panelists, allowing for the collection of rep data (Replication or Repetition). Reps can occur one after the other, or at set dates and times. For presenting ...
      • Samples & Design: Triangle Test - Single

        Overview The number of samples and their blinding codes play an important role in your Triangle test setup. You may create a single Triangle or a double (back to back) Triangle . In both Triangle types, there can be only one Triangle question in the ...
      • Samples & Design: Same/Different Test - Single

        Overview The number of samples play an important role in your Same/Different test setup. The sample blinding codes will not be displayed to panelists on the buttons. However, it is important to specify blinding codes in case you wish to display them ...
      • Samples & Design

        Overview Samples and Design are core components of all test types in Compusense20.   Throughout the test, each panelist will evaluate a Sample set.  The number of Sample sets in a test is equal to the maximum number of evaluations and orders in a ...