Hi Ventity Team (Tom),
I am running some simulations and my results are in millions (M) and billions (B). I would like the exact numbers instead of these and I cannot find the fix in the unit settings.
Appreciate your help.
Regards,
Athar
Units (Millions and Billions)
Re: Units (Millions and Billions)
Where do you need these numbers? (Charts, tables, data grid?)
If you copy-paste or export the values to Excel or csv, you'll get the raw numbers.
If you copy-paste or export the values to Excel or csv, you'll get the raw numbers.
/*
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
*/
Re: Units (Millions and Billions)
Hi Tom,
I want to copy the results of aggregate of vehicle stocks. While the ventity plotter shows the number, when i try to copy these numbers. Instead of the whole number, the M and B show up in excel. Moreover, i am not able to export the results to excel file (maybe i am doing the exporting wrong).
I want to copy the results of aggregate of vehicle stocks. While the ventity plotter shows the number, when i try to copy these numbers. Instead of the whole number, the M and B show up in excel. Moreover, i am not able to export the results to excel file (maybe i am doing the exporting wrong).
Re: Units (Millions and Billions)
The M is definitely a bug - I've put in a ticket for it.
How did you generate the "path not of legal form" error? The export command is working for me.
How did you generate the "path not of legal form" error? The export command is working for me.
/*
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
*/
Re: Units (Millions and Billions)
Speculation: the path error has something to do with the location where you're saving the file.
/*
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
*/
Re: Units (Millions and Billions)
HI Tom,
I can save the complete results (for the whole run) from the Results tab in the entity picker into excel files.
However, if i go to data of an individual stock/variable/aggregate (like the table image above) and right click and do export to excel, it gives the error (in the second screenshot).
I can save the complete results (for the whole run) from the Results tab in the entity picker into excel files.
However, if i go to data of an individual stock/variable/aggregate (like the table image above) and right click and do export to excel, it gives the error (in the second screenshot).
Re: Units (Millions and Billions)
Thanks. Two requests:
- can you post a screenshot of the save dialog, showing the Excel filename to be used? (Email to us at info at ventity.biz if easier.)
- the text of the extended error message - this will be on the clipboard after you click OK on the "path is not of legal form" dialog.
- can you post a screenshot of the save dialog, showing the Excel filename to be used? (Email to us at info at ventity.biz if easier.)
- the text of the extended error message - this will be on the clipboard after you click OK on the "path is not of legal form" dialog.
/*
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
*/
Re: Units (Millions and Billions)
Hi Tom,
I have sent the screenshots and error clipboard text file on the info@ventity email.
Please let me know if you (or the team) haven't received it.
I have sent the screenshots and error clipboard text file on the info@ventity email.
Please let me know if you (or the team) haven't received it.
Re: Units (Millions and Billions)
Got it - thanks! I'll put in a ticket and we'll investigate.
/*
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
*/
Re: Units (Millions and Billions)
Before we fix the bug, let's make sure it isn't a feature! There are a number of ways Excel can display numbers with a suffix, without changing the underlying number. It would be great if Ventity supported one or more of these when copy-and-pasting, or saving-as.
(1) Excel can display numbers with a suffix, e.g. "M" when the number is greater than 1000000. Excel custom number format for up to two break points that gives this is
[>=1000000]0,,"M";[>=1000]0,"K";0
(2) With conditional formatting, the custom formatting can be extended to more than two break points. (The conditional formatting can be copied and pasted amongst cells.) A nice explanation how to do it is https://www.excelforum.com/excel-genera ... t-etc.html. This works only for cells greater than 1, so is of limited value IMHO.
(3) With a helper-cel, numbers smaller and larger than one can be formatted with SI prefixes. A good article is https://answers.microsoft.com/en-us/mso ... e4e31237e0
I've attached an Excel spreadsheet that does all this.
(1) Excel can display numbers with a suffix, e.g. "M" when the number is greater than 1000000. Excel custom number format for up to two break points that gives this is
[>=1000000]0,,"M";[>=1000]0,"K";0
(2) With conditional formatting, the custom formatting can be extended to more than two break points. (The conditional formatting can be copied and pasted amongst cells.) A nice explanation how to do it is https://www.excelforum.com/excel-genera ... t-etc.html. This works only for cells greater than 1, so is of limited value IMHO.
(3) With a helper-cel, numbers smaller and larger than one can be formatted with SI prefixes. A good article is https://answers.microsoft.com/en-us/mso ... e4e31237e0
I've attached an Excel spreadsheet that does all this.