Home | Using Katmandoo | Quick Start Guide | How-to | Task Menu | Table of Contents | See Also | Collapse All

Treatment

Overview

A treatment in the experimantal design context refers to the combination of actions (such as cultural practice or genetic effects) applied  to an experimental unit. While Genotypes would typically be part of the treatment regime, their special status in Katmandoo is recognised and the term treatment is applied to those treatment factors additional to genotype. For example, in an agronomy trial treatments could include seeding rate, fertilizer regime or sowing time etc, optionally in combination with genotype.

Detail

The treatment must be added in the database as a Virtual Column before a Treatment record can be created. 

Treatment Text

Treatment Text uniquely identifies a treatment in the Treatment table and it is generated by system using the Treatment Virtual Column and its value as shown in the example below. So, the Treatment Text or value of the Treatment Virtual Column can not be modified.

Treatment Text Treatment Virtual Column and its value Can be From...
NitrogenApplied0|SeedingDensity250 NitrogenApplied = 0 and SeedingDensity = 250 Plant Agronomy Trial
NitrogenApplied150|SeedingDensity250 NitrogenApplied = 150 and SeedingDensity = 250 Plant Agronomy Trial
RowSpace15 RowSpace = 15 Plant Agronomy Trial



There are following two ways to add Treatment Text in the database.
  1. Use Treatment Setup Form to bulk insert treatment records using the starting and ending NUMERIC value of the Virtual Column (of the TreatmentFactor table).
  2. Using Import Trial Design. While importing data, system use the Virtual Column (of the TreatmentFactor table) and its value to generate the Treatment Texts as shown above and save them into the database.
Once the Treatment Text are saved in the database, it can be used in the trial design, Analysis of Variance and Multi Environment Trial Analysis. 

Treatment Virtual Column

These are the Virtual Columns of TreatmentFactor table and are used to generate Treatment Text that uniquely identifies a record (or row) in the Treatment Table.

Follow these steps to add a Virtual Column for TreatmentFactor Table:
  1. [ Task > System > Manage Virtual Column and Alias ] to load Virtual Column Main Form with all the virtual columns in the database.
  2. [ Record > Add Virtual Column ] to load the Virtual Column Setup Form.
  3. Enter name, caption, description of the Virtual Column
  4. Select TreatmentFactor for Table Name of Virtual Column.
  5. Select Data Type of Virtual Column.
  6. Enter a value between 1 and 32 for the Text size of the Virtual Column value.
  7. Enter the Unit of the virtual column (if available).
  8. Must uncheck checkbox for Can have Null Value?.
  9. Check the Tickbox to add validation rule for all the Sub-systems.

Table Structure

Column Name Description
TreatmentId (PK) Identification Number that uniquely identifies a Treatment.
TreatmentText (AK) Automatically generated treatment text using the information of the Treatment Virtual Column.

Pre-requisite

The following information must exist before a Contact can be added into the database.

Main Form

Use [ Task > Trial > Raw Data > Manage Treatment of Trial Unit ] to load Treatment Main Form with all the treatments in the database.
Illustrative snapshot:
Main Form of Unit Position (Click it to change its size)
  1. Treatment Main Form displaying the Treatments at the selected location. 
    • Click here for an illustration of the main form template.
  2. Treatment subform displays virtual column information of the selected Treatment in the Treatment Main Form (Treatment Text "BlockNo2|ColumnNo2|RowNo2" in the snapshot).

Setup Form

Important Note: The Treatment records are added while importing trial design, AOV or MET; if they already do not exist in the database. Use this Setup Form to Bulk-insert the Treatment records WITH NUMERIC TREATMENT VALUE for initial setup only.

To add Treatments WITH NUMERIC TREATMENT VALUE ONLY, follow the steps below :
Illustrative snapshot:
Setup Form of Unit Position (Click it to change its size)
  1. Virtual Columns of TreatmentFactor Table. Click here for instruction on adding Treatment Virtual Column.
  2. Enter Minimum (ie starting) Value to generate Treatment Text.
  3. Enter Maximum (ie ending) Value to generate Treatment Text.
  4. Enter Increment Value to generate Treatment Text.
When saved, this will generate the Treatments as shown in the Treatment Main Form (see the selected row).

Export / Import

Export
Import

See Also