Dear all,
I have been scanning this forum and other websites, without success, for how to set up a custom table that displays all currently loaded runs. I figured how to generate the custom table, and how to change fonts etc, but what remains a mystery is how to set the table up in the way that it displays the scenarios that are currently loaded.
Purpose of the custom table is to use it for exporting data into Excel and to conduction manual calculations there for advanced analysis purposes, and exporting a single table for multiple scenarios again and again is driving me nuts
Hoping you can help me out here.
Best,
Georg
Custom table for multiple scenarios
Re: Custom table for multiple scenarios
In the table definition, there's a "Dataset" field where you specify the run name to show. You can use *1, *2, etc. to show the first, second... loaded dataset. It's a bit cumbersome if you have a lot of datasets, but it does permit you to add multiples.
/*
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: Custom table for multiple scenarios
Thank you for the swift reply! Assuming I name my datasets differently, then the asterix should bypass putting the whole name for the dataset, correct?
Further would it work to indicate " *1, *2, ..., *10 " even if only 2 runs are loaded, or would I get 8 empty rows then?
Thanks again for your help, this will save me a lot of time in terms of number crunching
Further would it work to indicate " *1, *2, ..., *10 " even if only 2 runs are loaded, or would I get 8 empty rows then?
Thanks again for your help, this will save me a lot of time in terms of number crunching
Re: Custom table for multiple scenarios
Correct, the * is a wildcard, followed by a number. I don't think it will put empty rows, but I haven't tried it.
/*
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: Custom table for multiple scenarios
Correct, the * is a wildcard, followed by a number. I don't think it will put empty rows, but I haven't tried it.
/*
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
*/