Search found 40 matches

by drw
Tue Jan 07, 2020 11:54 pm
Forum: Vensim
Topic: DDE with 64-bit
Replies: 3
Views: 3923

Re: DDE with 64-bit

The example spreadsheet in the Vensim folder does this ("C:\Users\Public\Vensim\DDE\DDESERV.XLS") in conjunction with the example ball model ("C:\Users\Public\Vensim\Models\Sample\EXTRA\BALL.MDL"). You can start the connection (using the macro) and should get the DDE dialog box t...
by drw
Tue Jan 07, 2020 9:30 pm
Forum: Vensim
Topic: DDE with 64-bit
Replies: 3
Views: 3923

DDE with 64-bit

Hi folks, We have been using DDE for a while now to interface between Excel and Vensim on a 32-bit system but when using it on the 64-bit version (DSS 8.06) it seems to crash Vensim. I can create the connection using DDEInitiate ok, but when passing a command using DDEExecute (e.g. SPECIAL>LOADMODEL...
by drw
Tue Jan 07, 2020 1:09 am
Forum: Vensim
Topic: Different behaviour for Vector Select function when compiled
Replies: 1
Views: 1963

Different behaviour for Vector Select function when compiled

Hi Folks, Investigating compiled versus non-compiled for our rather large energy model, and was noticing some output differences between compiled versus non-compiled. I managed to track it back to some equations that were using the VECTOR SELECT function which was using double subscript variables. E...
by drw
Sat Dec 21, 2019 11:49 pm
Forum: Vensim
Topic: Changing vdf data sources from Excel using dll
Replies: 4
Views: 3551

Re: Changing vdf data sources from Excel using dll

That's great news. Thanks.
by drw
Fri Dec 20, 2019 12:44 am
Forum: Vensim
Topic: Changing vdf data sources from Excel using dll
Replies: 4
Views: 3551

Re: Changing vdf data sources from Excel using dll

Thanks a lot, those commands look like they could be a winner. For my understanding, when using results from another model run I need to export them as a *.DAT file first and then convert them to a vdf/vdfx to be read in as a data source (i.e. you cannot directly link to the results from another mod...
by drw
Wed Dec 18, 2019 11:16 pm
Forum: Vensim
Topic: Changing vdf data sources from Excel using dll
Replies: 4
Views: 3551

Changing vdf data sources from Excel using dll

Hi Folks, Looking to understand what would be the recommended way to change a vdf input data source when interacting with a vensim package file using vensim_dll from Excel please. With Excel files, one can use the "SIMULATE>SPREADALIAS" command to change the input xls file (to use with say...
by drw
Mon Dec 16, 2019 9:36 pm
Forum: Vensim
Topic: Model crashing Vensim 8.06 DSS 64-bit
Replies: 2
Views: 2503

Re: Model crashing Vensim 8.06 DSS 64-bit

I have just found out that one of my colleagues has already been in touch with you separately and that they believe they have identified the issue. It appeared to be linked the function DELAY MATERIAL (input, delay time, initial value, missval). If the delay time is >5 then it seemed to crash the 64...
by drw
Mon Dec 16, 2019 12:46 am
Forum: Vensim
Topic: Model crashing Vensim 8.06 DSS 64-bit
Replies: 2
Views: 2503

Model crashing Vensim 8.06 DSS 64-bit

Hi folks, We are looking at potentially moving to 64-bit platform using Vensim (DSS v8.06) in conjuction with 64-bit versions of Win 10 and office 2016. One of our rather large and complicated energy models (which unfortunately I cannot post), that works fine in a 32 bit environment (Vensim DSS 7.2 ...
by drw
Wed May 10, 2017 10:39 pm
Forum: Vensim
Topic: Vdf2tab issue
Replies: 3
Views: 3165

Re: Vdf2tab issue

Two sample files are in the attached zipped file. One with time specified and the other where time period was not specified and has the zero offset for some variables. Also I should have mentioned in the first post that when exporting this manually this was using a list file where time is specified ...
by drw
Tue May 09, 2017 11:16 pm
Forum: Vensim
Topic: Vdf2tab issue
Replies: 3
Views: 3165

Vdf2tab issue

Using the latest version of Vensim 6.4e DSS we are finding that when using the vdf2tab functionality as well as the manual export (manual -> export -> tab delimited) that some variables are being output offset by 1 year relative to the actual year if the time parameters are not specified. For exampl...
by drw
Sun Apr 30, 2017 10:35 pm
Forum: Vensim
Topic: Vector Reorder error message
Replies: 7
Views: 5228

Re: Vector Reorder error message

Thanks a lot, that is awesome. Love it when there is a smarter and more efficient way of doing the modelling. I definitely need to get my head around this vector elm map function as I imagine it should be able to simplify other parts of my model too! Many thanks again for your assistance. It is very...
by drw
Thu Apr 27, 2017 12:11 am
Forum: Vensim
Topic: Vector Reorder error message
Replies: 7
Views: 5228

Re: Vector Reorder error message

Thanks for the suggestion. Tried that both linked and unlinked to the "additional logic" part and unfortunately still have the same "out of range in reorder" error message.
by drw
Wed Apr 26, 2017 1:32 am
Forum: Vensim
Topic: Vector Reorder error message
Replies: 7
Views: 5228

Re: Vector Reorder error message

Thanks for looking at this. To simplify the mdl file that I posted, I pretty much stripped out all the input elements that feed into this section (i.e. all the get VDFs, get Excel function) and these are highlighted in orange and set to a constant 0. The only exception is the "Marginal SRMC&quo...
by drw
Tue Apr 25, 2017 4:08 am
Forum: Vensim
Topic: Vector Reorder error message
Replies: 7
Views: 5228

Vector Reorder error message

In order to optimise and reduce the computational and memory overhead of a fairly large hourly power generation dispatch model I am trying to separate some of the preprocessing calculations before the dispatch part of the model. In creating this smaller model I am finding that some of the logic whic...
by drw
Fri Jul 17, 2015 8:58 am
Forum: Vensim
Topic: Load run order
Replies: 5
Views: 4677

Re: Load run order

Thanks for your help. Finally got the latest version installed on my PC and can confirm it has been indeed fixed.

Thanks
Dave
by drw
Wed Jul 08, 2015 10:54 am
Forum: Vensim
Topic: Load run order
Replies: 5
Views: 4677

Re: Load run order

Thanks for the fast response. The current setting was set to "first" dataset already. I tried changing it to "2" and to "last" and in both instances it always loads as the last dataset. In other words, it appears to always load as the last dataset regardless of this set...
by drw
Wed Jul 08, 2015 9:39 am
Forum: Vensim
Topic: Load run order
Replies: 5
Views: 4677

Load run order

Since upgrading to version 6.3 of Venism DSS (x32), when running a new simulation the result appears to be last in the order rather than first (as in previous versions). I know you can go into the control panel and manually change this, but is there a system setting one can set to ensure that new ru...
by drw
Tue Feb 03, 2015 9:26 am
Forum: Vensim
Topic: DDE with Win 8.1 VM
Replies: 3
Views: 3446

Re: DDE with Win 8.1 VM

Using Office 2010. But also tried Excel 2007 and Excel 2003. Same result for all three.

Thanks
Dave
by drw
Mon Feb 02, 2015 6:41 pm
Forum: Vensim
Topic: DDE with Win 8.1 VM
Replies: 3
Views: 3446

DDE with Win 8.1 VM

Trying to use DDE to connect Excel to Vensim DSS on a windows 8.1 virtual machine (VM) which seems to hang Excel (specifically when you call DDEInitiate). I have no problems with the same VBA script (code reproduced below if needed) on a standard PC with windows 8.1 and vensim DSS. Also a previous i...
by drw
Thu Jan 22, 2015 4:38 pm
Forum: Vensim
Topic: Display scaling on model open
Replies: 3
Views: 3420

Re: Display scaling on model open

Many thanks for your advice and swift response. We operate only on windows PCs so a mac wasn't the likely cause but the article got me on the right track thinking re screen resolutions. We have just migrated to windows 8.1 and it seems this behaviour may be triggered if you change the default scalin...
by drw
Thu Jan 22, 2015 10:31 am
Forum: Vensim
Topic: Display scaling on model open
Replies: 3
Views: 3420

Display scaling on model open

We have a shared Vensim model file which multiple colleagues use. Recently, when the model is open it has started prompting to rescale the sketch. The prompt (see attached file) states "The current display scaling is different from the computer the model was last modified on". Is there a w...
by drw
Wed Feb 26, 2014 11:09 am
Forum: Vensim
Topic: What improvements would you like to see in Vensim?
Replies: 150
Views: 11208331

Re: What improvements would you like to see in Vensim?

It would be great if some of the analytical buttons are "sticky" (i.e. remain active) in a better way. For instance, for table and graphs you have the option of selecting "Activate on variable selection" after right clicking the button graph/table and going to options. However, t...
by drw
Tue Feb 07, 2012 5:36 pm
Forum: Vensim
Topic: Close/Save functions in command scripts
Replies: 3
Views: 3491

Re: Close/Save functions in command scripts

I have a number of automated routines using Excel as a front end to a large number of regional Vensim models. When I run scripts to change things like aliases it would be great to be able to tell the model to save and close before moving on to the next one without just relying on the fact that when ...
by drw
Tue Feb 07, 2012 4:51 pm
Forum: Vensim
Topic: Close/Save functions in command scripts
Replies: 3
Views: 3491

Close/Save functions in command scripts

Using command scripts are there commands available to 1) save a current model and 2) to close an open model (without closing Vensim). If you open another model it effectively does both at once (i.e. save, close existing file and then opens new one) as long as the close active model op open/new is ch...
by drw
Thu Feb 02, 2012 9:54 am
Forum: Vensim
Topic: Question about the DDE connection with Excel
Replies: 7
Views: 5785

Re: Question about the DDE connection with Excel

Had a similar problem but got around the issue by effectively putting a 'pause' in Excel wherever needed. Try using this function: Public Function PauseExcel(NumOfSeconds As Integer) As Boolean ' Procedure allows a delay but does not hang the application to allow other procedures ' to run and still ...