I'm trying to make a list of my stamps by catalog number. I would like to add numbers while sorting the stamps, so I might get something initially like this: 234, 465, 279, 863, 396a, 469B, 396, etc. then sort the numbers in ascending order to get, e.g., 234, 279, 396, 396a, 465, 469B, 863
I tried putting them in a spread sheet column and hitting the sort ascending button, but all the ones with letter suffixes got ordered separately.
Any tricks to get around this problem?
Last Edit: Dec 26, 2016 15:04:53 GMT -5 by Butterfly
Post by Philatarium on Dec 26, 2016 15:20:04 GMT -5
I've definitely run into this problem before, because catalog numbers don't necessarily run in pure alphanumeric sequence. What I've ended up doing in situations like this is to actually have an additional column that I sort off of. It's not much more work.
In your example, I would do something like this:
234, 465, 279, 863, 396a, 469B, 396
Scott sequence #
I actually have some rules I use about the digits to the right of the decimal, so that I can sequence sets, mnh vs mh vs used, etc., because I'm trying to do this in a database where consistence is helpful.
I also "pre-pend" large numbers to catalog numbers like this:
"B" prefixes get 15,000 "C" prefixes get 20,000, etc.
So, B451 would be 15451, and so on.
Because Japan has the unusual "Z" prefix, which appears right after regular issues and before semi-postals, that's what I assign the 10,000 prepend to. So Z363 would be 10363.
Obviously, as long as you're reasonably systematic about it, you can do whatever makes the most sense for you personally.
To sort catalog numbers, especially by Scott, try the below. Since you seem to be using EXCEL, or something similar, the process is relatively easy.
1. Right Justify the catalog number column, including prefixes. 2. Sort the catalog number column. 3. Left Justify the catalog number column.
Realize that the sort order for numbers is: B1 , B10, B100, etc.. Therefore, insure that all numerics are the same length with leading zeros, at least 4 or 5 digits, i.e., B0001, B0010, B0100. This is accomplished using Formatting and/or Padding. After sorting, Formatting can be used to delete the leading zeros. There are many EXCEL sites describing how to accomplish this. It may be a little complicated, but not overly complicated.
Unfortunately I do not have EXCEL on my computer. If I did, I would send you the functions needed.
Last Edit: Jan 1, 2017 7:22:28 GMT -5 by JerryB: Changed Search to Formatting
JerryB, Thank you. Now I have yet another way to do it 3920004554
I finished one series already and ran into another problem at the end. Maybe you all also know how to get around this new problem?
I'm using open office, which when you open a new file you get to choose text document, spreadsheet, presentation, drawing, or database. I knew you could sort in spreadsheet mode so I went there. When done I wanted to change the result to a text document, but couldn't figure out how to do it. Copy/pasting the columns of numbers into a text file just gave me an image rather than text. My 'gut' told me there might be a way by exporting as a PDF and then doing something sneaky.
My 'gut' told me there might be a way by exporting as a PDF and then doing something sneaky.
I'm using OO's cousin, LibreOffice, but this should work anyway.
From the Edit menu (Later: I meant with an OO Writer document open; serves me right for looking at this forum before imbibing caffeine), choose Paste Special. (Just going Ctrl-Shift-V might work, too; keystrokes can be a bit squonky in Open/LibreOffice.)
That should give you the option to paste as unformatted text.
Post by zepherusbane on Jan 1, 2017 11:10:01 GMT -5
There is almost always a "save as" function in the file menu of these kinds of software, it's been too many years since I have used open office to recall if it had this, but you can check.
If you find "save as" and select it, you probably will see a box with a way to give your file a new name, but also a drop down that lets you select whatever other types of file you can save as, in that list will almost certainly be text.
Worldwide collector of stamps and covers! I gave up on limiting to only certain countries.
I gave up on trying to sort in excel since you had to use leading zeros. etc. to make it work correctly. Since I have a master list, I just put them in order.
Now realize Scott does have priorities that go against a sort. For example, if there is a stamp with Scott #3000 and then Scott #3000A (a major catalog number) and there is a minor variety of #3000 (#3000b) the correct sort would be
#3000 Issue 1 #3000b minor variety of Issue 1
#3000A Issue 2 #3000Ac minor variety of Issue 2
I track prefix, base number, suffix in separate columns and the use =CONCATENATE(N8828,O8828,P8828) to combine to make a nicer number presentation. I end up using groups to collapse columns. With columns for sorting filters, I can create views (always in catalog order) using quick filters.
I try to keep a running number in a column (1,2,3...to end of rows) just in case I accidentally sort by any row. I never sort - just filter.
I tried the save as and paste special features without success, but then discovered a sort feature hidden in the table menu of the text document. I'll go with that next. Groups and filters sound intriguing, though I expect the truism about old dogs and new tricks applies here for me.
EDIT: Thanks also madbaker, Just now caught up with your post. Love seeing see all the different ways we go about this task.
Last Edit: Jan 2, 2017 9:26:01 GMT -5 by Butterfly
I have made a inventory for my stamps In my documents.
First a file titled World Stamps in this file I add folders with the country name, eg Germany each stamp I have is scanned cropped and saved at 500pix the title is then added eg 1964 SG1345 year first Cat No next and prefix last this will follow alpha numeric order.
This can be made to suite your needs, I started this to store images of stamps to post on may web site (which has gone now) I will see if I can and an image to this thread.
We are Happy to have you here!! New members, we would love to get to know you. Please feel free to introduce yourself HERE
Otherwise - Jump right on into the conversations!! We look forward to your participation.
If you are not a member yet, register today!! It's all free and we want to hear from you!!
Please share our site on social media networks. Thanks!!!