Hi All,

I am in middle of something and need your help to come out.

As we all know, Individual ACE calculations can be tested against any of the below points :

Current value, Maximum value, Minimum value, typical value and User Specified value.

I want to pick **User specific values** from an excel sheet for given number of calculations and test them once.

it will be something like this:

tag testing value

outputtag1 100

outputtag2 200 ..... and so on.

How to do that ? i dont want to go one by one and test calculations .

please help me to write a custom code for the same.

Many Thanks in advance,

prabhat mishra

Hi Prabhat,

Given the situation you describe, it seems like a simpler approach would be to just go ahead, register the ACE calculation and have it running with the ACE scheduler.

With the ACE calculation running, you can then use the spreadsheet C:\Program Files\PIPC\Excel\PIEXAM32.xls to write values to the input tags of your ACE calculation and use the Current Value function of PI DataLink in another (or the same) spreadsheet and check the values of the output tags.

Would this approach be handy in your situation?