[cfdblender]

I need to do a parametric study in STAR CCM+. The study will have anything between 50 and 150 runs. In each run, several parameters of the CAD model geometry will change, then the new model is remeshed, simulation run.

Obviously, doing this by hand would be very inefficient.

I'd like to use a macro that will read the parameters for each run from an Excel (or .csv) file, then remesh, run simulation and perhaps even save some key numerical results to another spreadsheet.

Does anyone have macro that does something similar to this?

Thanks in advance!

[marmot]

People make a living off of that, but really just record yourself changing the design parameters, once that is changed its just one command to mesh and one command to run, writing out results, below are some basic java commands that are helpful for writing out data from a simulation,

Simulation sim = getActiveSimulation();
String filePath = sim.getSessionDir().toString();
String simName = sim.getPresentationName();

ArrayList<Double> someValue = new ArrayList<Double>();
ArrayList caseNameList = new ArrayList(); (define a list of case names probably related to your design changes or read from csv file)

For loop
//Changing design parameters,
mesh
run
get a value
aValue = avgReport.getValue(); (assuming you created an AvgReport variable)

someValue.add(aValue);
end the loop

FileWriter fstream;
BufferedWriter reportfile = null;

try{
fstream = new FileWriter(filePath + File.separator+simName+caseName+"SomeValue"+".csv" );
reportfile = new BufferedWriter(fstream);
reportfile.write(caseName+","+"ValueType");
reportfile.write("\r\n");
for loop
reportfile.write(caseNameList.get(i).toString() + "," + someValue.get(i).toString());
reportfile.write("\r\n");
end loop

reportfile.close();
}catch {something here}

[cfdblender]

Thank you, marmot! That is brilliant!