This was an absolutely perfect video for what I was needing; quick tutorial on Solver in Excel! Thank you so much! I'm actually looking forward to my next assignment.
concise and clear! thank you so much. i learned this skill in less than 15 minutes thanks to you! and my prof was making a huge fuss about me not knowing it too. ha!
Oooh my, thank you very much Lady, was stuck with my assignement and after a long day or reading material on the internet, I somehow landed on this video. Off to sleep now. But thanks a lot)))
Great video! One helpful tip is that you can just copy and paste the sumproduct formulas instead of typing it out each time; which is basically the whole point of using the absolute reference function (Fn+F4) which you DID enter, but didn't take advantage of by copying and pasting the sumproduct formula instead of typing it separately each time.
I love this video and the algorithm that they used to answer the problem but it could be greatest if you could show us how do you took the constraint of the problem. So, thank you very much this lesson will be very useful to acquire a skill.
Hi Afsham. You are pretty capable to deliver your knowledge to your a audiences, the quality a few people possess. With such great ability , I wonder why you dont make more videos?
+emperoy8 Thank you. I am humbled by your kind words and encouragement. But, honestly this was done as a part of an MBA class as an example of conducting tutorials. I am happy to know that it was helpful and people are benefiting from it. I am more caught up on setting up a responsible social business now and hope to bring some positive change. Perhaps in the future I may :).
The video is really simple and yet really helpful. very nice tutorial :D Please do work on transportation and assignment, Game Theory, Goal programming, Markov analysis and other similar Excel based solutions :D
I appreciate the video, but I can't seem to get the same results as you do. I think I put in everything correctly as I've checked it multiple times, but I keep getting values over the max for the first 2 rows of demand constraints and I can't seem to figure out what I did wrong. Hmm...
hmmm..... you might want to re-check to make sure you have put in the constraints parameter correctly like the appropriate greater then, less then signs perhaps
It's the demand, if you place less than or equal to signs, you can produce less that the demand. Placing greater than or equal to signs, you can produce more or equal to the demand. So basically you can sell as much as your customers want, and more. For a different problem, they should put another constraint for the cost of inventory of the excess of units. But that's another story.
+YaBoyBlake h No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "=").
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
Thanks for the helpful tutorial. However, 1. Using the exact same figures, functions, etc.. gives me a different result altogether 2. Why do we have the first 2 demand constraints as ">=" in the constraints section of the solver window (ref: at 9.52)? Shouldn't all the demand constraints be same "
No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "=").
Great appreciate work. first question was very great explanation but i m facing to solve second question. i m not getting the right ans as you are. my answer around 2600. m new follower from INDIA (IIT Rookee)
Dear Afshamkhan, I appreciate the video but whenever I try to do my work.... The results become with negative values!! is there anything wrong or do i need to change something in the options (setting)?
Hi afshamkhan, what are the formula for supply and demand constraints formula, because I cannot get the production units correctly. i tried for 1 hour in different ways. please tell me.
in demand constraints in the second option it is exceeding the maximum limit? solver suggeted 500 usage where max limit is 400?? moreover my answer is coming in decimel u suggested one of the user to change the cell setting.but what setting to change for that we need to ask God i guess... did not help much infact confused a lot..://
My problem looks like this, how can I organize it like this in excel "NEC Computer Company in Japan is preparing two products: tablet and computers. The production process for each product is similar in that both require a certain number of hours of electronic work and a certain number of labor hours in the assembly shop. Each tablet requires 4 hours of electronic work and 3 hours in the assembly department. And each computer takes 2 hours in electronics and 1 hours in assembly. During the manufacturing process, 240 hours of electronic time are available and 102 hours of assembly time are available. The profit for a tablet is USD 70 and USD 50 for a computer. Calculate how many units of each type should be produced for the maximum possible profit. Using graphical solution method, please explain the nature of the problem as clear as possible. Besides that, please compare your graphical calculation with MS-Excel result".
Very nice, thank you... Solver seems to be a very powerful tool, tough it has some pitfalls I can't find how to solve: Let's suppose I have in Sheet 1 of Workbook "A" an objective function that i want to maximize changin' cells in othe Sheet in anothar Workbook. A seemengly easy task couldn't be performed as long as I get am annoying message 'Changing cells must be in the active sheet'. I mean, I can try this using VBA macros and the so, and is OK, but what I wan is to solve this interactively. Anyone has a hint on how to do this? Thanks in advance....
you mean to get the max profit i should not make tables?? are you sure?? if somebody wana make maximum profit by having varieties of products i.e having both tables as well as chairs then your method seems go wrong. so please give the example ...of that one also.
I honestly did not even try to see if I got the same calculations, I just needed some questions answered and you answered them. So thank you.
Best tutorial I have found and I have been watching video after video. THANK YOU SO MUCH!
This was an absolutely perfect video for what I was needing; quick tutorial on Solver in Excel! Thank you so much! I'm actually looking forward to my next assignment.
This homework problem took me hours to figure it out. Using your video cut the time to minutes. Thank you very much
concise and clear! thank you so much. i learned this skill in less than 15 minutes thanks to you! and my prof was making a huge fuss about me not knowing it too. ha!
Oooh my, thank you very much Lady, was stuck with my assignement and after a long day or reading material on the internet, I somehow landed on this video. Off to sleep now. But thanks a lot)))
Many thanks for this. I used it as a template and it gave me the same result as my manual matrix calculations.
You have made this Solver so simple! Thank you- hope to see some more of your videos
Great video! One helpful tip is that you can just copy and paste the sumproduct formulas instead of typing it out each time; which is basically the whole point of using the absolute reference function (Fn+F4) which you DID enter, but didn't take advantage of by copying and pasting the sumproduct formula instead of typing it separately each time.
So nicely explained. The best video on this topic!
Thanks for making this video.. You have the most updated Excel I've found, really helpful and you explained everything well.
Thank you I am glad you found it helpful. It was done as part of a class project :).
I finally figured out after watching your video
Thanks
Thank you for your help, this is exactly the issue I was facing. Thanks a lot again.
Thank you for updating this video, it was really helpfull and easy to understand.
Thank you very much! I think I can finish my assignment today!
I love this video and the algorithm that they used to answer the problem but it could be greatest if you could show us how do you took the constraint of the problem. So, thank you very much this lesson will be very useful to acquire a skill.
So simple and straight forward
Very Helpful Video .Thank you
very clear and helpful, thank you so much for your effort!
Crystal clear! Thanks a lot!
Hi Afsham. You are pretty capable to deliver your knowledge to your a audiences, the quality a few people possess. With such great ability , I wonder why you dont make more videos?
+emperoy8 Thank you. I am humbled by your kind words and encouragement. But, honestly this was done as a part of an MBA class as an example of conducting tutorials. I am happy to know that it was helpful and people are benefiting from it. I am more caught up on setting up a responsible social business now and hope to bring some positive change. Perhaps in the future I may :).
Thank you so much for this! It was very helpful.
Thank you very much. I have learned something new.
Great job!
Very helpful, thanks!
Thank you, This really helped me alot
iram naeem awesome! I am happy it was helpful.
This helped me so much, thank you!!!!!!!!!!!
Thank you so so much, it really helped!
The video is really simple and yet really helpful. very nice tutorial :D Please do work on transportation and assignment, Game Theory, Goal programming, Markov analysis and other similar Excel based solutions :D
It was so helpful thank you.
Thank you so much!! Very useful!!
Fantastic
Good tutorial, thank you.
I appreciate the video, but I can't seem to get the same results as you do. I think I put in everything correctly as I've checked it multiple times, but I keep getting values over the max for the first 2 rows of demand constraints and I can't seem to figure out what I did wrong. Hmm...
hmmm..... you might want to re-check to make sure you have put in the constraints parameter correctly like the appropriate greater then, less then signs perhaps
great job thank you
the best
Thank you!
Thank you so much!!!!!!!!
Why are your greater than less signs different for some constraints in solver? Shouldn't they all be less than or = to the amount available?
It's the demand, if you place less than or equal to signs, you can produce less that the demand. Placing greater than or equal to signs, you can produce more or equal to the demand. So basically you can sell as much as your customers want, and more.
For a different problem, they should put another constraint for the cost of inventory of the excess of units. But that's another story.
+YaBoyBlake h No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "=").
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
Thanks for the helpful tutorial. However,
1. Using the exact same figures, functions, etc.. gives me a different result altogether
2. Why do we have the first 2 demand constraints as ">=" in the constraints section of the solver window (ref: at 9.52)? Shouldn't all the demand constraints be same "
No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "=").
Thank u for the vid!
Great appreciate work. first question was very great explanation but i m facing to solve second question. i m not getting the right ans as you are. my answer around 2600. m new follower from INDIA (IIT Rookee)
I'm trying to follow along, but I'm stuck.
What are the formulas for column G, demand constraints?
Thank you.
Thanks!
Dear Afshamkhan, I appreciate the video but whenever I try to do my work.... The results become with negative values!! is there anything wrong or do i need to change something in the options (setting)?
solver is giving solution but in decimals. Is there any option in solver to get whole number units?
+ankushzap right click on that cell, go to "format cell" and change the setting there.
+afshamkhan what setting to change?
Hi afshamkhan, what are the formula for supply and demand constraints formula, because I cannot get the production units correctly. i tried for 1 hour in different ways. please tell me.
Thank you!!
Thanks.
in demand constraints in the second option it is exceeding the maximum limit? solver suggeted 500 usage where max limit is 400?? moreover my answer is coming in decimel u suggested one of the user to change the cell setting.but what setting to change for that we need to ask God i guess... did not help much infact confused a lot..://
My problem looks like this, how can I organize it like this in excel "NEC Computer Company in Japan is preparing two products: tablet and computers. The production process for each product is similar in that both require a certain number of hours of electronic work and a certain number of labor hours in the assembly shop. Each tablet requires 4 hours of electronic work and 3 hours in the assembly department. And each computer takes 2 hours in electronics and 1 hours in assembly. During the manufacturing process, 240 hours of electronic time are available and 102 hours of assembly time are available. The profit for a tablet is USD 70 and USD 50 for a computer. Calculate how many units of each type should be produced for the maximum possible profit.
Using graphical solution method, please explain the nature of the problem as clear as possible. Besides that, please compare your graphical calculation with MS-Excel result".
thanks :)
Thanks
"solver could not find a feasible solution" What to do?
sir, please provide the same complete excel sheet to us.
I need help with my homework can you help?
Very nice, thank you... Solver seems to be a very powerful tool, tough it has some pitfalls I can't find how to solve: Let's suppose I have in Sheet 1 of Workbook "A" an objective function that i want to maximize changin' cells in othe Sheet in anothar Workbook. A seemengly easy task couldn't be performed as long as I get am annoying message 'Changing cells must be in the active sheet'. I mean, I can try this using VBA macros and the so, and is OK, but what I wan is to solve this interactively. Anyone has a hint on how to do this? Thanks in advance....
Thank you sooo much
What is the meaning of LP?
Linear Programming :)
you mean to get the max profit i should not make tables?? are you sure?? if somebody wana make maximum profit by having varieties of products i.e having both tables as well as chairs then your method seems go wrong. so please give the example ...of that one also.
How does a company maximize their profit by producing deez nuts?
AAAAAAAAH
Nice tutorial, horrible data...
Thank you!