Integrated Domestic Electricity Demand and Solar PV Micro-Generation Model with VBA Code

Ian Richardson's integrated high-resolution model simulates domestic whole-house electricity demand and solar PV micro-generation. The model is based on a previously developed demand model and is provided as an Excel Workbook containing all necessary data and Visual Basic for Applications source code. The underlying models are discussed in a journal paper and a conference paper presented at Microgen 'II.

Use Cases

• Simulating household electricity consumption patterns based on the integrated demand model.
• Modeling solar photovoltaic micro-generation output for residential buildings.
• Analyzing the interaction between domestic electricity demand and on-site solar generation.
• Developing or validating energy system simulations using the provided VBA source code.

Strengths

• Includes the full Visual Basic for Applications source code for model transparency and modification.
• Integrates two previously published and peer-reviewed models for demand and generation.
• Workbook contains all necessary data to run the simulation without external dependencies.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Row count is unknown, which may limit suitability assessment.
• Last update date is unknown; freshness unverified.

Provenance

Source

Ian Richardson

Collection Method

Simulation model based on prior research, distributed as an Excel Workbook.