|
|
Art spreadsheet., by josephwillis123 on Jul 5, 2018 22:31:57 GMT 1, This is related to Art storage...
I wanted to see how you guys document what you have in their collection.
Recently I decided to make a spreadsheet of my collection (about 50 pieces total). It was a fun activity that let me evaluate a few things about my collection. Also, if there was ever a fire or major damage I now at least have it somewhat documented. I need to figure out if you can add an image link to excel.
I set it up with Artist, Artwork, Medium, Edition, Year, Purchase Location, and Purchase Price. Any other suggested categories? I was going to do a Current Value, but I know I would just over estimate everything so I didn't end up adding it.
On a side note, seeing it all together its very clear a couple artists make up the majority of the collection. One artist makes up about 30% of the collection. I have about about 15 of her prints and one original painting. Though I enjoy having all those prints, there are only a couple that are framed and on the walls. I have been weighing the pros and cons of selling the majority of them and putting that towards another original painting from that artist. Others gone though the same? I have a MUCH harder time selling a piece than I do buying one!
This is related to Art storage...
I wanted to see how you guys document what you have in their collection.
Recently I decided to make a spreadsheet of my collection (about 50 pieces total). It was a fun activity that let me evaluate a few things about my collection. Also, if there was ever a fire or major damage I now at least have it somewhat documented. I need to figure out if you can add an image link to excel.
I set it up with Artist, Artwork, Medium, Edition, Year, Purchase Location, and Purchase Price. Any other suggested categories? I was going to do a Current Value, but I know I would just over estimate everything so I didn't end up adding it.
On a side note, seeing it all together its very clear a couple artists make up the majority of the collection. One artist makes up about 30% of the collection. I have about about 15 of her prints and one original painting. Though I enjoy having all those prints, there are only a couple that are framed and on the walls. I have been weighing the pros and cons of selling the majority of them and putting that towards another original painting from that artist. Others gone though the same? I have a MUCH harder time selling a piece than I do buying one!
|
|
warwolf
New Member
Posts • 255
Likes • 186
April 2018
|
Art spreadsheet., by warwolf on Jul 5, 2018 22:39:06 GMT 1, Its probably an exercise all collectors should do as like you suggest, it will give you an insight into your collection.
On this note, I'm pretty handy on excel so if anyone needs any guidance on formulas etc, give me a shout 👍
Its probably an exercise all collectors should do as like you suggest, it will give you an insight into your collection.
On this note, I'm pretty handy on excel so if anyone needs any guidance on formulas etc, give me a shout 👍
|
|
irl1
Full Member
Posts • 9,274
Likes • 9,380
December 2017
|
Art spreadsheet., by irl1 on Jul 5, 2018 22:41:33 GMT 1, Sell the prints that are under the bed  . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you.
Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. |
|
ca
Junior Member
Posts • 1,915
Likes • 2,372
March 2011
|
Art spreadsheet., by ca on Jul 5, 2018 22:58:53 GMT 1, Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. 
Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. no such thing as selling what's under the bed. you keep whats there and you buy more |
|
warwolf
New Member
Posts • 255
Likes • 186
April 2018
|
Art spreadsheet., by warwolf on Jul 5, 2018 23:02:29 GMT 1, Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. no such thing as selling what's under the bed. you keep whats there and you buy more
Hoarder alert 😁
Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. no such thing as selling what's under the bed. you keep whats there and you buy more Hoarder alert 😁 |
|
|
|
Art spreadsheet., by josephwillis123 on Jul 5, 2018 23:08:27 GMT 1, no such thing as selling what's under the bed. you keep whats there and you buy more Hoarder alert 😁
no such thing as selling what's under the bed. you keep whats there and you buy more Hoarder alert 😁 Yes, this is my exact problem! I think I will get in touch with the artist about buying a new original, and then I will have a goal with how much I need to raise. Maybe this will be the push I need to sell some pieces. I suppose its not always about quantity..... |
|
|
|
warwolf
New Member
Posts • 255
Likes • 186
April 2018
|
Art spreadsheet., by warwolf on Jul 5, 2018 23:17:33 GMT 1, Yes, this is my exact problem! I think I will get in touch with the artist about buying a new original, and then I will have a goal with how much I need to raise. Maybe this will be the push I need to sell some pieces. I suppose its not always about quantity.....
Who is the artist in question?
Yes, this is my exact problem! I think I will get in touch with the artist about buying a new original, and then I will have a goal with how much I need to raise. Maybe this will be the push I need to sell some pieces. I suppose its not always about quantity..... Who is the artist in question? |
|
|
|
Art spreadsheet., by Happy Shopper on Jul 6, 2018 7:56:57 GMT 1, Rather than a spreadsheet I just use expressobeans.
Makes it easier to remember what I have and decide what to sell.
I had the same idea recently about selling smaller pieces and prints to by a few originals.
Sold a few prints... But also bought a few new ones!!
Rather than a spreadsheet I just use expressobeans.
Makes it easier to remember what I have and decide what to sell.
I had the same idea recently about selling smaller pieces and prints to by a few originals.
Sold a few prints... But also bought a few new ones!!
|
|
Hubble Bubble
Junior Member
Posts • 4,094
Likes • 3,525
December 2010
|
Art spreadsheet., by Hubble Bubble on Jul 6, 2018 8:04:06 GMT 1, Art buying is very straightforward and can be expressed by appropriating a formula from cycling. For that sport, the formula is:
Bikes owned = n + 1
(Where n = the current number of bikes)
Simples 
Art buying is very straightforward and can be expressed by appropriating a formula from cycling. For that sport, the formula is: Bikes owned = n + 1 (Where n = the current number of bikes) Simples |
|
hibster
New Member
Posts • 227
Likes • 214
October 2013
|
Art spreadsheet., by hibster on Jul 6, 2018 13:17:48 GMT 1, whilst the correct number of bikes owned (x) can be expressed as x = n+1 where n is the number currently owned it can also be written as x = s -1 where s = the number of bikes owned that would result in separation from your partner (rule 12)
whilst the correct number of bikes owned (x) can be expressed as x = n+1 where n is the number currently owned it can also be written as x = s -1 where s = the number of bikes owned that would result in separation from your partner (rule 12) |
|
|
|
Art spreadsheet., by josephwillis123 on Jul 6, 2018 13:43:27 GMT 1, Faith47. I am a huge fan of her style and work. A couple of my favorites in my collection are:
Jou Vir Ons Suid Afrika - Woodblock print (davidkrutprojects.com/artworks/21763/jou-vir-ons-suid-afrika-by-faith-47)
Psychic Power of Animals (regular ed and the white F&F version) - Etching
Ex Animo (Sepia version. ed. of 7)
Mysterium Tremendum Et Fascinans (Red version ed. of 5)
Faith47. I am a huge fan of her style and work. A couple of my favorites in my collection are: Jou Vir Ons Suid Afrika - Woodblock print ( davidkrutprojects.com/artworks/21763/jou-vir-ons-suid-afrika-by-faith-47) Psychic Power of Animals (regular ed and the white F&F version) - Etching Ex Animo (Sepia version. ed. of 7) Mysterium Tremendum Et Fascinans (Red version ed. of 5) |
|
ab3
New Member
Posts • 323
Likes • 533
December 2017
|
Art spreadsheet., by ab3 on Jul 6, 2018 15:21:29 GMT 1, Its a really useful thing to do just for insurance purposes. I've had mine listed for years, but just a list in a spreadsheet by artist and work below and price paid and what it's currently worth in the market place at replacement value.
Nice keeping a record. I also have photos of all the work stored online on my google drive incase there is a fire and everything goes up in smoke, at least there is a record of it in the cloud.
Its a really useful thing to do just for insurance purposes. I've had mine listed for years, but just a list in a spreadsheet by artist and work below and price paid and what it's currently worth in the market place at replacement value.
Nice keeping a record. I also have photos of all the work stored online on my google drive incase there is a fire and everything goes up in smoke, at least there is a record of it in the cloud.
|
|
Dive Jedi
Junior Member
Posts • 6,159
Likes • 9,384
October 2015
|
Art spreadsheet., by Dive Jedi on Jul 6, 2018 15:41:07 GMT 1, Its a really useful thing to do just for insurance purposes. I've had mine listed for years, but just a list in a spreadsheet by artist and work below and price paid and what it's currently worth in the market place at replacement value. Nice keeping a record. I also have photos of all the work stored online on my google drive incase there is a fire and everything goes up in smoke, at least there is a record of it in the cloud.
Its a really useful thing to do just for insurance purposes. I've had mine listed for years, but just a list in a spreadsheet by artist and work below and price paid and what it's currently worth in the market place at replacement value. Nice keeping a record. I also have photos of all the work stored online on my google drive incase there is a fire and everything goes up in smoke, at least there is a record of it in the cloud. If there is a fire and everything goes up in smoke, it's already in a cloud. |
|
|
|
Art spreadsheet., by Cool User Name on Jul 6, 2018 15:41:52 GMT 1, Rather than a spreadsheet I just use expressobeans. Makes it easier to remember what I have and decide what to sell. I had the same idea recently about selling smaller pieces and prints to by a few originals. Sold a few prints... But also bought a few new ones!!
Anything i buy that they are missing from their DB I add.
Rather than a spreadsheet I just use expressobeans. Makes it easier to remember what I have and decide what to sell. I had the same idea recently about selling smaller pieces and prints to by a few originals. Sold a few prints... But also bought a few new ones!! I use expressobeans to keep track of my collection too and find it very useful. Anything i buy that they are missing from their DB I add. |
|
|
|
Dive Jedi
Junior Member
Posts • 6,159
Likes • 9,384
October 2015
|
Art spreadsheet., by Dive Jedi on Jul 6, 2018 15:42:35 GMT 1, Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. no such thing as selling what's under the bed. you keep whats there and you buy more
Sell the prints that are under the bed . Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. no such thing as selling what's under the bed. you keep whats there and you buy more I actually had to buy a spare bed just to store more prints..... |
|
mrred11
New Member
Posts • 286
Likes • 114
June 2018
|
Art spreadsheet., by mrred11 on Jul 14, 2018 21:45:40 GMT 1, Can you post a copy of your spreadsheet? i would love to try it out.
Can you post a copy of your spreadsheet? i would love to try it out.
|
|
mack
New Member
Posts • 288
Likes • 179
July 2018
|
Art spreadsheet., by mack on Jan 26, 2019 22:59:06 GMT 1, Was thinking about starting a new thread, but might as well bump this one. Have anyone found any good apps to keep track of your collection? Excel is boring...
Was thinking about starting a new thread, but might as well bump this one. Have anyone found any good apps to keep track of your collection? Excel is boring...
|
|
Wisconinla
New Member
Posts • 627
Likes • 583
September 2017
|
Art spreadsheet., by Wisconinla on Jan 27, 2019 6:31:00 GMT 1, And how do you “use expressobeans”?
And how do you “use expressobeans”?
|
|
Gard
Junior Member
Posts • 1,604
Likes • 1,243
June 2012
|
Art spreadsheet., by Gard on Jan 27, 2019 12:13:22 GMT 1, There's a lot of payed solutions for this (Artlogic, Artbutler and Collectrium might be the biggest). But Airtable is a good free online solution. It looks and works like a spreadsheet, bit it's built more like a database. Here you can save images and invoices for each work and all other info you desire.
There's a lot of payed solutions for this (Artlogic, Artbutler and Collectrium might be the biggest). But Airtable is a good free online solution. It looks and works like a spreadsheet, bit it's built more like a database. Here you can save images and invoices for each work and all other info you desire.
|
|
pada1
New Member
Posts • 627
Likes • 424
August 2012
|
Art spreadsheet., by pada1 on Jan 27, 2019 14:41:34 GMT 1, I built my own excel spreadsheet with a bunch of indicators to indeed know better my habits and how I evolved as a collector for the past few years. I have also put some VBA into it to get automatically prices from Expressobeans. However they don't have much price updates, especially for the art released years ago.
Would anyone recommend a good source of prices, ideally public/free?
I checked Airtable on Gard 's recommendation. Very nice tool. Thinking to switch to it, as it makes the list more mobile and nice looking Thanks!
I built my own excel spreadsheet with a bunch of indicators to indeed know better my habits and how I evolved as a collector for the past few years. I have also put some VBA into it to get automatically prices from Expressobeans. However they don't have much price updates, especially for the art released years ago. Would anyone recommend a good source of prices, ideally public/free? I checked Airtable on Gard 's recommendation. Very nice tool. Thinking to switch to it, as it makes the list more mobile and nice looking Thanks! |
|
maven
New Member
Posts • 589
Likes • 746
November 2017
|
Art spreadsheet., by maven on Jan 27, 2019 17:45:38 GMT 1, I just keep a folder on my computer with copies of my invoices. I think if I did more than this it would no longer feel like a hobby and more like a job!
I just keep a folder on my computer with copies of my invoices. I think if I did more than this it would no longer feel like a hobby and more like a job!
|
|
piggybank
New Member
Posts • 4
Likes • 5
February 2018
|
Art spreadsheet., by piggybank on Jan 30, 2019 9:28:28 GMT 1, I've always used a simple excel for my current inventory and wish list. The wish list has some auto updating currency pairs on the side. Never heard of expressobeans but will check it out.
I've always used a simple excel for my current inventory and wish list. The wish list has some auto updating currency pairs on the side. Never heard of expressobeans but will check it out.
|
|
|
|
Fake
Artist
Junior Member
Posts • 2,376
Likes • 2,143
July 2008
|
Art spreadsheet., by Fake on Jan 30, 2019 10:04:13 GMT 1, Would be nice to have an app that also keeps recent sales on ebay and auction houses of the works you have entered in to the app.
Would be nice to have an app that also keeps recent sales on ebay and auction houses of the works you have entered in to the app.
|
|
|
|
Art spreadsheet., by josephwillis123 on Feb 12, 2019 14:56:25 GMT 1, I think your on to something... And you can set it up to get alerts whenever a piece that you have marked comes up for sale or sales.
I think your on to something... And you can set it up to get alerts whenever a piece that you have marked comes up for sale or sales.
|
|
soupy
Junior Member
Posts • 2,108
Likes • 2,610
April 2014
|
Art spreadsheet., by soupy on Feb 12, 2019 15:28:29 GMT 1, I think your on to something... And you can set it up to get alerts whenever a piece that you have marked comes up for sale or sales.
EB also keeps track of ebay sales (as long as they are user entered). they don't track auction houses but members can enter them themselves.
I think your on to something... And you can set it up to get alerts whenever a piece that you have marked comes up for sale or sales. expressobeans has a "wanted" section and you can get ebay alerts for auctions (and you can get trade alerts of other members that post it "for sale/trade"). however, ebay alerts only show up if a user enters it into the expressobeans listing. EB also keeps track of ebay sales (as long as they are user entered). they don't track auction houses but members can enter them themselves. |
|
. Buy another one or two originals and hang them. This way you can enjoy them and most of the time they will increase in value, if this matters to you. 
