| Author |
 Replies: 26 / Views: 4,582 |
|
Pillar of the Community
United States
1915 Posts |
Hello all. I have been too busy to post any comments lately, but finally this weekend I got some much needed time with my coins. I am so not looking forward to Monday. Anyway, as you can tell by the time of this post it is late, and after cleaning and reorganizing my desk, AGAIN, I have simpled out a bit. An idea came to me in this simple frame of mind. I have often needed checklists for the sets I am currently working on. Now when I am home I just go to the simple want-lists I have made on my computer. I got to thinking. What about a checklist that you could check off the coins you have so you can see which ones you still need? Well that concept I have seen before. But, what if your checklist gave you an idea of the FMV? So away I went designing just that. Now I am no whiz with Microsoft Excel, but my accountant wife is. She showed me a few tricks, and I think it turned out pretty good for an amateur. I think I may even offer them on my website that I am working on. Here is a screen shot of one of those sheets. It is not actual size, which would be one normal sheet of paper. I am still working on others, but I wanted to get some feedback from the forum. I have grown fond of many of you, and really want to hear your thoughts.  Edited by seal006
08/29/2010 02:23 am
|
|
|
|
Pillar of the Community
United States
564 Posts |
I like it. I do something like that with my sets. The coins I need I put on a list like yours with the price of each. It also helps keep me focused because I always buy coins that look so good you can't pass them up. We all have done that before!
|
|
Pillar of the Community
 United States
1915 Posts |
That seems to be what I have been doing lately. I don't think they make a checklist for those  I really think this kind of checklist is good because you can see the different prices for the different grades while seeing if it is one you need or not. You could probably circle the price at the grade you currently have a coin of that you would like to upgrade as well. I guess this kind of list would be as versitile as you want it to be. Do you think that it would be worthwhile to offer them on my website? Edited by seal006
08/29/2010 2:07 pm
|
|
Valued Member
United States
487 Posts |
I think your on to something. I would loved to have the sheet of the coins sets I'm working on with FMV at hand. Keep us posted here at CCF on how your project is coming!
|
|
Pillar of the Community
United States
2541 Posts |
Nice idea. This saves dragging a Coin Values magazine along to the show to flick through.
|
|
Pillar of the Community
United States
592 Posts |
We do something very similar with a combo of excell & word.
We Always bring a folder with these lists to the shows. It helps us to keep focused on what we need not what we do not.
I really do not think anybody cares if we have our cheat sheets at the shows.
|
|
Pillar of the Community
United States
524 Posts |
I like it but maybe have a spot to put the date you last updated pricing. If you skip a month or two the price of silver could move 10%-15%. Even if you don't update your entire list you can compare the dates and estimate the change.
|
|
New Member
United States
26 Posts |
I think its a great idea! I definately needed something like this at the show yesterday.
I have something similar to keep track of my coin inventory. I also have the coins in my spread sheet hyperlinked to the online priceguide I use.
|
|
Pillar of the Community
United States
1915 Posts |
Here is what the first page of the LWC checklist looks like. I did add a header that has the updated date. It just cannot be seen in this image.  Edited by seal006
08/29/2010 2:07 pm
|
|
New Member
United States
26 Posts |
That looks great. What about the different variations? Like "red" "red/brown" etc
|
|
Valued Member
United States
102 Posts |
Looks good, I'd definitely use something like that.
|
|
Pillar of the Community
United States
1915 Posts |
Quote:
That looks great. What about the different variations? Like "red" "red/brown" etc
I thought about that. Here are my reasons for not doing it: 1) There is already so much info on each page I just felt I would keep it simple. 2) If I did, it would just be another price guide. I really wanted this to serve as a quick reference. Being that it is in excel format, I guess anyone could change it to suit their needs. |
|
New Member
United States
26 Posts |
That makes sense. It is alot of info.
|
|
Pillar of the Community
United States
1915 Posts |
So far I have done a checklist for LWC, Liberty nickels, Buffs, Jefferson 38-61, SLQ, Washingtons 32-64. I plan on adding IHC, Mercs, Rosies 46-64, Franklin halves, JFK Halves, Morgans, Peace, and Ikes. Do you think I need to include anyting else? |
|
Bedrock of the Community
United States
17884 Posts |
Whitman publishes a Checklist of United States and Canadian coins. It doesn't list prices but instead has a series of boxes so you can check off that you have it and the grade you have. House of Collectibles publishes The Official Black Book price guide to United States coins that is almost identical to what Seal006 is doing. The question is are the prices comparitable, but that it the problem with any price guide. You have to know the values to know if the prices in the book are accurate. And even if they are, after a little while they won't be. No offense but Seal006 is basically re-inventing the wheel. If you do something like this the only way to really make it worthwhile is to also keep a constantly updated file of the prices that people could download and then use to update their inventory file so they don't have to constantly copy their data over to a new form every time you update the values. If I was going to do that in an excel format I would have the inventory file separate from the price files, then in the inventory file I would include a formula that copied the price file into the inventory file. Then when you want to update the prices on your list you just download the new price file for that series and have it overwrite the old price file. (As long as it has the same name.) Then when you open the inventory file the next time it will load the new prices but all your data will still be there. and you can print off a new copy if you want. The problem is I doubt Seal006 would want the full time job of keeping all the prices up to date. Edited by Conder101
08/30/2010 09:15 am
|
|
Pillar of the Community
United States
1915 Posts |
Yes, I know this concept is not new. I just thought it would be a simplified solution to a problem I have had. I think an easy solution to the update problem people would have is to simply download the update and copy the value table the paste over the old values.
|
| |
Replies: 26 / Views: 4,582 |
Posted 08/29/2010 03:23 am
