Home | Community | Message Board


DoubleBlind - Learn to Grow Mushrooms
Please support our sponsors.

Mushrooms, Mycology and Psychedelics >> Mushroom Cultivation

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Shop: North Spore Bulk Substrate, North Spore Mushroom Grow Kits & Cultivation Supplies   Original Sensible Seeds Bulk Cannabis Seeds   Kraken Kratom Red Vein Kratom   PhytoExtractum Maeng Da Thai Kratom Leaf Powder   Amazon Coir, Spawn Bags

Jump to first unread post. Pages: 1 | 2 | 3 | 4 | Next >  [ show all ]
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Substrate Calculator Spreadsheet - over 1,500 Downloads! * 9
    #11501203 - 11/21/09 10:36 PM (11 years, 3 months ago)
Log in to view attachment

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!

:mushroom2::mushroom2::mushroom2::mushroom2::mushroom2:

Here's a screenshot: 


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinesansa
Registered: 11/17/09
Posts: 647
Last seen: 6 years, 6 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11501292 - 11/21/09 10:51 PM (11 years, 3 months ago)

Cool


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: sansa]
    #11503213 - 11/22/09 11:51 AM (11 years, 3 months ago)

I tested this last night with a bulk run...
Worked well, very precise, but I think I "short-changed" my coir when prepping it because its so damn fluffy.  Possibly same on the poo.  SO - when you are measuring, err toward too much substrate material.


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineNoBrainNoPain
Enthusiast noob


Registered: 03/27/09
Posts: 427
Loc: here
Last seen: 5 years, 11 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11516866 - 11/24/09 07:28 AM (11 years, 3 months ago)

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 :confused:


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: NoBrainNoPain]
    #11516996 - 11/24/09 09:03 AM (11 years, 3 months ago)

Hmmmm strange... I haven't tested it outside of MS Excel.  I wonder if its trying to find a different worksheet or something?

I'll take a look and see what I can find out.


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineNoBrainNoPain
Enthusiast noob


Registered: 03/27/09
Posts: 427
Loc: here
Last seen: 5 years, 11 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517012 - 11/24/09 09:15 AM (11 years, 3 months ago)

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

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: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517026 - 11/24/09 09:22 AM (11 years, 3 months ago)

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.


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinecowfodder
banged your mom.
Male

Folding@home Statistics
Registered: 10/22/09
Posts: 391
Last seen: 9 years, 3 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517046 - 11/24/09 09:30 AM (11 years, 3 months ago)

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


:guitarhero:


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineBatista
**ANIMAL**
Male


Registered: 11/03/09
Posts: 68
Last seen: 10 years, 10 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: cowfodder]
    #11517050 - 11/24/09 09:32 AM (11 years, 3 months ago)

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


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinecowfodder
banged your mom.
Male

Folding@home Statistics
Registered: 10/22/09
Posts: 391
Last seen: 9 years, 3 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Batista]
    #11517085 - 11/24/09 09:43 AM (11 years, 3 months ago)

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


:guitarhero:


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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Batista]
    #11517116 - 11/24/09 09:55 AM (11 years, 3 months ago)

I don't, but it would be pretty easy to convert it.
I'll upload a metric version later today, but will need someone to sanity check my conversion numbers.  I just don't think in metric. :wink:


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineBatista
**ANIMAL**
Male


Registered: 11/03/09
Posts: 68
Last seen: 10 years, 10 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517157 - 11/24/09 10:10 AM (11 years, 3 months ago)

Il check it out Gorny lol
Thanks man - this would really help as im spawning to Hpoo tonight


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Invisibledaytripper05
Psychonaut
Male User Gallery


Folding@home Statistics
Registered: 10/31/06
Posts: 6,962
Loc: In my garden
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517239 - 11/24/09 10:31 AM (11 years, 3 months ago)

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: Filter  Print Post  Remind Me! Notify Moderator
InvisibleSlimz
.-~*´`*·~-experience-~*´`*·~-.
Male User Gallery


Folding@home Statistics
Registered: 10/03/07
Posts: 3,588
Loc: Maryland
Re: Upgraded Substrate Calculator Spreadsheet [Re: daytripper05] * 1
    #11517255 - 11/24/09 10:37 AM (11 years, 3 months ago)

there is a simple substrate calculator in the #feelfamily chat room (in the text chat section of this site)

just type
!binq <L> <W> <D>
and it will return how many total quarts you need to fill a bin to a certain depth (D is desired depth)
use !binl for liters

all measurements are in inches

Code:

<Slimz> !binq 12 24 4
<FeelBot> For a bin that is 12 inches long, 24 inches wide for which you want 4 inches of substrate, you will need 19.948051948051948 total quarts of material



--------------------
Lazy Drywall Tek (no powdery mess)

This series will blow your mind and confirm what you already know to be true.
The Pharmacratic Inquisition
Best Thread Ever ! ! !

:pm: me if you have questions about lasers

Although i may advise others in a general way regarding all types of mushroom grows, and may even post question from other forums about growing "active" mushrooms, i only grow non-"active" mushrooms and edibles.

FeelFamily resident tech guru


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Slimz]
    #11517545 - 11/24/09 11:45 AM (11 years, 3 months ago)

Okay, I added a metric version.  It looks right, but let me know if its fucked.

I also saved both english and metric versions in:
-latest excel format
-old excel format
-old excel format exported from google docs
-open office format

Sheeeeesh! :laugh:


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
InvisibleSlimz
.-~*´`*·~-experience-~*´`*·~-.
Male User Gallery


Folding@home Statistics
Registered: 10/03/07
Posts: 3,588
Loc: Maryland
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517559 - 11/24/09 11:48 AM (11 years, 3 months ago)

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


--------------------
Lazy Drywall Tek (no powdery mess)

This series will blow your mind and confirm what you already know to be true.
The Pharmacratic Inquisition
Best Thread Ever ! ! !

:pm: me if you have questions about lasers

Although i may advise others in a general way regarding all types of mushroom grows, and may even post question from other forums about growing "active" mushrooms, i only grow non-"active" mushrooms and edibles.

FeelFamily resident tech guru


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Slimz]
    #11517568 - 11/24/09 11:50 AM (11 years, 3 months ago)

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... :cool:  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.


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,932
Loc: USA Flag
Last seen: 1 year, 2 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: daytripper05]
    #11517590 - 11/24/09 11:53 AM (11 years, 3 months ago)

Quote:

daytripper05 said:
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.





Not enough time in the day for fun projects like that. :frown:


--------------------
:mushroom2:Bulk Grow Substrate Calculator Spreadsheet - Download :heartpump: Thread:mushroom2:
*Downloaded over 3,000 times!* Also try the DMT Changa Mix Calculator

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



Post Extras: Filter  Print Post  Remind Me! Notify Moderator
InvisibleSlimz
.-~*´`*·~-experience-~*´`*·~-.
Male User Gallery


Folding@home Statistics
Registered: 10/03/07
Posts: 3,588
Loc: Maryland
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517709 - 11/24/09 12:14 PM (11 years, 3 months ago)

yeah the calculator is by no means done on my part. but i plan to make it able to calculate anything you need as far as mycology goes.

one day it will be done


--------------------
Lazy Drywall Tek (no powdery mess)

This series will blow your mind and confirm what you already know to be true.
The Pharmacratic Inquisition
Best Thread Ever ! ! !

:pm: me if you have questions about lasers

Although i may advise others in a general way regarding all types of mushroom grows, and may even post question from other forums about growing "active" mushrooms, i only grow non-"active" mushrooms and edibles.

FeelFamily resident tech guru


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
OfflineBatista
**ANIMAL**
Male


Registered: 11/03/09
Posts: 68
Last seen: 10 years, 10 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Slimz]
    #11524501 - 11/25/09 08:58 AM (11 years, 3 months ago)

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


Post Extras: Filter  Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1 | 2 | 3 | 4 | Next >  [ show all ]

Shop: North Spore Bulk Substrate, North Spore Mushroom Grow Kits & Cultivation Supplies   Original Sensible Seeds Bulk Cannabis Seeds   Kraken Kratom Red Vein Kratom   PhytoExtractum Maeng Da Thai Kratom Leaf Powder   Amazon Coir, Spawn Bags

Mushrooms, Mycology and Psychedelics >> Mushroom Cultivation

Similar ThreadsPosterViewsRepliesLast post
* Mycology Spreadsheet Satori23 3,893 19 02/22/10 11:18 PM
by Satori23
* Free Excel spreadsheet to calculate plate pouring schedule Terry M 1,009 8 05/07/11 01:35 AM
by jokefox
* Q about substrate storing iangato 822 4 03/02/02 09:59 AM
by XAZIA
* Ready to upgrade... Thrillz 1,590 14 09/10/02 10:56 AM
by Green_Velvet
* White mold? Unsure about the white texture on the substrate Jvxn 1,003 10 03/02/18 12:58 PM
by mushboy
* A friend wants to "upgrade" to casing......but issues..... factory81 827 4 10/26/03 06:02 PM
by Anonymous
* Hygrometer Upgrade Suggestions TrippingBillies 903 1 06/20/02 07:34 AM
by Anno
* Magic Mushroom Dosage Calculator !!!!
( 1 2 3 all )
Psilocybin_monkey 8,558 44 09/30/03 08:08 PM
by NiamhNyx

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Shroomism, george castanza, RogerRabbit, FooMan, mushboy, fahtster, LogicaL Chaos, 13shrooms, stonesun, wildernessjunkie, cronicr, Pastywhyte, bodhisatta
20,949 topic views. 31 members, 174 guests and 55 web crawlers are browsing this forum.
[ Print Topic ]
Search this thread:
Everything Mushrooms
Please support our sponsors.

Copyright 1997-2021 Mind Media. Some rights reserved.

Generated in 0.056 seconds spending 0.005 seconds on 15 queries.