Contents - Index

Four-way data - serial

• This data format should have 6 columns, representing 1) year, 2) location, 3) block (replicate), 4) entry (e.g., genotype), 5) trait, and 6) measured value for the trait, respectively.

• The first row is the header, containing the names of the columns, namely, 1) "Year",  2) "Location name", 3) "Block name", 4) "Entry name", 5) "Trait name" , and 6) measured values. The end of the header should be indicated by the word "End" if file is in text format for a text file. "End" is not needed if the file is an Excel or Access file.

• Each subsequent row contains a single observation (a data point), and the 6 columns are for 1) year, 2) tester name, 3) block (replication) name, 4) entry name, 5) trait name, and 6) measured value, respectively.

• The data do not have to be balanced in terms of entry by tester combinations. The number of blocks can differ for different testers. 

• Missing cells can be indicated by anything except that it cannot be left empty for text files.

Example: