best value of bud
docs.google.com
Sheet1 price per gram of THC product,grams g,dollars $,thc %,cbd %,$ per g,g of THC per jar of weed,price of jar / (grams in jar x % of THC as decimal) Levin HealthTHC 26% IndicaTHC 26% : CBD <1%$279Herb, Dried - 30g,30,279,26,1,9.3,7.8

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

  • scrion@lemmy.world
    4·
    3 days ago

    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).

    • Aubmaire@lemmy.worldOP
      2·
      3 days ago

      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)

  • Album@lemmy.ca
    3·
    3 days ago

    I did this in my area for the first few years of legalization in my country because prices were confusing. I was even able to calculate it down to dosage for various delivery methods (eg. smoking is less effective than vaping is less effective than edibles) so I had dosages and effective dosages per dollar and then you can even calculate out uses per package from that. Prices in Canada plummeted 4 years after legalization so it stopped being as relevant. Like it’s $29 cad for 1g of 80%+ distillate in a 510 vape cart and $100 for an oz of 25%+ thc flower. With prices that low for quality that high the choices are pretty easy.