Claude Davis 4/28/2009

Like

1 Like 3122 Views

Is it possible to import time slice data (e.g., hourly week day and week-end data).
Also on exporting sample load share data, then editing the data and trying to import the edited excel file, the exported file has two columns but the import dialog appears to want only one column of data.
Help?

Charlie Heaps 5/1/2009
 

Like

3113 Views

> Is it possible to import time slice data (e.g., hourly week day and week-end data).

At the moment you cannot import the data for the names of the time slices. However there is an option to import the data for each load shape from Excel.

> Also on exporting sample load share data, then editing the data and trying to import the edited excel file, the exported file has two columns but the import dialog appears to want only one column of data.

Yes, both the names and the values get exported but when importing you only need to specify the range containing the values. Note that LEAP assumes that the values are in the same order in Excel as they appear in LEAP. A tip: the easiest way to import is to mark the values in Excel using a range name. Just select the range then type a name for it in Excel (in the box in the left hand corner of Excel). Then when you go back to LEAP you can select that name in the drop down selection box that appears when you select "import" in the General: Load Shapes screen. You can use the same technique in other screens where you import from Excel.

I hope this helps,

Chrlie