Calculator of fertilizing routine + water change - The Planted Tank Forum
 
LinkBack Thread Tools Display Modes
post #1 of 1 (permalink) Old 12-26-2017, 10:39 PM Thread Starter
Algae Grower
 
PTrader: (0/0%)
Join Date: Nov 2017
Posts: 39
Calculator of fertilizing routine + water change

I know there are multiple online tools for calculation of fertilizing routines, but I have always been missing a more complex calculation involving multiple solutions, water change and mineralization of water. Because of that, I created my own excel calculator which can do multiple things. I decided to translate it to English, perhaps it will be useful to somebody.

The calculator will not tell you what fertilizer to use and how much of it, that’s all up to you. It will provide you with a neat overview of total macros and micros added to the tank on weekly basis (and daily). The calculator considers the volume of the tank, water change and its frequency, content of RO water in the changed water, one-time remineralization of the water, customizable concentrations and frequency of the fertilization using common and less common compounds. The table uses a weekly (7 day) cycle and maximum water change frequency of 14 days. Of course, it cannot cover the needs of every single person, but I dare to say it solves most of the issues.

Comments on the functions

The green cells are the input; the red cells represent the results of fertilization.
1. Volume of the tank a calculated net volume (75% of the given volume) of the tank.
2. The volume and frequency of water change, proportion of RO water in the exchanged water volume. The calculations assume the RO water is absolutely pure and does not contain anything.
3. Remineralization of the exchanged water. Useful especially in the case your tap water does not contain enough calcium, magnesium (my case) or potassium.
4. The parameters of the tap water. In case of unknown values, use 0 or ?.
5. Fertilization using macro elements. The stock solution represents the weighted amount of the compound dissolved in the given volume of the water. Dosing per week represents the volume of one dose and frequency of the dosing per week (7 days).
6. Fertilization using micro elements. The stock solution represents the weighted amount of the compound dissolved in the given volume of the water. Dosing per week represents the volume of one dose and frequency of the dosing per week (7 days). The calculator contains the four most used commercial micro mixtures (Tenso Cocktail, CSM, CSM+B a MicroMix), several common iron chelates and salts of transition metals in case of chelate-free fertilization.
7. The results of the fertilizing routine given as the average daily and total weekly doses in mg/l. The increase of water hardness and alkalinity represents potential increase per week, however it does not consider water changes and the uptake by plants (can’t really estimate that).
Excel file for download (do not use GoogleDocs to edit): https://drive.google.com/open?id=1Hc...liTzBQTGWaYnmv
P.S. The figure is from the original, Slovak version, but the components correspond to the English version.
Attached Thumbnails
Click image for larger version

Name:	1702_1.jpg
Views:	37
Size:	131.4 KB
ID:	813858  

acino is offline  
Reply

Tags
None

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the The Planted Tank Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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 On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome