microsoft-excel solver coding using Smath

microsoft-excel solver coding using Smath - Messages

#1 Posted: 12/26/2018 11:04:46 PM
mm5087

mm5087

0 likes in 2 posts.

Group: 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 KiB) downloaded 61 time(s).
#2 Posted: 12/27/2018 9:30:40 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: 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 KiB) downloaded 45 time(s).
#3 Posted: 12/27/2018 9:45:36 PM
mm5087

mm5087

0 likes in 2 posts.

Group: 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
  • New Posts New Posts
  • No New Posts No New Posts