Search found 32 matches

by pav80
Wed Feb 02, 2022 8:04 am
Forum: Vensim
Topic: issue with "Export units" option?
Replies: 0
Views: 17599

issue with "Export units" option?

Hi, Wondering if anybody in the community when exporting results from VDFX uses both a LST file and also the option "Export units"? On both small and big models we are noticing that if you DON'T use LST and just export all variables from the model and if "Export units" is selecte...
by pav80
Wed Dec 15, 2021 8:15 am
Forum: Vensim
Topic: Global variables in VDI files
Replies: 5
Views: 2760

Re: Global variables in VDI files

Administrator wrote: Mon Nov 22, 2021 8:51 am I'm fairly certain it cannot be done at present. But it seems like it could be easy enough to do. I'll create a ticket in our system to add it in a future release.
Dear Administrator, just checking if this was included in Vensim 9.1.0 release?
by pav80
Mon Nov 22, 2021 2:09 pm
Forum: Vensim
Topic: Global variables in VDI files
Replies: 5
Views: 2760

Re: Global variables in VDI files

I'm fairly certain it cannot be done at present. But it seems like it could be easy enough to do. I'll create a ticket in our system to add it in a future release.
Thank you Administrator, that would be very much appreciated as would render the VDI further efficient when using large SQL statements.
by pav80
Sat Nov 20, 2021 7:36 am
Forum: Vensim
Topic: Global variables in VDI files
Replies: 5
Views: 2760

Global variables in VDI files

Hello, Below is an example of some VDI code. Wondering if it is possible to declare in the VDI file at the start a global variable that you can then call in the SQL statements in the VDI file, so as to make the VDI code easier to update with such global variables. In the below case for example can w...
by pav80
Fri Nov 05, 2021 4:12 pm
Forum: Vensim
Topic: VDF2TIDY
Replies: 3
Views: 2275

Re: VDF2TIDY

Thanks tomfid. In regards to "What's the use case for exporting the data from the simulation, rather than using the input data?" if you have the data in Excel, it goes into your vensim Model for example as a DATA variable. You then want to store it in the DW, so you use the export option o...
by pav80
Fri Nov 05, 2021 1:11 pm
Forum: Vensim
Topic: VDF2TIDY
Replies: 3
Views: 2275

VDF2TIDY

Hi Vensim users, We are noticing that when using the command VDF2TIDY (described here https://www.vensim.com/documentation/vdf2tidy.html) it doesn't want to export data from a Vensim run if a given variable is defined as DATA. So effectively one has to create a passthrough variable of AUXILLIARY typ...
by pav80
Mon Jun 29, 2020 3:39 am
Forum: Vensim
Topic: Vensim ODBC scenario selection via run name
Replies: 2
Views: 2141

Vensim ODBC scenario selection via run name

Hi, Saw on https://www.vensim.com/documentation/values_by_scenario.htm that one can refer to the name of the current Vensim simulation run by using the character (!). Therefore if one has the below ODBC query, can one actually send the scenario name in the form of the character (!) to the select sta...
by pav80
Wed Nov 27, 2019 10:59 am
Forum: Vensim
Topic: Exporting UNITS is possible?
Replies: 2
Views: 2155

Re: Exporting UNITS is possible?

Thank you that would be great, as exporting UNITS is useful if you want to send the TIDY format directly to a data warehouse structure.
by pav80
Wed Nov 27, 2019 10:03 am
Forum: Vensim
Topic: Exporting UNITS is possible?
Replies: 2
Views: 2155

Exporting UNITS is possible?

Greetings,

Using VDF2TIDY is it possible to also export whatever is UNITS assigned to a given variable in Vensim?

Thanks, Pawel
by pav80
Mon Nov 18, 2019 9:08 am
Forum: Vensim
Topic: What improvements would you like to see in Vensim?
Replies: 150
Views: 11217235

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

Our IT staff would appreciate the "silent install" option for Vensim in the future. More details here. Ideally, we would like to push the Vensim install out using System Center Configuration Manager (SCCM). This allows to track our licence usage, and also orchestrate version updates in a m...
by pav80
Wed Nov 06, 2019 4:12 pm
Forum: Vensim
Topic: Vensim 8 without single precision?
Replies: 6
Views: 3955

Re: Vensim 8 without single precision?

Thanks Administrator
by pav80
Wed Nov 06, 2019 3:31 pm
Forum: Vensim
Topic: What improvements would you like to see in Vensim?
Replies: 150
Views: 11217235

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

Greetings,

Our IT staff are wondering if in the long term Vensim could be designed for multithreading, because based on tests we did, seems Vensim is more designed for single-thread processing?

Regards
by pav80
Wed Nov 06, 2019 3:23 pm
Forum: Vensim
Topic: What improvements would you like to see in Vensim?
Replies: 150
Views: 11217235

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

Greetings,

Our IT staff are wondering if for the long term vision of Vensim, if you have any plans to offer an MSI-based installer?
Based on some exchanges understand this is not planned at the moment.

Regards
by pav80
Wed Nov 06, 2019 2:55 pm
Forum: Vensim
Topic: Vensim 8 without single precision?
Replies: 6
Views: 3955

Re: Vensim 8 without single precision?

Thanks Aministrator
by pav80
Wed Nov 06, 2019 2:34 pm
Forum: Vensim
Topic: Vensim 8 without single precision?
Replies: 6
Views: 3955

Re: Vensim 8 without single precision?

Thank you for the confirmation. Do you also confirm that "For large models the double precision version of Vensim essentially takes twice the memory, so it should be used with discretion. For most business models there seems little to be gained from the added precision." ? Taken from https...
by pav80
Wed Nov 06, 2019 12:05 pm
Forum: Vensim
Topic: Vensim 8 without single precision?
Replies: 6
Views: 3955

Vensim 8 without single precision?

Greetings, On this site https://vensim.com/september-newsletter-ventana-news-vensim-8-ventity-3-releases/ it mentions "All configurations of Vensim now use double floating point precision for both calculations and results storage" So does that mean as of Vensim 8, single precision is no lo...
by pav80
Thu Oct 31, 2019 2:47 pm
Forum: Vensim
Topic: Vensim DSS 8 x64 DLL Issues
Replies: 4
Views: 3358

Re: Vensim DSS 8 x64 DLL Issues

Dear Administrator, Anything else we should try and then communicate back to you, so as to resolve when we run the sample Excel97 code, Vensim throws up two errors. The first is a message box with a single ".", followed by a second message box saying "Reinstall Vensim (error 977)"...
by pav80
Wed Oct 30, 2019 1:29 pm
Forum: Vensim
Topic: Vensim DSS 8 x64 DLL Issues
Replies: 4
Views: 3358

Re: Vensim DSS 8 x64 DLL Issues

Thank you Administrator for the prompt reply.

Unfortunately the same error messages we mention in original post still appear after downloading 8.0.6 and installing as Administrator.
by pav80
Wed Oct 30, 2019 12:23 pm
Forum: Vensim
Topic: Vensim DSS 8 x64 DLL Issues
Replies: 4
Views: 3358

Vensim DSS 8 x64 DLL Issues

Hi, We're looking to replace our age-old DDE code in Excel by using the Vensim DLL functionality, and at the same time move to the x64 version of Vensim 8. Right now we are stumbling at the first hurdle. When we run the sample Excel97 code, Vensim throws up two errors. The first is a message box wit...
by pav80
Wed Jan 17, 2018 9:19 am
Forum: Vensim
Topic: TIDY data format & tableau
Replies: 2
Views: 2489

TIDY data format & tableau

Dear Forum Participants,

Wanted to see if anybody has seen a useful tutorial that shows how to use the TIDY data format export from Vensim and then to use the data in a software called Tableau?

Thanks,

Pawel
by pav80
Thu May 11, 2017 8:04 am
Forum: Vensim
Topic: Exporting data without zeros
Replies: 5
Views: 4099

Re: Exporting data without zeros

Thank you again
by pav80
Thu May 11, 2017 7:36 am
Forum: Vensim
Topic: Exporting data without zeros
Replies: 5
Views: 4099

Re: Exporting data without zeros

Thank you for the prompt reply.
Agree that this could be done in Excel with VB for example.
But still could be a useful tool to have in Vensim directly as would make the analysts concentrate more on the output of Vensim rather than manipulating it.

Pawel
by pav80
Thu May 11, 2017 7:15 am
Forum: Vensim
Topic: Exporting data without zeros
Replies: 5
Views: 4099

Exporting data without zeros

Hi, Was wondering whether in Vensim there is an option than when you export a data matrix that it can automatically truncate the data matrix to get rid of zeros? For example if you have a matrix from 1970 to 2050 (you want each year to appear), but on the X axis you might have more than 100 countrie...
by pav80
Mon May 18, 2015 5:05 pm
Forum: Vensim
Topic: Bugs with GET XLS SUBSCRIPT?
Replies: 4
Views: 3709

Re: Bugs with GET XLS SUBSCRIPT?

Yes 'Vensim_PYEAR' points to a range, not a single cell.

Excel procedure uses DDE.

All the best
by pav80
Mon May 18, 2015 3:58 pm
Forum: Vensim
Topic: Bugs with GET XLS SUBSCRIPT?
Replies: 4
Views: 3709

Re: Bugs with GET XLS SUBSCRIPT?

TOMFID thanks for the reply. I had noted that but at the same time on http://www.vensim.com/documentation/index.html?fn_get_xls_subscript.htm it states "You can substitute named Excel ranges for 'firstcell'. In this case 'lastcell' is ignored." Since I am using a named range in Excel for f...