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 39### Output 40 41<img src="example.png" border="0" /> 42 43## To Do 44 45Not yet tested with cells that span multiple columns or rows. 46 47## Version History 48 492026-02-25 - First version with basic functions.
