Procedure for transforming tab-separated value (tsv) plaintext judging form into Excel Spreadsheet.

Process each topic-specific tsv file separately.

1. Open the file with Excel. The text import wizard will come up. Use delimited, start import at row 1, use Tab delimiters.
2. Format the first header row in bold from column A to J.
3. Format the "MESH ASPECTS" row header text with blue and underline. This cell is a hyperlink, and needs to look like one.
4. Format the cells under the "PMID" column, but not the column head with blue and underline.
5. Hide columns D, E, and F, which are the "OFFSET", "LENGTH", and "SPANID" columns.
6. Format the "QUESTION TEST" column with the Format Cells Wrap Text option.
7. Format the "PLAIN TEXT" and "ANSWER TEXT" columns with the Format Cells Wrap Text option.
8. Expand the width of the "QUESTION", "PLAIN TEXT", "ANSWER TEXT", and "MESH ASPECTS" Columns approximately equally to fill the available
visible horizontal space.
9. Adjust row widths to ensure that each column header is fully visible.
10. Select the data cells of the "RELEVANCE" column H, but not the header cell.
Under Data Validation, allow "List", uncheck "Ignore blank", make sure "in cell drop down" is checked and for Source put in "=$K$1:$N$1"
This creates a dropdown box of 4 choices when the relevance cells are selected.
11. Hide rows K through N.
12. Add list sorting functionality in this manner. Select all cells with values on form, that is rows A through J, and all rows
that include data including the header row. Then select the menu item Data, List=>Create List, and click OK.
13. Rearrange row widths as in step 8 to fill the horizontal space and create a useful layout.
14. Select all cells and Autofit the row heights.
15. Split the view vertically so the top header row always shows when the large bottom window is scrolled.
16. Save the file as an Excel Spreadsheet. Use the same base filename but with the ".xls" extension.