Excel and Python based calculators to find the ability of a flex load to contribute to different grid services. Currently includes a Python version of the FLS for Energy Service, an XML template for flex loads for the Regulation calculator, and the VBA code for importing XML flex load files to Excel for the Regulation calculator (7/5/26).
Thomas: Thomas' Repository
Othman: Othman's Repository
Currently contains (7/5/26):
- Python version of FLS from the Energy Service calculator
- VBA code for importing XML flex load files to the Excel Regulation calculator
- XML template for flex loads (for the Excel Regulation calculator) with imaginary values
- Language: Python, VBA, XML
- Energy Service Calculator (Python) - A Python version of the Energy Service calculator's FLS. Currently (7/5/26) the XML import functionality doesn't exist.
- Regulation Calculator (Excel) - VBA code allowing for XML files of different flex loads to be imported to the Excel Regulation calculator.
- XML Flex Load Structure (Regulation) - A test XML file demonstrating the expected structure of the flex load XML files that can be imported to the Excel Regulation calculator, with imaginary values.
Follow these steps to set up the project locally.
List any software, tools, or global packages needed:
- Python (I used 3.11.9)
- Python's dataclasses
- Excel, with Developer tools enabled (How to show the Developer tab)
- Clone the repository:
git clone
- Energy Service - Run energyserviceFLS.py
- Regulation Calculator - Used as reference/storage, all functionality should be inherent in Excel file.
- XML Flex Load Structure - Duplicate XML file structure, replacing current imaginary values with actual values for flex load under study. Eventually there will be a library of different flex loads in XML.