NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: For issue #209: Save as UTF-8 CSV.

To add findings to a characterization, you can add data directly to Data and Conditions by creating columns and adding data manually or you can import as many UTF-8 .csv files as needed(comma-separated value) files. Information can include laboratory include laboratory conditions, pH, or temperature.  You You can add as many files as you wish.

  1. Add data values to Data and Conditions.
    1. To import a file of data values
      1. Save the spreadsheet of data values to a UTF-8 csv (comma-separated value) filefile (not just csv).
      2. Click Import csv and select and follow the prompts to add the data file to the Findings Info.
        Import CSV button
      3. The columns and data are added to Data and Conditions.
    2. To add the data values manually
      1. Specify the number of columns and rows for the matrix, and click Update.
        Manually adding Data and Conditions data values
      2. Add the data values to the rows.

    Info

    Whether you imported or added information manually, you can preface each data value with one of the following: Maintain the default, equal to (=), or select greater than (>), less than (<), or infinity (approximate).
    Adding Data and Conditions values to the table

  2. To define a column, click an underlined column heading.
    Clicking column
    The Column Definition panel displays.
    Defining the Findings column definition
  3. Select a Column Type, Datum or Condition.
  4. Select a Column Name or select other and add a new one.

    Info
    titleColumn Notes
    You can add up to three cell viability Column Names, including cell viability, cell viability B, and cell viability C. You can further identify the column with the Column Value Type.


    1. For Column Type, Datum, the following characterization(s) display customized Column Name options.

      Characterization TypeColumn Type and Column Name Option(s)
      Physico-Chemical
      • Molecular – Molecular Weight
      • Purity – % purity for sample
      • Relaxivity – R1, R2, T1, T2
      • Size – PD1, Peak N , RMS size, Z Average
      • Surface – charge, zeta potential
      In Vitro

      Enzyme Induction – % of Control

      In VivoClick Other to name the column yourself.
    2. For Column Type, Condition, all characterizations provide the Column Name options in the left column of the following table. The Column Name autopopulates the Condition Property options in the right column.

      Column Type, Condition Autopopulates Column NameColumn Name Autopopulates
      Condition Property

      Centrifugation

      N/A

      Culture Media

      media type, serum percentage

      Electromagnetic Radiation

      bandwidth, frequency, time, wavelength

      Freeze Thaw

      N/A

      Long Term Storage

      lyophilized, time

      Lyophilization

      time

      pH

      N/A

      Sample concentration

      N/A

      Short Term Storage

      lyophilized, time

      Solvent Media

      ion concentration, ionic strength, molecular formula, osmolality, serum percentage, with serum

      Sonication

      number of pulses, pulse duration

      Temperature

      N/A

  5. To further identify a column, select a Column Value Type.

    Info
    Once the column information is saved, the Column Type is shown in parentheses after the Column Name, such as cell viability (mean).
  6. Select a Column Value Unit, or select other and add one.
  7. If you want the same value to fill all rows in a column, add a Constant Value.

    Info
    titleFor Column Value Type, boolean
    For Column Value Type, boolean, enter a Constant Value of 1 for true and 0 for false.
  8. Click Save, and the column(s) are updated.

    Info

    If needed, click Set Column Order to change the order of the column headings in the matrix.

  9. Click Save in the Finding section.