camiloramirezgo/Critical-Minerals-Power-Sizing-Workflow

A Snakemake pipeline optimizing power supply decisions (grid vs. solar-battery-diesel minigrids) for critical mineral mining and processing in 14 African nations. Spatial GIS data is used to estimate LCOE and CO2 emissions allocated by mineral and processing stage. # Critical Minerals Power Sizing Workflow This repository contains a Snakemake-based modeling pipeline designed to evaluate, size, and optimize power supply options for critical mineral mining and processing nodes across 14 East, Southern, and Central African nations. The workflow integrates spatial GIS analysis, hourly solar PV modeling, battery storage sizing, diesel fuel transportation costs, and utility grid constraints to decide whether a mining location should connect to the national grid or run on an off-grid solar-battery-diesel hybrid system. It also attributes capacity requirements, capital investments, and greenhouse gas emissions to specific minerals and processing stages based on their production volumes. --- ## Workflow Overview & Methodology The pipeline processes multiple scenarios across two primary scopes (`country` and `region`) and two constraint conditions (`constrained` and `unconstrained`). ```mermaid graph TD A[Raw Input Data: combined_water_*.csv] --> B[rule mining_power_sizing] C[Jan_26_GridParameters_updatedheadings.xlsx] --> B D[min_processing_values_dict_New.xlsx] --> B E[GIS layers: GHI, HV Grid, substations, accessibility] --> B B -->|Outputs Results CSVs| F[rule post_analysis] D --> F F -->|Outputs Scenario CSVs| G[rule post_post_analysis] G -->|Generates Excel Summaries| H[Summaries & Comparisons] ``` ### 1. Power Solution Decision Model For each mining site (cluster node), the model compares two main options over the project life (2023–2040): * **Off-Grid Solution (PV-Battery-Diesel Hybrid):** The model simulates different configurations (combinations of PV arrays and diesel generators) using hourly solar irradiance and temperature profiles. The configuration that minimizes the Levelized Cost of Electricity (LCOE) while satisfying a Loss of Power Supply Probability (LPSP) limit of 1% is selected. Battery sizing is dynamically matched to daily demand. * **Grid Connection Option:** The model calculates the capital cost of ex …