Nothing Special   »   [go: up one dir, main page]

Next Article in Journal
FTIR Analysis for Determining Stability of Methanol–HVO Blends for Non-Road Engine Application
Previous Article in Journal
Sizing Methodology of Dynamic Wireless Charging Infrastructures for Electric Vehicles in Highways: An Italian Case Study
Previous Article in Special Issue
The Role of Flexibility in the Integrated Operation of Low-Carbon Gas and Electricity Systems: A Review
You seem to have javascript disabled. Please note that many of the page functionalities won't work as expected without javascript enabled.
 
 
Font Type:
Arial Georgia Verdana
Font Size:
Aa Aa Aa
Line Spacing:
Column Width:
Background:
Article

clicSAND for OSeMOSYS: A User-Friendly Interface Using Open-Source Optimisation Software for Energy System Modelling Analysis

1
Department of Geography and Environment, Loughborough University, Loughborough LE11 3TU, UK
2
Centre for Environmental Policy, Imperial College London, London SW7 1NE, UK
3
Independent Researcher, Cape Town 8000, South Africa
4
United Nations Department of Economic and Social Affairs (UNDESA), New York, NY 10017, USA
5
Independent Researcher, Johannesburg 2021, South Africa
6
Chemical Engineering Department, Universitat Politècnica de Catalunya·BarcelonaTECH, 08930 Barcelona, Spain
7
Independent Researcher, 71000 Sarajevo, Bosnia and Herzegovina
8
National Renewable Energy Laboratory (NREL), Golden, CO 80401, USA
*
Author to whom correspondence should be addressed.
Energies 2024, 17(16), 3923; https://doi.org/10.3390/en17163923
Submission received: 18 January 2024 / Revised: 9 April 2024 / Accepted: 12 April 2024 / Published: 8 August 2024
(This article belongs to the Special Issue Whole-Energy System Modeling)
Figure 1
<p>Overview of the clicSAND 1.0 user platform and main functionalities. “Data Source (xls)” button […] used to select the model data file; “Model” button […] to select the OSeMOSYS code; “Run” button to initialise solving; “Export Templates…” button to download the necessary templates. The “Open Log” button is not often used; however, it opens a new file in the text editor—we will disregard it in this paper. By using the arrows of the “Ratio (CBC)” button, the user can, if needed, change the accuracy of the model solution.</p> ">
Figure 2
<p>This figure presents an overview of clicSAND 3.0 software along with its primary functionalities. A notable addition, highlighted in dark red, is the “Generate OSeMOSYS Cloud Input” button, which facilitates the conversion of .txt files into a format compatible with the OSeMOSYS Cloud platform, enabling the option to run models online.</p> ">
Figure 3
<p>Operational flowchart of the clicSAND Software 1.0—fully offline.</p> ">
Figure 4
<p>Operational flowchart of the clicSAND Software 3.0—fully offline.</p> ">
Figure 5
<p>Operational flowchart of the clicSAND Software 3.0—partially online.</p> ">
Figure 6
<p>Main functionalities of the SAND Interface Excel Sheets and a screenshot of the “Parameters” Sheet at the bottom. The green box displays a list of graphs that can be visualised in the “Results Visualisation Template”, including Annual electricity generation (PJ), Electricity production by time slice (PJ), Total annual capacity (GW), Cooking and heat generation (PJ), Transport Mix (Gpkm/Gtkm), Annual CO<sub>2</sub> emissions (kt), Annual CO<sub>2</sub> emissions by technology (kt), Demand (PJ), Annual fixed operating costs (MUSD), Annual variable operating costs (MUSD), and Annual capital investment (MUSD).</p> ">
Figure 7
<p>Example of the new template applied to a study case with three different scenarios. In the dark blue box is a list of the graphs that can be visualised with the new template.</p> ">
Figure 8
<p>Overview of the Results Converter interface. Light Blue button: “Input file” selection; Red button: “Output directory” selection; Purple button: Type a “output filename” in the blank space; Green button: “Save output filename”; Yellow button: “Run” initialises the file conversion and saves the new results file in the output directory selected.</p> ">
Figure 9
<p>Results of the South African case study developed during EMP-A: (<b>a</b>) Comparison of the electricity production; (<b>b</b>) Comparison of the CO<sub>2</sub> emissions of scenarios; (<b>c</b>) Comparison of total costs (capital, fixed operation and maintenance (O&amp;M), and fuel costs).</p> ">
Versions Notes

Abstract

:
Energy modelling plays a crucial role in assisting governmental and policymaking bodies to strategise long-term investments within the context of energy transition. Among the well-established open-source optimisation models, OSeMOSYS—the Open-Source Energy Modelling System—stands out. This paper introduces clicSAND, a novel user interface designed for OSeMOSYS, aimed at reducing the learning curve and supporting novice energy modelers in efficiently conducting long-term investment analyses. clicSAND, freely available and open-source, features a user-friendly Excel interface for data input, integrated solvers, and a visualisation dashboard for result interpretation. The outcomes, projected up to 2070, hold the potential to inform policy decisions and mobilise financial resources for sustainable development endeavors, such as ensuring affordable and secure energy supply and mitigating climate change impacts. This advancement not only democratises access to energy modelling tools but also empowers policymakers and stakeholders to conduct thorough long-term investment analyses with ease. This paper elaborates on clicSAND’s key advantages, architecture, and functionalities. Additionally, it discusses the evolutionary journey from clicSAND 1.0 to 3.0, emphasising a commitment to continuous improvement and user-centric adaptation, thereby enhancing its utility and relevance. The inclusion of a South African case study, conducted during the EMP-A (Energy Modelling Platform for Africa) 2021 international capacity-building event, showcases clicSAND’s efficacy in facilitating knowledge transfer and skill development among inexperienced users, while providing a tangible example of its application in addressing specific regional energy challenges and policy contexts. Finally, current applications and future extensions of the software are also presented.

1. Scientific Significance and Purpose of the Study

The climate change crisis demands bold and courageous action from individuals and governments. One such action is the ‘energy transition’, which entails shifting away from a carbon-based economy towards less-polluting options like renewable energy sources. This transition necessitates multi-billion-dollar investments and long-term scenario planning extending to 2050, 2070, and beyond. To accomplish this, governments, academics, international organisations, and private-sector consultancies increasingly rely on energy models for long-term investment planning. These models offer valuable insights for efficient and reliable energy production aligned with climate change mitigation efforts. However, they are often complex and demanding, requiring a significant investment of time and resources to acquire the necessary skills. Hence, this study aims to explore how advancements in user interface design within energy modelling software can enhance accessibility, efficiency, and democratisation of access. This, in turn, can facilitate informed decision-making and sustainable development initiatives among policymakers and stakeholders.

1.1. A Focus on OSeMOSYS—The Open-Source Energy Modelling System

While there are numerous energy modelling tools available, this study focuses specifically on the Open-Source Energy Modelling System (OSeMOSYS) [1]. OSeMOSYS was selected due to its widespread adoption [2], robustness, and several distinct features that set it apart within the field. One notable feature is its recognition as being particularly well-suited for analysing energy scenarios in developing and emerging countries [3]. OSeMOSYS has been identified as the second-highest energy modelling tool used for analysis, especially for examining energy supply pathways and reducing greenhouse gas (GHG) emissions while effectively capturing the unique features of developing countries’ energy systems [3]. Moreover, another systematic literature review on energy system optimisation models (ESOMs) identified OSeMOSYS as “the most advanced in open science due to its diverse channels to communicate with users and developers and a further scope within the energy policy community” and of being “at the forefront of open-source codes due to its straightforward, elegant, and transparent setting, the adaptation for simple refinements, and the ability to conduct sophisticated analyses” [4]. Initially developed at the Royal Institute of Technology (KTH) in collaboration with various institutions and organisations [5], OSeMOSYS is a long-term bottom-up optimisation model for energy system analysis leading to better investment planning, as demonstrated by its use in various applications [6,7,8] and in the newly developed Data-to-Deal (D2D) approach [9].
By grounding our study within the context of OSeMOSYS, we acknowledge the significance of leveraging existing advancements in energy modelling. Our focus on enhancing user interface design within this established framework aims to build upon its strengths, further improving accessibility and usability. In doing so, we aspire to contribute to the broader goal of enabling informed decision-making and driving the transition towards sustainable energy systems.

State of the Art of OSeMOSYS User Interfaces

Throughout the continued development of OSeMOSYS over the past 15 years, developers focused on improving the user interface and user-friendliness, which enable skills to be developed faster and accelerate the uptake of models towards the formulation of sustainable development policies. Initially, users had to interact directly with the code and the input data file via text editor software and the command line, which was time-consuming and difficult for non-advanced users. As a result, a stand-alone open-source interface called MoManI (Model Management Infrastructure) was developed [10]. However, this interface had significant limitations in terms of data management [11]. The OSeMOSYS community tried to replicate the same functionality within an Excel workbook, but this informal process led to duplication of effort and scattered resources.
Cannone [11] addressed this problem by developing an Excel-based interface for OSeMOSYS called SAND (Simple And Nearly Done). Although the Excel interface improved the collection and input of data, the user still had to interact with the command line via simple lines of code to run the models, and computation time could be a few hours. Thus, stemming from the Excel SAND Interface, clicSAND is a user-friendly software interface designed for OSeMOSYS, created to overcome these limitations. It adds integrated solvers, one-click installation, and a graphical user-interface. clicSAND provides the OSeMOSYS community with an easy-to-use interface for energy modelling analysis and has been widely used for several applications (see Section 4.2). The clicSAND software helps model alternative long-term pathways of a selected region, identifying the optimal energy mix configuration, including allocation of energy resources and associated financial investment. Moreover, clicSAND is available for Windows and Mac users [12], increasing the accessibility of this tool to a wider audience.
The scientific novelty of the presented clicSAND software lies in its user interface innovation and its capacity to enhance accessibility and efficiency in energy modelling tasks, particularly for novice users. By introducing a user-friendly Excel interface coupled with integrated solvers and a visualisation dashboard, clicSAND significantly reduces the learning curve associated with complex energy modelling systems like OSeMOSYS. This advancement not only democratises access to energy modelling tools but also empowers policymakers and stakeholders to conduct thorough long-term investment analyses with ease.
The remainder of the paper is structured as follows: Section 2 presents clicSAND’s architecture and main functionalities. Section 3 provides a brief, illustrative example of clicSAND use. Finally, Section 4 concludes by presenting current and past software applications, extensions, and future work.

2. Software Description

This section outlines the key features of the clicSAND software in its initial version, clicSAND 1.0, and highlights the enhancements introduced in its third iteration, clicSAND 3.0. A brief mention will also be made of the macOS version of the software, clicSAND 2.0.

2.1. Key Features of clicSAND 1.0 Software

A basic overview of the clicSAND 1.0 software and its main functionalities is provided in Figure 1, while the primary advantages and limitations are summarised in Table 1. It utilises the SAND Excel interface as the sole data entry point for the user. A significant usability advantage is that no interaction with the command line is necessary during the modelling process. Furthermore, the software operates entirely offline, which is especially beneficial for regions with low-bandwidth connections.
A one-click installation package containing all the necessary components of the software is freely available for download on GitHub [13]. Instructions on correctly installing the clicSAND 1.0 software and the two free solvers can be found on Zenodo [14]. Additionally, a step-by-step online certified course hosted on the Open Learn Create (OLC) Platform is available as a public good [15]. This course combines theoretical lessons with practical exercises, teaching users the theory behind energy modelling for investment planning and how to build an energy model from scratch using the clicSAND 1.0 software for OSeMOSYS. The authors recommend that first-time users of the clicSAND 1.0 software enrol in this online course and carefully follow the instructions provided in practical exercises 1, 2, and 3:
  • Hands-on 1: Download and installation of the clicSAND 1.0 software and the solvers (GLPK and CBC).
  • Hands-on 2: Best practices for inputting data into the Excel SAND Interface and practical examples for one technology.
  • Hands-on 3: Instructions on how to save, run, and visualise results using the Microsoft Access database and the Excel template provided with the software.
Another asset of the clicSAND 1.0 software lies in its compatibility with a related project aimed at creating Starter Data Kits (SDKs) [16,17]. These SDKs consist of national datasets and simple energy system models, currently available for 69 countries in Africa, East Asia, and South America (Appendix A). Notably, the models in the Starter Data Kits were constructed using the Excel SAND Interface, and the results were obtained by running the clicSAND 1.0 software. The scientific significance of the SDK lies in its facilitation of access to national datasets and energy system models, thereby streamlining research processes and enhancing the efficiency of energy analysis. By providing a comprehensive set of predefined parameters within the SAND file, the SDK eliminates the arduous task of manual data entry, allowing researchers to focus more on analysis and interpretation.
One key requirement of this first version of the software is the need for at least 8 GB of RAM for smooth operation, along with a Windows computer with Microsoft Access and Excel installed, both of which are commercial software. However, to broaden the accessibility of this public good and to overcome the need for a Windows operating system, a second version of the clicSAND software (clicSAND 2.0), which is compatible with macOS and does not require Microsoft Access, was recently released. Details regarding this are provided in Section 4.1.1 of this paper. Similarly, to address the 8 GB RAM requirement, a third version of the software, clicSAND 3.0, was developed. This version offers the flexibility to execute a model on an online cloud platform, thereby eliminating the need for dependence on the computer’s memory.
The Excel SAND interface is specifically designed for beginner and intermediate users, allowing them to work on middle-sized models with basic regional and temporal resolution. As explained in Section 2.3, the Excel SAND Interface serves as the platform where users can intuitively input data for up to 200 technologies, 50 commodities, five types of emissions, one region, and 96 time slices.
It is important to note that when initially using the Excel Interface to input data, users need to be cautious when pasting data while a filter is applied, as Excel will copy the data to the subsequent row and not to the next filtered row. Nevertheless, to assist users in avoiding mistakes during model compilation, step-by-step video guidance has been released on YouTube, demonstrating best practices for effectively inputting data [18].
Another weakness of the first version of the clicSAND software for Windows was its inability to detect errors if the model failed during the run. In fact, the software platform depicted in Figure 1 does not specify the exact error that might occur; it simply indicates that the model is not functioning. This issue also arose when running OSeMOSYS models with other interfaces. To address this limitation and enhance the troubleshooting experience, clicSAND 3.0 has been equipped with functionality to identify in which step of the process the model is failing, as detailed in Section 2.2 of this paper.
All versions of the clicSAND software are fully compatible with the existing OSeMOSYS architecture, meaning that the constraints, variables, and parameters are all represented. Additionally, two widely used solvers to find a model’s optimal solution, GLPK (GNU Linear Programming Kit) [19] and CBC (COIN-OR branch and cut) [20], are included as part of the open-source and freely available clicSAND software.
Moreover, the results produced by the software are fully compatible with other tools such as CLEWS (Climate, Land, Food, Energy, and Water systems approach) [21], the IRENA FlexTool for analysing system flexibility, MUSE (Modular energy system Simulation Environment) [22], and other OSeMOSYS platforms, including the OSeMOSYS Cloud platform [23] (which provides online solvers through a cloud service). Further details on this compatibility are provided in Section 2.4.2 of this paper.

2.2. Enhancements in the clicSAND 1.0 Software: The Release of clicSAND 3.0

The decision to enhance the functionalities of clicSAND 1.0 and release an improved version, clicSAND 3.0, arose from a continuous improvement process. This process involved collecting feedback from users through surveys distributed at the conclusion of various capacity-building events. During these events, inexperienced users were tasked with constructing basic national OSeMOSYS models within a three-week timeframe using clicSAND 1.0. As indicated in Table A2 (Appendix B), the feedback received confirmed the limitations that developers had already identified, primarily concerning extended computational times and the laborious process of visualising results through an Access database.
To address these limitations, the authors developed, tested, and implemented a new version of the clicSAND software, known as clicSAND 3.0. Drawing inspiration from the innovations in clicSANDMac (clicSAND 2.0), this version of the software embeds a Python code that effectively reduces the data file size (both matrix and LP-file) by pre-filtering unused elements—available for download on GitHub [24]. This optimisation significantly accelerates the solving process. Additionally, this feature eliminates the need for an Access database to visualise results, which will be further elaborated upon in Section 2.5.2. Instructions to install clicSAND 3.0 and run the model on the OSeMOSYS Cloud are available on Zenodo [25]. Specific teaching material and exercises using clicSAND 3.0 are also freely available as a public good [26].
As discussed in the preceding section, clicSAND 1.0 had a specific requirement, necessitating a minimum of 8 GB of RAM for smooth model execution. However, clicSAND 3.0 has comprehensively addressed this requirement by introducing the capability to run models not only offline but also online through a cloud-based platform known as OSeMOSYS Cloud. This innovative approach circumvents the need to rely entirely on the computer’s internal memory, as elaborated further in Section 2.4.2.
To facilitate this novel functionality, significant modifications were made to the user interface of clicSAND 3.0. As shown in Figure 2, it now includes a button labelled “Generate OSeMOSYS Cloud input”. This button streamlines the process of formatting the .txt file generated by the Excel SAND interface into a compatible format tailored specifically for seamless integration with the OSeMOSYS Cloud platform. This transformative enhancement substantially expands the accessibility and flexibility of clicSAND 3.0, empowering users to tap into cloud resources without being restricted by local hardware limitations.
The integration with the OSeMOSYS Cloud platform greatly enhances the software’s convenience and adaptability, allowing users to access models and results from virtually anywhere, at any time. This development marks a significant step forward in making clicSAND 3.0 a versatile and user-centric tool in the field.
As highlighted in Table 1, one of the prominent limitations of clicSAND 1.0 revolved around troubleshooting and debugging challenges. In this earlier version, inexperienced users encountered significant difficulty in identifying errors because the user platform did not provide clear indications of where the error occurred, making the debugging process a challenging task.
However, with the introduction of clicSAND 3.0, this challenge has been effectively addressed through two key enhancements. First, when running a model offline, the user platform now displays the specific line where the error occurred, greatly simplifying the process of identifying and rectifying mistakes. Second, when utilising the OSeMOSYS Cloud to run a model, users have the ability to monitor the entire solving process in real-time, allowing them to pinpoint precisely where the process encounters an issue.
Furthermore, the integration with the cloud offers an exceptional feature for debugging: as a clicSAND model runs, OSeMOSYS Cloud generates a visualisation of the Reference Energy System for that model. This empowers users to effortlessly visualise their input data with a single click [23]. Any missing connections within the model are highlighted in red, providing valuable assistance to users in identifying and rectifying bugs within their models. These advancements collectively enhance the user experience, making troubleshooting and debugging significantly more accessible and efficient in clicSAND 3.0.
As summarised in Table 2, clicSAND 3.0 maintains the benefits introduced in clicSAND 1.0 while introducing enhanced features. These include embedded Python code, which reduces data file size and accelerates computation (with clicSAND 3.0, a full Starter Data Kit runs in less than 10 min). Users now have the flexibility to work offline or access a cloud-based service, eliminating the need for dependence on local memory. The tool also streamlines result visualisation with an offline Excel template and seamlessly integrates with the OSeMOSYS Cloud, enabling offline result visualisation.

2.3. Software Licenses

The clicSAND software and its components are licensed under an MIT license (open-source and free of charge), which permits the public to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the software. Users can do so by giving credit, linking to the license, and indicating if they have made any changes to the work in all copies or substantial portions of the software. clicSAND is written using the C# language, enabling easy uptake, improvements, and adaptability.

2.4. Operating the Software

2.4.1. clicSAND 1.0

As mentioned earlier, the user downloads the one-click installation package from GitHub [13], runs the executable, and follows the instructions for installing the GLPK solver and CBC solver available on Zenodo [14], either as part of the OLC online course [15] or in the ReadMe file of the clicSAND repository [24]. The one-click installation package contains the following components:
  • User platform (Figure 1);
  • Excel SAND Interface to input data (see Section 2.5.1);
  • Access database to import results;
  • Excel template to visualise the results;
  • OSeMOSYS code needed by the solvers.
The user populates the SAND Interface on Excel using a single spreadsheet where all the OSeMOSYS sets and parameters can be defined. Additionally, all parameters are initially set to default values to save time on entering non-variable data. The spreadsheet uses filters to guide the user in compiling the data file. The flowchart in Figure 3 describes all the process steps, while specific functionalities of the SAND Interface are presented in Section 2.5.1.
Next, the user saves and closes the Excel file to open the clicSAND executable (Figure 1). The user selects the SAND Excel file and then the OSeMOSYS code by clicking respectively on the “Data Source (xls)” button […] and “Model” button […] as presented in Figure 1. The OSeMOSYS code contains the mathematical model with the definition of sets, parameters, variables, and constraints. By using the arrows of the “Ratio (CBC)” button, the user can, if needed, change the accuracy of the model solution (a 0.05 ratio, which is usually used, means that a 5% range of error on the optimal solution is accepted). A lower ratio will result in a longer computational time.
A VBA (Visual Basic for Applications) Macro in the selected SAND Excel workbook is executed by clicking ‘Run’. The macro copies the last tab in SAND, named “ToDataFile”, into a new text file. The first solver, GLPK, will generate the matrix based on the data file and code selected. Then the second solver, CBC, will find the optimal solution and produce results in a text file format. If the model successfully runs, the large text box in Figure 1 will show lines of text describing the process followed and ends up with a sentence saying the “Optimal Solution was found”.
At that point, the results obtained will have been saved in a .txt file and should then be imported into the Access database. The last step to visualise the results requires the user to link the Excel Result Visualisation template with the Access database. The authors highly recommend following the step-by-step instructions on how to run and visualise the results provided in Hands-on 3 of the OLC Course [27] and the YouTube video [18].

2.4.2. clicSAND 3.0

Figure 4 illustrates the primary operational contrast between the third and first versions of the software. Specifically, it outlines the steps for a fully offline run with clicSAND 3.0. Meanwhile, Figure 5 details the procedures for a partially online run, which does not rely on the computer’s memory but utilises the OSeMOSYS Cloud platform.

Offline Run

When it comes to solving the model in clicSAND 3.0, clicking the “Run” button initiates the execution of an embedded Python code. This Python code, seamlessly integrated into the software, eliminates the need for users to possess Python skills and to engage with any coding. The code, which is also available in the folder “Python scripts” of the GitHub repository [24], scans the existing data combinations in the “ToDataFile” tab of the Excel SAND interface, where user-added data are stored. Consequently, it generates a considerably smaller matrix and data file that exclusively includes the existing combinations of technologies and fuels, resulting in a significant reduction in data file size. While a data file in clicSAND 1.0 was typically around 50MB, in clicSAND 3.0, it is approximately 1MB. This reduction in data file size significantly accelerates processing by the solvers, with a Starter Data Kit now taking only 5–6 min, as opposed to the previous 1.5–2 h. Another noteworthy difference in clicSAND 3.0 is that, upon solver completion, an automatic Result File in .csv format is generated. This .csv file can be directly imported into the newly created Excel “Results Template” with just a single click. Consequently, there is no longer a need for the Microsoft Access database and for the time-consuming process associated with it required in clicSAND 1.0. The “Results Template” facilitates the comparison of multiple scenarios and allows for the visualisation of up to 25 graphs (more details in Section 2.5.2).

Partially Online Run

This section outlines what happens in the clicSAND 3.0 interface when users opt to utilise the OSeMOSYS Cloud platform to run their models rather than relying on their machine’s internal RAM. If this option is chosen, users need to initiate the process by clicking on the newly introduced “Generate OSeMOSYS Cloud Input” button, as shown in Figure 2. Similarly to the offline run, the embedded Python code is executed, resulting in the generation of a compressed data file in the format required by the OSeMOSYS Cloud to run an OSeMOSYS model. At this point, users move to the OSeMOSYS Cloud platform. After creating a new run, they select the OSeMOSYS code and the compressed data file, then click “Run”. This initiates a process involving the creation of the matrix and so forth, ultimately producing the results. To view these results, users must download the Results.txt file from the cloud. Subsequently, they can employ the Results Converter app to transform the .txt file into a .csv format, which is ready for one-click import into the new Excel Results template, as per the offline version explained earlier. The benefits of running online are that it does not burden the internal RAM, and users can run multiple models simultaneously. However, it necessitates the additional step of using the results converter to visualise the graphs.

2.5. Software Functionalities

2.5.1. Input Data through the SAND Excel Interface

The clicSAND software comprises several components, but in this section, we will specifically discuss two of them—the SAND Excel interface and the Result Visualisation template—since users primarily interact with these for data management. Illustrated in Figure 6, the SAND Interface is an Excel workbook containing four sheets: Naming, SETS, Parameters, and ToDataFile.
In the “Naming” sheet, users find descriptions of all parameters utilised to construct and constrain the model. The “SETS” sheet enables users to define the names of up to 200 technologies, 50 commodities, and five types of emissions within their model. Users can revisit this sheet and make unlimited changes without losing progress. Any naming conventions added in the “SETS” sheet are automatically inserted into the other two sheets: “Parameters” and “ToDataFile”.
The “Parameters” sheet (see screenshot in Figure 6) is a worksheet containing 48,757 rows, encompassing all the OSeMOSYS parameters necessary for building a model. Each column is equipped with filters to enhance the interface’s usability. This enables users to apply multiple filters to pinpoint the desired data entry point. For instance, to input fixed costs for renewable technologies like geothermal, solar, wind, and hydro (as depicted in Figure 6), users access the Parameters sheet, filter out the fixed costs in column A, then filter out the selected technologies in column C, and finally, insert the data into columns K to BN (representing years 2015 to 2070).
The user follows this process for all data inputs in their model. The interface provides a modelling period spanning up to 55 years (from 2015 to 2070) and up to 96 time slices. Nevertheless, users have the option to model a shorter period or decrease the temporal resolution (number of time slices) as per their requirements (refer to guided exercises [28,29] and video recordings [30,31]).
In all versions of clicSAND, the user does not directly interact with the “ToDataFile” sheet to input modelling data. This sheet is pre-formatted to meet the requirements of the solvers, automatically capturing all data added from SETS and the Parameters sheet. When the user clicks ‘Run’ in clicSAND 1.0 (Figure 1), a VBA macro embedded in the Excel SAND Interface is triggered. This macro opens the SAND Interface, retrieves the “ToDataFile” sheet, and saves it in a new .txt file used by the solvers to find the optimal solution.
However, in clicSAND 3.0, an additional step is performed when clicking ‘Run’. The .txt file generated by the VBA macro undergoes processing with an embedded Python code. This code selectively includes only the existing combinations with non-default values, significantly reducing the size of the .txt file. As a result, the computational time is greatly shortened compared to that of clicSAND 1.0, as explained earlier in Section 2.4.2.

2.5.2. Results Visualisation Templates

clicSAND 1.0

In the Results Visualisation Template file (a separate Excel workbook), users can visualise the results of their modelling exercises (refer to the available graphs in the green box of Figure 6). These graphs are generated using pivot tables and depend on an Access database to store the data in a compatible format. In the following section, an illustrative example of an analysis using this software will be presented.

clicSAND 3.0

In clicSAND 3.0, we have introduced a new visualisation template aimed at enhancing usability and flexibility. Figure 7 presents an example of the template applied to a case study with three different scenarios. This template, also Excel-based, eliminates the need for Microsoft Access, streamlining the entire process. In the case of an offline run, a ready-to-use .csv file is generated in the correct format for easy copying and pasting into the visualisation template. However, if the run is conducted via the OSeMOSYS Cloud, it produces a .txt file, which is subsequently processed using a dedicated tool called the Results Converter (See Figure 8), included in the installation package of clicSAND 3.0. This converter transforms the .txt format into an equivalent .csv format, making it compatible with the visualisation template. After inputting the results, users can easily generate a series of graphs automatically by following a few simple steps. One notable addition is the feature to graph any number of scenarios, making it effortless to compare them, as shown in Figure 7, with three scenarios analysed. Furthermore, each graph includes slicers that allow users to select any combination of parameters to be displayed, enabling a wide range of analyses. To assist users in using this new visualisation template, the authors have developed a training video that demonstrates its functionality [32].

3. Illustrative Example of the Application of the clicSAND Software

This section presents the outcomes of a case study conducted for South Africa as part of the EMP-A (Energy Modelling Platform for Africa) 2021 capacity-building event [33]. The inclusion of such illustrative examples is crucial in demonstrating the practical application and capabilities of the clicSAND software and its interface. These examples provide concrete scenarios where clicSAND can effectively be used for energy modelling analyses, thereby providing valuable insights for decision-making processes. Specifically, the South Africa case study illustrates how clicSAND can analyse and evaluate energy system dynamics, resource allocation, and investment strategies within a real-world context. Through simulations of various scenarios and policy interventions, stakeholders can assess potential impacts on energy supply, demand, and environmental sustainability, thus informing strategic decisions and policy formulation processes. Furthermore, the South Africa case study serves as a reference point for users to understand the functionalities of clicSAND and its relevance to specific regional or national contexts. It demonstrates the versatility of clicSAND in addressing diverse energy challenges and emphasises its applicability across various geographical locations and socioeconomic settings.
The results of this case study come from a three-week online training course centred on clicSAND 1.0 for OSeMOSYS, as the third version of the software was not released at that time. Participants had no prior knowledge of OSeMOSYS. It is notable that the format of the results presented in Figure 9 was achieved using an additional scientific plotting package called Veusz [34], for post-processing graphics production, which was fully compatible with the Excel template generated with clicSAND 1.0 software. At the time of the initial writing, an older version of clicSAND was in operation, requiring Veusz for visualisations. However, with clicSAND 3.0, users can now visualise high-quality results using the new Excel Visualisation Template, as explained in Section 2.4.2, without the need of the software Veusz.

3.1. Background and Modelling Questions

The South African power system relies significantly on coal [35]. As a result, an exercise was conducted to explore the potential implications of reduced coal dependence compared to existing policy and the least-cost scenario. In order to create a representative scenario, all coal capacity would be decommissioned by 2040. The exercise considered the following questions:
  • How will the energy mix evolve?
  • How will CO2 emissions change?
  • What roles will different technologies play?

3.2. Modelled Scenarios and Starter Data Kit

The modelled scenarios are summarised in Table 3. The base model for the ‘Existing Policy’ scenario utilised an adjusted version of the available South African Starter Data Kit for implementation in OSeMOSYS [36,37], with further adjustments made (described in Table 3) to define the ‘Least Cost’ and ‘Game Change’ scenarios.

3.3. Discussion of Results

Compared to the Existing Policy scenario, both the Least Cost and Game Change scenarios show a trend towards a more diversified clean energy mix (Figure 9). In these scenarios, new-build capacity is predominantly comprised of solar photovoltaics and onshore wind, which serve to replace decommissioned coal capacity as per the planned transition, while also meeting the increasing energy demand. Transitioning from the Least Cost scenario to the Game Change scenario, there is a further increase in the deployment of solar photovoltaic and onshore wind technologies. Additionally, gas-fired generation capacity is introduced to supplement the energy gap left by the decommissioned coal capacity by 2040.

3.4. Policy Implications and Future Work

Based on the findings of these representative scenarios (see Figure 9a), early preparation for a transitioned power sector in South Africa is recommended. The primary objective is to gradually move away from coal-fired power generation through phased implementation, incorporating geographically tailored policy interventions, and conducting assessments of associated socio-economic costs and benefits.
Figure 9b compares the total system and discounted costs across the scenarios. Given the potentially significant role of variable renewable energy (VRE) such as solar photovoltaics and wind in South Africa (refer to Figure 9a), it is advisable to prioritise the localisation of the VRE supply chain whenever feasible. However, this localisation may lead to increased electricity costs.
While the adoption of the considered technologies results in reduced CO2 emissions (see Figure 9c), the transition to natural gas capacity from coal indicates a continued dependence on thermal fuels and imported fuel, raising concerns about energy security. This study did not delve into storage options (short- or long-duration) due to its limited scope for demonstration purposes and the absence of specific insights into the potential role of storage. However, considering the high penetration levels of VRE, particularly solar PV and wind (onshore/offshore), further exploration of various short-duration and long-duration storage options presents an exciting avenue for future research.

4. Software Extensions and Future Work

In conclusion, clicSAND presents a significant advancement in energy modelling, marked by its innovative user interface and enhanced accessibility for users across different expertise levels. The evolution from clicSAND 1.0 to the latest version, clicSAND 3.0, demonstrates a commitment to continual improvement and adaptation to user needs. By introducing a user-friendly Excel interface coupled with integrated solvers and a visualisation dashboard, clicSAND simplifies complex processes and empowers users to conduct thorough long-term investment analyses with unprecedented ease. The software’s integration of cutting-edge features such as embedded Python code, file size reduction, and real-time debugging through OSeMOSYS Cloud underscores its relevance and utility in the field. Notably, clicSAND’s transition from offline to cloud-based operations further enhances accessibility, enabling users to navigate complex energy models effortlessly. Moreover, clicSAND’s role in informing sustainable policies and mobilising resources highlights its importance in shaping a resilient and environmentally friendly energy future. The success stories showcased, such as the South African case study, underscore clicSAND’s effectiveness in facilitating knowledge transfer and skill development among participants of international capacity-building events. In essence, clicSAND represents a significant contribution to the field of energy system modelling, with promising implications for informed decision-making and sustainable development initiatives. In the remainder of this section, other parallel advancements of the clicSAND software will be presented, namely, its macOS version and the web interface OSeMOSYS UI. Finally, the chapter will showcase recent impacts and success stories of using clicSAND and will conclude with a view of future work and improvements.

4.1. Extensions and Software Updates

4.1.1. clicSAND for MacOS Users (clicSAND 2.0)

A second version of the software, called clicSAND for the Macintosh User Group (clicSANDMac), was developed [12,39,40]. This allows clicSAND and the Starter Data Kits [16] to be accessible and adaptable to a wider audience. The same principles and functionalities of clicSAND 1.0 for Windows and source code are maintained; however, a few changes are required for macOS compatibility. For example, Microsoft Access was replaced with a Python-based data manipulation approach (consequently embedded in the clicSAND 3.0 software for Windows). Additionally, data are run in a text file format rather than an Excel spreadsheet (however, the user still inputs the data through the Excel SAND Interface). An online course solely for OSeMOSYS MacOS users was released on the OLC Platform [41].

4.1.2. OSeMOSYS UI Development

As previously discussed, a notable feature of clicSAND is its utilisation of spreadsheets for data management. However, it is important to acknowledge that Microsoft Excel, a common choice for this purpose, has inherent limitations. These limitations encompass security vulnerabilities, error-prone operations, organisational challenges, and scalability issues, particularly when dealing with extensive projects. Recognising these challenges and building on the clicSAND software components, the development of an OSeMOSYS user-friendly interface has evolved into a comprehensive, standalone application known as OSeMOSYS UI. OSeMOSYS UI, developed by the United Nations Department of Economic and Social Affairs (UNDESA) [42], is available as a stand-alone platform on GitHub [43], empowering users to efficiently create, execute, and analyse OSeMOSYS models. Crucially, OSeMOSYS UI functions independently of any Microsoft software. It provides the flexibility to set up various units, construct models, and execute the solver, all within a unified interface. Furthermore, it streamlines the process of downloading and uploading models, facilitating seamless model-sharing among users. This not only promotes collaborative research but also simplifies the task of model updates over time, ensuring that research remains current and relevant.
Despite these advancements, it is important to highlight that the clicSAND software served as an initial iteration in improving user interaction with the OSeMOSYS model, predating the development of the web interface, OSeMOSYS UI. While the web interface represents a significant advancement in terms of accessibility and usability, it is essential to emphasise the continued relevance and benefits of the clicSAND software, particularly in regions with limited internet access. In low- to middle-income countries where internet bandwidth may be restricted or unreliable, the clicSAND software remains a valuable tool for energy modelling tasks. Its offline functionality allows users to work with the OSeMOSYS model without relying on internet connectivity, ensuring uninterrupted workflow and data manipulation even in areas with limited access to high-speed internet.
Furthermore, the clicSAND software may also cater to users who are more familiar and comfortable with traditional spreadsheet software like Microsoft Excel. Its interface provides a familiar environment for data input and manipulation, potentially reducing the learning curve for users transitioning to energy modelling tools. Therefore, while the OSeMOSYS UI represents a significant step forward in terms of accessibility and features, the clicSAND software continues to offer practical benefits, particularly in regions where internet access may be limited or unreliable, and for users who prefer a familiar spreadsheet-based environment.

4.2. Impact and Use of clicSAND Software

The clicSAND software has been employed in teaching, research analysis, and policy evaluation within a broader energy planning ecosystem [2]. It was initially used and tested with six Imperial College London master’s students for thesis projects in Kenya [44], Nigeria [45], Vietnam [46], Laos [47,48], and Armenia [49]. It proved to be a flexible tool supporting national energy planning strategies. These theses have expanded existing research and been incorporated into national government energy strategies (e.g., Vietnam [50]). clicSAND has also been used to develop 69 country Starter Data Kits (for countries in Africa, Asia, and South America), which are zero-order models with complete datasets freely available on Zenodo and pre-print papers on Research Square (complete list: Appendix A).
Furthermore, the clicSAND software was used to train over 250 energy analysts and academics during international capacity-building events, such as the Summer Schools at the Abdus Salam International Centre for Theoretical Physics (ICTP) [51,52,53], the EMP-A [33,54] and the Energy Modelling Platform for Latin America and the Caribbeans [55,56]. In these events, the skills previously taught using MoManI are now gained using the clicSAND software. As a result of these events, several researchers and government energy ministry analysts utilise clicSAND to build national energy strategies [57]. As explained in [2], the International Energy Agency (IEA) has made it a requirement to complete the OLC Platform online courses on OSeMOSYS, called “Energy and Flexibility Modelling”, using the clicSAND interface as a condition for taking part in its technical assistance program in Africa [58], utilising two of the above-mentioned capacity-building events, namely EMP-A 23 and ICTP 23.
clicSAND is the base of the practical exercises of the OLC Platform online course on “Energy and Flexibility Modelling” [15], which 444 people have currently completed and, in doing so, obtained an official certificate which was translated into Spanish. The GitHub supplementary repository is available on Zenodo [14].
Following participation in the OSeMOSYS&Flextool track of the online training event EMP-A 2021, a lecturer from Makerere University Business School, Faculty of Economics, Energy & Management Science, Department of Economics, incorporated two open-source tools into a postgraduate course syllabus. One of these tools was OSeMOSYS, along with its clicSAND software. clicSAND for OSeMOSYS was integrated into the syllabi of master’s and Ph.D. courses on Energy Economics and Governance at Makerere University Business School in Kampala, Uganda. Moreover, clicSAND is currently used to teach how to perform energy modelling analysis in the Climate Change Politics and Policy Master’s course [59] and the Climate Change Science and Management Degree [60] at Loughborough University [59], and to students of the Centre for Environmental Policy at Imperial College London working on their master’s thesis in consultation with the UK Government Energy Transition Council (ETC) [61].
To address the numerous requests from students for more teaching materials and video lectures, the authors have created a compilation of exercises which span applied case studies on clean cooking, decarbonisation of transport, and the integration of hydrogen and storage in OSeMOSYS using clicSAND 3.0 software (full list of available teaching material in Appendix C).
A survey conducted among participants in the capacity-building events, EMP-A 2021, and ICTP 2022, focusing on Energy and Flexibility Modelling, aimed at assessing the compatibility and user-friendliness of software tools. The survey results, presented in more detail in Appendix B, demonstrate that both the SAND Excel Interface and the initial version of clicSAND 1.0 received satisfactory ratings of 75/100 for their ease of use and user-friendliness. However, the results revealed certain weaknesses in terms of computational speed for the solvers. In response to the identified computational challenges, the development team introduced clicSAND 3.0, a solution designed to reduce data file sizes and significantly enhance solver performance (detailed information available in Section 2.4.2). As shown in Appendix B, following the integration of clicSAND 3.0 in international capacity-building events, subsequent feedback surveys indicated a noticeable improvement in both user satisfaction and software usability over time. These surveys consistently reported higher ratings, reflecting users’ growing perception of these tools as user-friendly and easy to use. Moreover, the speed and performance of the software and associated cloud platform demonstrated tangible improvements, marking a positive trend. Finally, clicSAND was an invaluable asset in the initial phase of OSEMOSYS UI development as a blueprint and prototype for data structure design.

4.3. Future Work

Looking forward, the future direction of clicSAND involves a comprehensive approach to enhance its functionalities and applicability in energy modelling. This includes improving features related to energy storage, integrating hydrogen, and refining transport system representation within the software to ensure a holistic view of energy transitions. Additionally, there is a need to explore advanced methods for representing transport data accurately, considering the complexities of mobility patterns and infrastructure requirements. Furthermore, integrating social aspects and parameters into the modelling framework is crucial for capturing societal impacts and preferences, thereby enhancing decision-making processes. Moreover, expanding the capability for multi-regional studies in clicSAND can offer valuable insights into interconnected energy systems, facilitating integrated planning and policy development across different geographical regions. Through these efforts, clicSAND aims to remain at the forefront of energy modelling, contributing to sustainable decision-making in the global energy sector.

Author Contributions

C.C.: Conceptualisation; Data curation; Investigation; Methodology; Software; Formal analysis; Validation; Visualisation; Writing—Original Draft. L.A.: Data curation; Investigation; Visualisation; Validation; Review. N.d.W.: Software; Visualisation; Validation. A.S.: Software; Formal Analysis; Validation; Methodology; Review. P.G.: Software; Formal Analysis; Validation. C.V.: Conceptualisation; Methodology; Review. A.K.: Software; Formal Analysis; Validation. F.A.P.N.: Software; Formal Analysis; Validation; Visualisation; Writing – Secondary Draft. R.M.: Software; Data Curation; Review. V.K.: Validation; Formal Analysis; Review. J.W.: Formal Analysis; Validation; Visualisation; Writing—Secondary Draft. R.Y.: Formal Analysis; Visualisation; Writing—Secondary Draft. N.T.: Formal Analysis; Visualisation; Writing—Secondary Draft; Writing—Secondary Draft. L.S.T.: Review. J.H.: Review. M.H.: Conceptualisation; Investigation; Methodology; Validation; Review. All authors have read and agreed to the published version of the manuscript.

Funding

For this research, CCG contributed to funding the time dedication of the co-authors for the production of this material, and CCG funded the publishing fees associated with the publishing of this material (APC). CCG (IATI identifier: GB-GOV-1-300125) is funded by the Foreign, Commonwealth and Development Office (FCDO) of the UK government; it brings together leading research organisations and is led out of the STEER Centre, Loughborough University. However, the views expressed herein do not necessarily reflect the UK government’s official policies.

Data Availability Statement

The original contributions presented in the study are included in the article, further inquiries can be directed to the corresponding authors. This work follows the U4RIA guidelines, which provide a set of high-level goals relating to conducting energy system analyses in countries. This paper was carried out involving stakeholders in the development of models, assumptions, scenarios, and results (Ubuntu/Community). The authors ensure that all data, source code and results can be easily found, accessed, downloaded, and viewed (retrievability), licensed for reuse (reusability), and that the modelling process can be repeated in an automatic way (repeatability). The authors provide complete metadata for reconstructing the modelling process (reconstructability), ensuring the transfer of data, assumptions and results to other projects, analyses, and models (interoperability), and facilitating peer-review through transparency (auditability).

Acknowledgments

The authors would like to extend special thanks to Simon Patterson of the #CCG team for his valuable editorial additions, which significantly improved the quality of this paper. Additionally, the authors would like to acknowledge the contribution of Sarel Greyling, also from the #CCG team, for his outstanding graphic design work, which enhanced the visual presentation of the findings.

Conflicts of Interest

The authors declare that they have no known competing financial interests or personal relationships that could have influenced the work reported in this paper.

Appendix A. Country Datasets

Table A1 lists the country-specific datasets that have been created using the data described in this article. For each country, a Zenodo dataset includes the data in a set of CSV tables and a Research Square pre-print article that describes the data collection process and provides stylised example scenarios created using OSeMOSYS.
Table A1. Starter Kit country datasets and pre-prints.
Table A1. Starter Kit country datasets and pre-prints.
RegionCountryZenodo Dataset
Access Date for All URLs: 1 April 2024
Research Square Pre-Print
Access Date for All URLs: 1 April 2024
Africa Algeria https://doi.org/10.5281/zenodo.4728143https://www.researchsquare.com/article/rs-478421/v2
Africa Angola https://doi.org/10.5281/zenodo.4650810https://www.researchsquare.com/article/rs-478581/v2
Africa Benin https://doi.org/10.5281/zenodo.4725486https://www.researchsquare.com/article/rs-478594/v2
Africa Botswana https://doi.org/10.5281/zenodo.4650986https://www.researchsquare.com/article/rs-478620/v2
Africa Burkina Faso https://doi.org/10.5281/zenodo.4650942https://www.researchsquare.com/article/rs-478764/v2
Africa Burundi https://doi.org/10.5281/zenodo.4725445https://www.researchsquare.com/article/rs-478806/v2
Africa Cameroon https://doi.org/10.5281/zenodo.4650822https://www.researchsquare.com/article/rs-478850/v2
Africa Central African Republic https://doi.org/10.5281/zenodo.4650968https://www.researchsquare.com/article/rs-478906/v2
Africa Chad https://doi.org/10.5281/zenodo.4725466https://www.researchsquare.com/article/rs-478927/v2
Africa Côte d’Ivoire https://doi.org/10.5281/zenodo.4737634https://www.researchsquare.com/article/rs-493226/v1
Africa Democratic Republic of the Congo https://doi.org/10.5281/zenodo.4737640https://www.researchsquare.com/article/rs-493235/v1
Africa Djibouti https://doi.org/10.5281/zenodo.4725462https://www.researchsquare.com/article/rs-479210/v2
Africa Egypt https://doi.org/10.5281/zenodo.4652804https://www.researchsquare.com/article/rs-479263/v2
Africa Equatorial Guinea https://doi.org/10.5281/zenodo.4650904https://www.researchsquare.com/article/rs-479310/v2
Africa Eritrea https://doi.org/10.5281/zenodo.4725456https://www.researchsquare.com/article/rs-479568/v2
Africa Eswatini https://doi.org/10.5281/zenodo.4737638https://www.researchsquare.com/article/rs-493243/v1
Africa Ethiopia https://doi.org/10.5281/zenodo.4650876https://www.researchsquare.com/article/rs-479603/v2
Africa Gabon https://doi.org/10.5281/zenodo.4737642https://www.researchsquare.com/article/rs-493249/v1
Africa The Gambia https://doi.org/10.5281/zenodo.4651140https://www.researchsquare.com/article/rs-479641/v2
Africa Ghana https://doi.org/10.5281/zenodo.4725480https://www.researchsquare.com/article/rs-479778/v2
Africa Guinea https://doi.org/10.5281/zenodo.4725454https://www.researchsquare.com/article/rs-480013/v3
Africa Guinea-Bissau https://doi.org/10.5281/zenodo.4650850https://www.researchsquare.com/article/rs-480393/v1
Africa Kenya https://doi.org/10.5281/zenodo.4650874https://www.researchsquare.com/article/rs-480458/v1
Africa Lesotho https://doi.org/10.5281/zenodo.4650866https://www.researchsquare.com/article/rs-480748/v1
Africa Liberia https://doi.org/10.5281/zenodo.4650794https://www.researchsquare.com/article/rs-480654/v1
Africa Libya https://doi.org/10.5281/zenodo.4650920https://www.researchsquare.com/article/rs-481132/v1
Africa Malawi https://doi.org/10.5281/zenodo.4652798https://www.researchsquare.com/article/rs-479507/v2
Africa Mali https://doi.org/10.5281/zenodo.4725447https://www.researchsquare.com/article/rs-479627/v2
Africa Mauritania https://doi.org/10.5281/zenodo.4650914https://www.researchsquare.com/article/rs-479591/v2
Africa Morocco https://doi.org/10.5281/zenodo.4725482https://www.researchsquare.com/article/rs-480023/v2
Africa Mozambique https://doi.org/10.5281/zenodo.4650902https://www.researchsquare.com/article/rs-481070/v1
Africa Namibia https://doi.org/10.5281/zenodo.4652808https://www.researchsquare.com/article/rs-481002/v1
Africa Niger https://doi.org/10.5281/zenodo.4725476https://www.researchsquare.com/article/rs-480051/v2
Africa Nigeria https://doi.org/10.5281/zenodo.4728145https://www.researchsquare.com/article/rs-480085/v2
Africa Republic of the Congo https://doi.org/10.5281/zenodo.4651133https://www.researchsquare.com/article/rs-479154/v2
Africa Rwanda https://doi.org/10.5281/zenodo.4652800https://www.researchsquare.com/article/rs-480847/v1
Africa Senegal https://doi.org/10.5281/zenodo.4725484https://www.researchsquare.com/article/rs-480122/v2
Africa Sierra Leone https://doi.org/10.5281/zenodo.4725544https://www.researchsquare.com/article/rs-480371/v2
Africa Somalia https://doi.org/10.5281/zenodo.4725474https://www.researchsquare.com/article/rs-480695/v1
Africa South Africa https://doi.org/10.5281/zenodo.4652802https://www.researchsquare.com/article/rs-480636/v1
Africa South Sudan https://doi.org/10.5281/zenodo.4725468https://www.researchsquare.com/article/rs-479969/v2
Africa Sudan https://doi.org/10.5281/zenodo.4725460https://www.researchsquare.com/article/rs-479952/v2
Africa Tanzania https://doi.org/10.5281/zenodo.4652806https://www.researchsquare.com/article/rs-481182/v1
Africa Togo https://doi.org/10.5281/zenodo.4725451https://www.researchsquare.com/article/rs-480160/v2
Africa Tunisia https://doi.org/10.5281/zenodo.4725458https://www.researchsquare.com/article/rs-480566/v1
Africa Uganda https://doi.org/10.5281/zenodo.4652795https://www.researchsquare.com/article/rs-480512/v1
Africa Zambia https://doi.org/10.5281/zenodo.4725470https://www.researchsquare.com/article/rs-480042/v2
Africa Zimbabwe https://doi.org/10.5281/zenodo.4650816https://www.researchsquare.com/article/rs-479655/v2
Asia Cambodia https://doi.org/10.5281/zenodo.5139538https://www.researchsquare.com/article/rs-757472/v1
Asia Indonesia https://doi.org/10.5281/zenodo.4926858https://www.researchsquare.com/article/rs-757493/v1
Asia Laos https://doi.org/10.5281/zenodo.4926880https://www.researchsquare.com/article/rs-757542/v1
Asia Malaysia https://doi.org/10.5281/zenodo.5139480https://www.researchsquare.com/article/rs-757581/v1
Asia Myanmar https://doi.org/10.5281/zenodo.5139484https://www.researchsquare.com/article/rs-757622/v1
Asia Philippines https://doi.org/10.5281/zenodo.5139542https://www.researchsquare.com/article/rs-757671/v1
Asia Republic of Korea (South Korea)https://doi.org/10.5281/zenodo.5139512https://www.researchsquare.com/article/rs-757722/v1
Asia Taiwan https://doi.org/10.5281/zenodo.5139520https://www.researchsquare.com/article/rs-757733/v1
Asia Thailand https://doi.org/10.5281/zenodo.5139498https://www.researchsquare.com/article/rs-757735/v1
Asia Vietnam https://doi.org/10.5281/zenodo.5139527https://www.researchsquare.com/article/rs-757746/v1
Asia Papua New Guinea https://doi.org/10.5281/zenodo.5139488https://www.researchsquare.com/article/rs-757653/v1
Latin America Argentina https://doi.org/10.5281/zenodo.5498081https://www.researchsquare.com/article/rs-893102/v1
Latin America Bolivia https://doi.org/10.5281/zenodo.5498083https://www.researchsquare.com/article/rs-893267/v1
Latin America Brazil https://doi.org/10.5281/zenodo.5498085https://www.researchsquare.com/article/rs-893535/v1
Latin America Chile https://doi.org/10.5281/zenodo.5498087https://www.researchsquare.com/article/rs-893607/v1
Latin America Colombia https://doi.org/10.5281/zenodo.5498091https://www.researchsquare.com/article/rs-893706/v1
Latin America Ecuador https://doi.org/10.5281/zenodo.5498093https://www.researchsquare.com/article/rs-893779/v1
Latin America Paraguay https://doi.org/10.5281/zenodo.5498099https://www.researchsquare.com/article/rs-895567/v1
Latin America Peru https://doi.org/10.5281/zenodo.5498101https://www.researchsquare.com/article/rs-895579/v1
Latin America Uruguay https://doi.org/10.5281/zenodo.5498103https://www.researchsquare.com/article/rs-895585/v1
Latin America Venezuela https://doi.org/10.5281/zenodo.5498105https://www.researchsquare.com/article/rs-895593/v1

Appendix B. User Satisfaction of Using clicSAND 1.0. Software

The results presented below were obtained in post-training surveys completed by the participants of the capacity-building events called EMP-A 2021 [33] and ICTP 2022 [52] of the track in Energy and Flexibility Modelling who used the SAND Excel Interface to input modelling data and clicSAND software to run their models. Fifty responses were considered over the two capacity-building trainings. The questions asked and average results are shown below:
“How would you rate the following characteristics of the interface/software for your modelling exercise? (0 = Not appropriate; 100 = Completely Appropriate)”
Table A2. Survey results—clicSAND 1.0.
Table A2. Survey results—clicSAND 1.0.
StatementRating (Out of 100)Number of Responses
The SAND Excel Interface was easy to use and user-friendly7450/70
The clicSAND solver was easy to use and user-friendly7550/70
The clicSAND solver produced results in a timely manner6050/70
Running the data file extracted from the SAND Interface on the OSeMOSYS Cloud was fast and easy to use7050/70
The results presented below were obtained through post-training surveys conducted during several capacity-building events, including EMP-LAC (Latin America and the Caribbean) in January 2023, EMP-A in April 2023, and ICTP in July 2023. Participants in these events utilised the SAND Excel Interface for data input and the clicSAND 3.0 software for model execution as part of the Energy and Flexibility Modelling track. The surveys aimed to assess the usability and satisfaction with these tools, posing the question, ‘How would you rate the following characteristics of the interface/software for your modelling exercise? (0 = Not appropriate; 100 = Completely Appropriate).’ In the following tables, you will find the statements, the average ratings given by the respondents (on a scale of 0 to 100), and the number of participants who provided responses. These ratings cover various aspects, including the ease of use and user-friendliness of the SAND Excel interface, clicSAND 3.0 software, the offline solver’s performance, the OSeMOSYS cloud platform’s effectiveness, and the speed and simplicity of running data extracted from clicSAND 3.0 on the cloud platform. The results reveal the evolving perceptions and experiences of users with these tools over time.
Table A3. Survey results—clicSAND 3.0, EMP-LAC January 23.
Table A3. Survey results—clicSAND 3.0, EMP-LAC January 23.
StatementRating (Out of 100)Number of Responses
The SAND Excel interface was easy to use and user-friendly72.3318/22
The clicSAND 3.0. software was easy to use and user-friendly85.5618/22
The offline clicSAND 3.0 solver produced results in a timely manner77.2218/22
The OSeMOSYS cloud platform produced results in a timely manner87.0618/22
Running the datafile extracted from the clicSAND 3.0. on the cloud platform was fast and easy to use84.8318/22
Table A4. Survey results—clicSAND 3.0, EMP-A April 23.
Table A4. Survey results—clicSAND 3.0, EMP-A April 23.
StatementRating (Out of 100)Number of Responses
The SAND Excel interface was easy to use and user-friendly81.6316/26
The clicSAND 3.0. software was easy to use and user-friendly89.8116/26
The offline clicSAND 3.0 solver produced results in a timely manner78.4416/26
The OSeMOSYS cloud platform produced results in a timely manner90.9416/26
Running the datafile extracted from the clicSAND 3.0. on the cloud platform was fast and easy to use88.516/26
Table A5. Survey results—clicSAND 3.0, ICTP July 23.
Table A5. Survey results—clicSAND 3.0, ICTP July 23.
StatementRating (Out of 100)Number of Responses
The SAND Excel interface was easy to use and user-friendly to input data93.2114/22
The clicSAND 3.0. software was easy to use and user-friendly90.8614/22
The results template was easy to use and user-friendly90.7114/22
The OSeMOSYS cloud platform produced results in a timely manner85.1414/22
The offline clicSAND 3.0 solver produced results in a timely manner84.2114/22

Appendix C. Teaching Material on clicSAND Software

Table A6. Additional Teaching Material for clicSAND 3.0. and OSeMOSYS.
Table A6. Additional Teaching Material for clicSAND 3.0. and OSeMOSYS.
IDExerciseYouTube VideoZenodo RepositoryExpected Learning Outcomes Difficulty (Low-Medium-High)
1Installing and using clicSAND 3.0 on WindowsYT—VideoZD—RepositoryYou will learn how to download and install the most recent version of clicSAND, called clicSAND 3.0 on Windows. You can also learn how to run a model using the OSeMOSYS Cloud.Low
2Installing and using clicSAND 3.0 on MacOSYT—VideoZD—RepositoryYou will learn how to download and install the most recent version of clicSAND, called clicSAND 3.0, on Mac. You can also learn how to run a model using the OSeMOSYS Cloud.Low
3Downloading a Starter Data KitYT—VideoZD—RepositoryYou will learn how to download and use a CCG Starter Data Kit (SDK).Low
4Reducing Time slicesYT—VideoZD—RepositoryYou will learn how to reduce the number of time slices from 96 to 8 using clicSAND interface for OSeMOSYS.Low
5Reducing Modelling PeriodYT—Video-You will learn how to reduce the modelling period using clicSAND interface for OSeMOSYS. For example, how to model until 2050 instead until 2070.Low
6Emission ConstraintsYT—VideoZD—RepositoryYou will learn how to implement emission constraints using the parameters Emission Penalty, Annual Emissions, and Model Period Emissions. Low
7Translating Policy into Modelling AssumptionsYT—VideoZD—RepositoryYou will learn how to translate a renewable production target policy into constraints for modelling and how to limit electricity imports. You will learn how to experiment with TotalTechnologyAnnualActivityUpperLimit, TotalTechnologyAnnualActivityLowerLimit and SpecifiedAnnualDemand. Medium
8Aggregate Renewable TargetYT—VideoZD—RepositoryYou will learn how to set an aggregated target for the Renewables in your model using the clicSAND interface for OSeMOSYS. Medium
9Modelling Energy Efficiency PolicyYT—VideoZD—RepositoryYou will learn how to model Energy Efficiency Policies in OSeMOSYS using the clicSAND Interface (version 3.0). Medium
10Explore the impacts of drought on hydropower generationYT—VideoZD—RepositoryYou will learn how to (1) distinguish how the availability factor and capacity factor vary outcomes when modelling a drought scenario, and (2) undertake a sensitivity analysis to replicate a long-term drought scenario.Medium
11Time slice Reducer Macro for OSeMOSYS Starter Data KitsYT—VideoZD—RepositoryYou will learn how to reduce the number of time slices from 96 to 8 using a macro in Excel.Low
12Electrification of TransportationYT—VideoZD—RepositoryYou will learn how to model a transport electrification policy using the OSeMOSYS model.High
13Residential Clean CookingYT—VideoZD—RepositoryYou will learn the importance of residential clean cooking and how to translate an example policy into modelling parameters for the OSeMOSYS model.Medium
14OSeMOSYS and FlexTool Hands-on Exercise: Data SharingYT—VideoZD—RepositoryYou will learn how to gather data from the clicSAND Interface and the OSeMOSYS model results, and then how to manipulate them to create input data for IRENA FlexTool.High
15Hydrogen PathwaysYT—VideoZD—RepositoryYou will learn how to model hydrogen pathways using the OSeMOSYS model.High
16Visualisation TemplateYT—VideoZD—RepositoryYou will learn how to use the result visualisation template to compare scenarios after obtaining the results from the clicSAND 3.0 interface.Medium
17Storage Modelling Using Dummy Technologies-ZD—RepositoryYou will learn how to model a storage technology using the OSeMOSYS model.High

References

  1. Howells, M.; Rogner, H.; Strachan, N.; Heaps, C.; Huntington, H.; Kypreos, S.; Hughes, A.; Silveira, S.; DeCarolis, J.; Bazillian, M.; et al. OSeMOSYS: The Open Source Energy Modeling System: An introduction to its ethos, structure and development. Energy Policy 2011, 39, 5850–5870. [Google Scholar] [CrossRef]
  2. Cannone, C.; Hoseinpoori, P.; Martindale, L.; Tennyson, E.M.; Gardumi, F.; Croxatto, L.S.; Pye, S.; Mulugetta, Y.; Vrochidis, I.; Krishnamurthy, S.; et al. Addressing Challenges in Long-Term Strategic Energy Planning in LMICs: Learning Pathways in an Energy Planning Ecosystem. Energies 2023, 16, 7267. [Google Scholar] [CrossRef]
  3. Akpahou, R.; Mensah, L.D.; Quansah, D.A.; Kemausuor, F. Energy planning and modeling tools for sustainable development: A systematic literature review. Energy Rep. 2024, 11, 830–845. [Google Scholar] [CrossRef]
  4. Plazas-Niño, F.; Ortiz-Pimiento, N.; Montes-Páez, E. National energy system optimization modelling for decarbonization pathways analysis: A systematic literature review. Renew. Sustain. Energy Rev. 2022, 162, 112406. [Google Scholar] [CrossRef]
  5. Niet, T.; Shivakumar, A.; Gardumi, F.; Usher, W.; Williams, E.; Howells, M. Developing a community of practice around an open source energy modelling tool. Energy Strat. Rev. 2021, 35, 100650. [Google Scholar] [CrossRef]
  6. Taliotis, C.; Shivakumar, A.; Ramos, E.; Howells, M.; Mentis, D.; Sridharan, V.; Broad, O.; Mofor, L. An indicative analysis of investment opportunities in the African electricity supply sector—Using TEMBA (The Electricity Model Base for Africa). Energy Sustain. Dev. 2016, 31, 50–66. [Google Scholar] [CrossRef]
  7. Löffler, K.; Hainsch, K.; Burandt, T.; Oei, P.-Y.; Kemfert, C.; Von Hirschhausen, C. Designing a Model for the Global Energy System—GENeSYS-MOD: An Application of the Open-Source Energy Modeling System (OSeMOSYS). Energies 2017, 10, 1468. [Google Scholar] [CrossRef]
  8. Godínez-Zamora, G.; Victor-Gallardo, L.; Angulo-Paniagua, J.; Ramos, E.; Howells, M.; Usher, W.; De León, F.; Meza, A.; Quirós-Tortós, J. Decarbonising the transport and energy sectors: Technical feasibility and socioeconomic impacts in Costa Rica. Energy Strat. Rev. 2020, 32, 100573. [Google Scholar] [CrossRef]
  9. Jaramillo, M.; Quirós-Tortós, J.; Vogt-Schilb, A.; Money, A.; Howells, M. Data-to-Deal (D2D): Open Data and Modelling of Long Term Strategies to Financial Resource Mobilization—The case of Costa Rica. Camb. Open Engag. 2023. [Google Scholar] [CrossRef]
  10. Almulla, J.; Broad, O.; Shivakumar, F.; Gardumi, A.; Ramos, E.; Avgerinopoulos, M.; Howells, G. Model Management Infrastructure (MoManI) Training Manual. Available online: http://www.osemosys.org/uploads/1/8/5/0/18504136/momani_training_manual-_rev170612.pdf (accessed on 23 October 2020).
  11. Cannone, C. Towards Evidence-Based Policymaking: Energy Modelling Tools for Sustainable Development; UPC Barcelona: Barcelona, Spain, 2020. [Google Scholar]
  12. Cannone, C.; de Wet, N.; Shivakumar, A.; Kell, A.; Tan, N.; Yeganyan, R.; To, L.S.; Harrison, J.; Howells, M. clicSANDMac for OSeMOSYS: A user-friendly interface for macOS users using open-source optimisation software for energy system planning. Res. Sq. 2022. [Google Scholar] [CrossRef]
  13. Cannone, C. Release clicSAND v1.2 · ClimateCompatibleGrowth/clicSAND. GitHub. Available online: https://github.com/ClimateCompatibleGrowth/clicSAND (accessed on 1 April 2024).
  14. Cannone, C.; Allington, L.; Howells, M. Hands-on 1: Energy and Flexibility Modelling. Version 3.2. Zenodo 2022. [Google Scholar] [CrossRef]
  15. OLCreate: Climate Compatible Growth November 2023 Courses. Available online: https://www.open.edu/openlearncreate/course/index.php?categoryid=1193 (accessed on 26 October 2023).
  16. Allington, L.; Cannone, C.; Pappis, I.; Barron, K.C.; Usher, W.; Pye, S.; Brown, E.; Howells, M.; Walker, M.Z.; Ahsan, A.; et al. Selected ‘Starter kit’ energy system modelling data for selected countries in Africa, East Asia, and South America (#CCG, 2021). Data Brief 2022, 42, 108021. [Google Scholar] [CrossRef] [PubMed]
  17. Cannone, C.; Allington, L.; Barron, K.C.; Charbonnier, F.; Walker, M.Z.; Halloran, C.; Yeganyan, R.; Tan, N.; Cullen, J.M.; Harrison, J.; et al. Designing a zero-order energy transition model: How to create a new Starter Data Kit. MethodsX 2023, 10, 102120. [Google Scholar] [CrossRef] [PubMed]
  18. OSeMOSYS & FlexTool course: Hands-On 3—YouTube. Available online: https://www.youtube.com/watch?v=DbUH00ruHnM (accessed on 1 April 2024).
  19. GLPK—GNU Project—Free Software Foundation (FSF). Available online: https://www.gnu.org/software/glpk/ (accessed on 25 January 2022).
  20. Coin-or/Cbc: COIN-OR Branch-and-Cut Solver. GitHub. Available online: https://github.com/coin-or/Cbc (accessed on 25 January 2022).
  21. CLEWS—Home. Available online: http://www.osimosys.org/ (accessed on 25 January 2022).
  22. Sachs, J.; Meng, Y.; Giarola, S.; Hawkes, A. An agent-based model for energy investment decisions in the residential sector. Energy 2019, 172, 752–768. [Google Scholar] [CrossRef]
  23. OsemosysCloud. Available online: https://www.osemosys-cloud.com/ (accessed on 20 January 2022).
  24. clicSAND v3.0. GitHub. Available online: https://github.com/ClimateCompatibleGrowth/clicSAND/tree/v3.0 (accessed on 1 April 2024).
  25. Cannone, C. ClimateCompatibleGrowth/clicSAND 3.0 for Windows. Zenodo. 2022. Available online: https://zenodo.org/records/6525441#.YnkPoRNBzPA (accessed on 1 April 2024).
  26. Additional Tutorial OSeMOSYS & FlexTool: Installing and using ClicSAND 3.0 on Windows—YouTube. Available online: https://www.youtube.com/watch?v=YDYGk0RbyW0&list=PLhLN8V8JSUnIw5osZPtOW-U4s87Qey115 (accessed on 1 April 2024).
  27. OLCreate: June 2022 PUB_5383_1.0 Energy and Flexibility Modelling: OSeMOSYS & FlexTool (Windows). Available online: https://www.open.edu/openlearncreate/course/view.php?id=8394 (accessed on 3 July 2022).
  28. Cannone, C.; Yeganyan, R.; Cronin, J. Hands-on: Reducing Number of Timeslices in SAND Interface. Zenodo 2021. [Google Scholar] [CrossRef]
  29. Yeganyan, R.; Cannone, C. Additional Hands-on: Reducing Modelling Period. Zenodo 2022. [Google Scholar] [CrossRef]
  30. Reduce Timeslices—YouTube. Available online: https://www.youtube.com/watch?v=3mZXEn8cn48&list=PLhLN8V8JSUnLPqC_CdRkr4jp9Dvy3WwmT&index=3 (accessed on 20 January 2022).
  31. Reduce Modelling Period—YouTube. Available online: https://www.youtube.com/watch?v=2Ya34nj1JIg&list=PLhLN8V8JSUnLPqC_CdRkr4jp9Dvy3WwmT&index=2 (accessed on 20 January 2022).
  32. Visualisation Template—YouTube. Available online: https://www.youtube.com/watch?v=aGkXkTqL-wY&list=PLhLN8V8JSUnIw5osZPtOW-U4s87Qey115&index=28 (accessed on 26 October 2023).
  33. EMP-A 2021—EMP. Available online: http://www.energymodellingplatform.org/emp-a-2021.html (accessed on 12 January 2022).
  34. Veusz—A Scientific Plotting Package. Github. Available online: https://veusz.github.io/ (accessed on 18 August 2022).
  35. Calitz, J.R.; Wright, J.G. Statistics of Utility-Scale Power Generation in South Africa in 2020. In Presentation by the CSIR Energy Centre on the Statistics of Utility-Scale Power Generation in South Africa in 2020. 2021. Available online: https://researchspace.csir.co.za/dspace/handle/10204/11865 (accessed on 1 April 2024).
  36. Allington, L.; Cannone, C.; Pappis, I.; Barron, K.C.; Usher, W.; Pye, S.; Brown, E.; Howells, M.; Taliotis, C.; Sundin, C.; et al. Selected ‘Starter Kit’ energy system modelling data for South Africa (#CCG). Res. Sq. 2021. [Google Scholar] [CrossRef]
  37. Allington, L.; Cannone, C.; Pappis, I.; Barron, K.C.; Usher, W.; Pye, S.; Howells, M.; Taliotis, C.; Sundin, C.; Sridharan, V.; et al. CCG Starter Data Kit: South Africa. Zenodo 2021. [Google Scholar] [CrossRef]
  38. Department of Mineral Resources and Energy. Integrated Resource Plan 2019. 2019. Available online: https://www.gov.za/sites/default/files/gcis_document/201910/42778gon1359.pdf (accessed on 1 April 2024).
  39. Cannone, C.; Tan, N.; Kell, A.; Nicki, W.; Howells, M.; Yeganyan, R. ClimateCompatibleGrowth/clicSAND for Mac. Zenodo 2022. [CrossRef]
  40. Release v1.04 ClimateCompatibleGrowth/clicSANDMac. GitHub. Available online: https://github.com/ClimateCompatibleGrowth/clicSANDMac/releases/tag/v1.04 (accessed on 23 August 2022).
  41. OLCreate: PUB_5398_1.0 (MacOS Users) Energy and Flexibility Modelling: OSeMOSYS & FlexTool. Available online: https://www.open.edu/openlearncreate/course/view.php?id=8409 (accessed on 3 February 2022).
  42. DESA|United Nations. Available online: https://www.un.org/en/desa (accessed on 2 February 2022).
  43. GitHub—ClimateCompatibleGrowth/OSEMOSYS_UI. GitHub. Available online: https://github.com/ClimateCompatibleGrowth/OSEMOSYS_UI (accessed on 26 October 2023).
  44. Burkill, E. Green Growth within Kenya’s Electricity Sector: An OSeMOSYS Based Approach to Formulate Future Policy Strategy; Imperial College London: London, UK, 2020. [Google Scholar]
  45. Allington, L. Long-Term Modelling of Nigeria’s Power System Using OSeMOSYS (Open-Source Energy Modelling System); Imperial College London: London, UK, 2020. [Google Scholar]
  46. Tan, N. Evidence-Based Policy-Making: Implementing a Clean Energy Transition in Vietnam’s Power Sector; Imperial College London: London, UK, 2021. [Google Scholar]
  47. Terpilowski-Gill, E. Decarbonising the Laotian Energy System; Imperial College London: London, UK, 2020. [Google Scholar]
  48. Montepeque, J. Decarbonising Laos’ Transport Sector; Imperial College London: London, UK, 2021. [Google Scholar]
  49. Yeganyan, R. Modelling Pathways to Energy Security for Armenia Using OSeMOSYS; Imperial College London: London, UK, 2021. [Google Scholar]
  50. CCG COP26 Side Events Session 2—Evidence for COP26: Bridging the Evidence-Policy Gap—YouTube. Available online: https://www.youtube.com/watch?v=w4GyXWTekxI (accessed on 18 January 2022).
  51. Joint Summer School on Modelling Tools for Sustainable Development|(smr 3581) (14 June 2021–1 July 2021). Available online: http://indico.ictp.it/event/9549/ (accessed on 24 August 2021).
  52. Joint Summer School on Modelling Tools for Sustainable Development 2022|(smr 3763) (30 May 2022–16 June 2022). Available online: https://indico.ictp.it/event/9879/ (accessed on 23 August 2021).
  53. Joint Summer School on Modelling Tools for Sustainable Development|(smr 3852) (3–13 July 2023). Available online: https://indico.ictp.it/event/10186 (accessed on 26 October 2023).
  54. Energy Modelling Platform for Africa (EMP-A)—Climate Compatible Growth. Available online: https://climatecompatiblegrowth.com/emp-a/ (accessed on 26 October 2023).
  55. EMP-LAC 2023 [Now Finished]—Climate Compatible Growth. Available online: https://climatecompatiblegrowth.com/emp-lac-2023/ (accessed on 26 October 2023).
  56. EMP-LAC 2024—Climate Compatible Growth. Available online: https://climatecompatiblegrowth.com/emp-lac/ (accessed on 26 October 2023).
  57. Cronin, J.; Bawakyillenuo, S.; Crentsil, A.O.; Pye, S.; Watson, J. Greening the COVID-19 Recovery in Ghana: Electricity Investment Needs to Meet the GH-NDC Targets. Institute of Sustainable Resources Key messages for COP26 Assessing the role of NDCs. 2021. Available online: https://www.ucl.ac.uk/bartlett/sustainable/sites/bartlett_sustainable/files/policybriefing_electricity_investment_needs_to_meet_the_gh-ndc_targets.pdf (accessed on 1 April 2024).
  58. Energy Sub-Saharan Africa—Programmes—IEA. Available online: https://www.iea.org/programmes/energy-sub-saharan-africa (accessed on 26 October 2023).
  59. Climate Change Politics and Policy Degree. Postgraduate Study. Loughborough University. Available online: https://www.lboro.ac.uk/study/postgraduate/masters-degrees/a-z/climate-change-politics-and-policy/ (accessed on 13 May 2023).
  60. Climate Change Science and Management Degree. Postgraduate Study. Loughborough University. Available online: https://www.lboro.ac.uk/study/postgraduate/masters-degrees/a-z/climate-change-science-and-management/ (accessed on 10 November 2023).
  61. COP26 Energy Transition Council: 2022 Strategic Priorities—GOV.UK. Available online: https://www.gov.uk/government/publications/cop26-energy-transition-council-2022-strategic-priorities (accessed on 23 August 2022).
Figure 1. Overview of the clicSAND 1.0 user platform and main functionalities. “Data Source (xls)” button […] used to select the model data file; “Model” button […] to select the OSeMOSYS code; “Run” button to initialise solving; “Export Templates…” button to download the necessary templates. The “Open Log” button is not often used; however, it opens a new file in the text editor—we will disregard it in this paper. By using the arrows of the “Ratio (CBC)” button, the user can, if needed, change the accuracy of the model solution.
Figure 1. Overview of the clicSAND 1.0 user platform and main functionalities. “Data Source (xls)” button […] used to select the model data file; “Model” button […] to select the OSeMOSYS code; “Run” button to initialise solving; “Export Templates…” button to download the necessary templates. The “Open Log” button is not often used; however, it opens a new file in the text editor—we will disregard it in this paper. By using the arrows of the “Ratio (CBC)” button, the user can, if needed, change the accuracy of the model solution.
Energies 17 03923 g001
Figure 2. This figure presents an overview of clicSAND 3.0 software along with its primary functionalities. A notable addition, highlighted in dark red, is the “Generate OSeMOSYS Cloud Input” button, which facilitates the conversion of .txt files into a format compatible with the OSeMOSYS Cloud platform, enabling the option to run models online.
Figure 2. This figure presents an overview of clicSAND 3.0 software along with its primary functionalities. A notable addition, highlighted in dark red, is the “Generate OSeMOSYS Cloud Input” button, which facilitates the conversion of .txt files into a format compatible with the OSeMOSYS Cloud platform, enabling the option to run models online.
Energies 17 03923 g002
Figure 3. Operational flowchart of the clicSAND Software 1.0—fully offline.
Figure 3. Operational flowchart of the clicSAND Software 1.0—fully offline.
Energies 17 03923 g003
Figure 4. Operational flowchart of the clicSAND Software 3.0—fully offline.
Figure 4. Operational flowchart of the clicSAND Software 3.0—fully offline.
Energies 17 03923 g004
Figure 5. Operational flowchart of the clicSAND Software 3.0—partially online.
Figure 5. Operational flowchart of the clicSAND Software 3.0—partially online.
Energies 17 03923 g005
Figure 6. Main functionalities of the SAND Interface Excel Sheets and a screenshot of the “Parameters” Sheet at the bottom. The green box displays a list of graphs that can be visualised in the “Results Visualisation Template”, including Annual electricity generation (PJ), Electricity production by time slice (PJ), Total annual capacity (GW), Cooking and heat generation (PJ), Transport Mix (Gpkm/Gtkm), Annual CO2 emissions (kt), Annual CO2 emissions by technology (kt), Demand (PJ), Annual fixed operating costs (MUSD), Annual variable operating costs (MUSD), and Annual capital investment (MUSD).
Figure 6. Main functionalities of the SAND Interface Excel Sheets and a screenshot of the “Parameters” Sheet at the bottom. The green box displays a list of graphs that can be visualised in the “Results Visualisation Template”, including Annual electricity generation (PJ), Electricity production by time slice (PJ), Total annual capacity (GW), Cooking and heat generation (PJ), Transport Mix (Gpkm/Gtkm), Annual CO2 emissions (kt), Annual CO2 emissions by technology (kt), Demand (PJ), Annual fixed operating costs (MUSD), Annual variable operating costs (MUSD), and Annual capital investment (MUSD).
Energies 17 03923 g006
Figure 7. Example of the new template applied to a study case with three different scenarios. In the dark blue box is a list of the graphs that can be visualised with the new template.
Figure 7. Example of the new template applied to a study case with three different scenarios. In the dark blue box is a list of the graphs that can be visualised with the new template.
Energies 17 03923 g007
Figure 8. Overview of the Results Converter interface. Light Blue button: “Input file” selection; Red button: “Output directory” selection; Purple button: Type a “output filename” in the blank space; Green button: “Save output filename”; Yellow button: “Run” initialises the file conversion and saves the new results file in the output directory selected.
Figure 8. Overview of the Results Converter interface. Light Blue button: “Input file” selection; Red button: “Output directory” selection; Purple button: Type a “output filename” in the blank space; Green button: “Save output filename”; Yellow button: “Run” initialises the file conversion and saves the new results file in the output directory selected.
Energies 17 03923 g008
Figure 9. Results of the South African case study developed during EMP-A: (a) Comparison of the electricity production; (b) Comparison of the CO2 emissions of scenarios; (c) Comparison of total costs (capital, fixed operation and maintenance (O&M), and fuel costs).
Figure 9. Results of the South African case study developed during EMP-A: (a) Comparison of the electricity production; (b) Comparison of the CO2 emissions of scenarios; (c) Comparison of total costs (capital, fixed operation and maintenance (O&M), and fuel costs).
Energies 17 03923 g009
Table 1. Advantages and limitations of the clicSAND 1.0. Software.
Table 1. Advantages and limitations of the clicSAND 1.0. Software.
clicSAND 1.0. Software
AdvantagesLimitations
  • Users do not need to interact with the command line at any stage.
  • Features a user-friendly SAND Interface, based on Excel, making it accessible to most IT users. A single spreadsheet with filtering capabilities is used for inputting all necessary data.
  • Installation is straightforward and swift.
  • Provides full compatibility with the Starter Data Kits models.
  • Has a free, self-learn tutorial in the form of an Open University course with certification.
  • All OSeMOSYS parameters are represented.
  • It is freely available as a public resource for everyone.
  • It is compatible with both Windows and macOS operating systems.
  • It operates entirely offline.
  • Troubleshooting proved time-consuming as the software did not point out errors.
  • A maximum of 96 time slices could be employed for seasonal representations of intermittent renewable technologies.
  • The software supported a maximum of 200 technologies, 50 commodities, and 5 types of emissions.
  • It has not been tested for multiregional studies.
  • Vertical copy-pasting could not be done when filters were applied to the Excel file.
Table 2. Advantages and limitations of the improved version of the software, clicSAND 3.0.
Table 2. Advantages and limitations of the improved version of the software, clicSAND 3.0.
clicSAND 3.0 Software
AdvantagesLimitations
  • Users do not need to interact with the command line at any stage.
  • Features a user-friendly SAND Interface, based on Excel, making it accessible to most IT users. A single spreadsheet with filtering capabilities is used for inputting all necessary data.
  • Installation is straightforward and swift.
  • Provides full compatibility with the Starter Data Kits models.
  • Has a free, self-learn tutorial in the form of an Open University course with certification. Additional step-by-step video lectures are available.
  • All OSeMOSYS parameters are represented.
  • It is freely available as a public resource for everyone.
  • It is compatible with both Windows and macOS operating systems.
  • Embedded Python code reduces data file size and consequently speeds up computational time.
  • The software provides the option to operate completely offline.
  • It also allows users to run the model using an online cloud-based service, eliminating the need to rely on the machine’s internal memory (RAM).
  • There is no need for an Access database for results visualisation.
  • A new offline Excel visualisation template is included, generating high-quality graphs.
  • It seamlessly integrates with the OSeMOSYS Cloud and provides the option to visualise results offline.
  • A maximum of 96 time slices could be employed for seasonal representations of intermittent renewable technologies.
  • The software supports a maximum of 200 technologies, 50 commodities, and 5 types of emissions.
  • It has not been tested for multiregional studies.
  • Vertical copy-pasting cannot be done when filters are applied to the Excel file.
Table 3. Summary of scenarios modelled including description and critical assumptions.
Table 3. Summary of scenarios modelled including description and critical assumptions.
Scenario LabelScenario DescriptionKey Assumptions
Existing PolicyThe power sector evolves with existing policy [38]
  • Coal capacity decommissions in line with existing expectations (Coal < 60%, 25% renewables by 2030)
  • Peak Plateau Decline (PPD) trajectory
Least Cost Least-cost evolution with no substantial upfront constraints
  • Least-cost optimal unconstrained path
  • PPD trajectory
Game ChangeNo coal generation by 2040; renewable energy revolution
  • All coal capacity decommissioned by 2040—linear decline (over ten years)
  • PPD trajectory
  • Least-cost path with the above constraint
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content.

Share and Cite

MDPI and ACS Style

Cannone, C.; Allington, L.; de Wet, N.; Shivakumar, A.; Goyns, P.; Valderrama, C.; Kell, A.; Plazas Niño, F.A.; Mohanty, R.; Kapor, V.; et al. clicSAND for OSeMOSYS: A User-Friendly Interface Using Open-Source Optimisation Software for Energy System Modelling Analysis. Energies 2024, 17, 3923. https://doi.org/10.3390/en17163923

AMA Style

Cannone C, Allington L, de Wet N, Shivakumar A, Goyns P, Valderrama C, Kell A, Plazas Niño FA, Mohanty R, Kapor V, et al. clicSAND for OSeMOSYS: A User-Friendly Interface Using Open-Source Optimisation Software for Energy System Modelling Analysis. Energies. 2024; 17(16):3923. https://doi.org/10.3390/en17163923

Chicago/Turabian Style

Cannone, Carla, Lucy Allington, Nicki de Wet, Abhishek Shivakumar, Philip Goyns, Cesar Valderrama, Alexander Kell, Fernando Antonio Plazas Niño, Reema Mohanty, Vedran Kapor, and et al. 2024. "clicSAND for OSeMOSYS: A User-Friendly Interface Using Open-Source Optimisation Software for Energy System Modelling Analysis" Energies 17, no. 16: 3923. https://doi.org/10.3390/en17163923

Note that from the first issue of 2016, this journal uses article numbers instead of page numbers. See further details here.

Article Metrics

Back to TopTop