Total valuation...?

TalkRecommend Site Improvements

Join LibraryThing to post.

Total valuation...?

1Malc2311
Mar 24, 7:44 am

Is there a way, having listed all of my items of note, with an estimated individual value, to get a total valuation on them all ? Or is a case of (rather mundanely) sitting there with a calculator?

2bnielsen
Mar 24, 7:54 am

>1 Malc2311: You can export as tsv or xlsx and import into Excel or similar. Much quicker than with a calculator :-)

/Top bar/More/Export files

or just go to this link

https://www.librarything.com/export.php

3knerd.knitter
Mar 24, 7:57 am

>1 Malc2311: In which field did you enter the value? On https://www.librarything.com/stats/MEMBERNAME/collector you can see the total list price of all your books. We could add sums of the other amount fields as well.

4Malc2311
Mar 24, 8:28 am

>3 knerd.knitter: Hi there - thanks for replying. All of my valuations are shown in the 'Value' field and it also includes DVD, Blu Ray, Vinyl etc... and I would love to be able to see a total value...

5knerd.knitter
Mar 24, 8:36 am

>4 Malc2311: Let me get that added. Give me a couple hours.

6bnielsen
Mar 24, 9:09 am

This is fun. I found the calculated sum of List Price rather high but it seems to be correctly calculated. But quite a lot are books I've borrowed at the local library ;-) (And returned, so I'll exclude them from the sum).

7knerd.knitter
Mar 24, 9:17 am

>5 knerd.knitter: You should be able to see the total purchase price and total value of your books at https://www.librarything.com/stats/MEMBERNAME/collector now