Support Board
Date/Time: Wed, 27 Nov 2024 06:39:51 +0000
Post From: Help Rounding the Total Volume in the Zig Zag Study
| [2014-02-09 15:38:37] |
| Sawtooth - Posts: 4120 |
|
It can be done easily with the Spreadsheet Study study: 1) In the ZZ study, -Set Additional Output for Spreadsheets to Yes -Set Calculate Zigzag Volume to Yes -Set Display Zigzag Volume to No 2) Add the Spreadsheet Study study, -Set the Chart Region to 1 -Give it a name in the Spreadsheet Name field -Set the Draw Style of K(SG1) to Value on High -Set the Draw Style of L(SG2) to Value on Low -On the spreadsheet: cell K3: =IF(AD3>0,AE3/$K$1,0) cell L3: =IF(AD3<0,AE3/$K$1,0) =cell K1: the volume divisor The formulas assume the ZZ study's Line Length is in column AD, and the AccumulatedVolume is in column AE. Requires v1090. |