Support Board
Date/Time: Tue, 04 Feb 2025 03:04:39 +0000
Post From: Pulling Length of Zig Zag Input Data 27, and Time(input data 31)
| [2019-12-18 13:48:03] |
| Sawtooth - Posts: 4166 |
|
Set 'Additional Output for Spreadsheets' to Yes so that the Zigzag Line Length outputs SG4 to the spreadsheet. For the Zigzag Time Duration, you must use formulas in three Formula Columns to calculate it, one to create a persistent time of each leg, one to return the time difference at a new leg, and one to convert to the displayed minutes, e.g.: In P3: =IF(ID1.SG4@3<>0,A3,P4) In Q3: =IF(P3<>P4,P3-P4,Q4) In R3: =IF(ID1.SG4@3<>0,Q3*1440,0) where the ZZ study is ID1. |