Cataloging your Collection
How does everyone catalog their collection? EB, spreadsheet, database?
I used EB for a little while but wanted some additional functionality and flexibility so I moved to a spreadsheet. Now I'm not happy with the spreadsheet and thinking about building a database of some sort.
I'm curious to hear how you guys keep track of everything.
I used EB for a little while but wanted some additional functionality and flexibility so I moved to a spreadsheet. Now I'm not happy with the spreadsheet and thinking about building a database of some sort.
I'm curious to hear how you guys keep track of everything.
- SurfingJeff
- Art Expert
- Posts: 2264
- Joined: Sat Jul 09, 2011 6:46 pm
- Location: Manhattan Beach, CA
- Contact:
I use both EB and a spreadsheet. My spreadsheet is pretty fancy, and uses pivot tables to calculate how many pieces I have by a given artist along with the total price paid, total value, etc. It still requires a ton of manual entry though.
T.H.C.
- churdiales
- Art Expert
- Posts: 2465
- Joined: Sun Apr 19, 2009 6:54 pm
- Location: USA
EB database can be as fancy as what you are describing if you use the tabs on the left and plug in the info when you add it to your collection.SurfingJeff wrote:I use both EB and a spreadsheet. My spreadsheet is pretty fancy, and uses pivot tables to calculate how many pieces I have by a given artist along with the total price paid, total value, etc. It still requires a ton of manual entry though.
Last edited by churdiales on Sun Dec 16, 2012 6:32 pm, edited 1 time in total.
krisjay wrote:I find this post odd.
- SurfingJeff
- Art Expert
- Posts: 2264
- Joined: Sat Jul 09, 2011 6:46 pm
- Location: Manhattan Beach, CA
- Contact:
It seems like EB is good for getting information about an individual print, but there's no summary page that will show you totals across your entire collection. Am I just missing something?churdiales wrote:EB database is as fancy as what you are describing here.SurfingJeff wrote:I use both EB and a spreadsheet. My spreadsheet is pretty fancy, and uses pivot tables to calculate how many pieces I have by a given artist along with the total price paid, total value, etc. It still requires a ton of manual entry though.
T.H.C.
- churdiales
- Art Expert
- Posts: 2465
- Joined: Sun Apr 19, 2009 6:54 pm
- Location: USA
Totals by artist? Use this tab on left...SurfingJeff wrote: It seems like EB is good for getting information about an individual print, but there's no summary page that will show you totals across your entire collection. Am I just missing something?
krisjay wrote:I find this post odd.
SurfingJeff would you be willing to send out the basic sheet you use? That way any one interested could plug-in their data without having to be an excel master.SurfingJeff wrote:It seems like EB is good for getting information about an individual print, but there's no summary page that will show you totals across your entire collection. Am I just missing something?churdiales wrote:EB database is as fancy as what you are describing here.SurfingJeff wrote:I use both EB and a spreadsheet. My spreadsheet is pretty fancy, and uses pivot tables to calculate how many pieces I have by a given artist along with the total price paid, total value, etc. It still requires a ton of manual entry though.
- churdiales
- Art Expert
- Posts: 2465
- Joined: Sun Apr 19, 2009 6:54 pm
- Location: USA
On this one you can plug in what you paid for (ouch) and in the "Note(s)" box you can enter how its value has decreased over time.
Price Paid: $450
Acquired from: heathunter
Note: *Note to self, never buy immediately off of ebay after the missed drop. !@@#@$@##%^^$@#!
Price Paid: $450
Acquired from: heathunter
Note: *Note to self, never buy immediately off of ebay after the missed drop. !@@#@$@##%^^$@#!
krisjay wrote:I find this post odd.
- SurfingJeff
- Art Expert
- Posts: 2264
- Joined: Sat Jul 09, 2011 6:46 pm
- Location: Manhattan Beach, CA
- Contact:
Ok, so here's an example of what I'm talking about from my spreadsheet (changed all the numbers from the real thing):xN3rDx wrote:SurfingJeff would you be willing to send out the basic sheet you use? That way any one interested could plug-in their data without having to be an excel master.SurfingJeff wrote:It seems like EB is good for getting information about an individual print, but there's no summary page that will show you totals across your entire collection. Am I just missing something?churdiales wrote:EB database is as fancy as what you are describing here.SurfingJeff wrote:I use both EB and a spreadsheet. My spreadsheet is pretty fancy, and uses pivot tables to calculate how many pieces I have by a given artist along with the total price paid, total value, etc. It still requires a ton of manual entry though.
For each artist, you can see how much you've spent on them, what the original cost was, how many items you have, what the sum of the current value (although you have to populate this yourself), how much you've spent on framing, how much markup you paid, etc. I have a separate summary page based on the art type (e.g. movie posters vs gig posters vs art prints). Not sure if it's always useful, but kind of fun to see (just don't let your spouse near it!).
I've cleared all my data out of the spreadsheet and put together a copy for those that want try. Be warned it is super geeky. You do data entry on the page labeled "catalog". It's pretty much the same as putting something into EB. You can also do basic searching here. Go to the "summary" tab to see stats on your entire collection. Go to "Artist Summary" to see the data above, and "Category Summary" to see art type stats. The summary tabs don't update automatically, so you'll have to highlight the table and go to "Options -> Refresh" to update the data once in a while.
T.H.C.
- rhythmgtr5
- Art Expert
- Posts: 1347
- Joined: Fri Jan 15, 2010 4:38 pm
EB and spreadsheet. Seeing the total $$$ spent on prints is a bit shocking but it's worth it
- mindtrick33
- Art Connoisseur
- Posts: 695
- Joined: Thu Feb 02, 2012 9:27 pm
- Location: San Francisco
Would be nice if you could export your personal data out of EB.
Good luck on future drops
- evilpresence
- Art Expert
- Posts: 2393
- Joined: Wed Apr 18, 2012 12:39 am
- Location: Frozen Tundra 4a
Is 'My Page' and 'Save Collection' on the left side not what you are looking for?