Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Wed, 04 Mar 2026 19:04:36 +0000

How to Post a Message for Support

Post From: Pulling Length of Zig Zag Input Data 27, and Time(input data 31)

[2019-12-18 13:48:03]
[Go To First Post]
Sawtooth - Posts: 4315
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.