Stamp Community Family of Web Sites
Stamp Community Forum
Username:
Password:
Save Password
Forgot your Password?

Welcome Guest! Need help? Got a question? Inherit some stamps?
Our stamp forum is completely free! Register Now!

What you use for your inventories ?Excel of dB programs ?  
 

Next Page    
 
To participate in the forum you must log in or register.
Author Previous Topic Topic Next Topic
Page: of 2
Valued Member

United States
352 Posts
Posted 12/13/2012   7:47 pm  Show Profile Bookmark this topic Add tikithindi to your friends list  Get a Link to this Message
I was qurious about what others use for Stamp collection Inventories.
I use Excel spreadsheet.

tikithindi
Send note to Staff

Pillar Of The Community
United States
6391 Posts
Posted 12/13/2012   7:48 pm  Show Profile Bookmark this reply Add khj to your friends list  Get a Link to this Reply
Excel is sufficient for my needs.
Send note to Staff  Go to Top of Page
Bedrock Of The Community
Australia
17707 Posts
Posted 12/13/2012   7:49 pm  Show Profile Bookmark this reply Add rod222 to your friends list  Get a Link to this Reply
Windows explorer.
Best database on the planet.
Send note to Staff  Go to Top of Page
SCF Advertiser
Australia
113 Posts
Posted 12/13/2012   7:56 pm  Show Profile Check koalastamps's eBay Listings Bookmark this reply Add koalastamps to your friends list  Get a Link to this Reply
I think Excel is perfect for keeping an inventory, especially for insurance purposes.

For organising a large collection, keeping detailed scans, notes, want lists, lots of specialised stamp data, and lots of ready made reports, I like both StampCAT and EZStamp.
Send note to Staff  Go to Top of Page
Valued Member
Learn More...
United States
296 Posts
Posted 12/13/2012   9:04 pm  Show Profile Bookmark this reply Add Art Strohmeier to your friends list  Get a Link to this Reply
Reprinting from an earlier post.

Prior to acquiring Stamp software, to computerize my inventory I developed Excel spreadsheets with the following features:

Separate spreadsheets (tabs) for each country. I have mine in two physical files, but they will vary according to the physical characteristics of the inventory and the ability to consolidate them.

Summary data: the First Tab in a file contains a summary of values for all countries, (I also identify the name of the ‘collection' in the summary, which ties to album, etc. ) I also plug in the values from the COTS software for supported countries in order to get a full valuation of the inventory.


Values are linked from the summary to the country spreadsheets so they change automatically with updates. A grand total for all countries is also calculated. I have tabs for approximately 250 countries, with the bulk being in US, Germany, New Zealand, and British Commonwealth, including Australia, and Canada. For many countries, I have less than $50.00 worth.

Detail data:
I enter stamp attributes necessary to identify it, without having to resort to the Catalog.
(Scott#, Year, Illustration #, Subject, color and denomination. I chose not to keep Perf or WM's.) My COTS stamp software also identifies ‘location' which is implied, in the Calculated summaries of total costs for singles, for blocks, and for totals of singles and blocks.

Calcs for blocks vary; a) individual stamp price * No. in the block)
b) fixed price per block
c) For US blocks, Zip Block Value, Plate Block value, and remainder.
Calculations for plateblocks are embedded in the cell formulae.

Quantity; both of number of singles and Plate blocks
Comments; both in the ID data and before the price section.
Price info; both of Singles and Plate Blocks.

Prior to each Group Classification (Regular Issue, Semi-Postal, Air Post, ) source of the data
is identified; specifically Year of Scott Catalog, Volume, Starting Page of the section, and summary calculation of total for that section . I find this invaluable in trying to review the source of previously entered data. Where data is cumbersome, ‘Rhodesia' for example, includes ‘Northern Rhodesia,' ‘Southern Rhodesia' and ‘Rhodesia.' I include all in the same spreadsheet, but it's personal preference. I find the same issue with ‘Palestine.'

Some customization may be necessary: US vs. foreign; For U.S., I like to calculate the book value of the single and block issues. Since I have purchasing info for only two countries (US and New Zealand,) I haven't included a provision to enter purchase price and resulting profit/loss calculations.

Let me also say that documenting the value also works well with albums, by preceding the data with a page number.
Send note to Staff  Go to Top of Page
Valued Member
United States
106 Posts
Posted 12/13/2012   9:40 pm  Show Profile Bookmark this reply Add stampcoder to your friends list  Get a Link to this Reply

Quote:
Windows explorer.
Best database on the planet.




Send note to Staff  Go to Top of Page
Valued Member
Canada
169 Posts
Posted 12/13/2012   9:41 pm  Show Profile Bookmark this reply Add serious collector to your friends list  Get a Link to this Reply
My preference is Excel fine tuned for my needs.
Send note to Staff  Go to Top of Page
Valued Member
Canada
169 Posts
Posted 12/13/2012   9:42 pm  Show Profile Bookmark this reply Add serious collector to your friends list  Get a Link to this Reply
My preference is Excel fine tuned for my needs.
Send note to Staff  Go to Top of Page
Valued Member
Canada
169 Posts
Posted 12/13/2012   9:42 pm  Show Profile Bookmark this reply Add serious collector to your friends list  Get a Link to this Reply
My preference is Excel fine tuned for my needs.
Send note to Staff  Go to Top of Page
Valued Member
Canada
169 Posts
Posted 12/13/2012   9:42 pm  Show Profile Bookmark this reply Add serious collector to your friends list  Get a Link to this Reply
My preference is Excel fine tuned for my needs.
Send note to Staff  Go to Top of Page
Pillar Of The Community
Canada
4090 Posts
Posted 12/13/2012   10:13 pm  Show Profile Bookmark this reply Add lithograving to your friends list  Get a Link to this Reply
Inventories....spreadsheet.....Excel....StampCAT and EZStamp.


Man you guys are serious collectors.

I used to draw a line under the number in the catalogue of
what I had.
I gave it up years ago, too complicated.
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
6391 Posts
Posted 12/13/2012   10:49 pm  Show Profile Bookmark this reply Add khj to your friends list  Get a Link to this Reply

Quote:
Man you guys are serious collectors.

Yes, we even post in quadruplicate.

Send note to Staff  Go to Top of Page
Pillar Of The Community
Learn More...
United States
2187 Posts
Posted 12/13/2012   11:52 pm  Show Profile Bookmark this reply Add Partime to your friends list  Get a Link to this Reply
I use StampManage. Lots of nice features, and good up-to-date values for the areas of interest to me. Plus, if you upload some of your own pictures, they give you a free update for the following year.
Send note to Staff  Go to Top of Page
Pillar Of The Community
Australia
3519 Posts
Posted 12/13/2012   11:55 pm  Show Profile Bookmark this reply Add tonymacg to your friends list  Get a Link to this Reply
I'd say it all depends on what you want your inventory to do.

I maintain mine to value my collection, and aid my heir & successor when she has to peddle my collection around the auction houses. I use Excel spreadsheets to track all items valued in Gibbons at £10 or more year by year. That cut-off point should exclude items not worth bothering about, from a valuation viewpoint.

As I have lists for every catalogue year since 2002, and some years before that, this method also has the interesting side benefit of showing up trends in pricing. So it shows me, for example, that this little Cochin stamp



has gone from £3.50 in 2004 to £11 this year. It doesn't really matter what multiple of catalogue value you apply: it's still tripled over 10 years. Very useful information to have
Send note to Staff  Go to Top of Page
Pillar Of The Community
United States
797 Posts
Posted 12/14/2012   01:41 am  Show Profile Bookmark this reply Add jbcev80 to your friends list  Get a Link to this Reply
Hi

I use WORD files. I have Inventory files and a Valuation file. This system is a carry over from a mainframe system I wrote in the 1980's. My inventory is maintained by VBA (Visual Basic For Applications) programs that I have written.

Jerry B
Send note to Staff  Go to Top of Page
Bedrock Of The Community
Australia
17707 Posts
Posted 12/14/2012   02:00 am  Show Profile Bookmark this reply Add rod222 to your friends list  Get a Link to this Reply

Quote:
Windows explorer.
Best database on the planet.


Yes Indeedee,
My inventory consists of images, excel databases, notes, receipts of purchase, value trends in my desired areas, books, CDRoms, *.pdf's
Anything you care to name.

I have over 1,000,000 stamp images, and I can (generally)
retrieve my desired stamp, in under 4 minutes.
If I know the country, well, that drops to fractions of a second.

Yep, Windows explorer will do me.

No coding..look no hands.

Send note to Staff  Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 
To participate in the forum you must log in or register.
United States Postal Service, Now on eBay!United States Postal Service, Now on eBay!
New Forum Topics Recently Active Forum Topics
  Forwarding agent or Business
  Scott #445 (A140) Coil Stamp Perf 10 Horizontally Washington 3c Violet? Is it Type I or Type III ?
  Providence Rhode Island 5 Cent Stamp With Red Strands. Authentic?
  2 Cent Red Washington Without corner triangles?
  Rules to Classify Topical Subjects
  New stamp error in Germany (christmas stamp)
  Guatemala stamp ?? Thanks for your help !
  ASDA Mid-West Postage Stamp Show
  New Online US Stamp Mount Finder Tool
  Regumming stamps - Why do it?
  Norway used lot off paper. 440 stamps.
  Places with philatelic references
  Need Help with understanding cancels France Ceres
  Question about Pricing of Korean Stamps
  Help needed identifying stamp
  Image naming : How to remove first 4 characters.
  Hi All, Could I get a certificate if this is a 534b ?
  possible 554d 10perf Washington 2cent
  Please help with these British Overprints
  Layout of De La Rue Sheets of 240 on early British Colonies
  How did early collectors keep stamps MNH??
  Barbados 1985 Marine Life and 1994 Ships Issues - date varieties
  J1 vs. J15 stamp size?
  Hi, Can I have help ich I believe is a 504 b type V11
  Indian collection of Feudatory States

  danish classics, show them to me.
  How did early collectors keep stamps MNH??
  Forwarding agent or Business
  Prephilatelic covers - any interest? Show - tell - ask - explain!
  New stamp error in Germany (christmas stamp)
  Flooding and Natural Disasters
  What kind of features do you expect from digital (philatelic) publications?
  Curious about Webstore anyone heard of or tried it?
  Layout of De La Rue Sheets of 240 on early British Colonies
  Rules to Classify Topical Subjects
  2 Cent Red Washington Without corner triangles?
  Scott #445 (A140) Coil Stamp Perf 10 Horizontally Washington 3c Violet? Is it Type I or Type III ?
  The Stamps of Australia : On Steiner Pages.
  Please help with these British Overprints
  New Online US Stamp Mount Finder Tool
  Need Help with understanding cancels France Ceres
  Latin Species Names For Plants & Animals
  1938 Jamaca Scott 116b Watermark Sideways cv $9000 does anybody know?
  Providence Rhode Island 5 Cent Stamp With Red Strands. Authentic?
  What Did You Do Philatelically: Today or Recently?
  Places with philatelic references
  possible 554d 10perf Washington 2cent
  Bicycles on Stamps...
  Everything's Coming Up BUTTERFLIES!
  Turtle Stamps

Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Stamp Community assumes no liability for errors. Copyright 2005 - 2017 Stamp Community Family - All rights reserved worldwide. Use of any images or content on this website without prior written permission of Stamp Community or the original lender is strictly prohibited.
Privacy Policy / Terms of Use    Advertise Here
Stamp Community Forum © 2007 - 2014 Stamp Community Forums Go To Top Of Page
It took 0.8 seconds to lick this stamp. Powered By: Snitz Forums 2000 Version 3.4.05