14b3ddbf5SSyntaxseed# DokuWiki Plugin: AV Math Table 24b3ddbf5SSyntaxseed 34b3ddbf5SSyntaxseedAdds math to columns for Dokuwiki tables. 44b3ddbf5SSyntaxseed 54b3ddbf5SSyntaxseed## Install and documentation: 64b3ddbf5SSyntaxseed 74b3ddbf5SSyntaxseed* https://www.dokuwiki.org/plugin:avmathtable 84b3ddbf5SSyntaxseed* Licence: GPL-2.0 (https://www.gnu.org/licenses/old-licenses/gpl-2.0.en.html) 94b3ddbf5SSyntaxseed* Author: Sherri W. (https://syntaxseed.com) 104b3ddbf5SSyntaxseed 114b3ddbf5SSyntaxseed## Usage 124b3ddbf5SSyntaxseed 134b3ddbf5SSyntaxseed### Format 144b3ddbf5SSyntaxseed 154b3ddbf5SSyntaxseed<img src="syntax.png" border="0" /> 164b3ddbf5SSyntaxseed 174b3ddbf5SSyntaxseed``` 184b3ddbf5SSyntaxseed<mathtable> 194b3ddbf5SSyntaxseed^ Name ^ Deposited ^ Balance ^ 204b3ddbf5SSyntaxseed| John | 25| 500 | 214b3ddbf5SSyntaxseed| Mary | 40.5| 680.5 | 224b3ddbf5SSyntaxseed^ Subtotal ^ ^ =SUM ^ 234b3ddbf5SSyntaxseed| Lex | 10| 140 | 244b3ddbf5SSyntaxseed| Sue | 18| 200.6 | 254b3ddbf5SSyntaxseed^ Average / Total ^ =AVG^ =SUM ^ 264b3ddbf5SSyntaxseed</mathtable> 274b3ddbf5SSyntaxseed``` 284b3ddbf5SSyntaxseed 294b3ddbf5SSyntaxseedColumn headers (^) and alignment are preserved. 304b3ddbf5SSyntaxseed 314b3ddbf5SSyntaxseed### Available Commands 324b3ddbf5SSyntaxseed 334b3ddbf5SSyntaxseedCommands operate on the **numeric** column values above them. Non-numeric or cells with these special commands are ignored. 344b3ddbf5SSyntaxseed 354b3ddbf5SSyntaxseed* `=AVG` - Calculate the average of the numeric values in this column so far. 364b3ddbf5SSyntaxseed* `=SUM` - Calculate the sum/total of the numeric values in this column so far. 374b3ddbf5SSyntaxseed* `=CNT` - Display the number of numeric values in this column so far. 38*4a9b1e96SSyntaxseed* `=MAX` - Display the maximum numeric value in the column. 39*4a9b1e96SSyntaxseed* `=MIN` - Display the minimum numeric value in the column. 404b3ddbf5SSyntaxseed 414b3ddbf5SSyntaxseed### Output 424b3ddbf5SSyntaxseed 434b3ddbf5SSyntaxseed<img src="example.png" border="0" /> 444b3ddbf5SSyntaxseed 454b3ddbf5SSyntaxseed## To Do 464b3ddbf5SSyntaxseed 474b3ddbf5SSyntaxseedNot yet tested with cells that span multiple columns or rows. 484b3ddbf5SSyntaxseed 494b3ddbf5SSyntaxseed## Version History 504b3ddbf5SSyntaxseed 51*4a9b1e96SSyntaxseed2026-02-26 - Make it work with 0 decimal numbers like for currency (8.00). Add MIN/MAX commands. 524b3ddbf5SSyntaxseed2026-02-25 - First version with basic functions.
