| Author |
 Replies: 18 / Views: 4,036 |
Page 2 of 2
|
|
|
|
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.
|
|
Moderator
United States
188938 Posts |
I use OpenOffice/LibreOffice as well, but stick to the spreadsheets (Calc). Sorry.
|
|
Pillar of the Community
United States
609 Posts |
I think I've got it figured out now. It's actually not as hard as it seems and after I get it all set up I can print reports at the click of a button.
|
|
Valued Member
United States
266 Posts |
I have an Excel spreadsheet with columns for the year, mm, variety, amt paid, coin worth, and where I bought it from. I also have a summary page adding it all up. I don't have the access to auto update the prices. When I want to update, I have to actually go on, and update the prices out of a book. I also taught myself Filemaker pro. It gives me a database for the coins that I have, complete with pictures of all of my coins. Again, I don't have access to any auto update. I have both sets set up so that to update prices, I would have to buy a new book, and manually update them. Right now, I have the prices entered from the 2007 Red Book. I figure that my current prices should be pretty accurate, seeing as I am using a 5 year old Red Book. I liked my creating my own inventory sheets, because it gave me the categories that I wanted to see in my inventory, in the way I like to see them. I figure that the only perk that I am missing is the auto update of price. I can take a rainy weekend, and sit down and update them all, someday. By doing this, I can see what some of the changes, and any trends are, as opposed to having it auto updates, and just see numbers, but not how it changed. |
|
Page 2 of 2
|
Replies: 18 / Views: 4,036 |
Page 2 of 2
|
First Page
Posted 07/12/2011 10:39 am
