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
Rounding discrepancy in Vensim export?
-
- Junior Member
- Posts: 6
- Joined: Tue Jun 05, 2018 9:32 am
- Vensim version: PLE+
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
Re: Rounding discrepancy in Vensim export?
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).
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Re: Rounding discrepancy in Vensim export?
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.
I think Excel uses Decimals instead of floats, which might create false precision.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/