Batch Runs and Spread Sheets

scottneh · March 6, 2011, 13:47

Hello,

I have been using STAR-CCM+ for about a year now and have been running multiple data sets and populating a spread sheet manually. I'm curious if anyone knows if there is a way I can create a batch file of sorts or a macro and use that to run my simulations. I'd like to be able to set the parameters from cells in the spread sheet and populate the spread sheet with data automatically. Or at least program the simulation parameters into the batch (macro) file and have it run and populate the spread sheet. The parameters that would change are, initial flow velocity, Mach number, and reference pressure.

Any help would be appreciated

Thanks
Scott

rwryne · March 7, 2011, 13:08

You can set up a macro to export plots to CSV with ease. Just record yourself doing it in STAR-CCM+ and work it into a macro.

scottneh · March 7, 2011, 13:23

Thanks for replying. I'm have not created any macros yet in Star CCM+, I have only been running simulations manually so I don;t know how to build the macros yet. What I would like to do is take to data points from the last iteration and do that for each steady state run after it converges. I don't really need the plots that are generated during convergence.

Paulh · March 8, 2011, 15:57

JAVA has the ability to interface with MicroSoft files through http://poi.apache.org/.

March 6, 2011, 13:47	Batch Runs and Spread Sheets	#1
scottneh Member Scott Join Date: Sep 2009 Posts: 30 Rep Power: 16	Hello, I have been using STAR-CCM+ for about a year now and have been running multiple data sets and populating a spread sheet manually. I'm curious if anyone knows if there is a way I can create a batch file of sorts or a macro and use that to run my simulations. I'd like to be able to set the parameters from cells in the spread sheet and populate the spread sheet with data automatically. Or at least program the simulation parameters into the batch (macro) file and have it run and populate the spread sheet. The parameters that would change are, initial flow velocity, Mach number, and reference pressure. Any help would be appreciated Thanks Scott

March 7, 2011, 13:08		#2
rwryne Senior Member Ryne Whitehill Join Date: Aug 2009 Posts: 312 Rep Power: 18	You can set up a macro to export plots to CSV with ease. Just record yourself doing it in STAR-CCM+ and work it into a macro.

March 7, 2011, 13:23		#3
scottneh Member Scott Join Date: Sep 2009 Posts: 30 Rep Power: 16	Thanks for replying. I'm have not created any macros yet in Star CCM+, I have only been running simulations manually so I don;t know how to build the macros yet. What I would like to do is take to data points from the last iteration and do that for each steady state run after it converges. I don't really need the plots that are generated during convergence.

March 8, 2011, 15:57		#4
Paulh Member Paul Hancock Join Date: Mar 2009 Location: Bellingham, WA Posts: 31 Rep Power: 17	JAVA has the ability to interface with MicroSoft files through http://poi.apache.org/.