| Author |
 Replies: 18 / Views: 4,035 |
|
New Member
United States
43 Posts |
*** Moved by Staff to a more appropriate forum. ***Perhaps you all could give me some advice on the best available software for inventorying my coin collection. I have done a little research on available software but everything I have seen to date appears to be very cluttered looking and quite cumbersome. I am looking for something user friendly with total value and reporting capabilities based on spot prices and coin grades. A pic or link to the pic of each coin would be great for insurance purposes. Anyone have any recommendations? 
|
|
|
|
New Member
United States
19 Posts |
I've built a nice Excel spreadsheet with type-tabs... easy to search and edit. Also helps when the insurance company requires an inventory.
|
|
New Member
 United States
43 Posts |
I thought about building one in excel as well, but figured there has to be some pretty sophisticated options available with good reporting capabilities, graphic interphase, and automatic updates depending on spot prices and recent auction pricing? Not sure what the cost would be or if it would even be worth while but it would be a great to be able to tie this into a persons entire financial portfolio.
|
|
New Member
United States
19 Posts |
That's a good point - mine has built-in hyperlinks, but nothing where actually pulls updated data from the web. I'm sure somebody's got the Excel know-how! I built an excel common gold/silver melt coin calculator that just needs daily spot prices inputed... then I found (124) Not Allowed - Auto-Removed .com and gave up on trying to get it to auto-update.
|
|
Pillar of the Community
United States
1064 Posts |
I use EXCEL as well, but taking advantage of the TABS is a great idea!
|
|
Bedrock of the Community
United States
20753 Posts |
With Excel you can get all kinds of information from members here, many other people you may know, people you may work with. Excel is so popular, you can find out info on that from many sources.
Another great thing about Excel is so many computers use it if you have your info on a CD, flash drive, floppy disc, you can go almost anywhere and bring up your info.
|
|
Pillar of the Community
United States
7840 Posts |
I am using Excel too, one tab for coins, another for paper.
The rows that I use are; description, grade, what I paid for it, collector value, and comments. I have to update the collector value myself about every three to six months (whenever I get around to it).
|
|
Pillar of the Community
2224 Posts |
|
|
Moderator
 United States
14463 Posts |
Excel here  I have 5 tabs, Current Bids, Current Orders, Cost of needs/wants, Coins, Currency within those tabs, I have sections for each auction site, groupings of coins, and groupings of currency |
|
Pillar of the Community
United States
1745 Posts |
MS Access database for me. I know I'm in the small minority, but if you take a little time to learn how to create and use a database application, everything becomes quite easy. For what it's worth, I started with an Excel spreadsheet with tabs for each denomination.
With my database, there is just one file with all the pertinent information and then I create queries/reports for the various "looks" I want. For example, I have queries which display only Lincoln Cents or another that displays all the coins I need to upgrade in my Dansco's.
Best of luck.
|
|
Valued Member
United States
223 Posts |
Using Coin Manager by Liberty Street.
It's pretty Awesome..
You can download a demo I believe...
|
|
Pillar of the Community
United States
759 Posts |
Excel here as well. With pivot tables and filters, I can produce most anything I'd like, rivaling novice Access capabilities. An input section with spot prices drives bullion values and it's all linked to a total investment/net worth file, also Excel based. Very easy to manage. No cost since I have Excel. I just wish the numbers were higher. :) Please, no data security lectures like last time I mentioned Excel. Got that covered.
|
|
Pillar of the Community
Australia
652 Posts |
Excel using multiple worksheets. I use pivot tables within each worksheet to sort and categorise. Relevant details from each worksheet is hyperlinked internally to a summary sheet. I toyed with hyperlinking photographs, but the hyperlinks break when you manipulate directory structures, and of course the pictures are large and not particularly portable.
|
|
Pillar of the Community
United States
609 Posts |
Does anyone use open office? I dont have microsoft access on my laptop at home, but at school the computers have access and I know how to use it, somewhat. I'm wondering if theres a tutorial for creating databases in open office like in microsoft office.
The database part of OOo seems to be unused by regular people:P
|
|
Moderator
United States
14463 Posts |
I have Open Office, but I don't use the database functions, sorry.
|
|
Pillar of the Community
United States
609 Posts |
Haha! See, regular people dont use database:/
Well I've been fiddling with it for about 30 minutes, figured out how to do basic stuff. Learning access from a book was easy, finding out how to do database on my own is difficult.
|
| |
Replies: 18 / Views: 4,035 |
Posted 07/11/2011 6:39 pm
