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.
Volume of the tank a calculated net volume (75% of the given volume) of the tank.
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.
Remineralization of the exchanged water. Useful especially in the case your tap water does not contain enough calcium, magnesium (my case) or potassium.
The parameters of the tap water. In case of unknown values, use 0 or ?.
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).
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.
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.