Hello,
I have two signals measured every second.
When Signal_1 is below a certain value Signal_2 should/will change; and i need to measure the latency between the two.
In the table below at 11:42:13 Signal_1 is dropping below (or equal) to 49.9 and Signal_2 is following 7 second later (at 11:42:20). Signal 2 can drop to 0 or to a lower value (and i should measure the difference absolute and percentage).
Later, at 11:42:33 Signal_1 is going up above 49.8 and Signal 2 is going up again, 22 seconds later at 11:42:55
I should also monitor if Signal 2 is moving erratically without Signal_1 to be changing around the 49.8 value.
| Time | Signal_1 | Signal_2 | Above 49.8 | below 49.8 | Latency |
| 11:42:04 | 50.0 | 10.9 | 11:42:04 | - | |
| 11:42:05 | 50.0 | 10.9 | 11:42:05 | - | |
| 11:42:08 | 50.0 | 10.9 | 11:42:08 | - | |
| 11:42:10 | 50.0 | 10.8 | 11:42:10 | - | |
(A1) | 11:42:13 | 49.8 | 10.8 | - | 11:42:13 | 7 |
| 11:42:14 | 49.8 | 10.8 | - | 11:42:14 |
| 11:42:15 | 49.8 | 10.8 | - | 11:42:15 |
| 11:42:18 | 49.8 | 10.8 | - | 11:42:18 |
(A2) | 11:42:20 | 49.8 | 0.0 | - | 11:42:20 |
| 11:42:22 | 49.8 | 0.0 | - | 11:42:22 | |
| 11:42:24 | 49.8 | 0.0 | - | 11:42:24 | |
| 11:42:26 | 49.8 | 0.0 | - | 11:42:26 | |
| 11:42:28 | 49.8 | 0.0 | - | 11:42:28 | |
| 11:42:30 | 49.8 | 0.0 | - | 11:42:30 | |
| 11:42:32 | 49.8 | 0.0 | - | 11:42:32 | |
(B1) | 11:42:33 | 49.9 | 0.0 | 11:42:33 | - | 22 |
| 11:42:34 | 49.9 | 0.0 | 11:42:34 | - |
| 11:42:36 | 49.9 | 0.0 | 11:42:36 | - |
| 11:42:39 | 49.9 | 0.0 | 11:42:39 | - |
| 11:42:40 | 49.9 | 0.0 | 11:42:40 | - |
| 11:42:42 | 49.9 | 0.0 | 11:42:42 | - |
| 11:42:43 | 49.9 | 0.0 | 11:42:43 | - |
| 11:42:46 | 49.9 | 0.0 | 11:42:46 | - |
| 11:42:49 | 49.9 | 0.0 | 11:42:49 | - |
| 11:42:52 | 49.9 | 0.0 | 11:42:52 | - |
(B2) | 11:42:55 | 49.9 | 4.7 | 11:42:55 | - |
| 11:42:56 | 49.9 | 4.7 | 11:42:56 | - | |
| 11:42:59 | 49.9 | 4.7 | 11:42:59 | - | |
| 11:43:02 | 49.9 | 4.7 | 11:43:02 | - | |
| 11:43:03 | 49.9 | 4.7 | 11:43:03 | - | |
| 11:43:05 | 49.9 | 5.2 | 11:43:05 | - | |
| 11:43:08 | 49.9 | 5.2 | 11:43:08 | - | |
| 11:43:10 | 49.9 | 5.2 | 11:43:10 | - | |
thank you,
Alex