This is the same question as: http://www.excelforum.com/excel-gene...el-solver.html
My issue is, what cells do I include as "by changing" for the excel solver. I know what to maximize and the constraints. I've attached the workbook to the problem.
This is the same question as: http://www.excelforum.com/excel-gene...el-solver.html
My issue is, what cells do I include as "by changing" for the excel solver. I know what to maximize and the constraints. I've attached the workbook to the problem.
Interesting as I did not understand this problem 5 years ago and looking at it now it's still a mystery to me. When you get a solution could you please post it?
Alf
I, too, do not really understand the problem.
Is Solver necessary? What I see is a system of four (linear) equations with four unkowns. While Solver can be used to solve such problems, I often find that using matrix algebra is an easier way to solve systems of linear equations.
Follow this tutorial through to understand how Gaussian elimination works: http://www.purplemath.com/modules/systlin7.htm
then look at this one to understand how to put Gaussian elimination into matrix form: http://www.mathsisfun.com/algebra/sy...-matrices.html
At that point, all you may need is to understand how the MINVERSE() and MMULT() functions work in Excel: https://support.office.com/en-us/art...__toc309306715
If nothing else, perhaps those resources will put the problem in a context that will help you explain the problem better.
Originally Posted by shg
Well, I found the solution that explains the problem a tad bit better. Posting to see if this resonates with anyone better than myself as to what to use as the constraints.
Thanks for posting this file. The concept of "Mixed Strategies" is quite new for me so I'll have to spend some time trying to figure it out + I'll have to read up on "Pure" and "Mixed Strategies". Nice to be able to spend time on things like this when it's not one's job or with an exam waiting just around the corner.
Alf
I found the narrative interesting, particularly the probabilistic aspect -- not making a deterministic choice that enables your opponent to make a deterministic counter.
Entia non sunt multiplicanda sine necessitate
Hello,
Brain challenging question!!
What we have here is an excel sheet with 1000 rows for my clients generated by system for my client's products with me,
1-Some of my clients are having more than one product not in the same row, which means sometimes one client has 10 products and the other has 4 etc.
2-System provides a total value$ of the products for each client below all of their products (clients are having a unique numbers and its arranged)
3-The problem is the total is not sum of each client's products since sometimes 2,3,4,,, products are sharing one value & system repeats the product value$
what we want is to highlight the values which related to the given total under each client product's value. by using solver in macro as below:
Client No Product name Product Value
1 A 100
1 B 75
1 C 50
1 D 200
Total 250 (Need to highlight C&D)
2 A 500
Total 500 (Need to highlight A only)
3 A 100
3 B 175
3 C 35
Total 175 (Need to highlight B)
Welcome to the forum.
What we have here is someone that needs to start their own thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks