How do you keep track of cigars?

[jfields]

Ask AI. I just asked it to create me a tracker and can send it to you. Shoot me your email. If you have Microsoft Excel on macOS, you should be good. All you'd do it:

1. Download the file
2. Open Excel for Mac
3. File - Open - Select the tracker
4. Start entering data or manipulate the tracker how you want.

I'm sorry, what language are you speaking?

 

[George Scott]

I'm not OCD, but I have a tendency to be a bit organized and like to track things. When I started buying I put everything in a spreadsheet. I don't track each cigar, but when I discard a box I cross it off in the spreadsheet (strike-though, I don't delete), so I'm not TOO bad. So glad I did, now I can see how many tens of thousands of dollars I've spent on cigars

 

[bfreebern]

I'm sorry, what language are you speaking?

Ask one of your kids, Grandpa.

 

[insight]

Pure grit and force of will.

 

[rbbrock]

Is that pretty much the same whether you are using IOS or windows?

I don't know about ios but it's pretty much the same on Windows and Android

 

[CigarStone]

John @jfields As an analytical person who spent my professional life as a project/business management consultant, I would suggest a multi-phase plan. For now, until you find the perfect answer, I would use the spreadsheet I sent you (after we teak a couple things) and get the stuff documented. This will be the first step of inventory and provenance. Almost certainly, you will be able to import that data into a more interactive app which will be able to do "almost everything" you want.

I know how busy you are so you don't have time to look into what Rod @Rod is doing with his idea but I have a feeling it might be close to what you need.

If you wait until you understand everything, you may never get the basic steps done.

 

[CigarStone]

I've tried notepads, notebooks, spreadsheets....and finally gave up. Like MaytagMan, I've got lots coming and going. Also, now that I'm retired I usually smoke 3 a day, so I'd be doing more data entry than smoking. I do write the 'humi date' (the date they went in my cabinet) and the source on the bottom of boxes, which is helpful. Between that and my amazing razor sharp memory, I'm only surprised occasionally; "...holy crap, I've got a box of THOSE..??..."...

Same here! My amazing razor sharp memory produces tons of information.

Most of it is

1. Where the hell did these come from?
2. Where the hell did those go?
3. Who has been playing with my spreadsheet?
4. I sure hope I never hid any money anywhere!

 

[SKYDIVNEKD]

Obviously, I'm not the norm(shocking)!! I "keep track" of them by keeping them in coolers, in the same room. That way, if I need to check the "spread sheet", I just open the lid and look! "Filing" is just as easy. Open lid, drop in, close lid! Download complete!

Floyd T

 

[jfields]

Same here! My amazing razor sharp memory produces tons of information.

Most of it is

1. Where the hell did these come from?
2. Where the hell did those go?
3. Who has been playing with my spreadsheet?
4. I sure hope I never hid any money anywhere!

All kidding aside, I've got a really good grasp of what I bought, how much I paid for it, and who I bought it from/when. As an example, I bought two boxes of Bolivar Corona Gigantes 2014 & 2015 from John @investandprosper at $450 each in late 2017, and he bought them from a certain vendor we all know in Australia at the time. I can also tell you those same cigars now go for around $2500-$3000 per box currently. I don't know why I can remember this stuff, but I couldn't tell you what I had for breakfast this morning. But, if I die, all that information dies with me currently.

 

[insight]

Obviously, I'm not the norm(shocking)!! I "keep track" of them by keeping them in coolers, in the same room. That way, if I need to check the "spread sheet", I just open the lid and look! "Filing" is just as easy. Open lid, drop in, close lid! Download complete!

Floyd T

 

[bfreebern]

All kidding aside, I've got a really good grasp of what I bought, how much I paid for it, and who I bought it from/when. As an example, I bought two boxes of Bolivar Corona Gigantes 2014 & 2015 from John @investandprosper at $450 each in late 2017, and he bought them from a certain vendor we all know in Australia at the time. I can also tell you those same cigars now go for around $2500-$3000 per box currently. I don't know why I can remember this stuff, but I couldn't tell you what I had for breakfast this morning. But, if I die, all that information dies with me currently.

Just have your kids shoot me a price, when the time comes

 

[CigarStone]

Just have your kids shoot me when the time comes

You can't have your own kids shoot you?

 

[herdingcats]

From what I'm reading, it sounds like I'm on the "too organized" side of things.

I use the boxpressd app for each individual cigar, in combo with a note in Google notes to keep track of what box each cigar is in, and in which humidor. I also add the intake date to each cigar before it's added to the collection.

It took significant time to get all of that detailed when I first set up the app. Not only did I document my collection as it existed at that time, but I was significantly adding to the collection and so each new addition took time. Now that the humidors are full, it rarely takes any time at all.

Obviously, information is a priority for me. The result is a collection of cigars I can view from anywhere in the world knowing what boxes have room for additions, and which cigars are properly aged. I can shop a cigar store in any city and know exactly where new additions will go. In addition, the app allows me to make and keep tasting notes. Anyone else using the app can find and compare notes creating a kind of crowd-sourced resource. I've been doing significant sampling of blends new to me, so this is helpful when considering new blends and whether I want to add a box of something recently sampled.

I love it. Great for me, and likely far too organized for others.

 

[CigarStone]

From what I'm reading, it sounds like I'm on the "too organized" side of things.

I use the boxpressd app for each individual cigar, in combo with a note in Google notes to keep track of what box each cigar is in, and in which humidor. I also add the intake date to each cigar before it's added to the collection.

It took significant time to get all of that detailed when I first set up the app. Not only did I document my collection as it existed at that time, but I was significantly adding to the collection and so each new addition took time. Now that the humidors are full, it rarely takes any time at all.

Obviously, information is a priority for me. The result is a collection of cigars I can view from anywhere in the world knowing what boxes have room for additions, and which cigars are properly aged. I can shop a cigar store in any city and know exactly where new additions will go. In addition, the app allows me to make and keep tasting notes. Anyone else using the app can find and compare notes creating a kind of crowd-sourced resource. I've been doing significant sampling of blends new to me, so this is helpful when considering new blends and whether I want to add a box of something recently sampled.

I love it. Great for me, and likely far too organized for others.

Not too organized, just not enough cigars!

 

[hydro-terp]

I dont really track what is in inventory but I do track what I have purchased. I have an excel sheet. It has formulas to calc Price Per Stick and savings off reg CP prices. I use da page as my measuring stick for purchases from anywhere based on a box purchase price. The date of purchase is when it lands at my door and goes into the wineador. The top row I can filter stuff by whats in each column. It also helps to decide what to smoke to limit rummaging through stuff especially in the winter with low humidity in the house.

I have another tab with a deal or no deal calculator.

Its handy for CP scorcher deals where the clock is ticking and you have to make a quick decision, even though its 20 minutes in the basket. The sale price and reg price cells have simple formulas for calculating PPS. The savings cell has a formula to calc the % savings off everyday prices at CP with a box purchase and the deal or no deal cell has a formula that triggers a "Deal" or "No Deal" prompt based on % off. Right now I have it set to show deal if the savings is greater than 25% off reg price. Ive found it to be really helpful as some of those scorcher deals arent scorchers. Its not perfect as some get discounted more then others but thats what your brain is for.

HT