u/Quinten_MC

So, for a game I am trying to figure out how much "heavy oil" I require to make a set amount of "heavy fuel" and "propene". The issue is, to make propene there come a lot of side products, including the original products of "heavy fuel". See picture 1. (Steam cracked X, requires 1 X for 1.2 steam cracked X, that's why the number don't appear to match)

Pic 1

Light steam cracked light fuel for example produces naphtha, which can then be turned into Mid steam cracked naphtha. But that in turn produces light fuel. So you create a loop of naptha and light fuel. (This also happens for Heavy fuel as you can see.)

Now my question is, can I automatically calculate these loops? Excel usually returns 0 if I try.