Biodiesel from used vegetable oil

I will be walking through this with the assumption that you are using GHGenius 5.0e. The steps are similar for other versions of the model, but the exact cell locations may be different.

Initial Model Setup:

In cell B4 on the Input sheet, choose the region you are in, and install the regional defaults.
In cell B7 on the Input sheet, set the year. This probably corresponds with the data you have.

Transportation:

The used cooking oil pathway in the model is in two parts. The first part is the collection of waste cooking oil and the processing it to produce yellow grease which can be used for biodisel production. The transportation of the waste cooking oil is in column Y and the processed or rendered product transportation is in the range of Z76 to Z86 on the Input sheet you can adjust how and how far the oil is transported.

The transportation distances and modes of the finished biodiesel can also be entered. This is found in the range of AK91 to AK101 on the Input sheet.

For any transportation you can have more than one mode. For example 50% via rail and 50% via truck. Or perhaps 100% via rail, followed by 100% via truck to reach your plant. The only restriction is that the distance times the tonnes-shipped/tonnne-produced must be non-zero.

Energy Input:

For processing or rendering the waste cooking oil the energy input is in AT240 to 247.

Processed used cooking oil, or yellow grease, is a high free fatty acid pathway. Accordingly you will be entering the energy values for biodiesel production you have between AU240 and AU247 on the Input sheet. You should change the year in addition to adding your own energy values, this year should correspond to the data you have and the year you are running the model for.

Chemical Input:

This is done on the Alt Fuel Prod sheet, in the range of BF29 to BF72. There will be a number of default values that you may need to zero out while adding your own data, be sure to scroll through the full column.

Coproducts:

As you have identified, this is done in the range of Z98 through Z101 on the Coprods sheet. The difference between the four types of coproducts is determined by the quality and the use of the coproduct.

Refined is for when upgrading is done at your plant and a high purity product is produced.
Crude is most often used when the glycerine is being sold to a refiner.
Fuel is when the glycerine is being burned for heat or energy.
Feed is when the glycerine is used as an animal feedstock.

Outputs:

And that's it. Press the Run Program button on the Input sheet, or just hit F9 on your keyboard if you only need the results at the top of the Upstream Results sheet. The Biodiesel from Yellow Grease pathway results will be visible on Upstream Results, Lifecycle Results, and other output sheets.

I hope that covers everything. Please let us know if you have any further questions.

-Ryan

You only need to use the data in column AQ. It incorporates any emissions in AP automatically.

The yield is set on the Input sheet, cell AU247. You don't need to enter it anywhere else for it to be taken into account for transportation.

You should enter the quantity in the fuel line. The credit will be pretty small for this application.

Regards
Don O'Connor