Joana Pena 3/5/2013

Like

2170 Views

Hey Tory!

I have a problem, I'm trying to import an hourly shape and it is already in the exact same format of the one on the optimization example, and I put it on the folder of my current area.
On the yearly shapes menu I tried to import an houly shape with de the excel open and I put the range B2:B8761 and appears this error:
Error: Índice inválido
Type: EOleException
File: UNKNOWN
Module: ComObj
Line: UNKNOWN
Process: DispCallError

Details:
Call stack:
:0055D0B2 [leap.exe] __linkproc__ DispCallError
:75B4C41F [KERNELBASE.dll]
:0055D0B2 [leap.exe] __linkproc__ DispCallError
:0055C064 [leap.exe] __linkproc__ EOleException::Create
Recursive call (2 times):
:0055D0B2 [leap.exe] __linkproc__ DispCallError
:0055D0E5 [leap.exe] __linkproc__ DispatchInvokeError
:0055CDBE [leap.exe] __linkproc__ DispatchInvoke
:754B62D9 [RPCRT4.dll]
:754B58FA [RPCRT4.dll]
:754B6386 [RPCRT4.dll]
:750C2CBA [ole32.dll]
:750C2C70 [ole32.dll]
:754BFFDA [RPCRT4.dll]
:754B78DF [RPCRT4.dll]
:750F7D36 [ole32.dll]
:751DC80F [ole32.dll]
:750EEE81 [ole32.dll]
:750F90C1 [ole32.dll]
:751DD1E0 [ole32.dll]
:750D9F56 [ole32.dll]
:751DC7E4 [ole32.dll]
:751DD178 [ole32.dll]
:754B7185 [RPCRT4.dll]
:754B6546 [RPCRT4.dll]
:755501A0 [RPCRT4.dll]
:754B649C [RPCRT4.dll]
:75550175 [RPCRT4.dll]
:7565549D [GDI32.dll]
:75657DF1 [GDI32.dll]
:758B1668 [USER32.dll]
:004E4C41 [leap.exe] __linkproc__ TWinControl::WndProc
:754D4184 [RPCRT4.dll]
:754D413D [RPCRT4.dll]
:004E4EFE [leap.exe] __linkproc__ TWinControl::PaintHandler
:004E55D9 [leap.exe] __linkproc__ TWinControl::WMPaint
:004DFF9B [leap.exe] __linkproc__ TControl::Perform
:758B1396 [USER32.dll]
:004E788C [leap.exe] __linkproc__ TWinControl::CMInvalidate
:758B62D5 [USER32.dll]
:004EA64E [leap.exe] __linkproc__ TCustomControl::WMPaint
:004E0377 [leap.exe] __linkproc__ TControl::WndProc
:758B6381 [USER32.dll]
:758EC21F [USER32.dll]
:758A6E44 [USER32.dll]
:7730F8CA [ntdll.dll]
:758A6E57 [USER32.dll]
:75B759C7 [KERNELBASE.dll]
:75550175 [RPCRT4.dll]
:751DC8E2 [ole32.dll]
:750D98AD [ole32.dll]
:0055CF32 [leap.exe] __linkproc__ GetIDsOfNames
:0055D000 [leap.exe] __linkproc__ VarDispInvoke
:758A717A [USER32.dll]
:758A6D91 [USER32.dll]
:758A6D51 [USER32.dll]
:758A6CE9 [USER32.dll]
:758A6D91 [USER32.dll]
:758A6D51 [USER32.dll]
:758A6DE8 [USER32.dll]
Recursive call (2 times):
:758A6DF3 [USER32.dll]
:758A6E44 [USER32.dll]
:7730F8CA [ntdll.dll]
:758A6E57 [USER32.dll]
:004FBAB4 [leap.exe] __linkproc__ TCustomActionList::IsShortCut
:0042D2D4 [leap.exe] __linkproc__ __linkproc__ DispInvoke
:011731DA [leap.exe] __linkproc__ TLoadShapeFrm::ImportLoadCurveExecute (LoadShapeForm.pas, line 1314)
:004FBAB4 [leap.exe] __linkproc__ TCustomActionList::IsShortCut
:00456ACE [leap.exe] __linkproc__ TBasicAction::Execute
:004FB68A [leap.exe] __linkproc__ TContainedAction::Execute
:004FC445 [leap.exe] __linkproc__ TCustomAction::Execute
:00456994 [leap.exe] __linkproc__ TBasicActionLink::Execute
:00EF664F [leap.exe] __linkproc__ TTBCustomItem::Click (TB2Item.pas, line 1474)
:00EF654A [leap.exe] __linkproc__ TTBCustomItem::ClickWndProc (TB2Item.pas, line 1423)
:004577CA [leap.exe] __linkproc__ StdWndProc
:758A62FA [USER32.dll]
:758A6D3A [USER32.dll]
:758A6CE9 [USER32.dll]
:758A77C4 [USER32.dll]
:758A788A [USER32.dll]
:004C34F6 [leap.exe] __linkproc__ TApplication::ProcessMessage
:004FBAB4 [leap.exe] __linkproc__ TCustomActionList::IsShortCut
:004C353B [leap.exe] __linkproc__ TApplication::HandleMessage
:004BED66 [leap.exe] __linkproc__ TCustomForm::ShowModal
:004BEDEC [leap.exe] __linkproc__ TCustomForm::ShowModal
:004BEEAB [leap.exe] __linkproc__ TCustomForm::ShowModal
:004BEECD [leap.exe] __linkproc__ TCustomForm::ShowModal
:004BEEEA [leap.exe] __linkproc__ TCustomForm::ShowModal
:00406E0D [leap.exe] __linkproc__ __linkproc__ ClassCreate
:012CB19D [leap.exe] __linkproc__ TMainfrm::YearlyShapeActionExecute (MainForm.pas, line 16334)
:012CB1F5 [leap.exe] __linkproc__ TMainfrm::YearlyShapeActionExecute (MainForm.pas, line 16341)
:00456ACE [leap.exe] __linkproc__ TBasicAction::Execute
:004FB68A [leap.exe] __linkproc__ TContainedAction::Execute
:004FC445 [leap.exe] __linkproc__ TCustomAction::Execute
:00456994 [leap.exe] __linkproc__ TBasicActionLink::Execute
:00EF664F [leap.exe] __linkproc__ TTBCustomItem::Click (TB2Item.pas, line 1474)
:00EF654A [leap.exe] __linkproc__ TTBCustomItem::ClickWndProc (TB2Item.pas, line 1423)
:004577CA [leap.exe] __linkproc__ StdWndProc
:758A62FA [USER32.dll]
:758A6D3A [USER32.dll]
:758A6CE9 [USER32.dll]

Modules:
$00400000 (00400000,00001000,01074A00) C:\Program Files (x86)\LEAP2012\leap.exe
$75B40000 (75B40000,00001000,0003F800) C:\Windows\syswow64\KERNELBASE.dll
$754A0000 (754A0000,00010000,00097E00) C:\Windows\syswow64\RPCRT4.dll
$750A0000 (750A0000,00001000,00144A00) C:\Windows\syswow64\ole32.dll
$75640000 (75640000,00010000,00049000) C:\Windows\syswow64\GDI32.dll
$75890000 (75890000,00010000,0006CC00) C:\Windows\syswow64\USER32.dll
$772F0000 (772F0000,00010000,000D5C00) C:\Windows\SysWOW64\ntdll.dll

System Info:
LEAP
Registered to taniasousa@ist.utl.pt until March 5, 2014
User Name: Joana Pena
Version: 2012.0.0.37
Dictionary Version: 337
Program Folder: C:\Program Files (x86)\LEAP2012\
Areas Folder: C:\Users\Joana Pena\Documents\LEAP2011 Areas\
Settings Folder: C:\...\Documents\LEAP2011 Areas\_LEAP Settings\
Work Folder: C:\...\Documents\LEAP2011 Areas\_Work\
First Instance: Yes
First Instance: Yes
Mapping Components: Not Installed

Microsoft Windows
Version: Windows 7
Windows Directory: C:\Windows
Internet Explorer: 9
Fonts: Small fonts
Running as: Standard User
BDE Installed: Yes
Excel Installed: Yes
Word Installed: Yes
PowerPoint Installed: Yes
Running in Wine: No

Computer
Name: PIEDADEALMEIDAG
RAM: 4011 MB
CPU Manufacturer: GenuineIntel
CPU Type: P 6
CPU Speed: 2492 MHz
Number of CPUs: 4
MAC Address: 3212CD14AF5F
Disk Size: 111.0 GB
Free Disk Space: 23.0 GB
Screen Resolution: 1366 x 768

Can you please tell me what I'm doing wrong?

Tks!

Joana

Tory Clark 3/5/2013
 

Like

2169 Views

Hi Joana,

Can you confirm that you are using a named range in Excel of the corresponding electric demands from hours 1 to 8760?

If so, can you please send me the LEAP Area you are using to leap@sei-us.org (you can do this with Area: Email or by using the Area: Backup, saving the file to your computer and attaching it to an email to me) and also please send me the Excel file you are using so that I can investigate further.

Best,

Tory

Joana Pena 3/8/2013
 

Like

2161 Views

Tory I just emailed you with the data. I managed to rectify the error but the end result is not what I would like.

Thanks for all your help.

Joana