MINE ENERGY OPTIMIZER TOOL
Originally published: 08/10/2026 14:03
Publication number: ELQ-94756-1
View all versions & Certificate
certified

MINE ENERGY OPTIMIZER TOOL

An Excel-based mining energy planning tool that uses genetic algorithm and Monte Carlo searches to compare energy mixes, assess modeled costs, emissions and hou

Description
The Mine Energy Optimization Model is an Excel tool for exploring energy supply options for mines and industrial operations. It helps users compare combinations of solar PV, wind, hydro, battery storage, grid electricity, natural gas and diesel under selected operating assumptions.

The workbook includes genetic algorithm and Monte Carlo searches, with a choice of 1,000, 5,000 or 10,000 evaluations. Users can explore lower-cost capacity combinations or search for alternatives close to a specified annual cost target. A separate linear programming benchmark is available through Excel Solver.

Inputs include hourly demand, renewable output profiles, energy costs, annualized capital costs, emissions factors, carbon pricing and renewable targets. Results show selected capacities, hourly dispatch, operating costs, emissions, renewable contribution, grid dependence and unserved energy. Users can test scenarios such as increased production, higher fuel prices or reduced renewable output, then preserve preferred plans for comparison.

The package includes a detailed user guide covering setup, inputs, methods, result interpretation and troubleshooting. The main searches require neither Python nor VBA macros.

Designed for preliminary screening and client discussions, the model uses a representative 24-hour profile and simplified operating assumptions. Detailed engineering, annual reliability studies and financial appraisal should follow before making final procurement or investment decisions.

This Best Practice includes
1 Excel Spreadsheet, 1 pdf file

Acquire consulting license for $20.00

Add to cart

Add to bookmarks

Discuss

Further information

The objectives of this downloadable tool are to help users:
- Compare energy options including solar, wind, hydro, battery storage, grid electricity, natural gas and diesel.
- Explore capacity combinations using genetic algorithm and Monte Carlo searches.
- Evaluate modeled costs and distinguish operating, annualized capital and carbon costs.
- Assess hourly demand coverage, identifying periods of insufficient supply.
- Examine emissions and renewable energy contributions against selected targets.
- Test alternative scenarios, such as demand growth, higher energy prices and reduced renewable output.
- Support preliminary energy planning decisions with transparent Excel calculations and saved scenario comparisons.

This downloadable best practice is most useful when:
- Planning energy supply for mines or industrial sites with several potential energy sources.
- Screening hybrid energy systems combining renewables, battery storage, grid supply and thermal generation.
- Comparing preliminary options before commissioning detailed engineering or feasibility studies.
- Working with available site data, including hourly demand, renewable output profiles, energy costs and emissions factors.
- Exploring cost and environmental trade-offs, including renewable targets and carbon pricing.
- Testing changing operating conditions, such as production growth, higher fuel prices or reduced renewable output.
- Needing a transparent Excel tool for scenario analysis and discussion with clients or management.
It is best suited to preliminary planning using a representative 24-hour profile. Final investment decisions require detailed annual modeling, engineering validation and consistent cost comparisons.

This downloadable best practice is less suitable when:
- Final engineering or investment approval is required, rather than preliminary screening.
- Detailed annual or seasonal analysis is essential, as the model uses a representative 24-hour profile.
- Complex battery operation must be modeled, including charging schedules, degradation and multiple daily cycles.
- Electrical network studies are needed, such as voltage stability, power flows, protection or transmission constraints.
- Detailed generator scheduling is required, including start-up costs, ramp rates and minimum operating loads.
- Reliability must be quantified statistically, including equipment failures, outages and probabilities of supply loss.
- A complete financial appraisal is needed, including financing, taxation, depreciation, NPV and IRR.
- Reliable input data is unavailable, making comparisons highly dependent on unverified assumptions.
The tool supports initial option comparisons; these applications require more detailed models and specialist validation.


0.0 / 5 (0 votes)

please wait...