Home

1e oo < • 1 17. 1 - Repository

1. 4 If you want to correct the value because it does not agree with the hardcopy of your data select YES and the following dialog box appears Replace 86 with Cancel Enter the correct value and press OK The program will search for the next value that deviates by more than three standard deviations from the mean 5 If you do not want to correct that value because it does agree with the hardcopy of your data select NO The program will search for the next value that deviates by more than three standard deviations from the mean 7 3 PRINT FIELDBOOK automatically formats your worksheets and prints them by selecting PRINT from the FIELDBOOK menu 7 4 CLOSE FIELDBOOK automatically goes to the top of each worksheet and saves and closes a file by selecting CLOSE from the FIELDBOOK menu 30 8 OPTIONS 8 1 DEFAULTS The default installation of FIELDBOOK creates a sub directory in your C drive called CAFBK Within this subdirectory further subdirectories are made for seed preparation files C FBK SEEDPREP nursery files C FBK NURSERY trial files C FBK TRIAL inventory file C FBK INVENT and seed shipment files C FBK SEEDSHIP As a more advanced user you may want to place these files to another directory and still want FIELDBOOK to find the correct files Proceed as follows 1 From the FIELDBOOK menu select OPTIONS then DEFAULTS The following dialog box appears Options Direc
2. Entries are listed starting row 10 Worksheet Seed Shipment Row 9 is empty 10 2 5 TRIAL XLT TRIAL TEMPLATE Worksheets are labeled Fieldbook and Results and HP Worksheet Fieldbook Cell A1 is allocated to Trial name Worksheet Fieldbook Cell U1 is allocated to your Logo Worksheet Fieldbook Column A is allocated to Rep Worksheet Fieldbook Column B is allocated to Block Worksheet Fieldbook Column C is allocated to Plot Worksheet Fieldbook Column D is allocated to Entry Worksheet Fieldbook Column E is allocated to Pedigree Worksheet Fieldbook Row 5 is empty and hidden Worksheet Fieldbook Design and pedigree are listed starting row 6 Worksheet Results Cell A1 is allocated to Trial name Worksheet Results Column A is allocated to Entry Worksheet Results Column B is allocated to Pedigree Worksheet Results Column C is allocated to Origin Worksheet Results Row 8 is empty and hidden Worksheet Results Entries are listed starting row 9 36 Worksheet HP Column A is allocated to Rep Worksheet HP Column B is allocated to Block Worksheet HP Column C is allocated to Plot Worksheet HP Column D is allocated to Entry Worksheet HP Design is listed starting row 2 10 2 6 LABELS IN ALL TEMPLATE FILES Column A C and E have the width of the labels Column B and D fit the space be
3. 2 Highlight the pedigrees for which you want to make stock labels uc A Murr ren LULA rsen oman Levi sieve 1763 8TTZBSR 211 3 1 8 TZEESRWI BYKATUMANI 1754 PA43SRCSFS1 3 3 22b RVUTZEESRW1 BYKATUMANI 1765 P43SRCSFS2 5 3 3cb ft ITZEESRW I BTKATUMANI 1766 TZESRWXGUASI4BCIKATUMANI 1779 1780 3 From the FIELDBOOK menu select INVENTORY then STOCK LABELS The following dialog box appears Stock Labels How many labels in a row 17273 4 Enter the Number of labels per row depending on what kind of paper you are using 5 Select OK 6 Field book then creates stock labels sorted according to the stock number 7 DATA CHECK PRINT AND CLOSE 7 1 DOUBLE ENTRY Data entered into the computer need checking Some people prefer to enter data twice instead of visually comparing data on a hardcopy with data entered in the computer FIELDBOOK provides a feature to verify data by entering them twice Proceed as follows 1 Enter the data once 3 Highlight the data that you want to check 3 From the FIELDBOOK menu select DOUBLE ENTRY e File Edit View Insert Format Tools Data Window Help Fieldbook casar DAS CAE Seed Preparation Nursery Trials Times New Roman Inventory Seed Shipment Planting date 8 97 _ Data Check Print Close Options About Fieldbook 5 1 7 2 129 10 BERT RR RITE CREE 4 The following dialog
4. Prepare the seed Make corrections that occur during seed preparation in the seed preparation workbook Create and print the nursery and trial fieldbooks based on the seed preparation workbooks Enter data collected in the nursery in the entrylist of the nursery workbook Harvest nurseries double enter the number of ears selected and seed quantity Update pedigrees and print stocklist and stock labels Make corrections that occur during shelling in the stocklist of the nursery workbook When all nurseries of a site are harvested and stocklists are corrected update the inventory Double enter data collected in trials in the fieldbook of the trial workbook Use data check to highlight extreme values Calculate the variables that should be analyzed using the HP sheet Save the master sheet as comma delimited file CSV Import the comma delimited file to MSTAT using import Make the analysis of variance Note ALPHA cannot handle missing data Open the ASCII file that contains analysis of variance and adjusted means AOV file 33 21 Copy adjusted means and statistics to the result sheet of your trial workbook 10 ANNEX TO FIELDBOOK 10 1 ANNEX 1 COMPONENT OF FIELDBOOK e INVENT XLT Template for the seed inventory NURSERY XLT Template for the nursery file PERSONAL XLS Personal Macro Workbook that contains Dialog Sheets and Macros SEEDPREP XLT Template for the seed preparation file SE
5. e Pedigrees are updated for different types of pollinations common in a maize breeding program e Performance data can be carried over to descendants of germplasm and to the inventory and new nursery books e Entries can be selected based on stock ID pedigree origin or performance data e Different randomizations for trials conducted at several sites can be created using one master design e Data can be checked by double entering e Data that deviate by more than three standard deviations from the mean can be highlighted FIELDBOOK is designed to interact with the ALPHA software publicly available software from CIMMYT that creates and analyzes alpha 0 1 lattice designs and that contains a selection index program FIELDBOOK does not provide an algorithm for creating designs or analyzing data e Data files are stored in a logical manner that permits easy localization and manipulation of files with other programs e LOTUS 123 design files are created for use with an HP palmtop 1 3 WHAT IS THE DIFFERENCE BETWEEN FIELDBOOK 5 1 AND 7 1 FIELDBOOK 5 1 is an add in program for Microsoft EXCEL 5 0 95 FIELDBOOK 7 1 is a collection of macros for Microsoft EXCEL 97 You need to either install FIELDBOOK 5 1 or FIELDBOOK 7 1 depending on what version of EXCEL you have 2 INSTALLING FIELDBOOK To install FIELDBOOK proceed as follows ib pog 5 Go to the MSDOS prompt CA Put the installation diskette in the flop
6. Box MP163 Harare FAX 263 4 301807 Email M BANZIGEROCGIAR ORG DISCLAIMER FIELDBOOK and ALPHA were developed by CIMMYT The user takes full responsibility for all manipulations done with these programs They may not be sold or distributed for profit but may be copied or distributed for research Use by CIMMYT of any software does not imply endorsement or recommendation CIMMYT 1999 TABLE OF CONTENTS A FIELDBOOK 1 1 1 1 2 1 3 3 1 3 2 3 3 3 4 3 5 4 1 4 2 43 44 5 1 5 2 6 1 6 2 6 3 6 4 7 1 7 2 7 3 7 4 w INTRODUCTION WHAT IS FIELDBOOK SPECIAL FEATURES WHAT IS THE DIFFERENCE BETWEEN FIELDBOOK 5 1 AND 7 1 INSTALLING FIELDBOOK SEED PREPARATION CREATING A NEW SEED PREPARATION OPENING AN EXISTING SEED PREPARATION SELECT ENTRIES FOR A SEED PREPARATION MAKING A DESIGN FOR A SEED PREPARATION CREATING SEED LABELS FOR A SEED PREPARATION NURSERY CREATING A NEW NURSERY OPENING AN EXISTING NURSERY MAKE A STOCKLIST MAKING STOCK LABELS TRIAL CREATING A NEW TRIAL OPEN AN EXISTING TRIAL INVENTORY CREATING A NEW INVENTORY OPEN THE INVENTORY CONSOLIDATE THE INVENTORY CREATE STOCK LABELS FROM THE INVENTORY DATA CHECK PRINT AND CLOSE DOUBLE ENTRY DATA CHECK PRINT CLOSE OPTIONS Us au LL w uy Y L Bw YN YP W P d PD Pd PD P RN S S o m m gt e a U R A A MH oc U nh A 8 1 8 2 8 3 9 10 DEFAULTS CHANGE TEMPLATES MODIFYING THE FORMAT OF TEMPLATES
7. FIELDBOOK MADE EASY A QUICK RUN THROUGH THE SEASON ANNEX TO FIELDBOOK 10 1 ANNEX 1 COMPONENT OF FIELDBOOK 10 2 ANNEX 2 TEMPLATE RESTRICTIONS w w b M 4 1 42 43 44 4 5 4 6 4 7 5 6 ALPHA WHAT IS ALPHA INSTALLING ALPHA ON YOUR COMPUTER STARTING ALPHA USING ALPHA NEW RANDOMIZATION ANOVA ALPHA LATTICE DESIGN VIEWING THE OUTPUT OF THE ANALYSIS OF VARIANCE SELECTION ASSISTANT VIEWING THE OUTPUT OF THE SELECTION ASSISTANT VIEW EDIT DATA FILE TERMINATE THE ALPHA PROGRAMS MADE EASY A QUICK RUN THROUGH THE SEASON IMPORTING ASCII FILES INTO MSTAT 31 33 33 34 34 34 38 38 38 38 39 39 40 42 42 46 46 47 47 48 A FIELDBOOK 1 INTRODUCTION 1 1 WHAT IS FIELDBOOK FIELDBOOK is a collection of macros for Microsoft EXCEL designed to assist maize breeders in aspects of fieldbook pedigree and data management The program manages seed preparation nursery and trial books updates pedigrees and keeps a seed inventory of which germplasm can easily be selected using pedigree origin or performance data 1 2 SPECIAL FEATURES FIELDBOOK uses EXCEL menus and dialog boxes The user can combine features of FIELDBOOK with any feature available in EXCEL e FIELDBOOK creates and prints entry lists for seed preparations and seed shipments fieldbooks for trials and nurseries and labels for seed preparations inventory and seed shipments Templates for master files and result sheets can be defined
8. prevent that you accidentally overwrite a column which already contains data After completing the information in line to 11 and checking that the information is correct press the F10 key The program scrolls now through all variables that are used in selection and asks you to assign a Selection target and a Selection intensity to each variable How do you determine the selection target and selection intensity 14 1 Selection target Press the F2 key and you will see a frequency distribution for that value The x axis shows you the range of values that are found in your trial for this variable the y axis shows you how many percent of the entries assume a certain value Below the x axis you find a second x axis that expresses the values of this variable in number of standard deviations from the mean of the entire trial 142 Decide whether you want to increase the value in your selected fraction or whether you want to decrease the value in the selected fraction If you want to increase the value in the selected fraction choose the largest value for this variable on the standardized x axis This is your selection target If you want to decrease the value in the selected fraction choose the smallest value for this variable on the standardized x axis This is your selection target Example Your variable is grain yield and you want to select for increased grain yields Values are ranging from 0 23 t ha to 3 09 t ha on the
9. 2 INAW 5867 P30 SR 52 1 5 3 1 B GI6BNSEQCOF18 1 1 B I NAW 5867 P30 SR 11 2 NAW 5867 P30 SA 25 1 9 1 1 B B GI6BNSEQCOF 118 1 1 8 COMPE2 P43 SRHCOMPE2 FS11 20 1 1 8 1 B GI6SeqCIF 47 2 1 2 1 B Bil NAW 5861 P30 SP 1f 2 NAW 586T P30 SR 52 1 5 3 1 B GIESeqC1F 41 2 1 2 1 B BH NAW 5867 P30 SR 111 2 NAW 5861 P30 SR 25 1 9 1 1 B B 5 GI6Sc C1F47 2 1 2 1 B B COMPE2IP43 5RHCOMPE2 FS8 20 1 1 B 1 6 16 L NAW 5867 P30 SR 111 2 MAW 586T P30 SR 52 1 5 2 BI LMA W 5367 P30 SR 111 211 NAW 5867 P30 SR 111 2 1NAW 5861 P30 SR 52 1 5 5 t B COMPE2 P43 SRI COMPE y NAW 5861 P30 SP 111 2 NAW 5867 P30 SR 25 1 9 1 1 B B COMPE2IP43 SRACOM GI6BNSEQCOF116 1 1 B K64R PL16 SR 39 K54R PLI6 SP 20 2 5 1 2 B B B GIEScqC1F 4T 2 1 2 1 E BHI K64R PLI6 SP 33 1K64R PL16 5R 20 2 5 1 2 B B B K64R OTPIWCSF181 1 1 3 1 1 B B K6ARIGI6Sc qC1F44 1 1 1 1 B B K64R SCIK64R ZSMA 6 2 X 2 5 B K64R CMI 205 EMSRIRBREFIO1SR 2 15R 3 2 4 B 5 5 K64RICML 221 AC 730 SR 19 1 1 1 8 B 8 K64R SC K64R ZSMA 6 2 X 1 2 B B K64RHI K64R P30 SR 82 2 K64P P30 SR 67 4 1 3 4 B B B Top 10 Custom 10 13 14 5 If you click e g on 2 0 EXCEL will select all inventory items that have a score of 2 0 for P sorghi AB c _1 SEED INVENTORY M Biaziger 1338 2 _3_ STOCK S PEDIGREE SCIZM6058b 13 2 X 1 2 X 1 1 5 B B GI5C22MH1488 1 1 1 6 1 BBB B B B LB 1 8332 SP EC3 183 1 1 1 B
10. 5 If your output media is a file or the printer you adjust this value to fit the desired width of the file or the width of the paper In line 9 Desired output device you can either write SCREEN PRINTER or a file name e g C EXAMPLE LOWNSEL and the output will be written to the screen printer or that file respectively We suggest to set this option first to SCREEN until you are satisfied with the selection you will be doing Then change this option to either PRINTER or a file name and print or save the selection Size of selected fraction in line 10 refers to the number of entries you want to select among all entries Example Your trial contained 100 entries and you want to select the 20 best entries In this case answer this question with 20 Move the cursor to line 11 You need to assign an empty column for the program to store a selection index the program calculates You can assign any column number provided the 43 column is not yet filled with data If the column you assign is already filled with data the program will overwrite the data and you will loose it Example Your file has entry number stored in column 1 and 8 different variables are stored in column 2 to 9 In this case enter 10 as the next free column for the program to store the selection index Pressing the F1 key allows you to see a list of the variables columns in your file and helps to
11. 7 Move the cursor to MSTAT file name for adjusted means Enter the name of the drive subdirectory ies and file Use a unique file name to not overwrite previously saved files The file name should not exceed 8 letters Example CEXAMPLEILOWNMNS In this example CM is the name of the drive EXAMPLE is the name of the subdirectory and LOWNMNS is the name of the file that will contain the adjusted means for this trial 8 Line 10 Harmonic mean efficiency factor is filled in automatically by the program provided the file and randomization was created using the ALPHA programs If the harmonic mean efficiency factor is not filled in automatically i e remains as 0 9999 proceed as follows 8 1 Press the ESC key 8 2 Move the cursor to N NEW RANDOMIZATION on the main menu and press the ENTER key 8 3 Create a new randomization with the same number of replicates number of genotypes and block size as the trial has that you want to analyze but give it a different unique name E g C EXAMPLE TEST 8 4 After creating the randomization i e after filling in the design parameters and pressing F10 return to the main menu by pressing the ESC key three times 8 5 Move the cursor to A ANOVA ALPHA LATTICE DESIGN on the main menu and press the ENTER key 8 6 Move the cursor to MSTAT file name containing data Enter the name of the drive subdirectory ies and file of the file you j
12. EXAMPLE is the name of the subdirectory and LOWNMNS is the name of the file that you want to edit Press the F10 key and you see the content of the file 46 4 Use the arrow keys T or 4 or the PgUp and PgDn keys to move up and down in the file 5 Use the Tab key to move from on column to the next 6 Pressing the F1 key highlights a help menu with various possibilities you can use to edit the file Press F1 again to leave the help menu Choose any of the keys listed in the help screen to edit the file 7 Press the F9 key to save changes you made to the file 8 Press the ESC key to return to the VIEW EDIT DATA FILE menu 9 You can edit other filed or press the ESC key to return to the main menu 47 TERMINATE You can leave the ALPHA programs by moving the cursor to T TERMINATE and pressing the ENTER key 5 THE ALPHA PROGRAMS MADE EASY A QUICK RUN THROUGH THE wR o op SEASON Create a alpha 0 1 lattice design using N NEW RANDOMIZATION Print the design using MSTAT Enter data collected using MSTAT or V VIEW EDIT DATA FILE Calculate the master variables that you want to analyze using MSTAT Use A ANOVA ALPHA LATTICE to calculate the analysis of variance and lattice adjusted means of the master variables Use S SELECTION ASSISTANT to select the superior entries in the trial and or to allocate a selection index to all entries If you have conducted the same trial in several environments use the
13. K64R PL16 R 20 2 5 1 2 5 B B GI6ScqC1F47 2 1 2 1 B B K64R PL16 S R 39 1 K64R PL16 5R 20 2 5 1 2 5 B B K54R DTP1WC6F131 1 8 3 1 1 B B K64R G16SeqCIF 44 1 1 1 1 B B 38 SADVEA Fi 38 SADVEA F1 38 SADVEA F1 98 SADVEA F1 38 SADVEA F1 38 SADVEA F1 38 SADYEA FI 38 SADVEA F1 38 SADVEA F1 38 SADVEA F1 38 SADVEA F1 98 SADVEA F1 38 SADVEB F1 38 SADVEB F1 31101 42 12 ius 4 3 If you move towards the right in your inventory you will find performance data arrow for the seed listed in the inventory A Bl SEED INVENTORY M Bieziger 1398 STOCK PEDIGREE GI6BNSEQCOF118 1 1 B G16SeqC1F47 2 1 2 1 B B GI6BNSEQCOF113 1 1 B NAW 5867 P30 SR 111 2 NA w 5367 P30 SR 52 1 5 3 1 B GI6BNSEQCOF118 1 1 5 NAw 5867 P30 SR 111 2 NAW 5867 P30 SR 25 1 3 1 1 B B GI6BNSEQCOF 116 1 1 5 COMPE2 P43 SR COMPE2 FS8 20 1 1 B 1 B GI6SeqC1F47 2 1 2 1 B B I NAWw 5867 P30 SR 111 2 NAW 5867 P30 5R 52 1 5 3 1 B Gi6SeqC IF 4T 2 B BIINAW 5867 P30 SR 111 2 NAW 58677P30 SR 25 1 5 1 1 5 B B B COMPE2 P43 SR COMPE2 F 8 20 1 1 B 1 B 1 B NAw 5867 P30 SR 111 2 N A FUICOMDE IIDA 22D MONRADE II 25 4 Below the title for the performance data there are small arrows If you click on such an arrow e g the arrow below P sorg you get the following drop down menu GISBNSEQOOF 118 1 1 B GIESc qC1F41 2 1 2 1 B B GISBNSEQCOF 116 1 1 B IINAW 5861 P30 SR ftI
14. Labels Proceed as follows 20 1 From the FIELDBOOK menu select NURSERY then STOCK LABELS t3 FIELDBOOK will detect if you have already made a Stocklist or not If you have not yet made a Stocklist the following dialog box appears Microsoft Excel Ez You need first to make a stocklist 3 In this case go to MAKE STOCKLIST above 5 3 When you select OK FIELDBOOK takes you to the MAKE STOCKLIST dialog box 4 If you have made a Stocklist the following dialog box appears Make Stock Labels x How many labels are in a row 1 2 3 EMM 5 This question refers to the number of labels in a row you are feeding through your printer There is fanfold paper that has only one column of label In this case enter 1 Enter 2 or 3 if you are feeding fanfold paper with two or three respectively columns of labels 6 Select OK 7 FIELDBOOK creates Stock Labels sorted according to the Stock ID 8 Print the Stock Labels on fanfold paper with labels 5 TRIAL 5 1 CREATING A NEW TRIAL This option lets you create fieldbooks for all trials that you prepared with a certain seed preparation E g if you prepared seed for a trial to be planted at five sites you can create the fieldbooks for all five sites with one single command The trial workbooks are usually created based on an existing seed preparation but you can develop them as well from scratch A trial receives a Trial ID and is allocated to a Season Examples for
15. Season and Trial ID Season 97A stands for that the trial was grown in the year 1997 season A 97B stands for that the trial was grown in the year 1997 season B etc Prep ID EPOP3 stands for that the trial was called EPOP3 etc 5 1 1 CREATING A NEW TRIAL WORKBOOK BASED ON A SEED PREPARATION 1 From FIELDBOOK menu select TRIAL then NEW The following dialogue box appears 5 2 7 New Trial Serie C Trial without seed preparation i Seed has been prepared az Season ETE Si Print the fieldbooks Fill in the correct Season and the correct Prep ID for the seed preparation that you have used to prepare the seed for these trials New Trial Serie 21x AAA A AA UC Trial without seed preparation i i Seed has been prepared as RCA Season 98a Prep ID SAMPLE 3 Print the fieldbooks Cancel If you wish to print the fieldbooks at this stage tick the Print the Fieldbooks checkbox You can as well print the trial fieldbooks later Select OK FIELDBOOK will then want to know the range of sites for which you want to create trial files Maybe you have prepared seed of a trial for 15 sites but you only want to make the trial files for the first 10 sites In this case fill in the dialog box as follows New Trial Serie 124 x From Site fi To Site fio Cancel If you want to make the trial files for all 15 sites fill in New Trial Serie 121x mese ft To
16. box appears Data Entry 12 tony MEK 2nd Entry Cancel 5 Enter the data a second time As long you enter the second time the same data you entered the first time in this example 78 the program proceeds to the next data If the data entered the second time is different to the data entered the first time an error is reported You have to enter the faulty data twice so that FIELDBOOK accepts that data 72 DATA CHECK FIELDBOOK provides an additional feature to check data It can find all data that deviates by more than three standard deviations from the mean of a certain column i e extreme data and gives you the choice to correct such data Proceed as follows 1 Highlight the data that you want to check 2 From the FIELDBOOK menu select DATA CHECK 3 FIELDBOOK starts checking column by column If it finds data that deviates by more than three standard deviations from the mean of that column the following message appears Note that the value that was found to differ by more than three standard deviations from the mean of that column is highlighted by the cursor arrow 29 I Ki E M N o Planting date__8 Now97 _ Harvest date 21 Apr 98 wag Lodging Num Field pm lt uu lants pe 1 EN z 79 Miel al 13 154 3 EE ER mE I so s se 150 60 Do you want to correct this value sa sol se 15 70 s vel sol 15 70 12 so es 180 90 Le e s m ol op op i wp 12
17. current row Example if you want to select all entries harvested from the nursery HA97A 201 fill in the dialog box as follows Select Entries 2 C Inventory C Seed Preparation ESTE W Select entries from Nursery Ji Site ID Season Directory JHa97a Prep Nursery Inventory ID 201 C A subset will be inserted for the selected cells Cancel Example If you want to select all entries from a previous seed preparation made in 97B and called HYBRID fill in the dialog box as follows Select Entries BE Select entries from Nursery Inventory Seed Preparation Site ID SeasonjDirectory 97B Prep Nursery Inventory ID HYBRID Cancel C A subset will be inserted for the selected cells Press OK FIELDBOOK opens the selected nursery or seed preparation workbook and fills in all entries that were harvested from that nursery or all entries that were prepared in that previous seed preparation starting from the row where the cursor was placed before you selected SEED PREPARATION SELECT ENTRIES 3 3 3 COMPLETING INFORMATION FOR A SUBSET OF ENTRIES Frequently you only want to prepare seed for a sub set of entries for which the information is stored in a certain nursery previous seed preparation or the inventory Proceed as follows l Enter either the Stock ID in column B the Pedigree in column C or the Origin in column D for the en
18. for the nursery after harvest you can create the new pedigrees and origins of the harvested seed and make stock labels for that seed The nursery workbook is usually created based on an existing seed preparation or from scratch It receives a Site ID and Nursery ID Site ID and nursery ID form together the Origin of the seed harvested from that nursery Examples for Site ID Nursery ID and Origin Site ID HA97A stands for a nursery that was grown at Harare in the year 1997 season A MZ97B stands for a nursery that was grown at Mzarabani in the year 1997 season B etc Nursery ID 1201 stands for a nursery called 1201 etc Origin HA97A 1201 is a nursery called 1201 grown at Harare in the year 1997 season A Seed harvested from a nursery will receive a unique Stock ID that should help you to easily localize the seed in you store room We suggest you number the seed lots consecutively starting with Stock ID 1 then 2 3 etc 4 1 1 MAKING A NURSERY BASED ON A SEED PREPARATION To create a new nursery based on an existing seed preparation proceed as follows 1 From the FIELDBOOK menu select NURSERY then NEW Enter the Site ID in this example HA98A and the Nursery ID 1202 Select Seed has been prepared as w N Enter the Season in this example 98A and Prep ID SAMPLE of the appropriate seed preparation b 6 Enter the Site number that has been used for planting this nursery in this example 1 Include
19. parental data in nursery book is selected by default deselect it if you so wish Select OK New Nursery 21x Site ID HA98A Nursery ID 1202 C Nursery without seed preparation Seed has been prepared as Season Prep ID A Site aaa Loewe Include parental data in nursery book The program uses the entrylist and design of the corresponding seed preparation and site to make the entrylist of the new nursery workbook Each nursery is stored in a different nursery workbook The first worksheet of the nursery workbook labeled Entrvlist contains the list of the entries planted in that nursery The second worksheet labeled Ste list contains the list of the seed that is harvested from that nursery The third worksheet labeled Stock Label contains the stock labels for seed harvested from that nursery G16BNSEQCOF228 2 4 B B B 1F47 2 1 2 1 B B B G16SegC1FS8 1 1 1 2 B B MZ97B 1211 6 tol 28 Gl6Seg P49 SR BC6S3 JHSHHS 73 10 1 B1 B B B MZ978 1211 14 P49 SR BC6S3 HSKHSK 218 2 41 B1 B B B__ MZ97B 121117 20 28 B 1 8332 5R BC3 183 1 1 1 B B4 1 B1 B B MZ97B 1211 19 pe Sea epic 1 u A dun 1 3 4 Entry Pedigree 37 20 zst 30 10 The nursery workbooks are characterized by Site ID and Nursery ID and are stored in CAFBK NURSERY in this example CAFBK NURSERY HA98A 1202 11 Site ID and Nursery ID form the Origin of
20. part of the screen that gives you instructions how to answer each question in each line 3 Move the cursor to MSTAT file name containing data Enter the name of the drive subdirectory ies and file Example C EXAMPLE LOWN In this example is the name of the drive EXAMPLE is the name of the subdirectory and LOWN is the name of the file 4 The questions in line 2 to 6 refer to the column number in your find in which you find the information Example If replicate in your file is in column 3 enter 3 for the question in line 2 Variable containing replicate number Pressing the F1 key allows you to see a list of the variables columns in your file 5 You can answer the question in line 6 Variables to be used in the analysis either by listing the columns in which the variables are found and separating them by a space or by writing the column with the first variable and the column with the last variable and writing in between them Example If your variables for analysis are in columns 5 to 9 you can either write 5 6 7 89 or 5 9 40 6 Line 7 and 8 are usually filled in automatically by the program Unless you have empty lines at the beginning of your MSTAT file First case to be included should be set to 1 Unless you have empty lines at the beginning of your MSTAT file Last case to be included should be set to the number of plots in your trial
21. selection intensity of 5 on lodging In this 44 15 16 17 18 19 20 21 22 case the selection pressure on grain yield is ABS 3 0 10 30 the selection pressure on lodging is ABS 1 5 5 7 5 This means that you put a four time higher pressure on selecting for increased grain yield than on selecting for decreased lodging Rule Only include variables with significant differences between entries as seen from the analysis of variance in your selection If the entries did not differ significantly leave selection intensity at 0 14 6 Once you have completed selection target and selection intensity for a variable use the F10 key to move to the next variable You can use the F9 key to move to the previous variable After completing selection target and selection intensity for all variables and pressing the F10 key the program starts processing You will see a summary statistics for the trial Press the F10 key You will see the correlation matrix Press the F10 key You will see a summary table of the selection targets and selection intensities you have chosen for the different variables Press the F10 key You will see a list of the best entries considering the selection targets and intensities you have applied Press the F10 key until you come to Summary of averages for selected fraction Summary of averages for selected fraction This table shows the averages of the selected entries compared to the a
22. the stocklist of an existing nursery from the inventory or from a previous seed preparation 331 ENTERING ENTRIES MANUALLY You can enter entries manually in your seed preparation Proceed as follows 1 Enter entry number 1 2 3 in column A Note An entry list of a seed preparation needs to start in row 6 2 Enter Stock ID in column B 3 Enter Pedigree in column C 4 Enter Origin of the seed in column D You can as well cut and paste from other files Note Never leave a free row between entries in a seed preparation list 33 2 SELECTING ALL ENTRIES FROM AN EXISTING SEED PREPARATION OR NURSERY To fill automatical y all entries from an existing nursery or previous seed preparation in your current seed preparation proceed as follows 1 t2 Position your cursor in the line where you want to start inserting entries from an existing nursery or from a previous seed preparation From the FIELDBOOK menu select SEED PREPARATION then SELECT ENTRIES The following dialog box appears Select Entries Lx Select entries Nursery C Inventory C Seed Preparation L Site ID Season Directory R IN kennt ID Choose whether you want to insert entries from an existing nursery the inventory from previous seed preparation by clicking on the appropriate bullet Enter the corresponding identifier of nursery or seed preparation Choose All entries will be inserted at the
23. 4 5 6 7 8 Pedigree Origin Seeds per jentry 4134 2 Gl BNSEQCOF228 2 4 B B B MZ97B 1211 4 4134 3 G16SeqC1F47 2 1 2 1 B B B MZ97B 1211 5 134 4 G16SegC1FS8 1 1 1 2 B B B Mzo7B 1211 6 A134 7 SPEC7F41 1 2 2 1 B B B mzo78 1211 10 4134 8 G15C22MH13141 3 4 1 3 1 4 BBB B B B__ mz978 1211 11 A134 10 _ P49 SR BC6S3 JHSKHS4 73 10 41 B1 B B B _ MZ97B 1211 14 A134 11 _ P49 SR BC6S3 HSKHSK 218 2 41 Bl B B B MZ97B 1211 17 4134 13 LB 1 8332 SR BC3 183 1 1 1 B BA1 1 B1 B B4MZ97B 1211 19 PL20 SR FS amp FS amp S 44 28 1 B1 B B B MZ97B 1211 20 3 4 MAKING A DESIGN FOR A SEED PREPARATION After you have completed an entrylist you need to make a design e you need to decide at how many sites you want to plant these entries with how many reps and how much seed you need to put in each seed envelope 3 4 1 MAKING AN UNREPLICATED DESIGN 1 From the FIELDBOOK menu select SEED PREPARATION then APPLY DESIGN The following dialog box appears Apply Design 21x C Replicated Sites 3t Entries la Seeds mem Cancel 2 Click on Unreplicated 3 Fill in the number of sites where you want to plant the nursery In this example the nursery should be planted at 3 different sites 4 FIELDBOOK automatically detects the number of entries in your entrylist 5 Fill in the number of seeds y
24. AL In this example is the name of the drive EXAMPLE is the name of the subdirectory and TRIAL is the name of the file Be aware if you use a name and directory that you have previously used you will overwrite the previously created file and you will never be able anymore to retrieve the information that you stored in the previously created file Thus create a unique name for each trial 8 After completing the information in line 1 to 6 and checking that the information is correct press the F10 key 9 ALPHA makes an MSTAT file with an alpha 0 1 lattice design If successful the program automatically changes to the VIEW EDIT mode for this MSTAT file If you encounter problems after pressing F10 consult your computer expert to increase the conventional memory of your computer to at least 600 kBytes 10 Press the ESC Key twice to leave the VIEW EDIT mode and return to the menu for N NEW RANDOMIZATION 11 You can make randomizations for other trials or press the ESC key to return to the main menu 4 2 ANOVA ALPHA LATTICE DESIGN With this command you can make an analysis of variance for an alpha 0 1 lattice design and calculate the adjusted mean of each genotype treatment 1 Move the cursor to A ANOVA ALPHA LATTICE DESIGN on the main menu and press the ENTER key 2 Use the cursor to move from one line to the next Note that for each line you have a green box appearing in the lower
25. Agriculture Organization FAO of the United Nations the International Bank for Reconstruction and Development World Bank the United Nations Development Programme UNDP and the United Nations Environment Programme UNEP Financial support for CIMMYT s research agenda also comes from many other sources including foundations development banks and public and private agencies CIMMYT supports Future Harvest a public awareness campaign that builds understanding about the importance of agricultural issues and international agricultural research Future Harvest links respected research institutions influential public figures and leading agricultural scientists to underscore the wider social benefits of improved agriculture peace prosperity environmental renewal health and the alleviation of human suffering lnternational Maize and Wheat Improvement Center CIMMYT 1999 Responsibility for this publication rests solely with CIMMYT The designations employed in the presentation of material in this publication do not imply the expressions of any opinion whatsoever on the part of CIMMYT or contributory organizations concerning the legal status of any country territory city or area or of its authorities or concerning the delimitation of its frontiers or boundaries Printed in Mexico Correct citation The CIMMYT Maize Program 1999 A User s Manual for Fieldbook 5 1 7 1 and Alpha Mexico D F CIMMYT ISBN 970 648 26 9 AGROVOC des
26. B1 1 B1 B B B DTPTwCTF120 1 6 1 2 B DTPIWCTF122 4 2 2 1 B DTP2WCSF138 1 2 3 2 B OTPIWCTF230 1 6 B B DTPIWCSF259 2 2 4 2 1 1 8 5 B DTP1TwC6F186 1 2 1 4 1 B B B 13 2no68 1 2 B B b GI6BNSEQCHTF 115 4 1 30323 LPSC3H23T 2 1 1 2 2 amp B t CML202 3 11 2 B LPSC2H231 2 1 1 1 2 amp B S CML202 B B 4 CML202 G15C22MH1481 1 1 1 6 1 4 B BBB B B CML202 LB 1 8392 SR BC3 183 1 1 1 B B21 1 B1 8 B CML202 303224 PSCSH29T 2 1 1 2 2 8 B 4CML206 6 3 CONSOLIDATE THE INVENTORY This option lets you add the stocklists from all nurseries with the same Site ID to the inventory l e after finishing harvesting your nurseries at a certain site and making all the stocklists you can move the stocklists with one single command to the inventory This is called consolidate inventory To consolidate your inventory proceed as follows 1 From the FIELDBOOK menu select INVENTORY then CONSOLIDATE The following dialog box appears t3 3 6 4 consolidate Inventory All stocklists with a common site ID are added to the inventory The inventory of individual years is saved on different worksheets in the inventory workbook Inventor year Site ID Because an EXCEL worksheet cannot contain more than 65536 rows you need to divide your inventory so that not more than 65550 seed lots are stored on the same worksheet You can divide your inventory using Inventory year l e different inventory years are stored
27. CIMMYT Institutional Multimedia Publications Repository http repository cimmyt org CIMMYT Maize A user s manual for fieldbook 5 1 7 1 and alpha Banziger M 1999 Downloaded from the CIMMYT Institutional Multimedia Publications Repository SUA a mmm for User s Manual Fieldbook 5 1 7 1 Program for managing for a maize breeding program pedigrees data and fieldbooks Program for creating and analyzing alpha The Maize Program lattice designs User s Manual for Fieldbook 5 1 7 1 Program for managing pedigrees data and fieldbooks for a maize breeding program Developed by Marianne Banziger and Alpha Program for creating and analyzing alpha lattice designs Interface developed by Hector Barreto based on the algorithm developed by BioSS Biomathematics amp Statistics Scotland CIMMYT The Maize Program CIMMYT is an internationally funded nonprofit scientific research and training organization Headquartered in Mexico the Center works with agricultural research institutions worldwide to improve the productivity profitability and sustainability of maize and wheat systems for poor farmers in developing countries It is one of 16 similar centers supported by the Consultative Group on International Agricultural Research CGIAR The CGIAR comprises over 55 partner countries international and regional organizations and private foundations It is co sponsored by the Food and
28. EDSHIP XLT Template for the seed shipment file e TRIAL XLT Template for the trial file e FBKSI XLA FIELDBOOK 5 1 only Compiled ADD IN program for EXCEL 10 2 ANNEX 2 TEMPLATE RESTRICTIONS 10 21 INVENT XLT INVENTORY TEMPLATE e Worksheets are labeled Inventory and Stock Label e Worksheet Inventory Cell A is allocated to Title e Worksheet Inventory Cell G1 is allocated to Logo e Worksheet Inventory Column A and B are allocated to Stock ID e Worksheet Inventory Column C is allocated to Pedigree Worksheet Inventory Column D E and F are allocated to Origin e Worksheet Inventory Column is allocated to Memo Worksheet Inventory Column is allocated to Seed quantity e Worksheet Inventory Column I to X are allocated to Headers 1 to 16 as defined in Options Change Templates e Worksheet Inventory Inventory items are listed starting row 6 e Worksheet Inventory Row 5 is empty 10 2 2 NURSERY XLT NURSERY TEMPLATE Worksheets are labeled Entrylist Stocklist and Stock Label Worksheet Entrylist Cell is allocated to Title e Worksheet Entrylist Cell R1 is allocated to Site and Nursery ID e Worksheet Entrylist Column A is allocated to Entry e Worksheet Entrylist Column B is allocated to Pedigree e Worksheet Entrylist Column is allocated to Origin 34 Worksheet Entry
29. If possible do not choose block sizes that are less than 50 of the value you would have chosen for a fairly uniform soil Example You have a design with 192 genotypes Possible factors of 192 are 2 3 4 6 8 12 16 24 32 48 64 96 If your soil is fairly uniform choose a block size of 12 If your soil is variable choose a block size of 8 If your soil is very variable choose a block size of 6 Move your cursor to Randomize first replication Y N If you want to have the entries in your first replicate randomized write Y If you do not want to have the entries in your first replicate randomized i e plot 1 should be entry 1 plot 2 should be entry 2 plot 3 should be entry 3 etc write N Move your cursor to Number of check treatments Assuming that the check entries in your trial are the first entries in the entry list enter the number of checks in your trial Example Entry 1 is your check entry 1 entry 2 is your check entry 2 and entry 3 is the first experimental genotype in your trial In this case enter 2 in this line If your check entries are not the first entries in the entry list or if you do not have check entries in your trial enter 0 zero in this line 39 7 Move your cursor to Output file name Enter the name of the drive subdirectory ies and file where you want the new randomization to be saved The file name should consist of five or less letters Example CMEXAMPLENTRI
30. PEN 2 in Site ID and Nursery ID Open Nursery File HE Ste 1D usa Nursery ID 1201 Cancel w Select OK Lal The program opens the selected nursery workbook 43 MAKE A STOCKLIST After harvest of a nursery you want to make the new pedigree and origins for the harvested seed and allocate a stock ID to the seed that is unique in your entire inventory MAKE STOCKLIST lets you update pedigrees origins and allocates a unique stock ID Proceed as follows 1 Fill in the number of ears selected in column D Ears select of the Entrylist of the nursery workbook 2 ak 4 Material SAMPLE 1 A Entry select quant H mayi P poli Cummroomadepse rop sal GL6SeqC1F47 2 1 2 1 8 BB mzoBazii s ol 29 25 remonte al aof tol 4 SPEC7F41 1 2 2 1 8 B8B 2 a 14 28 econ ea 3 aul 15 P49 SR BCES3 JHSHHS 73 10 1 B1 B B B MZ97E 1211 14 2 P49 SR BC6S3 HSKHSK 218 2 41 B1 B B B MZ97B 1211 17 al 8 LB 1 8332 5R BC3 183 1 1 1 B BKl 1 B1 B B MZ97B 1211 19 9 pL20 SRJFSEFSH S 44 241 41 B1 B B B MZ97B 1211 20 1 2 3 From the FIELDBOOK menu select NURSERY then MAKE STOCKLIST Stocklist FIETEWJ C Sib increased 1t Bulked B C Paired crosses C Topcrosses to tester Recombination bew
31. Site is Cancel FIELDBOOK will use the entry list and design in the seed preparation file to create the trial files For each site the program creates a new trial workbook 8 The trial workbook is stored in C FILEDBOOK TRIAL using season prep ID and site number as sub directory and file name E g the trial for site 4 3 of the seed preparation C FBK SEEDPREP 98A SAMPLE XLS is stored as C FBK TRIAL 98A SAMPLE3 XLS Kit Harvest date zam ij 2 G16SeqC1F47 2 1 2 1 B B B Aleowe7MA1 1991 RRR 9 The trial workbook contains a Fieldbook with design and pedigrees a Result sheet with entry numbers pedigrees and origins and a master sheet with the design only labeled as HP ALETA 6 P49 SRBCES3 ESHHSA 73 10 81 Bl B B B 1635 o IPL20 SRJESHSHS 44 241 41 BL B E B ree 19 iE 2 GI6SeqC1F41 2 1 2 1 B B B EE 20 2 if s peesmecespsenwezi2t mtsn5 144 bi Fieldbook Results HP 17 18 10 A copy of the HP sheet is stored as Lotus 123 file C FILEDBOOK TRIAL using season prep ID and site number as sub directory and workbook name example CAFBKATRIAL 98A SAMPLE3 WK 1 This file contains the trial design and can be transferred to an HP palmtop 512 CREATING A NEW TRIAL WORKBOOK WITHOUT A SEED PREPARATION Sometimes you want to create a new trial for which you did not prepare the seed yourself because g the seed for the trial was sent to you ready for planting Pro
32. and and pressing the ENTER key At the bottom of the screen you always find a box that gives you information and instructions to a selected command E g Use the arrow keys f or J to move your cursor to N NEW RANDOMIZATION until it is highlighted At the bottom you find the explanation Generate new randomization for an alpha 0 1 lattice design USING ALPHA NEW RANDOMIZATION With this command you can make a randomization for an alpha 0 1 lattice design 1 Move the cursor to NEW RANDOMIZATION on the main menu and press the ENTER key Move the cursor to the first line Number of replications in design and choose and enter the number of replications for your trial design e g 3 Move the cursor to the second line Number of treatments e g genotypes and choose and enter the number of genotypes e g 96 The number of genotypes must not be a prime number Move your cursor to third line Number of plots per block and enter the number of plots per block block size This number must be a factor of genotype number i e you must be able to divide the number of genotypes by the number of plots per block Use the following rules e f your soil is fairly uniform choose a block size that is near the square root or slightly below the square root of the number of genotypes e f your soil is very variable choose a block size within which you expect the soil to be fairly uniform e
33. ason A 97B stands for that the seed was prepared in the year 1997 season B etc Prep ID EPOP stands for that the seed preparation was called EPOP etc 3 1 CREATING A NEW SEED PREPARATION To create a new seed preparation proceed as follows AA A A low Help Fieldbook En Nursery Open gt eee Trials gt Select Entries Inventory Apply Design Seed Shipment Seed Labels Double Entry Data Check Print Options About Fieldbook 5 1 1 From the FIELDBOOK menu select SEED PREPARATION then NEW 2 The following dialog box is displayed New Seed Preparation Eg an GEA Prep 1D 3 Enter the Season 1 the season for which you are preparing the seed and the Prep ID i e the identity by which this particular preparation will henceforth be known by In this tutorial the season is 98A and the Prep ID is Sample New Seed Preparation i x Season 98a Prep ID Sample 4 Select OK 5 You will now have a blank seed preparation workbook on the screen In this case Sample see below EF Microsoft Excel SAMPLE XLS a Eile Edi View Insert Format Tools Data Window Fieldbook Help O SES 2 BISS 2191 10 ee oz Times New Roman 10 7 0 25 8 08 1 45 Al 3 ss Prep ID sap a AA E EE A 1 Prep IDISAMPLE 2 Entry E ID 6 Each seed preparation
34. ceed as follows 1 From FIELDBOOK menu select TRIAL then NEW The following dialogue box appears New Trial Serie 12 x C Seed has been prepared as Season 39a war Eos V the freldoocks Cancel 23 2 Click on Trial without seed preparation 3 You will be prompted to fill in Season e g 98A and Trial ID e g NOPREP New Trial File HE Season oos Trial ID NOPREP Cancel 4 Select OK 5 2 OPEN AN EXISTING TRIAL To open an existing trial workbook proceed as follows 1 From the FIELDBOOK menu select TRIAL then OPEN The following dialog box appears Season oaa Trial ID 5AMPLE3 Cancel N Fill in the Season e g 98A and Trial ID e g SAMPLE3 Select OK 3 4 The program opens the selected trial workbook 6 INVENTORY So far you have stored the information on harvested seed in individual nursery files Often you want to search across different nursery files and it is therefore of advantage to pull all nursery information into one single file the inventory An inventory file is usually created only ONCE because you want to have all information in ONE file only After creating an inventory you just continue adding information coming from nurseries that you harvested 6 1 CREATING A NEW INVENTORY To create your inventory file proceed as follows 1 From the FIELDBOOK menu select INVENTORY then NEW The following dialog box appears New Inventor
35. criptors Maize Zea mays Varieties Land races Plant breeding Variety trials Ancestry Provenance Genera Taxa Data analysis Methods Computer software Additional keywords Alpha Lattice Designs CIMMYT AGRIS category codes F30 Plant Genetics and Breeding F70 Plant Taxonomy and Geography U10 Mathematical and Statistical Methods Dewey decimal classification 633 153 FIELDBOOK Hardware requirement PC with at least a 486 processor and 16 MB ram Software requirement Microsoft EXCELO 95 or later versions of Microsoft EXCEL Necessary disc space for programs 700 kB ALPHA Hardware requirement PC with at least a 386 processor and 8 MB ram Software requirement MS DOS Necessary disc space for programs 2 200 kBytes Necessary space in conventional memory for programs 600 kBytes USER SUPPORT Colombia L Narro Leon CIMMYT Colombia c o CIAT Apdo Aereo 67 13 Cali FAX 57 2 4450025 Email LNARRO CGIAR ORG Ethiopia S Twumasi Afriyie CIMMYT Ethiopia P O Box 5689 Addis Ababa FAX 251 1 611892 Email S TWUMASI CGIAR ORG Kenya A O Diallo CIMMYT Kenya P O Box 25171 Nairobi FAX 254 2 521001 Email A O DIALLO CGIAR ORG Mexico E Rodriguez CIMMYT Mexico Apdo postal 6 641 06600 Mexico D F FAX 52 5 7269091 Email E RODRIGUEZ CGIAR ORG Thailand F Gonzalez CIMMYT Thailand P O Box 9 188 Bangkok 10900 FAX 66 2 5614057 Email F GONZALEZQCGIAR ORG Zimbabwe M B nziger CIMMYT Zimbabwe P O
36. ction intensities to weight the relative importance of the different environments IMPORTING ASCII FILES INTO MSTAT If you use other programs such as Word Word Perfect or EXCEL you may need to exchange files between those programs and ALPHA or MSTAT 1 4 2 5 In Word Word Perfect EXCEL or any other program save the file as a text file where columns are separated by either a space comma or Tab Go to MS DOS At the C prompt type CDIALPHA and press the ENTER key Type IMPORT and press the ENTER key Enter the name of the drive subdirectory ies and file of the text file and press the ENTER key Example CEXAMPLEIDROUGHT TXT In this example C is the name of the drive EXAMPLE is the name of the subdirectory and DROUGHT TXT is the name of the text file Enter the name of the drive subdirectory ies and file of the MSTAT file you want to create and press the ENTER key Example 5 In this example is the name of the drive EXAMPLE is the name of the subdirectory and DRTMST is the name of the MSTAT file Enter 32 if columns in the text file are separated by a space Enter 44 if columns in the text file are separated by a comma Enter 9 if columns in the text file are separated by a Tab Press the ENTER key You should get the message that the file was successfully imported If yes you can open the
37. d Preparation Column C is allocated to Pedigree Worksheet Seed Preparation Column D is allocated to Origin Worksheet Seed Preparation Column H to W are allocated to Headers 1 to 16 as defined in Options Change Templates Worksheet Seed Preparation Entries are listed starting row 6 Worksheet Seed Preparation Row 5 is empty Worksheet Design Column A is allocated to Site Worksheet Design Column B is allocated to Rep Worksheet Design Column C is allocated to Block Worksheet Design Column D is allocated to Plot 35 Worksheet Design Column E is allocated to Entry Worksheet Design Column F is allocated to Seed Worksheet Design Design is listed starting row 3 Worksheet Design Row 2 is empty 10 24 SEEDSHIP XLT SEED SHIPMENT TEMPLATE Worksheets are labeled Seed Shipment and Labels Worksheet Seed Shipment Cell B3 is allocated to Receiver Worksheet Seed Shipment Cell G3 is allocated to Shipment ID Worksheet Seed Shipment Cell GS is allocated to Date and your Ref Worksheet Seed Shipment Column A is allocated to Entry Worksheet Seed Shipment Column B is allocated to Stock ID Worksheet Seed Shipment Column C is allocated to Pedigree Worksheet Seed Shipment Column D is allocated to Origin Worksheet Seed Shipment Column E is allocated to Seed quantity Worksheet Seed Shipment
38. e with the adjusted means in this example CAEXAMPLELOWNMNS You can as well use MSTAT to use the adjusted means in further calculations SELECTION ASSISTANT This part of the program assists you in selecting the best entries of a trial using the data of various traits i e you can create a simple selection index l In the main menu of ALPHA move the cursor to S SELECTION ASSISTANT on the main menu and press the ENTER key Use the cursor to move from one line to the next Note that for each line you have a green box appearing in the lower part of the screen that gives you instructions how to answer each question in each line 42 Move the cursor to File name with selection data Enter the name of the drive subdirectory ies and file from which you want to select the best entries This file is usually a means file you created using A ANOVA ALPHA LATTICE DESIGN or any other program that calculates you the means of a replicated trial The file must be in MSTAT file format Example CHEXAMPLELOWNMNS In this example C V is the name of the drive EXAMPLE is the name of the subdirectory and LOWNMNS is the name of the file that contains the means The questions in line 2 and 3 refer to the column number in your find in which you find the information Example If the variable that identifies the entry in your file is in column 1 enter 1 for the question in line 2 variable containing en
39. ed 1 Sib increased ERE Bulked 8 LL Paired crosses Topcrosses to tester 6 202 Recombination beween lines to and to Stock ID 198 Select OK FIELDBOOK updates the pedigrees and origins and assigns a Stock ID The Stock ID consists of two parts separated by The left part of the Stock ID is identical for all seed harvested from a certain nursery as characterized by Site ID and Nursery ID The right part of Stock ID differs for different progenies harvested from that nursery If the Entrylist of that nursery contains performance data it is copied to the Stocklist Enter a description for the seed harvested from this nursery in cell C3 in this example EARLY LINES CML202 A B D E E G C 1 Material EARLY LINES CML202 Stock ID 198 4 4 31198 3 SPEC7F41 1 2 2 1 B B B CML202 HA9SA 1202 4 4 mm Stock ID Pedigree Seed Memo quant 11198 1 GI6BNSEQCOF223 2 4 B B B CML202 HA98A 1202 1 1 21198 2 G16SeqC1FS8 1 1 1 2 B B B CML202 HA984 1202 3 3 41198 4 G15C22MH131 1 3 4 1 3 1 BBB B B B CMLAHA98A 1202 5 2 51198 5 P4S SR BC S3 HSMHS amp 218 2 l Bl B B E CMI HA98A 1202 7 4 61198 6 B 1 8332 5R BC3 183 1 1 1 B B41 1 B1 B BJHA98A 1202 8 1 71198 7 MAKING STOCK LABELS After harvesting the ears and shelling them you want to store the seed and label it appropriately with Stock ID Pedigree and Origin This option lets you prepare such Stock
40. een ines to and mE to Stock ID Select type of pollination if necessary indicate name of tester or entries that are recombined Selfed indicates plants were selfed and ears will be shelled individually to plant ear to row in the next season e Sib increased indicates plants were sibbed full sibs or half sibs and ears are bulked for shelling e Bulked B indicates plants were selfed and ears are bulked for shelling e Paired crosses indicates that entry 1 was crossed with entry 2 entry 3 with entry 4 5 with 6 7 with 8 etc e Topcrosses to tester indicates that all entries were crossed with one common tester Recombination between lines means a specified set of lines of this nursery was crossed with another specified set of lines in this nursery Allocate a unique Stock ID You can simply use a continuous number 1 2 3 for this purpose It is important that you allocate a certain Stock ID only once so that no seed lot has the same Stock ID If several breeders are using the same store room allocate a letter A B 19 C to each breeder and ask the breeder to put that letter in front of each of his Stock ID s i e Al A2 In the following example all entries in this nursery were crossed with a common tester called CML202 and a Stock ID of 198 was allocated that indicates that this seed lot was number 198 harvested by this breeder joke stocz 7 Self
41. esign Number of treatments e g genotypes Number of plots per block Randomize first replication Y N Number of check treatments 0 NF IELDBR SEEDPREP 98A SAMPLE Use cursor keys to position cursor on each question After entering all information press lt F10 gt to begin processing 3 20 58pm Monday August 24 1998 11 Press F10 12 Press ESC three times 13 Open EXCEL and your seed preparation 3 5 CREATING SEED LABELS FOR A SEED PREPARATION This option lets you prepare seed labels for a seed preparation The labels contain all information necessary to prepare the seed and sort seed envelopes according to site and experiment Proceed as follows 1 From the FIELDBOOK menu select SEED PREPARATION then SEED LABELS The following dialogue box appears Make SeedLabeis O O HI How many labels are in a row 17273 EM This question refers to the number of labels in a row you are feeding through your printer There is fanfold paper that has only one column of label In this case enter 1 Enter 2 or 3 if you are feeding fanfold paper with two or three respectively columns of labels Select OK ta FIELDBOOK creates labels sorted according to entry Print the stock labels on fanfold paper with labels Do u e w Prepare the seed and sort it by site and plot number 4 NURSERY 4 1 CREATING A NEW NURSERY This option lets you create a new nursery A nursery file contains the field book
42. file using MSTAT or ALPHA If no you may have used the wrong delimiter to separate columns 48 Centro Internacional del Mejoramiento de Ma z y Trigo Lisboa 27 Apartado Postal 6 641 06600 M xico D F M xico OZAWY 4 151 Ws Tai li i i 1 1 AHHH
43. following approach first possibility 7 1 Use MSTAT to the means files from the various environments so that entry number is in column 1 and the variables of the various environments are listed in the following columns 7 2 You may want to average some data across environments such as anthesis date plant height ear height lodging grain texture etc Do not average grain yields of different environments Do not average data that have shown good genotypic differences in one environment but not in the other such as ASI under drought 73 Use S SELECTION ASSISTANT to select the superior entries across all environments Apply high selection intensities on variables and environments with good genotypic differences If you have conducted the same trial in several environments use the following approach second possibility 8 1 Use MSTAT to merge the selection indices from means files from the various environments so that you receive a file with entry number in the first column selection 47 6 index of the first environment in the second column selection index of the second environment in the third column etc 8 2 Use S SELECTION ASSISTANT to select the superior entries across all environments Note that small selection index values indicate good performing entries and large selection index values indicate poor performing entries Thus you need to have a negative value for the selection targets Use different sele
44. haracteristics of the selected fraction Once you are satisfied with the characteristics of the selected fraction 22 1 Return to the menu of the selection assistant software by pressing the F10 key 222 Change Desired output device to either PRINTER or enter a file name e g C EXAMPLE LOWNSEL 22 3 Press the F10 key and scroll through the screens that contain the selection targets and selection intensities for the different variables but do not change these values anymore 45 23 24 4 5 1 4 6 22 4 Your last selection will be repeated but the selection output will be directed to the printer or the specified file Allocation a selection index to all entries Once you are satisfied with the characteristics of the selected fraction you can use the selection assistant to allocate a selection index ALL entries in the trial 23 1 Return to the menu of the selection assistant software by pressing the F10 key 23 2 Change Desired output device to either PRINTER or enter a file name e g CAEXAMPLEILOWNSEL 23 3 Change Size of selected fraction to the total number of entries in the trial 23 4 Press the F10 key and scroll through the screens that contain the selection targets and selection intensities for the different variables but do not change these values anymore 23 5 Your last selection will be repeated but the selection output will be directed to the printer or the spec
45. ified file and a selection index will be allocated to ALL entries A small value for the selection index indicates good performing entries according to the selection targets and intensities allocated by you a large value for the selection index indicates poor performing entries Press the ESC key then Y to return to the main menu VIEWING THE OUTPUT OF THE SELECTION ASSISTANT Leave the ALPHA programs by pressing the ESC key In MS DOS write EDIT and the drive subdirectory ies and file name where the file with the selection was saved e g EDIT C EXAMPLE LOWNSEL You can scroll up and down in the file using the arrow keys T or Y or the PgUp and PgDn keys Exit by pressing the ALT key pressing then the ENTER key moving with the cursor to Exit and pressing the ENTER key You can as well view and edit the selection file with other programs such as Word Word Perfect or EXCEL VIEW EDIT DATA FILE This option permits you to view an edit an MSTAT file e g a randomization created by N NEW RANDOMIZATION or an adjusted means file as created by A ANOVA ALPHA LATTICE You can as well use MSTAT to view and edit these files 1 In the main menu of ALPHA move the cursor to V VIEW EDIT DATA FILE on the main menu and press the ENTER key Enter the name of the drive subdirectory ies and file that you want to edit Example CMEXAMPLEWLOWNMNS In this example C is the name of the drive
46. is stored in a different seed preparation workbook The seed preparation workbooks are characterized by Season and Prep ID and are stored as C FBK SEEDPREP SEASON PrepID in this example as C FBK SEEDPREP 98A SAMPLE XLS 7 The first worksheet of the seed preparation workbook labeled Seed Preparation will contain the list of the entries prepared for a trial trial series or nursery The second worksheet labeled Design will contain the design for the trials and nurseries for which the seed is prepared The third worksheet labeled Seed Label will contain the seed labels Select the different worksheets by clicking on the appropriate tag of the worksheet 3 2 OPENING AN EXISTING SEED PREPARATION To open an existing seed preparation proceed as follows 1 From the FIELDBOOK menu select SEED PREPARATION then OPEN The following dialog box appears Open Seed Preparation File x Season i Prep ID Enter the Season and Prep ID In this tutorial the season is 98A and the Prep ID is Sample mem Seed Preparation File ES Season 98a Prep ID Sample tro 3 Select OK 4 The specified seed preparation workbook i e C FBK SEEDPREP 98A SAMPLE XLS will display on the screen 3 3 SELECT ENTRIES FOR A SEED PREPARATION This option helps you making an entry list for your seed preparation You can either fill in entries manually or select entries from
47. list Column D is allocated to Ear selected Worksheet Entrylist Column E is allocated to Seed quantity Worksheet Entrylist Column to U are allocated to Headers 1 to 16 as defined in Options Change Templates Worksheet Entrylist Entries are listed starting row 6 Worksheet Entrylist Row 5 is empty Worksheet Stocklist Cell C1 is allocated to Title Worksheet Stocklist Cell G1 is allocated to Stock ID Worksheet Stocklist Column A is allocated to Worksheet Stocklist Column B is allocated to Stock ID Worksheet Stocklist Column C is allocated to Pedigree Worksheet Stocklist Column D is allocated to Origin Worksheet Stocklist Column E is allocated to Ear selected Worksheet Stocklist Column F is allocated to Seed quantity Worksheet Stocklist Column H to W are allocated to Headers 1 to 16 as defined in Options Change Templates Worksheet Stocklist Entries are listed starting row 6 Worksheet Stocklist Row 5 is empty 102 3 SEEDPREP XLT SEED PREPARATION TEMPLATE Worksheets are labeled Seed Preparation Design and Seed Label Worksheet Seed Preparation Cell B1 is allocated to Prep ID Worksheet Seed Preparation Cell A2 is allocated to Seed preparation instructions Worksheet Seed Preparation Column A is allocated to Entry Worksheet Seed Preparation Column B is allocated to Stock ID Worksheet See
48. ng Change Templates data from workbooks created before using Change Templates might be allocated wrongly to workbooks 8 3 created after using Change Templates because FIELDBOOK allocates data according to their position on the worksheet Therefore Select the headers you want to use in your nursery book when you start working with FIELDBOOK Afterwards do not change them any more MODIFYING THE FORMAT OF TEMPLATES The default installation of FIELDBOOK creates a sub directory in your C drive called CAXLFBK Within this subdirectory all your templates for seed preparation files CAXLFBKISEEDPREP XLT nursery files C XLFBK NURSERY XLT trial files CAXLFBKATRIAL XLT inventory file C XLFBK INVENT XLT and seed shipment files C XLFBK SEEDSHIP XLT are saved These templates can be opened like other EXCEL workbooks and the format of the various worksheets can be modified e g to fit the printer set up However the name of the worksheets and the position of rows and columns as indicated in Annex 2 must not be changed Save modified templates as EXCEL template files For further information see Annex 2 FIELDBOOK MADE EASY A QUICK RUN THROUGH THE SEASON Make the entrylist for the seed preparation Create an alpha 0 lattice design using ALPHA and store it in the same directory and with the same name as the seed preparation Apply the design Modify the design manually if necessary Make the seed labels
49. of 1 000 indicates significant differences at 1 a value of 0 000 indicates that are no significant differences between genotypes treatments Rel Eff Indicates how much more efficient the alpha 0 1 lattice was as compared to a randomized complete block design If the value is greater than 1 the alpha 0 1 lattice results in a smaller error variance and it adjusts genotype means for block effects If the relative efficiency is less than 1 0 the alpha 0 1 lattice is less efficient than the randomized complete block design In this case the trial is analyzed as a randomized complete block design and means are not adjusted for block effects Press the ENTER key twice to return to the menu for A ANOVA ALPHA LATTICE DESIGN You can analyze other trials or press the ESC key to return to the main menu VIEWING THE OUTPUT OF THE ANALYSIS OF VARIANCE Leave the ALPHA programs by pressing the ESC key In MS DOS write EDIT and the drive subdirectory ies and file name where the analysis of variance was saved e g EDIT C EXAMPLE LOWN AOV You can scroll up and down in the analysis of variance file using the arrow keys or y or the PgUp and PgDn keys Exit by pressing the ALT key pressing then the ENTER key moving with the cursor to Exit and pressing the ENTER key You can as well view and edit the AOV file with other programs such as Word Word Perfect or EXCEL You can use MSTAT to open and print the fil
50. on different worksheets It is advisable to store as much information as possible on a certain worksheet Thus before consolidating you need to first consider how many different seed lots you harvest at a certain site season year In an average breeding program you may produce 65550 seed lots only within three to five years In this case use 1998 2002 as inventory year and store all nurseries harvested between 1998 and 2002 in the 1998 2002 inventory year In a larger breeding program you may produce 65550 seed lots within one to two years In this case use 1998 as inventory year and store all nurseries harvested in 1998 in the 1998 inventory year Fill in Inventory year and the Site ID from where vou want to add the information of the stocklists to the inventory Consolidate Inventory All stocklists with a common site ID are added to the inventory The inventory of individual years is saved on different worksheets in the inventory workbook Inventory year 1998 Site 1D Hasea Cancel Select OK CREATE STOCK LABELS FROM THE INVENTORY Usually Stock Labels are created after making a stocklist in a certain nursery file However sometimes you enter pedigrees origins and Stock ID s manually in your inventory and you want to label the corresponding germplasm Proceed as follows 15 Open the inventory and manually enter the information for such germplasm Stock Id pedigree origin performance data etc
51. ou want to prepare in each seed envelope In this example 34 seeds are prepared per envelope Apply Design BE Unreplicated C Replicated Sites 3 Entries f ses Seeds 54 Camel 6 Select OK 7 FIELDBOOK asks you whether you wish to create the seed labels at this point or you would wish to do so later Microsoft Excel Do you want to make seed labels 8 Press YES if you want to make the seed labels now press NO if you want to make manual changes on the Design worksheet before you make the seed labels 3 4 2 MAKING A REPLICATED DESIGN Frequently you want to plant a replicated trial at several sites FIELDBOOK relies on one externally created master design for creating different randomizations for several site Proceed as follows 1 Create a master design for the trial Write the master design using four columns e Column 1 Replicate e Column 2 Incomplete block if you do not use a lattice design fill this column with any default value e g with 1 e Column 3 Plot number e Column 4 Entry number 2 Store the master design as an ASCII file with extension DSN Give this file the same name as the seed preparation and store it in the appropriate seed preparation subdirectory e g a master design for a seed preparation saved as C FBK SEEDPREP 98A SAMPLE XLS should be stored as C FBK SEEDPREP 98A SAMPLE DSN You can create the master design using ALPHA a publicly available soft
52. pha U attice design 4 Select NEW RANDOMIZATION The following screen appears Humber of plots per block Randomize first replication Y N Humber of check treatments Output file name 3 12 43pm Monday August 24 1998 Fill in Number of replications Fill in Number of treatments e g genotypes This number must agree with the number of entries in your entrylist 7 Fill in Number of plots per incompete block Use the following rules e If your soil is fairly uniform choose a block size that is near the square root or slightly below the square root of the number of genotypes e If your soil is very variable choose a block size within which you expect the soil to be fairly uniform e If possible do not choose block sizes that are less than 50 of the value you would have chosen for a fairly uniform soil 8 Choose Y Yes or N No for Randomize first replication Y N 9 Fill in Number of check treatments Assuming that the check entries in your trial are the first entries in the entry list enter the number of checks in your trial If your check entries are not the first entries in the entry list or if you do not have check entries in your trial enter 0 zero in this line 10 Fill in the Output file name This Output file should have the same name as the seed preparation and it should be created at the same location as the seed preparation e g FBK SEEDPREP 98A SAMPLE See below Humber of replications in d
53. py drive Assuming that the A drive is the floppy drive type A and press ENTER Type INSFBK and press ENTER This command stands for Install FIELDBOOK The installation will take a few seconds depending on the speed of your computer Start WINDOWS IMPORTANT If you are installing version 7 1 of FIELDBOOK skip steps 6 through 11 Mh m ew EN Start EXCEL From the Tools menu select Add ins Click on the Browse button Select C XLFBK FBK51 XLA Press OK press OK again Exit EXCEL important Copy PERSONAL XLS to C MSOFFICE EXCFL XLSTART assuming standard installation of MSOFFICE or to the location of your EXCEL start up directory EXCEL XLSTART The installation diskette should be kept in a safe place and should not be used for any purposes other than installing FIELDBOOK Start EXCEL FIELDBOOK is ready on the main toolbar of EXCEL any time you open EXCEL 16 When leaving EXCEL a dialog box similar to the one below appears asking you whether changes to the Personal Macro Workbook should be saved Microsoft Excel x 3 Save changes to Personal Macro Workbook 17 Click on YES to save the current settings of the dialog boxes 3 SEED PREPARATION The seed preparation workbook is usually the first workbook created It receives a Prep ID and is allocated to a Season Examples for Season and Prep ID Season 97A stands for that the seed was prepared in the year 1997 se
54. the seed harvested from the nursery in this example HA98A 1202 12 If Include parental data in nursery book was selected the performance data of the parent that produced the seed is included in the nursery book see arrow 4 1 2 MAKING A NURSERY WITHOUT A CORRESPONDING SEED PREPARATION Sometimes you want to create a new nursery for which you did not prepare the seed yourself because e g the seed for the nursery was sent to you ready for planting To make a new nursery in this case proceed as follows l From the FIELDBOOK menu select NURSERY then NEW 2 Enter the Site ID in this example HA98A and the Nursery ID in this example 1203 3 Select Nursery without seed preparation New Nursery 21x Site ID Nursery ID 1203 Nursery without seed preparation C Seed has been prepared as Include parental deta in nursery book 4 Select OK 5 You will get a blank nursery workbook into which you can manually enter pedigree and origins or you can paste pedigree and origins from other files into this workbook X Microsoft Excel 1203 xls 55 File Edit View Insert Format Tools Data Window Help Doe 2968 BAS Oru BEE 92 0 Z Fu Times New Roman 10 B Z U 8 A zz is 3 Entry 8 4 6 7 8 9 12 4 2 OPENING AN EXISTING NURSERY To open an existing nursery proceed as follows 1 From the FIELDBOOK menu select NURSERY then O
55. to be able to search the inventory 2 From the FIELDBOOK menu select OPTIONS then CHAMGE TEMPLATES The following dialog box appears Make Template Headers of data stored in nursery workbook inventory workbook and seed preparation workbook Changes will modify the templates of these workbooks Headeri Header2 Header3 Header4 Header5 Header6 Header Header 8 1st row P sorg MSY GLS Lodg Plt Husk Grain 2nd row Hmay P poli DMR hgt cov text Header9 Header 10 Header 11 Header 12 Header 13 Header 14 Header 15 Header 16 1st row Anth A Resp B Resp Het 2ndrow date Yld pot Drt Low N Yld pot Drt Low N resp Logo used in inventory workbook trial workbook and seed shipment workbook Changes will modify the templates of these workbooks Logo CIMMYT Zimbabwe Cancel 3 in the headers you want to have in your nursery book and inventory using Header 1 to Header 16 enter the Logo you want to have at the top of your field books 4 Press OK 5 FIELDBOOK replaces the headers in the templates for nursery seed preparation inventory and trial files and will ask you several times whether you want to replace the existing template Microsoft Excel xd A file named d xlfbk seedprep xlt already exists in this location Do you want to replace it 6 Choose YES 7 Note Changes of templates will only become effective for workbooks created affer using Change Templates Note If headers are changed usi
56. tory with Seed Preparations cWieldbdseedpep Nursery Files Wedbnusey Trial Files Wed Inventory File s _ efieldbkiwemt Seed Shipments _ erfieldbkiseedhp SCS Directory and Name of Templates Seed Preparation Je xibkiseedprepxt Nursery esvdfbkinurseryxk Trial ce Inventory esdfbkinventk Seed Shipment Default File Names Inventory invent xds wee oem 2 You can change the location of e g your seed preparation files by exchanging C FBK SEEDPREP with any other subdirectory 3 The default installation of FIELDBOOK creates a sub directory in your C drive called CAXLFBK Within this subdirectory all your templates for seed preparation files C XLFBK SEEDPREP XLT nursery files C XLFBK NURSERY XLT trial files CAXLFBKNTRIAL XLT inventory file C XLFBK INVENT XLT and seed shipment files C XLFBK SEEDSHIP XLT are saved You can change the location of e g your nursery template by exchanging C XLFBK NURSERY XLT with any other name of a template 31 8 2 CHANGE TEMPLATES Y our nursery seed preparation and inventory files contain common headers for performance data that you routinely gather in your breeding program You may want to change the headers to match the specific requirement of your breeding program Proceed as follows 1 Make a list of traits performance data you routinely gather in your nursery and for which you want
57. tries that you want to select from a certain nursery a previous seed preparation or the inventory Highlight the information that you entered From the FIELDBOOK menu select SEED PREPARATION then SELECT ENTRIES Seed Preparation Nursery Trials Inventory Apply Design Seed Shipment Seed Labels Double Entry Data Check Print Close Options About Fieldbook 5 1 4 Choose whether the selected entries can be found in the stocklist of an existing nursery in the inventory or in a previous seed preparation by clicking on the appropriate bullet 5 Enter the corresponding identifier of nursery inventory or seed preparation In this example the pedigree and origin of the selected entries can be found in the stocklist of the nursery MZ97B 1211 6 Choose A subset will be inserted for the selected cells ZA Prep ID Entry Stock ID Pedigree expres C D n SAMPLE Select Entries Select entries from Nursery C Inventory C Seed Preparation Site ID SeasonjDirectory Mz978 Prep Nursery Inventory ID 21 1 A subset will be inserted for the selected cells 134 14 o C All entries will be inserted at the current row 9 1 Cancel 7 Press OK 8 FIELDBOOK opens the selected nursery or seed preparation workbook and fills in the remaining information for the entries you selected 1 2 3
58. try ID number Pressing the F1 key allows you to see a list of the variables columns in your file You can answer the question in line 3 Variables to be used in selection either by listing the columns in which the variables are found and separating them by a space or by writing the column with the first variable and the column with the last variable and writing in between them Example If your variables to be used in selection are in columns 2 to 9 you can either write 2 3 456789 or 2 9 Line 4 and are usually filled in automatically by the program Unless you have empty lines at the beginning of your MSTAT file First case to be included should be set to 1 Unless you have empty lines at the beginning of your MSTAT file Last case to be included should be set to the number of entries in your trial Move your cursor to line 6 and write a title that meaningfully describes the trial and the type of selection you want to make Line 7 Include correlation matrix Y N If you type Y you will obtain a correlation matrix among all variables used in selection A correlation matrix provides useful information for selection and it is therefore advisable to answer this question with Y Move your cursor to line 8 Your output will be listing results in columns and you may need to adjust the column number to fit the output media If your output media is the screen set column number to
59. tween labels Four rows are printed on a label Every fifth row is skipped 37 B ALPHA 1 WHAT IS ALPHA The ALPHA Program lets you Create randomizations for alpha 0 1 lattice designs Make an analysis of variance for an alpha 0 1 lattice design and calculate lattice adjusted means Select the best entries from a trial using the data of various traits e g grain yield and secondary traits or using data taken in various environments The ALPHA Program uses MSTAT files i e MSTAT can be used to enter and transform the data gathered for a trial with an alpha 0 1 lattice design INSTALLING ALPHA ON YOUR COMPUTER On your computer go to MS DOS Put the installation disc in the floppy drive Type A and press ENTER assuming that the A drive is the floppy drive Type INSALPHA and press ENTER The ALPHA program is installed in a sub directory called C ALPHA STARTING ALPHA On your computer go to MS DOS At the C prompt type CD ALPHA and press the ENTER key Type ALPHA and press the ENTER key If ALPHA does not start consult your computer expert to increase the conventional memory of your computer to at least 600 kBytes You have a menu with five options N NEW RANDOMIZATION A ANOVA ALPHA LATTICE S SELECTION ASSISTANT V VIEW EDIT DATA FILE T TERMINATE 38 4 4 1 You can select any of the five menu commands by using the arrow keys T or 4 to move the cursor to that comm
60. ust created e g C EXAMPLE TEST 8 7 When you move the cursor to the next line you see the harmonic mean efficiency factor changing to a number that is less than 0 9999 Write this number on a piece of paper 8 8 Move the cursor to MSTAT file name containing data Enter the name of the drive subdirectory ies and file of the file you want to analyze e g C IEXAMPLEILOWN 8 9 Move the cursor to line 2 to 9 and fill in the information as described in point 2 to 7 of this chapter 8 10 Fill in the harmonic mean efficiency factor in line 10 as the number you have noted in point 8 7 9 Move your cursor to line 11 and write a title that meaningfully describes the trial 10 After completing the information in line 1 to 11 and checking that the information is correct press the F10 key 11 ALPHA makes an analysis of variance If successful the program tells you that it created a file with the extension AOV where the analysis of variance is saved You will find a summary table with the following statistics Variable Name of the variables 41 12 13 4 3 12 4 4 MEAN Mean of this variable across the trial LSD Least significant difference at P lt 5 for this variable CV Coefficient of variation for this variable Prob F Probability that there is a significant differences between genotypes treatments for this variable A value of 5 000 indicates significant differences at 5 a value
61. verage of the entire trial population Variable that had a selection intensity different from Zero are indicated with a star Decide whether you are satisfied with the characteristics of the selected fraction By applying selection pressure on a certain value you may have induced correlated changes for another variable and you need to decide whether you can accept that change If not you need to rerun the selection index program and adjust selection intensities so that you result with a selected fraction with satisfactory characteristics Example By selecting for higher grain yield you may have selected plants that have a later anthesis date and are later maturing You may want to select for increased grain yield but maintain the anthesis date constant In this case rerun the selection assistant by continuing to press the F10 key until the screen appears where you can change the selection target and selection intensity on anthesis date Set the selection target to the standardized value for the earliest anthesis date and apply a mild selection intensity Press the F10 key until you see the summary of averages for the selected fraction By applying a selection pressure for earlier flowering entries with higher yield you should result in a selected fraction with high yield but whose anthesis date is more similar to the trial population mean Rerun the selection assistant and change selection intensities until you are satisfied with the c
62. ware from CIMMYT that creates and analyzes alpha 0 1 lattice designs ALPHA stores data in a format that FIELDBOOK will easily interpret and use see 4 4 3 From the FIELDBOOK menu select SEED PREPARATION then APPLY DESIGN Click on Replicated Fill in the number of sites In this example a replicated trial will be planted at 15 sites FIELDBOOK automatically detects the number of entries in your seed preparation list A A DA M Fill in the number of replications In this example the trial has 3 replicates and a master design was created with 12 entries and 3 replicates 8 in the number of seeds you want to prepare in each seed envelope in this example 68 Apply Design El Unreplicated Replicated Sites 15 Entries 12 Reps Seeds Jes Carcel 9 Select OK 9 FIELDBOOK asks you whether you wish to create the seed labels at this point or you would wish to do so later 10 Press YES if you want to make the seed labels now press NO if you want to make manual changes on the Design worksheet before you make the seed labels 3 4 3 USING ALPHA FOR CREATING YOUR MASTER DESIGN To use ALPHA for creating your design proceed as follows Vie Exit EXCEL and go to the DOS prompt C Type CD ALPHA and press ENTER Type ALPHA and press ENTER The following screen appears AOE tc SELECTION ASSISTANT VIEW EDIT DATA FILE TERMINATE enerate new randomization for al
63. x axis On the standardized x axis this corresponds to 3 0 to 3 0 standard deviations c from the mean grain yield 1 66 t ha In this case your selection target is 3 0 which corresponds to the highest grain yield Example Your variable is lodging and you want to select for decreased lodging Values are ranging from 0 to 69 lodged plants On the standardized x axis this corresponds to 3 8 to 3 8 standard deviations c from the mean lodging percentage 18 In this case your selection target is 3 8 which corresponds to the lowest lodging percentage 14 3 Press the F2 key to come to a summary table for the graph you just saw 14 4 Press the F2 key again to return to the screen that asks you to assign a Selection target and a Selection intensity to this variable Enter the selection target that you have chosen after consulting the frequency distribution graph 14 5 Selection intensity You can choose values between 0 to 10 This value corresponds to the relative importance of this value in selection It is entirely chosen by the breeder The program will calculate the product of selection intensity selection target The larger the absolute value for this product the more selection pressure you apply on this variable Example You include two variables in your selection grain yield and lodging Grain yield has a selection target of 3 0 lodging has a selection target of 1 5 You puta selection intensity of 10 on grain yield and a
64. y 12 1x Name of the new inventory I 24 2 Fill in the name of your inventory in this example INVENT New Inventory of the new inventory INVENT Cancel 3 Select OK 6 2 OPEN THE INVENTORY To open you inventory workbook proceed as follows 1 From the FIELDBOOK menu select INVENTORY then OPEN 2 As you only have one single inventory FIELDBOOK opens it for you to select material nvMB_xls 1597 File Edit View Insert Format Tools Data Window Help Fieldbook jn SESIATEXSAC o c Oe rei wea Times New Roman 8 Y U H SEED INVENTORY M B nziger 1998 Microsoft Exce MEMO GI6BNSEQCOF 118 1 1 B GI6ScqC1F 41 2 1 2 1 B B GI6BNSEQCOF118 1 1 B NAW 5867 P30 SR 111 2 NA w 5867 P30 SR 52 1 5 3 1 B GI6BNSEQCOF113 1 1 B INAW 58567 P30 SR 111 2 NAw 5867 P30 SR 25 1 3 1 1 B B GI6BNSEGCOF118 1 1 BHCOMPE2 P43 5R COMPE2 FS8 20 1 1 B 1 B GI6Sc qC1F4T 2 1 2 1 B B NAw 5867 P30 SR 111 2 fNAWw 586T P30 SR 52 1 5 3 B G16SeqCiF47 2 1 2 1 B BI NAW 5867 P30 SR 111 2 NAw 5867 P30 SP 25 1 9 1 1 5 B GI6SeqC1F47 2 1 2 1 B B COMPE2 P43 SR COMPE2 FS8 20 1 1 6 1 B INAW 5867 P30 SR 111 2 NA w 5867 P30 SR 52 1 5 3 1 B NAW 5867 P30 SR 111 2 1N NAW 5367 P30 SR 111 2 NAW 5861 P30 SR 52 1 5 3 1 B COMPE2 P43 SRHCOMPE2 NAW 5867 P30 SR 111 2 NAw 5861 P30 SR 25 1 3 1 1 B B COMPE2 P43 SRI COMPE GI6BNSEQCOF116 1 1 B K64R PL16 R 39 1

1e oo < • 1 17. 1 - Repository

Contents

Download Pdf Manuals

Related Search

Related Contents

1e oo &lt; &bull; 1 17. 1 - Repository

Contents

Download Pdf Manuals

Related Search

Related Contents

1e oo < • 1 17. 1 - Repository