MSMGOptimizer

Overview

MSMGOptimizer is an R package that transforms raw Life Cycle Inventory (LCI) data from Excel into a fully compatible CSV format for seamless import into SimaPro — one of the world’s leading Life Cycle Assessment (LCA) software platforms.

Developed as part of the NSF-funded project:

ECO-CBET: GOALI: CAS-Climate: Expediting Decarbonization of the Cement Industry through Integration of CO2 Capture and Conversion (NSF Project No. 2219086)

Installation

Option 1 — Install from CRAN (recommended)

install.packages("MSMGOptimizer")

Option 2 — Install from GitHub (development version)

# install.packages("remotes")
remotes::install_github("Duah-Philip/MSMGOptimizer")

Option 3 — Run directly without installing

shiny::runGitHub(
  repo     = "MSMGOptimizer",
  username = "Duah-Philip",
  ref      = "master",
  subdir   = "inst/shiny"
)

Usage

library(MSMGOptimizer)

# Launch the Shiny application
ShinyMSMGOptimizer()

Features

📂 Upload .xlsx or .xls Excel LCI files
⚙ Automatically converts all worksheets to SimaPro CSV format
📦 Downloads all converted files as a single ZIP archive
👁 Live sheet preview before conversion
🔄 Supports all SimaPro exchange types:
- Materials/Fuels, Resources, Emissions to Air/Water/Soil
- Final Waste Flows, Social Issues, Economic Issues
- Waste to Treatment

Excel File Format

Your Excel file must follow this structure:

Row	Column A	Column B	Column D	Column E+
1				Process Name
2				Unit
3				Amount
4
5				Comment
6				Category
7+	Type	Name	Unit	Value

Exchange type codes for Column A:

Code	Exchange Type
(blank)	Materials/Fuels
`Raw`	Resources
`Air`	Emissions to Air
`Water`	Emissions to Water
`Soil`	Emissions to Soil
`Waste`	Final Waste Flows
`Social`	Social Issues
`Economic`	Economic Issues
`Wastetotreatment`	Waste to Treatment

Acknowledgments

Inspired by the original Python-based SimaPro CSV converter developed by Professor Massimo Pizzol.

Citation

If you use MSMGOptimizer in your research, please cite:

Duah, P. & Awuah-Offei, K. (2025). MSMGOptimizer: MSMG SimaPro CSV Optimizer.
R package version 0.1.0.
https://github.com/Duah-Philip/MSMGOptimizer

Contact

Philip Duah
Missouri University of Science & Technology
📧 dpbxc@mst.edu

mirror server hosted at Truenetwork, Russian Federation.