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.
