microsoft-excel solver coding using Smath

microsoft-excel solver coding using Smath - Mensajes

#1 Publicado: 26/12/2018 23:04:46
mm5087

mm5087

0 me gusta en 2 mensajes.

Grupo: User

dear team,
actually i'm noob in math modelling.
just need help, how can i code inside SMath similar to solver function inside Microsoft Excel.

change the "yellow" items to fulfill the constraint values "purple".

help appreciated.
RMix-Test.sm (18,21 KiB) descargado 1221 vez(es).
#2 Publicado: 27/12/2018 21:30:40
Jean Giraud

Jean Giraud

983 me gusta en 6.866 mensajes.

Grupo: User

Wrote

change the "yellow" items to fulfill the constraint values "purple".



Sorry my friend not clear. If any of the purple change,
you will have to reconsider all the other ones.
No problem but for each and any possible combination
that corresponds to a specific recipe, that you may not
have authority to play with unless you are the Lab_Man.
Suggested simplifications attached.

Jean

RMix-Test.sm (28,38 KiB) descargado 1196 vez(es).
#3 Publicado: 27/12/2018 21:45:36
mm5087

mm5087

0 me gusta en 2 mensajes.

Grupo: User

thank J.Giraud for quick reply,

sorry for my unclear statements.
actually I try to get the "LSF" as near to 100 (my target)
by adjusting the "yellow" items and the "SM" "IM" to be within the constraint range.

rgds

edit:
done it by the try and error, but I prefer to do it in mathematical way.
rmix.capture.PNG
  • Nuevos mensajes
  • Sin mensajes nuevos