Nutrient Ratios Information

Anyways, if you want to know more or want help adding products you are welcome to PM me so I don't cluster fuck this thread anymore than I just did lol.
 
If anything, I would just want to learn how to make my own spread sheet as my needs lead me rather than task someone else to do the work for me. As is now, I have a calculator in Hydro Buddy with most stock solutions already recorded. It is these same solutions that I use to make my own nutrient formulations, and if I needed to stare at all of the various other formulations such as GH, Botanicare, AN etc, it would greatly confuse my very stoned eyes when contemplating various ideas. No worries, I will search for a tutorial if I ever get to the point where Hydro Buddy simply will not cut it for me anymore.
 
Well look at my spreadsheet to see how to make formulas, it's super easy. Go to the cells that show the calculated PPM, they start with = and that makes them a formula, then the cells are referred to by their grid. You will see the formula in the edit bar up top when you select the cell.
 
I am sure you can find a lot of youtube videos on excel if thats more your speed. I just figured it out partly by playing and partly by looking at others work and dissecting it.
 
Skybound420 said:
I'm sorry if this confuses you. It confuses me too, but this system was developed long before either of us was born and is how I learned here on RIU about a year ago on another thread from @im4satori @nxsov180db and a few other contributors that I fail to recall. In all fairness to simplicity, IMO, they should no longer refer to the oxides as all other elements are referred to in plain form, and P, K and Si should follow this model.
Click to expand...
You just said it all... confusing. They should have a standard but who is going to take the time to clean up the fertilizer industry.
Skybound420 said:
I saw a few other spread sheets for calculating nutes but never could figure them out. I'm just not versed enough in xls. I learned to use Hydro Buddy, but it is very restrictive to the elements it will compute, and for a guy like me that mixes his own micro blend, there was no place to enter elements like nickel, alumina, cobalt etc etc etc. Maybe I'll go search out some tutorials for using XLS for that. Can you give me a lead of which terminology I should punch in to get to the tutorials to learn this part of xls? Like how to do behind the scenes math?
Click to expand...
I think Renfro would make a better teacher than I for learning xls but it's really fairly simple. If you want the cell to equal the sum of cells A1 and B1 you would just enter =A1+B1 ... it will even let you click on the cell to enter it's grid location into the equation... any other equations follow suit and you can use ()... if you can do the equation on paper then you can use excel to automate the calculations. If you can't figure it on paper then quit while you are ahead and stay with hydro buddy. Simple as that. Excel spreadsheets also run the risk of programmer error so never hurts to double check by doing the calculation on paper to verify when you just set up a new sheet.
 
Here is the latest version, I added some more detailed instructions and did some formatting "user friendly" fixes. No numbers were changed, just trying to make it easier to understand.
 

Attachments

This has some very handy formatting fixes and some products that my buddy and I added last night while playing with his numbers. I plan to weigh a sample and calculate the specific gravity on the Natures Nectar Phosphorous later today so thats why the "b" version.
 

Attachments

Had to lower P2O5 all the way down to 15ppm but looking better now.

Renfro I'll try inputting something I've already calculated and see if it gives me similar values or not.
 
Almost forgot... where's the best place to order nitrogen and phosphorous chems from... I've got all the chems I need except for nitrogen and phosphorous.
 
Well I just entered 1.5t FloraMicro, 1t FloraGro, 1/32t FloraBloom and 2034.75mg MgSO4... the values I come up with are
N 124ppm
P2O5 15
K2O 99
Ca 97.7
Mg 60
S 70
Your calc is returning
N 151ppm
P 8 = 18.3 P2O5
K 95 = 114 K2O
Ca 122
Mg 14
S 7.4
Something is amiss... is that 26 and 34 under Mg and S percent of each element... MgSO4 is a heptahydrate and you must consider the 7H2O attached to each element... this makes it roughly 9.86% Mg and 13.01%S. Could be my numbers... I've got equations everywhere in my notebook... looks like a math horder over here.
 
Doh... it was my fault... I input 0.203475 instead of 2.03475 on the grams (can't do math in my head for some reason)... new values from your sheet are
N 151 (not sure why this is so much higher than mine)
P 8 = 18.3 P2O5
K 95 = 114K2O
Ca 122
Mg 61
S 70
so values are pretty close to what I figured
 
Diatomacious said:
Hey... forgot to ask... can you plug those values (post #113) into hydrobuddy and see what it returns.
Click to expand...

yes, but you have to also load up solutions that can resolve your targets, so for instance if you only have one source of each element, the app will likely resolve with a wide margin of error on most elements. It is important to have multiple sources of each of your macros and secondaries to greatly improve your odds of hitting your targets with zero% errors. My lineup includes;

calcium sulfate (gypsum)
calcium nitrate
magnesium nitrate
magnesium sulfate (Epsom)
potassium sulfate
monopotassium phosphate
monoammonium phosphate - this may or may not be needed

Diatomacious said:
I'm probably gonna use mostly sulfates for my micros... I'm a little bit afraid to smoke ethyl whatever acetate.
Click to expand...

metallic sulfates are fine if you keep them in powder form until use, but if you try to whip up a concentrate, you will have a jug of rust in about 3 days. I know this because I made my own jug of rust, lol. However, the creator of hydro buddy insists micro sulfates are good to use, but I think he's keeping them as a powder until use because there's simply no other way to keep the metals, especially the iron from quickly oxidizing if not properly chelated.

stained sulfates.jpg
 
You must log in or register to reply here.
Back
Top