Fert Calculator V1.8 - currently no download as next version on its way

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
Upcoming update

Calcium Carbonate CaCO3

With its relatively low solubility adding it to the dosing mix is a waste of time OFC, so when you have a target [CO3] and pick CaCO3 as a salt gives the amount to add as weekly dry dose to suit the water added in WC

upload_2020-5-7_17-25-57.png


Urea added as Salt with a warning in helpfile about its use OFC

upload_2020-5-7_16-46-54.png
I will have a tick box that manual has been read before it gives results for Urea salt

Cost of fert mix and Cost Comparison

I've new page where the costs of salts have been entered, which user will be able to change for the amount purchased, works out the cost per gram etc etc then gives you the cost of making your own DIY fert mix :D so for my 500l tank dosing to Clives regime
upload_2020-5-7_16-30-56.png
allow for Mg & NO3 in my tap water with WC
upload_2020-5-7_16-32-47.png

:thumbup:

Also entered the cost of commercial ferts (editable by user to allow for increases etc ) so you can compare them :eek:

upload_2020-5-7_16-35-14.png


So Cloned my own ADA Brighty N 300ml worth

upload_2020-5-7_16-39-52.png

upload_2020-5-7_16-40-27.png

upload_2020-5-7_16-41-3.png

upload_2020-5-7_16-41-41.png


Only a saving of 907%

Repeated the process for Tropica Specialised Nutrition clone
upload_2020-5-7_16-52-17.png

upload_2020-5-7_16-52-35.png

upload_2020-5-7_16-53-45.png

upload_2020-5-7_16-54-10.png

upload_2020-5-7_16-54-32.png


It doesnt have Fe EDTA but can make a 1.0litre solution of Fe EDDHA dose 6ml per week for same of yeild Fe for Tropica Specialised Nutrition
upload_2020-5-7_16-59-43.png

or maybe Fe DTPA
upload_2020-5-7_17-0-45.png


So 5.0 Litres for £3.15 not £90

Using CSM+B for traces salts for Tropica Specialised Nutrition clone
upload_2020-5-7_17-9-12.png


Obviously I haven't accounted for the cost of the water in making the ferts :rolleyes: but the 'maths' speak for themselves
 

Attachments

  • upload_2020-5-7_16-24-10.png
    upload_2020-5-7_16-24-10.png
    7.8 KB · Views: 11
  • upload_2020-5-7_16-53-26.png
    upload_2020-5-7_16-53-26.png
    7 KB · Views: 12

Hanuman

Member
Joined
4 Jan 2019
Messages
506
Location
Thailand
Noticed some errors first hand. This looks like some mix up while dragging formulas and because you are arranging chemicals in a different order in different linked sheets. I suggest you order the chemicals in the same order in the DD, HSPF, SS, DIYFert sheets and whenever you have to list the chemicals sequentially. This will save you serious headaches believe me. Here it goes:

Sheet "DD" cell F28. Formula is:
=ROUNDUP((DIYFert!G29/HSPF!$F$15*1000)/(D28/100),0)&"%"
should be:
=ROUNDUP((DIYFert!G34/HSPF!$F$15*1000)/(D28/100),0)&"%"

Sheet "DD" cell F29. Formula is:
=ROUNDUP((DIYFert!G30/HSPF!$F$15*1000)/(D29/100),0)&"%"
should be:
=ROUNDUP((DIYFert!G29/HSPF!$F$15*1000)/(D29/100),0)&"%"

Sheet "DD" cell F30. Formula is:
=ROUNDUP((DIYFert!G31/HSPF!$F$15*1000)/(D30/100),0)&"%"
should be:
=ROUNDUP((DIYFert!G30/HSPF!$F$15*1000)/(D30/100),0)&"%"

Sheet "DD" cell F31. Formula is:
=ROUNDUP((DIYFert!G32/HSPF!$F$15*1000)/(D31/100),0)&"%"
should be:
=ROUNDUP((DIYFert!G31/HSPF!$F$15*1000)/(D31/100),0)&"%"

Sheet "DD" cell F33. Formula is:
=ROUNDUP((DIYFert!G34/HSPF!$F$15*1000)/(D33/100),0)&"%"
should be:
=ROUNDUP((DIYFert!G32/HSPF!$F$15*1000)/(D33/100),0)&"%"

Alternatively you could rearrange the order of the chemical on the left of the table to match the proper solubility.

And yes I had to crack the password of the sheets to copy paste the formulas. lol - Didn't want to rewrite them.

If you need any help let me know.
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
Upcoming release
added Calcium Sulphate to boost dGH
1589284209520.png

quite easily exceeds the solubility limit for a dosing solution so tuned for weekly dosing dry salts

Custom DIY Trace mix (advance users) has been integrated with 'Headshot/Clone Wizard'so their custom DIY trace mix can be mixed with other traces mixes (or used by itself) to meet the users requirements.
1589284689516.png

Giving total yield for dose per week and integrate to do Micro and AIO solutions, with mixing instructions
1589284838119.png

JBL ProFlora Ferropol added to compare and clone list.
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
@Zeus I just have to say this is a pretty epic use of spare time. Would be awesome to have this a phone app!
It did work on phone but I tried last night and there was some issues so will be looking into that. Thanks for your very kind words. Just thought a spreadsheet we can all use (and check) makes sense, as so easy to make mistakes doing ppm calculations, as you will be well aware yourself.

Noticed some errors first hand.

🥰 excellent - I was hoping I would attract someone with better skills than me with MS software, to check my work.

This looks like some mix up while dragging formulas and because you are arranging chemicals in a different order in different linked sheets. I suggest you order the chemicals in the same order in the DD, HSPF, SS, DIYFert sheets and whenever you have to list the chemicals sequentially. This will save you serious headaches believe me.
Learning the Hard way unfortunately, but have already started using the same order in places.

will check those out you have linked, I may have already spotted the error in V1.8 and corrected it in the pre release version V1.9.


Hanuman said:
Alternatively you could rearrange the order of the chemical on the left of the table to match the proper solubility.

Yes 👌, I do find myself changing the orders as the program evolves, but sometimes the links dont always auto change depending on how they are linked :banghead: (RTFM springs to mind)

yes I had to crack the password of the sheets to copy paste the formulas.
:thumbup: good, well its only there to protect the end user from overwriting the formulas, hence it was made easy to enter and not forget, having it alphanumeric to 16 places would of been a PITA every time I did a release :rolleyes:

If you need any help let me know.

Yes if you see anything you can improve on I can give you the down link to the version I'm working on, you can do your 'magic' and then I can then upload it back and so on. As long as we dont both work on it at the same time there isn't an issue OFC. I was hoping some one with the right skill set would pop up in the community to help.

The whole idea of doing the calculator was to do it for the community, done by the commuity and it shall be done for free for no persoanl profit or gain and free for there end user to use, being open, honest and transparant etc. So basically follows the principles of 'Good Science' outlined in Ben Goldacre book 'Bad science'
 

Hanuman

Member
Joined
4 Jan 2019
Messages
506
Location
Thailand
the down link to the version I'm working on, you can do your 'magic' and then I can then upload it back and so on. As long as we dont both work on it at the same time there isn't an issue OFC.
Yeap you can send me the pre-release. In fact I think we could both work on it at the same time. For the time being I will simply focus on looking for bugs or errors in formulas. I will keep track of what I find so you can then integrate it in your version. That way I don't slow you down and you don't need to wait for me to submit revisions before continuing your work. You can simply add them or disregard them (if already corrected by yourself or not deemed necessary) as they come in future releases.

In my opinion though before adding further features, I think the calculator needs to be cleaned up a bit both from a usability and organisation stand point. This will allow for less errors to be made down the road but also make the tool more user friendly / "plug and play".
 

Basviola

Member
Joined
3 Apr 2019
Messages
117
Location
Denmark
Version V1.9 coming soon

Zeus recently you added Rexolin to the calculator, is that the version 1.9 ?

Please consider making a video tutorial. The excel sheets is the most advanced I have seen...well that might be the reason, but I just don't really get it.

I feel so stupid, but I would just love to learn how to use the calculator so I can compare different fert mix recipies.

Tried rotala butterfly... but it confuses me that I only can calculate on one salt at the time.
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
Rexolin to the calculator, is that the version 1.9 ?

Yes its in :thumbup:

but I just don't really get it.

I feel so stupid, but I would just love to learn how to use the calculator so I can compare different fert mix recipies.

@Hanuman is working many an hour at the moment working on how to simplify the calculator without losing any functionality, plus making it more intuitive to use based on international English. But it all takes time. Should be worth the wait IMO
 

hypnogogia

Member
Joined
6 Apr 2017
Messages
594
Location
Oxfordshire
Now that I’ve got my head round the calculator I use it to establish how to mix my ferts. In fact, it got me back into mixing my own as I can establish a target and work out exactly how much of each salt to add to achieve that target. :)
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
Now that I’ve got my head round the calculator I use it to establish how to mix my ferts. In fact, it got me back into mixing my own as I can establish a target and work out exactly how much of each salt to add to achieve that target. :)

That was always the aim - to make it all easier to all the salts at once with no maths :thumbup: Good to hear you getting on with it. I do think it will be better when @Hanuman has done his magic as he is much more competent at Excel than me, I was just 'Winging it' ;)
 

Basviola

Member
Joined
3 Apr 2019
Messages
117
Location
Denmark
Tanks for all the work you into that calculator.

I will definately wait for it and just keep dosing the recipie I am ising at the moment for now.

The following is not to give you more work, just what I find a good ide to help out many upcoming users with the calculator.
About intuition...
Often importen steps, the order to fill in information, and other stuff is just a matter of course to the programmer and/og specialist.

A simple 'walk through video', of how to calc a specific fert mix, would force all the 'know how' out of you experienced guys.

Don't know if the following makes sense, but with my novice information about fert mixing, I would find it interesting with a database of fert recipes.

Don't know how it should be evaluated, but if people shared the recipe they used with most success, among other parameters like water hardness, light, cow and so on.
If a database like that existed, it might be quite easy to draw some imperial conclusions of what micro to choose with hard water and so on... Or that most people with hard water tanks used this or this product along with their ferts for the best effect.

Anyway a big thanks again for working on the calculator.
 

dcurzon

Member
Joined
4 Jul 2020
Messages
200
Location
Essex
First post! Have I come to the right place to bug report?? :)
Thank you for the fine work put into this. I know that its almost impossible to test every possible scenario, that's why we have beta releases...

v1.8
On the Dose Devil tab, Macro Dosing Solubility report, discrepancy with the chemicals being used on DIYFert tab.

Im using:
1593837756046.png


DD shows:
1593837780529.png


So its pulling information from the wrong cells for the following:
kh2po4
CaNO3
K2SO4
MgSO4
CaCO3
K2CO3

Looks likely that its because compounds have been put in a different order between the 2 lists.

I can't edit the worksheet because a) its protected, and b) I have no idea what the solubility is of these things so it might not work correctly with the formula MAX D27-34.

Ah, that's not a bad first post! Anyway, superb job on the spreadsheet! Thanks :) I made my first DIY mixes yesterday, using this tool to give me confirmations :)
 

madhunm

New Member
Joined
4 Jul 2020
Messages
22
Location
Bangalore, India
Hello @Zeus,

Awesome tool!

I have a couple of questions:

1. If I want to setup my own regime based on percentages, where do I enter the values?
2. My CSM+B is not the same as what is on your sheet. How do I change the element percentage values?
3. Can you also please add KCl (Potassium Chloride) for Potassium contribution? insteead of only K2SO4 (Potassium Sulphate)

Thanks,
Madhu.

P.S. Where can I find version 1.9 of this tool?
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
First post! Have I come to the right place to bug report?? :)
Thank you for the fine work put into this. I know that its almost impossible to test every possible scenario, that's why we have beta releases...

v1.8
On the Dose Devil tab, Macro Dosing Solubility report, discrepancy with the chemicals being used on DIYFert tab.

Im using:
View attachment 151569

DD shows:
View attachment 151570

So its pulling information from the wrong cells for the following:
kh2po4
CaNO3
K2SO4
MgSO4
CaCO3
K2CO3

Looks likely that its because compounds have been put in a different order between the 2 lists.

I can't edit the worksheet because a) its protected, and b) I have no idea what the solubility is of these things so it might not work correctly with the formula MAX D27-34.

Ah, that's not a bad first post! Anyway, superb job on the spreadsheet! Thanks :) I made my first DIY mixes yesterday, using this tool to give me confirmations :)

Thanks for the positive feedback and double thanks for posting about the error, we are aware of some issues but new version on its way , soon.............
 

Zeus.

Member
Joined
1 Oct 2016
Messages
3,379
Location
Yorkshire,UK
Hello @Zeus,

Awesome tool!

Thank you :D

1. If I want to setup my own regime based on percentages, where do I enter the values?

We haven't configured it for percentages as most folk use weekly [ppm]

My CSM+B is not the same as what is on your sheet. How do I change the element percentage values?

In the hidden locked sheets, if there isn't much difference I would just go off the weekly Fe ppm your after.
we could always add it later once V1.9 is out

3. Can you also please add KCl (Potassium Chloride) for Potassium contribution? insteead of only K2SO4 (Potassium Sulphate)

Already been added in version 1.9


P.S. Where can I find version 1.9 of this tool?

On @Hanuman hard drive ;) I'm not even allowed to see it till hes done 🤣 I do get little snippets here and there, but some jobs cant be rushed
 

Hanuman

Member
Joined
4 Jan 2019
Messages
506
Location
Thailand
v1.8
On the Dose Devil tab, Macro Dosing Solubility report, discrepancy with the chemicals being used on DIYFert tab.

Im using:
View attachment 151569

DD shows:
View attachment 151570

So its pulling information from the wrong cells for the following:
kh2po4
CaNO3
K2SO4
MgSO4
CaCO3
K2CO3

Looks likely that its because compounds have been put in a different order between the 2 lists.

I can't edit the worksheet because a) its protected, and b) I have no idea what the solubility is of these things so it might not work correctly with the formula MAX D27-34.

This has been fixed in the current version I am working on. It was one of the first bugs I noticed when I started helping [mention]Zeus. [/mention]
 

Similar threads

Top