I need help finding a manual solution! Thank you! Here is my Excel sheet before any manual solutions.

Finding a Manual Solution

Now that you have completed the worksheet, attempt to find a manual solution that meets all the requirements listed in the Constants and Requirements sections. For example, entering $20,000 in each of the changing cells yields a good 5-year weighted expected annual return, but it violates the maximum amount of 25 percent that can be invested in sector funds. Try to adjust the amounts in the funds while maintaining the total investment at $200,000. Do not spend an excessive amount of time trying to optimize your portfolio manually; just find a solution that meets the requirements. In the next section, Solver will be able to optimize the portfolio after you set up the Solver parameters.

=