Greetings narcotic nute nerds Here is a nutrient calculator I cobbled together out of a solar powered calculator, an old EC meter, and some duct tape. Oops no wait, that's the other one.
This one here is called Nute MashUp and it's an Excel spreadsheet so you will need Microsoft Excel installed, or there's other options like Open Office (.org - free last time I looked). Excel is part of MS's Office collection of programs, so if you do install MS Office, you only need a minimal/custom install of just Excel, not all the other progs. Same goes for Open Office I think, just that they call their spreadsheet prog something other than Excel.
I had next to no experience in Excel before this and I kind of thought it was a useless office program, but Cannastats made me think differently! All the calculations that go on are actually quite simple, the hard part was trying to convert that into excel code and make it all work smoothly together and look nice. Being that I have no internet at home, I jump at the chance to read anything. 3 times just for something to friggin' do, lol. So I basically just read the manual and when I couldn't work something out, I would kinda reverse engineer the situation. The whole thing was made on a 7" screen (800x600) so you'll probably want to zoom some things. I use Ctrl + mouse scroll wheel.
So, opening the file (the zip password is icmag), we have four tabs...
MashUp tab: This is like the "Solution Mix" and "Calcs" tabs in Cannastats but on the same page. You enter (or "paste special") your various products, and mix various amounts to achieve the final mix. The big thing here is the graphs which I have to thank Tester for the idea. And in conjunction with this is the "Target" idea. Paste your target formula (see "Store" tab for examples) into the blue section, then make like a DJ and mix that shit up! The graph/target idea really makes it fast and easy. Then I look to the left at the red and blue columns to do the fine tuning between Current and Target. If the Current is more than 10 ppm away from the Target, it shows in a slightly different colour.
To start from the top though, res size is litres and everything is metric - sorry about that. There's a converter on the Convert tab at least.
Everything works generally the same as Cannastats, but there is an "Unknown N" row which I find handy. There are five custom element rows which can be renamed, for things like heavy metals, chelating agents, witching potions, et al. A lot of these figures will be in PPMs already, so you can convert them on the Convert tab to percentages. There are also 10 columns/products you can work in. If you have a water analysis report, you may want to use a column just for that. You'd give it a weight of 1 and "use" it at 0.1 ml per litre for the numbers to crunch properly (I think... I have never had a water report).
Then you have the Elemental PPMs listed further down which is like the "Calcs" tab in Cannastats. CStats had too much tab switching for me, even though it's a great prog of course, so I tried to squish it up more. I originally had it so the elemental ppm zeroes don't display, but that messed up something else, so I'll have to redesign it one day as I find it annoying.
Then you have the Totals. I added the drip thing because I use that all day, and more-so when I was micro growing. Be aware that some of the figures in the program may be rounded. For example the total amount to add in ml/gm is rounded to 2 decimal points, and so on. As far as I'm aware, the calculations taking place use the actual number you typed in (8.897565848439347) even if the number displays as 8.9.
Under those are the coloured Current and Target displays which the graphs then display. Please note the "Adjuster" thing is not really complete, I just don't have the brainpower to devote to it yet. It just lets you adjust the Current numbers up or down. IE: If you pasted in the Fatman Bloom formula (from the Store tab) which would be a very high EC, and you were using H3ad at the 6/9 rate (much lower EC), you would not be able to compare them that well, graph-ically. The adjuster in theory lets you match them up better, but it's not quite right in scale or something. I'd really like to implement the expected EC/PPM idea of Cstats, and the adjuster would be the EC number, and it would also adjust everything else accordingly, like how much to add, etc.
The pie chart below that breaks down your final nitrogen content inna visual stylee. And finally there's the trace element graph. Phew.
Store tab: should be self explanatory now. I included some examples to play with. They are indeed all just examples and you should check your own labels in case I made a typo or something. Most of the data in Nute MashUp is loosely compatible with Cannastats, so you can "paste special -> values" from Cstats into here, apart from the extra nitrogen row, and the custom elements of course. You pretty much always want to use Paste Special -> Values any time you paste anything to avoid formatting issues, at least on the MashUp tab.
Convert tab: I'll probably expand on these and add more, or if you have any requests go ahead. If anything doesn't add up right, please let me know. In fact I'd better cover my ass here and say don't use ANY of these numbers in actual growing/feeding until we all decide the numbers are correct, lol.
Thx tab: Thx! I learnt so much on this forum.
Well, try it out, let me know what you think. Cheers. (please note that porn popups may popup! If that's an issue and you need it uploaded at a different hosting site, let me know) Clicky.
This one here is called Nute MashUp and it's an Excel spreadsheet so you will need Microsoft Excel installed, or there's other options like Open Office (.org - free last time I looked). Excel is part of MS's Office collection of programs, so if you do install MS Office, you only need a minimal/custom install of just Excel, not all the other progs. Same goes for Open Office I think, just that they call their spreadsheet prog something other than Excel.
I had next to no experience in Excel before this and I kind of thought it was a useless office program, but Cannastats made me think differently! All the calculations that go on are actually quite simple, the hard part was trying to convert that into excel code and make it all work smoothly together and look nice. Being that I have no internet at home, I jump at the chance to read anything. 3 times just for something to friggin' do, lol. So I basically just read the manual and when I couldn't work something out, I would kinda reverse engineer the situation. The whole thing was made on a 7" screen (800x600) so you'll probably want to zoom some things. I use Ctrl + mouse scroll wheel.
So, opening the file (the zip password is icmag), we have four tabs...
MashUp tab: This is like the "Solution Mix" and "Calcs" tabs in Cannastats but on the same page. You enter (or "paste special") your various products, and mix various amounts to achieve the final mix. The big thing here is the graphs which I have to thank Tester for the idea. And in conjunction with this is the "Target" idea. Paste your target formula (see "Store" tab for examples) into the blue section, then make like a DJ and mix that shit up! The graph/target idea really makes it fast and easy. Then I look to the left at the red and blue columns to do the fine tuning between Current and Target. If the Current is more than 10 ppm away from the Target, it shows in a slightly different colour.
To start from the top though, res size is litres and everything is metric - sorry about that. There's a converter on the Convert tab at least.
Everything works generally the same as Cannastats, but there is an "Unknown N" row which I find handy. There are five custom element rows which can be renamed, for things like heavy metals, chelating agents, witching potions, et al. A lot of these figures will be in PPMs already, so you can convert them on the Convert tab to percentages. There are also 10 columns/products you can work in. If you have a water analysis report, you may want to use a column just for that. You'd give it a weight of 1 and "use" it at 0.1 ml per litre for the numbers to crunch properly (I think... I have never had a water report).
Then you have the Elemental PPMs listed further down which is like the "Calcs" tab in Cannastats. CStats had too much tab switching for me, even though it's a great prog of course, so I tried to squish it up more. I originally had it so the elemental ppm zeroes don't display, but that messed up something else, so I'll have to redesign it one day as I find it annoying.
Then you have the Totals. I added the drip thing because I use that all day, and more-so when I was micro growing. Be aware that some of the figures in the program may be rounded. For example the total amount to add in ml/gm is rounded to 2 decimal points, and so on. As far as I'm aware, the calculations taking place use the actual number you typed in (8.897565848439347) even if the number displays as 8.9.
Under those are the coloured Current and Target displays which the graphs then display. Please note the "Adjuster" thing is not really complete, I just don't have the brainpower to devote to it yet. It just lets you adjust the Current numbers up or down. IE: If you pasted in the Fatman Bloom formula (from the Store tab) which would be a very high EC, and you were using H3ad at the 6/9 rate (much lower EC), you would not be able to compare them that well, graph-ically. The adjuster in theory lets you match them up better, but it's not quite right in scale or something. I'd really like to implement the expected EC/PPM idea of Cstats, and the adjuster would be the EC number, and it would also adjust everything else accordingly, like how much to add, etc.
The pie chart below that breaks down your final nitrogen content inna visual stylee. And finally there's the trace element graph. Phew.
Store tab: should be self explanatory now. I included some examples to play with. They are indeed all just examples and you should check your own labels in case I made a typo or something. Most of the data in Nute MashUp is loosely compatible with Cannastats, so you can "paste special -> values" from Cstats into here, apart from the extra nitrogen row, and the custom elements of course. You pretty much always want to use Paste Special -> Values any time you paste anything to avoid formatting issues, at least on the MashUp tab.
Convert tab: I'll probably expand on these and add more, or if you have any requests go ahead. If anything doesn't add up right, please let me know. In fact I'd better cover my ass here and say don't use ANY of these numbers in actual growing/feeding until we all decide the numbers are correct, lol.
Thx tab: Thx! I learnt so much on this forum.
Well, try it out, let me know what you think. Cheers. (please note that porn popups may popup! If that's an issue and you need it uploaded at a different hosting site, let me know) Clicky.
Last edited: