Sorry, I didn’t notice that accumulation happens on the group level for the max value in a step. So times in each step are added in top of cumulative max values of all previous steps. Therefore we need to:
Get max values of each step
Get a cumulative sum of them
Bring them to the next step
Add step times to the cumulative sum
Here is an example that does group-level accumulation.
What you have is great. But the engineers now through me a curve ball. There is both a Step and Cycle, and the step time resets based on both. A test has multiple steps, and the steps restart after a cycle). But the step number does not necessary go back to 1.
(this is an artifact of the test equipment which is built in China, and the excel table is output by it).
I am appending the file, without the voltage values, but just the step time, and what they want for the Relative time (it won’t be in the source data) as well as the step and cycle.
Then your groups are now defined by both step and cycle. If you understood my solution, you should be able to modify it to accommodate cycles too. If you didn’t understand it, let me know what causes questions.
Then again, I think I may have to go back to the Material Scientists. I think they may have given me bad data (I don’t see step time (s) after cycle 3, step 3.