The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

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

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.