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!