SMath Studio Forum
»
SMath Studio
»
Questions
»
microsoft-excel solver coding using Smath
 Rank: Newbie
Groups: Registered
Joined: 06/12/2018(UTC) Posts: 2  Location: Kuala Lumpur
|
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 (19kb) downloaded 22 time(s).
|
|
|
|
|
|
 Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866  Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: mm5087  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 (29kb) downloaded 7 time(s).
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 06/12/2018(UTC) Posts: 2 Location: Kuala Lumpur
|
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.  Edited by user 28 December 2018 04:10:52(UTC)
| Reason: Not specified
|
|
|
|
|
|
SMath Studio Forum
»
SMath Studio
»
Questions
»
microsoft-excel solver coding using Smath
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
