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.

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!

Best tutorial I have found and I have been watching video after video. THANK YOU SO MUCH!

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.

This homework problem took me hours to figure it out. Using your video cut the time to minutes. Thank you very much

You have made this Solver so simple! Thank you- hope to see some more of your videos

Many thanks for this. I used it as a template and it gave me the same result as my manual matrix calculations.

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)))

So nicely explained. The best video on this topic!

So simple and straight forward

Thank you for updating this video, it was really helpfull and easy to understand.

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?

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.

Thanks for making this video.. You have the most updated Excel I've found, really helpful and you explained everything well.

Thank you for your help, this is exactly the issue I was facing. Thanks a lot again.

I finally figured out after watching your video Thanks

very clear and helpful, thank you so much for your effort!

Thank you very much! I think I can finish my assignment today!

Thank you so much for this! It was very helpful.

Thank you very much. I have learned something new.

Very Helpful Video .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...

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

Great job!

Very helpful, thanks!

Good tutorial, thank you.

Thank you, This really helped me alot

Crystal clear! Thanks a lot!

It was so helpful thank you.

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?

I'm trying to follow along, but I'm stuck. What are the formulas for column G, demand constraints? Thank you.

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".

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)

Thank you so much!! Very useful!!

Thank you so so much, it really helped!

This helped me so much, thank you!!!!!!!!!!!

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 "

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..://

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.

the best

Fantastic

Thank you!

great job thank you

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)?

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?

Thank you so much!!!!!!!!

Thanks.

Thank u for the vid!

Thanks!

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....

solver is giving solution but in decimals. Is there any option in solver to get whole number units?

Thank you!!

Thanks

"solver could not find a feasible solution" What to do?

thanks :)

sir, please provide the same complete excel sheet to us.

I need help with my homework can you help?

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.

Thank you sooo much

What is the meaning of LP?

How does a company maximize their profit by producing deez nuts?

AAAAAAAAH

Nice tutorial, horrible data...

Thank you!