microsoft-excel solver coding using Smath

microsoft-excel solver coding using Smath - Сообщения

#1 Опубликовано: 26.12.2018 23:04:46
mm5087

mm5087

0 сообщений из 2 понравились пользователям.

Группа: 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 КиБ) скачан 61 раз(а).
#2 Опубликовано: 27.12.2018 21:30:40
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: 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 КиБ) скачан 45 раз(а).
#3 Опубликовано: 27.12.2018 21:45:36
mm5087

mm5087

0 сообщений из 2 понравились пользователям.

Группа: 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
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений