Hi all,

I was wondering if there is any way to perform optimization calculations (similar to, say, the GRG Linear algorithm used by the Excel Solver add-in) can be performed within PI/AF, either out of the box or programmatically. Reviewing the available functions of PI PE, AF Formulas, and AF Analyses, as well as the AFSDK help file, I was unable to find anything related. Appreciate any insights you could share

Thanks!

Hi Vincent,

We do not have many statistical optimization (gradient descent, root-finding, etc.) functions within PI libraries, mainly because our data access products are aimed at providing methods to get data out of (and into) the PI System, and we like customer's to use third-party tools for statistical/mathematical calculations, since other data sources/platforms may be involved and those libraries would be more mature and optimized. We have a White Paper below on how to get PI data into MATLAB which may be of interest.

White Paper - Using PI Data with MATLAB

Other tools like R and Python have also been used by customers to do these sorts of analyses. Let us know if you have additional questions.