Array

pochoa · Post by **pochoa** » Wed Mar 17, 2004 10:11 am

I have a 2 dimensional subscripted variable
Offer[Price,Quantity]
I need to sort it by Price and then I need to read the Quantity corresponding to each of the ordered Price.
I don't know how to fill the variables for the two dimensions, and I don't know how to call the value of the quantity relating to a price.
Thanks

Pruyn · Post by **Pruyn** » Wed Mar 17, 2004 10:23 am

If I get your Idea right, it sounds more like you need a lookup or other one-to-one funcion.
But to answer part of your question. To input 2-dimensional arrays use comma's to separate the first set of values for quantity, then use a ; to input the next set of values corresponding to quantity and the second price. (1,2,3;1,2,3; ). But all this is in the manual under subscripts.
As far as I know it is only possible to order by the last subscript, so you should change their order.

[Edited on 17-3-2004 by Pruyn]

pochoa · Post by **pochoa** » Wed Mar 17, 2004 12:30 pm

Thanks Pruyn, But what I need is to fill the 2 dimensional array with variables, not with constant values, so the structure with 1,3,4;5,6...does not work.
For 1 dimension I use multiple equations, but I don't know how to fill in the variable for the second dimension

Post by **Administrator** » Wed Mar 17, 2004 12:56 pm

Can you give an example of what you have (vensim variables) and what you need? I am sure it is easy, just need to see what variable types you are using.

Tony.