Ventana software support forum

hi, I am wondering, does Vensim provide any function to perform moving average. specifically speaking, I would like to take an average of a variable in its last three time steps. For example, Average =(Variable(t-3)+variable (t-2)+variable(t-1))/3, where t is time. I would appreciate that any one co...

Many thanks. It is working now as I follows your advice. In order to make it more clear, I quote your advice here. "that means you create a variable named "excel lookup" then open the equation editor, then select type Lookup, then enter the equation GET XLS LOOKUPS('test.xls','Sheet2'...

I have figured out the problem, by using Delay Fixed function, I have tested it and it is working.

hi, I am trying to use the function GET XLS LOOKUPS('file','tab','x row or col','cell') function to import data from EXCEL, I have read the VEnsim Manual about this function, and it gives a example regular lookup((0,0),(1,1)) excel lookup(GET XLS LOOKUPS('test.xls','Sheet2','1','B2')) ~~| subbed exc...

hi,

any ideas to get the value of variables in last time step?

Roger