-
Notifications
You must be signed in to change notification settings - Fork 35
Excel format for exchange of process data sets
This document describes the Excel format for exchanging process data sets.
A process data set is stored in a single Excel file (workbook). Thus, the export creates an Excel file for each process. A workbook contains sheets with information as in the process editor. Additionally, it contains sheets with reference data. The export will write all reference data from the database into these sheets. For the import, only the reference data that are referenced by the process are required. Thus, if you want to exchange a lot of data sets it is recommended to create a template with only the reference data you need (especially only the flows you need) in order to increase the performance of the import. In the following the format of the sheets is described in detail.
- B2: UUID of the process (reference ID), (UUID, optional)
- B3: process name (string, required)
- B4: process description (string, optional)
- B5: category path separated by '/' (string, optional)
- B6: Version, format: ##.##.### (string, optional)
- B7: last change (date, optional)
- B10: name of the output product which is the quantitative reference
- B13: start date from which the process is valid (date, optional)
- B14: end date until which the process is valid (date, optional)
- B15: time description (string, optional)
- B18: location code of a location in the
Locationssheets (string, optional) - B19: geography description (string, optional)
- B22: technology description (string, optional)
Entries start in row 2; the first empty line indicates the end of the entries. Flows are identified by name and category.
- A*: flow name (string, required)
- B*: flow category (string, path separated by '/', optional)
- C*: flow property name (string, required)
- D*: unit name (string, required)
- E*: amount (number, required)
- F*: formula (string, optional)
- G*: uncertainty type (enumeration: {undefined, log-normal, normal, triangular, uniform}, optional)
- H*: mean, geometric mean, mode (required for normal, log-normal, triangular)
- I*: standard deviation, geometric standard deviation (required for normal, log-normal)
- J*: minimum (required for uniform, triangular)
- K*: maximum (required for uniform, triangular)
Entries start in row 3; the first empty line indicates the end of the entries.
- A*: name of the parameter (string, required, unique)
- B*: parameter value (number, required)
- C*: uncertainty type (enumeration: {undefined, log-normal, normal, triangular, uniform}, optional)
- D*: mean, geometric mean, mode (required for normal, log-normal, triangular)
- E*: standard deviation, geometric standard deviation (required for normal, log-normal)
- F*: minimum (required for uniform, triangular)
- G*: maximum (required for uniform, triangular)
- H*: description (string, optional)
Entries start two rows after the section header; the first empty line indicates the end of the entries.
- A*: name of the parameter (string, required, unique)
- B*: parameter value (number, required)
- C*: uncertainty type (enumeration: {undefined, log-normal, normal, triangular, uniform}, optional)
- D*: mean, geometric mean, mode (required for normal, log-normal, triangular)
- E*: standard deviation, geometric standard deviation (required for normal, log-normal)
- F*: minimum (required for uniform, triangular)
- G*: maximum (required for uniform, triangular)
- H*: description (string, optional)
Entries start two rows after the section header; the first empty line indicates the end of the entries.
- A*: name of the parameter (string, required, unique)
- B*: parameter formula (string, required)
- C*: parameter value (result of the formula evaluation, number, required)
- D*: description (string, optional)
- B2: intended application (string, optional)
- B3/C3: name and category path of the data set owner (identifier for actor, optional)
- B4/C4: name and category path of the data set generator (identifier for actor, optional)
- B5/C5: name and category path of the data set documentor (identifier for actor, optional)
- B6/C6: name and category path of the publication source (identifier for source, optional)
- B7: access and use restrictions (string, optional)
- B8: project (string, optional)
- B9: creation date (date, optional)
- B10: copyright (boolean, required)
- B2: process type (enumeration: {LCI result, Unit process}, required)
- B3: LCI method (string, optional)
- B4: modeling constants (string, optional)
- B5: data completeness (string, optional)
- B6: data selection (string, optional)
- B7: data treatment (string, optional)
- B10: sampling procedure (string, optional)
- B11: data collection period (string, optional)
- B14/C14: name and category path of the reviewer (identifier for actor, optional)
- B15: review details (string, optional)
Entries start in row 18; the first empty line indicates the end of the entries.
- A*/B*: name and category path of the source (identifier for source, optional)
Entries start in row 2; the first empty line indicates the end of the entries.
- A*: UUID of the unit (UUID, required)
- B*: unit name (string, required, unique)
- C*: name of the unit group to which this unit belongs (string, required)
- D*: unit description (string, optional)
- E*: unit synonyms (string list separated by semicolon, optional)
- F*: conversion factor to the reference unit of the unit group (number, required)
Entries start in row 2; the first empty line indicates the end of the entries.
- A*: UUID of the unit group (UUID, required)
- B*: unit group name (string, required, unique)
- C*: unit group description (string, optional)
- D*: category of the unit group (string, path separated by '/', optional)
- E*: name of the reference unit (string, required, unique)
- F*: name of the default flow property (string, optional)
- G*: version of the unit group (string, format 00.00.000, optional)
- H*: last change of the unit group (date, optional)
Entries start in row 2; the first empty line indicates the end of the entries.
- A*: UUID of the flow property (UUID, required)
- B*: flow property name (string, required, unique)
- C*: flow property description (string, optional)
- D*: category of the flow property (string, path separated by '/', optional)
- E*: name of the unit group of the flow property (string, required)
- F*: type of the flow property (enumeration: {Physical, Economic})
- G*: version of the flow property (string, format 00.00.000, optional)
- H*: last change of the flow property (date, optional)
Entries start in row 2; the first empty line indicates the end of the entries.
- A*: UUID of the location (UUID, required)
- B*: location code (string, required, unique)
- C*: location name (string, required, unique)
- D*: location description (string, optional)
- E*: average latitude of the location (number, optional)
- F*: average latitude of the location (number, optional)
Entries start in row 2; the first empty line indicates the end of the entries. The combination of name and category must be unique.
- A*: UUID of the actor (UUID, required)
- B*: actor name (string, required)
- C*: actor description (string, optional)
- D*: category of the actor (string, path separated by '/', optional)
- E*: version of the actor (string, format 00.00.000, optional)
- F*: last change of the actor (date, optional)
- G*: address (string, optional)
- H*: city (string, optional)
- I*: zip code (string, optional)
- J*: country (string, optional)
- K*: e-mail (string, optional)
- L*: telefax (string, optional)
- M*: telephone (string, optional)
- N*: website (string, optional)
Entries start in row 2; the first empty line indicates the end of the entries. The combination of name and category must be unique.
- A*: UUID of the source (UUID, required)
- B*: source name (string, required)
- C*: source description (string, optional)
- D*: category of the source (string, path separated by '/', optional)
- E*: version of the source (string, format 00.00.000, optional)
- F*: last change of the source (date, optional)
- G*: DOI (string, optional)
- H*: text reference (string, optional)
- I*: year (number, optional)
Entries start in row 2; the first empty line indicates the end of the entries. The combination of name and category must be unique.
- A*: UUID of the flow (UUID, required)
- B*: flow name (string, required)
- C*: flow description (string, optional)
- D*: category of the flow (string, path separated by '/', optional)
- E*: version of the flow (string, format 00.00.000, optional)
- F*: last change of the flow (date, optional)
- G*: flow type (enumeration: {Elementary flow, Product flow, Waste flow})
- H*: CAS number (string, optional)
- I*: chemical formula (string, optional)
- J*: location code (string, optional)
- K*: name of the reference flow property (string, required)
Entries start in row 2; the first empty line indicates the end of the entries. The flow name and category are used to identify a flow. Each flow in the flow sheet must have at least one flow property factor, the reference flow property factor with a conversion factor of 1.
- A*: flow name (string, required)
- B*: category of the flow (string, path separated by '/', optional)
- C*: flow property name (string, required)
- D*: conversion factor (number, required)
- E*: reference unit (of the unit group of the flow property) (string, required)