Create new table from raw data using multiple lookup values

[Luuck234]

All,

I have a rather complicated issue (at least with regards to my programming skills..:p) and was hoping if somebody might be able to help out. I've added an excel file to this thread as an example.

In the tab raw data there are 4 columns: Date/time; Module; Parameter and value. Every line in this table is an event in time obtained from a realtime proces. I would like to create snapshots per module to track changes of the mode of a module (xxx/MODE.TARGET) in time.

So for instance module D32XV207:

At tab Overview I've created a row (2) in which modules have been put which have changed mode (xxx/MODE.TARGET in the parameter column of raw data as trigger) in the raw data overview. In column B I've created a column with times at which I would like to know what the value (column D Raw data) was when ever the trigger (xxx/MODE.TARGET) has been seen. The idea is that a script looks at a given time in column B | tab Overview and looks back in the raw data table when the last event occured compared to the previous time value (delta of 30 seconds). So for instance at time 1-02-2020 3:19:30 the latest change when looking back from this time is at 1-02-2020 3:19:24 where the Value changed to NEW VALUE = AUTO. This NEW VALUE = AUTO should be shown for all following times untill a change is found again in the raw data table. For this example the NEW VALUE = CAS at 3:19:11 will not show up anywere in the new table which is ok. Because the first change happened at 3:19:30 all the values before this time should be given the text Unknown.

I've made another example in blue for D32FC205.

I hope the explanation / question is a bit clear with these examples, please let me know if you need more info / clarification.

Hope somebody can help out!

Best regards,
Lucas

Because the upload file keeps failing (even with a .zip of less then 7MB) i've created this link based on previous discussions on failing uploads:

app. box . com/s/d1r844dka4j0z3v1nxof1eta9hshjjf2

[Luuck234]

Still trying to find a solution for this, anybody perhaps an idea how to tackle this?

Thanks!