topic Re: How to get the different recipes output from mixer. in FlexSim Forum

How to get the different recipes output from mixer.

Rambabu — Fri, 06 Oct 2023 09:22:43 GMT

[ FlexSim 23.1.3 ]

Hi flexsimers,

I have a query on mixing the ingredient in different proportions to make different recipes using mixer. In my model I am using mixer to mix four ingredients and make four different recipes. The ratio of ingredients to be mixed are taken in the global table. Is there any solution?

I am attaching the model here: mixing ingredients.fsm

Thankyou.

Re: How to get the different recipes output from mixer.

jason_lightfoot_adsk — Fri, 06 Oct 2023 11:33:24 GMT

Just write to the table which is found at:

Table recipetable = getvarnode(current,"recipetable");

Then read the values from the global table with your format you'll need something like:

Table recipeTable=getvarnode(Model.find("FluidMixer1"),"recipetable");
Table globRecipes=Table("RecipesTable");
string newRecipe="Recipe2";
for (int n=globRecipes.numCols;n>0;n--){
    string ingredient=globRecipes.getColHeader(n);
    int row=recipeTable.getRowByKey(ingredient,1);
    recipeTable[row]["Amount"]=globRecipes[newRecipe];
}

But you need to change the ingredient names to match those of the mixer. Example attached.

Note you can also choose the option to update from a global table on the triggers, but that relies on your table format matching what the trigger expects.

mixing-ingredients_jl.fsm

Re: How to get the different recipes output from mixer.

Rambabu — Sat, 07 Oct 2023 08:27:32 GMT

@Jason Lightfoot The above code indicates only for recipe2. Can you Explain that How to do for remaining recipes by order. I am using global table data only.

Thankyou

Re: How to get the different recipes output from mixer.

jason_lightfoot_adsk — Sat, 07 Oct 2023 12:12:20 GMT

Create a user command that accepts two parameters: the mixer and the recipe name.

In the code place this version of the above script:

Object mixer=param(1);
string newRecipe=param(2);

Table recipeTable=getvarnode(mixer,"recipetable");
Table globRecipes=Table("RecipesTable");
for (int n=globRecipes.numCols;n>0;n--){
    string ingredient=globRecipes.getColHeader(n);
    int row=recipeTable.getRowByKey(ingredient,1);
    recipeTable[row]["Amount"]=globRecipes[newRecipe];
}

then call the command using

changeMixerRecipe(<mixerObject>,<recipename>)

where you replace the chevron parameters with a mixer object and a string name of a recipe. eg:

Object mymixer=Model.find("FluidMixer1");
string recipe=getRecipeForOrder(orderNum);   // another user command
changeMixerRecipe(mymixer,recipe);

I can't tell you how you map the order to the recipe - that will be based on the data you know and have.

Re: How to get the different recipes output from mixer.

Rambabu — Mon, 09 Oct 2023 08:38:07 GMT

@Jason Lightfoot Thankyou for your answer, But I applied that code to my model that shows error. When I debugging the code. It is showing the error in the last line. Could You tell me why it was going wrong.

Table recipeTable=getvarnode(Model.find("FluidMixer1"),"recipetable");
Table globRecipes=Table("RecipesTable");
string newRecipe="Recipe2";
for (int n=globRecipes.numCols;n>0;n--){
string ingredient=globRecipes.getColHeader(n);
int row=recipeTable.getRowByKey(ingredient,1);
recipeTable[row]["Amount"]=globRecipes[newRecipe][n];
}

Thankyou

Re: How to get the different recipes output from mixer.

jason_lightfoot_adsk — Mon, 09 Oct 2023 14:21:53 GMT

I don't think the error screen matches the code - nowhere do you mention Recipe3 - we'd need to see the model to determine what is wrong. Your row headers should look something like this: