Ventana software support forum

Ok. Was very helpful.

Thanks a lot.

Yes. I was confused here and not taking into account that VECTOR SORT ORDER works on the last subscript range. My question now is how I can reorder a 2-dimension (10 x 50) matrix by its 1st subscript range. I was thinking of transposing, reordering and transposing it again but I don´t see an easy wa...

I am having trouble for reordering long vectors (50 elements). Please see an example below (model attached): INITIAL VECTOR 1,1,1,1,1,1,1,1,1,1, 1,1,1,1,1,1,1,1,1,1, 1,1,1,1,1,1,1,1,1,1, 1,1,1,1,1,1,1,1,1,1, 1,1,1,1,1,1,1,0.04,0,0 SORTING VECTOR 0,1,2,3,4,5,6,19,20,21, 35,36,24,25,26,15,16,42,45,49,...

I am trying to reorder a matrix by rows the following way: INITAL MATRIX [1,2,3; 1,2,3; 1,2,3] REORDER VECTOR [2,1,0] EXPECTED RESULT[/b] [3,2,1; 3,2,1; 3,2,1] I am using the model attached but I am not getting the expected result. Why is the model not working? Is there a better way for reordering a...

Hi,

Can you please advice regarding how I can export the Montecarlo simulation results to an Excel file? I don't see how I can edit the .lst file.

Thank you very much,

Santiago

Hi,

Is there any way to view the results of Montecarlo simulations in table format?

I´m able to get sensitivity charts and histograms of the target variable but don´t see any way to get the actual data, which I need for further processing.

Thank you very much

Santiago

Hi,

I would like to know how can I find the position of an specific within a vector. For example:

Vector = [3, 6, 7, 1, 0, 8]

Is there any straightforward way to get the position of '1' (= 4)?

Thank you

Santiago

Hi,

Great hints. Very useful, as usual

Thanks a lot!

Santiago

Hi, I need a level variable to not go below zero and so I am using an IF THEN condition in the 'emptying' rate so that if the level is greater than zero, the 'emptying' rate is non-zero and when the level is equal or less than zero, the 'emptying' rate becomes zero (see simple example attached). The...

Hi, I need to combine n variables with m subscripts each into one single variable with [ n x m ] subscripts. For example ( n = 3, m = 5) I need to combine these variables - Var 1 [Sub1, Sub2, Sub3, Sub4, Sub5] - Var 2 [Sub1, Sub2, Sub3, Sub4, Sub5] - Var 3 [Sub1, Sub2, Sub3, Sub4, Sub5] Into the fol...

Hi, I am implementing an information delay by means of the SMOOTH function. The information delay should work in a way that the output should be delayed with a specific value when the input is increasing and with a different value when the input is decreasing. Specifically I I need the delay to have...

Ok. Thank you very much.

How can we know when the addition is implemented? Is it posted anywhere?

Thanks.

Santiago

Hi, I am calculating the Internal Rate of Return (IRR) of investments by using the FIND ZERO function applied to the Net Present Value (NPV). A solution for the IRR does not always exist (for example in the case where all future cash flows are negative) so that, in these cases, the FIND ZERO functio...

Hi, Well, I was trying to keep it as simple as possible. Also, can you please help me to implement it with level variables? I haven't figured out how to do it yet. Please have a look at the model attached: I need the 'Result' variable to be equal to 'Sin initial' while Time <=10 and after to increas...

Hi, I need an auxiliary variable (Aux) to be driven by Excel data until a specific time (e.g. Time = 100). After, I need it to change by a specific % (e.g. 5%) of the last value taken from the Excel spreadsheet. Is there any way I can do this without having to introduce level variables? I was trying...

Ok. Got it now.

Thank you very much again!

Ok. Thanks!

Can you please have a look at the model and Excel attached? I don't know what I'm doing wrong but if I table the 'Read data' variable I can only get the data at the specific years (2000. 2001. 2002. etc.) There is no data at the intermediate values (2000.25, 2000,50, 2000.75, etc.) in case I use any...

Hi again, I am using a set of annual data in order to drive a model. I am using a time step equal to 0.0625 so that the model calculates 16 values per year/variable. The point is that when I use the GET XLS DATA function with a set of data such as the one below: Year Value 2000 5 2001 6 2002 7 Vensi...

Hi, I am trying to calculate the expected profitability of a specific project by taking the averages of the last 3 years profits and extrapolating them 2 years in the future (when the project is expected to be online) My question is: how can I store and retrieve the profitability data corresponding ...

Not really. As far as I understand it VECTOR LOOKUP allows me to build a lookup function with equally spaced X values while I need unequally spaced X values. For example, I can build the following lookup table: x=[0 1 2 3 4 5] y=[2 2 2 3 3 3] but I can't build a lookup table like the one below: x=[0...

Hi, I need to define variable (across time) lookup functions. As far as I've seen I can achieve this only by using the VECTOR LOOKUP function as it seems that lookup tables can be used only with constant values and not variables (please correct me if I am wrong). The problem is that the VECTOR LOOKU...

Hi again, I am developing a model which calculated the IRR (Internal Rate of Return) of specific assets as an intermediate variable. I am sending attached a simplified piece of the model as an example. PROBLEM DEFINITION - There are 5 different asset classes (subscripted): W, SPV, SH, STE and GCC - ...

Thanks for you answers. I am trying to do it because I am having convergence problems with the FIND ZERO function but only with specific subscripts. While some subscripts converge when I add a new one, it does not converge (and makes sense) but the problem is that this fact makes some of the subscri...

Hi, Vensim PRO6.3D Windows XP I'm trying to include exceptions for specific subscripts in a Lookup table. I am sending attached a sample simplify model: - Subscript elements for [Class] are: a, b, c, d - I need the general Lookup table (which should return a constant value equal to 5) for all subscr...