User Guides / ELN

Spreadsheets

Last updated on 01-Apr-2025 by Jakob Jakobsen Boysen
Jakob Jakobsen Boysen

Platform Lead
boysen@scifeon.com
, Philip Bocayes Ørnskov
Philip Bocayes Ørnskov

Developer
ornskov@scifeon.com
On this page

The following sections describe how to use Spreadsheet in Scifeon. Spreadsheets are used to register, modify, and hold data in Scifeon.

Creating and Editing Spreadsheets

In the ELN click + Section (1) and select Spreadsheet, then after that the spreadsheet is added to the ELN.

Our Spreadsheet section works just like a very basic excel.

We support the following basic features directly from the Spreadsheet header:

  1. Undo & Redo - The option to undo and redo recent actions.
  2. Text Decorations – Size, colors, position and text formatting.
  3. Cell Styling – Merging cells and adding borders.
  4. Cell Locking – Locking and unlocking of cells to ensure they cannot be accidentally edited.
  5. Cell Validation – Rules to validate cells and clearly mark if something is wrong.
  6. Cell Typing – Change cell type to Standard, Number, Percent, or Text.
  7. Decimal Point – Easily change decimal point position.
  8. Import Excel – Import excel sheet directly into the ELN.
  9. Export Excel – Export your ELN Spreadsheet to excel or CSV.
  10. Full Screen mode – Expand the Spreadsheet to fill your whole screen.
  11. Save – The Spreadsheet section will automatically save after ~10 seconds, but you can manually save as well.

A Spreadsheet that has unsaved data in it will have a yellow line in the left side. This a general way to tell a section has unsaved data. (1)

As in a Excel you can use the standard function like AVERAGE(), SUM(), COUNT() etc. (2)

You can also have multiple sheet (3), and all sheets are connected throughout the ELN.

Inserting ELN data into Spreadsheets

It is possible to insert any data from the ELN into a Spreadsheet:

  1. Insert Entity Table - Click the "Insert Entity Table" button above the entity table.
  2. Configure table - A slide in modal will appear in the right side of the Spreadsheet.
  3. Set Table Start Cell - Select the cell from where the table should start from. You can either manually type this, or use the cell picker.
  4. Select an Entity Source - Click the "Select Entities" button.
  1. Select Entity type - Select desired type e.g Samples, Batches, Animals or Fermentations
  2. Select Step Input/Output - The step where your entities are/will be located.
  3. Save Source - Save the selected configurations.
  1. Overview of found Entities - Here a list of all found entities are shown.
  2. Select columns to show in Spreadsheet - Select the columns from your entity that you wish to appear in the Spreadsheet.
  3. Closing Table Configuration - Clicking a cell that is no part of entity table will close the slide in modal.
  4. Opening Table Configuration - Clicking a cell that is a part of a entity table will open the slide in modal with all set configurations.
  5. Deleting Table Configuration - You can delete the inserted table by using the trashcan in the bottom right corner of the slide in modal.
  6. Error Handling - If there is not enough space for your table it will appear as "#ERROR". Ensure the whole table can fit in the Spreadsheet, and won't override other data.

Extracting Results from the Spreadsheet into the ELN

You can extract Result Values from the Spreadsheet that is saved as structured data in Scifeon.

To extract results you need to create a extract result value configuration:

  1. Create a Extract Result Value configuration - Click the "Extract Result Value +" button above the entity table.
  2. Configure table - A slide in modal will appear in the right side of the Spreadsheet.
  3. Fill out relevant field - See the guide below on how to fill out configuration.
  4. See result values - When the configuration has all required information it will create Result Values that can be seen under the Spreadsheet section.
  5. Errors - If information can not be found in the table Result Values will not be created. Ensure all rows have required information for Extract config to read.
  6. Opening existing configurations - If you want to edit or delete a existing configuration, click the "Extract Result Value" button for a list of existing configurations.
  7. Deleting Extract Configuration - You can delete the Extract Result Value configuration by using the trashcan in the bottom right corner of the slide in modal.

To extract result you make configuration of what needs to be extracted. You will need to set the following information in the slide in modal:

  1. Extraction configuration name - A name to discern this configuration should you have multiple Result Values to be extracted.
  2. Start and end row - The rows where extraction of results will be considered. (If end is not static, you can set it very high)
  3. Result column - The column in the Spreadsheet where the result value is.
  4. Sample ID column - The column in the Spreadsheet where the SampleIDs are. Each Result Value must be related to a SampleID.
  5. Type column - The column in the Spreadsheet where the type of the Result Value can be found. (Direct input available)
  6. Unit column (optional) - The column where the Result Values unit is. (Direct input available)
On this page