How to remove uncertainty for all processes?

Question

Hi

I am currently doing a Monte Carlo uncertainty analysis on my product system. However, I only want to investigate the uncertainty from my foreground system i.e. the uncertainty from the values I have inputted myself and not include the uncertainty that ecoinvent have added. Is there a way to remove the uncertainty ranges from all processes in OpenLCA?

Answer 1

Yes that is a good point, currently the uncertainty cannot be deselected. We think of releasing the next ecoinvent database in one version without uncertainty.

If you want, you can erase the uncertainty in e.g. ecoinvent, with this sql code, via the sql editor window in openLCA. Make a backup of the database first. It is also possible to filter the datasets to exclude your own processes from this "erasure".

update tbl_exchanges 
set 
DISTRIBUTION_TYPE = null, 
PARAMETER1_VALUE = null, 
PARAMETER1_FORMULA = null, 
PARAMETER2_VALUE = null, 
PARAMETER2_FORMULA = null, 
PARAMETER3_VALUE = null, 
PARAMETER3_FORMULA = null, 
BASE_UNCERTAINTY = null