Hi!
I am in the process of creating a model for calculation CO2 emission by a company, on a yearly basis. So what i am trying to do is automatically mulitply the inputed value in a cell with a set emissionfactor, and then in the same cell get the output with the new "scaled value" value. I would like this multiplication to be set for the whole row as this mulitplication should be able to be used for future yearly inputs...I have tried to show what i mean in the table below, where the red coloured text would be numbers that will vary year to year, but the emission factor would be the constant.... So my goal is to let the user only have to but in the collected data (like 500 000 KWh of windpower electricity) and the output in 2018 should be 500 000 * 0,005? Makes sence?
Thanks in advance for help!
I am in the process of creating a model for calculation CO2 emission by a company, on a yearly basis. So what i am trying to do is automatically mulitply the inputed value in a cell with a set emissionfactor, and then in the same cell get the output with the new "scaled value" value. I would like this multiplication to be set for the whole row as this mulitplication should be able to be used for future yearly inputs...I have tried to show what i mean in the table below, where the red coloured text would be numbers that will vary year to year, but the emission factor would be the constant.... So my goal is to let the user only have to but in the collected data (like 500 000 KWh of windpower electricity) and the output in 2018 should be 500 000 * 0,005? Makes sence?
Thanks in advance for help!
Source | unit | EM (emission factor) | 2018 | 2019 | 2020 | 2021 |
Windpower electricity | KWh | 0,005 | EM(windpower)* used electricity KWh 2018 | EM(windpower)* used electricityKWh 2019 | EM(windpower)* used electricity KWh 2020 | EM(windpower)* used electricity KWh 2021 |
Construction | m^2 | 4 | EM(construction)* m^2 construction 2018 | EM(construction)* m^2 construction 2019 | EM(construction)* m^2 construction 2020 | EM(construction)* m^2 construction 2021 |
Petrol | liter | 0,028 | EM(petrol)* litter used petrol 2018 | EM(petrol)* liter used petrol 2019 | EM(petrol)* liter used petrol 2020 | EM(petrol)* liter used petrol 2021 |