108 lines
3.2 KiB
Markdown
108 lines
3.2 KiB
Markdown
---
|
||
pageType: source
|
||
id: source.psb-gemma-tilt-spreadsheet-protocol
|
||
title: psb-gemma-tilt-spreadsheet-protocol
|
||
sourceType: local-file
|
||
sourcePath: /home/topher/.openclaw/workspace-psb-gemma/memory/tilt-spreadsheet-protocol.md
|
||
ingestedAt: 2026-05-03T01:25:38.420Z
|
||
updatedAt: 2026-05-03T01:25:38.420Z
|
||
status: active
|
||
---
|
||
|
||
# psb-gemma-tilt-spreadsheet-protocol
|
||
|
||
## Source
|
||
- Type: `local-file`
|
||
- Path: `/home/topher/.openclaw/workspace-psb-gemma/memory/tilt-spreadsheet-protocol.md`
|
||
- Bytes: 2576
|
||
- Updated: 2026-05-03T01:25:38.420Z
|
||
|
||
## Content
|
||
````text
|
||
# TILT Spreadsheet Entry Protocol
|
||
_Created: 2026-04-16 — learned through trial and error_
|
||
|
||
---
|
||
|
||
## Spreadsheet Structure (all TILT spreadsheets follow this pattern)
|
||
|
||
Each TILT spreadsheet in Google Drive has two tabs:
|
||
- **"Data"** — actual readings (columns below)
|
||
- **"Report"** — charts/config, NOT where readings go
|
||
|
||
### Data Tab Columns
|
||
| Col | Header | Example |
|
||
|-----|--------|---------|
|
||
| A | Timestamp | 4/16/2026 14:41:00 |
|
||
| B | Timepoint | 04/16/2026 14:41:00 |
|
||
| C | SG | 1.022 |
|
||
| D | Temp | 68.4 |
|
||
| E | Color | Orange |
|
||
| F | Beer | Seltzer Base-4/26 |
|
||
| G | Comment | (optional) |
|
||
|
||
---
|
||
|
||
## Critical Bug
|
||
|
||
**Use lowercase `data!` in range — NOT `Data!`**
|
||
|
||
GOG has a bug where `Data!A1` routes to the Report tab, but `data!A1` correctly targets the Data tab.
|
||
|
||
❌ `gog sheets update "ID" "Data!A199" "value"` → writes to Report tab
|
||
✅ `gog sheets update "ID" "data!A199" "value"` → writes to Data tab
|
||
|
||
---
|
||
|
||
## When You Need to Add a Reading
|
||
|
||
Use the **tilt-logger skill**: `skills/tilt-logger/SKILL.md`
|
||
|
||
Just say: "Update [beer name] — SG 1.022, temp 68.4°F" and it'll find the right sheet, add the reading, handle conversions, and insert rows if needed.
|
||
|
||
```bash
|
||
# Example: adding row 199
|
||
gog sheets update "SPREADSHEET_ID" "data!A199" "4/16/2026 14:41:00"
|
||
gog sheets update "SPREADSHEET_ID" "data!B199" "04/16/2026 14:41:00"
|
||
gog sheets update "SPREADSHEET_ID" "data!C199" "1.022"
|
||
gog sheets update "SPREADSHEET_ID" "data!D199" "68.4"
|
||
gog sheets update "SPREADSHEET_ID" "data!E199" "Orange"
|
||
gog sheets update "SPREADSHEET_ID" "data!F199" "Seltzer Base-4/26"
|
||
```
|
||
|
||
4. Verify with: `gog sheets get "ID" "data!A{last-3}:J{last+3}" --plain`
|
||
|
||
---
|
||
|
||
## Active TILT Spreadsheets (updated 2026-04-21)
|
||
|
||
| Beer | TILT Color | Spreadsheet ID |
|
||
|------|------------|----------------|
|
||
| Adams-CiderAle - 4-26 | Black | `1VEvXzzl7ejjYBGWxreHjGOOsfgPpdw-PlXByWIDqD_A` |
|
||
| Seltzer Base-4/26 | Orange | `14tnc31TTteTswzfGlIdjm5u8WSKOzs7HfQazzzZe-g8` |
|
||
| 70megOhm | Pink | `1S8uSN_KeJXv6chtYVYJCXkGZq_d47l5WCXoThPwbLss` |
|
||
| HotForTeacher-4-26 | Green | `1Y87yeo6SkxQVBotWq4xLIXLVJGYAVh1pZ9rAQa9EtQY` |
|
||
|
||
**Archived:** Mount Vernon Molasses (kegged 4/19) — `1QUAfig7zlvvRAMm45e4NYh-syAyiRfOWC4OCFse3qdM`
|
||
|
||
---
|
||
|
||
## Manual Reading Workflow (when TILT is down)
|
||
|
||
1. Get reading from physical TILT or estimated
|
||
2. Convert if needed: °Brix/Plato → SG: `SG = 1 + P / (258.6 - 0.8796 × P)`
|
||
3. Convert °C → °F: `°F = °C × 9/5 + 32`
|
||
4. Add to correct spreadsheet's Data tab using protocol above
|
||
5. Check if TILT is actually down (gap in recent readings = dropouts)
|
||
|
||
````
|
||
|
||
## Notes
|
||
<!-- openclaw:human:start -->
|
||
<!-- openclaw:human:end -->
|
||
|
||
## Related
|
||
<!-- openclaw:wiki:related:start -->
|
||
- No related pages yet.
|
||
<!-- openclaw:wiki:related:end -->
|