Ventana software support forum

Ahhh I see
thanks

thanks tony
that works.
odd about the other function though
regards
chester

Hi Tony
One problem: the function "vector sort order" does not give the expected results.
I've defined var1[day]=1,4,2,3,5,7,6
Then sorted var=Vector sort order(var1[day],1)
This gives
sorted var[day]=0,2,3,1,4,6,5
Not
sorted var[day]=0,3,1,2,4,6,5
as I would expect. Can you explain please?

Hello I'm looking for a way to add 2 subscripted variables (var1 and var2) together so that the largest element of var2 is added to the first element of var1, the second largest element of var2 is added to the second element of var1... and so on. I have seen the functions vector reorder and vector s...

Thanks alot for that. Will give it a go

Is there a way when using the venapp command:
menu>vdfxls|vdffile|tabfile|savelist|+*!number,
to only read out the data for the final time?

Thanks for your thoughts. Unfortunately, I've opted against an SD approach for this problem for a number of reasons: I am looking to get recommendations for individual SKUs and so the model tracks the flow of 1 product rather than a group of products. Therefore the delays are discrete rather than di...

Are there any plans to provide a queue function that operates on a last in first out principle? This would be very useful for modelling date life waste in inventory stocks: Customers tend to look for the youngest goods on a supermarket shelf. This is hard to replicate using the standard vensim queue.

That's as i expected. Essentially I need to look ahead from the current day (the model time step) in some data read in from excel. The trouble is the look ahead shift is dependent (a function of) on another variable which is read in from excel. Incidentally, I have found that that using an element f...

I have found that using the function 'time shift' to look ahead along a data series, often returns an error if the shift parameter is not a constant. For example if the time series is shifted by a variable shift and shift=constant +1, where 1 is a constant, the error is returned even if shift is des...

Have figured it out. Need to define: sub element[sub] = sub. Then insert this (with an exclamation mark) instead of the sub on its own. Thanks

Have just actually tried this: it does not quite do it. It actually sums over all the subscripts for the first m-1 elements of sum variable, and puts zero in the rest. The sub without the exclamation mark is not summed over. Any thoughts?

thank you.
easy when you know how!

Summing over the entire subscript range is easy using sum(!). My question is: Is there a way to sum over the first (or last) n elements in an m element range (m>n)?:(