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.

本研究提出了一种基于参数化生命周期评估（parametric life cycle assessment, LCA）的新型生态设计方法。所开发的方法可对比海量不同产品配置的环境影响，此类配置可通过枚举给定设计选项的所有可能组合自动生成。该生命周期模型集成了随机故障与维修仿真模块，以覆盖多样化使用场景，同时配备可确定环境最优回收路径的回收仿真模块。本方法以智能手机为例开展案例研究，尽管研究中开发并使用的配套软件原型存在效率局限，但仍验证了该方法可识别不同设计选项的环境影响，以及年全球变暖潜势最低的产品配置。本文件包含数据库Excel文件，内含故障与维修统计数据、材料组成信息，以及本研究开发的软件原型所用的输入表格。研究人员可直接查阅该文件以理解研究中的基础数据与流程，或将其作为输入文件用于本研究的Python源代码以运行生命周期评估模型，源代码可在以下地址获取：https://zenodo.org/doi/10.5281/zenodo.10617863。注：已发布版本中已删除对Sphera与ecoinvent数据库授权环境数据集的引用。若需运行该软件工具，请在"processes_data"工作表中补充全球变暖潜势（Global Warming Potential, GWP）或其他影响类别的对应数值，并删除文件名中的"_noLCIA"后缀。