Excel to vensim

Franklin · Post by **Franklin** » Tue Oct 02, 2007 3:06 pm

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?

bob@vensim.com · Post by **bob@vensim.com** » Wed Oct 03, 2007 11:27 am

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.