Exemplary ecodesign of a smartphone based on a parametric life cycle assessment - Database (Excel)

This study presents the development of a novel ecodesign approach based on a parametric life cycle assessment (LCA). The developed method allows for the comparison of environmental impacts of a vast number of different product configurations, which are derived automatically by determining every possible combination of the given design options. The life cycle model features a stochastic failure and repair simulation to account for a wide range of use cases as well as a recycling simulation that can determine the environmentally optimal recycling route. The developed method is tested on an exemplary case study of a smartphone. Despite efficiency limitations of the accompanying software tool prototype that was developed and used for the case study, it could be shown that the method allows to identify the environmental influence of different design options as well as the product configuration with the least annual global warming potential.

This file contains the database Excel file with data and calculations on failure and repair statistics, material compositions, and input tables for the software tool prototype developed in the study. It can be inspected as is to understand the underlying data and procedure presented in the study or used as an input for the Python source code to run the LCA model, which can be found here: https://zenodo.org/doi/10.5281/zenodo.10617863

Note: References to licensed environmental datasets from the Sphera and ecoinvent databases have been deleted in the published version. In order to run the software tool, please add the respective values for the Global Warming Potential (or alternative impact categories) in the "processes_data" sheet and delete the suffix "_noLCIA" from the file name.

本研究提出了一种基于参数化生命周期评估（Life Cycle Assessment，LCA）的新型生态设计方法。所提出的方法可对海量不同产品配置的环境影响进行对比分析，此类配置可通过枚举给定设计选项的所有可能组合自动生成。该生命周期模型集成了随机故障与维修仿真模块以覆盖多样化使用场景，同时配备可筛选环境最优回收路径的回收仿真模块。本方法以智能手机为示例性案例开展验证。尽管本研究开发并用于该案例的配套软件原型工具存在效率局限，但研究结果证实，该方法可明确不同设计选项以及年全球变暖潜势最低的产品配置对环境的影响。

本文件包含研究中开发的软件原型工具所需的数据库Excel文件，内含故障与维修统计数据、材料组成信息以及输入表格。使用者可直接查阅该文件以理解本研究的底层数据与研究流程，亦可将其作为输入文件供运行LCA模型的Python源代码使用，相关源代码可在以下链接获取：https://zenodo.org/doi/10.5281/zenodo.10617863

注意：公开版本中已删除对Sphera与ecoinvent数据库授权环境数据集的引用。若需运行该软件工具，请在"processes_data"工作表中补充全球变暖潜势（Global Warming Potential，或其他影响类别）的对应数值，并删除文件名中的"_noLCIA"后缀。