• 103 views | 3 messages Discussion: LEAP
    Topic: Solar wind power availability data import from ExcelSubscribe | Previous | Next
  • Hyungsik Choi 3/29/2021

    1 Like


    Hi,

    I want to import renewable energy like solar, wind power availability(0...100%) data from Excel to LEAP as below.
    I succeeded in import electricity demand data, following the guide on the training material.
    But, in this case, the situation is different.

    The current time slice shape is 4 seasons and 24hours. I used the option - import from time-sliced shape.
    When I click it, a window pops up and it shows "Key Assumptions"_FilterDatabase.
    And when I tried to link it with an excel which containing the data, the next error messages are shown.

    Please, tell me what I should do in this case. I want to import data automatically and not want to type it manually.

    Best, hyungsik






  • Utsavshree Rajbhandari 4/3/2021
      Best Response

    1 Like

    Dear Hyungsik,
    The import into the yearly shape is not similar to importing values of demand branches.
    The only specific format you need to follow is that arrange the values in single column as shown in highlight.


    Thereafter for importing the excel range should contain sheet name along with range, but of the value column only.
    In shown example, the values are in column C, ranging from row 2 to row 97.



    Now you can import the data.

    Hope this helps.

    Best,
    Utsav

  • Hyungsik Choi 4/4/2021
      Best Response

    Thanks a lot!!!, Utsav.
    It works in my PC as well.