Please enable JavaScript to view this site.

Vensim Help

Details for importing data from spreadsheets are covered in Preparing, Using and Exporting Data.  It is also possible to directly get data from a spreadsheet using the GET 123 DATA, GET XLS DATA and GET DIRECT DATA functions, or ODBC.  For example, the equation

sales data := GET XLS DATA('ourstore.xls','sales','1','B5')

tells Vensim to look to the Excel file ourstore.xls on the tab labeled sales.  Vensim will read values for Time from row 1 and get values for sales data starting in cell B5 (from the 5th row starting in the second column).