Jayefc1
Member
Thanks il do the update glad to help mate really appreciate the time and effort your putting in to this I wouldnt know where to start
-
You are viewing the forum as a Guest, please login (you can use your Facebook, Twitter, Google or Microsoft account to login) or register using this link: Log in or Sign Up
Fert Calculator V1.8 - New version out! Check Note first/last post!
- Thread starter Zeus.
- Start date
- Status
Well it helps me as then I know I will have a calculator thats easy to use and works with little to no effort
so its a WIN WIN for us allUsed your details and with the fix I just did the results was better ( it was the 'Factor Four bug'
)
Slight formatting differences above as V1.1
Jayefc1
Member
Do.i need to.down load again
if your on V1.0 to V1.2 it will be fine as differences are mainly cosmetic 😉
-------------------------------------
Updated first post about the comparisons and in V1.2 I've added 'ADA mighty Brightly Nitrogen' for comparison
V1.3 released
Sorted out how to choose your salts so you can select them and it adds them to your list - saves values if deselected and restore if you choose them again eg if deselected sets value to "0" but has the value saved.
Big back end redesign - 'boring stuff' but will make adding more salts easier long term.
Had to learn some Excel Visual Basic to get the program to work the way I was after but should have lots of scope to add lots more features so you can set it all up to suit your needs without seeing everything so one version should be able to suit everybody - when done OFC
Lots still to do 😀
All Feedback welcome
Request for salts to be added will speed them up the list be added OFC 😉
Sorted out how to choose your salts so you can select them and it adds them to your list - saves values if deselected and restore if you choose them again eg if deselected sets value to "0" but has the value saved.
Big back end redesign - 'boring stuff' but will make adding more salts easier long term.
Had to learn some Excel Visual Basic to get the program to work the way I was after but should have lots of scope to add lots more features so you can set it all up to suit your needs without seeing everything so one version should be able to suit everybody - when done OFC
Lots still to do 😀
All Feedback welcome
Request for salts to be added will speed them up the list be added OFC 😉
Jayefc1
Member
Wont let me choose my salts mate dont know why 
Thought that might be a little issue with the 'Excel Macro Enabled Spreadsheet' 🙄 Just tried it on phone and same issue but was still able to adjust the details of tank size amount of salts etc, so it isnt a big issue IMO, it just means when using Excel veiwer you cant pick/choose your salts etc. The options/salts to be used are picked when you first use the app, then after that the 'Active X" controls are not used.
So I will make the STD download available with the most likely salts so ready for most folk (already done) using mobile devices, and will add another download link with the full array of options pre enabled !!!
Folks using normal Excel on PC will have full functionality from the start, mobile users may need to use a PC ( or ask a friend) to select some stuff then upload file to mobile device
so a little more effort for mobile users at first 😛Will add a checkbox to close/hide all the main options as once selected no need to see them plus better for mobile users too😉 Edit Done 😀
Last edited:
Andrew Butler
Member
Aren't you going to name and shame them? 😉
Ivan Stoyanov
Member
What are ideal ca:mg:k and no3😛o4:k ratios, can someone to tell?
Think they already know your a PITA M8
Well according to T Barr there are no ideal ones its all about Liebig’s law, there was much debate about it in Mg in Tapwater but T Barr was suggesting a ratio for awhile some time back but more recently dismissed it, below is a quote from Darrel
which says a lot about much of what we think/say/post/read there isnt an answer that has hard proof to support it 100% either way
Jayefc1
Member
It's a shame cause I think most people use there phones now days just for ease of access
Well you can run Maros if you have the MS full product on your phone
But "Excel viewer" doesn't have any Functionally for macros as far as I am aware ATM 🙄
Jayefc1
Member
Maybe as you said make 2 versions available one for mobile where all salts are there and one for PC is that much more work
No same version will work on PC and mobile, I just save with all options enabled 😀 So Full Excel users can just disable the options😉
Last edited:
Jayefc1
Member
I have one if you need i could email.it to you
Done
two links in first post I will be working mainly on the non macro version for some time, as unfortunately adding rows and columns in Excel doesn't update the macro code as well
so it is slowing the development process down updating the code all the time as I add salts etc 🙄 But I have learnt what I needed on how to do it So when I have further developed the app, I will be able to do the macro code so end users can customise it to suit their needs. 😀
Thought I would add a little calculator to calculate tank volume based on tank dimensions and thickness of glass and work from the depth of water to bottom of glass of the tank to surface of water, then add the same measurement so at WC you just measure the distance from bottom of tank to water level. With it removing the glass thickness for each calculation.
Simple enough to do and calculate
Had to modify my tanks details had never got the tape measure out and did the actual calculation, had just used the tanks specs from the manufacture 🙄
needless to say my fert levels just increase
(upload the update to Non Macro version download)
Simple enough to do and calculate
Had to modify my tanks details
had never got the tape measure out and did the actual calculation, had just used the tanks specs from the manufacture 🙄needless to say my fert levels just increase
(upload the update to Non Macro version download)
Sammy Islam
Member
That's actually just what i needed to work out, the realistic amount of water my tank actually holds, the AS900 is rated 186L.
According to the calculator an AS900 holds realistically about 145-150L, then i have to account for soil and hardscape, 27L and 22kg. So i would be looking at around 120L actual volume?
I've been dosing for 160L tank, so i've been massively over dosing?
Might have to do a reset and recalculate my ferts
According to the calculator an AS900 holds realistically about 145-150L, then i have to account for soil and hardscape, 27L and 22kg. So i would be looking at around 120L actual volume?
I've been dosing for 160L tank, so i've been massively over dosing?
Might have to do a reset and recalculate my ferts
- Status
