Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
US Coins Forum
>
Coin Inventory Software / Websites
>
Reply to Thread
Message:
<p>[QUOTE="GeorgeM, post: 1088659, member: 28550"]I currently use excel, with a different tab (aka worksheet) for each binder, lockbox, or storage box. I use a slightly different page layout for medals vs. coins, but my general layout looks like:</p><p><br /></p><p>A: Country of Origin</p><p>B: Date</p><p>C: Mintmark</p><p>D: Denomination</p><p>E: Notes (ie; slabbed, rim dings, rotated reverse, etc)</p><p>F: Condition / Grade</p><p>G: Purchase Price (if recorded)</p><p>H: Estimated Purchase Price (if not recorded, otherwise I copy G over)</p><p>I: Date of purchase</p><p>J: Estimated value</p><p> K: ASW</p><p>L: AGW</p><p>M: Index number (a 1 copied down)</p><p><br /></p><p>At the bottom of each worksheet, I total up and average the columns (using the =AVERAGE and =SUM formulas). </p><p><br /></p><p>I'm currently creating a separate photo inventory system, but I understand that some software allows you to integrate photos and scans of receipts.[/QUOTE]</p><p><br /></p>
[QUOTE="GeorgeM, post: 1088659, member: 28550"]I currently use excel, with a different tab (aka worksheet) for each binder, lockbox, or storage box. I use a slightly different page layout for medals vs. coins, but my general layout looks like: A: Country of Origin B: Date C: Mintmark D: Denomination E: Notes (ie; slabbed, rim dings, rotated reverse, etc) F: Condition / Grade G: Purchase Price (if recorded) H: Estimated Purchase Price (if not recorded, otherwise I copy G over) I: Date of purchase J: Estimated value K: ASW L: AGW M: Index number (a 1 copied down) At the bottom of each worksheet, I total up and average the columns (using the =AVERAGE and =SUM formulas). I'm currently creating a separate photo inventory system, but I understand that some software allows you to integrate photos and scans of receipts.[/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
>
US Coins Forum
>
Coin Inventory Software / Websites
>
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...