| # | Label | Timestamp | Value | A |
|---|
| Timestamp | Elapsed (s) | Value | Label |
|---|
| Parameter | Set to | Latest reported | Status |
|---|
How it works
Set, <name>, <value> on the serial link.
Any incoming line of the form Gain: 16x, Gain = 16,
Set, Gain, 16x, Report, Gain, 16x
— or a CSV row under a header carrying that column — updates
“Latest reported”, and the status tag says whether the device confirmed the value you chose.Read me
Serial Data Logging App
Reads a sensor over USB and saves the numbers as .csv files for Excel. For the
spectrophotometer it also works out absorbance / OD, calibration curves and growth curves.
Start
Choose in Settings › What are you measuring? The choice shows as a tag at the top of the page.
Connect the spectrophotometer by USB.
Click the USB button (top right). Pick the port the first time.
Number stuck at its maximum: lower the gain (Settings). Very small: raise it.
Measure
Medium, or water with reagents. No cells, no sugar.
Wait for the green ● Steady tag (last 8 s within 1 %).
Set blank from current reading in the Blank box. That value is I0.
Each standard or sample: wait for Steady, type a label, press Save.
Absorbance
- the gain changed since the blank;
- the blank is over 30 min old (the light may drift);
- a sample reads higher than the blank (A < 0: wrong blank, bubbles, or a smudged cuvette).
Tabs
| Analysis | You enter | You get |
|---|---|---|
| Calibration curve DNS assay | Each standard's concentration; samples' dilution | C = k × A through the origin (as Excel LINEST(C, A, FALSE)), k, R², each sample's concentration |
| Growth curve OD600 | Dilution; untick lag or stationary points | OD × dilution against time, growth rate μ, doubling time |
| Time series any .csv | X and Y columns | Summary statistics, linear fit, moving average |
Files
| File | Made by | Columns |
|---|---|---|
| Saved points | Save (written straight away) | n, label, time, reading, blank I0, A / OD |
| Recording | ● Record (top right), every 2 s | time, reading, blank I0, A / OD, label |
| Analysis table | Download table (Analysis) | the table and the fit, for your report |
Computers & phones
Problems
| What you see | What to do |
|---|---|
| The port won't open | Close other tabs, the Arduino serial monitor or any program using it; try again. |
| No number appears | Open Console to check lines arrive; check Settings shows the right measurement. |
| A / OD switch greyed out | Set a blank first (Blank box on Reading). |
| Saved points not in a file | Use Download next to the saved points. |
Feedback
Found a problem, or have an idea? Tell us on GitHub (free account). The link fills in your browser and settings. No account? Tell your lab instructor or TA.