arbrandt / OPGEE

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

Effective output energy stream drawing diluent co-product treatment instead of NG #52

Closed qlangfitt closed 5 years ago

qlangfitt commented 5 years ago

On the Energy Summary sheet, the effective output energy stream (E117) references Table 3 above to draw allocation/displacement treatment. The formula pairs the secondary product output with an on/off factor for displacement for each product. The on/off factor multiplied by the natural gas output stream references the allocation/displacement treatment for diluent rather than natural gas. I believe the formula should read: =E111+E113(1-G79)+E114(1-G75)+E115(1-G77)+E116(1-G83)

Making the fix on my end significantly improves the correlation between OPGEE 2.0 and 3.0 (see plots below; line represents 1:1 relationship).

olrds-op3-points

olrds-op3-points_v2

arbrandt commented 5 years ago

Found and fixed independently! Good catch. I found this this morning when debugging issues between 2.0 and 3.0. That is what I get for falling behind on github issues!