Hello Sir, I did not understand the constraint part. How did you choose th sum of $G$9:$G$13 to be equal to 1 instead of 5. Any one can do only one of marketing, hr, finance, operations , so the total of G9:G13 needs to be 5, Infact the solver does the same. Similarly, the constraint sum of B14:F14 how the value is equal to 1 rather than 5. Please explain
They have to make the assignments such that one student does one assignment only and one assignment is done by one student only. So, for example, if cell B14 is allowed to equal 5, it means that Akira can do all 4 assignments and the dummy - and this is not allowed. So, we force B14 to be 1, and that way Akira can do only one assignment. The same logic can be applied to other rows and columns. Hope this helps.
I think you're looking for 4:00 when he first opens the Solver and chooses the target cell. Notice how there are radio buttons labeled "Max", "Min", and "Value" with a textbox input. You would select "Min". In Libre Office which is what I use, it's labelled a little differently like "Least" or something similar but hopefully you get the idea.
Thank you for this. Very straightforward and well explained.
Thank you Piyush. Your explanation is very simple. It helped me to solve my assignment question.
Thank you so much. This really helped
Thank you sir 🙏🙏🙏🙏
Hi Sir! Thank you for your videos. How to model if it would require the sequence of the assignment in order to attain minimum total?
Thanks!! This helped me out a lot.
4th video is missing from the playlist
sir.. should we select LP simplex or GRG Non linear?
Either would work. In this case, since we have a linear relationship, the simplex LP should give you faster results.
@@piyushashah1 ok sir.. thanks for the prompt response.
Nice explanation. Thank you.
Thank you....really enjoyed your tutorial.
Thank you so much. By the way even m from durgadevi saraf institute of mgmt studie s :-)
Thanks Rohit. Best wishes.
Thank you so much! really helpful
is this a zero one programming model
Thank you so much! Really easy to understand :-)
Hello Sir, I did not understand the constraint part. How did you choose th sum of $G$9:$G$13 to be equal to 1 instead of 5. Any one can do only one of marketing, hr, finance, operations , so the total of G9:G13 needs to be 5, Infact the solver does the same. Similarly, the constraint sum of B14:F14 how the value is equal to 1 rather than 5. Please explain
They have to make the assignments such that one student does one assignment only and one assignment is done by one student only. So, for example, if cell B14 is allowed to equal 5, it means that Akira can do all 4 assignments and the dummy - and this is not allowed. So, we force B14 to be 1, and that way Akira can do only one assignment. The same logic can be applied to other rows and columns. Hope this helps.
@@piyushashah1 thanks Sir, also really appreciate the fast response.
While I was trying it says "too many variable cells"
Thanks this helps alot!
is it minimization problem
helps alot
how do I use this to minimize the sum of the array
SkillaRaw, sorry did not understand your question. Can you please explain in detail?
I think you're looking for 4:00 when he first opens the Solver and chooses the target cell. Notice how there are radio buttons labeled "Max", "Min", and "Value" with a textbox input. You would select "Min".
In Libre Office which is what I use, it's labelled a little differently like "Least" or something similar but hopefully you get the idea.
is it min question?>
No, this is a maximization problem. At around 1:18 I mention that the total scores have to be maximized.
Can you help me ?
Post your question here, will try to help
@@piyushashah1 it is about transportation and assignment method also but with different problems. Can I have your email so i can send you the problem?
@@Itz_Princess27 Have a look at this and let me know if it works for you. ruclips.net/video/qjM_5RP-eJw/видео.html