ICISworkbook: Forming the hybridization block
From ICISWiki
The succeeding steps will teach you how to create a germplasm list in ICIS Workbook by starting from a pre-formatted list template. Once you have selected the parents you wish to cross, you need to make a list of those lines for planting in a Hybridization Block (HB).
In this exercise, it is assumed that all the parents were already in the IRIS database. If this is not the case, the parents can be entered together with their pedigrees during the formation of the HB or prior to its formation (if the lines that are not in the database are already known).
1. Click List ► New List.
2. A blank list template will be created where you can start entering information about the germplasm list. At this point, enter the information (found in Table 1) to their respective cells.
Table 1. Entries to be entered
| LIST | U03WSHB |
|---|---|
| TITLE | Upland Hybridization Block 2003 Wet Season |
| DATE | 20030601 |
| TYPE | HB |
3. Go to the Observation sheet where you can see six columns which contain information about each germplasm entries. These would comprise the list. Enter the entries in Table 2 to their respective columns in the list template.
Table 2. Entries for Designation, Cross, and Source
| Designation | Cross | Source |
|---|---|---|
| CNA 4196 | CNA 4196 | IURON12 |
| IDSA 113 | IDSA 113 | IURON03 |
| IRAT 170 | IRAT 13/PALAWAN | IURON15 |
| UPL RI 5 | SIGADIS/BPI 76-1 | IURON07 |
| WAB 326-B-B-7-H1 | TOX 1785-19-18/WABC 165 | IURON06 |
| WAB 534-B-3A 1-1 | WAB 181-18/DR 2 | IURON11 |
| YUNLU 28 | IDSA 6/WUNENGDABAIGU-2-5 | IURON04 |
| IRRI 132 | UPL RI 5/IR 12979-24-1 (BROWN) | IURON17 |
| IR 72768-12-1-1 | IR 60080-46 A/IR 65907-116-1-B | U03DSOYT |
| IR 72768-28-1-1 | IR 60080-46 A/IR 65907-116-1-B | U03DSOYT |
| IR 75502-24-1-1-B | B 6144 F-MR-6-0-0/NSIC RC 9 | U03DSOYT |
| IR 75516-30-1-1-B | IR 53236-275-1/CT 6516-24-3-2 | U03DSOYT |
| IR 75516-56-1-1-B | IR 53236-275-1/CT 6516-24-3-2 | U03DSOYT |
| IR 75518-84-1-1-B | IR 60080-46 A/IR 53236-275-1 | U03DSOYT |
| IR 75531-31-1-2-B | IR 70360-54-1-B/VIENG | U03DSOYT |
| IR 76561-AC 8-B | CT 13382-9-4-M/IR 70358-145-1-1 | U03DSOYT |
4. After filling-up the DESIGNATION, CROSS, and SOURCE columns, click List ► Check List.
The application will search for the germplasm names in the ICIS database to see if the germplasm name already exist or not. If the name already exists, the Search Germplasm window (Fig. 5) will appear to show you more information about the matching germplasm and to verify if it is the correct match. If the germplasm name does not exist, the Input Germplasm window will appear for you to enter corresponding information about the germplasm to register it into the database.
5. Since the checking of each germplasm entries is done with the entire batch, a Germplasm Validation window (Fig. 4) will appear at the bottom of the worksheet to identify the errors you encountered. The corresponding cells with an error are also color-coded for you to easily spot the error(s). There are two ways to address this: (1) click the color-coded cell; or (2) click the error entry at the bottom to determine what needs to be done.
In this exercise, you should see orange-colored cells for all the 16 germplasm entries. This means that all names are found in the database and you need to confirm it to get the right GID entry. If you see a red-colored cell, it denotes that the name was not found in the database. This could be due to a typographical error in entering the DESIGNATION and CROSS entries. Kindly double check. Otherwise, you may not be using the proper database for this training exercise. In this case, kindly inform the facilitator.
6. To correct the orange-colored errors, look at the matching germplasm names as shown in the Search Germplasm window (Fig. 5) located on the right side of the screen. Note that you may see more than one germplasm match. This means that there are more than one registered germplasm using the same name. You will also notice that for each individual match (one row) you will see other germplasm names with it, implying that the germplasm has other names, too. In this exercise, double click on each entry that has the name “IRTP” in it.
As you select the correct germplasm entries, each color-coded cell is cleared and is filled with the proper GID entry. The corresponding error entry at the bottom is also cleared until you fix the last error and the Germplasm Validation window disappears.
7. At this point, you can now fill up the ENTRYCODE column. Select any cell in the said column. Then, click Add-ins ► GMS Functions ► Fill with Sequence.
8. This will launch the Naming Convention window where you can specify your customized naming scheme for new germplasms or for other coding needs. In the case of the ENTRYCODE, on the [Sequence] tab specify the information indicated in Table 3.
Table 3. Information for the Naming Convention
| Prefix | HB |
|---|---|
| Start No. | 1 |
| Fixed Width | True |
| Width Size | 3 |
| Suffix | U |
9. Then, click [Apply] to fill the ENTRYCODE column with data.
10. At this point, you are now ready to load the germplasm list into the database. Click List ► Load List.
11. The Load List window, where you can specify where to save the list, will appear . In this case, click [OK] to save it in the default root folder.
12. You’ll be informed of the success of the loading operation with a confirmation message.
13. Click [OK] but do not close the current workbook file for you’ll be using for the next exercise.
