Log in to view attachment



GORNYHUY'S BULK SUBSTRATE CALCULATOR SPREADSHEET VERSION 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:





Edited by gornyhuy (08/15/11 08:29 AM)



Post Extras:



Cool



Post Extras:



Sounds nice, but doesn't seem to work…?



It asks for missing links at opening, and I get lots of cells with #NAME? or ### in it.



Tried with neoOffice 3.0.1



--------------------

I would love a woodlover's print… PM If you have one and want to trade



Post Extras:



Very strange, as I can't ever open it with MS Excel, ahah



I unzipped the .zip folder, get a gornyhuy_substrate_calc_v2.xlsx file, that won't open with anything than neoOffice



Every day I get more and more convinced that MS softwares are curses placed upon mankind…



--------------------

I would love a woodlover's print… PM If you have one and want to trade



Post Extras:



Well, I tested it by uploading it on its own to google docs, and it works fine - doesn't try to find any other documents, doesn't throw any errors, and calculates fine.



I'm guessing it has to do with neoOffice puking. So - I've saved it in an old Excel 97 format and even as an open office format and zipped all that up in the main download file for you and anyone else who runs into issues. Hopefully that will solve any compatibility issues.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Quote:

gornyhuy said:

Well, I tested it by uploading it on its own to google docs, and it works fine - doesn't try to find any other documents, doesn't throw any errors, and calculates fine.



I'm guessing it has to do with neoOffice puking. So - I've saved it in an old Excel 97 format and even as an open office format and zipped all that up in the main download file for you and anyone else who runs into issues. Hopefully that will solve any compatibility issues.







Thanks gornyhuy! It's nice to see someone looking out for those of us that refuse to use M$ products.



*edit* The ODS and xlsx versions still give me the "$name" problems, but the regular xls version opened up just fine in open office. Nice work.



--------------------

"“Today a young man on acid realized that all matter is merely energy condensed to a slow vibration, that we are all one consciousness experiencing itself subjectively, there is no such thing as death, life is only a dream, and we are the imagination of ourselves. Here's Tom with the Weather.""

—Bill Hicks







Edited by cowfodder (11/24/09 07:40 AM)



Post Extras:



Nice work, you dont perhaps have one with metric system units?



Edited by Batista (11/24/09 07:33 AM)



Post Extras:



Quote:

Batista said:

Nice work, you dont perhaps have one with metric system units?







1 quart = approx .95 liters. 1 pint = approx. .47 liters.



It's almost a 1:1 conversion, so if you go on the premise that 1 quart is pretty much the same as one liter, and 1 pint is half a liter (500ml) then your ratios end up being the same, you'll just have a tiny bit of left over material.



*edit* Of course, I didn't think about the calculations for volume. I'm sure gornyhuy can rework the math for metric, but if not I might play around with it when I get a chance. Should just be a matter of multiplying a few numbers to convert to metric.



*edit 2* I see where some of the calculations are. One pint dry is 33.6 cubic inches by this calculator. That is 0.000550 cubic meters, or 16.387 cubic centimeters. I'm not sure where I was going after that.



--------------------

"“Today a young man on acid realized that all matter is merely energy condensed to a slow vibration, that we are all one consciousness experiencing itself subjectively, there is no such thing as death, life is only a dream, and we are the imagination of ourselves. Here's Tom with the Weather.""

—Bill Hicks







Edited by cowfodder (11/24/09 07:58 AM)



Post Extras:



Il check it out Gorny lol

Thanks man - this would really help as im spawning to Hpoo tonight



Post Extras:



You should convert the this little app to a javascript/html page for easier use so everyone can use it. If I had the time I would do it myself.



Post Extras:



Quote:

Slimz said:

yeah thats why i just stuck mine in the text chat..

im gonna make it more complex just as soon as i get around to it. the code is written from scratch in TCL







Very sexy... Love that its in the chatroom like that.

I like to do stuff like this in a spreadsheet so that anyone can edit or expand it to their needs and use it offline.



I was always turned off by the older calculators that required you to install a .exe file.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Just checked the metric one, thanks Gorny! Works like a charm!



Post Extras:



That joke…



The specific ods version don't work with neoOffice, but the old excel one does…



Thanks a lot for your work



--------------------

I would love a woodlover's print… PM If you have one and want to trade



Post Extras:



BUMP



Just wanted to bump ye old calculator thread because I just noticed that the latest version hit 100 downloads!



I've used it with great success lately, just be careful with your coir expansion, it can throw off your volume calcs depending on what your "brick" is like and how much actual volume it takes up after hydration and expansion.







--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Thank you! worked perfectly.



--------------------

A man should look for what is, and not for what he thinks should be. -Albert Einstein



Post Extras:



I for one am grateful for the bump.





This app is awesome and I plan on using it for all future bulk calculations.



--------------------

MY TRADE LIST



Post Extras:



Quote:

gornyhuy said:

Thanks man... just hit 300 Downloads!









This is a very nice tool. Thank you for putting the effort in to it. Runs nicely on Office 2007.



--------------------



.



Post Extras:



This is really cool, will definitely save time checking and double checking references, and will make a good template for an experiment log. Very convienient, thanks for sharing!



--------------------

"Oh and technically speaking I didn't find the bluing pluteus... My mom did! We were out for a walk and she was like "Ooooh loookie!". I was like, "shit...". She also found weilii without realizing it. I'd say the mushrooms want to have a word with her!"



Post Extras:



Thank you so much for creating this! Its such a time-saver



Post Extras:



This is amazing!



Post Extras:



Quote:

gornyhuy said:

Wow - just hit the 400 download mark - 100 DLs in the past month alone!









Its a nice tool.



I would like to see an option for straw added if you are considering updating it. I know I could just sub it for an existing slot... its just a suggestion.



--------------------



.



Post Extras:



Quote:

CrayolaHalls said:

Quote:

gornyhuy said:

Wow - just hit the 400 download mark - 100 DLs in the past month alone!









Its a nice tool.



I would like to see an option for straw added if you are considering updating it. I know I could just sub it for an existing slot... its just a suggestion.







Thanks!



Funny you should say that, I had to substitute straw in for the coffee slot a few weeks ago. Straw is almost as hard to nail down volume as coir is!



yeah, if there is ever a need for version 3, I'll expand the ingredient list, but for now its pretty easy to make small changes like that.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Guys id hate to be a pest, but my excel wont work because its expired, would anyone be kind enough to figure this out for me?



How many qts of spawn(rye) will i need for 2lbs of dried poo?



And once all that is mixed, how big of a container will i need to make the substrate depth 3"? (dimensions of container, going to do a monotub)



Thanks!



--------------------

FIGHT THE POWER!



Post Extras:



Quote:

NoBrainNoPain said:

Sounds nice, but doesn't seem to work…?



It asks for missing links at opening, and I get lots of cells with #NAME? or ### in it.



Tried with neoOffice 3.0.1







If anyone encounters this phenomenon it is sometimes caused by the cells widths being too small for the data or text which can be from large fonts.



I'm really looking forward to giving this a go



Post Extras:



Quote:

ruckusman said:

Quote:

NoBrainNoPain said:

Sounds nice, but doesn't seem to work…?



It asks for missing links at opening, and I get lots of cells with #NAME? or ### in it.



Tried with neoOffice 3.0.1







If anyone encounters this phenomenon it is sometimes caused by the cells widths being too small for the data or text which can be from large fonts.



I'm really looking forward to giving this a go







If this happens, you can usually double click on the right edge of the column header and it will auto-size to match the width of your largest cell content.



Thanks for the bump - feel free to give me some love!



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Quote:

Base Icks said:

I'm assuming someone sorted this guy out ^^ but Open Office is free.



Works like a charm.







Damn, finally. After almost a month!!



Jk, Thanks for that tho dude. Thats gonna come in a lottt of handy



--------------------

FIGHT THE POWER!



Post Extras:



im gunna have to try this on my next batch!



Post Extras:



IMPORTANT UPDATE

Special Thanks to Todlow who pointed out that the spawn ratio calculation was assuming "1:N" means "spawn to total" versus "spawn to substrate". I think most people think of substrate ratios as SPAWN to SUBSTRATE so that a 1:4 ratio is 1 part spawn to 4 parts substrate which is actually 20% spawn.



All spreadsheets have been corrected as of November 4, 2010 - you may want to re-download the latest version or correct that spreadsheet formula yourself.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Gornyhuy is a great guy. Thanks for this update my friend



--------------------







You have to die a few times before you can really live.



-Charles Bukowski-



Post Extras:



Quote:

Base Icks said:

Wow I had a debate with myself about this the other day while away from the pc. I forgot to bring this up. Glad its sorted. I thought that it was the other way tbh.



I always thought that 1:4 was a 25% ratio.



Can we have a poll of this in mush cult?









Yeah, obviously that's where my head was as well. It all depends on if you mean spawn:total or spawn:sub.



Its easy to adjust, depending on what your preference is.



Instructions

You go to cell B16 in the spreadsheet and change the formula for the percentage value.



If you want to do ratios as Spawn:Total, the formula should be:

=1/spawnratio



If you want to do ratios as Spawn:Substrate, the formula should be:

=1/(1+spawnratio)



The latest version uses the second formula above.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Quote:

Barakanaten said:

Thanks for the effort you put into this I tried to use it a while back and it just seemed a little off to me..maybe the new fix will clear it up.



Also way cool that you made it compatible with oO open office is what I use.







Thanks! For this latest version, I downloaded the latest oO and built it fresh so it should work perfectly in there now.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



Quote:

gornyhuy said:

Okay, 1,000 downloads! I think I'll stop bumping this thing now.

Thanks everyone!







1,001!!



--------------------

"Disbelief in magic can force a poor soul into believing in government and business."

— Tom Robbins



“The true value of a human being can be found in the degree to which he has attained liberation from the self"

-- Albert Einstein



Post Extras:



Nice jarb! Miss you gorny, I don't see you post around here anymore.



--------------------

ephemeral anomalous



Post Extras:



Quote:

prismism said:

Nice jarb! Miss you gorny, I don't see you post around here anymore.







Thanks man! I'm still here.



I lurk WAY too much, but mostly post in the psychedelic experiences section because I stopped growing. When you mostly solo trip and don't ever sell or trade, you can get to a lifetime supply of ridiculously potent PE isolates in a rather short amount of time.



--------------------

Bulk Grow Substrate Calculator Spreadsheet - Download Thread

* D o w n l o a d e d o v e r 3 , 0 0 0 t i m e s ! * Also try the DMT Changa Mix Calculator

Stonesun's Amazing Sclerotia/Stones Guide Vasodilator List Niacinamide - reduce trip anxiety





Post Extras:



thats alot of cultivators







Post Extras:



Awesome! Thank you



Post Extras:



Thanks for the work



Post Extras: