You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

There is possibility to export Compounds and Assays results to the Excel.

Selecting Compounds

To choose compounds for export you can use Compound cart (similar to an eshop).

  • select compounds by mouse and Shift or Ctrl key
  • to add selected compounds to the cart use the menu Add selected compounds to cart
  • compounds remain in the cart until you remove them using Empty compound cart
    • note: before you start your next export do not forget empty your cart
  • to edit compound cart use menu Edit compound cart
     
    • LEM list must be comma separated and only valid form LEMs are allowed (LEMnnnnnnnn - 8 digits).
    • do not forget use button Update LEM list to store changes in cart.
    • note: invalid LEMs formats are removed from the cart
    • there is nor check if the LEM exist in Portal neither you have access to this compound, but inaccessible compounds are not exported

Starting export job

  • By pressing button Start Export selected and cart compounds

    currently selected compounds are added to the cart and Export window appears:
  • you can name you export for easier finding if you start more exports. Name is only used in Portal and is not part of the exported Excel.
  • you can also again check and edit compounds in cart.

Selecting fields for export

In the Compound and Assay tree you can see all fields what can be exported. At the beginning some fields are preselected. Here you can add more fields for the export. Idea behind this selection is following:

e.g. Assay Cell Cycle Analyses - Flow Cytometry will export in following settings these fields: for each compound in cart will be exported columns with data for Cell Line CCRF-CEM and Concentration among first 3 (sorted ascending) and values sub-G1 Avg, G0/G1 Avg, etc.

 


  • Note: you have to create valid selection. E.g. if you deselect Cell Line in above example then export will not start.
  • Note: currently there is not possibility to save selection of fields.

Start Export

By pressing button Start Export, the export job is scheduled and performed on the server. You can continue in the other work with Portal and also start another export.

There are following information about running export:

  • short indication that export has started: 
  • running dot in menu Export 
  • in the menu Export you can see progress of the lately started export
     
  • you can download latest Export from the menu when it is ready and/or in the menu Show all Exports
  • there is list of all exports you have run within last 7 days including information about progress
  • by double click on the export line you can download and open any ready export, even repeatedly.

Exported Excel

Exported excel is very simple data oriented excel where in multiline header are selected fields names and in the data below the header are values. Values are rounded to 2 significant digits, same as in the Portal. There is no divider between Compound and each Assay, you should found it be the header.


  • No labels