Rounding discrepancy in Vensim export?

Use this forum to post Vensim related questions.
Post Reply
Robyn Letts
Junior Member
Posts: 6
Joined: Tue Jun 05, 2018 9:32 am
Vensim version: PLE+

Rounding discrepancy in Vensim export?

Post by Robyn Letts »

Hi

Using Vensim DSS 7.2 (Double precision) x32, I have been successfully exporting datasets as Excel files and CSV files but have just noticed a discrepancy in the number of decimal places recorded for the variables - Excel files have 15 while CSV only has 6. Is there a reason for this or am I missing something?

Thanks
Robyn
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Rounding discrepancy in Vensim export?

Post by Administrator »

The values in Vensim datasets are stored in single floating point format, so exporting also gives the reduced accuracy.

This is something we are fixing for the 64 bit version of Vensim (it's just taking a little longer than we expected).
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: 3806
Joined: Wed May 24, 2006 4:54 am

Re: Rounding discrepancy in Vensim export?

Post by tomfid »

Of course, this is only relevant if you're simulating in double precision.

I think Excel uses Decimals instead of floats, which might create false precision.
Post Reply