Page 1 of 1

Excel to vensim

Posted: Tue Oct 02, 2007 3:06 pm
by Franklin
In Vensim
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?

Posted: Wed Oct 03, 2007 11:27 am
by bob@vensim.com
I am not sure I really understand the question - if you have, for example, two rows of values in Excel you could use:

row1[sub] = GET XLS CONSTANTS('file.xls','Sheet1','A1')
row2[sub] = GET XLS CONSTANTS('file.xls','Sheet1','A2')

row2 plus row2[sub] = row1[sub] + row2[sub]

Once you have the numbers in Vensim you can just use them like other variables.