Using Google Gemini to log parameters

[Lizardking]

Hi all, what are everyones thoughts or experiences on using Gemini/chatgpt for logging aquarium parameters.

I'm not interested in having the LLM advise on dosages or what changes I should make but rather log the parameters and whether or not those parameters are within an acceptable range and historical numbers from previous readings.

I've attached my most recent results as an example.

 

[kboogie]

Is you are not using the LLM for recommendations then is there any reason you would not use a simple spreadsheet?

 

[bobbravo2]

My biggest worry would be context rot/hallucinations.

These tools are great for synthesis and analysis when constrained, but can drift over time, or “be lazy” by not having perfect recall.

Context: work in AI. Part of these systems is fragmented: memory vs the LLMs context window. Memory is usually a vector database, where strings and numbers are “chunked” into a multi dimensional space. When you ask a question about a value, you’re relying on the LLM -> talk to the memory system and find the correct values. The likelihood of it missing something becomes higher over time.

I’d plus one that a simple spreadsheet with some “conditional formatting” is a much more trustworthy and reliable solution.

Ps: I have an open source google sheet I’ve used for 10+ years here:
Look at the [TEMPLATE] chemistry section.

 

[Gumbies R Us]

I am a fan of either using a basic spreadsheet/notes app or using one of the many apps out there to log your parameters

What do you use to keep logs and records of your testing?

I'm curious what you all use for long term logging of test results and reef notes. For the last 4 years or so I found a custom made spread sheet that I've been using in Excel and that works pretty well. Sometimes I wonder if there is a more elegant solution. I have no issues with my spreadsheet...

www.reef2reef.com

 

[Isaac Alves]

I believe you can use Gemini within Google Sheets to basically log your parameters and do things like charting and doing other analysis.

This way you are solely referencing the data from the spreadsheet and adding directly to it dynamically.

You might even be able to write an Opal or your own vibe coded app to add data to the sheet.

Here’s some intro information:

https://support.google.com/docs/answer/14218565?hl=en