Reading Excel Data - Inconsistency

Use this forum to post Vensim related questions.
Post Reply
karankhosla
Senior Member
Posts: 107
Joined: Wed Nov 26, 2008 6:12 am

Reading Excel Data - Inconsistency

Post by karankhosla »

Greetings!

Attached is an excel file and the beginnings of a dynamic model of a company's P&L statement.

The Get XLS command will read values "time down".

On some columns for example "o13" or "l13" Vensim imports the data correctly; however, on other columns such as "b13" it doesn't. The results indicate some sort integration error (which doesn't make sense as I haven't defined any stocks as yet).

Best Wishes,

Karan
Attachments
Karan_Excel.zip
(11.49 KiB) Downloaded 389 times
Administrator
Super Administrator
Posts: 4841
Joined: Wed Mar 05, 2003 3:10 am

Post by Administrator »

Seems the problem is that Vensim is reading down the time column and finding two values for each year (some of the imported data comes from the "Resources" part of the spreadsheet when I ran the demo you uploaded).

If you move the resources part to somewhere else (or delete the 1995-2011) it should import correctly.

Can you do that for now?

Tony.
karankhosla
Senior Member
Posts: 107
Joined: Wed Nov 26, 2008 6:12 am

Post by karankhosla »

Thanks! For now, this works!
bob@vensim.com
Senior Member
Posts: 1107
Joined: Wed Mar 12, 2003 2:46 pm

Post by bob@vensim.com »

An alternative solution in this case would be to use named ranges as in:

GET XLS DATA('RYANAIR_DATA.xls', 'Summary', 'TIME1', 'PJF')

Where Time1 is selected as B13-B29 and PJF is selected as F13-F29 in the Excel Sheet.
Post Reply