Quote:

---

boommer said:
nice i like what i c... really helps if you want to change the size of your grow but still keep the same desired ratio of the mixture. well done

---

Thanks a lot, I appreciate it.  Happy to hear it's going to be useful

Quote:

---

kansastornado said:
Nice, I appreciate the time you put into it. Im not sure though, I think your round calulations might not be right. I have a 6" pan 3" inches deep and it can only hold just over 3 pints, just perfect for a 1:2 ratio, 3" sub. depth and 1/4" casing. Your calulations say 10 + pints, unless I am not understading something.

---

Thank you too for the kind words

As for the calculations though, I can assure you, they're correct.  You say you have a six inch pan and it's three inches deep.  That means the radius is three inches (radius is the distance from the center of the bottom of the container to the outside edge...so, in other words, the radius is equal to half the diameter).

The volume of a cylinder in cubic inches is calculated like this:
(radius x radius) x pi x height = cubic inches

So, for your container, it would be:
(3x3) x 3.14159265 x 3 = 84.82 cubic inches

The formula for cubic inches to dry pints is:
cubic inches x 0.0298 = pints

So again, it would be:
84.82 x 0.0298 = 2.52 dry pints

The formula for cubic inches to liquid pints is:
cubic inches x 0.0346 = pints

So again, it would be:
84.82 x 0.0346 = 2.93 liquid pints

The calculator I made uses the dry pints calculation, not the liquid pints calculation.

You can mouseover any of the red question marks if there is something that confuses you to get a more thorough explanation.

Quote:

---

kansastornado said:
Yea sorry for not reading, again nice job. Wasn't trying to discredit you in any way. I do appreciate your time and effort.

---

No worries, I do that all the time (not read/skip ahead/etc.), haha.

And I didn't think you were trying to discredit me, it's cool.  In fact, I asked anybody who spotted an error/problem to say so, and that's what you thought you were doing.

Once again, thanks for the kind words, I hope you get some use out of it

Quote:

---

psychotropical said:
Sweet! Many thanks for putting the time into this. I've got it bookmarked in my essential myco tools folder...

---

Quote:

---

Fishie said:
Quite fucking spectacular.
Bookmarked on the toolbar!

---

Same to you

Quote:

---

SpookyCupid said:
I must say, well done. I've got some grain colonizing right now for my first mono I'm planning. It's fantastic that you went through all the time to make this, as well as the $ for the domain. This is a big help. Thank you, you're the man.

---

No problem, I'm happy to see it's going to good use

Quote:

---

Sparkx said:
Very cool. Only issue I ran into is I get "NaN" in the field of Volume Required of Each Substrate Component when I attempt to calculate on it. The Total Substrate Volume worked though. Nice site and good work; you know your math! Thank goodness someone does. I'm awful at it. Thankx and on the bugs!

---

Quote:

---

sgfcchamber said:
Idea 1:
One thing I want to do, is make buttons at the bottom of the page that will auto-populate substrate recipes others have used.

So if you use an 80/20 coir/verm recipe with a 1-to-3 spawn ratio and you have a grow log/thread showing your results using it, I'll make a button that will bear your forum username.  When clicked, it will auto-populate your substrate recipe percentages and the only thing the user will have to input is their container size.

There would also be a link next to it that links back to the thread showing the results of that recipe (this is to prevent made up recipes that haven't been tested as well as so other people can see what type of results said recipe can have).

If you would like to see a button bearing your username that auto-populates your recipe, just go ahead and post on this thread what your bulk substrate ingredients are and the percentages you use them in (by volume) along with your spawn ratio.  You would also need to link to a thread here at shroomery showing the results you had using it.

Idea 2:
Another option for ovular (ellipsoid) shaped containers.  As of now, you can calculate what you're going to need only if you've got a round/square/rectangular container.

---

Quote:

---

Sparkx said:
Derp! I typed 1-2 in the spawn ratio field. I was confused on what exactly you needed there. Now I understand you've included the one because its a constant. LoL I misunderstood. So being the helpful little designer/marketer I am, I'd definitly suggest a red helpful mouseover that explains the NaN error message for your users and clear up the confusion in the spawn ratio field. Great work though and yeah that definitly fixed it User Error! Hehe its the most common bug you'll find in development.

I was part of the Microsoft family for some years.

---

Quote:

---

Hartge said:
First off, thank you! Making a web based ratio calc is something I have been thinking about for awhile and am glad someone put it together!

Idea 1 - sounds like a winner to me, possibly get any TC's sub recipe would be awesome, and I wouldn't disagree to see others on there as well.

Idea 2 - eh, not really sure on this, most people seem to use square or rectangular pans anyways, but hey, up to you.

And again, thank you for putting this together.

---

Thanks for the kind words!  And no problem on putting it together, I just figured it would be nice to give back to the community a bit.  Happy to see people are enjoying it

Yeah, I guess I'll be leaving out "Idea 2".  "Idea 1" was the one I was most excited about doing, I was just hoping more people would post their percentages & spawn ratios here.  Looks like I'll have to PM some folks to see if they'd mind sharing.

Nice work, but this has already been done... I like the round container measurements but how many people do you actually see using round containers. Last time i checked mono tubs were rectangular

Quote:

---

gornyhuy said:
GORNYHUY'S BULK SUBSTRATE CALCULATOR SPREADSHEETVERSION 3(ish)
Calculate substrate content for perfect bulk grows!

• spreadsheet-based substrate calculator that uses a width, length, and depth of your actual substrate to calculate volume
  
  
• if you have a non-rectangular substrate, simply overwrite the total substrate volume (cell B32) with whatever volume you have measured from your spawn bag or cup or whatever.
  
  
• enter percentages of ingredients and see what precise amounts to use based on your desired substrate volume, depth, and spawn ratio so that you can hit your "perfect substrate depth" with your "perfect recipe".
  
  
• Includes metric version
  
  
• Includes Excel version, OLD Excel format, open office version,  etc all zipped up into one file.
  
  
• Instructions are at the top of the worksheet, and its fairly easy to modify it for your own custom needs.
  
  

If anyone finds any errors, or has requests for version 3 please let me know.

Zip file is attached to this post.

Ratings are appreciated! If you like, stick it in your sig!



Here's a screenshot: 

---