Message:

<p>[QUOTE=&quot;Vess1, post: 446638, member: 13650&quot;]<b>Excel</b></p><p><br /></p><p>Here&#039;s my current system with Excel.&nbsp; It took some time to initially get set up but now that it&#039;s current, this is a very easy system that I&#039;m very happy with.</p><p><br /></p><p>&nbsp; I&#039;ll try to explain it as simply as possibly.</p><p><br /></p><p>&nbsp; I started from scratch with a new spreadsheet.&nbsp; At the bottom of the screen where the tab says &quot;Sheet 1&quot;, I created a whole row of extra sheets I can click on to look at stuff.</p><p><br /></p><p>&nbsp;Currently that row of tabs goes, &quot;Bullion, Silver Dollars, Half dollars, Quarters, S.State Quarters, dimes, Buff. Nickels, Pennies, 19th Century, Commems., and gold.&nbsp;&nbsp; If I ever need another work sheet, it&#039;s easy to right click and stick another one in between existing ones.&nbsp; Then I just use the arrows at the side to scroll through them.&nbsp; Click on the tab to bring up whatever page I need.</p><p><br /></p><p>&nbsp; Currently, I don&#039;t have much for pennies so that sheet is still blank.&nbsp; </p><p>Almost all of the other pages have formulas put in that total columns and calculates silver content.&nbsp; </p><p><br /></p><p>&nbsp; Here&#039;s the key to this system.&nbsp; I&#039;ve collected a lot of MS half dollars and have them in albums.&nbsp; I&#039;m not even going to try to photograph all this.&nbsp; I just put a generic picture of a Kennedy half, then the dates for that set (example 1986-2003 heading), then the spreadsheet.&nbsp;&nbsp; This took up 3 pages on my Half dollars sheet.</p><p><br /></p><p>&nbsp; Next, on the same half dollars sheet, Franklin halves, on their own individual, *printable* page.&nbsp; Again, generic pic, with the dates of the mintage.&nbsp; Then the spread sheet.&nbsp; Columns are in order as follows:</p><p><br /></p><p>&nbsp;Date, MM, Grading Co., Grade, Qty., Purch. Date, Prch. Price, RB value, Comments.&nbsp; &nbsp; All the columns are adjusted to appropriate size as needed.&nbsp; </p><p><br /></p><p>&nbsp; I picked up 3 Franklins for my set yesterday.&nbsp; These are nice ones.&nbsp; So, I fill in the rows, and then next to the date, I put an astrick, to signifiy that this date and MM has been purchased for the album.&nbsp; Other rows may have a &#039;qty.&#039; but no asterick, signifying that I have not purchased a good one yet but may have 3 of them.&nbsp;&nbsp; I can enter this data in quickly and easily.&nbsp; </p><p><br /></p><p>&nbsp;On the Buff. Nickels sheet, I put a page break at the top.&nbsp; So all the headings stay put, but you can scroll through all the dates.</p><p><br /></p><p>&nbsp; Quarters sheet is only documenting silver quarters of various grades.&nbsp; If I buy a nice one, I enter it in.&nbsp; Enter 1 for the quantity.&nbsp; That &#039;1&#039; is automatically tallied into the total, and then another formula on the sheet calculates and tallies the new bullion total for quarters.&nbsp; &nbsp; This allows me to go through and add up total amount of silver owned in about 1 minute at any time.&nbsp; </p><p><br /></p><p>&nbsp;Commemoratives have their own sheet.&nbsp; <b>These I do individually take pictures of front and back</b>.&nbsp; I insert and shrink them down to about a 1x1 square on the screen, then side by side.&nbsp; Each gets it&#039;s own informational section, ending with bullion content to the side.&nbsp;&nbsp; Just because it&#039;s fun to know.&nbsp;&nbsp; <b>The pictures are shrunk down but are still high quality</b>.&nbsp; All you have to do is grab a corner and stretch it out to see full screen.&nbsp; Then go to the top, click undo and it goes back to it&#039;s original state.</p><p><br /></p><p>&nbsp; Keep in mind, all these separate sheets are stored on one file.&nbsp; You just click the tab of what you need to look at.&nbsp; Anybody can make one and customize it for your needs.&nbsp; The way mine is set up, probably isn&#039;t going to work for everybody&#039;s collecting habits but may work for quite a few.</p><p><br /></p><p>&nbsp; If anybody would like to set one of these up, feel free to PM me if you have any questions.&nbsp; I feel this has been a quick, easy and informative way to keep track.</p><p><br /></p><p>&nbsp;If I could remember how to do a screen shot again, I&#039;d post a pic.[/QUOTE]</p><p><br /></p>

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