I know several users here have personal spreadsheets or databases for their chip collections, but I was just thinking if we shared our own tips/advice on this, it might help others.
So over the weekend I created an Excel workbook with 4 worksheets: Chips, Samples, DBs and Cards
Chips is for playable sets
Samples is for sample sets
DBs is for Dealer Buttons
Cards is for my setups
One thing I discovered that was pretty cool, was how to get an image of the chip to appear on a certain cell, this way each row is not huge just to get the image in place. The trick is to use a "Comment" bubble, delete the text and then edit it 1"x1" in size and under Color/Lines choose the "Fill" option and select "Picture" and then choose your image. That makes the image the background for the comment box and only appears when you mouse over the cell you choose. The hardest part has been trying to locate good images of the sets I have and get screenshots of each chip.....
In terms of what I'm tracking, I thought the following headers were good, but there might be others (e.g. 'artwork by'):
Company/Brand (GOCC, PGI, OWPS, etc)
Chip Type (Clay, Ceramic, China Clay, Plastic Dice of course)
Color(s)
Denomination (Cash or T#)
Quantity
Cost (my purchase cost, may want to skip if spouse has access to file!)
Notes
Anyone else have ideas or suggestions, I'm always looking for spreadsheet tricks/tips
nitzilla
So over the weekend I created an Excel workbook with 4 worksheets: Chips, Samples, DBs and Cards
Chips is for playable sets
Samples is for sample sets
DBs is for Dealer Buttons
Cards is for my setups
One thing I discovered that was pretty cool, was how to get an image of the chip to appear on a certain cell, this way each row is not huge just to get the image in place. The trick is to use a "Comment" bubble, delete the text and then edit it 1"x1" in size and under Color/Lines choose the "Fill" option and select "Picture" and then choose your image. That makes the image the background for the comment box and only appears when you mouse over the cell you choose. The hardest part has been trying to locate good images of the sets I have and get screenshots of each chip.....
In terms of what I'm tracking, I thought the following headers were good, but there might be others (e.g. 'artwork by'):
Company/Brand (GOCC, PGI, OWPS, etc)
Chip Type (Clay, Ceramic, China Clay, Plastic Dice of course)
Color(s)
Denomination (Cash or T#)
Quantity
Cost (my purchase cost, may want to skip if spouse has access to file!)
Notes
Anyone else have ideas or suggestions, I'm always looking for spreadsheet tricks/tips
nitzilla
) and start a WTS, with each set having an "accept nothing less than $XX" price by it (edit: this *should* only be necessary should something unexpected happen to me - hopefully not because I pissed her off something fierce).
