|
Some of these posts are very old and might contain outdated information. You may wish to search for newer posts instead.
|
Mojo
Stranger
Registered: 07/12/07
Posts: 1,677
|
Spawn Ratio Calculator. 5
#7803673 - 12/27/07 11:47 AM (16 years, 3 months ago) |
|
|
Log in to view attachment
Update 07/20/08
I’m really happy to see that some users have found this calculator useful. I am now releasing version 1.4. I have removed UK Quarts and decreased the decimals displayed in the results, overall the newer version just looks a little “cleaner” and that’s it. So if you already have v1.3 your good to go and there is no need to upgrade to this one.
I purposefully did not add any features because I don’t want the calculator to become overly complicated to understand or too presumptuous into other aspects of the grow.
This will be the last release, and I regret not doing it much sooner.
Compatibility,
This file is a Microsoft Excel (.xls) file.
If you don’t have MS Office you can download openoffice at www.openoffice.org which is a free application that will run on any OS.
Or
www.docs.google.com is a google application that will let you view the file through your gmail account.
I’m paraphrasing posts that have been buried in this thread; I’d like to thank the people that brought these recourses to everyone’s attention, you know who you are.
If there are any problems with the calculator, post your question here and I will try and help you.
Thanks for all of the great feedback people, and hey, if you found this useful don’t hesitate to thank me!
VVVVV Original Post VVVVV
I know some people struggle with calculating spawn ratios.
I hope this may help people so they don’t have to post every time they buy a new container, it may also aid in picking the right container for a specific amount of spawn you already have.
I made this calculator in excel. You simply type the dimensions of your container with the desired substrate depth into the calculator and it will tell you how much spawn you need to use in order to achieve a 1:4 or a 1:10 ratio.
I don’t know much about the common measurements outside of the united states so the SI version will calculate the volume in both UK Quarts, and Liters.
I appreciate any input. And if no one is interested than there are no hard feelings, it took a mere five minutes to throw together.
Let me know if anything should be added or subtracted. I wanted to keep it simple.
I had to zip the file in order to upload it.
Edit:
I’m glad to see a positive response. I have upgraded the calculator to v1.3 so you might want to check out the new one.
I have modified the calculator to show the total volume, as well as the fractional amounts of spawn and substrate required to reach it.
I also protected the worksheet so you can only input values where they need to be.
Im still looking for input, and I appreciate the positive responses so far.
Edited by Mojo (07/20/08 02:05 AM)
|
Crasher
αἱρετίζω
Registered: 03/13/01
Posts: 6,220
Loc: Tardy to the Party
|
Re: Spawn Ratio Calculator. [Re: Mojo]
#7803742 - 12/27/07 12:01 PM (16 years, 3 months ago) |
|
|
You magnificent bastard, thanks.
-------------------- Give me silence, water, hope; Give me struggle, iron, volcanoes...
|
Molasses
sobriety with aside of what thefuck am i doing?
Registered: 11/03/07
Posts: 564
Loc: Marijuanaville, Vermont
Last seen: 11 years, 7 months
|
Re: Spawn Ratio Calculator. [Re: Crasher]
#7803769 - 12/27/07 12:08 PM (16 years, 3 months ago) |
|
|
well played, we should sticky it.
is a uk quart close to a us quart?
|
origami.octopus
Mycoporn fanaticin training
Registered: 11/17/07
Posts: 256
Last seen: 15 years, 11 months
|
Re: Spawn Ratio Calculator. [Re: Mojo]
#7803818 - 12/27/07 12:20 PM (16 years, 3 months ago) |
|
|
will it work on macs?
-------------------- I like to look at mushrooms the way most people like to look at flowers. this is an amazing game http://www.kongregate.com/games/customlogic/sprout
|
Mojo
Stranger
Registered: 07/12/07
Posts: 1,677
|
Re: Spawn Ratio Calculator. [Re: Molasses]
#7803823 - 12/27/07 12:21 PM (16 years, 3 months ago) |
|
|
One US liquid quart is equal to 0.83 UK Quarts.
I used US liquid quarts as a standard because it is what you commonly see in measuring devices here in the US, it is also much easier to convert liquid quarts into cups (4 cups = 1 liquid Quart).
I would appreciate some input from people that reside outside of the US. I assume that most of your jars are measured in mL, and that’s why I put liters in the calculator. I put UK quarts in case anyone uses it. But i would be happy to modify it if anyone can chime in about what is commonly used.
|
Mojo
Stranger
Registered: 07/12/07
Posts: 1,677
|
|
Quote:
origami.octopus said: will it work on macs?
It should work if you have Office 2003 or higher. Let me know if it doesn’t work for you.
|
doc34
Fungitarian
Registered: 02/14/04
Posts: 2,667
Loc: Myceliaville !!!
Last seen: 9 months, 27 days
|
Re: Spawn Ratio Calculator. [Re: Mojo]
#7803910 - 12/27/07 12:49 PM (16 years, 3 months ago) |
|
|
Pretty sweeeeeeeet!
Thanks, takes out the guess work for sure!
Doc
|
MaddenKing081
trippin teddywannabe
Registered: 12/24/07
Posts: 83
Loc: Arizona
Last seen: 16 years, 2 months
|
Re: Spawn Ratio Calculator. [Re: Mojo]
#7804172 - 12/27/07 01:57 PM (16 years, 3 months ago) |
|
|
That is awesome. Ive yet to actually spawn to anything, But this might just encourage me to spawn my WBS on my next grow.
Thanks Brother
--------------------
|
shaggydogman
Stranger
Registered: 04/20/07
Posts: 672
|
Re: Spawn Ratio Calculator. [Re: Mojo]
#7806589 - 12/28/07 04:37 AM (16 years, 3 months ago) |
|
|
Log in to view attachment
Nice job.
I was just using it to check the ratio of a half pint (240ml) pf cake crumbled to hpoo in a 1.5 liter tuperware container and it was very useful, thanks.
I then went on to check how much casing material I was going to need to pasturise for 4 of the trays. http://www.shroomery.org/5227/How-and-how-deep-should-I-apply-the-casing-layer suggest 1/4 of the substrate depth with a max depth of 2 inches.
I added a few calculations onto the bottom of your sheet to calculate the recommeded depth of casing material and its volume (very badly formatted) which are attached. Any chance something like this can make v1.4?
-------------------- Rye -- WBS | Grain LC -- G2G | Bulk -- Monotub | 50/50 -- Late Casing -- A Pinning Strategy Disclaimer: My opinion is subject to change at short notice subject to but not limited by new information and knowledge being made available.
Edited by shaggydogman (12/28/07 04:47 AM)
|
norml840
sex toy guru
Registered: 10/19/07
Posts: 3,170
Loc: lost
|
Re: Spawn Ratio Calculator. [Re: shaggydogman]
#7806616 - 12/28/07 05:10 AM (16 years, 3 months ago) |
|
|
you are awesome
|
anarchOi
Ellenalien is fat.
Registered: 08/06/07
Posts: 2,293
Loc: ASE
Last seen: 13 years, 1 month
|
Re: Spawn Ratio Calculator. [Re: norml840]
#7807003 - 12/28/07 10:08 AM (16 years, 3 months ago) |
|
|
Wow
I'm quite impressed to see another way to incorporate computers into mushroom growing and i thought the shroomery was all there was
i sincerely thank you for putting this togethor it will be a serious aid in the near future
--------------------
|
PinniesPlox
Deep in the bushes...
Registered: 09/05/07
Posts: 90
Last seen: 12 years, 4 months
|
Re: Spawn Ratio Calculator. [Re: anarchOi]
#7822566 - 01/02/08 03:55 AM (16 years, 2 months ago) |
|
|
Very practical. Extremely useful tool as well.
Watch the views for this thread exponentially increase as I'm sure many will refer to this future to come
Definitely going to help me in the future with some projects.
-------------------- I've got bigger blunts to smoke...
|
veda_sticks
Cultivator
Registered: 07/29/07
Posts: 14,191
Loc: UK
Last seen: 4 years, 2 months
|
Re: Spawn Ratio Calculator. [Re: PinniesPlox]
#7822586 - 01/02/08 04:24 AM (16 years, 2 months ago) |
|
|
Very nice, though i have never ever heard of a quart being used in the uk before.
Its always litres
Whenever i buy bilk its either 4 or 6 litres
When buy a can oh juice, its 440ml
When i buy orange juice is 1 litre.
-------------------- PF TEK - writeup by EvilMushroom666 Lets Grow Mushrooms - RogerRabbit & RoadKills website with sample videos plus the full PF TEK video series. Alot of great information - BUY THE DVD Cakes can and will pin! - So you think cakes suck for pins. Your wrong Franks Simple Coir/Verm Tek Franks Proper Pasturisation Tek Franks Spawning To Bulk - Monotub Professor Pinheads RTV Injection Port Tek Foo Mans No Soak WBS Prep Tek
|
Nibin
Getting there
Registered: 11/29/05
Posts: 4,480
Last seen: 10 years, 10 months
|
Re: Spawn Ratio Calculator. [Re: veda_sticks]
#7824070 - 01/02/08 03:01 PM (16 years, 2 months ago) |
|
|
Quote:
veda_sticks said: Very nice, though i have never ever heard of a quart being used in the uk before.
Its always litres
Whenever i buy bilk its either 4 or 6 litres
When buy a can oh juice, its 440ml
When i buy orange juice is 1 litre.
Have we Brits finally adopted metric? It must be at least 6 years since I was last in the U.K. and it was all pints then.
-------------------- Newcomers guide-----> For all things shroomy
|
shaggydogman
Stranger
Registered: 04/20/07
Posts: 672
|
Re: Spawn Ratio Calculator. [Re: Nibin]
#7825950 - 01/02/08 11:42 PM (16 years, 2 months ago) |
|
|
We use both, but pretty much everything you buy comes in metric. Beer still comes in pints
Jars and Tubs come in metric
-------------------- Rye -- WBS | Grain LC -- G2G | Bulk -- Monotub | 50/50 -- Late Casing -- A Pinning Strategy Disclaimer: My opinion is subject to change at short notice subject to but not limited by new information and knowledge being made available.
|
creekfreek
Certified phunologist
Registered: 01/26/08
Posts: 4,818
Loc: Right about here
|
|
This should come in handy.
|
navyseals101
Stranger
Registered: 09/16/04
Posts: 1,053
Last seen: 6 years, 9 months
|
Re: Spawn Ratio Calculator. [Re: creekfreek]
#8185823 - 03/24/08 12:56 AM (16 years, 8 days ago) |
|
|
is there any way to use this without Microsoft office?
-------------------- "Ten thousand flowers in spring the moon in autumn, a cool breeze in summer, snow in winter. If your mind isn't clouded by unnecessary things, this is the best season of your life." -wumen
Edited by navyseals101 (03/24/08 12:58 AM)
|
shaggydogman
Stranger
Registered: 04/20/07
Posts: 672
|
|
Edited by shaggydogman (03/24/08 02:10 AM)
|
navyseals101
Stranger
Registered: 09/16/04
Posts: 1,053
Last seen: 6 years, 9 months
|
|
^ I actually just mentioned excel viewer but I deleted that post because when opening the program with excel viewer you cant enter values...
I tryed clicking on the boxes and pressing numbers in but it didnt work..
any idea?
-------------------- "Ten thousand flowers in spring the moon in autumn, a cool breeze in summer, snow in winter. If your mind isn't clouded by unnecessary things, this is the best season of your life." -wumen
|
shaggydogman
Stranger
Registered: 04/20/07
Posts: 672
|
|
Excel VIEWER! Yeah makes sense, bad call there!
Just tried it using google docs (you need to sign up a google account) and it works there. http://docs.google.com/
If not then I'd certanly give OpenOffice a go...
-------------------- Rye -- WBS | Grain LC -- G2G | Bulk -- Monotub | 50/50 -- Late Casing -- A Pinning Strategy Disclaimer: My opinion is subject to change at short notice subject to but not limited by new information and knowledge being made available.
|
|