+2 votes


For a particular project related to food, we are using a food database to do an analysis of procurement. I have been trying to connect to the database using OpenLCA and the Olca Python package with mixed success.

With help from other questions in this forum I have been able to connect, build a product system, calculate the system, and export the results of the many processes I need.

However, when comparing the results from the Olca method to calculation within OpenLCA, the results come out different.

The export from OpenLCA is more in-depth and seems to go a lot deeper than the Olca analysis. There are flows missing in every sheet in the Excel export.

So far I have tried:
1. Using various calculation methods in Olca
2. Different databases to cross-compare
3. Different Impact Assessments

I have seen similar questions but no real answers as to how to retreive the same Excel export from Olca-IPC as one can from OpenLCA, meaning the same level of detail.

You can find my code here.

in openLCA by (140 points)
by (140 points)
Unfortunately I have not been able to solve the issue.
This was partly due to time constraints, and we solved it differently now, temporarily.

However, I am also still interested and I hope to pick this up in the future.

I don't know if I remember this correctly but part of the problem could be that writing to Excel gave me an error for using too many rows.

Given the speed at which OpenLCA normally calculates processes and through my code, I assume something else is wrong because the code just flies through only to leave me with 0's everywhere..

1 Answer

0 votes
by (1k points)

Hi, can you identify/reproduce, how the differences in the underlying inventories (i.e. included flows) are generated?

Are you 100% sure, that you use identical ...

a) ... ways of creating the product systems (provider linking, preferred process type, cut-off)

b) ...  calculation setups (same allocation method)

... in both the openLCA client as well as in olca-ipc?

by (140 points)
To answer this, I have tried every kind of calculation setup, and while there should be a difference, it shouldn't be all zeroes for many of the processes.

Also tried making a product system, that was not the issue.

Thank you for the help though!

I'm still open to other possible solutions