NIH | National Cancer Institute | NCI Wiki  

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 UTF-8 .csv (comma-separated value) files. Information can include laboratory conditions, pH, or temperature. 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. Organize your data so that each column name is unique. The following table provides an example. 

        column_name:ExperimentFormulation(other):Size by DLS


        To add a value that is not currently in the system, such as a column name, insert "(other):" before the value. 

        The "value_type:", "value_unit:", and "constant_value:" rows are optional. In those rows, an empty cell is acceptable. 

      2. Save the spreadsheet of data values to a UTF-8 csv file (not just csv).
      3. Click Import csv and follow the prompts to add the data file to the Findings Info.
        Import CSV button
      4. 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.

    Whether you imported or added information manually, you can preface each data value with one of the following: Maintain the default, equal to (=), greater than (>), less than (<), or 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 appears.
    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.

    Column 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)
      • 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 auto-populates the Condition Property options in the right column.

      Column Type, Condition Auto-populates Column NameColumn Name Auto-populates
      Condition Property



      Culture Media

      media type, serum percentage

      Electromagnetic Radiation

      bandwidth, frequency, time, wavelength

      Freeze Thaw


      Long Term Storage

      lyophilized, time





      Sample concentration


      Short Term Storage

      lyophilized, time

      Solvent Media

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


      number of pulses, pulse duration



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

    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.

    For 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.

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

  9. Click Save in the Finding section.
  • No labels