UPSTREAM results HHV

More
1 week 5 days ago #138 by nikannf37
UPSTREAM results HHV was created by nikannf37
Hi,

I was looking around the upstreams results HHV sheet and noticed that in the "grams CO2 per GJ of fuel delivered to end-user" row 69 which is the 'emissions displaced by co products" is arbitrarily entered by the developer. I was wondering how the numbers are calculated or retrieved.
Thanks

Please Log in or Create an account to join the conversation.

More
1 week 4 days ago #139 by doconnor
Replied by doconnor on topic UPSTREAM results HHV
Those values are written in by separate gases macro. The basis operation is:

It sets all GWPs to one and calculates the results, pastes this as the unweighted emissions in Upstream Results HHV.

For CO2 it sets all values to zero in the matrix and the difference is pasted in the corresponding section on the Upstream Results HHV sheet.

It then selects a gas, setting it to zero and calculating the results. The difference between the two calculations is the value for the gas that was set to zero and it is pasted in the corresponding section on the Upstream Results HHV sheet.

The macro sequentially steps through each separate gas repeating the process.

I hope this helps.

Regards
Don O'Connor

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum