Changes between Version 4 and Version 5 of net.sf.basedb.reggie.notes213


Ignore:
Timestamp:
Oct 2, 2013, 1:56:40 PM (6 years ago)
Author:
Nicklas Nordborg
Comment:

Adding note about fixing PoolConc? annotations

Legend:

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

    v4 v5  
    1818
    1919=== 3. Fix !PoolConc values for all *.dil extracts ===
    20 A manual update is needed to fix `PoolConc` values for existing `*.dil` extracts. More instructions will follow. For now, see #507.
     20
     21Due to a bug (see #507), all `*.dil` extracts have been registered with an incorrect value for the '''!PoolConc''' annotation. This need to be fixed by a manual export/import procedure.
     22
     23 1. To find the libraries in question go to the '''Biomaterial LIMS->Extracts''' page and filter on '''name=%.dil'''.
     24 2. To avoid rounding errors in the exported data go to '''BASE->Preferences''' and set '''Decimals=all'''.
     25 3. Use the '''Table exporter''' plug-in to export a tab-separated file with '''Name''' and '''Original quantity''' columns.
     26 4. Download the exported file to your computer and open in a spreadsheet program.
     27 5. Add a new column '''!PoolConc''' and use the following formula to calculate the values: `=5 * <quantity> / 1000`
     28 6. Save the results as a tab-separated file and upload it to BASE.
     29 7. Use the annotation importer to update the '''!PoolConc''' values.