In the "Drilling and Development" tab, Cell C75 currently employs the formula INDEX(FlowTable, LHV_O_bbl, 14) to calculate land use emissions. However, when the boundary is set to "field", Stream 14 becomes empty, resulting in INDEX(FlowTable, LHV_O_bbl, 14) equalling 0.
To address this issue, please update the formula in Cell C75 to: =SUM(M37:M39)MJ_per_mmbtuOil_prod*INDEX(FlowTable, LHV_O_bbl, 13)/1000000
In the "Drilling and Development" tab, Cell C75 currently employs the formula INDEX(FlowTable, LHV_O_bbl, 14) to calculate land use emissions. However, when the boundary is set to "field", Stream 14 becomes empty, resulting in INDEX(FlowTable, LHV_O_bbl, 14) equalling 0.
To address this issue, please update the formula in Cell C75 to: =SUM(M37:M39)MJ_per_mmbtuOil_prod*INDEX(FlowTable, LHV_O_bbl, 13)/1000000