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