Distributed processing and spreadsheet elements

Comments

4 comments

  • Avatar
    Jason

    Tim,

    Thank you for posting a question in our Forum! This is a good question. Is there a chance you can use Time History Result to export results to Excel? If so, you can set it up to not export automatically and then click the "Export Now" button after the DP simulation is complete (see screen capture below). 

    Please keep in mind that you need 1 of your processors for the "master" so if you have 4 available cores on your machine, please note that you should only use 3 slaves. 

    I hope this is helpful,

    Jason

    0
    Comment actions Permalink
  • Avatar
    Tim Wallis

    Thanks Jason.

    Unfortunately we have too many data points to use time histories efficiently. We're running a 360 hr simulation on an hourly time step with 5776 realisations. We have a total of 110 results exported via a spreadsheet element.  While we can do multiple runs concurrently to reduce the total time, DP might potentially give us an opportunity to reduce the overall run time for each individual run. This is most beneficial when we need a quicker turnaround during testing and setup. Being able to use DP would be nice to have but not having it isn't a show stopper!

    Cheers,

    Tim

    0
    Comment actions Permalink
  • Avatar
    Jason

    Tim,

    If you need to export a lot of final value results, then another option is the Multi-variate chart, which has a shortcut key option within the table view that generates a tab-delimited file of all the tabular results from a DP run. You can read more about this option here. Will this work for you?

    Jason

    0
    Comment actions Permalink
  • Avatar
    David Esh

    Tim - I try to avoid the use of spreadsheets for the reason you indicate regarding DP and sometimes it can impact execution time significantly.

    I do a combination of what Jason suggested.  You can add as many time series to a chart as you want (I think, Jason is there a limit?).  Then when your simulation is done just click on the chart, choose table view, and copy and paste your data over to Excel.  I combine that with what Jason suggested for non-time series outputs.  Create a multivariate output with all the inputs and outputs you want, and do the same procedure of grabbing all the data at the end of your calculation and copy and paste to Excel.  If your model takes awhile to run you may want to get a DP license and move beyond the DP lite.  That is what I do and 40 processes makes a big difference over 4 :)

    The other option would be to create a custom DLL to write all of the outputs you want at the end of the simulation to a *.txt, *.csv, etc.

    Regards,

    Dave

    0
    Comment actions Permalink

Please sign in to leave a comment.