Go Back   Aquarium Advice - Aquarium Forum Community > Freshwater > Freshwater & Brackish - General Discussion
Click Here to Login

Join Aquarium Advice Today
Reply
 
Thread Tools Search this Thread Display Modes
Please support our sponsors and let them know you heard about them on AquariumAdvice.com
 
Old 05-28-2017, 01:40 AM   #1
Aquarium Advice Activist
 
jc102's Avatar
 
Join Date: Feb 2017
Location: Trumann, Arkansas
Posts: 138
Creating a water test log

Hey guys,

I have been keeping up with 3 new aquariums and doing frequent water testing and water changes. I finally decided to make a spreadsheet log to help me keep up with it and track everything.

I have been learning a lot, but there is still a lot that I don't know. I usually do my water changes weekly or if the water gets too cloudy. Based off of the water chemistry alone, when would you advise someone to do a water change? This will be for a cycled tank.

I am wanting to make a function that prints (Water Change Recommended) when the (e.g. nitrates) are too high. I believe the recommended level is between 10 and 40ppm? So if I am correct, anything over 40 would require a water change, right?

I know that this is overkill, but I am trying to teach two kids how to care for an aquarium. I think the visuals will help them better understand what is going on.

Here is a screenshot of my spreadsheet so far. Any advice/recommendations is also appreciated! I can post it up for download once it is done.

__________________

__________________
jc102 is offline   Reply With Quote
Old 05-28-2017, 03:33 AM   #2
Aquarium Advice Addict
Community Moderator
 
Autumnsky's Avatar



POTM Champion
Tank of the Month Award
 
Join Date: Apr 2012
Location: Northern Colorado, USA
Posts: 12,901
This is a good idea as visuals will speak as loud as the numbers. Better for those who are visual learners.

It is hard for me to see all the small detail. But if I understand, the change in color will help see when a water change is needed???
__________________

__________________

New to FW fish? First tank in a long time or EVER??? Need some info on keeping fish?
Start here - Aquarium Advice Article
https://www.aquariumadvice.com/guide...ater-aquarium/

Community Rules
https://www.aquariumadvice.com/forum...ork&page=rules

FW & SW
Favorite tank right now -5G Spec V Snails & Betta
Autumnsky is offline   Reply With Quote
Old 05-28-2017, 08:31 AM   #3
Aquarium Advice Addict
 
toolman's Avatar
 
Join Date: Mar 2017
Location: Indiana
Posts: 1,275
Very nice, good teaching method for your little ones.
__________________
toolman is offline   Reply With Quote
Old 05-28-2017, 08:54 AM   #4
Aquarium Advice Freak
 
Join Date: Apr 2017
Location: Port Richey, FL
Posts: 206
What a great idea.
__________________
Sharmon is offline   Reply With Quote
Old 05-28-2017, 11:30 AM   #5
Aquarium Advice Activist
 
TeenyFish's Avatar
 
Join Date: Apr 2017
Location: London, UK
Posts: 110
I love how you can see the cycle happening

I would do a water change anywhere over 20ppm nitrAte. If it gets to 40 in a one-off situation it won't hurt, but to be that high over a prolonged period of time would be stressful.

This is a great idea
__________________
TeenyFish is offline   Reply With Quote
Old 05-28-2017, 03:10 PM   #6
Aquarium Advice Activist
 
jc102's Avatar
 
Join Date: Feb 2017
Location: Trumann, Arkansas
Posts: 138
Thanks guys! I spent more time working on it last night. I was aiming at making it a guide for the kids. So in the "Water Change?" column I changed that to "Recommendation" and now based off of your water parameters it will either recommend you do nothing, a water change, or daily dose with Prime (since that's what we use).

Here are the rules and a new screenshot. This is for the kids, so an experienced fishkeeper wouldn't need (and might not want) the recommendations. So I will have 2 spreadsheets, one for new fishkeepers and one for experienced ones.

It tells you the next time you should test the water. I set it for 7 days if the tank is cycled and everything looks good. 2 days if you are daily dosing with prime. What do you think about the timeframe?

For example, if I add a row on June 1, 2017 and the Ammonia is 4ppm, it will suggest to daily dose with Prime and add a new row with a date of June 3, 2017 automatically. If everything is fine on June 3, it will add a new row with a date of June 10, 2017. If more than a week has passed since your last entry, it will automatically recommend a water change.

Here is the notes section of the spreadsheet in case you can't read it from the screenshot:
Measured in PPM
If more than 7 days have passed since your last entry, a water change will be recommended.
If Nitrate is 20ppm or higher, a water change will be recommended.
If Ammonia or Nitrite is greater than 0.50ppm, a daily dose of prime will be recommended.
If a water change is recommended, the suggested next test date is in 7 days.
If a daily dose of prime is recommended, the suggested next test date is in 2 days.
Dates can be overridden, but when you type you will not see the text appear in the cell. View the function bar at the top.
A blank field under action indicates no action should be taken. Your next test date should be within 7 days.

It can be improved so any suggestions are welcome! The formulas were tricky but I think I have worked out the kinks.

__________________
jc102 is offline   Reply With Quote
Old 05-28-2017, 03:13 PM   #7
Aquarium Advice Activist
 
jc102's Avatar
 
Join Date: Feb 2017
Location: Trumann, Arkansas
Posts: 138
Quote:
Originally Posted by Autumnsky View Post
This is a good idea as visuals will speak as loud as the numbers. Better for those who are visual learners.

It is hard for me to see all the small detail. But if I understand, the change in color will help see when a water change is needed???
Yes, that's right!
__________________
jc102 is offline   Reply With Quote
Old 05-28-2017, 03:29 PM   #8
Aquarium Advice Addict
 
toolman's Avatar
 
Join Date: Mar 2017
Location: Indiana
Posts: 1,275
Looking good, could be very helpful.
__________________
toolman is offline   Reply With Quote
Old 08-22-2017, 11:49 PM   #9
Aquarium Advice Newbie
 
Join Date: Aug 2017
Location: San Diego
Posts: 3
Hi Jc102,
My 2 daughters and myself are new to aquariums and looking to build a tank log. Did you reach a point where you are willing to share yours?

Thanks!
__________________

__________________
MacGuruTX is offline   Reply With Quote
Reply

Tags
ate, eat, eating, log, test, water

Please support our sponsors and let them know you heard about them on AquariumAdvice.com

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating the perfect planted/ Discus water with RO JackBlasto Freshwater & Brackish - Planted Tanks 4 09-23-2013 01:19 PM
Creating a 20 gallon salt water tank Ben the Betta Saltwater & Reef - Getting Started 5 06-19-2013 02:45 PM
Creating new water djones169 Saltwater & Reef - Getting Started 14 05-15-2011 09:23 PM
Log in Log out! Quartz92 Forum Admin & Announcements 2 09-02-2009 10:38 AM







» Photo Contest Winners








All times are GMT -4. The time now is 05:39 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2019, vBulletin Solutions, Inc.