Hawk Collective 2890

psb-gemma-tilt-spreadsheet-protocol

3 min read

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

# 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

  • No related pages yet.

Graph View

Backlinks