117 Views
Hi Stuart,
In your first step, are you referring to an MS Excel file which you have created yourself? Have you assigned a name to the contiguous range of cells in your workbook which contain your hourly load information?
The "Import Hourly Shape" dialog is designed to read from named ranges in open Excel workbooks. In the sample spreadsheet from the optimization exercise, there is a named range entitled "kWh". To assign your own names to ranges, please follow these instructions:
https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
Once you've done that, then you should see a list of names appear in the drop-down Excel range menu when you try to import your hourly data.
You also mention that you are unable to import the load data from the sample document provided for the optimization exercise. Does this mean that you can not view the "kWh" range in this workbook during the import process?
Hope this helps,
Taylor
*Side note* LEAP's interaction with Excel is enabled by a part of the Windows OS. This means that performing import/export operations using Excel will only work on modern *full* Windows installations (i.e. not "starter" versions of Windows, not Mac or Unix).