I'm trying to run an excel calculation using PI data (Real time inputs),please let me know if anybody have encountered any issue regarding the process. thanks!

I'm trying to run an excel calculation using PI data (Real time inputs),please let me know if anybody have encountered any issue regarding the process. thanks!

Thanks Wilson, I am on the process of creating a simple algorthm in excel like timer, totalizer etc. The intent is that I will use Sheet1 for all PI inputs that will be use in Sheet2. i.e. If Sheet1! A1 = 1 then trigger the timer in Sheet 2. Cell B2.

In other words, I am using specific sheet just for all PI real data inputs that will be use to all associated calculation in Sheet 2.

Hope this make sense.

Thanks!

If it was my task i think i would go down the path of combining performance equations or Totalizers(apply filter for the parameters you want to trigger your totalizer) under the Points tab in the Pi System Management Tools. I think you could also do it with excel but it might require some VBA to make it a real time totalizer, i am not 100% sure i have not done this.

Jerry,

This will work, I've created similar spreadsheets in the past. However, using the performance equations also works well.

Hi Jerry,

I have tested in my own spreadsheet and it is working fine according to what you intend to achieve. Just make sure that you set the real time PI value to update automatically in order to see the changes (Click on the green update button in Datalink ribbon). You can configure your desired update frequency by selecting "Settings" in the Datalink ribbon and enter a value for "interval" field (in seconds).

Hope it helps!

Just a follow up question, I am doing a multi sheets (i.2=e. 10 sheets ) in a workbook and each sheet has it's own PI data input used in Calculation.

Does the Pi current value data updates even the sheet isnt open. In other words, I am viewing/open Sheet No2, of the workbook does Sheet Nos1, 3,4,5,6,7,8,9,10 of the same work book Data updating?

Hope this make sense. I appreciate all your inputs.

Thanks!

Hi Jerry,

I assume that you are using "Current Value" of PI Data to perform excel calculation. A simple formula to get the current real time value of a tag will look like:

=PICurrVal("<tagname>",0,"<PIServerName>")

I would appreciate if you can describe more about the calculation that you are trying to perform and the issue that you ran into so that I can further assist you.

Also, what is the version of Datalink you are using currently?