Search found 12 matches

by Camila
Thu Feb 16, 2023 9:15 pm
Forum: Vensim
Topic: Error in models with GET XLS...
Replies: 1
Views: 866

Error in models with GET XLS...

Hello, I'm having an issue with different models that are supposed to get data from Excel files. I keep getting the same error message, and then Vensim suddenly closes, even when using blank Excel files. I've attached a screenshot of the error message for reference. Has anyone else experienced this ...
by Camila
Mon Jun 22, 2015 1:55 pm
Forum: Vensim
Topic: IF THEN ELSE with ALLOCATE AVAILABLE
Replies: 1
Views: 1956

IF THEN ELSE with ALLOCATE AVAILABLE

Hello, In order to speed up my model I would like to avoid calculating a dispatch (with Allocate Available) in every time step. So I am trying to do something like: IF THEN ELSE(GET TIME VALUE(1,0,4)=1, ALLOCATE AVAILABLE( Supply[Country,Tech], Supply Curve[Country,Tech,ptype], Demand[Country]) ,0) ...
by Camila
Fri Jun 12, 2015 12:53 pm
Forum: Vensim
Topic: Subscript position
Replies: 3
Views: 3287

Re: Subscript position

Thank you! it works perfectly :)
by Camila
Fri Jun 12, 2015 12:04 pm
Forum: Vensim
Topic: Subscript position
Replies: 3
Views: 3287

Subscript position

Hello, Is there a function that allows me to get the subscript in a certain position? For instance: I have the following subscript ranges subMonth: (m1-m12) subWD: (d0-d6) and a variable: Demand(subMonth, subWD) I would like to obtain the demand value for the current month (Month=GET TIME VALUE(1,0,...
by Camila
Fri Jun 06, 2014 1:40 pm
Forum: Vensim
Topic: Error: Gaming file corrupted
Replies: 3
Views: 3109

Error: Gaming file corrupted

Hello, I am getting the following error only when I try to run a model in Game mode, otherwise it works fine: ERROR: Unable to open the file x.vdf.vdf. ERROR: Gaming file x.vdf corrupted. I don't know why it has an extra ".vdf", the file is created by Vensim, not an existing one... can you...
by Camila
Sun Mar 10, 2013 1:59 pm
Forum: Vensim
Topic: Getting subscripts from Excel
Replies: 1
Views: 2080

Getting subscripts from Excel

Hi,

I am using the function "GET XLS SUBSCRIPT", but it seems that when I publish the model (.vpm) the subscripts are fixed, so they will not change when I change the values in Excel.

I would really appreciate your help on this,

Thank you,
Camila
by Camila
Fri Jan 08, 2010 5:09 pm
Forum: Vensim
Topic: Concat Vectors
Replies: 1
Views: 1759

Concat Vectors

I am trying to define a variable with 4 subscripts in which the first input is another variable and the others are numbers, something like this:

X[Subscripts]=(Y, 1, 2, 3)

Is it possible?
by Camila
Fri Oct 16, 2009 4:21 pm
Forum: Vensim
Topic: Number Format and Excel
Replies: 1
Views: 1957

Number Format and Excel

Hello, I am trying to import data from Vensim to Excel, but when the numbers exceed a million, Vensim uses for example 1M, and I can't get the other digits in Excel. Does anyone know how to make Vensim work with scientific notation or at least including all the digits of a number? Thank you! Camila.
by Camila
Thu Apr 23, 2009 4:37 pm
Forum: Vensim
Topic: Run Step by Step from DDE
Replies: 6
Views: 3989

The only value I can get in each step is Time. I have tried using vensim_get_val and Application.DDERequest for other variables, the first one returns 0 unless I have run the complete simulation, and the other, using the time value I get with vensim_get_val, does not return any value. Both of them w...
by Camila
Thu Apr 23, 2009 1:22 am
Forum: Vensim
Topic: Run Step by Step from DDE
Replies: 6
Views: 3989

Well, I have solved the problem of running step by step with the vensim_start_simulation and vensim_continue_simulation functions, but I still can't get the value of a variable without running the complete simulation, it seems that vensim doesn't save that information before Final Time. Is there any...
by Camila
Wed Apr 22, 2009 4:27 pm
Forum: Vensim
Topic: Run Step by Step from DDE
Replies: 6
Views: 3989

Thank you Bob, I have tried that, and the MENU>GAME works fine, but the GAME>GAMEON doesn't seem to do anything. I have this instructions in VB: Sub Game() Application.DDEExecute DDE_channel, "[MENU>GAME|o]" End Sub Sub Avanzar() Application.DDEExecute DDE_channel, "[GAME>GAMEON]"...
by Camila
Tue Apr 21, 2009 8:56 pm
Forum: Vensim
Topic: Run Step by Step from DDE
Replies: 6
Views: 3989

Run Step by Step from DDE

Hi,

I'm trying to control Vensim from Excel with a DDE in VB, but I can't find how to run one step of the simulation, like in games. Does anyone knows how to do that?

Thanks!!