search

arbrandt / OPGEE

Oil Production Greenhouse Gas Emissions Estimator
18 stars 4 forks source link

Non exclude path for oil cause mass imbalance #468

Open wennanlong opened 2 years ago

wennanlong commented 2 years ago

In the Crude oil dewater tab, Cell O12 (crude oil upgrader path) does not eliminate the possibility of crude oil dilution path. So does P12.

So I would suggest changing O12's formula to =IF($N$1="ON",IF(AND('Flow Sheet'!AW160="OFF",Upgrader_type<>0, Fraction_diluent=0),E12,0),0)

Changing P12's formula to =IF(N1="ON",IF(AND('Flow Sheet'!AW160="OFF",Fraction_diluent<>0, Upgrader_type=0),E12,0),0)

Then I suggest using the crude oil storage path as the last choice if other choices are not valid. Change N12 to =IF(N1="ON",SUM(E12:G12)-M12-O12-P12,0)