README.md
1# DokuWiki Plugin: AV Math Table
2
3Adds math to columns for Dokuwiki tables.
4
5## Install and documentation:
6
7* https://www.dokuwiki.org/plugin:avmathtable
8* Licence: GPL-2.0 (https://www.gnu.org/licenses/old-licenses/gpl-2.0.en.html)
9* Author: Sherri W. (https://syntaxseed.com)
10
11## Usage
12
13### Format
14
15<img src="syntax.png" border="0" />
16
17```
18<mathtable>
19^ Name ^ Deposited ^ Balance ^
20| John | 25| 500 |
21| Mary | 40.5| 680.5 |
22^ Subtotal ^ ^ =SUM ^
23| Lex | 10| 140 |
24| Sue | 18| 200.6 |
25^ Average / Total ^ =AVG^ =SUM ^
26</mathtable>
27```
28
29Column headers (^) and alignment are preserved.
30
31### Available Commands
32
33Commands operate on the **numeric** column values above them. Non-numeric or cells with these special commands are ignored.
34
35* `=AVG` - Calculate the average of the numeric values in this column so far.
36* `=SUM` - Calculate the sum/total of the numeric values in this column so far.
37* `=CNT` - Display the number of numeric values in this column so far.
38* `=MAX` - Display the maximum numeric value in the column.
39* `=MIN` - Display the minimum numeric value in the column.
40
41### Output
42
43<img src="example.png" border="0" />
44
45## To Do
46
47Not yet tested with cells that span multiple columns or rows.
48
49## Version History
50
512026-02-26 - Make it work with 0 decimal numbers like for currency (8.00). Add MIN/MAX commands.
522026-02-25 - First version with basic functions.
