The Practical Manual for the Palm Oil LCA Spreadsheet
(Initial Draft)
December 2013
1. Contents of the spreadsheet
Name of sheet Outline
Inputs - All the necessary data will be inputted in this sheet.
- Data will be separately inputted by processes.
Result (LCI) - One of the results. After completing “Inputs” sheet, the lifecycle
inventory will be automatically established.
Result (LCI per 1t-FFB) - One of the results. The lifecycle inventory (per 1 ton of FFB) will
be automatically established.
Result (IA) - One of the results. The impact assessment, including global
warming, acidification and eutrophication, will be automatically
done.
Result (IA per 1t-FFB) - One of the results. The impact assessment (per 1 ton of FFB),
including global warming, acidification and eutrophication, will be
automatically done.
Graphs - One of the results. Graphs of the inventory and the impact
assessment will be automatically created.
Default - Provides necessary fixed data for calculation of emissions etc. No
need for project participants to modify this sheet.
cal - Intermediate calculation sheet for the inventory and the impact
assessment. No need for project participants to modify this sheet.
1
2. Procedure of data input - Explanation of the “Inputs” sheet -
2.1 Land use change process
“Land use change process” includes changes of the land use through the project development. The
transformation can be from previous land types, such as secondary/degraded forest or alang-alang
grassland, to the oil palm plantation. As a result of land use change, carbon in the soil/vegetation is
converted to CO2 and emitted to the air, or CO2 is sequestered in the soil/vegetation.
Input the area of secondary/degraded
forest which was/will be converted to the oil
palm plantation through the project. The
unit should be “ha: hectare”.
Input the area of alang-alang grassland
which was/will be converted to the oil palm
plantation through the project. The unit
should be “ha: hectare”.
2
2.2 Oil palm cultivation process
The process includes activities related to cultivation of oil palm, such as fertilizer application, pesticide
and insecticide use. Diesel oil use for transportation of FFB and other materials are also included in the
process.
Input the annual total production of FFB
(Fresh Fruit Bunch) from the oil palm
plantation, in tonnes per year.
Input the amount of solid biomass waste
from the oil palm plantation in tones per
year. The waste includes fronds, trunks,
covered crops etc.
Input the annual total amount of fertilizers
used for the oil palm cultivation. Please
input the amount by types of fertilizers in
tonnes per year.
3
Input the annual total amount of compost
Input the annual total amount of pesticide
including organic fertilizers, if it is used for
used for the oil palm cultivation in tonnes
the oil palm cultivation.
per year.
Input the annual total amount of insecticide
used for the oil palm cultivation in tonnes
per year.
Input the amount of diesel oil used for
transportation of fertilizer from the fertilizer
factory to the plantation site.
This can be calculated...(show an example)
Input the amount of diesel oil used for
transportation of pesticide from the
pesticide factory to the plantation site.
This can be calculated...(show an example)
Input the amount of diesel oil used for
transportation of insecticide from the
insecticide factory to the plantation site.
This can be calculated...(show an example)
Input the amount of diesel oil used for
transportation of FFB from the plantation
Input the annual total amount of diesel oil site to the mill. Annual total consumption
used for agricultural machineries at the site should be estimated, and input in Kilo Liter
of oil plantation. Annual total consumption (kL).
should be estimated, and input in Kilo Liter
(kL).
4
2.3 Palm oil production process
The process includes activities related to palm oil production, such as energy use, discharge of wastes.
Input the annual amount of FFB (Fresh Fruit
Input the annual amount of diesel oil and
Bunch) which is inputted to the oil mill for
natural gas which is used for the boiler or
the production of palm oil.
other purposes in the oil mill.
Input the annual amount of electricity which Input the annual amount of solid biomass
is used for any processes in the oil mill. waster used for the boiler or other purposes
Only the grid electricity should be counted. in the oil mill, such as EFB, fiber and shell.
Input the annual production of CPO and
palm kernel, in Kilo Liter (kL) and tonnes
per year, respectively.
Input the annual amount of exhaust gas Input the annual amount of POME from the
from the oil mill. oil mill.
Input the annual amount of biomass waste
from the oil mill, such as EFB, fiber and
shell.
5
2.4 Palm kernel oil production process
The process includes activities related to palm kernel oil production only. If it is not possible to separate
the necessary data from “Palm oil production process”, this process and “Palm oil production process”
should be combined with.
Input the annual amount of palm kernel
which is inputted to the kernel production
process. Input the annual amount of diesel oil and
natural gas which is used for the kernel oil
production.
Input the annual amount of electricity which Input the annual amount of solid biomass
is used for the kernel oil production. Only waster used for the kernel oil production,
the grid electricity should be counted. such as EFB, fiber and shell.
Input the annual production of CPKO in Kilo
Liter (kL).
Input the annual amount of exhaust gas Input the annual amount of POME from the
from the kernel oil production. kernel oil production.
Input the annual amount of biomass waste
from the kernel oil production, such as EFB,
fiber and shell.
6
2.5 Waste water treatment
The process includes activities related to waste water treatment, such as POME treatment (such as
aerobic/anaerobic treatment) and associated energy uses. (Methane recovery and energy uses should be
included in this process, but not yet included in the spreadsheet)
Input the annual amount of POME produced Input the annual amount of POME treated
in the process of oil palm production. and discharged to the river or others.
Input the annual amount of POME treated
and applied to the land, such as the oil palm
plantation.
Input average COD concentration of POME, Input average COD concentration of POME,
before the treatment. after the treatment.
Input average N (Nitrogen) concentration of Input average P (Phosphorus)
POME, after the treatment. concentration of POME, after the treatment.
Input the annual amount of diesel oil used
for the waste water treatment in Kilo Liter Input the annual amount of electricity which
(kL). is used for the waste water treatment. Only
the grid electricity should be counted.
7
2.6 Waste treatment
The process includes activities related to waste treatment, such as incineration, mulching, compost and
associated energy uses.
Input the annual amount of solid biomass
Input the annual amount of solid biomass waste which is incinerated.
waste which is used for mulching for the oil
palm plantation.
Input the annual amount of solid biomass
Input the annual amount of solid biomass
waste which is used for the production of
waste which is used for the other purpose
compost.
than incineration, mulching and compost.
Input the annual amount of diesel oil and Input the annual amount of electricity which
natural gas which is used for the waste is used for the waste treatment. Only the
treatment. grid electricity should be counted.
Input the annual amount of ash discharged
Input the annual amount of ash applied to
from the waste treatment process.
the land.
Input the annual amount of exhaust gas
from the waste treatment process.
8
3. Results
3.1 The sheet “Result (LCI)”
9
3.2 The sheet “Result (LCI per 1t-FFB)”
10
3.3 The sheet “Result (IA)”
3.4 The sheet “Result (IA per 1t-FFB)”
11
3.5 The sheet “Graphs”
12
