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 timeE.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:
button.
