BatchRunExcel

A script used to solve a batch series of energy hubs in a combined PyEHub model.

This functionality is now also provided by the multiple hubs module.

BatchRunExcel.get_output_fields(list, str)

Gets the required outputs from the excel files passed in the list of filenames.

Parameters:

• filenames (list) – A list of the excel files to find outputs for.

• directory (str) – The optional dicretory that these filenames are located at. for use only if the filenames do not include their directory.

Returns:

A list with every output requested from every file (duplicates are deleted.)

BatchRunExcel.output_to_excel(dict, openpyxl.sheet, dict)

Takes the output dictionary produced by multiple hubs, and writes specific fields to the passed excel sheet based on the output dictionary passed.

Parameters:

• outputs (dict) – The dictionary produced by multiple_hubs.

• sheet (openpyxl.sheet) – The excel sheet to be written to.

• output_dict (dict) – A dictionary that links keys found in the outputs dict, and the column that they should appear in, within the sheet.