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
Reading Excel Data - Inconsistency
-
- Senior Member
- Posts: 107
- Joined: Wed Nov 26, 2008 6:12 am
Reading Excel Data - Inconsistency
- Attachments
-
- Karan_Excel.zip
- (11.49 KiB) Downloaded 389 times
-
- Super Administrator
- Posts: 4841
- Joined: Wed Mar 05, 2003 3:10 am
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.
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.
-
- Senior Member
- Posts: 107
- Joined: Wed Nov 26, 2008 6:12 am
-
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm