<jupyter_start><jupyter_text>Using Excel for parameter input and model runsBesides using a python script or a jupyter notebook it is also possible to read and run a model using excel files.The energySystemModelRunFromExcel() function reads a model from excel, optimizes it and stores it to an excel file.The readEnergySystemModelFromExcel() function reads a model from excel.The model run can also be started on double-klicking on the run.bat Windows batch script in the folder where this notebook is located (still requires that a Python version, the FINE package and an optmization solver are installed).Moreover, it is possible to run the model inside the Excel file with a VBA Macro (see scenarioInputWithMacro.xlsx)  Import FINE package<jupyter_code>import FINE as fn<jupyter_output><empty_output><jupyter_text>Call energySystemModelRunFromExcel function  Read model from excel file, optimize and store to excel fileCheckout the output excel file in the folder where this notebook is located<jupyter_code>esM = fn.energySystemModelRunFromExcel()<jupyter_output>Academic license - for non-commercial use only
Changed value of parameter QCPDual to 1
   Prev: 0  Min: 0  Max: 1  Default: 0
Freed default Gurobi environment<jupyter_text>Read only<jupyter_code>esM, esMData = fn.readEnergySystemModelFromExcel()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.04325130499627144, 'fraction_numerical': 0.0037285607755406414, 'mean_word_length': 6.176470588235294, 'pattern_counts': {'":': 0, '<': 12, '<?xml version=': 0, '>': 12, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '477705', 'license': 'MIT', 'n_tokens_mistral': 394, 'n_tokens_neox': 363, 'n_words': 165, 'path': 'examples/Model Run from Excel/Model Run from Excel.ipynb', 'repo_name': 'l-welder/FINE', 'size': '1341'}