CRX id
dpmpgcmonekpljonjjdadbbdfkfapgdc
dpmpgcmonekpljonjjdadbbdfkfapgdc
Description from extension meta
Add useful functions for table rows and columns
Image from store
Description from store
UPDATE: Now supports commas for decimal places too!
Adds some useful functions to tables.
When you have a table you want to work on, click the 'Totalizer' icon in the toolbar. When it lights up, you can now right click on a table row or column and choose a simple spreadsheet function from the following:
- Sum (calculate the total)
- Average (work out the average)
- Min (find the smallest or most negative value)
- Max (find the biggest value)
- Count (count the number of values in the row/column)
The result will be added to the end of the row or column.
The 'Exclude Cell' option can be used to remove cells from the function if required. 'Exclude All' does the same thing for each cell in the current row or column. Both can be undone by repeating. 'Clear' will remove all functions from the table.
Note: This obviously works best with rows/columns containing numeric values! Anything that's not a digit, '+', '-', ',' or '.' will be ignored. Results are displayed to two decimal places.
TODO:
- Add user functions, eg A1+B2, etc.
- Add column/row labels
- Export to CSV or google docs.
Version History:
0.90 Now supports commas!
0.80 Add row support
Recalculates when excluding cells
Improved highlight
0.71 Updated to manifest v.2
0.6 Fixed toggle logic to be much simpler
0.5 Added enable/disable button
0.4 Fixed a bug in column highlighting
0.3 Included cells highlighted on hover
Exclude row option added
Exclude is now a toggle
Better column selection
0.2 Updated description
0.1 First working version
Uses Joe Walnes's neat jquery context menu plugin (https://github.com/joewalnes/jquery-simple-context-menu).
Latest reviews
- (2021-07-12) I am Poltergasm: It just works. Managed to easily calculate my total expenditures from a MMO billing table. Thanks!
- (2021-06-01) Algimantas K: Exactly what I was looking for. I hope it will work as it works right now.
- (2021-04-09) Very nice, but the comma separator function is not working.
- (2021-03-11) Peter Kam: Does this work on any page that has columns like Azure DevOps or only online spreadsheets
- (2020-09-25) Liem Do: It stops working now.
- (2020-09-06) Nova Aurata: Very useful for dealing with websites with long tabulated lists (i.e. Internet Banking etc.). There are some field selection peculiarities, but as long as you're careful with what you're asking it to sum and average then it works very well. If hotkey support was implemented for the context-menu functions currently accessible only via the mouse this would be five-stars. :)
- (2019-01-12) Luciano Minervino: Gets the job done.
- (2018-08-29) Jim Grissom: Its probably ok if I could find where its at on my computer
- (2018-03-23) Scott Davis: It's helpful in some cases, but lack of decimal accuracy beyond two floating points makes it have limited use for me. I wish you could adjust this in the settings.
- (2017-11-23) Grzegorz Kolasa: Great, but has problem with comma as a decimal separator in my country :(
- (2016-08-27) Ali A: love it. Many Thanks to you.How can I donate?
- (2016-05-02) Puck Winchester: Does what it needs to - I manage a budget via browser and needed a way to easily calculate totals without exporting it every time. There's a bit of wonkiness that I'm sure can be worked on: sometimes right-clicking to bring up the Totalizer menu and scrolling away would result in the menu being selectable but right-clicking or clicking away wouldn't make it disappear as normal. Would also appreciate a way to calculate rows (perhaps holding ctrl to switch the highlighted axis). Options would be nice as well, such as color of highlighting. Overall: works and glad to have it around.
- (2015-09-28) Yuri Vic: Didn't work at all. Chrome version 44.0.2403.155
- (2015-02-25) Ian Maddox: The functionality is good, but when you install it, some random spammy ad site pops up. It crushed all trust I had for this plugin.
- (2013-09-18) Remy Beharaing: Great idea! Do you think possible to add the same function on: 1. rows (and not only columns) 2. selected value in a row or column, because total are often already existing, but while analyzing, I often need to sumarize part of a line or column Thanks a lot for this work.
- (2012-11-07) Georg Ochsner: Does only work with "." as separator. Would be cool to add an option for languages/number formats which use "," as separator.
- (2012-03-19) Derk Braakman: Great extension! Feature request: Set the amount of decimal places
- (2012-02-27) Francisco Maltez: Awesome, do you think you can multiply the value of one collumn by another and present the result in a new collumn?
- (2012-01-22) Don Schmitt: A simple, handy utility. Especially for computing column subtotals when the site doesn't help with that.