search

arbrandt / OPGEE

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

Pumping water mass issue in the well and downhole pump #509

Closed wennanlong closed 1 year ago

wennanlong commented 1 year ago

In the Downhole Pump tab of the workbook, there is an issue with the formula in cell M54. The current formula does not provide the correct calculation.

To fix this issue, please update the formula in cell M54 to the following: =(INDEX(FlowTable,Q_W_bbl,102) + INDEX(FlowTable,Q_W_bbl,4))*ft3_per_bbl

myjabbar commented 1 year ago

=AVERAGE(INDEX(FlowTable,Q_W_bbl,101),INDEX(FlowTable,Q_W_bbl,102))*ft3_per_bbl which is the same as

=@INDEX(FlowTable,Q_W_bbl,102)*ft3_per_bbl

Can you please confirm @wennanlong if we still need the above-proposed update?

wennanlong commented 1 year ago

the Cell M54 under downhole pump tab should be (INDEX(FlowTable,Q_W_bbl,102) + INDEX(FlowTable,Q_W_bbl,4))*ft3_per_bbl. water from Stream 102 and Stream 4 needs to be considered in this cell.

I will forward an email I sent to Mohammad to you