How to Export Load profile in Excel format?

General
, ,
1

Hi, is it possible to export profile in excel format from a network scenario model? I can only export in .prf format.

Thanks,
Aftab

2

Hi Mohammad,
Thanks for your question.

Yes, in SAInt 3.7.14.5, it is possible to export profiles in formats other than the SAint native *.prfl. This is still a “beta” functionality, but you can already try it.

You can export your profiles by selecting Export > Profile(s) > “From Electric Scenarios (ESCE)” from the “Scenario” tab. In the " Export Profile file" window, choose Excel, CSV, or TXT, instead of *.prfl, from the “Save as type” dropdown menu.

Check the following screenshot:

image
image748×519 25.4 KB

Happy SAInt modeling :+1:

3

Thank you for the reply. Unfortunately, my version is v3.6.7.6 and there is only one format to export and that is .pfrl

4

Thanks Mohammad for clarifying which version you are using right now.

To “export” profiles in SAInt 3.6.x to a format different from SAInt native *.prfl you may need to follow these steps (apologies as it is not as straightforward as in the latest SAInt public release):

  1. Make a copy of the profiles template “Template_Profile_Import.xlsx” from .Documents\encoord\SAInt-v3\DataImport\Profile\. I will call it **Manual_Profiles.xlsx".

  2. In SAint have your model and scenario active, and open the “Table EPRF” from the tab “Scenario” and Profile > EPRF.

  3. In the “Table EPRF” add if missing and sort the columns as follows:

  4. Now you can export the table to Excel. Just right-click on the top cell that says “Drag column here to group …” (see screenshot above) and select Export (at the bottom) and the format you want, like Excel. This will create a file and you can now copy the content from the second row to the last row into the “Template_Profile_Import.xlsx” sheet PRF.

  5. Now the boring part! We need to copy&paste the time series of the profiles into the “Template_Profile_Import.xlsx” sheet PRFDATA. You can either:

  • Export each profile to an Excel file by right-clicking on the cell “Drag column here to group …” above the cell “Mean [-]”, and from there copy&paste the content of the newly generated file into the sheet PRFDATA.
  • Or you can select all cells containing values under “Mean [-]” and CTRL+C to copy them, and then paste them into the sheet PRFDATA.
  1. I assume all your profiles are “deterministic”, so you can remove any distance of the “Deviation” from the sheet PRFDATA.
  2. Each column with data in the sheet PRFDATA must start with the name of the profile between square brackets. The following cell is states “Mean”, and the following cells the data of the profiles. The name of the profile must match the name on sheet PRF.
  3. IMPORTANT: Please pay attention to the unit of measure used on sheet PRF to measure the time steps. The value stated in cell B2 (e.g., [h] which stands for hours) and used in cell C4, must match the actual values reported from C5 to Cx. If you check the screenshot above, there the time step is in minutes, so you need to convert it into hours in your PRF sheet if C2 states [h].

I understand this procedure is quite time-consuming, but it gets the job done.

Maybe consider updating your release of SAInt.

Happy modeling :+1:

1 Like
5

Hi Thank you for this detailed description. I think it will help.

6

Hi @aftabzmn1,

Thank you for using SAInt!

Just a note unless you have a compelling reason to maintain your current version of SAInt, I highly recommend downloading the latest version of SAInt 3.7. Not only will your profile export process be streamlined, but there are many other functionality additions and performance improvements. You can find the latest download on the forum here:

SAInt 3.7

Happy Modeling!

  • Wallace
7

Thank you. I will get it soon