Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Paper Money
>
Looking for software to manage a non-US paper collection
>
Reply to Thread
Message:
<p>[QUOTE="10gary22, post: 993019, member: 23626"]I have written Excel spreadsheets for everything. It's not that hard to figure out and with the "sort" capabilities, you can really get a handle on your data. The hardest part is determining how you want to track your data (sortable fields). A few might be; Country, Denomination, year, mint, grade, pic file number, date acquired, value, storage location, slab #, flip #. Using those a column headers then using a row for each coin. Of course, you can use different pages for currency and coins, or just make one large list. I prefer different pages, myself because I don't have a background with any computer skills, so I keep it simple. </p><p>You can always add another data column, but it requires going back and adding the data. You might consider noting pic file locations as well as the file names if you store a lot of them on disks or zips (or at least note the back-up locations). Since you still need to enter the data, I think the only thing you get with commercial software is graphics ?</p><p> </p><p>I am still learning, but am considering loading the pic file as hyperlinks, so I can go directly to them from the sheet ? I never had a computer before retiring a few years ago, so the learning is by rote and very time consuming. But, with basic knowledge already in hand, I think you could set it up in a couple of hours ?</p><p> </p><p>Adding columns for sales data might not even be a bad idea, in case you do future trading that you need to record.[/QUOTE]</p><p><br /></p>
[QUOTE="10gary22, post: 993019, member: 23626"]I have written Excel spreadsheets for everything. It's not that hard to figure out and with the "sort" capabilities, you can really get a handle on your data. The hardest part is determining how you want to track your data (sortable fields). A few might be; Country, Denomination, year, mint, grade, pic file number, date acquired, value, storage location, slab #, flip #. Using those a column headers then using a row for each coin. Of course, you can use different pages for currency and coins, or just make one large list. I prefer different pages, myself because I don't have a background with any computer skills, so I keep it simple. You can always add another data column, but it requires going back and adding the data. You might consider noting pic file locations as well as the file names if you store a lot of them on disks or zips (or at least note the back-up locations). Since you still need to enter the data, I think the only thing you get with commercial software is graphics ? I am still learning, but am considering loading the pic file as hyperlinks, so I can go directly to them from the sheet ? I never had a computer before retiring a few years ago, so the learning is by rote and very time consuming. But, with basic knowledge already in hand, I think you could set it up in a couple of hours ? Adding columns for sales data might not even be a bad idea, in case you do future trading that you need to record.[/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
>
Paper Money
>
Looking for software to manage a non-US paper collection
>
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...