Fert Calculator V1.8 - AIO, TPN, Solufeed TEC, improved compare/clone Plus Help File

Zeus.

Member
Joined
1 Oct 2016
Messages
3,013
Location
Yorkshire,UK
Hi Folks

I was recently asked by a UKAPS member for my fert dosing I had on an Excel spreadsheet :eek: was my initial reaction. But in the spirit of UKAPS ie friendly and helpful, and help others as others have help you. I went about tidying my spreadsheet up and a bit of chaos to something some else could use.

In the process I discovered an error on my spreadsheet which had my tanks not getting enough Mg. Which is one of the small issues with Rotala Butterfly and other calculators, is that you have to input all your data each time choose your salt or make adjustments get the ppms then choose another salt rinse repeat add them all up :bored::bored:. So plenty of room for human error. Having a Calculator which does it all and adds up all the ppm makes some sense IMO.

Then thought lets add the elements in the tap water, work out the GH of the tap water, Lets see the 'ratios of out fert mix', lets compare our results/ppms with fert regimes and commercial products. What are the Dry dosing weights- Think you get the picture.

Not trying to re-invent the wheel - akin to adding headlight auto dip, self activating wipers,cruise control, park assist and pro pilot. The wheels still spin the same but there's a better driving experience ;)

Version V1.9 coming soon

@Hanuman is on the development team and the 'Barr Team' who made Rotala Butterfly have also asked if they can help the team :D
1589994839402.png
1589994890681.png





Lots of changes and made more mobile friendly - still Beta

Its feed back I am after even its just to inform me some regime isn't correct or complete, or the ppms don't match you working out, does the calculation I have on a commercial product not match your calculations. Even if you don't use it your input could help others with the whole DIY ferts dosing regime without the headache of multiple searches etc.

If you don't have Excel on your PC you can get Excel Viewer for free.

I'm not an Excel power user so be kind :angelic:

Download Fert Calculator Beta V1.8 -
the downloads are straight from my NAS so virus/AD free ;) the latest download is via the same link

Comparisons

It can be tricky as manufacturers try to hide what they actually contain by supplying the analysis in format most folk dont understand - its an age old trick

So therefore I (we) have to make some assumptions to be able to compare the products

eg.

Manufacturer quotes Nitrogen as Urea so 'CO(NH2)2', so

upload_2020-3-1_17-25-21.png


Therefore 100g of urea has 46.64grams of Nitrogen (N)

Will will assume all this 'N' gets converted by the bacteria in your tank to NO3 ions

upload_2020-3-1_17-31-50.png


So 46.64g N. / 22.59% x100 = 206.5 grams NO3

Therefore if 1.0 litre of product 'X' has 1.0% urea as Nitrogen by mass and a dose regime say 2ml per 50Litre tank

So 1.0L has mass of 1000g so in there is 10.0g of Urea or 4.664g of Nitrogen or (once the bacteria in your tank has converted it 20.65g of NO3 so 20.65g/litre NO3 or 20650mglL NO3

So product 'X' has 20.65mg per 1.0ml

Dose 2ml per 50l then 20.65mg x 2ml / 50litres = 0.826mg/L NO3 or 0.83 ppm NO3 for comparison.

Hope my explanation make sense, maths are correct and assumptions correct.

I sure @dw1305 will correct me if i'm wrong :angelic:
------------------------------------------------------------------------------------------------------------------------------------

I have never seen this as 'my' program, as its build on the ideas/posts/requests of users on the forums and Rolatala and Zorfoxs calculators was the go to reference points. Its for the users and made by the users and its free for everybody to use, the 'end goal' is to have a user friendly app/program you can use on any PC/Mac/mobile device to do your fert calculations 'ad free' without the need for any calculations.

Then base on the principles of 'Good Science' that's 'Accurate' , 'Peer Reviewed', 'Open', 'Honest' and 'Free'

Any one contributing to the development of this app/program does so freely and does not expect to gain any monies or gifts from it -Any 'Kudos' gained is paymant in full

Its is used at your own risks and should not be used for personal profit or gain

Cheers.

Zeus.
 

Attachments

Last edited:
Joined
20 Jul 2018
Messages
324
Location
Netherlands
Hmm just filled in the macros and I got some crazy amounts compared to what I had calculated before with the butterfly site.. I will check again later on if I didn't do something wrong..
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,013
Location
Yorkshire,UK
Comparisons for -
CSM+B
SeaChem Flourish

Added

Hmm just filled in the macros and I got some crazy amounts compared to what I had calculated before with the butterfly site.. I will check again later on if I didn't do something wrong..
:angelic: If you can take a screen shot or use snipping tool and post or pm it m8
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,013
Location
Yorkshire,UK
Hey @Zeus. regarding the feedback, section with water re-mineralisation to desired hardness will be very useful.
Thats one of the things I was planning already and it does it to some extent with the MgSO4.7H20 which is added

upload_2020-2-29_22-31-15.png


But if you let me know which GH booster (with a link your using) I will add the Compound so it will do the maths and add the relevent ppms and the GH Boost ;) the grunt work is done so adding more shouldnt be take long.

Edit -Was also planning an RO and Tap water mix and resulting GH
 
Last edited:
Joined
20 Jul 2018
Messages
324
Location
Netherlands
It seems that I filled out the wrong dosing make up of my micro mix so not so strange that it didn't made sense. Now it is filled in correctly, only thing that does not work for me is that I dry dose my Mg..

upload_2020-3-1_8-17-17.png


Just for comparison this is mine calculated with rotala butterffly.

upload_2020-3-1_8-15-34.png
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,013
Location
Yorkshire,UK
Hehe I just ordered 5kg buckets of KNO3, K2SO4 and 1kg of KH2PO4 for about 60 euro last week.. This will last me a while (lifetime?:) and just cost nothing compared to premade mixes.

Well if folks spend less on ferts for the same fert regime they an pocket the money or get so more scaping gear :lol:

The DIY fert route can be a bit daunting at first (it was for me), if 'we' can help the folk new to the hobby make transition to DIY ferts easier then that good IMO.
 

papa_c

Member
Joined
22 Jan 2013
Messages
255
Hey Zeus,

Interesting spreadsheet, not sure if it is my mistake but based on the calculations I get from rotala butterfly your ppm dose/weekly for NO3 and PO4 seem massively different. Rotala gives me a 30 and 12 ppm weekly dose respectively and your sheet gives 120 and 48 for the same dose. Both a factor of 4 different.
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,013
Location
Yorkshire,UK
Am I doing something wrong it is saying I need to add 300gr of MGSO4 get 9.6ppm
I get from rotala butterfly your ppm dose/weekly for NO3 and PO4 seem massively different. Rotala gives me a 30 and 12 ppm weekly dose respectively and your sheet gives 120 and 48 for the same dose. Both a factor of 4 different.
If you can both post a screen shot of the calculator showing all the input data and results -then I can see where the problem/error is ;)

Big thanks guys for trying it out :clap::clap::thumbup:
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,013
Location
Yorkshire,UK
Big help - found error and sorted it :thumbup: ( with my tank, volumes and salts it was right, your it was way off :oops:, sorted the error in formula and now mine data is unchanged,but yours is correct :D)

upload_2020-3-1_15-26-37.png


Am I doing something wrong it is saying I need to add 300gr of MGSO4 get 9.6ppm
Hard to say without the tank details entered as well - but probably same issue as 'papa'

Update uploaded

Thanks again Guys :clap:
 
Top