Home | Community | Message Board

Sporeworks
This site includes paid links. Please support our sponsors.


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: Original Sensible Seeds Bulk Cannabis Seeds   Kraken Kratom Red Vein Kratom   North Spore Bulk Substrate   Myyco.com Golden Teacher Liquid Culture For Sale   MagicBag.co Certified Organic All-In-One Grow Bags   PhytoExtractum Maeng Da Thai Kratom Leaf Powder

Jump to first unread post Pages: 1 | 2 | 3 | 4 | Next >  [ show all ]
Some of these posts are very old and might contain outdated information. You may wish to search for newer posts instead.
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Substrate Calculator Spreadsheet - over 1,500 Downloads! * 11
    #11501203 - 11/21/09 08:36 PM (14 years, 4 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 08:29 AM)

Extras: Filter Print Post Top
Offlinesansa
Registered: 11/17/09
Posts: 647
Last seen: 9 years, 7 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11501292 - 11/21/09 08:51 PM (14 years, 4 months ago)

Cool

Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: sansa]
    #11503213 - 11/22/09 09:51 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
OfflineNoBrainNoPain
Enthusiast noob


Registered: 03/27/09
Posts: 427
Loc: here
Last seen: 9 years, 20 days
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11516866 - 11/24/09 05:28 AM (14 years, 4 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

Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: NoBrainNoPain]
    #11516996 - 11/24/09 07:03 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
OfflineNoBrainNoPain
Enthusiast noob


Registered: 03/27/09
Posts: 427
Loc: here
Last seen: 9 years, 20 days
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517012 - 11/24/09 07:15 AM (14 years, 4 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

Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517026 - 11/24/09 07:22 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
Offlinecowfodder
banged your mom.
Male

Folding@home Statistics
Registered: 10/22/09
Posts: 391
Last seen: 12 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517046 - 11/24/09 07:30 AM (14 years, 4 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 07:40 AM)

Extras: Filter Print Post Top
OfflineBatista
**ANIMAL**
Male


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

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

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

Extras: Filter Print Post Top
Offlinecowfodder
banged your mom.
Male

Folding@home Statistics
Registered: 10/22/09
Posts: 391
Last seen: 12 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Batista]
    #11517085 - 11/24/09 07:43 AM (14 years, 4 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 07:58 AM)

Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Batista]
    #11517116 - 11/24/09 07:55 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
OfflineBatista
**ANIMAL**
Male


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

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

Extras: Filter Print Post Top
Invisibledaytripper05
Psychonaut
Male User Gallery


Folding@home Statistics
Registered: 10/30/06
Posts: 6,962
Loc: In my garden
Re: Upgraded Substrate Calculator Spreadsheet [Re: gornyhuy]
    #11517239 - 11/24/09 08:31 AM (14 years, 4 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.

Extras: Filter Print Post Top
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 08:37 AM (14 years, 4 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

Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Slimz]
    #11517545 - 11/24/09 09:45 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
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 09:48 AM (14 years, 4 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

Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: Slimz]
    #11517568 - 11/24/09 09:50 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
Offlinegornyhuy
A Myth Intrepidly Met
Male User Gallery


Registered: 08/04/09
Posts: 2,933
Loc: USA Flag
Last seen: 2 years, 4 months
Re: Upgraded Substrate Calculator Spreadsheet [Re: daytripper05]
    #11517590 - 11/24/09 09:53 AM (14 years, 4 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,500 times!* Also try the DMT Changa Mix Calculator

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


Extras: Filter Print Post Top
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 10:14 AM (14 years, 4 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

Extras: Filter Print Post Top
OfflineBatista
**ANIMAL**
Male


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

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

Extras: Filter Print Post Top
Jump to top Pages: 1 | 2 | 3 | 4 | Next >  [ show all ]

Shop: Original Sensible Seeds Bulk Cannabis Seeds   Kraken Kratom Red Vein Kratom   North Spore Bulk Substrate   Myyco.com Golden Teacher Liquid Culture For Sale   MagicBag.co Certified Organic All-In-One Grow Bags   PhytoExtractum Maeng Da Thai Kratom Leaf Powder


Similar ThreadsPosterViewsRepliesLast post
* BEST SUBSTRATE = COMPOST agar 12,390 4 08/20/14 04:48 AM
by Nos-hroom
* Mycology Spreadsheet
( 1 2 all )
Satori23 6,390 22 01/24/24 04:39 AM
by Screwup
* Free Excel spreadsheet to calculate plate pouring schedule Terry M 1,238 8 05/06/11 11:35 PM
by jokefox
* How to Make A Straw Based Substrate
( 1 2 all )
Lana 15,188 23 08/13/13 02:16 PM
by saskuats
* Adding more brf to substrate??? dannycorona82 940 2 03/27/03 03:49 PM
by ExtravagantDream
* Magic Mushroom Dosage Calculator !!!!
( 1 2 3 all )
Psilocybin_monkey 11,068 44 09/30/03 06:08 PM
by NiamhNyx
* Dosage Calculator Question luvdemshrooms 2,019 15 12/15/01 10:44 AM
by luvdemshrooms
* Using Google for all your calculating needs GatorB 811 7 06/16/05 12:29 AM
by lardnar

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Shroomism, george castanza, RogerRabbit, veggie, mushboy, fahtster, LogicaL Chaos, 13shrooms, Stipe-n Cap, Pastywhyte, bodhisatta, Tormato, Land Trout, A.k.a
25,368 topic views. 30 members, 137 guests and 71 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.031 seconds spending 0.006 seconds on 16 queries.