국제 수소 LCA 툴 벤치마킹을 통한 한국형 엑셀 모듈 구조 설계 연구

• 영문명: A Study on the Design of a Korean Excel Module Structure through Benchmarking of International Hydrogen LCA Tools
• 발행기관: 한국환경에너지공학회
• 저자명: 여채은 김건용 박영수
• 간행물 정보: 『환경에너지공학』제20권 제3호, 43~61쪽, 전체 19쪽
• 주제분류: 공학 > 환경공학
• 파일형태: PDF
• 발행일자: 2025.10.31

국문 초록

This study systematically benchmarks international hydrogen life-cycle assessment (LCA) tools to enhance domestic applicability and, from the findings, develops a Korean Excel-based lightweight module (v1.0). We define 15 evaluation items spanning technical (model scope, data structure, interoperability) and layout/UX (input, validation, reporting) aspects, normalize evidence from public releases/manuals to a 0–2 scale, and compute axis-wise benchmark averages. When the same scale is applied to the proposed module, it shows performance above the benchmark in 12/15 items, with an average gain of +0.49 (of 2). UX improvement (+0.67) exceeds technical (+0.37), indicating practical usability for non-specialists. The module is built around: (1) a unified functional unit of 1 kg-H₂ and sheet-level selection of EN 15804 A/B/C boundaries; (2) transparent computation via sheet separation of input → calculation/aggregation → reporting, with formulas disclosed; and (3) error-preventive UI (conditional-format warnings, dual units, example values) plus a “Version Control” sheet to strengthen reproducibility and auditability. Internal tables (“DB [ecoinvent]”, “DB—Raw materials & utilities”) enable direct reference and substitution of base coefficients (electricity by generation source, fuels, hydrogen types), facilitating explainable reporting. Rather than competing on results, we translate structure–usability–transparency evaluations into a practitioner-friendly module that can expand via K-LCI/public data and policy scenarios to support Korean hydrogen LCA.

목차

1. 서 론

2. 연구 방법

3. 수소 LCA 툴 교차 비교 분석

4. 한국형 엑셀 기반 수소 LCA 모듈 설계

5. 결 론

감사의 글

References

키워드

Hydrogen Life cycle assessment Benchmarking Excel module LCA