Spreadsheet specific Features

Help Index > Spreadsheet specific Features

Spreadsheet specific Features

Selecting cell ranges via text input

A text selection box is available in the Spreadsheet interface, making it easier to select multiple
non-adjacent groups of cells, by using Excel-like syntax and separating groups with a comma.
Examples:

  • selections within the active sheet: A1:C80, F1:J80
  • selections in different sheets: sheet2!A1:C80, sheet3:sheet4!F1:J80 (this is currently not useful, but later on plotting across sheet will be implemented).
    Note: backward selections such as A80:C1 would work too.

Heat Map

Heat map visualization of data from an Excel sheet in SEEK. Thresholds corresponding to the colours can easily modified using sliders, and the new heat map is instantly calculated and visualized.

  • Select the data to visualize and click on the “Heat map” button.
  • Change the sliders as needed.
  • Click the ‘-‘ to zoom out when there are too many rows, and ‘+’ to zoom back. More than 100% zoom is currently not impossible.
  • Export the figure using “Save as SVG”. A legend representing the status of your sliders will be exported as well.

Parallel Coordinates

Description:
Parallel coordinates are a method for exploring multi-dimensional data. These data can be ordered (as any number) or based on categories such as gender. Parallel coordinate plots map every point to a line linking parallel axes. Distinct items thus become lines that differ in at least one point. The plots allow selecting range filters on the axes. e.g. the users can choose lines that correspond to a high inhibition and to certain IC50 values. Missing data values will be mapped to a horizontal “Missing values” axis under the corresponding vertical axis. This allows to see more easily how missing data is distributed across the different measurements.

  • Select the data you wish to plot and click on the “Parallel Coordinates” button.
  • Filtering data:
    • Click and drag the mouse along axes, marking only the ranges of values which are of interest.
    • Choose whether the filtered data should match “all” or “any” of the conditions you specified.
      “ALL”: one range per axis should be matched by each line (all column filters must satisfied).
      “ANY”: It is enough to fulfill any of the given conditions (at least one column filter must be satisfied).
    • Click “reset filters” to erase all filters and to see all the data again.
    • Rescale the plot to a subset of the data by ‘excluding’ or ‘keeping’ the filtered selection.
  • Visualization:
    • Hover over a line to see its values on every axis.
    • Drag an axis right or left to change the axes order.
    • Click the axis title to highlight it and color the lines based on the values of that particular axis.
    • Roll the mouse wheel over an axis title to rotate all labels. Helpful if long labels overlap.
    • Double-click an axis title to flip the axis values from top to bottom.
    • Export the data to an image file with the “Export PNG” button.


Log in / Register

Need an account?
Sign up

Forgotten password?

Front Page

About NMTrypI WP6

Synergy

(v.0.22.0)

Related Projects and friends

Taverna workflow workbench myExperiment JWS Online ISATAB myGrid Sabio-RK BioPortal Semantic SBML Virtual Liver Network

Powered by:

Ror-logo-32

Icons:
Silk icons 1.3
Crystal Clear icons