I made a spreadsheet for comparing the available buds against price and THC content.
I made a spreadsheet for comparing the available buds against price and THC content.
Sheet1 product,grams g,dollars $,thc %,cbd %,$ per g,g of THC per g of weed,price of jar / (grams in jar x % of THC as decimal) <a href="https://circuit.montu.com.au/product-detail/190">ConcessionGreenaGreena IndicaTHC 22% : CBD <1%$85Herb, Dried - 10g</a>,10,85,22,1,8.5,2.2,38.63636364 <a href...
I wanted to figure out how to get the best bang for my buck from the buds available to me. I'm Australian and have a prescription for medicinal weed.
I like getting value for money but also a left over from black market purchasing avoiding getting scammed. In Australian black market, generally you want at least 28g (an ounce) for $350 AUD, at least it was last time I checked. this works out to $12.50 a gram.
The buds I'm currently getting are $13.90 a gram, this is absolutely worth it, the quality of THC content and curing are phenomenal! but after completing this exercise there are buds that are under $10 a gram which is what I'm going to ask about at my next check in.
ultimately the calculation is price of jar / (grams in jar x % of THC as decimal)
the lower the number, the better the value (in my opinion)
I also need to let you know that I managed to get this calculation from chatgpt by asking it and telling it what I was trying to achieve. I still don't actually fully understand what multiplying the grams in jar by the THC% decimal is doing. My mathematics literacy has diminished since highschool. I only landed on the above calculation because I could see in my spreadsheet that it looked about right haha.
I'd love to know if this is useful and if you're into maths, an explanation of what is happening
have a good weekend y'all
You're viewing a single thread.
So you created a spreadsheet in order to determine the THC/cost ratio as a factor, but then you did not sort your rows based on that factor?
Multiplying by the percentage shifts the calculation to determine the price of THC, not the price of the weed overall.
Example: You have a jar with 100g of weed you bought for $900 (bulk discounts ignored). You know the weed has a THC content of 22%, which equals a factor of 0.22. Multiply the 100g in your jar by 0.22 and you get 22g of pure THC in that jar. 900/22 means around $41 per gram of THC.
That way, you can easily compare price to THC ratio, that is, you will know how much you paid for a gram of THC, not for a gram of weed.
Put that new value (cost of THC per gram) into a new column and then start sorting all of your rows by that value in ascending order. Thay way, you can instantly look at the optimal entry (the top one), but also determine similar products, for example if your source is out of the best product, or it's generally unavailable for someone without re-scanning the whole table (making it pretty useless).
yeah it seems the filter resets to how I pasted the info in. sharing permissions aren't allowing you to use the filter, sorry about this.
thanks for explaining. I understand what's going on now.
image with filter applied. (theoretical bulk bud just for experimenting)
