I'd like to import processes that have input and output flows from providers that only differ in terms of their location.
Here is an example to make it feasible - I'd like openLCA to recognise the following via excel import:
Inputs:
| Flow | Provider |
| electricity, low voltage | market for electricity, low voltage | electricity, low voltage | Cutoff, U - EC |
| electricity, low voltage | market for electricity, low voltage | electricity, low voltage | Cutoff, U - BE |
| (...) | (...) |
Outputs:
| Flow | Provider |
| heat, district or industrial, natural gas | market group for heat, district or industrial, natural gas | heat, district or industrial, natural gas | Cutoff, U - RER |
| heat, district or industrial, natural gas | market group for heat, district or industrial, natural gas | heat, district or industrial, natural gas | Cutoff, U - GLO |
| (...) | (...) |
(In this case, heat energy is avoided)
In the excel file, this is reflected in the following entries in the "Providers" tab:
Though, when importing the excel file only the first providers are recognised by openLCA, leading to the both input providers being "EC", and both output providers being "RER". In general, it is not clear to me how openLCA links the entries made in the "Inputs" and "Outputs" tabs to the providers in the "Providers" tab.
My questions:
1) Is there something like a general guidance document for preparing excel files for process import? In the openLCA manual, I only found very few information.
2) Is it, at all, possible to import multiple located providers using the excel template, and if so, how?
3) The answer to 2) is "no", what would be the easiest and fasted alternative? I currently have all my data ready in an excel copy-paste format, as well (copy-pasting inputs and outputs is fully working, but the goal is to automate the process for hundreds of process datasets).
Thank you in advance to anyone who can help out - also, don't hesitate to ask any questions in case you need more information.
Best regards,
Johannes
