Impact of Energy Source on Feedstock CI

More
6 months 2 weeks ago #150 by Tidewater1
Impact of Energy Source on Feedstock CI was created by Tidewater1
Hi There,

I am in the process of calculating the CI's of different feedstocks for HRD. I am wanting to gage the impact of an energy source on the CI. For example, how does the CI of tallow change when using solar generation over a natural gas turbine?

Thanks,
Clint.

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

More
6 months 2 weeks ago #151 by rdo
Replied by rdo on topic Impact of Energy Source on Feedstock CI
This is an advanced use case that we recently made much easier in GHGenius 5.01. The main assumption that I'm going to be making is that we are only altering the GHG emissions of the fuel production stage. This is a fairly safe assumption to make.

To do this we'll be making use of the new User Defined Power grid, that exists alongside other use-specific grids and the generic regional grid. The main change is done on the Upstream Results HHV sheet, in cell AZ11. It normally looks like:

=(('Alt Fuel Prod'!CB10-SUMPRODUCT('Alt Fuel Prod'!CB29:CB78,'Alt Fuel Prod'!C99:C148))*'Fuel Char'!$Q$125/'Alt Fuel Prod'!CB$26*'Elec Emissions'!$B$55+'Energy Use'!BM$110*IF(Input!B53="Fish Oil",'Equip Emis Factors'!$M$27,'Equip Emis Factors'!$G$27)+'Energy Use'!BM$111*'Equip Emis Factors'!$W$27+'Energy Use'!BM$113*'Equip Emis Factors'!$R$27+'Energy Use'!BM$115*'Equip Emis Factors'!$U$27)*'Alt Fuel Prod'!CB27+'Alt Fuel Prod'!CB79+SUMPRODUCT('Alt Fuel Prod'!CB29:CB78,'Alt Fuel Prod'!H99:H148)/'Fuel Char'!$B$89*1000+'Alt Fuel Prod'!CB89

The bolded term is the one to change. It refers to the generic grid power. This is a cell that is heavily regionalized and heavily used, it pops up in most phases of most fuels. For this purpose it needs to be changed to refer to the user defined grid. Simply change the bolded 55 to 56 as below.

=(('Alt Fuel Prod'!CB10-SUMPRODUCT('Alt Fuel Prod'!CB29:CB78,'Alt Fuel Prod'!C99:C148))*'Fuel Char'!$Q$125/'Alt Fuel Prod'!CB$26*'Elec Emissions'!$B$56+'Energy Use'!BM$110*IF(Input!B53="Fish Oil",'Equip Emis Factors'!$M$27,'Equip Emis Factors'!$G$27)+'Energy Use'!BM$111*'Equip Emis Factors'!$W$27+'Energy Use'!BM$113*'Equip Emis Factors'!$R$27+'Energy Use'!BM$115*'Equip Emis Factors'!$U$27)*'Alt Fuel Prod'!CB27+'Alt Fuel Prod'!CB79+SUMPRODUCT('Alt Fuel Prod'!CB29:CB78,'Alt Fuel Prod'!H99:H148)/'Fuel Char'!$B$89*1000+'Alt Fuel Prod'!CB89

Once this change is made you can then change your user defined grid on the Power Gen sheet, in row 21. Try to keep it adding to 1.0, anything less will just put the remainder into "Other" which is a barely defined pathway with emissions a bit better than solar.
The following user(s) said Thank You: jeremy.olson, Tidewater1

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

More
6 months 1 week ago #153 by Tidewater1
Replied by Tidewater1 on topic Impact of Energy Source on Feedstock CI
Very helpful, thank you!

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

Powered by Kunena Forum