Login

u/UFO_Airsoft

r/ukmedicalcannabis
Image 1 — 🪵Smoking Log - I finally cleaned up my medical cannabis tracker enough to share it!
Image 2 — 🪵Smoking Log - I finally cleaned up my medical cannabis tracker enough to share it!
Image 3 — 🪵Smoking Log - I finally cleaned up my medical cannabis tracker enough to share it!
Image 4 — 🪵Smoking Log - I finally cleaned up my medical cannabis tracker enough to share it!
▲ 7 r/ukmedicalcannabis

🪵Smoking Log - I finally cleaned up my medical cannabis tracker enough to share it!

A couple of days ago I posted some screenshots of the Google Sheets tracker I'd been building to keep track of my medical cannabis.

It originally started as a very basic spreadsheet to remember which strains I'd tried... and then it slowly grew into something much bigger.

After spending the last couple of days polishing it up, fixing bugs and simplifying the workflow, I think it's finally at a point where I'm happy to share it.

I've called it 🪵Smoking Log.

It includes things like:

🍃 Inventory management

📝 Session journal with automatic lookups

📊 Dashboard with live statistics

🌿 Curated terpene library

🏆 Confidence-adjusted rankings for strains, suppliers, and terpenes

🎯 Personal ratings for Aroma, Flavour, Mental, Physical, Smoothness, and Enjoyment

Everything runs entirely inside your own copy of Google Sheets.

No accounts.

No subscriptions.

No data collection.

I've included a Google Drive folder containing:

• Blank template

• Example workbook

• README

• Changelog

Download:
https://drive.google.com/drive/folders/1c1S9gCBtPimAj6WmYGlONYFfFkaT7Bqs?usp=sharing

This isn't intended to recommend strains or make medical claims—it's simply a way of organising and analysing your own experiences over time.

If anyone gives it a try, I'd genuinely appreciate hearing what works, what doesn't, and any ideas you have for improving it. It started as a personal project, but if it ends up being useful to other people too, that'd make all the hours spent building it worthwhile.

Hope someone gets some use out of it. 🍃

u/UFO_Airsoft — 12 hours ago
▲ 34 r/ukmedicalcannabis

I got tired of trying to mentally track which strains actually worked for me and I enjoyed, so I went a little overboard with Google Sheets and built this semi-automated tracker for myself. I'm wondering if anyone else might find this useful for themselves?

I've been prescribed medical cannabis for a while now and realised I kept asking myself the same questions.

"Did this strain work for me previously?"

"How consistent is the quality of this supplier?"

"Was this the terpene that I enjoyed last time, or am I remembering a different one?"

I started with a really basic spreadsheet that was just meant to keep track of my tubs... and then I got a bit carried away.

It's now turned into a full Google Sheets workbook with Apps Script automation that tracks things like:

  • Current inventory
  • Batch history
  • Supplier performance
  • Review history
  • Terpene profiles
  • Personal ratings (mental, physical, smoothness, overall)
  • Dashboard summaries
  • Charts and analytics

This isn't intended to recommend strains or make medical claims; it's simply a way of organising and analysing my own experiences over time.

It's all based on my own reviews rather than trying to make general claims about cannabis.

I've finally reached a point where it feels stable enough that I think other people might actually find it useful too.

I've attached a few screenshots with this post. If there's enough interest, I'm happy to share a free template version along with the example version in my screenshots and I'd genuinely appreciate any feedback or ideas for improving it.

I'd be interested to know:

  • Is there anything you'd want a tracker like this to do that mine doesn't?
  • Do you currently keep records of your prescriptions, or do you just go from memory?
u/UFO_Airsoft — 2 days ago