Feedback on Reef Chemistry Spreadsheet

[kjellwr4]

I made the spreadsheet below as a database/log for when I test my new aquarium or events happen. What am I missing? What else would you include? Is there something better? Thanks for any feedback.

50G Cube Aquarium Log

Also, I know that there are #VALUE! errors in the date column. The timestamp column autofills columns B and C with the =now() function which I have not filled in.

 

[vetteguy53081]

Looks clean

 

[revhtree]

I would also is the ability to track when you installed new RO/DI filters or changed out media etc..

 

[kjellwr4]

I would also is the ability to track when you installed new RO/DI filters or changed out media etc..

Great call.

 

[Spieg]

Looks similar to a spreadsheet I use. I also added conditional formatting to color the cells to show if values are in acceptable range (green is good, yellow is a little off, red requires action).

 

[MikeTheNewbie]

Be careful, reefing logs are addictive :P

This is how I started 9 months ago

And this is how it looks now

 

[kjellwr4]

Looks similar to a spreadsheet I use. I also added conditional formatting to color the cells to show if values are in acceptable range (green is good, yellow is a little off, red requires action).

Cool. Do you find it more useful to have a column for "action after test?" I have a notes area, but I was of the mindset that I would put info about pre-H2Otest changes. I like your approach.

I will definitely add some conditional formatting. Good call.

 

[kjellwr4]

Be careful, reefing logs are addictive :p

This is how I started 9 months ago

And this is how it looks now

Whoa. Did you make all of the graphs in Excel/Google Sheets? This looks more like a web-based dashboard. Maybe I am wrong. It is slick!

 

[ying yang]

Temp

 

[MikeTheNewbie]

I started with Excel but the time charts don't work great for metrics with different durations between samples.
You're right it is a locally hosted time series database (influxdb) and a web-based dashboard (grafana). See more info here.
https://www.reef2reef.com/threads/grafana-apex.842704/

 

[dbowman5]

I would move the nitrite, ammonia columns to the right, (they wont be used much after cycle). i use the comment column to track WC's, livestock additions/losses, equipment changes, will you use the event column for that?. I have a separate spreadsheet to track expenses including start up.
my FW hobby has been active since march of '18 with a running daly average cost of $2/day, My SW has been active since August of '19 with a $10 daily cost. I realize that over time it is less expensive to do this! Last year it was $12.86/day in a few years it will be free? sure...

 

[kjellwr4]

I would move the nitrite, ammonia columns to the right, (they wont be used much after cycle). i use the comment column to track WC's, livestock additions/losses, equipment changes, will you use the event column for that?. I have a separate spreadsheet to track expenses including start up.
my FW hobby has been active since march of '18 with a running daly average cost of $2/day, My SW has been active since August of '19 with a $10 daily cost. I realize that over time it is less expensive to do this! Last year it was $12.86/day in a few years it will be free? sure...

You are right. I will move the nitrite and ammonia columns to the right. Yes, I plan to use the event drop-down to track major changes. I decided to standardize it so that I can run separate pivot tables if I need to do so for things like fish additions, losses, and equipment changes.

I am a bit scared to put in prices because I am already shelling out crazy amounts! However, it is a good idea. Maybe I will go with a separate sheet. I can't envision how to put money in with all of the testing info.

 

[KMCA]

Looks similar to a spreadsheet I use. I also added conditional formatting to color the cells to show if values are in acceptable range (green is good, yellow is a little off, red requires action).

I don't suppose it's on Gdocs so I can rip a copy?