wennanlong
commented
1 year ago The solution provided above needs to be corrected. Here is the updated solution:
Problem Statement: When the fraction of diluent is close to one, OPGEE does not consider crude oil produced from the reservoir. The oil will be delivered primarily from imported diluent.
Solution:
In the Well and Downhole Pump sheet, assuming a 0% loss rate for completion and workovers:
Cell M117: =IF($N$1="ON",IF('Drilling & development'!M50=0, 0,('Drilling & development'!M501000)/(O201000)),0) Cell M118: =IF($N$1="ON",IF('Drilling & development'!M50=0, 0, ('Drilling & development'!M501000)/(O201000)),0) Cell M122: =IF($N$1="ON",IF('Drilling & development'!M61=0,0, ('Drilling & development'!M611000)/(O201000)),0) Cell M123: =IF($N$1="ON",IF('Drilling & development'!M61=0, 0, ('Drilling & development'!M611000)/(O201000)),0)
In the Separation sheet:
Cell M12: =IF($N$1="ON",IF(Fraction_diluent=1,0,Oil_prod(1-Oil_sands_mine_int_01-Oil_sands_mine_nonint_01)M99*liters_per_bbl/1000),0)
In the HeavyOilDilution sheet:
Cell M72: =IF(1-Fraction_diluent<=0.001,0,M71/(IF(Oil_sands_mine_nonint_01<>0,F57,E57))/m3_per_bbl) Cell M73: =IF(1-Fraction_diluent<=0.001,Oil_prod,Oil_prod/(1-Fraction_diluent)) Cell M74: =IF(1-Fraction_diluent<=0.001,dilbit_bbl_per_day,M73Fraction_diluent) Cell M77: =IF(N1="ON",IFERROR(M761000/((M73)*liters_per_bbl),1),Oil_sg)
Please make the necessary changes in the respective sheets as indicated above.
I encountered a problem with the calculated API values in the "HeavyOilDilution" tab. Specifically, I noticed that the API values become negative when the diluted crude reaches a certain point. This should not happen, as API values must be positive.
Change Cell M77 from "HeavyOilDilution" tab to
=IF(N1="ON",IFERROR(M761000/((M73+bitumen_bbl_per_day)liters_per_bbl),1),Oil_sg)