stainlessb
Member
qaStaHvIS yIn 'ej chep
Posts: 4,906
What I collect: currently focused on most of western Europe, much of which is spent on France, Belgium, Germany and Great Britain Queen Victoria
|
Post by stainlessb on Jan 22, 2019 21:04:26 GMT
I see various offerings, and I'm thinking this may be a better approach than handwritten notes , espeicially if I update more than a few times?
any suggestions?
I am on a Mac (just in case that matters)
Thanks
|
|
renden
Member
Posts: 9,162
What I collect: Canada-USA-France-Lithuania-Austria--Germany-Mauritius-French Colonies in Africa
|
Post by renden on Jan 22, 2019 22:40:03 GMT
What do you desire from a software program(s) ? Cheers !
René
|
|
kgvistamps
Member
Posts: 201
What I collect: British Colonies - King George VI from all countries and King Edward VII & King George V from the West Indies.
|
Post by kgvistamps on Jan 22, 2019 23:27:27 GMT
I use Excel, which is available for the Mac, or you might try Google Docs, I think they have an Excel like version for the Mac.
Anyway, you can customize it any way you like. Just determine the columns you want to track.
I make each country a worksheet and then list the stamps from the country in a row. (If it is a small wantlist you can just put it on one worksheet.)
If you are tracking what you own, I would add them as you purchase the stamps - or put every stamp you want and make a column labeled Wantlist - you can then indicate Yes/No for each stamp.
Across the top I have columns for Description, Perforation, Watermark, the Catalog or Catalogs you want to include, Catalog value, and if you want to you can have a calculated target price. It is pretty easy to set up, and can be downloaded to your phone or printed when you go to a show.
|
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110
|
Post by brightonpete on Jan 23, 2019 2:33:29 GMT
I'm on a Mac as well. I have tried lots of programs, but have settled on Numbers. Very easy to use, keep track of what you have, add to, subtract from, keep a running total of collections value and (eek) how much you have spent on it.
Some have extremely detailed spreadsheets, I keep mine fairly basic, and friendly.
Everybody with a Mac has Numbers!
|
|
stainlessb
Member
qaStaHvIS yIn 'ej chep
Posts: 4,906
What I collect: currently focused on most of western Europe, much of which is spent on France, Belgium, Germany and Great Britain Queen Victoria
|
Post by stainlessb on Jan 24, 2019 2:11:05 GMT
What do you desire from a software program(s) ? Cheers ! René Well, a better way to keep track of what I have... My handwriting is horrible and even I have at times a hard time deciphering what I wrote, so a database/spreasheet seems more practical, but EZStamp is pricey. I even contacted to see if they offered versions up to certain years, but it is apparentlly all or nothing kgvistamps and brightonpete- I had considered just building a spreadsheet -I have both Excel and Numbers- and while I deal with spreadsheets at work all the time- to build one for stamps of the world seemed a bit overwhelming.. but that may be my best option
|
|
tomiseksj
Moderator
Woodbridge, Virginia, USA
Posts: 6,385
What I collect: Worldwide stamps/covers, Cinderellas, Ohio Prepaid Sales Tax Receipts, U.S. WWII Ration ephemera
|
Post by tomiseksj on Jan 24, 2019 13:06:15 GMT
...I had considered just building a spreadsheet -I have both Excel and Numbers- and while I deal with spreadsheets at work all the time- to build one for stamps of the world seemed a bit overwhelming.. but that may be my best option An inventory spreadsheet doesn't have to be complex -- here is how I have mine:
|
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110
|
Post by brightonpete on Jan 24, 2019 13:46:17 GMT
Spreadsheets are easy. Just map out a way you want to keep track of stamps.
I start with a sheet for Definitives, one for commemoratives, semi-postals etc etc etc, then I make up a summary sheet showing totals.
Catalog number, date of issue, description, condition (M, U, CTO), grade(G, F, VF), price paid, cat. value & notes.
Of course you can keep as detailed a listing as you want, or just a basic listing if that's all you want. It's all up to you what you want to track
Most people I see who open up a spreadsheet (esp. Excel) are overwhelmed by all the cells displayed. Numbers isn't quite as bad. But you don't need all those cells, and you can spread the data out over different pages in the file to keep things simple. And if you have any questions, ask here, or google. Mr Excel website is great for Excel (IIRC) and Apple support forums for Numbers.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jan 24, 2019 15:28:03 GMT
What do you desire from a software program(s) ? Cheers ! René I had considered just building a spreadsheet -I have both Excel and Numbers- and while I deal with spreadsheets at work all the time- to build one for stamps of the world seemed a bit overwhelming.. Lots of work building & maintaining a WW spreadsheet from scratch - definitely overwhelming. One fairly easy possibility is making use of your pdf version of Scotts, provided your intention is not to get new editions yearly just for present values.
I know of collectors (not many) who use the pdf to add sticky notes to the item. When you hover over it, the message comes up. Easy to search, portable and your catalog and inventory in one. You can easily modify it anytime with the info you need and add info that might be specific to that issue like condition or need to upgrade.
|
|
angore
Member
Posts: 5,699
What I collect: WW, focus on British Empire
|
Post by angore on Jan 24, 2019 15:55:55 GMT
I am in the Windows world.
For my US collection, I have used Excel and have a lot of data in it. I designed it to filter how I want to view it.
For my worldwide collection, I use Stamp Manage
|
|
stainlessb
Member
qaStaHvIS yIn 'ej chep
Posts: 4,906
What I collect: currently focused on most of western Europe, much of which is spent on France, Belgium, Germany and Great Britain Queen Victoria
|
Post by stainlessb on Jan 24, 2019 18:58:52 GMT
Thanks everyone-
Lots of good ideas and I think I can come up with something manageable in Excel or Numbers (I've never looked at Numbers much as everything at work is Excel and I've built a number of multi-linked page spreadsheets) and I like the idea of PDF notes
Stan
|
|
Ryan
Moderator
Calgary, Alberta, Canada
Posts: 2,749
What I collect: If I have a catalogue for it, I collect it. And I have many catalogues ....
|
Post by Ryan on Jan 24, 2019 20:26:02 GMT
An inventory spreadsheet doesn't have to be complex -- here is how I have mine: One common issue with spreadsheets with a fair amount of info is trying to squeeze more of it on the screen. One thing I always do is to switch the font to Arial Narrow 10 point, which is still easy to read but leaves room for much more "stuff" on the screen (Steve, try clicking the "G" to highlight the entire "Date Purchased" column and then change the font, you'll see what I mean). And with my screen size / resolution on my laptop, I can also work with the zoom slider at the lower right - when I need even more stuff on the screen, I click the minus sign once to drop it to 90% and it's still easily legible. 80% and my eyes start to work a bit too much so I don't use that. Ryan
|
|
renden
Member
Posts: 9,162
What I collect: Canada-USA-France-Lithuania-Austria--Germany-Mauritius-French Colonies in Africa
|
Post by renden on Jan 24, 2019 20:41:54 GMT
I do not like spreadsheets, never used them in my prior life - like something that does the work for me my wife uses it to keep track of her "birding" and she is quite a birder We also keep the list of books we read with opinion in +,++,+++ etc.....that is all ! René
|
|
angore
Member
Posts: 5,699
What I collect: WW, focus on British Empire
|
Post by angore on Jan 25, 2019 12:41:20 GMT
To expand on my earlier comments, in my excel file I have a lot of columns for information (not always used) so would never fit all on a screen.
I use the group function to collapse sections (like anything to do with value) when not needed and also use the split view horizontally (like freezing columns) so you can see far left and far right columns at same time.
For catalog numbers (prefix, main number, suffix) I end up with 3 columns and then concatenate them to create the composite number so that is a 4th column. I will hide the first 3 most of the time except when entering new numbers.
Actually all this work helped me learn Excel for stamping and at work.
|
|
tobben63
Member
Stamp eat sleep repeat
Posts: 1,874
What I collect: I collect to much, world wide!
|
Post by tobben63 on Jan 25, 2019 12:59:53 GMT
|
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110
|
Post by brightonpete on Jan 25, 2019 13:37:00 GMT
I'd rather type than click click click!
|
|
tomiseksj
Moderator
Woodbridge, Virginia, USA
Posts: 6,385
What I collect: Worldwide stamps/covers, Cinderellas, Ohio Prepaid Sales Tax Receipts, U.S. WWII Ration ephemera
|
Post by tomiseksj on Jan 25, 2019 21:32:42 GMT
If you have a small monitor, the approach Ryan suggested above is a good one when using a spreadsheet to manage your inventory. I have a 22" monitor and haven't yet needed to scroll horizontally to enter or review data. Hiding infrequently used columns is also an option to provide increased visibility of the data most frequently entered/viewed.
|
|