OneNote PowerToys » Blog Archive » Table Sum Powertoy for OneNote

Table Sum Powertoy for OneNote

December11

John Guin has post one of many new powertoys to come over the next week…

Table Sum Powertoy for OneNote

As promised, here is the first of a week’s worth of addins/powertoys for OneNote 2007. This addin will sum the columns of a table for you and add the new row to the bottom. It ignores non-numeric values in the column. It’s only requirement is that you need to click in a table to select it before hitting the Sum button (although it will prompt you for clicking the table if you need to).

It does have some limitations. Inking (writing numbers in tables w/o converting them to text) is not supported, and tables within tables will cause problems.

Here’s the link for the setup file: http://johnguin.members.winisp.net/Shared%20Documents/table_sums.zip

Alternate location: http://elhombre.members.winisp.net/api/table_sums.zip

And the source code: http://johnguin.members.winisp.net/Shared%20Documents/table_sums_Source.zip

Alternate location: http://elhombre.members.winisp.net/api/table_sums_Source.zip

Standard setup directions apply: ensure OneNote has exitied, run setup.exe (as an admin on Vista) and install for all users.

Here it is in action. Before adding the columns:

And after:

(And there is a hidden preview for another addin to be released later this week in the images above. Can you find it?)

There is a lot to do with this from here. Adding support to sum rows (relatively easy, but requires some new UI), performing other simple math routines, completely ignoring columns which have no numbers at all, perhaps applying boldface to the answers and similar tasks would all be appreciated. Moving this code over to the Object Model at www.codeplex.com/onom and extending it there is also a task on my radar.

As always, let me know what you think.

Questions, comments, concerns and criticisms always welcome,

John

Share and Enjoy:

posted under Taskbar & Utilities

9 Comments to

“Table Sum Powertoy for OneNote”

On December 19th, 2007 at 7:06 am gabe Says:
Seems the picture links are dead?
On December 19th, 2007 at 10:06 am gabe Says:
Seems the picture links are dead?
On February 10th, 2008 at 4:35 pm C Says:
Awesome! Also the coming improvements you listed look great too.
On February 10th, 2008 at 7:35 pm C Says:
Awesome! Also the coming improvements you listed look great too.
On March 5th, 2008 at 7:47 am Bob Says:
I downloaded and installed, but I must have missed something….

How do I get this toy to total?

Thanks!
On March 5th, 2008 at 10:47 am Bob Says:
I downloaded and installed, but I must have missed something….

How do I get this toy to total?

Thanks!
On September 2nd, 2008 at 5:27 pm Jessica Says:
Suggestion: sort/filter ability for tables.
I sort my assignments in Excel by due date, and then filter them out as I've finished them. Being able to just do this in OneNote would be very cool, and think others might find it helpful, including even those of us who don't work w/ numbers in our work. I have no idea how to program anything, but if anyone's interested you'd have my undying gratitude…. thanks!
On October 26th, 2008 at 5:57 am Rodface Says:
I want to takeaway dates so i know my deadlines and was wondering if the pics would work and A1-B1 he said about that A1 A2 possible
On November 16th, 2008 at 8:28 pm eq plat Says:
Cool powertoy. However, the holy grail here has got to be excel embedded into notebook pages like it can be into a word doc. Even better would be some native editing capabilities without opening the full blown excel application in the background. Is this on the team's radar?