I have an Excel data set that looks like this:
year unit variable1 variable2 variable3 variable4 ...
1990 A 1 2 6 9
1990 B 7 13 12 4
1990 C 1 5 8 0
. . . . . .
1991 A 1 2 6 9
1991 B 7 13 12 4
1991 C 1 5 8 0
. . . . . .
1992 A 1 2 6 9
1992 B 7 13 12 4
1992 C 1 5 8 0
. . . . . .
. . . . . .
. . . . . .
Note the values are not repeated, they are just examples. The years go from 1990 to 2006, there are 87 units and 4 variables.
Can someone suggest the best way to lay this out in Excel and and the code to use for GET XLS DATA?
Thanks.
3d input from Excel
-
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm
The simplest layout would be
Time 1990 1991
var1[a] 1 1
var1 3 4
var2[a] 5 7
and so on. Then you can either use GET XLS DATA or Model>Import Dataset to bring the values into Vensim without difficulty. Note that instead of var1[a] you could have var1 in only cell and a in the next. For GET XLS DATA the labeling does not matter anyway but it does when importing.
Time 1990 1991
var1[a] 1 1
var1 3 4
var2[a] 5 7
and so on. Then you can either use GET XLS DATA or Model>Import Dataset to bring the values into Vensim without difficulty. Note that instead of var1[a] you could have var1 in only cell and a in the next. For GET XLS DATA the labeling does not matter anyway but it does when importing.