Changes between Version 1 and Version 2 of net.sf.basedb.reggie.notes27


Ignore:
Timestamp:
May 31, 2012, 11:42:53 AM (8 years ago)
Author:
Nicklas Nordborg
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • net.sf.basedb.reggie.notes27

    v1 v2  
    1919 * Export the name and laterality for all cases that are found and save that to the local computer.
    2020
    21 == 4. Use Excel/OpenOffice or compatible to map laterality to `NoSpecimen` ==
     21== 4. Use Excel/!OpenOffice or compatible to map laterality to `NoSpecimen` ==
    2222
    2323 * The two files that has been exported should include all information that is needed to find the laterality for a given `NoSpecimen` item. With a spreadsheet program as Excel it should be possible to create a formula to do this.
    2424
    25  * TODO -- how to create a formula
     25 * !OpenOffice has the LOOKUP formula that can be used. Open both files and copy the information to two sheets in the same document. In the sheet with the `NoSpecimen` items create a formula that uses LOOKUP on the `Case` name to find the laterality from the other sheet.
    2626
    2727 * Save the result as a tab separated text file, upload it to BASE and use the annotation importer to import the laterality values.