Hi!

I am trying to see if there is a clever way to calculate the theoretical yield of the refinery. This value depends on the blend of the feed. There are more than 400 feed types and usually we blend 10-50 of these. For each feed we have polynomial regressions.

I want to automate this with AF, but I couldn't find a good way to do it.

So I have 2 tables:

- Feed type and the coefficients of the polynomial regression (Feed_type, a0, a1, a2, a3)

- Query that brings me the blend of the day, with the volume of each feed type. (Date, Feed_type, Volume)

The calculation is to look for the feed type processed in the day, look for the corresponding coefficients, calculate a value. Repeat with all the feed type of the day (possibly up to 50), sum up and save in a PI Point.

I don't know if I must have to create an attribute to each potencial feed, giving me more than 400 attributes to do that. Is there a way to do a Table lookup and bring all the Feed_type of the day? There is only the first match criteria. I need to bring every feed stock processed with each volume in the day.

Thanks in advance!

Hi Mauricio,

Please accept our apologies for the late response!

Do you have a PI Point which records the current blend? Are you recording the production volume to PI Points?

If you just have the information in relational tables, you may get the information you are after by joining information from tables but this would be outside of PI and almost impossible with Asset Analytics and I agree that creating an attribute for each potential feed is at least not a nice way to get the information you are after.