working wiht vector, array or matrix

[Franklin]

I am trying to take a value of excell to use in vensim.
How to do vensim take a value of excel and put in array, vaector or matrix?

[LAUJJL]

Look at the GET XLS CONSTANTS function at the index of the help.
JJ

[Franklin]

I saw the index help, but my aplication need more.
I use the function GET XLS CONSTANTS,I can get of information of excel but I need take information of excel and put in array,vector or matrix to work with them.
Are there possibilite in vensim to use the control to change a "firstcell" of function GET XLS CONSTANTS?

[LAUJJL]

Hi,
I answered you directly by mail.
If you have problems, the best is to post a little model with the conrresponding spreadsheet.
Regards.
JJ

[bob@vensim.com]

Hi Franklin,

I am not really sure what you are trying to do but one thing you might try is to use a named range instead of a cell reference. This will make it easier to change which cells are referred to by the GET XLS CONSTANTS call.

[LAUJJL]

This what I sent already directly with a model with the three dells of the get xls constants named.
Zip joined.
JJ

[Franklin]

I know how to take value of excell but I don't understand how to store in vensim.
there are possibilite to multiple, coluns or lines in vensim?
I have two lines in excell, I want to sum, multiple, or use another opertation matemathic.
Line 3 and line 5 of excel, how to use vensim for multiple this lines?

[LAUJJL]

Hi Franklin

Just write a program in Excel that does exactly what you want to do in Vensim. It is always possible especially if the model is simple.
The columns in Excel will represent the steps and the lines
will represent the values.
The first column will have the name of the variables and one more column for the initialisation.
The levels are easy to represent by cumulating the value in the preceding column to the rate.
If you have vectors it will be necessary to use several lines for the same value.
Post the excel program and it will be possible to understand
your problem.
Regards.
JJ

[Franklin]

Hi! Jean



I am trying to develop a model of auction of power. In my spreadsheet made table of information with date of start, type, duration, price and average power about electric power. I want put this information in vector to work. For example when have contract in same year average power plus in other vector and show in graph.

Thank for your help!

[bob@vensim.com]

Hi Franklin,

It sounds like you are simply trying to bring time series data from excel into Vensim. Chapter 16 of the User's Guide describes how to do that. I would suggest working through that chapter.