spm2olca 1.1.0

Installation

The installation of the package requires that Python >= 3.5 is installed and that the Python Scripts folder is in your system path. Then, you can just use pip to install it:

pip install spm2olca

After this you should be able to run the tool anywhere on your system. You can test this by executing the following command:

spm2olca -h

To uninstall it, just execute the following command:

pip uninstall spm2olca

Usage

Just type the spm2olca command followed by the SimaPro CSV file with LCIA methods you want to convert:

spm2olca "My Method.csv"

This will generate the olca-schema package which will have the same file name but with a .zip extension. This file can be then imported into openLCA.

To see additional options use the help flag -h:

spm2olca -h

Additional options:

• -out: define the name of the output file

• -skip_unmapped: LCIA factors with unmapped flows are not included (only applicable when a flow mapping is provided)

• -log: define the log level (e.g. ‘all’ will log everything)

• -units: a CSV file with unit mappings that should be used

• -flows: a CSV file with flow mappings that should be used

A command with all options could look like this:

spm2olca -out=out.zip -log=all -skip_unmapped -units=units.csv -flows=flows.csv Method.csv

Mapping files

You can specify mapping files for flows and units that should be used in the conversion. If no unit mapping file is given, spm2olca will take a default mapping file in the conversion. For flows, new flows will be created if no mapping file is provided or if they are not contained in the mapping file. The general format of these mapping files is:

• CSV files with semicolons as separator

• UTF-8 encoded without a byte order mark

• no column headers

0.  SimaPro name of the unit
1.  openLCA reference ID of the unit
2.  openLCA name of the flow property
3.  openLCA reference ID of the flow property

0.  SimaPro name of the flow (string)
1.  SimaPro compartment of the flow (string)
2.  SimaPro sub-compartment of the flow (string)
3.  SimaPro unit of the flow (string)
4.  openLCA reference ID of the flow (UUID)
5.  openLCA name of the flow (string)
6.  openLCA reference ID of the reference flow property of the flow (UUID)
7.  openLCA name of the reference flow property of the flow (string)
8.  openLCA reference ID of the reference unit of the flow (UUID)
9.  openLCA name of the reference unit of the flow (string)
10. conversion factor: amount_simapro * factor = amount_openlca (double)

a_o = f * a_s

a_o = [m3] = 0.001 * [kg] with a_s = [kg]

lcia_o = 2000/[m3] = 2/(0.001*[kg]) with a_s = [kg]

The structure of a SimaPro LCIA method file

In the following, the format of a SimaPro LCIA method file is shown in an EBNF like notation:

(* A LCIA method file contains a file header, LCIA methods, and flow lists *)
MethodFile  = FileHeader
              { Method }

              { UnitList }
              { FlowList };

(* The file header contains meta-data about the file format, column separator
   etc. *)
FileHeader  = "{" ... "}";

(* Each LCIA method starts with a line "Method" and ends with a line "End". It
   contains some method meta data, the LCIA categories*)
Method      = "Method"
              MethodMetaData
              { ImpactCategory }
              { NWSet }
              { DamageCategory } ;

(* An LCIA category starts with the line "Impact category" directly followed by
   a line with the meta-information like name and reference unit. *)
ImpactCategory   = "Impact category"
                   ImpactCategory ";" ReferenceUnit ;
                   ImpactFactors ;

(* The LCIA factors are written into a section starting with the header
   "Substances" followed with an LCIA factors each in a separate row. *)
ImpactFactors = "Substances"
                 { Compartment ";" SubCompartment ";" FlowName ";" CasNumber ";" ImpactFactor ";" Unit} ;


(* The weighting section in a normalization weighting set is optional *)
NWSet = "Normalization-Weighting set"
        NWSetName
        EmptyLine
        "Normalization"
        { ImpactCategory ";" NormalizationFactor }
        [
          "Weighting"
          ImpactCategory ";" WeightingFactor
        ];

(* A damage category starts with the header "Damage category" and contains a
   damage factor for each impact category. *)
DamageCategory = "Damage category"
                 DamageCategory ";" ReferenceUnit
                 EmptyLine
                 "Impact categories"
                 { ImpactCategory ";" DamageFactor }

QuantityList = "Quantities"
               { QuantityName ";" }

UnitList = "Units"
           { UnitSymbol ";" QuantityName ";" UnitFactor ";" ReferenceUnitName} ;

(* A flow list starts with a line with the flow type (e.g. "Waterborne emissions"
   followed by the meta data of the flows of this type with a separate line for
   each flow. *)
FlowList = <FlowType>
           { FlowMetaData }
           "End" ;