My handwriting is shitty and labels are super tiny. Is anyone using a printer to print labels with source/date/etc. on them, or does everyone hand-write?
Label printing
- Thread starter Senor Perfecto
- Start date
I hand write on printer paper honestly.
Edyy5750@yahoo.com send it yo
i'll take it too. jay (dot) bruner (at) gmail (dot) com
Shadowcam is a boss.
cgraunke
BoM March '14
Those look good! They're just a different end goal than what I wanted.
I put this together because I wanted a clean, legible (my handwriting is NOT) way to reference, with multiple lines of text, and I didn't want to have to buy sheets of special pre-cut/perforated paper.
(And, if you want to add a graphic like that and need help, just ask, it's easy enough.)
https://www.dropbox.com/s/yyvph7riz5q8emn/cigar%20labels.xls
I decided it was easier to just share a dropbox link, but I'll still email it to all who sent me PMs as well.
You'll see three worksheets in this file:
- The first is the blank template that will yield a column of 3" x 1" blocks on the left, a column of 2.5" x 1" in the center, and another column of 3"x 1" blocks on the right.
- The second sheet is just an example of some that I printed early on.
- The third sheet is a RG conversion chart I put together if you ever want to measure/identify an unknown cigar.
From the conversion chart, you can see that the 2.5" paper will cover everything 50 RG and below (great for lanceros, coronas, etc.) and the 3" paper covers up to a 60 RG.
For those not familiar with more in-depth usage of Excel, to do multiple lines within a cell, press "Alt+Enter" (if you just press enter it will leave the cell you're in and move to the cell below)
Once printed, I take these and dice them up on a paper cutter, columns at 3", 2.5" & 3" as noted above, rows as every 1", then just wrap and affix with a small piece of tape.
If you don't have a paper cutter in your household, a ruler (many are exactly 1" thick and make for easy 1" cuts that way) and a razor blade make short work of the cutting
Easy, clean, legible, and no special purchases. I hope some find a use for this - enjoy!
cgraunke
BoM March '14
Also, for anyone without the Microsoft Office Suite, you can download a free open-source version of similar software from openoffice.org
I am not affiliated in any way, so I can't provide any support if you have issues, but I have successfully used it on multiple personal installations.
It allows you to open, edit, and save in standard Microsoft Office file formats and should interface back and forth seamlessly.
I am not affiliated in any way, so I can't provide any support if you have issues, but I have successfully used it on multiple personal installations.
It allows you to open, edit, and save in standard Microsoft Office file formats and should interface back and forth seamlessly.
Google docs is also "free" isn't it? You can also edit it from your Android phones
cgraunke
BoM March '14
Could very well be!
Does it read/write MS Office file types?
I'm going to have to check that out.
Thanks Edwin!
I believe so. Been awhile since I've used it though.