### Excel export and contribution tree

Posted:

**17 Dec 2015 12:20**Hello OpenLCA forum,

I’m a new OpenLCA user and I‘m in front of a misunderstanding. Here, I think it’s a good place to overcome it.

In order to avoid increasing the complexity of this explanation, let me give you an simply example.

I would like to realize a LCA of chocolate pie composed by a pastry base and a chocolate ganache.

PROCESS 1 : pastry base

flow 1 : 100g flour

flow 2 : 2 eggs

PROCESS 2 : chocolate ganache

flow 1 : 50g flour

flow 2 : 200g chocolate

I would like to obtain not only environmental impacts of chocolate pie but also that of its components (pastry base & ganache).

The “contribution tree” tab of OpenLCA give me the right information. I expected the same from the Excel export file but…

In this file :

- The tab “LCIA total” give me : chocolate pie = 2g CO2eq for climate change impact for example.

- The tab "LCIA contribution", correctly describes the contribution of each flow but does not give the impact of each process. Worse, he sum the impact of identical flow from two different processes (here is flour) making impossible to calculate "manually" the contribution of each process. So, this Excel file loses a lot of value for what I want to do.

Finally, there is a only one solution : copy-paste the “contribution tree” calculated by OpenLCA for each impact to analyze it on Excel. But, it’s longer and impossible to create an automated tool by doing that.

To make an LCA, this Excel file seems unusable. I hope I’m wrong…

Is my reasoning good?

Do I have a simple and automatic way to recover "a contribution tree" or to calculate it via Excel?

Given the recipe, I hope you never have to eat this chocolate pie one day…

Please, I'm sorry to express myself with a poor english. Thanks a lot for your help! Have a nice day.

Alexy

I’m a new OpenLCA user and I‘m in front of a misunderstanding. Here, I think it’s a good place to overcome it.

In order to avoid increasing the complexity of this explanation, let me give you an simply example.

I would like to realize a LCA of chocolate pie composed by a pastry base and a chocolate ganache.

**LCA of chocolate pie**PROCESS 1 : pastry base

flow 1 : 100g flour

flow 2 : 2 eggs

PROCESS 2 : chocolate ganache

flow 1 : 50g flour

flow 2 : 200g chocolate

I would like to obtain not only environmental impacts of chocolate pie but also that of its components (pastry base & ganache).

The “contribution tree” tab of OpenLCA give me the right information. I expected the same from the Excel export file but…

In this file :

- The tab “LCIA total” give me : chocolate pie = 2g CO2eq for climate change impact for example.

- The tab "LCIA contribution", correctly describes the contribution of each flow but does not give the impact of each process. Worse, he sum the impact of identical flow from two different processes (here is flour) making impossible to calculate "manually" the contribution of each process. So, this Excel file loses a lot of value for what I want to do.

Finally, there is a only one solution : copy-paste the “contribution tree” calculated by OpenLCA for each impact to analyze it on Excel. But, it’s longer and impossible to create an automated tool by doing that.

To make an LCA, this Excel file seems unusable. I hope I’m wrong…

Is my reasoning good?

Do I have a simple and automatic way to recover "a contribution tree" or to calculate it via Excel?

Given the recipe, I hope you never have to eat this chocolate pie one day…

Please, I'm sorry to express myself with a poor english. Thanks a lot for your help! Have a nice day.

Alexy