ello, Is there a way to filter data based on the time-elapsed with PI-Excel interface. For example, I have data on PI for 1 hour and I want to find the maximum value of this data. However, I want the program to ignore transient values, that is values that only last for 2 seconds. If I could filter those transient values (that is values greater than 2 seconds), I would then want to find the maximum of these values. Please help out! Your help would be greatly appreciated.

You can use Excel functions to filter the data once you have it in Excel.

I've created an example that runs calculates the delta t between value(t) and value (t-2). If that delta is 10 or less, drop the middle value.

I use multiple columns to acheive this because it makes it easier to follow what each formula does, but it can be condensed a single column.

Then, to add an extra step, I can easily test the size of the transient spike by taking the absolute value of the difference between the transient value and the average of the surrounding values.

In the "Final" column I add a test for the size of the spike. Now only spikes larger than 15 will be filtered from the results. Note that the value TRUE in the "Final" column does not impact the results of the the MAX() forumula in the bottom row. Also, note that another spike of 150 was not filtered out because it has a duration longer than 5 seconds.

EDIT: Forgot to attach the example file.