Can I generate sum of column or columns?

GeekyGal · 09-28-2011, 12:36 PM

Kindly Calibre Gurus:

Is there a relatively easy way to sum a custom column "Price" which has floating point numbers as its format? If so, where does the result display? If I want to get really fancy, can I sum column Price and column Shopping List to see how much the projected total would be? I'm not good at regex, so simplified instructions would be most appreciated.

FWIW, I'm running Calibre 8.20 on a Mac OS 10.7 and on a Win 7 64 bit PC, though I would think that this would work the same way for both.

This seems like something which has probably been asked and answered, and most likely in the Manual. If so, I'm missing it. If it has been answered here before, I'm not searching correctly. Sorry. I did try to do my homework. Thank you so much.

GeekyGal (feeling most un-geeky today)

DoctorOhh · 09-29-2011, 12:10 AM

Quote:

Originally Posted by GeekyGal

Is there a relatively easy way to sum a custom column "Price" which has floating point numbers as its format? If so, where does the result display? If I want to get really fancy, can I sum column Price and column Shopping List to see how much the projected total would be?
...~~~...
This seems like something which has probably been asked and answered, and most likely in the Manual.

It may have been asked, but in over two years I can't recall this being asked or answered. I don't believe what you want is a main feature, but with the robust template programming language available to the end user I can't say for sure that it's impossible.

GeekyGal · 09-29-2011, 01:26 AM

Thank you. I feel so much better that I am not just missing something obvious. \

kovidgoyal · 09-29-2011, 02:35 AM

I doubt summing a column is possible (the template language acts only on a single book at a time), but you should be able to sum the fields from two columns for a single book and output the result in a third column

Manichean · 09-29-2011, 04:48 AM

You could create a CSV catalog, import that to your favourite spreadsheet application and use that to sum.

GeekyGal · 09-29-2011, 07:32 PM

Thank you, all. I was trying to skip the export / import steps, but that will work, too. I see now that this works on one book at a time, not across them. I appreciate that you took the time to answer this.

09-28-2011, 12:36 PM	#1
GeekyGal Enthusiast Posts: 40 Karma: 13888 Join Date: Sep 2010 Device: Kindle FireHD, Kindle3G, iPad, MacBook, iRex Illiad (ret)	Can I generate sum of column or columns? Kindly Calibre Gurus: Is there a relatively easy way to sum a custom column "Price" which has floating point numbers as its format? If so, where does the result display? If I want to get really fancy, can I sum column Price and column Shopping List to see how much the projected total would be? I'm not good at regex, so simplified instructions would be most appreciated. FWIW, I'm running Calibre 8.20 on a Mac OS 10.7 and on a Win 7 64 bit PC, though I would think that this would work the same way for both. This seems like something which has probably been asked and answered, and most likely in the Manual. If so, I'm missing it. If it has been answered here before, I'm not searching correctly. Sorry. I did try to do my homework. Thank you so much. GeekyGal (feeling most un-geeky today)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Q: multi-column PDF to single column mobi format converstion	auburn1975	Calibre	7	01-28-2012 06:11 PM
New Member who NEEDS sum HELP!	MESA62606	Introduce Yourself	3	04-23-2011 03:19 AM
The Sum of All Knowledge	kennyc	News	6	09-30-2009 10:59 PM
split 2-column doc into single columns	braver	PDF	4	09-30-2009 11:15 AM
pdf to lrf with 2 column and 1 column pages in same file	danielwille	Sony Reader	3	11-12-2008 10:57 AM

09-29-2011, 01:26 AM	#3
GeekyGal Enthusiast Posts: 40 Karma: 13888 Join Date: Sep 2010 Device: Kindle FireHD, Kindle3G, iPad, MacBook, iRex Illiad (ret)	Thank you. I feel so much better that I am not just missing something obvious. \

09-29-2011, 02:35 AM	#4
kovidgoyal creator of calibre Posts: 43,996 Karma: 22669822 Join Date: Oct 2006 Location: Mumbai, India Device: Various	I doubt summing a column is possible (the template language acts only on a single book at a time), but you should be able to sum the fields from two columns for a single book and output the result in a third column

09-29-2011, 04:48 AM	#5
Manichean Wizard Posts: 3,130 Karma: 91256 Join Date: Feb 2008 Location: Germany Device: Cybook Gen3	You could create a CSV catalog, import that to your favourite spreadsheet application and use that to sum.

09-29-2011, 07:32 PM	#6
GeekyGal Enthusiast Posts: 40 Karma: 13888 Join Date: Sep 2010 Device: Kindle FireHD, Kindle3G, iPad, MacBook, iRex Illiad (ret)	Thank you, all. I was trying to skip the export / import steps, but that will work, too. I see now that this works on one book at a time, not across them. I appreciate that you took the time to answer this.

Advert

Advert