Ventana software support forum

Hi,

I have resolved the issue myself I think see below.

using the matrix previously discussed. I now use the following equations.

health[need]= -sum(develop need[need,toNeed!])

Care[need]= sum(develop need[need!,toNeed])

If you have any other suggestions please let me know.

Many thanks

Joe

Hi, I am trying to simplify a model by including subscripts. The purpose of the model was to model people progressing from healthy to a level of care need. The subscripts I have in the model thus far are: none, low, medium, substantial and critical. Rather than have 6 stocks, I have two. A healthy s...

Hi, Is it possible to link sliders for constants in a model without using VENAPPS? I have 3 variables that are linked to one another: 1. Capacity of a service 2. Initial population using service 1 3. Initial population using service 2 These variables can be set using sliders. The initial population ...

Hi Tony,

Don't worry I have found the VENDLL.XLS example and I have figured it out. Many thanks again for your advice though.

C:\Program Files\Vensim\dll\EXCEL7

Joe

Thanks Tony, I am trying to use the code in Excel and I now get the compile error: ByRed argument type mismatch. What I would like to do is extract the data from a VENSIM table and place it in Excel. The code I am using is trying to get the information from a single variable in the model. The code t...

Hi

Thanks for the quick response. I have tried to implement the code above but I get a compile error stating that I am making Invalid ReDim.

Do I need to define vval and tval, as I haven't currently done this?

Many thanks again

Joe

Hi, I have a table in VENSIM that relates to 25 vals Private Sub ResultGet() result = vensim_get_data("base", "LR Susceptible 1[age1,female]", "TIME", vval, tval, 1) Worksheets("sheet1").Cells(6, 16) = result Worksheets("sheet1").Cells(7, 16) = vval ...

Thanks Tom, that sounds promising I will look into Matrices and see if I can use them, the logic makes sense.

Joe

Hi, I am trying to create an SIS (infection) model using subscripts and subranges to represent age groups and gender but I am getting confused with subscript mapping. There are 3 different infection rates depending on the age of the contact partner which I am trying to capture in the rate lr t: 1. t...