| Author |
 Replies: 12 / Views: 1,457 |
|
|
Valued Member
United States
270 Posts |
I want to start using Excel to keep track of my coin collection but I don't really know where to start with what types of things to chart on it. I know many other people use excel to keep track of their collections what types of things do you all do with it?
|
|
|
|
Pillar of the Community
United States
1626 Posts |
I use excel for my coins, and I can show you a sample of how I use it. Send me an email and I will send you an example file....
Tim
|
|
Pillar of the Community
United States
1151 Posts |
My charts contain the following columns for each denomination:
Date of the coin
Mint Mark
Grade
Date purchased
Cost
Where stored ( album, folder 2x2 in a box)
Date sold / traded
Price received
|
|
Pillar of the Community
United States
651 Posts |
|
|
Valued Member
 United States
270 Posts |
|
|
Pillar of the Community
United States
595 Posts |
If you still need ideas, send me your e-mail and I'll send you some samples. I keep track of just about everything in Excel -- coins, stamps, wooden nickels, casino chips -- even how many and what size of Air-Tites, cardboard holders, and plastic 2x2's I have left.
Happy to help if you're interested.
Jan
Jan
|
|
Pillar of the Community
Australia
1262 Posts |
Here is a link to a great spreadsheet that I use. I just change the details (ie Country etc) to suit what I want. http://www.aussie-coins.com/ then go to links |
|
Moderator
 United States
23516 Posts |
I am in the process of updating the spread sheet on aussie-coins
It is two years old, but I will have it updated shortly.
rggoodie
aka Richard
"catch em doing something right"
|
|
Pillar of the Community
United States
2254 Posts |
Not xls related as I use Coin Manage, but:
BM1947, that is a great quote!!!!
|
|
Valued Member
Sweden
79 Posts |
Cool link, Ken! And there they have the CC forum embedded right in the middle of the page.
|
|
Pillar of the Community
United States
651 Posts |
Thanks Mynt. Actually, it's my site...I try not to hawk it here in the forum but occasionally there's some helpful stuff.
|
|
Valued Member
United States
208 Posts |
Hey Ken thanks for that example spreadsheet. I took my current spread sheet and integrated some functions into it to calculate cost\prices\worth of my collection. I actually googled arithmetic functions in Excel..
|
|
Pillar of the Community
United States
651 Posts |
Glad I can help, if you came up with anything interesting you might want to share it with imanangel0686.
|
| |
Replies: 12 / Views: 1,457 |
|
Posted 02/26/2007 7:33 pm
