Problem exporting data with VENSIM_GET_VAL

Use this forum to post Vensim related questions.
Post Reply
Omarin
Newbie
Posts: 1
Joined: Tue May 19, 2015 2:31 am
Vensim version: DSS

Problem exporting data with VENSIM_GET_VAL

Post by Omarin »

Hi,

I am trying to export data from vensim using VENSIM_GET_VAL in a macro during a game. However the data exported to excel miss some zeros when it is the last number of the value, also I miss all dots in excel.
I switched , to . in excel options as decimal separator but nothing changed.
However, when I copy manually the table from vensim and paste it into excel there is not any missing zero (0) or dot(.)

Many thanks for your help with this

Omar
Administrator
Super Administrator
Posts: 4611
Joined: Wed Mar 05, 2003 3:10 am

Re: Problem exporting data with VENSIM_GET_VAL

Post by Administrator »

Can you upload something to demonstrate the problem?
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
tomfid
Administrator
Posts: 3816
Joined: Wed May 24, 2006 4:54 am

Re: Problem exporting data with VENSIM_GET_VAL

Post by tomfid »

This sounds like a problem in the macro code rather than vensim_get_val - the function returns floating point numbers, so it's not clear what it would even mean to be missing dots.
Post Reply