Hello there,
so just to double check if I understood correctly:
- You have several excel files of input and outputs.
- All of these contain different values but are for the same process.
- You now want to run impact calculations for the product system derived from that process for each set of values (i.e. each data sheet).
- You would like to automate this as it is a lot of work.
- You want to export the results as an Excel file.
If I understood correctly, I would say that you are dealing with a situation where the use of parameters would be ideal. If only the amounts in the exchanges differ from data sheet to data sheet but the process stays the same, you would be best off using parameters in the amount and then run impact calculation by setting up different parameter sets (one for each data sheet). This can be done in openLCA manually or you can automate this procedure.
To do this manually:
- Go to openLCA
- Open the product system
- Go to the 'Parameters' tab
- Click on 'Add parameter set'
- Fill in each parameter for each parameter set (i.e. each data sheet)
These results you could then export as an Excel file just like you are used to. However, this is a lot of work so if you are familiar with a programming language like Python for example, I recommend you let a script read out your data sets (e.g. with Pandas or openpyxl) and then use the olca-ipc module to run the calculations with the different parameter sets. An example of how to do this you find here:
https://greendelta.github.io/openLCA-ApiDoc/ipc/examples/parameters.html
The results will be returned as a json-object. If you want these to be returned as an Excel file you will need to again use a custom script to bring the data in the desired format.
I hope this answers your question.
Best wishes,
Raphael
