# [pmwiki-users] Simple math

Martin Fick mogulguy at yahoo.com
Thu Sep 21 14:29:01 CDT 2006

```--- Robin Sheat <robin at kallisti.net.nz> wrote:

> On Thursday 21 September 2006 00:05, Tom Lederer
> wrote:
> I have an idea for an extension to this that would
> be useful. I use PmWiki to
> (among other things) keep track of hours worked.
> Currently I do:
> ||Date ||time start-time end ||hours ||
> ...
> || || ||''total hours'' ||
>
> Is there a way to have the total hours line
> automatically calculated? Perhaps
> something that, if put in a table, checks all the
> columns above it, and if
> followed by whitespace, or
> something like that) inserts the sum. I'm thinking
> perhaps to replace the
> last line with something like:
> || || ||''(:sum:)'' ||

A cool idea, but this seems a like vague.  Should sum
consider the column or the row?  If the column, how
many rows...

> If the flexibility is there, how about automatically
> working out the hours by
> calculating based on the previous column, too, e.g:
> ||Date ||1000-1800 ||(:hours:) hours||
> becoming:
> ||Date ||1000-1800 ||8 hours ||
>
> This isn't so much for laziness (although that's
> certainly a driving factor)
> but it would also help prevent simple maths errors,
> and stop me getting told
> off when I work it out wrong :)
>
> I guess a natural extension of this is primitive
> that may be going too far...

Well, primitive spreadsheet stuff might seem easier
since it would not infer anything from your layout.
Seems like a good use case for me to consider when
designing wikipaths and for Dominique when designing
wikiformulas!

Maybe something like:
(:eval sum({{\$||1(2,3-14)}}) :)

sum rows 3 through 14 from column two of the first
table.  I have to admit, that's ugly. :(

-Martin

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

```