Reading Excel Data - Inconsistency

[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

[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]

Thanks! For now, this works!

[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.