Section 2 Instructions for use
Step 1
Unzip the compressed folder AGEC-LCI_v1_0.zip, then open the file AGEC-LCI_v1_0.xlsm (Figure 2.1).
Figure 2.1: AGEC-LCI is stored in a macro-enabled workbook
Step 2
Click on the Launch AGEC-LCI user interface button at the top of the README-RUN worksheet of AGEC-LCI_v1_0.xlsm (Figure 2.2).
Figure 2.2: Launch AGEC-LCI user interface
Step 3
The AGEC-LCI user interface will be displayed (Figure 2.3).
Figure 2.3: AGEC-LCI user interface
AGEC-LCI allows the user to select inputs from a database composed of 25 crops (Table 2.1), 42 fertilizers (Table 2.2), 6 metal-based fungicides (Table 2.3), and the pedo-climatic characteristics of 5 French regions (Figure 2.4) according to data from AGRIBALYSE (Koch and Salou 2015). Furthermore, the user is allowed to add crops, regions, and other inputs not available in the accompanying database.
| Crop |
|---|
| Carrots |
| Grapes/vine (tree nursery) |
| Grapes/vine (non productive) |
| Grapes/vine (productive) |
| Durum wheat |
| Durum wheat – straw |
| Soft wheat |
| Soft wheat – straw |
| Rapeseed |
| Silage maize |
| Grain maize |
| Seed maize |
| Potatoes |
| Sugar beet |
| Alfalfa |
| Barley |
| Barley- straw |
| Peas |
| Permanent meadow |
| Temporary grassland |
| Sunflowers |
| Triticale |
| Triticale – straw |
| Product, average |
| Co-product, average |
| Fertilizer | Type |
|---|---|
| Feather meal | Compost |
| Green waste compost | Compost |
| Household waste compost | Compost |
| Manure / slurry compost | Compost |
| Cattle slurry | Slurry |
| Thin cattle slurry | Slurry |
| Broiler manure | Manure |
| Cattle manure | Manure |
| Cattle manure heap | Manure |
| Compost bedded cattle manure | Manure |
| Laying hen manure | Manure |
| Pig manure | Manure |
| Ammonium nitrate | Mineral fertilizer |
| Ammonium sulphate | Mineral fertilizer |
| Average mineral fertilizer, as K2O | Mineral fertilizer |
| Average mineral fertilizer, as N | Mineral fertilizer |
| Average mineral fertilizer, as P2O5 | Mineral fertilizer |
| Calcium ammonium nitrate | Mineral fertilizer |
| Calcium nitrate | Mineral fertilizer |
| Diammonium phosphate | Mineral fertilizer |
| Lime, from carbonation | Mineral fertilizer |
| Magnesium oxide | Mineral fertilizer |
| Monoammonium phosphate | Mineral fertilizer |
| Potassium chloride | Mineral fertilizer |
| Potassium nitrate | Mineral fertilizer |
| Potassium sulphate | Mineral fertilizer |
| Single superphosphate | Mineral fertilizer |
| Triple superphosphate | Mineral fertilizer |
| Urea | Mineral fertilizer |
| Urea ammonium nitrate | Mineral fertilizer |
| Limestone, milled, loose | Mineral fertilizer |
| Composted sewage sludge | Sludge |
| Composted sewage sludge (default) | Sludge |
| Concentrated sugar beet vinasse | Sludge |
| Dried sewage sludge | Sludge |
| Dried sewage sludge (default) | Sludge |
| Limed sewage sludge | Sludge |
| Limed sewage sludge (default) | Sludge |
| Liquid sewage sludge | Sludge |
| Liquid sewage sludge (default) | Sludge |
| Sugar beet vinasse | Sludge |
| Sugar beet vinasse (default) | Sludge |
| Metal-based fungicides |
|---|
| Mancozeb |
| Metiram zinc |
| Propineb |
| Zineb |
| Ziram |
Click on the coloured polygons to display the main characteristics of the available regions in AGEC-LCI.
Figure 2.4: Regions available in AGEC-LCI
Step 4
You will be asked to provide a short name for your current project. It is advised to give a short and meaningful name because it will be part of the name of the reports and the process generated (Figure 2.5). Click OK to run the computations.
Figure 2.5: Name your current project
Step 5
Three reports will be generated and stored under the Results folder accompanying this tool (Figure 2.6). The Results folder will be automatically open at the end of the computation.
Report_Project_Name_YYYY-MM-DD.xlsx: Contains the user’s inputs and the calculated emissions. The aim of this report is to keep track of the inputs that need to be entered by the LCA practitioner into a LCA software.
Report_olca_Project_Name_YYYY-MM-DD.xlsx: Reports the calculated emissions in an Excel file compatible with openLCA. The importation of this report was tested with openLCA 1.9.0, and the procedure is described in Section 3.1.
Report_SimaPro_Project_Name_YYYY-MM-DD.csv: Reports the calculated emissions in a csv file compatible with SimaPro. The importation of this csv file was tested with SimaPro 8.5.2.2, it is not guaranteed that it will work in previous versions of the software. The procedure for importing this file is described in Section 3.2.
Figure 2.6: Files generated by AGEC-LCI
References
Koch, Peter, and Thibault Salou. 2015. AGRIBALYSE: Rapport Méthodologique - Version 1.2. Book. Angers, France: ADEME. https://www.ademe.fr/sites/default/files/assets/documents/agribalyse-rapport-methodologique-v1_2.pdf.