Measurements

Your BactoBox® measurements presented as a spreadsheet

View, filter, edit, group, print, export all program executions on your BactoBox®. All through a familiar spreadsheet interface.

Navigate to the Measurements page and view the latest program executions.

Rows

There is one row for each program (Measure, Empty, Clean, etc.) started on your BactoBox®. We refer to a started program as a program execution or just execution in short.

We sort the executions by the Started at column. The newest row comes first.

Usable and unusable executions

We show unusable executions in faded grey colors (see the figure below).

Example program executions from the Measurements page. The top execution is unusable due to the error. The other two executions are usable.

An execution is unusable if any of these conditions apply:

• The execution resulted in an error message. E.g., "Error 3000: Too many particles".

• The execution was stopped. E.g., the user pressed Stop.

• The execution failed. E.g., due to a system error.

• The execution was abandoned. E.g., due to a sudden power off.

• The execution was excluded by the user. E.g., via a press of the button.

Otherwise, the execution is usable.

We ignore unusable executions in, e.g., analytics, plotting, reporting, etc.

Made a mistake? Mark the program as excluded

Press the button to exclude the execution. This excludes the execution from analytics, plotting, and reporting.

Examples: You measured the wrong vial. You used the wrong dilution. You forgot to disaggregate.

Change cells

Change individual cells just like you would do in a spreadsheet. Click inside the cell and start typing. When you are done, press Enter or click another cell.

Press the Save button to commit your changes

Alternatively, press the Discard button to explicitly revert (undo) the unsaved changes.

We intentionally opt for manual-save over auto-save wherever possible. Manual-save both avoids accidental edits and offers transactional semantics. Both are important features in cGMP.

Use this to, e.g., add a Label or Dilution to an execution. The list of columns below goes into more detail about each individual column and its purpose.

Click the Label field. Type in your text. Click another field (or press Enter). Finally, press Save to commit your changes.

Unsaved changes

Rows with unsaved (pending) changes have:

• A thick, blue border to the left

• A faded, blue background

Moreover, the changed cells have a blue triangle in the upper right corner.

The second row (ID K57) has unsaved changes. We changed the Sampled at column and cleared the Label column. Note the thick blue border to the left and the faded blue background. Likewise, the two changed cells have a blue triangle in the upper right corner.

Columns

There are many columns, so we split them into column groups. See below for details about each

Individual

Columns that are individual to each execution.

Column name	Example	Description
N/A		Press to exclude this execution. Excluded executions are unusable. Button.
Status	Error 1200	If this execution is unusable, this column shows why. Read only.
Program	Measure	The name of the program. Read only.
Started at	2025-12-19 11:13	When you started the execution. E.g., when you pressed Measure. Read only.
Sampled at	2025-12-19 09:15	When you grabbed the sample from, e.g., the bioreactor. Used as the x-axis in various auto-generated plots. Date and time field.
ID	A01	Mnemonic measurement ID. Read only.
Label	E. coli	Can be any of species name, bioreactor name, experiment name, etc. Used as to group measurements in various auto-generated plots. Text field.
Cells/mL	3 800 000	Cell concentration of the diluted sample. Read only.
Total/mL	3 830 000	Total concentration of the diluted sample. Read only.
Dilution	1001	Dilution used in the sample vial. Non-negative integer field.
Cells/mL × Dil.	1.90e+9	Cell concentration of the undiluted (original) sample. Computed from Cells/mL and Dilution. Read only.
Total/mL × Dil.	1.92e+9	Total concentration of the undiluted (original) sample. Computed from Total/mL and Dilution. Read only.
CFU/mL × Dil.	1.88e+9	CFU concentration of the undiluted (original) sample. Determined through, e.g., plate counting. Used in, e.g., the correlation plots. Number field.
Measurement group	rc-01 test	Name of the measurement group that this execution belongs to (if any). Used as basis for analytics, plotting, and reporting. Options field.

Group

Columns shared between all executions in the same measurement group.

Column name	Example	Description
Created at	last Wednesday at 04:57	When the measurement group was created. Read only.

Additional information

Columns that are individual to each execution but used less often.

Column name	Example	Description
Software	2026.01	Software version used during this execution. Read only.
Flow cell	2F5A1I4T	ID of the flow cell used during this execution. Read only.
Conductivity	1750 µS/cm	Electrical conductivity of the sample vial. Read only.
Classification	BacTotal_v2024-10	The gating settings (CRS file) used for this execution. Read only.

Filter columns

Several columns has a filter function. Use these filters to narrow down the entries in the table.

Filter by text

Type into the Filter field just below the column header. The filter applies instantly as you type it out. All text filters are case insensitive (as shown below).

Filter executions by the Program column. The filter applies instantly as you type it out. Note that the filter is case insensitive.

Filter by date range

Choose either a From date, a To date, or both. This narrows in executions to the chosen range.

Choose a date range to narrow in the executions.

Export CSV file

Press the Export CSV button to download a CSV file of the current view. By current view, we mean the filtered executions. Clear the filters to export all executions.

Press the Export CSV to download a CSV file. Open the CSV file in your spreadsheet editor of choice. E.g., Microsoft Excel as shown in this quick clip.

Exported columns

The CSV file contains most columns mentioned above. We exclude action-only columns such as the column with the exclude button.

For some columns, the CSV file transforms the value first. Here are some examples of this:

Column type	Value in Access	Value in CSV file
Date and time E.g., Started at, Sampled at, Created at.	last Wednesday at 4:57 PM Human-friendly format relative to current local time.	2026-01-07 16:57:50 Machine-friendly format compatible with Microsoft Excel.
Numbers E.g., Cells/mL × Dil..	3.10e+5 Scientific notation	310000 Decimal notation
Numbers with units E.g., Conductivity.	1750 µS/cm Number with unit	1750 Number without unit

The value transformations used in the CSV file are still subject to change! A software update may change the value transformation.

Difference to the summary.csv file

At a first glance, the summary.csv file may seem identical to the CSV file mentioned above. However, there are some key differences:

What	summary.csv	Exported CSV file
Software version	Since 1.0.3 (released 2020-08-17).	Since 2026.01 (released 2026-01-13).
Columns	Basic info. See summary.csv columns.	Advanced info. See above.
Rows	Long form: Everything. Short form: Max 200 rows.	Current filter settings.
Value transform	Yes, for compatibility with Microsoft Excel.	Yes, for compatibility with Microsoft Excel.