I am clueless in the ways of spreadsheets, but I can fill them out if someone else designs them. So do any of you have a spreadsheet to log tobaccos? I'd like to keep track better than I do.
Anyone Have A Spreadsheet To Share?
- Thread starter jrharrigan
- Start date
PipesMagazine Approved Sponsor
Site Sponsors
PipesMagazine Approved Sponsor
PipesMagazine Approved Sponsor
PipesMagazine Approved Sponsor
PipesMagazine Approved Sponsor
First requirement is to be afflicted with OCD (Obsessive Compulsive Disorder).
I once kept a cellar book. Several months later I found that long lunches and going into the cellar repeatedly for more bottles of wine while inebriated does not lead to tidy book-keeping.
I once kept a cellar book. Several months later I found that long lunches and going into the cellar repeatedly for more bottles of wine while inebriated does not lead to tidy book-keeping.
I used to, at the beginning of the journey, but at some point I kept adding tobacco to the cellar and now I am at a complete loss as to what I actually have cellared. I since began to appreciate the excitement of stumbling upon blends I simply forgot. ?
I don't really have a system for acquiring tobacco, I walk into the store and if they have something I have tried before or that simply stands out I purchase everything they have of that tobacco.
In the beginning, I would transfer everything to mason jars, now it's round tins piling up everywhere and only the occasional opened tin or rectangle/paper tin that makes it to the jar - saves money for more tobacco.
I don't really have a system for acquiring tobacco, I walk into the store and if they have something I have tried before or that simply stands out I purchase everything they have of that tobacco.
In the beginning, I would transfer everything to mason jars, now it's round tins piling up everywhere and only the occasional opened tin or rectangle/paper tin that makes it to the jar - saves money for more tobacco.
Happy to build you one if you know what inputs you want to track.
Guessing:
Guessing:
- Purchase date
- Manufacturer
- Blend
- Type
- Quantity
- Notes
This looks right. I am interested in a grand total on the weight too.
I'd appreciate whatever you could do. I would like the order to be: Manufacturer, blend, date, weight, notes...with a total weight at the bottom, if that makes sense.
You can make a copy of this. It will do what you mentioned you wanted. The total weight is at the top, so you don’t have to scroll. Enter the quantity in ounces.
docs.google.com
Cellar Template
Used to generate monthly reports to guys who make whole lot more coins than I do. Purely based on my principles, I refuse to do that for tobacco.
@jrharrigan
I had the permissions set wrong, but anyone with the link can now see it. It’s best to make your own copy if you don’t won’t @BROBS messing with your cellar inventory. ?
I had the permissions set wrong, but anyone with the link can now see it. It’s best to make your own copy if you don’t won’t @BROBS messing with your cellar inventory. ?
Here is my spreadsheet. Make a copy for yourself and clear out information. Just to let you know the Age Date field is a formula so don't clear that column out.
Google Sheets: Sign-in
Access Google Sheets with a personal Google account or Google Workspace account (for business use).
docs.google.com
