Welcome to the Growery 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!
Here is my spreadsheet that I use to track costs. It's set up for nutrients, Canna based but can take any 10 products. Just edit the appropriate cells and it will calculate:
Day number in flower nutrient strength individual cost of nutrients per day/cumulative percent cost of each nutrient Oz/gallon pot size electricity used grams per watt of light grams per kw-h of all electricity used grams/sq-ft Nutrient, electricity and total costs per gram/ounce/pound
Its pretty easy to use once you get used to it. I just went through and updated a lot of the formulas to not show any errors. Everything appears to be working but let me know if you find anything.
The first thing you'll want to do is check out the Example tab with all the explanations. Then switch to the Vars tab and change the product names to reflect your nutrients. Enter the price paid and size container. There is a cost estimator based on water consumption and rate of each additive. Then go to the Elec tab and rename the variables and watts used and how many hours per day to figure the total wattage consumed per day.
Set your nutrient info up, change the labels and they will change everywhere in the book
Electricity info, set the rate, tax rate and enter the wattage each piece of equipment uses and hours it is used per day.
Create a copy of the Template and rename it to whatever reflects your current grow. On that log sheet enter the flower start/end date (or estimated end date) and copy over the electricity information from the light gray text next to their boxes. Fill in the amount of nutrients you use each time you water and eventually enter the total yield.
If you set up your variables correctly it should give you a pretty accurate cost analysis. As you can see from the example, it cost me $8.38 per ounce of quality bud. There is no trim input (yet.)
If anyone who uses hydro, like set amount of water/nutrients per week wants to fill out a mock report to see how it works that'd be great--I wouldn't need to wait a few months for someone to finish using it. Just fake the dates a week apart and use past harvest weight.
What I really want to know is if there is enough "equipment" rows. I figure you could just add your AC to lights, since that's what's causing its use. 1000w lighting plus 1500w cooling it
With alternative lighting sources now coming into the realm, the real test of overall garden efficiency is the gram/kw-h of total electricity used. The days of grams per watt of light will not transfer well between the different light sources since there is more or less equipment to support that light source. Moreover, it accounts for the total amount of time used, be it 8 week or 12 week, we can directly compare.
I think I've got all the essential information, but there's always something that I could add. Every time I thought I was done I found myself changing and adding a few more things.
I used to have it create a nutrient concentration graph as time went on but I found it was really not needed. If anyone wants one though I could toss in an xy scatter plot no problem.
-------------------- Authorized Medical Marijuana patient. Any help given is for educational purposes only. Its your responsibility not to break any applicable laws.