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

Selecting Compounds

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

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

...

• By pressing button Start Export selected and cart compounds
  Image RemovedImage Added
  currently selected compounds are added to the cart and Export window appears:
  Image Modified
• you You can set export name you export for easier finding if you start more exportsfor each export. Name is only used in Portal and is not part of the exported Excel.
• you 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 Some fields are preselected by default. Here There you can add more fields for the exportchange selection of export fields. 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.

Image Modified 

• Note: you have to create valid selection. E.g. if you deselect Cell Line in above example then export will not startThat means you have to select at least one item from each subcategory: Cell Line, Concentration and Data.
• Note: currently there is not possibility to save selection of export 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 working with Portal and also start another export.

There are is following information about running export:

• short Short indication that export has started:
   Image RemovedImage Added
  
  
• running Running dot in menu Export Image Removed
  Image AddedImage Added
  
  
• in In the menu Export you can see progress of the lately last started export
   Image RemovedImage Added
  
  
• you You can download latest last Export from the menu when it is ready and/or in the menu . Or you can open dialog with all exports via menu item Show all Exports.
  Image RemovedImage Added
  
  
• there There is list of all exports you have run within last 7 days including information about progress
  Image Modified
  
  
• by double Double click on the export line you can will download and open any export with status ready export, even repeatedly.
  Image Modified

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 from the Portal.

 Values Values are rounded to 2 significant digits, same as in the Portal. There is no divider between Compound and each Assay, you should could found it be by the header.