<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body><div style="text-align: left;"><br><br>Dave, <br><br>I have a script that sums row and sums columns putting in a markup in the summing row/column and quite a bit smarter then the code below. Haven't looked at it in a while. <br><br>Your problem is similar and could be solved using 'relative' addressing. Recognize cells which have the sequence you need and modify them, something like (for simple tables):<br><br> Markup('celldiv','>{$var}'<br> ,'/([|][|] *(\d+(?:[.,]\d+)) *[|][|] *(\d+(?:[.,]\d+)) *[|][|] *)[(][(](+|-|/*)[)][)]/e'<br> ,"'$1'.($2$4$3)");<br><br>This recognizes 2 numeric cells leading up to a third containing the ((/)) markup. <br><br>The same markup would allow ((+)), ((-)) and ((*)) also. <br><br>It will only perform its magic on numeric inputs, it won't cascade into formulas. <br><br>/jm<br><br><br><br><br><br><div><span class="gmail_quote">On 12/27/06, <b class="gmail_sendername">DaveG</b> <pmwiki@solidgone.com> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Is there any way to do basic computations in PMWiki? I have an excel<br>spreadsheet that I'd like to move onto the wiki. The sheet has the<br>following columns (actually a few more, but these are the core):<br><br>Gallons - Miles - Miles/Gallon<br><br>I'd like to be able to enter the first two cols and have PM calculate<br>the third. Additionally I'd like to maintain a "Average of Miles/Gallon"<br>number as well.<br><br>Is the built-in functionaity to do this, or a Recipe somewhere?<br><br><br> ~ ~ Dave<br><br></blockquote></div><br></div><br /><hr />Try amazing new 3D maps <a href='http://maps.live.com/?wip=51' target='_new'>Check it out!</a></body>
</html>