Feedback on Reef Chemistry Spreadsheet

BRS

kjellwr4

New Member
View Badges
Joined
Jul 30, 2021
Messages
5
Reaction score
0
Review score
+0 /0 /-0
Location
Charlottesville
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.
 
Click to watch best scape method in 5 easy steps!

revhtree

Owner Administrator
View Badges
Joined
May 8, 2006
Messages
43,524
Reaction score
67,904
Review score
+1 /0 /-0
I would also is the ability to track when you installed new RO/DI filters or changed out media etc..
 

Spieg

Valuable Member
View Badges
Joined
Jan 12, 2020
Messages
1,100
Reaction score
1,087
Review score
+0 /0 /-0
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).
Screenshot 2021-07-31 043113.png
 
Avast
OP
kjellwr4

kjellwr4

New Member
View Badges
Joined
Jul 30, 2021
Messages
5
Reaction score
0
Review score
+0 /0 /-0
Location
Charlottesville
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).
Screenshot 2021-07-31 043113.png
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.
 
Zoanthids

dbowman5

Valuable Member
View Badges
Joined
Feb 19, 2020
Messages
1,944
Reaction score
8,878
Review score
+0 /0 /-0
Location
Dayton, Ohio
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...
 
OP
kjellwr4

kjellwr4

New Member
View Badges
Joined
Jul 30, 2021
Messages
5
Reaction score
0
Review score
+0 /0 /-0
Location
Charlottesville
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.
 
BRS

Do you house a "Reef Safe" Angelfish in your reef tank?

  • YES and it's going good

    Votes: 180 41.1%
  • YES but it's not working out

    Votes: 12 2.7%
  • NO I have tried it in the past and it didn't work out

    Votes: 38 8.7%
  • NO I haven't tried yet

    Votes: 193 44.1%
  • Other (please explain)

    Votes: 15 3.4%
Inkbird
Top