Help with Running TSPF_import_export.py for Converting LoadProfiles to .rawx
Hi everyone,
I am trying to use the script TSPFimportexport.py to convert an Excel file (LoadProfiles.xlsx) containing active power load demands for multiple buses into a .rawx file (TestProfile.rawx).
The Excel file has the following structure:
Columns: Each hour of the day (1–24). Rows: Multiple buses (e.g., Bus 1, Bus 2, etc.) with their respective load values for each hour on different dates. Here is the command I am using:
py -3 TSPFimportexport.py "LoadProfiles.xlsx" "TestProfile.rawx"
However, I have several doubts:
I am not sure how the Excel file should be structured to work with this script. Could anyone confirm the required format? Does this module (TSPFimportexport.py) exist in PSS®E v35.4? If not, could you recommend any alternatives for achieving this? If this module is available, how does it map Excel data to the .rawx file, and does it handle hourly load profiles for multiple buses properly? If the module isn’t included in v35.4 or there’s a better way to create .rawx files from load profiles, I’d really appreciate some guidance or examples.
Thanks in advance for your help!