There are three output streams from the Heavy Oil Upgrading process: (1) upgraded oil to storage; (2) petrol coke generated from upgrader; and (3) process gas exported from upgrader. The current framework calculates all of them independently. I would suggest calculating (1) and (3) first and then using mass balance to calculate (2). Here is what I changed
Change Cell K132 to =IFERROR((SUM(E11:H14)+SUM(E16:H27)-SUM(M11:M14)-SUM(M16:O27))/M96,0)
b).
There are three output streams from the Heavy Oil Upgrading process: (1) upgraded oil to storage; (2) petrol coke generated from upgrader; and (3) process gas exported from upgrader. The current framework calculates all of them independently. I would suggest calculating (1) and (3) first and then using mass balance to calculate (2). Here is what I changed
Change Cell K132 to =IFERROR((SUM(E11:H14)+SUM(E16:H27)-SUM(M11:M14)-SUM(M16:O27))/M96,0) b).