When trying to calculate the steam generation emissions, mass balance errors were occurring when switching from gaseous fuel to liquid fuel ('Secondary inputs' tab, Cells M272:M273; causing errors to appear in 'Steam Generation' tab, Cells G98:H98).
The error appears to be caused by the formula for calculating exhaust mass flow ('Steam Generation' tab, Cells O93, O101, O109). The formula takes the total no. of moles of exhaust per kg of fuel (SUM(K151:K162)), converts to grams (K168), then multiplies by the mass flowrate of fuel in kg/d (M145). This would give an output in grams, not kg. Correcting this by dividing by 1000 eliminates the mass balance error.
Suggested fix:
'Steam Generation' tab, Cells O93, O101, O109 formula should be corrected to:
=Fuel_input_type_OTSG_gas*SUM(H151:H162)*H168*M144/D168+Fuel_input_type_OTSG_crude*SUM(K151:K162)*K168*M145/1000
This is corrected from:
=Fuel_input_type_OTSG_gas*SUM(H151:H162)*H168*M144/D168+Fuel_input_type_OTSG_crude*SUM(K151:K162)*K168*M145
When trying to calculate the steam generation emissions, mass balance errors were occurring when switching from gaseous fuel to liquid fuel ('Secondary inputs' tab, Cells M272:M273; causing errors to appear in 'Steam Generation' tab, Cells G98:H98).
The error appears to be caused by the formula for calculating exhaust mass flow ('Steam Generation' tab, Cells O93, O101, O109). The formula takes the total no. of moles of exhaust per kg of fuel (SUM(K151:K162)), converts to grams (K168), then multiplies by the mass flowrate of fuel in kg/d (M145). This would give an output in grams, not kg. Correcting this by dividing by 1000 eliminates the mass balance error.
Suggested fix: 'Steam Generation' tab, Cells O93, O101, O109 formula should be corrected to:
=Fuel_input_type_OTSG_gas*SUM(H151:H162)*H168*M144/D168+Fuel_input_type_OTSG_crude*SUM(K151:K162)*K168*M145/1000This is corrected from:
=Fuel_input_type_OTSG_gas*SUM(H151:H162)*H168*M144/D168+Fuel_input_type_OTSG_crude*SUM(K151:K162)*K168*M145