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
Seems the picture links are dead?
Seems the picture links are dead?
Awesome! Also the coming improvements you listed look great too.
Awesome! Also the coming improvements you listed look great too.
I downloaded and installed, but I must have missed something….
How do I get this toy to total?
Thanks!
I downloaded and installed, but I must have missed something….
How do I get this toy to total?
Thanks!
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!
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
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?
Is there any possibility you could update this for 64-bit OneNote 2010?
Tuhodcown! That’s a really cool way of putting it!
I have looked for a similar tool for long time…My dream is to have a onenote with:
1. some basic function of spreadsheet
2. introduce automatically an hypertext link to a specific website/doc file/ pdf page every time I paste something from somewhere else.
3. To have a formula editor as open math.
With this tools onenote could be amazing.