|
|
Rank: Advanced Member
Groups: Member
Joined: 9/3/2009
Posts: 32
Location: Massachusetts, USA
|
Hello RJK , I have a list of tags in column A that changes due to the user input. The goal is to create a macro (for a command button for e.g. )which will display the properties of tags , mainly Minimum , Maximum , Average and Descriptor for a given Start and End time on the sheet.  This could be done by the help of PIDataObject and using pbwPropertyDescriptorEnum. The constants that should be used are respectively pbwMinimum, pbwMaximum, pbwAverage, pbwDescriptor. Thanks in advance. Kapil
|
|
|
|
|
|
|
|
Rank: Member
Groups: Member
Joined: 5/14/2009
Posts: 28
Location: UK
|
Hi,
Will the functions in PI Datalink not suffice?
It already has built in calculation functions for min,max and average.
And with version 4.11 it will even update at a defined rate.
.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 9/3/2009
Posts: 32
Location: Massachusetts, USA
|
That is true. But this is the case of dynamic tags. The tags are populated based on what system the user is choosing.
So the no of tags in the column won't be the same anytime. Only solution to this problem is programing.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 409
Location: Cheshire, United Kingdom.
|
Hello, I am with ThePIman on this one, you should look at the built in functions from PI-Datalink. Even with a dynamic number of tags you just adjust the Formula or FormulaArray to cover the number of tags and different PI servers. So whilst there is small amount of programming required, it is just Excel manipulation via VBA. Cheers, Rhys.  OSIsoft PI System SpecialistsPI consultancy on PI Systems, PISDK, AFSDK, OLEDB etc and PI custom developments. Well pretty much anything to do with PI!
|
|
|
|
Guest
|
