microsoft-excel solver coding using Smath

microsoft-excel solver coding using Smath - Messaggi

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

mm5087

0 apprezzamenti in 2 post.

Gruppo: 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) scaricato 1225 volta(e).
#2 Pubblicato: 27/12/2018 21:30:40
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: 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) scaricato 1202 volta(e).
#3 Pubblicato: 27/12/2018 21:45:36
mm5087

mm5087

0 apprezzamenti in 2 post.

Gruppo: 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
  • Nuovi post
  • Nessun nuovo post