Quote:
Originally Posted by Inukami
@latepaul - Do you export the price values to get the TOTAL price? Why is price so important to have for you? You like to see how much you spend?
|
I think I added it because someone else talked about it on here! I do like to keep an eye on how much I am spending. Actually I don't do that as much as I used to. I used to feel guilty if I was buying new books (especially if they might later go on sale) when I had so many unread ones.
I actually run SQL directly against the calibre database to look at things like total price. I work in databases so it's pretty natural for me.
So I have a script called "mr_status", which if I run it now shows me this:
Code:
MR Report for Year beginning: 2018-01-01
title num_books
---------- ----------
Read Books 8
TBR 560
title num_books total_cost
------------ ---------- ----------
Money Spent 4 £ 14.85
Free Books 2 £ 0.00
Cost of TBR 431 £ 922.40
Cost of Read 7 £ 16.65
NB: counts with prices may be out due to books with no price
So I've bought 4 books this year, spending £14.85. But I've read 8 which cost £16.65 - so that's good because I'm reading more cost-wise than I'm spending. So I've reduced that "Cost of TBR" figure a little bit.
I'm not too bothered by that by the way. It has built up over years. My spending on books is still less than on things like coffee.
You can also see that I read 8 books but only 7 appear in the price section. That's because one (Frankenstein) was a PD title that I got for free.
Actually I've read 9 books this year, but the other one was a re-read and my "read date" column only records the first read. I'm OK with that, particularly when looking at the price. Counting the full price as part of the read when I've read it before wouldn't be quite right.