Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Coin organization
>
Reply to Thread
Message:
<p>[QUOTE="Billy Kingsley, post: 781152, member: 19456"]I have all my collection on Excel. For the US, each denomination gets it's own sheet, up to the half dollar. (everything else, Dollars, 2 cents, three cents, proofs and NCLT are on one sheet, I don't have enough of any of them to warrant their own sheet)</p><p> </p><p>Here is an example of the Quarters page.</p><p>I did not remove all of the names of where I got them from here.</p><p><img src="http://images50.fotki.com/v397/photos/3/348354/6136805/quarters-vi.jpg" class="bbCodeImage wysiwygImage" alt="" unselectable="on" /></p><p> </p><p>For Canadian coins, I have them all on one sheet. I have a column for each denomination, color coded for easy reference. I list the coin itself, the date I got it, and where I got it from. All the coins dated 10/10/08 were the new issues in my collection that my friend from Canada gave me. Since I took this screen cap a few months ago I have redone the page a bit to add in where I got them as well as the date.</p><p> </p><p><img src="http://images19.fotki.com/v286/photos/3/348354/6136805/CoinChartCanada-vi.jpg?1262942900" class="bbCodeImage wysiwygImage" alt="" unselectable="on" /></p><p> </p><p>For World coins, they are all on one sheet. Each country is listed by itself, with the coins from that country listed in chronological order by denomination. </p><p>See this old screen shot. I have removed the names of the places or people I have gotten these from, but that would go in the column to the right of the date I got it.</p><p><img src="http://images50.fotki.com/v393/photos/3/348354/6136805/various-vi.jpg" class="bbCodeImage wysiwygImage" alt="" unselectable="on" /></p><p> </p><p>What I did so I know what I am looking for, either at shows, or just simply going through my change, is make a sheet, that can be printed out on one page, of what I Need. The coins I don't have are in black, the coins I have but want a better example of are in blue. I put the Dollar coins and the Candian coins as what I HAVE, because what I need is much more then what I have. </p><p> </p><p>When I get coins I am after, I cross them out on my sheet. I see that I have been slacking in keeping this sheet updated, as I know I found a 1989 Quarter at least that was good for my collection, so later today I will get the sheet, and correct the file on Excel. </p><p> </p><p>I print the sheet about twice a year, OR if I find a lot of things, and it really needs to be updated. I mostly limit this sheet to current circulating coins, although I did put the silver Roosevelt coins on there, as I am working on completing them when I can. </p><p> </p><p>Here is a screen shot of it:</p><p><img src="http://images51.fotki.com/v423/photos/3/348354/6136805/Untitled1-vi.jpg?1262942079" class="bbCodeImage wysiwygImage" alt="" unselectable="on" /></p><p> </p><p>For the classic coins that I have, well, I didn't have too many of them. I was out traveling one day and came across an antique shop that had a lot of coins. I thought I could remember what I had, but it turned out, I couldn't, as I ended up purchasing a duplicate. Later that day, I created the Classics I have chart. It is very similar to the coins I need chart, in that each denomination gets their own column. Within each column, each type has it's own section where I list the dates I have. When I get something new, I write in the dates I've purchased or, in the rare instance, found. I recently added a seperate column on there for cents that are fully original red. It's not a very large number that I have, maybe 20-25 coins, mostly all from the 70s to today. But I have them there anyway, because eventually I will purchase the others in full mint red. This sheet needs to be reprinted after my first coin show, CoinFest, this past October. For classic currency, they are also listed on there. I don't have too much classic currency yet, but I hope someday I will need a sheet for them as well. I also hope that I will need a sheet for classic world coins. Most of my world coins are modern issues that I get from bulk lots or dealer bins. Not something I saw for sale at CoinFest, so I don't think I have to worry about it. And at 10 cents or less a coin, I wouldn't worry about a duplicate or multiple duplicates, it gives me something to use as trade bait or to give away. </p><p> </p><p>I am going to have to adjust this sheet soon, as I have been purchasing mostly dimes when I purchase new coins. I more then tripled my Barber Dime collection at coin Fest, of cource, I only had two before the show. One of my local shop also had quite a few silver Roosevelts which I purchased the dates I needed, unfortunatly he had less then 10 that I didn't have, and at a dollar each I would have gotten every date I needed. Maybe next time!</p><p> </p><p>I am not going to share my Classics I have chart right now.[/QUOTE]</p><p><br /></p>
[QUOTE="Billy Kingsley, post: 781152, member: 19456"]I have all my collection on Excel. For the US, each denomination gets it's own sheet, up to the half dollar. (everything else, Dollars, 2 cents, three cents, proofs and NCLT are on one sheet, I don't have enough of any of them to warrant their own sheet) Here is an example of the Quarters page. I did not remove all of the names of where I got them from here. [IMG]http://images50.fotki.com/v397/photos/3/348354/6136805/quarters-vi.jpg[/IMG] For Canadian coins, I have them all on one sheet. I have a column for each denomination, color coded for easy reference. I list the coin itself, the date I got it, and where I got it from. All the coins dated 10/10/08 were the new issues in my collection that my friend from Canada gave me. Since I took this screen cap a few months ago I have redone the page a bit to add in where I got them as well as the date. [IMG]http://images19.fotki.com/v286/photos/3/348354/6136805/CoinChartCanada-vi.jpg?1262942900[/IMG] For World coins, they are all on one sheet. Each country is listed by itself, with the coins from that country listed in chronological order by denomination. See this old screen shot. I have removed the names of the places or people I have gotten these from, but that would go in the column to the right of the date I got it. [IMG]http://images50.fotki.com/v393/photos/3/348354/6136805/various-vi.jpg[/IMG] What I did so I know what I am looking for, either at shows, or just simply going through my change, is make a sheet, that can be printed out on one page, of what I Need. The coins I don't have are in black, the coins I have but want a better example of are in blue. I put the Dollar coins and the Candian coins as what I HAVE, because what I need is much more then what I have. When I get coins I am after, I cross them out on my sheet. I see that I have been slacking in keeping this sheet updated, as I know I found a 1989 Quarter at least that was good for my collection, so later today I will get the sheet, and correct the file on Excel. I print the sheet about twice a year, OR if I find a lot of things, and it really needs to be updated. I mostly limit this sheet to current circulating coins, although I did put the silver Roosevelt coins on there, as I am working on completing them when I can. Here is a screen shot of it: [IMG]http://images51.fotki.com/v423/photos/3/348354/6136805/Untitled1-vi.jpg?1262942079[/IMG] For the classic coins that I have, well, I didn't have too many of them. I was out traveling one day and came across an antique shop that had a lot of coins. I thought I could remember what I had, but it turned out, I couldn't, as I ended up purchasing a duplicate. Later that day, I created the Classics I have chart. It is very similar to the coins I need chart, in that each denomination gets their own column. Within each column, each type has it's own section where I list the dates I have. When I get something new, I write in the dates I've purchased or, in the rare instance, found. I recently added a seperate column on there for cents that are fully original red. It's not a very large number that I have, maybe 20-25 coins, mostly all from the 70s to today. But I have them there anyway, because eventually I will purchase the others in full mint red. This sheet needs to be reprinted after my first coin show, CoinFest, this past October. For classic currency, they are also listed on there. I don't have too much classic currency yet, but I hope someday I will need a sheet for them as well. I also hope that I will need a sheet for classic world coins. Most of my world coins are modern issues that I get from bulk lots or dealer bins. Not something I saw for sale at CoinFest, so I don't think I have to worry about it. And at 10 cents or less a coin, I wouldn't worry about a duplicate or multiple duplicates, it gives me something to use as trade bait or to give away. I am going to have to adjust this sheet soon, as I have been purchasing mostly dimes when I purchase new coins. I more then tripled my Barber Dime collection at coin Fest, of cource, I only had two before the show. One of my local shop also had quite a few silver Roosevelts which I purchased the dates I needed, unfortunatly he had less then 10 that I didn't have, and at a dollar each I would have gotten every date I needed. Maybe next time! I am not going to share my Classics I have chart right now.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Coin organization
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...