My New Cigar Labels!

[stroke]

As some of you may know, I'm a little OCD... I label all of my cigars, but I've taken it a step further! I now have them all inventoried on an Excel spreadsheet with all of my cigars on it, including all the basics on the label as well as where I got it, when, MSRP, what I purchased it for (always good to know when you got a good deal!), where it's stored, etc. I also have a tab set up to show me how many I have where. Instead of trying to include all the information on the label, I gave each cigar a serial number that corresponds with the tracker. And, I added a little somethin' somethin' on the label. Let me know what you think!

By the way, here's where it all began: http://www.botl.org/community/forums/showthread.php?t=33975

 

[mwlabel]

VERY cool! If I had a more impressive inventory, I would kill to have something like this :thumbsup:

 

[themoneycollector]

Missing a barcode :rofl:

 

[stroke]

Missing a barcode :rofl:

I seriously considered it... but then I'd need to figure out how to read it with my phone, how to link to the spreadsheet, etc... Didn't seem worth the headache!

 

[gibbleguts]

Wow little tiny OCD. Can I put you on retainer to do my cigars the same way? Let me know how many cigars it would cost? Seriously though great system if you can maintain it but I am way too lazy to even think about it

 

[TravelingJ]

Wow little tiny OCD. Can I put you on retainer to do my cigars the same way? Let me know how many cigars it would cost? Seriously though great system if you can maintain it but I am way too lazy to even think about it

Yeah, no kidding. I had all my cigars inventoried at one point, but let it slide. I just didn't always want to hop on the computer each time I smoked a cigar, and my biggest issue was moving cigars from home storage, locker storage, friends house storage, and travel humi storage.

I would be interested in the spreadsheet if you are willing to share it!

 

[orangedog]

I would be interested in the spreadsheet if you are willing to share it!

Indeed - always looking for ways to improve inventory tracking!

 

[danthebugman]

Seriously though great system if you can maintain it but I am way too lazy to even think about it

Same here...think of all the cigars I could smoke instead of sitting there labeling things :ccowboy:. Good system though :thumbsup:.

Dan

 

[SuprHasan]

Wow little tiny OCD. Can I put you on retainer to do my cigars the same way? Let me know how many cigars it would cost? Seriously though great system if you can maintain it but I am way too lazy to even think about it

Aaron, the attached file should be sufficient for your collection.

 

[GoingPostal]

Aaron, the attached file should be sufficient for your collection.

:rofl: Classic

 

[stroke]

Wow little tiny OCD. Can I put you on retainer to do my cigars the same way? Let me know how many cigars it would cost? Seriously though great system if you can maintain it but I am way too lazy to even think about it

Guessing that was in jest, but just in case: just the cost of shipping the labels, which looks like it'd be about $3. If u sent me a list of all of your cigars I'd inventory them for ya!

Yeah, no kidding. I had all my cigars inventoried at one point, but let it slide. I just didn't always want to hop on the computer each time I smoked a cigar, and my biggest issue was moving cigars from home storage, locker storage, friends house storage, and travel humi storage.

I would be interested in the spreadsheet if you are willing to share it!

I used the Avery Wizard to transfer the info from the tracker to the labels, but I should only have to do that the first time. From now on, I'll just enter them in individually.

On the "Location Totals" tab, simply change the value in row 1 to reflect the amount of cigars in the location you wish, and make sure it's typed the same way is the location on the main tab. I included a black photo of the BOTL logo on the labels sheet in case you're interested, but I chose to save some ink and inverted the colors. Enjoy!


Cigar Labels

Aaron, the attached file should be sufficient for your collection.

:headroll:

 

[vivalanation734]

Holy OCD, Batman!

Wish I had the time and/or energy! lol

Nice set up.

 

[SkinsFanLarry]

Definately a nice set-up Brian....what I want to know is do you smoke'em at the same time you are labeling them?

 

[stroke]

Definately a nice set-up Brian....what I want to know is do you smoke'em at the same time you are labeling them?

Unfortunately, no. Unlike you, I'm unable to light 'em up in the house!

 

[SailorAg]

Ever considered running a B&M? You're inventory system would be the envy of the industry! :smokingbo

 

[TravelingJ]

On the "Location Totals" tab, simply change the value in row 1 to reflect the amount of cigars in the location you wish, and make sure it's typed the same way is the location on the main tab. I included a black photo of the BOTL logo on the labels sheet in case you're interested, but I chose to save some ink and inverted the colors. Enjoy!

Thanks! I have downloaded it and will toy with it in the morning after work. The issues I've had with tracking, and the existing tracking softwares out there, is that I move cigars from location to location fairly regularly. Your sheet actually gives me some ideas on how to pull that off. I'll let you know what I come up with!

 

[mcroom]

Stroke that is very cool! I have a spread sheet that was sent to me form a year ago but I have not found the time to inventory and did not want my sticks exposed to low RH that long. Maybe one day. I love the BOTL on your label.

 

[ciggy]

Wow little tiny OCD. Can I put you on retainer to do my cigars the same way? Let me know how many cigars it would cost? Seriously though great system if you can maintain it but I am way too lazy to even think about it

Yea...I'm not to good at doing that either. Very cool though Brian!

 

[stroke]

Ever considered running a B&M? You're inventory system would be the envy of the industry! :smokingbo

I have! My heart is telling me yes, but my pocketbook is telling me no :agreesmil

 

[tobii3]

Holy Hell.

That's beyond OCD. WAAAAAAAAAAAAAAAAAAAAAY beyond OCD....:laugh:

OCD is when you have one of these -