Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Storage
>
Reply to Thread
Message:
<p>[QUOTE="geekpryde, post: 4132754, member: 36248"]I wouldn't bother using someones else template. Make it exactly how it works best for you. It's probably both a waste of your time to look for and modify a pre-made one.</p><p><br /></p><p>Mine looks exactly like this, however, I don't really collect raw coins. Yeah, I like junk silver, but most of my coins are graded, and they are all USA, so this wouldn't work for you. This might give you a general idea, but really, make it exactly to your needs.</p><p><br /></p><p>Your will only take a new minutes to create the layout, add header-rows, etc. You can always add columns and move things around easily as you find need to expanding.</p><p><br /></p><p>It's hard to show in a forum, but here is what the first few fields look like on my Coin Inventory spreadsheet.</p><p><br /></p><p>[ATTACH=full]1069818[/ATTACH]</p><p><br /></p><p>Here are the fields I use, these are Columns in excel, and each row would be 1 coin, but I'm listing them below vertically to make it easier to read on a forum. Maybe you don't need many of these, maybe you would add a ton more. These worked for all my needs:</p><p><br /></p><p><br /></p><p><b> DESCRIPTION </b></p><p><b> SERIES </b></p><p><b> DATE </b></p><p><b> MM </b></p><p><b> DENOM </b></p><p><b> MS / PF </b></p><p><b> GRADE PREFIX </b></p><p><b> GRADE </b></p><p><b> GRADE SUFFIX </b></p><p><b> SERVICE </b></p><p><b> CERT # </b></p><p><b> VARIETY </b></p><p><b> CAC </b></p><p><b> PERMANENT COLLECTION </b></p><p><b> VALUE </b></p><p><b> PURCHASE PRICE </b></p><p><b> PCGS RARITY </b></p><p><b> CAC POP </b></p><p><b> PURCHASED FROM </b></p><p><b> PURCHASED DATE </b></p><p><b> NOTES </b></p><p><b> SLAB GENERATION </b></p><p><b> COUNTRY </b></p><p><br /></p><p>In excel you can search, filter, etc and drill down to specific series, years, denoms, counties, etc. in seconds!</p><p><br /></p><p>Good luck and keep us posted.[/QUOTE]</p><p><br /></p>
[QUOTE="geekpryde, post: 4132754, member: 36248"]I wouldn't bother using someones else template. Make it exactly how it works best for you. It's probably both a waste of your time to look for and modify a pre-made one. Mine looks exactly like this, however, I don't really collect raw coins. Yeah, I like junk silver, but most of my coins are graded, and they are all USA, so this wouldn't work for you. This might give you a general idea, but really, make it exactly to your needs. Your will only take a new minutes to create the layout, add header-rows, etc. You can always add columns and move things around easily as you find need to expanding. It's hard to show in a forum, but here is what the first few fields look like on my Coin Inventory spreadsheet. [ATTACH=full]1069818[/ATTACH] Here are the fields I use, these are Columns in excel, and each row would be 1 coin, but I'm listing them below vertically to make it easier to read on a forum. Maybe you don't need many of these, maybe you would add a ton more. These worked for all my needs: [B] DESCRIPTION SERIES DATE MM DENOM MS / PF GRADE PREFIX GRADE GRADE SUFFIX SERVICE CERT # VARIETY CAC PERMANENT COLLECTION VALUE PURCHASE PRICE PCGS RARITY CAC POP PURCHASED FROM PURCHASED DATE NOTES SLAB GENERATION COUNTRY [/B] In excel you can search, filter, etc and drill down to specific series, years, denoms, counties, etc. in seconds! Good luck and keep us posted.[/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
>
Storage
>
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...