Hi,

I am a new user of PI Process book and currently exploring the PI Datalink in Excel to count the number of critical machine trips (Start / Stops) between dates. Could any one help me how to conduct this task ? We have been doing this manually since last few years, to identify those machines which are having highest number of machines trips during last month. Trying to automate this using PI Datalink in Excel.

Thanks in advance.

I am trying to figure out what you are dealing.

If i understand you want to know when one of your values is 0. Well, i am assuming that when it stops, its value is 0.

If it is your problem, you can get the current value in one cell, and try a IF function in another cell, based on your current value.

Good luck!